[Home] [Help]
22: vp_certifier_id Varchar2(8) ;
23: vp_report_fiscal_yr number(4) ;
24: vp_report_qtr number(1) ;
25: vp_currency_code Varchar2(15) ;
26: vp_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE ;
27: vp_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
28: vp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE ;
29: vp_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
30: vp_summary_type varchar2(1) ;
23: vp_report_fiscal_yr number(4) ;
24: vp_report_qtr number(1) ;
25: vp_currency_code Varchar2(15) ;
26: vp_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE ;
27: vp_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
28: vp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE ;
29: vp_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
30: vp_summary_type varchar2(1) ;
31: vp_fund_low fv_fund_parameters.fund_value%type ;
133: v_period_cr Number ;
134: v_period_dr Number ;
135: vl_retcode Number ;
136: v_begin_amount number ;
137: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
138: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
139: v_fiscal_yr Varchar2(25);
140: v_segment varchar2(30);
141: v_year_gtn2001 BOOLEAN ;
138: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
139: v_fiscal_yr Varchar2(25);
140: v_segment varchar2(30);
141: v_year_gtn2001 BOOLEAN ;
142: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
143: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
144: v_year_budget_auth VARCHAR2(3);
145: v_tbal_run_flag Varchar2(1) ;
146: v_tbal_indicator FV_FACTS_TEMP.TBAL_INDICATOR%TYPE ;
554: vl_years_available,
555: vc_dept_transfer
556: From
557: FV_FACTS_FEDERAL_ACCOUNTS FFFA,
558: FV_TREASURY_SYMBOLS FTS
559: Where FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
560: AND FTS.treasury_symbol = vp_treasury_symbol
561: AND FTS.set_of_books_id = vp_set_of_books_id
562: AND FFFA.set_of_books_id = vp_set_of_books_id ;
2002: INTO vl_resource_type,
2003: va_def_indef_val,
2004: vl_fund_category,
2005: va_bea_category_val
2006: From fv_treasury_symbols fts,
2007: fv_fund_parameters ffp
2008: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
2009: AND ffp.fund_value = fund_val
2010: AND fts.treasury_symbol = vp_treasury_symbol
2121:
2122: From fv_facts_budget_accounts ffba,
2123:
2124: fv_facts_federal_accounts fffa,
2125: fv_treasury_symbols fts ,
2126: fv_facts_bud_fed_accts ffbfa
2127: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2128: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
2129: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id
2150: Select RPAD(substr(ffba.budget_function,1,3), 3)
2151: Into va_budget_function
2152: From fv_facts_budget_accounts ffba,
2153: fv_facts_federal_accounts fffa,
2154: fv_treasury_symbols fts ,
2155: fv_facts_bud_fed_accts ffbfa
2156: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2157: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
2158: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id
2177: Select RPAD(substr(ffba.borrowing_source,1,6), 6)
2178: Into va_borrowing_source_val
2179: From fv_facts_budget_accounts ffba,
2180: fv_facts_federal_accounts fffa,
2181: fv_treasury_symbols fts ,
2182: fv_facts_bud_fed_accts ffbfa
2183: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2184: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
2185: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id
2955: l_module_name VARCHAR2(200) := g_module_name || 'Load_Treasury_Symbol_Id';
2956: Begin
2957: Select Treasury_Symbol_id
2958: Into v_treasury_symbol_id
2959: From fv_treasury_symbols
2960: where treasury_symbol = vp_treasury_symbol
2961: and set_of_books_id = vp_set_of_books_id ;
2962: Exception
2963: WHEN NO_DATA_FOUND Then
3313: BEGIN
3314: --Getting the Treasury Symbol value
3315: Select treasury_symbol
3316: Into vp_treasury_symbol
3317: From fv_treasury_symbols
3318: Where treasury_symbol_id = (Select treasury_symbol_id
3319: From fv_fund_parameters
3320: Where fund_value = C_Get_Fund_Values_Rec.flex_value
3321: And set_of_books_id = vp_set_of_books_id);