4631: l_purchase_option_sty_id NUMBER;
4632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4633: l_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
4634: lx_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
4635: l_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4636: lx_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4637: l_empty_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
4638: l_empty_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4639: l_api_name CONSTANT VARCHAR2(30) := 'process_auto_inv';
4632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4633: l_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
4634: lx_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
4635: l_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4636: lx_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4637: l_empty_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
4638: l_empty_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4639: l_api_name CONSTANT VARCHAR2(30) := 'process_auto_inv';
4640: l_api_version CONSTANT NUMBER := 1;
4634: lx_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
4635: l_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4636: lx_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4637: l_empty_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
4638: l_empty_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
4639: l_api_name CONSTANT VARCHAR2(30) := 'process_auto_inv';
4640: l_api_version CONSTANT NUMBER := 1;
4641: l_msg_count NUMBER;
4642: l_msg_data VARCHAR2(2000);
4661: -- ansethur 23-FEB-07 R12B Added for Billing Enhancement Project Start Changes
4662: l_tldv_tbl okl_tld_pvt.tldv_tbl_type;
4663: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
4664:
4665: l_tilv_tbl okl_txl_ar_inv_lns_pub.tilv_tbl_type;
4666: lx_tilv_tbl okl_txl_ar_inv_lns_pub.tilv_tbl_type;
4667: -- ansethur 23-FEB-07 R12B Added for Billing Enhancement Project End Changes
4668: -- asawanka added for debug feature start
4669: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'process_auto_invoice';
4662: l_tldv_tbl okl_tld_pvt.tldv_tbl_type;
4663: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
4664:
4665: l_tilv_tbl okl_txl_ar_inv_lns_pub.tilv_tbl_type;
4666: lx_tilv_tbl okl_txl_ar_inv_lns_pub.tilv_tbl_type;
4667: -- ansethur 23-FEB-07 R12B Added for Billing Enhancement Project End Changes
4668: -- asawanka added for debug feature start
4669: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'process_auto_invoice';
4670: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
4950: 'Start(+)');
4951: END IF;
4952:
4953: -- Create Invoice Line
4954: OKL_TXL_AR_INV_LNS_PUB.insert_txl_ar_inv_lns (
4955: p_api_version => l_api_version,
4956: p_init_msg_list => OKL_API.G_FALSE,
4957: x_return_status => l_return_status,
4958: x_msg_count => l_msg_count,