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

Line 729: okl_trx_ar_invoices_b tai,

725: SELECT st.khr_id contract_id,
726: cn.contract_number
727: FROM okl_xtl_sell_invs_v xls,
728: okl_txl_ar_inv_lns_b til,
729: okl_trx_ar_invoices_b tai,
730: okc_k_headers_all_b cn,
731: ar_payment_schedules_all ps,
732: ar_receivable_applications_all arapp,
733: okl_cnsld_ar_strms_b st,

Line 767: okl_trx_ar_invoices_b tai,

763: SELECT st.khr_id contract_id,
764: cn.contract_number
765: FROM okl_xtl_sell_invs_v xls,
766: okl_txl_ar_inv_lns_b til,
767: okl_trx_ar_invoices_b tai,
768: okc_k_headers_b cn,
769: ar_payment_schedules_all ps,
770: ar_receivable_applications_all arapp,
771: okl_cnsld_ar_strms_b st,

Line 1765: okl_trx_ar_invoices_b tai,

1761: tai.date_invoiced,
1762: tai.amount,
1763: tai.currency_code
1764: from
1765: okl_trx_ar_invoices_b tai,
1766: okl_txl_ar_inv_lns_b til,
1767: okl_cure_refunds crf
1768: where tai.id =til.tai_id
1769: and tai.id =crf.tai_id

Line 1781: from okl_trx_ar_invoices_b tai,

1777: tai.khr_id khr_id,
1778: tai.date_invoiced date_invoiced,
1779: tai.amount amount,
1780: tai.currency_code currency_code
1781: from okl_trx_ar_invoices_b tai,
1782: okl_txl_ar_inv_lns_b til,
1783: okl_txd_ar_ln_dtls_b txd,
1784: okl_cure_refunds crf
1785: where crf.cure_refund_header_id = p_refund_header_id

Line 1794: l_tai_id okl_trx_ar_invoices_b.id%TYPE;

1790:
1791:
1792: -- ASHIM CHANGE - END
1793:
1794: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1795: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
1796: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
1797: l_line_id okl_txl_ar_inv_lns_b.id%TYPE;
1798: l_khr_id okc_k_headers_b.id%TYPE;

Line 1796: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;

1792: -- ASHIM CHANGE - END
1793:
1794: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1795: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
1796: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
1797: l_line_id okl_txl_ar_inv_lns_b.id%TYPE;
1798: l_khr_id okc_k_headers_b.id%TYPE;
1799: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
1800: l_amount okl_trx_ar_invoices_b.amount%TYPE;

Line 1799: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;

1795: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
1796: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
1797: l_line_id okl_txl_ar_inv_lns_b.id%TYPE;
1798: l_khr_id okc_k_headers_b.id%TYPE;
1799: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
1800: l_amount okl_trx_ar_invoices_b.amount%TYPE;
1801:
1802: CURSOR product_csr (p_chr_id IN NUMBER) IS
1803: SELECT khr.pdt_id,

Line 1800: l_amount okl_trx_ar_invoices_b.amount%TYPE;

1796: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
1797: l_line_id okl_txl_ar_inv_lns_b.id%TYPE;
1798: l_khr_id okc_k_headers_b.id%TYPE;
1799: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
1800: l_amount okl_trx_ar_invoices_b.amount%TYPE;
1801:
1802: CURSOR product_csr (p_chr_id IN NUMBER) IS
1803: SELECT khr.pdt_id,
1804: chr.scs_code --Bug# 4622198

Line 2059: p_trx_header_table => 'OKL_TRX_AR_INVOICES_B'); -- 06/28/07 cklee

2055: p_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl,
2056: x_template_tbl => l_template_tbl,
2057: x_amount_tbl => l_amount_tbl,
2058: p_trx_header_id => j.tai_id,--); 06/28/07 cklee
2059: p_trx_header_table => 'OKL_TRX_AR_INVOICES_B'); -- 06/28/07 cklee
2060:
2061: -- R12 CHANGE - END
2062:
2063: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: CREATE_TAI_ACCOUNTING : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);

Line 3167: okl_trx_ar_invoices_b b

3163: CURSOR l_curr_csr(p_khr_id number) IS
3164: SELECT c.minimum_accountable_unit,
3165: c.PRECISION
3166: FROM fnd_currencies c,
3167: okl_trx_ar_invoices_b b
3168: WHERE c.currency_code = b.currency_code
3169: AND b.khr_id = p_khr_id;
3170:
3171:

Line 3437: --INSERT okl_trx_ar_invoices_b

3433: /**logic
3434: 1) create tai * TIL
3435: **/
3436:
3437: --INSERT okl_trx_ar_invoices_b
3438: --set error message,so this will be prefixed before the
3439: --actual message, so it makes more sense than displaying an
3440: -- OKL message.
3441: AddfailMsg(

Line 3683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error in updating okl_trx_ar_invoices_b '

3679:
3680: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3681: Get_Messages (l_msg_count,l_message);
3682: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error in updating okl_trx_ar_invoices_b '
3684: ||l_message);
3685: END IF;
3686: raise FND_API.G_EXC_ERROR;
3687: ELSE

Line 4381: p_object => 'RECORD IN OKL_TRX_AR_INVOICES_B ',

4377: --set error message,so this will be prefixed before the
4378: --actual message, so it makes more sense than displaying an
4379: -- OKL message.
4380: AddfailMsg(
4381: p_object => 'RECORD IN OKL_TRX_AR_INVOICES_B ',
4382: p_operation => 'CREATE' );
4383:
4384:
4385: -- ASHIM CHANGE - START