DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE dependencies on CZ_DES_CHART_FEATURES

Line 9327: --We don't even need cz_des_chart_features table for explicit compatibility. Here we read all the data

9323: l_count PLS_INTEGER;
9324:
9325: BEGIN
9326:
9327: --We don't even need cz_des_chart_features table for explicit compatibility. Here we read all the data
9328: --in bulk and then transform it into another form in memory. This way we don't need any SQL ordering.
9329:
9330: SELECT primary_opt_id, secondary_opt_id, secondary_feature_id, secondary_feat_expl_id
9331: BULK COLLECT INTO tl_primaryoptid, tl_secondaryoptid, tl_featureid, tl_modelrefexplid

Line 9402: FROM cz_des_chart_features

9398: BEGIN
9399:
9400: SELECT feature_id, model_ref_expl_id, feature_type
9401: BULK COLLECT INTO tl_featureid, tl_modelrefexplid, tl_featuretype
9402: FROM cz_des_chart_features
9403: WHERE deleted_flag = '0'
9404: AND rule_id = this_rule_id;
9405:
9406: IF ( tl_featureid.COUNT = 0 ) THEN