APPS.FV_FACTS1_PKG dependencies on FV_FACTS1_DIFF_BALANCES

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

1679: DELETE FROM fv_facts_report_t2
1680: WHERE set_of_books_id = gbl_set_of_books_id;
1681:
1682: /** cleanup the line balance differrence records */
1683: FV_UTILITY.LOG_MESG('Deleting from fv_facts1_diff_balances for Period Year: '||
1684: gbl_period_year);
1685:
1686: DELETE FROM fv_facts1_diff_balances
1687: WHERE set_of_books_id = gbl_set_of_books_id

Line 1686: DELETE FROM fv_facts1_diff_balances

1682: /** cleanup the line balance differrence records */
1683: FV_UTILITY.LOG_MESG('Deleting from fv_facts1_diff_balances for Period Year: '||
1684: gbl_period_year);
1685:
1686: DELETE FROM fv_facts1_diff_balances
1687: WHERE set_of_books_id = gbl_set_of_books_id
1688: and period_year = gbl_period_year
1689: and balance_type = 'D';
1690:

Line 1692: ' records from fv_facts1_diff_balances.');

1688: and period_year = gbl_period_year
1689: and balance_type = 'D';
1690:
1691: FV_UTILITY.LOG_MESG('Deleted '||SQL%ROWCOUNT||
1692: ' records from fv_facts1_diff_balances.');
1693:
1694: EXCEPTION
1695: WHEN OTHERS THEN
1696: gbl_error_code := -1 ;

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

2421: and fiscal_year = gbl_fiscal_year;
2422:
2423: -- To delete the erroneous record
2424: fnd_file.put_line(fnd_file.log,
2425: 'Deleting the begin balance difference records from fv_facts1_diff_balances.');
2426:
2427: if l_diff_flag = 'N' then
2428: DELETE FROM fv_facts1_diff_balances
2429: WHERE set_of_books_id = gbl_set_of_books_id

Line 2428: DELETE FROM fv_facts1_diff_balances

2424: fnd_file.put_line(fnd_file.log,
2425: 'Deleting the begin balance difference records from fv_facts1_diff_balances.');
2426:
2427: if l_diff_flag = 'N' then
2428: DELETE FROM fv_facts1_diff_balances
2429: WHERE set_of_books_id = gbl_set_of_books_id
2430: and period_year = gbl_fiscal_year
2431: and balance_type = 'B';
2432: end if;

Line 2770: INSERT INTO fv_facts1_diff_balances

2766: l_budget_subfunction, l_fund_value,
2767: 0, l_ccid_l(i), l_account_type,
2768: 'Other', 0, 0);
2769:
2770: INSERT INTO fv_facts1_diff_balances
2771: (
2772: ccid,period_num,period_year,set_of_books_id,
2773: eliminations_dept,
2774: g_ng_indicator,

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

2787: 'D','Other', l_account_number, l_fund_value);
2788: END IF;
2789:
2790: -------------------------------------------------------------------------
2791: -- Populate fv_facts1_diff_balances with previous year's ending balance
2792: -- and create a difference record
2793:
2794: /* check the begin_balance record been created , if not run it */
2795:

Line 2828: INSERT INTO fv_facts1_diff_balances

2824: l_budget_subfunction, l_fund_value,
2825: 0, l_ccid_l(i), l_account_type,
2826: 'Other', 0, 0);
2827:
2828: INSERT INTO fv_facts1_diff_balances
2829: (ccid,period_num,period_year,set_of_books_id,
2830: eliminations_dept,
2831: g_ng_indicator,
2832: amount,