APPS.CZ_REFS dependencies on CZ_COMBO_FEATURES

Line 1682: FOR m IN(SELECT rule_id,feature_id,model_ref_expl_id FROM CZ_COMBO_FEATURES

1678: -- DEBUG ERROR CODE --
1679: --
1680: ERROR_CODE:=410;
1681:
1682: FOR m IN(SELECT rule_id,feature_id,model_ref_expl_id FROM CZ_COMBO_FEATURES
1683: WHERE feature_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1684: LOOP
1685: BEGIN
1686:

Line 1699: UPDATE CZ_COMBO_FEATURES

1695: -- DEBUG ERROR CODE --
1696: --
1697: ERROR_CODE:=412;
1698:
1699: UPDATE CZ_COMBO_FEATURES
1700: SET model_ref_expl_id=v_ref_id
1701: WHERE rule_id=m.rule_id AND feature_id=m.feature_id;
1702:
1703: --

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

1707:
1708:
1709: EXCEPTION
1710: WHEN NO_DATA_FOUND THEN
1711: LOG_REPORT('set_Expls','CZ_COMBO_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1712: WHEN OTHERS THEN
1713: LOG_REPORT('set_Expls','CZ_COMBO_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1714: END;
1715:

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

1709: EXCEPTION
1710: WHEN NO_DATA_FOUND THEN
1711: LOG_REPORT('set_Expls','CZ_COMBO_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1712: WHEN OTHERS THEN
1713: LOG_REPORT('set_Expls','CZ_COMBO_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1714: END;
1715:
1716: END LOOP;
1717:

Line 2146: UPDATE CZ_COMBO_FEATURES

2142: UPDATE CZ_EXPRESSION_NODES SET model_ref_expl_id=v_new_expl_id
2143: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2144: AND ps_node_id=n.ps_node_id;
2145:
2146: UPDATE CZ_COMBO_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: