APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_RULE_GROUPS_V

Line 421: l_rgd_code okc_rule_groups_v.rgd_code%type;

417:
418: row_count Number default 0;
419: l_chr_id okl_k_headers.id%type;
420: l_rdf_code okc_rules_v.rule_information_category%type;
421: l_rgd_code okc_rule_groups_v.rgd_code%type;
422:
423:
424: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rule';
425: l_api_version CONSTANT NUMBER := 1.0;

Line 439: from okc_rule_groups_v rgp, okc_rules_v rul

435:
436:
437: CURSOR check_rule_csr(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
438: select count(1)
439: from okc_rule_groups_v rgp, okc_rules_v rul
440: where rgp.id = rul.rgp_id
441: and rgp.rgd_code = p_rgd_code
442: and rul.rule_information_category = p_rdf_code
443: and rgp.dnz_chr_id = p_chr_id

Line 887: l_rgd_code okc_rule_groups_v.rgd_code%type;

883:
884:
885: l_chr_id okl_k_headers.id%type;
886: l_rdf_code okc_rules_v.rule_information_category%type;
887: l_rgd_code okc_rule_groups_v.rgd_code%type;
888:
889:
890:
891: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Contact';

Line 907: from okc_rule_groups_v rgp, okc_rules_v rul

903:
904: CURSOR check_rule_csr(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
905:
906: select count(1)
907: from okc_rule_groups_v rgp, okc_rules_v rul
908: where rgp.id = rul.rgp_id
909: and rgp.rgd_code = p_rgd_code
910: and rul.rule_information_category = p_rdf_code
911: and rgp.dnz_chr_id = p_chr_id