APPS.PAY_AU_MODULES_SWI SQL Statements

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

Line: 133

PROCEDURE delete_au_module
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_module_id                    in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 148

  l_proc := g_package ||'delete_au_module';

Line: 154

  savepoint delete_au_module_swi;

Line: 174

  pay_au_modules_api.delete_au_module
    (p_validate                     => l_validate
    ,p_module_id                    => p_module_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 201

    rollback to delete_au_module_swi;

Line: 215

    rollback to delete_au_module_swi;

Line: 225

end delete_au_module;

Line: 229

PROCEDURE update_au_module
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_module_id                    in     number
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_enabled_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_module_type_id               in     number
  ,p_business_group_id            in     number
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_package_name                 in     varchar2  default hr_api.g_varchar2
  ,p_procedure_function_name      in     varchar2  default hr_api.g_varchar2
  ,p_formula_name                 in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 254

  l_proc    := g_package ||'update_au_module';

Line: 259

  savepoint update_au_module_swi;

Line: 280

  pay_au_modules_api.update_au_module
    (p_validate                     => l_validate
    ,p_module_id                    => p_module_id
    ,p_name                         => p_name
    ,p_enabled_flag                 => p_enabled_flag
    ,p_module_type_id               => p_module_type_id
    ,p_business_group_id            => p_business_group_id
    ,p_legislation_code             => p_legislation_code
    ,p_description                  => p_description
    ,p_package_name                 => p_package_name
    ,p_procedure_function_name      => p_procedure_function_name
    ,p_formula_name                 => p_formula_name
    ,p_object_version_number        => p_object_version_number
    );

Line: 316

    rollback to update_au_module_swi;

Line: 331

    rollback to update_au_module_swi;

Line: 342

end update_au_module;