124: from dual;
125: end if;
126:
127: if p_created_by is null then
128: p_created_by := fnd_global.user_id;
129: end if;
130:
131: if p_last_updated_by is null then
132: p_last_updated_by := fnd_global.user_id;
128: p_created_by := fnd_global.user_id;
129: end if;
130:
131: if p_last_updated_by is null then
132: p_last_updated_by := fnd_global.user_id;
133: end if;
134:
135: if p_last_update_login is null then
136: p_last_update_login := fnd_global.login_id;
132: p_last_updated_by := fnd_global.user_id;
133: end if;
134:
135: if p_last_update_login is null then
136: p_last_update_login := fnd_global.login_id;
137: end if;
138:
139: if p_creation_date is null then
140: p_creation_date := sysdate;
345: is
346: begin
347:
348: if p_last_updated_by is null then
349: p_last_updated_by := fnd_global.user_id;
350: end if;
351:
352: if p_last_update_login is null then
353: p_last_update_login := fnd_global.login_id;
349: p_last_updated_by := fnd_global.user_id;
350: end if;
351:
352: if p_last_update_login is null then
353: p_last_update_login := fnd_global.login_id;
354: end if;
355:
356: if p_last_update_date is null then
357: p_last_update_date := sysdate;