[Home] [Help]
8: vp_retcode NUMBER ;
9: vp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE ;
10: vp_report_fiscal_yr NUMBER(4) ;
11: vp_report_qtr NUMBER(1) ;
12: vp_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE ;
13: vp_run_mode VARCHAR2(1) ;
14: vp_currency_code VARCHAR2(15) ;
15: vp_contact_fname VARCHAR2(20) ;
16: vp_contact_lname VARCHAR2(30) ;
78: -- ========================================================================
79: v_period_num gl_period_statuses.period_num%TYPE ;
80: --v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
81: v_year_gtn2001 BOOLEAN ;
82: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
83: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;
84: v_acc_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
85: v_bal_seg_name VARCHAR2(20);
86: v_acc_seg_name VARCHAR2(20);
84: v_acc_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
85: v_bal_seg_name VARCHAR2(20);
86: v_acc_seg_name VARCHAR2(20);
87: v_fyr_segment_name VARCHAR2(20);
88: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
89: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
90: v_cohort_seg_name VARCHAR2(20) ;
91: v_period_name gl_period_statuses.period_name%TYPE ;
92: v_period_start_dt DATE ;
256: CURSOR facts_record IS
257: SELECT fv_facts_submission.rowid,
258: fv_facts_submission.Set_Of_Books_Id ,
259: fv_facts_submission.Run_Mode,
260: fv_treasury_symbols.Treasury_Symbol,
261: fv_facts_submission.rep_fyr ,
262: fv_facts_submission.rep_period_num,
263: fv_facts_submission.first_name,
264: fv_facts_submission.last_name,
279: fv_facts_submission.zip ,
280: fv_facts_submission.currency_code,
281: fv_facts_submission.treasury_symbol_id
282: FROM fv_facts_submission ,
283: fv_treasury_symbols
284: WHERE submit_flag = 'Y'
285: AND fv_treasury_symbols.set_of_books_id = sob
286: AND fv_facts_submission.set_of_books_id = sob
287: AND fv_facts_submission.treasury_symbol_id =
281: fv_facts_submission.treasury_symbol_id
282: FROM fv_facts_submission ,
283: fv_treasury_symbols
284: WHERE submit_flag = 'Y'
285: AND fv_treasury_symbols.set_of_books_id = sob
286: AND fv_facts_submission.set_of_books_id = sob
287: AND fv_facts_submission.treasury_symbol_id =
288: fv_treasury_symbols.treasury_symbol_id;
289:
284: WHERE submit_flag = 'Y'
285: AND fv_treasury_symbols.set_of_books_id = sob
286: AND fv_facts_submission.set_of_books_id = sob
287: AND fv_facts_submission.treasury_symbol_id =
288: fv_treasury_symbols.treasury_symbol_id;
289:
290:
291: BEGIN
292: retcode := 0;
731: BEGIN
732: l_module_name := g_module_name || 'load_treasury_symbol_id';
733: SELECT treasury_symbol_id
734: INTO v_treasury_symbol_id
735: FROM fv_treasury_symbols
736: WHERE treasury_symbol = vp_treasury_symbol
737: AND set_of_books_id = vp_set_of_books_id ;
738:
739: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
927: vl_years_available,
928: vc_dept_transfer
929: FROM
930: fv_facts_federal_accounts fffa,
931: fv_treasury_symbols fts
932: WHERE fffa.federal_acct_symbol_id = fts.federal_acct_symbol_id
933: AND fts.treasury_symbol = vp_treasury_symbol
934: AND fts.set_of_books_id = vp_set_of_books_id
935: AND fffa.set_of_books_id = vp_set_of_books_id ;
1198: das_id NUMBER;
1199: das_where VARCHAR2(600);
1200:
1201: CURSOR footnote_select
1202: (p_tsymbol_id fv_treasury_symbols.treasury_symbol_id%TYPE)
1203: IS
1204: SELECT treasury_symbol_id,
1205: sgl_acct_number
1206: FROM fv_facts_temp
1252: v_cohort_select ||
1253: ' FROM GL_BALANCES GLB,
1254: GL_CODE_COMBINATIONS GLCC,
1255: FV_FUND_PARAMETERS FFP,
1256: FV_TREASURY_SYMBOLS FTS
1257: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1258: AND GLB.code_combination_id = GLCC.code_combination_id
1259: AND glb.actual_flag = :actual_flag
1260: AND FTS.TREASURY_SYMBOL_ID = FFP.TREASURY_SYMBOL_ID
1289: glb.period_net_dr - glb.period_net_cr,0)) end_amount
1290: FROM GL_BALANCES GLB,
1291: GL_CODE_COMBINATIONS GLCC,
1292: FV_FUND_PARAMETERS FFP,
1293: FV_TREASURY_SYMBOLS FTS
1294: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1295: AND FTS.SET_OF_BOOKS_ID = :set_of_books_id
1296: AND FFP.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
1297: AND FFP.SET_OF_BOOKS_ID = :set_of_books_id
3789: ffp.fund_category
3790: INTO vl_resource_type,
3791: va_def_indef_val,
3792: vl_fund_category
3793: FROM fv_treasury_symbols fts,
3794: fv_fund_parameters ffp
3795: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
3796: AND ffp.fund_value = fund_val
3797: AND fts.treasury_symbol = vp_treasury_symbol
3933:
3934: /*
3935: FROM fv_facts_budget_accounts ffba,
3936: fv_facts_federal_accounts fffa,
3937: fv_treasury_symbols fts ,
3938: fv_facts_bud_fed_accts ffbfa
3939: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
3940: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
3941: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id
3979: SELECT RPAD(substr(ffba.budget_function,1,3), 3)
3980: INTO va_budget_function
3981: FROM fv_facts_budget_accounts ffba,
3982: fv_facts_federal_accounts fffa,
3983: fv_treasury_symbols fts ,
3984: fv_facts_bud_fed_accts ffbfa
3985: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
3986: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
3987: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id
4024: SELECT RPAD(substr(ffba.borrowing_source,1,6), 6)
4025: INTO va_borrowing_source_val
4026: FROM fv_facts_budget_accounts ffba,
4027: fv_facts_federal_accounts fffa,
4028: fv_treasury_symbols fts ,
4029: fv_facts_bud_fed_accts ffbfa
4030: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4031: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
4032: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id