[Home] [Help]
113: FND_GLOBAL.CONC_REQUEST_ID,
114: FND_GLOBAL.PROG_APPL_ID,
115: FND_GLOBAL.CONC_PROGRAM_ID,
116: SYSDATE
117: FROM WIP_OPERATION_RESOURCES
118: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
119: AND ORGANIZATION_ID = P_ORGANIZATION_ID);
120: END IF;
121:
227: FND_GLOBAL.CONC_REQUEST_ID,
228: FND_GLOBAL.PROG_APPL_ID,
229: FND_GLOBAL.CONC_PROGRAM_ID,
230: SYSDATE
231: FROM WIP_OPERATION_RESOURCES
232: WHERE (WIP_ENTITY_ID, ORGANIZATION_ID) IN
233: (SELECT WIP_ENTITY_ID,
234: ORGANIZATION_ID
235: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI
298: LAST_UPDATE_DATE = SYSDATE
299: WHERE WO.WIP_ENTITY_ID = C.WIP_ENTITY_ID
300: AND WO.ORGANIZATION_ID = C.ORGANIZATION_ID;
301:
302: UPDATE WIP_OPERATION_RESOURCES WOR
303: SET (START_DATE,
304: COMPLETION_DATE,
305: LAST_UPDATE_DATE,
306: LAST_UPDATED_BY) =
316: AND WOR.ORGANIZATION_ID = C.ORGANIZATION_ID;
317:
318: ELSIF C.SCHEDULING_LEVEL = 2 THEN
319:
320: UPDATE WIP_OPERATION_RESOURCES WOR
321: SET (WOR.START_DATE,
322: WOR.COMPLETION_DATE,
323: WOR.USAGE_RATE_OR_AMOUNT,
324: WOR.LAST_UPDATED_BY) =
338: FOR D IN COP(C.WIP_ENTITY_ID, C.ORGANIZATION_ID) LOOP
339:
340: SELECT MIN(START_DATE), MAX(COMPLETION_DATE)
341: INTO x_min_date, x_max_date
342: FROM WIP_OPERATION_RESOURCES WOR
343: WHERE WOR.WIP_ENTITY_ID = C.WIP_ENTITY_ID
344: AND WOR.OPERATION_SEQ_NUM = D.OPERATION_SEQ_NUM
345: AND WOR.ORGANIZATION_ID = C.ORGANIZATION_ID;
346:
586: AND SI2.PROCESS_PHASE = 2
587: AND SI2.PROCESS_STATUS = 2
588: MINUS
589: SELECT OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM
590: FROM WIP_OPERATION_RESOURCES WOR
591: WHERE WOR.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
592: AND WOR.ORGANIZATION_ID = WSI.ORGANIZATION_ID
593: ) ',
594: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
600: WIP_CONSTANTS.ERROR,
601: ' WSI.SCHEDULING_LEVEL = 2
602: AND EXISTS (
603: SELECT OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM
604: FROM WIP_OPERATION_RESOURCES WOR
605: WHERE WOR.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
606: AND WOR.ORGANIZATION_ID = WSI.ORGANIZATION_ID
607: MINUS
608: SELECT OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM