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_RULES_V

Line 421: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;

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;
422: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
423: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
424: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
425: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;

Line 422: lv_k_rule_information3 okc_rules_v.rule_information3%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;
422: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
423: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
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;

Line 423: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;

419: l_rgp_id NUMBER;
420:
421: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
422: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
423: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
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:

Line 424: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;

420:
421: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
422: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
423: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
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

Line 425: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;

421: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
422: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
423: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
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

Line 426: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;

422: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
423: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
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

Line 437: FROM OKC_RULES_V rul,

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
439: WHERE rul.rgp_id = rgp.id
440: AND rgp.dnz_chr_id = p_chr_id
441: AND rgp.cle_id is NULL

Line 447: FROM OKC_RULES_V rul,

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
450: AND rgp.dnz_chr_id = p_chr_id
451: AND rgp.cle_id is NULL

Line 471: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;

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:
475: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 691: ln_rule_id okc_rules_v.id%TYPE;

687: lx_rulv_rec rulv_rec_type;
688:
689: ln_cle_id okc_k_lines_v.id%TYPE;
690:
691: ln_rule_id okc_rules_v.id%TYPE;
692: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;
693: l_ak_prompt varchar2(100);
694: l_rebook_yn varchar2(1) := 'N';
695: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;

Line 692: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;

688:
689: ln_cle_id okc_k_lines_v.id%TYPE;
690:
691: ln_rule_id okc_rules_v.id%TYPE;
692: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;
693: l_ak_prompt varchar2(100);
694: l_rebook_yn varchar2(1) := 'N';
695: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
696:

Line 697: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;

693: l_ak_prompt varchar2(100);
694: l_rebook_yn varchar2(1) := 'N';
695: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
696:
697: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
698: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;

Line 698: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;

694: l_rebook_yn varchar2(1) := 'N';
695: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
696:
697: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
698: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
702: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;

Line 699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;

695: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
696:
697: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
698: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
702: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
703: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;

Line 700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;

696:
697: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
698: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
702: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
703: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
704: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;

Line 701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;

697: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
698: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
702: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
703: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
704: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
705:

Line 702: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;

698: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
702: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
703: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
704: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
705:
706: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_SALES_TAX';

Line 703: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;

699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
702: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
703: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
704: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
705:
706: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_SALES_TAX';
707:

Line 704: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;

700: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
701: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
702: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
703: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
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

Line 711: FROM OKC_RULES_V rul,

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
713: WHERE rul.rgp_id = rgp.id
714: AND rgp.dnz_chr_id = p_chr_id
715: AND rgp.cle_id is NULL

Line 738: FROM OKC_RULES_V rul,

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,
740: okc_k_lines_b cle
741: WHERE rul.rgp_id = rgp.id
742: AND rgp.dnz_chr_id = p_chr_id

Line 752: FROM OKC_RULES_V rul,

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
754: WHERE rul.rgp_id = rgp.id
755: AND rgp.dnz_chr_id = p_chr_id
756: AND rgp.cle_id is NULL

Line 3421: FROM OKC_RULES_V rul

3417: , rgp.cle_id asset_id
3418: , txs.id tax_header_id
3419: , txl.tax_line_id tax_line_id
3420: , txl.tax_amt tax_amount
3421: FROM OKC_RULES_V rul
3422: , OKC_RULE_GROUPS_V rgp
3423: , okl_tax_sources txs
3424: , zx_lines txl
3425: WHERE rul.rgp_id = rgp.id

Line 3459: FROM OKC_RULES_V rul

3455: , rgp.cle_id asset_id
3456: , txs.id tax_header_id
3457: , txl.tax_line_id tax_line_id
3458: , txl.tax_amt tax_amount
3459: FROM OKC_RULES_V rul
3460: , OKC_RULE_GROUPS_V rgp
3461: , okl_tax_sources txs
3462: , zx_lines txl
3463: WHERE rul.rgp_id = rgp.id

Line 3495: FROM OKC_RULES_V rul

3491: , rgp.cle_id asset_id
3492: , txs.id tax_header_id
3493: , txl.tax_line_id tax_line_id
3494: , txl.tax_amt tax_amount
3495: FROM OKC_RULES_V rul
3496: , OKC_RULE_GROUPS_V rgp
3497: , okl_tax_sources txs
3498: , zx_lines txl
3499: WHERE rul.rgp_id = rgp.id

Line 3578: FROM OKC_RULES_V rul

3574: , rgp.cle_id asset_id
3575: , txs.id tax_header_id
3576: , txl.tax_line_id tax_line_id
3577: , txl.tax_amt tax_amount
3578: FROM OKC_RULES_V rul
3579: , OKC_RULE_GROUPS_V rgp
3580: , okl_tax_sources txs
3581: , zx_lines txl
3582: WHERE rul.rgp_id = rgp.id

Line 3625: FROM OKC_RULES_V rul

3621: , rgp.cle_id asset_id
3622: , txs.id tax_header_id
3623: , txl.tax_line_id tax_line_id
3624: , txl.tax_amt tax_amount
3625: FROM OKC_RULES_V rul
3626: , OKC_RULE_GROUPS_V rgp
3627: , okl_tax_sources txs
3628: , zx_lines txl
3629: WHERE rul.rgp_id = rgp.id

Line 3670: FROM OKC_RULES_V rul

3666: , rgp.cle_id asset_id
3667: , txs.id tax_header_id
3668: , txl.tax_line_id tax_line_id
3669: , txl.tax_amt tax_amount
3670: FROM OKC_RULES_V rul
3671: , OKC_RULE_GROUPS_V rgp
3672: , okl_tax_sources txs
3673: , zx_lines txl
3674: WHERE rul.rgp_id = rgp.id