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 1762: update wsm_copy_op_resources

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

Line 1784: update wsm_copy_op_resources

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