572: IF (x_mode = 'I') THEN
573: x_last_updated_by := 1;
574: x_last_update_login := 0;
575: ELSIF (x_mode = 'R') THEN
576: x_last_updated_by := fnd_global.user_id;
577: IF (x_last_updated_by IS NULL) THEN
578: x_last_updated_by := -1;
579: END IF;
580: x_last_update_login := fnd_global.login_id;
576: x_last_updated_by := fnd_global.user_id;
577: IF (x_last_updated_by IS NULL) THEN
578: x_last_updated_by := -1;
579: END IF;
580: x_last_update_login := fnd_global.login_id;
581: IF (x_last_update_login IS NULL) THEN
582: x_last_update_login := -1;
583: END IF;
584: x_request_id := fnd_global.conc_request_id;
580: x_last_update_login := fnd_global.login_id;
581: IF (x_last_update_login IS NULL) THEN
582: x_last_update_login := -1;
583: END IF;
584: x_request_id := fnd_global.conc_request_id;
585: x_program_id := fnd_global.conc_program_id;
586: x_program_application_id := fnd_global.prog_appl_id;
587:
588: IF (x_request_id = -1) THEN
581: IF (x_last_update_login IS NULL) THEN
582: x_last_update_login := -1;
583: END IF;
584: x_request_id := fnd_global.conc_request_id;
585: x_program_id := fnd_global.conc_program_id;
586: x_program_application_id := fnd_global.prog_appl_id;
587:
588: IF (x_request_id = -1) THEN
589: x_request_id := NULL;
582: x_last_update_login := -1;
583: END IF;
584: x_request_id := fnd_global.conc_request_id;
585: x_program_id := fnd_global.conc_program_id;
586: x_program_application_id := fnd_global.prog_appl_id;
587:
588: IF (x_request_id = -1) THEN
589: x_request_id := NULL;
590: x_program_id := NULL;
910: IF (X_MODE = 'I') THEN
911: x_last_updated_by := 1;
912: x_last_update_login := 0;
913: ELSIF (x_mode = 'R') THEN
914: x_last_updated_by := fnd_global.user_id;
915: IF x_last_updated_by IS NULL THEN
916: x_last_updated_by := -1;
917: END IF;
918: x_last_update_login := fnd_global.login_id;
914: x_last_updated_by := fnd_global.user_id;
915: IF x_last_updated_by IS NULL THEN
916: x_last_updated_by := -1;
917: END IF;
918: x_last_update_login := fnd_global.login_id;
919: IF (x_last_update_login IS NULL) THEN
920: x_last_update_login := -1;
921: END IF;
922: ELSE
965:
966: );
967:
968: IF (x_mode = 'R') THEN
969: x_request_id := fnd_global.conc_request_id;
970: x_program_id := fnd_global.conc_program_id;
971: x_program_application_id := fnd_global.prog_appl_id;
972: IF (x_request_id = -1) THEN
973: x_request_id := old_references.request_id;
966: );
967:
968: IF (x_mode = 'R') THEN
969: x_request_id := fnd_global.conc_request_id;
970: x_program_id := fnd_global.conc_program_id;
971: x_program_application_id := fnd_global.prog_appl_id;
972: IF (x_request_id = -1) THEN
973: x_request_id := old_references.request_id;
974: x_program_id := old_references.program_id;
967:
968: IF (x_mode = 'R') THEN
969: x_request_id := fnd_global.conc_request_id;
970: x_program_id := fnd_global.conc_program_id;
971: x_program_application_id := fnd_global.prog_appl_id;
972: IF (x_request_id = -1) THEN
973: x_request_id := old_references.request_id;
974: x_program_id := old_references.program_id;
975: x_program_application_id := old_references.program_application_id;