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: ln_facts1_rollup fv_fund_groups.fund_group_code%TYPE;
691:

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: ln_facts1_rollup fv_fund_groups.fund_group_code%TYPE;
691:
692: CURSOR fund_cur IS

Line 695: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

691:
692: CURSOR fund_cur IS
693: SELECT ffp.fund_value fund_val, fts.fund_group_code fund_grp,
694: fts.department_id dep_id, fts.bureau_id bu_id
695: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
696: WHERE ffp.set_of_books_id = gbl_set_of_books_id
697: AND fts.treasury_symbol_id = ffp.treasury_symbol_id;
698:
699: BEGIN

Line 1091: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

1087:
1088: IF (l_c_nc_ind = 'Y') THEN
1089: SELECT 'X', fts.cust_non_cust
1090: INTO l_row_exists, l_c_nc
1091: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
1092: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
1093: AND ffp.set_of_books_id = gbl_set_of_books_id
1094: AND ffp.fund_value = P_FUND_VALUE;
1095: END IF;

Line 1228: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

1224:
1225: IF (l_c_nc_ind = 'Y') THEN
1226: SELECT 'X', fts.cust_non_cust
1227: INTO l_row_exists, l_c_nc
1228: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
1229: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
1230: AND ffp.set_of_books_id = gbl_set_of_books_id
1231: AND ffp.fund_value = P_FUND_VALUE;
1232: END IF;

Line 1295: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

1291:
1292: IF (l_c_nc_ind = 'Y') THEN
1293: SELECT 'X', fts.cust_non_cust
1294: INTO l_row_exists, l_c_nc
1295: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
1296: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
1297: AND ffp.set_of_books_id = gbl_set_of_books_id
1298: AND ffp.fund_value = P_FUND_VALUE;
1299: END IF;

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

2128: t1_record_c t_ref_cur ;
2129:
2130: TYPE l_account_number_t is table of VARCHAR2(30);
2131: TYPE l_fund_value_t is table of VARCHAR2(30);
2132: TYPE l_fund_group_t is table of fv_treasury_symbols.fund_group_code%TYPE;
2133: TYPE l_dept_id_t is table of fv_treasury_symbols.department_id%TYPE;
2134: TYPE l_bureau_id_t is table of fv_treasury_symbols.bureau_id%TYPE;
2135: TYPE l_sgl_acct_num_t is table of VARCHAR2(4);
2136: TYPE l_govt_non_govt_ind_t is table of VARCHAR2(1);

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

2129:
2130: TYPE l_account_number_t is table of VARCHAR2(30);
2131: TYPE l_fund_value_t is table of VARCHAR2(30);
2132: TYPE l_fund_group_t is table of fv_treasury_symbols.fund_group_code%TYPE;
2133: TYPE l_dept_id_t is table of fv_treasury_symbols.department_id%TYPE;
2134: TYPE l_bureau_id_t is table of fv_treasury_symbols.bureau_id%TYPE;
2135: TYPE l_sgl_acct_num_t is table of VARCHAR2(4);
2136: TYPE l_govt_non_govt_ind_t is table of VARCHAR2(1);
2137: TYPE l_exch_non_exch_t is table of VARCHAR2(1);

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

2130: TYPE l_account_number_t is table of VARCHAR2(30);
2131: TYPE l_fund_value_t is table of VARCHAR2(30);
2132: TYPE l_fund_group_t is table of fv_treasury_symbols.fund_group_code%TYPE;
2133: TYPE l_dept_id_t is table of fv_treasury_symbols.department_id%TYPE;
2134: TYPE l_bureau_id_t is table of fv_treasury_symbols.bureau_id%TYPE;
2135: TYPE l_sgl_acct_num_t is table of VARCHAR2(4);
2136: TYPE l_govt_non_govt_ind_t is table of VARCHAR2(1);
2137: TYPE l_exch_non_exch_t is table of VARCHAR2(1);
2138: TYPE l_cust_non_cust_t is table of VARCHAR2(1);

Line 2202: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;

2198:
2199:
2200: l_account_number VARCHAR2(30);
2201: l_fund_value VARCHAR2(30);
2202: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
2203: l_dept_id fv_treasury_symbols.department_id%TYPE;
2204: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
2205: l_sgl_acct_num VARCHAR2(4);
2206: l_govt_non_gov VARCHAR2(1);

Line 2203: l_dept_id fv_treasury_symbols.department_id%TYPE;

2199:
2200: l_account_number VARCHAR2(30);
2201: l_fund_value VARCHAR2(30);
2202: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
2203: l_dept_id fv_treasury_symbols.department_id%TYPE;
2204: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
2205: l_sgl_acct_num VARCHAR2(4);
2206: l_govt_non_gov VARCHAR2(1);
2207: l_exch_non_exch VARCHAR2(1);

Line 2204: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;

2200: l_account_number VARCHAR2(30);
2201: l_fund_value VARCHAR2(30);
2202: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
2203: l_dept_id fv_treasury_symbols.department_id%TYPE;
2204: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
2205: l_sgl_acct_num VARCHAR2(4);
2206: l_govt_non_gov VARCHAR2(1);
2207: l_exch_non_exch VARCHAR2(1);
2208: l_cust_non_cust VARCHAR2(1);