APPS.WIP_REPETITIVE_UTILITIES dependencies on WIP_OPERATION_RESOURCES

Line 432: INSERT INTO WIP_OPERATION_RESOURCES

428: WHERE ORGANIZATION_ID = p_org_id
429: AND WIP_ENTITY_ID = x_wip_id
430: AND REPETITIVE_SCHEDULE_ID = p_sched_id;
431:
432: INSERT INTO WIP_OPERATION_RESOURCES
433: (WIP_ENTITY_ID, OPERATION_SEQ_NUM,
434: RESOURCE_SEQ_NUM, ORGANIZATION_ID,
435: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
436: LAST_UPDATED_BY, CREATION_DATE,

Line 477: FROM WIP_OPERATION_RESOURCES R,

473: R.ATTRIBUTE8, R.ATTRIBUTE9,
474: R.ATTRIBUTE10, R.ATTRIBUTE11,
475: R.ATTRIBUTE12, R.ATTRIBUTE13,
476: R.ATTRIBUTE14, R.ATTRIBUTE15
477: FROM WIP_OPERATION_RESOURCES R,
478: WIP_OPERATIONS O
479: WHERE R.WIP_ENTITY_ID = x_wip_id
480: AND R.ORGANIZATION_ID = p_org_id
481: AND R.REPETITIVE_SCHEDULE_ID = p_sched_id

Line 487: UPDATE WIP_OPERATION_RESOURCES OPS

483: AND O.ORGANIZATION_ID = p_org_id
484: AND O.REPETITIVE_SCHEDULE_ID = p_new_sched_id
485: AND R.OPERATION_SEQ_NUM = O.OPERATION_SEQ_NUM;
486:
487: UPDATE WIP_OPERATION_RESOURCES OPS
488: SET COMPLETION_DATE =
489: (SELECT TO_DATE(TO_CHAR(CD2.CALENDAR_DATE, WIP_CONSTANTS.DATE_FMT) || ' ' ||
490: TO_CHAR(OPS.COMPLETION_DATE,
491: WIP_CONSTANTS.TIMESEC_FMT),