48: g_fii_login_id NUMBER(15);
49: g_truncate_staging VARCHAR2(1) := 'N';
50: g_truncate_id VARCHAR2(1) := 'N';
51: g_truncate_rates VARCHAR2(1) := 'N';
52: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
53: g_exp_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_EXP_IMP'), 'N');
54: g_oper_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_IMP'), 'N');
55: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second
56:
49: g_truncate_staging VARCHAR2(1) := 'N';
50: g_truncate_id VARCHAR2(1) := 'N';
51: g_truncate_rates VARCHAR2(1) := 'N';
52: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
53: g_exp_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_EXP_IMP'), 'N');
54: g_oper_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_IMP'), 'N');
55: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second
56:
57: g_program_type VARCHAR2(1);
50: g_truncate_id VARCHAR2(1) := 'N';
51: g_truncate_rates VARCHAR2(1) := 'N';
52: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
53: g_exp_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_EXP_IMP'), 'N');
54: g_oper_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_IMP'), 'N');
55: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second
56:
57: g_program_type VARCHAR2(1);
58: