APPS.CZ_REFS dependencies on CZ_DES_CHART_COLUMNS

Line 1780: FOR m IN(SELECT rule_id,option_id,model_ref_expl_id FROM CZ_DES_CHART_COLUMNS

1776:
1777: END IF;
1778:
1779: IF i.ps_node_type=OPTION_TYPE THEN
1780: FOR m IN(SELECT rule_id,option_id,model_ref_expl_id FROM CZ_DES_CHART_COLUMNS
1781: WHERE option_id=i.ps_node_id)
1782: LOOP
1783: BEGIN
1784: v_ref_id:=get_Next_ExplId(m.model_ref_expl_id,v_model_ref_id,p_mode);

Line 1786: UPDATE CZ_DES_CHART_COLUMNS

1782: LOOP
1783: BEGIN
1784: v_ref_id:=get_Next_ExplId(m.model_ref_expl_id,v_model_ref_id,p_mode);
1785:
1786: UPDATE CZ_DES_CHART_COLUMNS
1787: SET model_ref_expl_id=v_ref_id
1788: WHERE rule_id=m.rule_id AND option_id=m.option_id;
1789:
1790: EXCEPTION

Line 1792: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));

1788: WHERE rule_id=m.rule_id AND option_id=m.option_id;
1789:
1790: EXCEPTION
1791: WHEN NO_DATA_FOUND THEN
1792: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));
1793: WHEN OTHERS THEN
1794: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));
1795: END;
1796: END LOOP;

Line 1794: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));

1790: EXCEPTION
1791: WHEN NO_DATA_FOUND THEN
1792: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));
1793: WHEN OTHERS THEN
1794: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));
1795: END;
1796: END LOOP;
1797: END IF;
1798:

Line 2167: UPDATE CZ_DES_CHART_COLUMNS

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:
2167: UPDATE CZ_DES_CHART_COLUMNS
2168: SET model_ref_expl_id=v_new_expl_id
2169: WHERE model_ref_expl_id=v_old_expl_id AND
2170: option_id=n.ps_node_id;
2171: END LOOP;