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: -- CGAC

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

750:
751: --fv_utility.log_mesg('**********fund_value: '||fund_rec.fund_val);
752: --fv_utility.log_mesg('**********fund_group_code: '||l_fund_group);
753:
754: UPDATE fv_fund_parameters
755: SET department_id = fund_rec.dep_id,
756: bureau_id = fund_rec.bu_id,
757: fund_group_code = l_fund_group
758: WHERE fund_value = fund_rec.fund_val

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

799: END process_t1_records;
800: --------------------------------------------------------------------------------
801: -- PROCEDURE GET_FUND_GROUP_INFO
802: --------------------------------------------------------------------------------
803: -- Get the Fund Group, Dept Id, Bureau Id and from the fv_fund_parameters
804: -- table for the passed fund value.
805: --------------------------------------------------------------------------------
806: PROCEDURE GET_FUND_GROUP_INFO
807: ( p_fund_value IN VARCHAR2,

Line 833: FROM fv_fund_parameters

829: fund_group_code
830: INTO p_dept_id,
831: p_bureau_id,
832: p_fund_group
833: FROM fv_fund_parameters
834: WHERE fund_value = p_fund_value
835: AND set_of_books_id = gbl_set_of_books_id;
836: p_exists := 'Y';
837: EXCEPTION

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

1055: p_govt_non_govt := l_g_ng_ind;
1056:
1057: -- Account Number Valid
1058: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1059: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then
1060: -- the account gets reported to exception report
1061:
1062: IF (l_budget_sub_ind = 'Y') THEN
1063: SELECT 'X', budget_subfunction

Line 1065: FROM fv_fund_parameters

1061:
1062: IF (l_budget_sub_ind = 'Y') THEN
1063: SELECT 'X', budget_subfunction
1064: INTO l_row_exists, l_budget_sub
1065: FROM fv_fund_parameters
1066: WHERE fund_value = P_FUND_VALUE
1067: AND set_of_books_id = gbl_set_of_books_id;
1068: END IF;
1069:

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 1105: FROM fv_fund_parameters ffp

1101: AND ffp.fund_value = P_FUND_VALUE;
1102: */
1103: SELECT 'X', ffp.cust_non_cust
1104: INTO l_row_exists, l_c_nc
1105: FROM fv_fund_parameters ffp
1106: WHERE ffp.set_of_books_id = gbl_set_of_books_id
1107: AND ffp.fund_value = P_FUND_VALUE;
1108: END IF;
1109:

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

1201: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES
1202: p_govt_non_govt := l_g_ng_ind;
1203:
1204: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1205: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then
1206: -- the account gets reported to exception report
1207: IF (l_budget_sub_ind = 'Y') THEN
1208: SELECT 'X', budget_subfunction
1209: INTO l_row_exists, l_budget_sub

Line 1210: FROM fv_fund_parameters

1206: -- the account gets reported to exception report
1207: IF (l_budget_sub_ind = 'Y') THEN
1208: SELECT 'X', budget_subfunction
1209: INTO l_row_exists, l_budget_sub
1210: FROM fv_fund_parameters
1211: WHERE fund_value = P_FUND_VALUE
1212: AND set_of_books_id = gbl_set_of_books_id;
1213: END IF;
1214:

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 1249: FROM fv_fund_parameters ffp

1245: AND ffp.fund_value = P_FUND_VALUE;
1246: */
1247: SELECT 'X', ffp.cust_non_cust
1248: INTO l_row_exists, l_c_nc
1249: FROM fv_fund_parameters ffp
1250: WHERE ffp.set_of_books_id = gbl_set_of_books_id
1251: AND ffp.fund_value = P_FUND_VALUE;
1252: END IF;
1253:

Line 1284: FROM fv_fund_parameters

1280:
1281: IF (l_budget_sub_ind = 'Y') THEN
1282: SELECT 'X', budget_subfunction
1283: INTO l_row_exists, l_budget_sub
1284: FROM fv_fund_parameters
1285: WHERE fund_value = p_fund_value
1286: AND set_of_books_id = gbl_set_of_books_id;
1287: END IF;
1288:

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 1323: FROM fv_fund_parameters ffp

1319: AND ffp.fund_value = P_FUND_VALUE;
1320: */
1321: SELECT 'X', ffp.cust_non_cust
1322: INTO l_row_exists, l_c_nc
1323: FROM fv_fund_parameters ffp
1324: WHERE ffp.set_of_books_id = gbl_set_of_books_id
1325: AND ffp.fund_value = P_FUND_VALUE;
1326: END IF;
1327:

Line 1843: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,

1839: PROCEDURE TRIAL_BALANCE_MAIN (p_errbuf OUT NOCOPY Varchar2,
1840: p_retcode OUT NOCOPY Number,
1841: p_sob Gl_ledgers_public_v.ledger_id%TYPE,
1842: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,
1843: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,
1844: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,
1845: p_currency_code Varchar2,
1846: p_period_name Varchar2,
1847: p_report_id Number,

Line 1844: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,

1840: p_retcode OUT NOCOPY Number,
1841: p_sob Gl_ledgers_public_v.ledger_id%TYPE,
1842: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,
1843: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,
1844: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,
1845: p_currency_code Varchar2,
1846: p_period_name Varchar2,
1847: p_report_id Number,
1848: p_attribute_set Varchar2,