[Home] [Help]
34: ENTITY_TYPE_PROPERTY CONSTANT VARCHAR2(3) := 'PRP';
35:
36: -- special fields in id resolution
37: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id
38: -- cz_des_chart_feature.feature_id, cz_rules.rule_folder_id,
39: -- cz_ps_nodes.reference_id, cz_ui_nodes.ui_node_ref_id
40: FLD_PSN_REFERENCE_ID CONSTANT VARCHAR2(9) := 'PSNREFID';
41: FLD_RULE_COMPONENT_ID CONSTANT VARCHAR2(9) := 'RULCOMID';
42: FLD_UI_NODE_REF_ID CONSTANT VARCHAR2(9) := 'UINREFID';
475: cz_pb_mgr.v_cz_enodes_par_sig_id_ref.DELETE;
476: cz_pb_mgr.v_cz_expr_sig_ref.DELETE;
477: cz_pb_mgr.v_cz_enodes_prop_id_ref.delete;
478: END IF;
479: ELSIF(p_table_name = 'cz_rules') THEN
480: IF (p_table_type = 'ref') THEN
481: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
482: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
483: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
477: cz_pb_mgr.v_cz_enodes_prop_id_ref.delete;
478: END IF;
479: ELSIF(p_table_name = 'cz_rules') THEN
480: IF (p_table_type = 'ref') THEN
481: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
482: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
483: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
484: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
478: END IF;
479: ELSIF(p_table_name = 'cz_rules') THEN
480: IF (p_table_type = 'ref') THEN
481: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
482: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
483: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
484: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
479: ELSIF(p_table_name = 'cz_rules') THEN
480: IF (p_table_type = 'ref') THEN
481: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
482: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
483: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
484: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
480: IF (p_table_type = 'ref') THEN
481: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
482: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
483: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
484: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
481: cz_pb_mgr.v_cz_rules_rule_id_old_ref.DELETE;
482: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
483: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
484: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
482: cz_pb_mgr.v_cz_rules_rule_id_new_ref.DELETE;
483: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
484: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
483: cz_pb_mgr.v_cz_rules_persistent_id_ref.DELETE;
484: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
491: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
484: cz_pb_mgr.v_cz_rules_rule_id_idx_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
491: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
492: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
485: cz_pb_mgr.v_cz_rules_rf_id_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
491: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
492: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
493: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
486: cz_pb_mgr.v_cz_rules_proj_id_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
491: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
492: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
493: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
494: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
487: cz_pb_mgr.v_cz_rules_comp_id_ref.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
491: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
492: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
493: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
494: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
495: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
488: cz_pb_mgr.v_cz_rules_ant_id_ref.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
491: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
492: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
493: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
494: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
495: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
496: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
489: cz_pb_mgr.v_cz_rules_con_id_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
491: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
492: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
493: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
494: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
495: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
496: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
497: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
490: cz_pb_mgr.v_cz_rules_rea_id_ref.DELETE;
491: cz_pb_mgr.v_cz_rules_eff_id_ref.DELETE;
492: cz_pb_mgr.v_cz_rules_unmsg_id_ref.DELETE;
493: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
494: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
495: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
496: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
497: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
498: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
493: cz_pb_mgr.v_cz_rules_expl_ref.DELETE;
494: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
495: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
496: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
497: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
498: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
499: cz_pb_mgr.v_cz_rules_ui_ref.DELETE;
500: END IF;
501: ELSIF(p_table_name = 'cz_des_chart_features')
494: cz_pb_mgr.v_cz_rules_sig_ref.DELETE;
495: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
496: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
497: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
498: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
499: cz_pb_mgr.v_cz_rules_ui_ref.DELETE;
500: END IF;
501: ELSIF(p_table_name = 'cz_des_chart_features')
502: THEN
495: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
496: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
497: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
498: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
499: cz_pb_mgr.v_cz_rules_ui_ref.DELETE;
500: END IF;
501: ELSIF(p_table_name = 'cz_des_chart_features')
502: THEN
503: IF (p_table_type = 'ref')
3364: ,'switcherCondnId'
3365: )
3366: )
3367: THEN
3368: IF (cz_pb_mgr.v_cz_rules_rule_id_idx_ref.EXISTS(l_old_id))
3369: THEN
3370: l_new_persistentid := cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_id);
3371: END IF;
3372: ELSIF(l_attr3_name IN
3366: )
3367: THEN
3368: IF (cz_pb_mgr.v_cz_rules_rule_id_idx_ref.EXISTS(l_old_id))
3369: THEN
3370: l_new_persistentid := cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_id);
3371: END IF;
3372: ELSIF(l_attr3_name IN
3373: ('urlIntlTextId', 'captionIntlTextId', 'rolloverIntlTextId', 'tableSummaryIntlTextId', 'cellIntlTextId', 'imageSourceIntlTextId')
3374: )
4598:
4599: ----caption ids of ui pages
4600: 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');
4601:
4602: 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');
4603: 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');
4604: 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');
4605: plsql_table_list.DELETE;
4606: rec_count := 1;
4599: ----caption ids of ui pages
4600: 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');
4601:
4602: 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');
4603: 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');
4604: 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');
4605: plsql_table_list.DELETE;
4606: rec_count := 1;
4607: plsql_table_list(rec_count).col_name := 'ui_def_id';
4841: ----resolve ui_def_id
4842: 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 refs');
4843:
4844: ---bug14004074. Should not resolve caption_rule_id of page refs as this will have always a seeded value.
4845: --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 refs');
4846:
4847: ---create rules for g_page_refs_cond_id_ref
4848: 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 refs');
4849: ----caption ids of ui pages
4844: ---bug14004074. Should not resolve caption_rule_id of page refs as this will have always a seeded value.
4845: --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 refs');
4846:
4847: ---create rules for g_page_refs_cond_id_ref
4848: 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 refs');
4849: ----caption ids of ui pages
4850: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4851: 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');
4852: ----resolve expl id
5385: WHEN OTHERS
5386: THEN
5387: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5388: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
5389: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
5390: RAISE;
5391: END create_uit_publication;
5392:
5393: --------------------------------
6446: -- ignore expl id resolution failure because of a ui refresh issue (see 6817586)
6447: 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);
6448: -- context_component_id, obsolete
6449: -- 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');
6450: 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');
6451:
6452: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
6453: 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');
6454: 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);
7197: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
7198: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref
7199: );
7200: 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);
7201: 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);
7202: delete_from_table('cz_des_chart_features'
7203: ,'rule_id'
7204: ,v_database_link
7205: ,'cz_pb_mgr.v_cz_des_feature_rid_new_ref'
7650: FROM cz_expression_nodes t
7651: WHERE t.deleted_flag = record_not_deleted
7652: AND t.expr_type <> 208
7653: AND EXISTS(SELECT 1
7654: FROM cz_rules
7655: WHERE rule_id = t.rule_id AND devl_project_id = p_model_id AND deleted_flag = record_not_deleted)
7656: AND t.deleted_flag = record_not_deleted
7657: AND t.expr_type <> 208;
7658: EXCEPTION
8804: )
8805: AS
8806: l_new_rule_id NUMBER;
8807: l_old_rule_id NUMBER;
8808: v_cz_rules_rf_id NUMBER;
8809: v_cz_rules_proj_id NUMBER;
8810: v_cz_rules_comp_id NUMBER;
8811: v_cz_rules_rea_id NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8805: AS
8806: l_new_rule_id NUMBER;
8807: l_old_rule_id NUMBER;
8808: v_cz_rules_rf_id NUMBER;
8809: v_cz_rules_proj_id NUMBER;
8810: v_cz_rules_comp_id NUMBER;
8811: v_cz_rules_rea_id NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8813: v_cz_rules_unmsg_id NUMBER;
8806: l_new_rule_id NUMBER;
8807: l_old_rule_id NUMBER;
8808: v_cz_rules_rf_id NUMBER;
8809: v_cz_rules_proj_id NUMBER;
8810: v_cz_rules_comp_id NUMBER;
8811: v_cz_rules_rea_id NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8813: v_cz_rules_unmsg_id NUMBER;
8814: v_cz_rules_expl_id NUMBER;
8807: l_old_rule_id NUMBER;
8808: v_cz_rules_rf_id NUMBER;
8809: v_cz_rules_proj_id NUMBER;
8810: v_cz_rules_comp_id NUMBER;
8811: v_cz_rules_rea_id NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8813: v_cz_rules_unmsg_id NUMBER;
8814: v_cz_rules_expl_id NUMBER;
8815: v_cz_rules_sig NUMBER;
8808: v_cz_rules_rf_id NUMBER;
8809: v_cz_rules_proj_id NUMBER;
8810: v_cz_rules_comp_id NUMBER;
8811: v_cz_rules_rea_id NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8813: v_cz_rules_unmsg_id NUMBER;
8814: v_cz_rules_expl_id NUMBER;
8815: v_cz_rules_sig NUMBER;
8816: v_cz_rules_ui NUMBER;
8809: v_cz_rules_proj_id NUMBER;
8810: v_cz_rules_comp_id NUMBER;
8811: v_cz_rules_rea_id NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8813: v_cz_rules_unmsg_id NUMBER;
8814: v_cz_rules_expl_id NUMBER;
8815: v_cz_rules_sig NUMBER;
8816: v_cz_rules_ui NUMBER;
8817: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8810: v_cz_rules_comp_id NUMBER;
8811: v_cz_rules_rea_id NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8813: v_cz_rules_unmsg_id NUMBER;
8814: v_cz_rules_expl_id NUMBER;
8815: v_cz_rules_sig NUMBER;
8816: v_cz_rules_ui NUMBER;
8817: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8818:
8811: v_cz_rules_rea_id NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8813: v_cz_rules_unmsg_id NUMBER;
8814: v_cz_rules_expl_id NUMBER;
8815: v_cz_rules_sig NUMBER;
8816: v_cz_rules_ui NUMBER;
8817: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8818:
8819: rec_count NUMBER;
8812: v_cz_rules_eff_id NUMBER;
8813: v_cz_rules_unmsg_id NUMBER;
8814: v_cz_rules_expl_id NUMBER;
8815: v_cz_rules_sig NUMBER;
8816: v_cz_rules_ui NUMBER;
8817: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8818:
8819: rec_count NUMBER;
8820: BEGIN
8813: v_cz_rules_unmsg_id NUMBER;
8814: v_cz_rules_expl_id NUMBER;
8815: v_cz_rules_sig NUMBER;
8816: v_cz_rules_ui NUMBER;
8817: v_cz_eff_usage_mask cz_rules.effective_usage_mask%TYPE;
8818:
8819: rec_count NUMBER;
8820: BEGIN
8821: IF (x_status = PUBLICATION_ERROR OR p_rule_id_array.COUNT = 0) THEN
8821: IF (x_status = PUBLICATION_ERROR OR p_rule_id_array.COUNT = 0) THEN
8822: RETURN;
8823: END IF;
8824:
8825: rec_count := cz_pb_mgr.v_cz_rules_rule_id_new_ref.COUNT;
8826:
8827: FOR i IN p_rule_id_array.FIRST .. p_rule_id_array.LAST
8828: LOOP
8829: IF (p_rule_type_array(i) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)) THEN
8827: FOR i IN p_rule_id_array.FIRST .. p_rule_id_array.LAST
8828: LOOP
8829: IF (p_rule_type_array(i) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)) THEN
8830: BEGIN
8831: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
8832: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link
8833: ,cz_pb_mgr.v_oraclesequenceincr
8834: )
8835: ,rule_id, rule_folder_id, devl_project_id, component_id
8828: LOOP
8829: IF (p_rule_type_array(i) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)) THEN
8830: BEGIN
8831: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
8832: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link
8833: ,cz_pb_mgr.v_oraclesequenceincr
8834: )
8835: ,rule_id, rule_folder_id, devl_project_id, component_id
8836: ,reason_id, unsatisfied_msg_id, effectivity_set_id
8835: ,rule_id, rule_folder_id, devl_project_id, component_id
8836: ,reason_id, unsatisfied_msg_id, effectivity_set_id
8837: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
8838: INTO l_new_rule_id
8839: ,l_old_rule_id, v_cz_rules_rf_id, v_cz_rules_proj_id, v_cz_rules_comp_id
8840: ,v_cz_rules_rea_id, v_cz_rules_unmsg_id, v_cz_rules_eff_id
8841: ,v_cz_rules_expl_id, v_cz_rules_sig, v_cz_rules_ui, v_cz_eff_usage_mask
8842: FROM cz_rules
8843: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8836: ,reason_id, unsatisfied_msg_id, effectivity_set_id
8837: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
8838: INTO l_new_rule_id
8839: ,l_old_rule_id, v_cz_rules_rf_id, v_cz_rules_proj_id, v_cz_rules_comp_id
8840: ,v_cz_rules_rea_id, v_cz_rules_unmsg_id, v_cz_rules_eff_id
8841: ,v_cz_rules_expl_id, v_cz_rules_sig, v_cz_rules_ui, v_cz_eff_usage_mask
8842: FROM cz_rules
8843: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8844:
8837: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
8838: INTO l_new_rule_id
8839: ,l_old_rule_id, v_cz_rules_rf_id, v_cz_rules_proj_id, v_cz_rules_comp_id
8840: ,v_cz_rules_rea_id, v_cz_rules_unmsg_id, v_cz_rules_eff_id
8841: ,v_cz_rules_expl_id, v_cz_rules_sig, v_cz_rules_ui, v_cz_eff_usage_mask
8842: FROM cz_rules
8843: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8844:
8845: rec_count := rec_count + 1;
8838: INTO l_new_rule_id
8839: ,l_old_rule_id, v_cz_rules_rf_id, v_cz_rules_proj_id, v_cz_rules_comp_id
8840: ,v_cz_rules_rea_id, v_cz_rules_unmsg_id, v_cz_rules_eff_id
8841: ,v_cz_rules_expl_id, v_cz_rules_sig, v_cz_rules_ui, v_cz_eff_usage_mask
8842: FROM cz_rules
8843: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8844:
8845: rec_count := rec_count + 1;
8846: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8842: FROM cz_rules
8843: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8844:
8845: rec_count := rec_count + 1;
8846: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8847: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8848: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8849: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8843: WHERE rule_id = p_rule_id_array(i) AND deleted_flag = '0' AND seeded_flag = '0';
8844:
8845: rec_count := rec_count + 1;
8846: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8847: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8848: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8849: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8844:
8845: rec_count := rec_count + 1;
8846: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8847: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8848: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8849: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8845: rec_count := rec_count + 1;
8846: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8847: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8848: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8849: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8846: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_old_rule_id):=l_new_rule_id;
8847: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8848: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8849: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8847: cz_pb_mgr.v_cz_rules_rule_id_new_ref(rec_count) := l_new_rule_id;
8848: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8849: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8855: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8848: cz_pb_mgr.v_cz_rules_rule_id_old_ref(rec_count) := l_old_rule_id;
8849: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8855: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8856: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8849: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := v_cz_rules_proj_id;
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8855: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8856: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8857: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8850: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := v_cz_rules_comp_id;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8855: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8856: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8857: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8858: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8851: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8855: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8856: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8857: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8858: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8859: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8852: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := v_cz_rules_expl_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8855: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8856: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8857: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8858: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8859: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8860: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_new_rule_id;
8853: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := v_cz_rules_rea_id;
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8855: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8856: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8857: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8858: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8859: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8860: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_new_rule_id;
8861:
8854: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := v_cz_rules_unmsg_id;
8855: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := v_cz_rules_eff_id;
8856: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8857: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8858: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8859: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8860: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_new_rule_id;
8861:
8862: EXCEPTION
8856: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := v_cz_rules_sig;
8857: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
8858: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := v_cz_rules_ui;
8859: cz_pb_mgr.v_new_rul_usg_msk_tbl(rec_count) := v_cz_eff_usage_mask;
8860: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_new_rule_id;
8861:
8862: EXCEPTION
8863: WHEN NO_DATA_FOUND THEN
8864: cz_pb_mgr.v_err_message := 'No rules found: ' || p_rule_id_array(i);
8865: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULES', SQLCODE);
8866: END;
8867:
8868: BEGIN
8869: p_rule_id_array(i) := cz_pb_mgr.v_cz_rules_rule_id_idx_ref(p_rule_id_array(i));
8870: EXCEPTION
8871: WHEN OTHERS THEN
8872: NULL;
8873: END;
8874: END IF;
8875: END LOOP;
8876: EXCEPTION
8877: WHEN OTHERS THEN
8878: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
8879: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
8880: x_status := PUBLICATION_ERROR;
8881: RAISE;
8882: END collect_global_rules;
8875: END LOOP;
8876: EXCEPTION
8877: WHEN OTHERS THEN
8878: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
8879: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
8880: x_status := PUBLICATION_ERROR;
8881: RAISE;
8882: END collect_global_rules;
8883:
9130: --For publishing, this code gets executed right in the beginning(when all the tables are empty
9131: --anyway), and seems redundant. But for the risk of introducing regressions, we
9132: --will execute this only for publishing.
9133: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
9134: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
9135: END IF;
9136:
9137: cz_pb_mgr.g_ui_templates_old_temp_id_ref.DELETE;
9138: cz_pb_mgr.g_ui_templates_new_temp_id_ref.DELETE;
9992: FROM cz_expression_nodes t
9993: WHERE t.deleted_flag = '0'
9994: AND t.expr_type <> 208
9995: AND EXISTS(SELECT 1
9996: FROM cz_rules
9997: WHERE rule_id = t.rule_id AND devl_project_id = v_model_id AND deleted_flag = '0')
9998: AND t.deleted_flag = '0'
9999: AND t.expr_type <> 208;
10000:
11069: FROM cz_intl_texts
11070: WHERE model_id = cz_pb_mgr.v_models_to_be_exported(i)
11071: AND deleted_flag = '0' AND (seeded_flag IS NULL OR seeded_flag = '0')
11072: AND intl_text_id IN (SELECT reason_id
11073: FROM cz_rules
11074: WHERE devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
11075: AND deleted_flag = '0' AND reason_id IS NOT NULL
11076: UNION ALL
11077: SELECT unsatisfied_msg_id
11074: WHERE devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
11075: AND deleted_flag = '0' AND reason_id IS NOT NULL
11076: UNION ALL
11077: SELECT unsatisfied_msg_id
11078: FROM cz_rules
11079: WHERE devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
11080: AND deleted_flag = '0' AND unsatisfied_msg_id IS NOT NULL);
11081: IF l_text_id_tbl.COUNT > 0 THEN
11082: FOR j IN l_text_id_tbl.FIRST .. l_text_id_tbl.LAST LOOP
11088: END get_rule_intl_text_ids;
11089:
11090: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11091: ---------procedure to copy data into cz_lce_texts
11092: ---------reason ids and unsatisfied message ids of cz rules
11093: ---------are copied and resolved in this procedure
11094: ---------
11095: PROCEDURE copy_lce_texts(p_copy_rules_flag IN VARCHAR2)
11096: IS
12972: ,p_rules_sng_array IN OUT NOCOPY cz_pb_mgr.t_ref_idx_vc2
12973: ,x_status IN OUT NOCOPY VARCHAR2
12974: )
12975: AS
12976: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12977: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12978: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12979: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12973: ,x_status IN OUT NOCOPY VARCHAR2
12974: )
12975: AS
12976: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12977: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12978: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12979: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12974: )
12975: AS
12976: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12977: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12978: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12979: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12975: AS
12976: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12977: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12978: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12979: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12976: l_cz_rules_new_id_tbl cz_pb_mgr.t_ref;
12977: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12978: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12979: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12984: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12977: l_cz_rules_old_id_tbl cz_pb_mgr.t_ref;
12978: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12979: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12984: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12985: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12978: l_cz_rules_rf_id_tbl cz_pb_mgr.t_ref;
12979: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12984: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12985: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12986: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12979: l_cz_rules_proj_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12984: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12985: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12986: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12987: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12980: l_cz_rules_comp_id_tbl cz_pb_mgr.t_ref;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12984: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12985: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12986: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12987: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12988: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12981: l_cz_rules_rea_id_tbl cz_pb_mgr.t_ref;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12984: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12985: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12986: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12987: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12988: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12989: l_object_type cz_rule_folders.object_type%TYPE;
12982: l_cz_rules_eff_id_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12984: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12985: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12986: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12987: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12988: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12989: l_object_type cz_rule_folders.object_type%TYPE;
12990: l_rule_type_tbl cz_pb_mgr.t_ref;
12983: l_cz_rules_unmsg_id_tbl cz_pb_mgr.t_ref;
12984: l_cz_rules_expl_id_tbl cz_pb_mgr.t_ref;
12985: l_cz_rules_sig_tbl cz_pb_mgr.t_ref;
12986: l_cz_rules_ui_tbl cz_pb_mgr.t_ref;
12987: l_cz_rules_perst_id_tbl cz_pb_mgr.t_ref;
12988: l_eff_usg_mask_tbl cz_pb_mgr.t_eff_usage_mask;
12989: l_object_type cz_rule_folders.object_type%TYPE;
12990: l_rule_type_tbl cz_pb_mgr.t_ref;
12991:
12994: BEGIN
12995: IF (x_status = PUBLICATION_ERROR OR p_model_array.COUNT = 0) THEN
12996: RETURN;
12997: END IF;
12998: rec_count := cz_pb_mgr.v_cz_rules_rule_id_new_ref.COUNT; -- ? 0
12999:
13000: FOR i IN p_model_array.FIRST .. p_model_array.LAST
13001: LOOP
13002: l_cz_rules_new_id_tbl.DELETE;
12998: rec_count := cz_pb_mgr.v_cz_rules_rule_id_new_ref.COUNT; -- ? 0
12999:
13000: FOR i IN p_model_array.FIRST .. p_model_array.LAST
13001: LOOP
13002: l_cz_rules_new_id_tbl.DELETE;
13003: l_cz_rules_old_id_tbl.DELETE;
13004: l_cz_rules_rf_id_tbl.DELETE;
13005: l_cz_rules_proj_id_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
12999:
13000: FOR i IN p_model_array.FIRST .. p_model_array.LAST
13001: LOOP
13002: l_cz_rules_new_id_tbl.DELETE;
13003: l_cz_rules_old_id_tbl.DELETE;
13004: l_cz_rules_rf_id_tbl.DELETE;
13005: l_cz_rules_proj_id_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13000: FOR i IN p_model_array.FIRST .. p_model_array.LAST
13001: LOOP
13002: l_cz_rules_new_id_tbl.DELETE;
13003: l_cz_rules_old_id_tbl.DELETE;
13004: l_cz_rules_rf_id_tbl.DELETE;
13005: l_cz_rules_proj_id_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13001: LOOP
13002: l_cz_rules_new_id_tbl.DELETE;
13003: l_cz_rules_old_id_tbl.DELETE;
13004: l_cz_rules_rf_id_tbl.DELETE;
13005: l_cz_rules_proj_id_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13009: l_cz_rules_unmsg_id_tbl.DELETE;
13002: l_cz_rules_new_id_tbl.DELETE;
13003: l_cz_rules_old_id_tbl.DELETE;
13004: l_cz_rules_rf_id_tbl.DELETE;
13005: l_cz_rules_proj_id_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13009: l_cz_rules_unmsg_id_tbl.DELETE;
13010: l_cz_rules_expl_id_tbl.DELETE;
13003: l_cz_rules_old_id_tbl.DELETE;
13004: l_cz_rules_rf_id_tbl.DELETE;
13005: l_cz_rules_proj_id_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13009: l_cz_rules_unmsg_id_tbl.DELETE;
13010: l_cz_rules_expl_id_tbl.DELETE;
13011: l_cz_rules_sig_tbl.DELETE;
13004: l_cz_rules_rf_id_tbl.DELETE;
13005: l_cz_rules_proj_id_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13009: l_cz_rules_unmsg_id_tbl.DELETE;
13010: l_cz_rules_expl_id_tbl.DELETE;
13011: l_cz_rules_sig_tbl.DELETE;
13012: l_cz_rules_ui_tbl.DELETE;
13005: l_cz_rules_proj_id_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13009: l_cz_rules_unmsg_id_tbl.DELETE;
13010: l_cz_rules_expl_id_tbl.DELETE;
13011: l_cz_rules_sig_tbl.DELETE;
13012: l_cz_rules_ui_tbl.DELETE;
13013: l_eff_usg_mask_tbl.DELETE;
13006: l_cz_rules_comp_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13009: l_cz_rules_unmsg_id_tbl.DELETE;
13010: l_cz_rules_expl_id_tbl.DELETE;
13011: l_cz_rules_sig_tbl.DELETE;
13012: l_cz_rules_ui_tbl.DELETE;
13013: l_eff_usg_mask_tbl.DELETE;
13014: l_cz_rules_perst_id_tbl.DELETE;
13007: l_cz_rules_rea_id_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13009: l_cz_rules_unmsg_id_tbl.DELETE;
13010: l_cz_rules_expl_id_tbl.DELETE;
13011: l_cz_rules_sig_tbl.DELETE;
13012: l_cz_rules_ui_tbl.DELETE;
13013: l_eff_usg_mask_tbl.DELETE;
13014: l_cz_rules_perst_id_tbl.DELETE;
13015: l_rule_type_tbl.DELETE;
13008: l_cz_rules_eff_id_tbl.DELETE;
13009: l_cz_rules_unmsg_id_tbl.DELETE;
13010: l_cz_rules_expl_id_tbl.DELETE;
13011: l_cz_rules_sig_tbl.DELETE;
13012: l_cz_rules_ui_tbl.DELETE;
13013: l_eff_usg_mask_tbl.DELETE;
13014: l_cz_rules_perst_id_tbl.DELETE;
13015: l_rule_type_tbl.DELETE;
13016:
13010: l_cz_rules_expl_id_tbl.DELETE;
13011: l_cz_rules_sig_tbl.DELETE;
13012: l_cz_rules_ui_tbl.DELETE;
13013: l_eff_usg_mask_tbl.DELETE;
13014: l_cz_rules_perst_id_tbl.DELETE;
13015: l_rule_type_tbl.DELETE;
13016:
13017: BEGIN
13018: IF (cz_pb_mgr.v_session_parameter = MODEL_COPY) THEN
13016:
13017: BEGIN
13018: IF (cz_pb_mgr.v_session_parameter = MODEL_COPY) THEN
13019: IF (COPY_RULES = 'YES') THEN
13020: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
13021: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
13022: ,rule_id, rule_folder_id, devl_project_id, component_id
13023: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13024: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13017: BEGIN
13018: IF (cz_pb_mgr.v_session_parameter = MODEL_COPY) THEN
13019: IF (COPY_RULES = 'YES') THEN
13020: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
13021: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
13022: ,rule_id, rule_folder_id, devl_project_id, component_id
13023: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13024: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13025: ,persistent_rule_id, rule_type
13022: ,rule_id, rule_folder_id, devl_project_id, component_id
13023: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13024: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13025: ,persistent_rule_id, rule_type
13026: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13027: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13028: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13029: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13030: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13023: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13024: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13025: ,persistent_rule_id, rule_type
13026: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13027: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13028: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13029: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13030: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13031: FROM cz_rules t
13024: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13025: ,persistent_rule_id, rule_type
13026: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13027: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13028: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13029: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13030: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13031: FROM cz_rules t
13032: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13025: ,persistent_rule_id, rule_type
13026: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13027: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13028: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13029: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13030: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13031: FROM cz_rules t
13032: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13033: AND t.seeded_flag <> SEED_DATA
13026: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13027: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13028: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13029: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13030: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13031: FROM cz_rules t
13032: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13033: AND t.seeded_flag <> SEED_DATA
13034: AND ((CZ_PB_MGR.COPY_UIS='YES')
13027: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13028: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13029: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13030: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13031: FROM cz_rules t
13032: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13033: AND t.seeded_flag <> SEED_DATA
13034: AND ((CZ_PB_MGR.COPY_UIS='YES')
13035: OR
13045: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13046: );
13047:
13048: ELSIF (COPY_RULES = 'NO') THEN -- vigramak edit bug 13340775
13049: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
13050: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
13051: ,rule_id, rule_folder_id, devl_project_id, component_id
13052: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13053: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13046: );
13047:
13048: ELSIF (COPY_RULES = 'NO') THEN -- vigramak edit bug 13340775
13049: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
13050: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
13051: ,rule_id, rule_folder_id, devl_project_id, component_id
13052: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13053: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13054: ,persistent_rule_id, rule_type
13051: ,rule_id, rule_folder_id, devl_project_id, component_id
13052: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13053: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13054: ,persistent_rule_id, rule_type
13055: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13056: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13057: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13058: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13059: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13052: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13053: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13054: ,persistent_rule_id, rule_type
13055: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13056: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13057: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13058: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13059: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13060: FROM cz_rules t
13053: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13054: ,persistent_rule_id, rule_type
13055: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13056: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13057: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13058: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13059: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13060: FROM cz_rules t
13061: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13054: ,persistent_rule_id, rule_type
13055: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13056: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13057: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13058: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13059: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13060: FROM cz_rules t
13061: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13062: AND t.seeded_flag <> SEED_DATA
13055: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13056: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13057: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13058: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13059: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13060: FROM cz_rules t
13061: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13062: AND t.seeded_flag <> SEED_DATA
13063: AND ((CZ_PB_MGR.COPY_UIS='YES' AND rule_type IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION,RULE_TYPE_POPULATOR))
13056: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13057: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13058: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13059: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13060: FROM cz_rules t
13061: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13062: AND t.seeded_flag <> SEED_DATA
13063: AND ((CZ_PB_MGR.COPY_UIS='YES' AND rule_type IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION,RULE_TYPE_POPULATOR))
13064: OR
13075: );
13076: END IF;
13077: ELSE
13078: IF (p_rules_flag = 'YES') THEN
13079: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
13080: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
13081: ,rule_id, rule_folder_id, devl_project_id, component_id
13082: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13083: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13076: END IF;
13077: ELSE
13078: IF (p_rules_flag = 'YES') THEN
13079: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
13080: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
13081: ,rule_id, rule_folder_id, devl_project_id, component_id
13082: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13083: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13084: ,persistent_rule_id, rule_type
13081: ,rule_id, rule_folder_id, devl_project_id, component_id
13082: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13083: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13084: ,persistent_rule_id, rule_type
13085: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13086: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13087: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13088: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13089: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13082: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13083: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13084: ,persistent_rule_id, rule_type
13085: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13086: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13087: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13088: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13089: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13090: FROM cz_rules t
13083: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13084: ,persistent_rule_id, rule_type
13085: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13086: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13087: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13088: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13089: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13090: FROM cz_rules t
13091: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13084: ,persistent_rule_id, rule_type
13085: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13086: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13087: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13088: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13089: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13090: FROM cz_rules t
13091: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13092: AND t.seeded_flag <> SEED_DATA
13085: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13086: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13087: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13088: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13089: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13090: FROM cz_rules t
13091: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13092: AND t.seeded_flag <> SEED_DATA
13093: AND (
13086: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13087: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13088: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13089: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13090: FROM cz_rules t
13091: WHERE t.devl_project_id = p_model_array(i) AND t.deleted_flag = '0'
13092: AND t.seeded_flag <> SEED_DATA
13093: AND (
13094: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13100: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13101: );
13102:
13103: ELSE
13104: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
13105: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
13106: ,rule_id, rule_folder_id, devl_project_id, component_id
13107: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13108: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13101: );
13102:
13103: ELSE
13104: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_rules_seq
13105: ,'cz_rules_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr)
13106: ,rule_id, rule_folder_id, devl_project_id, component_id
13107: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13108: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13109: ,persistent_rule_id, rule_type
13106: ,rule_id, rule_folder_id, devl_project_id, component_id
13107: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13108: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13109: ,persistent_rule_id, rule_type
13110: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13111: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13112: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13113: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13114: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13107: ,reason_id, unsatisfied_msg_id, effectivity_set_id
13108: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13109: ,persistent_rule_id, rule_type
13110: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13111: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13112: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13113: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13114: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13115: FROM cz_rules t
13108: ,model_ref_expl_id, signature_id, ui_def_id, effective_usage_mask
13109: ,persistent_rule_id, rule_type
13110: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13111: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13112: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13113: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13114: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13115: FROM cz_rules t
13116: WHERE t.devl_project_id = p_model_array(i)
13109: ,persistent_rule_id, rule_type
13110: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13111: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13112: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13113: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13114: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13115: FROM cz_rules t
13116: WHERE t.devl_project_id = p_model_array(i)
13117: AND t.rule_type IN (RULE_TYPE_CONFIG_EXTENSION, RULE_TYPE_DISPLAY_CONDITION,
13110: BULK COLLECT INTO l_cz_rules_new_id_tbl, l_cz_rules_old_id_tbl
13111: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13112: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13113: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13114: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13115: FROM cz_rules t
13116: WHERE t.devl_project_id = p_model_array(i)
13117: AND t.rule_type IN (RULE_TYPE_CONFIG_EXTENSION, RULE_TYPE_DISPLAY_CONDITION,
13118: RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)
13111: ,l_cz_rules_rf_id_tbl, l_cz_rules_proj_id_tbl, l_cz_rules_comp_id_tbl
13112: ,l_cz_rules_rea_id_tbl, l_cz_rules_unmsg_id_tbl, l_cz_rules_eff_id_tbl
13113: ,l_cz_rules_expl_id_tbl, l_cz_rules_sig_tbl, l_cz_rules_ui_tbl, l_eff_usg_mask_tbl
13114: ,l_cz_rules_perst_id_tbl, l_rule_type_tbl
13115: FROM cz_rules t
13116: WHERE t.devl_project_id = p_model_array(i)
13117: AND t.rule_type IN (RULE_TYPE_CONFIG_EXTENSION, RULE_TYPE_DISPLAY_CONDITION,
13118: RULE_TYPE_ENABLED_CONDITION, RULE_TYPE_CAPTION)
13119: AND t.deleted_flag = '0' AND t.seeded_flag <> SEED_DATA
13136: WHEN OTHERS THEN
13137: RAISE;
13138: END;
13139:
13140: IF l_cz_rules_new_id_tbl.COUNT > 0 THEN
13141: FOR k IN l_cz_rules_new_id_tbl.FIRST .. l_cz_rules_new_id_tbl.LAST
13142: LOOP
13143: rec_count := rec_count + 1;
13144: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
13137: RAISE;
13138: END;
13139:
13140: IF l_cz_rules_new_id_tbl.COUNT > 0 THEN
13141: FOR k IN l_cz_rules_new_id_tbl.FIRST .. l_cz_rules_new_id_tbl.LAST
13142: LOOP
13143: rec_count := rec_count + 1;
13144: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
13145: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
13140: IF l_cz_rules_new_id_tbl.COUNT > 0 THEN
13141: FOR k IN l_cz_rules_new_id_tbl.FIRST .. l_cz_rules_new_id_tbl.LAST
13142: LOOP
13143: rec_count := rec_count + 1;
13144: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
13145: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
13146: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
13147: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13141: FOR k IN l_cz_rules_new_id_tbl.FIRST .. l_cz_rules_new_id_tbl.LAST
13142: LOOP
13143: rec_count := rec_count + 1;
13144: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
13145: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
13146: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
13147: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13142: LOOP
13143: rec_count := rec_count + 1;
13144: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
13145: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
13146: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
13147: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13143: rec_count := rec_count + 1;
13144: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
13145: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
13146: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
13147: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13151: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
13144: cz_pb_mgr.v_cz_rules_rule_id_idx_ref(l_cz_rules_old_id_tbl(k)):=l_cz_rules_new_id_tbl(k);
13145: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
13146: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
13147: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13151: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
13152: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
13145: cz_pb_mgr.v_cz_rules_proj_id_ref(rec_count) := l_cz_rules_proj_id_tbl(k);
13146: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
13147: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13151: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
13152: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
13153: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
13146: cz_pb_mgr.v_cz_rules_comp_id_ref(rec_count) := l_cz_rules_comp_id_tbl(k);
13147: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13151: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
13152: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
13153: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
13154: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
13147: cz_pb_mgr.v_cz_rules_expl_ref(rec_count) := l_cz_rules_expl_id_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13151: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
13152: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
13153: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
13154: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
13155: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
13148: p_rules_new_array(rec_count) := l_cz_rules_new_id_tbl(k);
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13151: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
13152: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
13153: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
13154: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
13155: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
13156: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
13149: p_rules_old_array(rec_count) := l_cz_rules_old_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13151: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
13152: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
13153: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
13154: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
13155: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
13156: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
13157: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
13150: cz_pb_mgr.v_cz_rules_rea_id_ref(rec_count) := l_cz_rules_rea_id_tbl(k);
13151: cz_pb_mgr.v_cz_rules_unmsg_id_ref(rec_count) := l_cz_rules_unmsg_id_tbl(k);
13152: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
13153: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
13154: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
13155: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
13156: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
13157: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
13158:
13152: cz_pb_mgr.v_cz_rules_eff_id_ref(rec_count) := l_cz_rules_eff_id_tbl(k);
13153: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
13154: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
13155: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
13156: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
13157: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
13158:
13159: IF l_rule_type_tbl(k) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
13160: RULE_TYPE_CAPTION, RULE_TYPE_POPULATOR) THEN
13153: cz_pb_mgr.v_cz_rules_sig_ref(rec_count) := l_cz_rules_sig_tbl(k);
13154: cz_pb_mgr.v_cz_rules_ui_ref(rec_count) := l_cz_rules_ui_tbl(k);
13155: cz_pb_mgr.v_cz_rule_usage_mask_tbl(rec_count) := l_eff_usg_mask_tbl(k);
13156: cz_pb_mgr.v_cz_rules_obj_ref(rec_count) := 'RUL';
13157: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
13158:
13159: IF l_rule_type_tbl(k) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
13160: RULE_TYPE_CAPTION, RULE_TYPE_POPULATOR) THEN
13161: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
13157: cz_pb_mgr.v_cz_rules_persistent_id_ref(rec_count) := l_cz_rules_perst_id_tbl(k);
13158:
13159: IF l_rule_type_tbl(k) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
13160: RULE_TYPE_CAPTION, RULE_TYPE_POPULATOR) THEN
13161: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
13162: ELSE
13163: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := l_cz_rules_rf_id_tbl(k);
13164: END IF;
13165: END LOOP;
13159: IF l_rule_type_tbl(k) IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
13160: RULE_TYPE_CAPTION, RULE_TYPE_POPULATOR) THEN
13161: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := 0;
13162: ELSE
13163: cz_pb_mgr.v_cz_rules_rf_id_ref(rec_count) := l_cz_rules_rf_id_tbl(k);
13164: END IF;
13165: END LOOP;
13166: END IF;
13167: END LOOP;
13173: BEGIN
13174: SELECT object_type INTO l_object_type
13175: FROM cz_rule_folders
13176: WHERE rule_folder_id = p_rules_old_array(j) AND object_type NOT IN ('FNC', 'RFL', 'RSQ');
13177: cz_pb_mgr.v_cz_rules_obj_ref(j) := l_object_type;
13178: EXCEPTION
13179: WHEN NO_DATA_FOUND THEN
13180: NULL;
13181: END;
13182: END LOOP;
13183: END IF;
13184: EXCEPTION
13185: WHEN OTHERS THEN
13186: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
13187: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
13188: x_status := PUBLICATION_ERROR;
13189: RAISE;
13190: END bulk_collect_rules;
13183: END IF;
13184: EXCEPTION
13185: WHEN OTHERS THEN
13186: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
13187: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
13188: x_status := PUBLICATION_ERROR;
13189: RAISE;
13190: END bulk_collect_rules;
13191:
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
13212: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
13213: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
13214: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
13215: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
13216: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);
13217: clear_tables('cz_lce_headers', 'ref', cz_pb_mgr.v_status_code);
13218: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
13893: END IF;
13894:
13895: IF (cz_pb_mgr.l_bom_caption_rule <> 0)
13896: THEN
13897: 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);
13898: ELSE
13899: cz_pb_mgr.l_bom_caption_rule := NULL;
13900: END IF;
13901:
13900: END IF;
13901:
13902: IF (cz_pb_mgr.l_nonbom_capt_rule_id <> 0)
13903: THEN
13904: 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);
13905: ELSE
13906: cz_pb_mgr.l_nonbom_capt_rule_id := NULL;
13907: END IF;
13908:
14509: ,'cz_pb_mgr.v_cz_eff_sets_old_tbl'
14510: ,'cz_pb_mgr.v_cz_eff_sets_new_tbl'
14511: ,'Eff sets of ps nodes'
14512: );
14513: ------clear_tables('cz_rules','ref',cz_pb_mgr.v_status_code);
14514: -----bulk collect old and new rule ids
14515: bulk_collect_rules(p_export_flag
14516: ,cz_pb_mgr.v_models_to_be_exported
14517: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
14513: ------clear_tables('cz_rules','ref',cz_pb_mgr.v_status_code);
14514: -----bulk collect old and new rule ids
14515: bulk_collect_rules(p_export_flag
14516: ,cz_pb_mgr.v_models_to_be_exported
14517: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
14518: ,cz_pb_mgr.v_cz_rules_rule_id_new_ref
14519: ,cz_pb_mgr.v_cz_rules_rule_id_idx_ref
14520: ,cz_pb_mgr.v_status_code
14521: );
14514: -----bulk collect old and new rule ids
14515: bulk_collect_rules(p_export_flag
14516: ,cz_pb_mgr.v_models_to_be_exported
14517: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
14518: ,cz_pb_mgr.v_cz_rules_rule_id_new_ref
14519: ,cz_pb_mgr.v_cz_rules_rule_id_idx_ref
14520: ,cz_pb_mgr.v_status_code
14521: );
14522:
14515: bulk_collect_rules(p_export_flag
14516: ,cz_pb_mgr.v_models_to_be_exported
14517: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
14518: ,cz_pb_mgr.v_cz_rules_rule_id_new_ref
14519: ,cz_pb_mgr.v_cz_rules_rule_id_idx_ref
14520: ,cz_pb_mgr.v_status_code
14521: );
14522:
14523: IF (cz_pb_mgr.g_log_timing = publication_timing)
14528:
14529: -- resolve effective usage mask for rules
14530: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
14531: THEN
14532: resolve_effective_usage_mask(cz_pb_mgr.v_cz_rules_rule_id_old_ref, 1);
14533: END IF;
14534:
14535: ---------resolve eff sets
14536: 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');
14596: THEN
14597: log_timing_message('start resolve caption rule ids in ps nodes');
14598: END IF;
14599:
14600: 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');
14601:
14602: IF (cz_pb_mgr.g_log_timing = publication_timing)
14603: THEN
14604: log_timing_message('end resolve resolve caption rule ids in ps nodes');
15394: THEN
15395: log_timing_message('end component_ids of models not to be exported');
15396: END IF;
15397:
15398: 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');
15399: 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');
15400:
15401: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
15402: THEN
15395: log_timing_message('end component_ids of models not to be exported');
15396: END IF;
15397:
15398: 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');
15399: 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');
15400:
15401: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
15402: THEN
15403: synch_master_template;
16074: IS
16075: plsql_table_list cz_pb_mgr.col_plsql_table_list;
16076: rec_count NUMBER := 0;
16077: BEGIN
16078: ---------------reason id of cz rules
16079: insert_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, 'Reason ids of cz rules');
16080: --------resolve reason ids
16081: 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');
16082:
16075: plsql_table_list cz_pb_mgr.col_plsql_table_list;
16076: rec_count NUMBER := 0;
16077: BEGIN
16078: ---------------reason id of cz rules
16079: insert_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, 'Reason ids of cz rules');
16080: --------resolve reason ids
16081: 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');
16082:
16083: ---------------unsatisfied message of cz rules
16077: BEGIN
16078: ---------------reason id of cz rules
16079: insert_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, 'Reason ids of cz rules');
16080: --------resolve reason ids
16081: 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');
16082:
16083: ---------------unsatisfied message of cz rules
16084: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
16085: ---------resolve unsatisfied message ids
16079: insert_intl_texts(cz_pb_mgr.v_cz_rules_rea_id_ref, 'Reason ids of cz rules');
16080: --------resolve reason ids
16081: 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');
16082:
16083: ---------------unsatisfied message of cz rules
16084: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
16085: ---------resolve unsatisfied message ids
16086: 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');
16087:
16080: --------resolve reason ids
16081: 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');
16082:
16083: ---------------unsatisfied message of cz rules
16084: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
16085: ---------resolve unsatisfied message ids
16086: 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');
16087:
16088: ------------populate effectivity set ids for cz rules
16082:
16083: ---------------unsatisfied message of cz rules
16084: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
16085: ---------resolve unsatisfied message ids
16086: 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');
16087:
16088: ------------populate effectivity set ids for cz rules
16089: insert_eff_sets(cz_pb_mgr.v_cz_rules_eff_id_ref
16090: ,cz_pb_mgr.v_cz_eff_sets_old_tbl
16084: insert_intl_texts(cz_pb_mgr.v_cz_rules_unmsg_id_ref, 'Unsatisfied message ids of cz rules');
16085: ---------resolve unsatisfied message ids
16086: 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');
16087:
16088: ------------populate effectivity set ids for cz rules
16089: insert_eff_sets(cz_pb_mgr.v_cz_rules_eff_id_ref
16090: ,cz_pb_mgr.v_cz_eff_sets_old_tbl
16091: ,cz_pb_mgr.v_cz_eff_sets_new_tbl
16092: ,cz_pb_mgr.v_cz_eff_sets_idx_tbl
16085: ---------resolve unsatisfied message ids
16086: 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');
16087:
16088: ------------populate effectivity set ids for cz rules
16089: insert_eff_sets(cz_pb_mgr.v_cz_rules_eff_id_ref
16090: ,cz_pb_mgr.v_cz_eff_sets_old_tbl
16091: ,cz_pb_mgr.v_cz_eff_sets_new_tbl
16092: ,cz_pb_mgr.v_cz_eff_sets_idx_tbl
16093: ,'cz_pb_mgr.v_cz_eff_sets_old_tbl'
16091: ,cz_pb_mgr.v_cz_eff_sets_new_tbl
16092: ,cz_pb_mgr.v_cz_eff_sets_idx_tbl
16093: ,'cz_pb_mgr.v_cz_eff_sets_old_tbl'
16094: ,'cz_pb_mgr.v_cz_eff_sets_new_tbl'
16095: ,'Eff sets of cz rules'
16096: );
16097:
16098: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
16099: -------------Resolve sig id of cz_rules
16094: ,'cz_pb_mgr.v_cz_eff_sets_new_tbl'
16095: ,'Eff sets of cz rules'
16096: );
16097:
16098: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
16099: -------------Resolve sig id of cz_rules
16100: 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);
16101: ----------resolve_eff_sets;
16102: 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');
16095: ,'Eff sets of cz rules'
16096: );
16097:
16098: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
16099: -------------Resolve sig id of cz_rules
16100: 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);
16101: ----------resolve_eff_sets;
16102: 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');
16103:
16096: );
16097:
16098: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
16099: -------------Resolve sig id of cz_rules
16100: 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);
16101: ----------resolve_eff_sets;
16102: 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');
16103:
16104: -------------Resolve rule_folder_id of cz_rules
16098: export_signatures(cz_pb_mgr.v_cz_rules_sig_ref);
16099: -------------Resolve sig id of cz_rules
16100: 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);
16101: ----------resolve_eff_sets;
16102: 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');
16103:
16104: -------------Resolve rule_folder_id of cz_rules
16105: -- if copy rule db setting is not yes, publishing still copies CXs and FCs but only copies
16106: -- the root rule folder of a model, so we will put such rules under root folder in tgt model
16100: 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);
16101: ----------resolve_eff_sets;
16102: 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');
16103:
16104: -------------Resolve rule_folder_id of cz_rules
16105: -- if copy rule db setting is not yes, publishing still copies CXs and FCs but only copies
16106: -- the root rule folder of a model, so we will put such rules under root folder in tgt model
16107: -- note we do not want to leave rule folders unresolved because it may cause problem in developer
16108: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
16105: -- if copy rule db setting is not yes, publishing still copies CXs and FCs but only copies
16106: -- the root rule folder of a model, so we will put such rules under root folder in tgt model
16107: -- note we do not want to leave rule folders unresolved because it may cause problem in developer
16108: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
16109: FOR i IN cz_pb_mgr.v_cz_rules_rf_id_ref.FIRST .. cz_pb_mgr.v_cz_rules_rf_id_ref.LAST LOOP
16110: IF cz_pb_mgr.v_cz_rules_rf_id_ref(i)<>0 THEN
16111: 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));
16112: END IF;
16113: END LOOP;
16106: -- the root rule folder of a model, so we will put such rules under root folder in tgt model
16107: -- note we do not want to leave rule folders unresolved because it may cause problem in developer
16108: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
16109: FOR i IN cz_pb_mgr.v_cz_rules_rf_id_ref.FIRST .. cz_pb_mgr.v_cz_rules_rf_id_ref.LAST LOOP
16110: IF cz_pb_mgr.v_cz_rules_rf_id_ref(i)<>0 THEN
16111: 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));
16112: END IF;
16113: END LOOP;
16114: END IF;
16107: -- note we do not want to leave rule folders unresolved because it may cause problem in developer
16108: IF cz_pb_mgr.v_session_parameter=pub_model AND p_copy_rules_flag<>'YES' THEN
16109: FOR i IN cz_pb_mgr.v_cz_rules_rf_id_ref.FIRST .. cz_pb_mgr.v_cz_rules_rf_id_ref.LAST LOOP
16110: IF cz_pb_mgr.v_cz_rules_rf_id_ref(i)<>0 THEN
16111: 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));
16112: END IF;
16113: END LOOP;
16114: END IF;
16115: 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');
16111: 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));
16112: END IF;
16113: END LOOP;
16114: END IF;
16115: 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');
16116:
16117: -------------Resolve devl_project_id of cz_rules
16118: 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');
16119: -------------Resolve component_id of cz_rules
16113: END LOOP;
16114: END IF;
16115: 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');
16116:
16117: -------------Resolve devl_project_id of cz_rules
16118: 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');
16119: -------------Resolve component_id of cz_rules
16120: 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);
16121:
16114: END IF;
16115: 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');
16116:
16117: -------------Resolve devl_project_id of cz_rules
16118: 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');
16119: -------------Resolve component_id of cz_rules
16120: 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);
16121:
16122: -------------Resolve expl id of cz_rules
16115: 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');
16116:
16117: -------------Resolve devl_project_id of cz_rules
16118: 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');
16119: -------------Resolve component_id of cz_rules
16120: 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);
16121:
16122: -------------Resolve expl id of cz_rules
16123: 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');
16116:
16117: -------------Resolve devl_project_id of cz_rules
16118: 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');
16119: -------------Resolve component_id of cz_rules
16120: 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);
16121:
16122: -------------Resolve expl id of cz_rules
16123: 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');
16124: 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');
16118: 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');
16119: -------------Resolve component_id of cz_rules
16120: 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);
16121:
16122: -------------Resolve expl id of cz_rules
16123: 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');
16124: 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');
16125: -------------populate plsql_table_list for cz rules
16126: plsql_table_list.DELETE;
16119: -------------Resolve component_id of cz_rules
16120: 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);
16121:
16122: -------------Resolve expl id of cz_rules
16123: 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');
16124: 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');
16125: -------------populate plsql_table_list for cz rules
16126: plsql_table_list.DELETE;
16127: rec_count := 1;
16120: 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);
16121:
16122: -------------Resolve expl id of cz_rules
16123: 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');
16124: 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');
16125: -------------populate plsql_table_list for cz rules
16126: plsql_table_list.DELETE;
16127: rec_count := 1;
16128: plsql_table_list(rec_count).col_name := 'rule_id';
16121:
16122: -------------Resolve expl id of cz_rules
16123: 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');
16124: 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');
16125: -------------populate plsql_table_list for cz rules
16126: plsql_table_list.DELETE;
16127: rec_count := 1;
16128: plsql_table_list(rec_count).col_name := 'rule_id';
16129: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
16125: -------------populate plsql_table_list for cz rules
16126: plsql_table_list.DELETE;
16127: rec_count := 1;
16128: plsql_table_list(rec_count).col_name := 'rule_id';
16129: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
16130: rec_count := rec_count + 1;
16131: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16132: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
16133: rec_count := rec_count + 1;
16128: plsql_table_list(rec_count).col_name := 'rule_id';
16129: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
16130: rec_count := rec_count + 1;
16131: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16132: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
16133: rec_count := rec_count + 1;
16134: plsql_table_list(rec_count).col_name := 'devl_project_id';
16135: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
16136: rec_count := rec_count + 1;
16131: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16132: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
16133: rec_count := rec_count + 1;
16134: plsql_table_list(rec_count).col_name := 'devl_project_id';
16135: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
16136: rec_count := rec_count + 1;
16137: plsql_table_list(rec_count).col_name := 'component_id';
16138: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_comp_id_ref';
16139: rec_count := rec_count + 1;
16134: plsql_table_list(rec_count).col_name := 'devl_project_id';
16135: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
16136: rec_count := rec_count + 1;
16137: plsql_table_list(rec_count).col_name := 'component_id';
16138: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_comp_id_ref';
16139: rec_count := rec_count + 1;
16140: plsql_table_list(rec_count).col_name := 'reason_id';
16141: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rea_id_ref';
16142: rec_count := rec_count + 1;
16137: plsql_table_list(rec_count).col_name := 'component_id';
16138: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_comp_id_ref';
16139: rec_count := rec_count + 1;
16140: plsql_table_list(rec_count).col_name := 'reason_id';
16141: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rea_id_ref';
16142: rec_count := rec_count + 1;
16143: plsql_table_list(rec_count).col_name := 'unsatisfied_msg_id';
16144: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_unmsg_id_ref';
16145: rec_count := rec_count + 1;
16140: plsql_table_list(rec_count).col_name := 'reason_id';
16141: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rea_id_ref';
16142: rec_count := rec_count + 1;
16143: plsql_table_list(rec_count).col_name := 'unsatisfied_msg_id';
16144: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_unmsg_id_ref';
16145: rec_count := rec_count + 1;
16146: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
16147: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
16148: rec_count := rec_count + 1;
16143: plsql_table_list(rec_count).col_name := 'unsatisfied_msg_id';
16144: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_unmsg_id_ref';
16145: rec_count := rec_count + 1;
16146: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
16147: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
16148: rec_count := rec_count + 1;
16149: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
16150: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_expl_ref';
16151: rec_count := rec_count + 1;
16146: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
16147: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
16148: rec_count := rec_count + 1;
16149: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
16150: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_expl_ref';
16151: rec_count := rec_count + 1;
16152: plsql_table_list(rec_count).col_name := 'signature_id';
16153: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_sig_ref';
16154: rec_count := rec_count + 1;
16149: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
16150: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_expl_ref';
16151: rec_count := rec_count + 1;
16152: plsql_table_list(rec_count).col_name := 'signature_id';
16153: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_sig_ref';
16154: rec_count := rec_count + 1;
16155: plsql_table_list(rec_count).col_name := 'ui_def_id';
16156: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_ui_ref';
16157: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
16152: plsql_table_list(rec_count).col_name := 'signature_id';
16153: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_sig_ref';
16154: rec_count := rec_count + 1;
16155: plsql_table_list(rec_count).col_name := 'ui_def_id';
16156: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_ui_ref';
16157: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
16158: rec_count := rec_count + 1;
16159: plsql_table_list(rec_count).col_name := 'effective_usage_mask';
16160: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_rul_usg_msk_tbl';
16159: plsql_table_list(rec_count).col_name := 'effective_usage_mask';
16160: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_rul_usg_msk_tbl';
16161: rec_count := rec_count + 1;
16162: plsql_table_list(rec_count).col_name := 'persistent_rule_id';
16163: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_persistent_id_ref';
16164: END IF;
16165:
16166: ------populate cz_rules
16167: insert_into_table('cz_rules'
16162: plsql_table_list(rec_count).col_name := 'persistent_rule_id';
16163: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_persistent_id_ref';
16164: END IF;
16165:
16166: ------populate cz_rules
16167: insert_into_table('cz_rules'
16168: ,'rule_id'
16169: ,cz_pb_mgr.v_db_link
16170: ,plsql_table_list
16163: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_persistent_id_ref';
16164: END IF;
16165:
16166: ------populate cz_rules
16167: insert_into_table('cz_rules'
16168: ,'rule_id'
16169: ,cz_pb_mgr.v_db_link
16170: ,plsql_table_list
16171: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
16167: insert_into_table('cz_rules'
16168: ,'rule_id'
16169: ,cz_pb_mgr.v_db_link
16170: ,plsql_table_list
16171: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
16172: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
16173: );
16174:
16175: -----insert new records into cz_rule_folders
16168: ,'rule_id'
16169: ,cz_pb_mgr.v_db_link
16170: ,plsql_table_list
16171: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
16172: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
16173: );
16174:
16175: -----insert new records into cz_rule_folders
16176: plsql_table_list.DELETE;
16175: -----insert new records into cz_rule_folders
16176: plsql_table_list.DELETE;
16177: rec_count := 1;
16178: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16179: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
16180: rec_count := rec_count + 1;
16181: plsql_table_list(rec_count).col_name := 'object_type';
16182: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_obj_ref';
16183: rec_count := rec_count + 1;
16178: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16179: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rule_id_new_ref';
16180: rec_count := rec_count + 1;
16181: plsql_table_list(rec_count).col_name := 'object_type';
16182: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_obj_ref';
16183: rec_count := rec_count + 1;
16184: plsql_table_list(rec_count).col_name := 'devl_project_id';
16185: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
16186: rec_count := rec_count + 1;
16181: plsql_table_list(rec_count).col_name := 'object_type';
16182: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_obj_ref';
16183: rec_count := rec_count + 1;
16184: plsql_table_list(rec_count).col_name := 'devl_project_id';
16185: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
16186: rec_count := rec_count + 1;
16187: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
16188: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
16189: rec_count := rec_count + 1;
16184: plsql_table_list(rec_count).col_name := 'devl_project_id';
16185: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_proj_id_ref';
16186: rec_count := rec_count + 1;
16187: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
16188: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
16189: rec_count := rec_count + 1;
16190: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
16191: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
16192: ----------insert into cz_func_comp_specs
16187: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
16188: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
16189: rec_count := rec_count + 1;
16190: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
16191: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
16192: ----------insert into cz_func_comp_specs
16193: insert_into_table('cz_rule_folders'
16194: ,'rule_folder_id'
16195: ,'object_type'
16194: ,'rule_folder_id'
16195: ,'object_type'
16196: ,cz_pb_mgr.v_db_link
16197: ,plsql_table_list
16198: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
16199: ,'cz_pb_mgr.v_cz_rules_obj_ref'
16200: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
16201: ,cz_pb_mgr.v_cz_rules_obj_ref
16202: );
16195: ,'object_type'
16196: ,cz_pb_mgr.v_db_link
16197: ,plsql_table_list
16198: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
16199: ,'cz_pb_mgr.v_cz_rules_obj_ref'
16200: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
16201: ,cz_pb_mgr.v_cz_rules_obj_ref
16202: );
16203: END insert_rules;
16196: ,cz_pb_mgr.v_db_link
16197: ,plsql_table_list
16198: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
16199: ,'cz_pb_mgr.v_cz_rules_obj_ref'
16200: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
16201: ,cz_pb_mgr.v_cz_rules_obj_ref
16202: );
16203: END insert_rules;
16204:
16197: ,plsql_table_list
16198: ,'cz_pb_mgr.v_cz_rules_rule_id_old_ref'
16199: ,'cz_pb_mgr.v_cz_rules_obj_ref'
16200: ,cz_pb_mgr.v_cz_rules_rule_id_old_ref
16201: ,cz_pb_mgr.v_cz_rules_obj_ref
16202: );
16203: END insert_rules;
16204:
16205: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
16464:
16465: ------resolve devl id and rule id
16466: 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');
16467: ------resolve devl id
16468: 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');
16469: -----resolve ps node id
16470: 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');
16471: -----resolve filter set id
16472: resolve_ids(cz_pb_mgr.v_populators_set_id_ref, cz_pb_mgr.v_filter_sets_idx_ref, 'filter set id of cz populators');
16572: EXCEPTION
16573: WHEN NO_DATA_FOUND THEN
16574: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16575: FOR j IN (SELECT rule.name rulename, prj.name prjname
16576: FROM cz_rules rule, cz_devl_projects prj
16577: WHERE rule.rule_id=p_ruleid_tbl(i) AND rule.devl_project_id=prj.devl_project_id) LOOP
16578: 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);
16579: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'upload_rule_schema.mm_resolve_rule_fks', SQLCODE);
16580: END LOOP;
16866: -----export archives
16867: export_archives;
16868: export_populators;
16869:
16870: IF cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0 THEN
16871: insert_rules(p_copy_rules_flag, v_model_root_folder_map);
16872: END IF;
16873:
16874: IF cz_pb_mgr.v_session_parameter = pub_model THEN
16879: copy_lce_texts(p_copy_rules_flag);
16880: END IF;
16881: END IF;
16882:
16883: ---------------local pl/sql tables of cz rules released after populating rule sub schema
16884: -------------insert expressions
16885: IF (cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0)
16886: THEN
16887: 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
16881: END IF;
16882:
16883: ---------------local pl/sql tables of cz rules released after populating rule sub schema
16884: -------------insert expressions
16885: IF (cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0)
16886: THEN
16887: 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
16888: LOOP
16889: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
16883: ---------------local pl/sql tables of cz rules released after populating rule sub schema
16884: -------------insert expressions
16885: IF (cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0)
16886: THEN
16887: 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
16888: LOOP
16889: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
16890:
16891: BEGIN
16903: ,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
16904: ,cz_pb_mgr.v_cz_enodes_par_sig_id_tbl
16905: ,cz_pb_mgr.v_cz_enodes_prop_id_tbl
16906: FROM cz_expression_nodes t
16907: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0';
16908: ELSE
16909: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
16910: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
16911: ,cz_pb_mgr.v_oraclesequenceincr
16917: ,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
16918: ,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
16919: ,cz_pb_mgr.v_cz_enodes_par_sig_id_tbl
16920: FROM cz_expression_nodes t
16921: 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;
16922: END IF;
16923: EXCEPTION
16924: WHEN NO_DATA_FOUND
16925: THEN
16976: END IF;
16977: END LOOP;
16978: END IF;
16979: END LOOP; /* end loop of */
16980: END IF; -- end cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0 /* (COUNT > 0) */
16981:
16982: --------export_signatures
16983: export_signatures(cz_pb_mgr.v_cz_expr_sig_ref);
16984: -----------resolve parent expr node id
16995: 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);
16996: 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);
16997: END IF;
16998:
16999: 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');
17000:
17001: --------populate plsql_table_list for cz_expression_nodes
17002: plsql_table_list.DELETE;
17003: rec_count := 1;
17059: 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
17060: FROM cz_des_chart_features t
17061: WHERE t.rule_id IN(
17062: SELECT rule_id
17063: FROM cz_rules
17064: WHERE cz_rules.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
17065: AND cz_rules.deleted_flag = '0')
17066: AND t.deleted_flag = '0';
17067: EXCEPTION
17060: FROM cz_des_chart_features t
17061: WHERE t.rule_id IN(
17062: SELECT rule_id
17063: FROM cz_rules
17064: WHERE cz_rules.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
17065: AND cz_rules.deleted_flag = '0')
17066: AND t.deleted_flag = '0';
17067: EXCEPTION
17068: WHEN NO_DATA_FOUND
17061: WHERE t.rule_id IN(
17062: SELECT rule_id
17063: FROM cz_rules
17064: WHERE cz_rules.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
17065: AND cz_rules.deleted_flag = '0')
17066: AND t.deleted_flag = '0';
17067: EXCEPTION
17068: WHEN NO_DATA_FOUND
17069: THEN
17101: 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);
17102: 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);
17103: END IF;
17104:
17105: 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');
17106:
17107: ------insert new records into cz_des_chart_features
17108: insert_des_chart_features(cz_pb_mgr.v_status_code);
17109: -------------release local pl/sql tables of des chart features
17129: SELECT rul.rule_id, secondary_feature_id, primary_opt_id, secondary_opt_id
17130: , secondary_feat_expl_id, mark_char, rule_type
17131: 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
17132: ,v_cz_des_cells_sexpl_id_tbl, v_cz_des_cells_mark_char_tbl, v_rule_type_tbl
17133: FROM cz_rules rul, cz_des_chart_cells dcc
17134: WHERE rul.deleted_flag = '0' AND rul.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
17135: AND rul.rule_id = dcc.rule_id AND dcc.deleted_flag = '0';
17136: EXCEPTION
17137: WHEN NO_DATA_FOUND
17164: END IF;
17165: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
17166: END IF; /* end if of cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
17167:
17168: 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');
17169: 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);
17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: 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');
20202: ---at which point, tables cannot be cleared because rules of the model have
20203: ---already been collected in these tables from bulk_collect_rules.
20204: ---so, if model migration, the rules related tables will NOT be cleared
20205: ---get_oa_tmpls.
20206: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
20207: END IF;
20208:
20209: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
20210: log_timing_message('end has_tobe_published');
20420: --Calculate the max_persistent_rec_id for the model and insert into CZ_PERSISTENT_REC_IDS.
20421: EXECUTE IMMEDIATE 'SELECT GREATEST(NVL((SELECT MAX(persistent_node_id) FROM cz_ps_nodes'
20422: || cz_pb_mgr.v_db_link
20423: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :1), 0),'
20424: || ' NVL((SELECT MAX(persistent_rule_id) FROM cz_rules'
20425: || cz_pb_mgr.v_db_link
20426: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :2), 0),'
20427: || ' NVL((SELECT MAX(persistent_intl_text_id) FROM cz_localized_texts'
20428: || cz_pb_mgr.v_db_link
24976: remote_effs_cv ref_cursor;
24977: remote_rule_seq_name_cv ref_cursor;
24978: l_effecivity_set_id NUMBER;
24979: l_rule_folder_name cz_rule_folders.NAME%TYPE;
24980: l_rule_name cz_rules.NAME%TYPE;
24981: BEGIN
24982: --all the rule sequences have been accumulated here
24983: IF (mm_v_tbl_rule_seq.COUNT > 0) THEN
24984: FOR rule_seq IN mm_v_tbl_rule_seq.FIRST .. mm_v_tbl_rule_seq.LAST
24988: --get all the effectivity_set_ids for the rules in that rule sequence
24989: l_sql_string :=
24990: 'SELECT effectivity_set_id, name'
24991: || ' '
24992: || 'FROM cz_rules'
24993: || cz_pb_mgr.v_db_link
24994: || ' '
24995: || 'WHERE rule_folder_id = :1'
24996: || ' '
25039:
25040: 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);
25041: log_pb_errors(cz_pb_mgr.v_err_message, 0, 'mm_resolve_rule_seq_effsetid', -1);
25042: l_sql_string :=
25043: 'UPDATE cz_rules'
25044: || cz_pb_mgr.v_db_link
25045: || ' '
25046: || 'SET effective_from = :1'
25047: || ', '