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_TREASURY_SYMBOLS

Line 52: gbl_agency_id_low fv_treasury_symbols.department_id%TYPE;

48: vg_bud_impact_ind_flag VARCHAR2(1);
49: vg_trading_partner_flag VARCHAR2(1);
50: g_is_acct_parent VARCHAR2(1);
51: gbl_reporting_period NUMBER;
52: gbl_agency_id_low fv_treasury_symbols.department_id%TYPE;
53: gbl_agency_id_high fv_treasury_symbols.department_id%TYPE;
54: gbl_main_account_low fv_treasury_symbols.fund_group_code%TYPE;
55: gbl_main_account_high fv_treasury_symbols.fund_group_code%TYPE;
56:

Line 53: gbl_agency_id_high fv_treasury_symbols.department_id%TYPE;

49: vg_trading_partner_flag VARCHAR2(1);
50: g_is_acct_parent VARCHAR2(1);
51: gbl_reporting_period NUMBER;
52: gbl_agency_id_low fv_treasury_symbols.department_id%TYPE;
53: gbl_agency_id_high fv_treasury_symbols.department_id%TYPE;
54: gbl_main_account_low fv_treasury_symbols.fund_group_code%TYPE;
55: gbl_main_account_high fv_treasury_symbols.fund_group_code%TYPE;
56:
57: --------------------------------------------------------------------------------

Line 54: gbl_main_account_low fv_treasury_symbols.fund_group_code%TYPE;

50: g_is_acct_parent VARCHAR2(1);
51: gbl_reporting_period NUMBER;
52: gbl_agency_id_low fv_treasury_symbols.department_id%TYPE;
53: gbl_agency_id_high fv_treasury_symbols.department_id%TYPE;
54: gbl_main_account_low fv_treasury_symbols.fund_group_code%TYPE;
55: gbl_main_account_high fv_treasury_symbols.fund_group_code%TYPE;
56:
57: --------------------------------------------------------------------------------
58: PROCEDURE get_segment_names;

Line 55: gbl_main_account_high fv_treasury_symbols.fund_group_code%TYPE;

51: gbl_reporting_period NUMBER;
52: gbl_agency_id_low fv_treasury_symbols.department_id%TYPE;
53: gbl_agency_id_high fv_treasury_symbols.department_id%TYPE;
54: gbl_main_account_low fv_treasury_symbols.fund_group_code%TYPE;
55: gbl_main_account_high fv_treasury_symbols.fund_group_code%TYPE;
56:
57: --------------------------------------------------------------------------------
58: PROCEDURE get_segment_names;
59: Procedure Submit_Exception_Report;

Line 711: l_Financing_Account fv_Treasury_symbols.financing_account%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);
715: Vl_Cursor Integer;

Line 718: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;

714: select_stmt VARCHAR2(10000);
715: Vl_Cursor Integer;
716: Vl_Prc_Val Varchar2(4);
717: I integer;
718: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;
719: l_Acct_Num Varchar2(8);
720: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;
721: l_dir_or_reimb_flag fv_gtas_attributes.direct_or_reimb_flag%TYPE;
722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;

Line 770: fv_treasury_symbols tas

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;
774:

Line 1844: --fv_treasury_symbols.treasury_symbol_id%type;

1840: TYPE l_CREDIT_COHORT_YR_t is table of VARCHAR2(150);
1841: TYPE l_PROGRAM_COST_IND_t is table of VARCHAR2(4) ;
1842: --fv_facts_prc_Dtl.reporting_code%type;
1843: TYPE l_TREASURY_SYMBOL_ID_t is table of number(15);
1844: --fv_treasury_symbols.treasury_symbol_id%type;
1845:
1846: -- individual entries
1847: l_account_number_L l_account_number_t ;
1848: l_end_bal_ind_l l_end_bal_ind_t;

Line 1930: l_tREASURY_SYMBOL_ID fv_treasury_symbols.treasury_symbol_id%type;

1926: l_CUR_SUBSEQUENT_CODE VARCHAR2(4) ;
1927: l_PYA_CODE VARCHAR2(4) ;
1928: l_CREDIT_COHORT_YR VARCHAR2(150);
1929: l_PROGRAM_COST_IND fv_facts_prc_Dtl.reporting_code%type;
1930: l_tREASURY_SYMBOL_ID fv_treasury_symbols.treasury_symbol_id%type;
1931: l_account_number_prv VARCHAR2(30);
1932: l_t2_detail_amount NUMBER;
1933: l_fed_account VARCHAR2(1);
1934: l_amount NUMBER;

Line 2026: fv_treasury_symbols fts

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'' '
2030: ||l_aid_condition||l_main_account_condition