APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WSM_COPY_OP_RESOURCES

Line 646: from wsm_copy_op_resources

642: for update nowait;
643:
644: cursor c_WCOR is
645: select 1
646: from wsm_copy_op_resources
647: where wip_entity_id = p_wipEntityID
648: and organization_id = p_orgID
649: for update nowait;
650:

Line 759: wsm_copy_op_resources wcor,

755: wcor.basis_type,
756: wcor.assigned_units
757: from wip_discrete_jobs wdj,
758: wsm_copy_operations wco,
759: wsm_copy_op_resources wcor,
760: mtl_uom_conversions muc,
761: bom_department_resources bdr
762: where wdj.wip_entity_id = p_wipEntityID
763: and wdj.organization_id = p_orgID

Line 1071: from WSM_COPY_OP_RESOURCES

1067: select substitute_group_num,
1068: replacement_group_num
1069: into l_sub_grp_num,
1070: l_rpl_grp_num
1071: from WSM_COPY_OP_RESOURCES
1072: where wip_entity_id = p_wipEntityID
1073: and operation_seq_num = p_opSeqNum
1074: and resource_seq_num = p_resSeqNum;
1075: else

Line 1765: update wsm_copy_op_resources

1761:
1762: l_stat_num := 120;
1763: --update resources (WCOR)
1764: forall i in l_cnt_wor+1..x_resTbls.resID.count
1765: update wsm_copy_op_resources
1766: set reco_start_date = x_resTbls.startDate(i),
1767: reco_completion_date = x_resTbls.endDate(i),
1768: ----standard who columns----
1769: last_update_date = l_sysdate,

Line 1787: update wsm_copy_op_resources

1783:
1784: --bug 6345672: begin
1785: l_stat_num := 125;
1786: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672/bug 7163667
1787: update wsm_copy_op_resources
1788: set reco_start_date = x_resTbls.startDate(l_cnt_wor),
1789: reco_completion_date = x_resTbls.endDate(l_cnt_wor),
1790: ----standard who columns----
1791: last_update_date = l_sysdate,