APPS.PAY_AU_MODULE_PARAMETERS_SWI SQL Statements

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

Line: 141

PROCEDURE delete_au_module_parameter
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_module_parameter_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: 156

  l_proc := g_package ||'delete_au_module_parameter';

Line: 162

  savepoint delete_au_module_parameter_swi;

Line: 182

  pay_au_module_parameters_api.delete_au_module_parameter
    (p_validate                     => l_validate
    ,p_module_parameter_id          => p_module_parameter_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 209

    rollback to delete_au_module_parameter_swi;

Line: 223

    rollback to delete_au_module_parameter_swi;

Line: 233

end delete_au_module_parameter;

Line: 237

PROCEDURE update_au_module_parameter
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_module_parameter_id          in     number
  ,p_module_id                    in     number
  ,p_internal_name                in     varchar2  default hr_api.g_varchar2
  ,p_data_type                    in     varchar2  default hr_api.g_varchar2
  ,p_input_flag                   in     varchar2  default hr_api.g_varchar2
  ,p_context_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_output_flag                  in     varchar2  default hr_api.g_varchar2
  ,p_result_flag                  in     varchar2  default hr_api.g_varchar2
  ,p_error_message_flag           in     varchar2  default hr_api.g_varchar2
  ,p_enabled_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_function_return_flag         in     varchar2  default hr_api.g_varchar2
  ,p_external_name                in     varchar2  default hr_api.g_varchar2
  ,p_database_item_name           in     varchar2  default hr_api.g_varchar2
  ,p_constant_value               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: 266

  l_proc    := g_package ||'update_au_module_parameter';

Line: 272

  savepoint update_au_module_parameter_swi;

Line: 293

  pay_au_module_parameters_api.update_au_module_parameter
    (p_validate                     => l_validate
    ,p_module_parameter_id          => p_module_parameter_id
    ,p_module_id                    => p_module_id
    ,p_internal_name                => p_internal_name
    ,p_data_type                    => p_data_type
    ,p_input_flag                   => p_input_flag
    ,p_context_flag                 => p_context_flag
    ,p_output_flag                  => p_output_flag
    ,p_result_flag                  => p_result_flag
    ,p_error_message_flag           => p_error_message_flag
    ,p_enabled_flag                 => p_enabled_flag
    ,p_function_return_flag         => p_function_return_flag
    ,p_external_name                => p_external_name
    ,p_database_item_name           => p_database_item_name
    ,p_constant_value               => p_constant_value
    ,p_object_version_number        => p_object_version_number
    );

Line: 333

    rollback to update_au_module_parameter_swi;

Line: 348

    rollback to update_au_module_parameter_swi;

Line: 359

end update_au_module_parameter;