491: if(X_MODE = 'I') then
492: X_LAST_UPDATED_BY := 1;
493: X_LAST_UPDATE_LOGIN := 0;
494: elsif (X_MODE = 'R') then
495: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
496: if X_LAST_UPDATED_BY is NULL then
497: X_LAST_UPDATED_BY := -1;
498: end if;
499: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
495: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
496: if X_LAST_UPDATED_BY is NULL then
497: X_LAST_UPDATED_BY := -1;
498: end if;
499: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
500: if X_LAST_UPDATE_LOGIN is NULL then
501: X_LAST_UPDATE_LOGIN := -1;
502: end if;
503: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
499: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
500: if X_LAST_UPDATE_LOGIN is NULL then
501: X_LAST_UPDATE_LOGIN := -1;
502: end if;
503: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
504: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
505:
506: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
507: if (X_REQUEST_ID = -1) then
500: if X_LAST_UPDATE_LOGIN is NULL then
501: X_LAST_UPDATE_LOGIN := -1;
502: end if;
503: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
504: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
505:
506: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
507: if (X_REQUEST_ID = -1) then
508: X_REQUEST_ID := NULL;
502: end if;
503: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
504: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
505:
506: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
507: if (X_REQUEST_ID = -1) then
508: X_REQUEST_ID := NULL;
509: X_PROGRAM_ID := NULL;
510: X_PROGRAM_APPLICATION_ID := NULL;
653: if(X_MODE = 'I') then
654: X_LAST_UPDATED_BY := 1;
655: X_LAST_UPDATE_LOGIN := 0;
656: elsif (X_MODE = 'R') then
657: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
658: if X_LAST_UPDATED_BY is NULL then
659: X_LAST_UPDATED_BY := -1;
660: end if;
661: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
657: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
658: if X_LAST_UPDATED_BY is NULL then
659: X_LAST_UPDATED_BY := -1;
660: end if;
661: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
662: if X_LAST_UPDATE_LOGIN is NULL then
663: X_LAST_UPDATE_LOGIN := -1;
664: end if;
665: else
685: x_last_update_login=>X_LAST_UPDATE_LOGIN
686: );
687:
688: if (X_MODE = 'R') then
689: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
690: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
691: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
692: if (X_REQUEST_ID = -1) then
693: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
686: );
687:
688: if (X_MODE = 'R') then
689: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
690: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
691: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
692: if (X_REQUEST_ID = -1) then
693: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
694: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
687:
688: if (X_MODE = 'R') then
689: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
690: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
691: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
692: if (X_REQUEST_ID = -1) then
693: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
694: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
695: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;