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

Line 12: serverLocalName cz_servers.local_name%TYPE;

8: thisRunId PLS_INTEGER;
9: thisStatusCode PLS_INTEGER;
10:
11: dbLinkName user_db_links.db_link%TYPE;
12: serverLocalName cz_servers.local_name%TYPE;
13: serverLocalId cz_servers.server_local_id%TYPE;
14: NoIntegrityCheck BOOLEAN;
15:
16: PROCEDURE adjust_specific_control;

Line 13: serverLocalId cz_servers.server_local_id%TYPE;

9: thisStatusCode PLS_INTEGER;
10:
11: dbLinkName user_db_links.db_link%TYPE;
12: serverLocalName cz_servers.local_name%TYPE;
13: serverLocalId cz_servers.server_local_id%TYPE;
14: NoIntegrityCheck BOOLEAN;
15:
16: PROCEDURE adjust_specific_control;
17: FUNCTION verify_target_database RETURN PLS_INTEGER;

Line 88: FROM cz_servers WHERE UPPER(local_name) = UPPER(p_local_name);

84: RETURN INTEGER IS
85: BEGIN
86:
87: SELECT server_local_id, fndnam_link_name INTO serverLocalId, x_link_name
88: FROM cz_servers WHERE UPPER(local_name) = UPPER(p_local_name);
89:
90: IF(x_link_name IS NULL)THEN
91: --'No database link is associated with the specified server name ''%LOCALNAME''.'
92: report(CZ_UTILS.GET_TEXT('CZ_MIGR_EMPTY_LINK', 'LOCALNAME', p_local_name), URGENCY_ERROR);

Line 309: sourceMaxId cz_servers.server_local_id%TYPE;

305: xReturnStatus VARCHAR2(255);
306: xMsgData VARCHAR2(32000);
307:
308: MigrationStatus cz_db_settings.value%TYPE;
309: sourceMaxId cz_servers.server_local_id%TYPE;
310: targetMaxId cz_servers.server_local_id%TYPE;
311: srcPbSessionCnt NUMBER := 0;
312: l_src_sessn_cur REF_CURSOR;
313: begin

Line 310: targetMaxId cz_servers.server_local_id%TYPE;

306: xMsgData VARCHAR2(32000);
307:
308: MigrationStatus cz_db_settings.value%TYPE;
309: sourceMaxId cz_servers.server_local_id%TYPE;
310: targetMaxId cz_servers.server_local_id%TYPE;
311: srcPbSessionCnt NUMBER := 0;
312: l_src_sessn_cur REF_CURSOR;
313: begin
314:

Line 438: --CZ_SERVERS: we need to make sure that the current server entry would not conflict with a server entry in

434: end if;
435:
436: --Start of the table-specific data preparation section----------------------------------------------------
437:
438: --CZ_SERVERS: we need to make sure that the current server entry would not conflict with a server entry in
439: --the source table. Do this only if CZ_SERVERS is on the processing list and only for 'MIGRATE' operation.
440:
441: FOR c_table IN (SELECT NULL FROM cz_xfr_tables
442: WHERE UPPER(dst_table) = 'CZ_SERVERS'

Line 439: --the source table. Do this only if CZ_SERVERS is on the processing list and only for 'MIGRATE' operation.

435:
436: --Start of the table-specific data preparation section----------------------------------------------------
437:
438: --CZ_SERVERS: we need to make sure that the current server entry would not conflict with a server entry in
439: --the source table. Do this only if CZ_SERVERS is on the processing list and only for 'MIGRATE' operation.
440:
441: FOR c_table IN (SELECT NULL FROM cz_xfr_tables
442: WHERE UPPER(dst_table) = 'CZ_SERVERS'
443: AND UPPER(xfr_group) = 'MIGRATE'

Line 442: WHERE UPPER(dst_table) = 'CZ_SERVERS'

438: --CZ_SERVERS: we need to make sure that the current server entry would not conflict with a server entry in
439: --the source table. Do this only if CZ_SERVERS is on the processing list and only for 'MIGRATE' operation.
440:
441: FOR c_table IN (SELECT NULL FROM cz_xfr_tables
442: WHERE UPPER(dst_table) = 'CZ_SERVERS'
443: AND UPPER(xfr_group) = 'MIGRATE'
444: AND disabled = '0'
445: AND ROWNUM = 1) LOOP
446:

Line 449: EXECUTE IMMEDIATE 'SELECT MAX(server_local_id) FROM cz_servers' INTO targetMaxId;

445: AND ROWNUM = 1) LOOP
446:
447: BEGIN
448:
449: EXECUTE IMMEDIATE 'SELECT MAX(server_local_id) FROM cz_servers' INTO targetMaxId;
450: EXECUTE IMMEDIATE 'SELECT MAX(server_local_id) FROM cz_servers@' || dbLinkName INTO sourceMaxId;
451:
452: UPDATE cz_servers SET
453: server_local_id = GREATEST(NVL(sourceMaxId, 0), NVL(targetMaxId, 0))

Line 450: EXECUTE IMMEDIATE 'SELECT MAX(server_local_id) FROM cz_servers@' || dbLinkName INTO sourceMaxId;

446:
447: BEGIN
448:
449: EXECUTE IMMEDIATE 'SELECT MAX(server_local_id) FROM cz_servers' INTO targetMaxId;
450: EXECUTE IMMEDIATE 'SELECT MAX(server_local_id) FROM cz_servers@' || dbLinkName INTO sourceMaxId;
451:
452: UPDATE cz_servers SET
453: server_local_id = GREATEST(NVL(sourceMaxId, 0), NVL(targetMaxId, 0))
454: WHERE server_local_id = serverLocalId

Line 452: UPDATE cz_servers SET

448:
449: EXECUTE IMMEDIATE 'SELECT MAX(server_local_id) FROM cz_servers' INTO targetMaxId;
450: EXECUTE IMMEDIATE 'SELECT MAX(server_local_id) FROM cz_servers@' || dbLinkName INTO sourceMaxId;
451:
452: UPDATE cz_servers SET
453: server_local_id = GREATEST(NVL(sourceMaxId, 0), NVL(targetMaxId, 0))
454: WHERE server_local_id = serverLocalId
455: RETURNING server_local_id INTO serverLocalId;
456:

Line 461: report(CZ_UTILS.GET_TEXT('CZ_MIGR_PREPARE_ERROR', 'TABLENAME', 'CZ_SERVERS', 'ERRORTEXT', SQLERRM), URGENCY_WARNING);

457: EXCEPTION
458: WHEN OTHERS THEN
459:
460: --'Error in table-specific data preparation for the table ''%TABLENAME'': %ERRORTEXT.'
461: report(CZ_UTILS.GET_TEXT('CZ_MIGR_PREPARE_ERROR', 'TABLENAME', 'CZ_SERVERS', 'ERRORTEXT', SQLERRM), URGENCY_WARNING);
462:
463: IF(StopOnSkippable = 1)THEN RETURN FATAL_ERROR; END IF;
464: END;
465: END LOOP;

Line 1531: AND UPPER(dst_table) = 'CZ_SERVERS';

1527: AND UPPER(dst_table) IN ('CZ_DB_SETTINGS', 'CZ_XFR_FIELDS');
1528:
1529: UPDATE cz_xfr_tables SET xfr_group = 'MIGRATE'
1530: WHERE UPPER(xfr_group) = 'OVERRIDE'
1531: AND UPPER(dst_table) = 'CZ_SERVERS';
1532:
1533: UPDATE cz_xfr_tables SET disabled = '1'
1534: WHERE UPPER(xfr_group) = 'TRIGGERS'
1535: AND UPPER(dst_table) NOT LIKE 'CZ/_%' ESCAPE '/';

Line 1770: (62, 'SEQUENCES', '0', 'CZ_SERVERS_S', 'CZ_SERVERS', 'SERVER_LOCAL_ID', '20');

1766:
1767: INSERT INTO cz_xfr_tables
1768: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1769: VALUES
1770: (62, 'SEQUENCES', '0', 'CZ_SERVERS_S', 'CZ_SERVERS', 'SERVER_LOCAL_ID', '20');
1771:
1772: INSERT INTO cz_xfr_tables
1773: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1774: VALUES

Line 2025: l_link_name cz_servers.fndnam_link_name%TYPE;

2021: x_return_status OUT NOCOPY VARCHAR2,
2022: x_msg_count OUT NOCOPY NUMBER,
2023: x_msg_data OUT NOCOPY VARCHAR2)
2024: IS
2025: l_link_name cz_servers.fndnam_link_name%TYPE;
2026: l_ref_cursor ref_cursor;
2027: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2028: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2029: l_XML_CHUNK VARCHAR2(32767);

Line 2097: l_link_name cz_servers.fndnam_link_name%TYPE;

2093: IS
2094: TYPE t_ref IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2095: l_ui_def_id_tbl t_ref;
2096: l_template_id_tbl t_ref;
2097: l_link_name cz_servers.fndnam_link_name%TYPE;
2098: l_ref_cursor ref_cursor;
2099: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2100: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2101: l_XML_CHUNK VARCHAR2(32767);