[Home] [Help]
207: okl_k_headers khl,
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
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;
357: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
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
1565: a.request_id = p_req_id ;
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
1576: a.request_id = p_req_id ;
1774: okl_k_headers khl,
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
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;
1927: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;