226: IF (x_mode = 'I') THEN
227: x_last_updated_by := 1;
228: x_last_update_login := 0;
229: ELSIF (x_mode = 'R') THEN
230: x_last_updated_by := fnd_global.user_id;
231: IF (x_last_updated_by IS NULL) THEN
232: x_last_updated_by := -1;
233: END IF;
234: x_last_update_login := fnd_global.login_id;
230: x_last_updated_by := fnd_global.user_id;
231: IF (x_last_updated_by IS NULL) THEN
232: x_last_updated_by := -1;
233: END IF;
234: x_last_update_login := fnd_global.login_id;
235: IF (x_last_update_login IS NULL) THEN
236: x_last_update_login := -1;
237: END IF;
238: x_request_id := fnd_global.conc_request_id;
234: x_last_update_login := fnd_global.login_id;
235: IF (x_last_update_login IS NULL) THEN
236: x_last_update_login := -1;
237: END IF;
238: x_request_id := fnd_global.conc_request_id;
239: x_program_id := fnd_global.conc_program_id;
240: x_program_application_id := fnd_global.prog_appl_id;
241:
242: IF (x_request_id = -1) THEN
235: IF (x_last_update_login IS NULL) THEN
236: x_last_update_login := -1;
237: END IF;
238: x_request_id := fnd_global.conc_request_id;
239: x_program_id := fnd_global.conc_program_id;
240: x_program_application_id := fnd_global.prog_appl_id;
241:
242: IF (x_request_id = -1) THEN
243: x_request_id := NULL;
236: x_last_update_login := -1;
237: END IF;
238: x_request_id := fnd_global.conc_request_id;
239: x_program_id := fnd_global.conc_program_id;
240: x_program_application_id := fnd_global.prog_appl_id;
241:
242: IF (x_request_id = -1) THEN
243: x_request_id := NULL;
244: x_program_id := NULL;
423: IF (X_MODE = 'I') THEN
424: x_last_updated_by := 1;
425: x_last_update_login := 0;
426: ELSIF (x_mode = 'R') THEN
427: x_last_updated_by := fnd_global.user_id;
428: IF x_last_updated_by IS NULL THEN
429: x_last_updated_by := -1;
430: END IF;
431: x_last_update_login := fnd_global.login_id;
427: x_last_updated_by := fnd_global.user_id;
428: IF x_last_updated_by IS NULL THEN
429: x_last_updated_by := -1;
430: END IF;
431: x_last_update_login := fnd_global.login_id;
432: IF (x_last_update_login IS NULL) THEN
433: x_last_update_login := -1;
434: END IF;
435: ELSE
457: x_last_update_login => x_last_update_login
458: );
459:
460: IF (x_mode = 'R') THEN
461: x_request_id := fnd_global.conc_request_id;
462: x_program_id := fnd_global.conc_program_id;
463: x_program_application_id := fnd_global.prog_appl_id;
464: IF (x_request_id = -1) THEN
465: x_request_id := old_references.request_id;
458: );
459:
460: IF (x_mode = 'R') THEN
461: x_request_id := fnd_global.conc_request_id;
462: x_program_id := fnd_global.conc_program_id;
463: x_program_application_id := fnd_global.prog_appl_id;
464: IF (x_request_id = -1) THEN
465: x_request_id := old_references.request_id;
466: x_program_id := old_references.program_id;
459:
460: IF (x_mode = 'R') THEN
461: x_request_id := fnd_global.conc_request_id;
462: x_program_id := fnd_global.conc_program_id;
463: x_program_application_id := fnd_global.prog_appl_id;
464: IF (x_request_id = -1) THEN
465: x_request_id := old_references.request_id;
466: x_program_id := old_references.program_id;
467: x_program_application_id := old_references.program_application_id;