Oracle Element Entry API

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;