APPS.CZ_REFS dependencies on CZ_FUNC_COMP_SPECS

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

1569: -- DEBUG ERROR CODE --
1570: --
1571: ERROR_CODE:=406;
1572:
1573: FOR m IN(SELECT func_comp_id,component_id,model_ref_expl_id FROM CZ_FUNC_COMP_SPECS
1574: WHERE component_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1575: LOOP
1576: BEGIN
1577:

Line 1590: UPDATE CZ_FUNC_COMP_SPECS

1586: -- DEBUG ERROR CODE --
1587: --
1588: ERROR_CODE:=408;
1589:
1590: UPDATE CZ_FUNC_COMP_SPECS
1591: SET model_ref_expl_id=v_ref_id
1592: WHERE func_comp_id=m.func_comp_id AND component_id=m.component_id;
1593:
1594: --

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

1597: ERROR_CODE:=409;
1598:
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: LOG_REPORT('set_Expls','CZ_FUNC_COMP_SPECS : func_comp_id='||TO_CHAR(m.func_comp_id));
1602: END;
1603:
1604: END LOOP;
1605:

Line 2096: UPDATE CZ_FUNC_COMP_SPECS

2092: WHERE secondary_feat_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2093: AND (secondary_feature_id=n.ps_node_id OR
2094: primary_opt_id=n.ps_node_id OR secondary_opt_id=n.ps_node_id);
2095:
2096: UPDATE CZ_FUNC_COMP_SPECS
2097: SET model_ref_expl_id=v_new_expl_id
2098: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG AND
2099: component_id=n.ps_node_id;
2100: