APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_RG_DEF_RULES

Line 586: FROM OKC_RG_DEF_RULES rgr

582:
583: CURSOR l_rgr_csr IS
584: -- SELECT NVL(rgr.optional_yn, 'N')
585: SELECT decode(sign(nvl(rgr.min_cardinality, 0)), 1, 'N', 'Y')
586: FROM OKC_RG_DEF_RULES rgr
587: WHERE rgr.rdf_code = p_rul_rec.rule_information_category
588: AND rgr.rgd_code = p_rgd_code;
589:
590: /* -- /striping/

Line 608: l_optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE;

604: l_rule_def okc_rule_defs_v.MEANING%TYPE;
605:
606:
607: l_dummy VARCHAR2(1);
608: l_optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE;
609:
610: l_token VARCHAR2(2000);
611: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
612: TYPE l_info_type IS REF CURSOR;

Line 1047: OKC_RG_DEF_RULES rgr,

1043: rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1044: fnd1.meaning rule_name
1045: FROM FND_LOOKUPS fnd,
1046: FND_LOOKUPS fnd1,
1047: OKC_RG_DEF_RULES rgr,
1048: OKC_RULE_GROUPS_B rgp
1049: WHERE rgp.dnz_chr_id = p_chr_id
1050: AND fnd.lookup_code = rgp.rgd_code
1051: AND fnd.lookup_type = 'OKC_RULE_GROUP_DEF'

Line 1065: OKC_RG_DEF_RULES rgr,

1061: rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1062: fnd1.meaning rule_name
1063: FROM FND_LOOKUPS fnd,
1064: okc_rule_defs_v fnd1,
1065: OKC_RG_DEF_RULES rgr,
1066: OKC_RULE_GROUPS_B rgp
1067: WHERE rgp.dnz_chr_id = p_chr_id
1068: AND fnd.lookup_code = rgp.rgd_code
1069: AND fnd.lookup_type = 'OKC_RULE_GROUP_DEF'

Line 1076: /* CURSOR l_rgr_csr(p_rgd_code IN okc_rg_def_rules.rgd_code%TYPE) IS

1072: ORDER BY rgp.id;
1073:
1074: l_rgp_rec l_rgp_csr%ROWTYPE;
1075:
1076: /* CURSOR l_rgr_csr(p_rgd_code IN okc_rg_def_rules.rgd_code%TYPE) IS
1077: SELECT rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1078: fnd.meaning
1079: FROM OKC_RG_DEF_RULES rgr,
1080: FND_LOOKUPS fnd

Line 1079: FROM OKC_RG_DEF_RULES rgr,

1075:
1076: /* CURSOR l_rgr_csr(p_rgd_code IN okc_rg_def_rules.rgd_code%TYPE) IS
1077: SELECT rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1078: fnd.meaning
1079: FROM OKC_RG_DEF_RULES rgr,
1080: FND_LOOKUPS fnd
1081: WHERE rgr.rgd_code = p_rgd_code
1082: AND rgr.rdf_code = fnd.lookup_code
1083: AND fnd.lookup_type = 'OKC_RULE_DEF';

Line 1110: l_optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE;

1106:
1107: l_prev_rgp_rec_id Number := -1;
1108: l_token VARCHAR2(2000);
1109: l_dummy VARCHAR2(1);
1110: l_optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE;
1111: l_func_curr_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
1112: l_return_status VARCHAR2(1);
1113:
1114: l_adv_pricing_profile VARCHAR2(10) := 'N';