[Home] [Help]
722: resolved_array(j) := array_of_new_keys(array_to_resolve(j));
723: END IF;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN
726: IF (array_to_resolve(j) = 0 AND(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)) THEN
727:
728: IF NOT(ui_templ_id_tbl(j)=0 OR ui_templ_id_tbl(j) IS NULL) THEN
729:
730: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES
770: THEN
771: IF ((p_array_to_resolve(i) = 0))
772: THEN
773: IF ( (NOT cz_pb_mgr.g_ui_templates_idx_temp_ref.EXISTS(p_templ_array(i)))
774: OR (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
775: )
776: THEN
777: p_array_to_resolve(i) := 0;
778: ELSE
1215: rec_count NUMBER;
1216: BEGIN
1217: --All reading has been moved to load_data->read_item_schema.
1218:
1219: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1220: THEN
1221: mm_v_tbl_sync_prop_vals_num.DELETE;
1222: mm_v_tbl_prop_vals_trans_old.DELETE;
1223: mm_v_tbl_prop_vals_trans_new.DELETE;
1258: plsql_table_list(rec_count).col_name := 'item_type_id';
1259:
1260: -- sure if we need to maintain a table for orig_sys_ref, if needed, we need to maintain a sync table
1261: -- for model migration and then resolve them before updating
1262: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1263: THEN
1264: cz_pb_mgr.mm_insert_array1.DELETE;
1265: cz_pb_mgr.mm_insert_array2.DELETE;
1266: cz_pb_mgr.mm_source_array1.DELETE;
1306: --ITEMS
1307: plsql_table_list.DELETE;
1308: rec_count := 1;
1309:
1310: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1311: THEN
1312: cz_pb_mgr.mm_insert_array1.DELETE;
1313: cz_pb_mgr.mm_insert_array2.DELETE;
1314: cz_pb_mgr.mm_source_array1.DELETE;
1367: --PROPERTIES (with RP_ENTRIES if model migration)
1368: plsql_table_list.DELETE;
1369: rec_count := 1;
1370:
1371: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1372: THEN
1373: cz_pb_mgr.mm_insert_array1.DELETE;
1374: cz_pb_mgr.mm_insert_array2.DELETE;
1375: cz_pb_mgr.mm_objtype_array.DELETE;
1449: );
1450: END IF;
1451:
1452: --ITEM TYPE PROPERTIES
1453: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1454: THEN
1455: cz_pb_mgr.mm_insert_array1.DELETE;
1456: cz_pb_mgr.mm_insert_array2.DELETE;
1457: cz_pb_mgr.mm_objtype_array.DELETE;
1489: );
1490: END IF;
1491:
1492: --ITEM PROPERTY VALUES
1493: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1494: THEN
1495: cz_pb_mgr.mm_insert_array1.DELETE;
1496: cz_pb_mgr.mm_insert_array2.DELETE;
1497: cz_pb_mgr.mm_objtype_array.DELETE;
2449: plsql_table_list(rec_count).col_name := 'intl_text_id';
2450: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_intl_text_new_ref';
2451: rec_count := rec_count + 1;
2452:
2453: IF (p_from_template AND CZ_PB_MGR.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
2454: plsql_table_list(rec_count).col_name := 'persistent_intl_text_id';
2455: plsql_table_list(rec_count).table_name := 'CZ_PB_MGR.v_cz_intl_text_new_ref';
2456: rec_count := rec_count + 1;
2457: END IF;
3136: l_chunk_tbl(l_seq_nbr).xml_chunk := l_buffer;
3137: END IF;
3138: END LOOP;
3139:
3140: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
3141: IF (l_chunk_tbl.COUNT > 0) THEN
3142: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3143: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3144:
4521: l_persistent_element_id CZ_UI_TEMPLATE_ELEMENTS.persistent_element_id%TYPE := p_persistent_element_id;
4522:
4523: BEGIN
4524:
4525: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
4526: l_ui_def_id := 0;
4527: l_persistent_element_id := p_element_id;
4528: END IF;
4529:
4578: l_status NUMBER := 0;
4579: l_ref_cursor ref_cursor;
4580: l_src_pb_id cz_model_publications.publication_id%TYPE;
4581: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
4582: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
4583: BEGIN
4584: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
4585: THEN
4586: l_inst_str :=
4698: BEGIN
4699: IF ((cz_pb_mgr.l_template_id_ref.COUNT > 0) AND(cz_pb_mgr.v_session_parameter <> model_copy) AND(cz_pb_mgr.v_status_code <> PUBLICATION_ERROR))
4700: THEN
4701:
4702: IF (CZ_PB_MGR.v_session_parameter = cz_model_migration_pvt.migrate_model)
4703: THEN
4704: l_ui_def_id := 0;
4705: ELSE
4706: l_ui_def_id := 1;
4742: END IF;
4743:
4744: COMMIT;
4745:
4746: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model AND cz_pb_mgr.g_ui_templates_old_temp_id_ref.COUNT > 0)
4747: THEN
4748: -- array already has the new ids
4749: -- resolve_ids(cz_pb_mgr.g_ui_templates_new_temp_id_ref, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'resolve global templates');
4750:
4761: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
4762: ,cz_pb_mgr.v_oraclesequenceincr
4763: );
4764:
4765: -- IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
4766: create_uit_publication(cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)
4767: ,cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)
4768: ,g_source_flag
4769: ,' '
4901: ,'cz_pb_mgr.g_ui_templates_ui_def_old_ref'
4902: ,cz_pb_mgr.g_ui_templates_old_temp_id_ref
4903: ,cz_pb_mgr.g_ui_templates_ui_def_old_ref
4904: );
4905: IF(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
4906: refresh_global_templates(cz_pb_mgr.g_ui_templates_old_temp_id_ref);
4907: END IF;
4908:
4909: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
4905: IF(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
4906: refresh_global_templates(cz_pb_mgr.g_ui_templates_old_temp_id_ref);
4907: END IF;
4908:
4909: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
4910: ----------begin insert into cz_rp_entries----------------
4911: plsql_table_list.DELETE;
4912: rec_count := 1;
4913: plsql_table_list(rec_count).col_name := 'object_id';
4996: l_cnt_typ_tmpls_uidef_tbl.DELETE;
4997: l_cnt_typ_tmpls_cont_tbl.DELETE;
4998: l_cnt_typ_tmpls_tgtuidef_tbl.DELETE;
4999:
5000: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
5001: THEN
5002: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5003: BULK COLLECT INTO l_cnt_typ_tmpls_uidef_tbl, l_cnt_typ_tmpls_tmpid_tbl, l_cnt_typ_tmpls_tgtuidef_tbl, l_cnt_typ_tmpls_cont_tbl
5004: FROM cz_ui_cont_type_templs
5592:
5593: -- A master template carries its own set of content templates
5594: -- need to resolved everything and insert separately for master templates
5595: -- for local migration, cz_pb_mgr.v_new_mt_id_tbl should be empty
5596: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_new_mt_id_tbl.COUNT > 0)
5597: THEN
5598: --collect content templates
5599: bulk_collect_cont_type_templs(cz_pb_mgr.v_mt_old_id_tbl);
5600: --resolve template ids
5756: ,cz_pb_mgr.g_ui_actns_ui_act_id_old_ref
5757: ,cz_pb_mgr.g_ui_actns_ui_uidef_old_ref
5758: );
5759:
5760: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
5761: THEN
5762: refresh_ui_actions(cz_pb_mgr.g_ui_actns_ui_uidef_old_ref);
5763: END IF;
5764:
5763: END IF;
5764:
5765: ------bulk collect ui images for Master templates
5766: -- for local migration, cz_pb_mgr.v_new_mt_id_tbl should be empty
5767: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_new_mt_id_tbl.COUNT > 0)
5768: THEN
5769: bulk_collect_ui_images(cz_pb_mgr.v_mt_old_id_tbl);
5770: resolve_ids(cz_pb_mgr.v_ui_images_ui_tbl,cz_pb_mgr.v_ui_images_ui_ref, cz_pb_mgr.v_mt_old_to_new_id, 'ui def ids of mt ui images');
5771: plsql_table_list.DELETE;
6875: ,x_last_xfr_activity IN OUT NOCOPY DATE
6876: )
6877: AS
6878: BEGIN
6879: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
6880: THEN
6881: SELECT last_xfr_activity
6882: INTO x_last_xfr_activity
6883: FROM cz_pb_model_exports
6891: SELECT publication_id
6892: FROM cz_model_publications
6893: WHERE export_status IN('OK', 'PUP')
6894: AND server_id = p_server_id
6895: AND publication_mode = cz_model_migration_pvt.mode_migration));
6896: ELSE
6897: SELECT last_xfr_activity
6898: INTO x_last_xfr_activity
6899: FROM cz_pb_model_exports
6907: SELECT publication_id
6908: FROM cz_model_publications
6909: WHERE export_status IN('OK', 'PUP')
6910: AND server_id = p_server_id
6911: AND publication_mode <> cz_model_migration_pvt.mode_migration));
6912: END IF;
6913: EXCEPTION
6914: WHEN OTHERS
6915: THEN
7824: IS
7825: l_last_update_date DATE;
7826: l_prev_date DATE := cz_utils.epoch_begin;
7827: rec_count NUMBER := 0;
7828: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
7829: BEGIN
7830: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
7831: THEN
7832: l_pub_mode := cz_model_migration_pvt.mode_migration;
7826: l_prev_date DATE := cz_utils.epoch_begin;
7827: rec_count NUMBER := 0;
7828: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
7829: BEGIN
7830: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
7831: THEN
7832: l_pub_mode := cz_model_migration_pvt.mode_migration;
7833: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
7834: THEN
7828: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
7829: BEGIN
7830: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
7831: THEN
7832: l_pub_mode := cz_model_migration_pvt.mode_migration;
7833: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
7834: THEN
7835: l_pub_mode := cz_model_migration_pvt.mode_copy;
7836: END IF;
7831: THEN
7832: l_pub_mode := cz_model_migration_pvt.mode_migration;
7833: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
7834: THEN
7835: l_pub_mode := cz_model_migration_pvt.mode_copy;
7836: END IF;
7837:
7838: x_last_xfr_activity := cz_utils.epoch_begin;
7839:
7967: FOR j IN l_ui_actns_ui_act_id_tbl.FIRST .. l_ui_actns_ui_act_id_tbl.LAST
7968: LOOP
7969: rec_count := rec_count + 1;
7970:
7971: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0) THEN
7972: cz_pb_mgr.g_ui_actns_ui_act_id_ref(rec_count) := l_ui_actns_ui_act_new_id_tbl(j);
7973: cz_pb_mgr.g_ui_actions_id_idx_ref(l_ui_actns_ui_act_id_tbl(j)):=l_ui_actns_ui_act_new_id_tbl(j);
7974: ELSE
7975: cz_pb_mgr.g_ui_actns_ui_act_id_ref(rec_count) := l_ui_actns_ui_act_id_tbl(j);
8006: IF l_text_count > 0 THEN
8007: insert_intl_texts(l_text_tbl, 'global texts from ui actions', TRUE);
8008: END IF;
8009:
8010: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
8011:
8012: --The resolution moved here from insert_template_elements.
8013: BEGIN
8014: p_elem_id_tbl(i) := cz_pb_mgr.g_ui_actions_id_idx_ref(p_elem_id_tbl(i));
8399: --which is called from here.
8400: --For publishing, this code gets executed right in the beginning(when all the tables are empty
8401: --anyway), and seems redundant. But for the risk of introducing regressions, we
8402: --will execute this only for publishing.
8403: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
8404: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
8405: END IF;
8406:
8407: cz_pb_mgr.g_ui_templates_old_temp_id_ref.DELETE;
8509:
8510: FOR i IN l_new_tmpl_tbl.FIRST .. l_new_tmpl_tbl.LAST LOOP
8511: FOR j IN (SELECT * FROM cz_ui_templates
8512: WHERE template_id = l_new_tmpl_tbl(i) AND ui_def_id = '0' AND deleted_flag = '0') LOOP
8513: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model THEN
8514: -- The synch check will be performed here
8515: -- The template name will be checked over the link
8516: -- If the the template does not exists, then we will be using the new template that is created
8517: l_template_name := NULL;
8573: -- these two arrays are used in replace_extends()
8574: -- This part shoul be executed in the loop for already published/migrated templates
8575: -- but current code has a mny problems in this area ( checking for ui templates
8576: -- which need to be published/migrated
8577: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND l_template_name IS NOT NULL THEN
8578: l_rec_count := l_rec_count + 1;
8579: cz_pb_mgr.g_ui_templates_jrad_old_ref(l_rec_count) := j.jrad_doc;
8580: cz_pb_mgr.g_ui_templates_jrad_new_ref(l_rec_count) := REPLACE(j.jrad_doc,TO_CHAR(j.template_id),TO_CHAR(l_template_id));
8581: END IF;
9043: IF ((x_status <> PUBLICATION_ERROR) AND (cz_pb_mgr.v_session_parameter <> model_copy)) THEN
9044: IF cz_pb_mgr.v_cz_ps_nodes_idx_tbl.EXISTS(p_model_id) THEN
9045: x_remote_model_id := cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id);
9046: ELSE
9047: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model THEN
9048: IF p_server_id=0 THEN
9049: SELECT remote_model_id INTO x_remote_model_id
9050: FROM cz_pb_model_exports
9051: WHERE export_id=(SELECT max(export_id)
9084: || 'AND cz_pb_model_exports.model_id = :5'
9085: || ' '
9086: || 'AND cz_pb_model_exports.status = ''OK'''
9087: INTO x_remote_model_id
9088: USING p_server_id, p_server_id, p_model_id, cz_model_migration_pvt.change_flag_unchanged, p_model_id;
9089: END IF;
9090: ELSE
9091: SELECT cz_pb_model_exports.remote_model_id
9092: INTO x_remote_model_id
9151: BEGIN
9152: cz_pb_mgr.v_models_to_be_exported.DELETE;
9153: cz_pb_mgr.v_models_not_to_be_exported.DELETE;
9154:
9155: IF (cz_pb_mgr.v_session_parameter IN(pub_model, cz_model_migration_pvt.migrate_model))
9156: THEN
9157: OPEN model_cur(rootmodelid);
9158:
9159: /* Bug 5523268
9162: * if there is a change in the UI of child models, pick that up
9163: * as well;
9164: */
9165:
9166: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
9167: THEN
9168: child_model_ui_has_changed :=has_ui_inany_chld_mdl_changed(rootmodelid);
9169: END IF;
9170:
9187:
9188: EXIT WHEN model_cur%NOTFOUND;
9189: v_count := 0;
9190:
9191: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
9192: IF cz_pb_mgr.v_server_id = 0 THEN
9193: SELECT COUNT(*) INTO v_count
9194: FROM cz_pb_model_exports
9195: WHERE model_id=v_model_id AND status=publication_ok AND server_id=0
9212: || 'AND farprj.post_migr_change_flag = :4'
9213: || ' '
9214: || 'AND x.migration_group_id IS NOT NULL'
9215: INTO v_count
9216: USING v_model_id, publication_ok, cz_pb_mgr.v_server_id, cz_model_migration_pvt.change_flag_unchanged;
9217: END IF;
9218: ELSE
9219: SELECT COUNT(*)
9220: INTO v_count
9289: IF l_max_ui_date IS NOT NULL AND l_max_ui_date > v_expr_last_update THEN
9290: v_expr_last_update := l_max_ui_date;
9291: END IF;
9292:
9293: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
9294: IF cz_pb_mgr.v_server_id = 0 THEN
9295: SELECT COUNT(*) INTO v_count
9296: FROM cz_devl_projects x, cz_pb_model_exports y
9297: WHERE x.devl_project_id = y.model_id
9321: || 'AND farprj.post_migr_change_flag = :4'
9322: || ' '
9323: || 'AND y.migration_group_id IS NOT NULL AND y.status = :5'
9324: INTO v_count
9325: USING v_expr_last_update, v_model_id, cz_pb_mgr.v_server_id, cz_model_migration_pvt.change_flag_unchanged, publication_ok;
9326: END IF;
9327: ELSE
9328: SELECT COUNT(*)
9329: INTO v_count
9619: FOR r IN v_cz_eff_sets_new_ref.FIRST .. v_cz_eff_sets_new_ref.LAST
9620: LOOP
9621: IF (v_cz_eff_sets_new_ref(r) IS NOT NULL)
9622: THEN
9623: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
9624: THEN
9625: l_eff_set_new_id := mm_sync_eff_sets(v_cz_eff_sets_old_ref(r), v_cz_eff_sets_new_ref(r));
9626:
9627: IF ((l_eff_set_new_id IS NULL) AND(NOT v_cz_eff_sets_idx_tbl.EXISTS(v_cz_eff_sets_old_ref(r))))
9664: ,p_old_key_name
9665: ,p_eff_sets_old_key
9666: );
9667:
9668: IF (p_eff_sets_new_key.COUNT > 0 AND cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
9669: THEN
9670: ----------begin insert into cz_rp_entries----------------
9671: plsql_table_list.DELETE;
9672: rec_count := 1;
9736:
9737: v_verify_model_msg_ref verify_model_message_list;
9738: BEGIN
9739: -------no synchronization required if published locally
9740: IF ((p_server_id <> 0) AND(g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
9741: )
9742: THEN
9743: -----call to this procedure made to determine if the model being published
9744: -----contains a BOM
10955: )
10956: )
10957: THEN
10958: BEGIN
10959: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
10960: THEN
10961: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
10962: || cz_pb_mgr.v_db_link
10963: || ' '
11319: v_devl_project_id := p_models_not_exported(i);
11320: get_remote_model_id(p_server_id,v_devl_project_id,x_status,v_remote_devl_project_id);
11321:
11322: -- For each of these source models, get all the UIs
11323: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0) THEN
11324: SELECT ui_def_id BULK COLLECT INTO v_ui_defs_tbl
11325: FROM cz_ui_defs
11326: WHERE deleted_flag='0' AND devl_project_id=v_devl_project_id AND ui_style=g_ui_style_jrad;
11327: ELSE
12174: END IF;
12175: END LOOP;
12176:
12177: IF (rec_count > 0 AND (cz_pb_mgr.v_session_parameter = MODEL_COPY OR
12178: cz_pb_mgr.v_session_parameter = CZ_MODEL_MIGRATION_PVT.MIGRATE_MODEL)) THEN
12179: FOR j IN p_rules_old_array.FIRST .. p_rules_old_array.LAST
12180: LOOP
12181: BEGIN
12182: SELECT object_type INTO l_object_type
13471: log_timing_message('start eff sets of ps nodes');
13472: END IF;
13473:
13474: -- resolve effective usage mask for rules
13475: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
13476: THEN
13477: resolve_effective_usage_mask(cz_pb_mgr.v_cz_rules_rule_id_old_ref, 1);
13478: END IF;
13479:
13567: ------------Resolving component -ids of ps_nodes
13568: resolve_ids(cz_pb_mgr.v_cz_ps_nodes_comp_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz ps nodes', FLD_PSN_REFERENCE_ID);
13569:
13570: -- resolve effective usage mask for ps nodes.
13571: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
13572: THEN
13573: resolve_effective_usage_mask(cz_pb_mgr.v_cz_ps_nodes_old_tbl, 0);
13574: END IF;
13575:
13622: rec_count := rec_count + 1;
13623: plsql_table_list(rec_count).col_name := 'reverse_connector_id';
13624: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ps_reverse_connector_tbl';
13625:
13626: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
13627: THEN
13628: rec_count := rec_count + 1;
13629: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_eff_usg_msk_tbl';
13630: plsql_table_list(rec_count).col_name := 'effective_usage_mask';
13883: log_timing_message('end resolve_virtual_components');
13884: END IF;
13885:
13886: -------get func comp spec by expl id
13887: IF (cz_pb_mgr.v_session_parameter IN(pub_model, cz_model_migration_pvt.migrate_model))
13888: THEN
13889: collect_func_comp_specs;
13890: ELSIF(cz_pb_mgr.v_session_parameter = model_copy)
13891: THEN
14186: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
14187:
14188: IF (p_models_for_export.COUNT > 0) THEN
14189: -- not copy non-jrad ui in any conversion session or in a copy session flagged by p_copy_nonjradui
14190: IF NOT (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 OR
14191: cz_pb_mgr.v_session_parameter=model_copy AND NOT p_copy_nonjradui) THEN
14192: get_source_uis(cz_pb_mgr.v_root_model_id, p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref);
14193: END IF;
14194: get_oa_uis(p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref, cz_pb_mgr.v_cz_ui_defs_old_oa_ref);
14195:
14196: --get_oa_tmpls is also called from has_to_be_published.
14197: --However, for model migration, has_to_be_published
14198: --is not called. So make the call to get_oa_tmpls here.
14199: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0 THEN
14200: get_oa_tmpls;
14201: END IF;
14202:
14203: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
14337:
14338: resolve_ids(cz_pb_mgr.v_ui_defs_mcpt_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'menu caption rule ids of ui defs');
14339: resolve_ids(cz_pb_mgr.v_ui_defs_pcpt_rule_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'page caption rule ids of ui defs');
14340:
14341: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
14342: THEN
14343: synch_master_template;
14344: resolve_ids(cz_pb_mgr.v_master_template_id_ref, cz_pb_mgr.v_mt_old_to_new_id, 'from_master_template_id of uidef', ENTITY_TYPE_UMT);
14345: END IF;
14367: THEN
14368: log_timing_message('start insert_into_table cz_ui_defs');
14369: END IF;
14370:
14371: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
14372: THEN
14373: rec_count := rec_count + 1;
14374: plsql_table_list(rec_count).col_name := 'from_master_template_id';
14375: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_master_template_id_ref';
14790: log_timing_message('start resolve prop num value');
14791: END IF;
14792:
14793: IF (cz_pb_mgr.v_prop_vals_data_num_ref.COUNT > 0 AND
14794: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0)) THEN
14795: FOR intltext IN cz_pb_mgr.v_prop_vals_data_num_ref.FIRST .. cz_pb_mgr.v_prop_vals_data_num_ref.LAST
14796: LOOP
14797: IF cz_pb_mgr.v_prop_vals_data_typ_ref(intltext) = 8 AND
14798: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR
14794: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0)) THEN
14795: FOR intltext IN cz_pb_mgr.v_prop_vals_data_num_ref.FIRST .. cz_pb_mgr.v_prop_vals_data_num_ref.LAST
14796: LOOP
14797: IF cz_pb_mgr.v_prop_vals_data_typ_ref(intltext) = 8 AND
14798: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR
14799: cz_pb_mgr.v_prop_vals_valuesource_ref(intltext) = 'PsValue') THEN
14800: rec_count := rec_count + 1;
14801: cz_pb_mgr.v_prop_vals_intl_text_ref(rec_count) := cz_pb_mgr.v_prop_vals_data_num_ref(intltext);
14802: END IF;
14834: FOR intltext IN cz_pb_mgr.v_prop_vals_data_num_ref.FIRST .. cz_pb_mgr.v_prop_vals_data_num_ref.LAST
14835: LOOP
14836: IF cz_pb_mgr.v_prop_vals_data_typ_ref(intltext) = 8 AND
14837: cz_pb_mgr.v_prop_vals_data_num_ref(intltext) IS NOT NULL AND
14838: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR
14839: cz_pb_mgr.v_prop_vals_valuesource_ref(intltext) = 'PsValue') THEN
14840: cz_pb_mgr.v_prop_vals_data_num_ref(intltext) := cz_pb_mgr.v_cz_intl_text_idx_ref(cz_pb_mgr.v_prop_vals_data_num_ref(intltext));
14841: END IF;
14842: END LOOP;
14855:
14856: -- If this is remote model migration, we need to synchronize the properties before
14857: -- we insert into the target machine
14858: -- that will be done as part of insert item schema
14859: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0) THEN
14860: ------insert into cz_ps_prop_vals
14861: IF cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model THEN
14862: insert_into_ps_prop_vals;
14863: ELSE
14857: -- we insert into the target machine
14858: -- that will be done as part of insert item schema
14859: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0) THEN
14860: ------insert into cz_ps_prop_vals
14861: IF cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model THEN
14862: insert_into_ps_prop_vals;
14863: ELSE
14864: mc_insert_pspropvals;
14865: END IF;
14880: insert_item_schema;
14881:
14882: -- if model migration, the tables were not cleared before,
14883: -- they are being taken care of at this stage
14884: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
14885: THEN
14886: ---------release pl/sql tables
14887: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
14888: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
14888: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
14889: END IF;
14890:
14891: ----------refresh model usages
14892: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
14893: THEN
14894: load_usages;
14895: END IF;
14896:
15039: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_sig_ref';
15040: rec_count := rec_count + 1;
15041: plsql_table_list(rec_count).col_name := 'ui_def_id';
15042: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_ui_ref';
15043: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
15044: rec_count := rec_count + 1;
15045: plsql_table_list(rec_count).col_name := 'effective_usage_mask';
15046: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_rul_usg_msk_tbl';
15047: rec_count := rec_count + 1;
15186: END LOOP;
15187: END IF;
15188: END LOOP;
15189:
15190: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
15191: THEN
15192: mm_sync_archives;
15193: -- resolve the array to only those that need to be inserted
15194: END IF;
15192: mm_sync_archives;
15193: -- resolve the array to only those that need to be inserted
15194: END IF;
15195:
15196: IF (cz_pb_mgr.v_session_parameter <> model_copy AND cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
15197: THEN
15198: resolve_ids(cz_pb_mgr.g_archive_id_old_ref,cz_pb_mgr.g_archive_id_ref, cz_pb_mgr.g_archives_idx_ref, 'resolve archive id of archives');
15199:
15200: ELSE
15205: cz_pb_mgr.g_archive_id_ref(rec_count):=cz_pb_mgr.g_archive_id_old_ref(i);
15206: END LOOP;
15207: END IF;
15208:
15209: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
15210: THEN
15211: mm_insert_archives;
15212: ELSE
15213: mm_insert_archives_for_pb;
15239: rec_pop_count NUMBER := 0;
15240: rec_count PLS_INTEGER := 0;
15241: plsql_table_list cz_pb_mgr.col_plsql_table_list;
15242: BEGIN
15243: IF ((cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model)) AND(cz_pb_mgr.v_models_to_be_exported.COUNT > 0))
15244: THEN
15245: cz_pb_mgr.v_filter_sets_new_id_ref.DELETE;
15246: cz_pb_mgr.v_filter_sets_id_ref.DELETE;
15247: cz_pb_mgr.v_filter_sets_devl_ref.DELETE;
15774: LOOP
15775: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
15776:
15777: BEGIN
15778: IF (cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model))
15779: THEN
15780: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
15781: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
15782: ,cz_pb_mgr.v_oraclesequenceincr
15835: cz_pb_mgr.v_cz_enodes_rule_id_ref(rec_count) := cz_pb_mgr.v_cz_enodes_rule_id_tbl(i);
15836: cz_pb_mgr.v_cz_enodes_arg_sig_id_ref(rec_count) := cz_pb_mgr.v_cz_enodes_arg_sig_id_tbl(i);
15837: cz_pb_mgr.v_cz_enodes_par_sig_id_ref(rec_count) := cz_pb_mgr.v_cz_enodes_par_sig_id_tbl(i);
15838:
15839: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model)
15840: THEN
15841: cz_pb_mgr.v_cz_enodes_prop_id_ref(rec_count):=cz_pb_mgr.v_cz_enodes_prop_id_tbl(i);
15842: END IF;
15843:
15872: -------resolve sig ids
15873: resolve_ids(cz_pb_mgr.v_cz_enodes_arg_sig_id_ref, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz expr nodes', ENTITY_TYPE_SIGNATURE);
15874: resolve_ids(cz_pb_mgr.v_cz_enodes_par_sig_id_ref, cz_pb_mgr.v_sig_idx_ref, 'param sig ids cz expr nodes', ENTITY_TYPE_SIGNATURE);
15875:
15876: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15877: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.ps_node_id');
15878: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');
15879: resolve_ids(cz_pb_mgr.v_cz_enodes_prop_id_ref, cz_pb_mgr.mm_v_ht_sync_all_prop, 'property id of cz expr nodes', ENTITY_TYPE_PROPERTY);
15880: ELSE
15907: rec_count := rec_count + 1;
15908: plsql_table_list(rec_count).col_name := 'param_signature_id';
15909: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_par_sig_id_ref';
15910:
15911: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model)
15912: THEN
15913: rec_count := rec_count + 1;
15914: plsql_table_list(rec_count).col_name := 'property_id';
15915: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_prop_id_ref';
15979: END IF;
15980: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
15981: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
15982:
15983: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15984: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.feature_id');
15985: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');
15986: ELSE
15987: resolve_ids(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'feature id of cz_des_features',FLD_IGNORE_NOW);
16053:
16054: resolve_ids(cz_pb_mgr.v_cz_des_cells_rule_id_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart cells');
16055: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);
16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
16059: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_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_opt_id');
16060: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
16061: ELSE
16070: --during model migration, if a rule_seq has a rule whose effectivity_set_id already
16071: --exists on the target, then set the rule effectivity to be
16072: --never effective for all the rules in that rule sequence
16073: --do this only if there is something to resolve(mm_v_ht_eff_set_tbl_t.COUNT >0)
16074: IF ( (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
16075: AND (mm_v_tbl_rule_seq.COUNT > 0)
16076: AND (mm_v_ht_eff_set_tbl_t.COUNT > 0)
16077: )
16078: THEN
16584: END LOOP;
16585: END IF;
16586:
16587: -- The copy of item type props and item prop values is uncessary for publication (4861805)
16588: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
16589: --~> Item type properties
16590: IF (cz_pb_mgr.v_item_types_new_ref.COUNT > 0)
16591: THEN
16592: cz_pb_mgr.v_item_prop_id_tbl.DELETE;
16687: --bom model.
16688:
16689: --The bug is deferred.
16690: /*
16691: IF(cz_pb_mgr.bomsynch_flag = 'N' AND cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)THEN
16692:
16693: FOR i IN 1..v_item_masters_tbl.COUNT LOOP
16694:
16695: IF(mm_v_itmst_src_app_id_ref(i) = 401)THEN
16707: END LOOP;
16708: END IF;
16709: */
16710: --Now run the upfront validations for model migration.
16711: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
16712: THEN
16713: mm_raiseallpossiblesyncerrors;
16714: END IF;
16715: END;
16771: read_item_schema;
16772: END IF;
16773:
16774: --------upload item sub-schema
16775: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
16776: THEN
16777: IF (cz_pb_mgr.g_log_timing = publication_timing)
16778: THEN
16779: log_timing_message('start upload_item_schema');
16790: END IF;
16791: END IF;
16792:
16793: ------export product structure
16794: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
16795: THEN
16796: IF (cz_pb_mgr.g_log_timing = publication_timing)
16797: THEN
16798: log_timing_message('start upload_ps_structure');
16819: log_timing_message('end upload_ui_schema');
16820: END IF;
16821:
16822: ------upload rule schema
16823: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
16824: THEN
16825: IF (cz_pb_mgr.g_log_timing = publication_timing)
16826: THEN
16827: log_timing_message('start upload_rule_schema');
17158: THEN
17159: log_timing_message('start get_models_tobe_exported');
17160: END IF;
17161:
17162: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
17163: THEN
17164: mm_models_to_be_migrated := get_rootmodel_and_mig_tgt_fldr(publicationid);
17165: mm_get_models_tobe_exported(mm_models_to_be_migrated);
17166: ELSIF(g_object_type = MODEL_PUBLICATION)
17196: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:EXPREQ', SQLCODE);
17197: END IF;
17198:
17199: -----create_copy_requests;
17200: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
17201: THEN
17202: cz_pb_mgr.v_models_to_be_exported.DELETE;
17203:
17204: IF (cz_pb_mgr.g_log_timing = publication_timing)
17263: export_global_template(modelid, publicationid);
17264: END IF;
17265:
17266: -----upload publication data
17267: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
17268: THEN
17269: upload_publication_data(cz_pb_mgr.v_publication_id);
17270: END IF;
17271:
17596:
17597: cz_pb_mgr.v_server_id := p_server_id;
17598: -------set session level parameter that differentiates from publishing
17599: cz_pb_mgr.v_session_parameter := model_copy;
17600: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
17601: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
17602: ---------check if model exists
17603: v_model_chk_count := 0;
17604:
17597: cz_pb_mgr.v_server_id := p_server_id;
17598: -------set session level parameter that differentiates from publishing
17599: cz_pb_mgr.v_session_parameter := model_copy;
17600: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
17601: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
17602: ---------check if model exists
17603: v_model_chk_count := 0;
17604:
17605: BEGIN
18252: cz_pb_mgr.v_pb_run_id := 0.0;
18253: cz_pb_mgr.bomsynch_flag := 'N';
18254: cz_pb_mgr.v_status_code := publication_ok;
18255: cz_pb_mgr.v_session_parameter := pub_model;
18256: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
18257: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
18258: cz_pb_mgr.v_cz_model_pub_old_id := p_publication_id;
18259: cz_pb_mgr.v_cz_model_pub_new_id := NULL;
18260: cz_pb_mgr.v_ui_name := NULL;
18253: cz_pb_mgr.bomsynch_flag := 'N';
18254: cz_pb_mgr.v_status_code := publication_ok;
18255: cz_pb_mgr.v_session_parameter := pub_model;
18256: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
18257: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
18258: cz_pb_mgr.v_cz_model_pub_old_id := p_publication_id;
18259: cz_pb_mgr.v_cz_model_pub_new_id := NULL;
18260: cz_pb_mgr.v_ui_name := NULL;
18261: cz_pb_mgr.v_sql_err_msg := 'Fatal error reported';
18265: INTO l_pub_mode
18266: FROM cz_model_publications
18267: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted;
18268:
18269: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
18270: THEN
18271: cz_pb_mgr.v_session_parameter := cz_model_migration_pvt.migrate_model;
18272: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
18273: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
18267: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted;
18268:
18269: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
18270: THEN
18271: cz_pb_mgr.v_session_parameter := cz_model_migration_pvt.migrate_model;
18272: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
18273: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
18274: END IF;
18275:
18268:
18269: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
18270: THEN
18271: cz_pb_mgr.v_session_parameter := cz_model_migration_pvt.migrate_model;
18272: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
18273: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
18274: END IF;
18275:
18276: ---------select run_id and user from dual
18269: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
18270: THEN
18271: cz_pb_mgr.v_session_parameter := cz_model_migration_pvt.migrate_model;
18272: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
18273: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
18274: END IF;
18275:
18276: ---------select run_id and user from dual
18277: BEGIN
18659:
18660: l_ui_upto_date := TRUE;
18661:
18662: IF uidefid IS NULL THEN
18663: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
18664: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
18665: FROM cz_ui_defs
18666: WHERE deleted_flag='0' AND ui_style=g_ui_style_jrad AND devl_project_id IN
18667: (SELECT component_id FROM cz_model_ref_expls
18781: END;
18782:
18783: IF (original_name IS NOT NULL)
18784: THEN
18785: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
18786: v_name := SUBSTR (original_name|| '-[FCE]', 1, 235);
18787:
18788: ELSE
18789: v_name :=
18794: || REPLACE(cz_developer_utils_pvt.get_repository_path(p_devl_project_id, 'PRJ'), '/', '.'), 1, 235);
18795: -- Bug 5514199; 12-Sep-2006; kdande; Taking 235 chars only as other characters would be appended at runtime like copy x, rules etc
18796: END IF;
18797:
18798: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
18799: l_endBr:='';
18800: ELSE
18801: l_endBr:=')';
18802: END IF;
18964: RAISE not_global_template;
18965: END IF;
18966: ELSIF(g_object_type = MODEL_PUBLICATION) THEN
18967: check_model_ui_exist(publicationid, cz_pb_mgr.v_root_model_id, cz_pb_mgr.v_root_ui_def_id, cz_pb_mgr.v_status_code);
18968: ELSIF(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
18969: RAISE invalid_object_type;
18970: END IF;
18971:
18972: check_export_status(v_cur_export_status, cz_publish, cz_pb_mgr.v_status_code);
18979: cz_pb_mgr.v_db_link := retrieve_db_link(cz_pb_mgr.v_server_id);
18980:
18981: -----check for source server flag on the target instance
18982: IF (cz_pb_mgr.v_server_id <> 0) THEN
18983: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
18984: cz_pb_sync_util.verify_mig_tgt_server(cz_pb_mgr.v_db_link, l_tgt_status, l_tgt_msg);
18985: ELSE
18986: cz_pb_sync_util.verify_tgt_server(cz_pb_mgr.v_db_link, l_tgt_status, l_tgt_msg);
18987: END IF;
18994: END IF;
18995:
18996: l_target_imp_server_on_local := cz_pb_mgr.v_server_id;
18997:
18998: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
18999:
19000: ----check for remote publication id on the target instance
19001:
19002: remote_pb_check(cz_pb_mgr.remote_publication_id);
19022: log_timing_message('start has_tobe_published');
19023: END IF;
19024:
19025: ----check if the publication has to be published
19026: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
19027: v_check_publication := has_tobe_published(publicationid);
19028: ELSE
19029: v_check_publication := TRUE;
19030: ---for publishing, rules related tables are cleared in get_oa_tmpls
19074: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
19075: log_timing_message('start verify_model_for_sync');
19076: END IF;
19077:
19078: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
19079: verify_model_for_sync(l_target_imp_server_on_local, cz_pb_mgr.v_root_model_id);
19080: END IF;
19081:
19082: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
19099: --and insert into CZ_PERSISTENT_REC_IDS with its value, report the migrated and not migrated models.
19100: --------------------------------------------------------------------------------------------
19101:
19102: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) THEN
19103: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
19104: EXECUTE IMMEDIATE 'SELECT REPLACE(cz_developer_utils_pvt.get_repository_path'
19105: || cz_pb_mgr.v_db_link
19106: || '(:1, ''FLD''), ''/'', ''.'') FROM DUAL'
19107: INTO l_tgt_fld_path
19213: || ' t'
19214: || ' '
19215: || 'SET t.name = cz_pb_mgr.v_rp_name'
19216: || ', post_migr_change_flag = '''
19217: || cz_model_migration_pvt.change_flag_unchanged
19218: || ''' '
19219: || 'WHERE t.devl_project_id = '
19220: || cz_pb_mgr.v_new_object_id
19221: || ';'
19781: no_link_name EXCEPTION;
19782: invalid_object_type EXCEPTION;
19783: template_in_use EXCEPTION;
19784: cannot_del_pup EXCEPTION;
19785: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
19786: BEGIN
19787: fnd_msg_pub.initialize;
19788: x_return_status := FND_API.G_RET_STS_SUCCESS;
19789: x_msg_count := 0;
19789: x_msg_count := 0;
19790: x_msg_data := '';
19791: fnd_msg_pub.initialize;
19792:
19793: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
19794: THEN
19795: l_pub_mode := cz_model_migration_pvt.mode_migration;
19796: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
19797: THEN
19791: fnd_msg_pub.initialize;
19792:
19793: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
19794: THEN
19795: l_pub_mode := cz_model_migration_pvt.mode_migration;
19796: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
19797: THEN
19798: l_pub_mode := cz_model_migration_pvt.mode_copy;
19799: END IF;
19794: THEN
19795: l_pub_mode := cz_model_migration_pvt.mode_migration;
19796: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
19797: THEN
19798: l_pub_mode := cz_model_migration_pvt.mode_copy;
19799: END IF;
19800:
19801: SELECT server_id, export_status, remote_publication_id, object_type
19802: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
19808: --if the target has been converted into a development instance
19809:
19810: IF (v_export_status <> model_publication_obselete) THEN
19811:
19812: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
19813: --it is possible that the obsoleting process changed value of the publication record.
19814: --so requery
19815: SELECT server_id, export_status, remote_publication_id, object_type
19816: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
19985: fnd_msg_pub.initialize;
19986: --execute the procedure that obsoletes the records
19987: --if the target has been converted into a development
19988: --instance
19989: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
19990:
19991: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
19992: THEN
19993: RAISE pub_maybe_obsoleted;
20360: v_language_id_tbl.DELETE;
20361: --execute the procedure that obsoletes the records
20362: --if the target has been converted into a development
20363: --instance
20364: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
20365:
20366: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
20367: THEN
20368: RAISE pub_maybe_obsoleted;
20483: fnd_msg_pub.initialize;
20484: --execute the procedure that obsoletes the records
20485: --if the target has been converted into a development
20486: --instance
20487: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
20488:
20489: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
20490: THEN
20491: RAISE pub_maybe_obsoleted;
20604: v_language_id_tbl.DELETE;
20605: --execute the procedure that obsoletes the records
20606: --if the target has been converted into a development
20607: --instance
20608: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
20609:
20610: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
20611: THEN
20612: RAISE pub_maybe_obsoleted;
20940: PROCEDURE reset_processing_pubs
20941: IS
20942: v_link_name cz_servers.fndnam_link_name%TYPE;
20943: v_db_link VARCHAR2(255);
20944: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20945: BEGIN
20946: fnd_msg_pub.initialize;
20947:
20948: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
20944: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20945: BEGIN
20946: fnd_msg_pub.initialize;
20947:
20948: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
20949: THEN
20950: l_pub_mode := cz_model_migration_pvt.mode_migration;
20951: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
20952: THEN
20946: fnd_msg_pub.initialize;
20947:
20948: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
20949: THEN
20950: l_pub_mode := cz_model_migration_pvt.mode_migration;
20951: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
20952: THEN
20953: l_pub_mode := cz_model_migration_pvt.mode_copy;
20954: END IF;
20949: THEN
20950: l_pub_mode := cz_model_migration_pvt.mode_migration;
20951: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
20952: THEN
20953: l_pub_mode := cz_model_migration_pvt.mode_copy;
20954: END IF;
20955:
20956: FOR i IN (SELECT publication_id, remote_publication_id, server_id
20957: FROM cz_model_publications
21146: fnd_msg_pub.initialize;
21147: --execute the procedure that obsoletes the records
21148: --if the target has been converted into a development
21149: --instance
21150: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21151:
21152: ----check status
21153: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21154: THEN
21158: ----get source pb info
21159: SELECT *
21160: INTO v_source_pb_record
21161: FROM cz_model_publications
21162: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted AND source_target_flag = cz_model_migration_pvt.pub_source_flag;
21163:
21164: ----check status
21165: IF (v_source_pb_record.export_status <> 'OK')
21166: THEN
21646: fnd_msg_pub.initialize;
21647: --execute the procedure that obsoletes the records
21648: --if the target has been converted into a development
21649: --instance
21650: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21651:
21652: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21653: THEN
21654: RAISE pub_maybe_obsoleted;
21967:
21968: IF (l_publication_mode IS NULL)
21969: THEN
21970: l_publication_mode := 'P';
21971: ELSIF(UPPER(l_publication_mode) NOT IN('P', 'T', cz_model_migration_pvt.mode_migration))
21972: THEN
21973: RAISE invalid_pb_mode;
21974: END IF;
21975:
21972: THEN
21973: RAISE invalid_pb_mode;
21974: END IF;
21975:
21976: IF (UPPER(l_publication_mode) = cz_model_migration_pvt.mode_migration)
21977: THEN
21978: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
21979: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
21980: ELSE
21974: END IF;
21975:
21976: IF (UPPER(l_publication_mode) = cz_model_migration_pvt.mode_migration)
21977: THEN
21978: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
21979: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
21980: ELSE
21981: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
21982: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
21975:
21976: IF (UPPER(l_publication_mode) = cz_model_migration_pvt.mode_migration)
21977: THEN
21978: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
21979: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
21980: ELSE
21981: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
21982: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
21983: END IF;
21977: THEN
21978: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
21979: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
21980: ELSE
21981: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
21982: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
21983: END IF;
21984:
21985: ----check that atleast one application id
21978: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
21979: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
21980: ELSE
21981: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
21982: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
21983: END IF;
21984:
21985: ----check that atleast one application id
21986: ----- is passed
22219: ------------------------------------------------------------------------------------------------
22220: --The current design for model migration will run
22221: --the publication process for every model that has been selected
22222: --to be migrated. The process of collecting the models is in
22223: --CZ_MODEL_MIGRATION_PVT. Once the models are collected there, for every
22224: --CZ_MODEL_PUBLICATIONS record, publish model is called. Given that,
22225: --this procedure gets the model for the current migration cz_model_publication
22226: --record.
22227:
23728: SELECT publication_id
23729: FROM cz_model_publications
23730: WHERE export_status IN('OK', 'PUP')
23731: AND server_id = p_server_id
23732: AND publication_mode = cz_model_migration_pvt.mode_migration));
23733:
23734: RETURN x_last_xfr_activity;
23735:
23736: