APPS.PER_POS_STRUCTURE_VERSION_SWI SQL Statements

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

Line: 22

  ,p_program_update_date          in     date      default null
  ,p_pos_structure_version_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: 72

    ,p_program_update_date          => p_program_update_date
    ,p_pos_structure_version_id     => p_pos_structure_version_id
    ,p_object_version_number        => p_object_version_number
    ,p_gap_warning                  => l_gap_warning
    );

Line: 136

PROCEDURE delete_pos_structure_version
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_pos_structure_version_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: 149

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

Line: 155

  savepoint delete_posstructureversion_swi;

Line: 175

  per_pos_structure_version_api.delete_pos_structure_version
    (p_validate                     => l_validate
    ,p_pos_structure_version_id     => p_pos_structure_version_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 202

    rollback to delete_posstructureversion_swi;

Line: 216

    rollback to delete_posstructureversion_swi;

Line: 226

end delete_pos_structure_version;

Line: 230

PROCEDURE update_pos_structure_version
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_date_from                    in     date
  ,p_version_number               in     number
  ,p_copy_structure_version_id    in     number    default hr_api.g_number
  ,p_date_to                      in     date      default hr_api.g_date
  ,p_request_id                   in     number    default hr_api.g_number
  ,p_program_application_id       in     number    default hr_api.g_number
  ,p_program_id                   in     number    default hr_api.g_number
  ,p_program_update_date          in     date      default hr_api.g_date
  ,p_pos_structure_version_id     in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 254

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

Line: 260

  savepoint update_posstructureversion_swi;

Line: 281

  per_pos_structure_version_api.update_pos_structure_version
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_date_from                    => p_date_from
    ,p_version_number               => p_version_number
    ,p_copy_structure_version_id    => p_copy_structure_version_id
    ,p_date_to                      => p_date_to
    ,p_request_id                   => p_request_id
    ,p_program_application_id       => p_program_application_id
    ,p_program_id                   => p_program_id
    ,p_program_update_date          => p_program_update_date
    ,p_pos_structure_version_id     => p_pos_structure_version_id
    ,p_object_version_number        => p_object_version_number
    ,p_gap_warning                  => l_gap_warning
    );

Line: 323

    rollback to update_posstructureversion_swi;

Line: 338

    rollback to update_posstructureversion_swi;

Line: 349

end update_pos_structure_version;