DBA Data[Home] [Help]

APPS.CSM_SERVICE_REQUESTS_PKG dependencies on CSM_PROFILE_PKG

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

454:
455: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,
456: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
457: -- Check for Stale data
458: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
459: if l_profile_value = 'SERVER_WINS' AND
460: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE then
461: open c_last_update_date(b_incident_id => p_record.incident_id);
462: fetch c_last_update_date into r_last_update_date;

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

952: AND a.incident_id = b.incident_id ;
953:
954: BEGIN
955: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_SERVICE_REQUESTS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
956: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
957: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
958: FETCH get_user_id
959: INTO l_user_id ;
960: CLOSE get_user_id ;