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_CURE_RECON_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 497: FROM okl_trx_ar_invoices_b

493:
494: CURSOR c_get_obj_ver ( p_tai_id IN NUMBER)
495: IS
496: SELECT object_version_number
497: FROM okl_trx_ar_invoices_b
498: WHERE id = p_tai_id;
499:
500: CURSOR c_get_til_obj_ver ( p_tai_id IN NUMBER)
501: IS

Line 579: ,'Error in updating okl_trx_ar_invoices_b '||l_message);

575: IF (G_IS_DEBUG_STATEMENT_ON = true)
576: THEN
577: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
578: , G_MODULE
579: ,'Error in updating okl_trx_ar_invoices_b '||l_message);
580: END IF;
581: raise FND_API.G_EXC_ERROR;
582: ELSE
583: FND_MSG_PUB.initialize;

Line 741: okl_trx_ar_invoices_b b

737: CURSOR l_curr_csr(p_khr_id number) IS
738: SELECT c.minimum_accountable_unit,
739: c.PRECISION
740: FROM fnd_currencies c,
741: okl_trx_ar_invoices_b b
742: WHERE c.currency_code = b.currency_code
743: AND b.khr_id = p_khr_id;
744:
745: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

Line 1026: --INSERT okl_trx_ar_invoices_b set error message,so this will be prefixed before

1022: , 'start INSERT_INVOICE_HDR_LINES');
1023: END IF;
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: --INSERT okl_trx_ar_invoices_b set error message,so this will be prefixed before
1027: --the actual message, so it makes more sense than displaying an OKL message.
1028: AddfailMsg(
1029: p_object => 'RECORD IN OKL_TRX_AR_INVOICES ',
1030: p_operation => 'INSERT' );

Line 1355: 'Error in updating okl_trx_ar_invoices_b '||l_message);

1351: IF (G_IS_DEBUG_STATEMENT_ON = true)
1352: THEN
1353: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1354: G_MODULE,
1355: 'Error in updating okl_trx_ar_invoices_b '||l_message);
1356: END IF;
1357: raise FND_API.G_EXC_ERROR;
1358: ELSE
1359: FND_MSG_PUB.initialize;

Line 1607: 'Error in updating okl_trx_ar_invoices_b '||l_message);

1603: IF (G_IS_DEBUG_STATEMENT_ON = true)
1604: THEN
1605: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1606: G_MODULE,
1607: 'Error in updating okl_trx_ar_invoices_b '||l_message);
1608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1609: G_MODULE,
1610: 'Error from the API : ' ||l_err_msg);
1611: END IF;

Line 1672: from okl_trx_ar_invoices_b where

1668: || l_api_name;
1669:
1670: Cursor c_get_tai_id ( p_cam_id IN NUMBER) is
1671: select id
1672: from okl_trx_ar_invoices_b where
1673: cpy_id =p_cam_id;
1674:
1675: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1676: l_process OKL_CURE_AMOUNTS.process%TYPE;

Line 1675: l_tai_id okl_trx_ar_invoices_b.id%TYPE;

1671: select id
1672: from okl_trx_ar_invoices_b where
1673: cpy_id =p_cam_id;
1674:
1675: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1676: l_process OKL_CURE_AMOUNTS.process%TYPE;
1677: BEGIN
1678:
1679: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_TAI_TIL : START ');

Line 2052: FROM okl_trx_ar_invoices_b tai

2048: ,tld.id
2049: ,tai.khr_id
2050: ,tai.date_invoiced
2051: ,tai.amount
2052: FROM okl_trx_ar_invoices_b tai
2053: ,okl_txl_ar_inv_lns_b til
2054: ,okl_txd_ar_ln_dtls_b tld
2055: WHERE tai.cpy_id = p_cam_id
2056: AND tai.id = til.tai_id

Line 2059: l_tai_id okl_trx_ar_invoices_b.id%TYPE;

2055: WHERE tai.cpy_id = p_cam_id
2056: AND tai.id = til.tai_id
2057: AND tld.til_id_details = til.id;
2058:
2059: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
2060: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
2061: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
2062: l_line_id okl_txd_ar_ln_dtls_b.id%TYPE;
2063: l_khr_id okc_k_headers_b.id%TYPE;

Line 2061: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;

2057: AND tld.til_id_details = til.id;
2058:
2059: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
2060: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
2061: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
2062: l_line_id okl_txd_ar_ln_dtls_b.id%TYPE;
2063: l_khr_id okc_k_headers_b.id%TYPE;
2064: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
2065: l_amount okl_trx_ar_invoices_b.amount%TYPE;

Line 2064: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;

2060: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
2061: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
2062: l_line_id okl_txd_ar_ln_dtls_b.id%TYPE;
2063: l_khr_id okc_k_headers_b.id%TYPE;
2064: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
2065: l_amount okl_trx_ar_invoices_b.amount%TYPE;
2066:
2067: CURSOR get_product_id(p_cam_id IN NUMBER)
2068: IS

Line 2065: l_amount okl_trx_ar_invoices_b.amount%TYPE;

2061: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
2062: l_line_id okl_txd_ar_ln_dtls_b.id%TYPE;
2063: l_khr_id okc_k_headers_b.id%TYPE;
2064: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
2065: l_amount okl_trx_ar_invoices_b.amount%TYPE;
2066:
2067: CURSOR get_product_id(p_cam_id IN NUMBER)
2068: IS
2069: SELECT okl.pdt_id

Line 2400: p_trx_header_table => 'OKL_TRX_AR_INVOICES_B');

2396: p_acc_gen_primary_key_tbl => l_acc_gen_tbl,
2397: x_template_tbl => l_template_tbl,
2398: x_amount_tbl => l_amount_tbl,
2399: p_trx_header_id => l_tai_id,
2400: p_trx_header_table => 'OKL_TRX_AR_INVOICES_B');
2401:
2402: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);
2403:
2404: -- R12 CHANGE - END