DBA Data[Home] [Help]

APPS.FII_INDEX_UTIL dependencies on FND_PROFILE

Line 6: l_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');

2: /* $Header: FIIIDUTB.pls 120.2.12000000.3 2007/04/26 08:42:05 dhmehra ship $ */
3:
4: procedure set_table_name( p_table_name IN VARCHAR2, p_owner VARCHAR2) IS
5:
6: l_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
7:
8: begin
9: IF p_table_name is NOT NULL THEN
10: g_tab_name := p_table_name;

Line 26: l_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');

22:
23: procedure drop_index(p_table_name VARCHAR2, p_owner VARCHAR2,
24: p_retcode in out NOCOPY Varchar2) is
25:
26: l_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
27:
28: var1 varchar2(2000) := NULL;
29: var2 varchar2(500) := NULL;
30: var3 varchar2(500) := NULL;

Line 255: l_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');

251:
252: procedure create_index(p_table_name VARCHAR2, p_owner VARCHAR2,
253: p_retcode in out NOCOPY Varchar2) is
254:
255: l_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
256: l_rows number:=0;
257: var2 varchar2(500) := NULL;
258: var5 varchar2(2000) := NULL;
259: