APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_DES_CHART_FEATURES

Line 1197: FROM cz_des_chart_features f, cz_rules r, cz_ps_nodes p

1193: -- cursor to load all participating ps nodes in design chart or explicit comp rule
1194: ----------------------------------------------------------------------------------
1195: CURSOR l_rule_nodes_csr2 (iRuleId NUMBER) IS
1196: SELECT DISTINCT f.feature_id, p.devl_project_id, f.model_ref_expl_id
1197: FROM cz_des_chart_features f, cz_rules r, cz_ps_nodes p
1198: WHERE f.deleted_flag = '0'
1199: AND r.deleted_flag = '0'
1200: AND p.deleted_flag = '0'
1201: AND p.ps_node_id = f.feature_id

Line 1555: UPDATE cz_des_chart_features

1551: WHERE secondary_feature_id = l_index
1552: AND rule_id = l_new_rule_id;
1553:
1554: -- des chart features feature_id
1555: UPDATE cz_des_chart_features
1556: SET feature_id = l_ps_nodes_tbl(l_index)
1557: WHERE feature_id = l_index
1558: AND rule_id = l_new_rule_id;
1559:

Line 1581: UPDATE cz_des_chart_features

1577: WHERE secondary_feat_expl_id = l_index
1578: AND rule_id = l_new_rule_id;
1579:
1580: -- des_chart_features model_ref_expl_id
1581: UPDATE cz_des_chart_features
1582: SET model_ref_expl_id = l_expl_nodes_tbl(l_index)
1583: WHERE model_ref_expl_id = l_index
1584: AND rule_id = l_new_rule_id;
1585:

Line 1604: UPDATE cz_des_chart_features

1600: WHERE secondary_feat_expl_id = l_index
1601: AND rule_id = l_new_rule_id;
1602:
1603: -- des_chart_features model_ref_expl_id
1604: UPDATE cz_des_chart_features
1605: SET model_ref_expl_id = l_expl_nodes_all_tbl(l_index)
1606: WHERE model_ref_expl_id = l_index
1607: AND rule_id = l_new_rule_id;
1608:

Line 1621: UPDATE cz_des_chart_features

1617: WHERE secondary_feat_expl_id = l_expl_id
1618: AND rule_id = l_new_rule_id;
1619:
1620: -- des_chart_features model_ref_expl_id
1621: UPDATE cz_des_chart_features
1622: SET model_ref_expl_id = l_new_expl_id
1623: WHERE model_ref_expl_id = l_expl_id
1624: AND rule_id = l_new_rule_id;
1625:

Line 2115: INSERT INTO CZ_DES_CHART_FEATURES

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,
2117: FEATURE_ID,
2118: FEATURE_TYPE ,
2119: MODEL_REF_EXPL_ID,

Line 2131: FROM CZ_DES_CHART_FEATURES

2127: MODEL_REF_EXPL_ID,
2128: DELETED_FLAG,
2129: SECURITY_MASK,
2130: CHECKOUT_USER
2131: FROM CZ_DES_CHART_FEATURES
2132: WHERE rule_id=p_rule_id AND deleted_flag='0';
2133:
2134: /* need to investigate this, sselahi */
2135: if l_rule_type = RULE_TYPE_POPULATOR then