DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_TRX_AP_INVOICES_V

Line 889: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;

885: lx_tplv_tbl OKL_TPL_PVT.tplv_tbl_type;
886:
887: l_cnsld_invs cnsld_invs_tbl_type;
888:
889: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;
890:
891: CURSOR c_invoice IS
892: SELECT
893: tap.id tap_id

Line 1696: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;

1692: lx_tplv_tbl OKL_TPL_PVT.tplv_tbl_type;
1693:
1694: -- l_cnsld_invs cnsld_invs_tbl_type;
1695:
1696: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;
1697: l_conc_status VARCHAR2(1);
1698:
1699: -- Main cursor to get the consolidate invoice header
1700: CURSOR c_cin_invoice IS

Line 2666: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;

2662: /* -- Nulling record */
2663: /* l_init_tilv_rec okl_til_pvt.tilv_rec_type; */
2664: --
2665:
2666: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;
2667: l_okl_application_id NUMBER(3) := 540;
2668: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';
2669: lX_dbseqnm VARCHAR2(2000):= '';
2670: lX_dbseqid NUMBER(38):= NULL;

Line 3245: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;

3241:
3242: -----------------------------------------------------------
3243: -- Variables for Bug 2949640, Sunil Mathew, 12-May-2003
3244: -----------------------------------------------------------
3245: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;
3246: l_okl_application_id NUMBER(3) := 540;
3247: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';
3248: lX_dbseqnm VARCHAR2(2000):= '';
3249: lX_dbseqid NUMBER(38):= NULL;

Line 4299: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;

4295:
4296: -----------------------------------------------------------
4297: -- Variables for Bug 2949640, Sunil Mathew, 12-May-2003
4298: -----------------------------------------------------------
4299: l_gen_seq okl_trx_ap_invoices_v.invoice_number%TYPE;
4300: l_okl_application_id NUMBER(3) := 540;
4301: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';
4302: lX_dbseqnm VARCHAR2(2000):= '';
4303: lX_dbseqid NUMBER(38):= NULL;