APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WSM_COPY_OP_RESOURCE_INSTANCES

Line 667: from wsm_copy_op_resource_instances

663: for update nowait;
664:
665: cursor c_WCORI is
666: select 1
667: from wsm_copy_op_resource_instances
668: where wip_entity_id = p_wipEntityID
669: and organization_id = p_orgID
670: for update nowait;
671:

Line 1831: update wsm_copy_op_resource_instances

1827:
1828: l_stat_num := 140;
1829: --update resources instances (WCORI)
1830: forall i in l_cnt_wor+1..x_resTbls.resID.count
1831: update wsm_copy_op_resource_instances
1832: set start_date = x_resTbls.startDate(i),
1833: completion_date = x_resTbls.endDate(i),
1834: ----standard who columns----
1835: last_update_date = l_sysdate,

Line 1849: update wsm_copy_op_resource_instances

1845:
1846: --bug 6345672: begin
1847: l_stat_num := 145;
1848: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672/bug 7163667
1849: update wsm_copy_op_resource_instances
1850: set start_date = x_resTbls.startDate(l_cnt_wor),
1851: completion_date = x_resTbls.endDate(l_cnt_wor),
1852: ----standard who columns----
1853: last_update_date = l_sysdate,

Line 2139: wsm_copy_op_resource_instances wcori

2135: l_progApplID,
2136: l_progID,
2137: l_sysdate
2138: from wsm_copy_op_resource_usage wcoru,
2139: wsm_copy_op_resource_instances wcori
2140: where wcoru.wip_entity_id = wcori.wip_entity_id
2141: and wcoru.operation_seq_num = wcori.operation_seq_num
2142: and wcoru.resource_seq_num = wcori.resource_seq_num
2143: and wcoru.organization_id = wcori.organization_id

Line 2196: wsm_copy_op_resource_instances wcori

2192: l_progApplID,
2193: l_progID,
2194: l_sysdate
2195: from wsm_copy_op_resource_usage wcoru,
2196: wsm_copy_op_resource_instances wcori
2197: where wcoru.wip_entity_id = wcori.wip_entity_id
2198: and wcoru.operation_seq_num = wcori.operation_seq_num
2199: and wcoru.resource_seq_num = wcori.resource_seq_num
2200: and wcoru.organization_id = wcori.organization_id