Oracle HRMS API – Delete Employee Element Entry

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;