DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_PARAMETER_PVT

Line 2125: , wms_parameter_pvt.getflexdatatypecode(

2121: , wpb.column_name
2122: , wpb.expression
2123: , wpb.data_type_code
2124: , wdo.table_alias -- alias n.a. for multi object based parameters
2125: , wms_parameter_pvt.getflexdatatypecode(
2126: wpb.data_type_code
2127: , wpb.db_object_ref_type_code
2128: , wpb.parameter_type_code
2129: , wpb.flexfield_usage_code

Line 2186: ,nvl(WMS_Parameter_PVT.GetAvailableUnitCapacity

2182: ' and msi.ORGANIZATION_ID = mptdtv.FROM_ORGANIZATION_ID
2183: and msi.INVENTORY_ITEM_ID = mptdtv.inventory_item_id ';
2184: ELSE
2185: g_rule_select := 'NULL serial_number
2186: ,nvl(WMS_Parameter_PVT.GetAvailableUnitCapacity
2187: ( mptdtv.TO_ORGANIZATION_ID
2188: ,base.SUBINVENTORY_CODE
2189: ,base.LOCATOR_ID
2190: ,mil.LOCATION_MAXIMUM_UNITS

Line 8969: wms_parameter_pvt.clearcache;

8965: END IF;
8966:
8967: -- make sure, everything is clean
8968: freeglobals;
8969: wms_parameter_pvt.clearcache;
8970:
8971: g_trace_recs.DELETE;
8972: l_debug_on := isruledebugon(p_simulation_mode);
8973:

Line 12558: l_possible_quantity := wms_parameter_pvt.getavailableunitcapacity(

12554: log_statement(l_api_name, 'qty_function', 'qty function code: ' || l_quantity_function);
12555: END IF;
12556: -- IF l_consider_staging_capacity THEN --Added bug3237702 -- commented for bug 6369468
12557: IF l_quantity_function = 530003 THEN
12558: l_possible_quantity := wms_parameter_pvt.getavailableunitcapacity(
12559: p_organization_id => p_organization_id
12560: , p_subinventory_code => l_osubinventory_code
12561: , p_locator_id => l_olocator_id
12562: );

Line 12564: l_possible_quantity := wms_parameter_pvt.getavailablevolumecapacity(

12560: , p_subinventory_code => l_osubinventory_code
12561: , p_locator_id => l_olocator_id
12562: );
12563: ELSIF l_quantity_function = 530007 THEN
12564: l_possible_quantity := wms_parameter_pvt.getavailablevolumecapacity(
12565: p_organization_id => p_organization_id
12566: , p_subinventory_code => l_osubinventory_code
12567: , p_locator_id => l_olocator_id
12568: , p_inventory_item_id => p_inventory_item_id

Line 12576: l_possible_quantity := wms_parameter_pvt.getavailableweightcapacity(

12572: , p_transaction_uom => p_transaction_uom
12573: , p_base_uom => p_base_uom_code
12574: );
12575: ELSIF l_quantity_function = 530011 THEN
12576: l_possible_quantity := wms_parameter_pvt.getavailableweightcapacity(
12577: p_organization_id => p_organization_id
12578: , p_subinventory_code => l_osubinventory_code
12579: , p_locator_id => l_olocator_id
12580: , p_inventory_item_id => p_inventory_item_id

Line 12588: l_possible_quantity := wms_parameter_pvt.getminimumavailablevwcapacity(

12584: , p_transaction_uom => p_transaction_uom
12585: , p_base_uom => p_base_uom_code
12586: );
12587: ELSIF l_quantity_function = 530015 THEN
12588: l_possible_quantity := wms_parameter_pvt.getminimumavailablevwcapacity(
12589: p_organization_id => p_organization_id
12590: , p_subinventory_code => l_osubinventory_code
12591: , p_locator_id => l_olocator_id
12592: , p_inventory_item_id => p_inventory_item_id

Line 12602: l_possible_quantity := wms_parameter_pvt.getminimumavailableuvwcapacity(

12598: , p_transaction_uom => p_transaction_uom
12599: , p_base_uom => p_base_uom_code
12600: );
12601: ELSIF l_quantity_function = 530019 THEN
12602: l_possible_quantity := wms_parameter_pvt.getminimumavailableuvwcapacity(
12603: p_organization_id => p_organization_id
12604: , p_subinventory_code => l_osubinventory_code
12605: , p_locator_id => l_olocator_id
12606: , p_inventory_item_id => p_inventory_item_id

Line 14123: wms_parameter_pvt.ClearCache;

14119:
14120: --
14121: -- make sure, everything is clean
14122: FreeGlobals;
14123: wms_parameter_pvt.ClearCache;
14124: --
14125: g_trace_recs.DELETE;
14126: l_debug_on := IsRuleDebugOn(p_simulation_mode);
14127:

Line 18811: wms_parameter_pvt.clearcache;

18807: END IF;
18808:
18809: -- make sure, everything is clean
18810: freeglobals;
18811: wms_parameter_pvt.clearcache;
18812: --
18813: g_trace_recs.DELETE;
18814: l_debug_on := isruledebugon(p_simulation_mode);
18815: --query items table to see if item is serial controlled (picking) or if it