APPS.WIP_CPLPROC_PRIV dependencies on WIP_REQUIREMENT_OPERATIONS

Line 790: from wip_requirement_operations

786: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
787: --use the cursors only to lock the relavent wro rows
788: cursor c_repRows(v_schedID NUMBER) is
789: select required_quantity
790: from wip_requirement_operations
791: where repetitive_schedule_id = v_schedID
792: for update of required_quantity nowait;
793:
794: cursor c_discRows(v_wipEntityID NUMBER) is

Line 796: from wip_requirement_operations

792: for update of required_quantity nowait;
793:
794: cursor c_discRows(v_wipEntityID NUMBER) is
795: select required_quantity
796: from wip_requirement_operations
797: where wip_entity_id = v_wipEntityID
798: for update of required_quantity nowait;
799:
800: begin

Line 899: update wip_requirement_operations

895: --otherwise we just have to increase the component requirements in wro
896: else
897: if(p_cplRec.wipEntityType = wip_constants.repetitive) then
898: open c_repRows(v_schedID => l_lastSchedID);
899: update wip_requirement_operations
900: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)
901: where repetitive_schedule_id = l_lastSchedID;
902: close c_repRows;
903: else

Line 905: update wip_requirement_operations

901: where repetitive_schedule_id = l_lastSchedID;
902: close c_repRows;
903: else
904: open c_discRows(v_wipEntityID => p_cplRec.wipEntityID);
905: update wip_requirement_operations
906: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)
907: where wip_entity_id = p_cplRec.wipEntityID
908: AND nvl(basis_type,1) <> WIP_CONSTANTS.LOT_BASED_MTL; /* LBM Project */
909: close c_discRows;