DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE dependencies on CZ_DES_CHART_FEATURES

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

9189: l_count PLS_INTEGER;
9190:
9191: BEGIN
9192:
9193: --We don't even need cz_des_chart_features table for explicit compatibility. Here we read all the data
9194: --in bulk and then transform it into another form in memory. This way we don't need any SQL ordering.
9195:
9196: SELECT primary_opt_id, secondary_opt_id, secondary_feature_id, secondary_feat_expl_id
9197: BULK COLLECT INTO tl_primaryoptid, tl_secondaryoptid, tl_featureid, tl_modelrefexplid

Line 9268: FROM cz_des_chart_features

9264: BEGIN
9265:
9266: SELECT feature_id, model_ref_expl_id, feature_type
9267: BULK COLLECT INTO tl_featureid, tl_modelrefexplid, tl_featuretype
9268: FROM cz_des_chart_features
9269: WHERE deleted_flag = '0'
9270: AND rule_id = this_rule_id;
9271:
9272: IF ( tl_featureid.COUNT = 0 ) THEN