APPS.PAY_AU_PROCESS_MODULES_API SQL Statements

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

Line: 37

  select process_module_id
  from   pay_au_process_modules papm
  where  papm.process_id  = p_process_id
  and    papm.process_sequence = p_process_sequence;

Line: 118

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

Line: 126

  l_proc := g_package||'delete_au_process_module';

Line: 133

    savepoint delete_au_process_module;

Line: 163

    ROLLBACK TO delete_au_process_module;

Line: 164

end delete_au_process_module;

Line: 172

procedure update_au_process_module
  (p_validate                      in      boolean  default false,
   p_process_module_id             in      number,
   p_process_id                    in      number,
   p_module_id                     in      number,
   p_process_sequence              in      number,
   p_enabled_flag                  IN      varchar2,
   p_object_version_number         in out  nocopy   number
  )  is
  --
  l_proc                       varchar2(72);

Line: 185

  l_proc := g_package||'update_au_process_module';

Line: 192

    savepoint update_au_process_module;

Line: 227

    ROLLBACK TO update_au_process_module;

Line: 228

end update_au_process_module;