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 1828: update wsm_copy_op_resource_instances

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

Line 1846: update wsm_copy_op_resource_instances

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

Line 2136: wsm_copy_op_resource_instances wcori

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

Line 2193: wsm_copy_op_resource_instances wcori

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