APPS.CZ_REFS dependencies on CZ_COMBO_FEATURES

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

1612: -- DEBUG ERROR CODE --
1613: --
1614: ERROR_CODE:=410;
1615:
1616: FOR m IN(SELECT rule_id,feature_id,model_ref_expl_id FROM CZ_COMBO_FEATURES
1617: WHERE feature_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1618: LOOP
1619: BEGIN
1620:

Line 1633: UPDATE CZ_COMBO_FEATURES

1629: -- DEBUG ERROR CODE --
1630: --
1631: ERROR_CODE:=412;
1632:
1633: UPDATE CZ_COMBO_FEATURES
1634: SET model_ref_expl_id=v_ref_id
1635: WHERE rule_id=m.rule_id AND feature_id=m.feature_id;
1636:
1637: --

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

1641:
1642:
1643: EXCEPTION
1644: WHEN NO_DATA_FOUND THEN
1645: LOG_REPORT('set_Expls','CZ_COMBO_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1646: WHEN OTHERS THEN
1647: LOG_REPORT('set_Expls','CZ_COMBO_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1648: END;
1649:

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

1643: EXCEPTION
1644: WHEN NO_DATA_FOUND THEN
1645: LOG_REPORT('set_Expls','CZ_COMBO_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1646: WHEN OTHERS THEN
1647: LOG_REPORT('set_Expls','CZ_COMBO_FEATURES : feature_id='||TO_CHAR(m.feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1648: END;
1649:
1650: END LOOP;
1651:

Line 2080: UPDATE CZ_COMBO_FEATURES

2076: UPDATE CZ_EXPRESSION_NODES SET model_ref_expl_id=v_new_expl_id
2077: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2078: AND ps_node_id=n.ps_node_id;
2079:
2080: UPDATE CZ_COMBO_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: