APPS.INV_LOT_SEL_ATTR dependencies on FND_PROFILE

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

11: p_module IN VARCHAR2,
12: p_level IN NUMBER
13: ) IS
14:
15: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
16:
17: BEGIN
18:
19: IF NOT g_version_printed THEN

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

49: p_lot_serial_number IN VARCHAR2 ) IS
50:
51: i NUMBER;
52: l_context_column_name VARCHAR2(12);
53: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
54: l_module_name VARCHAR2(30) := 'GET_CONTEXT_CODE';
55: BEGIN
56: context_value := NULL;
57: l_context_column_name := 'ITEM';

Line 185: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

181: p_lot_serial IN VARCHAR2,
182: flex_name IN VARCHAR2
183: ) IS
184:
185: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
186:
187: l_module_name VARCHAR2(30) := 'GET_LOT_SERIAL_CONTEXT';
188: l_progress_indicator VARCHAR2(10) := '0';
189:

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

280:
281: l_retVarchar VARCHAR2(15) := 'VARCHAR2';
282: l_retDate VARCHAR2(15) := 'DATE';
283: l_retNumber VARcHAR2(15) := 'NUMBER';
284: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
285: BEGIN
286: if( upper(p_table_name) = 'MTL_LOT_NUMBERS' ) then
287: if( upper(p_column_name ) = 'VENDOR_ID') then
288: x_column_type := l_retNumber;

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

412: v_value VARCHAR2(200);
413: v_a_name VARCHAR2(50);
414: l_context_column_name VARCHAR2(240); --bug 2474713
415: l_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE; --bug#2474713
416: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
417:
418: TYPE t_genref is REF CURSOR;
419: default_value_csr t_genref;
420: l_default_date_value DATE;

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

804: i BINARY_INTEGER;
805: j BINARY_INTEGER;
806:
807: v_is_enabled NUMBER := 0;
808: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
809: BEGIN
810:
811: v_is_enabled :=0;
812:

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

895: i BINARY_INTEGER;
896: j BINARY_INTEGER;
897:
898: v_is_enabled NUMBER := 0;
899: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
900: BEGIN
901:
902: v_is_enabled :=0;
903:

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

1024: l_column_idx BINARY_INTEGER;
1025: l_default_format VARCHAR2(30) := 'YYYY/MM/DD HH24:MI:SS';
1026: l_date DATE;
1027: l_get_default BOOLEAN DEFAULT FALSE; -- true if we are to get the default values for the attributes
1028: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1029: l_ret boolean;
1030:
1031: cursor column_csr(p_table_name VARCHAR2, p_owner VARCHAR2) is
1032: /* bug 15933838 */

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

1509: x_context OUT NOCOPY t_genref,
1510: p_application_id IN NUMBER,
1511: p_flex_name IN VARCHAR2) IS
1512:
1513: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1514: BEGIN
1515: OPEN x_context FOR
1516: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
1517: global_flag, enabled_flag

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

1525: x_segment OUT NOCOPY t_genref,
1526: p_application_id IN NUMBER,
1527: p_flex_name IN VARCHAR2,
1528: p_flex_context_code IN VARCHAR2) IS
1529: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1530: BEGIN
1531: OPEN x_segment FOR
1532: SELECT end_user_column_name, application_column_name, enabled_flag,
1533: required_flag, default_type, default_value