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.HR_PERF_MGMT_PLAN_SWI SQL Statements

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

Line: 252


PROCEDURE delete_perf_mgmt_plan
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_plan_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: 265


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

Line: 271


  savepoint delete_perf_mgmt_plan_swi;

Line: 291


  hr_perf_mgmt_plan_api.delete_perf_mgmt_plan
    (p_validate                     => l_validate
    ,p_plan_id                      => p_plan_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 318


    rollback to delete_perf_mgmt_plan_swi;

Line: 332


    rollback to delete_perf_mgmt_plan_swi;

Line: 342


end delete_perf_mgmt_plan;

Line: 346


PROCEDURE update_perf_mgmt_plan
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_plan_id                      in     number
  ,p_plan_name                    in     varchar2  default hr_api.g_varchar2
  ,p_administrator_person_id      in     number    default hr_api.g_number
  ,p_previous_plan_id             in     number    default hr_api.g_number
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_hierarchy_type_code          in     varchar2  default hr_api.g_varchar2
  ,p_supervisor_id                in     number    default hr_api.g_number
  ,p_supervisor_assignment_id     in     number    default hr_api.g_number
  ,p_organization_structure_id    in     number    default hr_api.g_number
  ,p_org_structure_version_id     in     number    default hr_api.g_number
  ,p_top_organization_id          in     number    default hr_api.g_number
  ,p_position_structure_id        in     number    default hr_api.g_number
  ,p_pos_structure_version_id     in     number    default hr_api.g_number
  ,p_top_position_id              in     number    default hr_api.g_number
  ,p_hierarchy_levels             in     number    default hr_api.g_number
  ,p_automatic_enrollment_flag    in     varchar2  default hr_api.g_varchar2
  ,p_assignment_types_code        in     varchar2  default hr_api.g_varchar2
  ,p_primary_asg_only_flag        in     varchar2  default hr_api.g_varchar2
  ,p_include_obj_setting_flag     in     varchar2  default hr_api.g_varchar2
  ,p_obj_setting_start_date       in     date      default hr_api.g_date
  ,p_obj_setting_deadline         in     date      default hr_api.g_date
  ,p_obj_set_outside_period_flag  in     varchar2  default hr_api.g_varchar2
  ,p_method_code                  in     varchar2  default hr_api.g_varchar2
  ,p_notify_population_flag       in     varchar2  default hr_api.g_varchar2
  ,p_automatic_allocation_flag    in     varchar2  default hr_api.g_varchar2
  ,p_copy_past_objectives_flag    in     varchar2  default hr_api.g_varchar2
  ,p_sharing_alignment_task_flag  in     varchar2  default hr_api.g_varchar2
  ,p_include_appraisals_flag      in     varchar2  default hr_api.g_varchar2
  ,p_change_sc_status_flag 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_attribute21                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute22                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute23                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute24                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute25                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute26                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute27                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute28                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute29                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute30                  in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_status_code                     out nocopy varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 424


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

Line: 430


  savepoint update_perf_mgmt_plan_swi;

Line: 451


  hr_perf_mgmt_plan_api.update_perf_mgmt_plan
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_plan_id                      => p_plan_id
    ,p_plan_name                    => p_plan_name
    ,p_administrator_person_id      => p_administrator_person_id
    ,p_previous_plan_id             => p_previous_plan_id
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_hierarchy_type_code          => p_hierarchy_type_code
    ,p_supervisor_id                => p_supervisor_id
    ,p_supervisor_assignment_id     => p_supervisor_assignment_id
    ,p_organization_structure_id    => p_organization_structure_id
    ,p_org_structure_version_id     => p_org_structure_version_id
    ,p_top_organization_id          => p_top_organization_id
    ,p_position_structure_id        => p_position_structure_id
    ,p_pos_structure_version_id     => p_pos_structure_version_id
    ,p_top_position_id              => p_top_position_id
    ,p_hierarchy_levels             => p_hierarchy_levels
    ,p_automatic_enrollment_flag    => p_automatic_enrollment_flag
    ,p_assignment_types_code        => p_assignment_types_code
    ,p_primary_asg_only_flag        => p_primary_asg_only_flag
    ,p_include_obj_setting_flag     => p_include_obj_setting_flag
    ,p_obj_setting_start_date       => p_obj_setting_start_date
    ,p_obj_setting_deadline         => p_obj_setting_deadline
    ,p_obj_set_outside_period_flag  => p_obj_set_outside_period_flag
    ,p_method_code                  => p_method_code
    ,p_notify_population_flag       => p_notify_population_flag
    ,p_automatic_allocation_flag    => p_automatic_allocation_flag
    ,p_copy_past_objectives_flag    => p_copy_past_objectives_flag
    ,p_sharing_alignment_task_flag  => p_sharing_alignment_task_flag
    ,p_include_appraisals_flag      => p_include_appraisals_flag
 ,p_change_sc_status_flag  => p_change_sc_status_flag
    ,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_attribute21                  => p_attribute21
    ,p_attribute22                  => p_attribute22
    ,p_attribute23                  => p_attribute23
    ,p_attribute24                  => p_attribute24
    ,p_attribute25                  => p_attribute25
    ,p_attribute26                  => p_attribute26
    ,p_attribute27                  => p_attribute27
    ,p_attribute28                  => p_attribute28
    ,p_attribute29                  => p_attribute29
    ,p_attribute30                  => p_attribute30
    ,p_object_version_number        => p_object_version_number
    ,p_status_code                  => p_status_code
    ,p_duplicate_name_warning       => l_duplicate_name_warning
    ,p_no_life_events_warning       => l_no_life_events_warning
    );

Line: 553


    rollback to update_perf_mgmt_plan_swi;

Line: 569


    rollback to update_perf_mgmt_plan_swi;

Line: 581


end update_perf_mgmt_plan;