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: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
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: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
15: v_transfers_out fv_fund_parameters.transfers_out%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: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
15: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
16: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%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: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
15: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
16: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
17: v_fund_value fv_fund_parameters.fund_value%TYPE;
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: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
15: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
16: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
17: v_fund_value fv_fund_parameters.fund_value%TYPE;
18: v_acct_seg_name varchar2(30);
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: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
15: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
16: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
17: v_fund_value fv_fund_parameters.fund_value%TYPE;
18: v_acct_seg_name varchar2(30);
19: v_bal_seg_name varchar2(30);
13: v_expenditure fv_fund_parameters.expended_amount%TYPE;
14: v_transfers_in fv_fund_parameters.transfers_in%TYPE;
15: v_transfers_out fv_fund_parameters.transfers_out%TYPE;
16: v_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
17: v_fund_value fv_fund_parameters.fund_value%TYPE;
18: v_acct_seg_name varchar2(30);
19: v_bal_seg_name varchar2(30);
20: bud_authority_type varchar2(50);
21:
113: fp.unliquid_obligations,
114: fp.expended_amount,
115: fp.transfers_in,
116: fp.transfers_out
117: FROM fv_fund_parameters fp
118: WHERE fp.set_of_books_id = sob_id
119: and decode(rollup_type,'F',fp.fund_value,'T',treasury_symbol_id)
120: between decode(rollup_type,
121: 'T',temp_v_treasury_symbol_id,