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_MODEL_PUBLICATIONS

Line 30: v_server_id cz_model_publications.server_id%TYPE;

26: */
27:
28: EXPLORETREE_ERROR EXCEPTION;
29: PRAGMA EXCEPTION_INIT(EXPLORETREE_ERROR, -20001);
30: v_server_id cz_model_publications.server_id%TYPE;
31: v_ui_def_id cz_model_publications.ui_def_id%TYPE;
32: v_export_id cz_pb_model_exports.export_id%TYPE;
33: v_publication_id cz_model_publications.publication_id%TYPE;
34: v_root_model_id cz_model_publications.model_id%TYPE;

Line 31: v_ui_def_id cz_model_publications.ui_def_id%TYPE;

27:
28: EXPLORETREE_ERROR EXCEPTION;
29: PRAGMA EXCEPTION_INIT(EXPLORETREE_ERROR, -20001);
30: v_server_id cz_model_publications.server_id%TYPE;
31: v_ui_def_id cz_model_publications.ui_def_id%TYPE;
32: v_export_id cz_pb_model_exports.export_id%TYPE;
33: v_publication_id cz_model_publications.publication_id%TYPE;
34: v_root_model_id cz_model_publications.model_id%TYPE;
35: v_root_ui_def_id cz_model_publications.ui_def_id%TYPE;

Line 33: v_publication_id cz_model_publications.publication_id%TYPE;

29: PRAGMA EXCEPTION_INIT(EXPLORETREE_ERROR, -20001);
30: v_server_id cz_model_publications.server_id%TYPE;
31: v_ui_def_id cz_model_publications.ui_def_id%TYPE;
32: v_export_id cz_pb_model_exports.export_id%TYPE;
33: v_publication_id cz_model_publications.publication_id%TYPE;
34: v_root_model_id cz_model_publications.model_id%TYPE;
35: v_root_ui_def_id cz_model_publications.ui_def_id%TYPE;
36: target_root_model_id cz_model_publications.model_id%TYPE;
37: v_status_code cz_model_publications.export_status%TYPE;

Line 34: v_root_model_id cz_model_publications.model_id%TYPE;

30: v_server_id cz_model_publications.server_id%TYPE;
31: v_ui_def_id cz_model_publications.ui_def_id%TYPE;
32: v_export_id cz_pb_model_exports.export_id%TYPE;
33: v_publication_id cz_model_publications.publication_id%TYPE;
34: v_root_model_id cz_model_publications.model_id%TYPE;
35: v_root_ui_def_id cz_model_publications.ui_def_id%TYPE;
36: target_root_model_id cz_model_publications.model_id%TYPE;
37: v_status_code cz_model_publications.export_status%TYPE;
38: v_remote_comp_id cz_model_ref_expls.component_id%TYPE;

Line 35: v_root_ui_def_id cz_model_publications.ui_def_id%TYPE;

31: v_ui_def_id cz_model_publications.ui_def_id%TYPE;
32: v_export_id cz_pb_model_exports.export_id%TYPE;
33: v_publication_id cz_model_publications.publication_id%TYPE;
34: v_root_model_id cz_model_publications.model_id%TYPE;
35: v_root_ui_def_id cz_model_publications.ui_def_id%TYPE;
36: target_root_model_id cz_model_publications.model_id%TYPE;
37: v_status_code cz_model_publications.export_status%TYPE;
38: v_remote_comp_id cz_model_ref_expls.component_id%TYPE;
39: v_child_expl_id cz_model_ref_expls.child_model_expl_id%TYPE;

Line 36: target_root_model_id cz_model_publications.model_id%TYPE;

32: v_export_id cz_pb_model_exports.export_id%TYPE;
33: v_publication_id cz_model_publications.publication_id%TYPE;
34: v_root_model_id cz_model_publications.model_id%TYPE;
35: v_root_ui_def_id cz_model_publications.ui_def_id%TYPE;
36: target_root_model_id cz_model_publications.model_id%TYPE;
37: v_status_code cz_model_publications.export_status%TYPE;
38: v_remote_comp_id cz_model_ref_expls.component_id%TYPE;
39: v_child_expl_id cz_model_ref_expls.child_model_expl_id%TYPE;
40: v_server_local_name cz_servers.local_name%TYPE;

Line 37: v_status_code cz_model_publications.export_status%TYPE;

33: v_publication_id cz_model_publications.publication_id%TYPE;
34: v_root_model_id cz_model_publications.model_id%TYPE;
35: v_root_ui_def_id cz_model_publications.ui_def_id%TYPE;
36: target_root_model_id cz_model_publications.model_id%TYPE;
37: v_status_code cz_model_publications.export_status%TYPE;
38: v_remote_comp_id cz_model_ref_expls.component_id%TYPE;
39: v_child_expl_id cz_model_ref_expls.child_model_expl_id%TYPE;
40: v_server_local_name cz_servers.local_name%TYPE;
41: v_target_ui_def_id cz_ui_defs.ui_def_id%TYPE;

Line 52: v_prev_remote_publication_id cz_model_publications.publication_id%TYPE;

48: v_rp_name cz_rp_entries.NAME%TYPE;
49: v_rp_desc cz_rp_entries.description%TYPE;
50: v_sql_err_msg cz_db_logs.MESSAGE%TYPE;
51: v_db_link cz_servers.fndnam_link_name%TYPE;
52: v_prev_remote_publication_id cz_model_publications.publication_id%TYPE;
53: v_new_devl_id cz_devl_projects.devl_project_id%TYPE;
54: new_ui_def_id cz_ui_defs.ui_def_id%TYPE;
55: sequence_no NUMBER := 0;
56: v_oraclesequenceincr PLS_INTEGER := 0.0;

Line 66: remote_publication_id cz_model_publications.remote_publication_id%TYPE;

62: index_variable NUMBER := 0.0;
63: -----table_name variable used in insert_into_table procedure
64: v_insert_table_name VARCHAR2(128);
65: v_insert_error VARCHAR2(2000);
66: remote_publication_id cz_model_publications.remote_publication_id%TYPE;
67: v_ui_str VARCHAR2(6) := 'x';
68: ------------parameters of delete publication
69: d_pbid NUMBER;
70:

Line 134: TYPE model_id_table IS TABLE OF cz_model_publications.model_id%TYPE

130: INDEX BY BINARY_INTEGER;
131:
132: TYPE ref_cursor IS REF CURSOR;
133:
134: TYPE model_id_table IS TABLE OF cz_model_publications.model_id%TYPE
135: INDEX BY BINARY_INTEGER;
136:
137: TYPE t_ref IS TABLE OF NUMBER
138: INDEX BY BINARY_INTEGER;

Line 385: v_cz_model_pub_new_id cz_model_publications.publication_id%TYPE;

381: v_remote_prop_ref t_ref;
382: v_property_record_ref t_propertytable;
383: v_type_property_record_ref table_of_propertytables;
384: v_type_record_ref t_typetable;
385: v_cz_model_pub_new_id cz_model_publications.publication_id%TYPE;
386: v_cz_model_pub_old_id cz_model_publications.publication_id%TYPE;
387: v_models_to_be_exported t_ref;
388: v_models_not_to_be_exported t_ref;
389: v_models_to_be_exported_new t_ref;

Line 386: v_cz_model_pub_old_id cz_model_publications.publication_id%TYPE;

382: v_property_record_ref t_propertytable;
383: v_type_property_record_ref table_of_propertytables;
384: v_type_record_ref t_typetable;
385: v_cz_model_pub_new_id cz_model_publications.publication_id%TYPE;
386: v_cz_model_pub_old_id cz_model_publications.publication_id%TYPE;
387: v_models_to_be_exported t_ref;
388: v_models_not_to_be_exported t_ref;
389: v_models_to_be_exported_new t_ref;
390: v_cz_express_expr_id_new_ref1 t_ref;

Line 521: CZ_MODEL_PUBLICATIONS_SEQ CONSTANT PLS_INTEGER := 15;

517: CZ_EXPRESSION_NODES_SEQ CONSTANT PLS_INTEGER := 11;
518: CZ_RULES_SEQ CONSTANT PLS_INTEGER := 12;
519: CZ_GRID_CELLS_SEQ CONSTANT PLS_INTEGER := 13;
520: CZ_LCE_HEADERS_SEQ CONSTANT PLS_INTEGER := 14;
521: CZ_MODEL_PUBLICATIONS_SEQ CONSTANT PLS_INTEGER := 15;
522: CZ_EFFECTIVITY_SETS_SEQ CONSTANT PLS_INTEGER := 16;
523: CZ_CONFIG_MESSAGES_SEQ CONSTANT PLS_INTEGER := 17;
524: CZ_UI_TEMPLATES CONSTANT PLS_INTEGER := 18;
525: CZ_SIGNATURES_SEQ CONSTANT PLS_INTEGER := 19;

Line 540: v_bomsynch_product_key cz_model_publications.product_key%TYPE;

536: ----variables used for orig_sys_ref returned by bomsynch
537: v_devl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
538: v_it_masters_sys_ref VARCHAR2(255);
539: v_it_types_sys_ref VARCHAR2(255);
540: v_bomsynch_product_key cz_model_publications.product_key%TYPE;
541: v_bomsynch_org_id cz_model_publications.organization_id%TYPE;
542: v_bomsynch_item_id cz_model_publications.top_item_id%TYPE;
543: ---variables used by republish model
544: v_orig_start_date DATE;

Line 541: v_bomsynch_org_id cz_model_publications.organization_id%TYPE;

537: v_devl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
538: v_it_masters_sys_ref VARCHAR2(255);
539: v_it_types_sys_ref VARCHAR2(255);
540: v_bomsynch_product_key cz_model_publications.product_key%TYPE;
541: v_bomsynch_org_id cz_model_publications.organization_id%TYPE;
542: v_bomsynch_item_id cz_model_publications.top_item_id%TYPE;
543: ---variables used by republish model
544: v_orig_start_date DATE;
545: v_orig_end_date DATE;

Line 542: v_bomsynch_item_id cz_model_publications.top_item_id%TYPE;

538: v_it_masters_sys_ref VARCHAR2(255);
539: v_it_types_sys_ref VARCHAR2(255);
540: v_bomsynch_product_key cz_model_publications.product_key%TYPE;
541: v_bomsynch_org_id cz_model_publications.organization_id%TYPE;
542: v_bomsynch_item_id cz_model_publications.top_item_id%TYPE;
543: ---variables used by republish model
544: v_orig_start_date DATE;
545: v_orig_end_date DATE;
546: v_repub_appl_from DATE;

Line 549: v_repub_remote_pb_id cz_model_publications.remote_publication_id%TYPE;

545: v_orig_end_date DATE;
546: v_repub_appl_from DATE;
547: v_repub_appl_until DATE;
548: v_republish_model NUMBER := -1;
549: v_repub_remote_pb_id cz_model_publications.remote_publication_id%TYPE;
550: ------------variables used in publication functions
551: model_ref_expl_id_table t_ref;
552: v_last_struct_update DATE;
553: ----global declarations for item schema bug# 2463594

Line 637: g_source_flag cz_model_publications.source_target_flag%TYPE;

633:
634: TYPE varchar_tbl_type_3 IS TABLE OF cz_rp_entries.object_type%TYPE
635: INDEX BY BINARY_INTEGER;
636:
637: g_source_flag cz_model_publications.source_target_flag%TYPE;
638: g_target_flag cz_model_publications.source_target_flag%TYPE;
639: g_migration_group_id cz_model_publications.migration_group_id%TYPE;
640: g_object_type cz_model_publications.object_type%TYPE;
641: g_template_id cz.cz_ui_templates.template_id%TYPE;

Line 638: g_target_flag cz_model_publications.source_target_flag%TYPE;

634: TYPE varchar_tbl_type_3 IS TABLE OF cz_rp_entries.object_type%TYPE
635: INDEX BY BINARY_INTEGER;
636:
637: g_source_flag cz_model_publications.source_target_flag%TYPE;
638: g_target_flag cz_model_publications.source_target_flag%TYPE;
639: g_migration_group_id cz_model_publications.migration_group_id%TYPE;
640: g_object_type cz_model_publications.object_type%TYPE;
641: g_template_id cz.cz_ui_templates.template_id%TYPE;
642: g_jrad_doc cz.cz_ui_templates.jrad_doc%TYPE;

Line 639: g_migration_group_id cz_model_publications.migration_group_id%TYPE;

635: INDEX BY BINARY_INTEGER;
636:
637: g_source_flag cz_model_publications.source_target_flag%TYPE;
638: g_target_flag cz_model_publications.source_target_flag%TYPE;
639: g_migration_group_id cz_model_publications.migration_group_id%TYPE;
640: g_object_type cz_model_publications.object_type%TYPE;
641: g_template_id cz.cz_ui_templates.template_id%TYPE;
642: g_jrad_doc cz.cz_ui_templates.jrad_doc%TYPE;
643: g_button_tmpl_id cz.cz_ui_templates.template_id%TYPE;

Line 640: g_object_type cz_model_publications.object_type%TYPE;

636:
637: g_source_flag cz_model_publications.source_target_flag%TYPE;
638: g_target_flag cz_model_publications.source_target_flag%TYPE;
639: g_migration_group_id cz_model_publications.migration_group_id%TYPE;
640: g_object_type cz_model_publications.object_type%TYPE;
641: g_template_id cz.cz_ui_templates.template_id%TYPE;
642: g_jrad_doc cz.cz_ui_templates.jrad_doc%TYPE;
643: g_button_tmpl_id cz.cz_ui_templates.template_id%TYPE;
644: g_main_msg_id cz.cz_ui_templates.main_message_id%TYPE;

Line 771: g_migration_tgt_folder_id cz_model_publications.migration_tgt_folder%TYPE;

767: v_populators_id_ref t_ref;
768: v_populators_node_ref t_ref;
769: v_populators_set_id_ref t_ref;
770: g_jrad_trans_list jdr_utils.translationlist := jdr_utils.translationlist();
771: g_migration_tgt_folder_id cz_model_publications.migration_tgt_folder%TYPE;
772: g_mt_obj_type varchar_tbl_type_3;
773: g_mt_enclosing_fld_rp_entry t_ref;
774: g_ui_templates_obj_type varchar_tbl_type_3;
775: g_enclosing_fld_rp_entry t_ref;

Line 982: ,x_status OUT NOCOPY cz_model_publications.export_status%TYPE

978: p_publication_id IN OUT NOCOPY NUMBER
979: ,p_start_date IN OUT NOCOPY DATE
980: ,p_end_date IN OUT NOCOPY DATE
981: ,x_run_id OUT NOCOPY NUMBER
982: ,x_status OUT NOCOPY cz_model_publications.export_status%TYPE
983: );
984:
985: PROCEDURE create_republish_publication(
986: p_publication_id IN NUMBER

Line 1219: p_model_id IN cz_model_publications.model_id%TYPE

1215: PROCEDURE mm_resolve_rule_seq_effsetid;
1216: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER;
1217: FUNCTION has_ui_inany_chld_mdl_changed(rootmodelid IN NUMBER)RETURN boolean;
1218: FUNCTION get_mdl_last_xfr_activity(
1219: p_model_id IN cz_model_publications.model_id%TYPE
1220: ,p_server_id IN cz_model_publications.server_id%TYPE
1221:
1222: ) RETURN DATE;
1223: END cz_pb_mgr;

Line 1220: ,p_server_id IN cz_model_publications.server_id%TYPE

1216: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER;
1217: FUNCTION has_ui_inany_chld_mdl_changed(rootmodelid IN NUMBER)RETURN boolean;
1218: FUNCTION get_mdl_last_xfr_activity(
1219: p_model_id IN cz_model_publications.model_id%TYPE
1220: ,p_server_id IN cz_model_publications.server_id%TYPE
1221:
1222: ) RETURN DATE;
1223: END cz_pb_mgr;