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_AR_FACTS_AGING_PKG dependencies on FII_AR_TRANSACTIONS_F

Line 1243: -- This procedure inserts records in FII_AR_TRANSACTIONS_F

1239:
1240: ------------------------------------------------------------------
1241: -- Procedure POPULATE_TRANSACTIONS
1242: -- Purpose
1243: -- This procedure inserts records in FII_AR_TRANSACTIONS_F
1244: ------------------------------------------------------------------
1245: PROCEDURE POPULATE_TRANSACTIONS IS
1246: BEGIN
1247:

Line 1248: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';

1244: ------------------------------------------------------------------
1245: PROCEDURE POPULATE_TRANSACTIONS IS
1246: BEGIN
1247:
1248: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';
1249: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
1250: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
1251: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
1252:

Line 1249: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');

1245: PROCEDURE POPULATE_TRANSACTIONS IS
1246: BEGIN
1247:
1248: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';
1249: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
1250: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
1251: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
1252:
1253: g_state := 'Populating FII_AR_TRANSACTIONS_F';

Line 1250: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';

1246: BEGIN
1247:
1248: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';
1249: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
1250: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
1251: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
1252:
1253: g_state := 'Populating FII_AR_TRANSACTIONS_F';
1254: if g_debug_flag = 'Y' then

Line 1251: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');

1247:
1248: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';
1249: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
1250: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
1251: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
1252:
1253: g_state := 'Populating FII_AR_TRANSACTIONS_F';
1254: if g_debug_flag = 'Y' then
1255: FII_UTIL.put_line(g_state);

Line 1253: g_state := 'Populating FII_AR_TRANSACTIONS_F';

1249: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
1250: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
1251: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
1252:
1253: g_state := 'Populating FII_AR_TRANSACTIONS_F';
1254: if g_debug_flag = 'Y' then
1255: FII_UTIL.put_line(g_state);
1256: FII_UTIL.start_timer;
1257: FII_UTIL.put_line('');

Line 1260: INSERT /+ append parallel(F) / INTO FII_AR_TRANSACTIONS_F F

1256: FII_UTIL.start_timer;
1257: FII_UTIL.put_line('');
1258: end if;
1259:
1260: INSERT /*+ append parallel(F) */ INTO FII_AR_TRANSACTIONS_F F
1261: (customer_trx_id,
1262: org_id,
1263: time_id,
1264: trx_date,

Line 1405: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_TRANSACTIONS_F');

1401: trx.created_by,
1402: trx.creation_date;
1403:
1404: if g_debug_flag = 'Y' then
1405: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_TRANSACTIONS_F');
1406: FII_UTIL.stop_timer;
1407: FII_UTIL.print_timer('Duration');
1408: FII_UTIL.put_line('');
1409: end if;

Line 1411: g_state := 'Analyzing FII_AR_TRANSACTIONS_F table';

1407: FII_UTIL.print_timer('Duration');
1408: FII_UTIL.put_line('');
1409: end if;
1410:
1411: g_state := 'Analyzing FII_AR_TRANSACTIONS_F table';
1412: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');
1413:
1414: EXCEPTION
1415: WHEN OTHERS THEN

Line 1412: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');

1408: FII_UTIL.put_line('');
1409: end if;
1410:
1411: g_state := 'Analyzing FII_AR_TRANSACTIONS_F table';
1412: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');
1413:
1414: EXCEPTION
1415: WHEN OTHERS THEN
1416: g_errbuf:=sqlerrm;

Line 1510: FII_AR_TRANSACTIONS_F trx,

1506: sysdate, --LAST_UPDATE_DATE,
1507: g_fii_user_id, --LAST_UPDATED_BY,
1508: g_fii_login_id --LAST_UPDATE_LOGIN
1509: FROM AR_ADJUSTMENTS_ALL adj,
1510: FII_AR_TRANSACTIONS_F trx,
1511: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR
1512: RA_CUSTOMER_TRX_LINES_ALL line,
1513: FII_AR_CURR_RATES_T rt,
1514: AR_SYSTEM_PARAMETERS_ALL par,

Line 1511: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR

1507: g_fii_user_id, --LAST_UPDATED_BY,
1508: g_fii_login_id --LAST_UPDATE_LOGIN
1509: FROM AR_ADJUSTMENTS_ALL adj,
1510: FII_AR_TRANSACTIONS_F trx,
1511: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR
1512: RA_CUSTOMER_TRX_LINES_ALL line,
1513: FII_AR_CURR_RATES_T rt,
1514: AR_SYSTEM_PARAMETERS_ALL par,
1515: GL_SETS_OF_BOOKS sob

Line 5479: -- This procedure manipulates records in FII_AR_TRANSACTIONS_F

5475:
5476: ------------------------------------------------------------------
5477: -- Procedure Inc_TRANSACTIONS
5478: -- Purpose
5479: -- This procedure manipulates records in FII_AR_TRANSACTIONS_F
5480: ------------------------------------------------------------------
5481: PROCEDURE Inc_TRANSACTIONS IS
5482: BEGIN
5483:

Line 5485: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';

5481: PROCEDURE Inc_TRANSACTIONS IS
5482: BEGIN
5483:
5484: /*
5485: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';
5486: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
5487: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
5488: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
5489: */

Line 5486: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');

5482: BEGIN
5483:
5484: /*
5485: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';
5486: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
5487: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
5488: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
5489: */
5490:

Line 5487: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';

5483:
5484: /*
5485: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';
5486: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
5487: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
5488: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
5489: */
5490:
5491: g_state := 'Deleting FII_AR_TRANSACTIONS_F';

Line 5488: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');

5484: /*
5485: g_state := 'Truncating table MLOG$_FII_AR_TRANSACTIONS_F';
5486: TRUNCATE_TABLE('MLOG$_FII_AR_TRANSACTIONS_F');
5487: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
5488: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
5489: */
5490:
5491: g_state := 'Deleting FII_AR_TRANSACTIONS_F';
5492: if g_debug_flag = 'Y' then

Line 5491: g_state := 'Deleting FII_AR_TRANSACTIONS_F';

5487: g_state := 'Truncating table FII_AR_TRANSACTIONS_F';
5488: TRUNCATE_TABLE('FII_AR_TRANSACTIONS_F');
5489: */
5490:
5491: g_state := 'Deleting FII_AR_TRANSACTIONS_F';
5492: if g_debug_flag = 'Y' then
5493: FII_UTIL.put_line(g_state);
5494: FII_UTIL.start_timer;
5495: FII_UTIL.put_line('');

Line 5498: delete from fii_ar_transactions_f

5494: FII_UTIL.start_timer;
5495: FII_UTIL.put_line('');
5496: end if;
5497:
5498: delete from fii_ar_transactions_f
5499: where CUSTOMER_TRX_ID in (
5500: -- Trans Delete
5501: select CUSTOMER_TRX_ID
5502: from FII_AR_TRANS_DELETE_GT

Line 5506: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_TRANSACTIONS_F');

5502: from FII_AR_TRANS_DELETE_GT
5503: );
5504:
5505: if g_debug_flag = 'Y' then
5506: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_TRANSACTIONS_F');
5507: FII_UTIL.stop_timer;
5508: FII_UTIL.print_timer('Duration');
5509: FII_UTIL.put_line('');
5510: end if;

Line 5514: g_state := 'Merging into FII_AR_TRANSACTIONS_F';

5510: end if;
5511:
5512: commit;
5513:
5514: g_state := 'Merging into FII_AR_TRANSACTIONS_F';
5515: if g_debug_flag = 'Y' then
5516: FII_UTIL.put_line(g_state);
5517: FII_UTIL.start_timer;
5518: FII_UTIL.put_line('');

Line 5521: merge into fii_ar_transactions_f old using (

5517: FII_UTIL.start_timer;
5518: FII_UTIL.put_line('');
5519: end if;
5520:
5521: merge into fii_ar_transactions_f old using (
5522: -- POPULATE_TRANSACTIONS
5523: SELECT trx.customer_trx_id,
5524: trx.org_id,
5525: to_number(to_char(decode(g_collection_criteria,

Line 5820: FII_UTIL.put_line('Merged ' ||SQL%ROWCOUNT|| ' records into FII_AR_TRANSACTIONS_F');

5816: dlt.LAST_UPDATE_LOGIN
5817: );
5818:
5819: if g_debug_flag = 'Y' then
5820: FII_UTIL.put_line('Merged ' ||SQL%ROWCOUNT|| ' records into FII_AR_TRANSACTIONS_F');
5821: FII_UTIL.stop_timer;
5822: FII_UTIL.print_timer('Duration');
5823: FII_UTIL.put_line('');
5824: end if;

Line 5826: g_state := 'Analyzing FII_AR_TRANSACTIONS_F table';

5822: FII_UTIL.print_timer('Duration');
5823: FII_UTIL.put_line('');
5824: end if;
5825:
5826: g_state := 'Analyzing FII_AR_TRANSACTIONS_F table';
5827: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');
5828:
5829: EXCEPTION
5830: WHEN OTHERS THEN

Line 5827: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');

5823: FII_UTIL.put_line('');
5824: end if;
5825:
5826: g_state := 'Analyzing FII_AR_TRANSACTIONS_F table';
5827: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');
5828:
5829: EXCEPTION
5830: WHEN OTHERS THEN
5831: g_errbuf:=sqlerrm;

Line 5934: FII_AR_TRANSACTIONS_F trx,

5930: select * from FII_AR_ADJ_UPDATE_GT
5931: -- where last_update_date <= g_sysdate_time
5932: ) */
5933: FII_AR_ADJ_UPDATE_GT adj,
5934: FII_AR_TRANSACTIONS_F trx,
5935: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR
5936: RA_CUSTOMER_TRX_LINES_ALL line,
5937: FII_AR_CURR_RATES_T rt,
5938: AR_SYSTEM_PARAMETERS_ALL par,

Line 5935: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR

5931: -- where last_update_date <= g_sysdate_time
5932: ) */
5933: FII_AR_ADJ_UPDATE_GT adj,
5934: FII_AR_TRANSACTIONS_F trx,
5935: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR
5936: RA_CUSTOMER_TRX_LINES_ALL line,
5937: FII_AR_CURR_RATES_T rt,
5938: AR_SYSTEM_PARAMETERS_ALL par,
5939: GL_SETS_OF_BOOKS sob