APPS.CZ_BOM_SYNCH dependencies on CZ_SERVERS

Line 14: g_target_instance cz_servers.server_local_id%TYPE;

10: component_seq_id_map typeIntegerTable_vc2; --SKM: Bug16190145 (Int2Long)
11: catalog_group_id_map typeNumberTable;
12: organization_id_map typeNumberTable;
13: APC_APPL_ID CONSTANT NUMBER:=431; --Application ID for Advanced Product Catalog Application
14: g_target_instance cz_servers.server_local_id%TYPE;
15: GenHeader VARCHAR2(100) := '$Header: czbomsyb.pls 120.12.12020000.3 2013/01/31 20:32:35 smanna ship $';
16: ---------------------------------------------------------------------------------------
17: --Synchronizes all the models in one instance to corresponding bills in the specified
18: --target instance. Stops and rolls back at the very first error or warning.

Line 177: sourceServer cz_servers.server_local_id%TYPE;

173: messageId PLS_INTEGER := 1000;
174: sourceLinkVerified PLS_INTEGER := ORACLE_NO;
175: sourceLinkName user_db_links.db_link%TYPE;
176: targetLinkName user_db_links.db_link%TYPE;
177: sourceServer cz_servers.server_local_id%TYPE;
178:
179: alreadyVerified typeIntegerTable_vc2; --Bug9941274
180:
181: baseLanguageCode fnd_languages.language_code%TYPE;

Line 310: --link name. As the same operation does not automatically occur in cz_servers table, names

306: BEGIN
307:
308: --This block is commented OUT NOCOPY as a fix for the bug #2195164. When the global name contains
309: --a not empty domain part, it will be automatically appended in user_db_links table to the
310: --link name. As the same operation does not automatically occur in cz_servers table, names
311: --of the links may not match.
312:
313: --BEGIN
314:

Line 348: instanceName cz_servers.local_name%TYPE;

344: --Does this only once per session.
345:
346: PROCEDURE verify_source_server IS
347:
348: instanceName cz_servers.local_name%TYPE;
349: linkName cz_servers.fndnam_link_name%TYPE;
350:
351: BEGIN
352: IF(sourceLinkVerified = ORACLE_NO)THEN

Line 349: linkName cz_servers.fndnam_link_name%TYPE;

345:
346: PROCEDURE verify_source_server IS
347:
348: instanceName cz_servers.local_name%TYPE;
349: linkName cz_servers.fndnam_link_name%TYPE;
350:
351: BEGIN
352: IF(sourceLinkVerified = ORACLE_NO)THEN
353:

Line 357: FROM cz_servers

353:
354: BEGIN
355:
356: SELECT fndnam_link_name, local_name INTO linkName, instanceName
357: FROM cz_servers
358: WHERE server_local_id = sourceServer;
359:
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN

Line 1343: linkName cz_servers.fndnam_link_name%TYPE;

1339: --Reads and verifies the link to the instance specified as target.
1340:
1341: PROCEDURE verify_target_instance IS
1342:
1343: linkName cz_servers.fndnam_link_name%TYPE;
1344:
1345: BEGIN
1346:
1347: --Read the link name from cz_servers for the specified target instance and verify the link.

Line 1347: --Read the link name from cz_servers for the specified target instance and verify the link.

1343: linkName cz_servers.fndnam_link_name%TYPE;
1344:
1345: BEGIN
1346:
1347: --Read the link name from cz_servers for the specified target instance and verify the link.
1348:
1349: BEGIN
1350:
1351: SELECT fndnam_link_name, server_local_id INTO linkName, g_target_instance

Line 1352: FROM cz_servers

1348:
1349: BEGIN
1350:
1351: SELECT fndnam_link_name, server_local_id INTO linkName, g_target_instance
1352: FROM cz_servers
1353: WHERE UPPER(local_name) = UPPER(p_target_name);
1354:
1355: EXCEPTION
1356: WHEN NO_DATA_FOUND THEN