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_FUND_PARAMETERS

Line 111: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;

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

Line 112: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;

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;
115:
116: -- Global Variable for RXi

Line 678: -- Update fv_fund_parameters table with the required info.

674: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
675: END process_input_parameters;
676: --------------------------------------------------------------------------------
677: -- FUND_GROUP_INFO_SETUP
678: -- Update fv_fund_parameters table with the required info.
679: --------------------------------------------------------------------------------
680: PROCEDURE FUND_GROUP_INFO_SETUP
681: IS
682: l_module_name VARCHAR2(200);

Line 686: l_fund_val fv_fund_parameters.fund_value%TYPE;

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

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 748: UPDATE fv_fund_parameters

744:
745: --fv_utility.log_mesg('**********fund_value: '||fund_rec.fund_val);
746: --fv_utility.log_mesg('**********fund_group_code: '||l_fund_group);
747:
748: UPDATE fv_fund_parameters
749: SET department_id = fund_rec.dep_id,
750: bureau_id = fund_rec.bu_id,
751: fund_group_code = l_fund_group
752: WHERE fund_value = fund_rec.fund_val

Line 797: -- Get the Fund Group, Dept Id, Bureau Id and from the fv_fund_parameters

793: END process_t1_records;
794: --------------------------------------------------------------------------------
795: -- PROCEDURE GET_FUND_GROUP_INFO
796: --------------------------------------------------------------------------------
797: -- Get the Fund Group, Dept Id, Bureau Id and from the fv_fund_parameters
798: -- table for the passed fund value.
799: --------------------------------------------------------------------------------
800: PROCEDURE GET_FUND_GROUP_INFO
801: ( p_fund_value IN VARCHAR2,

Line 827: FROM fv_fund_parameters

823: fund_group_code
824: INTO p_dept_id,
825: p_bureau_id,
826: p_fund_group
827: FROM fv_fund_parameters
828: WHERE fund_value = p_fund_value
829: AND set_of_books_id = gbl_set_of_books_id;
830: p_exists := 'Y';
831: EXCEPTION

Line 1053: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then

1049: p_govt_non_govt := l_g_ng_ind;
1050:
1051: -- Account Number Valid
1052: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1053: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then
1054: -- the account gets reported to exception report
1055:
1056: IF (l_budget_sub_ind = 'Y') THEN
1057: SELECT 'X', budget_subfunction

Line 1059: FROM fv_fund_parameters

1055:
1056: IF (l_budget_sub_ind = 'Y') THEN
1057: SELECT 'X', budget_subfunction
1058: INTO l_row_exists, l_budget_sub
1059: FROM fv_fund_parameters
1060: WHERE fund_value = P_FUND_VALUE
1061: AND set_of_books_id = gbl_set_of_books_id;
1062: END IF;
1063:

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 1192: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then

1188: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES
1189: p_govt_non_govt := l_g_ng_ind;
1190:
1191: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1192: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then
1193: -- the account gets reported to exception report
1194: IF (l_budget_sub_ind = 'Y') THEN
1195: SELECT 'X', budget_subfunction
1196: INTO l_row_exists, l_budget_sub

Line 1197: FROM fv_fund_parameters

1193: -- the account gets reported to exception report
1194: IF (l_budget_sub_ind = 'Y') THEN
1195: SELECT 'X', budget_subfunction
1196: INTO l_row_exists, l_budget_sub
1197: FROM fv_fund_parameters
1198: WHERE fund_value = P_FUND_VALUE
1199: AND set_of_books_id = gbl_set_of_books_id;
1200: END IF;
1201:

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 1264: FROM fv_fund_parameters

1260:
1261: IF (l_budget_sub_ind = 'Y') THEN
1262: SELECT 'X', budget_subfunction
1263: INTO l_row_exists, l_budget_sub
1264: FROM fv_fund_parameters
1265: WHERE fund_value = p_fund_value
1266: AND set_of_books_id = gbl_set_of_books_id;
1267: END IF;
1268:

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 1802: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,

1798: PROCEDURE TRIAL_BALANCE_MAIN (p_errbuf OUT NOCOPY Varchar2,
1799: p_retcode OUT NOCOPY Number,
1800: p_sob Gl_ledgers_public_v.ledger_id%TYPE,
1801: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,
1802: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,
1803: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,
1804: p_currency_code Varchar2,
1805: p_period_name Varchar2,
1806: p_report_id Number,

Line 1803: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,

1799: p_retcode OUT NOCOPY Number,
1800: p_sob Gl_ledgers_public_v.ledger_id%TYPE,
1801: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,
1802: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,
1803: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,
1804: p_currency_code Varchar2,
1805: p_period_name Varchar2,
1806: p_report_id Number,
1807: p_attribute_set Varchar2,