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 3454: l_link_name cz_servers.fndnam_link_name%TYPE;

3450: ,x_msg_data OUT NOCOPY VARCHAR2
3451: )
3452: IS
3453: l_jrad_doc_tbl jraddoc_type_tbl;
3454: l_link_name cz_servers.fndnam_link_name%TYPE;
3455: link_name_is_null EXCEPTION;
3456: BEGIN
3457: pbdebug := 22026;
3458:

Line 3555: l_link_name cz_servers.fndnam_link_name%TYPE;

3551: )
3552: IS
3553: l_ui_def_id_tbl cz_pb_mgr.t_ref;
3554: l_template_id_tbl cz_pb_mgr.t_ref;
3555: l_link_name cz_servers.fndnam_link_name%TYPE;
3556: link_name_is_null EXCEPTION;
3557: BEGIN
3558: IF (p_link_name IS NULL)
3559: THEN

Line 6172: v_source_id cz_servers.server_local_id%TYPE;

6168: ------------ to retrieve the db link
6169: FUNCTION retrieve_db_link(p_server_id PLS_INTEGER)
6170: RETURN VARCHAR2
6171: IS
6172: v_source_id cz_servers.server_local_id%TYPE;
6173: v_source_instance cz_servers.instance_name%TYPE;
6174: v_source_host cz_servers.hostname%TYPE;
6175: v_source_port cz_servers.db_listener_port%TYPE;
6176: v_source_owner cz_servers.cz_owner%TYPE;

Line 6173: v_source_instance cz_servers.instance_name%TYPE;

6169: FUNCTION retrieve_db_link(p_server_id PLS_INTEGER)
6170: RETURN VARCHAR2
6171: IS
6172: v_source_id cz_servers.server_local_id%TYPE;
6173: v_source_instance cz_servers.instance_name%TYPE;
6174: v_source_host cz_servers.hostname%TYPE;
6175: v_source_port cz_servers.db_listener_port%TYPE;
6176: v_source_owner cz_servers.cz_owner%TYPE;
6177: v_target_id cz_servers.server_local_id%TYPE;

Line 6174: v_source_host cz_servers.hostname%TYPE;

6170: RETURN VARCHAR2
6171: IS
6172: v_source_id cz_servers.server_local_id%TYPE;
6173: v_source_instance cz_servers.instance_name%TYPE;
6174: v_source_host cz_servers.hostname%TYPE;
6175: v_source_port cz_servers.db_listener_port%TYPE;
6176: v_source_owner cz_servers.cz_owner%TYPE;
6177: v_target_id cz_servers.server_local_id%TYPE;
6178: v_target_instance cz_servers.instance_name%TYPE;

Line 6175: v_source_port cz_servers.db_listener_port%TYPE;

6171: IS
6172: v_source_id cz_servers.server_local_id%TYPE;
6173: v_source_instance cz_servers.instance_name%TYPE;
6174: v_source_host cz_servers.hostname%TYPE;
6175: v_source_port cz_servers.db_listener_port%TYPE;
6176: v_source_owner cz_servers.cz_owner%TYPE;
6177: v_target_id cz_servers.server_local_id%TYPE;
6178: v_target_instance cz_servers.instance_name%TYPE;
6179: v_target_host cz_servers.hostname%TYPE;

Line 6176: v_source_owner cz_servers.cz_owner%TYPE;

6172: v_source_id cz_servers.server_local_id%TYPE;
6173: v_source_instance cz_servers.instance_name%TYPE;
6174: v_source_host cz_servers.hostname%TYPE;
6175: v_source_port cz_servers.db_listener_port%TYPE;
6176: v_source_owner cz_servers.cz_owner%TYPE;
6177: v_target_id cz_servers.server_local_id%TYPE;
6178: v_target_instance cz_servers.instance_name%TYPE;
6179: v_target_host cz_servers.hostname%TYPE;
6180: v_target_port cz_servers.db_listener_port%TYPE;

Line 6177: v_target_id cz_servers.server_local_id%TYPE;

6173: v_source_instance cz_servers.instance_name%TYPE;
6174: v_source_host cz_servers.hostname%TYPE;
6175: v_source_port cz_servers.db_listener_port%TYPE;
6176: v_source_owner cz_servers.cz_owner%TYPE;
6177: v_target_id cz_servers.server_local_id%TYPE;
6178: v_target_instance cz_servers.instance_name%TYPE;
6179: v_target_host cz_servers.hostname%TYPE;
6180: v_target_port cz_servers.db_listener_port%TYPE;
6181: v_target_owner cz_servers.cz_owner%TYPE;

Line 6178: v_target_instance cz_servers.instance_name%TYPE;

6174: v_source_host cz_servers.hostname%TYPE;
6175: v_source_port cz_servers.db_listener_port%TYPE;
6176: v_source_owner cz_servers.cz_owner%TYPE;
6177: v_target_id cz_servers.server_local_id%TYPE;
6178: v_target_instance cz_servers.instance_name%TYPE;
6179: v_target_host cz_servers.hostname%TYPE;
6180: v_target_port cz_servers.db_listener_port%TYPE;
6181: v_target_owner cz_servers.cz_owner%TYPE;
6182: v_db_link cz_servers.cz_link_name%TYPE;

Line 6179: v_target_host cz_servers.hostname%TYPE;

6175: v_source_port cz_servers.db_listener_port%TYPE;
6176: v_source_owner cz_servers.cz_owner%TYPE;
6177: v_target_id cz_servers.server_local_id%TYPE;
6178: v_target_instance cz_servers.instance_name%TYPE;
6179: v_target_host cz_servers.hostname%TYPE;
6180: v_target_port cz_servers.db_listener_port%TYPE;
6181: v_target_owner cz_servers.cz_owner%TYPE;
6182: v_db_link cz_servers.cz_link_name%TYPE;
6183:

Line 6180: v_target_port cz_servers.db_listener_port%TYPE;

6176: v_source_owner cz_servers.cz_owner%TYPE;
6177: v_target_id cz_servers.server_local_id%TYPE;
6178: v_target_instance cz_servers.instance_name%TYPE;
6179: v_target_host cz_servers.hostname%TYPE;
6180: v_target_port cz_servers.db_listener_port%TYPE;
6181: v_target_owner cz_servers.cz_owner%TYPE;
6182: v_db_link cz_servers.cz_link_name%TYPE;
6183:
6184: CURSOR db_compare_cur(p_server_id PLS_INTEGER)

Line 6181: v_target_owner cz_servers.cz_owner%TYPE;

6177: v_target_id cz_servers.server_local_id%TYPE;
6178: v_target_instance cz_servers.instance_name%TYPE;
6179: v_target_host cz_servers.hostname%TYPE;
6180: v_target_port cz_servers.db_listener_port%TYPE;
6181: v_target_owner cz_servers.cz_owner%TYPE;
6182: v_db_link cz_servers.cz_link_name%TYPE;
6183:
6184: CURSOR db_compare_cur(p_server_id PLS_INTEGER)
6185: IS

Line 6182: v_db_link cz_servers.cz_link_name%TYPE;

6178: v_target_instance cz_servers.instance_name%TYPE;
6179: v_target_host cz_servers.hostname%TYPE;
6180: v_target_port cz_servers.db_listener_port%TYPE;
6181: v_target_owner cz_servers.cz_owner%TYPE;
6182: v_db_link cz_servers.cz_link_name%TYPE;
6183:
6184: CURSOR db_compare_cur(p_server_id PLS_INTEGER)
6185: IS
6186: SELECT server_local_id, instance_name, hostname, db_listener_port, cz_owner, fndnam_link_name

Line 6187: FROM cz_servers

6183:
6184: CURSOR db_compare_cur(p_server_id PLS_INTEGER)
6185: IS
6186: SELECT server_local_id, instance_name, hostname, db_listener_port, cz_owner, fndnam_link_name
6187: FROM cz_servers
6188: WHERE server_local_id = p_server_id OR server_local_id = 0
6189: ORDER BY server_local_id;
6190:
6191: v_compare_record db_compare_cur%ROWTYPE;

Line 6606: FROM cz_servers

6602:
6603: CURSOR db_link_cur(p_server_id PLS_INTEGER)
6604: IS
6605: SELECT local_name, fndnam_link_name
6606: FROM cz_servers
6607: WHERE server_local_id = p_server_id;
6608:
6609: v_link_record db_link_cur%ROWTYPE;
6610: v_str VARCHAR2(4000);

Line 6613: v_db_link cz_servers.fndnam_link_name%TYPE;

6609: v_link_record db_link_cur%ROWTYPE;
6610: v_str VARCHAR2(4000);
6611: db_schema_compare_cur ref_cursor;
6612: v_count PLS_INTEGER := 0;
6613: v_db_link cz_servers.fndnam_link_name%TYPE;
6614: BEGIN
6615: OPEN db_link_cur(target_server_id);
6616:
6617: LOOP

Line 9036: p_server_id IN cz_servers.server_local_id%TYPE

9032: ------@x_status --- publication status
9033: ------@p_model_id --- source model id
9034: ------@x_remote_model_id -- retrieved remote model id
9035: PROCEDURE get_remote_model_id(
9036: p_server_id IN cz_servers.server_local_id%TYPE
9037: ,p_model_id IN cz_pb_model_exports.model_id%TYPE
9038: ,x_status IN OUT NOCOPY VARCHAR2
9039: ,x_remote_model_id IN OUT NOCOPY cz_pb_model_exports.model_id%TYPE
9040: )

Line 9510: v_remote_link cz_servers.fndnam_link_name%TYPE;

9506: PROCEDURE remote_pb_check(p_publication_id NUMBER)
9507: IS
9508: remote_pb_cv ref_cursor;
9509: v_publication_id NUMBER := 0;
9510: v_remote_link cz_servers.fndnam_link_name%TYPE;
9511: BEGIN
9512: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
9513: THEN
9514: IF ((p_publication_id > 0) AND(cz_pb_mgr.v_session_parameter <> model_copy))

Line 9723: 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)

9719: -----@p_server_id is the target_server_id
9720: -----@p_model_id is the devl_project_id of the model being published
9721: -----@cz_pb_mgr.bom_flag is the out parameter: 'Y' indicates the model is to be
9722: -----synchronized. 'N' indicates that no sync is necessary.
9723: 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)
9724: AS
9725: v_source_server NUMBER;
9726: v_bom_persistent_node_id NUMBER;
9727: v_bom_ps_node_id NUMBER;

Line 9767: FROM cz_servers

9763: THEN
9764: BEGIN
9765: SELECT local_name
9766: INTO cz_pb_mgr.v_server_local_name
9767: FROM cz_servers
9768: WHERE cz_servers.server_local_id = p_server_id;
9769: EXCEPTION
9770: WHEN NO_DATA_FOUND
9771: THEN

Line 9768: WHERE cz_servers.server_local_id = p_server_id;

9764: BEGIN
9765: SELECT local_name
9766: INTO cz_pb_mgr.v_server_local_name
9767: FROM cz_servers
9768: WHERE cz_servers.server_local_id = p_server_id;
9769: EXCEPTION
9770: WHEN NO_DATA_FOUND
9771: THEN
9772: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_NO_SERVER_NAME_FOUND', 'SERVERID', p_server_id);

Line 10679: ,p_server_id IN cz_servers.server_local_id%TYPE

10675: -------procedure retrieves the component id
10676: PROCEDURE remote_component_id(
10677: p_resolved_key_value IN OUT NOCOPY NUMBER
10678: ,p_model_not_exported_array IN OUT NOCOPY cz_pb_mgr.t_ref
10679: ,p_server_id IN cz_servers.server_local_id%TYPE
10680: ,x_status IN OUT NOCOPY VARCHAR2
10681: )
10682: AS
10683: BEGIN

Line 11034: ,p_server_id IN cz_servers.server_local_id%TYPE

11030: -- Note: do get_rem_nodes_of_models early, then we can remove this ugly method as well as some other bad ones
11031: PROCEDURE update_remote_reference_ids(
11032: p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11033: ,p_new_ps_node_array IN OUT NOCOPY cz_pb_mgr.t_ref
11034: ,p_server_id IN cz_servers.server_local_id%TYPE
11035: ,x_status IN OUT NOCOPY VARCHAR2
11036: )
11037: AS
11038: l_sql_string VARCHAR2(32000);

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

11076: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11077: --------procedure that resolves the virtual components of explosion records
11078: --------@p_model_ref_expls_ref :explosion array
11079: --------@p_models_not_exported :source models that are not exported
11080: --------@p_server_id :server local id of cz servers of the target instance
11081: --------@x_status :publication_status
11082: PROCEDURE resolve_virtual_components(
11083: p_model_ref_expls_ref IN OUT NOCOPY cz_pb_mgr.t_ref
11084: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref

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

11081: --------@x_status :publication_status
11082: PROCEDURE resolve_virtual_components(
11083: p_model_ref_expls_ref IN OUT NOCOPY cz_pb_mgr.t_ref
11084: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11085: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
11086: ,x_status IN OUT NOCOPY VARCHAR2
11087: )
11088: AS
11089: rec_count PLS_INTEGER := 0;

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

11294: -- source to corresponding remote Ids. This is exactly what this procedure does i.e. tt maps the
11295: -- source ui_def_ids to remote ui_def_ids in the table x_cz_ui_defs_idx_ref
11296: PROCEDURE get_uis_of_mdls_not_exported(p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref,
11297: x_cz_ui_defs_idx_ref IN OUT NOCOPY cz_pb_mgr.t_ref_idx_vc2,
11298: p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE,
11299: x_status IN OUT NOCOPY VARCHAR2)
11300: AS
11301:
11302: v_ui_defs_tbl cz_pb_mgr.t_ref;

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

11396: PROCEDURE resolve_remote_ui_nodes(
11397: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
11398: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11399: ,p_resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_ui_ref_id_ref
11400: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
11401: ,x_status IN OUT NOCOPY VARCHAR2
11402: )
11403: AS
11404: v_remote_ui_defs_ref cz_pb_mgr.t_ref;

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

17450: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
17451: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
17452: -----------deep model copy
17453: -----------p_model_id : devl_project_id of the model for which a copy is to be made.
17454: -----------p_server_id: server_id from cz_servers that contains db info
17455: -----------p_folder: folder to which the copy is made
17456: -----------p_copy_rules: flag 1 implies copy rules else 0
17457: -----------p_copy_uis: flag 1 implies copy uis
17458: -----------p_copy_root: flag 1 implies that only root model would be copied

Line 18758: v_instance_name cz_servers.instance_name%TYPE;

18754: RETURN VARCHAR2
18755: IS
18756: original_name cz_devl_projects.NAME%TYPE;
18757: v_name cz_devl_projects.NAME%TYPE;
18758: v_instance_name cz_servers.instance_name%TYPE;
18759: v_null PLS_INTEGER;
18760: l_endBr varchar2(3):=NULL;
18761: BEGIN
18762: BEGIN

Line 18765: FROM cz_servers

18761: BEGIN
18762: BEGIN
18763: SELECT instance_name
18764: INTO v_instance_name
18765: FROM cz_servers
18766: WHERE server_local_id = 0;
18767:
18768: SELECT NAME
18769: INTO original_name

Line 18875: v_import_server_on_remote cz_servers.server_local_id%TYPE;

18871: l_targrootpath VARCHAR2(32000);
18872: l_srcmodel VARCHAR2(32000);
18873: l_tgt_fld_path VARCHAR2(32000);
18874:
18875: v_import_server_on_remote cz_servers.server_local_id%TYPE;
18876: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;
18877:
18878: has_no_priv_to_publish EXCEPTION;
18879: failed_to_lock_model EXCEPTION;

Line 18876: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;

18872: l_srcmodel VARCHAR2(32000);
18873: l_tgt_fld_path VARCHAR2(32000);
18874:
18875: v_import_server_on_remote cz_servers.server_local_id%TYPE;
18876: l_target_imp_server_on_local cz_servers.server_local_id%TYPE;
18877:
18878: has_no_priv_to_publish EXCEPTION;
18879: failed_to_lock_model EXCEPTION;
18880: priv_check_err EXCEPTION;

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

19008: * On migrating a model to a remote server, if there are BOM models involved,
19009: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
19010: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
19011: * migration target. Currently it was being copied from the source to the
19012: * target. In order to do this we need to query CZ_SERVERS in the migration
19013: * target to get the SERVER_LOCAL_ID.
19014: */
19015:
19016: v_import_server_on_remote := getRemoteImportServer(l_target_imp_server_on_local);

Line 19775: v_cz_link_name cz_servers.cz_link_name%TYPE;

19771: ,x_msg_data OUT NOCOPY VARCHAR2
19772: )
19773: AS
19774: v_server_id cz_model_publications.server_id%TYPE;
19775: v_cz_link_name cz_servers.cz_link_name%TYPE;
19776: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19777: v_export_status cz_model_publications.export_status%TYPE;
19778: l_tmp_publication NUMBER;
19779: l_object_type cz_model_publications.object_type%TYPE;

Line 19850: FROM cz_servers

19846: ELSE
19847: BEGIN
19848: SELECT fndnam_link_name
19849: INTO v_cz_link_name
19850: FROM cz_servers
19851: WHERE cz_servers.server_local_id = v_server_id;
19852: EXCEPTION
19853: WHEN OTHERS
19854: THEN

Line 19851: WHERE cz_servers.server_local_id = v_server_id;

19847: BEGIN
19848: SELECT fndnam_link_name
19849: INTO v_cz_link_name
19850: FROM cz_servers
19851: WHERE cz_servers.server_local_id = v_server_id;
19852: EXCEPTION
19853: WHEN OTHERS
19854: THEN
19855: v_cz_link_name := NULL;

Line 19977: v_cz_link_name cz_servers.cz_link_name%TYPE;

19973: ,x_msg_data OUT NOCOPY VARCHAR2
19974: )
19975: AS
19976: v_server_id cz_model_publications.server_id%TYPE;
19977: v_cz_link_name cz_servers.cz_link_name%TYPE;
19978: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
19979: v_object_type cz_model_publications.object_type%TYPE;
19980: v_export_status cz_model_publications.export_status%TYPE;
19981: cannot_disable_template EXCEPTION;

Line 20004: FROM cz_servers

20000:
20001: BEGIN
20002: SELECT fndnam_link_name
20003: INTO v_cz_link_name
20004: FROM cz_servers
20005: WHERE cz_servers.server_local_id = v_server_id;
20006: EXCEPTION
20007: WHEN OTHERS
20008: THEN

Line 20005: WHERE cz_servers.server_local_id = v_server_id;

20001: BEGIN
20002: SELECT fndnam_link_name
20003: INTO v_cz_link_name
20004: FROM cz_servers
20005: WHERE cz_servers.server_local_id = v_server_id;
20006: EXCEPTION
20007: WHEN OTHERS
20008: THEN
20009: v_cz_link_name := NULL;

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

20072: PROCEDURE get_edit_info(
20073: publicationid IN cz_model_publications.publication_id%TYPE
20074: ,x_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
20075: ,x_publication_mode IN OUT NOCOPY VARCHAR2
20076: ,x_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
20077: ,x_export_status IN OUT NOCOPY cz_model_publications.export_status%TYPE
20078: ,x_source_target_flag IN OUT NOCOPY cz_model_publications.source_target_flag%TYPE
20079: ,x_remote_publication_id IN OUT NOCOPY cz_model_publications.remote_publication_id%TYPE
20080: )

Line 20230: ,p_tgt_link IN cz_servers.fndnam_link_name%TYPE

20226: -------->>>>>>>>>>>>>>>>>>>>>
20227: PROCEDURE insert_tgt_pb_data(
20228: p_status_str IN OUT NOCOPY VARCHAR2
20229: ,p_export_status IN cz_model_publications.export_status%TYPE
20230: ,p_tgt_link IN cz_servers.fndnam_link_name%TYPE
20231: ,p_publication_mode IN VARCHAR2
20232: ,p_start_date IN DATE
20233: ,p_disable_date IN DATE
20234: ,p_remote_publication_id IN cz_model_publications.remote_publication_id%TYPE

Line 20942: v_link_name cz_servers.fndnam_link_name%TYPE;

20938:
20939: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
20940: PROCEDURE reset_processing_pubs
20941: IS
20942: v_link_name cz_servers.fndnam_link_name%TYPE;
20943: v_db_link VARCHAR2(255);
20944: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20945: BEGIN
20946: fnd_msg_pub.initialize;

Line 20963: FROM cz_servers

20959: LOOP
20960: BEGIN
20961: SELECT fndnam_link_name
20962: INTO v_link_name
20963: FROM cz_servers
20964: WHERE server_local_id = i.server_id;
20965:
20966: v_db_link := '';
20967:

Line 21332: v_db_link cz_servers.fndnam_link_name%TYPE;

21328: ,x_reset_str IN OUT NOCOPY VARCHAR2
21329: ,x_status IN OUT NOCOPY VARCHAR2
21330: )
21331: AS
21332: v_db_link cz_servers.fndnam_link_name%TYPE;
21333: v_server_id cz_model_publications.server_id%TYPE;
21334: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21335: reset_date_error EXCEPTION;
21336: BEGIN

Line 21626: v_cz_link_name cz_servers.cz_link_name%TYPE;

21622: ,x_msg_data OUT NOCOPY VARCHAR2
21623: )
21624: AS
21625: v_server_id cz_model_publications.server_id%TYPE;
21626: v_cz_link_name cz_servers.cz_link_name%TYPE;
21627: v_remote_publication_id cz_model_publications.remote_publication_id%TYPE;
21628: v_app_id_tbl cz_pb_mgr.t_ref;
21629: v_usg_id_tbl cz_pb_mgr.t_ref;
21630: v_lang_id_tbl cz_pb_mgr.t_lang_code;

Line 21683: FROM cz_servers

21679:
21680: BEGIN
21681: SELECT fndnam_link_name
21682: INTO v_cz_link_name
21683: FROM cz_servers
21684: WHERE cz_servers.server_local_id = v_server_id;
21685: EXCEPTION
21686: WHEN OTHERS
21687: THEN

Line 21684: WHERE cz_servers.server_local_id = v_server_id;

21680: BEGIN
21681: SELECT fndnam_link_name
21682: INTO v_cz_link_name
21683: FROM cz_servers
21684: WHERE cz_servers.server_local_id = v_server_id;
21685: EXCEPTION
21686: WHEN OTHERS
21687: THEN
21688: v_cz_link_name := NULL;

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

23555: * On migrating a model to a remote server, if there are BOM models involved,
23556: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
23557: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
23558: * migration target. Currently it was being copied from the source to the
23559: * target. In order to do this we need to query CZ_SERVERS in the migration
23560: * target to get the SERVER_LOCAL_ID.
23561: */
23562: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER
23563: AS

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

23558: * migration target. Currently it was being copied from the source to the
23559: * target. In order to do this we need to query CZ_SERVERS in the migration
23560: * target to get the SERVER_LOCAL_ID.
23561: */
23562: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER
23563: AS
23564:
23565: l_sql_string VARCHAR2(2000);
23566: l_remote_server_id cz_servers.server_local_id%TYPE;

Line 23566: l_remote_server_id cz_servers.server_local_id%TYPE;

23562: FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER
23563: AS
23564:
23565: l_sql_string VARCHAR2(2000);
23566: l_remote_server_id cz_servers.server_local_id%TYPE;
23567: l_hostname cz_servers.hostname%TYPE;
23568: l_db_listener_port cz_servers.db_listener_port%TYPE;
23569: l_instance_name cz_servers.instance_name%TYPE;
23570:

Line 23567: l_hostname cz_servers.hostname%TYPE;

23563: AS
23564:
23565: l_sql_string VARCHAR2(2000);
23566: l_remote_server_id cz_servers.server_local_id%TYPE;
23567: l_hostname cz_servers.hostname%TYPE;
23568: l_db_listener_port cz_servers.db_listener_port%TYPE;
23569: l_instance_name cz_servers.instance_name%TYPE;
23570:
23571: BEGIN

Line 23568: l_db_listener_port cz_servers.db_listener_port%TYPE;

23564:
23565: l_sql_string VARCHAR2(2000);
23566: l_remote_server_id cz_servers.server_local_id%TYPE;
23567: l_hostname cz_servers.hostname%TYPE;
23568: l_db_listener_port cz_servers.db_listener_port%TYPE;
23569: l_instance_name cz_servers.instance_name%TYPE;
23570:
23571: BEGIN
23572:

Line 23569: l_instance_name cz_servers.instance_name%TYPE;

23565: l_sql_string VARCHAR2(2000);
23566: l_remote_server_id cz_servers.server_local_id%TYPE;
23567: l_hostname cz_servers.hostname%TYPE;
23568: l_db_listener_port cz_servers.db_listener_port%TYPE;
23569: l_instance_name cz_servers.instance_name%TYPE;
23570:
23571: BEGIN
23572:
23573: l_sql_string := 'SELECT server_local_id, hostname, db_listener_port, instance_name' ||

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

23570:
23571: BEGIN
23572:
23573: l_sql_string := 'SELECT server_local_id, hostname, db_listener_port, instance_name' ||
23574: ' FROM cz_servers' || cz_pb_mgr.v_db_link ||
23575: ' WHERE import_enabled = 1';
23576:
23577: BEGIN
23578:

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

23587: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23588: RAISE;
23589: END;
23590:
23591: --Now we need to identify a record in the local cz_servers that points to the target's import
23592: --source server. Per migration design, such record should exist.
23593: --We are not trying to detect the case when the target's import server is the migration source
23594: --itself - to do this we need to match the target's server record to the LOCAL record, but we
23595: --don't consistently populate instance parameters for the LOCAL record.

Line 23610: FOR c_server IN (SELECT server_local_id FROM cz_servers

23606:
23607: x_import_server_on_local := cz_pb_mgr.v_server_id;
23608: ELSE
23609:
23610: FOR c_server IN (SELECT server_local_id FROM cz_servers
23611: WHERE UPPER(LTRIM(RTRIM(db_listener_port))) = l_db_listener_port
23612: AND UPPER(LTRIM(RTRIM(hostname))) = l_hostname
23613: AND UPPER(LTRIM(RTRIM(instance_name))) = l_instance_name)LOOP
23614: