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

Line 771: l_bank_id OKL_TRX_AR_INVOICES_B.CUSTOMER_BANK_ACCOUNT_ID%TYPE := p_bank_id;

767: x_msg_data OUT NOCOPY VARCHAR2
768:
769: ) IS
770:
771: l_bank_id OKL_TRX_AR_INVOICES_B.CUSTOMER_BANK_ACCOUNT_ID%TYPE := p_bank_id;
772:
773: CURSOR instr_type_csr(p_instr_use_id NUMBER)
774: IS
775: SELECT ipiu.payment_function

Line 2039: FROM okl_trx_ar_invoices_b tai,

2035: ,tai.id tai_id
2036: ,tai.okl_source_billing_trx
2037: ,tai.ixx_id customer_id
2038: ,iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
2039: FROM okl_trx_ar_invoices_b tai,
2040: okc_k_headers_b khr,
2041: hz_cust_accounts hca
2042: WHERE tai.khr_id = khr.id
2043: AND tai.ixx_id = khr.cust_acct_id

Line 2054: FROM okl_trx_ar_invoices_b tai,

2050: CURSOR cust_bankrupt_cnt_csr IS
2051: SELECT khr.contract_number khr_number
2052: ,nvl(hca.account_name,hp.party_name) name
2053: ,COUNT(tai.id) cust_rec_cnt
2054: FROM okl_trx_ar_invoices_b tai,
2055: hz_cust_accounts hca,
2056: okc_k_headers_b khr,
2057: hz_parties hp
2058: WHERE tai.ixx_id = khr.cust_acct_id

Line 2069: FROM okl_trx_ar_invoices_b tai

2065: ,nvl(hca.account_name,hp.party_name);
2066:
2067: CURSOR bankrupt_cnt_cust_csr IS
2068: SELECT COUNT(tai.id) cust_bkrpt_cnt
2069: FROM okl_trx_ar_invoices_b tai
2070: WHERE tai.trx_status_code = 'CUST-BANKRUPT';
2071:
2072: l_cust_bkrpt_cnt NUMBER;
2073: -- End -- Added by venkatho as part of Bug 15953012

Line 2085: FROM okl_trx_ar_invoices_b tai,

2081: SELECT distinct khr.id khr_id
2082: ,khr.contract_number contract_number
2083: ,tai.ixx_id vendor_customer_id
2084: ,iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
2085: FROM okl_trx_ar_invoices_b tai,
2086: okc_k_headers_b khr,
2087: hz_cust_accounts hca,
2088: okc_k_party_roles_b opr
2089: WHERE tai.khr_id = khr.id

Line 2103: FROM okl_trx_ar_invoices_b tai,

2099: CURSOR vndr_bankrupt_cnt_csr IS
2100: SELECT khr.contract_number khr_number
2101: ,ap.vendor_name name
2102: ,COUNT(tai.id) vndr_rec_cnt
2103: FROM okl_trx_ar_invoices_b tai,
2104: hz_cust_accounts hca,
2105: okc_k_headers_b khr,
2106: ap_suppliers ap,
2107: hz_parties hp

Line 2120: FROM okl_trx_ar_invoices_b tai

2116: ,ap.vendor_name;
2117:
2118: CURSOR bankrupt_cnt_vndr_csr IS
2119: SELECT COUNT(tai.id) vndr_bkrpt_cnt
2120: FROM okl_trx_ar_invoices_b tai
2121: WHERE tai.trx_status_code = 'VNDR-BANKRUPT';
2122:
2123: l_vndr_bkrpt_cnt NUMBER;
2124: l_vndr_cnt NUMBER;

Line 2154: FROM OKL_TRX_AR_INVOICES_B TAI,

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
2156: WHERE TLD.TIL_ID_DETAILS = TIL.ID
2157: AND TIL.TAI_ID = TAI.ID
2158: AND TAI.trx_status_code = p_sts

Line 2166: FROM OKL_TRX_AR_INVOICES_B TAI,

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
2168: WHERE TLD.TIL_ID_DETAILS = TIL.ID
2169: AND TIL.TAI_ID = TAI.ID
2170: AND TAI.request_id = p_req_id);

Line 2186: processed_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;

2182:
2183: -- ------------------------------------------------
2184: -- Bind variables to address issues in bug 3761940
2185: -- ------------------------------------------------
2186: processed_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;
2187: error_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;
2188:
2189: -- -------------------------
2190: -- Bulk Fetch Size

Line 2187: error_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;

2183: -- ------------------------------------------------
2184: -- Bind variables to address issues in bug 3761940
2185: -- ------------------------------------------------
2186: processed_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;
2187: error_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;
2188:
2189: -- -------------------------
2190: -- Bulk Fetch Size
2191: -- -------------------------

Line 2200: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;

2196:
2197: -- ----------------------
2198: -- Std Who columns
2199: -- ----------------------
2200: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id

Line 2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

2197: -- ----------------------
2198: -- Std Who columns
2199: -- ----------------------
2200: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;

Line 2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

2198: -- Std Who columns
2199: -- ----------------------
2200: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
2206: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

Line 2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;

2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
2206: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
2207:
2208: -- ---------------------------
2209: -- Bulk Insert changes

Line 2206: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
2206: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
2207:
2208: -- ---------------------------
2209: -- Bulk Insert changes
2210: -- ---------------------------

Line 2369: l_error_tai_id okl_trx_ar_invoices_b.id%TYPE;

2365: error_tbl error_tbl_type;
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;

Line 2588: UPDATE okl_trx_ar_invoices_b trx

2584: --IF (cust_bankruptcy_rec.okl_source_billing_trx = 'TAX_ONLY_INVOICE_TAX' AND cust_bankruptcy_rec.bankruptcy_sts = 'Y')
2585: IF (cust_bankruptcy_rec.bankruptcy_sts = 'Y')
2586: THEN
2587:
2588: UPDATE okl_trx_ar_invoices_b trx
2589: SET trx_status_code = 'CUST-BANKRUPT'
2590: WHERE khr_id = cust_bankruptcy_rec.khr_id
2591: AND ixx_id = cust_bankruptcy_rec.customer_id
2592: AND trx_status_code = 'SUBMITTED';

Line 2620: UPDATE okl_trx_ar_invoices_b

2616:
2617: IF (vndr_bankruptcy_rec.bankruptcy_sts = 'Y')
2618: THEN
2619:
2620: UPDATE okl_trx_ar_invoices_b
2621: SET trx_status_code = 'VNDR-BANKRUPT'
2622: WHERE khr_id = vndr_bankruptcy_rec.khr_id
2623: AND ixx_id = vndr_bankruptcy_rec.vendor_customer_id
2624: AND trx_status_code = 'SUBMITTED';

Line 2681: UPDATE okl_trx_ar_invoices_b

2677: END IF;
2678:
2679: hdr_cnt := 0;
2680: FOR K IN l_xfer_tbl.FIRST..l_xfer_tbl.LAST LOOP
2681: UPDATE okl_trx_ar_invoices_b
2682: SET request_id = lx_request_id
2683: WHERE ID = l_xfer_tbl(k).tai_id ;
2684:
2685:

Line 3013: UPDATE okl_trx_ar_invoices_b

3009: -- ----------------------------------
3010: IF l_hdr_id <> -9999 THEN
3011: --start: | 15-FEB-07 cklee R12 Billing enhancement project
3012: -- UPDATE OKL_EXT_SELL_INVS_B
3013: UPDATE okl_trx_ar_invoices_b
3014: --end: | 15-FEB-07 cklee R12 Billing enhancement project
3015: SET trx_status_code = 'PROCESSED',
3016: last_update_date = sysdate,
3017: last_updated_by = lx_last_updated_by,

Line 4250: UPDATE okl_trx_ar_invoices_b

4246: -- ----------------------------------
4247: --start: | 15-FEB-07 cklee R12 Billing enhancement project
4248: -- UPDATE OKL_EXT_SELL_INVS_B
4249: -- Update internal billing table instead
4250: UPDATE okl_trx_ar_invoices_b
4251: --end: | 15-FEB-07 cklee R12 Billing enhancement project
4252: SET trx_status_code = 'PROCESSED',
4253: last_update_date = sysdate,
4254: last_updated_by = lx_last_updated_by,

Line 4487: update okl_trx_ar_invoices_b tai

4483: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** Exception ** error_txd_id: '||error_tbl(indx).id);
4484: END IF;
4485: End;
4486: -- update okl_ext_sell_invs_b
4487: update okl_trx_ar_invoices_b tai
4488: set tai.trx_status_code = 'WORKING'
4489: -- where id = l_error_xsi_id;
4490: where id = l_error_tai_id;
4491: --end: | 15-FEB-07 cklee R12 Billing enhancement project

Line 4559: , OKL_TRX_AR_INVOICES_B TAI

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
4562: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4563:

Line 4569: , OKL_TRX_AR_INVOICES_B TAI

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
4572: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4573:

Line 4579: , OKL_TRX_AR_INVOICES_B TAI

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
4582: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4583:

Line 4589: , OKL_TRX_AR_INVOICES_B TAI

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
4592: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4593:

Line 4594: -- Update the OKL_TRX_AR_INVOICES_B back to Submitted status

4590: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4591: AND TAI.ID = TIL.TAI_ID
4592: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4593:
4594: -- Update the OKL_TRX_AR_INVOICES_B back to Submitted status
4595: UPDATE OKL_TRX_AR_INVOICES_B
4596: SET TRX_STATUS_CODE = 'SUBMITTED'
4597: WHERE ID = l_error_tai_tbl(err_tai_cnt);
4598: END LOOP;

Line 4595: UPDATE OKL_TRX_AR_INVOICES_B

4591: AND TAI.ID = TIL.TAI_ID
4592: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4593:
4594: -- Update the OKL_TRX_AR_INVOICES_B back to Submitted status
4595: UPDATE OKL_TRX_AR_INVOICES_B
4596: SET TRX_STATUS_CODE = 'SUBMITTED'
4597: WHERE ID = l_error_tai_tbl(err_tai_cnt);
4598: END LOOP;
4599:

Line 4712: UPDATE okl_trx_ar_invoices_b

4708: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4709:
4710:
4711: -- Start added as part of Bug#: 15953012, 15953954
4712: UPDATE okl_trx_ar_invoices_b
4713: SET trx_status_code = 'SUBMITTED'
4714: WHERE trx_status_code IN ('CUST-BANKRUPT','VNDR-BANKRUPT');
4715:
4716: IF (SQL%ROWCOUNT >0) THEN