543: if(X_MODE = 'I') then
544: X_LAST_UPDATED_BY := 1;
545: X_LAST_UPDATE_LOGIN := 0;
546: elsif (X_MODE = 'R') then
547: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
548: if X_LAST_UPDATED_BY is NULL then
549: X_LAST_UPDATED_BY := -1;
550: end if;
551: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
547: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
548: if X_LAST_UPDATED_BY is NULL then
549: X_LAST_UPDATED_BY := -1;
550: end if;
551: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
552: if X_LAST_UPDATE_LOGIN is NULL then
553: X_LAST_UPDATE_LOGIN := -1;
554: end if;
555: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
551: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
552: if X_LAST_UPDATE_LOGIN is NULL then
553: X_LAST_UPDATE_LOGIN := -1;
554: end if;
555: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
556: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
557:
558: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
559: if (X_REQUEST_ID = -1) then
552: if X_LAST_UPDATE_LOGIN is NULL then
553: X_LAST_UPDATE_LOGIN := -1;
554: end if;
555: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
556: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
557:
558: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
559: if (X_REQUEST_ID = -1) then
560: X_REQUEST_ID := NULL;
554: end if;
555: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
556: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
557:
558: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
559: if (X_REQUEST_ID = -1) then
560: X_REQUEST_ID := NULL;
561: X_PROGRAM_ID := NULL;
562: X_PROGRAM_APPLICATION_ID := NULL;
753: if(X_MODE = 'I') then
754: X_LAST_UPDATED_BY := 1;
755: X_LAST_UPDATE_LOGIN := 0;
756: elsif (X_MODE = 'R') then
757: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
758: if X_LAST_UPDATED_BY is NULL then
759: X_LAST_UPDATED_BY := -1;
760: end if;
761: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
757: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
758: if X_LAST_UPDATED_BY is NULL then
759: X_LAST_UPDATED_BY := -1;
760: end if;
761: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
762: if X_LAST_UPDATE_LOGIN is NULL then
763: X_LAST_UPDATE_LOGIN := -1;
764: end if;
765: else
788: x_abort_flag => x_abort_flag
789: );
790:
791: if (X_MODE = 'R') then
792: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
793: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
794: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
795: if (X_REQUEST_ID = -1) then
796: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
789: );
790:
791: if (X_MODE = 'R') then
792: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
793: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
794: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
795: if (X_REQUEST_ID = -1) then
796: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
797: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
790:
791: if (X_MODE = 'R') then
792: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
793: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
794: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
795: if (X_REQUEST_ID = -1) then
796: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
797: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
798: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;