APPS.FII_AR_FACTS_AGING_PKG dependencies on FND_PROFILE

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

12: g_prim_rate_type VARCHAR2(30);
13: g_sec_rate_type VARCHAR2(30);
14: g_state VARCHAR2(200);
15: g_global_start_date DATE;
16: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
17: g_collection_criteria VARCHAR2(2) := NVL(FND_PROFILE.value('FII_AR_COLLECTION_CRITERIA'), 'TR');
18: g_primary_mau NUMBER;
19: g_secondary_mau NUMBER;
20: g_fii_user_id NUMBER(15);

Line 17: g_collection_criteria VARCHAR2(2) := NVL(FND_PROFILE.value('FII_AR_COLLECTION_CRITERIA'), 'TR');

13: g_sec_rate_type VARCHAR2(30);
14: g_state VARCHAR2(200);
15: g_global_start_date DATE;
16: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
17: g_collection_criteria VARCHAR2(2) := NVL(FND_PROFILE.value('FII_AR_COLLECTION_CRITERIA'), 'TR');
18: g_primary_mau NUMBER;
19: g_secondary_mau NUMBER;
20: g_fii_user_id NUMBER(15);
21: g_fii_login_id NUMBER(15);

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

448: if g_debug_flag = 'Y' then
449: FII_UTIL.put_line('Initializing the Global Start Date');
450: end if;
451:
452: g_global_start_date := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');
453:
454: if g_debug_flag = 'Y' then
455: FII_UTIL.put_line('g_global_start_date = '||g_global_start_date);
456: end if;

Line 3930: l_class_category VARCHAR2(30) := NVL(fnd_profile.value('BIS_CUST_CLASS_TYPE'),'-1');

3926:
3927:
3928: PROCEDURE POPULATE_HELPER_TABLES IS
3929:
3930: l_class_category VARCHAR2(30) := NVL(fnd_profile.value('BIS_CUST_CLASS_TYPE'),'-1');
3931: l_unassigned_message VARCHAR2(30) := FND_MESSAGE.get_string('BIS', 'EDW_UNASSIGNED');
3932:
3933: BEGIN
3934:

Line 4098: SET class_category = nvl(fnd_profile.value('BIS_CUST_CLASS_TYPE'),-1),

4094: FII_UTIL.put_line('-------------------------------------------------');
4095: end if;
4096:
4097: UPDATE FII_AR_SETUP
4098: SET class_category = nvl(fnd_profile.value('BIS_CUST_CLASS_TYPE'),-1),
4099: LAST_UPDATE_DATE = sysdate,
4100: LAST_UPDATED_BY = g_fii_user_id,
4101: LAST_UPDATE_LOGIN = g_fii_login_id;
4102:

Line 4112: VALUES (fnd_profile.value('BIS_CUST_CLASS_TYPE'),

4108: CREATED_BY,
4109: LAST_UPDATE_DATE,
4110: LAST_UPDATED_BY,
4111: LAST_UPDATE_LOGIN)
4112: VALUES (fnd_profile.value('BIS_CUST_CLASS_TYPE'),
4113: sysdate, --CREATION_DATE,
4114: g_fii_user_id, --CREATED_BY,
4115: sysdate, --LAST_UPDATE_DATE,
4116: g_fii_user_id, --LAST_UPDATED_BY,