[Home] [Help]
618: FETCH cust_trx_type_csr INTO l_type;
619: CLOSE cust_trx_type_csr;
620: --Bug# 10160494
621:
622: FOR acc_dtls_rec IN acc_dstrs_csr(p_tld_id, 'OKL_TXD_AR_LN_DTLS_B') LOOP
623:
624: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
625: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.Get_acct_disb.debug','acc_dtls_rec.cr_dr_flag'||acc_dtls_rec.cr_dr_flag);
626: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.Get_acct_disb.debug','acc_dtls_rec.code_combination_id'||acc_dtls_rec.code_combination_id);
1994: -- bug 6744584: contingency fix, added contingecy_id..racheruv
1995: , STY.CONTINGENCY_ID
1996: , TLD.INVOICE_FORMAT_LINE_TYPE INVOICE_LINE_TYPE -- Bug 7045347
1997: , TIL.ID TIL_ID -- Bug# 12617408
1998: FROM OKL_TXD_AR_LN_DTLS_B TLD,
1999: OKL_TXL_AR_INV_LNS_V TIL,
2000: OKL_TRX_AR_INVOICES_V TAI,
2001: OKC_K_HEADERS_ALL_B KHR,
2002: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2143: FROM hr_operating_units
2144: WHERE organization_id = mo_global.get_current_org_id;
2145:
2146:
2147: -- For R12, OKL_TXD_AR_LN_DTLS_B will be invoice line.
2148: --
2149: CURSOR tld_cnt_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
2150: SELECT count(1)
2151: FROM OKL_TXD_AR_LN_DTLS_B TLD
2147: -- For R12, OKL_TXD_AR_LN_DTLS_B will be invoice line.
2148: --
2149: CURSOR tld_cnt_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
2150: SELECT count(1)
2151: FROM OKL_TXD_AR_LN_DTLS_B TLD
2152: WHERE EXISTS
2153: (SELECT 1
2154: FROM OKL_TRX_AR_INVOICES_B TAI,
2155: OKL_TXL_AR_INV_LNS_B TIL
2159: AND TAI.request_id = p_req_id);
2160:
2161: CURSOR tld_cnt_csr_selected( p_req_id NUMBER ) IS
2162: SELECT count(1)
2163: FROM OKL_TXD_AR_LN_DTLS_B TLD
2164: WHERE EXISTS
2165: (SELECT 1
2166: FROM OKL_TRX_AR_INVOICES_B TAI,
2167: OKL_TXL_AR_INV_LNS_B TIL
2366:
2367: --start: | 15-FEB-07 cklee R12 Billing enhancement project
2368: --l_error_xsi_id okl_ext_sell_invs_v.id%TYPE;
2369: l_error_tai_id okl_trx_ar_invoices_b.id%TYPE;
2370: l_error_txd_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
2371: --end: | 15-FEB-07 cklee R12 Billing enhancement project
2372:
2373: hdr_cnt NUMBER;
2374: sales_cr_cnt NUMBER;
2382:
2383: l_memo_line_id ar_memo_lines.memo_line_id%TYPE;
2384: */
2385:
2386: Cursor is_legacy_invoice (p_rev_txn_id OKL_TXD_AR_LN_DTLS_B.id%type) is
2387: select lsm_id
2388: from OKL_TXD_AR_LN_DTLS_B
2389: where id = p_rev_txn_id;
2390:
2384: */
2385:
2386: Cursor is_legacy_invoice (p_rev_txn_id OKL_TXD_AR_LN_DTLS_B.id%type) is
2387: select lsm_id
2388: from OKL_TXD_AR_LN_DTLS_B
2389: where id = p_rev_txn_id;
2390:
2391: l_lsm_id OKL_TXD_AR_LN_DTLS_B.lsm_id%type;
2392:
2387: select lsm_id
2388: from OKL_TXD_AR_LN_DTLS_B
2389: where id = p_rev_txn_id;
2390:
2391: l_lsm_id OKL_TXD_AR_LN_DTLS_B.lsm_id%type;
2392:
2393: Cursor get_invoice_line_id (p_rev_txn_id OKL_TXD_AR_LN_DTLS_B.id%type) is
2394: select a.customer_trx_line_id
2395: from ra_customer_trx_lines_all a
2389: where id = p_rev_txn_id;
2390:
2391: l_lsm_id OKL_TXD_AR_LN_DTLS_B.lsm_id%type;
2392:
2393: Cursor get_invoice_line_id (p_rev_txn_id OKL_TXD_AR_LN_DTLS_B.id%type) is
2394: select a.customer_trx_line_id
2395: from ra_customer_trx_lines_all a
2396: where a.INTERFACE_LINE_ATTRIBUTE14 = to_char(p_rev_txn_id); -- AKP
2397:
2410: txs.entity_code,
2411: inv.tax_line_id -- Bug 6619311
2412: FROM okl_tax_sources txs,
2413: okl_txl_ar_inv_lns_b inv
2414: ,okl_txd_ar_ln_dtls_b tld
2415: WHERE txs.trx_id = inv.txs_trx_id
2416: AND trx_line_id = inv.txs_trx_line_id
2417: AND inv.id = tld.til_id_details
2418: AND inv.tai_id = p_tai_id
3710: x_msg_data => x_msg_data,
3711: p_source_trx_id => l_xfer_tbl(k).TXN_ID,
3712: --p_source_trx_name => l_xfer_tbl(k).try_name, --sechawla 01-jun-11 12539101
3713: p_source_trx_name => l_trx_type_name, --sechawla 01-jun-11 12539101
3714: p_source_table => 'OKL_TXD_AR_LN_DTLS_B',
3715: x_tax_det_rec => x_tax_det_rec); -- 5902234
3716: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3717: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','okl_process_sales_tax_pvt.get_tax_determinants returned with x_return_status:'||x_return_status);
3718: END IF;
4553: LOOP
4554: DELETE FROM RA_INTERFACE_SALESCREDITS
4555: WHERE interface_line_attribute14 IN
4556: (SELECT TLD.ID
4557: FROM OKL_TXD_AR_LN_DTLS_B TLD
4558: , OKL_TXL_AR_INV_LNS_B TIL
4559: , OKL_TRX_AR_INVOICES_B TAI
4560: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4561: AND TAI.ID = TIL.TAI_ID
4563:
4564: DELETE FROM AR_INTERFACE_CONTS
4565: WHERE interface_line_attribute14 IN
4566: (SELECT TLD.ID
4567: FROM OKL_TXD_AR_LN_DTLS_B TLD
4568: , OKL_TXL_AR_INV_LNS_B TIL
4569: , OKL_TRX_AR_INVOICES_B TAI
4570: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4571: AND TAI.ID = TIL.TAI_ID
4573:
4574: DELETE FROM RA_INTERFACE_DISTRIBUTIONS
4575: WHERE interface_line_attribute14 IN
4576: (SELECT TLD.ID
4577: FROM OKL_TXD_AR_LN_DTLS_B TLD
4578: , OKL_TXL_AR_INV_LNS_B TIL
4579: , OKL_TRX_AR_INVOICES_B TAI
4580: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4581: AND TAI.ID = TIL.TAI_ID
4583:
4584: DELETE FROM RA_INTERFACE_LINES
4585: WHERE interface_line_attribute14 IN
4586: (SELECT TLD.ID
4587: FROM OKL_TXD_AR_LN_DTLS_B TLD
4588: , OKL_TXL_AR_INV_LNS_B TIL
4589: , OKL_TRX_AR_INVOICES_B TAI
4590: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4591: AND TAI.ID = TIL.TAI_ID