DBA Data[Home] [Help]

APPS.CZ_UPGRADE dependencies on CZ_COMBO_FEATURES

Line 803: UPDATE cz_combo_features SET model_ref_expl_id = correct_expl_id

799:
800: UPDATE cz_func_comp_specs SET model_ref_expl_id = correct_expl_id
801: WHERE component_id = incomponentid AND deleted_flag = flag_not_deleted;
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;

Line 827: UPDATE cz_combo_features SET model_ref_expl_id = correct_expl_id

823:
824: UPDATE cz_func_comp_specs SET model_ref_expl_id = correct_expl_id
825: WHERE component_id = ntpsnodeid(i) AND deleted_flag = flag_not_deleted;
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;

Line 1775: TYPE tGridColId IS TABLE OF cz_combo_features.grid_col_id%TYPE INDEX BY BINARY_INTEGER;

1771: TYPE tExprDataValue IS TABLE OF cz_expression_nodes.data_value%TYPE INDEX BY BINARY_INTEGER;
1772: TYPE tExprDataNumValue IS TABLE OF cz_expression_nodes.data_num_value%TYPE INDEX BY BINARY_INTEGER; -- sselahi
1773: TYPE tExprPropertyId IS TABLE OF cz_expression_nodes.property_id%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:

Line 2113: FROM cz_combo_features

2109: --Read all the features
2110:
2111: SELECT model_ref_expl_id, feature_id, grid_col_id, EXPR_NODE_TYPE_NODE
2112: BULK COLLECT INTO v_tExplNodeId, v_tExprPsNodeId, v_tGridColId, v_tExprType
2113: FROM cz_combo_features
2114: WHERE rule_id = nRuleId
2115: AND deleted_flag = FLAG_NOT_DELETED;
2116:
2117: nDebug := 32;