APPS.PAY_AU_MODULES_API SQL Statements

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

Line: 41

  select module_id
  from   pay_au_modules pam
  where  pam.name  = p_name
  and    (pam.business_group_id is null
         or pam.business_group_id = p_business_group_id)
  and    pam.legislation_code = p_legislation_code;

Line: 129

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

Line: 137

  l_proc := g_package||'delete_au_module';

Line: 144

    savepoint delete_au_module;

Line: 174

    ROLLBACK TO delete_au_module;

Line: 175

end delete_au_module;

Line: 182

procedure update_au_module
  (p_validate                      in      boolean  default false,
   p_module_id                     in      number,
   p_name                          in      varchar2,
   p_enabled_flag                  in      varchar2,
   p_module_type_id                in      number,
   p_business_group_id             in      number,
   p_legislation_code              in      varchar2,
   p_description                   in      varchar2,
   p_package_name                  in      varchar2,
   p_procedure_function_name       in      varchar2,
   p_formula_name                  in      varchar2,
   p_object_version_number         in out  nocopy   number
  )  is
  --
  l_proc                       varchar2(72);

Line: 200

  l_proc := g_package||'update_au_module';

Line: 207

    savepoint update_au_module;

Line: 247

    ROLLBACK TO update_au_module;

Line: 248

end update_au_module;