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 263: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;

259: l_chr_id okc_k_headers_b.id%TYPE;
260: l_cle_id okc_k_lines_v.id%TYPE;
261: l_rgp_id NUMBER;
262:
263: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
264: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
265: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
266: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
267: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;

Line 264: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;

260: l_cle_id okc_k_lines_v.id%TYPE;
261: l_rgp_id NUMBER;
262:
263: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
264: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
265: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
266: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
267: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;
268: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;

Line 265: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;

261: l_rgp_id NUMBER;
262:
263: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
264: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
265: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
266: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
267: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;
268: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;
269:

Line 266: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;

262:
263: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
264: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
265: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
266: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
267: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;
268: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;
269:
270: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS

Line 267: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;

263: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
264: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
265: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
266: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
267: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;
268: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;
269:
270: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS
271: select deal_type

Line 268: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;

264: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
265: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE;
266: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
267: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;
268: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;
269:
270: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS
271: select deal_type
272: from okl_k_headers

Line 279: FROM OKC_RULES_V rul,

275:
276: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
277: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
278: rul.rule_information5, rul.rule_information6, rul.rule_information7
279: FROM OKC_RULES_V rul,
280: OKC_RULE_GROUPS_V rgp
281: WHERE rul.rgp_id = rgp.id
282: AND rgp.dnz_chr_id = p_chr_id
283: AND rgp.cle_id is NULL

Line 289: FROM OKC_RULES_V rul,

285: AND rul.rule_information_category = 'LASTCL';
286:
287: CURSOR l_hdr_upfront_tax(p_chr_id okc_k_headers_b.id%TYPE) IS
288: SELECT rul.rule_information1
289: FROM OKC_RULES_V rul,
290: OKC_RULE_GROUPS_V rgp
291: WHERE rul.rgp_id = rgp.id
292: AND rgp.dnz_chr_id = p_chr_id
293: AND rgp.cle_id is NULL

Line 313: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;

309:
310: l_flag VARCHAR2(30) := 'XXXX';
311: l_deal_type okl_k_headers.deal_type%type;
312: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
313: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
314:
315: BEGIN
316:
317: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 533: ln_rule_id okc_rules_v.id%TYPE;

529: lx_rulv_rec rulv_rec_type;
530:
531: ln_cle_id okc_k_lines_v.id%TYPE;
532:
533: ln_rule_id okc_rules_v.id%TYPE;
534: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;
535: l_ak_prompt varchar2(100);
536: l_rebook_yn varchar2(1) := 'N';
537: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;

Line 534: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;

530:
531: ln_cle_id okc_k_lines_v.id%TYPE;
532:
533: ln_rule_id okc_rules_v.id%TYPE;
534: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;
535: l_ak_prompt varchar2(100);
536: l_rebook_yn varchar2(1) := 'N';
537: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
538:

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

535: l_ak_prompt varchar2(100);
536: l_rebook_yn varchar2(1) := 'N';
537: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
538:
539: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
540: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
541: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
542: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
543: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;

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

536: l_rebook_yn varchar2(1) := 'N';
537: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
538:
539: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
540: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
541: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
542: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
543: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
544: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;

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

537: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
538:
539: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
540: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
541: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
542: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
543: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
544: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
545: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;

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

538:
539: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
540: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
541: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
542: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
543: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
544: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
545: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
546: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;

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

539: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
540: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
541: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
542: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
543: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
544: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
545: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
546: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
547:

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

540: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
541: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
542: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
543: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
544: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
545: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
546: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
547:
548: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_SALES_TAX';

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

541: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;
542: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
543: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
544: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
545: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
546: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
547:
548: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_SALES_TAX';
549:

Line 546: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;

542: lv_k_rule_information4 okc_rules_v.rule_information4%TYPE := null;
543: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE := null;
544: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE := null;
545: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE := null;
546: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
547:
548: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_SALES_TAX';
549:
550: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

Line 553: FROM OKC_RULES_V rul,

549:
550: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
551: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
552: rul.rule_information5, rul.rule_information6, rul.rule_information7
553: FROM OKC_RULES_V rul,
554: OKC_RULE_GROUPS_V rgp
555: WHERE rul.rgp_id = rgp.id
556: AND rgp.dnz_chr_id = p_chr_id
557: AND rgp.cle_id is NULL

Line 580: FROM OKC_RULES_V rul,

576:
577: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
578: p_cle_id okc_k_lines_v.id%TYPE) IS
579: SELECT rul.id, rul.rule_information5, cle.ORIG_SYSTEM_ID1
580: FROM OKC_RULES_V rul,
581: OKC_RULE_GROUPS_V rgp,
582: okc_k_lines_b cle
583: WHERE rul.rgp_id = rgp.id
584: AND rgp.dnz_chr_id = p_chr_id

Line 594: FROM OKC_RULES_V rul,

590:
591: CURSOR get_sales_tax_prc_info(p_chr_id okc_k_headers_b.id%TYPE) IS
592: SELECT rul.rule_information1, rul.rule_information2,
593: rul.rule_information3, rul.rule_information4, rul.rule_information4
594: FROM OKC_RULES_V rul,
595: OKC_RULE_GROUPS_V rgp
596: WHERE rul.rgp_id = rgp.id
597: AND rgp.dnz_chr_id = p_chr_id
598: AND rgp.cle_id is NULL

Line 3217: FROM OKC_RULES_V rul

3213: , rgp.cle_id asset_id
3214: , txs.id tax_header_id
3215: , txl.tax_line_id tax_line_id
3216: , txl.tax_amt tax_amount
3217: FROM OKC_RULES_V rul
3218: , OKC_RULE_GROUPS_V rgp
3219: , okl_tax_sources txs
3220: , zx_lines txl
3221: WHERE rul.rgp_id = rgp.id

Line 3255: FROM OKC_RULES_V rul

3251: , rgp.cle_id asset_id
3252: , txs.id tax_header_id
3253: , txl.tax_line_id tax_line_id
3254: , txl.tax_amt tax_amount
3255: FROM OKC_RULES_V rul
3256: , OKC_RULE_GROUPS_V rgp
3257: , okl_tax_sources txs
3258: , zx_lines txl
3259: WHERE rul.rgp_id = rgp.id

Line 3291: FROM OKC_RULES_V rul

3287: , rgp.cle_id asset_id
3288: , txs.id tax_header_id
3289: , txl.tax_line_id tax_line_id
3290: , txl.tax_amt tax_amount
3291: FROM OKC_RULES_V rul
3292: , OKC_RULE_GROUPS_V rgp
3293: , okl_tax_sources txs
3294: , zx_lines txl
3295: WHERE rul.rgp_id = rgp.id

Line 3374: FROM OKC_RULES_V rul

3370: , rgp.cle_id asset_id
3371: , txs.id tax_header_id
3372: , txl.tax_line_id tax_line_id
3373: , txl.tax_amt tax_amount
3374: FROM OKC_RULES_V rul
3375: , OKC_RULE_GROUPS_V rgp
3376: , okl_tax_sources txs
3377: , zx_lines txl
3378: WHERE rul.rgp_id = rgp.id

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 3466: FROM OKC_RULES_V rul

3462: , rgp.cle_id asset_id
3463: , txs.id tax_header_id
3464: , txl.tax_line_id tax_line_id
3465: , txl.tax_amt tax_amount
3466: FROM OKC_RULES_V rul
3467: , OKC_RULE_GROUPS_V rgp
3468: , okl_tax_sources txs
3469: , zx_lines txl
3470: WHERE rul.rgp_id = rgp.id