[Home] [Help]
208: okc_k_lines_b kle,
209: okc_statuses_b khs,
210: okc_statuses_b kls,
211: okl_txd_ar_ln_dtls_v tld,
212: okl_txl_ar_inv_lns_v til,
213: okl_trx_ar_invoices_v tai,
214: okl_bpd_tld_ar_lines_v tldv,
215: AR_PAYMENT_SCHEDULES_ALL PS
216: WHERE sty.billable_yn = 'Y'
345:
346: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;
347: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
348: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
349: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
350:
351:
352: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
353: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
348: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
349: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
350:
351:
352: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
353: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
354:
355:
356: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
353: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
354:
355:
356: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
357: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
358:
359:
360: l_header_id okl_trx_ar_invoices_v.id%TYPE;
361: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
357: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
358:
359:
360: l_header_id okl_trx_ar_invoices_v.id%TYPE;
361: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
362:
363:
364: ------------------------------------------------------------
365: -- Declare variables required by APIs
1556:
1557: CURSOR txd_cnt_succ_csr( p_req_id NUMBER ) IS
1558: SELECT count(*)
1559: FROM okl_trx_ar_invoices_v a,
1560: okl_txl_ar_inv_lns_v b,
1561: okl_txd_ar_ln_dtls_v c
1562: WHERE a.id = b.tai_id AND
1563: b.id = c.til_id_details AND
1564: a.trx_status_code = 'SUBMITTED' AND
1567:
1568: CURSOR txd_cnt_err_csr( p_req_id NUMBER ) IS
1569: SELECT count(*)
1570: FROM okl_trx_ar_invoices_v a,
1571: okl_txl_ar_inv_lns_v b,
1572: okl_txd_ar_ln_dtls_v c
1573: WHERE a.id = b.tai_id AND
1574: b.id = c.til_id_details AND
1575: a.trx_status_code = 'ERROR' AND
1775: okc_k_lines_b kle,
1776: okc_statuses_b khs,
1777: okc_statuses_b kls,
1778: okl_txd_ar_ln_dtls_v tld,
1779: okl_txl_ar_inv_lns_v til,
1780: okl_trx_ar_invoices_v tai,
1781: okl_bpd_tld_ar_lines_v tldv,
1782: AR_PAYMENT_SCHEDULES_ALL PS
1783: WHERE sty.billable_yn = 'Y'
1915:
1916: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;
1917: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
1918: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1919: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1920:
1921:
1922: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1923: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1918: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1919: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1920:
1921:
1922: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1923: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1924:
1925:
1926: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1923: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1924:
1925:
1926: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1927: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
1928:
1929:
1930: l_header_id okl_trx_ar_invoices_v.id%TYPE;
1931: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
1927: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
1928:
1929:
1930: l_header_id okl_trx_ar_invoices_v.id%TYPE;
1931: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
1932:
1933:
1934: ------------------------------------------------------------
1935: -- Declare variables required by APIs