eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AP_INV_SUM_INIT dependencies on FND_PROFILE

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

11: g_end_date DATE;
12: l_date_mask VARCHAR2(240);
13: g_sysdate DATE := TRUNC(SYSDATE);
14: g_seq_id NUMBER;
15: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
16: g_oper_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_IMP'), 'N');
17: g_exp_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_EXP_IMP'), 'N');
18: g_manual_sources VARCHAR2(2000) := FND_PROFILE.value('FII_AP_MANUAL_SOURCES');
19: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second

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

12: l_date_mask VARCHAR2(240);
13: g_sysdate DATE := TRUNC(SYSDATE);
14: g_seq_id NUMBER;
15: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
16: g_oper_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_IMP'), 'N');
17: g_exp_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_EXP_IMP'), 'N');
18: g_manual_sources VARCHAR2(2000) := FND_PROFILE.value('FII_AP_MANUAL_SOURCES');
19: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second
20: INTERVAL_SIZE NUMBER := 50000;

Line 17: g_exp_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_EXP_IMP'), 'N');

13: g_sysdate DATE := TRUNC(SYSDATE);
14: g_seq_id NUMBER;
15: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
16: g_oper_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_IMP'), 'N');
17: g_exp_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_EXP_IMP'), 'N');
18: g_manual_sources VARCHAR2(2000) := FND_PROFILE.value('FII_AP_MANUAL_SOURCES');
19: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second
20: INTERVAL_SIZE NUMBER := 50000;
21: MAX_LOOP CONSTANT NUMBER := 60;

Line 18: g_manual_sources VARCHAR2(2000) := FND_PROFILE.value('FII_AP_MANUAL_SOURCES');

14: g_seq_id NUMBER;
15: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
16: g_oper_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_IMP'), 'N');
17: g_exp_imp_prof_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_AP_DBI_EXP_IMP'), 'N');
18: g_manual_sources VARCHAR2(2000) := FND_PROFILE.value('FII_AP_MANUAL_SOURCES');
19: ONE_SECOND CONSTANT NUMBER := 0.000011574; -- 1 second
20: INTERVAL_SIZE NUMBER := 50000;
21: MAX_LOOP CONSTANT NUMBER := 60;
22:

Line 7110: FND_PROFILE.PUT('CONC_SINGLE_THREAD','N');

7106: and re-populate this table */
7107: TRUNCATE_TABLE('MLOG$_FII_AP_PAY_SCHED_B');
7108: TRUNCATE_TABLE('FII_AP_PAY_SCHED_B');
7109:
7110: FND_PROFILE.PUT('CONC_SINGLE_THREAD','N');
7111:
7112: --------------------------------------------------------
7113: -- Launch worker
7114: --------------------------------------------------------

Line 7142: FND_PROFILE.PUT('CONC_SINGLE_THREAD','Y');

7138: -------------------------------------------------------------------
7139: FND_STATS.GATHER_TABLE_STATS(g_ap_schema,'AP_PAYMENT_SCHEDULES_ALL');
7140: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
7141:
7142: FND_PROFILE.PUT('CONC_SINGLE_THREAD','Y');
7143:
7144: if g_debug_flag = 'Y' then
7145: FII_UTIL.put_line('-------------------------------------------------');
7146: FII_UTIL.put_line('Calling procedure POPULATE_PS_BUCKET_COUNT');