APPS.PER_ORG_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_topnode_pos_ctrl_enabled_fla in     varchar2  default null
  ,p_org_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: 73

    ,p_program_update_date          => p_program_update_date
    ,p_topnode_pos_ctrl_enabled_fla => p_topnode_pos_ctrl_enabled_fla
    ,p_org_structure_version_id     => p_org_structure_version_id
    ,p_object_version_number        => p_object_version_number
    ,p_gap_warning                  => l_gap_warning
    );

Line: 138

PROCEDURE delete_org_structure_version
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_org_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: 151

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

Line: 157

  savepoint delete_org_struct_version_swi;

Line: 177

  per_org_structure_version_api.delete_org_structure_version
    (p_validate                     => l_validate
    ,p_org_structure_version_id     => p_org_structure_version_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 204

    rollback to delete_org_struct_version_swi;

Line: 218

    rollback to delete_org_struct_version_swi;

Line: 228

end delete_org_structure_version;

Line: 232

PROCEDURE update_org_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_topnode_pos_ctrl_enabled_fla in     varchar2  default hr_api.g_varchar2
  ,p_org_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: 257

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

Line: 263

  savepoint update_org_struct_version_swi;

Line: 284

  per_org_structure_version_api.update_org_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_topnode_pos_ctrl_enabled_fla => p_topnode_pos_ctrl_enabled_fla
    ,p_org_structure_version_id     => p_org_structure_version_id
    ,p_object_version_number        => p_object_version_number
    ,p_gap_warning                  => l_gap_warning
    );

Line: 327

    rollback to update_org_struct_version_swi;

Line: 342

    rollback to update_org_struct_version_swi;

Line: 353

end update_org_structure_version;