DBA Data[Home] [Help]

APPS.OKL_RGRP_RULES_PROCESS_PVT dependencies on OKC_RULES_V

Line 128: --text OKC_RULES_V.TEXT%TYPE := NULL,

124: x_rulv_rec.attribute12 := p_rgr_rec.attribute12;
125: x_rulv_rec.attribute13 := p_rgr_rec.attribute13;
126: x_rulv_rec.attribute14 := p_rgr_rec.attribute14;
127: x_rulv_rec.attribute15 := p_rgr_rec.attribute15;
128: --text OKC_RULES_V.TEXT%TYPE := NULL,
129: x_rulv_rec.created_by := p_rgr_rec.created_by;
130: x_rulv_rec.creation_date := p_rgr_rec.creation_date;
131: x_rulv_rec.last_updated_by := p_rgr_rec.last_updated_by;
132: x_rulv_rec.last_update_date := p_rgr_rec.last_update_date;

Line 325: RETURN OKC_RULES_V.ID%TYPE IS

321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_chr_id IN NUMBER,
324: p_rgr_rec IN rgr_rec_type)
325: RETURN OKC_RULES_V.ID%TYPE IS
326: i NUMBER := 0;
327: j NUMBER;
328: rule_id NUMBER := null;
329: l_rgr_rec rgr_rec_type := p_rgr_rec;

Line 332: SELECT ID FROM OKC_RULES_V

328: rule_id NUMBER := null;
329: l_rgr_rec rgr_rec_type := p_rgr_rec;
330: cursor RULE_CSR(P_CHR_ID IN NUMBER, P_RGP_ID IN NUMBER,
331: P_RULE_CODE IN VARCHAR2) is
332: SELECT ID FROM OKC_RULES_V
333: WHERE DNZ_CHR_ID = P_CHR_ID AND
334: RGP_ID = P_RGP_ID AND
335: RULE_INFORMATION_CATEGORY = P_RULE_CODE;
336: BEGIN