APPS.FV_UPG_FACTS_EB_TO_GTAS dependencies on FV_GTAS_ENDING_BALANCES

Line 46: 'Deleting from fv_gtas_ending_balances table.');

42: g_fiscal_year := p_fiscal_year;
43: log(l_module, 'g_fiscal_year: ' || g_fiscal_year);
44: --Deleting any existing rows in gtas ending bal table
45: fnd_file.put_line(fnd_file.log,
46: 'Deleting from fv_gtas_ending_balances table.');
47:
48: --IF there are no rows in facts 1 and facts 2 ending
49: --balances table, then error and return
50: SELECT count(*)

Line 66: DELETE FROM fv_gtas_ending_balances;

62: p_err_buff := 'No Facts 1 and Facts 2 ending balances found to migrate.';
63: RETURN;
64: END IF;
65:
66: DELETE FROM fv_gtas_ending_balances;
67:
68: IF g_err_code = 0 THEN
69: process_facts1_eb;
70: END IF;

Line 113: from fv_gtas_ending_balances

109: SET_OF_BOOKS_ID||'',''||FISCAL_YEAR||'',''||CCID||'',''||FUND_VALUE||'',''||
110: ACCOUNT_NUMBER||'',''||D_C_INDICATOR||'',''||AUTHORITY_TYPE_CODE||'',''||
111: FED_NON_FED||'',''||TRADING_PARTNER_AGENCY_ID||'',''||
112: TRADING_PARTNER_MAIN_ACCOUNT||'',''||AMOUNT
113: from fv_gtas_ending_balances
114: order by 1';
115: fv_flatfiles.create_flat_file(l_statement);
116:
117: log(l_module, 'End');

Line 585: INSERT INTO fv_gtas_ending_balances

581: NVL(f1_eb_rec.eliminations_dept, 'BLANK'));
582: END;
583: END IF;
584:
585: INSERT INTO fv_gtas_ending_balances
586: (set_of_books_id,
587: fiscal_year,
588: ccid,
589: fund_value,

Line 831: INSERT INTO fv_gtas_ending_balances

827: l_main_account := NULL;
828: END IF;
829: END IF;
830:
831: INSERT INTO fv_gtas_ending_balances
832: (set_of_books_id,
833: fiscal_year,
834: ccid,
835: fund_value,

Line 898: l_fund_value fv_gtas_ending_balances.fund_value%TYPE;

894: l_prev_sob_id NUMBER;
895: TYPE l_ref_cur IS REF CURSOR;
896: gl_record l_ref_cur;
897: l_ccid NUMBER;
898: l_fund_value fv_gtas_ending_balances.fund_value%TYPE;
899: l_account_number fv_gtas_ending_balances.account_number%TYPE;
900: l_amount NUMBER;
901:
902: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;

Line 899: l_account_number fv_gtas_ending_balances.account_number%TYPE;

895: TYPE l_ref_cur IS REF CURSOR;
896: gl_record l_ref_cur;
897: l_ccid NUMBER;
898: l_fund_value fv_gtas_ending_balances.fund_value%TYPE;
899: l_account_number fv_gtas_ending_balances.account_number%TYPE;
900: l_amount NUMBER;
901:
902: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;
903: l_ussgl_acct_number fv_gtas_attributes.ussgl_acct_number%TYPE;

Line 1083: INSERT INTO fv_gtas_ending_balances

1079: ELSE
1080: l_d_c_indicator := 'C';
1081: END IF;
1082:
1083: INSERT INTO fv_gtas_ending_balances
1084: (set_of_books_id,
1085: fiscal_year,
1086: ccid,
1087: fund_value,