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;
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;
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;
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;
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;
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;
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);
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);
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;
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;
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) )
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
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
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
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
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
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