APPS.OKL_VP_RULE_PVT dependencies on OKC_RULE_GROUPS_B

Line 20: FROM okc_rule_groups_b

16: l_api_name CONSTANT VARCHAR2(30) := 'create_rule_group';
17: l_cnt_rg NUMBER(9) := 0;
18: CURSOR csr_chr_rg_cnt IS
19: SELECT count('X')
20: FROM okc_rule_groups_b
21: WHERE rgd_code = p_rgpv_rec.rgd_code
22: AND (dnz_chr_id = p_rgpv_rec.chr_id and cle_id IS NULL)
23: AND id <> NVL(p_rgpv_rec.id,-1);
24:

Line 127: FROM okc_rule_groups_b

123: SELECT chr_id,
124: dnz_chr_id,
125: created_by,
126: creation_date
127: FROM okc_rule_groups_b
128: WHERE ID = p_id ;
129:
130: l_chr_id okc_k_headers_b.id%TYPE;
131: l_dnz_chr_id okc_k_headers_b.id%TYPE;

Line 132: l_created_by okc_rule_groups_b.created_by%type;

128: WHERE ID = p_id ;
129:
130: l_chr_id okc_k_headers_b.id%TYPE;
131: l_dnz_chr_id okc_k_headers_b.id%TYPE;
132: l_created_by okc_rule_groups_b.created_by%type;
133: l_creation_date okc_rule_groups_b.creation_date%type;
134: -- END of code changes for bug 4723775
135:
136: BEGIN

Line 133: l_creation_date okc_rule_groups_b.creation_date%type;

129:
130: l_chr_id okc_k_headers_b.id%TYPE;
131: l_dnz_chr_id okc_k_headers_b.id%TYPE;
132: l_created_by okc_rule_groups_b.created_by%type;
133: l_creation_date okc_rule_groups_b.creation_date%type;
134: -- END of code changes for bug 4723775
135:
136: BEGIN
137: -- gboomina: bug fix for populating the mandatory fields that are

Line 217: ln_chr_id OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE;

213: i NUMBER;
214:
215:
216: -- Bug# 3477560
217: ln_chr_id OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE;
218: CURSOR get_chr_id(p_rgd_id OKC_RULE_GROUPS_B.ID%TYPE)
219: IS
220: SELECT to_char(rgd.dnz_chr_id)
221: FROM okc_rule_groups_b rgd

Line 218: CURSOR get_chr_id(p_rgd_id OKC_RULE_GROUPS_B.ID%TYPE)

214:
215:
216: -- Bug# 3477560
217: ln_chr_id OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE;
218: CURSOR get_chr_id(p_rgd_id OKC_RULE_GROUPS_B.ID%TYPE)
219: IS
220: SELECT to_char(rgd.dnz_chr_id)
221: FROM okc_rule_groups_b rgd
222: WHERE rgd.id = p_rgd_id;

Line 221: FROM okc_rule_groups_b rgd

217: ln_chr_id OKC_RULE_GROUPS_B.DNZ_CHR_ID%TYPE;
218: CURSOR get_chr_id(p_rgd_id OKC_RULE_GROUPS_B.ID%TYPE)
219: IS
220: SELECT to_char(rgd.dnz_chr_id)
221: FROM okc_rule_groups_b rgd
222: WHERE rgd.id = p_rgd_id;
223:
224: BEGIN
225:

Line 311: FROM OKC_RULE_GROUPS_B

307: lx_vrs_rulv_rec Okl_Rule_Pub.rulv_rec_type;
308:
309: cursor RULE_GROUP_CSR(P_CHR_ID IN NUMBER, P_RGD_CODE IN VARCHAR2) is
310: SELECT ID
311: FROM OKC_RULE_GROUPS_B
312: WHERE CHR_ID = P_CHR_ID AND
313: DNZ_CHR_ID = P_CHR_ID AND
314: CLE_ID IS NULL AND
315: RGD_CODE = P_RGD_CODE;

Line 634: okc_rule_groups_b rgp

630:
631: cursor RESI_PERCENT_CSR is
632: SELECT sum(to_number(nvl(RULE_INFORMATION2,0)))
633: FROM OKC_RULES_B rul,
634: okc_rule_groups_b rgp
635: WHERE rgp.ID = rul.rgp_id
636: AND rgp.dnz_chr_id = rul.dnz_chr_id
637: AND rgp.chr_id = p_chr_id;
638: