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_FACTS1_PKG dependencies on FV_FACTS1_DIFF_BALANCES

Line 1723: FV_UTILITY.LOG_MESG('Deleting from fv_facts1_diff_balances for Period Year: '||

1719: DELETE FROM fv_facts_report_t2
1720: WHERE set_of_books_id = gbl_set_of_books_id;
1721:
1722: /** cleanup the line balance differrence records */
1723: FV_UTILITY.LOG_MESG('Deleting from fv_facts1_diff_balances for Period Year: '||
1724: gbl_period_year);
1725:
1726: DELETE FROM fv_facts1_diff_balances
1727: WHERE set_of_books_id = gbl_set_of_books_id

Line 1726: DELETE FROM fv_facts1_diff_balances

1722: /** cleanup the line balance differrence records */
1723: FV_UTILITY.LOG_MESG('Deleting from fv_facts1_diff_balances for Period Year: '||
1724: gbl_period_year);
1725:
1726: DELETE FROM fv_facts1_diff_balances
1727: WHERE set_of_books_id = gbl_set_of_books_id
1728: and period_year = gbl_period_year
1729: and balance_type IN ('B', 'D');
1730: --and balance_type = 'D';

Line 1733: ' records from fv_facts1_diff_balances.');

1729: and balance_type IN ('B', 'D');
1730: --and balance_type = 'D';
1731:
1732: FV_UTILITY.LOG_MESG('Deleted '||SQL%ROWCOUNT||
1733: ' records from fv_facts1_diff_balances.');
1734:
1735: EXCEPTION
1736: WHEN OTHERS THEN
1737: gbl_error_code := -1 ;

Line 2481: 'Deleting the begin balance difference records from fv_facts1_diff_balances.');

2477: and fiscal_year = gbl_fiscal_year;
2478:
2479: -- To delete the erroneous record
2480: fnd_file.put_line(fnd_file.log,
2481: 'Deleting the begin balance difference records from fv_facts1_diff_balances.');
2482:
2483: if l_diff_flag = 'N' then
2484: DELETE FROM fv_facts1_diff_balances
2485: WHERE set_of_books_id = gbl_set_of_books_id

Line 2484: DELETE FROM fv_facts1_diff_balances

2480: fnd_file.put_line(fnd_file.log,
2481: 'Deleting the begin balance difference records from fv_facts1_diff_balances.');
2482:
2483: if l_diff_flag = 'N' then
2484: DELETE FROM fv_facts1_diff_balances
2485: WHERE set_of_books_id = gbl_set_of_books_id
2486: and period_year = gbl_fiscal_year
2487: and balance_type = 'B';
2488: end if;

Line 2831: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Inserting into fv_facts1_diff_balances values: ');

2827: 0, l_ccid_l(i), l_account_type,
2828: 'Other', 0, 0);
2829:
2830: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2831: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Inserting into fv_facts1_diff_balances values: ');
2832: fv_utility.log_mesg('l_ccid_l(i): '||l_ccid_l(i));
2833: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
2834: fv_utility.log_mesg('gbl_fiscal_year: '||gbl_fiscal_year);
2835: fv_utility.log_mesg('gbl_set_of_books_id: '||gbl_set_of_books_id);

Line 2839: INSERT INTO fv_facts1_diff_balances

2835: fv_utility.log_mesg('gbl_set_of_books_id: '||gbl_set_of_books_id);
2836: fv_utility.log_mesg('balance_type: D');
2837: END IF;
2838:
2839: INSERT INTO fv_facts1_diff_balances
2840: (
2841: ccid,period_num,period_year,set_of_books_id,
2842: eliminations_dept,
2843: g_ng_indicator,

Line 2861: -- Populate fv_facts1_diff_balances with previous year's ending balance

2857: 'D','Other', l_account_number, l_fund_value);
2858: END IF;
2859:
2860: -------------------------------------------------------------------------
2861: -- Populate fv_facts1_diff_balances with previous year's ending balance
2862: -- and create a difference record
2863:
2864: /* check the begin_balance record been created , if not run it */
2865:

Line 2898: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Inserting into fv_facts1_diff_balances values: ');

2894: l_budget_subfunction, l_fund_value,
2895: 0, l_ccid_l(i), l_account_type,
2896: 'Other', 0, 0);
2897: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2898: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Inserting into fv_facts1_diff_balances values: ');
2899: fv_utility.log_mesg('l_ccid_l(i): '||l_ccid_l(i));
2900: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
2901: fv_utility.log_mesg('gbl_fiscal_year: '||gbl_fiscal_year);
2902: fv_utility.log_mesg('gbl_set_of_books_id: '||gbl_set_of_books_id);

Line 2906: INSERT INTO fv_facts1_diff_balances

2902: fv_utility.log_mesg('gbl_set_of_books_id: '||gbl_set_of_books_id);
2903: fv_utility.log_mesg('balance_type: B');
2904: END IF;
2905:
2906: INSERT INTO fv_facts1_diff_balances
2907: (ccid,period_num,period_year,set_of_books_id,
2908: eliminations_dept,
2909: g_ng_indicator,
2910: amount,