6:
7: /*******************************************************************/
8: /***** Variable Declaration For All Processes ******/
9: /*******************************************************************/
10: v_budget fv_fund_parameters.budget_authority%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
7: /*******************************************************************/
8: /***** Variable Declaration For All Processes ******/
9: /*******************************************************************/
10: v_budget fv_fund_parameters.budget_authority%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
8: /***** Variable Declaration For All Processes ******/
9: /*******************************************************************/
10: v_budget fv_fund_parameters.budget_authority%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
9: /*******************************************************************/
10: v_budget fv_fund_parameters.budget_authority%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
17: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
11: v_commitment fv_fund_parameters.unliquid_commitments%TYPE;
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
17: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
18: v_fund_value fv_fund_parameters.fund_value%TYPE;
19: v_acct_seg_name varchar2(30);
12: v_obligation fv_fund_parameters.unliquid_obligations%TYPE;
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
17: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
18: v_fund_value fv_fund_parameters.fund_value%TYPE;
19: v_acct_seg_name varchar2(30);
20: v_bal_seg_name varchar2(30);
14:
15: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
16: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
17: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
18: v_fund_value fv_fund_parameters.fund_value%TYPE;
19: v_acct_seg_name varchar2(30);
20: v_bal_seg_name varchar2(30);
21: bud_authority_type varchar2(50);
22:
116: fp.unliquid_obligations,
117: fp.expended_amount,
118: fp.transfers_in,
119: fp.transfers_out
120: FROM fv_fund_parameters fp
121: WHERE fp.set_of_books_id = sob_id
122: and decode(rollup_type,'F',fp.fund_value,'T',treasury_symbol_id)
123: between decode(rollup_type,
124: 'T',temp_v_treasury_symbol_id,