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_SYNC dependencies on CZ_SERVERS

Line 11: SRC_SERVER_FLAG cz_servers.source_server_flag%TYPE := '1';

7:
8: m_msg_tbl cz_pb_sync_util.message_list;
9: m_err_message VARCHAR2(2000);
10:
11: SRC_SERVER_FLAG cz_servers.source_server_flag%TYPE := '1';
12:
13: OBJECT_TYPE_PROJECT CONSTANT cz_model_publications.object_type%TYPE := 'PRJ';
14: OBJECT_TYPE_UITEMPL CONSTANT cz_model_publications.object_type%TYPE := 'UIT';
15: GLOBAL_UI_DEF_PUB CONSTANT NUMBER := 1;

Line 39: FUNCTION verify_src_server_entry( p_link_name cz_servers.fndnam_link_name%TYPE

35: END error_msg_populate;
36:
37: ------------------------------------------------------
38: -----verifies source server entry on the target instance
39: FUNCTION verify_src_server_entry( p_link_name cz_servers.fndnam_link_name%TYPE
40: ,p_source_server cz_servers.local_name%TYPE)
41: RETURN BOOLEAN
42: IS
43:

Line 40: ,p_source_server cz_servers.local_name%TYPE)

36:
37: ------------------------------------------------------
38: -----verifies source server entry on the target instance
39: FUNCTION verify_src_server_entry( p_link_name cz_servers.fndnam_link_name%TYPE
40: ,p_source_server cz_servers.local_name%TYPE)
41: RETURN BOOLEAN
42: IS
43:
44: gl_ref_cursor REF_CURSOR;

Line 45: l_source_server_flag cz_servers.source_server_flag%TYPE;

41: RETURN BOOLEAN
42: IS
43:
44: gl_ref_cursor REF_CURSOR;
45: l_source_server_flag cz_servers.source_server_flag%TYPE;
46:
47: BEGIN
48: OPEN gl_ref_cursor FOR 'SELECT source_server_flag
49: FROM cz_servers'||p_link_name||' t

Line 49: FROM cz_servers'||p_link_name||' t

45: l_source_server_flag cz_servers.source_server_flag%TYPE;
46:
47: BEGIN
48: OPEN gl_ref_cursor FOR 'SELECT source_server_flag
49: FROM cz_servers'||p_link_name||' t
50: WHERE UPPER(t.local_name) = UPPER(:1)' USING p_source_server;
51: LOOP
52: FETCH gl_ref_cursor INTO l_source_server_flag;
53: EXIT WHEN gl_ref_cursor%NOTFOUND;

Line 79: l_hostname cz_servers.hostname%TYPE;

75: v_flag BOOLEAN := TRUE;
76: x_src_verification NUMBER := 0;
77: gl_ref_cursor REF_CURSOR;
78:
79: l_hostname cz_servers.hostname%TYPE;
80: l_instance_name cz_servers.instance_name%TYPE;
81: l_src_server_flg cz_servers.source_server_flag%TYPE;
82: l_src_count NUMBER;
83:

Line 80: l_instance_name cz_servers.instance_name%TYPE;

76: x_src_verification NUMBER := 0;
77: gl_ref_cursor REF_CURSOR;
78:
79: l_hostname cz_servers.hostname%TYPE;
80: l_instance_name cz_servers.instance_name%TYPE;
81: l_src_server_flg cz_servers.source_server_flag%TYPE;
82: l_src_count NUMBER;
83:
84: v_target_server_id NUMBER := 0;

Line 81: l_src_server_flg cz_servers.source_server_flag%TYPE;

77: gl_ref_cursor REF_CURSOR;
78:
79: l_hostname cz_servers.hostname%TYPE;
80: l_instance_name cz_servers.instance_name%TYPE;
81: l_src_server_flg cz_servers.source_server_flag%TYPE;
82: l_src_count NUMBER;
83:
84: v_target_server_id NUMBER := 0;
85: v_link_name cz_servers.fndnam_link_name%TYPE;

Line 85: v_link_name cz_servers.fndnam_link_name%TYPE;

81: l_src_server_flg cz_servers.source_server_flag%TYPE;
82: l_src_count NUMBER;
83:
84: v_target_server_id NUMBER := 0;
85: v_link_name cz_servers.fndnam_link_name%TYPE;
86:
87: CURSOR src_server_info IS SELECT hostname, instance_name, source_server_flag
88: FROM cz_servers
89: WHERE UPPER(local_name) = 'LOCAL';

Line 88: FROM cz_servers

84: v_target_server_id NUMBER := 0;
85: v_link_name cz_servers.fndnam_link_name%TYPE;
86:
87: CURSOR src_server_info IS SELECT hostname, instance_name, source_server_flag
88: FROM cz_servers
89: WHERE UPPER(local_name) = 'LOCAL';
90:
91: BEGIN
92: --------compare instance information

Line 102: FROM cz_servers

98: CLOSE src_server_info;
99:
100: SELECT COUNT(*)
101: INTO l_src_count
102: FROM cz_servers
103: WHERE cz_servers.source_server_flag = SRC_SERVER_FLAG;
104:
105: IF (l_src_count <> 0) THEN
106: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_NOT_SRC_INSTANCE', 'INSTANCE', l_instance_name);

Line 103: WHERE cz_servers.source_server_flag = SRC_SERVER_FLAG;

99:
100: SELECT COUNT(*)
101: INTO l_src_count
102: FROM cz_servers
103: WHERE cz_servers.source_server_flag = SRC_SERVER_FLAG;
104:
105: IF (l_src_count <> 0) THEN
106: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_NOT_SRC_INSTANCE', 'INSTANCE', l_instance_name);
107: error_msg_populate(m_err_message ,'CZ_PB_SYNC.VERIFYSRCINST',21061);

Line 141: FUNCTION check_target_instance(p_link_name IN cz_servers.fndnam_link_name%TYPE)

137: END verify_source_instance;
138:
139: -------------------------------------------------------------
140: -----function that checks if the target instance is a clone
141: FUNCTION check_target_instance(p_link_name IN cz_servers.fndnam_link_name%TYPE)
142: RETURN BOOLEAN
143: IS
144:
145: gl_ref_cursor REF_CURSOR;

Line 146: l_instance_name cz_servers.instance_name%TYPE;

142: RETURN BOOLEAN
143: IS
144:
145: gl_ref_cursor REF_CURSOR;
146: l_instance_name cz_servers.instance_name%TYPE;
147: l_host_name cz_servers.hostname%TYPE;
148: v_instance_name cz_servers.instance_name%TYPE;
149: v_host_name cz_servers.hostname%TYPE;
150: v_notes VARCHAR2(2000);

Line 147: l_host_name cz_servers.hostname%TYPE;

143: IS
144:
145: gl_ref_cursor REF_CURSOR;
146: l_instance_name cz_servers.instance_name%TYPE;
147: l_host_name cz_servers.hostname%TYPE;
148: v_instance_name cz_servers.instance_name%TYPE;
149: v_host_name cz_servers.hostname%TYPE;
150: v_notes VARCHAR2(2000);
151: v_return_flg BOOLEAN := FALSE;

Line 148: v_instance_name cz_servers.instance_name%TYPE;

144:
145: gl_ref_cursor REF_CURSOR;
146: l_instance_name cz_servers.instance_name%TYPE;
147: l_host_name cz_servers.hostname%TYPE;
148: v_instance_name cz_servers.instance_name%TYPE;
149: v_host_name cz_servers.hostname%TYPE;
150: v_notes VARCHAR2(2000);
151: v_return_flg BOOLEAN := FALSE;
152:

Line 149: v_host_name cz_servers.hostname%TYPE;

145: gl_ref_cursor REF_CURSOR;
146: l_instance_name cz_servers.instance_name%TYPE;
147: l_host_name cz_servers.hostname%TYPE;
148: v_instance_name cz_servers.instance_name%TYPE;
149: v_host_name cz_servers.hostname%TYPE;
150: v_notes VARCHAR2(2000);
151: v_return_flg BOOLEAN := FALSE;
152:
153: BEGIN

Line 163: FROM cz_servers'||p_link_name||' t

159: END LOOP;
160: CLOSE gl_ref_cursor;
161:
162: OPEN gl_ref_cursor FOR 'SELECT instance_name,hostname,notes
163: FROM cz_servers'||p_link_name||' t
164: WHERE UPPER(local_name) = ''LOCAL'' ';
165: LOOP
166: FETCH gl_ref_cursor INTO v_instance_name,v_host_name,v_notes;
167: EXIT WHEN gl_ref_cursor%NOTFOUND;

Line 194: FUNCTION get_tgt_server_id(p_link_name cz_servers.fndnam_link_name%TYPE)

190: END check_target_instance;
191:
192: -------------------------------------------------
193: -----function that returns the server id of the cloned instance
194: FUNCTION get_tgt_server_id(p_link_name cz_servers.fndnam_link_name%TYPE)
195: RETURN NUMBER
196: IS
197:
198: gl_ref_cursor REF_CURSOR;

Line 199: v_tgt_server_id cz_servers.server_local_id%TYPE := 0;

195: RETURN NUMBER
196: IS
197:
198: gl_ref_cursor REF_CURSOR;
199: v_tgt_server_id cz_servers.server_local_id%TYPE := 0;
200:
201: BEGIN
202: OPEN gl_ref_cursor FOR 'SELECT distinct server_id
203: FROM cz_model_publications'||p_link_name||' t

Line 220: FUNCTION verify_src_tgt_instances(p_link_name IN cz_servers.fndnam_link_name%TYPE)

216: END get_tgt_server_id;
217:
218: ---------------------------------------------------
219: ------function that verifies that the source and target server ids match
220: FUNCTION verify_src_tgt_instances(p_link_name IN cz_servers.fndnam_link_name%TYPE)
221: RETURN BOOLEAN
222: IS
223:
224: v_tgt_pb_server_id cz_servers.server_local_id%TYPE;

Line 224: v_tgt_pb_server_id cz_servers.server_local_id%TYPE;

220: FUNCTION verify_src_tgt_instances(p_link_name IN cz_servers.fndnam_link_name%TYPE)
221: RETURN BOOLEAN
222: IS
223:
224: v_tgt_pb_server_id cz_servers.server_local_id%TYPE;
225: v_validate_flag BOOLEAN := TRUE;
226: v_src_server_count NUMBER := 0;
227:
228: NO_TGT_ID EXCEPTION;

Line 264: FUNCTION verify_src_tgt_models(p_link_name IN cz_servers.fndnam_link_name%TYPE)

260: END verify_src_tgt_instances;
261:
262: -------------------------------------------------------
263: ------function that verifies if model ids on source and target instances are the same
264: FUNCTION verify_src_tgt_models(p_link_name IN cz_servers.fndnam_link_name%TYPE)
265: RETURN BOOLEAN
266: IS
267:
268: gl_ref_cursor REF_CURSOR;

Line 299: FUNCTION verify_src_tgt_pb_ids(p_link_name IN cz_servers.fndnam_link_name%TYPE)

295: END verify_src_tgt_models;
296:
297: ---------------------------------------------------
298: ---------function that validates publication ids on the tgt instance
299: FUNCTION verify_src_tgt_pb_ids(p_link_name IN cz_servers.fndnam_link_name%TYPE)
300: RETURN BOOLEAN
301: IS
302:
303: gl_ref_cursor REF_CURSOR;

Line 338: FUNCTION has_to_be_synced(p_tgt_server_id IN cz_servers.server_local_id%TYPE)

334:
335: ----------------------------------------------------
336: -----procedure that checks if the target instance has to be synchronized
337: -----x_sync_flag : TRUE if it has to be synced
338: FUNCTION has_to_be_synced(p_tgt_server_id IN cz_servers.server_local_id%TYPE)
339: RETURN BOOLEAN
340: IS
341:
342: v_link_name cz_servers.fndnam_link_name%TYPE;

Line 342: v_link_name cz_servers.fndnam_link_name%TYPE;

338: FUNCTION has_to_be_synced(p_tgt_server_id IN cz_servers.server_local_id%TYPE)
339: RETURN BOOLEAN
340: IS
341:
342: v_link_name cz_servers.fndnam_link_name%TYPE;
343: v_sync_flag BOOLEAN := TRUE;
344:
345: BEGIN
346: FOR I IN 1..1

Line 468: PROCEDURE update_tgt_server_id(p_target_server_id IN cz_servers.server_local_id%TYPE,

464: END clear_pb_exports;
465:
466: ---------------------------------------------------------
467: -----procedure that updates the server_id of the target publication record
468: PROCEDURE update_tgt_server_id(p_target_server_id IN cz_servers.server_local_id%TYPE,
469: p_link_name In cz_servers.fndnam_link_name%TYPE)
470: IS
471:
472: BEGIN

Line 469: p_link_name In cz_servers.fndnam_link_name%TYPE)

465:
466: ---------------------------------------------------------
467: -----procedure that updates the server_id of the target publication record
468: PROCEDURE update_tgt_server_id(p_target_server_id IN cz_servers.server_local_id%TYPE,
469: p_link_name In cz_servers.fndnam_link_name%TYPE)
470: IS
471:
472: BEGIN
473: EXECUTE IMMEDIATE

Line 485: p_sync_tgt_link_name IN cz_servers.fndnam_link_name%TYPE,

481: --jhanda
482: -- procedure that returns the product_id and organisation_id in the target corresponding
483: -- to the product_id and organisation_id in the source for a given source publication
484: PROCEDURE get_local_ids(p_publication_id IN cz_model_publications.publication_id%TYPE,
485: p_sync_tgt_link_name IN cz_servers.fndnam_link_name%TYPE,
486: p_import_link_name IN cz_servers.fndnam_link_name%TYPE,
487: p_item_id IN OUT NOCOPY cz_item_masters.item_id%TYPE,
488: p_org_id IN OUT NOCOPY cz_model_publications.organization_id%TYPE,
489: p_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE

Line 486: p_import_link_name IN cz_servers.fndnam_link_name%TYPE,

482: -- procedure that returns the product_id and organisation_id in the target corresponding
483: -- to the product_id and organisation_id in the source for a given source publication
484: PROCEDURE get_local_ids(p_publication_id IN cz_model_publications.publication_id%TYPE,
485: p_sync_tgt_link_name IN cz_servers.fndnam_link_name%TYPE,
486: p_import_link_name IN cz_servers.fndnam_link_name%TYPE,
487: p_item_id IN OUT NOCOPY cz_item_masters.item_id%TYPE,
488: p_org_id IN OUT NOCOPY cz_model_publications.organization_id%TYPE,
489: p_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
490: )

Line 605: p_link_name IN cz_servers.fndnam_link_name%TYPE,

601: ------------------------------------------------------
602: ------procedure that creates a single publication record on the source for a
603: ------target publication. This proc is called from create_src_pb_records.
604: PROCEDURE create_src_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,
605: p_link_name IN cz_servers.fndnam_link_name%TYPE,
606: p_tgt_server_id IN cz_servers.server_local_id%TYPE,
607: p_src_object_id IN cz_model_publications.object_id%TYPE,
608: -- p_src_object_type IN cz_model_publications.object_type%TYPE,
609: p_src_ui_def_id IN cz_model_publications.ui_def_id%TYPE)

Line 606: p_tgt_server_id IN cz_servers.server_local_id%TYPE,

602: ------procedure that creates a single publication record on the source for a
603: ------target publication. This proc is called from create_src_pb_records.
604: PROCEDURE create_src_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,
605: p_link_name IN cz_servers.fndnam_link_name%TYPE,
606: p_tgt_server_id IN cz_servers.server_local_id%TYPE,
607: p_src_object_id IN cz_model_publications.object_id%TYPE,
608: -- p_src_object_type IN cz_model_publications.object_type%TYPE,
609: p_src_ui_def_id IN cz_model_publications.ui_def_id%TYPE)
610: IS

Line 619: linkName cz_servers.fndnam_link_name%TYPE;

615: v_item_id cz_item_masters.item_id%TYPE;
616: v_org_id cz_model_publications.organization_id%TYPE;
617: v_product_key cz_model_publications.product_key%TYPE;
618:
619: linkName cz_servers.fndnam_link_name%TYPE;
620:
621: BEGIN
622: ----get new publication id
623: SELECT cz_model_publications_s.nextval

Line 635: FROM cz_servers

631: END IF;
632:
633: -- Get Import Server link name
634: SELECT fndnam_link_name INTO linkName
635: FROM cz_servers
636: WHERE import_enabled='1';
637:
638:
639: IF(linkName IS NOT NULL)THEN

Line 785: p_link_name IN cz_servers.fndnam_link_name%TYPE)

781: --------------------------------------------------------
782: ----procedure that deletes a publication record on the target
783: ----instance
784: PROCEDURE delete_tgt_publication(p_publication_id IN cz_model_publications.publication_id%TYPE,
785: p_link_name IN cz_servers.fndnam_link_name%TYPE)
786: IS
787:
788: BEGIN
789: EXECUTE IMMEDIATE

Line 799: PROCEDURE get_src_tgt_info(p_tgt_server_id IN cz_servers.server_local_id%TYPE,

795: END;
796:
797: ---------------------------------------------------------
798: ------procedure that retrieves the src and tgt information
799: PROCEDURE get_src_tgt_info(p_tgt_server_id IN cz_servers.server_local_id%TYPE,
800: x_src_instance OUT NOCOPY cz_servers.local_name%TYPE,
801: x_tgt_instance OUT NOCOPY cz_servers.local_name%TYPE)
802: IS
803:

Line 800: x_src_instance OUT NOCOPY cz_servers.local_name%TYPE,

796:
797: ---------------------------------------------------------
798: ------procedure that retrieves the src and tgt information
799: PROCEDURE get_src_tgt_info(p_tgt_server_id IN cz_servers.server_local_id%TYPE,
800: x_src_instance OUT NOCOPY cz_servers.local_name%TYPE,
801: x_tgt_instance OUT NOCOPY cz_servers.local_name%TYPE)
802: IS
803:
804: BEGIN

Line 801: x_tgt_instance OUT NOCOPY cz_servers.local_name%TYPE)

797: ---------------------------------------------------------
798: ------procedure that retrieves the src and tgt information
799: PROCEDURE get_src_tgt_info(p_tgt_server_id IN cz_servers.server_local_id%TYPE,
800: x_src_instance OUT NOCOPY cz_servers.local_name%TYPE,
801: x_tgt_instance OUT NOCOPY cz_servers.local_name%TYPE)
802: IS
803:
804: BEGIN
805: SELECT instance_name

Line 807: FROM cz_servers

803:
804: BEGIN
805: SELECT instance_name
806: INTO x_src_instance
807: FROM cz_servers
808: WHERE cz_servers.server_local_id = 0;
809:
810: SELECT instance_name
811: INTO x_tgt_instance

Line 808: WHERE cz_servers.server_local_id = 0;

804: BEGIN
805: SELECT instance_name
806: INTO x_src_instance
807: FROM cz_servers
808: WHERE cz_servers.server_local_id = 0;
809:
810: SELECT instance_name
811: INTO x_tgt_instance
812: FROM cz_servers

Line 812: FROM cz_servers

808: WHERE cz_servers.server_local_id = 0;
809:
810: SELECT instance_name
811: INTO x_tgt_instance
812: FROM cz_servers
813: WHERE cz_servers.server_local_id = p_tgt_server_id ;
814: EXCEPTION
815: WHEN OTHERS THEN
816: RAISE;

Line 813: WHERE cz_servers.server_local_id = p_tgt_server_id ;

809:
810: SELECT instance_name
811: INTO x_tgt_instance
812: FROM cz_servers
813: WHERE cz_servers.server_local_id = p_tgt_server_id ;
814: EXCEPTION
815: WHEN OTHERS THEN
816: RAISE;
817: END;

Line 859: PROCEDURE create_src_pb_records(p_tgt_server_id IN cz_servers.server_local_id%TYPE)

855:
856: ----------------------------------------------------------
857: ----procedure that creates the source publication records for each valid publication
858: ----on the clone
859: PROCEDURE create_src_pb_records(p_tgt_server_id IN cz_servers.server_local_id%TYPE)
860: IS
861:
862: TYPE object_type_tbl_type IS TABLE OF cz_model_publications.object_type%TYPE
863: INDEX BY BINARY_INTEGER;

Line 882: l_link_name cz_servers.fndnam_link_name%TYPE;

878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;
879: l_src_object_name cz_devl_projects.name%TYPE;
880: l_tgt_object_name cz_devl_projects.name%TYPE;
881:
882: l_link_name cz_servers.fndnam_link_name%TYPE;
883:
884: l_tgt_src_pub_tbl t_ref;
885: l_tgt_rem_pub_tbl t_ref;
886: l_tgt_object_id_tbl t_ref;

Line 893: l_src_instance cz_servers.local_name%TYPE;

889: l_tgt_src_ui_def_tbl t_ref;
890: l_tgt_object_name_tbl t_name;
891: l_tgt_pb_count NUMBER;
892:
893: l_src_instance cz_servers.local_name%TYPE;
894: l_tgt_instance cz_servers.local_name%TYPE;
895: l_tgt_ui_def_id cz_ui_defs.ui_def_id%TYPE;
896:
897: OBJ_TYPE_MISMATCH_ERR EXCEPTION;

Line 894: l_tgt_instance cz_servers.local_name%TYPE;

890: l_tgt_object_name_tbl t_name;
891: l_tgt_pb_count NUMBER;
892:
893: l_src_instance cz_servers.local_name%TYPE;
894: l_tgt_instance cz_servers.local_name%TYPE;
895: l_tgt_ui_def_id cz_ui_defs.ui_def_id%TYPE;
896:
897: OBJ_TYPE_MISMATCH_ERR EXCEPTION;
898: MODEL_MISMATCH_ERR EXCEPTION;

Line 1202: l_instance_name cz_servers.instance_name%TYPE;

1198: FUNCTION verify_input_parameters(p_target_instance IN VARCHAR2)
1199: RETURN BOOLEAN
1200: IS
1201:
1202: l_instance_name cz_servers.instance_name%TYPE;
1203: l_host_name cz_servers.hostname%TYPE;
1204: l_listener_port cz_servers.db_listener_port%TYPE;
1205: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
1206: v_ret_flag BOOLEAN := TRUE;

Line 1203: l_host_name cz_servers.hostname%TYPE;

1199: RETURN BOOLEAN
1200: IS
1201:
1202: l_instance_name cz_servers.instance_name%TYPE;
1203: l_host_name cz_servers.hostname%TYPE;
1204: l_listener_port cz_servers.db_listener_port%TYPE;
1205: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
1206: v_ret_flag BOOLEAN := TRUE;
1207:

Line 1204: l_listener_port cz_servers.db_listener_port%TYPE;

1200: IS
1201:
1202: l_instance_name cz_servers.instance_name%TYPE;
1203: l_host_name cz_servers.hostname%TYPE;
1204: l_listener_port cz_servers.db_listener_port%TYPE;
1205: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
1206: v_ret_flag BOOLEAN := TRUE;
1207:
1208: BEGIN

Line 1205: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;

1201:
1202: l_instance_name cz_servers.instance_name%TYPE;
1203: l_host_name cz_servers.hostname%TYPE;
1204: l_listener_port cz_servers.db_listener_port%TYPE;
1205: l_fndnam_link_name cz_servers.fndnam_link_name%TYPE;
1206: v_ret_flag BOOLEAN := TRUE;
1207:
1208: BEGIN
1209: IF (p_target_instance IS NULL) THEN

Line 1216: FROM cz_servers

1212: v_ret_flag := FALSE;
1213: ELSE
1214: SELECT instance_name,hostname,db_listener_port,fndnam_link_name
1215: INTO l_instance_name,l_host_name,l_listener_port,l_fndnam_link_name
1216: FROM cz_servers
1217: WHERE UPPER(cz_servers.local_name) = UPPER(p_target_instance);
1218:
1219: IF (l_instance_name IS NULL) THEN
1220: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_INSTANCE_IS_NULL', 'TGTINSTANCE',p_target_instance);

Line 1217: WHERE UPPER(cz_servers.local_name) = UPPER(p_target_instance);

1213: ELSE
1214: SELECT instance_name,hostname,db_listener_port,fndnam_link_name
1215: INTO l_instance_name,l_host_name,l_listener_port,l_fndnam_link_name
1216: FROM cz_servers
1217: WHERE UPPER(cz_servers.local_name) = UPPER(p_target_instance);
1218:
1219: IF (l_instance_name IS NULL) THEN
1220: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_INSTANCE_IS_NULL', 'TGTINSTANCE',p_target_instance);
1221: error_msg_populate(m_err_message ,'CZ_PB_SYNC.INPUTPARAMS',21004);

Line 1258: PROCEDURE update_server_info(p_target_server_id IN cz_servers.server_local_id%TYPE,

1254: END verify_input_parameters;
1255:
1256: -------------------------------------------------------
1257: -----procedure that updates server information on the target
1258: PROCEDURE update_server_info(p_target_server_id IN cz_servers.server_local_id%TYPE,
1259: p_link_name IN cz_servers.fndnam_link_name%TYPE)
1260: IS
1261:
1262: l_instance_name cz_servers.instance_name%TYPE;

Line 1259: p_link_name IN cz_servers.fndnam_link_name%TYPE)

1255:
1256: -------------------------------------------------------
1257: -----procedure that updates server information on the target
1258: PROCEDURE update_server_info(p_target_server_id IN cz_servers.server_local_id%TYPE,
1259: p_link_name IN cz_servers.fndnam_link_name%TYPE)
1260: IS
1261:
1262: l_instance_name cz_servers.instance_name%TYPE;
1263: l_host_name cz_servers.hostname%TYPE;

Line 1262: l_instance_name cz_servers.instance_name%TYPE;

1258: PROCEDURE update_server_info(p_target_server_id IN cz_servers.server_local_id%TYPE,
1259: p_link_name IN cz_servers.fndnam_link_name%TYPE)
1260: IS
1261:
1262: l_instance_name cz_servers.instance_name%TYPE;
1263: l_host_name cz_servers.hostname%TYPE;
1264: l_listener_port cz_servers.db_listener_port%TYPE;
1265: l_sync_date VARCHAR2(50);
1266:

Line 1263: l_host_name cz_servers.hostname%TYPE;

1259: p_link_name IN cz_servers.fndnam_link_name%TYPE)
1260: IS
1261:
1262: l_instance_name cz_servers.instance_name%TYPE;
1263: l_host_name cz_servers.hostname%TYPE;
1264: l_listener_port cz_servers.db_listener_port%TYPE;
1265: l_sync_date VARCHAR2(50);
1266:
1267: BEGIN

Line 1264: l_listener_port cz_servers.db_listener_port%TYPE;

1260: IS
1261:
1262: l_instance_name cz_servers.instance_name%TYPE;
1263: l_host_name cz_servers.hostname%TYPE;
1264: l_listener_port cz_servers.db_listener_port%TYPE;
1265: l_sync_date VARCHAR2(50);
1266:
1267: BEGIN
1268: l_sync_date := TO_CHAR(sysdate, 'mm-dd-yyyy hh24:mi:ss');

Line 1272: FROM cz_servers

1268: l_sync_date := TO_CHAR(sysdate, 'mm-dd-yyyy hh24:mi:ss');
1269:
1270: SELECT instance_name,hostname,db_listener_port
1271: INTO l_instance_name,l_host_name,l_listener_port
1272: FROM cz_servers
1273: WHERE cz_servers.server_local_id = p_target_server_id;
1274:
1275: EXECUTE IMMEDIATE
1276: 'UPDATE cz_servers'||p_link_name||' t ' ||

Line 1273: WHERE cz_servers.server_local_id = p_target_server_id;

1269:
1270: SELECT instance_name,hostname,db_listener_port
1271: INTO l_instance_name,l_host_name,l_listener_port
1272: FROM cz_servers
1273: WHERE cz_servers.server_local_id = p_target_server_id;
1274:
1275: EXECUTE IMMEDIATE
1276: 'UPDATE cz_servers'||p_link_name||' t ' ||
1277: ' SET t.instance_name = '''||l_instance_name||''', ' ||

Line 1276: 'UPDATE cz_servers'||p_link_name||' t ' ||

1272: FROM cz_servers
1273: WHERE cz_servers.server_local_id = p_target_server_id;
1274:
1275: EXECUTE IMMEDIATE
1276: 'UPDATE cz_servers'||p_link_name||' t ' ||
1277: ' SET t.instance_name = '''||l_instance_name||''', ' ||
1278: ' t.hostname = '''||l_host_name||''', ' ||
1279: ' t.db_listener_port = '||l_listener_port||', ' ||
1280: ' t.notes = '''||l_sync_date||''' ' ||

Line 1299: PROCEDURE sync_publication_clone(p_target_server_id IN cz_servers.server_local_id%TYPE,

1295: -----and target servers
1296: ------@p_target_server_id --- server id of the target server
1297: ------@x_pb_clone_flg --- TRUE if sync was successful
1298:
1299: PROCEDURE sync_publication_clone(p_target_server_id IN cz_servers.server_local_id%TYPE,
1300: x_pb_clone_flg OUT NOCOPY BOOLEAN)
1301: IS
1302:
1303: v_link_name cz_servers.fndnam_link_name%TYPE;

Line 1303: v_link_name cz_servers.fndnam_link_name%TYPE;

1299: PROCEDURE sync_publication_clone(p_target_server_id IN cz_servers.server_local_id%TYPE,
1300: x_pb_clone_flg OUT NOCOPY BOOLEAN)
1301: IS
1302:
1303: v_link_name cz_servers.fndnam_link_name%TYPE;
1304:
1305: BEGIN
1306: x_pb_clone_flg := TRUE;
1307:

Line 1342: l_link_name cz_servers.fndnam_link_name%TYPE;

1338: l_validate_flg BOOLEAN := TRUE;
1339: l_has_to_be_synced_flg BOOLEAN := TRUE;
1340: l_pb_clone_flg BOOLEAN ;
1341: l_run_id NUMBER := 0;
1342: l_link_name cz_servers.fndnam_link_name%TYPE;
1343: l_proc_name v$session.module%TYPE;
1344:
1345: BEGIN
1346:

Line 1478: PROCEDURE get_local_server_info (x_hostname OUT NOCOPY cz_servers.hostname%TYPE,

1474: END sync_cloned_tgt_pub_data_cp;
1475:
1476: ---------------------------------------------------------
1477: ----get local server information
1478: PROCEDURE get_local_server_info (x_hostname OUT NOCOPY cz_servers.hostname%TYPE,
1479: x_instance_name OUT NOCOPY cz_servers.instance_name%TYPE)
1480: IS
1481:
1482: BEGIN

Line 1479: x_instance_name OUT NOCOPY cz_servers.instance_name%TYPE)

1475:
1476: ---------------------------------------------------------
1477: ----get local server information
1478: PROCEDURE get_local_server_info (x_hostname OUT NOCOPY cz_servers.hostname%TYPE,
1479: x_instance_name OUT NOCOPY cz_servers.instance_name%TYPE)
1480: IS
1481:
1482: BEGIN
1483: SELECT host_name,instance_name

Line 1493: p_hostname IN cz_servers.hostname%TYPE,

1489: END get_local_server_info;
1490:
1491: --------------------------------------------------------
1492: PROCEDURE modify_target_server(p_link_name IN VARCHAR2,
1493: p_hostname IN cz_servers.hostname%TYPE,
1494: p_instance_name IN cz_servers.instance_name%TYPE,
1495: p_local_name IN cz_servers.local_name%TYPE)
1496: IS
1497:

Line 1494: p_instance_name IN cz_servers.instance_name%TYPE,

1490:
1491: --------------------------------------------------------
1492: PROCEDURE modify_target_server(p_link_name IN VARCHAR2,
1493: p_hostname IN cz_servers.hostname%TYPE,
1494: p_instance_name IN cz_servers.instance_name%TYPE,
1495: p_local_name IN cz_servers.local_name%TYPE)
1496: IS
1497:
1498: v_str VARCHAR2(2000);

Line 1495: p_local_name IN cz_servers.local_name%TYPE)

1491: --------------------------------------------------------
1492: PROCEDURE modify_target_server(p_link_name IN VARCHAR2,
1493: p_hostname IN cz_servers.hostname%TYPE,
1494: p_instance_name IN cz_servers.instance_name%TYPE,
1495: p_local_name IN cz_servers.local_name%TYPE)
1496: IS
1497:
1498: v_str VARCHAR2(2000);
1499:

Line 1501: v_str := ' UPDATE cz_servers'||p_link_name||' SET hostname = '''||p_hostname||''', ' ||

1497:
1498: v_str VARCHAR2(2000);
1499:
1500: BEGIN
1501: v_str := ' UPDATE cz_servers'||p_link_name||' SET hostname = '''||p_hostname||''', ' ||
1502: ' instance_name = '''||p_instance_name||''', ' ||
1503: ' local_name = :1 ' ||
1504: ' WHERE source_server_flag = ''1'' ';
1505:

Line 1514: FUNCTION get_link_name(p_local_name IN cz_servers.local_name%TYPE)

1510: RAISE;
1511: END;
1512:
1513: -----procedure that retrieves the link name
1514: FUNCTION get_link_name(p_local_name IN cz_servers.local_name%TYPE)
1515: RETURN VARCHAR2
1516: IS
1517:
1518: l_link_name cz_servers.fndnam_link_name%TYPE := NULL;

Line 1518: l_link_name cz_servers.fndnam_link_name%TYPE := NULL;

1514: FUNCTION get_link_name(p_local_name IN cz_servers.local_name%TYPE)
1515: RETURN VARCHAR2
1516: IS
1517:
1518: l_link_name cz_servers.fndnam_link_name%TYPE := NULL;
1519:
1520: BEGIN
1521: SELECT fndnam_link_name
1522: INTO l_link_name

Line 1523: FROM cz_servers

1519:
1520: BEGIN
1521: SELECT fndnam_link_name
1522: INTO l_link_name
1523: FROM cz_servers
1524: WHERE UPPER(local_name) = UPPER(p_local_name);
1525:
1526: RETURN l_link_name;
1527: EXCEPTION

Line 1545: v_link_name cz_servers.fndnam_link_name%TYPE;

1541: v_validate_flg BOOLEAN := TRUE;
1542: v_has_to_be_synced_flg BOOLEAN := TRUE;
1543: v_pb_clone_flg BOOLEAN ;
1544: v_run_id NUMBER := 0;
1545: v_link_name cz_servers.fndnam_link_name%TYPE;
1546:
1547: l_hostname cz_servers.hostname%TYPE;
1548: l_instance_name cz_servers.instance_name%TYPE;
1549: l_local_name_tbl t_name ;

Line 1547: l_hostname cz_servers.hostname%TYPE;

1543: v_pb_clone_flg BOOLEAN ;
1544: v_run_id NUMBER := 0;
1545: v_link_name cz_servers.fndnam_link_name%TYPE;
1546:
1547: l_hostname cz_servers.hostname%TYPE;
1548: l_instance_name cz_servers.instance_name%TYPE;
1549: l_local_name_tbl t_name ;
1550: l_message VARCHAr2(2000);
1551: l_proc_name v$session.module%TYPE;

Line 1548: l_instance_name cz_servers.instance_name%TYPE;

1544: v_run_id NUMBER := 0;
1545: v_link_name cz_servers.fndnam_link_name%TYPE;
1546:
1547: l_hostname cz_servers.hostname%TYPE;
1548: l_instance_name cz_servers.instance_name%TYPE;
1549: l_local_name_tbl t_name ;
1550: l_message VARCHAr2(2000);
1551: l_proc_name v$session.module%TYPE;
1552:

Line 1595: UPDATE cz_servers

1591:
1592: -----update local server entry
1593: get_local_server_info (l_hostname,l_instance_name);
1594:
1595: UPDATE cz_servers
1596: set hostname = l_hostname,
1597: instance_name = l_instance_name
1598: WHERE UPPER(cz_servers.local_name) = 'LOCAL';
1599:

Line 1598: WHERE UPPER(cz_servers.local_name) = 'LOCAL';

1594:
1595: UPDATE cz_servers
1596: set hostname = l_hostname,
1597: instance_name = l_instance_name
1598: WHERE UPPER(cz_servers.local_name) = 'LOCAL';
1599:
1600: -----recreate database links
1601: BEGIN
1602: SELECT local_name

Line 1606: FROM cz_servers

1602: SELECT local_name
1603: BULK
1604: COLLECT
1605: INTO l_local_name_tbl
1606: FROM cz_servers
1607: WHERE UPPER(cz_servers.local_name) <> 'LOCAL';
1608: EXCEPTION
1609: WHEN NO_DATA_FOUND THEN
1610: -----do not care

Line 1607: WHERE UPPER(cz_servers.local_name) <> 'LOCAL';

1603: BULK
1604: COLLECT
1605: INTO l_local_name_tbl
1606: FROM cz_servers
1607: WHERE UPPER(cz_servers.local_name) <> 'LOCAL';
1608: EXCEPTION
1609: WHEN NO_DATA_FOUND THEN
1610: -----do not care
1611: NULL;

Line 1665: l_src_instance cz_servers.instance_name%TYPE;

1661: IS
1662:
1663: v_run_id NUMBER := 0.0;
1664: v_sync_status VARCHAR2(1);
1665: l_src_instance cz_servers.instance_name%TYPE;
1666:
1667: BEGIN
1668: Retcode:=0;
1669: Errbuf := NULL;