DBA Data[Home] [Help]

APPS.CSL_TASK_ASSIGNMENTS_PKG dependencies on ASG_BASE

Line 236: if r_last_update_date.last_updated_by <> asg_base.get_user_id( p_record.clid$$cs ) AND r_last_update_date.last_update_date <> p_record.last_update_date then

232: then
233: open c_last_update_date(b_task_assignment_id => p_record.task_assignment_id);
234: fetch c_last_update_date into r_last_update_date;
235: if c_last_update_date%found then
236: if r_last_update_date.last_updated_by <> asg_base.get_user_id( p_record.clid$$cs ) AND r_last_update_date.last_update_date <> p_record.last_update_date then
237: close c_last_update_date;
238: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
239: jtm_message_log_pkg.Log_Msg
240: ( v_object_id => p_record.task_assignment_id

Line 820: AND l_user_id <> asg_base.get_user_id( p_user_name ) then

816: FETCH get_user_id INTO l_user_id ;
817: CLOSE get_user_id ;
818:
819: if l_profile_value = 'SERVER_WINS'
820: AND l_user_id <> asg_base.get_user_id( p_user_name ) then
821: RETURN 'S' ;
822: else
823: RETURN 'C' ;
824: END IF ;