34: from dual;
35: end if;
36:
37: if p_created_by is null then
38: p_created_by := fnd_global.user_id;
39: end if;
40:
41: if p_last_updated_by is null then
42: p_last_updated_by := fnd_global.user_id;
38: p_created_by := fnd_global.user_id;
39: end if;
40:
41: if p_last_updated_by is null then
42: p_last_updated_by := fnd_global.user_id;
43: end if;
44:
45: if p_last_update_login is null then
46: p_last_update_login := fnd_global.login_id;
42: p_last_updated_by := fnd_global.user_id;
43: end if;
44:
45: if p_last_update_login is null then
46: p_last_update_login := fnd_global.login_id;
47: end if;
48:
49: if p_creation_date is null then
50: p_creation_date := sysdate;
144: is
145: begin
146:
147: if p_last_updated_by is null then
148: p_last_updated_by := fnd_global.user_id;
149: end if;
150:
151: if p_last_update_login is null then
152: p_last_update_login := fnd_global.login_id;
148: p_last_updated_by := fnd_global.user_id;
149: end if;
150:
151: if p_last_update_login is null then
152: p_last_update_login := fnd_global.login_id;
153: end if;
154:
155: if p_last_update_date is null then
156: p_last_update_date := sysdate;