DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

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

500:
501: begin
502:
503:
504: FOR acc_dtls_rec IN acc_dstrs_csr(p_tld_id, 'OKL_TXD_AR_LN_DTLS_B')
505: LOOP
506:
507: x_code_combination_id := acc_dtls_rec.code_combination_id;
508: x_dist_amount := acc_dtls_rec.amount;

Line 1634: p_source_table => 'OKL_TXD_AR_LN_DTLS_B',

1630: x_msg_count => x_msg_count,
1631: x_msg_data => x_msg_data,
1632: p_source_trx_id => lxfer_rec.TXN_ID,
1633: p_source_trx_name => lxfer_rec.try_name,
1634: p_source_table => 'OKL_TXD_AR_LN_DTLS_B',
1635: x_tax_det_rec => x_tax_det_rec);
1636:
1637:
1638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2082: FROM OKL_TXD_AR_LN_DTLS_B TLD,

2078: -- start: bug 6744584 .. racheruv. get the contingency_id and pass to AR
2079: -- for cash basis rev rec method on stream type.
2080: , STY.CONTINGENCY_ID
2081: -- end : bug 6744584 .. racheruv
2082: FROM OKL_TXD_AR_LN_DTLS_B TLD,
2083: OKL_TXL_AR_INV_LNS_V TIL,
2084: OKL_TRX_AR_INVOICES_V TAI,
2085: OKC_K_HEADERS_ALL_B KHR,
2086: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |

Line 3077: UPDATE Okl_Txd_Ar_Ln_Dtls_B

3073: UPDATE Okl_Txl_Ar_Inv_Lns_B
3074: SET RECEIVABLES_INVOICE_ID = l_customer_trx_id
3075: WHERE id = xfer_rec.TIL_ID;
3076: */
3077: UPDATE Okl_Txd_Ar_Ln_Dtls_B
3078: SET RECEIVABLES_INVOICE_ID = l_customer_trx_id
3079: WHERE id = xfer_rec.TXN_ID;
3080: --end: | 02-APR-07 cklee R12 Billing enhancement project |
3081: