APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_QUANTITY_TREE_PUB

Line 1073: inv_quantity_tree_pub.clear_quantity_cache;

1069: IF (l_allocated_lpn_id IS NOT NULL ) THEN --9301174 added IF
1070: mdebug('l_allocated_lpn_id => '||l_allocated_lpn_id);
1071: -- calling query quantity tree API to get l_atr
1072: mdebug('calling quantity tree API');
1073: inv_quantity_tree_pub.clear_quantity_cache;
1074: /* Bug 7504490- Passing allocated_lpn_id to query_quantities to fetch the quantity to reserve
1075: for the LPN when the MMTT is for an allocated lpn */
1076: inv_quantity_tree_pub.query_quantities
1077: ( p_api_version_number => 1.0

Line 1076: inv_quantity_tree_pub.query_quantities

1072: mdebug('calling quantity tree API');
1073: inv_quantity_tree_pub.clear_quantity_cache;
1074: /* Bug 7504490- Passing allocated_lpn_id to query_quantities to fetch the quantity to reserve
1075: for the LPN when the MMTT is for an allocated lpn */
1076: inv_quantity_tree_pub.query_quantities
1077: ( p_api_version_number => 1.0
1078: , p_init_msg_lst => fnd_api.g_false
1079: , x_return_status => l_return_status
1080: , x_msg_count => l_msg_count

Line 1084: , p_tree_mode => INV_Quantity_Tree_PUB.g_reservation_mode

1080: , x_msg_count => l_msg_count
1081: , x_msg_data => l_msg_data
1082: , p_organization_id => l_organization_id
1083: , p_inventory_item_id => l_item_id
1084: , p_tree_mode => INV_Quantity_Tree_PUB.g_reservation_mode
1085: , p_is_revision_control => b_is_revision_control
1086: , p_is_lot_control => b_is_lot_control
1087: , p_is_serial_control => b_is_serial_control
1088: , p_grade_code => null

Line 1165: inv_quantity_tree_pub.clear_quantity_cache;

1161: mdebug(' l_atr is 0, no need to call create reservation API');
1162: END IF;
1163: ELSE --l_allocated_lpn_id is NULL --9301174 starts
1164: mdebug('l_allocated_lpn_id is null ');
1165: inv_quantity_tree_pub.clear_quantity_cache;
1166:
1167: OPEN C_DISTINCT_LOT_LPN_CUR(l_rsv_rec.lot_number);
1168: LOOP
1169: FETCH C_DISTINCT_LOT_LPN_CUR INTO l_rsv_rec.lpn_id;

Line 1176: inv_quantity_tree_pub.query_quantities

1172: l_rsv_rec.lpn_id :=NULL;
1173: END IF;
1174:
1175: mdebug('lpn_id :'||l_rsv_rec.lpn_id );
1176: inv_quantity_tree_pub.query_quantities
1177: ( p_api_version_number => 1.0
1178: , p_init_msg_lst => fnd_api.g_false
1179: , x_return_status => l_return_status
1180: , x_msg_count => l_msg_count

Line 1184: , p_tree_mode => INV_Quantity_Tree_PUB.g_reservation_mode

1180: , x_msg_count => l_msg_count
1181: , x_msg_data => l_msg_data
1182: , p_organization_id => l_organization_id
1183: , p_inventory_item_id => l_item_id
1184: , p_tree_mode => INV_Quantity_Tree_PUB.g_reservation_mode
1185: , p_is_revision_control => b_is_revision_control
1186: , p_is_lot_control => b_is_lot_control
1187: , p_is_serial_control => b_is_serial_control
1188: , p_grade_code => null

Line 1262: inv_quantity_tree_pub.clear_quantity_cache;

1258: END IF;
1259: ELSE
1260: mdebug(' l_atr is 0, no need to call create reservation API');
1261: END IF;
1262: inv_quantity_tree_pub.clear_quantity_cache;
1263: END LOOP;
1264: CLOSE C_DISTINCT_LOT_LPN_CUR;
1265: END IF; --allcoated_lpn --9301174 Ends
1266:

Line 1276: inv_quantity_tree_pub.clear_quantity_cache;

1272: IF l_allocated_lpn_id IS NOT NULL THEN
1273:
1274: mdebug('calling quantity tree API with lpn_id :'||l_allocated_lpn_id);
1275:
1276: inv_quantity_tree_pub.clear_quantity_cache;
1277:
1278: /* Bug 7504490- Passing allocated_lpn_id to query_quantities to fetch the quantity to reserve
1279: for the LPN when the MMTT is for an allocated lpn */
1280:

Line 1281: inv_quantity_tree_pub.query_quantities

1277:
1278: /* Bug 7504490- Passing allocated_lpn_id to query_quantities to fetch the quantity to reserve
1279: for the LPN when the MMTT is for an allocated lpn */
1280:
1281: inv_quantity_tree_pub.query_quantities
1282: ( p_api_version_number => 1.0
1283: , p_init_msg_lst => fnd_api.g_false
1284: , x_return_status => l_return_status
1285: , x_msg_count => l_msg_count

Line 1289: , p_tree_mode => INV_Quantity_Tree_PUB.g_reservation_mode

1285: , x_msg_count => l_msg_count
1286: , x_msg_data => l_msg_data
1287: , p_organization_id => l_organization_id
1288: , p_inventory_item_id => l_item_id
1289: , p_tree_mode => INV_Quantity_Tree_PUB.g_reservation_mode
1290: , p_is_revision_control => b_is_revision_control
1291: , p_is_lot_control => b_is_lot_control
1292: , p_is_serial_control => b_is_serial_control
1293: , p_grade_code => null

Line 1383: inv_quantity_tree_pub.clear_quantity_cache;

1379: END IF;
1380:
1381: mdebug('calling quantity tree API with lpn_id :'||l_rsv_rec.lpn_id);
1382:
1383: inv_quantity_tree_pub.clear_quantity_cache;
1384:
1385: inv_quantity_tree_pub.query_quantities
1386: ( p_api_version_number => 1.0
1387: , p_init_msg_lst => fnd_api.g_false

Line 1385: inv_quantity_tree_pub.query_quantities

1381: mdebug('calling quantity tree API with lpn_id :'||l_rsv_rec.lpn_id);
1382:
1383: inv_quantity_tree_pub.clear_quantity_cache;
1384:
1385: inv_quantity_tree_pub.query_quantities
1386: ( p_api_version_number => 1.0
1387: , p_init_msg_lst => fnd_api.g_false
1388: , x_return_status => l_return_status
1389: , x_msg_count => l_msg_count

Line 1393: , p_tree_mode => INV_Quantity_Tree_PUB.g_reservation_mode

1389: , x_msg_count => l_msg_count
1390: , x_msg_data => l_msg_data
1391: , p_organization_id => l_organization_id
1392: , p_inventory_item_id => l_item_id
1393: , p_tree_mode => INV_Quantity_Tree_PUB.g_reservation_mode
1394: , p_is_revision_control => b_is_revision_control
1395: , p_is_lot_control => b_is_lot_control
1396: , p_is_serial_control => b_is_serial_control
1397: , p_grade_code => null

Line 1478: inv_quantity_tree_pub.clear_quantity_cache; --16070349 raminoch

1474: END LOOP; --8267628 Looping for distinct LPNs
1475: CLOSE c_distinct_lpn;
1476: END IF; --allocated lpn
1477: END IF; --Lot control
1478: inv_quantity_tree_pub.clear_quantity_cache; --16070349 raminoch
1479:
1480: --Bug3633573 following deletion not required for mtlt
1481:
1482: --if l_lot_control_code = 2 then