APPS.WMS_REPLENISHMENT_PVT dependencies on INV_QUANTITY_TREE_PUB

Line 891: inv_quantity_tree_pub.clear_quantity_cache;

887: ' Total Primary Dmd Qty :'||l_prim_repl_qty);
888: END IF ;
889:
890: --Query Quantity Tree
891: inv_quantity_tree_pub.clear_quantity_cache;
892:
893: -- Check value passed in this call to QTY Tree
894: inv_quantity_tree_pub.query_quantities
895: (

Line 894: inv_quantity_tree_pub.query_quantities

890: --Query Quantity Tree
891: inv_quantity_tree_pub.clear_quantity_cache;
892:
893: -- Check value passed in this call to QTY Tree
894: inv_quantity_tree_pub.query_quantities
895: (
896: p_api_version_number => 1.0
897: , p_init_msg_lst => fnd_api.g_false
898: , x_return_status => l_return_status

Line 903: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

899: , x_msg_count => l_msg_count
900: , x_msg_data => l_msg_data
901: , p_organization_id => L_ORG_ID
902: , p_inventory_item_id => L_item_id
903: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
904: , p_is_revision_control => l_is_revision_ctrl
905: , p_is_lot_control => l_is_lot_ctrl
906: , p_is_serial_control => l_is_serial_ctrl
907: , p_demand_source_type_id => -9999 --should not be null

Line 2797: inv_quantity_tree_pub.clear_quantity_cache;

2793: IF (l_debug = 1) THEN
2794: print_debug('Clearing Qty Tree' );
2795: END IF;
2796: --Query Quantity Tree
2797: inv_quantity_tree_pub.clear_quantity_cache;
2798:
2799: IF (l_debug = 1) THEN
2800: print_debug('Calling Qty Tree API' );
2801: END IF;

Line 2803: inv_quantity_tree_pub.query_quantities

2799: IF (l_debug = 1) THEN
2800: print_debug('Calling Qty Tree API' );
2801: END IF;
2802:
2803: inv_quantity_tree_pub.query_quantities
2804: (
2805: p_api_version_number => 1.0
2806: , p_init_msg_lst => fnd_api.g_false
2807: , x_return_status => l_return_status

Line 2812: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

2808: , x_msg_count => x_msg_count
2809: , x_msg_data => x_msg_data
2810: , p_organization_id => p_organization_id
2811: , p_inventory_item_id => p_inventory_item_id
2812: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
2813: , p_is_revision_control => l_is_revision_ctrl
2814: , p_is_lot_control => l_is_lot_ctrl
2815: , p_is_serial_control => l_is_serial_ctrl
2816: , p_demand_source_type_id => -9999 --should not be null

Line 5204: inv_quantity_tree_pub.clear_quantity_cache;

5200: IF (l_debug = 1) THEN
5201: print_debug('Clearing Qty Tree' );
5202: END IF;
5203: --Query Quantity Tree
5204: inv_quantity_tree_pub.clear_quantity_cache;
5205:
5206: IF (l_debug = 1) THEN
5207: print_debug('Calling Qty Tree API' );
5208: END IF;

Line 5210: inv_quantity_tree_pub.query_quantities

5206: IF (l_debug = 1) THEN
5207: print_debug('Calling Qty Tree API' );
5208: END IF;
5209:
5210: inv_quantity_tree_pub.query_quantities
5211: (
5212: p_api_version_number => 1.0
5213: , p_init_msg_lst => fnd_api.g_false
5214: , x_return_status => l_return_status

Line 5219: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

5215: , x_msg_count => x_msg_count
5216: , x_msg_data => x_msg_data
5217: , p_organization_id => x_consol_item_repl_tbl(i).organization_id
5218: , p_inventory_item_id => x_consol_item_repl_tbl(i).item_id
5219: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
5220: , p_is_revision_control => l_is_revision_ctrl
5221: , p_is_lot_control => l_is_lot_ctrl
5222: , p_is_serial_control => l_is_serial_ctrl
5223: , p_demand_source_type_id => l_demand_type_id -- 2 (OE) / 8 for Internal Order

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

5248:
5249: END IF; --For an Org+item+Sub combination
5250:
5251:
5252: -- In transaction_mode call to API inv_quantity_tree_pub.query_quantities pass parameters: item_id, demand header, demand line, subinventory
5253:
5254: --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.
5255:
5256: --(l_atr) will be available qty to reserve. It includes rsv_qty