6: if hr_general.g_data_migrator_mode <> 'Y' then
7: if inserting and
8: :new.created_by is null and
9: :new.creation_date is null then
10: :new.created_by := fnd_global.user_id;
11: :new.creation_date := sysdate;
12: end if;
13: if :new.last_update_date is null
14: or :new.last_update_date = nvl(:old.last_update_date,
16: or :new.last_update_date = trunc(:new.last_update_date)
17: then
18: :new.last_update_date := sysdate;
19: end if;
20: :new.last_updated_by := fnd_global.user_id;
21: :new.last_update_login := fnd_global.login_id;
22: end if;
23: end;
17: then
18: :new.last_update_date := sysdate;
19: end if;
20: :new.last_updated_by := fnd_global.user_id;
21: :new.last_update_login := fnd_global.login_id;
22: end if;
23: end;