APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on ASG_BASE

Line 278: IF(r_deb_head.last_update_date <> p_record.server_last_update_date AND r_deb_head.last_updated_by <> NVL(p_record.last_updated_by,asg_base.get_user_id(p_record.clid$$cs))) THEN --12.1

274:
275: -- SERVER_WINS profile value
276: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS) AND
277: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE THEN
278: IF(r_deb_head.last_update_date <> p_record.server_last_update_date AND r_deb_head.last_updated_by <> NVL(p_record.last_updated_by,asg_base.get_user_id(p_record.clid$$cs))) THEN --12.1
279: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For CSF_DEBRIEF_HEADERS: CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE: P_KEY = '
280: || p_record.debrief_header_id;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: csm_util_pkg.log(p_error_msg, g_object_name || '.APPLY_UPDATE', FND_LOG.LEVEL_ERROR);

Line 411: IF (r_debrief_header.last_update_date <> p_record.server_last_update_date AND r_debrief_header.last_updated_by <> NVL(p_record.last_updated_by,asg_base.get_user_id(p_record.clid$$cs))) THEN --12.1

407: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE THEN
408: OPEN c_debrief_header(b_debrief_header_id => p_record.debrief_header_id, b_task_assignment_id => p_record.task_assignment_id);
409: FETCH c_debrief_header INTO r_debrief_header;
410: IF c_debrief_header%FOUND THEN
411: IF (r_debrief_header.last_update_date <> p_record.server_last_update_date AND r_debrief_header.last_updated_by <> NVL(p_record.last_updated_by,asg_base.get_user_id(p_record.clid$$cs))) THEN --12.1
412: CLOSE c_debrief_header;
413: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_UPDATE:'
414: || ' for PK ' || p_record.debrief_header_id,
415: g_object_name || '.APPLY_UPDATE',

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

749: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
750: FETCH get_user_id INTO l_user_id ;
751: CLOSE get_user_id ;
752:
753: if l_profile_value = 'SERVER_WINS' AND l_user_id <> asg_base.get_user_id(p_user_name) then
754: RETURN 'S' ;
755: else
756: RETURN 'C' ;
757: END IF ;