222: IF (x_mode = 'I') THEN
223: x_last_updated_by := 1;
224: x_last_update_login := 0;
225: ELSIF (x_mode = 'R') THEN
226: x_last_updated_by := fnd_global.user_id;
227: IF (x_last_updated_by IS NULL) THEN
228: x_last_updated_by := -1;
229: END IF;
230: x_last_update_login := fnd_global.login_id;
226: x_last_updated_by := fnd_global.user_id;
227: IF (x_last_updated_by IS NULL) THEN
228: x_last_updated_by := -1;
229: END IF;
230: x_last_update_login := fnd_global.login_id;
231: IF (x_last_update_login IS NULL) THEN
232: x_last_update_login := -1;
233: END IF;
234: x_request_id := fnd_global.conc_request_id;
230: x_last_update_login := fnd_global.login_id;
231: IF (x_last_update_login IS NULL) THEN
232: x_last_update_login := -1;
233: END IF;
234: x_request_id := fnd_global.conc_request_id;
235: x_program_id := fnd_global.conc_program_id;
236: x_program_application_id := fnd_global.prog_appl_id;
237:
238: IF (x_request_id = -1) THEN
231: IF (x_last_update_login IS NULL) THEN
232: x_last_update_login := -1;
233: END IF;
234: x_request_id := fnd_global.conc_request_id;
235: x_program_id := fnd_global.conc_program_id;
236: x_program_application_id := fnd_global.prog_appl_id;
237:
238: IF (x_request_id = -1) THEN
239: x_request_id := NULL;
232: x_last_update_login := -1;
233: END IF;
234: x_request_id := fnd_global.conc_request_id;
235: x_program_id := fnd_global.conc_program_id;
236: x_program_application_id := fnd_global.prog_appl_id;
237:
238: IF (x_request_id = -1) THEN
239: x_request_id := NULL;
240: x_program_id := NULL;
420: IF (X_MODE = 'I') THEN
421: x_last_updated_by := 1;
422: x_last_update_login := 0;
423: ELSIF (x_mode = 'R') THEN
424: x_last_updated_by := fnd_global.user_id;
425: IF x_last_updated_by IS NULL THEN
426: x_last_updated_by := -1;
427: END IF;
428: x_last_update_login := fnd_global.login_id;
424: x_last_updated_by := fnd_global.user_id;
425: IF x_last_updated_by IS NULL THEN
426: x_last_updated_by := -1;
427: END IF;
428: x_last_update_login := fnd_global.login_id;
429: IF (x_last_update_login IS NULL) THEN
430: x_last_update_login := -1;
431: END IF;
432: ELSE
452: x_last_update_login => x_last_update_login
453: );
454:
455: IF (x_mode = 'R') THEN
456: x_request_id := fnd_global.conc_request_id;
457: x_program_id := fnd_global.conc_program_id;
458: x_program_application_id := fnd_global.prog_appl_id;
459: IF (x_request_id = -1) THEN
460: x_request_id := old_references.request_id;
453: );
454:
455: IF (x_mode = 'R') THEN
456: x_request_id := fnd_global.conc_request_id;
457: x_program_id := fnd_global.conc_program_id;
458: x_program_application_id := fnd_global.prog_appl_id;
459: IF (x_request_id = -1) THEN
460: x_request_id := old_references.request_id;
461: x_program_id := old_references.program_id;
454:
455: IF (x_mode = 'R') THEN
456: x_request_id := fnd_global.conc_request_id;
457: x_program_id := fnd_global.conc_program_id;
458: x_program_application_id := fnd_global.prog_appl_id;
459: IF (x_request_id = -1) THEN
460: x_request_id := old_references.request_id;
461: x_program_id := old_references.program_id;
462: x_program_application_id := old_references.program_application_id;