8: if inserting
9: and :new.created_by is null
10: and :new.creation_date is null then
11:
12: :new.created_by := fnd_global.user_id;
13: :new.creation_date := sysdate;
14:
15: end if;
16:
14:
15: end if;
16:
17: :new.last_update_date := sysdate;
18: :new.last_updated_by := fnd_global.user_id;
19: :new.last_update_login := fnd_global.login_id;
20:
21: end if;
22:
15: end if;
16:
17: :new.last_update_date := sysdate;
18: :new.last_updated_by := fnd_global.user_id;
19: :new.last_update_login := fnd_global.login_id;
20:
21: end if;
22:
23: end;