eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_GTAS_INTERFACE dependencies on FV_FUND_PARAMETERS

Line 148: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;

144: RETURN VARCHAR2;
145: PROCEDURE print_header;
146: PROCEDURE del_disabled_accts(p_acct_num IN VARCHAR2);
147:
148: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;
149: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;
150: gbl_period_num Gl_Balances.period_num%TYPE;
151: gbl_period_year gl_period_statuses.period_year%TYPE;
152:

Line 149: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;

145: PROCEDURE print_header;
146: PROCEDURE del_disabled_accts(p_acct_num IN VARCHAR2);
147:
148: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;
149: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;
150: gbl_period_num Gl_Balances.period_num%TYPE;
151: gbl_period_year gl_period_statuses.period_year%TYPE;
152:
153: g_Treasury_Symbol_Low_id number(15);

Line 705: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;

701: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
702:
703: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
704:
705: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
706: l_Bea_Category fv_fund_parameters.Bea_Category%type;
707: l_appor_cat fv_fund_parameters.fund_category%type;
708: l_c_nc fv_fund_parameters.cust_non_cust%type;
709: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;

Line 706: l_Bea_Category fv_fund_parameters.Bea_Category%type;

702:
703: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
704:
705: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
706: l_Bea_Category fv_fund_parameters.Bea_Category%type;
707: l_appor_cat fv_fund_parameters.fund_category%type;
708: l_c_nc fv_fund_parameters.cust_non_cust%type;
709: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;
710: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;

Line 707: l_appor_cat fv_fund_parameters.fund_category%type;

703: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
704:
705: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
706: l_Bea_Category fv_fund_parameters.Bea_Category%type;
707: l_appor_cat fv_fund_parameters.fund_category%type;
708: l_c_nc fv_fund_parameters.cust_non_cust%type;
709: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;
710: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
711: l_Financing_Account fv_Treasury_symbols.financing_account%type;

Line 708: l_c_nc fv_fund_parameters.cust_non_cust%type;

704:
705: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
706: l_Bea_Category fv_fund_parameters.Bea_Category%type;
707: l_appor_cat fv_fund_parameters.fund_category%type;
708: l_c_nc fv_fund_parameters.cust_non_cust%type;
709: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;
710: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
711: l_Financing_Account fv_Treasury_symbols.financing_account%type;
712: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;

Line 709: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;

705: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
706: l_Bea_Category fv_fund_parameters.Bea_Category%type;
707: l_appor_cat fv_fund_parameters.fund_category%type;
708: l_c_nc fv_fund_parameters.cust_non_cust%type;
709: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;
710: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
711: l_Financing_Account fv_Treasury_symbols.financing_account%type;
712: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;
713: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;

Line 710: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;

706: l_Bea_Category fv_fund_parameters.Bea_Category%type;
707: l_appor_cat fv_fund_parameters.fund_category%type;
708: l_c_nc fv_fund_parameters.cust_non_cust%type;
709: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;
710: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
711: l_Financing_Account fv_Treasury_symbols.financing_account%type;
712: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;
713: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
714: select_stmt VARCHAR2(10000);

Line 769: From Fv_Fund_Parameters fp,

765: into l_treasury_symbol_id, l_Outlays_Bea_Category_Code,
766: l_Bea_Category, l_appor_cat,
767: l_c_nc, l_bsc,
768: l_drc, l_financing_account
769: From Fv_Fund_Parameters fp,
770: fv_treasury_symbols tas
771: Where fp.Fund_Value = P_Fund_Value
772: AND fp.set_of_books_id = gbl_set_of_books_id
773: AND fp.treasury_symbol_id = tas.treasury_symbol_id;

Line 1337: From Fv_Fund_Parameters

1333: cv_sob_id IN NUMBER) IS
1334: SELECT fund_value,
1335: fund_category,
1336: treasury_symbol_id
1337: From Fv_Fund_Parameters
1338: WHERE fund_value = p_fund_value
1339: AND set_of_books_id = p_sob_id;
1340:
1341: --vl_ts_id NUMBER;

Line 1342: vl_fund_value fv_fund_parameters.fund_value%TYPE;

1338: WHERE fund_value = p_fund_value
1339: AND set_of_books_id = p_sob_id;
1340:
1341: --vl_ts_id NUMBER;
1342: vl_fund_value fv_fund_parameters.fund_value%TYPE;
1343: vl_treasury_symbol_id NUMBER;
1344: vl_fund_category VARCHAR2(1);
1345: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
1346: Vl_Prc_Header_Id Number;

Line 1826: --fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;

1822: TYPE l_balance_amoun_t is table of number;
1823: TYPE l_ccid_t is table of number(15);
1824: TYPE l_rowid_t is table of ROWID;
1825: TYPE l_DIRECT_OR_REIMB_CODE_t is table of varchar2(1);
1826: --fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1827: TYPE l_APPOR_CAT_CODE_t is table of varchar2(1);
1828: --fv_fund_parameters.fund_category%type;
1829: TYPE l_APPOR_CAT_B_CODE_t is table of varchar2(4);
1830: --fv_facts_prc_Dtl.reporting_code%type;

Line 1828: --fv_fund_parameters.fund_category%type;

1824: TYPE l_rowid_t is table of ROWID;
1825: TYPE l_DIRECT_OR_REIMB_CODE_t is table of varchar2(1);
1826: --fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1827: TYPE l_APPOR_CAT_CODE_t is table of varchar2(1);
1828: --fv_fund_parameters.fund_category%type;
1829: TYPE l_APPOR_CAT_B_CODE_t is table of varchar2(4);
1830: --fv_facts_prc_Dtl.reporting_code%type;
1831: TYPE l_PROGRAM_REPT_CODE_t is table of varchar2(4);
1832: --fv_facts_prc_Dtl.reporting_code%type;

Line 1834: --fv_fund_parameters.BEA_CATEGORY%type;

1830: --fv_facts_prc_Dtl.reporting_code%type;
1831: TYPE l_PROGRAM_REPT_CODE_t is table of varchar2(4);
1832: --fv_facts_prc_Dtl.reporting_code%type;
1833: TYPE l_BEA_CAT_CODE_t is table of varchar2(1);
1834: --fv_fund_parameters.BEA_CATEGORY%type;
1835: TYPE l_BORR_SRC_CODE_t is table of varchar2(1);
1836: --fv_fund_parameters.BORROWING_SOURCE_CODE%type;
1837: TYPE l_NEW_BAL_CODE_t is table of VARCHAR2(3) ;
1838: TYPE l_CUR_SUBSEQUENT_CODE_t is table of VARCHAR2(4) ;

Line 1836: --fv_fund_parameters.BORROWING_SOURCE_CODE%type;

1832: --fv_facts_prc_Dtl.reporting_code%type;
1833: TYPE l_BEA_CAT_CODE_t is table of varchar2(1);
1834: --fv_fund_parameters.BEA_CATEGORY%type;
1835: TYPE l_BORR_SRC_CODE_t is table of varchar2(1);
1836: --fv_fund_parameters.BORROWING_SOURCE_CODE%type;
1837: TYPE l_NEW_BAL_CODE_t is table of VARCHAR2(3) ;
1838: TYPE l_CUR_SUBSEQUENT_CODE_t is table of VARCHAR2(4) ;
1839: TYPE l_PYA_CODE_t is table of VARCHAR2(4) ;
1840: TYPE l_CREDIT_COHORT_YR_t is table of VARCHAR2(150);

Line 1919: l_DIRECT_OR_REIMB_CODE fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;

1915: l_account_type VARCHAR2(1);
1916: l_balance_amount number;
1917: l_curr_year_bal number;
1918: l_ccid number(15);
1919: l_DIRECT_OR_REIMB_CODE fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1920: l_APPOR_CAT_CODE fv_fund_parameters.fund_category%type;
1921: l_APPOR_CAT_B_CODE fv_facts_prc_Dtl.reporting_code%type;
1922: l_PROGRAM_REPT_CODE fv_facts_prc_Dtl.reporting_code%type;
1923: l_BEA_CAT_CODE fv_fund_parameters.BEA_CATEGORY%type;

Line 1920: l_APPOR_CAT_CODE fv_fund_parameters.fund_category%type;

1916: l_balance_amount number;
1917: l_curr_year_bal number;
1918: l_ccid number(15);
1919: l_DIRECT_OR_REIMB_CODE fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1920: l_APPOR_CAT_CODE fv_fund_parameters.fund_category%type;
1921: l_APPOR_CAT_B_CODE fv_facts_prc_Dtl.reporting_code%type;
1922: l_PROGRAM_REPT_CODE fv_facts_prc_Dtl.reporting_code%type;
1923: l_BEA_CAT_CODE fv_fund_parameters.BEA_CATEGORY%type;
1924: l_BORR_SRC_CODE fv_fund_parameters.BORROWING_SOURCE_CODE%type;

Line 1923: l_BEA_CAT_CODE fv_fund_parameters.BEA_CATEGORY%type;

1919: l_DIRECT_OR_REIMB_CODE fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1920: l_APPOR_CAT_CODE fv_fund_parameters.fund_category%type;
1921: l_APPOR_CAT_B_CODE fv_facts_prc_Dtl.reporting_code%type;
1922: l_PROGRAM_REPT_CODE fv_facts_prc_Dtl.reporting_code%type;
1923: l_BEA_CAT_CODE fv_fund_parameters.BEA_CATEGORY%type;
1924: l_BORR_SRC_CODE fv_fund_parameters.BORROWING_SOURCE_CODE%type;
1925: l_NEW_BAL_CODE VARCHAR2(3) ;
1926: l_CUR_SUBSEQUENT_CODE VARCHAR2(4) ;
1927: l_PYA_CODE VARCHAR2(4) ;

Line 1924: l_BORR_SRC_CODE fv_fund_parameters.BORROWING_SOURCE_CODE%type;

1920: l_APPOR_CAT_CODE fv_fund_parameters.fund_category%type;
1921: l_APPOR_CAT_B_CODE fv_facts_prc_Dtl.reporting_code%type;
1922: l_PROGRAM_REPT_CODE fv_facts_prc_Dtl.reporting_code%type;
1923: l_BEA_CAT_CODE fv_fund_parameters.BEA_CATEGORY%type;
1924: l_BORR_SRC_CODE fv_fund_parameters.BORROWING_SOURCE_CODE%type;
1925: l_NEW_BAL_CODE VARCHAR2(3) ;
1926: l_CUR_SUBSEQUENT_CODE VARCHAR2(4) ;
1927: l_PYA_CODE VARCHAR2(4) ;
1928: l_CREDIT_COHORT_YR VARCHAR2(150);

Line 2025: from fv_fund_parameters ffp,

2021: AND glb.currency_code <> ''STAT''
2022: AND glc.code_combination_id = glb.code_combination_id
2023: AND glc.'||gbl_bal_segment_name||' in
2024: (select ffp.fund_value
2025: from fv_fund_parameters ffp,
2026: fv_treasury_symbols fts
2027: where fts.treasury_symbol_id = ffp.treasury_symbol_id
2028: and fts.set_of_books_id = '||gbl_set_of_books_id||
2029: ' and fts.gtas_reportable_indicator = ''Y'' '