APPS.HR_BATCH_MESSAGE_LINE_API SQL Statements

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

Line: 102

procedure delete_message_line
  (p_validate                      in     boolean  default false
  ,p_line_id                       in     number) is
  --
  l_proc                varchar2(72) := g_package||'delete_message_line';

Line: 116

  savepoint delete_message_line;

Line: 147

    ROLLBACK TO delete_message_line;

Line: 155

  ROLLBACK TO delete_message_line;

Line: 159

end delete_message_line;

Line: 165

procedure delete_batch_lines
  (p_validate                      in     boolean  default false
  ,p_batch_run_number              in     number) is
  --
  l_proc                varchar2(72) := g_package||'delete_batch_lines';

Line: 174

    select abm.line_id
    from   hr_api_batch_message_lines abm
    where  abm.batch_run_number = p_batch_run_number
    order by 1;

Line: 187

  savepoint delete_batch_lines;

Line: 202

    delete_message_line
      (p_validate => false
      ,p_line_id  => csr_sel.line_id);

Line: 227

    ROLLBACK TO delete_batch_lines;

Line: 235

  ROLLBACK TO delete_batch_lines;

Line: 239

end delete_batch_lines;