APPS.HR_WIP_LCKS SQL Statements

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

Line: 17

          select state,dml_mode
            from hr_wip_transactions
           where transaction_id = p_transaction_id;

Line: 74

  insert into hr_wip_locks
  (lock_id
  ,transaction_id
  ,table_name
  ,primary_key_val1
  ,primary_key_val2
  ,primary_key_val3
  ,primary_key_val4
  ,primary_key_val5)
  VALUES
  (hr_wip_locks_s.nextval
  ,p_transaction_id
  ,p_table_name
  ,p_primary_key_val1
  ,p_primary_key_val2
  ,p_primary_key_val3
  ,p_primary_key_val4
  ,p_primary_key_val5)returning lock_id into l_lock_id;

Line: 220

     select lck.transaction_id,
            lck.lock_id
     from   hr_wip_locks lck
     where  lck.transaction_id  <> p_transaction_id
     and    lck.table_name       = p_table_name
     and    lck.primary_key_val1 = p_primary_key_val1
     and  ((lck.primary_key_val2 = p_primary_key_val2)
     or    (lck.primary_key_val2 is null and p_primary_key_val2 is null))
     and  ((lck.primary_key_val3 = p_primary_key_val3)
     or    (lck.primary_key_val3 is null and p_primary_key_val3 is null))
     and  ((lck.primary_key_val4 = p_primary_key_val4)
     or    (lck.primary_key_val4 is null and p_primary_key_val4 is null))
     and  ((lck.primary_key_val5 = p_primary_key_val5)
     or    (lck.primary_key_val5 is null and p_primary_key_val5 is null));

Line: 273

  select lck.transaction_id,
         lck.lock_id
    from   hr_wip_locks lck
   where  lck.table_name       = p_table_name
     and    lck.primary_key_val1 = p_primary_key_val1
     and  ((lck.primary_key_val2 = p_primary_key_val2)
      or    (lck.primary_key_val2 is null and p_primary_key_val2 is null))
     and  ((lck.primary_key_val3 = p_primary_key_val3)
      or    (lck.primary_key_val3 is null and p_primary_key_val3 is null))
     and  ((lck.primary_key_val4 = p_primary_key_val4)
      or    (lck.primary_key_val4 is null and p_primary_key_val4 is null))
     and  ((lck.primary_key_val5 = p_primary_key_val5)
      or    (lck.primary_key_val5 is null and p_primary_key_val5 is null));