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_STATUS_OF_FUNDS_PKG dependencies on FV_FUND_PARAMETERS

Line 8: v_budget fv_fund_parameters.budget_authority%TYPE;

4: /*******************************************************************/
5: /***** Variable Declaration For All Processes ******/
6: /*******************************************************************/
7: g_module_name varchar2(100) := 'fv.plsql.fv_status_of_funds_pkg.' ;
8: v_budget fv_fund_parameters.budget_authority%TYPE;
9: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
10: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
11: v_expenditure fv_fund_parameters.expended_amount%TYPE;
12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;

Line 9: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;

5: /***** Variable Declaration For All Processes ******/
6: /*******************************************************************/
7: g_module_name varchar2(100) := 'fv.plsql.fv_status_of_funds_pkg.' ;
8: v_budget fv_fund_parameters.budget_authority%TYPE;
9: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
10: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
11: v_expenditure fv_fund_parameters.expended_amount%TYPE;
12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;

Line 10: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;

6: /*******************************************************************/
7: g_module_name varchar2(100) := 'fv.plsql.fv_status_of_funds_pkg.' ;
8: v_budget fv_fund_parameters.budget_authority%TYPE;
9: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
10: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
11: v_expenditure fv_fund_parameters.expended_amount%TYPE;
12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
14: v_fund_value fv_fund_parameters.fund_value%TYPE;

Line 11: v_expenditure fv_fund_parameters.expended_amount%TYPE;

7: g_module_name varchar2(100) := 'fv.plsql.fv_status_of_funds_pkg.' ;
8: v_budget fv_fund_parameters.budget_authority%TYPE;
9: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
10: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
11: v_expenditure fv_fund_parameters.expended_amount%TYPE;
12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
14: v_fund_value fv_fund_parameters.fund_value%TYPE;
15: v_fund_value1 fv_fund_parameters.fund_value%TYPE;

Line 12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;

8: v_budget fv_fund_parameters.budget_authority%TYPE;
9: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
10: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
11: v_expenditure fv_fund_parameters.expended_amount%TYPE;
12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
14: v_fund_value fv_fund_parameters.fund_value%TYPE;
15: v_fund_value1 fv_fund_parameters.fund_value%TYPE;
16: v_treasury_symbol fv_fund_parameters.treasury_symbol%TYPE;

Line 13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;

9: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
10: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
11: v_expenditure fv_fund_parameters.expended_amount%TYPE;
12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
14: v_fund_value fv_fund_parameters.fund_value%TYPE;
15: v_fund_value1 fv_fund_parameters.fund_value%TYPE;
16: v_treasury_symbol fv_fund_parameters.treasury_symbol%TYPE;
17: v_treasury_symbol1 fv_fund_parameters.treasury_symbol%TYPE;

Line 14: v_fund_value fv_fund_parameters.fund_value%TYPE;

10: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
11: v_expenditure fv_fund_parameters.expended_amount%TYPE;
12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
14: v_fund_value fv_fund_parameters.fund_value%TYPE;
15: v_fund_value1 fv_fund_parameters.fund_value%TYPE;
16: v_treasury_symbol fv_fund_parameters.treasury_symbol%TYPE;
17: v_treasury_symbol1 fv_fund_parameters.treasury_symbol%TYPE;
18: v_statement varchar2(2);

Line 15: v_fund_value1 fv_fund_parameters.fund_value%TYPE;

11: v_expenditure fv_fund_parameters.expended_amount%TYPE;
12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
14: v_fund_value fv_fund_parameters.fund_value%TYPE;
15: v_fund_value1 fv_fund_parameters.fund_value%TYPE;
16: v_treasury_symbol fv_fund_parameters.treasury_symbol%TYPE;
17: v_treasury_symbol1 fv_fund_parameters.treasury_symbol%TYPE;
18: v_statement varchar2(2);
19: err_message varchar2(300);

Line 16: v_treasury_symbol fv_fund_parameters.treasury_symbol%TYPE;

12: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
14: v_fund_value fv_fund_parameters.fund_value%TYPE;
15: v_fund_value1 fv_fund_parameters.fund_value%TYPE;
16: v_treasury_symbol fv_fund_parameters.treasury_symbol%TYPE;
17: v_treasury_symbol1 fv_fund_parameters.treasury_symbol%TYPE;
18: v_statement varchar2(2);
19: err_message varchar2(300);
20: acct_flex_id fnd_flex_values.flex_value_id%TYPE;

Line 17: v_treasury_symbol1 fv_fund_parameters.treasury_symbol%TYPE;

13: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
14: v_fund_value fv_fund_parameters.fund_value%TYPE;
15: v_fund_value1 fv_fund_parameters.fund_value%TYPE;
16: v_treasury_symbol fv_fund_parameters.treasury_symbol%TYPE;
17: v_treasury_symbol1 fv_fund_parameters.treasury_symbol%TYPE;
18: v_statement varchar2(2);
19: err_message varchar2(300);
20: acct_flex_id fnd_flex_values.flex_value_id%TYPE;
21: v_ca_id gl_sets_of_books.chart_of_accounts_id%TYPE;

Line 758: FROM fv_fund_parameters fp

754: fp.unliquid_commitments,
755: fp.unliquid_obligations,
756: fp.expended_amount ,
757: fp.treasury_symbol_id
758: FROM fv_fund_parameters fp
759: WHERE fp.set_of_books_id = sob_id
760: AND decode(rollup_type,'T',to_char(fp.treasury_symbol_id),'F',fp.fund_value)
761: between decode(rollup_type,'T',nvl(temp_v_treasury_symbol_id,fp.treasury_symbol_id),
762: 'F',nvl(acct_ff_low,fp.fund_value) )

Line 779: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,

775: PROCEDURE sum_children_budget
776: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
777: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
778: sob_id1 IN gl_balances.ledger_id%TYPE,
779: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
780: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
781: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE ) --Changed to Fix 1575992
782: Is
783: CURSOR c_parent_value_budget IS

Line 780: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,

776: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
777: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
778: sob_id1 IN gl_balances.ledger_id%TYPE,
779: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
780: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
781: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE ) --Changed to Fix 1575992
782: Is
783: CURSOR c_parent_value_budget IS
784: SELECT child_flex_value_low, child_flex_value_high

Line 934: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,

930: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
931: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
932: v_trans_type IN VARCHAR2,
933: sob_id1 IN gl_balances.ledger_id%TYPE,
934: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
935: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
936: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )--Added to fix bug.1575992
937:
938: IS

Line 935: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,

931: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
932: v_trans_type IN VARCHAR2,
933: sob_id1 IN gl_balances.ledger_id%TYPE,
934: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
935: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
936: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )--Added to fix bug.1575992
937:
938: IS
939: CURSOR c_parent_value_transfers IS

Line 1132: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,

1128: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
1129: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
1130: v_spend_type IN varchar2,
1131: sob_id1 IN gl_balances.ledger_id%TYPE,
1132: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
1133: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
1134: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )
1135:
1136: IS

Line 1133: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,

1129: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
1130: v_spend_type IN varchar2,
1131: sob_id1 IN gl_balances.ledger_id%TYPE,
1132: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
1133: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
1134: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE )
1135:
1136: IS
1137: CURSOR c_parent_value_spending IS