eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PB_MGR dependencies on CZ_LOCALIZED_TEXTS

Line 578: ----update orig_sys_ref of cz_localized_texts to NULL

574: RAISE;
575: END sequence_generate;
576:
577: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
578: ----update orig_sys_ref of cz_localized_texts to NULL
579: PROCEDURE update_localized_texts
580: AS
581: BEGIN
582: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)

Line 590: || 'UPDATE cz_localized_texts'

586: || 'FOR I IN cz_pb_mgr.v_cz_intl_text_new_ref.FIRST..cz_pb_mgr.v_cz_intl_text_new_ref.LAST'
587: || ' '
588: || 'LOOP'
589: || ' '
590: || 'UPDATE cz_localized_texts'
591: || cz_pb_mgr.v_db_link
592: || ' t'
593: || ' '
594: || 'SET t.orig_sys_ref = NULL'

Line 615: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_localized_texts', 'SQLERRM', SQLERRM);

611: END IF;
612: EXCEPTION
613: WHEN OTHERS
614: THEN
615: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_localized_texts', 'SQLERRM', SQLERRM);
616: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDLOCALTEXT', SQLCODE);
617: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
618: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
619: RAISE;

Line 1174: || ' INSERT INTO cz_localized_texts'

1170: || ' '
1171: || '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'
1172: || ' '
1173: || 'LOOP'
1174: || ' INSERT INTO cz_localized_texts'
1175: || cz_pb_mgr.v_db_link
1176: || '('
1177: || ' '
1178: || 'intl_text_id,localized_str,ui_def_id,ORIG_SYS_REF,model_id,source_lang,language)'

Line 1182: || ' from cz_localized_texts where intl_text_id=cz_pb_mgr.mm_v_tbl_prop_vals_trans_old(i);'

1178: || 'intl_text_id,localized_str,ui_def_id,ORIG_SYS_REF,model_id,source_lang,language)'
1179: || ' '
1180: || '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'
1181: || ' '
1182: || ' from cz_localized_texts where intl_text_id=cz_pb_mgr.mm_v_tbl_prop_vals_trans_old(i);'
1183: || ' '
1184: || 'IF ( cz_pb_mgr.v_expr_count > cz_pb_mgr.RECORD_COMMIT_SIZE) THEN'
1185: || ' '
1186: || 'COMMIT; cz_pb_mgr.v_expr_count := 0;'

Line 1203: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'CZ_LOCALIZED_TEXTS', 'SQLERRM', SQLERRM);

1199: COMMIT;
1200: EXCEPTION
1201: WHEN OTHERS
1202: THEN
1203: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'CZ_LOCALIZED_TEXTS', 'SQLERRM', SQLERRM);
1204: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_localized_texts', SQLCODE);
1205: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1206: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
1207: RAISE;

Line 1204: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_localized_texts', SQLCODE);

1200: EXCEPTION
1201: WHEN OTHERS
1202: THEN
1203: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'CZ_LOCALIZED_TEXTS', 'SQLERRM', SQLERRM);
1204: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_localized_texts', SQLCODE);
1205: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1206: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
1207: RAISE;
1208: END;

Line 2358: -----procedure that insert intl texts into cz_localized_texts

2354: END;
2355:
2356: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2357: ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2358: -----procedure that insert intl texts into cz_localized_texts
2359: -- set persistent_intl_text_id with new intl_text_id if texts are from templates
2360: -- and if the session is model migration. Note local model migration (via model
2361: -- conversion) does not copy any template
2362: PROCEDURE insert_intl_texts(p_intl_text_id_ref IN cz_pb_mgr.t_ref, p_intl_text IN VARCHAR2,

Line 2464: -----------insert into cz_localized_texts

2460: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_intl_text_model_tbl';
2461: rec_count := rec_count + 1;
2462: plsql_table_list(rec_count).col_name := 'ui_def_id';
2463: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_intl_text_ui_tbl';
2464: -----------insert into cz_localized_texts
2465: insert_into_table('cz_localized_texts'
2466: ,'intl_text_id'
2467: ,cz_pb_mgr.v_db_link
2468: ,plsql_table_list

Line 2465: insert_into_table('cz_localized_texts'

2461: rec_count := rec_count + 1;
2462: plsql_table_list(rec_count).col_name := 'ui_def_id';
2463: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_intl_text_ui_tbl';
2464: -----------insert into cz_localized_texts
2465: insert_into_table('cz_localized_texts'
2466: ,'intl_text_id'
2467: ,cz_pb_mgr.v_db_link
2468: ,plsql_table_list
2469: ,'cz_pb_mgr.v_cz_intl_text_old_ref'

Line 6524: 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);

6520:
6521: 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);
6522:
6523: 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);
6524: 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);
6525:
6526: 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);
6527: 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);
6528:

Line 7767: FROM cz_localized_texts

7763: AS
7764: BEGIN
7765: SELECT MAX(last_update_date)
7766: INTO x_last_update_date
7767: FROM cz_localized_texts
7768: WHERE model_id = p_model_id;
7769: EXCEPTION
7770: WHEN OTHERS
7771: THEN

Line 19242: || ' NVL((SELECT MAX(persistent_intl_text_id) FROM cz_localized_texts'

19238: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :1), 0),'
19239: || ' NVL((SELECT MAX(persistent_rule_id) FROM cz_rules'
19240: || cz_pb_mgr.v_db_link
19241: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :2), 0),'
19242: || ' NVL((SELECT MAX(persistent_intl_text_id) FROM cz_localized_texts'
19243: || cz_pb_mgr.v_db_link
19244: || ' WHERE deleted_flag = ''0'' AND model_id = :3), 0)) FROM DUAL'
19245: INTO v_max_rec_id
19246: USING v_object_id, v_object_id, v_object_id;

Line 22483: --inserting into cz_localized_texts.

22479: IF(l_data_type_tbl(j) = 8)THEN
22480:
22481: --Bug #5441580. This is the case of translatable properties, data_num_value contains
22482: --intl_text_id of the property value. Hash the node's devl_project_id for later use
22483: --inserting into cz_localized_texts.
22484:
22485: cz_pb_mgr.h_devl_prj_by_intl_text(l_prop_num_value_tbl(j)) := l_devl_project_id_tbl(j);
22486: END IF;
22487:

Line 22563: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts

22559: --First for the numeric value of the translatable property.
22560:
22561: t_prop_val_num := mm_get_newid('INTL_TEXT');
22562:
22563: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts
22564: --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
22565:
22566: mm_v_tbl_prop_vals_trans_new(mm_v_tbl_prop_vals_trans_new.count+1) := t_prop_val_num;
22567: 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);

Line 22564: --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

22560:
22561: t_prop_val_num := mm_get_newid('INTL_TEXT');
22562:
22563: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts
22564: --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
22565:
22566: mm_v_tbl_prop_vals_trans_new(mm_v_tbl_prop_vals_trans_new.count+1) := t_prop_val_num;
22567: 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);
22568:

Line 22713: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts

22709: IF(cz_pb_mgr.v_item_prop_data_typ_tbl(j) = 8)THEN /*Tranlatable properties*/
22710:
22711: new_def_num_val := mm_get_newid('INTL_TEXT');
22712:
22713: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts
22714: --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
22715:
22716: mm_v_tbl_prop_vals_trans_new(mm_v_tbl_prop_vals_trans_new.count+1) := new_def_num_val;
22717: 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);

Line 22714: --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

22710:
22711: new_def_num_val := mm_get_newid('INTL_TEXT');
22712:
22713: --mm_v_tbl_prop_vals_trans_new:contains all inl text(new def num vals) which need to be inserted into cz_localized_texts
22714: --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
22715:
22716: mm_v_tbl_prop_vals_trans_new(mm_v_tbl_prop_vals_trans_new.count+1) := new_def_num_val;
22717: 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);
22718: