APPS.FV_FACTS1_PKG dependencies on FV_FACTS_ENDING_BALANCES

Line 274: FROM fv_facts_ending_balances

270: IF (gbl_run_type = 'Y') THEN
271:
272: SELECT count(*)
273: INTO l_row_exists
274: FROM fv_facts_ending_balances
275: WHERE fiscal_year = gbl_period_year
276: AND set_of_books_id = gbl_set_of_books_id
277: AND rownum = 1;
278:

Line 282: ' DELETING RECORDS FROM FV_FACTS_ENDING_BALANCES FOR

278:
279: IF (l_row_exists > 0) THEN
280: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_EVENT, l_module_name,
282: ' DELETING RECORDS FROM FV_FACTS_ENDING_BALANCES FOR
283: THE YEAR = '|| GBL_PERIOD_YEAR);
284: END IF;
285: fv_utility.log_mesg('Deleting recs from fv_facts_ending_balances
286: for Period Year: '||gbl_period_year);

Line 285: fv_utility.log_mesg('Deleting recs from fv_facts_ending_balances

281: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_EVENT, l_module_name,
282: ' DELETING RECORDS FROM FV_FACTS_ENDING_BALANCES FOR
283: THE YEAR = '|| GBL_PERIOD_YEAR);
284: END IF;
285: fv_utility.log_mesg('Deleting recs from fv_facts_ending_balances
286: for Period Year: '||gbl_period_year);
287:
288: DELETE FROM fv_facts_ending_balances
289: WHERE set_of_books_id = gbl_set_of_books_id

Line 288: DELETE FROM fv_facts_ending_balances

284: END IF;
285: fv_utility.log_mesg('Deleting recs from fv_facts_ending_balances
286: for Period Year: '||gbl_period_year);
287:
288: DELETE FROM fv_facts_ending_balances
289: WHERE set_of_books_id = gbl_set_of_books_id
290: AND fiscal_year = gbl_period_year;
291: fv_utility.log_mesg('Deleted '||SQL%ROWCOUNT ||' recs from fv_facts_ending_balances.');
292: COMMIT;

Line 291: fv_utility.log_mesg('Deleted '||SQL%ROWCOUNT ||' recs from fv_facts_ending_balances.');

287:
288: DELETE FROM fv_facts_ending_balances
289: WHERE set_of_books_id = gbl_set_of_books_id
290: AND fiscal_year = gbl_period_year;
291: fv_utility.log_mesg('Deleted '||SQL%ROWCOUNT ||' recs from fv_facts_ending_balances.');
292: COMMIT;
293: END IF;
294: create_end_bal_record;
295: END IF;

Line 1600: INSERT INTO FV_FACTS_ENDING_BALANCES

1596:
1597: l_module_name := g_module_name || 'CREATE_END_BAL_RECORD';
1598: FV_UTILITY.LOG_MESG('In '||l_module_name);
1599:
1600: INSERT INTO FV_FACTS_ENDING_BALANCES
1601: (fund_group,
1602: account_number,
1603: dept_id,
1604: bureau_id,

Line 1656: fv_utility.log_mesg('Inserted '||SQL%ROWCOUNT ||' recs into fv_facts_ending_balances.');

1652: t2.cust_non_cust, t2.budget_subfunction, t2.d_c_indicator,
1653: t2.fund_value, t2.ccid, t2.account_type, t2.recipient_name
1654: HAVING SUM(NVL(amount,0)) <> 0) ;
1655:
1656: fv_utility.log_mesg('Inserted '||SQL%ROWCOUNT ||' recs into fv_facts_ending_balances.');
1657:
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: gbl_error_code := -1;

Line 2803: FROM fv_facts_ending_balances

2799: l_stage := 'Ending balance diff';
2800:
2801: SELECT NVL(SUM(amount), 0)
2802: INTO l_ending_amount
2803: FROM fv_facts_ending_balances
2804: WHERE ccid = l_ccid_l(i)
2805: AND set_of_books_id = gbl_set_of_books_id
2806: AND fiscal_year = (gbl_fiscal_year - 1)
2807: AND record_category = 'ENDING_BAL'