[Home] [Help]
754: RAISE;
755: END sequence_generate;
756:
757: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
758: ----update orig_sys_ref of cz_localized_texts to NULL
759: PROCEDURE update_localized_texts
760: AS
761: BEGIN
762: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)
766: || 'FOR I IN cz_pb_mgr.v_cz_intl_text_new_ref.FIRST..cz_pb_mgr.v_cz_intl_text_new_ref.LAST'
767: || ' '
768: || 'LOOP'
769: || ' '
770: || 'UPDATE cz_localized_texts'
771: || cz_pb_mgr.v_db_link
772: || ' t'
773: || ' '
774: || 'SET t.orig_sys_ref = NULL'
791: END IF;
792: EXCEPTION
793: WHEN OTHERS
794: THEN
795: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_localized_texts', 'SQLERRM', SQLERRM);
796: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDLOCALTEXT', SQLCODE);
797: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
798: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
799: RAISE;
799: RAISE;
800: END;
801:
802: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
803: ----update orig_sys_ref of cz_localized_texts to target values during model migration.
804: PROCEDURE update_mm_localized_texts
805: AS
806: BEGIN
807: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)
827: || 'SELECT DECODE(cz_pb_mgr.bomsynch_flag,''Y'', cz_bom_synch.locText_origSysRef(t.orig_sys_ref),t.orig_sys_ref)'
828: || ' '
829: || 'INTO orig_sys_ref_tgt'
830: || ' '
831: || 'FROM cz_localized_texts'
832: || cz_pb_mgr.v_db_link
833: || ' t'
834: || ' '
835: || 'WHERE t.intl_text_id = cz_pb_mgr.v_cz_intl_text_new_ref(i) AND t.orig_sys_ref IS NOT NULL AND t.language = base_lang;'
833: || ' t'
834: || ' '
835: || 'WHERE t.intl_text_id = cz_pb_mgr.v_cz_intl_text_new_ref(i) AND t.orig_sys_ref IS NOT NULL AND t.language = base_lang;'
836: || ' '
837: || 'UPDATE cz_localized_texts'
838: || cz_pb_mgr.v_db_link
839: || ' t'
840: || ' '
841: || 'SET t.orig_sys_ref = orig_sys_ref_tgt'
865: END IF;
866: EXCEPTION
867: WHEN OTHERS
868: THEN
869: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_localized_texts', 'SQLERRM', SQLERRM);
870: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDLOCALTEXT', SQLCODE);
871: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
872: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
873: RAISE;
1430: || ' '
1431: || 'FOR I IN cz_pb_mgr.mm_v_tbl_prop_vals_trans_new.FIRST .. cz_pb_mgr.mm_v_tbl_prop_vals_trans_new.LAST'
1432: || ' '
1433: || 'LOOP'
1434: || ' INSERT INTO cz_localized_texts'
1435: || cz_pb_mgr.v_db_link
1436: || '('
1437: || ' '
1438: || 'intl_text_id,localized_str,ui_def_id,ORIG_SYS_REF,model_id,source_lang,language)'
1438: || 'intl_text_id,localized_str,ui_def_id,ORIG_SYS_REF,model_id,source_lang,language)'
1439: || ' '
1440: || 'select cz_pb_mgr.mm_v_tbl_prop_vals_trans_new(i),localized_str,ui_def_id,ORIG_SYS_REF,cz_pb_mgr.mm_intl_text_model_id_ref(i),source_lang,language'
1441: || ' '
1442: || ' from cz_localized_texts where intl_text_id=cz_pb_mgr.mm_v_tbl_prop_vals_trans_old(i);'
1443: || ' '
1444: || 'IF ( cz_pb_mgr.v_expr_count > cz_pb_mgr.RECORD_COMMIT_SIZE) THEN'
1445: || ' '
1446: || 'COMMIT; cz_pb_mgr.v_expr_count := 0;'
1459: COMMIT;
1460: EXCEPTION
1461: WHEN OTHERS
1462: THEN
1463: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'CZ_LOCALIZED_TEXTS', 'SQLERRM', SQLERRM);
1464: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_localized_texts', SQLCODE);
1465: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1466: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
1467: RAISE;
1460: EXCEPTION
1461: WHEN OTHERS
1462: THEN
1463: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'CZ_LOCALIZED_TEXTS', 'SQLERRM', SQLERRM);
1464: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_localized_texts', SQLCODE);
1465: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1466: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
1467: RAISE;
1468: END;
2850:
2851: v_insertstring := RTRIM(v_insertstring, ',');
2852: v_insertstring := v_insertstring || ' FROM ' || table_name || ' WHERE ' || table_name || '.' || primary_key || ' = ' || plsql_table_name || '(m) ';
2853: --SKM -- Added check for Single Publication Langiage
2854: IF (vPubSingleLang IS NOT NULL AND table_name = 'cz_localized_texts') THEN
2855: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' AND LANGUAGE = '''||vPubSingleLang||''' ';
2856: ELSE
2857: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
2858: END IF;
2880: END;
2881:
2882: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2883: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2884: -----procedure that insert intl texts into cz_localized_texts
2885: -- set persistent_intl_text_id with new intl_text_id if texts are from templates
2886: -- and if the session is model migration. Note local model migration (via model
2887: -- conversion) does not copy any template
2888: PROCEDURE insert_intl_texts(p_intl_text_id_ref IN cz_pb_mgr.t_ref, p_intl_text IN VARCHAR2,
3056: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_intl_text_model_tbl';
3057: rec_count := rec_count + 1;
3058: plsql_table_list(rec_count).col_name := 'ui_def_id';
3059: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_intl_text_ui_tbl';
3060: -----------insert into cz_localized_texts
3061: insert_into_table('cz_localized_texts'
3062: ,'intl_text_id'
3063: ,cz_pb_mgr.v_db_link
3064: ,plsql_table_list
3057: rec_count := rec_count + 1;
3058: plsql_table_list(rec_count).col_name := 'ui_def_id';
3059: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_intl_text_ui_tbl';
3060: -----------insert into cz_localized_texts
3061: insert_into_table('cz_localized_texts'
3062: ,'intl_text_id'
3063: ,cz_pb_mgr.v_db_link
3064: ,plsql_table_list
3065: ,'cz_pb_mgr.v_cz_intl_text_old_ref'
5210: IS
5211: l_str VARCHAR2(2000);
5212: BEGIN
5213:
5214: -------bug#13517253 physical delete from cz_localized_texts before deleteing the cz_ui_template_elements.
5215: ---- Else this leads to the unwanted data in this table for every template publication.
5216: -------mpothubo.
5217:
5218:
5216: -------mpothubo.
5217:
5218:
5219: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5220: log_timing_message('Start of update of cz_localized_texts');
5221: END IF;
5222:
5223: l_str :=
5224: 'DELETE FROM cz_localized_texts'
5220: log_timing_message('Start of update of cz_localized_texts');
5221: END IF;
5222:
5223: l_str :=
5224: 'DELETE FROM cz_localized_texts'
5225: || p_link_name
5226: || ' WHERE ui_def_id = :1 '
5227: || ' AND NVL(seeded_flag, ''0'') = ''0'''
5228: || ' AND deleted_flag = ''0'''
5240: EXECUTE IMMEDIATE l_str
5241: USING p_ui_def_id, p_ui_def_id, p_template_id ;
5242:
5243: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5244: log_timing_message('No. of Records updated in cz_localized_texts (cz_ui_template_elements.element_id) : ' || sql%rowcount );
5245: log_timing_message('End of update of cz_localized_texts ');
5246: END IF;
5247:
5248: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5241: USING p_ui_def_id, p_ui_def_id, p_template_id ;
5242:
5243: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5244: log_timing_message('No. of Records updated in cz_localized_texts (cz_ui_template_elements.element_id) : ' || sql%rowcount );
5245: log_timing_message('End of update of cz_localized_texts ');
5246: END IF;
5247:
5248: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5249: log_timing_message('Start of delete of cz_ui_template_elements ');
7241:
7242: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.mm_v_ht_sync_archives',cz_pb_mgr.mm_v_ht_sync_archives);
7243:
7244: delete_from_table('cz_archive_refs','archive_id','devl_project_id',v_database_link,'cz_pb_mgr.g_archive_id_ref','cz_pb_mgr.g_devl_proj_ref',cz_pb_mgr.g_archive_id_ref);
7245: delete_from_table('cz_localized_texts','intl_text_id',v_database_link,'cz_pb_mgr.v_cz_intl_text_new_ref',cz_pb_mgr.v_cz_intl_text_new_ref);
7246:
7247: delete_from_idx_tables('cz_rule_folders', 'rule_folder_id', cz_pb_mgr.v_cz_folders_id_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref);
7248: delete_from_idx_tables('cz_expression_nodes', 'expr_node_id', cz_pb_mgr.v_cz_enodes_enode_id_old_ref, cz_pb_mgr.v_cz_enodes_enode_id_idx_ref);
7249:
8486: AS
8487: BEGIN
8488: SELECT MAX(last_update_date)
8489: INTO x_last_update_date
8490: FROM cz_localized_texts
8491: WHERE model_id = p_model_id;
8492: EXCEPTION
8493: WHEN OTHERS
8494: THEN
20423: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :1), 0),'
20424: || ' NVL((SELECT MAX(persistent_rule_id) FROM cz_rules'
20425: || cz_pb_mgr.v_db_link
20426: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :2), 0),'
20427: || ' NVL((SELECT MAX(persistent_intl_text_id) FROM cz_localized_texts'
20428: || cz_pb_mgr.v_db_link
20429: || ' WHERE deleted_flag = ''0'' AND model_id = :3), 0)) FROM DUAL'
20430: INTO v_max_rec_id
20431: USING v_object_id, v_object_id, v_object_id;
23696: IF(l_data_type_tbl(j) = 8)THEN
23697:
23698: --Bug #5441580. This is the case of translatable properties, data_num_value contains
23699: --intl_text_id of the property value. Hash the node's devl_project_id for later use
23700: --inserting into cz_localized_texts.
23701:
23702: cz_pb_mgr.h_devl_prj_by_intl_text(l_prop_num_value_tbl(j)) := l_devl_project_id_tbl(j);
23703: -- BUG11685105
23704: cz_pb_mgr.v_psnode_propval_tbl(v_property_count).devl_project_id := l_devl_project_id_tbl(j);
23841: IF(l_data_type_tbl(j) = 8)THEN
23842:
23843: --Bug #5441580. This is the case of translatable properties, data_num_value contains
23844: --intl_text_id of the property value. Hash the node's devl_project_id for later use
23845: --inserting into cz_localized_texts.
23846:
23847: cz_pb_mgr.h_devl_prj_by_intl_text(l_prop_num_value_tbl(j)) := l_devl_project_id_tbl(j);
23848: END IF;
23849:
23917: IF(l_data_type_tbl(j) = 8)THEN
23918:
23919: --Bug #5441580. This is the case of translatable properties, data_num_value contains
23920: --intl_text_id of the property value. Hash the node's devl_project_id for later use
23921: --inserting into cz_localized_texts.
23922:
23923: cz_pb_mgr.h_devl_prj_by_intl_text(l_prop_num_value_tbl(j)) := l_devl_project_id_tbl(j);
23924: END IF;
23925:
24001: --First for the numeric value of the translatable property.
24002:
24003: t_prop_val_num := mm_get_newid('INTL_TEXT');
24004:
24005: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts
24006: --mm_v_tbl_prop_vals_trans_old:contains all old inl text(old def num vals) for which data need to be inserted into cz_localized_texts
24007:
24008: mm_v_tbl_prop_vals_trans_new(mm_v_tbl_prop_vals_trans_new.count+1) := t_prop_val_num;
24009: mm_v_tbl_prop_vals_trans_old(mm_v_tbl_prop_vals_trans_old.count+1) := cz_pb_mgr.v_prop_vals_data_num_ref(j);
24002:
24003: t_prop_val_num := mm_get_newid('INTL_TEXT');
24004:
24005: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts
24006: --mm_v_tbl_prop_vals_trans_old:contains all old inl text(old def num vals) for which data need to be inserted into cz_localized_texts
24007:
24008: mm_v_tbl_prop_vals_trans_new(mm_v_tbl_prop_vals_trans_new.count+1) := t_prop_val_num;
24009: mm_v_tbl_prop_vals_trans_old(mm_v_tbl_prop_vals_trans_old.count+1) := cz_pb_mgr.v_prop_vals_data_num_ref(j);
24010:
24151: IF(cz_pb_mgr.v_item_prop_data_typ_tbl(j) = 8)THEN /*Tranlatable properties*/
24152:
24153: new_def_num_val := mm_get_newid('INTL_TEXT');
24154:
24155: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts
24156: --mm_v_tbl_prop_vals_trans_old:contains all old inl text(old def num vals) for which data need to be inserted into cz_localized_texts
24157:
24158: mm_v_tbl_prop_vals_trans_new(mm_v_tbl_prop_vals_trans_new.count+1) := new_def_num_val;
24159: mm_v_tbl_prop_vals_trans_old(mm_v_tbl_prop_vals_trans_old.count+1) := cz_pb_mgr.v_item_prop_num_val_tbl(j);
24152:
24153: new_def_num_val := mm_get_newid('INTL_TEXT');
24154:
24155: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts
24156: --mm_v_tbl_prop_vals_trans_old:contains all old inl text(old def num vals) for which data need to be inserted into cz_localized_texts
24157:
24158: mm_v_tbl_prop_vals_trans_new(mm_v_tbl_prop_vals_trans_new.count+1) := new_def_num_val;
24159: mm_v_tbl_prop_vals_trans_old(mm_v_tbl_prop_vals_trans_old.count+1) := cz_pb_mgr.v_item_prop_num_val_tbl(j);
24160: