Delete Employee Element Entry Using Oracle HRMS API

Following scripts can be used to delete an existing Employee Element Entry for an existing employee.

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('01-JAN-2013'), 
             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;