DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 246: FOR acc_dtls_rec IN acc_dstrs_csr(p_tld_id, 'OKL_TXD_AR_LN_DTLS_B')

242:
243: begin
244:
245:
246: FOR acc_dtls_rec IN acc_dstrs_csr(p_tld_id, 'OKL_TXD_AR_LN_DTLS_B')
247: LOOP
248:
249: x_code_combination_id := acc_dtls_rec.code_combination_id;
250: x_dist_amount := acc_dtls_rec.amount;

Line 1426: p_source_table => 'OKL_TXD_AR_LN_DTLS_B',

1422: x_msg_count => x_msg_count,
1423: x_msg_data => x_msg_data,
1424: p_source_trx_id => lxfer_rec.TXN_ID,
1425: p_source_trx_name => lxfer_rec.try_name,
1426: p_source_table => 'OKL_TXD_AR_LN_DTLS_B',
1427: x_tax_det_rec => x_tax_det_rec);
1428:
1429:
1430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1874: FROM OKL_TXD_AR_LN_DTLS_B TLD,

1870: -- start: bug 6744584 .. racheruv. get the contingency_id and pass to AR
1871: -- for cash basis rev rec method on stream type.
1872: , STY.CONTINGENCY_ID
1873: -- end : bug 6744584 .. racheruv
1874: FROM OKL_TXD_AR_LN_DTLS_B TLD,
1875: OKL_TXL_AR_INV_LNS_V TIL,
1876: OKL_TRX_AR_INVOICES_V TAI,
1877: OKC_K_HEADERS_ALL_B KHR,
1878: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |

Line 2931: UPDATE Okl_Txd_Ar_Ln_Dtls_B

2927: UPDATE Okl_Txl_Ar_Inv_Lns_B
2928: SET RECEIVABLES_INVOICE_ID = l_customer_trx_id
2929: WHERE id = xfer_rec.TIL_ID;
2930: */
2931: UPDATE Okl_Txd_Ar_Ln_Dtls_B
2932: SET RECEIVABLES_INVOICE_ID = l_customer_trx_id
2933: WHERE id = xfer_rec.TXN_ID;
2934: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2935: