DBA Data[Home] [Help]

APPS.HR_WHO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

Procedure who(p_new_last_update_date	in out nocopy date,
              p_new_last_updated_by     in out nocopy number,
              p_new_last_update_login   in out nocopy number,
              p_old_last_update_date    in     date,
              p_old_last_updated_by     in     number,
              p_old_last_update_login   in     number) Is
--
  l_proc        varchar2(72)    := g_package||'who';
Line: 48

  If (p_new_last_update_date is null or
      p_new_last_update_date = p_old_last_update_date) Then
    p_new_last_update_date := sysdate;
Line: 55

  If (p_new_last_updated_by is null or
      p_new_last_updated_by = p_old_last_updated_by) Then
    p_new_last_updated_by := fnd_global.user_id;
Line: 62

  If (p_new_last_update_login is null or
      p_new_last_update_login = p_old_last_update_login) Then
    p_new_last_update_login := fnd_global.login_id;