APPS.OKL_CURE_RECON_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 509: FROM OKL_TXD_AR_LN_DTLS_b

505:
506: CURSOR c_get_txd_obj_ver ( p_til_id_details IN NUMBER)
507: IS
508: SELECT object_version_number,id
509: FROM OKL_TXD_AR_LN_DTLS_b
510: WHERE til_id_details = p_til_id_details;
511:
512: lp_taiv_rec okl_tai_pvt.taiv_rec_type;
513: xp_taiv_rec okl_tai_pvt.taiv_rec_type;

Line 715: -- OKL_TXD_AR_LN_DTLS_B

711: -- Start of comments
712: --
713: -- Procedure Name : additional_tld_attr
714: -- Description : Internal procedure to add additional columns for
715: -- OKL_TXD_AR_LN_DTLS_B
716: -- Important Note : This procedure taken from BPD package on Ashim's advise
717: -- Business Rules :
718: -- Parameters :
719: --

Line 747: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;

743: AND b.khr_id = p_khr_id;
744:
745: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
746: l_precision fnd_currencies.PRECISION %TYPE;
747: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;
748:
749: -- to get inventory_org_id bug 4890024 begin
750: CURSOR inv_org_id_csr(p_contract_id NUMBER) IS
751: SELECT NVL(inv_organization_id, -99)

Line 2054: ,okl_txd_ar_ln_dtls_b tld

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
2057: AND tld.til_id_details = til.id;
2058:

Line 2062: l_line_id okl_txd_ar_ln_dtls_b.id%TYPE;

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

Line 2193: l_dist_info_tbl(1).source_table := 'OKL_TXD_AR_LN_DTLS_B';

2189: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).transaction_type_id : '||l_tmpl_identify_tbl(1).transaction_type_id);
2190: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).stream_type_id : '||l_tmpl_identify_tbl(1).stream_type_id);
2191:
2192: l_dist_info_tbl(1).source_id := l_line_id;
2193: l_dist_info_tbl(1).source_table := 'OKL_TXD_AR_LN_DTLS_B';
2194: l_dist_info_tbl(1).accounting_date := l_date_invoiced;
2195: l_dist_info_tbl(1).gl_reversal_flag :='N';
2196: l_dist_info_tbl(1).post_to_gl :='N';
2197: l_dist_info_tbl(1).contract_id :=l_khr_id;