APPS.WSM_JOBCOPIES_PVT dependencies on WSM_COPY_OP_RESOURCE_INSTANCES

Line 1080: DELETE WSM_COPY_OP_RESOURCE_INSTANCES

1076:
1077: DELETE WSM_COPY_OP_RESOURCES
1078: WHERE wip_entity_id = p_wip_entity_id;
1079:
1080: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
1081: WHERE wip_entity_id = p_wip_entity_id;
1082:
1083: DELETE WSM_COPY_OP_RESOURCE_USAGE
1084: WHERE wip_entity_id = p_wip_entity_id;

Line 4168: DELETE WSM_COPY_OP_RESOURCE_INSTANCES

4164:
4165: DELETE WSM_COPY_OP_RESOURCES
4166: WHERE wip_entity_id = p_new_wip_entity_id;
4167:
4168: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
4169: WHERE wip_entity_id = p_new_wip_entity_id;
4170:
4171: DELETE WSM_COPY_OP_RESOURCE_USAGE
4172: WHERE wip_entity_id = p_new_wip_entity_id;

Line 4609: INSERT INTO WSM_COPY_OP_RESOURCE_INSTANCES

4605:
4606: /***** Make a copy of the Instances Resources for the job *****/
4607:
4608: l_stmt_num := 40;
4609: INSERT INTO WSM_COPY_OP_RESOURCE_INSTANCES
4610: (WIP_ENTITY_ID,
4611: OPERATION_SEQ_NUM,
4612: RESOURCE_SEQ_NUM,
4613: ORGANIZATION_ID,

Line 4640: FROM WSM_COPY_OP_RESOURCE_INSTANCES

4636: SERIAL_NUMBER,
4637: start_date, -- START_DATE
4638: completion_date, --COMPLETION_DATE
4639: BATCH_ID
4640: FROM WSM_COPY_OP_RESOURCE_INSTANCES
4641: WHERE wip_entity_id = p_rep_wip_entity_id;
4642:
4643: IF (g_debug = 'Y') THEN
4644: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCORI for we_id='||p_new_wip_entity_id);

Line 5309: DELETE WSM_COPY_OP_RESOURCE_INSTANCES

5305:
5306: DELETE WSM_COPY_OP_RESOURCES
5307: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5308:
5309: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
5310: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5311:
5312: DELETE WSM_COPY_OP_RESOURCE_USAGE
5313: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);