DBA Data[Home] [Help]

APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on CSM_PROFILE_PKG

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

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

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

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';
565:
566: EXECUTE IMMEDIATE 'create synonym '
567: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';

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

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';
565:
566: EXECUTE IMMEDIATE 'create synonym '
567: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';
568: END IF;

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

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

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

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';
575:
576: EXECUTE IMMEDIATE 'create synonym '
577: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';

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

602: l_profile_value VARCHAR2(30) ;
603: BEGIN
604: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,
605: 'CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
606: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
607:
608: if l_profile_value = 'SERVER_WINS' then
609: RETURN 'S' ;
610: else