APPS.FII_SNAP_TBL_REFRESH dependencies on FND_PROFILE

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

1: PACKAGE BODY FII_SNAP_TBL_REFRESH AS
2: /*$Header: FIISNPRB.pls 120.5 2006/06/02 00:17:15 hlchen noship $*/
3:
4: g_phase VARCHAR2(80);
5: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
6: g_retcode VARCHAR2(20) := NULL;
7: g_fii_user_id NUMBER;
8: g_fii_login_id NUMBER;
9: g_fii_sysdate DATE;

Line 16: g_test_sysdate DATE := to_date(FND_PROFILE.value('FII_TEST_SYSDATE'), 'DD/MM/YYYY');

12: G_LOGIN_INFO_NOT_AVABLE EXCEPTION;
13:
14: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
15: --to reset different sysdate so that we can test for snapshot tables.
16: g_test_sysdate DATE := to_date(FND_PROFILE.value('FII_TEST_SYSDATE'), 'DD/MM/YYYY');
17:
18: ----------------------------------------------------
19: -- PROCEDURE Initialize (private)
20: --

Line 36: l_dir := fnd_profile.value('BIS_DEBUG_LOG_DIRECTORY');

32: ----------------------------------------------
33: -- Do set up for log file
34: ----------------------------------------------
35:
36: l_dir := fnd_profile.value('BIS_DEBUG_LOG_DIRECTORY');
37: ------------------------------------------------------
38: -- Set default directory in CASE if the profile option
39: -- BIS_DEBUG_LOG_DIRECTORY is not set up
40: ------------------------------------------------------

Line 120: l_industry_pf := FND_PROFILE.value('INDUSTRY');

116: END IF;
117:
118: -- Find out if this is commercial or government install
119: g_phase := 'Find out if this is commercial or government install';
120: l_industry_pf := FND_PROFILE.value('INDUSTRY');
121:
122: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';
123:
124: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")

Line 1131: l_profile := NVL(FND_PROFILE.VALUE('INDUSTRY'),'C');

1127: IF g_debug_flag = 'Y' THEN
1128: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_LOCAL_SNAP_F');
1129: END IF;
1130:
1131: l_profile := NVL(FND_PROFILE.VALUE('INDUSTRY'),'C');
1132:
1133: /* The code to populate different types of budgets should ONLY run when industry profile is set to Government. Consequently,
1134: if profile set to Government, we execute IF part otherwise, we execute ELSE part */
1135: