DBA Data[Home] [Help]

APPS.FV_GTAS_AGENCY_ID_UPGRADE dependencies on FV_FACTS_BUD_FED_ACCTS

Line 639: DELETE FROM fv_facts_bud_fed_accts;

635: -----------------------------------------------------------------------------------
636: PROCEDURE UPGRADE_BUDGET_CODES IS
637:
638: BEGIN
639: DELETE FROM fv_facts_bud_fed_accts;
640: DELETE FROM fv_facts_budget_accounts;
641:
642: fnd_file.put_line(fnd_file.log, 'Deleted all records FROM fv_facts_bud_fed_accts AND fv_facts_budget_accounts');
643: EXCEPTION

Line 642: fnd_file.put_line(fnd_file.log, 'Deleted all records FROM fv_facts_bud_fed_accts AND fv_facts_budget_accounts');

638: BEGIN
639: DELETE FROM fv_facts_bud_fed_accts;
640: DELETE FROM fv_facts_budget_accounts;
641:
642: fnd_file.put_line(fnd_file.log, 'Deleted all records FROM fv_facts_bud_fed_accts AND fv_facts_budget_accounts');
643: EXCEPTION
644: WHEN OTHERS THEN
645: g_err_buff := 'When Others Error: '||SQLERRM;
646: g_err_code := sqlcode;

Line 1053: DELETE FROM fv_facts_bud_fed_accts;

1049: END;
1050:
1051: --7)Update Budget Codes Table
1052: BEGIN
1053: DELETE FROM fv_facts_bud_fed_accts;
1054: DELETE FROM fv_facts_budget_accounts;
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: FND_FILE.PUT_LINE(FND_FILE.LOG,