APPS.FII_GL_JE_B_C dependencies on FND_PROFILE

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

26: g_fii_user_id NUMBER(15);
27: g_fii_login_id NUMBER(15);
28: g_truncate_stg BOOLEAN;
29: g_truncate_id BOOLEAN;
30: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
31: g_program_type VARCHAR2(1);
32: g_industry VARCHAR2(1) := NVL(FND_PROFILE.value('Industry'), 'C');
33: g_global_start_date DATE := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');
34:

Line 32: g_industry VARCHAR2(1) := NVL(FND_PROFILE.value('Industry'), 'C');

28: g_truncate_stg BOOLEAN;
29: g_truncate_id BOOLEAN;
30: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
31: g_program_type VARCHAR2(1);
32: g_industry VARCHAR2(1) := NVL(FND_PROFILE.value('Industry'), 'C');
33: g_global_start_date DATE := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');
34:
35: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second
36: INTERVAL CONSTANT NUMBER := 4; -- 4 days

Line 33: g_global_start_date DATE := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');

29: g_truncate_id BOOLEAN;
30: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
31: g_program_type VARCHAR2(1);
32: g_industry VARCHAR2(1) := NVL(FND_PROFILE.value('Industry'), 'C');
33: g_global_start_date DATE := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');
34:
35: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second
36: INTERVAL CONSTANT NUMBER := 4; -- 4 days
37: MAX_LOOP CONSTANT NUMBER := 180; -- 180 loops = 180 minutes

Line 3431: l_start_date := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');

3427: l_last_period_from,
3428: l_last_period_to);
3429:
3430: IF l_last_start_date IS NULL THEN
3431: l_start_date := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');
3432: ELSE
3433: -----------------------------------------------------------------------
3434: -- Bug fix 3021099: In this sql to find the earliest period we need to
3435: -- process for incremental, we will only look at periods that is on or

Line 3439: l_global_start_date := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');

3435: -- process for incremental, we will only look at periods that is on or
3436: -- after global start date. Thus we will not be processing extra periods
3437: -- which does not have data for us to process.
3438: -----------------------------------------------------------------------
3439: l_global_start_date := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');
3440:
3441: SELECT trunc(min(stu.start_date))
3442: INTO l_start_date
3443: FROM gl_period_statuses stu,