APPS.CZ_BOM_SYNCH dependencies on USER_DB_LINKS

Line 175: sourceLinkName user_db_links.db_link%TYPE;

171:
172: nDebug PLS_INTEGER := 1000;
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

Line 176: targetLinkName user_db_links.db_link%TYPE;

172: nDebug PLS_INTEGER := 1000;
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:

Line 300: --Verifies a database link by quering user_db_links and remote org_organization_definitions.

296: END;
297: ---------------------------------------------------------------------------------------
298: --build_structure_map->verify_database_link
299:
300: --Verifies a database link by quering user_db_links and remote org_organization_definitions.
301:
302: PROCEDURE verify_database_link(inLinkName IN VARCHAR2) IS
303:
304: nGeneric PLS_INTEGER;

Line 309: --a not empty domain part, it will be automatically appended in user_db_links table to the

305:
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

Line 316: -- FROM user_db_links

312:
313: --BEGIN
314:
315: -- SELECT NULL INTO nGeneric
316: -- FROM user_db_links
317: -- WHERE UPPER(db_link) = UPPER(inLinkName);
318:
319: --EXCEPTION
320: -- WHEN NO_DATA_FOUND THEN