APPS.INV_TABLE_LOCK_PVT dependencies on FND_PROFILE

Line 18: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

14: l_lock_name VARCHAR2(2000);
15: l_status NUMBER;
16: l_neg_exists NUMBER;
17: l_sessionid NUMBER;
18: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
19: BEGIN
20: l_status := 9;
21: l_lock_name := 'INV_MOQ_' || p_organization_id || '_' ||
22: p_inventory_item_id || '_' ||

Line 138: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

134: PROCEDURE release_locks IS
135: TYPE CHAR_TABLE is TABLE OF VARCHAR2(200);
136: table_handle CHAR_TABLE;
137: l_ret_status NUMBER;
138: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
139: BEGIN
140: IF (l_debug = 1 ) THEN /* Bug#5401181*/
141: inv_log_util.trace('Begin release locks.. ' , 'INV_TABLE_LOCK_PVT', 9);
142: END IF;

Line 174: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

170: , p_commit IN NUMBER DEFAULT 0) IS
171: TYPE char_table IS TABLE OF VARCHAR2(200);
172: table_handle char_table;
173: l_ret_status NUMBER;
174: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
175: BEGIN
176: IF (l_debug = 1 ) THEN /* Bug#5401181*/
177: inv_log_util.TRACE('Begin release locks for header id.. ' || p_header_id, 'INV_TABLE_LOCK_PVT', 9);
178: END IF;