27: ENTITY_TYPE_PROPERTY CONSTANT VARCHAR2(3) := 'PRP';
28:
29: -- special fields in id resolution
30: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id
31: -- cz_des_chart_feature.feature_id, cz_rules.rule_folder_id,
32: -- cz_ps_nodes.reference_id, cz_ui_nodes.ui_node_ref_id
33: FLD_PSN_REFERENCE_ID CONSTANT VARCHAR2(9) := 'PSNREFID';
34: FLD_RULE_COMPONENT_ID CONSTANT VARCHAR2(9) := 'RULCOMID';
35: FLD_UI_NODE_REF_ID CONSTANT VARCHAR2(9) := 'UINREFID';
426: cz_pb_mgr.v_cz_enodes_par_sig_id_ref.DELETE;
427: cz_pb_mgr.v_cz_expr_sig_ref.DELETE;
428: cz_pb_mgr.v_cz_enodes_prop_id_ref.delete;
429: END IF;
430: ELSIF(p_table_name = 'cz_rules') THEN
431: IF (p_table_type = 'ref') THEN
432: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
433: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
434: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
428: cz_pb_mgr.v_cz_enodes_prop_id_ref.delete;
429: END IF;
430: ELSIF(p_table_name = 'cz_rules') THEN
431: IF (p_table_type = 'ref') THEN
432: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
433: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
434: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
435: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
429: END IF;
430: ELSIF(p_table_name = 'cz_rules') THEN
431: IF (p_table_type = 'ref') THEN
432: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
433: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
434: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
435: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
430: ELSIF(p_table_name = 'cz_rules') THEN
431: IF (p_table_type = 'ref') THEN
432: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
433: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
434: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
435: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
431: IF (p_table_type = 'ref') THEN
432: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
433: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
434: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
435: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
432: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
433: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
434: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
435: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
433: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
434: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
435: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
434: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
435: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
442: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
435: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
442: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
443: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
436: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
442: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
443: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
444: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
437: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
442: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
443: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
444: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
445: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
438: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
442: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
443: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
444: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
445: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
446: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
439: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
442: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
443: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
444: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
445: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
446: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
447: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
440: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
442: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
443: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
444: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
445: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
446: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
447: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
448: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
441: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
442: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
443: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
444: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
445: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
446: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
447: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
448: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
449: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
444: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
445: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
446: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
447: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
448: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
449: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
450: cz_pb_mgr.v_cz_rules_ui_ref.DELETE;
451: END IF;
452: ELSIF(p_table_name = 'cz_des_chart_features')
445: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
446: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
447: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
448: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
449: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
450: cz_pb_mgr.v_cz_rules_ui_ref.DELETE;
451: END IF;
452: ELSIF(p_table_name = 'cz_des_chart_features')
453: THEN
446: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
447: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
448: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
449: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
450: cz_pb_mgr.v_cz_rules_ui_ref.DELETE;
451: END IF;
452: ELSIF(p_table_name = 'cz_des_chart_features')
453: THEN
454: IF (p_table_type = 'ref')
2757: ,'switcherCondnId'
2758: )
2759: )
2760: THEN
2761: IF (cz_pb_mgr.v_cz_rules_rule_id_idx_ref.EXISTS(l_old_id))
2762: THEN
2763: l_new_persistentid := cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_id);
2764: END IF;
2765: ELSIF(l_attr3_name IN
2759: )
2760: THEN
2761: IF (cz_pb_mgr.v_cz_rules_rule_id_idx_ref.EXISTS(l_old_id))
2762: THEN
2763: l_new_persistentid := cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_id);
2764: END IF;
2765: ELSIF(l_attr3_name IN
2766: ('urlIntlTextId', 'captionIntlTextId', 'rolloverIntlTextId', 'tableSummaryIntlTextId', 'cellIntlTextId', 'imageSourceIntlTextId')
2767: )
3940:
3941: ----caption ids of ui pages
3942: resolve_intl_texts(cz_pb_mgr.g_cz_ui_pages_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui pages');
3943:
3944: resolve_ids(cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'disabled condition of ui pages');
3945: resolve_ids(cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'enabled condition of ui pages');
3946: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');
3947: plsql_table_list.DELETE;
3948: rec_count := 1;
3941: ----caption ids of ui pages
3942: resolve_intl_texts(cz_pb_mgr.g_cz_ui_pages_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui pages');
3943:
3944: resolve_ids(cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'disabled condition of ui pages');
3945: resolve_ids(cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'enabled condition of ui pages');
3946: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');
3947: plsql_table_list.DELETE;
3948: rec_count := 1;
3949: plsql_table_list(rec_count).col_name := 'ui_def_id';
4182: pbdebug := 22034;
4183: ----resolve ui_def_id
4184: resolve_ids(cz_pb_mgr.g_page_refs_ui_def_old_ref,cz_pb_mgr.g_page_refs_ui_def_new_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of page sets');
4185: ---create rules for g_page_refs_cond_id_ref
4186: resolve_ids(cz_pb_mgr.g_page_refs_cpt_rule_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'caption rule id of page sets');
4187: resolve_ids(cz_pb_mgr.g_page_refs_cond_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'condition id of page sets');
4188: ----caption ids of ui pages
4189: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4190: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');
4183: ----resolve ui_def_id
4184: resolve_ids(cz_pb_mgr.g_page_refs_ui_def_old_ref,cz_pb_mgr.g_page_refs_ui_def_new_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of page sets');
4185: ---create rules for g_page_refs_cond_id_ref
4186: resolve_ids(cz_pb_mgr.g_page_refs_cpt_rule_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'caption rule id of page sets');
4187: resolve_ids(cz_pb_mgr.g_page_refs_cond_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'condition id of page sets');
4188: ----caption ids of ui pages
4189: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4190: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');
4191: ----resolve expl id
4679: WHEN OTHERS
4680: THEN
4681: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4682: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
4683: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
4684: RAISE;
4685: END create_uit_publication;
4686:
4687: --------------------------------
5692: -- ignore expl id resolution failure because of a ui refresh issue (see 6817586)
5693: resolve_ids(cz_pb_mgr.g_ui_actns_tgtexpl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of ui actions', FLD_IGNORE_NOW);
5694: -- context_component_id, obsolete
5695: -- resolve_ids(cz_pb_mgr.g_ui_actns_ctx_comp_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'ctx comp id of ui actions');
5696: resolve_ids(cz_pb_mgr.g_ui_actns_ren_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'render condition id of ui actions');
5697:
5698: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
5699: resolve_tmpl_ui_defs(cz_pb_mgr.g_uiact_prcpg_tmpui_tbl, cz_pb_mgr.g_uiact_prcpg_templ_tbl, 'prc pg tmp uidef of ui actions');
5700: resolve_ids(cz_pb_mgr.g_uiact_prcpg_templ_tbl, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'prc pg templ id of ui actions', ENTITY_TYPE_UCT);
6485: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
6486: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref
6487: );
6488: delete_from_table('cz_lce_headers', 'lce_header_id', v_database_link, 'cz_pb_mgr.v_cz_lce_headers_new_ref', cz_pb_mgr.v_cz_lce_headers_new_ref);
6489: delete_from_table('cz_rules', 'rule_id', v_database_link, 'cz_pb_mgr.v_cz_rules_rule_id_new_ref', cz_pb_mgr.v_cz_rules_rule_id_new_ref);
6490: delete_from_table('cz_des_chart_features'
6491: ,'rule_id'
6492: ,v_database_link
6493: ,'cz_pb_mgr.v_cz_des_feature_rid_new_ref'
6927: FROM cz_expression_nodes t
6928: WHERE t.deleted_flag = record_not_deleted
6929: AND t.expr_type <> 208
6930: AND EXISTS(SELECT 1
6931: FROM cz_rules
6932: WHERE rule_id = t.rule_id AND devl_project_id = p_model_id AND deleted_flag = record_not_deleted)
6933: AND t.deleted_flag = record_not_deleted
6934: AND t.expr_type <> 208;
6935: EXCEPTION
8080: )
8081: AS
8082: l_new_rule_id NUMBER;
8083: l_old_rule_id NUMBER;
8084: v_cz_rules_rf_id NUMBER;
8085: v_cz_rules_proj_id NUMBER;
8086: v_cz_rules_comp_id NUMBER;
8087: v_cz_rules_rea_id NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8081: AS
8082: l_new_rule_id NUMBER;
8083: l_old_rule_id NUMBER;
8084: v_cz_rules_rf_id NUMBER;
8085: v_cz_rules_proj_id NUMBER;
8086: v_cz_rules_comp_id NUMBER;
8087: v_cz_rules_rea_id NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8089: v_cz_rules_unmsg_id NUMBER;
8082: l_new_rule_id NUMBER;
8083: l_old_rule_id NUMBER;
8084: v_cz_rules_rf_id NUMBER;
8085: v_cz_rules_proj_id NUMBER;
8086: v_cz_rules_comp_id NUMBER;
8087: v_cz_rules_rea_id NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8089: v_cz_rules_unmsg_id NUMBER;
8090: v_cz_rules_expl_id NUMBER;
8083: l_old_rule_id NUMBER;
8084: v_cz_rules_rf_id NUMBER;
8085: v_cz_rules_proj_id NUMBER;
8086: v_cz_rules_comp_id NUMBER;
8087: v_cz_rules_rea_id NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8089: v_cz_rules_unmsg_id NUMBER;
8090: v_cz_rules_expl_id NUMBER;
8091: v_cz_rules_sig NUMBER;
8084: v_cz_rules_rf_id NUMBER;
8085: v_cz_rules_proj_id NUMBER;
8086: v_cz_rules_comp_id NUMBER;
8087: v_cz_rules_rea_id NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8089: v_cz_rules_unmsg_id NUMBER;
8090: v_cz_rules_expl_id NUMBER;
8091: v_cz_rules_sig NUMBER;
8092: v_cz_rules_ui NUMBER;
8085: v_cz_rules_proj_id NUMBER;
8086: v_cz_rules_comp_id NUMBER;
8087: v_cz_rules_rea_id NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8089: v_cz_rules_unmsg_id NUMBER;
8090: v_cz_rules_expl_id NUMBER;
8091: v_cz_rules_sig NUMBER;
8092: v_cz_rules_ui NUMBER;
8093: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8086: v_cz_rules_comp_id NUMBER;
8087: v_cz_rules_rea_id NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8089: v_cz_rules_unmsg_id NUMBER;
8090: v_cz_rules_expl_id NUMBER;
8091: v_cz_rules_sig NUMBER;
8092: v_cz_rules_ui NUMBER;
8093: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8094:
8087: v_cz_rules_rea_id NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8089: v_cz_rules_unmsg_id NUMBER;
8090: v_cz_rules_expl_id NUMBER;
8091: v_cz_rules_sig NUMBER;
8092: v_cz_rules_ui NUMBER;
8093: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8094:
8095: rec_count NUMBER;
8088: v_cz_rules_eff_id NUMBER;
8089: v_cz_rules_unmsg_id NUMBER;
8090: v_cz_rules_expl_id NUMBER;
8091: v_cz_rules_sig NUMBER;
8092: v_cz_rules_ui NUMBER;
8093: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8094:
8095: rec_count NUMBER;
8096: BEGIN
8089: v_cz_rules_unmsg_id NUMBER;
8090: v_cz_rules_expl_id NUMBER;
8091: v_cz_rules_sig NUMBER;
8092: v_cz_rules_ui NUMBER;
8093: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8094:
8095: rec_count NUMBER;
8096: BEGIN
8097: IF (x_status = PUBLICATION_ERROR OR p_rule_id_array.COUNT = 0) THEN
8097: IF (x_status = PUBLICATION_ERROR OR p_rule_id_array.COUNT = 0) THEN
8098: RETURN;
8099: END IF;
8100:
8101: rec_count := cz_pb_mgr.v_cz_rules_rule_id_new_ref.COUNT;
8102:
8103: FOR i IN p_rule_id_array.FIRST .. p_rule_id_array.LAST
8104: LOOP
8105: IF (p_rule_type_array(i) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)) THEN
8103: FOR i IN p_rule_id_array.FIRST .. p_rule_id_array.LAST
8104: LOOP
8105: IF (p_rule_type_array(i) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)) THEN
8106: BEGIN
8107: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
8108: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link
8109: ,cz_pb_mgr.v_oraclesequenceincr
8110: )
8111: ,rule_id, rule_folder_id, devl_project_id, component_id
8104: LOOP
8105: IF (p_rule_type_array(i) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)) THEN
8106: BEGIN
8107: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
8108: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link
8109: ,cz_pb_mgr.v_oraclesequenceincr
8110: )
8111: ,rule_id, rule_folder_id, devl_project_id, component_id
8112: ,reason_id, unsatisfied_msg_id, effectivity_set_id
8111: ,rule_id, rule_folder_id, devl_project_id, component_id
8112: ,reason_id, unsatisfied_msg_id, effectivity_set_id
8113: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
8114: INTO l_new_rule_id
8115: ,l_old_rule_id, v_cz_rules_rf_id, v_cz_rules_proj_id, v_cz_rules_comp_id
8116: ,v_cz_rules_rea_id, v_cz_rules_unmsg_id, v_cz_rules_eff_id
8117: ,v_cz_rules_expl_id, v_cz_rules_sig, v_cz_rules_ui, v_cz_eff_usage_mask
8118: FROM cz_rules
8119: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8112: ,reason_id, unsatisfied_msg_id, effectivity_set_id
8113: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
8114: INTO l_new_rule_id
8115: ,l_old_rule_id, v_cz_rules_rf_id, v_cz_rules_proj_id, v_cz_rules_comp_id
8116: ,v_cz_rules_rea_id, v_cz_rules_unmsg_id, v_cz_rules_eff_id
8117: ,v_cz_rules_expl_id, v_cz_rules_sig, v_cz_rules_ui, v_cz_eff_usage_mask
8118: FROM cz_rules
8119: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8120:
8113: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
8114: INTO l_new_rule_id
8115: ,l_old_rule_id, v_cz_rules_rf_id, v_cz_rules_proj_id, v_cz_rules_comp_id
8116: ,v_cz_rules_rea_id, v_cz_rules_unmsg_id, v_cz_rules_eff_id
8117: ,v_cz_rules_expl_id, v_cz_rules_sig, v_cz_rules_ui, v_cz_eff_usage_mask
8118: FROM cz_rules
8119: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8120:
8121: rec_count := rec_count + 1;
8114: INTO l_new_rule_id
8115: ,l_old_rule_id, v_cz_rules_rf_id, v_cz_rules_proj_id, v_cz_rules_comp_id
8116: ,v_cz_rules_rea_id, v_cz_rules_unmsg_id, v_cz_rules_eff_id
8117: ,v_cz_rules_expl_id, v_cz_rules_sig, v_cz_rules_ui, v_cz_eff_usage_mask
8118: FROM cz_rules
8119: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8120:
8121: rec_count := rec_count + 1;
8122: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8118: FROM cz_rules
8119: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8120:
8121: rec_count := rec_count + 1;
8122: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8123: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8124: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8125: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8119: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8120:
8121: rec_count := rec_count + 1;
8122: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8123: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8124: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8125: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8120:
8121: rec_count := rec_count + 1;
8122: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8123: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8124: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8125: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8121: rec_count := rec_count + 1;
8122: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8123: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8124: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8125: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8122: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8123: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8124: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8125: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8123: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8124: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8125: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8131: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8124: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8125: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8131: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8132: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8125: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8131: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8132: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8133: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8126: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8131: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8132: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8133: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8134: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8127: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8131: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8132: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8133: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8134: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8135: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8128: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8131: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8132: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8133: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8134: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8135: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8136: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_new_rule_id;
8129: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8131: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8132: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8133: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8134: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8135: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8136: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_new_rule_id;
8137:
8130: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8131: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8132: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8133: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8134: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8135: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8136: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_new_rule_id;
8137:
8138: EXCEPTION
8132: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8133: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8134: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8135: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8136: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_new_rule_id;
8137:
8138: EXCEPTION
8139: WHEN NO_DATA_FOUND THEN
8140: cz_pb_mgr.v_err_message := 'No rules found: ' || p_rule_id_array(i);
8141: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULES', SQLCODE);
8142: END;
8143:
8144: BEGIN
8145: p_rule_id_array(i) := cz_pb_mgr.v_cz_rules_rule_id_idx_ref(p_rule_id_array(i));
8146: EXCEPTION
8147: WHEN OTHERS THEN
8148: NULL;
8149: END;
8150: END IF;
8151: END LOOP;
8152: EXCEPTION
8153: WHEN OTHERS THEN
8154: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
8155: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
8156: x_status := PUBLICATION_ERROR;
8157: RAISE;
8158: END collect_global_rules;
8151: END LOOP;
8152: EXCEPTION
8153: WHEN OTHERS THEN
8154: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
8155: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
8156: x_status := PUBLICATION_ERROR;
8157: RAISE;
8158: END collect_global_rules;
8159:
8400: --For publishing, this code gets executed right in the beginning(when all the tables are empty
8401: --anyway), and seems redundant. But for the risk of introducing regressions, we
8402: --will execute this only for publishing.
8403: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
8404: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
8405: END IF;
8406:
8407: cz_pb_mgr.g_ui_templates_old_temp_id_ref.DELETE;
8408: cz_pb_mgr.g_ui_templates_new_temp_id_ref.DELETE;
9236: FROM cz_expression_nodes t
9237: WHERE t.deleted_flag = '0'
9238: AND t.expr_type <> 208
9239: AND EXISTS(SELECT 1
9240: FROM cz_rules
9241: WHERE rule_id = t.rule_id AND devl_project_id = v_model_id AND deleted_flag = '0')
9242: AND t.deleted_flag = '0'
9243: AND t.expr_type <> 208;
9244:
10313: FROM cz_intl_texts
10314: WHERE model_id = cz_pb_mgr.v_models_to_be_exported(i)
10315: AND deleted_flag = '0' AND (seeded_flag IS NULL OR seeded_flag = '0')
10316: AND intl_text_id IN (SELECT reason_id
10317: FROM cz_rules
10318: WHERE devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
10319: AND deleted_flag = '0' AND reason_id IS NOT NULL
10320: UNION ALL
10321: SELECT unsatisfied_msg_id
10318: WHERE devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
10319: AND deleted_flag = '0' AND reason_id IS NOT NULL
10320: UNION ALL
10321: SELECT unsatisfied_msg_id
10322: FROM cz_rules
10323: WHERE devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
10324: AND deleted_flag = '0' AND unsatisfied_msg_id IS NOT NULL);
10325: IF l_text_id_tbl.COUNT > 0 THEN
10326: FOR j IN l_text_id_tbl.FIRST .. l_text_id_tbl.LAST LOOP
10332: END get_rule_intl_text_ids;
10333:
10334: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10335: ---------procedure to copy data into cz_lce_texts
10336: ---------reason ids and unsatisfied message ids of cz rules
10337: ---------are copied and resolved in this procedure
10338: ---------
10339: PROCEDURE copy_lce_texts(p_copy_rules_flag IN VARCHAR2)
10340: IS
12008: ,p_rules_sng_array IN OUT NOCOPY cz_pb_mgr.t_ref_idx_vc2
12009: ,x_status IN OUT NOCOPY VARCHAR2
12010: )
12011: AS
12012: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12013: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12014: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12015: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12009: ,x_status IN OUT NOCOPY VARCHAR2
12010: )
12011: AS
12012: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12013: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12014: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12015: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12010: )
12011: AS
12012: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12013: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12014: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12015: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12011: AS
12012: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12013: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12014: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12015: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12012: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12013: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12014: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12015: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12020: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12013: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12014: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12015: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12020: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12021: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12014: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12015: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12020: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12021: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12022: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12015: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12020: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12021: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12022: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12023: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12016: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12020: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12021: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12022: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12023: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12024: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12017: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12020: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12021: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12022: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12023: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12024: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12025: l_object_type cz_rule_folders.object_type%TYPE;
12018: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12020: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12021: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12022: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12023: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12024: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12025: l_object_type cz_rule_folders.object_type%TYPE;
12026: l_rule_type_tbl cz_pb_mgr.t_ref;
12019: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12020: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12021: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12022: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12023: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12024: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12025: l_object_type cz_rule_folders.object_type%TYPE;
12026: l_rule_type_tbl cz_pb_mgr.t_ref;
12027:
12030: BEGIN
12031: IF (x_status = PUBLICATION_ERROR OR p_model_array.COUNT = 0) THEN
12032: RETURN;
12033: END IF;
12034: rec_count := cz_pb_mgr.v_cz_rules_rule_id_new_ref.COUNT; -- ? 0
12035:
12036: FOR i IN p_model_array.FIRST .. p_model_array.LAST
12037: LOOP
12038: l_cz_rules_new_id_tbl.DELETE;
12034: rec_count := cz_pb_mgr.v_cz_rules_rule_id_new_ref.COUNT; -- ? 0
12035:
12036: FOR i IN p_model_array.FIRST .. p_model_array.LAST
12037: LOOP
12038: l_cz_rules_new_id_tbl.DELETE;
12039: l_cz_rules_old_id_tbl.DELETE;
12040: l_cz_rules_rf_id_tbl.DELETE;
12041: l_cz_rules_proj_id_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12035:
12036: FOR i IN p_model_array.FIRST .. p_model_array.LAST
12037: LOOP
12038: l_cz_rules_new_id_tbl.DELETE;
12039: l_cz_rules_old_id_tbl.DELETE;
12040: l_cz_rules_rf_id_tbl.DELETE;
12041: l_cz_rules_proj_id_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12036: FOR i IN p_model_array.FIRST .. p_model_array.LAST
12037: LOOP
12038: l_cz_rules_new_id_tbl.DELETE;
12039: l_cz_rules_old_id_tbl.DELETE;
12040: l_cz_rules_rf_id_tbl.DELETE;
12041: l_cz_rules_proj_id_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12037: LOOP
12038: l_cz_rules_new_id_tbl.DELETE;
12039: l_cz_rules_old_id_tbl.DELETE;
12040: l_cz_rules_rf_id_tbl.DELETE;
12041: l_cz_rules_proj_id_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12045: l_cz_rules_unmsg_id_tbl.DELETE;
12038: l_cz_rules_new_id_tbl.DELETE;
12039: l_cz_rules_old_id_tbl.DELETE;
12040: l_cz_rules_rf_id_tbl.DELETE;
12041: l_cz_rules_proj_id_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12045: l_cz_rules_unmsg_id_tbl.DELETE;
12046: l_cz_rules_expl_id_tbl.DELETE;
12039: l_cz_rules_old_id_tbl.DELETE;
12040: l_cz_rules_rf_id_tbl.DELETE;
12041: l_cz_rules_proj_id_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12045: l_cz_rules_unmsg_id_tbl.DELETE;
12046: l_cz_rules_expl_id_tbl.DELETE;
12047: l_cz_rules_sig_tbl.DELETE;
12040: l_cz_rules_rf_id_tbl.DELETE;
12041: l_cz_rules_proj_id_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12045: l_cz_rules_unmsg_id_tbl.DELETE;
12046: l_cz_rules_expl_id_tbl.DELETE;
12047: l_cz_rules_sig_tbl.DELETE;
12048: l_cz_rules_ui_tbl.DELETE;
12041: l_cz_rules_proj_id_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12045: l_cz_rules_unmsg_id_tbl.DELETE;
12046: l_cz_rules_expl_id_tbl.DELETE;
12047: l_cz_rules_sig_tbl.DELETE;
12048: l_cz_rules_ui_tbl.DELETE;
12049: l_eff_usg_mask_tbl.DELETE;
12042: l_cz_rules_comp_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12045: l_cz_rules_unmsg_id_tbl.DELETE;
12046: l_cz_rules_expl_id_tbl.DELETE;
12047: l_cz_rules_sig_tbl.DELETE;
12048: l_cz_rules_ui_tbl.DELETE;
12049: l_eff_usg_mask_tbl.DELETE;
12050: l_cz_rules_perst_id_tbl.DELETE;
12043: l_cz_rules_rea_id_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12045: l_cz_rules_unmsg_id_tbl.DELETE;
12046: l_cz_rules_expl_id_tbl.DELETE;
12047: l_cz_rules_sig_tbl.DELETE;
12048: l_cz_rules_ui_tbl.DELETE;
12049: l_eff_usg_mask_tbl.DELETE;
12050: l_cz_rules_perst_id_tbl.DELETE;
12051: l_rule_type_tbl.DELETE;
12044: l_cz_rules_eff_id_tbl.DELETE;
12045: l_cz_rules_unmsg_id_tbl.DELETE;
12046: l_cz_rules_expl_id_tbl.DELETE;
12047: l_cz_rules_sig_tbl.DELETE;
12048: l_cz_rules_ui_tbl.DELETE;
12049: l_eff_usg_mask_tbl.DELETE;
12050: l_cz_rules_perst_id_tbl.DELETE;
12051: l_rule_type_tbl.DELETE;
12052:
12046: l_cz_rules_expl_id_tbl.DELETE;
12047: l_cz_rules_sig_tbl.DELETE;
12048: l_cz_rules_ui_tbl.DELETE;
12049: l_eff_usg_mask_tbl.DELETE;
12050: l_cz_rules_perst_id_tbl.DELETE;
12051: l_rule_type_tbl.DELETE;
12052:
12053: BEGIN
12054: IF (cz_pb_mgr.v_session_parameter = MODEL_COPY) THEN
12052:
12053: BEGIN
12054: IF (cz_pb_mgr.v_session_parameter = MODEL_COPY) THEN
12055: IF (COPY_RULES = 'YES') THEN
12056: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
12057: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
12058: ,rule_id, rule_folder_id, devl_project_id, component_id
12059: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12060: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12053: BEGIN
12054: IF (cz_pb_mgr.v_session_parameter = MODEL_COPY) THEN
12055: IF (COPY_RULES = 'YES') THEN
12056: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
12057: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
12058: ,rule_id, rule_folder_id, devl_project_id, component_id
12059: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12060: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12061: ,persistent_rule_id, rule_type
12058: ,rule_id, rule_folder_id, devl_project_id, component_id
12059: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12060: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12061: ,persistent_rule_id, rule_type
12062: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12063: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12064: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12065: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12066: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12059: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12060: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12061: ,persistent_rule_id, rule_type
12062: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12063: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12064: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12065: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12066: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12067: FROM cz_rules t
12060: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12061: ,persistent_rule_id, rule_type
12062: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12063: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12064: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12065: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12066: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12067: FROM cz_rules t
12068: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
12061: ,persistent_rule_id, rule_type
12062: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12063: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12064: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12065: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12066: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12067: FROM cz_rules t
12068: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
12069: AND t.seeded_flag <> SEED_DATA
12062: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12063: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12064: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12065: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12066: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12067: FROM cz_rules t
12068: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
12069: AND t.seeded_flag <> SEED_DATA
12070: AND ((CZ_PB_MGR.COPY_UIS='YES')
12063: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12064: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12065: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12066: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12067: FROM cz_rules t
12068: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
12069: AND t.seeded_flag <> SEED_DATA
12070: AND ((CZ_PB_MGR.COPY_UIS='YES')
12071: OR
12083:
12084: END IF;
12085: ELSE
12086: IF (p_rules_flag = 'YES') THEN
12087: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
12088: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
12089: ,rule_id, rule_folder_id, devl_project_id, component_id
12090: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12091: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12084: END IF;
12085: ELSE
12086: IF (p_rules_flag = 'YES') THEN
12087: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
12088: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
12089: ,rule_id, rule_folder_id, devl_project_id, component_id
12090: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12091: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12092: ,persistent_rule_id, rule_type
12089: ,rule_id, rule_folder_id, devl_project_id, component_id
12090: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12091: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12092: ,persistent_rule_id, rule_type
12093: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12094: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12095: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12096: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12097: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12090: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12091: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12092: ,persistent_rule_id, rule_type
12093: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12094: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12095: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12096: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12097: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12098: FROM cz_rules t
12091: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12092: ,persistent_rule_id, rule_type
12093: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12094: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12095: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12096: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12097: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12098: FROM cz_rules t
12099: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
12092: ,persistent_rule_id, rule_type
12093: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12094: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12095: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12096: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12097: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12098: FROM cz_rules t
12099: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
12100: AND t.seeded_flag <> SEED_DATA
12093: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12094: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12095: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12096: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12097: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12098: FROM cz_rules t
12099: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
12100: AND t.seeded_flag <> SEED_DATA
12101: AND (
12094: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12095: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12096: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12097: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12098: FROM cz_rules t
12099: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
12100: AND t.seeded_flag <> SEED_DATA
12101: AND (
12102: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
12108: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
12109: );
12110:
12111: ELSE
12112: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
12113: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
12114: ,rule_id, rule_folder_id, devl_project_id, component_id
12115: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12116: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12109: );
12110:
12111: ELSE
12112: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
12113: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
12114: ,rule_id, rule_folder_id, devl_project_id, component_id
12115: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12116: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12117: ,persistent_rule_id, rule_type
12114: ,rule_id, rule_folder_id, devl_project_id, component_id
12115: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12116: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12117: ,persistent_rule_id, rule_type
12118: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12119: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12120: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12121: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12122: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12115: ,reason_id, unsatisfied_msg_id, effectivity_set_id
12116: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12117: ,persistent_rule_id, rule_type
12118: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12119: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12120: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12121: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12122: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12123: FROM cz_rules t
12116: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
12117: ,persistent_rule_id, rule_type
12118: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12119: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12120: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12121: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12122: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12123: FROM cz_rules t
12124: WHERE t.devl_project_id = p_model_array(i)
12117: ,persistent_rule_id, rule_type
12118: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12119: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12120: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12121: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12122: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12123: FROM cz_rules t
12124: WHERE t.devl_project_id = p_model_array(i)
12125: AND t.rule_type IN (RULE_TYPE_CONFIG_EXTENSION, RULE_TYPE_DISPLAY_CONDITION,
12118: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
12119: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12120: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12121: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12122: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12123: FROM cz_rules t
12124: WHERE t.devl_project_id = p_model_array(i)
12125: AND t.rule_type IN (RULE_TYPE_CONFIG_EXTENSION, RULE_TYPE_DISPLAY_CONDITION,
12126: RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)
12119: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
12120: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
12121: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
12122: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
12123: FROM cz_rules t
12124: WHERE t.devl_project_id = p_model_array(i)
12125: AND t.rule_type IN (RULE_TYPE_CONFIG_EXTENSION, RULE_TYPE_DISPLAY_CONDITION,
12126: RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)
12127: AND t.deleted_flag = '0' AND t.seeded_flag <> SEED_DATA
12144: WHEN OTHERS THEN
12145: RAISE;
12146: END;
12147:
12148: IF l_cz_rules_new_id_tbl.COUNT > 0 THEN
12149: FOR k IN l_cz_rules_new_id_tbl.FIRST .. l_cz_rules_new_id_tbl.LAST
12150: LOOP
12151: rec_count := rec_count + 1;
12152: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
12145: RAISE;
12146: END;
12147:
12148: IF l_cz_rules_new_id_tbl.COUNT > 0 THEN
12149: FOR k IN l_cz_rules_new_id_tbl.FIRST .. l_cz_rules_new_id_tbl.LAST
12150: LOOP
12151: rec_count := rec_count + 1;
12152: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
12153: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
12148: IF l_cz_rules_new_id_tbl.COUNT > 0 THEN
12149: FOR k IN l_cz_rules_new_id_tbl.FIRST .. l_cz_rules_new_id_tbl.LAST
12150: LOOP
12151: rec_count := rec_count + 1;
12152: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
12153: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
12154: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
12155: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12149: FOR k IN l_cz_rules_new_id_tbl.FIRST .. l_cz_rules_new_id_tbl.LAST
12150: LOOP
12151: rec_count := rec_count + 1;
12152: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
12153: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
12154: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
12155: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12150: LOOP
12151: rec_count := rec_count + 1;
12152: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
12153: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
12154: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
12155: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12151: rec_count := rec_count + 1;
12152: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
12153: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
12154: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
12155: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12159: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
12152: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
12153: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
12154: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
12155: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12159: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
12160: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
12153: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
12154: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
12155: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12159: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
12160: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
12161: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
12154: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
12155: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12159: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
12160: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
12161: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
12162: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
12155: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12159: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
12160: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
12161: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
12162: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
12163: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
12156: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12159: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
12160: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
12161: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
12162: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
12163: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
12164: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
12157: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12159: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
12160: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
12161: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
12162: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
12163: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
12164: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
12165: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
12158: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
12159: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
12160: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
12161: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
12162: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
12163: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
12164: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
12165: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
12166:
12160: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
12161: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
12162: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
12163: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
12164: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
12165: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
12166:
12167: IF l_rule_type_tbl(k) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
12168: RULE_TYPE_CAPTION, RULE_TYPE_POPULATOR) THEN
12161: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
12162: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
12163: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
12164: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
12165: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
12166:
12167: IF l_rule_type_tbl(k) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
12168: RULE_TYPE_CAPTION, RULE_TYPE_POPULATOR) THEN
12169: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
12165: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
12166:
12167: IF l_rule_type_tbl(k) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
12168: RULE_TYPE_CAPTION, RULE_TYPE_POPULATOR) THEN
12169: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
12170: ELSE
12171: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := l_cz_rules_rf_id_tbl(k);
12172: END IF;
12173: END LOOP;
12167: IF l_rule_type_tbl(k) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
12168: RULE_TYPE_CAPTION, RULE_TYPE_POPULATOR) THEN
12169: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
12170: ELSE
12171: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := l_cz_rules_rf_id_tbl(k);
12172: END IF;
12173: END LOOP;
12174: END IF;
12175: END LOOP;
12181: BEGIN
12182: SELECT object_type INTO l_object_type
12183: FROM cz_rule_folders
12184: WHERE rule_folder_id = p_rules_old_array(j) AND object_type NOT IN ('FNC', 'RFL', 'RSQ');
12185: cz_pb_mgr.v_cz_rules_obj_ref(j) := l_object_type;
12186: EXCEPTION
12187: WHEN NO_DATA_FOUND THEN
12188: NULL;
12189: END;
12190: END LOOP;
12191: END IF;
12192: EXCEPTION
12193: WHEN OTHERS THEN
12194: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
12195: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
12196: x_status := PUBLICATION_ERROR;
12197: RAISE;
12198: END bulk_collect_rules;
12191: END IF;
12192: EXCEPTION
12193: WHEN OTHERS THEN
12194: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
12195: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
12196: x_status := PUBLICATION_ERROR;
12197: RAISE;
12198: END bulk_collect_rules;
12199:
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12219: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
12220: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
12221: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
12222: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
12223: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
12224: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);
12225: clear_tables('cz_lce_headers', 'ref', cz_pb_mgr.v_status_code);
12226: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
12895: END IF;
12896:
12897: IF (cz_pb_mgr.l_bom_caption_rule <> 0)
12898: THEN
12899: resolve_ids(cz_pb_mgr.l_bom_caption_rule_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'bom rule ids of projects', ENTITY_TYPE_RULE);
12900: ELSE
12901: cz_pb_mgr.l_bom_caption_rule := NULL;
12902: END IF;
12903:
12902: END IF;
12903:
12904: IF (cz_pb_mgr.l_nonbom_capt_rule_id <> 0)
12905: THEN
12906: resolve_ids(cz_pb_mgr.l_nonbom_caption_rule_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'non bom rule ids of projects', ENTITY_TYPE_RULE);
12907: ELSE
12908: cz_pb_mgr.l_nonbom_capt_rule_id := NULL;
12909: END IF;
12910:
13454: ,'cz_pb_mgr.v_cz_eff_sets_old_tbl'
13455: ,'cz_pb_mgr.v_cz_eff_sets_new_tbl'
13456: ,'Eff sets of ps nodes'
13457: );
13458: ------clear_tables('cz_rules','ref',cz_pb_mgr.v_status_code);
13459: -----bulk collect old and new rule ids
13460: bulk_collect_rules(p_export_flag
13461: ,cz_pb_mgr.v_models_to_be_exported
13462: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
13458: ------clear_tables('cz_rules','ref',cz_pb_mgr.v_status_code);
13459: -----bulk collect old and new rule ids
13460: bulk_collect_rules(p_export_flag
13461: ,cz_pb_mgr.v_models_to_be_exported
13462: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
13463: ,cz_pb_mgr.v_cz_rules_rule_id_new_ref
13464: ,cz_pb_mgr.v_cz_rules_rule_id_idx_ref
13465: ,cz_pb_mgr.v_status_code
13466: );
13459: -----bulk collect old and new rule ids
13460: bulk_collect_rules(p_export_flag
13461: ,cz_pb_mgr.v_models_to_be_exported
13462: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
13463: ,cz_pb_mgr.v_cz_rules_rule_id_new_ref
13464: ,cz_pb_mgr.v_cz_rules_rule_id_idx_ref
13465: ,cz_pb_mgr.v_status_code
13466: );
13467:
13460: bulk_collect_rules(p_export_flag
13461: ,cz_pb_mgr.v_models_to_be_exported
13462: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
13463: ,cz_pb_mgr.v_cz_rules_rule_id_new_ref
13464: ,cz_pb_mgr.v_cz_rules_rule_id_idx_ref
13465: ,cz_pb_mgr.v_status_code
13466: );
13467:
13468: IF (cz_pb_mgr.g_log_timing = publication_timing)
13473:
13474: -- resolve effective usage mask for rules
13475: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
13476: THEN
13477: resolve_effective_usage_mask(cz_pb_mgr.v_cz_rules_rule_id_old_ref, 1);
13478: END IF;
13479:
13480: ---------resolve eff sets
13481: resolve_ids(cz_pb_mgr.v_ps_eff_set_id_tbl, cz_pb_mgr.v_cz_eff_sets_idx_tbl, 'eff sets of ps nodes');
13541: THEN
13542: log_timing_message('start resolve caption rule ids in ps nodes');
13543: END IF;
13544:
13545: resolve_ids(cz_pb_mgr.v_ps_capt_rule_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'caption rule ids of ps nodes');
13546:
13547: IF (cz_pb_mgr.g_log_timing = publication_timing)
13548: THEN
13549: log_timing_message('end resolve resolve caption rule ids in ps nodes');
14334: THEN
14335: log_timing_message('end component_ids of models not to be exported');
14336: END IF;
14337:
14338: resolve_ids(cz_pb_mgr.v_ui_defs_mcpt_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'menu caption rule ids of ui defs');
14339: resolve_ids(cz_pb_mgr.v_ui_defs_pcpt_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'page caption rule ids of ui defs');
14340:
14341: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
14342: THEN
14335: log_timing_message('end component_ids of models not to be exported');
14336: END IF;
14337:
14338: resolve_ids(cz_pb_mgr.v_ui_defs_mcpt_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'menu caption rule ids of ui defs');
14339: resolve_ids(cz_pb_mgr.v_ui_defs_pcpt_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'page caption rule ids of ui defs');
14340:
14341: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
14342: THEN
14343: synch_master_template;
14960: IS
14961: plsql_table_list cz_pb_mgr.col_plsql_table_list;
14962: rec_count NUMBER := 0;
14963: BEGIN
14964: ---------------reason id of cz rules
14965: insert_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, 'Reason ids of cz rules');
14966: --------resolve reason ids
14967: resolve_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'reason id of cz rules');
14968:
14961: plsql_table_list cz_pb_mgr.col_plsql_table_list;
14962: rec_count NUMBER := 0;
14963: BEGIN
14964: ---------------reason id of cz rules
14965: insert_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, 'Reason ids of cz rules');
14966: --------resolve reason ids
14967: resolve_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'reason id of cz rules');
14968:
14969: ---------------unsatisfied message of cz rules
14963: BEGIN
14964: ---------------reason id of cz rules
14965: insert_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, 'Reason ids of cz rules');
14966: --------resolve reason ids
14967: resolve_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'reason id of cz rules');
14968:
14969: ---------------unsatisfied message of cz rules
14970: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
14971: ---------resolve unsatisfied message ids
14965: insert_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, 'Reason ids of cz rules');
14966: --------resolve reason ids
14967: resolve_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'reason id of cz rules');
14968:
14969: ---------------unsatisfied message of cz rules
14970: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
14971: ---------resolve unsatisfied message ids
14972: resolve_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'unmsg id of cz rules');
14973:
14966: --------resolve reason ids
14967: resolve_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'reason id of cz rules');
14968:
14969: ---------------unsatisfied message of cz rules
14970: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
14971: ---------resolve unsatisfied message ids
14972: resolve_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'unmsg id of cz rules');
14973:
14974: ------------populate effectivity set ids for cz rules
14968:
14969: ---------------unsatisfied message of cz rules
14970: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
14971: ---------resolve unsatisfied message ids
14972: resolve_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'unmsg id of cz rules');
14973:
14974: ------------populate effectivity set ids for cz rules
14975: insert_eff_sets(cz_pb_mgr.v_cz_rules_eff_id_ref
14976: ,cz_pb_mgr.v_cz_eff_sets_old_tbl
14970: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
14971: ---------resolve unsatisfied message ids
14972: resolve_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'unmsg id of cz rules');
14973:
14974: ------------populate effectivity set ids for cz rules
14975: insert_eff_sets(cz_pb_mgr.v_cz_rules_eff_id_ref
14976: ,cz_pb_mgr.v_cz_eff_sets_old_tbl
14977: ,cz_pb_mgr.v_cz_eff_sets_new_tbl
14978: ,cz_pb_mgr.v_cz_eff_sets_idx_tbl
14971: ---------resolve unsatisfied message ids
14972: resolve_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'unmsg id of cz rules');
14973:
14974: ------------populate effectivity set ids for cz rules
14975: insert_eff_sets(cz_pb_mgr.v_cz_rules_eff_id_ref
14976: ,cz_pb_mgr.v_cz_eff_sets_old_tbl
14977: ,cz_pb_mgr.v_cz_eff_sets_new_tbl
14978: ,cz_pb_mgr.v_cz_eff_sets_idx_tbl
14979: ,'cz_pb_mgr.v_cz_eff_sets_old_tbl'
14977: ,cz_pb_mgr.v_cz_eff_sets_new_tbl
14978: ,cz_pb_mgr.v_cz_eff_sets_idx_tbl
14979: ,'cz_pb_mgr.v_cz_eff_sets_old_tbl'
14980: ,'cz_pb_mgr.v_cz_eff_sets_new_tbl'
14981: ,'Eff sets of cz rules'
14982: );
14983:
14984: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
14985: -------------Resolve sig id of cz_rules
14980: ,'cz_pb_mgr.v_cz_eff_sets_new_tbl'
14981: ,'Eff sets of cz rules'
14982: );
14983:
14984: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
14985: -------------Resolve sig id of cz_rules
14986: resolve_ids(cz_pb_mgr.v_cz_rules_sig_ref, cz_pb_mgr.v_sig_idx_ref, 'sig id of cz rules', ENTITY_TYPE_SIGNATURE);
14987: ----------resolve_eff_sets;
14988: resolve_ids(cz_pb_mgr.v_cz_rules_eff_id_ref, cz_pb_mgr.v_cz_eff_sets_idx_tbl, 'eff sets of cz rules');
14981: ,'Eff sets of cz rules'
14982: );
14983:
14984: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
14985: -------------Resolve sig id of cz_rules
14986: resolve_ids(cz_pb_mgr.v_cz_rules_sig_ref, cz_pb_mgr.v_sig_idx_ref, 'sig id of cz rules', ENTITY_TYPE_SIGNATURE);
14987: ----------resolve_eff_sets;
14988: resolve_ids(cz_pb_mgr.v_cz_rules_eff_id_ref, cz_pb_mgr.v_cz_eff_sets_idx_tbl, 'eff sets of cz rules');
14989:
14982: );
14983:
14984: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
14985: -------------Resolve sig id of cz_rules
14986: resolve_ids(cz_pb_mgr.v_cz_rules_sig_ref, cz_pb_mgr.v_sig_idx_ref, 'sig id of cz rules', ENTITY_TYPE_SIGNATURE);
14987: ----------resolve_eff_sets;
14988: resolve_ids(cz_pb_mgr.v_cz_rules_eff_id_ref, cz_pb_mgr.v_cz_eff_sets_idx_tbl, 'eff sets of cz rules');
14989:
14990: -------------Resolve rule_folder_id of cz_rules
14984: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
14985: -------------Resolve sig id of cz_rules
14986: resolve_ids(cz_pb_mgr.v_cz_rules_sig_ref, cz_pb_mgr.v_sig_idx_ref, 'sig id of cz rules', ENTITY_TYPE_SIGNATURE);
14987: ----------resolve_eff_sets;
14988: resolve_ids(cz_pb_mgr.v_cz_rules_eff_id_ref, cz_pb_mgr.v_cz_eff_sets_idx_tbl, 'eff sets of cz rules');
14989:
14990: -------------Resolve rule_folder_id of cz_rules
14991: -- if copy rule db setting is not yes, publishing still copies CXs and FCs but only copies
14992: -- the root rule folder of a model, so we will put such rules under root folder in tgt model
14986: resolve_ids(cz_pb_mgr.v_cz_rules_sig_ref, cz_pb_mgr.v_sig_idx_ref, 'sig id of cz rules', ENTITY_TYPE_SIGNATURE);
14987: ----------resolve_eff_sets;
14988: resolve_ids(cz_pb_mgr.v_cz_rules_eff_id_ref, cz_pb_mgr.v_cz_eff_sets_idx_tbl, 'eff sets of cz rules');
14989:
14990: -------------Resolve rule_folder_id of cz_rules
14991: -- if copy rule db setting is not yes, publishing still copies CXs and FCs but only copies
14992: -- the root rule folder of a model, so we will put such rules under root folder in tgt model
14993: -- note we do not want to leave rule folders unresolved because it may cause problem in developer
14994: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
14991: -- if copy rule db setting is not yes, publishing still copies CXs and FCs but only copies
14992: -- the root rule folder of a model, so we will put such rules under root folder in tgt model
14993: -- note we do not want to leave rule folders unresolved because it may cause problem in developer
14994: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
14995: FOR i IN cz_pb_mgr.v_cz_rules_rf_id_ref.FIRST .. cz_pb_mgr.v_cz_rules_rf_id_ref.LAST LOOP
14996: IF cz_pb_mgr.v_cz_rules_rf_id_ref(i)<>0 THEN
14997: cz_pb_mgr.v_cz_rules_rf_id_ref(i):=p_model_root_folder_map(cz_pb_mgr.v_cz_rules_proj_id_ref(i));
14998: END IF;
14999: END LOOP;
14992: -- the root rule folder of a model, so we will put such rules under root folder in tgt model
14993: -- note we do not want to leave rule folders unresolved because it may cause problem in developer
14994: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
14995: FOR i IN cz_pb_mgr.v_cz_rules_rf_id_ref.FIRST .. cz_pb_mgr.v_cz_rules_rf_id_ref.LAST LOOP
14996: IF cz_pb_mgr.v_cz_rules_rf_id_ref(i)<>0 THEN
14997: cz_pb_mgr.v_cz_rules_rf_id_ref(i):=p_model_root_folder_map(cz_pb_mgr.v_cz_rules_proj_id_ref(i));
14998: END IF;
14999: END LOOP;
15000: END IF;
14993: -- note we do not want to leave rule folders unresolved because it may cause problem in developer
14994: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
14995: FOR i IN cz_pb_mgr.v_cz_rules_rf_id_ref.FIRST .. cz_pb_mgr.v_cz_rules_rf_id_ref.LAST LOOP
14996: IF cz_pb_mgr.v_cz_rules_rf_id_ref(i)<>0 THEN
14997: cz_pb_mgr.v_cz_rules_rf_id_ref(i):=p_model_root_folder_map(cz_pb_mgr.v_cz_rules_proj_id_ref(i));
14998: END IF;
14999: END LOOP;
15000: END IF;
15001: resolve_ids(cz_pb_mgr.v_cz_rules_rf_id_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder ids of cz rules');
14997: cz_pb_mgr.v_cz_rules_rf_id_ref(i):=p_model_root_folder_map(cz_pb_mgr.v_cz_rules_proj_id_ref(i));
14998: END IF;
14999: END LOOP;
15000: END IF;
15001: resolve_ids(cz_pb_mgr.v_cz_rules_rf_id_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder ids of cz rules');
15002:
15003: -------------Resolve devl_project_id of cz_rules
15004: resolve_ids(cz_pb_mgr.v_cz_rules_proj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl_project_id of cz rules');
15005: -------------Resolve component_id of cz_rules
14999: END LOOP;
15000: END IF;
15001: resolve_ids(cz_pb_mgr.v_cz_rules_rf_id_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder ids of cz rules');
15002:
15003: -------------Resolve devl_project_id of cz_rules
15004: resolve_ids(cz_pb_mgr.v_cz_rules_proj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl_project_id of cz rules');
15005: -------------Resolve component_id of cz_rules
15006: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
15007:
15000: END IF;
15001: resolve_ids(cz_pb_mgr.v_cz_rules_rf_id_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder ids of cz rules');
15002:
15003: -------------Resolve devl_project_id of cz_rules
15004: resolve_ids(cz_pb_mgr.v_cz_rules_proj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl_project_id of cz rules');
15005: -------------Resolve component_id of cz_rules
15006: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
15007:
15008: -------------Resolve expl id of cz_rules
15001: resolve_ids(cz_pb_mgr.v_cz_rules_rf_id_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder ids of cz rules');
15002:
15003: -------------Resolve devl_project_id of cz_rules
15004: resolve_ids(cz_pb_mgr.v_cz_rules_proj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl_project_id of cz rules');
15005: -------------Resolve component_id of cz_rules
15006: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
15007:
15008: -------------Resolve expl id of cz_rules
15009: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
15002:
15003: -------------Resolve devl_project_id of cz_rules
15004: resolve_ids(cz_pb_mgr.v_cz_rules_proj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl_project_id of cz rules');
15005: -------------Resolve component_id of cz_rules
15006: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
15007:
15008: -------------Resolve expl id of cz_rules
15009: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
15010: resolve_ids(cz_pb_mgr.v_cz_rules_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz rules');
15004: resolve_ids(cz_pb_mgr.v_cz_rules_proj_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl_project_id of cz rules');
15005: -------------Resolve component_id of cz_rules
15006: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
15007:
15008: -------------Resolve expl id of cz_rules
15009: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
15010: resolve_ids(cz_pb_mgr.v_cz_rules_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz rules');
15011: -------------populate plsql_table_list for cz rules
15012: plsql_table_list.DELETE;
15005: -------------Resolve component_id of cz_rules
15006: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
15007:
15008: -------------Resolve expl id of cz_rules
15009: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
15010: resolve_ids(cz_pb_mgr.v_cz_rules_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz rules');
15011: -------------populate plsql_table_list for cz rules
15012: plsql_table_list.DELETE;
15013: rec_count := 1;
15006: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
15007:
15008: -------------Resolve expl id of cz_rules
15009: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
15010: resolve_ids(cz_pb_mgr.v_cz_rules_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz rules');
15011: -------------populate plsql_table_list for cz rules
15012: plsql_table_list.DELETE;
15013: rec_count := 1;
15014: plsql_table_list(rec_count).col_name := 'rule_id';
15007:
15008: -------------Resolve expl id of cz_rules
15009: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
15010: resolve_ids(cz_pb_mgr.v_cz_rules_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz rules');
15011: -------------populate plsql_table_list for cz rules
15012: plsql_table_list.DELETE;
15013: rec_count := 1;
15014: plsql_table_list(rec_count).col_name := 'rule_id';
15015: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
15011: -------------populate plsql_table_list for cz rules
15012: plsql_table_list.DELETE;
15013: rec_count := 1;
15014: plsql_table_list(rec_count).col_name := 'rule_id';
15015: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
15016: rec_count := rec_count + 1;
15017: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15018: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
15019: rec_count := rec_count + 1;
15014: plsql_table_list(rec_count).col_name := 'rule_id';
15015: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
15016: rec_count := rec_count + 1;
15017: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15018: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
15019: rec_count := rec_count + 1;
15020: plsql_table_list(rec_count).col_name := 'devl_project_id';
15021: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
15022: rec_count := rec_count + 1;
15017: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15018: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
15019: rec_count := rec_count + 1;
15020: plsql_table_list(rec_count).col_name := 'devl_project_id';
15021: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
15022: rec_count := rec_count + 1;
15023: plsql_table_list(rec_count).col_name := 'component_id';
15024: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_comp_id_ref';
15025: rec_count := rec_count + 1;
15020: plsql_table_list(rec_count).col_name := 'devl_project_id';
15021: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
15022: rec_count := rec_count + 1;
15023: plsql_table_list(rec_count).col_name := 'component_id';
15024: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_comp_id_ref';
15025: rec_count := rec_count + 1;
15026: plsql_table_list(rec_count).col_name := 'reason_id';
15027: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rea_id_ref';
15028: rec_count := rec_count + 1;
15023: plsql_table_list(rec_count).col_name := 'component_id';
15024: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_comp_id_ref';
15025: rec_count := rec_count + 1;
15026: plsql_table_list(rec_count).col_name := 'reason_id';
15027: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rea_id_ref';
15028: rec_count := rec_count + 1;
15029: plsql_table_list(rec_count).col_name := 'unsatisfied_msg_id';
15030: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_unmsg_id_ref';
15031: rec_count := rec_count + 1;
15026: plsql_table_list(rec_count).col_name := 'reason_id';
15027: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rea_id_ref';
15028: rec_count := rec_count + 1;
15029: plsql_table_list(rec_count).col_name := 'unsatisfied_msg_id';
15030: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_unmsg_id_ref';
15031: rec_count := rec_count + 1;
15032: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
15033: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
15034: rec_count := rec_count + 1;
15029: plsql_table_list(rec_count).col_name := 'unsatisfied_msg_id';
15030: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_unmsg_id_ref';
15031: rec_count := rec_count + 1;
15032: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
15033: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
15034: rec_count := rec_count + 1;
15035: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
15036: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_expl_ref';
15037: rec_count := rec_count + 1;
15032: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
15033: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
15034: rec_count := rec_count + 1;
15035: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
15036: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_expl_ref';
15037: rec_count := rec_count + 1;
15038: plsql_table_list(rec_count).col_name := 'signature_id';
15039: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_sig_ref';
15040: rec_count := rec_count + 1;
15035: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
15036: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_expl_ref';
15037: rec_count := rec_count + 1;
15038: plsql_table_list(rec_count).col_name := 'signature_id';
15039: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_sig_ref';
15040: rec_count := rec_count + 1;
15041: plsql_table_list(rec_count).col_name := 'ui_def_id';
15042: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_ui_ref';
15043: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
15038: plsql_table_list(rec_count).col_name := 'signature_id';
15039: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_sig_ref';
15040: rec_count := rec_count + 1;
15041: plsql_table_list(rec_count).col_name := 'ui_def_id';
15042: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_ui_ref';
15043: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
15044: rec_count := rec_count + 1;
15045: plsql_table_list(rec_count).col_name := 'effective_usage_mask';
15046: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_rul_usg_msk_tbl';
15045: plsql_table_list(rec_count).col_name := 'effective_usage_mask';
15046: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_rul_usg_msk_tbl';
15047: rec_count := rec_count + 1;
15048: plsql_table_list(rec_count).col_name := 'persistent_rule_id';
15049: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_persistent_id_ref';
15050: END IF;
15051:
15052: ------populate cz_rules
15053: insert_into_table('cz_rules'
15048: plsql_table_list(rec_count).col_name := 'persistent_rule_id';
15049: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_persistent_id_ref';
15050: END IF;
15051:
15052: ------populate cz_rules
15053: insert_into_table('cz_rules'
15054: ,'rule_id'
15055: ,cz_pb_mgr.v_db_link
15056: ,plsql_table_list
15049: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_persistent_id_ref';
15050: END IF;
15051:
15052: ------populate cz_rules
15053: insert_into_table('cz_rules'
15054: ,'rule_id'
15055: ,cz_pb_mgr.v_db_link
15056: ,plsql_table_list
15057: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
15053: insert_into_table('cz_rules'
15054: ,'rule_id'
15055: ,cz_pb_mgr.v_db_link
15056: ,plsql_table_list
15057: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
15058: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
15059: );
15060:
15061: -----insert new records into cz_rule_folders
15054: ,'rule_id'
15055: ,cz_pb_mgr.v_db_link
15056: ,plsql_table_list
15057: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
15058: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
15059: );
15060:
15061: -----insert new records into cz_rule_folders
15062: plsql_table_list.DELETE;
15061: -----insert new records into cz_rule_folders
15062: plsql_table_list.DELETE;
15063: rec_count := 1;
15064: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15065: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
15066: rec_count := rec_count + 1;
15067: plsql_table_list(rec_count).col_name := 'object_type';
15068: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_obj_ref';
15069: rec_count := rec_count + 1;
15064: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15065: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
15066: rec_count := rec_count + 1;
15067: plsql_table_list(rec_count).col_name := 'object_type';
15068: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_obj_ref';
15069: rec_count := rec_count + 1;
15070: plsql_table_list(rec_count).col_name := 'devl_project_id';
15071: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
15072: rec_count := rec_count + 1;
15067: plsql_table_list(rec_count).col_name := 'object_type';
15068: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_obj_ref';
15069: rec_count := rec_count + 1;
15070: plsql_table_list(rec_count).col_name := 'devl_project_id';
15071: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
15072: rec_count := rec_count + 1;
15073: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
15074: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
15075: rec_count := rec_count + 1;
15070: plsql_table_list(rec_count).col_name := 'devl_project_id';
15071: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
15072: rec_count := rec_count + 1;
15073: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
15074: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
15075: rec_count := rec_count + 1;
15076: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
15077: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
15078: ----------insert into cz_func_comp_specs
15073: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
15074: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
15075: rec_count := rec_count + 1;
15076: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
15077: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
15078: ----------insert into cz_func_comp_specs
15079: insert_into_table('cz_rule_folders'
15080: ,'rule_folder_id'
15081: ,'object_type'
15080: ,'rule_folder_id'
15081: ,'object_type'
15082: ,cz_pb_mgr.v_db_link
15083: ,plsql_table_list
15084: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
15085: ,'cz_pb_mgr.v_cz_rules_obj_ref'
15086: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
15087: ,cz_pb_mgr.v_cz_rules_obj_ref
15088: );
15081: ,'object_type'
15082: ,cz_pb_mgr.v_db_link
15083: ,plsql_table_list
15084: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
15085: ,'cz_pb_mgr.v_cz_rules_obj_ref'
15086: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
15087: ,cz_pb_mgr.v_cz_rules_obj_ref
15088: );
15089: END insert_rules;
15082: ,cz_pb_mgr.v_db_link
15083: ,plsql_table_list
15084: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
15085: ,'cz_pb_mgr.v_cz_rules_obj_ref'
15086: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
15087: ,cz_pb_mgr.v_cz_rules_obj_ref
15088: );
15089: END insert_rules;
15090:
15083: ,plsql_table_list
15084: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
15085: ,'cz_pb_mgr.v_cz_rules_obj_ref'
15086: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
15087: ,cz_pb_mgr.v_cz_rules_obj_ref
15088: );
15089: END insert_rules;
15090:
15091: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
15350:
15351: ------resolve devl id and rule id
15352: resolve_ids(cz_pb_mgr.v_filter_sets_devl_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'dev proj id of cz filter sets');
15353: ------resolve devl id
15354: resolve_ids(cz_pb_mgr.v_filter_sets_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of cz filter sets');
15355: -----resolve ps node id
15356: resolve_ids(cz_pb_mgr.v_populators_node_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'owned by node id of cz populators');
15357: -----resolve filter set id
15358: resolve_ids(cz_pb_mgr.v_populators_set_id_ref, cz_pb_mgr.v_filter_sets_idx_ref, 'filter set id of cz populators');
15458: EXCEPTION
15459: WHEN NO_DATA_FOUND THEN
15460: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15461: FOR j IN (SELECT rule.name rulename, prj.name prjname
15462: FROM cz_rules rule, cz_devl_projects prj
15463: WHERE rule.rule_id=p_ruleid_tbl(i) AND rule.devl_project_id=prj.devl_project_id) LOOP
15464: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MIGR_RULE_ERR', 'FK_COL', p_colname, 'RULE_NAME', j.rulename, 'MODEL_NAME', j.prjname);
15465: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'upload_rule_schema.mm_resolve_rule_fks', SQLCODE);
15466: END LOOP;
15752: -----export archives
15753: export_archives;
15754: export_populators;
15755:
15756: IF cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0 THEN
15757: insert_rules(p_copy_rules_flag, v_model_root_folder_map);
15758: END IF;
15759:
15760: IF cz_pb_mgr.v_session_parameter = pub_model THEN
15765: copy_lce_texts(p_copy_rules_flag);
15766: END IF;
15767: END IF;
15768:
15769: ---------------local pl/sql tables of cz rules released after populating rule sub schema
15770: -------------insert expressions
15771: IF (cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0)
15772: THEN
15773: FOR m IN cz_pb_mgr.v_cz_rules_rule_id_old_ref.FIRST .. cz_pb_mgr.v_cz_rules_rule_id_old_ref.LAST
15767: END IF;
15768:
15769: ---------------local pl/sql tables of cz rules released after populating rule sub schema
15770: -------------insert expressions
15771: IF (cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0)
15772: THEN
15773: FOR m IN cz_pb_mgr.v_cz_rules_rule_id_old_ref.FIRST .. cz_pb_mgr.v_cz_rules_rule_id_old_ref.LAST
15774: LOOP
15775: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
15769: ---------------local pl/sql tables of cz rules released after populating rule sub schema
15770: -------------insert expressions
15771: IF (cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0)
15772: THEN
15773: FOR m IN cz_pb_mgr.v_cz_rules_rule_id_old_ref.FIRST .. cz_pb_mgr.v_cz_rules_rule_id_old_ref.LAST
15774: LOOP
15775: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
15776:
15777: BEGIN
15789: ,cz_pb_mgr.v_cz_enodes_mrefl_id_tbl, cz_pb_mgr.v_cz_enodes_rule_id_tbl, cz_pb_mgr.v_cz_enodes_arg_sig_id_tbl
15790: ,cz_pb_mgr.v_cz_enodes_par_sig_id_tbl
15791: ,cz_pb_mgr.v_cz_enodes_prop_id_tbl
15792: FROM cz_expression_nodes t
15793: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0';
15794: ELSE
15795: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
15796: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
15797: ,cz_pb_mgr.v_oraclesequenceincr
15803: ,cz_pb_mgr.v_cz_enodes_enode_id_old_tbl, cz_pb_mgr.v_cz_enodes_psnode_id_tbl, cz_pb_mgr.v_cz_enodes_pexpr_id_tbl
15804: ,cz_pb_mgr.v_cz_enodes_mrefl_id_tbl, cz_pb_mgr.v_cz_enodes_rule_id_tbl, cz_pb_mgr.v_cz_enodes_arg_sig_id_tbl
15805: ,cz_pb_mgr.v_cz_enodes_par_sig_id_tbl
15806: FROM cz_expression_nodes t
15807: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0' AND t.expr_type <> 208;
15808: END IF;
15809: EXCEPTION
15810: WHEN NO_DATA_FOUND
15811: THEN
15862: END IF;
15863: END LOOP;
15864: END IF;
15865: END LOOP; /* end loop of */
15866: END IF; -- end cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0 /* (COUNT > 0) */
15867:
15868: --------export_signatures
15869: export_signatures(cz_pb_mgr.v_cz_expr_sig_ref);
15870: -----------resolve parent expr node id
15881: resolve_ids(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of expression nodes',FLD_IGNORE_NOW);
15882: resolve_ids(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'ps node ids of expression nodes',FLD_IGNORE_NOW);
15883: END IF;
15884:
15885: resolve_ids(cz_pb_mgr.v_cz_enodes_rule_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of expression nodes');
15886:
15887: --------populate plsql_table_list for cz_expression_nodes
15888: plsql_table_list.DELETE;
15889: rec_count := 1;
15945: BULK COLLECT INTO v_cz_des_feature_id_old_tbl, v_cz_des_feature_rule_id_tbl, v_cz_des_feature_mrefl_id_tbl, v_cz_des_feature_ft_typ_tbl
15946: FROM cz_des_chart_features t
15947: WHERE t.rule_id IN(
15948: SELECT rule_id
15949: FROM cz_rules
15950: WHERE cz_rules.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15951: AND cz_rules.deleted_flag = '0')
15952: AND t.deleted_flag = '0';
15953: EXCEPTION
15946: FROM cz_des_chart_features t
15947: WHERE t.rule_id IN(
15948: SELECT rule_id
15949: FROM cz_rules
15950: WHERE cz_rules.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15951: AND cz_rules.deleted_flag = '0')
15952: AND t.deleted_flag = '0';
15953: EXCEPTION
15954: WHEN NO_DATA_FOUND
15947: WHERE t.rule_id IN(
15948: SELECT rule_id
15949: FROM cz_rules
15950: WHERE cz_rules.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
15951: AND cz_rules.deleted_flag = '0')
15952: AND t.deleted_flag = '0';
15953: EXCEPTION
15954: WHEN NO_DATA_FOUND
15955: THEN
15987: resolve_ids(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'feature id of cz_des_features',FLD_IGNORE_NOW);
15988: resolve_ids(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of cz_des_features',FLD_IGNORE_NOW);
15989: END IF;
15990:
15991: resolve_ids(cz_pb_mgr.v_cz_des_feature_rid_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart features');
15992:
15993: ------insert new records into cz_des_chart_features
15994: insert_des_chart_features(cz_pb_mgr.v_status_code);
15995: -------------release local pl/sql tables of des chart features
16015: SELECT rul.rule_id, secondary_feature_id, primary_opt_id, secondary_opt_id
16016: , secondary_feat_expl_id, mark_char, rule_type
16017: BULK COLLECT INTO v_cz_des_cells_rule_id_tbl, v_cz_des_cells_sf_id_tbl, v_cz_des_cells_popt_id_tbl, v_cz_des_cells_sopt_id_tbl
16018: ,v_cz_des_cells_sexpl_id_tbl, v_cz_des_cells_mark_char_tbl, v_rule_type_tbl
16019: FROM cz_rules rul, cz_des_chart_cells dcc
16020: WHERE rul.deleted_flag = '0' AND rul.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16021: AND rul.rule_id = dcc.rule_id AND dcc.deleted_flag = '0';
16022: EXCEPTION
16023: WHEN NO_DATA_FOUND
16050: END IF;
16051: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
16052: END IF; /* end if of cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
16053:
16054: resolve_ids(cz_pb_mgr.v_cz_des_cells_rule_id_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart cells');
16055: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);
16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
19033: ---at which point, tables cannot be cleared because rules of the model have
19034: ---already been collected in these tables from bulk_collect_rules.
19035: ---so, if model migration, the rules related tables will NOT be cleared
19036: ---get_oa_tmpls.
19037: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
19038: END IF;
19039:
19040: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
19041: log_timing_message('end has_tobe_published');
19235: --Calculate the max_persistent_rec_id for the model and insert into CZ_PERSISTENT_REC_IDS.
19236: EXECUTE IMMEDIATE 'SELECT GREATEST(NVL((SELECT MAX(persistent_node_id) FROM cz_ps_nodes'
19237: || cz_pb_mgr.v_db_link
19238: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :1), 0),'
19239: || ' NVL((SELECT MAX(persistent_rule_id) FROM cz_rules'
19240: || cz_pb_mgr.v_db_link
19241: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :2), 0),'
19242: || ' NVL((SELECT MAX(persistent_intl_text_id) FROM cz_localized_texts'
19243: || cz_pb_mgr.v_db_link
23465: remote_effs_cv ref_cursor;
23466: remote_rule_seq_name_cv ref_cursor;
23467: l_effecivity_set_id NUMBER;
23468: l_rule_folder_name cz_rule_folders.NAME%TYPE;
23469: l_rule_name cz_rules.NAME%TYPE;
23470: BEGIN
23471: --all the rule sequences have been accumulated here
23472: IF (mm_v_tbl_rule_seq.COUNT > 0) THEN
23473: FOR rule_seq IN mm_v_tbl_rule_seq.FIRST .. mm_v_tbl_rule_seq.LAST
23477: --get all the effectivity_set_ids for the rules in that rule sequence
23478: l_sql_string :=
23479: 'SELECT effectivity_set_id, name'
23480: || ' '
23481: || 'FROM cz_rules'
23482: || cz_pb_mgr.v_db_link
23483: || ' '
23484: || 'WHERE rule_folder_id = :1'
23485: || ' '
23528:
23529: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MM_EFFSET_CORRUPT_RULSEQ', 'RULE_NAME', l_rule_name, 'RULE_SEQUENCE', l_rule_folder_name);
23530: log_pb_errors(cz_pb_mgr.v_err_message, 0, 'mm_resolve_rule_seq_effsetid', -1);
23531: l_sql_string :=
23532: 'UPDATE cz_rules'
23533: || cz_pb_mgr.v_db_link
23534: || ' '
23535: || 'SET effective_from = :1'
23536: || ', '