APPS.PQH_DE_RESULT_SETS_SWI SQL Statements

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

Line: 11

PROCEDURE delete_result_sets
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_result_set_id                in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 24

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

Line: 30

  savepoint delete_result_sets_swi;

Line: 50

  pqh_de_result_sets_api.delete_result_sets
    (p_validate                     => l_validate
    ,p_result_set_id                => p_result_set_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 77

    rollback to delete_result_sets_swi;

Line: 91

    rollback to delete_result_sets_swi;

Line: 101

end delete_result_sets;

Line: 105

PROCEDURE insert_result_sets
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_gradual_value_number_from    in     number
  ,p_gradual_value_number_to      in     number
  ,p_grade_id                     in     number
  ,p_result_set_id                   out nocopy number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 122

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

Line: 128

  savepoint insert_result_sets_swi;

Line: 148

  pqh_de_result_sets_api.insert_result_sets
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_gradual_value_number_from    => p_gradual_value_number_from
    ,p_gradual_value_number_to      => p_gradual_value_number_to
    ,p_grade_id                     => p_grade_id
    ,p_result_set_id                => p_result_set_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 179

    rollback to insert_result_sets_swi;

Line: 195

    rollback to insert_result_sets_swi;

Line: 207

end insert_result_sets;

Line: 211

PROCEDURE update_result_sets
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_result_set_id                in     number
  ,p_object_version_number        in out nocopy number
  ,p_gradual_value_number_from    in     number    default hr_api.g_number
  ,p_gradual_value_number_to      in     number    default hr_api.g_number
  ,p_grade_id                     in     number    default hr_api.g_number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 229

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

Line: 235

  savepoint update_result_sets_swi;

Line: 256

  pqh_de_result_sets_api.update_result_sets
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_result_set_id                => p_result_set_id
    ,p_object_version_number        => p_object_version_number
    ,p_gradual_value_number_from    => p_gradual_value_number_from
    ,p_gradual_value_number_to      => p_gradual_value_number_to
    ,p_grade_id                     => p_grade_id
    );

Line: 287

    rollback to update_result_sets_swi;

Line: 302

    rollback to update_result_sets_swi;

Line: 313

end update_result_sets;