77:
78: IF (x_mode = 'R') THEN
79: x_last_update_date := SYSDATE;
80: x_creation_date := SYSDATE;
81: x_created_by := fnd_global.user_id;
82: IF (x_created_by IS NULL) THEN
83: x_created_by := -1;
84: END IF;
85: x_last_updated_by := fnd_global.user_id;
81: x_created_by := fnd_global.user_id;
82: IF (x_created_by IS NULL) THEN
83: x_created_by := -1;
84: END IF;
85: x_last_updated_by := fnd_global.user_id;
86: IF (x_last_updated_by IS NULL) THEN
87:
88: x_last_updated_by := -1;
89: END IF;
86: IF (x_last_updated_by IS NULL) THEN
87:
88: x_last_updated_by := -1;
89: END IF;
90: x_last_update_login := fnd_global.login_id;
91: IF (x_last_update_login IS NULL) THEN
92: x_last_update_login := -1;
93: END IF;
94: ELSE
222: BEGIN
223:
224: x_last_update_date := SYSDATE;
225: IF (x_mode = 'R') THEN
226: x_last_updated_by := fnd_global.user_id;
227:
228: IF x_last_updated_by IS NULL THEN
229:
230: x_last_updated_by := -1;
228: IF x_last_updated_by IS NULL THEN
229:
230: x_last_updated_by := -1;
231: END IF;
232: x_last_update_login := fnd_global.login_id;
233: IF (x_last_update_login IS NULL) THEN
234: x_last_update_login := -1;
235: END IF;
236: ELSE