[Home] [Help]
976: resolved_array(j) := array_of_new_keys(array_to_resolve(j));
977: END IF;
978: EXCEPTION
979: WHEN NO_DATA_FOUND THEN
980: IF (array_to_resolve(j) = 0 AND(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)) THEN
981:
982: IF NOT(ui_templ_id_tbl(j)=0 OR ui_templ_id_tbl(j) IS NULL) THEN
983:
984: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES
1024: THEN
1025: IF ((p_array_to_resolve(i) = 0))
1026: THEN
1027: IF ( (NOT cz_pb_mgr.g_ui_templates_idx_temp_ref.EXISTS(p_templ_array(i)))
1028: OR (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1029: )
1030: THEN
1031: p_array_to_resolve(i) := 0;
1032: ELSE
1476: tmp_array_count NUMBER;
1477: BEGIN
1478: --All reading has been moved to load_data->read_item_schema.
1479:
1480: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1481: THEN
1482: mm_v_tbl_sync_prop_vals_num.DELETE;
1483: mm_v_tbl_prop_vals_trans_old.DELETE;
1484: mm_v_tbl_prop_vals_trans_new.DELETE;
1520: plsql_table_list(rec_count).col_name := 'item_type_id';
1521:
1522: -- sure if we need to maintain a table for orig_sys_ref, if needed, we need to maintain a sync table
1523: -- for model migration and then resolve them before updating
1524: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1525: THEN
1526: cz_pb_mgr.mm_insert_array1.DELETE;
1527: cz_pb_mgr.mm_insert_array2.DELETE;
1528: cz_pb_mgr.mm_insert_array3.DELETE;
1624: --ITEMS
1625: plsql_table_list.DELETE;
1626: rec_count := 1;
1627:
1628: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1629: THEN
1630: cz_pb_mgr.mm_insert_array1.DELETE;
1631: cz_pb_mgr.mm_insert_array2.DELETE;
1632: cz_pb_mgr.mm_insert_array3.DELETE;
1726: --PROPERTIES (with RP_ENTRIES if model migration)
1727: plsql_table_list.DELETE;
1728: rec_count := 1;
1729:
1730: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1731: THEN
1732: cz_pb_mgr.mm_insert_array1.DELETE;
1733: cz_pb_mgr.mm_insert_array2.DELETE;
1734: cz_pb_mgr.mm_objtype_array.DELETE;
1808: );
1809: END IF;
1810:
1811: --ITEM TYPE PROPERTIES
1812: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1813: THEN
1814: cz_pb_mgr.mm_insert_array1.DELETE;
1815: cz_pb_mgr.mm_insert_array2.DELETE;
1816: cz_pb_mgr.mm_insert_array3.DELETE;
1916: END;
1917: END IF;
1918:
1919: --ITEM PROPERTY VALUES
1920: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
1921: THEN
1922: cz_pb_mgr.mm_insert_array1.DELETE;
1923: cz_pb_mgr.mm_insert_array2.DELETE;
1924: cz_pb_mgr.mm_insert_array3.DELETE;
2906:
2907: FOR c IN p_intl_text_id_ref.FIRST .. p_intl_text_id_ref.LAST -- cz_pb_mgr.v_prop_vals_data_num_ref.LAST
2908: LOOP
2909: IF (cz_pb_mgr.v_prop_vals_data_typ_ref(c) = 8 AND
2910: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR
2911: cz_pb_mgr.v_prop_vals_valuesource_ref(c) = 'PsValue'))
2912: THEN
2913: v_cz_intl_text_new_tbl.DELETE;
2914: v_cz_intl_text_old_tbl.DELETE;
3045: plsql_table_list(rec_count).col_name := 'intl_text_id';
3046: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_intl_text_new_ref';
3047: rec_count := rec_count + 1;
3048:
3049: IF (p_from_template AND CZ_PB_MGR.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
3050: plsql_table_list(rec_count).col_name := 'persistent_intl_text_id';
3051: plsql_table_list(rec_count).table_name := 'CZ_PB_MGR.v_cz_intl_text_new_ref';
3052: rec_count := rec_count + 1;
3053: END IF;
3067: );
3068: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3069: -- log_timing_message('SPITRE rework After calling insert_into_table');
3070: --END IF;
3071: IF (CZ_PB_MGR.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
3072: update_mm_localized_texts;
3073: ELSE
3074: update_localized_texts;
3075: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3756: l_chunk_tbl(l_seq_nbr).xml_chunk := l_buffer;
3757: END IF;
3758: END LOOP;
3759:
3760: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
3761: IF (l_chunk_tbl.COUNT > 0) THEN
3762: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3763: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3764:
5182: l_persistent_element_id CZ_UI_TEMPLATE_ELEMENTS.persistent_element_id%TYPE := p_persistent_element_id;
5183:
5184: BEGIN
5185:
5186: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
5187: l_ui_def_id := 0;
5188: l_persistent_element_id := p_element_id;
5189: END IF;
5190:
5284: l_status NUMBER := 0;
5285: l_ref_cursor ref_cursor;
5286: l_src_pb_id cz_model_publications.publication_id%TYPE;
5287: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
5288: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
5289: BEGIN
5290: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
5291: THEN
5292: l_inst_str :=
5404: BEGIN
5405: 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))
5406: THEN
5407:
5408: IF (CZ_PB_MGR.v_session_parameter = cz_model_migration_pvt.migrate_model)
5409: THEN
5410: l_ui_def_id := 0;
5411: ELSE
5412: l_ui_def_id := 1;
5448: END IF;
5449:
5450: COMMIT;
5451:
5452: 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)
5453: THEN
5454: -- array already has the new ids
5455: -- resolve_ids(cz_pb_mgr.g_ui_templates_new_temp_id_ref, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'resolve global templates');
5456:
5467: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link
5468: ,cz_pb_mgr.v_oraclesequenceincr
5469: );
5470:
5471: -- IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
5472: create_uit_publication(cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)
5473: ,cz_pb_mgr.g_ui_templates_old_temp_id_ref(i)
5474: ,g_source_flag
5475: ,' '
5624: ,'cz_pb_mgr.g_ui_templates_ui_def_old_ref'
5625: ,cz_pb_mgr.g_ui_templates_old_temp_id_ref
5626: ,cz_pb_mgr.g_ui_templates_ui_def_old_ref
5627: );
5628: IF(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
5629: refresh_global_templates(cz_pb_mgr.g_ui_templates_old_temp_id_ref);
5630: END IF;
5631:
5632: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
5628: IF(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
5629: refresh_global_templates(cz_pb_mgr.g_ui_templates_old_temp_id_ref);
5630: END IF;
5631:
5632: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
5633: ----------begin insert into cz_rp_entries----------------
5634: plsql_table_list.DELETE;
5635: rec_count := 1;
5636: plsql_table_list(rec_count).col_name := 'object_id';
5736: l_cnt_typ_tmpls_uidef_tbl.DELETE;
5737: l_cnt_typ_tmpls_cont_tbl.DELETE;
5738: l_cnt_typ_tmpls_tgtuidef_tbl.DELETE;
5739:
5740: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
5741: THEN
5742: SELECT ui_def_id, template_id, template_ui_def_id, content_type
5743: 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
5744: FROM cz_ui_cont_type_templs
6346:
6347: -- A master template carries its own set of content templates
6348: -- need to resolved everything and insert separately for master templates
6349: -- for local migration, cz_pb_mgr.v_new_mt_id_tbl should be empty
6350: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_new_mt_id_tbl.COUNT > 0)
6351: THEN
6352: --collect content templates
6353: bulk_collect_cont_type_templs(cz_pb_mgr.v_mt_old_id_tbl);
6354: --resolve template ids
6510: ,cz_pb_mgr.g_ui_actns_ui_act_id_old_ref
6511: ,cz_pb_mgr.g_ui_actns_ui_uidef_old_ref
6512: );
6513:
6514: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
6515: THEN
6516: refresh_ui_actions(cz_pb_mgr.g_ui_actns_ui_uidef_old_ref);
6517: END IF;
6518:
6520: g_skip_templaction_rollback := TRUE;
6521:
6522: ------bulk collect ui images for Master templates
6523: -- for local migration, cz_pb_mgr.v_new_mt_id_tbl should be empty
6524: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_new_mt_id_tbl.COUNT > 0)
6525: THEN
6526: bulk_collect_ui_images(cz_pb_mgr.v_mt_old_id_tbl);
6527: 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');
6528: plsql_table_list.DELETE;
7596: ,x_last_xfr_activity IN OUT NOCOPY DATE
7597: )
7598: AS
7599: BEGIN
7600: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
7601: THEN
7602: SELECT last_xfr_activity
7603: INTO x_last_xfr_activity
7604: FROM cz_pb_model_exports
7612: SELECT publication_id
7613: FROM cz_model_publications
7614: WHERE export_status IN('OK', 'PUP')
7615: AND server_id = p_server_id
7616: AND UPPER(publication_mode) = cz_model_migration_pvt.mode_migration));
7617: --SPUPPALA bug#7116052 7-AUG-2009
7618: ELSE
7619: SELECT last_xfr_activity
7620: INTO x_last_xfr_activity
7629: SELECT publication_id
7630: FROM cz_model_publications
7631: WHERE export_status IN('OK', 'PUP')
7632: AND server_id = p_server_id
7633: AND UPPER(publication_mode) <> cz_model_migration_pvt.mode_migration));
7634: --SPUPPALA bug#7116052 7-AUG-2009
7635: END IF;
7636: EXCEPTION
7637: WHEN OTHERS
8547: IS
8548: l_last_update_date DATE;
8549: l_prev_date DATE := cz_utils.epoch_begin;
8550: rec_count NUMBER := 0;
8551: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
8552: BEGIN
8553: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
8554: THEN
8555: l_pub_mode := cz_model_migration_pvt.mode_migration;
8549: l_prev_date DATE := cz_utils.epoch_begin;
8550: rec_count NUMBER := 0;
8551: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
8552: BEGIN
8553: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
8554: THEN
8555: l_pub_mode := cz_model_migration_pvt.mode_migration;
8556: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
8557: THEN
8551: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
8552: BEGIN
8553: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
8554: THEN
8555: l_pub_mode := cz_model_migration_pvt.mode_migration;
8556: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
8557: THEN
8558: l_pub_mode := cz_model_migration_pvt.mode_copy;
8559: END IF;
8554: THEN
8555: l_pub_mode := cz_model_migration_pvt.mode_migration;
8556: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
8557: THEN
8558: l_pub_mode := cz_model_migration_pvt.mode_copy;
8559: END IF;
8560:
8561: x_last_xfr_activity := cz_utils.epoch_begin;
8562:
8691: FOR j IN l_ui_actns_ui_act_id_tbl.FIRST .. l_ui_actns_ui_act_id_tbl.LAST
8692: LOOP
8693: rec_count := rec_count + 1;
8694:
8695: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0) THEN
8696: cz_pb_mgr.g_ui_actns_ui_act_id_ref(rec_count) := l_ui_actns_ui_act_new_id_tbl(j);
8697: 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);
8698: ELSE
8699: cz_pb_mgr.g_ui_actns_ui_act_id_ref(rec_count) := l_ui_actns_ui_act_id_tbl(j);
8730: IF l_text_count > 0 THEN
8731: insert_intl_texts(l_text_tbl, 'global texts from ui actions', TRUE);
8732: END IF;
8733:
8734: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
8735:
8736: --The resolution moved here from insert_template_elements.
8737: BEGIN
8738: p_elem_id_tbl(i) := cz_pb_mgr.g_ui_actions_id_idx_ref(p_elem_id_tbl(i));
9129: --which is called from here.
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;
9244:
9245: FOR i IN l_new_tmpl_tbl.FIRST .. l_new_tmpl_tbl.LAST LOOP
9246: FOR j IN (SELECT * FROM cz_ui_templates
9247: WHERE template_id = l_new_tmpl_tbl(i) AND ui_def_id = '0' AND deleted_flag = '0') LOOP
9248: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model THEN
9249: -- The synch check will be performed here
9250: -- The template name will be checked over the link
9251: -- If the the template does not exists, then we will be using the new template that is created
9252: l_template_name := NULL;
9308: -- these two arrays are used in replace_extends()
9309: -- This part shoul be executed in the loop for already published/migrated templates
9310: -- but current code has a mny problems in this area ( checking for ui templates
9311: -- which need to be published/migrated
9312: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND l_template_name IS NOT NULL THEN
9313: l_rec_count := l_rec_count + 1;
9314: cz_pb_mgr.g_ui_templates_jrad_old_ref(l_rec_count) := j.jrad_doc;
9315: 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));
9316: END IF;
9799: IF ((x_status <> PUBLICATION_ERROR) AND (cz_pb_mgr.v_session_parameter <> model_copy)) THEN
9800: IF cz_pb_mgr.v_cz_ps_nodes_idx_tbl.EXISTS(p_model_id) THEN
9801: x_remote_model_id := cz_pb_mgr.v_cz_ps_nodes_idx_tbl(p_model_id);
9802: ELSE
9803: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model THEN
9804: IF p_server_id=0 THEN
9805: SELECT remote_model_id INTO x_remote_model_id
9806: FROM cz_pb_model_exports
9807: WHERE export_id=(SELECT max(export_id)
9840: || 'AND cz_pb_model_exports.model_id = :5'
9841: || ' '
9842: || 'AND cz_pb_model_exports.status = ''OK'''
9843: INTO x_remote_model_id
9844: USING p_server_id, p_server_id, p_model_id, cz_model_migration_pvt.change_flag_unchanged, p_model_id;
9845: END IF;
9846: ELSE
9847: SELECT cz_pb_model_exports.remote_model_id
9848: INTO x_remote_model_id
9907: BEGIN
9908: cz_pb_mgr.v_models_to_be_exported.DELETE;
9909: cz_pb_mgr.v_models_not_to_be_exported.DELETE;
9910:
9911: IF (cz_pb_mgr.v_session_parameter IN(pub_model, cz_model_migration_pvt.migrate_model))
9912: THEN
9913: OPEN model_cur(rootmodelid);
9914:
9915: /* Bug 5523268
9918: * if there is a change in the UI of child models, pick that up
9919: * as well;
9920: */
9921:
9922: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
9923: THEN
9924: child_model_ui_has_changed :=has_ui_inany_chld_mdl_changed(rootmodelid);
9925: END IF;
9926:
9943:
9944: EXIT WHEN model_cur%NOTFOUND;
9945: v_count := 0;
9946:
9947: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
9948: IF cz_pb_mgr.v_server_id = 0 THEN
9949: SELECT COUNT(*) INTO v_count
9950: FROM cz_pb_model_exports
9951: WHERE model_id=v_model_id AND status=publication_ok AND server_id=0
9968: || 'AND farprj.post_migr_change_flag = :4'
9969: || ' '
9970: || 'AND x.migration_group_id IS NOT NULL'
9971: INTO v_count
9972: USING v_model_id, publication_ok, cz_pb_mgr.v_server_id, cz_model_migration_pvt.change_flag_unchanged;
9973: END IF;
9974: ELSE
9975: SELECT COUNT(*)
9976: INTO v_count
10045: IF l_max_ui_date IS NOT NULL AND l_max_ui_date > v_expr_last_update THEN
10046: v_expr_last_update := l_max_ui_date;
10047: END IF;
10048:
10049: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
10050: IF cz_pb_mgr.v_server_id = 0 THEN
10051: SELECT COUNT(*) INTO v_count
10052: FROM cz_devl_projects x, cz_pb_model_exports y
10053: WHERE x.devl_project_id = y.model_id
10077: || 'AND farprj.post_migr_change_flag = :4'
10078: || ' '
10079: || 'AND y.migration_group_id IS NOT NULL AND y.status = :5'
10080: INTO v_count
10081: USING v_expr_last_update, v_model_id, cz_pb_mgr.v_server_id, cz_model_migration_pvt.change_flag_unchanged, publication_ok;
10082: END IF;
10083: ELSE
10084: SELECT COUNT(*)
10085: INTO v_count
10375: FOR r IN v_cz_eff_sets_new_ref.FIRST .. v_cz_eff_sets_new_ref.LAST
10376: LOOP
10377: IF (v_cz_eff_sets_new_ref(r) IS NOT NULL)
10378: THEN
10379: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
10380: THEN
10381: l_eff_set_new_id := mm_sync_eff_sets(v_cz_eff_sets_old_ref(r), v_cz_eff_sets_new_ref(r));
10382:
10383: IF ((l_eff_set_new_id IS NULL) AND(NOT v_cz_eff_sets_idx_tbl.EXISTS(v_cz_eff_sets_old_ref(r))))
10420: ,p_old_key_name
10421: ,p_eff_sets_old_key
10422: );
10423:
10424: IF (p_eff_sets_new_key.COUNT > 0 AND cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
10425: THEN
10426: ----------begin insert into cz_rp_entries----------------
10427: plsql_table_list.DELETE;
10428: rec_count := 1;
10492:
10493: v_verify_model_msg_ref verify_model_message_list;
10494: BEGIN
10495: -------no synchronization required if published locally
10496: IF ((p_server_id <> 0) AND(g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
10497: )
10498: THEN
10499: -----call to this procedure made to determine if the model being published
10500: -----contains a BOM
11711: )
11712: )
11713: THEN
11714: BEGIN
11715: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
11716: THEN
11717: OPEN child_ref_id_cv FOR 'SELECT ui_def_id FROM cz_ui_defs'
11718: || cz_pb_mgr.v_db_link
11719: || ' '
12075: v_devl_project_id := p_models_not_exported(i);
12076: get_remote_model_id(p_server_id,v_devl_project_id,x_status,v_remote_devl_project_id);
12077:
12078: -- For each of these source models, get all the UIs
12079: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0) THEN
12080: SELECT ui_def_id BULK COLLECT INTO v_ui_defs_tbl
12081: FROM cz_ui_defs
12082: WHERE deleted_flag='0' AND devl_project_id=v_devl_project_id AND ui_style=g_ui_style_jrad;
12083: ELSE
13166: END IF;
13167: END LOOP;
13168:
13169: IF (rec_count > 0 AND (cz_pb_mgr.v_session_parameter = MODEL_COPY OR
13170: cz_pb_mgr.v_session_parameter = CZ_MODEL_MIGRATION_PVT.MIGRATE_MODEL)) THEN
13171: FOR j IN p_rules_old_array.FIRST .. p_rules_old_array.LAST
13172: LOOP
13173: BEGIN
13174: SELECT object_type INTO l_object_type
14526: log_timing_message('start eff sets of ps nodes');
14527: END IF;
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:
14622: ------------Resolving component -ids of ps_nodes
14623: 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);
14624:
14625: -- resolve effective usage mask for ps nodes.
14626: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
14627: THEN
14628: resolve_effective_usage_mask(cz_pb_mgr.v_cz_ps_nodes_old_tbl, 0);
14629: END IF;
14630:
14677: rec_count := rec_count + 1;
14678: plsql_table_list(rec_count).col_name := 'reverse_connector_id';
14679: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ps_reverse_connector_tbl';
14680:
14681: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
14682: THEN
14683: rec_count := rec_count + 1;
14684: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_new_eff_usg_msk_tbl';
14685: plsql_table_list(rec_count).col_name := 'effective_usage_mask';
14943: log_timing_message('end resolve_virtual_components');
14944: END IF;
14945:
14946: -------get func comp spec by expl id
14947: IF (cz_pb_mgr.v_session_parameter IN(pub_model, cz_model_migration_pvt.migrate_model))
14948: THEN
14949: collect_func_comp_specs;
14950: ELSIF(cz_pb_mgr.v_session_parameter = model_copy)
14951: THEN
15246: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
15247:
15248: IF (p_models_for_export.COUNT > 0) THEN
15249: -- not copy non-jrad ui in any conversion session or in a copy session flagged by p_copy_nonjradui
15250: IF NOT (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 OR
15251: cz_pb_mgr.v_session_parameter=model_copy AND NOT p_copy_nonjradui) THEN
15252: get_source_uis(cz_pb_mgr.v_root_model_id, p_models_for_export, cz_pb_mgr.v_cz_ui_defs_old_ref);
15253: END IF;
15254: 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);
15255:
15256: --get_oa_tmpls is also called from has_to_be_published.
15257: --However, for model migration, has_to_be_published
15258: --is not called. So make the call to get_oa_tmpls here.
15259: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0 THEN
15260: get_oa_tmpls;
15261: END IF;
15262:
15263: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
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;
15404: 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);
15405: END IF;
15427: THEN
15428: log_timing_message('start insert_into_table cz_ui_defs');
15429: END IF;
15430:
15431: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id <> 0)
15432: THEN
15433: rec_count := rec_count + 1;
15434: plsql_table_list(rec_count).col_name := 'from_master_template_id';
15435: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_master_template_id_ref';
15877: log_timing_message('start resolve prop num value');
15878: END IF;
15879:
15880: IF (cz_pb_mgr.v_prop_vals_data_num_ref.COUNT > 0 AND
15881: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0)) THEN
15882: FOR intltext IN cz_pb_mgr.v_prop_vals_data_num_ref.FIRST .. cz_pb_mgr.v_prop_vals_data_num_ref.LAST
15883: LOOP
15884: IF cz_pb_mgr.v_prop_vals_data_typ_ref(intltext) = 8 AND
15885: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR
15881: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0)) THEN
15882: FOR intltext IN cz_pb_mgr.v_prop_vals_data_num_ref.FIRST .. cz_pb_mgr.v_prop_vals_data_num_ref.LAST
15883: LOOP
15884: IF cz_pb_mgr.v_prop_vals_data_typ_ref(intltext) = 8 AND
15885: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR
15886: cz_pb_mgr.v_prop_vals_valuesource_ref(intltext) = 'PsValue') THEN
15887: rec_count := rec_count + 1;
15888: cz_pb_mgr.v_prop_vals_intl_text_ref(rec_count) := cz_pb_mgr.v_prop_vals_data_num_ref(intltext);
15889: END IF;
15926: FOR intltext IN cz_pb_mgr.v_prop_vals_data_num_ref.FIRST .. cz_pb_mgr.v_prop_vals_data_num_ref.LAST
15927: LOOP
15928: IF cz_pb_mgr.v_prop_vals_data_typ_ref(intltext) = 8 AND
15929: cz_pb_mgr.v_prop_vals_data_num_ref(intltext) IS NOT NULL AND
15930: (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR
15931: cz_pb_mgr.v_prop_vals_valuesource_ref(intltext) = 'PsValue') THEN
15932: IF (cz_pb_mgr.v_psnode_propval_tbl(intltext).new_property_num_value IS NOT NULL)
15933: THEN
15934: cz_pb_mgr.v_prop_vals_data_num_ref(intltext) := cz_pb_mgr.v_psnode_propval_tbl(intltext).new_property_num_value; -- BUG11685105
15952:
15953: -- If this is remote model migration, we need to synchronize the properties before
15954: -- we insert into the target machine
15955: -- that will be done as part of insert item schema
15956: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0) THEN
15957: ------insert into cz_ps_prop_vals
15958: ------Srinik---------------------------------------
15959:
15960: IF cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model THEN
15956: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model OR cz_pb_mgr.v_server_id = 0) THEN
15957: ------insert into cz_ps_prop_vals
15958: ------Srinik---------------------------------------
15959:
15960: IF cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model THEN
15961:
15962: IF(vBulkSelectInsert = 'YES')THEN
15963: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
15964: log_timing_message('start bulk remote bulk insert remote_insert_into_ps_prop_vals; ');
15994: insert_item_schema;
15995:
15996: -- if model migration, the tables were not cleared before,
15997: -- they are being taken care of at this stage
15998: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
15999: THEN
16000: ---------release pl/sql tables
16001: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
16002: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
16002: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
16003: END IF;
16004:
16005: ----------refresh model usages
16006: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
16007: THEN
16008: load_usages;
16009: END IF;
16010:
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';
16161: rec_count := rec_count + 1;
16300: END LOOP;
16301: END IF;
16302: END LOOP;
16303:
16304: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
16305: THEN
16306: mm_sync_archives;
16307: -- resolve the array to only those that need to be inserted
16308: END IF;
16306: mm_sync_archives;
16307: -- resolve the array to only those that need to be inserted
16308: END IF;
16309:
16310: IF (cz_pb_mgr.v_session_parameter <> model_copy AND cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
16311: THEN
16312: 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');
16313:
16314: ELSE
16319: cz_pb_mgr.g_archive_id_ref(rec_count):=cz_pb_mgr.g_archive_id_old_ref(i);
16320: END LOOP;
16321: END IF;
16322:
16323: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
16324: THEN
16325: mm_insert_archives;
16326: ELSE
16327: mm_insert_archives_for_pb;
16353: rec_pop_count NUMBER := 0;
16354: rec_count PLS_INTEGER := 0;
16355: plsql_table_list cz_pb_mgr.col_plsql_table_list;
16356: BEGIN
16357: 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))
16358: THEN
16359: cz_pb_mgr.v_filter_sets_new_id_ref.DELETE;
16360: cz_pb_mgr.v_filter_sets_id_ref.DELETE;
16361: cz_pb_mgr.v_filter_sets_devl_ref.DELETE;
16888: LOOP
16889: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
16890:
16891: BEGIN
16892: IF (cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model))
16893: THEN
16894: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
16895: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
16896: ,cz_pb_mgr.v_oraclesequenceincr
16949: cz_pb_mgr.v_cz_enodes_rule_id_ref(rec_count) := cz_pb_mgr.v_cz_enodes_rule_id_tbl(i);
16950: cz_pb_mgr.v_cz_enodes_arg_sig_id_ref(rec_count) := cz_pb_mgr.v_cz_enodes_arg_sig_id_tbl(i);
16951: cz_pb_mgr.v_cz_enodes_par_sig_id_ref(rec_count) := cz_pb_mgr.v_cz_enodes_par_sig_id_tbl(i);
16952:
16953: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model)
16954: THEN
16955: cz_pb_mgr.v_cz_enodes_prop_id_ref(rec_count):=cz_pb_mgr.v_cz_enodes_prop_id_tbl(i);
16956: END IF;
16957:
16986: -------resolve sig ids
16987: 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);
16988: 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);
16989:
16990: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16991: 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');
16992: 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');
16993: 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);
16994: ELSE
17021: rec_count := rec_count + 1;
17022: plsql_table_list(rec_count).col_name := 'param_signature_id';
17023: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_par_sig_id_ref';
17024:
17025: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model)
17026: THEN
17027: rec_count := rec_count + 1;
17028: plsql_table_list(rec_count).col_name := 'property_id';
17029: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_prop_id_ref';
17093: END IF;
17094: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
17095: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
17096:
17097: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17098: 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');
17099: 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');
17100: ELSE
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);
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');
17173: 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');
17174: 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');
17175: ELSE
17184: --during model migration, if a rule_seq has a rule whose effectivity_set_id already
17185: --exists on the target, then set the rule effectivity to be
17186: --never effective for all the rules in that rule sequence
17187: --do this only if there is something to resolve(mm_v_ht_eff_set_tbl_t.COUNT >0)
17188: IF ( (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
17189: AND (mm_v_tbl_rule_seq.COUNT > 0)
17190: AND (mm_v_ht_eff_set_tbl_t.COUNT > 0)
17191: )
17192: THEN
17704: END LOOP;
17705: END IF;
17706:
17707: -- The copy of item type props and item prop values is uncessary for publication (4861805)
17708: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
17709: --~> Item type properties
17710: IF (cz_pb_mgr.v_item_types_new_ref.COUNT > 0)
17711: THEN
17712: cz_pb_mgr.v_item_prop_id_tbl.DELETE;
17824: --bom model.
17825:
17826: --The bug is deferred.
17827: /*
17828: IF(cz_pb_mgr.bomsynch_flag = 'N' AND cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)THEN
17829:
17830: FOR i IN 1..v_item_masters_tbl.COUNT LOOP
17831:
17832: IF(mm_v_itmst_src_app_id_ref(i) = 401)THEN
17844: END LOOP;
17845: END IF;
17846: */
17847: --Now run the upfront validations for model migration.
17848: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
17849: THEN
17850: mm_raiseallpossiblesyncerrors;
17851: END IF;
17852: END;
17914: read_item_schema;
17915: END IF;
17916:
17917: --------upload item sub-schema
17918: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
17919: THEN
17920: IF (cz_pb_mgr.g_log_timing = publication_timing)
17921: THEN
17922: log_timing_message('start upload_item_schema');
17933: END IF;
17934: END IF;
17935:
17936: ------export product structure
17937: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
17938: THEN
17939: IF (cz_pb_mgr.g_log_timing = publication_timing)
17940: THEN
17941: log_timing_message('start upload_ps_structure');
17962: log_timing_message('end upload_ui_schema');
17963: END IF;
17964:
17965: ------upload rule schema
17966: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
17967: THEN
17968: IF (cz_pb_mgr.g_log_timing = publication_timing)
17969: THEN
17970: log_timing_message('start upload_rule_schema');
18301: THEN
18302: log_timing_message('start get_models_tobe_exported');
18303: END IF;
18304:
18305: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
18306: THEN
18307: mm_models_to_be_migrated := get_rootmodel_and_mig_tgt_fldr(publicationid);
18308: mm_get_models_tobe_exported(mm_models_to_be_migrated);
18309: ELSIF(g_object_type = MODEL_PUBLICATION)
18339: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:EXPREQ', SQLCODE);
18340: END IF;
18341:
18342: -----create_copy_requests;
18343: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
18344: THEN
18345: cz_pb_mgr.v_models_to_be_exported.DELETE;
18346:
18347: IF (cz_pb_mgr.g_log_timing = publication_timing)
18406: export_global_template(modelid, publicationid);
18407: END IF;
18408:
18409: -----upload publication data
18410: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)
18411: THEN
18412: upload_publication_data(cz_pb_mgr.v_publication_id);
18413: END IF;
18414:
18739:
18740: cz_pb_mgr.v_server_id := p_server_id;
18741: -------set session level parameter that differentiates from publishing
18742: cz_pb_mgr.v_session_parameter := model_copy;
18743: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
18744: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
18745: ---------check if model exists
18746: v_model_chk_count := 0;
18747:
18740: cz_pb_mgr.v_server_id := p_server_id;
18741: -------set session level parameter that differentiates from publishing
18742: cz_pb_mgr.v_session_parameter := model_copy;
18743: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
18744: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
18745: ---------check if model exists
18746: v_model_chk_count := 0;
18747:
18748: BEGIN
19389: cz_pb_mgr.v_pb_run_id := 0.0;
19390: cz_pb_mgr.bomsynch_flag := 'N';
19391: cz_pb_mgr.v_status_code := publication_ok;
19392: cz_pb_mgr.v_session_parameter := pub_model;
19393: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
19394: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
19395: cz_pb_mgr.v_cz_model_pub_old_id := p_publication_id;
19396: cz_pb_mgr.v_cz_model_pub_new_id := NULL;
19397: cz_pb_mgr.v_ui_name := NULL;
19390: cz_pb_mgr.bomsynch_flag := 'N';
19391: cz_pb_mgr.v_status_code := publication_ok;
19392: cz_pb_mgr.v_session_parameter := pub_model;
19393: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
19394: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
19395: cz_pb_mgr.v_cz_model_pub_old_id := p_publication_id;
19396: cz_pb_mgr.v_cz_model_pub_new_id := NULL;
19397: cz_pb_mgr.v_ui_name := NULL;
19398: cz_pb_mgr.v_sql_err_msg := 'Fatal error reported';
19402: INTO l_pub_mode
19403: FROM cz_model_publications
19404: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted;
19405:
19406: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
19407: THEN
19408: cz_pb_mgr.v_session_parameter := cz_model_migration_pvt.migrate_model;
19409: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
19410: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
19404: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted;
19405:
19406: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
19407: THEN
19408: cz_pb_mgr.v_session_parameter := cz_model_migration_pvt.migrate_model;
19409: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
19410: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
19411: END IF;
19412:
19405:
19406: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
19407: THEN
19408: cz_pb_mgr.v_session_parameter := cz_model_migration_pvt.migrate_model;
19409: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
19410: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
19411: END IF;
19412:
19413: ---------select run_id and user from dual
19406: IF (UPPER(l_pub_mode) = cz_model_migration_pvt.mode_migration)
19407: THEN
19408: cz_pb_mgr.v_session_parameter := cz_model_migration_pvt.migrate_model;
19409: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
19410: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
19411: END IF;
19412:
19413: ---------select run_id and user from dual
19414: BEGIN
19796:
19797: l_ui_upto_date := TRUE;
19798:
19799: IF uidefid IS NULL THEN
19800: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
19801: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
19802: FROM cz_ui_defs
19803: WHERE deleted_flag='0' AND ui_style=g_ui_style_jrad AND devl_project_id IN
19804: (SELECT component_id FROM cz_model_ref_expls
19918: END;
19919:
19920: IF (original_name IS NOT NULL)
19921: THEN
19922: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
19923: v_name := SUBSTR (original_name|| '-[FCE]', 1, 235);
19924:
19925: ELSE
19926: v_name :=
19931: || REPLACE(cz_developer_utils_pvt.get_repository_path(p_devl_project_id, 'PRJ'), '/', '.'), 1, 235);
19932: -- Bug 5514199; 12-Sep-2006; kdande; Taking 235 chars only as other characters would be appended at runtime like copy x, rules etc
19933: END IF;
19934:
19935: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
19936: l_endBr:='';
19937: ELSE
19938: l_endBr:=')';
19939: END IF;
20133: RAISE not_global_template;
20134: END IF;
20135: ELSIF(g_object_type = MODEL_PUBLICATION) THEN
20136: 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);
20137: ELSIF(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
20138: RAISE invalid_object_type;
20139: END IF;
20140:
20141: check_export_status(v_cur_export_status, cz_publish, cz_pb_mgr.v_status_code);
20148: cz_pb_mgr.v_db_link := retrieve_db_link(cz_pb_mgr.v_server_id);
20149:
20150: -----check for source server flag on the target instance
20151: IF (cz_pb_mgr.v_server_id <> 0) THEN
20152: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
20153: cz_pb_sync_util.verify_mig_tgt_server(cz_pb_mgr.v_db_link, l_tgt_status, l_tgt_msg);
20154: ELSE
20155: cz_pb_sync_util.verify_tgt_server(cz_pb_mgr.v_db_link, l_tgt_status, l_tgt_msg);
20156: END IF;
20163: END IF;
20164:
20165: l_target_imp_server_on_local := cz_pb_mgr.v_server_id;
20166:
20167: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
20168:
20169: ----check for remote publication id on the target instance
20170:
20171: remote_pb_check(cz_pb_mgr.remote_publication_id);
20191: log_timing_message('start has_tobe_published');
20192: END IF;
20193:
20194: ----check if the publication has to be published
20195: IF (cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model) THEN
20196: v_check_publication := has_tobe_published(publicationid);
20197: ELSE
20198: v_check_publication := TRUE;
20199: ---for publishing, rules related tables are cleared in get_oa_tmpls
20259: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
20260: log_timing_message('start verify_model_for_sync');
20261: END IF;
20262:
20263: IF (g_object_type = MODEL_PUBLICATION OR cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
20264: verify_model_for_sync(l_target_imp_server_on_local, cz_pb_mgr.v_root_model_id);
20265: END IF;
20266:
20267: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
20284: --and insert into CZ_PERSISTENT_REC_IDS with its value, report the migrated and not migrated models.
20285: --------------------------------------------------------------------------------------------
20286:
20287: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) THEN
20288: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
20289: EXECUTE IMMEDIATE 'SELECT REPLACE(cz_developer_utils_pvt.get_repository_path'
20290: || cz_pb_mgr.v_db_link
20291: || '(:1, ''FLD''), ''/'', ''.'') FROM DUAL'
20292: INTO l_tgt_fld_path
20398: || ' t'
20399: || ' '
20400: || 'SET t.name = cz_pb_mgr.v_rp_name'
20401: || ', post_migr_change_flag = '''
20402: || cz_model_migration_pvt.change_flag_unchanged
20403: || ''' '
20404: || 'WHERE t.devl_project_id = '
20405: || cz_pb_mgr.v_new_object_id
20406: || ';'
20989: no_link_name EXCEPTION;
20990: invalid_object_type EXCEPTION;
20991: template_in_use EXCEPTION;
20992: cannot_del_pup EXCEPTION;
20993: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20994: BEGIN
20995: fnd_msg_pub.initialize;
20996: x_return_status := FND_API.G_RET_STS_SUCCESS;
20997: x_msg_count := 0;
20997: x_msg_count := 0;
20998: x_msg_data := '';
20999: fnd_msg_pub.initialize;
21000:
21001: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
21002: THEN
21003: l_pub_mode := cz_model_migration_pvt.mode_migration;
21004: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
21005: THEN
20999: fnd_msg_pub.initialize;
21000:
21001: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
21002: THEN
21003: l_pub_mode := cz_model_migration_pvt.mode_migration;
21004: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
21005: THEN
21006: l_pub_mode := cz_model_migration_pvt.mode_copy;
21007: END IF;
21002: THEN
21003: l_pub_mode := cz_model_migration_pvt.mode_migration;
21004: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
21005: THEN
21006: l_pub_mode := cz_model_migration_pvt.mode_copy;
21007: END IF;
21008:
21009: SELECT server_id, export_status, remote_publication_id, object_type
21010: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
21016: --if the target has been converted into a development instance
21017:
21018: IF (v_export_status <> model_publication_obselete) THEN
21019:
21020: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21021: --it is possible that the obsoleting process changed value of the publication record.
21022: --so requery
21023: SELECT server_id, export_status, remote_publication_id, object_type
21024: INTO v_server_id, v_export_status, v_remote_publication_id, l_object_type
21194: fnd_msg_pub.initialize;
21195: --execute the procedure that obsoletes the records
21196: --if the target has been converted into a development
21197: --instance
21198: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21199:
21200: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21201: THEN
21202: RAISE pub_maybe_obsoleted;
21569: v_language_id_tbl.DELETE;
21570: --execute the procedure that obsoletes the records
21571: --if the target has been converted into a development
21572: --instance
21573: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21574:
21575: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21576: THEN
21577: RAISE pub_maybe_obsoleted;
21692: fnd_msg_pub.initialize;
21693: --execute the procedure that obsoletes the records
21694: --if the target has been converted into a development
21695: --instance
21696: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21697:
21698: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21699: THEN
21700: RAISE pub_maybe_obsoleted;
21813: v_language_id_tbl.DELETE;
21814: --execute the procedure that obsoletes the records
21815: --if the target has been converted into a development
21816: --instance
21817: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21818:
21819: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21820: THEN
21821: RAISE pub_maybe_obsoleted;
22149: PROCEDURE reset_processing_pubs
22150: IS
22151: v_link_name cz_servers.fndnam_link_name%TYPE;
22152: v_db_link VARCHAR2(255);
22153: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
22154: BEGIN
22155: fnd_msg_pub.initialize;
22156:
22157: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
22153: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
22154: BEGIN
22155: fnd_msg_pub.initialize;
22156:
22157: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
22158: THEN
22159: l_pub_mode := cz_model_migration_pvt.mode_migration;
22160: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
22161: THEN
22155: fnd_msg_pub.initialize;
22156:
22157: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
22158: THEN
22159: l_pub_mode := cz_model_migration_pvt.mode_migration;
22160: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
22161: THEN
22162: l_pub_mode := cz_model_migration_pvt.mode_copy;
22163: END IF;
22158: THEN
22159: l_pub_mode := cz_model_migration_pvt.mode_migration;
22160: ELSIF(cz_pb_mgr.v_session_parameter = cz_pb_mgr.model_copy)
22161: THEN
22162: l_pub_mode := cz_model_migration_pvt.mode_copy;
22163: END IF;
22164:
22165: FOR i IN (SELECT publication_id, remote_publication_id, server_id
22166: FROM cz_model_publications
22355: fnd_msg_pub.initialize;
22356: --execute the procedure that obsoletes the records
22357: --if the target has been converted into a development
22358: --instance
22359: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
22360:
22361: ----check status
22362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
22363: THEN
22367: ----get source pb info
22368: SELECT *
22369: INTO v_source_pb_record
22370: FROM cz_model_publications
22371: WHERE publication_id = p_publication_id AND deleted_flag = record_not_deleted AND source_target_flag = cz_model_migration_pvt.pub_source_flag;
22372:
22373: ----check status
22374: IF (v_source_pb_record.export_status <> 'OK')
22375: THEN
22855: fnd_msg_pub.initialize;
22856: --execute the procedure that obsoletes the records
22857: --if the target has been converted into a development
22858: --instance
22859: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
22860:
22861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
22862: THEN
22863: RAISE pub_maybe_obsoleted;
23176:
23177: IF (l_publication_mode IS NULL)
23178: THEN
23179: l_publication_mode := 'P';
23180: ELSIF(UPPER(l_publication_mode) NOT IN('P', 'T', cz_model_migration_pvt.mode_migration))
23181: THEN
23182: RAISE invalid_pb_mode;
23183: END IF;
23184:
23181: THEN
23182: RAISE invalid_pb_mode;
23183: END IF;
23184:
23185: IF (UPPER(l_publication_mode) = cz_model_migration_pvt.mode_migration)
23186: THEN
23187: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
23188: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
23189: ELSE
23183: END IF;
23184:
23185: IF (UPPER(l_publication_mode) = cz_model_migration_pvt.mode_migration)
23186: THEN
23187: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
23188: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
23189: ELSE
23190: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
23191: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
23184:
23185: IF (UPPER(l_publication_mode) = cz_model_migration_pvt.mode_migration)
23186: THEN
23187: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
23188: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
23189: ELSE
23190: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
23191: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
23192: END IF;
23186: THEN
23187: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
23188: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
23189: ELSE
23190: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
23191: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
23192: END IF;
23193:
23194: ----check that atleast one application id
23187: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
23188: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
23189: ELSE
23190: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.pub_source_flag;
23191: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.pub_target_flag;
23192: END IF;
23193:
23194: ----check that atleast one application id
23195: ----- is passed
23428: ------------------------------------------------------------------------------------------------
23429: --The current design for model migration will run
23430: --the publication process for every model that has been selected
23431: --to be migrated. The process of collecting the models is in
23432: --CZ_MODEL_MIGRATION_PVT. Once the models are collected there, for every
23433: --CZ_MODEL_PUBLICATIONS record, publish model is called. Given that,
23434: --this procedure gets the model for the current migration cz_model_publication
23435: --record.
23436:
25239: SELECT publication_id
25240: FROM cz_model_publications
25241: WHERE export_status IN('OK', 'PUP')
25242: AND server_id = p_server_id
25243: AND UPPER(publication_mode) = cz_model_migration_pvt.mode_migration));
25244: --SPUPPALA bug#7116052 7-AUG-2009
25245: RETURN x_last_xfr_activity;
25246:
25247: