1653: -- DEBUG ERROR CODE --
1654: --
1655: ERROR_CODE:=414;
1656:
1657: FOR m IN(SELECT rule_id,feature_id,model_ref_expl_id FROM CZ_DES_CHART_FEATURES
1658: WHERE feature_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1659: LOOP
1660: BEGIN
1661:
1670: -- DEBUG ERROR CODE --
1671: --
1672: ERROR_CODE:=416;
1673:
1674: UPDATE CZ_DES_CHART_FEATURES
1675: SET model_ref_expl_id=v_ref_id
1676: WHERE rule_id=m.rule_id AND feature_id=m.feature_id;
1677:
1678: --
1681: ERROR_CODE:=417;
1682:
1683: EXCEPTION
1684: WHEN NO_DATA_FOUND THEN
1685: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1686: WHEN OTHERS THEN
1687: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1688: END;
1689: END LOOP;
1683: EXCEPTION
1684: WHEN NO_DATA_FOUND THEN
1685: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1686: WHEN OTHERS THEN
1687: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1688: END;
1689: END LOOP;
1690:
1691: FOR m IN(SELECT rule_id,primary_opt_id,secondary_opt_id,secondary_feature_id,
2081: SET model_ref_expl_id=v_new_expl_id
2082: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2083: AND feature_id=n.ps_node_id;
2084:
2085: UPDATE CZ_DES_CHART_FEATURES
2086: SET model_ref_expl_id=v_new_expl_id
2087: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2088: AND feature_id=n.ps_node_id;
2089: