APPS.PAY_AU_MODULE_TYPES_API SQL Statements

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

Line: 34

  select module_type_id from pay_au_module_types pamt
  where  pamt.name  = p_name;

Line: 114

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

Line: 122

  l_proc := g_package||'delete_au_module_type';

Line: 129

    savepoint delete_au_module_type;

Line: 159

    ROLLBACK TO delete_au_module_type;

Line: 160

end delete_au_module_type;

Line: 167

procedure update_au_module_type
  (p_validate                      in      boolean  default false,
   p_module_type_id                in      number,
   p_name                          in      varchar2,
   p_enabled_flag                  in      varchar2,
   p_description                   in      varchar2,
   p_object_version_number         in out  nocopy   number
  )  is
  --
  l_proc                       varchar2(72);

Line: 179

  l_proc := g_package||'update_au_module_type';

Line: 186

    savepoint update_au_module_type;

Line: 220

    ROLLBACK TO update_au_module_type;

Line: 221

end update_au_module_type;