APPS.CSM_SERVICE_REQUESTS_PKG dependencies on ASG_BASE

Line 464: if r_last_update_date.last_update_date <> p_record.server_last_update_date and r_last_update_date.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs) then

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;
463: if c_last_update_date%found then
464: if r_last_update_date.last_update_date <> p_record.server_last_update_date and r_last_update_date.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs) then
465: close c_last_update_date;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE: Incident_id = '
468: || p_record.incident_id;

Line 962: if l_profile_value = 'SERVER_WINS' AND l_user_id <> asg_base.get_user_id(p_user_name) then

958: FETCH get_user_id
959: INTO l_user_id ;
960: CLOSE get_user_id ;
961:
962: if l_profile_value = 'SERVER_WINS' AND l_user_id <> asg_base.get_user_id(p_user_name) then
963: RETURN 'S' ;
964: else
965: RETURN 'C' ;
966: END IF ;