APPS.PER_POS_STRUCTURE_VERSION_API SQL Statements

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

Line: 21

  ,p_program_update_date            in     date     default null
  ,p_pos_structure_version_id          out nocopy number
  ,p_object_version_number             out nocopy number
  ,p_gap_warning                       out nocopy boolean
  ) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'create_pos_structure_version';

Line: 54

  ,p_program_update_date           =>   p_program_update_date
  );

Line: 80

  ,p_program_update_date           =>   p_program_update_date
  ,p_pos_structure_version_id      =>   l_pos_structure_version_id
  ,p_object_version_number         =>   l_object_version_number
  ,p_gap_warning                   =>   p_gap_warning
);

Line: 117

  ,p_program_update_date           =>   p_program_update_date
  ,p_pos_structure_version_id      =>   l_pos_structure_version_id
  ,p_object_version_number         =>   l_object_version_number
  ,p_gap_warning                   =>   p_gap_warning);

Line: 165

PROCEDURE update_pos_structure_version
  (p_validate                      in     boolean  default false
  ,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_gap_warning                       out nocopy boolean) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'update_pos_structures';

Line: 190

  savepoint update_pos_structure_version;

Line: 193

per_pos_structure_version_bk2.update_pos_structure_version_b
  ( p_validate                      =>   p_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
);

Line: 211

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

Line: 238

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

Line: 263

per_pos_structure_version_bk2.update_pos_structure_version_a
  (p_validate                       =>  p_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                   =>   p_gap_warning);

Line: 281

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

Line: 293

    ROLLBACK TO update_pos_structure_version;

Line: 305

    ROLLBACK TO update_pos_structure_version;

Line: 310

END update_pos_structure_version;

Line: 316

PROCEDURE delete_pos_structure_version
   (  p_validate                     IN BOOLEAN default false
     ,p_pos_structure_version_id     IN number
     ,p_object_version_number        IN number )

IS
  --
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'delete_pos_structure_version';

Line: 333

  savepoint delete_pos_structure_version;

Line: 336

per_pos_structure_version_bk3.delete_pos_structure_version_b
    ( p_validate                    => p_validate
    , p_pos_structure_version_id    => p_pos_structure_version_id
    , p_object_version_number       => p_object_version_number
  );

Line: 345

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

Line: 375

per_pos_structure_version_bk3.delete_pos_structure_version_a
    (p_validate                     => p_validate
    ,p_pos_structure_version_id     => p_pos_structure_version_id
    ,p_object_version_number        => p_object_version_number
  );

Line: 384

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

Line: 397

    ROLLBACK TO delete_pos_structure_version;

Line: 407

    ROLLBACK TO delete_pos_structure_version;

Line: 411

end delete_pos_structure_version;