eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SUCCESSION_PLAN_API SQL Statements

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

Line: 270


procedure update_succession_plan
 (p_validate                     in boolean         default false,
  p_succession_plan_id           in number,
  p_person_id                    in number           default hr_api.g_number,
  p_position_id                  in number           default hr_api.g_number,
  p_business_group_id            in number           default hr_api.g_number,
  p_start_date                   in date             default hr_api.g_date,
  p_time_scale                   in varchar2         default hr_api.g_varchar2,
  p_end_date                     in date             default hr_api.g_date,
  p_available_for_promotion      in varchar2         default hr_api.g_varchar2,
  p_manager_comments             in varchar2         default hr_api.g_varchar2,
  p_attribute_category           in varchar2         default hr_api.g_varchar2,
  p_attribute1                   in varchar2         default hr_api.g_varchar2,
  p_attribute2                   in varchar2         default hr_api.g_varchar2,
  p_attribute3                   in varchar2         default hr_api.g_varchar2,
  p_attribute4                   in varchar2         default hr_api.g_varchar2,
  p_attribute5                   in varchar2         default hr_api.g_varchar2,
  p_attribute6                   in varchar2         default hr_api.g_varchar2,
  p_attribute7                   in varchar2         default hr_api.g_varchar2,
  p_attribute8                   in varchar2         default hr_api.g_varchar2,
  p_attribute9                   in varchar2         default hr_api.g_varchar2,
  p_attribute10                  in varchar2         default hr_api.g_varchar2,
  p_attribute11                  in varchar2         default hr_api.g_varchar2,
  p_attribute12                  in varchar2         default hr_api.g_varchar2,
  p_attribute13                  in varchar2         default hr_api.g_varchar2,
  p_attribute14                  in varchar2         default hr_api.g_varchar2,
  p_attribute15                  in varchar2         default hr_api.g_varchar2,
  p_attribute16                  in varchar2         default hr_api.g_varchar2,
  p_attribute17                  in varchar2         default hr_api.g_varchar2,
  p_attribute18                  in varchar2         default hr_api.g_varchar2,
  p_attribute19                  in varchar2         default hr_api.g_varchar2,
  p_attribute20                  in varchar2         default hr_api.g_varchar2,
  p_effective_date               in date,
  p_job_id                       in number           default hr_api.g_number,
  p_successee_person_id          in number           default hr_api.g_number,
  p_object_version_number        in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_succession_plan_id		per_succession_planning.succession_plan_id%TYPE;

Line: 317


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

Line: 323


  savepoint update_succession_plan;

Line: 340


    PER_SUCCESSION_PLAN_BK2.update_succession_plan_b
      (
   p_person_id                    => p_person_id
 , p_position_id                  => p_position_id
 , p_business_group_id            => p_business_group_id
 , p_start_date                   => l_start_date
 , p_time_scale                   => p_time_scale
 , p_end_date                     => l_end_date
 , p_available_for_promotion      => p_available_for_promotion
 , p_manager_comments             => p_manager_comments
 , p_attribute_category           => p_attribute_category
 , p_attribute1                   => p_attribute1
 , p_attribute2                   => p_attribute2
 , p_attribute3                   => p_attribute3
 , p_attribute4                   => p_attribute4
 , p_attribute5                   => p_attribute5
 , p_attribute6                   => p_attribute6
 , p_attribute7                   => p_attribute7
 , p_attribute8                   => p_attribute8
 , p_attribute9                   => p_attribute9
 , p_attribute10                  => p_attribute10
 , p_attribute11                  => p_attribute11
 , p_attribute12                  => p_attribute12
 , p_attribute13                  => p_attribute13
 , p_attribute14                  => p_attribute14
 , p_attribute15                  => p_attribute15
 , p_attribute16                  => p_attribute16
 , p_attribute17                  => p_attribute17
 , p_attribute18                  => p_attribute18
 , p_attribute19                  => p_attribute19
 , p_attribute20                  => p_attribute20
 , p_effective_date               => l_effective_date
 , p_job_id                       => p_job_id
 , p_successee_person_id          => p_successee_person_id
 , p_succession_plan_id           => p_succession_plan_id
 , p_object_version_number        => p_object_version_number
      );

Line: 380


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

Line: 434


hr_utility.set_location('Entering:'|| 'PER_SUCCESSION_PLAN_BK1.update_succession_plan_a', 60);

Line: 439


    PER_SUCCESSION_PLAN_BK2.update_succession_plan_a
     (
   p_person_id                    => p_person_id
 , p_position_id                  => p_position_id
 , p_business_group_id            => p_business_group_id
 , p_start_date                   => l_start_date
 , p_time_scale                   => p_time_scale
 , p_end_date                     => l_end_date
 , p_available_for_promotion      => p_available_for_promotion
 , p_manager_comments             => p_manager_comments
 , p_attribute_category           => p_attribute_category
 , p_attribute1                   => p_attribute1
 , p_attribute2                   => p_attribute2
 , p_attribute3                   => p_attribute3
 , p_attribute4                   => p_attribute4
 , p_attribute5                   => p_attribute5
 , p_attribute6                   => p_attribute6
 , p_attribute7                   => p_attribute7
 , p_attribute8                   => p_attribute8
 , p_attribute9                   => p_attribute9
 , p_attribute10                  => p_attribute10
 , p_attribute11                  => p_attribute11
 , p_attribute12                  => p_attribute12
 , p_attribute13                  => p_attribute13
 , p_attribute14                  => p_attribute14
 , p_attribute15                  => p_attribute15
 , p_attribute16                  => p_attribute16
 , p_attribute17                  => p_attribute17
 , p_attribute18                  => p_attribute18
 , p_attribute19                  => p_attribute19
 , p_attribute20                  => p_attribute20
 , p_effective_date               => l_effective_date
 , p_job_id                       => p_job_id
 , p_successee_person_id          => p_successee_person_id
 , p_succession_plan_id           => l_succession_plan_id
 , p_object_version_number        => l_object_version_number
      );

Line: 479


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

Line: 503


    rollback to update_succession_plan;

Line: 517


    rollback to update_succession_plan;

Line: 527


end update_succession_plan;

Line: 533


procedure delete_succession_plan
(p_validate                           in boolean default false,
 p_succession_plan_id                 in number,
 p_object_version_number              in number
) is
  --
  -- Declare cursors and local variables
  --

  --
  --
  l_proc        varchar2(72) := g_package||'delete_succession_plan';

Line: 550


  savepoint delete_succession_plan;

Line: 556


    PER_SUCCESSION_PLAN_BK3.delete_succession_plan_b
      (p_succession_plan_id                       => p_succession_plan_id,
       p_object_version_number              => p_object_version_number
      );

Line: 564


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

Line: 601


    PER_SUCCESSION_PLAN_BK3.delete_succession_plan_a
      (p_succession_plan_id                 => p_succession_plan_id,
       p_object_version_number              => p_object_version_number
      );

Line: 608


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

Line: 628


    ROLLBACK TO delete_succession_plan;

Line: 640


  ROLLBACK TO delete_succession_plan;

Line: 644


end delete_succession_plan;