15: x_creation_date date;
16: x_created_by number;
17: BEGIN
18: x_last_update_date := sysdate;
19: x_last_updated_by := fnd_global.user_id;
20: x_last_update_login := fnd_global.user_id;
21: x_creation_date := sysdate;
22: x_created_by := fnd_global.user_id;
23: select gms_personnel_s.nextval
16: x_created_by number;
17: BEGIN
18: x_last_update_date := sysdate;
19: x_last_updated_by := fnd_global.user_id;
20: x_last_update_login := fnd_global.user_id;
21: x_creation_date := sysdate;
22: x_created_by := fnd_global.user_id;
23: select gms_personnel_s.nextval
24: into personnel_id
18: x_last_update_date := sysdate;
19: x_last_updated_by := fnd_global.user_id;
20: x_last_update_login := fnd_global.user_id;
21: x_creation_date := sysdate;
22: x_created_by := fnd_global.user_id;
23: select gms_personnel_s.nextval
24: into personnel_id
25: from dual;
26: insert into gms_personnel