APPS.WMS_RULE_PVT dependencies on WMS_PARAMETER_PVT

Line 2038: , wms_parameter_pvt.getflexdatatypecode(

2034: , wpb.column_name
2035: , wpb.expression
2036: , wpb.data_type_code
2037: , wdo.table_alias -- alias n.a. for multi object based parameters
2038: , wms_parameter_pvt.getflexdatatypecode(
2039: wpb.data_type_code
2040: , wpb.db_object_ref_type_code
2041: , wpb.parameter_type_code
2042: , wpb.flexfield_usage_code

Line 2097: ,nvl(WMS_Parameter_PVT.GetAvailableUnitCapacity

2093: ' and msi.ORGANIZATION_ID = mptdtv.FROM_ORGANIZATION_ID
2094: and msi.INVENTORY_ITEM_ID = mptdtv.inventory_item_id ';
2095: ELSE
2096: g_rule_select := 'NULL serial_number
2097: ,nvl(WMS_Parameter_PVT.GetAvailableUnitCapacity
2098: ( mptdtv.TO_ORGANIZATION_ID
2099: ,base.SUBINVENTORY_CODE
2100: ,base.LOCATOR_ID
2101: ,mil.LOCATION_MAXIMUM_UNITS

Line 7033: wms_parameter_pvt.clearcache;

7029: END IF;
7030:
7031: -- make sure, everything is clean
7032: freeglobals;
7033: wms_parameter_pvt.clearcache;
7034: --log_statement(l_api_name, 'apply', 'all cache cleared ');
7035: --
7036: g_trace_recs.DELETE;
7037: l_debug_on := isruledebugon(p_simulation_mode);

Line 10076: l_possible_quantity := wms_parameter_pvt.getavailableunitcapacity(

10072: log_statement(l_api_name, 'qty_function', 'qty function code: ' || l_quantity_function);
10073: END IF;
10074: IF l_consider_staging_capacity THEN --Added bug3237702
10075: IF l_quantity_function = 530003 THEN
10076: l_possible_quantity := wms_parameter_pvt.getavailableunitcapacity(
10077: p_organization_id => p_organization_id
10078: , p_subinventory_code => l_osubinventory_code
10079: , p_locator_id => l_olocator_id
10080: );

Line 10082: l_possible_quantity := wms_parameter_pvt.getavailablevolumecapacity(

10078: , p_subinventory_code => l_osubinventory_code
10079: , p_locator_id => l_olocator_id
10080: );
10081: ELSIF l_quantity_function = 530007 THEN
10082: l_possible_quantity := wms_parameter_pvt.getavailablevolumecapacity(
10083: p_organization_id => p_organization_id
10084: , p_subinventory_code => l_osubinventory_code
10085: , p_locator_id => l_olocator_id
10086: , p_inventory_item_id => p_inventory_item_id

Line 10094: l_possible_quantity := wms_parameter_pvt.getavailableweightcapacity(

10090: , p_transaction_uom => p_transaction_uom
10091: , p_base_uom => p_base_uom_code
10092: );
10093: ELSIF l_quantity_function = 530011 THEN
10094: l_possible_quantity := wms_parameter_pvt.getavailableweightcapacity(
10095: p_organization_id => p_organization_id
10096: , p_subinventory_code => l_osubinventory_code
10097: , p_locator_id => l_olocator_id
10098: , p_inventory_item_id => p_inventory_item_id

Line 10106: l_possible_quantity := wms_parameter_pvt.getminimumavailablevwcapacity(

10102: , p_transaction_uom => p_transaction_uom
10103: , p_base_uom => p_base_uom_code
10104: );
10105: ELSIF l_quantity_function = 530015 THEN
10106: l_possible_quantity := wms_parameter_pvt.getminimumavailablevwcapacity(
10107: p_organization_id => p_organization_id
10108: , p_subinventory_code => l_osubinventory_code
10109: , p_locator_id => l_olocator_id
10110: , p_inventory_item_id => p_inventory_item_id

Line 10120: l_possible_quantity := wms_parameter_pvt.getminimumavailableuvwcapacity(

10116: , p_transaction_uom => p_transaction_uom
10117: , p_base_uom => p_base_uom_code
10118: );
10119: ELSIF l_quantity_function = 530019 THEN
10120: l_possible_quantity := wms_parameter_pvt.getminimumavailableuvwcapacity(
10121: p_organization_id => p_organization_id
10122: , p_subinventory_code => l_osubinventory_code
10123: , p_locator_id => l_olocator_id
10124: , p_inventory_item_id => p_inventory_item_id

Line 11539: wms_parameter_pvt.ClearCache;

11535:
11536: --
11537: -- make sure, everything is clean
11538: FreeGlobals;
11539: wms_parameter_pvt.ClearCache;
11540: --
11541: g_trace_recs.DELETE;
11542: l_debug_on := IsRuleDebugOn(p_simulation_mode);
11543:

Line 16170: wms_parameter_pvt.clearcache;

16166: END IF;
16167:
16168: -- make sure, everything is clean
16169: freeglobals;
16170: wms_parameter_pvt.clearcache;
16171: --
16172: g_trace_recs.DELETE;
16173: l_debug_on := isruledebugon(p_simulation_mode);
16174: --query items table to see if item is serial controlled (picking) or if it