61:
62: IF (x_mode = 'R') THEN
63: x_last_update_date := SYSDATE;
64: x_creation_date := SYSDATE;
65: x_created_by := fnd_global.user_id;
66: IF (x_created_by IS NULL) THEN
67: x_created_by := -1;
68: END IF;
69: x_last_updated_by := fnd_global.user_id;
65: x_created_by := fnd_global.user_id;
66: IF (x_created_by IS NULL) THEN
67: x_created_by := -1;
68: END IF;
69: x_last_updated_by := fnd_global.user_id;
70: IF (x_last_updated_by IS NULL) THEN
71:
72: x_last_updated_by := -1;
73: END IF;
70: IF (x_last_updated_by IS NULL) THEN
71:
72: x_last_updated_by := -1;
73: END IF;
74: x_last_update_login := fnd_global.login_id;
75: IF (x_last_update_login IS NULL) THEN
76: x_last_update_login := -1;
77: END IF;
78: ELSE
156: BEGIN
157:
158: x_last_update_date := SYSDATE;
159: IF (x_mode = 'R') THEN
160: x_last_updated_by := fnd_global.user_id;
161:
162: IF x_last_updated_by IS NULL THEN
163:
164: x_last_updated_by := -1;
162: IF x_last_updated_by IS NULL THEN
163:
164: x_last_updated_by := -1;
165: END IF;
166: x_last_update_login := fnd_global.login_id;
167: IF (x_last_update_login IS NULL) THEN
168: x_last_update_login := -1;
169: END IF;
170: ELSE