APPS.CZ_REFS dependencies on CZ_DES_CHART_CELLS

Line 1758: secondary_feat_expl_id FROM CZ_DES_CHART_CELLS

1754: END;
1755: END LOOP;
1756:
1757: FOR m IN(SELECT rule_id,primary_opt_id,secondary_opt_id,secondary_feature_id,
1758: secondary_feat_expl_id FROM CZ_DES_CHART_CELLS
1759: WHERE secondary_feature_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1760: LOOP
1761: BEGIN
1762: v_ref_id:=get_Next_ExplId(m.secondary_feat_expl_id,v_model_ref_id,p_mode);

Line 1763: UPDATE CZ_DES_CHART_CELLS

1759: WHERE secondary_feature_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1760: LOOP
1761: BEGIN
1762: v_ref_id:=get_Next_ExplId(m.secondary_feat_expl_id,v_model_ref_id,p_mode);
1763: UPDATE CZ_DES_CHART_CELLS
1764: SET secondary_feat_expl_id=v_ref_id
1765: WHERE rule_id=m.rule_id AND secondary_feature_id=m.secondary_feature_id AND
1766: primary_opt_id=m.primary_opt_id AND secondary_opt_id=m.secondary_opt_id;
1767:

Line 1770: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));

1766: primary_opt_id=m.primary_opt_id AND secondary_opt_id=m.secondary_opt_id;
1767:
1768: EXCEPTION
1769: WHEN NO_DATA_FOUND THEN
1770: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1771: WHEN OTHERS THEN
1772: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1773: END;
1774:

Line 1772: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));

1768: EXCEPTION
1769: WHEN NO_DATA_FOUND THEN
1770: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1771: WHEN OTHERS THEN
1772: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1773: END;
1774:
1775: END LOOP;
1776:

Line 2156: UPDATE CZ_DES_CHART_CELLS

2152: SET model_ref_expl_id=v_new_expl_id
2153: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2154: AND feature_id=n.ps_node_id;
2155:
2156: UPDATE CZ_DES_CHART_CELLS
2157: SET secondary_feat_expl_id=v_new_expl_id
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);