DBA Data[Home] [Help]

APPS.PO_PARTIAL_FUNDING_PKG dependencies on PO_TBL_NUMBER

Line 209: l_dist_id_tbl PO_TBL_NUMBER;

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;

Line 210: l_price_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;

Line 212: l_qty_ordered_tbl PO_TBL_NUMBER;

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;

Line 213: l_amt_ordered_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;

Line 215: l_fund_value_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;

Line 216: l_nr_tax_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

Line 217: l_rate_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
221: -- to table of varchar as the data is inserted from GL_SETS_OF_BOOKS, currency

Line 218: l_qty_funded_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
222: -- code column which has varchar2 data type.

Line 219: l_amt_funded_tbl PO_TBL_NUMBER;

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;

Line 511: l_Distribution_id_tbl PO_TBL_NUMBER;

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;

Line 513: l_req_Line_qty_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;

Line 514: l_price_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;

Line 515: l_nr_tax_tbl PO_TBL_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;

Line 517: l_qty_funded_tbl PO_TBL_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;

Line 520: l_funded_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

Line 521: l_Chg_Fund_Value_Tbl PO_TBL_NUMBER;

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;

Line 522: l_parent_Dist_Id_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;
526: --Clm_Split

Line 527: l_qty_funded_tbl := PO_TBL_NUMBER();

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;

Line 528: L_FUNDED_VALUE_TBL := PO_TBL_NUMBER();

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

Line 529: L_CHG_FUND_VALUE_TBL := PO_TBL_NUMBER();

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