APPS.PAY_AU_MODULE_PARAMETERS_API SQL Statements

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

Line: 45

  select pamp.module_parameter_id
  from   pay_au_module_parameters pamp
  where  pamp.module_id  = p_module_id
  and    pamp.external_name = p_external_name;

Line: 134

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

Line: 142

  l_proc := g_package||'delete_au_module_parameter';

Line: 149

    savepoint delete_au_module_parameter;

Line: 179

    ROLLBACK TO delete_au_module_parameter;

Line: 180

end delete_au_module_parameter;

Line: 187

procedure update_au_module_parameter
  (p_validate                      in      boolean  default false,
   p_module_parameter_id           in      number,
   p_module_id                     in      number,
   p_internal_name                 in      varchar2,
   p_data_type                     in      varchar2,
   p_input_flag                    in      varchar2,
   p_context_flag                  in      varchar2,
   p_output_flag                   in      varchar2,
   p_result_flag                   in      varchar2,
   p_error_message_flag            in      varchar2,
   p_enabled_flag                  in      varchar2,
   p_function_return_flag          in      varchar2,
   p_external_name                 in      varchar2,
   p_database_item_name            in      varchar2,
   p_constant_value                in      varchar2,
   p_object_version_number         in out nocopy number
  )  is
  --
  l_proc                       varchar2(72);

Line: 209

  l_proc := g_package||'update_au_module_parameter';

Line: 216

    savepoint update_au_module_parameter;

Line: 260

    ROLLBACK TO update_au_module_parameter;

Line: 261

end update_au_module_parameter;