APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on ALL_SYNONYMS

Line 551: FROM all_synonyms

547: FUNCTION CHECK_OLITE_SCHEMA RETURN VARCHAR2 IS
548: l_count NUMBER;
549: BEGIN
550: SELECT count(1) INTO l_count
551: FROM all_synonyms
552: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'FND_GLOBAL';
553: IF l_count = 0 THEN
554: -- csm_util_pkg.log(' synonym mobileadmin.FND_GLOBAL does not exist');
555: --EXECUTE IMMEDIATE 'create synonym mobileadmin.FND_GLOBAL for FND_GLOBAL';

Line 560: FROM all_synonyms

556: EXECUTE IMMEDIATE 'create synonym '
557: ||g_olite_schema||'.FND_GLOBAL for FND_GLOBAL';
558: END IF;
559: SELECT count(1) INTO l_count
560: FROM all_synonyms
561: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';
562: IF l_count = 0 THEN
563: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
564: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_profile_pkg for csm_profile_pkg';

Line 570: FROM all_synonyms

566: EXECUTE IMMEDIATE 'create synonym '
567: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';
568: END IF;
569: SELECT count(1) INTO l_count
570: FROM all_synonyms
571: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';
572: IF l_count = 0 THEN
573: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
574: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';