pay_element_sets_mnt_tl_ard
/*
Maintain pay_element_sets_tl data in cases
where dml is being performed outside
api
*/
after delete
on pay_element_sets
for each row
Type
AFTER EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
declare
begin
--For sustaining dual maintenance---
if(PAY_ADHOC_UTILS_PKG.chk_post_r11i = 'Y') then
if ( hr_general.g_data_migrator_mode <> 'Y') and
( pay_element_sets_pkg.return_dml_status <> true ) then
pay_est_del.del_tl(P_ELEMENT_SET_ID => :NEW.element_set_id);
end if;
end if;
end pay_element_sets_mnt_tl_ard;