APPS.AME_CONFIG_VAR_SWI SQL Statements

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

Line: 11

PROCEDURE update_ame_config_variable
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_application_id               in     number
  ,p_variable_name                in     varchar2
  ,p_variable_value               in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 29

  l_proc    varchar2(72) := g_package ||'update_ame_config_variable';

Line: 35

  savepoint update_ame_config_variable_swi;

Line: 56

  ame_config_var_api.update_ame_config_variable
    (p_validate                     => l_validate
    ,p_application_id               => p_application_id
    ,p_variable_name                => p_variable_name
    ,p_variable_value               => p_variable_value
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 87

    rollback to update_ame_config_variable_swi;

Line: 104

    rollback to update_ame_config_variable_swi;

Line: 117

end update_ame_config_variable;

Line: 121

PROCEDURE delete_ame_config_variable
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_application_id               in     number
  ,p_variable_name                in     varchar2
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 138

  l_proc    varchar2(72) := g_package ||'delete_ame_config_variable';

Line: 144

  savepoint delete_ame_config_variable_swi;

Line: 165

  ame_config_var_api.delete_ame_config_variable
    (p_validate                     => l_validate
    ,p_application_id               => p_application_id
    ,p_variable_name                => p_variable_name
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 195

    rollback to delete_ame_config_variable_swi;

Line: 212

    rollback to delete_ame_config_variable_swi;

Line: 225

end delete_ame_config_variable;