TRIGGER: APPS.PAY_USER_ROWS_F_ARU

Source

Description

pay_user_rows_f_aru
after update on           pay_user_rows_f
for each row

Type

AFTER EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare

   -- Local variables
   l_user_table_name varchar2(80);

begin

   if hr_general.g_data_migrator_mode <> 'Y' then

      select ut.user_table_name
      into   l_user_table_name
      from   pay_user_tables ut
      where  ut.user_table_id = :old.user_table_id;

      if l_user_table_name = 'ZA_RSC_TABLE' then

         -- Update fnd_lookup_values */
         update fnd_lookup_values
         set    lookup_code      = :new.row_low_range_or_name,
                meaning          = :new.row_low_range_or_name,
                last_update_date = sysdate ,
                description      = :new.row_low_range_or_name
         where  lookup_type      = 'ZA_RSC_REGIONS'
         and
         (
            (lookup_code = :old.row_low_range_or_name)
            or
            (meaning     = :old.row_low_range_or_name)
         );

      end if;

   end if;

end;