TRIGGER: APPS.PAY_PUR_MNT_TL_BRD

Source

Description

"APPS"."PAY_PUR_MNT_TL_BRD" 

/*
  Maintain pay_user_rows_f_tl data in cases
  where dml is being performed outside
  api

*/

before delete
 ON  "HR"."PAY_USER_ROWS_F#"  for each row

Type

BEFORE 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_pur_shd.return_api_dml_status <> true ) then

    pay_mls_triggers.pur_brd(P_USER_ROW_ID    =>:OLD.user_row_id);

end if;
end pay_pur_mnt_tl_brd;