DBA Data[Home] [Help]

APPS.GME_RESERVATIONS_PVT dependencies on INV_QUANTITY_TREE_PUB

Line 23: Added call to procedure inv_quantity_tree_pub.clear_quantity_cache in the procedure

19: to assess the total unreserved quantity
20: Pawan kumar bug 5294184
21: add gme_common_pvt.g_rule_based_resv_horizon in auto_detail_batch
22: Swapna K bug: 6665408 28-DEC-2007
23: Added call to procedure inv_quantity_tree_pub.clear_quantity_cache in the procedure
24: auto_detail_line to clear the quantity cache and recreate it again
25:
26: S. Kommineni 11-Feb-2008 6778968
27: Added parameter value when calling build_and_create_transaction in procedure convert_dtl_reservation

Line 365: inv_quantity_tree_pub.clear_quantity_cache;

361: gme_debug.put_line ('Calling inv_reservation_pub.create_reservation');
362: END IF;
363:
364: -- Bug 9959125 - Clear tree so that multiple reservations can be created.
365: inv_quantity_tree_pub.clear_quantity_cache;
366:
367: -- nsinghi Bug5176319. Commented p_force_reservation_flag parameter. As per inv team, onhand could be -ve
368: -- before reservation, and hence this parameter should not be used.
369:

Line 2265: inv_quantity_tree_pub.clear_quantity_cache;

2261: END IF;
2262:
2263: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2264: -- Bug 12934259 - clear tree upon eror.
2265: inv_quantity_tree_pub.clear_quantity_cache;
2266:
2267: RAISE create_suggestions_err;
2268: END IF;
2269:

Line 2371: inv_quantity_tree_pub.clear_quantity_cache;

2367: IF l_return_status NOT IN
2368: (fnd_api.g_ret_sts_success, fnd_api.g_ret_sts_error) THEN
2369: x_return_status := l_return_status;
2370: -- Bug 12934259 - clear tree upon eror.
2371: inv_quantity_tree_pub.clear_quantity_cache;
2372: RAISE create_reservation_err;
2373: END IF;
2374: END IF; -- l_open_percent < 99.99
2375: END IF;

Line 2379: inv_quantity_tree_pub.clear_quantity_cache;

2375: END IF;
2376:
2377: /* bug: 6665408 Skommine Added call to clear_quantity_cache procedure
2378: to recreate the quantity tree after the reservations are done */
2379: inv_quantity_tree_pub.clear_quantity_cache;
2380:
2381:
2382: IF g_debug <= gme_debug.g_log_statement THEN
2383: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 2465: inv_quantity_tree_pub.clear_quantity_cache;

2461:
2462: END IF;
2463:
2464: -- bug 9852628 start
2465: inv_quantity_tree_pub.clear_quantity_cache;
2466:
2467: IF g_debug <= gme_debug.g_log_statement THEN
2468: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Acquiring locks on all the ingredients Qty tree before creating reservations ');
2469: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' This is required to resolve concurrency issues when the system is operating in multi user environment');