APPS.CZ_BOM_SYNCH dependencies on USER_DB_LINKS

Line 171: sourceLinkName user_db_links.db_link%TYPE;

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

Line 172: targetLinkName user_db_links.db_link%TYPE;

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

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

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

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

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

Line 312: -- FROM user_db_links

308:
309: --BEGIN
310:
311: -- SELECT NULL INTO nGeneric
312: -- FROM user_db_links
313: -- WHERE UPPER(db_link) = UPPER(inLinkName);
314:
315: --EXCEPTION
316: -- WHEN NO_DATA_FOUND THEN