Oracle HRMS API – Delete Employee Element Entry
- by PRajkumar
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;