APPS.CZ_REFS dependencies on CZ_DES_CHART_CELLS

Line 1692: secondary_feat_expl_id FROM CZ_DES_CHART_CELLS

1688: END;
1689: END LOOP;
1690:
1691: FOR m IN(SELECT rule_id,primary_opt_id,secondary_opt_id,secondary_feature_id,
1692: secondary_feat_expl_id FROM CZ_DES_CHART_CELLS
1693: WHERE secondary_feature_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1694: LOOP
1695: BEGIN
1696: v_ref_id:=get_Next_ExplId(m.secondary_feat_expl_id,v_model_ref_id,p_mode);

Line 1697: UPDATE CZ_DES_CHART_CELLS

1693: WHERE secondary_feature_id=i.ps_node_id AND deleted_flag=NO_FLAG)
1694: LOOP
1695: BEGIN
1696: v_ref_id:=get_Next_ExplId(m.secondary_feat_expl_id,v_model_ref_id,p_mode);
1697: UPDATE CZ_DES_CHART_CELLS
1698: SET secondary_feat_expl_id=v_ref_id
1699: WHERE rule_id=m.rule_id AND secondary_feature_id=m.secondary_feature_id AND
1700: primary_opt_id=m.primary_opt_id AND secondary_opt_id=m.secondary_opt_id;
1701:

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

1700: primary_opt_id=m.primary_opt_id AND secondary_opt_id=m.secondary_opt_id;
1701:
1702: EXCEPTION
1703: WHEN NO_DATA_FOUND THEN
1704: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1705: WHEN OTHERS THEN
1706: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1707: END;
1708:

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

1702: EXCEPTION
1703: WHEN NO_DATA_FOUND THEN
1704: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1705: WHEN OTHERS THEN
1706: LOG_REPORT('set_Expls','CZ_DES_CHART_CELLS : secondary_feature_id='||TO_CHAR(m.secondary_feature_id)||' rule_id='||TO_CHAR(m.rule_id));
1707: END;
1708:
1709: END LOOP;
1710:

Line 2090: UPDATE CZ_DES_CHART_CELLS

2086: SET model_ref_expl_id=v_new_expl_id
2087: WHERE model_ref_expl_id=v_old_expl_id AND deleted_flag=NO_FLAG
2088: AND feature_id=n.ps_node_id;
2089:
2090: UPDATE CZ_DES_CHART_CELLS
2091: SET secondary_feat_expl_id=v_new_expl_id
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);