APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_RULES_B

Line 262: ,okc_rules_b rul

258: --bug 2398639
259: CURSOR l_ph_can_rule(b_chr_id number) IS
260: SELECT 'Y'
261: FROM okc_rule_groups_b rgp
262: ,okc_rules_b rul
263: WHERE rgp.dnz_chr_id = b_chr_id
264: AND rgp.cle_id IS NULL
265: AND rul.rgp_id = rgp.id
266: AND rul.rule_information_category = 'CAN';

Line 565: p_rul_rec IN OKC_RULES_B%ROWTYPE,

561: -- End of comments
562:
563: PROCEDURE check_rule_values(
564: x_return_status OUT NOCOPY VARCHAR2,
565: p_rul_rec IN OKC_RULES_B%ROWTYPE,
566: p_rgd_code IN OKC_RULE_GROUPS_B.rgd_code%TYPE,
567: p_rgp_id IN OKC_RULE_GROUPS_B.id%TYPE,
568: p_chr_id IN OKC_RULE_GROUPS_B.chr_id%TYPE,
569: p_cle_id IN OKC_RULE_GROUPS_B.cle_id%TYPE,

Line 1029: FROM OKC_RULE_GROUPS_B rgp, OKC_RULES_B rul

1025: -- = 'CURRENCY' for core contracts
1026: --
1027: CURSOR l_cvn_csr(p_rgd_code VARCHAR2) IS
1028: SELECT 'x'
1029: FROM OKC_RULE_GROUPS_B rgp, OKC_RULES_B rul
1030: WHERE rgp.rgd_code = p_rgd_code
1031: AND rgp.dnz_chr_id = p_chr_id
1032: AND rul.dnz_chr_id = rgp.dnz_chr_id
1033: AND rgp.cle_id is null

Line 1086: CURSOR l_rul_cnt_csr(p_rgp_id IN okc_rules_b.rgp_id%TYPE,

1082: AND rgr.rdf_code = fnd.lookup_code
1083: AND fnd.lookup_type = 'OKC_RULE_DEF';
1084: l_rgr_rec l_rgr_csr%ROWTYPE; */
1085:
1086: CURSOR l_rul_cnt_csr(p_rgp_id IN okc_rules_b.rgp_id%TYPE,
1087: p_rdf_code IN okc_rules_b.rule_information_category%TYPE) IS
1088: SELECT count(*)
1089: FROM OKC_RULES_B rul
1090: WHERE rul.rule_information_category = p_rdf_code

Line 1087: p_rdf_code IN okc_rules_b.rule_information_category%TYPE) IS

1083: AND fnd.lookup_type = 'OKC_RULE_DEF';
1084: l_rgr_rec l_rgr_csr%ROWTYPE; */
1085:
1086: CURSOR l_rul_cnt_csr(p_rgp_id IN okc_rules_b.rgp_id%TYPE,
1087: p_rdf_code IN okc_rules_b.rule_information_category%TYPE) IS
1088: SELECT count(*)
1089: FROM OKC_RULES_B rul
1090: WHERE rul.rule_information_category = p_rdf_code
1091: AND rul.rgp_id = p_rgp_id;

Line 1089: FROM OKC_RULES_B rul

1085:
1086: CURSOR l_rul_cnt_csr(p_rgp_id IN okc_rules_b.rgp_id%TYPE,
1087: p_rdf_code IN okc_rules_b.rule_information_category%TYPE) IS
1088: SELECT count(*)
1089: FROM OKC_RULES_B rul
1090: WHERE rul.rule_information_category = p_rdf_code
1091: AND rul.rgp_id = p_rgp_id;
1092: l_rule_count Number;
1093:

Line 1096: FROM OKC_RULES_B rul

1092: l_rule_count Number;
1093:
1094: CURSOR l_rul_csr IS
1095: SELECT rul.*
1096: FROM OKC_RULES_B rul
1097: WHERE rgp_id = l_rgp_rec.id;
1098:
1099: l_rul_rec OKC_RULES_B%ROWTYPE;
1100:

Line 1099: l_rul_rec OKC_RULES_B%ROWTYPE;

1095: SELECT rul.*
1096: FROM OKC_RULES_B rul
1097: WHERE rgp_id = l_rgp_rec.id;
1098:
1099: l_rul_rec OKC_RULES_B%ROWTYPE;
1100:
1101: CURSOR l_cle_csr(p_id okc_k_lines_b.id%TYPE) IS
1102: SELECT cle.chr_id
1103: FROM OKC_K_LINES_B cle