DBA Data[Home] [Help]

APPS.FII_AP_TRANS_BACKLOG_SUM_C dependencies on FND_PROFILE

Line 4: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('EDW_DEBUG'), 'N');

1: Package Body FII_AP_TRANS_BACKLOG_SUM_C AS
2: /* $Header: FIIAP13B.pls 120.1 2005/06/13 11:11:37 sgautam noship $ */
3:
4: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('EDW_DEBUG'), 'N');
5: g_fii_schema VARCHAR2(30);
6: g_tablespace VARCHAR2(30);
7:
8: g_errbuf VARCHAR2(2000) := NULL;

Line 116: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN

112: l_stmt := ' ALTER SESSION SET global_names = false';
113: EXECUTE IMMEDIATE l_stmt;
114:
115: -- DEBUG
116: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
117: edw_log.g_debug := TRUE;
118: END IF;
119:
120: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

Line 120: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

116: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
117: edw_log.g_debug := TRUE;
118: END IF;
119:
120: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
121: if l_dir is null then
122: l_dir:='/sqlcom/log';
123: end if;
124: