eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_REBOOK_CM_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 213: okl_trx_ar_invoices_v tai,

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'
217: AND tld.sty_id = sty.id

Line 346: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;

342: -- Declare local variables used in the program
343: ------------------------------------------------------------
344:
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:

Line 347: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;

343: ------------------------------------------------------------
344:
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:

Line 348: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;

344:
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;

Line 356: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;

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;
358:
359:
360: l_header_id okl_trx_ar_invoices_v.id%TYPE;

Line 360: l_header_id okl_trx_ar_invoices_v.id%TYPE;

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;
362:
363:
364: ------------------------------------------------------------

Line 391: l_trx_status_code Okl_trx_ar_invoices_v.trx_status_code%TYPE;

387:
388:
389: l_error_status VARCHAR2(1);
390: l_error_message VARCHAR2(2000);
391: l_trx_status_code Okl_trx_ar_invoices_v.trx_status_code%TYPE;
392:
393:
394: -- To enforce commit frequency
395: l_commit_cnt NUMBER;

Line 1202: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;

1198: l_init_tldv_rec okl_tld_pvt.tldv_rec_type;
1199: r_tldv_rec okl_tld_pvt.tldv_rec_type;
1200:
1201:
1202: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1203: l_line_code CONSTANT VARCHAR2(30) := 'LINE';
1204:
1205:
1206: -----------------------------------------

Line 1559: FROM okl_trx_ar_invoices_v a,

1555:
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

Line 1570: FROM okl_trx_ar_invoices_v a,

1566:
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

Line 1780: okl_trx_ar_invoices_v tai,

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'
1784: AND tld.sty_id = p_sty_id

Line 1916: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;

1912: -- Declare local variables used in the program
1913: ------------------------------------------------------------
1914:
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:

Line 1917: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;

1913: ------------------------------------------------------------
1914:
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:

Line 1918: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;

1914:
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;

Line 1926: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;

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;
1928:
1929:
1930: l_header_id okl_trx_ar_invoices_v.id%TYPE;

Line 1930: l_header_id okl_trx_ar_invoices_v.id%TYPE;

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;
1932:
1933:
1934: ------------------------------------------------------------

Line 1963: l_trx_status_code Okl_trx_ar_invoices_v.trx_status_code%TYPE;

1959:
1960:
1961: l_error_status VARCHAR2(1);
1962: l_error_message VARCHAR2(2000);
1963: l_trx_status_code Okl_trx_ar_invoices_v.trx_status_code%TYPE;
1964:
1965:
1966: -- To enforce commit frequency
1967: l_commit_cnt NUMBER;

Line 2639: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;

2635: l_init_tldv_rec okl_tld_pvt.tldv_rec_type;
2636: r_tldv_rec okl_tld_pvt.tldv_rec_type;
2637:
2638:
2639: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
2640: l_line_code CONSTANT VARCHAR2(30) := 'LINE';
2641:
2642:
2643: -----------------------------------------