APPS.INV_TRX_RELIEF_C_PVT dependencies on FND_PROFILE

Line 8: --Bug 3559328: Performance bug fix. The fnd_profile.value call was put in

4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_TRX_RELIEF_C_PVT';
5: TYPE query_cur_ref_type IS REF CURSOR; --3347075
6: PROCEDURE debug_print(p_message IN VARCHAR2, p_level IN NUMBER := 9)
7: IS
8: --Bug 3559328: Performance bug fix. The fnd_profile.value call was put in
9: --debug_print. So, this gets called everytime we try to print to the debug
10: --file. Removing the call from here.
11: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12: BEGIN

Line 11: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

7: IS
8: --Bug 3559328: Performance bug fix. The fnd_profile.value call was put in
9: --debug_print. So, this gets called everytime we try to print to the debug
10: --file. Removing the call from here.
11: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12: BEGIN
13: -- IF (l_debug = 1) THEN
14: INV_LOG_UTIL.TRACE(p_message, 'INV_TRX_RELIEF_C_PVT', p_level);
15: -- END IF;

Line 113: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

109: AND p_dsrc_delivery IS NULL))))
110: AND (primary_reservation_quantity - NVL(detailed_quantity,0)) > 0
111: ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE; */
112: -- commented the above for bug 3347075
113: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
114: BEGIN
115: l_stmt := '1';
116: -- Begin changes for bug 3347075
117: l_miss_char := fnd_api.g_miss_char;

Line 967: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

963: AND p_dsrc_delivery IS NULL))))
964: AND (primary_reservation_quantity - NVL(detailed_quantity,0)) > 0
965: ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE; */
966: -- commented the above for bug 3347075
967: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
968: BEGIN
969: l_stmt := '1';
970: -- Begin changes for bug 3347075
971: l_miss_char := fnd_api.g_miss_char;