DBA Data[Home] [Help]

APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on CSM_PROFILE_PKG

Line 454: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';

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';
458:

Line 456: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');

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';
458:
459: EXECUTE IMMEDIATE 'create synonym '
460: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';

Line 457: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_profile_pkg for csm_profile_pkg';

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';
458:
459: EXECUTE IMMEDIATE 'create synonym '
460: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';
461: END IF;

Line 460: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';

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';
458:
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';

Line 466: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');

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';
468:
469: EXECUTE IMMEDIATE 'create synonym '
470: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';

Line 499: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);

495: l_profile_value VARCHAR2(30) ;
496: BEGIN
497: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,
498: 'CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
499: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
500:
501: if l_profile_value = 'SERVER_WINS' then
502: RETURN 'S' ;
503: else