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

Line 49: ------function that retrieves the db link name from cz_servers

45: RAISE;
46: END log_pb_sync_errors;
47:
48: ---------------------------------------------------
49: ------function that retrieves the db link name from cz_servers
50: FUNCTION retrieve_link_name(p_tgt_server_id cz_servers.server_local_id%TYPE)
51: RETURN VARCHAR2
52: IS
53:

Line 50: FUNCTION retrieve_link_name(p_tgt_server_id cz_servers.server_local_id%TYPE)

46: END log_pb_sync_errors;
47:
48: ---------------------------------------------------
49: ------function that retrieves the db link name from cz_servers
50: FUNCTION retrieve_link_name(p_tgt_server_id cz_servers.server_local_id%TYPE)
51: RETURN VARCHAR2
52: IS
53:
54: v_db_link_name cz_servers.fndnam_link_name%TYPE := NULL;

Line 54: v_db_link_name cz_servers.fndnam_link_name%TYPE := NULL;

50: FUNCTION retrieve_link_name(p_tgt_server_id cz_servers.server_local_id%TYPE)
51: RETURN VARCHAR2
52: IS
53:
54: v_db_link_name cz_servers.fndnam_link_name%TYPE := NULL;
55:
56: BEGIN
57: IF (p_tgt_server_id IS NOT NULL) THEN
58: SELECT fndnam_link_name

Line 60: FROM cz_servers

56: BEGIN
57: IF (p_tgt_server_id IS NOT NULL) THEN
58: SELECT fndnam_link_name
59: INTO v_db_link_name
60: FROM cz_servers
61: WHERE cz_servers.server_local_id = p_tgt_server_id;
62: v_db_link_name := '@'||v_db_link_name;
63: END IF;
64: RETURN v_db_link_name;

Line 61: WHERE cz_servers.server_local_id = p_tgt_server_id;

57: IF (p_tgt_server_id IS NOT NULL) THEN
58: SELECT fndnam_link_name
59: INTO v_db_link_name
60: FROM cz_servers
61: WHERE cz_servers.server_local_id = p_tgt_server_id;
62: v_db_link_name := '@'||v_db_link_name;
63: END IF;
64: RETURN v_db_link_name;
65: EXCEPTION

Line 71: ----procedure that retrieves the target server id from cz_servers

67: RETURN v_db_link_name;
68: END retrieve_link_name;
69:
70: ---------------------------------------------------------
71: ----procedure that retrieves the target server id from cz_servers
72: FUNCTION get_target_instance_id(p_target_instance IN VARCHAR2)
73: RETURN NUMBER
74: IS
75:

Line 76: v_tgt_server_id cz_servers.server_local_id%TYPE;

72: FUNCTION get_target_instance_id(p_target_instance IN VARCHAR2)
73: RETURN NUMBER
74: IS
75:
76: v_tgt_server_id cz_servers.server_local_id%TYPE;
77:
78: BEGIN
79: v_tgt_server_id := 0;
80: SELECT server_local_id

Line 82: FROM cz_servers

78: BEGIN
79: v_tgt_server_id := 0;
80: SELECT server_local_id
81: INTO v_tgt_server_id
82: FROM cz_servers
83: WHERE UPPER(cz_servers.local_name) = UPPER(LTRIM(RTRIM(p_target_instance)));
84: RETURN v_tgt_server_id ;
85: EXCEPTION
86: WHEN NO_DATA_FOUND THEN

Line 83: WHERE UPPER(cz_servers.local_name) = UPPER(LTRIM(RTRIM(p_target_instance)));

79: v_tgt_server_id := 0;
80: SELECT server_local_id
81: INTO v_tgt_server_id
82: FROM cz_servers
83: WHERE UPPER(cz_servers.local_name) = UPPER(LTRIM(RTRIM(p_target_instance)));
84: RETURN v_tgt_server_id ;
85: EXCEPTION
86: WHEN NO_DATA_FOUND THEN
87: RETURN v_tgt_server_id ;

Line 94: FUNCTION check_db_link(p_db_link_name IN cz_servers.fndnam_link_name%TYPE)

90: END get_target_instance_id;
91:
92: ------------------------------------------------------------
93: -----function that checks if the database lnk is active
94: FUNCTION check_db_link(p_db_link_name IN cz_servers.fndnam_link_name%TYPE)
95: RETURN BOOLEAN
96: IS
97:
98: gl_ref_cursor REF_CURSOR;

Line 130: FUNCTION validate_schema(target_server_id cz_servers.server_local_id%TYPE)

126: -------------------------------------------------------------
127: ------function that validates the schema versions on the source
128: ------and the cloned instances
129: ------
130: FUNCTION validate_schema(target_server_id cz_servers.server_local_id%TYPE)
131: RETURN BOOLEAN
132: IS
133:
134: v_source_major_version cz_db_settings.value%TYPE;

Line 139: v_db_link cz_servers.fndnam_link_name%TYPE;

135: v_source_minor_version cz_db_settings.value%TYPE;
136: v_target_major_version cz_db_settings.value%TYPE;
137: v_target_minor_version cz_db_settings.value%TYPE;
138: db_schema_compare_cur ref_cursor ;
139: v_db_link cz_servers.fndnam_link_name%TYPE;
140: v_validate_schema_flg BOOLEAN := TRUE;
141: v_count PLS_INTEGER := 0;
142:
143: BEGIN

Line 218: PROCEDURE verify_tgt_server(p_link_name IN cz_servers.fndnam_link_name%TYPE,

214: ------------------------------------------------------
215: ----procedure used by publishing to check if the target server is
216: ----actually a target and not a source.
217: ----if target then a value of 0 is returned
218: PROCEDURE verify_tgt_server(p_link_name IN cz_servers.fndnam_link_name%TYPE,
219: x_status OUT NOCOPY VARCHAR2,
220: x_msg OUT NOCOPY VARCHAR2)
221: IS
222:

Line 223: l_instance_name cz_servers.instance_name%TYPE;

219: x_status OUT NOCOPY VARCHAR2,
220: x_msg OUT NOCOPY VARCHAR2)
221: IS
222:
223: l_instance_name cz_servers.instance_name%TYPE;
224: l_hostname cz_servers.hostname%TYPE;
225: l_listener_port cz_servers.db_listener_port%TYPE;
226: l_source_server_flag cz_servers.source_server_flag%TYPE;
227: l_tgt_instance_name cz_servers.instance_name%TYPE;

Line 224: l_hostname cz_servers.hostname%TYPE;

220: x_msg OUT NOCOPY VARCHAR2)
221: IS
222:
223: l_instance_name cz_servers.instance_name%TYPE;
224: l_hostname cz_servers.hostname%TYPE;
225: l_listener_port cz_servers.db_listener_port%TYPE;
226: l_source_server_flag cz_servers.source_server_flag%TYPE;
227: l_tgt_instance_name cz_servers.instance_name%TYPE;
228: gl_ref_cursor REF_CURSOR;

Line 225: l_listener_port cz_servers.db_listener_port%TYPE;

221: IS
222:
223: l_instance_name cz_servers.instance_name%TYPE;
224: l_hostname cz_servers.hostname%TYPE;
225: l_listener_port cz_servers.db_listener_port%TYPE;
226: l_source_server_flag cz_servers.source_server_flag%TYPE;
227: l_tgt_instance_name cz_servers.instance_name%TYPE;
228: gl_ref_cursor REF_CURSOR;
229: seq_ref_cursor REF_CURSOR;

Line 226: l_source_server_flag cz_servers.source_server_flag%TYPE;

222:
223: l_instance_name cz_servers.instance_name%TYPE;
224: l_hostname cz_servers.hostname%TYPE;
225: l_listener_port cz_servers.db_listener_port%TYPE;
226: l_source_server_flag cz_servers.source_server_flag%TYPE;
227: l_tgt_instance_name cz_servers.instance_name%TYPE;
228: gl_ref_cursor REF_CURSOR;
229: seq_ref_cursor REF_CURSOR;
230: l_server_local_id cz_servers.server_local_id%TYPE;

Line 227: l_tgt_instance_name cz_servers.instance_name%TYPE;

223: l_instance_name cz_servers.instance_name%TYPE;
224: l_hostname cz_servers.hostname%TYPE;
225: l_listener_port cz_servers.db_listener_port%TYPE;
226: l_source_server_flag cz_servers.source_server_flag%TYPE;
227: l_tgt_instance_name cz_servers.instance_name%TYPE;
228: gl_ref_cursor REF_CURSOR;
229: seq_ref_cursor REF_CURSOR;
230: l_server_local_id cz_servers.server_local_id%TYPE;
231:

Line 230: l_server_local_id cz_servers.server_local_id%TYPE;

226: l_source_server_flag cz_servers.source_server_flag%TYPE;
227: l_tgt_instance_name cz_servers.instance_name%TYPE;
228: gl_ref_cursor REF_CURSOR;
229: seq_ref_cursor REF_CURSOR;
230: l_server_local_id cz_servers.server_local_id%TYPE;
231:
232: l_msg VARCHAR2(2000);
233:
234: BEGIN

Line 239: FROM cz_servers

235: x_status := '0';
236:
237: SELECT instance_name,hostname,db_listener_port
238: INTO l_instance_name,l_hostname,l_listener_port
239: FROM cz_servers
240: WHERE UPPER(cz_servers.local_name) = 'LOCAL';
241:
242: OPEN gl_ref_cursor FOR 'SELECT instance_name, source_server_flag
243: FROM cz_servers'||p_link_name||' t

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

236:
237: SELECT instance_name,hostname,db_listener_port
238: INTO l_instance_name,l_hostname,l_listener_port
239: FROM cz_servers
240: WHERE UPPER(cz_servers.local_name) = 'LOCAL';
241:
242: OPEN gl_ref_cursor FOR 'SELECT instance_name, source_server_flag
243: FROM cz_servers'||p_link_name||' t
244: WHERE UPPER(t.local_name) = UPPER('''||l_instance_name||''')';

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

239: FROM cz_servers
240: WHERE UPPER(cz_servers.local_name) = 'LOCAL';
241:
242: OPEN gl_ref_cursor FOR 'SELECT instance_name, source_server_flag
243: FROM cz_servers'||p_link_name||' t
244: WHERE UPPER(t.local_name) = UPPER('''||l_instance_name||''')';
245: LOOP
246: FETCH gl_ref_cursor INTO l_tgt_instance_name, l_source_server_flag;
247: EXIT WHEN gl_ref_cursor%NOTFOUND;

Line 262: l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;

258: x_status := '1';
259: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_MGR_NOT_PRD_INSTANCE');
260: END IF;
261: ELSE
262: l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;
263: OPEN seq_ref_cursor FOR 'SELECT cz_servers_s.nextval from dual'||p_link_name;
264: LOOP
265: EXIT WHEN seq_ref_cursor%NOTFOUND;
266: FETCH seq_ref_cursor INTO l_server_local_id;

Line 263: OPEN seq_ref_cursor FOR 'SELECT cz_servers_s.nextval from dual'||p_link_name;

259: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_MGR_NOT_PRD_INSTANCE');
260: END IF;
261: ELSE
262: l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;
263: OPEN seq_ref_cursor FOR 'SELECT cz_servers_s.nextval from dual'||p_link_name;
264: LOOP
265: EXIT WHEN seq_ref_cursor%NOTFOUND;
266: FETCH seq_ref_cursor INTO l_server_local_id;
267: END LOOP;

Line 270: l_msg := 'INSERT INTO cz_servers'||p_link_name||'

266: FETCH seq_ref_cursor INTO l_server_local_id;
267: END LOOP;
268: CLOSE seq_ref_cursor;
269:
270: l_msg := 'INSERT INTO cz_servers'||p_link_name||'
271: (server_local_id,local_name,hostname,db_listener_port,instance_name,import_enabled,source_server_flag)
272: SELECT '||l_server_local_id||',local_name,hostname,db_listener_port,instance_name,import_enabled,''1''
273: FROM cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';
274:

Line 273: FROM cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';

269:
270: l_msg := 'INSERT INTO cz_servers'||p_link_name||'
271: (server_local_id,local_name,hostname,db_listener_port,instance_name,import_enabled,source_server_flag)
272: SELECT '||l_server_local_id||',local_name,hostname,db_listener_port,instance_name,import_enabled,''1''
273: FROM cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';
274:
275: EXECUTE IMMEDIATE
276: 'INSERT INTO cz_servers'||p_link_name||
277: ' (server_local_id,local_name,hostname,db_listener_port,instance_name,import_enabled,source_server_flag) ' ||

Line 276: 'INSERT INTO cz_servers'||p_link_name||

272: SELECT '||l_server_local_id||',local_name,hostname,db_listener_port,instance_name,import_enabled,''1''
273: FROM cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';
274:
275: EXECUTE IMMEDIATE
276: 'INSERT INTO cz_servers'||p_link_name||
277: ' (server_local_id,local_name,hostname,db_listener_port,instance_name,import_enabled,source_server_flag) ' ||
278: ' SELECT '||l_server_local_id||',instance_name,hostname,db_listener_port,instance_name,import_enabled,''1'' ' ||
279: ' FROM cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';
280: COMMIT;

Line 279: ' FROM cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';

275: EXECUTE IMMEDIATE
276: 'INSERT INTO cz_servers'||p_link_name||
277: ' (server_local_id,local_name,hostname,db_listener_port,instance_name,import_enabled,source_server_flag) ' ||
278: ' SELECT '||l_server_local_id||',instance_name,hostname,db_listener_port,instance_name,import_enabled,''1'' ' ||
279: ' FROM cz_servers where UPPER(cz_servers.local_name) = ''LOCAL'' ';
280: COMMIT;
281: x_status := '0';
282: END IF;
283: EXCEPTION

Line 307: PROCEDURE verify_mig_tgt_server(p_link_name IN cz_servers.fndnam_link_name%TYPE,

303: ----------------------------------------------------------------
304: ----procedure used by migration to check if the target server is
305: ----a Development instance and models can indeed migrate
306: -----------------------------------------------------------------
307: PROCEDURE verify_mig_tgt_server(p_link_name IN cz_servers.fndnam_link_name%TYPE,
308: x_status OUT NOCOPY VARCHAR2,
309: x_msg OUT NOCOPY VARCHAR2)
310: IS
311:

Line 314: p_link_name_trim cz_servers.fndnam_link_name%TYPE;

310: IS
311:
312: l_converted_target VARCHAR2(1);
313: l_msg VARCHAR2(2000);
314: p_link_name_trim cz_servers.fndnam_link_name%TYPE;
315:
316: BEGIN
317:
318: --the local name is being passed as null because this is a migration