DBA Data[Home] [Help]

APPS.CZ_REFS dependencies on CZ_DES_CHART_FEATURES

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

1719: -- DEBUG ERROR CODE --
1720: --
1721: ERROR_CODE:=414;
1722:
1723: FOR m IN(SELECT rule_id,feature_id,model_ref_expl_id FROM CZ_DES_CHART_FEATURES
1724: WHERE feature_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1725: LOOP
1726: BEGIN
1727:

Line 1740: UPDATE CZ_DES_CHART_FEATURES

1736: -- DEBUG ERROR CODE --
1737: --
1738: ERROR_CODE:=416;
1739:
1740: UPDATE CZ_DES_CHART_FEATURES
1741: SET model_ref_expl_id=v_ref_id
1742: WHERE rule_id=m.rule_id AND feature_id=m.feature_id;
1743:
1744: --

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

1747: ERROR_CODE:=417;
1748:
1749: EXCEPTION
1750: WHEN NO_DATA_FOUND THEN
1751: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1752: WHEN OTHERS THEN
1753: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1754: END;
1755: END LOOP;

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

1749: EXCEPTION
1750: WHEN NO_DATA_FOUND THEN
1751: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1752: WHEN OTHERS THEN
1753: LOG_REPORT('set_Expls','CZ_DES_CHART_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1754: END;
1755: END LOOP;
1756:
1757: FOR m IN(SELECT rule_id,primary_opt_id,secondary_opt_id,secondary_feature_id,

Line 2151: UPDATE CZ_DES_CHART_FEATURES

2147: SET model_ref_expl_id=v_new_expl_id
2148: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2149: AND feature_id=n.ps_node_id;
2150:
2151: UPDATE CZ_DES_CHART_FEATURES
2152: SET model_ref_expl_id=v_new_expl_id
2153: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2154: AND feature_id=n.ps_node_id;
2155: