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.

[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_RULES_V

Line 1289: p_rule_code IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,

1285: x_msg_data OUT NOCOPY VARCHAR2,
1286: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1287: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
1288: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
1289: p_rule_code IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
1290: x_rulv_tbl OUT NOCOPY rulv_tbl_type,
1291: x_rule_count OUT NOCOPY NUMBER
1292: ) IS
1293: l_proc_name VARCHAR2(35) := 'GET_CONTRACT_RULES';

Line 1298: p_rule_code OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE) IS

1294:
1295: CURSOR rulv_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1296: p_cle_id OKC_K_LINES_V.ID%TYPE,
1297: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
1298: p_rule_code OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE) IS
1299: SELECT
1300: rule.ID,
1301: rule.OBJECT_VERSION_NUMBER,
1302: rule.SFWT_FLAG,

Line 1362: okc_rules_v rule

1358: rule.ans_set_jtot_object_id1,
1359: rule.ans_set_jtot_object_id2,
1360: rule.DISPLAY_SEQUENCE
1361: FROM okc_rule_groups_v rg,
1362: okc_rules_v rule
1363: WHERE rg.id = rule.rgp_id
1364: AND rg.dnz_chr_id = p_chr_id
1365: AND ( ( p_cle_id IS NULL
1366: AND

Line 5611: FROM okc_rules_v rule

5607: -- 5179119
5608: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
5609: p_rgp_id okc_k_lines_v.id%TYPE) IS
5610: SELECT rule.id
5611: FROM okc_rules_v rule
5612: WHERE rule.dnz_chr_id = p_chr_id
5613: AND rule.rgp_id = p_rgp_id
5614: AND rule.rule_information_category = 'LAASTX';
5615:

Line 5619: FROM okc_rules_v rule

5615:
5616: CURSOR get_prop_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
5617: p_rgp_id okc_k_lines_v.id%TYPE) IS
5618: SELECT rule.id
5619: FROM okc_rules_v rule
5620: WHERE rule.dnz_chr_id = p_chr_id
5621: AND rule.rgp_id = p_rgp_id
5622: AND rule.rule_information_category = 'LAPRTX';
5623:

Line 5625: ln_rule_id OKC_RULES_V.ID%TYPE;

5621: AND rule.rgp_id = p_rgp_id
5622: AND rule.rule_information_category = 'LAPRTX';
5623:
5624: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
5625: ln_rule_id OKC_RULES_V.ID%TYPE;
5626: -- 5179119
5627: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
5628: l_sales_tax_rule_found BOOLEAN;
5629:

Line 5627: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;

5623:
5624: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
5625: ln_rule_id OKC_RULES_V.ID%TYPE;
5626: -- 5179119
5627: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
5628: l_sales_tax_rule_found BOOLEAN;
5629:
5630: lv_rec_populate_check VARCHAR2(1) := 'N';
5631:

Line 6195: FROM okc_rules_v rule

6191:
6192: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
6193: p_rgp_id okc_k_lines_v.id%TYPE) IS
6194: SELECT rule.id
6195: FROM okc_rules_v rule
6196: WHERE rule.dnz_chr_id = p_chr_id
6197: AND rule.rgp_id = p_rgp_id
6198: AND rule.rule_information_category = 'LAASTX';
6199:

Line 6201: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;

6197: AND rule.rgp_id = p_rgp_id
6198: AND rule.rule_information_category = 'LAASTX';
6199:
6200: l_sales_tax_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
6201: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
6202: l_sales_tax_rgp_found BOOLEAN;
6203: l_sales_tax_rule_found BOOLEAN;
6204: l_create_rule_group BOOLEAN;
6205: -- 5179119

Line 7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;

7925: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7931: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7932: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7933: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;

Line 7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;

7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7931: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7932: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7933: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
7934: --l_rgp_id NUMBER;

Line 7931: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;

7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7931: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7932: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7933: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
7934: --l_rgp_id NUMBER;
7935:

Line 7932: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;

7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7931: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7932: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7933: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
7934: --l_rgp_id NUMBER;
7935:
7936: -- Rule Rec

Line 7933: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;

7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7931: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7932: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7933: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
7934: --l_rgp_id NUMBER;
7935:
7936: -- Rule Rec
7937: x_rgpv_rec rgpv_rec_type;