APPS.CSM_SERVICE_REQUESTS_PKG dependencies on ASG_BASE

Line 562: 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

558: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE then
559: open c_last_update_date(b_incident_id => p_record.incident_id);
560: fetch c_last_update_date into r_last_update_date;
561: if c_last_update_date%found then
562: 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
563: close c_last_update_date;
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE: Incident_id = '
566: || p_record.incident_id;

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

1097: FETCH get_user_id
1098: INTO l_user_id ;
1099: CLOSE get_user_id ;
1100:
1101: if l_profile_value = 'SERVER_WINS' AND l_user_id <> asg_base.get_user_id(p_user_name) then
1102: RETURN 'S' ;
1103: else
1104: RETURN 'C' ;
1105: END IF ;