APPS.WSM_JOBCOPIES_PVT dependencies on WSM_COPY_OP_RESOURCE_INSTANCES

Line 1079: DELETE WSM_COPY_OP_RESOURCE_INSTANCES

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

Line 3937: DELETE WSM_COPY_OP_RESOURCE_INSTANCES

3933:
3934: DELETE WSM_COPY_OP_RESOURCES
3935: WHERE wip_entity_id = p_new_wip_entity_id;
3936:
3937: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
3938: WHERE wip_entity_id = p_new_wip_entity_id;
3939:
3940: DELETE WSM_COPY_OP_RESOURCE_USAGE
3941: WHERE wip_entity_id = p_new_wip_entity_id;

Line 4378: INSERT INTO WSM_COPY_OP_RESOURCE_INSTANCES

4374:
4375: /***** Make a copy of the Instances Resources for the job *****/
4376:
4377: l_stmt_num := 40;
4378: INSERT INTO WSM_COPY_OP_RESOURCE_INSTANCES
4379: (WIP_ENTITY_ID,
4380: OPERATION_SEQ_NUM,
4381: RESOURCE_SEQ_NUM,
4382: ORGANIZATION_ID,

Line 4409: FROM WSM_COPY_OP_RESOURCE_INSTANCES

4405: SERIAL_NUMBER,
4406: start_date, -- START_DATE
4407: completion_date, --COMPLETION_DATE
4408: BATCH_ID
4409: FROM WSM_COPY_OP_RESOURCE_INSTANCES
4410: WHERE wip_entity_id = p_rep_wip_entity_id;
4411:
4412: IF (g_debug = 'Y') THEN
4413: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCORI for we_id='||p_new_wip_entity_id);

Line 5078: DELETE WSM_COPY_OP_RESOURCE_INSTANCES

5074:
5075: DELETE WSM_COPY_OP_RESOURCES
5076: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5077:
5078: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
5079: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5080:
5081: DELETE WSM_COPY_OP_RESOURCE_USAGE
5082: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);