APPS.AME_CONFIG_VAR_API SQL Statements

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

Line: 12

procedure update_ame_config_variable
  (p_validate                    in     boolean   default false
  ,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
  ) is
  --
  -- Declare cursors and local variables
  --
  cursor csr_isAlreadyDefined is
    select 'Y'
      from ame_config_vars
     where application_id = p_application_id
       and variable_name  = p_variable_name
       and sysdate between start_date and
             nvl(end_date - ame_util.oneSecond, sysdate);

Line: 31

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

Line: 42

    savepoint update_ame_config_variable;

Line: 51

      ame_config_var_bk1.update_ame_config_variable_b
        (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
        );

Line: 60

                              (p_module_name => 'update_ame_config_variable'
                              ,p_hook_type   => 'BP'
                              );

Line: 81

                     ,p_datetrack_mode        => hr_api.g_update
                     ,p_application_id        => p_application_id
                     ,p_variable_name         => p_variable_name
                     ,p_variable_value        => p_variable_value
                     ,p_security_group_id     => null
                     ,p_object_version_number => p_object_version_number
                     ,p_start_date            => l_start_date
                     ,p_end_date              => l_end_date
                     );

Line: 96

      ame_config_var_bk1.update_ame_config_variable_a
        (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            => l_start_date
        ,p_end_date              => l_end_date
        );

Line: 107

                              (p_module_name => 'update_ame_config_variable'
                              ,p_hook_type   => 'AP'
                              );

Line: 130

      rollback to update_ame_config_variable;

Line: 145

      rollback to update_ame_config_variable;

Line: 156

  end update_ame_config_variable;

Line: 163

procedure delete_ame_config_variable
  (p_validate              in     boolean  default false
  ,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
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                   varchar2(72) := g_package||'delete_ame_config_variable';

Line: 184

    savepoint delete_ame_config_variable;

Line: 193

      ame_config_var_bk2.delete_ame_config_variable_b
        (p_application_id           => p_application_id
        ,p_variable_name            => p_variable_name
        ,p_object_version_number    => p_object_version_number
        );

Line: 201

                              (p_module_name => 'delete_ame_config_variable'
                              ,p_hook_type   => 'BP'
                              );

Line: 209

                   ,p_datetrack_mode          => hr_api.g_delete
                   ,p_application_id          => p_application_id
                   ,p_variable_name           => p_variable_name
                   ,p_object_version_number   => p_object_version_number
                   ,p_start_date              => l_start_date
                   ,p_end_date                => l_end_date
                   );

Line: 220

      ame_config_var_bk2.delete_ame_config_variable_a
      (p_application_id          => p_application_id
      ,p_variable_name           => p_variable_name
      ,p_object_version_number   => p_object_version_number
      ,p_start_date              => l_start_date
      ,p_end_date                => l_end_date
      );

Line: 230

                              (p_module_name => 'delete_ame_config_variable'
                              ,p_hook_type   => 'AP'
                              );

Line: 253

      rollback to delete_ame_config_variable;

Line: 268

      rollback to delete_ame_config_variable;

Line: 279

  end delete_ame_config_variable;