[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;
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
1550: a.request_id = p_req_id ;
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
1561: a.request_id = p_req_id ;
1759: okl_k_headers khl,
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
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;
1912: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;