TRIGGER: APPS.BEN_BENEFIT_CONTRIBUTIONS_WHO

Source

Description

BEN_BENEFIT_CONTRIBUTIONS_WHO
before insert or update on BEN_BENEFIT_CONTRIBUTIONS_F
for each row

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare
 l_sysdate DATE := sysdate;
begin
  -- Trigger generated by hrcretrg2.sql at 2007/01/04 02:58:00.
 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   := l_sysdate;
  end if;
  :new.last_update_date  := l_sysdate;
  :new.last_updated_by   := fnd_global.user_id;
  :new.last_update_login := fnd_global.login_id;
 end if;
end;