APPS.CZ_ORAAPPS_INTEGRATE dependencies on USER_DB_LINKS

Line 1371: --compatibility with the previously used SELECT COUNT(*) FROM USER_DB_LINKS

1367: END;
1368:
1369: ------------------------------------------------------------------------------
1370: --The function returns 1 if the link exists, 0 otherwise. This is done for
1371: --compatibility with the previously used SELECT COUNT(*) FROM USER_DB_LINKS
1372: --method which didn't work well because of GLOBAL_NAMES.
1373:
1374: FUNCTION doesLinkExist(p_link_name IN VARCHAR2) RETURN PLS_INTEGER IS
1375: v_null PLS_INTEGER;

Line 1378: SELECT NULL INTO v_null FROM user_db_links WHERE UPPER(db_link) = UPPER(p_link_name)

1374: FUNCTION doesLinkExist(p_link_name IN VARCHAR2) RETURN PLS_INTEGER IS
1375: v_null PLS_INTEGER;
1376: BEGIN
1377: EXECUTE IMMEDIATE 'SELECT NULL FROM DUAL@' || p_link_name;
1378: SELECT NULL INTO v_null FROM user_db_links WHERE UPPER(db_link) = UPPER(p_link_name)
1379: OR UPPER(db_link) LIKE UPPER(p_link_name) || '.%';
1380: RETURN 1;
1381: EXCEPTION
1382: WHEN NO_DATA_FOUND THEN