APPS.AME_RLU_SHD SQL Statements

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

Line: 48

    select
     item_id
    ,usage_type
    ,rule_id
    ,start_date
    ,end_date
    ,security_group_id
    ,priority
    ,approver_category
    ,object_version_number
    ,start_date
    from        ame_rule_usages
    where       rule_id = p_rule_id
      and    item_id = p_item_id
      and    ( p_effective_date
           between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
          or
         (p_effective_date < start_date and
            start_date < nvl(end_date,start_date + ame_util.oneSecond)));

Line: 157

  update  ame_rule_usages t
  set     t.end_date          = p_new_end_date
         ,t.last_updated_by   = l_current_user_id
         ,t.last_update_date  = p_new_end_date
         ,t.last_update_login = l_current_user_id
    ,     t.object_version_number = l_object_version_number
  where   t.rule_id = p_rule_id
 and    t.item_id = p_item_id
 and    t.start_date = p_old_start_date
   and    ( p_effective_date
           between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
          or
         (p_effective_date < t.start_date and
            t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));

Line: 202

    select
     item_id
    ,usage_type
    ,rule_id
    ,start_date
    ,end_date
    ,security_group_id
    ,priority
    ,approver_category
    ,object_version_number
    ,start_date
    from    ame_rule_usages
    where   rule_id = p_rule_id
      and    item_id = p_item_id
      and    start_date = p_old_start_date
      and    ( p_effective_date
           between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
          or
         (p_effective_date < start_date and
            start_date < nvl(end_date,start_date + ame_util.oneSecond)))
    for update nowait;

Line: 253

  If (p_datetrack_mode <> hr_api.g_insert) then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;

Line: 290

  if (p_datetrack_mode = hr_api.g_update) then
    p_validation_start_date := p_effective_date;

Line: 293

  elsif (p_datetrack_mode = hr_api.g_delete) then
    p_validation_start_date := p_effective_date;

Line: 302

    select null
      into l_dummy
      from ame_rules
      where rule_id = p_rule_id and
       ((p_effective_date between start_date and
            nvl(end_date - ame_util.oneSecond, p_effective_date)) or
        (p_effective_date < start_date and
            start_date < nvl(end_date,start_date + ame_util.oneSecond)))
       for update of end_date nowait;

Line: 390

  select nvl(max(t.object_version_number),0) + 1
    into l_ovn
    from ame_rule_usages t
   where t.rule_id = p_rule_id
 and    t.item_id = p_item_id
 and    t.start_date = p_old_start_date;