APPS.CZ_REFS dependencies on CZ_DES_CHART_COLUMNS

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

1710:
1711: END IF;
1712:
1713: IF i.ps_node_type=OPTION_TYPE THEN
1714: FOR m IN(SELECT rule_id,option_id,model_ref_expl_id FROM CZ_DES_CHART_COLUMNS
1715: WHERE option_id=i.ps_node_id)
1716: LOOP
1717: BEGIN
1718: v_ref_id:=get_Next_ExplId(m.model_ref_expl_id,v_model_ref_id,p_mode);

Line 1720: UPDATE CZ_DES_CHART_COLUMNS

1716: LOOP
1717: BEGIN
1718: v_ref_id:=get_Next_ExplId(m.model_ref_expl_id,v_model_ref_id,p_mode);
1719:
1720: UPDATE CZ_DES_CHART_COLUMNS
1721: SET model_ref_expl_id=v_ref_id
1722: WHERE rule_id=m.rule_id AND option_id=m.option_id;
1723:
1724: EXCEPTION

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

1722: WHERE rule_id=m.rule_id AND option_id=m.option_id;
1723:
1724: EXCEPTION
1725: WHEN NO_DATA_FOUND THEN
1726: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));
1727: WHEN OTHERS THEN
1728: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));
1729: END;
1730: END LOOP;

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

1724: EXCEPTION
1725: WHEN NO_DATA_FOUND THEN
1726: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));
1727: WHEN OTHERS THEN
1728: LOG_REPORT('set_Expls','CZ_DES_CHART_COLUMNS : option_id='||TO_CHAR(m.option_id)||' rule_id='||TO_CHAR(m.rule_id));
1729: END;
1730: END LOOP;
1731: END IF;
1732:

Line 2101: UPDATE CZ_DES_CHART_COLUMNS

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:
2101: UPDATE CZ_DES_CHART_COLUMNS
2102: SET model_ref_expl_id=v_new_expl_id
2103: WHERE model_ref_expl_id=v_old_expl_id AND
2104: option_id=n.ps_node_id;
2105: END LOOP;