APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_RULES_B

Line 52: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

48: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
49: ---------------------------------------------------------------------------
50: cursor l_rl_csr( shid NUMBER,
51: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
52: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
53: chrId NUMBER,
54: cleId NUMBER ) IS
55: select crl.id slh_id,
56: crl.object1_id1,

Line 65: OKC_RULES_B crl

61: crl.RULE_INFORMATION6,
62: crl.RULE_INFORMATION7,
63: crl.RULE_INFORMATION10
64: from OKC_RULE_GROUPS_B crg,
65: OKC_RULES_B crl
66: where crl.object2_id1 = shid
67: and crl.rgp_id = crg.id
68: and crg.RGD_CODE = rgcode
69: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 75: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

71: and nvl(crg.cle_id,-1) = cleId
72: order by crl.RULE_INFORMATION1;
73:
74: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
75: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
76: chrId NUMBER,
77: cleId NUMBER ) IS
78: select crl.id slh_id,
79: crl.object1_id1,

Line 89: OKC_RULES_B crl

85: crl.RULE_INFORMATION7,
86: crl.RULE_INFORMATION8,
87: crl.RULE_INFORMATION10
88: from OKC_RULE_GROUPS_B crg,
89: OKC_RULES_B crl
90: where crl.rgp_id = crg.id
91: and crg.RGD_CODE = rgcode
92: and crl.RULE_INFORMATION_CATEGORY = rlcat
93: and crg.dnz_chr_id = chrId

Line 98: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

94: and nvl(crg.cle_id,-1) = cleId
95: order by crl.RULE_INFORMATION1;
96:
97: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
98: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
99: chrId NUMBER) IS
100: select crl.object1_id1,
101: crl.RULE_INFORMATION1,
102: crl.RULE_INFORMATION2,

Line 111: OKC_RULES_B crl

107: crl.RULE_INFORMATION7,
108: crl.RULE_INFORMATION10,
109: crl.RULE_INFORMATION11
110: from OKC_RULE_GROUPS_B crg,
111: OKC_RULES_B crl
112: where crl.rgp_id = crg.id
113: and crg.RGD_CODE = rgcode
114: and crl.RULE_INFORMATION_CATEGORY = rlcat
115: and crg.dnz_chr_id = chrId;

Line 117: cursor l_oksrl_csr(rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

113: and crg.RGD_CODE = rgcode
114: and crl.RULE_INFORMATION_CATEGORY = rlcat
115: and crg.dnz_chr_id = chrId;
116:
117: cursor l_oksrl_csr(rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
118: chrId NUMBER,
119: cleId NUMBER) IS
120: select crl.object1_id1,
121: crl.RULE_INFORMATION1,

Line 131: OKC_RULES_B crl

127: crl.RULE_INFORMATION7,
128: crl.RULE_INFORMATION10,
129: crl.RULE_INFORMATION11
130: from OKC_RULE_GROUPS_B crg,
131: OKC_RULES_B crl
132: where crl.rgp_id = crg.id
133: and crl.RULE_INFORMATION_CATEGORY = rlcat
134: and crg.dnz_chr_id = chrId
135: and nvl(crg.cle_id, -1) = cleId;

Line 315: OKC_RULES_B crl

311:
312: Cursor l_struct_csr( chrId NUMBER ) is
313: select distinct(nvl(crl.RULE_INFORMATION5,-1)) structure
314: from OKC_RULE_GROUPS_B crg,
315: OKC_RULES_B crl
316: where crl.rgp_id = crg.id
317: and crg.RGD_CODE = 'LALEVL'
318: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
319: and crg.dnz_chr_id = chrId