APPS.WSM_JOBCOPIES_PVT dependencies on WSM_COPY_OP_RESOURCES

Line 1076: DELETE WSM_COPY_OP_RESOURCES

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

Line 1639: INSERT INTO WSM_COPY_OP_RESOURCES

1635: v_job_nw.delete;
1636:
1637:
1638: -- ***** Make a copy of the primary Resources for the job ***** --
1639: INSERT INTO WSM_COPY_OP_RESOURCES
1640: (WIP_ENTITY_ID,
1641: OPERATION_SEQ_NUM,
1642: RESOURCE_SEQ_NUM,
1643: ORGANIZATION_ID,

Line 1782: from WSM_COPY_OP_RESOURCES wcor

1778:
1779:
1780: select OPERATION_SEQ_NUM,resource_seq_num
1781: bulk collect into v_op_seq_id,v_res_seq
1782: from WSM_COPY_OP_RESOURCES wcor
1783: where wcor.wip_entity_id = p_wip_entity_id;
1784:
1785: FOR i in 1..v_op_seq_id.count LOOP
1786:

Line 1800: INSERT INTO WSM_COPY_OP_RESOURCES

1796:
1797: l_stmt_num := 140;
1798:
1799: -- ***** Make a copy of the substitute Resources for the job ***** --
1800: INSERT INTO WSM_COPY_OP_RESOURCES
1801: (WIP_ENTITY_ID,
1802: OPERATION_SEQ_NUM,
1803: RESOURCE_SEQ_NUM,
1804: ORGANIZATION_ID,

Line 3391: FROM WSM_COPY_OP_RESOURCES

3387: l_stmt_num := 270;
3388:
3389: SELECT max(resource_seq_num)
3390: INTO l_curr_op_max_res_seq
3391: FROM WSM_COPY_OP_RESOURCES
3392: WHERE wip_entity_id = p_wip_entity_id
3393: AND organization_id = p_org_id
3394: AND operation_seq_num = l_curr_op_seq_num;
3395:

Line 3409: INSERT INTO WSM_COPY_OP_RESOURCES

3405:
3406: l_stmt_num := 290;
3407:
3408: -- insert phantom resources
3409: INSERT INTO WSM_COPY_OP_RESOURCES
3410: (WIP_ENTITY_ID,
3411: OPERATION_SEQ_NUM,
3412: RESOURCE_SEQ_NUM,
3413: ORGANIZATION_ID,

Line 3934: DELETE WSM_COPY_OP_RESOURCES

3930:
3931: DELETE WSM_COPY_OPERATIONS
3932: WHERE wip_entity_id = p_new_wip_entity_id;
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;

Line 4225: INSERT INTO WSM_COPY_OP_RESOURCES

4221: Firm End and Resource - Firm Resource
4222: Firm All - Firm Resource
4223: */
4224:
4225: INSERT INTO WSM_COPY_OP_RESOURCES
4226: (WIP_ENTITY_ID,
4227: OPERATION_SEQ_NUM,
4228: RESOURCE_SEQ_NUM,
4229: ORGANIZATION_ID,

Line 4364: FROM WSM_COPY_OP_RESOURCES

4360: ATTRIBUTE13,
4361: ATTRIBUTE14,
4362: ATTRIBUTE15,
4363: ORIGINAL_SYSTEM_REFERENCE
4364: FROM WSM_COPY_OP_RESOURCES
4365: WHERE wip_entity_id = p_rep_wip_entity_id;
4366:
4367:
4368:

Line 5075: DELETE WSM_COPY_OP_RESOURCES

5071:
5072: DELETE WSM_COPY_OP_NETWORKS
5073: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
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);

Line 5627: FROM WSM_COPY_OP_RESOURCES WCOR

5623: , WCOR.REPLACEMENT_GROUP_NUM
5624: , WCOR.PRINCIPLE_FLAG
5625: , WCOR.SETUP_ID
5626: , WCOR.DEPARTMENT_ID --Bug 4522620
5627: FROM WSM_COPY_OP_RESOURCES WCOR
5628: WHERE WCOR.WIP_ENTITY_ID = p_wip_entity_id
5629: AND WCOR.OPERATION_SEQ_NUM = l_curr_op_seq_num
5630: AND WCOR.recommended='Y';
5631:

Line 5724: FROM WSM_COPY_OP_RESOURCES WCOR

5720: WCOR.schedule_seq_num,
5721: WCOR.substitute_group_num,
5722: WCOR.replacement_group_num,
5723: WCOR.setup_id
5724: FROM WSM_COPY_OP_RESOURCES WCOR
5725: WHERE WCOR.WIP_ENTITY_ID = p_wip_entity_id
5726: AND WCOR.OPERATION_SEQ_NUM = l_curr_op_seq_num
5727: AND WCOR.PHANTOM_ITEM_ID IS NULL
5728: AND WCOR.recommended<>'Y';