TRIGGER: APPS.PAY_PUT_MNT_TL_ARU

Source

Description

pay_put_mnt_tl_aru

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

*/

after update
on pay_user_tables
for each row

Type

AFTER EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

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

 pay_ptt_upd.upd_tl(     P_LANGUAGE_CODE        =>userenv('LANG')
                        ,P_USER_TABLE_ID        =>:NEW.user_table_id
                        ,P_USER_TABLE_NAME      =>:NEW.user_table_name
                        ,P_USER_ROW_TITLE       =>:NEW.user_row_title );

end if;
end pay_put_mnt_tl_aru;