263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_receivables_invoice_id IN NUMBER,
267: p_tapv_rec IN okl_tap_pvt.tapv_rec_type,
268: p_tplv_rec IN okl_tpl_pvt.tplv_rec_type,
269: x_tapv_rec OUT NOCOPY okl_tap_pvt.tapv_rec_type)
270: IS
271:
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_receivables_invoice_id IN NUMBER,
267: p_tapv_rec IN okl_tap_pvt.tapv_rec_type,
268: p_tplv_rec IN okl_tpl_pvt.tplv_rec_type,
269: x_tapv_rec OUT NOCOPY okl_tap_pvt.tapv_rec_type)
270: IS
271:
272: -----------------------------------------------------------------
273: -- Declare Process Variable
279: lX_dbseqid NUMBER(38):= NULL;
280: ------------------------------------------------------------
281: -- Declare records: Payable Invoice Headers, Lines and Distributions
282: ------------------------------------------------------------
283: l_tapv_rec Okl_tap_pvt.tapv_rec_type;
284: lx_tapv_rec Okl_tap_pvt.tapv_rec_type;
285: l_tplv_rec okl_tpl_pvt.tplv_rec_type;
286: lx_tplv_rec okl_tpl_pvt.tplv_rec_type;
287:
280: ------------------------------------------------------------
281: -- Declare records: Payable Invoice Headers, Lines and Distributions
282: ------------------------------------------------------------
283: l_tapv_rec Okl_tap_pvt.tapv_rec_type;
284: lx_tapv_rec Okl_tap_pvt.tapv_rec_type;
285: l_tplv_rec okl_tpl_pvt.tplv_rec_type;
286: lx_tplv_rec okl_tpl_pvt.tplv_rec_type;
287:
288: --start:| 18-May-07 cklee -- Accounting API CR, Disbursement Central API uptake |
293: l_tmpl_identify_rec Okl_Account_Dist_Pvt.TMPL_IDENTIFY_REC_TYPE;
294: l_dist_info_rec Okl_Account_Dist_Pvt.dist_info_REC_TYPE;
295: l_ctxt_val_tbl okl_execute_formula_pvt.ctxt_val_tbl_type;
296: l_acc_gen_primary_key_tbl Okl_Account_Generator_Pvt.primary_key_tbl;
297: lu_tapv_rec Okl_tap_pvt.tapv_rec_type;
298: lux_tapv_rec Okl_tap_pvt.tapv_rec_type;
299:
300: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
301: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
294: l_dist_info_rec Okl_Account_Dist_Pvt.dist_info_REC_TYPE;
295: l_ctxt_val_tbl okl_execute_formula_pvt.ctxt_val_tbl_type;
296: l_acc_gen_primary_key_tbl Okl_Account_Generator_Pvt.primary_key_tbl;
297: lu_tapv_rec Okl_tap_pvt.tapv_rec_type;
298: lux_tapv_rec Okl_tap_pvt.tapv_rec_type;
299:
300: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
301: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
302: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
805:
806: ------------------------------------------------------------
807: -- Declare records: Payable Invoice Headers, Lines and Distributions
808: ------------------------------------------------------------
809: l_tapv_rec Okl_tap_pvt.tapv_rec_type;
810: l_tplv_rec okl_tpl_pvt.tplv_rec_type;
811: l_tapv_rec_null Okl_tap_pvt.tapv_rec_type;
812: l_tplv_rec_null okl_tpl_pvt.tplv_rec_type;
813: lx_tapv_rec Okl_tap_pvt.tapv_rec_type;
807: -- Declare records: Payable Invoice Headers, Lines and Distributions
808: ------------------------------------------------------------
809: l_tapv_rec Okl_tap_pvt.tapv_rec_type;
810: l_tplv_rec okl_tpl_pvt.tplv_rec_type;
811: l_tapv_rec_null Okl_tap_pvt.tapv_rec_type;
812: l_tplv_rec_null okl_tpl_pvt.tplv_rec_type;
813: lx_tapv_rec Okl_tap_pvt.tapv_rec_type;
814: l_disb_rec disb_rec_type;
815:
809: l_tapv_rec Okl_tap_pvt.tapv_rec_type;
810: l_tplv_rec okl_tpl_pvt.tplv_rec_type;
811: l_tapv_rec_null Okl_tap_pvt.tapv_rec_type;
812: l_tplv_rec_null okl_tpl_pvt.tplv_rec_type;
813: lx_tapv_rec Okl_tap_pvt.tapv_rec_type;
814: l_disb_rec disb_rec_type;
815:
816: -- Cursor to get the AR invoice Numbers for log file
817: CURSOR ar_inv_csr ( p_receivables_invoice_id NUMBER ) IS