454: if(X_MODE = 'I') then
455: X_LAST_UPDATED_BY := 1;
456: X_LAST_UPDATE_LOGIN := 0;
457: elsif (X_MODE = 'R') then
458: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
459: if X_LAST_UPDATED_BY is NULL then
460: X_LAST_UPDATED_BY := -1;
461: end if;
462: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
458: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
459: if X_LAST_UPDATED_BY is NULL then
460: X_LAST_UPDATED_BY := -1;
461: end if;
462: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
463: if X_LAST_UPDATE_LOGIN is NULL then
464: X_LAST_UPDATE_LOGIN := -1;
465: end if;
466: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
462: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
463: if X_LAST_UPDATE_LOGIN is NULL then
464: X_LAST_UPDATE_LOGIN := -1;
465: end if;
466: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
467: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
468: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
469: if (X_REQUEST_ID = -1) then
470: X_REQUEST_ID := NULL;
463: if X_LAST_UPDATE_LOGIN is NULL then
464: X_LAST_UPDATE_LOGIN := -1;
465: end if;
466: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
467: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
468: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
469: if (X_REQUEST_ID = -1) then
470: X_REQUEST_ID := NULL;
471: X_PROGRAM_ID := NULL;
464: X_LAST_UPDATE_LOGIN := -1;
465: end if;
466: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
467: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
468: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
469: if (X_REQUEST_ID = -1) then
470: X_REQUEST_ID := NULL;
471: X_PROGRAM_ID := NULL;
472: X_PROGRAM_APPLICATION_ID := NULL;
617: if(X_MODE = 'I') then
618: X_LAST_UPDATED_BY := 1;
619: X_LAST_UPDATE_LOGIN := 0;
620: elsif (X_MODE = 'R') then
621: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
622: if X_LAST_UPDATED_BY is NULL then
623: X_LAST_UPDATED_BY := -1;
624: end if;
625: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
621: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
622: if X_LAST_UPDATED_BY is NULL then
623: X_LAST_UPDATED_BY := -1;
624: end if;
625: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
626: if X_LAST_UPDATE_LOGIN is NULL then
627: X_LAST_UPDATE_LOGIN := -1;
628: end if;
629: else
650: x_last_update_login=>X_LAST_UPDATE_LOGIN,
651: x_uoo_id=>X_UOO_ID
652: );
653: if (X_MODE = 'R') then
654: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
655: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
656: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
657: if (X_REQUEST_ID = -1) then
658: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
651: x_uoo_id=>X_UOO_ID
652: );
653: if (X_MODE = 'R') then
654: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
655: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
656: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
657: if (X_REQUEST_ID = -1) then
658: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
659: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
652: );
653: if (X_MODE = 'R') then
654: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
655: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
656: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
657: if (X_REQUEST_ID = -1) then
658: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
659: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
660: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;