APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_DES_CHART_FEATURES

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

1221: -- cursor to load all participating ps nodes in design chart or explicit comp rule
1222: ----------------------------------------------------------------------------------
1223: CURSOR l_rule_nodes_csr2 (iRuleId NUMBER) IS
1224: SELECT DISTINCT f.feature_id, p.devl_project_id, f.model_ref_expl_id
1225: FROM cz_des_chart_features f, cz_rules r, cz_ps_nodes p
1226: WHERE f.deleted_flag = '0'
1227: AND r.deleted_flag = '0'
1228: AND p.deleted_flag = '0'
1229: AND p.ps_node_id = f.feature_id

Line 1583: UPDATE cz_des_chart_features

1579: WHERE secondary_feature_id = l_index
1580: AND rule_id = l_new_rule_id;
1581:
1582: -- des chart features feature_id
1583: UPDATE cz_des_chart_features
1584: SET feature_id = l_ps_nodes_tbl(l_index)
1585: WHERE feature_id = l_index
1586: AND rule_id = l_new_rule_id;
1587:

Line 1609: UPDATE cz_des_chart_features

1605: WHERE secondary_feat_expl_id = l_index
1606: AND rule_id = l_new_rule_id;
1607:
1608: -- des_chart_features model_ref_expl_id
1609: UPDATE cz_des_chart_features
1610: SET model_ref_expl_id = l_expl_nodes_tbl(l_index)
1611: WHERE model_ref_expl_id = l_index
1612: AND rule_id = l_new_rule_id;
1613:

Line 1632: UPDATE cz_des_chart_features

1628: WHERE secondary_feat_expl_id = l_index
1629: AND rule_id = l_new_rule_id;
1630:
1631: -- des_chart_features model_ref_expl_id
1632: UPDATE cz_des_chart_features
1633: SET model_ref_expl_id = l_expl_nodes_all_tbl(l_index)
1634: WHERE model_ref_expl_id = l_index
1635: AND rule_id = l_new_rule_id;
1636:

Line 1649: UPDATE cz_des_chart_features

1645: WHERE secondary_feat_expl_id = l_expl_id
1646: AND rule_id = l_new_rule_id;
1647:
1648: -- des_chart_features model_ref_expl_id
1649: UPDATE cz_des_chart_features
1650: SET model_ref_expl_id = l_new_expl_id
1651: WHERE model_ref_expl_id = l_expl_id
1652: AND rule_id = l_new_rule_id;
1653:

Line 2143: INSERT INTO CZ_DES_CHART_FEATURES

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,
2145: FEATURE_ID,
2146: FEATURE_TYPE ,
2147: MODEL_REF_EXPL_ID,

Line 2159: FROM CZ_DES_CHART_FEATURES

2155: MODEL_REF_EXPL_ID,
2156: DELETED_FLAG,
2157: SECURITY_MASK,
2158: CHECKOUT_USER
2159: FROM CZ_DES_CHART_FEATURES
2160: WHERE rule_id=p_rule_id AND deleted_flag='0';
2161:
2162: /* need to investigate this, sselahi */
2163: if l_rule_type = RULE_TYPE_POPULATOR then