APPS.CZ_REFS dependencies on CZ_FUNC_COMP_SPECS

Line 1639: FOR m IN(SELECT func_comp_id,component_id,model_ref_expl_id FROM CZ_FUNC_COMP_SPECS

1635: -- DEBUG ERROR CODE --
1636: --
1637: ERROR_CODE:=406;
1638:
1639: FOR m IN(SELECT func_comp_id,component_id,model_ref_expl_id FROM CZ_FUNC_COMP_SPECS
1640: WHERE component_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1641: LOOP
1642: BEGIN
1643:

Line 1656: UPDATE CZ_FUNC_COMP_SPECS

1652: -- DEBUG ERROR CODE --
1653: --
1654: ERROR_CODE:=408;
1655:
1656: UPDATE CZ_FUNC_COMP_SPECS
1657: SET model_ref_expl_id=v_ref_id
1658: WHERE func_comp_id=m.func_comp_id AND component_id=m.component_id;
1659:
1660: --

Line 1667: LOG_REPORT('set_Expls','CZ_FUNC_COMP_SPECS : func_comp_id='||TO_CHAR(m.func_comp_id));

1663: ERROR_CODE:=409;
1664:
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: LOG_REPORT('set_Expls','CZ_FUNC_COMP_SPECS : func_comp_id='||TO_CHAR(m.func_comp_id));
1668: END;
1669:
1670: END LOOP;
1671:

Line 2162: UPDATE CZ_FUNC_COMP_SPECS

2158: WHERE secondary_feat_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2159: AND (secondary_feature_id=n.ps_node_id OR
2160: primary_opt_id=n.ps_node_id OR secondary_opt_id=n.ps_node_id);
2161:
2162: UPDATE CZ_FUNC_COMP_SPECS
2163: SET model_ref_expl_id=v_new_expl_id
2164: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG AND
2165: component_id=n.ps_node_id;
2166: