406: IF (x_mode = 'I') THEN
407: x_last_updated_by := 1;
408: x_last_update_login := 0;
409: ELSIF (x_mode = 'R') THEN
410: x_last_updated_by := fnd_global.user_id;
411: IF (x_last_updated_by IS NULL) THEN
412: x_last_updated_by := -1;
413: END IF;
414: x_last_update_login := fnd_global.login_id;
410: x_last_updated_by := fnd_global.user_id;
411: IF (x_last_updated_by IS NULL) THEN
412: x_last_updated_by := -1;
413: END IF;
414: x_last_update_login := fnd_global.login_id;
415: IF (x_last_update_login IS NULL) THEN
416: x_last_update_login := -1;
417: END IF;
418: x_request_id := fnd_global.conc_request_id;
414: x_last_update_login := fnd_global.login_id;
415: IF (x_last_update_login IS NULL) THEN
416: x_last_update_login := -1;
417: END IF;
418: x_request_id := fnd_global.conc_request_id;
419: x_program_id := fnd_global.conc_program_id;
420: x_program_application_id := fnd_global.prog_appl_id;
421:
422: IF (x_request_id = -1) THEN
415: IF (x_last_update_login IS NULL) THEN
416: x_last_update_login := -1;
417: END IF;
418: x_request_id := fnd_global.conc_request_id;
419: x_program_id := fnd_global.conc_program_id;
420: x_program_application_id := fnd_global.prog_appl_id;
421:
422: IF (x_request_id = -1) THEN
423: x_request_id := NULL;
416: x_last_update_login := -1;
417: END IF;
418: x_request_id := fnd_global.conc_request_id;
419: x_program_id := fnd_global.conc_program_id;
420: x_program_application_id := fnd_global.prog_appl_id;
421:
422: IF (x_request_id = -1) THEN
423: x_request_id := NULL;
424: x_program_id := NULL;
624: IF (X_MODE = 'I') THEN
625: x_last_updated_by := 1;
626: x_last_update_login := 0;
627: ELSIF (x_mode = 'R') THEN
628: x_last_updated_by := fnd_global.user_id;
629: IF x_last_updated_by IS NULL THEN
630: x_last_updated_by := -1;
631: END IF;
632: x_last_update_login := fnd_global.login_id;
628: x_last_updated_by := fnd_global.user_id;
629: IF x_last_updated_by IS NULL THEN
630: x_last_updated_by := -1;
631: END IF;
632: x_last_update_login := fnd_global.login_id;
633: IF (x_last_update_login IS NULL) THEN
634: x_last_update_login := -1;
635: END IF;
636: ELSE
660: x_last_update_login => x_last_update_login
661: );
662:
663: IF (x_mode = 'R') THEN
664: x_request_id := fnd_global.conc_request_id;
665: x_program_id := fnd_global.conc_program_id;
666: x_program_application_id := fnd_global.prog_appl_id;
667: IF (x_request_id = -1) THEN
668: x_request_id := old_references.request_id;
661: );
662:
663: IF (x_mode = 'R') THEN
664: x_request_id := fnd_global.conc_request_id;
665: x_program_id := fnd_global.conc_program_id;
666: x_program_application_id := fnd_global.prog_appl_id;
667: IF (x_request_id = -1) THEN
668: x_request_id := old_references.request_id;
669: x_program_id := old_references.program_id;
662:
663: IF (x_mode = 'R') THEN
664: x_request_id := fnd_global.conc_request_id;
665: x_program_id := fnd_global.conc_program_id;
666: x_program_application_id := fnd_global.prog_appl_id;
667: IF (x_request_id = -1) THEN
668: x_request_id := old_references.request_id;
669: x_program_id := old_references.program_id;
670: x_program_application_id := old_references.program_application_id;