541: if(X_MODE = 'I') then
542: X_LAST_UPDATED_BY := 1;
543: X_LAST_UPDATE_LOGIN := 0;
544: elsif (X_MODE = 'R') then
545: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
546: if X_LAST_UPDATED_BY is NULL then
547: X_LAST_UPDATED_BY := -1;
548: end if;
549: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
545: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
546: if X_LAST_UPDATED_BY is NULL then
547: X_LAST_UPDATED_BY := -1;
548: end if;
549: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
550: if X_LAST_UPDATE_LOGIN is NULL then
551: X_LAST_UPDATE_LOGIN := -1;
552: end if;
553: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
549: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
550: if X_LAST_UPDATE_LOGIN is NULL then
551: X_LAST_UPDATE_LOGIN := -1;
552: end if;
553: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
554: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
555:
556: X_PROGRAM_APPLICATION_ID :=
557: FND_GLOBAL.PROG_APPL_ID;
550: if X_LAST_UPDATE_LOGIN is NULL then
551: X_LAST_UPDATE_LOGIN := -1;
552: end if;
553: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
554: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
555:
556: X_PROGRAM_APPLICATION_ID :=
557: FND_GLOBAL.PROG_APPL_ID;
558: if (X_REQUEST_ID = -1) then
553: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
554: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
555:
556: X_PROGRAM_APPLICATION_ID :=
557: FND_GLOBAL.PROG_APPL_ID;
558: if (X_REQUEST_ID = -1) then
559: X_REQUEST_ID := NULL;
560: X_PROGRAM_ID := NULL;
561: X_PROGRAM_APPLICATION_ID := NULL;
783: if(X_MODE = 'I') then
784: X_LAST_UPDATED_BY := 1;
785: X_LAST_UPDATE_LOGIN := 0;
786: elsif (X_MODE = 'R') then
787: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
788: if X_LAST_UPDATED_BY is NULL then
789: X_LAST_UPDATED_BY := -1;
790: end if;
791: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
787: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
788: if X_LAST_UPDATED_BY is NULL then
789: X_LAST_UPDATED_BY := -1;
790: end if;
791: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
792: if X_LAST_UPDATE_LOGIN is NULL then
793: X_LAST_UPDATE_LOGIN := -1;
794: end if;
795: else
824: x_last_update_login=>X_LAST_UPDATE_LOGIN
825: );
826:
827: if (X_MODE = 'R') then
828: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
829: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
830: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
831: if (X_REQUEST_ID = -1) then
832: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
825: );
826:
827: if (X_MODE = 'R') then
828: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
829: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
830: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
831: if (X_REQUEST_ID = -1) then
832: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
833: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
826:
827: if (X_MODE = 'R') then
828: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
829: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
830: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
831: if (X_REQUEST_ID = -1) then
832: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
833: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
834: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;