DBA Data[Home] [Help]

APPS.CZ_UPGRADE dependencies on CZ_DES_CHART_FEATURES

Line 806: UPDATE cz_des_chart_features SET model_ref_expl_id = correct_expl_id

802:
803: UPDATE cz_combo_features SET model_ref_expl_id = correct_expl_id
804: WHERE feature_id = incomponentid AND deleted_flag = flag_not_deleted;
805:
806: UPDATE cz_des_chart_features SET model_ref_expl_id = correct_expl_id
807: WHERE feature_id = incomponentid AND deleted_flag = flag_not_deleted;
808:
809: UPDATE cz_des_chart_cells SET secondary_feat_expl_id = correct_expl_id
810: WHERE secondary_feature_id = incomponentid AND deleted_flag = flag_not_deleted;

Line 830: UPDATE cz_des_chart_features SET model_ref_expl_id = correct_expl_id

826:
827: UPDATE cz_combo_features SET model_ref_expl_id = correct_expl_id
828: WHERE feature_id = ntpsnodeid(i) AND deleted_flag = flag_not_deleted;
829:
830: UPDATE cz_des_chart_features SET model_ref_expl_id = correct_expl_id
831: WHERE feature_id = ntpsnodeid(i) AND deleted_flag = flag_not_deleted;
832:
833: UPDATE cz_des_chart_cells SET secondary_feat_expl_id = correct_expl_id
834: WHERE secondary_feature_id = ntpsnodeid(i) AND deleted_flag = flag_not_deleted;

Line 1778: TYPE tDesFeatureType IS TABLE OF cz_des_chart_features.feature_type%TYPE INDEX BY BINARY_INTEGER;

1774: TYPE tPresentType IS TABLE OF cz_expressions.present_type%TYPE INDEX BY BINARY_INTEGER;
1775: TYPE tGridColId IS TABLE OF cz_combo_features.grid_col_id%TYPE INDEX BY BINARY_INTEGER;
1776: TYPE tOptionId IS TABLE OF cz_grid_cells.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
1777: TYPE tConsequentFlag IS TABLE OF cz_expression_nodes.consequent_flag%TYPE INDEX BY BINARY_INTEGER;
1778: TYPE tDesFeatureType IS TABLE OF cz_des_chart_features.feature_type%TYPE INDEX BY BINARY_INTEGER;
1779:
1780: --The cursor returns all the rules assigned in this project (model)
1781:
1782: CURSOR c_rules IS

Line 2157: FROM cz_des_chart_features

2153: --Read all the features
2154:
2155: SELECT model_ref_expl_id, feature_id, feature_type, EXPR_NODE_TYPE_NODE
2156: BULK COLLECT INTO v_tExplNodeId, v_tExprPsNodeId, v_tFeatureType, v_tExprType
2157: FROM cz_des_chart_features
2158: WHERE rule_id = nRuleId
2159: AND deleted_flag = FLAG_NOT_DELETED;
2160:
2161: nDebug := 34;