1146: if(X_MODE = 'I') then
1147: X_LAST_UPDATED_BY := 1;
1148: X_LAST_UPDATE_LOGIN := 0;
1149: elsif (X_MODE = 'R') then
1150: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1151: if X_LAST_UPDATED_BY is NULL then
1152: X_LAST_UPDATED_BY := -1;
1153: end if;
1154: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1150: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1151: if X_LAST_UPDATED_BY is NULL then
1152: X_LAST_UPDATED_BY := -1;
1153: end if;
1154: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1155: if X_LAST_UPDATE_LOGIN is NULL then
1156: X_LAST_UPDATE_LOGIN := -1;
1157: end if;
1158: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1154: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1155: if X_LAST_UPDATE_LOGIN is NULL then
1156: X_LAST_UPDATE_LOGIN := -1;
1157: end if;
1158: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1159: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1160: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1161: if (X_REQUEST_ID = -1) then
1162: X_REQUEST_ID := NULL;
1155: if X_LAST_UPDATE_LOGIN is NULL then
1156: X_LAST_UPDATE_LOGIN := -1;
1157: end if;
1158: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1159: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1160: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1161: if (X_REQUEST_ID = -1) then
1162: X_REQUEST_ID := NULL;
1163: X_PROGRAM_ID := NULL;
1156: X_LAST_UPDATE_LOGIN := -1;
1157: end if;
1158: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1159: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1160: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1161: if (X_REQUEST_ID = -1) then
1162: X_REQUEST_ID := NULL;
1163: X_PROGRAM_ID := NULL;
1164: X_PROGRAM_APPLICATION_ID := NULL;
1449: if(X_MODE = 'I') then
1450: X_LAST_UPDATED_BY := 1;
1451: X_LAST_UPDATE_LOGIN := 0;
1452: elsif (X_MODE = 'R') then
1453: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1454: if X_LAST_UPDATED_BY is NULL then
1455: X_LAST_UPDATED_BY := -1;
1456: end if;
1457: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1453: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1454: if X_LAST_UPDATED_BY is NULL then
1455: X_LAST_UPDATED_BY := -1;
1456: end if;
1457: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1458: if X_LAST_UPDATE_LOGIN is NULL then
1459: X_LAST_UPDATE_LOGIN := -1;
1460: end if;
1461: else
1496: x_last_update_login => X_LAST_UPDATE_LOGIN
1497: );
1498:
1499: if (X_MODE = 'R') then
1500: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1501: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1502: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1503: if (X_REQUEST_ID = -1) then
1504: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1497: );
1498:
1499: if (X_MODE = 'R') then
1500: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1501: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1502: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1503: if (X_REQUEST_ID = -1) then
1504: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1505: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
1498:
1499: if (X_MODE = 'R') then
1500: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1501: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1502: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1503: if (X_REQUEST_ID = -1) then
1504: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1505: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
1506: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;