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_FA_EXP_B_C dependencies on FII_FA_EXP_F

Line 418: FROM fii_fa_exp_f

414: begin
415:
416: SELECT 1
417: INTO l_count1
418: FROM fii_fa_exp_f
419: WHERE ROWNUM = 1;
420: exception
421: when NO_DATA_FOUND then
422: l_count1 := 0;

Line 1081: delete from fii_fa_exp_f

1077: FII_UTIL.put_line ('Calling Delete_From_Base_Summary Procedure');
1078: FII_UTIL.start_timer;
1079: end if;
1080:
1081: delete from fii_fa_exp_f
1082: where xla_event_id in
1083: (select ev_dep.event_id
1084: from fii_fa_new_exp_hdr_ids nid,
1085: xla_events ev_rb,

Line 1101: ' lines from FII_FA_EXP_F for rolled back entries');

1097: commit;
1098:
1099: if g_debug_flag = 'Y' then
1100: FII_UTIL.put_line('Deleted '|| l_count ||
1101: ' lines from FII_FA_EXP_F for rolled back entries');
1102: FII_UTIL.stop_timer;
1103: FII_UTIL.print_timer('Duration');
1104: FII_UTIL.put_line('');
1105: end if;

Line 1317: g_phase := 'Inserting into fii_fa_exp_f-periodic deprn';

1313: l_stmt VARCHAR2(1000);
1314:
1315: BEGIN
1316:
1317: g_phase := 'Inserting into fii_fa_exp_f-periodic deprn';
1318:
1319: if g_debug_flag = 'Y' then
1320: fii_util.put_line('g_number_of_process: ' || to_char(g_number_of_process));
1321: fii_util.put_line('g_worker_num: ' || to_char(g_worker_num));

Line 1329: insert into fii_fa_exp_f

1325: fii_util.start_timer;
1326: fii_util.put_line('');
1327: end if;
1328:
1329: insert into fii_fa_exp_f
1330: (LEDGER_ID ,
1331: ACCOUNT_DATE ,
1332: CURRENCY_CODE ,
1333: CHART_OF_ACCOUNTS_ID ,

Line 1443: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_fa_exp_f');

1439: and bc.book_type_code = dp.book_type_code
1440: and bc.set_of_books_id = sob.ledger_id;
1441:
1442: if g_debug_flag = 'Y' then
1443: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_fa_exp_f');
1444: fii_util.stop_timer;
1445: fii_util.print_timer('Duration');
1446: end if;
1447:

Line 1450: g_phase := 'Inserting into fii_fa_exp_f-catchup deprn';

1446: end if;
1447:
1448: commit;
1449:
1450: g_phase := 'Inserting into fii_fa_exp_f-catchup deprn';
1451:
1452: if g_debug_flag = 'Y' then
1453: fii_util.put_line(' ');
1454: fii_util.put_line(g_phase);

Line 1459: insert into fii_fa_exp_f

1455: fii_util.start_timer;
1456: fii_util.put_line('');
1457: end if;
1458:
1459: insert into fii_fa_exp_f
1460: (LEDGER_ID ,
1461: ACCOUNT_DATE ,
1462: CURRENCY_CODE ,
1463: CHART_OF_ACCOUNTS_ID ,

Line 1605: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_fa_exp_f');

1601:
1602:
1603:
1604: if g_debug_flag = 'Y' then
1605: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_fa_exp_f');
1606: fii_util.stop_timer;
1607: fii_util.print_timer('Duration');
1608: end if;
1609:

Line 1614: g_phase := 'Calling FND_STATS to collect statistics for fii_fa_exp_f';

1610: commit;
1611:
1612: --Call FND_STATS to collect statistics after populating the table
1613: /*
1614: g_phase := 'Calling FND_STATS to collect statistics for fii_fa_exp_f';
1615: FND_STATS.gather_table_stats
1616: (ownname => g_fii_schema,
1617: tabname => 'fii_fa_exp_f');
1618: */

Line 1617: tabname => 'fii_fa_exp_f');

1613: /*
1614: g_phase := 'Calling FND_STATS to collect statistics for fii_fa_exp_f';
1615: FND_STATS.gather_table_stats
1616: (ownname => g_fii_schema,
1617: tabname => 'fii_fa_exp_f');
1618: */
1619: commit;
1620:
1621: EXCEPTION

Line 1662: into fii_fa_exp_f bsum

1658:
1659: /*+ append parallel(bsum) */
1660:
1661: insert
1662: into fii_fa_exp_f bsum
1663: (LEDGER_ID ,
1664: ACCOUNT_DATE ,
1665: CURRENCY_CODE ,
1666: CHART_OF_ACCOUNTS_ID ,

Line 1808: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_fa_exp_f');

1804: headers.event_id,
1805: headers.ae_header_id;
1806:
1807: if g_debug_flag = 'Y' then
1808: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_fa_exp_f');
1809: fii_util.stop_timer;
1810: fii_util.print_timer('Duration');
1811: end if;
1812:

Line 1825: into fii_fa_exp_f bsum

1821: fii_util.put_line('');
1822: end if;
1823:
1824: insert
1825: into fii_fa_exp_f bsum
1826: (LEDGER_ID ,
1827: ACCOUNT_DATE ,
1828: CURRENCY_CODE ,
1829: CHART_OF_ACCOUNTS_ID ,

Line 1953: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_fa_exp_f');

1949: and ev_rb.application_id = 140
1950: and ev_rb.event_id > ev_dep.event_id);
1951:
1952: if g_debug_flag = 'Y' then
1953: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_fa_exp_f');
1954: fii_util.stop_timer;
1955: fii_util.print_timer('Duration');
1956: end if;
1957:

Line 2063: FII_UTIL.initialize('FII_FA_EXP_SUM.log','FII_FA_EXP_SUM.out',l_dir, 'FII_FA_EXP_F_L');

2059: g_phase := 'Calling FII_UTIL.initialize';
2060: IF g_program_type = 'I' THEN
2061: FII_UTIL.initialize('FII_FA_EXP_SUM.log','FII_FA_EXP_SUM.out',l_dir, 'FII_FA_EXP_B_C');
2062: ELSIF g_program_type = 'L' THEN
2063: FII_UTIL.initialize('FII_FA_EXP_SUM.log','FII_FA_EXP_SUM.out',l_dir, 'FII_FA_EXP_F_L');
2064: END IF;
2065:
2066:
2067: ------------------------------------------------

Line 2138: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_FA_EXP_F_L')) THEN

2134: raise_application_error(-20000,errbuf);
2135: return;
2136: END IF;
2137: ELSIF g_program_type = 'L' THEN
2138: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_FA_EXP_F_L')) THEN
2139: raise_application_error(-20000,errbuf);
2140: return;
2141: END IF;
2142: END IF;

Line 2163: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_F',

2159:
2160: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_T',
2161: P_RETCODE => l_ret_code);
2162:
2163: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_F',
2164: P_RETCODE => l_ret_code);
2165:
2166: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_HDR_IDS',
2167: P_RETCODE => l_ret_code);