APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_DES_CHART_CELLS

Line 1565: UPDATE cz_des_chart_cells

1561: EXIT;
1562: END IF;
1563:
1564: --des chart cells primary_opt_id
1565: UPDATE cz_des_chart_cells
1566: SET primary_opt_id = l_ps_nodes_tbl(l_index)
1567: WHERE primary_opt_id = l_index
1568: AND rule_id = l_new_rule_id;
1569:

Line 1571: UPDATE cz_des_chart_cells

1567: WHERE primary_opt_id = l_index
1568: AND rule_id = l_new_rule_id;
1569:
1570: -- des chart cells secondary_opt_id
1571: UPDATE cz_des_chart_cells
1572: SET secondary_opt_id = l_ps_nodes_tbl(l_index)
1573: WHERE secondary_opt_id = l_index
1574: AND rule_id = l_new_rule_id;
1575:

Line 1577: UPDATE cz_des_chart_cells

1573: WHERE secondary_opt_id = l_index
1574: AND rule_id = l_new_rule_id;
1575:
1576: -- des chart cells secondary_feature_id
1577: UPDATE cz_des_chart_cells
1578: SET secondary_feature_id = l_ps_nodes_tbl(l_index)
1579: WHERE secondary_feature_id = l_index
1580: AND rule_id = l_new_rule_id;
1581:

Line 1603: UPDATE cz_des_chart_cells

1599: EXIT;
1600: END IF;
1601:
1602: -- des_chart_cells secondary_feature_expl_id
1603: UPDATE cz_des_chart_cells
1604: SET secondary_feat_expl_id = l_expl_nodes_tbl(l_index)
1605: WHERE secondary_feat_expl_id = l_index
1606: AND rule_id = l_new_rule_id;
1607:

Line 1626: UPDATE cz_des_chart_cells

1622: EXIT;
1623: END IF;
1624:
1625: -- des_chart_cells secondary_feature_expl_id
1626: UPDATE cz_des_chart_cells
1627: SET secondary_feat_expl_id = l_expl_nodes_all_tbl(l_index)
1628: WHERE secondary_feat_expl_id = l_index
1629: AND rule_id = l_new_rule_id;
1630:

Line 1643: UPDATE cz_des_chart_cells

1639:
1640: -- also update those nodes in subtree under the non-virtual root
1641:
1642: -- des_chart_cells secondary_feature_expl_id
1643: UPDATE cz_des_chart_cells
1644: SET secondary_feat_expl_id = l_new_expl_id
1645: WHERE secondary_feat_expl_id = l_expl_id
1646: AND rule_id = l_new_rule_id;
1647:

Line 2120: INSERT INTO CZ_DES_CHART_CELLS

2116: WHERE rule_folder_id=p_rule_id AND parent_rule_folder_id = l_rule_folder_id AND deleted_flag='0';
2117:
2118: END LOOP;
2119:
2120: INSERT INTO CZ_DES_CHART_CELLS
2121: (RULE_ID,
2122: PRIMARY_OPT_ID,
2123: SECONDARY_OPT_ID,
2124: MARK_CHAR,

Line 2140: FROM CZ_DES_CHART_CELLS

2136: SECONDARY_FEATURE_ID,
2137: DELETED_FLAG,
2138: SECURITY_MASK,
2139: CHECKOUT_USER
2140: FROM CZ_DES_CHART_CELLS
2141: WHERE rule_id=p_rule_id AND deleted_flag='0';
2142:
2143: INSERT INTO CZ_DES_CHART_FEATURES
2144: (RULE_ID,