APPS.WMS_REPLENISHMENT_PVT dependencies on INV_QUANTITY_TREE_PUB

Line 882: inv_quantity_tree_pub.clear_quantity_cache;

878: ' Total Primary Dmd Qty :'||l_prim_repl_qty);
879: END IF ;
880:
881: --Query Quantity Tree
882: inv_quantity_tree_pub.clear_quantity_cache;
883:
884: -- Check value passed in this call to QTY Tree
885: inv_quantity_tree_pub.query_quantities
886: (

Line 885: inv_quantity_tree_pub.query_quantities

881: --Query Quantity Tree
882: inv_quantity_tree_pub.clear_quantity_cache;
883:
884: -- Check value passed in this call to QTY Tree
885: inv_quantity_tree_pub.query_quantities
886: (
887: p_api_version_number => 1.0
888: , p_init_msg_lst => fnd_api.g_false
889: , x_return_status => l_return_status

Line 894: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

890: , x_msg_count => l_msg_count
891: , x_msg_data => l_msg_data
892: , p_organization_id => L_ORG_ID
893: , p_inventory_item_id => L_item_id
894: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
895: , p_is_revision_control => l_is_revision_ctrl
896: , p_is_lot_control => l_is_lot_ctrl
897: , p_is_serial_control => l_is_serial_ctrl
898: , p_demand_source_type_id => -9999 --should not be null

Line 2711: inv_quantity_tree_pub.clear_quantity_cache;

2707: IF (l_debug = 1) THEN
2708: print_debug('Clearing Qty Tree' );
2709: END IF;
2710: --Query Quantity Tree
2711: inv_quantity_tree_pub.clear_quantity_cache;
2712:
2713: IF (l_debug = 1) THEN
2714: print_debug('Calling Qty Tree API' );
2715: END IF;

Line 2717: inv_quantity_tree_pub.query_quantities

2713: IF (l_debug = 1) THEN
2714: print_debug('Calling Qty Tree API' );
2715: END IF;
2716:
2717: inv_quantity_tree_pub.query_quantities
2718: (
2719: p_api_version_number => 1.0
2720: , p_init_msg_lst => fnd_api.g_false
2721: , x_return_status => l_return_status

Line 2726: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

2722: , x_msg_count => x_msg_count
2723: , x_msg_data => x_msg_data
2724: , p_organization_id => p_organization_id
2725: , p_inventory_item_id => p_inventory_item_id
2726: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
2727: , p_is_revision_control => l_is_revision_ctrl
2728: , p_is_lot_control => l_is_lot_ctrl
2729: , p_is_serial_control => l_is_serial_ctrl
2730: , p_demand_source_type_id => -9999 --should not be null

Line 5037: inv_quantity_tree_pub.clear_quantity_cache;

5033: IF (l_debug = 1) THEN
5034: print_debug('Clearing Qty Tree' );
5035: END IF;
5036: --Query Quantity Tree
5037: inv_quantity_tree_pub.clear_quantity_cache;
5038:
5039: IF (l_debug = 1) THEN
5040: print_debug('Calling Qty Tree API' );
5041: END IF;

Line 5043: inv_quantity_tree_pub.query_quantities

5039: IF (l_debug = 1) THEN
5040: print_debug('Calling Qty Tree API' );
5041: END IF;
5042:
5043: inv_quantity_tree_pub.query_quantities
5044: (
5045: p_api_version_number => 1.0
5046: , p_init_msg_lst => fnd_api.g_false
5047: , x_return_status => l_return_status

Line 5052: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

5048: , x_msg_count => x_msg_count
5049: , x_msg_data => x_msg_data
5050: , p_organization_id => x_consol_item_repl_tbl(i).organization_id
5051: , p_inventory_item_id => x_consol_item_repl_tbl(i).item_id
5052: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
5053: , p_is_revision_control => l_is_revision_ctrl
5054: , p_is_lot_control => l_is_lot_ctrl
5055: , p_is_serial_control => l_is_serial_ctrl
5056: , p_demand_source_type_id => l_demand_type_id -- 2 (OE) / 8 for Internal Order

Line 5085: -- In transaction_mode call to API inv_quantity_tree_pub.query_quantities pass parameters: item_id, demand header, demand line, subinventory

5081:
5082: END IF; --For an Org+item+Sub combination
5083:
5084:
5085: -- In transaction_mode call to API inv_quantity_tree_pub.query_quantities pass parameters: item_id, demand header, demand line, subinventory
5086:
5087: --For l_atr calculation for all high level reservations, qty_tree first consumes all available material from outside the current SUB then bite from the current sub if remaining any.
5088:
5089: --(l_atr) will be available qty to reserve. It includes rsv_qty