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_SERVERS

Line 4088: l_link_name cz_servers.fndnam_link_name%TYPE;

4084: ,x_msg_data OUT NOCOPY VARCHAR2
4085: )
4086: IS
4087: l_jrad_doc_tbl jraddoc_type_tbl;
4088: l_link_name cz_servers.fndnam_link_name%TYPE;
4089: link_name_is_null EXCEPTION;
4090: BEGIN
4091: pbdebug := 22026;
4092:

Line 4193: l_link_name cz_servers.fndnam_link_name%TYPE;

4189: )
4190: IS
4191: l_ui_def_id_tbl cz_pb_mgr.t_ref;
4192: l_template_id_tbl cz_pb_mgr.t_ref;
4193: l_link_name cz_servers.fndnam_link_name%TYPE;
4194: link_name_is_null EXCEPTION;
4195: BEGIN
4196: IF (p_link_name IS NULL)
4197: THEN

Line 6798: v_source_id cz_servers.server_local_id%TYPE;

6794: ------------ to retrieve the db link
6795: FUNCTION retrieve_db_link(p_server_id PLS_INTEGER)
6796: RETURN VARCHAR2
6797: IS
6798: v_source_id cz_servers.server_local_id%TYPE;
6799: v_source_instance cz_servers.instance_name%TYPE;
6800: v_source_host cz_servers.hostname%TYPE;
6801: v_source_port cz_servers.db_listener_port%TYPE;
6802: v_source_owner cz_servers.cz_owner%TYPE;

Line 6799: v_source_instance cz_servers.instance_name%TYPE;

6795: FUNCTION retrieve_db_link(p_server_id PLS_INTEGER)
6796: RETURN VARCHAR2
6797: IS
6798: v_source_id cz_servers.server_local_id%TYPE;
6799: v_source_instance cz_servers.instance_name%TYPE;
6800: v_source_host cz_servers.hostname%TYPE;
6801: v_source_port cz_servers.db_listener_port%TYPE;
6802: v_source_owner cz_servers.cz_owner%TYPE;
6803: v_target_id cz_servers.server_local_id%TYPE;

Line 6800: v_source_host cz_servers.hostname%TYPE;

6796: RETURN VARCHAR2
6797: IS
6798: v_source_id cz_servers.server_local_id%TYPE;
6799: v_source_instance cz_servers.instance_name%TYPE;
6800: v_source_host cz_servers.hostname%TYPE;
6801: v_source_port cz_servers.db_listener_port%TYPE;
6802: v_source_owner cz_servers.cz_owner%TYPE;
6803: v_target_id cz_servers.server_local_id%TYPE;
6804: v_target_instance cz_servers.instance_name%TYPE;

Line 6801: v_source_port cz_servers.db_listener_port%TYPE;

6797: IS
6798: v_source_id cz_servers.server_local_id%TYPE;
6799: v_source_instance cz_servers.instance_name%TYPE;
6800: v_source_host cz_servers.hostname%TYPE;
6801: v_source_port cz_servers.db_listener_port%TYPE;
6802: v_source_owner cz_servers.cz_owner%TYPE;
6803: v_target_id cz_servers.server_local_id%TYPE;
6804: v_target_instance cz_servers.instance_name%TYPE;
6805: v_target_host cz_servers.hostname%TYPE;

Line 6802: v_source_owner cz_servers.cz_owner%TYPE;

6798: v_source_id cz_servers.server_local_id%TYPE;
6799: v_source_instance cz_servers.instance_name%TYPE;
6800: v_source_host cz_servers.hostname%TYPE;
6801: v_source_port cz_servers.db_listener_port%TYPE;
6802: v_source_owner cz_servers.cz_owner%TYPE;
6803: v_target_id cz_servers.server_local_id%TYPE;
6804: v_target_instance cz_servers.instance_name%TYPE;
6805: v_target_host cz_servers.hostname%TYPE;
6806: v_target_port cz_servers.db_listener_port%TYPE;

Line 6803: v_target_id cz_servers.server_local_id%TYPE;

6799: v_source_instance cz_servers.instance_name%TYPE;
6800: v_source_host cz_servers.hostname%TYPE;
6801: v_source_port cz_servers.db_listener_port%TYPE;
6802: v_source_owner cz_servers.cz_owner%TYPE;
6803: v_target_id cz_servers.server_local_id%TYPE;
6804: v_target_instance cz_servers.instance_name%TYPE;
6805: v_target_host cz_servers.hostname%TYPE;
6806: v_target_port cz_servers.db_listener_port%TYPE;
6807: v_target_owner cz_servers.cz_owner%TYPE;

Line 6804: v_target_instance cz_servers.instance_name%TYPE;

6800: v_source_host cz_servers.hostname%TYPE;
6801: v_source_port cz_servers.db_listener_port%TYPE;
6802: v_source_owner cz_servers.cz_owner%TYPE;
6803: v_target_id cz_servers.server_local_id%TYPE;
6804: v_target_instance cz_servers.instance_name%TYPE;
6805: v_target_host cz_servers.hostname%TYPE;
6806: v_target_port cz_servers.db_listener_port%TYPE;
6807: v_target_owner cz_servers.cz_owner%TYPE;
6808: v_db_link cz_servers.cz_link_name%TYPE;

Line 6805: v_target_host cz_servers.hostname%TYPE;

6801: v_source_port cz_servers.db_listener_port%TYPE;
6802: v_source_owner cz_servers.cz_owner%TYPE;
6803: v_target_id cz_servers.server_local_id%TYPE;
6804: v_target_instance cz_servers.instance_name%TYPE;
6805: v_target_host cz_servers.hostname%TYPE;
6806: v_target_port cz_servers.db_listener_port%TYPE;
6807: v_target_owner cz_servers.cz_owner%TYPE;
6808: v_db_link cz_servers.cz_link_name%TYPE;
6809:

Line 6806: v_target_port cz_servers.db_listener_port%TYPE;

6802: v_source_owner cz_servers.cz_owner%TYPE;
6803: v_target_id cz_servers.server_local_id%TYPE;
6804: v_target_instance cz_servers.instance_name%TYPE;
6805: v_target_host cz_servers.hostname%TYPE;
6806: v_target_port cz_servers.db_listener_port%TYPE;
6807: v_target_owner cz_servers.cz_owner%TYPE;
6808: v_db_link cz_servers.cz_link_name%TYPE;
6809:
6810: CURSOR db_compare_cur(p_server_id PLS_INTEGER)

Line 6807: v_target_owner cz_servers.cz_owner%TYPE;

6803: v_target_id cz_servers.server_local_id%TYPE;
6804: v_target_instance cz_servers.instance_name%TYPE;
6805: v_target_host cz_servers.hostname%TYPE;
6806: v_target_port cz_servers.db_listener_port%TYPE;
6807: v_target_owner cz_servers.cz_owner%TYPE;
6808: v_db_link cz_servers.cz_link_name%TYPE;
6809:
6810: CURSOR db_compare_cur(p_server_id PLS_INTEGER)
6811: IS

Line 6808: v_db_link cz_servers.cz_link_name%TYPE;

6804: v_target_instance cz_servers.instance_name%TYPE;
6805: v_target_host cz_servers.hostname%TYPE;
6806: v_target_port cz_servers.db_listener_port%TYPE;
6807: v_target_owner cz_servers.cz_owner%TYPE;
6808: v_db_link cz_servers.cz_link_name%TYPE;
6809:
6810: CURSOR db_compare_cur(p_server_id PLS_INTEGER)
6811: IS
6812: SELECT server_local_id, instance_name, hostname, db_listener_port, cz_owner, fndnam_link_name

Line 6813: FROM cz_servers

6809:
6810: CURSOR db_compare_cur(p_server_id PLS_INTEGER)
6811: IS
6812: SELECT server_local_id, instance_name, hostname, db_listener_port, cz_owner, fndnam_link_name
6813: FROM cz_servers
6814: WHERE server_local_id = p_server_id OR server_local_id = 0
6815: ORDER BY server_local_id;
6816:
6817: v_compare_record db_compare_cur%ROWTYPE;

Line 7327: FROM cz_servers

7323:
7324: CURSOR db_link_cur(p_server_id PLS_INTEGER)
7325: IS
7326: SELECT local_name, fndnam_link_name
7327: FROM cz_servers
7328: WHERE server_local_id = p_server_id;
7329:
7330: v_link_record db_link_cur%ROWTYPE;
7331: v_str VARCHAR2(4000);

Line 7334: v_db_link cz_servers.fndnam_link_name%TYPE;

7330: v_link_record db_link_cur%ROWTYPE;
7331: v_str VARCHAR2(4000);
7332: db_schema_compare_cur ref_cursor;
7333: v_count PLS_INTEGER := 0;
7334: v_db_link cz_servers.fndnam_link_name%TYPE;
7335: BEGIN
7336: OPEN db_link_cur(target_server_id);
7337:
7338: LOOP

Line 9792: p_server_id IN cz_servers.server_local_id%TYPE

9788: ------@x_status --- publication status
9789: ------@p_model_id --- source model id
9790: ------@x_remote_model_id -- retrieved remote model id
9791: PROCEDURE get_remote_model_id(
9792: p_server_id IN cz_servers.server_local_id%TYPE
9793: ,p_model_id IN cz_pb_model_exports.model_id%TYPE
9794: ,x_status IN OUT NOCOPY VARCHAR2
9795: ,x_remote_model_id IN OUT NOCOPY cz_pb_model_exports.model_id%TYPE
9796: )

Line 10266: v_remote_link cz_servers.fndnam_link_name%TYPE;

10262: PROCEDURE remote_pb_check(p_publication_id NUMBER)
10263: IS
10264: remote_pb_cv ref_cursor;
10265: v_publication_id NUMBER := 0;
10266: v_remote_link cz_servers.fndnam_link_name%TYPE;
10267: BEGIN
10268: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
10269: THEN
10270: IF ((p_publication_id > 0) AND(cz_pb_mgr.v_session_parameter <> model_copy))

Line 10479: PROCEDURE verify_model_for_sync(p_server_id IN cz_servers.server_local_id%TYPE, p_model_id IN cz_devl_projects.devl_project_id%TYPE)

10475: -----@p_server_id is the target_server_id
10476: -----@p_model_id is the devl_project_id of the model being published
10477: -----@cz_pb_mgr.bom_flag is the out parameter: 'Y' indicates the model is to be
10478: -----synchronized. 'N' indicates that no sync is necessary.
10479: PROCEDURE verify_model_for_sync(p_server_id IN cz_servers.server_local_id%TYPE, p_model_id IN cz_devl_projects.devl_project_id%TYPE)
10480: AS
10481: v_source_server NUMBER;
10482: v_bom_persistent_node_id NUMBER;
10483: v_bom_ps_node_id NUMBER;

Line 10523: FROM cz_servers

10519: THEN
10520: BEGIN
10521: SELECT local_name
10522: INTO cz_pb_mgr.v_server_local_name
10523: FROM cz_servers
10524: WHERE cz_servers.server_local_id = p_server_id;
10525: EXCEPTION
10526: WHEN NO_DATA_FOUND
10527: THEN

Line 10524: WHERE cz_servers.server_local_id = p_server_id;

10520: BEGIN
10521: SELECT local_name
10522: INTO cz_pb_mgr.v_server_local_name
10523: FROM cz_servers
10524: WHERE cz_servers.server_local_id = p_server_id;
10525: EXCEPTION
10526: WHEN NO_DATA_FOUND
10527: THEN
10528: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_NO_SERVER_NAME_FOUND', 'SERVERID', p_server_id);

Line 11435: ,p_server_id IN cz_servers.server_local_id%TYPE

11431: -------procedure retrieves the component id
11432: PROCEDURE remote_component_id(
11433: p_resolved_key_value IN OUT NOCOPY NUMBER
11434: ,p_model_not_exported_array IN OUT NOCOPY cz_pb_mgr.t_ref
11435: ,p_server_id IN cz_servers.server_local_id%TYPE
11436: ,x_status IN OUT NOCOPY VARCHAR2
11437: )
11438: AS
11439: BEGIN

Line 11790: ,p_server_id IN cz_servers.server_local_id%TYPE

11786: -- Note: do get_rem_nodes_of_models early, then we can remove this ugly method as well as some other bad ones
11787: PROCEDURE update_remote_reference_ids(
11788: p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11789: ,p_new_ps_node_array IN OUT NOCOPY cz_pb_mgr.t_ref
11790: ,p_server_id IN cz_servers.server_local_id%TYPE
11791: ,x_status IN OUT NOCOPY VARCHAR2
11792: )
11793: AS
11794: l_sql_string VARCHAR2(32000);

Line 11836: --------@p_server_id :server local id of cz servers of the target instance

11832: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11833: --------procedure that resolves the virtual components of explosion records
11834: --------@p_model_ref_expls_ref :explosion array
11835: --------@p_models_not_exported :source models that are not exported
11836: --------@p_server_id :server local id of cz servers of the target instance
11837: --------@x_status :publication_status
11838: PROCEDURE resolve_virtual_components(
11839: p_model_ref_expls_ref IN OUT NOCOPY cz_pb_mgr.t_ref
11840: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref

Line 11841: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE

11837: --------@x_status :publication_status
11838: PROCEDURE resolve_virtual_components(
11839: p_model_ref_expls_ref IN OUT NOCOPY cz_pb_mgr.t_ref
11840: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11841: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
11842: ,x_status IN OUT NOCOPY VARCHAR2
11843: )
11844: AS
11845: rec_count PLS_INTEGER := 0;

Line 12054: p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE,

12050: -- source to corresponding remote Ids. This is exactly what this procedure does i.e. tt maps the
12051: -- source ui_def_ids to remote ui_def_ids in the table x_cz_ui_defs_idx_ref
12052: PROCEDURE get_uis_of_mdls_not_exported(p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref,
12053: x_cz_ui_defs_idx_ref IN OUT NOCOPY cz_pb_mgr.t_ref_idx_vc2,
12054: p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE,
12055: x_status IN OUT NOCOPY VARCHAR2)
12056: AS
12057:
12058: v_ui_defs_tbl cz_pb_mgr.t_ref;

Line 12156: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE

12152: PROCEDURE resolve_remote_ui_nodes(
12153: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
12154: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
12155: ,p_resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_ui_ref_id_ref
12156: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
12157: ,x_status IN OUT NOCOPY VARCHAR2
12158: )
12159: AS
12160: v_remote_ui_defs_ref cz_pb_mgr.t_ref;

Line 18597: -----------p_server_id: server_id from cz_servers that contains db info

18593: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18594: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18595: -----------deep model copy
18596: -----------p_model_id : devl_project_id of the model for which a copy is to be made.
18597: -----------p_server_id: server_id from cz_servers that contains db info
18598: -----------p_folder: folder to which the copy is made
18599: -----------p_copy_rules: flag 1 implies copy rules else 0
18600: -----------p_copy_uis: flag 1 implies copy uis
18601: -----------p_copy_root: flag 1 implies that only root model would be copied

Line 19895: v_instance_name cz_servers.instance_name%TYPE;

19891: RETURN VARCHAR2
19892: IS
19893: original_name cz_devl_projects.NAME%TYPE;
19894: v_name cz_devl_projects.NAME%TYPE;
19895: v_instance_name cz_servers.instance_name%TYPE;
19896: v_null PLS_INTEGER;
19897: l_endBr varchar2(3):=NULL;
19898: BEGIN
19899: BEGIN

Line 19902: FROM cz_servers

19898: BEGIN
19899: BEGIN
19900: SELECT instance_name
19901: INTO v_instance_name
19902: FROM cz_servers
19903: WHERE server_local_id = 0;
19904:
19905: SELECT NAME
19906: INTO original_name

Line 20015: v_import_server_on_remote cz_servers.server_local_id%TYPE;

20011: v_org_id cz_xfr_project_bills.organization_id%TYPE; -- Bug9031588
20012: v_component_item_id cz_xfr_project_bills.component_item_id%TYPE; -- Bug9031588
20013: v_top_item_id cz_xfr_project_bills.top_item_id%TYPE; -- Bug9031588
20014:
20015: v_import_server_on_remote cz_servers.server_local_id%TYPE;
20016: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;
20017: l_instance_nm cz_servers.instance_name%TYPE;
20018:
20019: has_no_priv_to_publish EXCEPTION;

Line 20016: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;

20012: v_component_item_id cz_xfr_project_bills.component_item_id%TYPE; -- Bug9031588
20013: v_top_item_id cz_xfr_project_bills.top_item_id%TYPE; -- Bug9031588
20014:
20015: v_import_server_on_remote cz_servers.server_local_id%TYPE;
20016: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;
20017: l_instance_nm cz_servers.instance_name%TYPE;
20018:
20019: has_no_priv_to_publish EXCEPTION;
20020: failed_to_lock_model EXCEPTION;

Line 20017: l_instance_nm cz_servers.instance_name%TYPE;

20013: v_top_item_id cz_xfr_project_bills.top_item_id%TYPE; -- Bug9031588
20014:
20015: v_import_server_on_remote cz_servers.server_local_id%TYPE;
20016: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;
20017: l_instance_nm cz_servers.instance_name%TYPE;
20018:
20019: has_no_priv_to_publish EXCEPTION;
20020: failed_to_lock_model EXCEPTION;
20021: priv_check_err EXCEPTION;

Line 20086: SELECT instance_name INTO l_instance_nm FROM CZ_SERVERS WHERE server_local_id = cz_pb_mgr.v_server_id;

20082:
20083: IF l_proc_name = l_publication_proc THEN
20084: -- bug #10417318
20085: IF (vMultiServerPub = 'YES') THEN
20086: SELECT instance_name INTO l_instance_nm FROM CZ_SERVERS WHERE server_local_id = cz_pb_mgr.v_server_id;
20087: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PARALLEL_PROCESS_EXISTS', 'PROC_TYPE', 'publication', 'TGT_NAME', l_instance_nm );
20088: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 1;
20089: ELSE
20090: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'publication');

Line 20181: * target. In order to do this we need to query CZ_SERVERS in the migration

20177: * On migrating a model to a remote server, if there are BOM models involved,
20178: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
20179: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
20180: * migration target. Currently it was being copied from the source to the
20181: * target. In order to do this we need to query CZ_SERVERS in the migration
20182: * target to get the SERVER_LOCAL_ID.
20183: */
20184:
20185: v_import_server_on_remote := getRemoteImportServer(l_target_imp_server_on_local);

Line 20983: v_cz_link_name cz_servers.cz_link_name%TYPE;

20979: ,x_msg_data OUT NOCOPY VARCHAR2
20980: )
20981: AS
20982: v_server_id cz_model_publications.server_id%TYPE;
20983: v_cz_link_name cz_servers.cz_link_name%TYPE;
20984: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
20985: v_export_status cz_model_publications.export_status%TYPE;
20986: l_tmp_publication NUMBER;
20987: l_object_type cz_model_publications.object_type%TYPE;

Line 21059: FROM cz_servers

21055: ELSE
21056: BEGIN
21057: SELECT fndnam_link_name
21058: INTO v_cz_link_name
21059: FROM cz_servers
21060: WHERE cz_servers.server_local_id = v_server_id;
21061: EXCEPTION
21062: WHEN OTHERS
21063: THEN

Line 21060: WHERE cz_servers.server_local_id = v_server_id;

21056: BEGIN
21057: SELECT fndnam_link_name
21058: INTO v_cz_link_name
21059: FROM cz_servers
21060: WHERE cz_servers.server_local_id = v_server_id;
21061: EXCEPTION
21062: WHEN OTHERS
21063: THEN
21064: v_cz_link_name := NULL;

Line 21186: v_cz_link_name cz_servers.cz_link_name%TYPE;

21182: ,x_msg_data OUT NOCOPY VARCHAR2
21183: )
21184: AS
21185: v_server_id cz_model_publications.server_id%TYPE;
21186: v_cz_link_name cz_servers.cz_link_name%TYPE;
21187: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21188: v_object_type cz_model_publications.object_type%TYPE;
21189: v_export_status cz_model_publications.export_status%TYPE;
21190: cannot_disable_template EXCEPTION;

Line 21213: FROM cz_servers

21209:
21210: BEGIN
21211: SELECT fndnam_link_name
21212: INTO v_cz_link_name
21213: FROM cz_servers
21214: WHERE cz_servers.server_local_id = v_server_id;
21215: EXCEPTION
21216: WHEN OTHERS
21217: THEN

Line 21214: WHERE cz_servers.server_local_id = v_server_id;

21210: BEGIN
21211: SELECT fndnam_link_name
21212: INTO v_cz_link_name
21213: FROM cz_servers
21214: WHERE cz_servers.server_local_id = v_server_id;
21215: EXCEPTION
21216: WHEN OTHERS
21217: THEN
21218: v_cz_link_name := NULL;

Line 21285: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE

21281: PROCEDURE get_edit_info(
21282: publicationid IN cz_model_publications.publication_id%TYPE
21283: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
21284: ,x_publication_mode IN OUT NOCOPY VARCHAR2
21285: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
21286: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
21287: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
21288: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
21289: )

Line 21439: ,p_tgt_link IN cz_servers.fndnam_link_name%TYPE

21435: -------->>>>>>>>>>>>>>>>>>>>>
21436: PROCEDURE insert_tgt_pb_data(
21437: p_status_str IN OUT NOCOPY VARCHAR2
21438: ,p_export_status IN cz_model_publications.export_status%TYPE
21439: ,p_tgt_link IN cz_servers.fndnam_link_name%TYPE
21440: ,p_publication_mode IN VARCHAR2
21441: ,p_start_date IN DATE
21442: ,p_disable_date IN DATE
21443: ,p_remote_publication_id IN cz_model_publications.remote_publication_id%TYPE

Line 22151: v_link_name cz_servers.fndnam_link_name%TYPE;

22147:
22148: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
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;

Line 22172: FROM cz_servers

22168: LOOP
22169: BEGIN
22170: SELECT fndnam_link_name
22171: INTO v_link_name
22172: FROM cz_servers
22173: WHERE server_local_id = i.server_id;
22174:
22175: v_db_link := '';
22176:

Line 22541: v_db_link cz_servers.fndnam_link_name%TYPE;

22537: ,x_reset_str IN OUT NOCOPY VARCHAR2
22538: ,x_status IN OUT NOCOPY VARCHAR2
22539: )
22540: AS
22541: v_db_link cz_servers.fndnam_link_name%TYPE;
22542: v_server_id cz_model_publications.server_id%TYPE;
22543: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22544: reset_date_error EXCEPTION;
22545: BEGIN

Line 22835: v_cz_link_name cz_servers.cz_link_name%TYPE;

22831: ,x_msg_data OUT NOCOPY VARCHAR2
22832: )
22833: AS
22834: v_server_id cz_model_publications.server_id%TYPE;
22835: v_cz_link_name cz_servers.cz_link_name%TYPE;
22836: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
22837: v_app_id_tbl cz_pb_mgr.t_ref;
22838: v_usg_id_tbl cz_pb_mgr.t_ref;
22839: v_lang_id_tbl cz_pb_mgr.t_lang_code;

Line 22892: FROM cz_servers

22888:
22889: BEGIN
22890: SELECT fndnam_link_name
22891: INTO v_cz_link_name
22892: FROM cz_servers
22893: WHERE cz_servers.server_local_id = v_server_id;
22894: EXCEPTION
22895: WHEN OTHERS
22896: THEN

Line 22893: WHERE cz_servers.server_local_id = v_server_id;

22889: BEGIN
22890: SELECT fndnam_link_name
22891: INTO v_cz_link_name
22892: FROM cz_servers
22893: WHERE cz_servers.server_local_id = v_server_id;
22894: EXCEPTION
22895: WHEN OTHERS
22896: THEN
22897: v_cz_link_name := NULL;

Line 25070: * target. In order to do this we need to query CZ_SERVERS in the migration

25066: * On migrating a model to a remote server, if there are BOM models involved,
25067: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
25068: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
25069: * migration target. Currently it was being copied from the source to the
25070: * target. In order to do this we need to query CZ_SERVERS in the migration
25071: * target to get the SERVER_LOCAL_ID.
25072: */
25073: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER
25074: AS

Line 25073: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER

25069: * migration target. Currently it was being copied from the source to the
25070: * target. In order to do this we need to query CZ_SERVERS in the migration
25071: * target to get the SERVER_LOCAL_ID.
25072: */
25073: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER
25074: AS
25075:
25076: l_sql_string VARCHAR2(2000);
25077: l_remote_server_id cz_servers.server_local_id%TYPE;

Line 25077: l_remote_server_id cz_servers.server_local_id%TYPE;

25073: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER
25074: AS
25075:
25076: l_sql_string VARCHAR2(2000);
25077: l_remote_server_id cz_servers.server_local_id%TYPE;
25078: l_hostname cz_servers.hostname%TYPE;
25079: l_db_listener_port cz_servers.db_listener_port%TYPE;
25080: l_instance_name cz_servers.instance_name%TYPE;
25081:

Line 25078: l_hostname cz_servers.hostname%TYPE;

25074: AS
25075:
25076: l_sql_string VARCHAR2(2000);
25077: l_remote_server_id cz_servers.server_local_id%TYPE;
25078: l_hostname cz_servers.hostname%TYPE;
25079: l_db_listener_port cz_servers.db_listener_port%TYPE;
25080: l_instance_name cz_servers.instance_name%TYPE;
25081:
25082: BEGIN

Line 25079: l_db_listener_port cz_servers.db_listener_port%TYPE;

25075:
25076: l_sql_string VARCHAR2(2000);
25077: l_remote_server_id cz_servers.server_local_id%TYPE;
25078: l_hostname cz_servers.hostname%TYPE;
25079: l_db_listener_port cz_servers.db_listener_port%TYPE;
25080: l_instance_name cz_servers.instance_name%TYPE;
25081:
25082: BEGIN
25083:

Line 25080: l_instance_name cz_servers.instance_name%TYPE;

25076: l_sql_string VARCHAR2(2000);
25077: l_remote_server_id cz_servers.server_local_id%TYPE;
25078: l_hostname cz_servers.hostname%TYPE;
25079: l_db_listener_port cz_servers.db_listener_port%TYPE;
25080: l_instance_name cz_servers.instance_name%TYPE;
25081:
25082: BEGIN
25083:
25084: l_sql_string := 'SELECT server_local_id, hostname, db_listener_port, instance_name' ||

Line 25085: ' FROM cz_servers' || cz_pb_mgr.v_db_link ||

25081:
25082: BEGIN
25083:
25084: l_sql_string := 'SELECT server_local_id, hostname, db_listener_port, instance_name' ||
25085: ' FROM cz_servers' || cz_pb_mgr.v_db_link ||
25086: ' WHERE import_enabled = 1';
25087:
25088: BEGIN
25089:

Line 25102: --Now we need to identify a record in the local cz_servers that points to the target's import

25098: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
25099: RAISE;
25100: END;
25101:
25102: --Now we need to identify a record in the local cz_servers that points to the target's import
25103: --source server. Per migration design, such record should exist.
25104: --We are not trying to detect the case when the target's import server is the migration source
25105: --itself - to do this we need to match the target's server record to the LOCAL record, but we
25106: --don't consistently populate instance parameters for the LOCAL record.

Line 25121: FOR c_server IN (SELECT server_local_id FROM cz_servers

25117:
25118: x_import_server_on_local := cz_pb_mgr.v_server_id;
25119: ELSE
25120:
25121: FOR c_server IN (SELECT server_local_id FROM cz_servers
25122: WHERE UPPER(LTRIM(RTRIM(db_listener_port))) = l_db_listener_port
25123: AND UPPER(LTRIM(RTRIM(hostname))) = l_hostname
25124: AND UPPER(LTRIM(RTRIM(instance_name))) = l_instance_name)LOOP
25125: