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_OPEN_INTERFACE_PVT dependencies on OKC_RULES_V

Line 1286: p_rule_code IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,

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

Line 1295: p_rule_code OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE) IS

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

Line 1359: okc_rules_v rule

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

Line 5443: FROM okc_rules_v rule

5439: -- 5179119
5440: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
5441: p_rgp_id okc_k_lines_v.id%TYPE) IS
5442: SELECT rule.id
5443: FROM okc_rules_v rule
5444: WHERE rule.dnz_chr_id = p_chr_id
5445: AND rule.rgp_id = p_rgp_id
5446: AND rule.rule_information_category = 'LAASTX';
5447:

Line 5451: FROM okc_rules_v rule

5447:
5448: CURSOR get_prop_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
5449: p_rgp_id okc_k_lines_v.id%TYPE) IS
5450: SELECT rule.id
5451: FROM okc_rules_v rule
5452: WHERE rule.dnz_chr_id = p_chr_id
5453: AND rule.rgp_id = p_rgp_id
5454: AND rule.rule_information_category = 'LAPRTX';
5455:

Line 5457: ln_rule_id OKC_RULES_V.ID%TYPE;

5453: AND rule.rgp_id = p_rgp_id
5454: AND rule.rule_information_category = 'LAPRTX';
5455:
5456: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
5457: ln_rule_id OKC_RULES_V.ID%TYPE;
5458: -- 5179119
5459: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
5460: l_sales_tax_rule_found BOOLEAN;
5461:

Line 5459: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;

5455:
5456: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
5457: ln_rule_id OKC_RULES_V.ID%TYPE;
5458: -- 5179119
5459: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
5460: l_sales_tax_rule_found BOOLEAN;
5461:
5462: lv_rec_populate_check VARCHAR2(1) := 'N';
5463:

Line 6027: FROM okc_rules_v rule

6023:
6024: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
6025: p_rgp_id okc_k_lines_v.id%TYPE) IS
6026: SELECT rule.id
6027: FROM okc_rules_v rule
6028: WHERE rule.dnz_chr_id = p_chr_id
6029: AND rule.rgp_id = p_rgp_id
6030: AND rule.rule_information_category = 'LAASTX';
6031:

Line 6033: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;

6029: AND rule.rgp_id = p_rgp_id
6030: AND rule.rule_information_category = 'LAASTX';
6031:
6032: l_sales_tax_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
6033: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
6034: l_sales_tax_rgp_found BOOLEAN;
6035: l_sales_tax_rule_found BOOLEAN;
6036: l_create_rule_group BOOLEAN;
6037: -- 5179119

Line 7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;

7757: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7763: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7764: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7765: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;

Line 7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;

7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7763: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7764: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7765: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
7766: --l_rgp_id NUMBER;

Line 7763: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;

7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7763: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7764: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7765: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
7766: --l_rgp_id NUMBER;
7767:

Line 7764: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;

7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7763: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7764: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7765: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
7766: --l_rgp_id NUMBER;
7767:
7768: -- Rule Rec

Line 7765: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;

7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7763: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7764: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
7765: l_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
7766: --l_rgp_id NUMBER;
7767:
7768: -- Rule Rec
7769: x_rgpv_rec rgpv_rec_type;