APPS.OKL_RULE_APIS_PVT dependencies on OKC_RULES_V

Line 377: -- FUNCTION get_rec for: OKC_RULES_V

373: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
374: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULES';
375: l_api_version CONSTANT NUMBER := 1.0;
376: ---------------------------------------------------------------------------
377: -- FUNCTION get_rec for: OKC_RULES_V
378: ---------------------------------------------------------------------------
379: FUNCTION get_rulv_tab (
380: p_rgpv_rec IN rgpv_rec_type,
381: p_rdf_code IN VARCHAR2,

Line 448: FROM Okc_Rules_V

444: ans_set_jtot_object_code,
445: ans_set_jtot_object_id1,
446: ans_set_jtot_object_id2,
447: DISPLAY_SEQUENCE
448: FROM Okc_Rules_V
449: WHERE okc_rules_v.rgp_id = p_rgp_id
450: AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
451: l_rulv_rec rulv_rec_type;
452: l_rulv_tab rulv_tbl_type;

Line 449: WHERE okc_rules_v.rgp_id = p_rgp_id

445: ans_set_jtot_object_id1,
446: ans_set_jtot_object_id2,
447: DISPLAY_SEQUENCE
448: FROM Okc_Rules_V
449: WHERE okc_rules_v.rgp_id = p_rgp_id
450: AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
451: l_rulv_rec rulv_rec_type;
452: l_rulv_tab rulv_tbl_type;
453: i NUMBER default 0;