DBA Data[Home] [Help]

APPS.CZ_REFS dependencies on CZ_DES_CHART_FEATURES

Line 1657: FOR m IN(SELECT rule_id,feature_id,model_ref_expl_id FROM CZ_DES_CHART_FEATURES

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:

Line 1674: UPDATE CZ_DES_CHART_FEATURES

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: --

Line 1685: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));

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;

Line 1687: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));

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,

Line 2085: UPDATE CZ_DES_CHART_FEATURES

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: