TRIGGER: APPS.PAY_PBC_MNT_TL_ARI

Source

Description

pay_pbc_mnt_tl_ari

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

*/

after insert
on pay_balance_categories_f
for each row

Type

AFTER EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare
begin
if ( hr_general.g_data_migrator_mode <> 'Y' and pay_balance_category_api.return_dml_status <> true ) then

   pay_mls_triggers.pbc_ari(  P_BALANCE_CATEGORY_ID  =>:NEW.balance_category_id
                             ,P_USER_CATEGORY_NAME_N =>:NEW.user_category_name
                             ,P_USER_CATEGORY_NAME_O => null
                           );

end if;
end pay_pbc_mnt_tl_ari;