TRIGGER: APPS.PAY_PCT_MNT_TL_ARI

Source

Description

pay_pct_mnt_tl_ari

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

*/

after insert
on pay_user_columns
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_puc_shd.return_api_dml_status <> true and
   pay_user_columns_pkg.return_dml_status <> true ) then

 pay_pct_ins.ins_tl(
                    P_LANGUAGE_CODE                =>userenv('LANG')
                    ,P_USER_COLUMN_ID               =>:NEW.user_column_id
                    ,P_USER_COLUMN_NAME             =>:NEW.user_column_name
 );

end if;
end pay_pct_mnt_tl_ari;