APPS.PER_ORG_STRUCTURE_VERSION_API SQL Statements

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

Line: 17

  cursor struct_element is  select *
    from per_org_structure_elements ose
    where ose.org_structure_version_id = p_copy_structure_version_id;

Line: 68

  ,p_program_update_date            in     date     default null
  ,p_topnode_pos_ctrl_enabled_fla   in     varchar2 default 'N'
  ,p_org_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_rowid VARCHAR2(20);

Line: 85

  cursor c is select rowid
      FROM PER_ORG_STRUCTURE_VERSIONS
      WHERE org_structure_version_id = l_Org_Structure_Version_Id;

Line: 118

  ,p_program_update_date           =>   p_program_update_date
  ,p_topnode_pos_ctrl_enabled_fla  =>   p_topnode_pos_ctrl_enabled_fla
  );

Line: 145

  ,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      =>   l_org_structure_version_id
  ,p_object_version_number         =>   l_object_version_number
  ,p_gap_warning                   =>   p_gap_warning
  );

Line: 167

  ,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      =>   l_org_structure_version_id
  ,p_object_version_number         =>   l_object_version_number
  ,p_gap_warning                   =>   p_gap_warning  );

Line: 253

PROCEDURE update_org_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_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_gap_warning                       out nocopy boolean
) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'update_org_structures';

Line: 280

  savepoint update_org_structure_version;

Line: 283

per_org_structure_version_bk2.update_org_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_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
);

Line: 302

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

Line: 328

  ,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         =>   l_object_version_number
  ,p_gap_warning                   =>   p_gap_warning    );

Line: 354

per_org_structure_version_bk2.update_org_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_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                   =>   p_gap_warning);

Line: 373

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

Line: 385

    ROLLBACK TO update_org_structure;

Line: 395

    ROLLBACK TO update_org_structure_version;

Line: 405

END update_org_structure_version;

Line: 411

PROCEDURE delete_org_structure_version
   (  p_validate                     IN BOOLEAN         default false
     ,p_org_structure_version_id     IN number
     ,p_object_version_number        IN number )

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

Line: 428

  savepoint delete_organization;

Line: 431

per_org_structure_version_bk3.delete_org_structure_version_b
    ( p_validate                    => p_validate
    , p_org_structure_version_id    => p_org_structure_version_id
    , p_object_version_number       => p_object_version_number
  );

Line: 440

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

Line: 470

per_org_structure_version_bk3.delete_org_structure_version_a
    (p_validate                     => p_validate
    ,p_org_structure_version_id     => p_org_structure_version_id
    ,p_object_version_number        => p_object_version_number
  );

Line: 479

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

Line: 492

    ROLLBACK TO delete_org_structure_version;

Line: 502

    ROLLBACK TO delete_org_structure_version;

Line: 506

end delete_org_structure_version;