Monday, September 9, 2013

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;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect