548: if(l_mode = 'I') then
549: X_LAST_UPDATED_BY := 1;
550: X_LAST_UPDATE_LOGIN := 0;
551: elsif (l_mode IN ('R','S')) then
552: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
553: if X_LAST_UPDATED_BY is NULL then
554: X_LAST_UPDATED_BY := -1;
555: end if;
556: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
552: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
553: if X_LAST_UPDATED_BY is NULL then
554: X_LAST_UPDATED_BY := -1;
555: end if;
556: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
557: if X_LAST_UPDATE_LOGIN is NULL then
558: X_LAST_UPDATE_LOGIN := -1;
559: end if;
560: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
556: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
557: if X_LAST_UPDATE_LOGIN is NULL then
558: X_LAST_UPDATE_LOGIN := -1;
559: end if;
560: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
561: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
562: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
563: if (X_REQUEST_ID = -1) then
564: X_REQUEST_ID := NULL;
557: if X_LAST_UPDATE_LOGIN is NULL then
558: X_LAST_UPDATE_LOGIN := -1;
559: end if;
560: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
561: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
562: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
563: if (X_REQUEST_ID = -1) then
564: X_REQUEST_ID := NULL;
565: X_PROGRAM_ID := NULL;
558: X_LAST_UPDATE_LOGIN := -1;
559: end if;
560: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
561: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
562: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
563: if (X_REQUEST_ID = -1) then
564: X_REQUEST_ID := NULL;
565: X_PROGRAM_ID := NULL;
566: X_PROGRAM_APPLICATION_ID := NULL;
803: if(l_mode = 'I') then
804: X_LAST_UPDATED_BY := 1;
805: X_LAST_UPDATE_LOGIN := 0;
806: elsif (l_mode IN ('R','S')) then
807: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
808: if X_LAST_UPDATED_BY is NULL then
809: X_LAST_UPDATED_BY := -1;
810: end if;
811: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
807: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
808: if X_LAST_UPDATED_BY is NULL then
809: X_LAST_UPDATED_BY := -1;
810: end if;
811: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
812: if X_LAST_UPDATE_LOGIN is NULL then
813: X_LAST_UPDATE_LOGIN := -1;
814: end if;
815: else
837: x_last_updated_by=>X_LAST_UPDATED_BY,
838: x_last_update_login=>X_LAST_UPDATE_LOGIN);
839:
840: if (l_mode IN ('R','S')) then
841: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
842: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
843: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
844: if (X_REQUEST_ID = -1) then
845: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
838: x_last_update_login=>X_LAST_UPDATE_LOGIN);
839:
840: if (l_mode IN ('R','S')) then
841: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
842: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
843: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
844: if (X_REQUEST_ID = -1) then
845: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
846: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
839:
840: if (l_mode IN ('R','S')) then
841: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
842: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
843: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
844: if (X_REQUEST_ID = -1) then
845: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
846: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
847: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;