APPS.WSM_JOBCOPIES_PVT dependencies on WSM_COPY_OP_RESOURCES

Line 1077: DELETE WSM_COPY_OP_RESOURCES

1073:
1074: DELETE WSM_COPY_OP_NETWORKS
1075: WHERE wip_entity_id = p_wip_entity_id;
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;

Line 1869: INSERT INTO WSM_COPY_OP_RESOURCES

1865: v_job_nw.delete;
1866:
1867:
1868: -- ***** Make a copy of the primary Resources for the job ***** --
1869: INSERT INTO WSM_COPY_OP_RESOURCES
1870: (WIP_ENTITY_ID,
1871: OPERATION_SEQ_NUM,
1872: RESOURCE_SEQ_NUM,
1873: ORGANIZATION_ID,

Line 2012: from WSM_COPY_OP_RESOURCES wcor

2008:
2009:
2010: select OPERATION_SEQ_NUM,resource_seq_num
2011: bulk collect into v_op_seq_id,v_res_seq
2012: from WSM_COPY_OP_RESOURCES wcor
2013: where wcor.wip_entity_id = p_wip_entity_id;
2014:
2015: FOR i in 1..v_op_seq_id.count LOOP
2016:

Line 2030: INSERT INTO WSM_COPY_OP_RESOURCES

2026:
2027: l_stmt_num := 140;
2028:
2029: -- ***** Make a copy of the substitute Resources for the job ***** --
2030: INSERT INTO WSM_COPY_OP_RESOURCES
2031: (WIP_ENTITY_ID,
2032: OPERATION_SEQ_NUM,
2033: RESOURCE_SEQ_NUM,
2034: ORGANIZATION_ID,

Line 3622: FROM WSM_COPY_OP_RESOURCES

3618: l_stmt_num := 270;
3619:
3620: SELECT max(resource_seq_num)
3621: INTO l_curr_op_max_res_seq
3622: FROM WSM_COPY_OP_RESOURCES
3623: WHERE wip_entity_id = p_wip_entity_id
3624: AND organization_id = p_org_id
3625: AND operation_seq_num = l_curr_op_seq_num;
3626:

Line 3640: INSERT INTO WSM_COPY_OP_RESOURCES

3636:
3637: l_stmt_num := 290;
3638:
3639: -- insert phantom resources
3640: INSERT INTO WSM_COPY_OP_RESOURCES
3641: (WIP_ENTITY_ID,
3642: OPERATION_SEQ_NUM,
3643: RESOURCE_SEQ_NUM,
3644: ORGANIZATION_ID,

Line 4165: DELETE WSM_COPY_OP_RESOURCES

4161:
4162: DELETE WSM_COPY_OPERATIONS
4163: WHERE wip_entity_id = p_new_wip_entity_id;
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;

Line 4456: INSERT INTO WSM_COPY_OP_RESOURCES

4452: Firm End and Resource - Firm Resource
4453: Firm All - Firm Resource
4454: */
4455:
4456: INSERT INTO WSM_COPY_OP_RESOURCES
4457: (WIP_ENTITY_ID,
4458: OPERATION_SEQ_NUM,
4459: RESOURCE_SEQ_NUM,
4460: ORGANIZATION_ID,

Line 4595: FROM WSM_COPY_OP_RESOURCES

4591: ATTRIBUTE13,
4592: ATTRIBUTE14,
4593: ATTRIBUTE15,
4594: ORIGINAL_SYSTEM_REFERENCE
4595: FROM WSM_COPY_OP_RESOURCES
4596: WHERE wip_entity_id = p_rep_wip_entity_id;
4597:
4598:
4599:

Line 5306: DELETE WSM_COPY_OP_RESOURCES

5302:
5303: DELETE WSM_COPY_OP_NETWORKS
5304: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
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);

Line 5858: FROM WSM_COPY_OP_RESOURCES WCOR

5854: , WCOR.REPLACEMENT_GROUP_NUM
5855: , WCOR.PRINCIPLE_FLAG
5856: , WCOR.SETUP_ID
5857: , WCOR.DEPARTMENT_ID --Bug 4522620
5858: FROM WSM_COPY_OP_RESOURCES WCOR
5859: WHERE WCOR.WIP_ENTITY_ID = p_wip_entity_id
5860: AND WCOR.OPERATION_SEQ_NUM = l_curr_op_seq_num
5861: AND WCOR.recommended='Y';
5862:

Line 5955: FROM WSM_COPY_OP_RESOURCES WCOR

5951: WCOR.schedule_seq_num,
5952: WCOR.substitute_group_num,
5953: WCOR.replacement_group_num,
5954: WCOR.setup_id
5955: FROM WSM_COPY_OP_RESOURCES WCOR
5956: WHERE WCOR.WIP_ENTITY_ID = p_wip_entity_id
5957: AND WCOR.OPERATION_SEQ_NUM = l_curr_op_seq_num
5958: AND WCOR.PHANTOM_ITEM_ID IS NULL
5959: AND WCOR.recommended<>'Y';