APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on ALL_SYNONYMS

Line 444: FROM all_synonyms

440: FUNCTION CHECK_OLITE_SCHEMA RETURN VARCHAR2 IS
441: l_count NUMBER;
442: BEGIN
443: SELECT count(1) INTO l_count
444: FROM all_synonyms
445: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'FND_GLOBAL';
446: IF l_count = 0 THEN
447: -- csm_util_pkg.log(' synonym mobileadmin.FND_GLOBAL does not exist');
448: --EXECUTE IMMEDIATE 'create synonym mobileadmin.FND_GLOBAL for FND_GLOBAL';

Line 453: FROM all_synonyms

449: EXECUTE IMMEDIATE 'create synonym '
450: ||g_olite_schema||'.FND_GLOBAL for FND_GLOBAL';
451: END IF;
452: SELECT count(1) INTO l_count
453: FROM all_synonyms
454: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';
455: IF l_count = 0 THEN
456: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
457: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_profile_pkg for csm_profile_pkg';

Line 463: FROM all_synonyms

459: EXECUTE IMMEDIATE 'create synonym '
460: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';
461: END IF;
462: SELECT count(1) INTO l_count
463: FROM all_synonyms
464: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';
465: IF l_count = 0 THEN
466: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
467: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';