273: IF (x_mode = 'I') THEN
274: x_last_updated_by := 1;
275: x_last_update_login := 0;
276: ELSIF (x_mode = 'R') THEN
277: x_last_updated_by := fnd_global.user_id;
278: IF (x_last_updated_by IS NULL) THEN
279: x_last_updated_by := -1;
280: END IF;
281: x_last_update_login := fnd_global.login_id;
277: x_last_updated_by := fnd_global.user_id;
278: IF (x_last_updated_by IS NULL) THEN
279: x_last_updated_by := -1;
280: END IF;
281: x_last_update_login := fnd_global.login_id;
282: IF (x_last_update_login IS NULL) THEN
283: x_last_update_login := -1;
284: END IF;
285: x_request_id := fnd_global.conc_request_id;
281: x_last_update_login := fnd_global.login_id;
282: IF (x_last_update_login IS NULL) THEN
283: x_last_update_login := -1;
284: END IF;
285: x_request_id := fnd_global.conc_request_id;
286: x_program_id := fnd_global.conc_program_id;
287: x_program_application_id := fnd_global.prog_appl_id;
288:
289: IF (x_request_id = -1) THEN
282: IF (x_last_update_login IS NULL) THEN
283: x_last_update_login := -1;
284: END IF;
285: x_request_id := fnd_global.conc_request_id;
286: x_program_id := fnd_global.conc_program_id;
287: x_program_application_id := fnd_global.prog_appl_id;
288:
289: IF (x_request_id = -1) THEN
290: x_request_id := NULL;
283: x_last_update_login := -1;
284: END IF;
285: x_request_id := fnd_global.conc_request_id;
286: x_program_id := fnd_global.conc_program_id;
287: x_program_application_id := fnd_global.prog_appl_id;
288:
289: IF (x_request_id = -1) THEN
290: x_request_id := NULL;
291: x_program_id := NULL;
485: IF (X_MODE = 'I') THEN
486: x_last_updated_by := 1;
487: x_last_update_login := 0;
488: ELSIF (x_mode = 'R') THEN
489: x_last_updated_by := fnd_global.user_id;
490: IF x_last_updated_by IS NULL THEN
491: x_last_updated_by := -1;
492: END IF;
493: x_last_update_login := fnd_global.login_id;
489: x_last_updated_by := fnd_global.user_id;
490: IF x_last_updated_by IS NULL THEN
491: x_last_updated_by := -1;
492: END IF;
493: x_last_update_login := fnd_global.login_id;
494: IF (x_last_update_login IS NULL) THEN
495: x_last_update_login := -1;
496: END IF;
497: ELSE
519: x_last_update_login => x_last_update_login
520: );
521:
522: IF (x_mode = 'R') THEN
523: x_request_id := fnd_global.conc_request_id;
524: x_program_id := fnd_global.conc_program_id;
525: x_program_application_id := fnd_global.prog_appl_id;
526: IF (x_request_id = -1) THEN
527: x_request_id := old_references.request_id;
520: );
521:
522: IF (x_mode = 'R') THEN
523: x_request_id := fnd_global.conc_request_id;
524: x_program_id := fnd_global.conc_program_id;
525: x_program_application_id := fnd_global.prog_appl_id;
526: IF (x_request_id = -1) THEN
527: x_request_id := old_references.request_id;
528: x_program_id := old_references.program_id;
521:
522: IF (x_mode = 'R') THEN
523: x_request_id := fnd_global.conc_request_id;
524: x_program_id := fnd_global.conc_program_id;
525: x_program_application_id := fnd_global.prog_appl_id;
526: IF (x_request_id = -1) THEN
527: x_request_id := old_references.request_id;
528: x_program_id := old_references.program_id;
529: x_program_application_id := old_references.program_application_id;