Scribd
Upload
18 views1 page

Oracle Payroll Element Entry Creation

The document contains a PL/SQL block that declares several variables and calls the 'create_element_entry' procedure from the 'pay_element_entry_api'. It sets parameters such as effective date, business group ID, assignment ID, and various input values. The purpose of the block is to create a new element entry in the payroll system.

Uploaded by

Raghava Reddy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
18 views1 page

Oracle Payroll Element Entry Creation

The document contains a PL/SQL block that declares several variables and calls the 'create_element_entry' procedure from the 'pay_element_entry_api'. It sets parameters such as effective date, business group ID, assignment ID, and various input values. The purpose of the block is to create a new element entry in the payroll system.

Uploaded by

Raghava Reddy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

declare

v_effective_start_date DATE;
v_effective_end_date DATE;
v_element_entry_id NUMBER;
v_object_version_number NUMBER;
v_create_warning BOOLEAN;
v_element_type_id NUMBER;
begin
pay_element_entry_api.create_element_entry(p_validate => false,
p_effective_date => sysdate,
p_business_group_id => 101,
p_assignment_id => 102,
p_element_link_id => 645,
p_entry_type => 'E',
p_input_value_id2 => 744,
p_input_value_id3 => 745,
p_input_value_id4 =>746,
p_input_value_id5 => 747,
p_entry_value2 => '09-2023',
p_entry_value3 => 4,
p_entry_value4 => 5,
p_entry_value5 => 6,
p_effective_start_date =>
v_effective_start_date,
p_effective_end_date =>
v_effective_end_date,
p_element_entry_id => v_element_entry_id,
p_object_version_number =>
v_object_version_number,
p_create_warning => v_create_warning);
end;

You might also like