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

Line 20: CURSOR Product_csr (p_contract_id OKC_K_HEADERS_B.ID%TYPE)

16:
17: -- R12 - START
18:
19: -- Global Cursor to get contract header linformation
20: CURSOR Product_csr (p_contract_id OKC_K_HEADERS_B.ID%TYPE)
21: IS
22: SELECT khr.pdt_id product_id
23: ,NULL product_name
24: ,khr.sts_code contract_status

Line 247: CURSOR c_chk_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS

243: AND NVL(txs.total_tax,0) <> 0;
244:
245: -- ER# 9327076
246: -- Check if present contract is a rebook copy
247: CURSOR c_chk_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
248: SELECT '!'
249: FROM okc_k_headers_b CHR
250: WHERE CHR.ID = chrid
251: AND CHR.orig_system_source_code = 'OKL_REBOOK';

Line 249: FROM okc_k_headers_b CHR

245: -- ER# 9327076
246: -- Check if present contract is a rebook copy
247: CURSOR c_chk_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
248: SELECT '!'
249: FROM okc_k_headers_b CHR
250: WHERE CHR.ID = chrid
251: AND CHR.orig_system_source_code = 'OKL_REBOOK';
252:
253: -- Cursor to check if mass rebook is in process

Line 256: FROM okc_k_headers_b chr

252:
253: -- Cursor to check if mass rebook is in process
254: CURSOR c_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
255: SELECT '!'
256: FROM okc_k_headers_b chr
257: WHERE chr.ID = p_chr_id
258: AND EXISTS (SELECT '1'
259: FROM okl_trx_contracts ktrx
260: WHERE ktrx.khr_id = chr.ID

Line 275: FUNCTION check_prior_upfront_tax(p_chr_id IN OKC_K_HEADERS_B.ID%TYPE)

271: -- Global Variables
272: g_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
273:
274: -- ER# 9327076 - Added new function to check for prior upfront tax calculation
275: FUNCTION check_prior_upfront_tax(p_chr_id IN OKC_K_HEADERS_B.ID%TYPE)
276: RETURN BOOLEAN IS
277: CURSOR c_chk_upfront(cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
278: SELECT 'x'
279: FROM okl_tax_sources

Line 277: CURSOR c_chk_upfront(cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

273:
274: -- ER# 9327076 - Added new function to check for prior upfront tax calculation
275: FUNCTION check_prior_upfront_tax(p_chr_id IN OKC_K_HEADERS_B.ID%TYPE)
276: RETURN BOOLEAN IS
277: CURSOR c_chk_upfront(cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
278: SELECT 'x'
279: FROM okl_tax_sources
280: WHERE khr_id = cp_chr_id
281: AND tax_call_type_code = 'UPFRONT_TAX' ;

Line 300: FUNCTION check_rel_mxd_ctr(p_chr_id IN OKC_K_HEADERS_B.ID%TYPE)

296:
297: -- 16522428 14/3/13
298: -- Check if a release contract has now become a mixed contract during rebook
299:
300: FUNCTION check_rel_mxd_ctr(p_chr_id IN OKC_K_HEADERS_B.ID%TYPE)
301: RETURN BOOLEAN IS
302:
303: l_chk VARCHAR2(1) := '?';
304:

Line 305: CURSOR c_chk_mxd_ctr (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

301: RETURN BOOLEAN IS
302:
303: l_chk VARCHAR2(1) := '?';
304:
305: CURSOR c_chk_mxd_ctr (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
306: SELECT 'Y'
307: FROM okc_k_headers_b CHR
308: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
309: and chr.ID = cp_chr_id

Line 307: FROM okc_k_headers_b CHR

303: l_chk VARCHAR2(1) := '?';
304:
305: CURSOR c_chk_mxd_ctr (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
306: SELECT 'Y'
307: FROM okc_k_headers_b CHR
308: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
309: and chr.ID = cp_chr_id
310: AND exists ( SELECT '1'
311: FROM okl_k_lines kle

Line 329: CURSOR c_chk_orig_rls_ctr(cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

325: AND cleb.lse_id = 33
326: AND cleb.sts_code <> 'ABANDONED'
327: AND nvl(kle.re_lease_yn,'N') = 'N');
328:
329: CURSOR c_chk_orig_rls_ctr(cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
330: SELECT 'Y'
331: FROM okc_k_headers_b CHR
332: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
333: and chr.ID = ( SELECT orig_system_id1

Line 331: FROM okc_k_headers_b CHR

327: AND nvl(kle.re_lease_yn,'N') = 'N');
328:
329: CURSOR c_chk_orig_rls_ctr(cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
330: SELECT 'Y'
331: FROM okc_k_headers_b CHR
332: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
333: and chr.ID = ( SELECT orig_system_id1
334: FROM okc_k_headers_b
335: WHERE id = cp_chr_id )

Line 334: FROM okc_k_headers_b

330: SELECT 'Y'
331: FROM okc_k_headers_b CHR
332: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
333: and chr.ID = ( SELECT orig_system_id1
334: FROM okc_k_headers_b
335: WHERE id = cp_chr_id )
336: AND exists ( SELECT '1'
337: FROM okl_k_lines kle
338: ,okc_k_lines_b cleb

Line 417: l_chr_id okc_k_headers_b.id%TYPE;

413: l_rulv_rec rulv_rec_type;
414: lx_rgpv_rec rgpv_rec_type;
415: lx_rulv_rec rulv_rec_type;
416:
417: l_chr_id okc_k_headers_b.id%TYPE;
418: l_cle_id okc_k_lines_v.id%TYPE;
419: l_rgp_id NUMBER;
420:
421: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;

Line 428: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS

424: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
425: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;
426: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;
427:
428: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS
429: select deal_type
430: from okl_k_headers
431: where deal_type = 'LOAN'
432: and id = p_chr_id;

Line 434: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

430: from okl_k_headers
431: where deal_type = 'LOAN'
432: and id = p_chr_id;
433:
434: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
435: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
436: rul.rule_information5, rul.rule_information6, rul.rule_information7
437: FROM OKC_RULES_V rul,
438: OKC_RULE_GROUPS_V rgp

Line 445: CURSOR l_hdr_upfront_tax(p_chr_id okc_k_headers_b.id%TYPE) IS

441: AND rgp.cle_id is NULL
442: AND rgp.rgd_code = 'LAHDTX'
443: AND rul.rule_information_category = 'LASTCL';
444:
445: CURSOR l_hdr_upfront_tax(p_chr_id okc_k_headers_b.id%TYPE) IS
446: SELECT rul.rule_information1
447: FROM OKC_RULES_V rul,
448: OKC_RULE_GROUPS_V rgp
449: WHERE rul.rgp_id = rgp.id

Line 455: CURSOR l_asset_tax_rule_group(p_chr_id okc_k_headers_b.id%TYPE,

451: AND rgp.cle_id is NULL
452: AND rgp.rgd_code = 'LAHDTX'
453: AND rul.rule_information_category = 'LASTPR';
454:
455: CURSOR l_asset_tax_rule_group(p_chr_id okc_k_headers_b.id%TYPE,
456: p_cle_id NUMBER) IS -- 5179119
457: SELECT id
458: FROM OKC_RULE_GROUPS_B rgp
459: WHERE rgp.dnz_chr_id = p_chr_id

Line 470: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

466: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALES_TAX_RULES';
467:
468: l_flag VARCHAR2(30) := 'XXXX';
469: l_deal_type okl_k_headers.deal_type%type;
470: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
471: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
472:
473: BEGIN
474:

Line 708: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

704: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
705:
706: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_SALES_TAX';
707:
708: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
709: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
710: rul.rule_information5, rul.rule_information6, rul.rule_information7
711: FROM OKC_RULES_V rul,
712: OKC_RULE_GROUPS_V rgp

Line 719: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS

715: AND rgp.cle_id is NULL
716: AND rgp.rgd_code = 'LAHDTX'
717: AND rul.rule_information_category = 'LASTCL';
718:
719: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS
720: SELECT cle.id
721: FROM OKC_K_LINES_V cle,
722: OKC_LINE_STYLES_V lse
723: WHERE cle.lse_id = lse.id

Line 729: CURSOR get_rebook_contract_csr(p_chr_id okc_k_headers_b.id%TYPE) IS

725: AND lse.lse_type = 'TLS'
726: AND cle.dnz_chr_id = p_chr_id;
727: -- AND cle.orig_system_id1 IS NULL; -- for rebook check
728:
729: CURSOR get_rebook_contract_csr(p_chr_id okc_k_headers_b.id%TYPE) IS
730: select 'Y'
731: from okc_k_headers_b
732: where id = p_chr_id
733: and nvl(orig_system_source_code,'XXX')='OKL_REBOOK';

Line 731: from okc_k_headers_b

727: -- AND cle.orig_system_id1 IS NULL; -- for rebook check
728:
729: CURSOR get_rebook_contract_csr(p_chr_id okc_k_headers_b.id%TYPE) IS
730: select 'Y'
731: from okc_k_headers_b
732: where id = p_chr_id
733: and nvl(orig_system_source_code,'XXX')='OKL_REBOOK';
734:
735: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,

Line 735: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,

731: from okc_k_headers_b
732: where id = p_chr_id
733: and nvl(orig_system_source_code,'XXX')='OKL_REBOOK';
734:
735: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
736: p_cle_id okc_k_lines_v.id%TYPE) IS
737: SELECT rul.id, rul.rule_information5, cle.ORIG_SYSTEM_ID1
738: FROM OKC_RULES_V rul,
739: OKC_RULE_GROUPS_V rgp,

Line 749: CURSOR get_sales_tax_prc_info(p_chr_id okc_k_headers_b.id%TYPE) IS

745: AND rul.rule_information_category = 'LAASTX'
746: AND cle.id = rgp.cle_id
747: AND cle.id = p_cle_id;
748:
749: CURSOR get_sales_tax_prc_info(p_chr_id okc_k_headers_b.id%TYPE) IS
750: SELECT rul.rule_information1, rul.rule_information2,
751: rul.rule_information3, rul.rule_information4, rul.rule_information4
752: FROM OKC_RULES_V rul,
753: OKC_RULE_GROUPS_V rgp

Line 1088: FROM OKC_K_HEADERS_B

1084:
1085: --Added by dpsingh for LE uptake
1086: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
1087: SELECT contract_number
1088: FROM OKC_K_HEADERS_B
1089: WHERE id = p_ctr_id1;
1090:
1091: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1092: l_legal_entity_id NUMBER;

Line 1091: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1087: SELECT contract_number
1088: FROM OKC_K_HEADERS_B
1089: WHERE id = p_ctr_id1;
1090:
1091: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1092: l_legal_entity_id NUMBER;
1093:
1094: -- R12 - START
1095:

Line 2556: FROM okc_k_headers_b

2552:
2553: -- Get contract dates
2554: CURSOR contract_dates_csr IS
2555: SELECT start_date, end_date
2556: FROM okc_k_headers_b
2557: WHERE id = p_contract_id;
2558:
2559: -- Cursor to get assets for financed fee association
2560: -- Bug# 6512668: Exclude asset lines in Abandoned status

Line 3209: okc_k_headers_b chr

3205: ,chr.scs_code scs_code
3206: FROM okc_contacts ct,
3207: okc_contact_sources csrc,
3208: okc_k_party_roles_b pty,
3209: okc_k_headers_b chr
3210: WHERE ct.cpl_id = pty.id
3211: AND ct.cro_code = csrc.cro_code
3212: AND ct.jtot_object1_code = csrc.jtot_object_code
3213: AND ct.dnz_chr_id = chr.id

Line 3227: FROM okc_k_headers_b

3223:
3224: CURSOR custBillTo_csr
3225: IS
3226: SELECT bill_to_site_use_id cust_acct_site_id
3227: FROM okc_k_headers_b
3228: WHERE id = p_trxh_out_rec.khr_id;
3229:
3230: l_custBillTo_rec custBillTo_csr%ROWTYPE;
3231:

Line 4792: FROM okc_k_headers_b

4788:
4789: -- Cursor to get contract start date for billing
4790: CURSOR contract_csr IS
4791: SELECT start_date
4792: FROM okc_k_headers_b
4793: WHERE id = p_contract_id;
4794:
4795: rule_info_csr_rec rule_info_csr%ROWTYPE;
4796: l_ST_params_exist VARCHAR2(1);

Line 4803: l_contract_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

4799: l_prebook_financed_tax NUMBER;
4800: l_booking_capitalized_tax NUMBER;
4801: L_prebook_capitalized_tax NUMBER;
4802: l_booking_billable_tax NUMBER;
4803: l_contract_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
4804: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
4805: l_billed_assets NUMBER :=0;
4806: l_asset_count NUMBER :=0;
4807: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;

Line 5364: FROM OKC_K_HEADERS_B

5360: -- Bug 4748910 - START
5361:
5362: CURSOR c_currency_code(p_khr_id IN NUMBER) IS
5363: SELECT start_date, end_date, currency_code
5364: FROM OKC_K_HEADERS_B
5365: WHERE ID = p_contract_id;
5366:
5367: CURSOR c_try_type(p_name IN VARCHAR2) IS
5368: SELECT ID

Line 6049: FROM okc_k_headers_b

6045: and lookup_code = fndCode;
6046:
6047: CURSOR l_hdr_csr IS
6048: SELECT authoring_org_id
6049: FROM okc_k_headers_b
6050: WHERE id = p_chr_id;
6051: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
6052:
6053: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

Line 6051: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

6047: CURSOR l_hdr_csr IS
6048: SELECT authoring_org_id
6049: FROM okc_k_headers_b
6050: WHERE id = p_chr_id;
6051: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
6052:
6053: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
6054: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
6055: chrId NUMBER) IS

Line 6233: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

6229: AND txs.kle_id = p_asset_id;
6230: l_asset_tax_amount NUMBER;
6231:
6232: -- R12B Authoring OA Migration
6233: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6234: SELECT COUNT(cleb.id)
6235: FROM okc_k_lines_b cleb,
6236: okl_k_lines kle,
6237: okc_line_styles_b sty,

Line 6249: CURSOR chk_line_upfront_tax (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

6245: AND cleb.chr_id = p_chr_id
6246: AND kle.id = cleb.id;
6247:
6248: -- ER# 9327076 - Cursor to check line level setup for upfront tax
6249: CURSOR chk_line_upfront_tax (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6250: SELECT '!'
6251: FROM okc_rule_groups_b crg,
6252: okc_rules_b crl
6253: WHERE crl.rgp_id = crg.ID

Line 7013: CURSOR l_fn_top_fee_ln_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS

7009: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_UPFRONT_TAX_FEE';
7010: l_api_version CONSTANT NUMBER := 1.0;
7011:
7012: /* Cursor to get the top fee line for Sales Tax financed fee of a given contract. */
7013: CURSOR l_fn_top_fee_ln_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
7014: SELECT kle.id,
7015: kle.amount,
7016: clev.name,
7017: lsev.name line_type,

Line 7036: CURSOR l_fn_sub_ln_fee_csr ( p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

7032: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED');
7033:
7034: /* Cursor to get the financed fee sub-lines (applied to assets) for a
7035: given contract. */
7036: CURSOR l_fn_sub_ln_fee_csr ( p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
7037: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
7038: SELECT kle.id,
7039: kle.amount,
7040: cleb.end_date,

Line 7053: CURSOR l_fn_fee_pmt_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

7049: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','ABANDONED');
7050:
7051: /* Cursor to get the financed fee top/sub-line payments for a
7052: given contract. */
7053: CURSOR l_fn_fee_pmt_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
7054: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
7055: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
7056: SLL.rule_information3 periods,
7057: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,

Line 7079: CURSOR l_fn_fee_pmtH_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

7075: AND sll.rule_information_category = 'LASLL';
7076:
7077: /* Cursor to get the financed fee top/sub-line payments HEADER for a
7078: given contract. */
7079: CURSOR l_fn_fee_pmtH_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
7080: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
7081:
7082: SELECT slh.id
7083: FROM okc_rules_b slh,

Line 7096: CURSOR l_strm_slh_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE,

7092: AND slh.object1_id1 = TO_CHAR(sty.id)
7093: AND styt.language = USERENV('LANG')
7094: AND sty.id = styt.id;
7095:
7096: CURSOR l_strm_slh_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
7097: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
7098: SELECT styt.name stream_type,
7099: rule.id rule_id,
7100: rgp.id rgp_id