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_GTAS_INTERFACE dependencies on FV_GTAS_DIFF_BALANCES

Line 1758: FV_UTILITY.LOG_MESG('Deleting from fv_gtas_diff_balances for Period Year: '||

1754: DELETE FROM fv_gtas1_report_t2
1755: WHERE set_of_books_id = gbl_set_of_books_id;
1756:
1757: /** cleanup the line balance differrence records */
1758: FV_UTILITY.LOG_MESG('Deleting from fv_gtas_diff_balances for Period Year: '||
1759: gbl_period_year);
1760:
1761: DELETE FROM fv_gtas_diff_balances
1762: WHERE set_of_books_id = gbl_set_of_books_id

Line 1761: DELETE FROM fv_gtas_diff_balances

1757: /** cleanup the line balance differrence records */
1758: FV_UTILITY.LOG_MESG('Deleting from fv_gtas_diff_balances for Period Year: '||
1759: gbl_period_year);
1760:
1761: DELETE FROM fv_gtas_diff_balances
1762: WHERE set_of_books_id = gbl_set_of_books_id
1763: and period_year = gbl_period_year
1764: and balance_type IN ('B', 'D');
1765: --and balance_type = 'D';

Line 1768: ' records from fv_gtas_diff_balances.');

1764: and balance_type IN ('B', 'D');
1765: --and balance_type = 'D';
1766:
1767: log(l_module_name, 'Deleted '||SQL%ROWCOUNT||
1768: ' records from fv_gtas_diff_balances.');
1769:
1770: --Set the reported_group to Null so that fv_gtas1_period_balances_v
1771: --picks up only the rows processed in the current run
1772: log(l_module_name, 'Setting reported_group to NULL');

Line 2122: 'Deleting the begin balance difference records from fv_gtas_diff_balances.');

2118: and fiscal_year = gbl_fiscal_year;
2119:
2120: -- To delete the erroneous record
2121: log(l_module_name,
2122: 'Deleting the begin balance difference records from fv_gtas_diff_balances.');
2123:
2124: if l_diff_flag = 'N' then
2125: DELETE FROM fv_gtas_diff_balances
2126: WHERE set_of_books_id = gbl_set_of_books_id

Line 2125: DELETE FROM fv_gtas_diff_balances

2121: log(l_module_name,
2122: 'Deleting the begin balance difference records from fv_gtas_diff_balances.');
2123:
2124: if l_diff_flag = 'N' then
2125: DELETE FROM fv_gtas_diff_balances
2126: WHERE set_of_books_id = gbl_set_of_books_id
2127: and period_year = gbl_fiscal_year
2128: and balance_type = 'B';
2129: end if;

Line 2353: 'Inserting into fv_gtas_diff_balances values: ');

2349:
2350: IF (l_curr_year_balance <> l_t2_detail_amount) THEN
2351: log(l_module_name, '*****inserting detail difference record');
2352: log(l_module_name,
2353: 'Inserting into fv_gtas_diff_balances values: ');
2354: log(l_module_name, 'l_ccid_l(i): '||l_ccid_l(i));
2355: log(l_module_name, 'gbl_period_num_low: '||gbl_period_num_low);
2356: log(l_module_name, 'gbl_fiscal_year: '||gbl_fiscal_year);
2357: log(l_module_name, 'gbl_set_of_books_id: '||gbl_set_of_books_id);

Line 2361: INSERT INTO fv_gtas_diff_balances

2357: log(l_module_name, 'gbl_set_of_books_id: '||gbl_set_of_books_id);
2358: log(l_module_name, 'balance_type: D');
2359:
2360:
2361: INSERT INTO fv_gtas_diff_balances
2362: (
2363: ccid,period_num,period_year,set_of_books_id,
2364: amount,
2365: d_c_indicator,

Line 2379: -- Populate fv_gtas_diff_balances with previous year's ending balance

2375:
2376: END IF;
2377: END IF;
2378: -------------------------------------------------------------------------
2379: -- Populate fv_gtas_diff_balances with previous year's ending balance
2380: -- and create a difference record
2381:
2382: -- check the begin_balance record been created , if not run it
2383:

Line 2406: 'Inserting into fv_gtas_diff_balances values: ');

2402:
2403: IF l_begin_bal_l(i) <> l_ending_amount THEN
2404: log(l_module_name, '*****inserting end bal difference record');
2405: log(l_module_name,
2406: 'Inserting into fv_gtas_diff_balances values: ');
2407: log(l_module_name, 'l_ccid_l(i): '||l_ccid_l(i));
2408: log(l_module_name, 'gbl_period_num_low: '||gbl_period_num_low);
2409: log(l_module_name, 'gbl_fiscal_year: '||gbl_fiscal_year);
2410: log(l_module_name, 'gbl_set_of_books_id: '||gbl_set_of_books_id);

Line 2414: INSERT INTO fv_gtas_diff_balances

2410: log(l_module_name, 'gbl_set_of_books_id: '||gbl_set_of_books_id);
2411: log(l_module_name, 'balance_type: B');
2412:
2413:
2414: INSERT INTO fv_gtas_diff_balances
2415: (ccid,period_num,period_year,set_of_books_id,
2416: amount,
2417: d_c_indicator,
2418: balance_type,