[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
1541:
1542: CURSOR txd_cnt_succ_csr( p_req_id NUMBER ) IS
1543: SELECT count(*)
1544: FROM okl_trx_ar_invoices_v a,
1545: okl_txl_ar_inv_lns_v b,
1546: okl_txd_ar_ln_dtls_v c
1547: WHERE a.id = b.tai_id AND
1548: b.id = c.til_id_details AND
1549: a.trx_status_code = 'SUBMITTED' AND
1552:
1553: CURSOR txd_cnt_err_csr( p_req_id NUMBER ) IS
1554: SELECT count(*)
1555: FROM okl_trx_ar_invoices_v a,
1556: okl_txl_ar_inv_lns_v b,
1557: okl_txd_ar_ln_dtls_v c
1558: WHERE a.id = b.tai_id AND
1559: b.id = c.til_id_details AND
1560: a.trx_status_code = 'ERROR' AND
1760: okc_k_lines_b kle,
1761: okc_statuses_b khs,
1762: okc_statuses_b kls,
1763: okl_txd_ar_ln_dtls_v tld,
1764: okl_txl_ar_inv_lns_v til,
1765: okl_trx_ar_invoices_v tai,
1766: okl_bpd_tld_ar_lines_v tldv,
1767: AR_PAYMENT_SCHEDULES_ALL PS
1768: WHERE sty.billable_yn = 'Y'
1900:
1901: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;
1902: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
1903: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1904: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1905:
1906:
1907: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1908: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1903: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1904: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1905:
1906:
1907: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1908: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1909:
1910:
1911: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1908: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1909:
1910:
1911: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1912: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
1913:
1914:
1915: l_header_id okl_trx_ar_invoices_v.id%TYPE;
1916: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
1912: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
1913:
1914:
1915: l_header_id okl_trx_ar_invoices_v.id%TYPE;
1916: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
1917:
1918:
1919: ------------------------------------------------------------
1920: -- Declare variables required by APIs