589: if(X_MODE = 'I') then
590: X_LAST_UPDATED_BY := 1;
591: X_LAST_UPDATE_LOGIN := 0;
592: elsif (X_MODE IN ('R', 'S')) then
593: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
594: if X_LAST_UPDATED_BY is NULL then
595: X_LAST_UPDATED_BY := -1;
596: end if;
597: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
593: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
594: if X_LAST_UPDATED_BY is NULL then
595: X_LAST_UPDATED_BY := -1;
596: end if;
597: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
598: if X_LAST_UPDATE_LOGIN is NULL then
599: X_LAST_UPDATE_LOGIN := -1;
600: end if;
601: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
597: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
598: if X_LAST_UPDATE_LOGIN is NULL then
599: X_LAST_UPDATE_LOGIN := -1;
600: end if;
601: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
602: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
603: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
604: if (X_REQUEST_ID = -1) then
605: X_REQUEST_ID := NULL;
598: if X_LAST_UPDATE_LOGIN is NULL then
599: X_LAST_UPDATE_LOGIN := -1;
600: end if;
601: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
602: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
603: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
604: if (X_REQUEST_ID = -1) then
605: X_REQUEST_ID := NULL;
606: X_PROGRAM_ID := NULL;
599: X_LAST_UPDATE_LOGIN := -1;
600: end if;
601: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
602: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
603: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
604: if (X_REQUEST_ID = -1) then
605: X_REQUEST_ID := NULL;
606: X_PROGRAM_ID := NULL;
607: X_PROGRAM_APPLICATION_ID := NULL;
820: if(X_MODE = 'I') then
821: X_LAST_UPDATED_BY := 1;
822: X_LAST_UPDATE_LOGIN := 0;
823: elsif (X_MODE IN ('R', 'S')) then
824: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
825: if X_LAST_UPDATED_BY is NULL then
826: X_LAST_UPDATED_BY := -1;
827: end if;
828: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
824: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
825: if X_LAST_UPDATED_BY is NULL then
826: X_LAST_UPDATED_BY := -1;
827: end if;
828: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
829: if X_LAST_UPDATE_LOGIN is NULL then
830: X_LAST_UPDATE_LOGIN := -1;
831: end if;
832: else
853: x_last_updated_by=>X_LAST_UPDATED_BY,
854: x_last_update_login=>X_LAST_UPDATE_LOGIN);
855:
856: if (X_MODE IN ('R', 'S')) then
857: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
858: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
859: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
860: if (X_REQUEST_ID = -1) then
861: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
854: x_last_update_login=>X_LAST_UPDATE_LOGIN);
855:
856: if (X_MODE IN ('R', 'S')) then
857: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
858: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
859: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
860: if (X_REQUEST_ID = -1) then
861: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
862: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
855:
856: if (X_MODE IN ('R', 'S')) then
857: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
858: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
859: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
860: if (X_REQUEST_ID = -1) then
861: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
862: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
863: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;