pay_pct_mnt_tl_ard
/*
Maintain pay_user_columns_tl data in cases
where dml is being performed outside
api
*/
after delete
on pay_user_columns
for each row
Type
AFTER EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
declare
begin
if ( hr_general.g_data_migrator_mode <> 'Y' and
pay_puc_shd.return_api_dml_status <> true and
pay_user_columns_pkg.return_dml_status <> true ) then
pay_pct_del.del_tl(P_USER_COLUMN_ID =>:OLD.user_column_id );
end if;
end pay_pct_mnt_tl_ard;