APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_RULE_GROUPS_V

Line 437: l_rgd_code okc_rule_groups_v.rgd_code%type;

433:
434: row_count Number default 0;
435: l_chr_id okl_k_headers.id%type;
436: l_rdf_code okc_rules_v.rule_information_category%type;
437: l_rgd_code okc_rule_groups_v.rgd_code%type;
438:
439:
440: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rule';
441: l_api_version CONSTANT NUMBER := 1.0;

Line 455: from okc_rule_groups_v rgp, okc_rules_v rul

451:
452:
453: CURSOR check_rule_csr(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
454: select count(1)
455: from okc_rule_groups_v rgp, okc_rules_v rul
456: where rgp.id = rul.rgp_id
457: and rgp.rgd_code = p_rgd_code
458: and rul.rule_information_category = p_rdf_code
459: and rgp.dnz_chr_id = p_chr_id

Line 903: l_rgd_code okc_rule_groups_v.rgd_code%type;

899:
900:
901: l_chr_id okl_k_headers.id%type;
902: l_rdf_code okc_rules_v.rule_information_category%type;
903: l_rgd_code okc_rule_groups_v.rgd_code%type;
904:
905:
906:
907: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Contact';

Line 923: from okc_rule_groups_v rgp, okc_rules_v rul

919:
920: CURSOR check_rule_csr(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
921:
922: select count(1)
923: from okc_rule_groups_v rgp, okc_rules_v rul
924: where rgp.id = rul.rgp_id
925: and rgp.rgd_code = p_rgd_code
926: and rul.rule_information_category = p_rdf_code
927: and rgp.dnz_chr_id = p_chr_id