227: IF (x_mode = 'I') THEN
228: x_last_updated_by := 1;
229: x_last_update_login := 0;
230: ELSIF (x_mode = 'R') THEN
231: x_last_updated_by := fnd_global.user_id;
232: IF (x_last_updated_by IS NULL) THEN
233: x_last_updated_by := -1;
234: END IF;
235: x_last_update_login := fnd_global.login_id;
231: x_last_updated_by := fnd_global.user_id;
232: IF (x_last_updated_by IS NULL) THEN
233: x_last_updated_by := -1;
234: END IF;
235: x_last_update_login := fnd_global.login_id;
236: IF (x_last_update_login IS NULL) THEN
237: x_last_update_login := -1;
238: END IF;
239: x_request_id := fnd_global.conc_request_id;
235: x_last_update_login := fnd_global.login_id;
236: IF (x_last_update_login IS NULL) THEN
237: x_last_update_login := -1;
238: END IF;
239: x_request_id := fnd_global.conc_request_id;
240: x_program_id := fnd_global.conc_program_id;
241: x_program_application_id := fnd_global.prog_appl_id;
242:
243: IF (x_request_id = -1) THEN
236: IF (x_last_update_login IS NULL) THEN
237: x_last_update_login := -1;
238: END IF;
239: x_request_id := fnd_global.conc_request_id;
240: x_program_id := fnd_global.conc_program_id;
241: x_program_application_id := fnd_global.prog_appl_id;
242:
243: IF (x_request_id = -1) THEN
244: x_request_id := NULL;
237: x_last_update_login := -1;
238: END IF;
239: x_request_id := fnd_global.conc_request_id;
240: x_program_id := fnd_global.conc_program_id;
241: x_program_application_id := fnd_global.prog_appl_id;
242:
243: IF (x_request_id = -1) THEN
244: x_request_id := NULL;
245: x_program_id := NULL;
427: IF (X_MODE = 'I') THEN
428: x_last_updated_by := 1;
429: x_last_update_login := 0;
430: ELSIF (x_mode = 'R') THEN
431: x_last_updated_by := fnd_global.user_id;
432: IF x_last_updated_by IS NULL THEN
433: x_last_updated_by := -1;
434: END IF;
435: x_last_update_login := fnd_global.login_id;
431: x_last_updated_by := fnd_global.user_id;
432: IF x_last_updated_by IS NULL THEN
433: x_last_updated_by := -1;
434: END IF;
435: x_last_update_login := fnd_global.login_id;
436: IF (x_last_update_login IS NULL) THEN
437: x_last_update_login := -1;
438: END IF;
439: ELSE
462: x_last_update_login => x_last_update_login
463: );
464:
465: IF (x_mode = 'R') THEN
466: x_request_id := fnd_global.conc_request_id;
467: x_program_id := fnd_global.conc_program_id;
468: x_program_application_id := fnd_global.prog_appl_id;
469: IF (x_request_id = -1) THEN
470: x_request_id := old_references.request_id;
463: );
464:
465: IF (x_mode = 'R') THEN
466: x_request_id := fnd_global.conc_request_id;
467: x_program_id := fnd_global.conc_program_id;
468: x_program_application_id := fnd_global.prog_appl_id;
469: IF (x_request_id = -1) THEN
470: x_request_id := old_references.request_id;
471: x_program_id := old_references.program_id;
464:
465: IF (x_mode = 'R') THEN
466: x_request_id := fnd_global.conc_request_id;
467: x_program_id := fnd_global.conc_program_id;
468: x_program_application_id := fnd_global.prog_appl_id;
469: IF (x_request_id = -1) THEN
470: x_request_id := old_references.request_id;
471: x_program_id := old_references.program_id;
472: x_program_application_id := old_references.program_application_id;