456: if(X_MODE = 'I') then
457: X_LAST_UPDATED_BY := 1;
458: X_LAST_UPDATE_LOGIN := 0;
459: elsif (X_MODE = 'R') then
460: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
461: if X_LAST_UPDATED_BY is NULL then
462: X_LAST_UPDATED_BY := -1;
463: end if;
464: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
460: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
461: if X_LAST_UPDATED_BY is NULL then
462: X_LAST_UPDATED_BY := -1;
463: end if;
464: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
465: if X_LAST_UPDATE_LOGIN is NULL then
466: X_LAST_UPDATE_LOGIN := -1;
467: end if;
468: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
464: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
465: if X_LAST_UPDATE_LOGIN is NULL then
466: X_LAST_UPDATE_LOGIN := -1;
467: end if;
468: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
469: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
470: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
471: if (X_REQUEST_ID = -1) then
472: X_REQUEST_ID := NULL;
465: if X_LAST_UPDATE_LOGIN is NULL then
466: X_LAST_UPDATE_LOGIN := -1;
467: end if;
468: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
469: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
470: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
471: if (X_REQUEST_ID = -1) then
472: X_REQUEST_ID := NULL;
473: X_PROGRAM_ID := NULL;
466: X_LAST_UPDATE_LOGIN := -1;
467: end if;
468: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
469: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
470: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
471: if (X_REQUEST_ID = -1) then
472: X_REQUEST_ID := NULL;
473: X_PROGRAM_ID := NULL;
474: X_PROGRAM_APPLICATION_ID := NULL;
682: if(X_MODE = 'I') then
683: X_LAST_UPDATED_BY := 1;
684: X_LAST_UPDATE_LOGIN := 0;
685: elsif (X_MODE = 'R') then
686: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
687: if X_LAST_UPDATED_BY is NULL then
688: X_LAST_UPDATED_BY := -1;
689: end if;
690: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
686: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
687: if X_LAST_UPDATED_BY is NULL then
688: X_LAST_UPDATED_BY := -1;
689: end if;
690: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
691: if X_LAST_UPDATE_LOGIN is NULL then
692: X_LAST_UPDATE_LOGIN := -1;
693: end if;
694: else
726: x_sua_location_cd =>X_SUA_LOCATION_CD
727: );
728:
729: if (X_MODE = 'R') then
730: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
731: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
732: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
733: if (X_REQUEST_ID = -1) then
734: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
727: );
728:
729: if (X_MODE = 'R') then
730: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
731: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
732: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
733: if (X_REQUEST_ID = -1) then
734: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
735: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
728:
729: if (X_MODE = 'R') then
730: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
731: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
732: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
733: if (X_REQUEST_ID = -1) then
734: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
735: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
736: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;