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_FACTS1_PKG dependencies on FV_TREASURY_SYMBOLS

Line 110: gbl_treasury_symbol_id FV_Treasury_Symbols.treasury_symbol_id%TYPE;

106: PROCEDURE journal_processes;
107: PROCEDURE rollup_process;
108: -- Global Variables for Trial Balance processing
109: gbl_trial_balance_type Varchar2(1) := NULL;
110: gbl_treasury_symbol_id FV_Treasury_Symbols.treasury_symbol_id%TYPE;
111: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;
112: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;
113: gbl_period_num Gl_Balances.period_num%TYPE;
114: gbl_period_year gl_period_statuses.period_year%TYPE;

Line 685: l_fund_group fv_treasury_symbols.fund_group_code%type;

681: IS
682: l_module_name VARCHAR2(200);
683: cnt BINARY_INTEGER := 0;
684: l_hash BINARY_INTEGER := 0;
685: l_fund_group fv_treasury_symbols.fund_group_code%type;
686: l_fund_val fv_fund_parameters.fund_value%TYPE;
687: l_dept_id fv_treasury_symbols.department_id%TYPE;
688: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
689: ln_fund_group_type fv_fund_groups.type%type ;

Line 687: l_dept_id fv_treasury_symbols.department_id%TYPE;

683: cnt BINARY_INTEGER := 0;
684: l_hash BINARY_INTEGER := 0;
685: l_fund_group fv_treasury_symbols.fund_group_code%type;
686: l_fund_val fv_fund_parameters.fund_value%TYPE;
687: l_dept_id fv_treasury_symbols.department_id%TYPE;
688: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
689: ln_fund_group_type fv_fund_groups.type%type ;
690: -- CGAC
691: ln_facts1_rollup fv_facts_federal_accounts.facts1_rollup%TYPE;

Line 688: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;

684: l_hash BINARY_INTEGER := 0;
685: l_fund_group fv_treasury_symbols.fund_group_code%type;
686: l_fund_val fv_fund_parameters.fund_value%TYPE;
687: l_dept_id fv_treasury_symbols.department_id%TYPE;
688: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
689: ln_fund_group_type fv_fund_groups.type%type ;
690: -- CGAC
691: ln_facts1_rollup fv_facts_federal_accounts.facts1_rollup%TYPE;
692: ln_federal_acct_symbol_id fv_treasury_symbols.federal_acct_symbol_id%TYPE;

Line 692: ln_federal_acct_symbol_id fv_treasury_symbols.federal_acct_symbol_id%TYPE;

688: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
689: ln_fund_group_type fv_fund_groups.type%type ;
690: -- CGAC
691: ln_facts1_rollup fv_facts_federal_accounts.facts1_rollup%TYPE;
692: ln_federal_acct_symbol_id fv_treasury_symbols.federal_acct_symbol_id%TYPE;
693:
694: -- Retrieiving federal_acct_symbol_id to use it to obtain facts1_rollup
695: -- from fv_facts_federal_accounts in facts1_rollup_cur cursor
696: CURSOR fund_cur IS

Line 699: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

695: -- from fv_facts_federal_accounts in facts1_rollup_cur cursor
696: CURSOR fund_cur IS
697: SELECT ffp.fund_value fund_val, fts.fund_group_code fund_grp,
698: fts.department_id dep_id, fts.bureau_id bu_id, fts.federal_acct_symbol_id
699: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
700: WHERE ffp.set_of_books_id = gbl_set_of_books_id
701: AND fts.treasury_symbol_id = ffp.treasury_symbol_id;
702:
703: BEGIN

Line 1098: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

1094: IF (l_c_nc_ind = 'Y') THEN
1095: /*
1096: SELECT 'X', fts.cust_non_cust
1097: INTO l_row_exists, l_c_nc
1098: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
1099: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
1100: AND ffp.set_of_books_id = gbl_set_of_books_id
1101: AND ffp.fund_value = P_FUND_VALUE;
1102: */

Line 1242: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

1238: IF (l_c_nc_ind = 'Y') THEN
1239: /*
1240: SELECT 'X', fts.cust_non_cust
1241: INTO l_row_exists, l_c_nc
1242: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
1243: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
1244: AND ffp.set_of_books_id = gbl_set_of_books_id
1245: AND ffp.fund_value = P_FUND_VALUE;
1246: */

Line 1316: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

1312: IF (l_c_nc_ind = 'Y') THEN
1313: /*
1314: SELECT 'X', fts.cust_non_cust
1315: INTO l_row_exists, l_c_nc
1316: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
1317: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
1318: AND ffp.set_of_books_id = gbl_set_of_books_id
1319: AND ffp.fund_value = P_FUND_VALUE;
1320: */

Line 2186: TYPE l_fund_group_t is table of fv_treasury_symbols.fund_group_code%TYPE;

2182: t1_record_c t_ref_cur ;
2183:
2184: TYPE l_account_number_t is table of VARCHAR2(30);
2185: TYPE l_fund_value_t is table of VARCHAR2(30);
2186: TYPE l_fund_group_t is table of fv_treasury_symbols.fund_group_code%TYPE;
2187: TYPE l_dept_id_t is table of fv_treasury_symbols.department_id%TYPE;
2188: TYPE l_bureau_id_t is table of fv_treasury_symbols.bureau_id%TYPE;
2189: TYPE l_sgl_acct_num_t is table of VARCHAR2(4);
2190: TYPE l_govt_non_govt_ind_t is table of VARCHAR2(1);

Line 2187: TYPE l_dept_id_t is table of fv_treasury_symbols.department_id%TYPE;

2183:
2184: TYPE l_account_number_t is table of VARCHAR2(30);
2185: TYPE l_fund_value_t is table of VARCHAR2(30);
2186: TYPE l_fund_group_t is table of fv_treasury_symbols.fund_group_code%TYPE;
2187: TYPE l_dept_id_t is table of fv_treasury_symbols.department_id%TYPE;
2188: TYPE l_bureau_id_t is table of fv_treasury_symbols.bureau_id%TYPE;
2189: TYPE l_sgl_acct_num_t is table of VARCHAR2(4);
2190: TYPE l_govt_non_govt_ind_t is table of VARCHAR2(1);
2191: TYPE l_exch_non_exch_t is table of VARCHAR2(1);

Line 2188: TYPE l_bureau_id_t is table of fv_treasury_symbols.bureau_id%TYPE;

2184: TYPE l_account_number_t is table of VARCHAR2(30);
2185: TYPE l_fund_value_t is table of VARCHAR2(30);
2186: TYPE l_fund_group_t is table of fv_treasury_symbols.fund_group_code%TYPE;
2187: TYPE l_dept_id_t is table of fv_treasury_symbols.department_id%TYPE;
2188: TYPE l_bureau_id_t is table of fv_treasury_symbols.bureau_id%TYPE;
2189: TYPE l_sgl_acct_num_t is table of VARCHAR2(4);
2190: TYPE l_govt_non_govt_ind_t is table of VARCHAR2(1);
2191: TYPE l_exch_non_exch_t is table of VARCHAR2(1);
2192: TYPE l_cust_non_cust_t is table of VARCHAR2(1);

Line 2256: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;

2252:
2253:
2254: l_account_number VARCHAR2(30);
2255: l_fund_value VARCHAR2(30);
2256: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
2257: l_dept_id fv_treasury_symbols.department_id%TYPE;
2258: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
2259: l_sgl_acct_num VARCHAR2(4);
2260: l_govt_non_gov VARCHAR2(1);

Line 2257: l_dept_id fv_treasury_symbols.department_id%TYPE;

2253:
2254: l_account_number VARCHAR2(30);
2255: l_fund_value VARCHAR2(30);
2256: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
2257: l_dept_id fv_treasury_symbols.department_id%TYPE;
2258: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
2259: l_sgl_acct_num VARCHAR2(4);
2260: l_govt_non_gov VARCHAR2(1);
2261: l_exch_non_exch VARCHAR2(1);

Line 2258: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;

2254: l_account_number VARCHAR2(30);
2255: l_fund_value VARCHAR2(30);
2256: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
2257: l_dept_id fv_treasury_symbols.department_id%TYPE;
2258: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
2259: l_sgl_acct_num VARCHAR2(4);
2260: l_govt_non_gov VARCHAR2(1);
2261: l_exch_non_exch VARCHAR2(1);
2262: l_cust_non_cust VARCHAR2(1);