APPS.PAY_BATCH_OBJECT_STATUS_PKG SQL Statements

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

Line: 17

  select
     bos.object_status
  from
    pay_batch_object_status bos
  where
      bos.object_type = p_object_type
  and bos.object_id   = p_object_id
  ;

Line: 72

  select
     bos.object_status
    ,bos.payroll_action_id
  from
    pay_batch_object_status bos
  where
      bos.object_type = p_object_type
  and bos.object_id   = p_object_id
  for update nowait
  ;

Line: 85

  select 1
  from  pay_payroll_actions
  where payroll_action_id = p_pact_id
  ;

Line: 255

    update pay_batch_object_status
    set object_status     = p_object_status
       ,payroll_action_id = p_payroll_action_id
    where
        object_type = p_object_type
    and object_id   = p_object_id;

Line: 266

    insert into pay_batch_object_status
      (object_type
      ,object_id
      ,object_status
      ,payroll_action_id
      )
      values
        (p_object_type
        ,p_object_id
        ,p_object_status
        ,p_payroll_action_id
        );

Line: 286

procedure delete_object_status
  (p_object_type                  in     varchar2
  ,p_object_id                    in     number
  ,p_payroll_action_id            in     number default null
  )
is
  l_object_status                 pay_batch_object_status.object_status%type;

Line: 304

  delete from pay_batch_object_status
  where
      object_type = p_object_type
  and object_id   = p_object_id;

Line: 309

end delete_object_status;