APPS.CZ_BOM_SYNCH dependencies on CZ_SERVERS

Line 14: g_target_instance cz_servers.server_local_id%TYPE;

10: component_seq_id_map typeNumberTable;
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.9 2008/04/15 20:52:26 asiaston 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 173: sourceServer cz_servers.server_local_id%TYPE;

169: messageId PLS_INTEGER := 1000;
170: sourceLinkVerified PLS_INTEGER := ORACLE_NO;
171: sourceLinkName user_db_links.db_link%TYPE;
172: targetLinkName user_db_links.db_link%TYPE;
173: sourceServer cz_servers.server_local_id%TYPE;
174:
175: alreadyVerified typeIntegerTable;
176:
177: baseLanguageCode fnd_languages.language_code%TYPE;

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

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

Line 344: instanceName cz_servers.local_name%TYPE;

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

Line 345: linkName cz_servers.fndnam_link_name%TYPE;

341:
342: PROCEDURE verify_source_server IS
343:
344: instanceName cz_servers.local_name%TYPE;
345: linkName cz_servers.fndnam_link_name%TYPE;
346:
347: BEGIN
348: IF(sourceLinkVerified = ORACLE_NO)THEN
349:

Line 353: FROM cz_servers

349:
350: BEGIN
351:
352: SELECT fndnam_link_name, local_name INTO linkName, instanceName
353: FROM cz_servers
354: WHERE server_local_id = sourceServer;
355:
356: EXCEPTION
357: WHEN NO_DATA_FOUND THEN

Line 1332: linkName cz_servers.fndnam_link_name%TYPE;

1328: --Reads and verifies the link to the instance specified as target.
1329:
1330: PROCEDURE verify_target_instance IS
1331:
1332: linkName cz_servers.fndnam_link_name%TYPE;
1333:
1334: BEGIN
1335:
1336: --Read the link name from cz_servers for the specified target instance and verify the link.

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

1332: linkName cz_servers.fndnam_link_name%TYPE;
1333:
1334: BEGIN
1335:
1336: --Read the link name from cz_servers for the specified target instance and verify the link.
1337:
1338: BEGIN
1339:
1340: SELECT fndnam_link_name, server_local_id INTO linkName, g_target_instance

Line 1341: FROM cz_servers

1337:
1338: BEGIN
1339:
1340: SELECT fndnam_link_name, server_local_id INTO linkName, g_target_instance
1341: FROM cz_servers
1342: WHERE UPPER(local_name) = UPPER(p_target_name);
1343:
1344: EXCEPTION
1345: WHEN NO_DATA_FOUND THEN