DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_TRX_AP_INVOICES_V

Line 504: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;

500: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
501:
502: l_pay_to_id NUMBER;
503: l_pay_site_id NUMBER;
504: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;
505: l_payment_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
506: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
507: l_fee_line_amount NUMBER;
508: l_amount_disbursed NUMBER;

Line 505: l_payment_method okl_trx_ap_invoices_v.payment_method_code%TYPE;

501:
502: l_pay_to_id NUMBER;
503: l_pay_site_id NUMBER;
504: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;
505: l_payment_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
506: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
507: l_fee_line_amount NUMBER;
508: l_amount_disbursed NUMBER;
509: l_amnt_to_be_disbursed NUMBER;

Line 506: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;

502: l_pay_to_id NUMBER;
503: l_pay_site_id NUMBER;
504: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;
505: l_payment_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
506: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
507: l_fee_line_amount NUMBER;
508: l_amount_disbursed NUMBER;
509: l_amnt_to_be_disbursed NUMBER;
510: l_sty_id okl_strm_type_v.id%TYPE;

Line 1104: tap_id okl_trx_ap_invoices_v.id%TYPE,

1100: TYPE tld_err_rec_type IS RECORD (
1101: -- lsm_id okl_cnsld_ar_strms_v.id%TYPE,
1102: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1103: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1104: tap_id okl_trx_ap_invoices_v.id%TYPE,
1105: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1106: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1107: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1108: proc_sel_id okl_strm_elements.id%TYPE,

Line 1122: tap_id okl_trx_ap_invoices_v.id%TYPE,

1118: -- lsm_id okl_cnsld_ar_strms_v.id%TYPE,
1119: TYPE tld_succ_rec_type IS RECORD (
1120: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1121: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1122: tap_id okl_trx_ap_invoices_v.id%TYPE,
1123: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1124: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1125: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1126: proc_sel_id okl_strm_elements.id%TYPE,

Line 1171: l_pay_terms okl_trx_ap_invoices_v.ippt_id%TYPE;

1167: l_update_flag VARCHAR2(1);
1168:
1169: l_investor_id NUMBER;
1170: l_investor_site_id NUMBER;
1171: l_pay_terms okl_trx_ap_invoices_v.ippt_id%TYPE;
1172: l_pay_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
1173: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
1174:
1175: l_payment_basis fnd_lookups.meaning%TYPE;

Line 1172: l_pay_method okl_trx_ap_invoices_v.payment_method_code%TYPE;

1168:
1169: l_investor_id NUMBER;
1170: l_investor_site_id NUMBER;
1171: l_pay_terms okl_trx_ap_invoices_v.ippt_id%TYPE;
1172: l_pay_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
1173: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
1174:
1175: l_payment_basis fnd_lookups.meaning%TYPE;
1176: l_payment_event fnd_lookups.meaning%TYPE;

Line 1173: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;

1169: l_investor_id NUMBER;
1170: l_investor_site_id NUMBER;
1171: l_pay_terms okl_trx_ap_invoices_v.ippt_id%TYPE;
1172: l_pay_method okl_trx_ap_invoices_v.payment_method_code%TYPE;
1173: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
1174:
1175: l_payment_basis fnd_lookups.meaning%TYPE;
1176: l_payment_event fnd_lookups.meaning%TYPE;
1177:

Line 1194: l_invoice_number okl_trx_ap_invoices_v.invoice_number%TYPE;

1190: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';
1191: lX_dbseqnm VARCHAR2(2000):= '';
1192: lX_dbseqid NUMBER(38):= NULL;
1193:
1194: l_invoice_number okl_trx_ap_invoices_v.invoice_number%TYPE;
1195:
1196: -- Create Distributions
1197: CURSOR dstrs_csr( p_pdt_id NUMBER, p_try_id NUMBER, p_sty_id NUMBER,
1198: p_cr_dr_flag VARCHAR2,

Line 1340: tap_id okl_trx_ap_invoices_v.id%TYPE,

1336: --ssiruvol Bug 5000886 end
1337:
1338: TYPE lsm_succ_rec_type IS RECORD (
1339: lsm_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1340: tap_id okl_trx_ap_invoices_v.id%TYPE,
1341: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1342: xpi_id okl_ext_pay_invs_v.id%TYPE,
1343: xlp_id okl_xtl_pay_invs_v.id%TYPE,
1344: proc_sel_id okl_strm_elements.id%TYPE,