288: RULE_INFORMATION12,
289: RULE_INFORMATION13,
290: RULE_INFORMATION14,
291: RULE_INFORMATION15
292: FROM Okc_Rules_b
293: WHERE okc_rules_b.id = p_id;
294: l_okc_rulv_pk okc_rulv_pk_csr%ROWTYPE;
295: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
296: l_row_notfound BOOLEAN := TRUE;
289: RULE_INFORMATION13,
290: RULE_INFORMATION14,
291: RULE_INFORMATION15
292: FROM Okc_Rules_b
293: WHERE okc_rules_b.id = p_id;
294: l_okc_rulv_pk okc_rulv_pk_csr%ROWTYPE;
295: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
296: l_row_notfound BOOLEAN := TRUE;
297: BEGIN
463: ,x_return_status OUT NOCOPY VARCHAR2)
464: IS
465: CURSOR okl_rulv_pk_csr (p_id IN NUMBER) IS
466: SELECT '1'
467: FROM okc_rules_b
468: WHERE okc_rules_b.id = p_id;
469:
470: l_rul_status VARCHAR2(1);
471: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
464: IS
465: CURSOR okl_rulv_pk_csr (p_id IN NUMBER) IS
466: SELECT '1'
467: FROM okc_rules_b
468: WHERE okc_rules_b.id = p_id;
469:
470: l_rul_status VARCHAR2(1);
471: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
472: l_row_notfound BOOLEAN := TRUE;