TRIGGER: APPS.PAY_ZA_CDV_PARAM_WHO

Source

Description

pay_za_cdv_param_who
before insert or update on pay_za_cdv_parameters
for each row

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin

   if hr_general.g_data_migrator_mode <> 'Y' then

      if  inserting
      and :new.created_by    is null
      and :new.creation_date is null then

         :new.created_by    := fnd_global.user_id;
         :new.creation_date := sysdate;

      end if;

      :new.last_update_date  := sysdate;
      :new.last_updated_by   := fnd_global.user_id;
      :new.last_update_login := fnd_global.login_id;

   end if;

end;