276: IF (x_mode = 'I') THEN
277: x_last_updated_by := 1;
278: x_last_update_login := 0;
279: ELSIF (x_mode = 'R') THEN
280: x_last_updated_by := fnd_global.user_id;
281: IF (x_last_updated_by IS NULL) THEN
282: x_last_updated_by := -1;
283: END IF;
284: x_last_update_login := fnd_global.login_id;
280: x_last_updated_by := fnd_global.user_id;
281: IF (x_last_updated_by IS NULL) THEN
282: x_last_updated_by := -1;
283: END IF;
284: x_last_update_login := fnd_global.login_id;
285: IF (x_last_update_login IS NULL) THEN
286: x_last_update_login := -1;
287: END IF;
288: x_request_id := fnd_global.conc_request_id;
284: x_last_update_login := fnd_global.login_id;
285: IF (x_last_update_login IS NULL) THEN
286: x_last_update_login := -1;
287: END IF;
288: x_request_id := fnd_global.conc_request_id;
289: x_program_id := fnd_global.conc_program_id;
290: x_program_application_id := fnd_global.prog_appl_id;
291:
292: IF (x_request_id = -1) THEN
285: IF (x_last_update_login IS NULL) THEN
286: x_last_update_login := -1;
287: END IF;
288: x_request_id := fnd_global.conc_request_id;
289: x_program_id := fnd_global.conc_program_id;
290: x_program_application_id := fnd_global.prog_appl_id;
291:
292: IF (x_request_id = -1) THEN
293: x_request_id := NULL;
286: x_last_update_login := -1;
287: END IF;
288: x_request_id := fnd_global.conc_request_id;
289: x_program_id := fnd_global.conc_program_id;
290: x_program_application_id := fnd_global.prog_appl_id;
291:
292: IF (x_request_id = -1) THEN
293: x_request_id := NULL;
294: x_program_id := NULL;
461: IF (X_MODE = 'I') THEN
462: x_last_updated_by := 1;
463: x_last_update_login := 0;
464: ELSIF (x_mode = 'R') THEN
465: x_last_updated_by := fnd_global.user_id;
466: IF x_last_updated_by IS NULL THEN
467: x_last_updated_by := -1;
468: END IF;
469: x_last_update_login := fnd_global.login_id;
465: x_last_updated_by := fnd_global.user_id;
466: IF x_last_updated_by IS NULL THEN
467: x_last_updated_by := -1;
468: END IF;
469: x_last_update_login := fnd_global.login_id;
470: IF (x_last_update_login IS NULL) THEN
471: x_last_update_login := -1;
472: END IF;
473: ELSE
491: x_last_update_login => x_last_update_login
492: );
493:
494: IF (x_mode = 'R') THEN
495: x_request_id := fnd_global.conc_request_id;
496: x_program_id := fnd_global.conc_program_id;
497: x_program_application_id := fnd_global.prog_appl_id;
498: IF (x_request_id = -1) THEN
499: x_request_id := old_references.request_id;
492: );
493:
494: IF (x_mode = 'R') THEN
495: x_request_id := fnd_global.conc_request_id;
496: x_program_id := fnd_global.conc_program_id;
497: x_program_application_id := fnd_global.prog_appl_id;
498: IF (x_request_id = -1) THEN
499: x_request_id := old_references.request_id;
500: x_program_id := old_references.program_id;
493:
494: IF (x_mode = 'R') THEN
495: x_request_id := fnd_global.conc_request_id;
496: x_program_id := fnd_global.conc_program_id;
497: x_program_application_id := fnd_global.prog_appl_id;
498: IF (x_request_id = -1) THEN
499: x_request_id := old_references.request_id;
500: x_program_id := old_references.program_id;
501: x_program_application_id := old_references.program_application_id;