446: IF (x_mode = 'I') THEN
447: x_last_updated_by := 1;
448: x_last_update_login := 0;
449: ELSIF (x_mode = 'R') THEN
450: x_last_updated_by := fnd_global.user_id;
451: IF (x_last_updated_by IS NULL) THEN
452: x_last_updated_by := -1;
453: END IF;
454: x_last_update_login := fnd_global.login_id;
450: x_last_updated_by := fnd_global.user_id;
451: IF (x_last_updated_by IS NULL) THEN
452: x_last_updated_by := -1;
453: END IF;
454: x_last_update_login := fnd_global.login_id;
455: IF (x_last_update_login IS NULL) THEN
456: x_last_update_login := -1;
457: END IF;
458: x_request_id := fnd_global.conc_request_id;
454: x_last_update_login := fnd_global.login_id;
455: IF (x_last_update_login IS NULL) THEN
456: x_last_update_login := -1;
457: END IF;
458: x_request_id := fnd_global.conc_request_id;
459: x_program_id := fnd_global.conc_program_id;
460: x_program_application_id := fnd_global.prog_appl_id;
461:
462: IF (x_request_id = -1) THEN
455: IF (x_last_update_login IS NULL) THEN
456: x_last_update_login := -1;
457: END IF;
458: x_request_id := fnd_global.conc_request_id;
459: x_program_id := fnd_global.conc_program_id;
460: x_program_application_id := fnd_global.prog_appl_id;
461:
462: IF (x_request_id = -1) THEN
463: x_request_id := NULL;
456: x_last_update_login := -1;
457: END IF;
458: x_request_id := fnd_global.conc_request_id;
459: x_program_id := fnd_global.conc_program_id;
460: x_program_application_id := fnd_global.prog_appl_id;
461:
462: IF (x_request_id = -1) THEN
463: x_request_id := NULL;
464: x_program_id := NULL;
683: IF (X_MODE = 'I') THEN
684: x_last_updated_by := 1;
685: x_last_update_login := 0;
686: ELSIF (x_mode = 'R') THEN
687: x_last_updated_by := fnd_global.user_id;
688: IF x_last_updated_by IS NULL THEN
689: x_last_updated_by := -1;
690: END IF;
691: x_last_update_login := fnd_global.login_id;
687: x_last_updated_by := fnd_global.user_id;
688: IF x_last_updated_by IS NULL THEN
689: x_last_updated_by := -1;
690: END IF;
691: x_last_update_login := fnd_global.login_id;
692: IF (x_last_update_login IS NULL) THEN
693: x_last_update_login := -1;
694: END IF;
695: ELSE
720: x_last_update_login => x_last_update_login
721: );
722:
723: IF (x_mode = 'R') THEN
724: x_request_id := fnd_global.conc_request_id;
725: x_program_id := fnd_global.conc_program_id;
726: x_program_application_id := fnd_global.prog_appl_id;
727: IF (x_request_id = -1) THEN
728: x_request_id := old_references.request_id;
721: );
722:
723: IF (x_mode = 'R') THEN
724: x_request_id := fnd_global.conc_request_id;
725: x_program_id := fnd_global.conc_program_id;
726: x_program_application_id := fnd_global.prog_appl_id;
727: IF (x_request_id = -1) THEN
728: x_request_id := old_references.request_id;
729: x_program_id := old_references.program_id;
722:
723: IF (x_mode = 'R') THEN
724: x_request_id := fnd_global.conc_request_id;
725: x_program_id := fnd_global.conc_program_id;
726: x_program_application_id := fnd_global.prog_appl_id;
727: IF (x_request_id = -1) THEN
728: x_request_id := old_references.request_id;
729: x_program_id := old_references.program_id;
730: x_program_application_id := old_references.program_application_id;