225: IF (x_mode = 'I') THEN
226: x_last_updated_by := 1;
227: x_last_update_login := 0;
228: ELSIF (x_mode = 'R') THEN
229: x_last_updated_by := fnd_global.user_id;
230: IF (x_last_updated_by IS NULL) THEN
231: x_last_updated_by := -1;
232: END IF;
233: x_last_update_login := fnd_global.login_id;
229: x_last_updated_by := fnd_global.user_id;
230: IF (x_last_updated_by IS NULL) THEN
231: x_last_updated_by := -1;
232: END IF;
233: x_last_update_login := fnd_global.login_id;
234: IF (x_last_update_login IS NULL) THEN
235: x_last_update_login := -1;
236: END IF;
237: x_request_id := fnd_global.conc_request_id;
233: x_last_update_login := fnd_global.login_id;
234: IF (x_last_update_login IS NULL) THEN
235: x_last_update_login := -1;
236: END IF;
237: x_request_id := fnd_global.conc_request_id;
238: x_program_id := fnd_global.conc_program_id;
239: x_program_application_id := fnd_global.prog_appl_id;
240:
241: IF (x_request_id = -1) THEN
234: IF (x_last_update_login IS NULL) THEN
235: x_last_update_login := -1;
236: END IF;
237: x_request_id := fnd_global.conc_request_id;
238: x_program_id := fnd_global.conc_program_id;
239: x_program_application_id := fnd_global.prog_appl_id;
240:
241: IF (x_request_id = -1) THEN
242: x_request_id := NULL;
235: x_last_update_login := -1;
236: END IF;
237: x_request_id := fnd_global.conc_request_id;
238: x_program_id := fnd_global.conc_program_id;
239: x_program_application_id := fnd_global.prog_appl_id;
240:
241: IF (x_request_id = -1) THEN
242: x_request_id := NULL;
243: x_program_id := NULL;
392: IF (X_MODE = 'I') THEN
393: x_last_updated_by := 1;
394: x_last_update_login := 0;
395: ELSIF (x_mode = 'R') THEN
396: x_last_updated_by := fnd_global.user_id;
397: IF x_last_updated_by IS NULL THEN
398: x_last_updated_by := -1;
399: END IF;
400: x_last_update_login := fnd_global.login_id;
396: x_last_updated_by := fnd_global.user_id;
397: IF x_last_updated_by IS NULL THEN
398: x_last_updated_by := -1;
399: END IF;
400: x_last_update_login := fnd_global.login_id;
401: IF (x_last_update_login IS NULL) THEN
402: x_last_update_login := -1;
403: END IF;
404: ELSE
420: x_last_update_login => x_last_update_login
421: );
422:
423: IF (x_mode = 'R') THEN
424: x_request_id := fnd_global.conc_request_id;
425: x_program_id := fnd_global.conc_program_id;
426: x_program_application_id := fnd_global.prog_appl_id;
427: IF (x_request_id = -1) THEN
428: x_request_id := old_references.request_id;
421: );
422:
423: IF (x_mode = 'R') THEN
424: x_request_id := fnd_global.conc_request_id;
425: x_program_id := fnd_global.conc_program_id;
426: x_program_application_id := fnd_global.prog_appl_id;
427: IF (x_request_id = -1) THEN
428: x_request_id := old_references.request_id;
429: x_program_id := old_references.program_id;
422:
423: IF (x_mode = 'R') THEN
424: x_request_id := fnd_global.conc_request_id;
425: x_program_id := fnd_global.conc_program_id;
426: x_program_application_id := fnd_global.prog_appl_id;
427: IF (x_request_id = -1) THEN
428: x_request_id := old_references.request_id;
429: x_program_id := old_references.program_id;
430: x_program_application_id := old_references.program_application_id;