Saturday Jun 09, 2012

Oracle HRMS API – Delete Employee Element Entry

API --  pay_element_entry_api.delete_element_entry 

 

Example --

Consider Employee has Element Entry "Bonus". Lets try to Delete Element Entry "Bonus" using delete API

 

 

DECLARE
      ld_effective_start_date            DATE;
      ld_effective_end_date             DATE;
      lb_delete_warning                   BOOLEAN;
      ln_object_version_number    PAY_ELEMENT_ENTRIES_F.OBJECT_VERSION_NUMBER%TYPE := 1;

BEGIN
      -- Delete Element Entry
      -- -------------------------------
        pay_element_entry_api.delete_element_entry
        (    -- Input data elements
             -- ------------------------------
             p_datetrack_delete_mode    => 'DELETE',
             p_effective_date                      => TO_DATE('23-JUNE-2011'),
             p_element_entry_id               => 118557,
             -- Output data elements
             -- --------------------------------
             p_object_version_number   => ln_object_version_number,
             p_effective_start_date           => ld_effective_start_date,
             p_effective_end_date            => ld_effective_end_date,
             p_delete_warning                  => lb_delete_warning
        );
 
 COMMIT;


EXCEPTION
        WHEN OTHERS THEN
                          ROLLBACK;
                          dbms_output.put_line(SQLERRM);
END;
/

SHOW ERR;

 

About

Welcome to My Oracle World Puneet Rajkumar

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today