APPS.WIP_CPLPROC_PRIV dependencies on WIP_REQUIREMENT_OPERATIONS

Line 764: from wip_requirement_operations

760: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
761: --use the cursors only to lock the relavent wro rows
762: cursor c_repRows(v_schedID NUMBER) is
763: select required_quantity
764: from wip_requirement_operations
765: where repetitive_schedule_id = v_schedID
766: for update of required_quantity nowait;
767:
768: cursor c_discRows(v_wipEntityID NUMBER) is

Line 770: from wip_requirement_operations

766: for update of required_quantity nowait;
767:
768: cursor c_discRows(v_wipEntityID NUMBER) is
769: select required_quantity
770: from wip_requirement_operations
771: where wip_entity_id = v_wipEntityID
772: for update of required_quantity nowait;
773:
774: begin

Line 873: update wip_requirement_operations

869: --otherwise we just have to increase the component requirements in wro
870: else
871: if(p_cplRec.wipEntityType = wip_constants.repetitive) then
872: open c_repRows(v_schedID => l_lastSchedID);
873: update wip_requirement_operations
874: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)
875: where repetitive_schedule_id = l_lastSchedID;
876: close c_repRows;
877: else

Line 879: update wip_requirement_operations

875: where repetitive_schedule_id = l_lastSchedID;
876: close c_repRows;
877: else
878: open c_discRows(v_wipEntityID => p_cplRec.wipEntityID);
879: update wip_requirement_operations
880: set required_quantity = round(required_quantity + p_cplRec.overCplPriQty * quantity_per_assembly, wip_constants.inv_max_precision)
881: where wip_entity_id = p_cplRec.wipEntityID
882: AND nvl(basis_type,1) <> WIP_CONSTANTS.LOT_BASED_MTL; /* LBM Project */
883: close c_discRows;