DECLARE
p_employee_number VARCHAR2 (200);
p_new_gosi NUMBER;
p_validate BOOLEAN;
p_effective_date DATE;
p_business_group_id NUMBER;
p_original_entry_id NUMBER;
p_assignment_id NUMBER;
p_element_link_id NUMBER;
p_entry_type VARCHAR2 (200);
p_creator_type VARCHAR2 (200);
p_input_value_id1 NUMBER;
p_input_value_id2 NUMBER;
p_input_value_id3 NUMBER;
p_input_value_id4 NUMBER;
p_input_value_id5 NUMBER;
p_input_value_id6 NUMBER;
p_input_value_id7 NUMBER;
p_input_value_id8 NUMBER;
p_input_value_id9 NUMBER;
p_input_value_id10 NUMBER;
p_input_value_id11 NUMBER;
p_input_value_id12 NUMBER;
p_input_value_id13 NUMBER;
p_input_value_id14 NUMBER;
p_input_value_id15 NUMBER;
p_entry_value1 VARCHAR2 (200);
p_entry_value2 VARCHAR2 (200);
p_entry_value3 VARCHAR2 (200);
p_entry_value4 VARCHAR2 (200);
p_entry_value5 VARCHAR2 (200);
p_entry_value6 VARCHAR2 (200);
p_entry_value7 VARCHAR2 (200);
p_entry_value8 VARCHAR2 (200);
p_entry_value9 VARCHAR2 (200);
p_entry_value10 VARCHAR2 (200);
p_entry_value11 VARCHAR2 (200);
p_entry_value12 VARCHAR2 (200);
p_entry_value13 VARCHAR2 (200);
p_entry_value14 VARCHAR2 (200);
p_entry_value15 VARCHAR2 (200);
p_effective_start_date DATE;
p_effective_end_date DATE;
p_element_entry_id NUMBER;
p_object_version_number NUMBER;
p_create_warning BOOLEAN;
L_effective_START_date DATE;
L_effective_end_date DATE;
L_element_entry_id NUMBER;
L_object_version_number NUMBER;
L_create_warning BOOLEAN;
BEGIN
L_effective_end_date := NULL;
L_effective_START_date := NULL;
L_element_entry_id := NULL;
L_object_version_number := NULL;
L_create_warning := NULL;
apps.pay_element_entry_api.create_element_entry
(p_validate=>FALSE,
p_effective_date=>TO_DATE ('01/07/2012', 'DD/MM/YYYY'),
p_business_group_id =>161,
p_original_entry_id=> NULL,
p_assignment_id =>521,
p_element_link_id=>301,
p_entry_type =>'E',
p_creator_type=>'F',
p_input_value_id1=>461,
p_input_value_id2=>NULL,
p_input_value_id3=>NULL,
p_input_value_id4=>NULL,
p_input_value_id5=>NULL,
p_input_value_id6=>NULL,
p_input_value_id7=>NULL,
p_input_value_id8=>NULL,
p_input_value_id9=>NULL,
p_input_value_id10=>NULL,
p_input_value_id11=>NULL,
p_input_value_id12=>NULL,
p_input_value_id13=>NULL,
p_input_value_id14=>NULL,
p_input_value_id15=>NULL,
p_entry_value1=>'TEST',
p_entry_value2=>NULL,
p_entry_value3=>NULL,
p_entry_value4=>NULL,
p_entry_value5=>NULL,
p_entry_value6=>NULL,
p_entry_value7=>NULL,
p_entry_value8=>NULL,
p_entry_value9=>NULL,
p_entry_value10=>NULL,
p_entry_value11=>NULL,
p_entry_value12=>NULL,
p_entry_value13=>NULL,
p_entry_value14=>NULL,
p_entry_value15=>NULL,
p_effective_start_date =>L_effective_start_date ,
p_effective_end_date
=>L_effective_end_date,
p_element_entry_id =>L_element_entry_id ,
p_object_version_number=>L_object_version_number ,
p_create_warning=>L_create_warning
);
COMMIT;
END;
No comments:
Post a Comment