DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_TRX_AP_INVOICES_V

Line 519: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;

515: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
516:
517: l_pay_to_id NUMBER;
518: l_pay_site_id NUMBER;
519: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;
520: l_payment_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
521: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
522: l_fee_line_amount NUMBER;
523: l_amount_disbursed NUMBER;

Line 520: l_payment_method okl_trx_ap_invoices_v.payment_method_code%TYPE;

516:
517: l_pay_to_id NUMBER;
518: l_pay_site_id NUMBER;
519: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;
520: l_payment_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
521: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
522: l_fee_line_amount NUMBER;
523: l_amount_disbursed NUMBER;
524: l_amnt_to_be_disbursed NUMBER;

Line 521: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;

517: l_pay_to_id NUMBER;
518: l_pay_site_id NUMBER;
519: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;
520: l_payment_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
521: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
522: l_fee_line_amount NUMBER;
523: l_amount_disbursed NUMBER;
524: l_amnt_to_be_disbursed NUMBER;
525: l_sty_id okl_strm_type_v.id%TYPE;

Line 1174: tap_id okl_trx_ap_invoices_v.id%TYPE,

1170: TYPE tld_err_rec_type IS RECORD (
1171: -- lsm_id okl_cnsld_ar_strms_v.id%TYPE,
1172: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1173: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1174: tap_id okl_trx_ap_invoices_v.id%TYPE,
1175: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1176: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1177: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1178: proc_sel_id okl_strm_elements.id%TYPE,

Line 1192: tap_id okl_trx_ap_invoices_v.id%TYPE,

1188: -- lsm_id okl_cnsld_ar_strms_v.id%TYPE,
1189: TYPE tld_succ_rec_type IS RECORD (
1190: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1191: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1192: tap_id okl_trx_ap_invoices_v.id%TYPE,
1193: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1194: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1195: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1196: proc_sel_id okl_strm_elements.id%TYPE,

Line 1241: l_pay_terms okl_trx_ap_invoices_v.ippt_id%TYPE;

1237: l_update_flag VARCHAR2(1);
1238:
1239: l_investor_id NUMBER;
1240: l_investor_site_id NUMBER;
1241: l_pay_terms okl_trx_ap_invoices_v.ippt_id%TYPE;
1242: l_pay_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
1243: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
1244:
1245: l_payment_basis fnd_lookups.meaning%TYPE;

Line 1242: l_pay_method okl_trx_ap_invoices_v.payment_method_code%TYPE;

1238:
1239: l_investor_id NUMBER;
1240: l_investor_site_id NUMBER;
1241: l_pay_terms okl_trx_ap_invoices_v.ippt_id%TYPE;
1242: l_pay_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
1243: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
1244:
1245: l_payment_basis fnd_lookups.meaning%TYPE;
1246: l_payment_event fnd_lookups.meaning%TYPE;

Line 1243: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;

1239: l_investor_id NUMBER;
1240: l_investor_site_id NUMBER;
1241: l_pay_terms okl_trx_ap_invoices_v.ippt_id%TYPE;
1242: l_pay_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
1243: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
1244:
1245: l_payment_basis fnd_lookups.meaning%TYPE;
1246: l_payment_event fnd_lookups.meaning%TYPE;
1247:

Line 1264: l_invoice_number okl_trx_ap_invoices_v.invoice_number%TYPE;

1260: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';
1261: lX_dbseqnm VARCHAR2(2000):= '';
1262: lX_dbseqid NUMBER(38):= NULL;
1263:
1264: l_invoice_number okl_trx_ap_invoices_v.invoice_number%TYPE;
1265:
1266: -- Create Distributions
1267: CURSOR dstrs_csr( p_pdt_id NUMBER, p_try_id NUMBER, p_sty_id NUMBER,
1268: p_cr_dr_flag VARCHAR2,

Line 1410: tap_id okl_trx_ap_invoices_v.id%TYPE,

1406: --ssiruvol Bug 5000886 end
1407:
1408: TYPE lsm_succ_rec_type IS RECORD (
1409: lsm_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1410: tap_id okl_trx_ap_invoices_v.id%TYPE,
1411: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1412: xpi_id okl_ext_pay_invs_v.id%TYPE,
1413: xlp_id okl_xtl_pay_invs_v.id%TYPE,
1414: proc_sel_id okl_strm_elements.id%TYPE,