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