205: d_api_name CONSTANT VARCHAR2(30) := 'Updt_Funding_Info';
206: d_module CONSTANT VARCHAR2(100) := d_pkg_name
207: ||d_api_name;
208: d_progress NUMBER;
209: l_dist_id_tbl PO_TBL_NUMBER;
210: l_price_tbl PO_TBL_NUMBER;
211: l_match_basis_tbl PO_TBL_VARCHAR20;
212: l_qty_ordered_tbl PO_TBL_NUMBER;
213: l_amt_ordered_tbl PO_TBL_NUMBER;
206: d_module CONSTANT VARCHAR2(100) := d_pkg_name
207: ||d_api_name;
208: d_progress NUMBER;
209: l_dist_id_tbl PO_TBL_NUMBER;
210: l_price_tbl PO_TBL_NUMBER;
211: l_match_basis_tbl PO_TBL_VARCHAR20;
212: l_qty_ordered_tbl PO_TBL_NUMBER;
213: l_amt_ordered_tbl PO_TBL_NUMBER;
214: l_partial_flag_tbl PO_TBL_VARCHAR1;
208: d_progress NUMBER;
209: l_dist_id_tbl PO_TBL_NUMBER;
210: l_price_tbl PO_TBL_NUMBER;
211: l_match_basis_tbl PO_TBL_VARCHAR20;
212: l_qty_ordered_tbl PO_TBL_NUMBER;
213: l_amt_ordered_tbl PO_TBL_NUMBER;
214: l_partial_flag_tbl PO_TBL_VARCHAR1;
215: l_fund_value_tbl PO_TBL_NUMBER;
216: l_nr_tax_tbl PO_TBL_NUMBER;
209: l_dist_id_tbl PO_TBL_NUMBER;
210: l_price_tbl PO_TBL_NUMBER;
211: l_match_basis_tbl PO_TBL_VARCHAR20;
212: l_qty_ordered_tbl PO_TBL_NUMBER;
213: l_amt_ordered_tbl PO_TBL_NUMBER;
214: l_partial_flag_tbl PO_TBL_VARCHAR1;
215: l_fund_value_tbl PO_TBL_NUMBER;
216: l_nr_tax_tbl PO_TBL_NUMBER;
217: l_rate_tbl PO_TBL_NUMBER;
211: l_match_basis_tbl PO_TBL_VARCHAR20;
212: l_qty_ordered_tbl PO_TBL_NUMBER;
213: l_amt_ordered_tbl PO_TBL_NUMBER;
214: l_partial_flag_tbl PO_TBL_VARCHAR1;
215: l_fund_value_tbl PO_TBL_NUMBER;
216: l_nr_tax_tbl PO_TBL_NUMBER;
217: l_rate_tbl PO_TBL_NUMBER;
218: l_qty_funded_tbl PO_TBL_NUMBER;
219: l_amt_funded_tbl PO_TBL_NUMBER;
212: l_qty_ordered_tbl PO_TBL_NUMBER;
213: l_amt_ordered_tbl PO_TBL_NUMBER;
214: l_partial_flag_tbl PO_TBL_VARCHAR1;
215: l_fund_value_tbl PO_TBL_NUMBER;
216: l_nr_tax_tbl PO_TBL_NUMBER;
217: l_rate_tbl PO_TBL_NUMBER;
218: l_qty_funded_tbl PO_TBL_NUMBER;
219: l_amt_funded_tbl PO_TBL_NUMBER;
220: -- Bug 16475592: Changing data type of l_func_currency_tbl from table of number
213: l_amt_ordered_tbl PO_TBL_NUMBER;
214: l_partial_flag_tbl PO_TBL_VARCHAR1;
215: l_fund_value_tbl PO_TBL_NUMBER;
216: l_nr_tax_tbl PO_TBL_NUMBER;
217: l_rate_tbl PO_TBL_NUMBER;
218: l_qty_funded_tbl PO_TBL_NUMBER;
219: l_amt_funded_tbl PO_TBL_NUMBER;
220: -- Bug 16475592: Changing data type of l_func_currency_tbl from table of number
221: -- to table of varchar as the data is inserted from GL_SETS_OF_BOOKS, currency
214: l_partial_flag_tbl PO_TBL_VARCHAR1;
215: l_fund_value_tbl PO_TBL_NUMBER;
216: l_nr_tax_tbl PO_TBL_NUMBER;
217: l_rate_tbl PO_TBL_NUMBER;
218: l_qty_funded_tbl PO_TBL_NUMBER;
219: l_amt_funded_tbl PO_TBL_NUMBER;
220: -- Bug 16475592: Changing data type of l_func_currency_tbl from table of number
221: -- to table of varchar as the data is inserted from GL_SETS_OF_BOOKS, currency
222: -- code column which has varchar2 data type.
215: l_fund_value_tbl PO_TBL_NUMBER;
216: l_nr_tax_tbl PO_TBL_NUMBER;
217: l_rate_tbl PO_TBL_NUMBER;
218: l_qty_funded_tbl PO_TBL_NUMBER;
219: l_amt_funded_tbl PO_TBL_NUMBER;
220: -- Bug 16475592: Changing data type of l_func_currency_tbl from table of number
221: -- to table of varchar as the data is inserted from GL_SETS_OF_BOOKS, currency
222: -- code column which has varchar2 data type.
223: l_func_currency_tbl PO_TBL_VARCHAR20;
507: ||d_api_name;
508: d_progress NUMBER;
509: l_price NUMBER;
510:
511: l_Distribution_id_tbl PO_TBL_NUMBER;
512: l_partial_flag_tbl PO_TBL_VARCHAR1;
513: l_req_Line_qty_tbl PO_TBL_NUMBER;
514: l_price_tbl PO_TBL_NUMBER;
515: l_nr_tax_tbl PO_TBL_NUMBER;
509: l_price NUMBER;
510:
511: l_Distribution_id_tbl PO_TBL_NUMBER;
512: l_partial_flag_tbl PO_TBL_VARCHAR1;
513: l_req_Line_qty_tbl PO_TBL_NUMBER;
514: l_price_tbl PO_TBL_NUMBER;
515: l_nr_tax_tbl PO_TBL_NUMBER;
516:
517: l_qty_funded_tbl PO_TBL_NUMBER;
510:
511: l_Distribution_id_tbl PO_TBL_NUMBER;
512: l_partial_flag_tbl PO_TBL_VARCHAR1;
513: l_req_Line_qty_tbl PO_TBL_NUMBER;
514: l_price_tbl PO_TBL_NUMBER;
515: l_nr_tax_tbl PO_TBL_NUMBER;
516:
517: l_qty_funded_tbl PO_TBL_NUMBER;
518: l_old_fund_value number;
511: l_Distribution_id_tbl PO_TBL_NUMBER;
512: l_partial_flag_tbl PO_TBL_VARCHAR1;
513: l_req_Line_qty_tbl PO_TBL_NUMBER;
514: l_price_tbl PO_TBL_NUMBER;
515: l_nr_tax_tbl PO_TBL_NUMBER;
516:
517: l_qty_funded_tbl PO_TBL_NUMBER;
518: l_old_fund_value number;
519: l_Old_Req_Line_Qty NUMBER;
513: l_req_Line_qty_tbl PO_TBL_NUMBER;
514: l_price_tbl PO_TBL_NUMBER;
515: l_nr_tax_tbl PO_TBL_NUMBER;
516:
517: l_qty_funded_tbl PO_TBL_NUMBER;
518: l_old_fund_value number;
519: l_Old_Req_Line_Qty NUMBER;
520: l_funded_Value_tbl PO_TBL_NUMBER;
521: l_Chg_Fund_Value_Tbl PO_TBL_NUMBER;
516:
517: l_qty_funded_tbl PO_TBL_NUMBER;
518: l_old_fund_value number;
519: l_Old_Req_Line_Qty NUMBER;
520: l_funded_Value_tbl PO_TBL_NUMBER;
521: l_Chg_Fund_Value_Tbl PO_TBL_NUMBER;
522: l_parent_Dist_Id_tbl PO_Tbl_Number;
523:
524: BEGIN
517: l_qty_funded_tbl PO_TBL_NUMBER;
518: l_old_fund_value number;
519: l_Old_Req_Line_Qty NUMBER;
520: l_funded_Value_tbl PO_TBL_NUMBER;
521: l_Chg_Fund_Value_Tbl PO_TBL_NUMBER;
522: l_parent_Dist_Id_tbl PO_Tbl_Number;
523:
524: BEGIN
525: D_PROGRESS := 10;
518: l_old_fund_value number;
519: l_Old_Req_Line_Qty NUMBER;
520: l_funded_Value_tbl PO_TBL_NUMBER;
521: l_Chg_Fund_Value_Tbl PO_TBL_NUMBER;
522: l_parent_Dist_Id_tbl PO_Tbl_Number;
523:
524: BEGIN
525: D_PROGRESS := 10;
526: --Clm_Split
523:
524: BEGIN
525: D_PROGRESS := 10;
526: --Clm_Split
527: l_qty_funded_tbl := PO_TBL_NUMBER();
528: L_FUNDED_VALUE_TBL := PO_TBL_NUMBER();
529: L_CHG_FUND_VALUE_TBL := PO_TBL_NUMBER();
530: --End
531: open New_Req_line_Info;
524: BEGIN
525: D_PROGRESS := 10;
526: --Clm_Split
527: l_qty_funded_tbl := PO_TBL_NUMBER();
528: L_FUNDED_VALUE_TBL := PO_TBL_NUMBER();
529: L_CHG_FUND_VALUE_TBL := PO_TBL_NUMBER();
530: --End
531: open New_Req_line_Info;
532: Fetch New_Req_line_Info
525: D_PROGRESS := 10;
526: --Clm_Split
527: l_qty_funded_tbl := PO_TBL_NUMBER();
528: L_FUNDED_VALUE_TBL := PO_TBL_NUMBER();
529: L_CHG_FUND_VALUE_TBL := PO_TBL_NUMBER();
530: --End
531: open New_Req_line_Info;
532: Fetch New_Req_line_Info
533: BULK COLLECT INTO