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 103: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

99: PROCEDURE release_locks IS
100: TYPE CHAR_TABLE is TABLE OF VARCHAR2(200);
101: table_handle CHAR_TABLE;
102: l_ret_status NUMBER;
103: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
104: BEGIN
105: IF (l_debug = 1 ) THEN /* Bug#5401181*/
106: inv_log_util.trace('Begin release locks.. ' , 'INV_TABLE_LOCK_PVT', 9);
107: END IF;

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

135: , p_commit IN NUMBER DEFAULT 0) IS
136: TYPE char_table IS TABLE OF VARCHAR2(200);
137: table_handle char_table;
138: l_ret_status NUMBER;
139: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
140: BEGIN
141: IF (l_debug = 1 ) THEN /* Bug#5401181*/
142: inv_log_util.TRACE('Begin release locks for header id.. ' || p_header_id, 'INV_TABLE_LOCK_PVT', 9);
143: END IF;