APPS.PAY_AU_PROCESS_PARAMETERS_API SQL Statements

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

Line: 36

  select process_parameter_id
  from   pay_au_process_parameters papp
  where  papp.process_id  = p_process_id
  and    papp.internal_name = p_internal_name;

Line: 117

procedure delete_au_process_parameter
  (p_validate                      in      boolean  default false,
   p_process_parameter_id          in      number,
   p_object_version_number         in      number)  is
  --
  l_proc                       varchar2(72);

Line: 125

  l_proc  := g_package||'delete_au_process_parameter';

Line: 132

    savepoint delete_au_process_parameter;

Line: 162

    ROLLBACK TO delete_au_process_parameter;

Line: 163

end delete_au_process_parameter;

Line: 170

procedure update_au_process_parameter
  (p_validate                      in      boolean  default false,
   p_process_parameter_id          in      number,
   p_process_id                    in      number,
   p_internal_name                 in      varchar2,
   p_data_type                     in      varchar2,
   p_enabled_flag                  in      varchar2,
   p_object_version_number         in out  nocopy   number
  )  is
  --
  l_proc                       varchar2(72);

Line: 183

  l_proc  := g_package||'update_au_process_parameter';

Line: 190

    savepoint update_au_process_parameter;

Line: 225

    ROLLBACK TO update_au_process_parameter;

Line: 226

end update_au_process_parameter;