APPS.AME_CONDITION_SWI SQL Statements

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

Line: 149

PROCEDURE update_ame_condition
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_condition_id                 in     number
  ,p_parameter_one                in     varchar2  default hr_api.g_varchar2
  ,p_parameter_two                in     varchar2  default hr_api.g_varchar2
  ,p_parameter_three              in     varchar2  default hr_api.g_varchar2
  ,p_include_upper_limit          in     varchar2  default hr_api.g_varchar2
  ,p_include_lower_limit          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: 170

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

Line: 176

  savepoint update_ame_condition_swi;

Line: 197

  ame_condition_api.update_ame_condition
    (p_validate                     => l_validate
    ,p_condition_id                 => p_condition_id
    ,p_parameter_one                => p_parameter_one
    ,p_parameter_two                => p_parameter_two
    ,p_parameter_three              => p_parameter_three
    ,p_include_upper_limit          => p_include_upper_limit
    ,p_include_lower_limit          => p_include_lower_limit
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 231

    rollback to update_ame_condition_swi;

Line: 248

    rollback to update_ame_condition_swi;

Line: 261

end update_ame_condition;

Line: 265

PROCEDURE delete_ame_condition
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_condition_id                 in     number
  ,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: 281

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

Line: 287

  savepoint delete_ame_condition_swi;

Line: 308

  ame_condition_api.delete_ame_condition
    (p_validate                     => l_validate
    ,p_condition_id                 => p_condition_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 337

    rollback to delete_ame_condition_swi;

Line: 354

    rollback to delete_ame_condition_swi;

Line: 367

end delete_ame_condition;

Line: 477

PROCEDURE delete_ame_string_value
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_condition_id                 in     number
  ,p_string_value                 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: 494

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

Line: 500

  savepoint delete_ame_string_value_swi;

Line: 521

  ame_condition_api.delete_ame_string_value
    (p_validate                     => l_validate
    ,p_condition_id                 => p_condition_id
    ,p_string_value                 => p_string_value
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 551

    rollback to delete_ame_string_value_swi;

Line: 568

    rollback to delete_ame_string_value_swi;

Line: 581

end delete_ame_string_value;