APPS.WIP_SCHEDULER dependencies on WIP_OPERATION_RESOURCES

Line 197: INSERT INTO WIP_OPERATION_RESOURCES

193: AND WO.ORGANIZATION_ID = X_Organization_Id
194: AND NVL(WO.REPETITIVE_SCHEDULE_ID, -1) =
195: NVL(X_Repetitive_Schedule_Id, -1);
196:
197: INSERT INTO WIP_OPERATION_RESOURCES
198: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM,
199: ORGANIZATION_ID, REPETITIVE_SCHEDULE_ID,
200: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
201: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,

Line 246: FROM WIP_OPERATION_RESOURCES

242: AND (ORS.ACD_TYPE IS NULL OR ORS.ACD_TYPE <> 3);
243:
244: SELECT MAX(resource_seq_num)
245: INTO max_seq
246: FROM WIP_OPERATION_RESOURCES
247: WHERE organization_id = X_Organization_Id and
248: wip_entity_id = X_Wip_Entity_Id;
249:
250: INSERT INTO WIP_SUB_OPERATION_RESOURCES

Line 480: UPDATE WIP_OPERATION_RESOURCES

476: WHERE ORGANIZATION_ID = X_Organization_Id
477: AND WIP_ENTITY_ID = X_Wip_Entity_Id
478: AND NVL(REPETITIVE_SCHEDULE_ID, -1) = NVL(X_Repetitive_Schedule_ID, -1);
479:
480: UPDATE WIP_OPERATION_RESOURCES
481: SET START_DATE = X_Start,
482: COMPLETION_DATE = DECODE(X_load_type, WIP_CONSTANTS.RESCHED_EAM_JOB , x_comp, x_start) ,
483: LAST_UPDATED_BY = X_Last_Updated_By,
484: LAST_UPDATE_DATE = SYSDATE,