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_PAY_CURE_REFUNDS_PVT dependencies on OKC_K_HEADERS_B

Line 173: FROM okc_k_headers_b chr

169:
170:
171: CURSOR org_id_csr ( p_khr_id NUMBER ) IS
172: SELECT chr.authoring_org_id
173: FROM okc_k_headers_b chr
174: WHERE id = p_khr_id;
175:
176: CURSOR sob_csr ( p_org_id NUMBER ) IS
177: SELECT hru.set_of_books_id

Line 702: okc_k_headers_b cn,

698: cn.contract_number
699: FROM okl_xtl_sell_invs_v xls,
700: okl_txl_ar_inv_lns_v til,
701: okl_trx_ar_invoices_v tai,
702: okc_k_headers_b cn,
703: ar_payment_schedules_all ps,
704: ar_receivable_applications_all arapp,
705: okl_cnsld_ar_strms_b st
706: WHERE st.id = xls.lsm_id

Line 736: okc_k_headers_b CHR,

732: ar_receivable_applications_all arapp,
733: okl_cnsld_ar_strms_b st,
734: okc_k_party_roles_b pty,
735: okc_rules_b rul,
736: okc_k_headers_b CHR,
737: po_vendors pvn,
738: po_vendor_sites_all pvs
739: WHERE st.id = xls.lsm_id
740: AND st.receivables_invoice_id = ps.customer_trx_id

Line 768: okc_k_headers_b cn,

764: cn.contract_number
765: FROM okl_xtl_sell_invs_v xls,
766: okl_txl_ar_inv_lns_b til,
767: okl_trx_ar_invoices_b tai,
768: okc_k_headers_b cn,
769: ar_payment_schedules_all ps,
770: ar_receivable_applications_all arapp,
771: okl_cnsld_ar_strms_b st,
772: okc_k_party_roles_b pty,

Line 993: x_contract_number okc_k_headers_b.contract_number%TYPE;

989: select refund_header_number
990: from okl_cure_refund_headers_b
991: where refund_header_number =p_refund_header_number;
992:
993: x_contract_number okc_k_headers_b.contract_number%TYPE;
994:
995: BEGIN
996:
997: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_hdr : START ');

Line 1733: select currency_code from OKC_K_HEADERS_b

1729: x_msg_count OUT NOCOPY NUMBER,
1730: x_msg_data OUT NOCOPY VARCHAR2) IS
1731:
1732: cursor c_get_contract_currency (l_khr_id IN NUMBER) IS
1733: select currency_code from OKC_K_HEADERS_b
1734: where id =l_khr_id;
1735:
1736: CURSOR curr_csr (l_khr_id NUMBER) IS
1737: SELECT currency_conversion_type,

Line 1748: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;

1744: l_functional_currency okl_trx_contracts.currency_code%TYPE;
1745: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
1746: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
1747: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
1748: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;
1749:
1750: next_row integer;
1751:
1752:

Line 1798: l_khr_id okc_k_headers_b.id%TYPE;

1794: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1795: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
1796: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
1797: l_line_id okl_txl_ar_inv_lns_b.id%TYPE;
1798: l_khr_id okc_k_headers_b.id%TYPE;
1799: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
1800: l_amount okl_trx_ar_invoices_b.amount%TYPE;
1801:
1802: CURSOR product_csr (p_chr_id IN NUMBER) IS

Line 1806: okc_k_headers_b chr --Bug# 4622198

1802: CURSOR product_csr (p_chr_id IN NUMBER) IS
1803: SELECT khr.pdt_id,
1804: chr.scs_code --Bug# 4622198
1805: FROM okl_k_headers khr,
1806: okc_k_headers_b chr --Bug# 4622198
1807: WHERE chr.id = khr.id --Bug# 4622198
1808: and khr.id = p_chr_id;
1809:
1810: /* -- OKL.H Code commented out

Line 1845: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;

1841:
1842: --Bug# 4622198 :For special accounting treatment - START
1843: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1844: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1845: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
1846: --Bug# 4622198 :For special accounting treatment - END
1847:
1848:
1849: BEGIN

Line 2235: select currency_code from OKC_K_HEADERS_b

2231: FROM okl_k_headers
2232: WHERE id = l_khr_id;
2233:
2234: cursor c_get_contract_currency (l_khr_id IN NUMBER) IS
2235: select currency_code from OKC_K_HEADERS_b
2236: where id =l_khr_id;
2237:
2238: l_functional_currency okl_trx_contracts.currency_code%TYPE;
2239: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

Line 2242: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;

2238: l_functional_currency okl_trx_contracts.currency_code%TYPE;
2239: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
2240: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
2241: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
2242: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;
2243: /*---New Code end ---*/
2244:
2245: BEGIN
2246: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: submit_cure_refund_hdr : START ');

Line 3180: FROM okc_k_headers_b

3176:
3177: -- to get inventory_org_id bug 4890024 begin
3178: CURSOR inv_org_id_csr(p_contract_id NUMBER) IS
3179: SELECT NVL(inv_organization_id, -99)
3180: FROM okc_k_headers_b
3181: WHERE id = p_contract_id;
3182:
3183: begin
3184: -- Set API savepoint

Line 3979: FROM okc_k_headers_b chr

3975:
3976:
3977: CURSOR org_id_csr ( p_khr_id NUMBER ) IS
3978: SELECT chr.authoring_org_id
3979: FROM okc_k_headers_b chr
3980: WHERE id = p_khr_id;
3981:
3982: CURSOR sob_csr ( p_org_id NUMBER ) IS
3983: SELECT hru.set_of_books_id

Line 5333: x_contract_number okc_k_headers_b.contract_number%TYPE;

5329: select refund_header_number
5330: from okl_cure_refund_headers_b
5331: where refund_header_number =p_refund_header_number;
5332:
5333: x_contract_number okc_k_headers_b.contract_number%TYPE;
5334:
5335: BEGIN
5336: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_refund_headers : START ');
5337: SAVEPOINT CREATE_REFUND_HEADERS;

Line 5660: from okl_cure_refunds b, okc_k_headers_b a

5656: CURSOR c_emps (p_cure_refund_header_id IN NUMBER)
5657: IS
5658: select a.contract_number,
5659: b.offset_amount
5660: from okl_cure_refunds b, okc_k_headers_b a
5661: where a.id =b.offset_contract
5662: and b.cure_refund_header_id =p_cure_refund_header_id;
5663:
5664: c_emps_rec c_emps%ROWTYPE;