APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_DES_CHART_CELLS

Line 1537: UPDATE cz_des_chart_cells

1533: EXIT;
1534: END IF;
1535:
1536: --des chart cells primary_opt_id
1537: UPDATE cz_des_chart_cells
1538: SET primary_opt_id = l_ps_nodes_tbl(l_index)
1539: WHERE primary_opt_id = l_index
1540: AND rule_id = l_new_rule_id;
1541:

Line 1543: UPDATE cz_des_chart_cells

1539: WHERE primary_opt_id = l_index
1540: AND rule_id = l_new_rule_id;
1541:
1542: -- des chart cells secondary_opt_id
1543: UPDATE cz_des_chart_cells
1544: SET secondary_opt_id = l_ps_nodes_tbl(l_index)
1545: WHERE secondary_opt_id = l_index
1546: AND rule_id = l_new_rule_id;
1547:

Line 1549: UPDATE cz_des_chart_cells

1545: WHERE secondary_opt_id = l_index
1546: AND rule_id = l_new_rule_id;
1547:
1548: -- des chart cells secondary_feature_id
1549: UPDATE cz_des_chart_cells
1550: SET secondary_feature_id = l_ps_nodes_tbl(l_index)
1551: WHERE secondary_feature_id = l_index
1552: AND rule_id = l_new_rule_id;
1553:

Line 1575: UPDATE cz_des_chart_cells

1571: EXIT;
1572: END IF;
1573:
1574: -- des_chart_cells secondary_feature_expl_id
1575: UPDATE cz_des_chart_cells
1576: SET secondary_feat_expl_id = l_expl_nodes_tbl(l_index)
1577: WHERE secondary_feat_expl_id = l_index
1578: AND rule_id = l_new_rule_id;
1579:

Line 1598: UPDATE cz_des_chart_cells

1594: EXIT;
1595: END IF;
1596:
1597: -- des_chart_cells secondary_feature_expl_id
1598: UPDATE cz_des_chart_cells
1599: SET secondary_feat_expl_id = l_expl_nodes_all_tbl(l_index)
1600: WHERE secondary_feat_expl_id = l_index
1601: AND rule_id = l_new_rule_id;
1602:

Line 1615: UPDATE cz_des_chart_cells

1611:
1612: -- also update those nodes in subtree under the non-virtual root
1613:
1614: -- des_chart_cells secondary_feature_expl_id
1615: UPDATE cz_des_chart_cells
1616: SET secondary_feat_expl_id = l_new_expl_id
1617: WHERE secondary_feat_expl_id = l_expl_id
1618: AND rule_id = l_new_rule_id;
1619:

Line 2092: INSERT INTO CZ_DES_CHART_CELLS

2088: WHERE rule_folder_id=p_rule_id AND parent_rule_folder_id = l_rule_folder_id AND deleted_flag='0';
2089:
2090: END LOOP;
2091:
2092: INSERT INTO CZ_DES_CHART_CELLS
2093: (RULE_ID,
2094: PRIMARY_OPT_ID,
2095: SECONDARY_OPT_ID,
2096: MARK_CHAR,

Line 2112: FROM CZ_DES_CHART_CELLS

2108: SECONDARY_FEATURE_ID,
2109: DELETED_FLAG,
2110: SECURITY_MASK,
2111: CHECKOUT_USER
2112: FROM CZ_DES_CHART_CELLS
2113: WHERE rule_id=p_rule_id AND deleted_flag='0';
2114:
2115: INSERT INTO CZ_DES_CHART_FEATURES
2116: (RULE_ID,