DBA Data[Home] [Help]

APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WSM_COPY_REQUIREMENT_OPS

Line 653: from wsm_copy_requirement_ops

649: for update nowait;
650:
651: cursor c_WCRO is
652: select 1
653: from wsm_copy_requirement_ops
654: where wip_entity_id = p_wipEntityID
655: and organization_id = p_orgID
656: for update nowait;
657:

Line 1686: update wsm_copy_requirement_ops

1682:
1683: l_stat_num := 100;
1684: --update mtl requirement dates WCRO
1685: forall i in l_cnt_wo+1..p_opTbl.count
1686: update wsm_copy_requirement_ops
1687: set reco_date_required = l_OpStartDate(i),
1688: ----standard who columns----
1689: last_update_date = l_sysdate,
1690: last_updated_by = l_userID,

Line 1706: update wsm_copy_requirement_ops

1702:
1703: --bug 6345672: begin
1704: l_stat_num := 105;
1705: if g_update_current_op and l_cnt_wo is not NULL and l_cnt_wo > 0 then --bug 6345672
1706: update wsm_copy_requirement_ops
1707: set reco_date_required = l_OpStartDate(l_cnt_wo),
1708: ----standard who columns----
1709: last_update_date = l_sysdate,
1710: last_updated_by = l_userID,