925: if(X_MODE = 'I') then
926: X_LAST_UPDATED_BY := 1;
927: X_LAST_UPDATE_LOGIN := 0;
928: elsif (X_MODE IN ('R', 'S')) then
929: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
930: if X_LAST_UPDATED_BY is NULL then
931: X_LAST_UPDATED_BY := -1;
932: end if;
933: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
929: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
930: if X_LAST_UPDATED_BY is NULL then
931: X_LAST_UPDATED_BY := -1;
932: end if;
933: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
934: if X_LAST_UPDATE_LOGIN is NULL then
935: X_LAST_UPDATE_LOGIN := -1;
936: end if;
937: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
933: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
934: if X_LAST_UPDATE_LOGIN is NULL then
935: X_LAST_UPDATE_LOGIN := -1;
936: end if;
937: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
938: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
939: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
940: if (X_REQUEST_ID = -1) then
941: X_REQUEST_ID := NULL;
934: if X_LAST_UPDATE_LOGIN is NULL then
935: X_LAST_UPDATE_LOGIN := -1;
936: end if;
937: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
938: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
939: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
940: if (X_REQUEST_ID = -1) then
941: X_REQUEST_ID := NULL;
942: X_PROGRAM_ID := NULL;
935: X_LAST_UPDATE_LOGIN := -1;
936: end if;
937: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
938: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
939: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
940: if (X_REQUEST_ID = -1) then
941: X_REQUEST_ID := NULL;
942: X_PROGRAM_ID := NULL;
943: X_PROGRAM_APPLICATION_ID := NULL;
1147: if(X_MODE = 'I') then
1148: X_LAST_UPDATED_BY := 1;
1149: X_LAST_UPDATE_LOGIN := 0;
1150: elsif (X_MODE IN ('R', 'S')) then
1151: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1152: if X_LAST_UPDATED_BY is NULL then
1153: X_LAST_UPDATED_BY := -1;
1154: end if;
1155: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1151: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1152: if X_LAST_UPDATED_BY is NULL then
1153: X_LAST_UPDATED_BY := -1;
1154: end if;
1155: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1156: if X_LAST_UPDATE_LOGIN is NULL then
1157: X_LAST_UPDATE_LOGIN := -1;
1158: end if;
1159: else
1182: );
1183:
1184:
1185: if (X_MODE IN ('R', 'S')) then
1186: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1187: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1188: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1189: if (X_REQUEST_ID = -1) then
1190: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1183:
1184:
1185: if (X_MODE IN ('R', 'S')) then
1186: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1187: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1188: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1189: if (X_REQUEST_ID = -1) then
1190: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1191: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
1184:
1185: if (X_MODE IN ('R', 'S')) then
1186: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1187: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1188: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1189: if (X_REQUEST_ID = -1) then
1190: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1191: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
1192: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;