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.FV_FACTS2_DERIVE_BALANCES dependencies on FV_FACTSII_ENDING_BALANCES

Line 53: FROM fv_factsii_ending_balances

49: report ('+-------+----------+-------+---------+--------------+-----------------+-----------------+');
50: report ('|Account|Public Law|Adv Flg|Txfr Dept|Txfr Main Acct|Ending Balance Cr|Ending Balance Cr|');
51: report ('|-------+----------+-------+---------+--------------+-----------------+-----------------|');
52: FOR factsii_rec IN (SELECT *
53: FROM fv_factsii_ending_balances
54: WHERE set_of_books_id = p_ledger_id
55: AND fiscal_year = p_fiscal_year) LOOP
56: report ('|'||
57: RPAD (factsii_rec.ussgl_account, 7, ' ')||

Line 563: --* Purpose : Purges data from the table fv_factsii_ending_balances for the given *--

559:
560: --****************************************************************************************--
561: --* Name : purge_balances *--
562: --* Type : Procedure *--
563: --* Purpose : Purges data from the table fv_factsii_ending_balances for the given *--
564: --* : set of books id and fiscal year. *--
565: --* Parameters : p_ledger_id IN Set Of Books Id *--
566: --* : p_fiscal_year IN Fiscal Year *--
567: --* : p_error_code OUT Return Error Code *--

Line 578: --* Tables Used : fv_factsii_ending_balances DELETE *--

574: --* : g_SUCCESS *--
575: --* Called from : derive_balances *--
576: --* Calls : fv_utility.debug_mesg *--
577: --* : fv_utility.log_mesg *--
578: --* Tables Used : fv_factsii_ending_balances DELETE *--
579: --* Logic : 1. Delete data from table fv_factsii_ending_balances for the given *--
580: --* : set of books id and fiscal year.
581: --****************************************************************************************--
582: PROCEDURE purge_balances

Line 579: --* Logic : 1. Delete data from table fv_factsii_ending_balances for the given *--

575: --* Called from : derive_balances *--
576: --* Calls : fv_utility.debug_mesg *--
577: --* : fv_utility.log_mesg *--
578: --* Tables Used : fv_factsii_ending_balances DELETE *--
579: --* Logic : 1. Delete data from table fv_factsii_ending_balances for the given *--
580: --* : set of books id and fiscal year.
581: --****************************************************************************************--
582: PROCEDURE purge_balances
583: (

Line 606: DELETE fv_factsii_ending_balances

602: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_fiscal_year = '||p_fiscal_year);
603: END IF;
604:
605: BEGIN
606: DELETE fv_factsii_ending_balances
607: WHERE set_of_books_id = p_ledger_id
608: AND fiscal_year = p_fiscal_year;
609: EXCEPTION
610: WHEN OTHERS THEN

Line 613: l_location := l_module_name||'delete_fv_factsii_ending_balances';

609: EXCEPTION
610: WHEN OTHERS THEN
611: p_error_code := g_FAILURE;
612: p_error_desc := SQLERRM;
613: l_location := l_module_name||'delete_fv_factsii_ending_balances';
614: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
615: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
616: END;
617:

Line 744: --* Tables Used : fv_factsii_ending_balances INSERT *--

740: --* : g_SUCCESS *--
741: --* Called from : derive_balances *--
742: --* Calls : fv_utility.debug_mesg *--
743: --* : fv_utility.log_mesg *--
744: --* Tables Used : fv_factsii_ending_balances INSERT *--
745: --* : gl_je_lines gll SELECT *--
746: --* : gl_je_headers gjh SELECT *--
747: --* : gl_period_statuses gps SELECT *--
748: --* : fv_be_trx_dtls SELECT *--

Line 869: l_gl_cursor_str := 'INSERT INTO fv_factsii_ending_balances

865: l_attr_group_columns := l_attr_group_columns||',be.dept_id ';
866: l_where_columns := l_where_columns||'(DECODE(:b_transfer_flag, ''Y'', be.dept_id, NULL) IS NOT NULL)) ';
867: END IF;
868:
869: l_gl_cursor_str := 'INSERT INTO fv_factsii_ending_balances
870: (
871: set_of_books_id,
872: fiscal_year,
873: ccid,

Line 1211: FROM fv_factsii_ending_balances ffeb

1207: END;
1208: END IF;
1209: IF (p_error_code = g_SUCCESS) THEN
1210: FOR previous_year_rec IN (SELECT *
1211: FROM fv_factsii_ending_balances ffeb
1212: WHERE ffeb.set_of_books_id = p_ledger_id
1213: AND ffeb.fiscal_year = p_fiscal_year-1
1214: AND ffeb.ccid = l_code_combination_id) LOOP
1215: BEGIN

Line 1216: UPDATE fv_factsii_ending_balances ffeb

1212: WHERE ffeb.set_of_books_id = p_ledger_id
1213: AND ffeb.fiscal_year = p_fiscal_year-1
1214: AND ffeb.ccid = l_code_combination_id) LOOP
1215: BEGIN
1216: UPDATE fv_factsii_ending_balances ffeb
1217: SET ffeb.ending_balance_cr = NVL(ffeb.ending_balance_cr, 0) + NVL(previous_year_rec.ending_balance_cr, 0),
1218: ffeb.ending_balance_dr = NVL(ffeb.ending_balance_dr, 0) + NVL(previous_year_rec.ending_balance_dr, 0)
1219: WHERE ffeb.set_of_books_id = previous_year_rec.set_of_books_id
1220: AND ffeb.fiscal_year = p_fiscal_year

Line 1234: l_location := l_module_name||'update_fv_factsii_ending_balances';

1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: p_error_code := g_FAILURE;
1233: p_error_desc := SQLERRM;
1234: l_location := l_module_name||'update_fv_factsii_ending_balances';
1235: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1236: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1237: END;
1238:

Line 1242: INSERT INTO fv_factsii_ending_balances

1238:
1239: IF (p_error_code = g_SUCCESS) THEN
1240: IF (l_insert_required) THEN
1241: BEGIN
1242: INSERT INTO fv_factsii_ending_balances
1243: (
1244: set_of_books_id,
1245: fiscal_year,
1246: ccid,

Line 1294: l_location := l_module_name||'insert_fv_factsii_ending_balances1';

1290: EXCEPTION
1291: WHEN OTHERS THEN
1292: p_error_code := g_FAILURE;
1293: p_error_desc := SQLERRM;
1294: l_location := l_module_name||'insert_fv_factsii_ending_balances1';
1295: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1296: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1297: END;
1298: END IF;

Line 1309: FROM fv_factsii_ending_balances ffeb

1305: BEGIN
1306: l_count_ccid := 0;
1307: SELECT COUNT (*)
1308: INTO l_count_ccid
1309: FROM fv_factsii_ending_balances ffeb
1310: WHERE ffeb.set_of_books_id = p_ledger_id
1311: AND ffeb.fiscal_year = p_fiscal_year
1312: AND ccid = l_code_combination_id;
1313: EXCEPTION

Line 1319: l_location := l_module_name||'select_fv_factsii_ending_balances';

1315: l_count_ccid := 0;
1316: WHEN OTHERS THEN
1317: p_error_code := g_FAILURE;
1318: p_error_desc := SQLERRM;
1319: l_location := l_module_name||'select_fv_factsii_ending_balances';
1320: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1321: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1322: END;
1323: END IF;

Line 1328: INSERT INTO fv_factsii_ending_balances

1324:
1325: IF (p_error_code = g_SUCCESS) THEN
1326: IF (l_count_ccid <> 0) THEN
1327: BEGIN
1328: INSERT INTO fv_factsii_ending_balances
1329: (
1330: set_of_books_id,
1331: fiscal_year,
1332: ccid,

Line 1373: FROM fv_factsii_ending_balances ffeb

1369: l_system_date,
1370: g_user_id,
1371: g_request_id,
1372: l_treasury_symbol_id
1373: FROM fv_factsii_ending_balances ffeb
1374: WHERE ffeb.set_of_books_id = p_ledger_id
1375: AND ffeb.fiscal_year = p_fiscal_year
1376: AND ccid = l_code_combination_id
1377: GROUP BY ccid

Line 1385: l_location := l_module_name||'INSERT INTO fv_factsii_ending_balances';

1381: EXCEPTION
1382: WHEN OTHERS THEN
1383: p_error_code := g_FAILURE;
1384: p_error_desc := SQLERRM;
1385: l_location := l_module_name||'INSERT INTO fv_factsii_ending_balances';
1386: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1387: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1388: END;
1389: END IF;

Line 1405: DELETE fv_factsii_ending_balances ffeb1

1401: END IF;
1402:
1403: IF (p_error_code = g_SUCCESS) THEN
1404: BEGIN
1405: DELETE fv_factsii_ending_balances ffeb1
1406: WHERE EXISTS (SELECT ffeb2.set_of_books_id,
1407: ffeb2.ccid,
1408: ffeb2.fiscal_year,
1409: count(*)

Line 1410: FROM fv_factsii_ending_balances ffeb2

1406: WHERE EXISTS (SELECT ffeb2.set_of_books_id,
1407: ffeb2.ccid,
1408: ffeb2.fiscal_year,
1409: count(*)
1410: FROM fv_factsii_ending_balances ffeb2
1411: WHERE ffeb2.set_of_books_id = ffeb1.set_of_books_id
1412: AND ffeb2.ccid = ffeb1.ccid
1413: AND ffeb2.fiscal_year = ffeb1.fiscal_year
1414: GROUP BY ffeb2.set_of_books_id,

Line 1426: l_location := l_module_name||'DELETE FROM fv_factsii_ending_balances1';

1422: EXCEPTION
1423: WHEN OTHERS THEN
1424: p_error_code := g_FAILURE;
1425: p_error_desc := SQLERRM;
1426: l_location := l_module_name||'DELETE FROM fv_factsii_ending_balances1';
1427: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1428: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1429: END;
1430: END IF;