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.

[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_API SQL Statements

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

Line: 81


  ,p_update_library_objectives in varchar2  default null    -- 8740021 bug fix
  ,p_automatic_approval_flag in varchar2  default null
  ) is
  --
  -- Declare cursors and local variables
  --
    l_proc                         varchar2(72) := g_package||'create_perf_mgmt_plan';

Line: 258


    ,p_update_library_objectives    => p_update_library_objectives  -- 8740021 bug fix
    ,p_automatic_approval_flag      => p_automatic_approval_flag
    );

Line: 344


  ,p_update_library_objectives    => p_update_library_objectives  -- 8740021 bug fix
  ,p_automatic_approval_flag      => p_automatic_approval_flag
  );

Line: 423


  ,p_update_library_objectives    => p_update_library_objectives  -- 8740021 bug fix
  ,p_automatic_approval_flag      => p_automatic_approval_flag
  );

Line: 536


procedure update_perf_mgmt_plan
  (p_validate                      in   boolean    default false
  ,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_duplicate_name_warning           out nocopy   boolean
  ,p_no_life_events_warning           out nocopy   boolean
  ,p_update_library_objectives in varchar2  default hr_api.g_varchar2     -- 8740021 bug fix
  ,p_automatic_approval_flag in varchar2  default hr_api.g_varchar2
  ) is

  --
  -- Declare cursors and local variables
  --
  --
  l_proc                       varchar2(72) := g_package||'update_perf_mgmt_plan';

Line: 710


  savepoint update_perf_mgmt_plan;

Line: 730


   hr_perf_mgmt_plan_bk2.update_perf_mgmt_plan_b
  (p_effective_date                => l_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                    => l_start_date
  ,p_end_date                      => l_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        => l_obj_setting_start_date
  ,p_obj_setting_deadline          => l_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         => l_object_version_number
  ,p_update_library_objectives    => p_update_library_objectives  -- 8740021 bug fix
  ,p_automatic_approval_flag      => p_automatic_approval_flag
  );

Line: 801


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

Line: 818


    l_status_code := 'UPDATED';

Line: 891


  ,p_update_library_objectives    => p_update_library_objectives  -- 8740021 bug fix
  ,p_automatic_approval_flag      => p_automatic_approval_flag
  );

Line: 900


  hr_perf_mgmt_plan_bk2.update_perf_mgmt_plan_a
  (p_effective_date                => l_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                    => l_start_date
  ,p_end_date                      => l_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        => l_obj_setting_start_date
  ,p_obj_setting_deadline          => l_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         => l_object_version_number
  ,p_status_code                   => l_status_code
  ,p_duplicate_name_warning        => l_duplicate_name_warning
  ,p_no_life_events_warning        => l_no_life_events_warning
  ,p_update_library_objectives    => p_update_library_objectives  -- 8740021 bug fix
  ,p_automatic_approval_flag      => p_automatic_approval_flag
  );

Line: 973


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

Line: 1037


      ROLLBACK TO update_perf_mgmt_plan;

Line: 1054


    rollback to update_perf_mgmt_plan;

Line: 1067


end update_perf_mgmt_plan;

Line: 1073


procedure delete_perf_mgmt_plan
  (p_validate                 in   boolean         default false
  ,p_plan_id                  in   number
  ,p_object_version_number    in   number
  ) is

  --
  -- Declare cursors and local variables
  --
     l_proc                  varchar2(72) := g_package||'delete_perf_mgmt_plan';

Line: 1111


     savepoint delete_perf_mgmt_plan;

Line: 1117


    hr_perf_mgmt_plan_bk3.delete_perf_mgmt_plan_b
    (p_plan_id                => p_plan_id
    ,p_object_version_number  => p_object_version_number
    );

Line: 1124


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

Line: 1147


  hr_perf_mgmt_plan_bk3.delete_perf_mgmt_plan_a
    (p_plan_id                => p_plan_id
    ,p_object_version_number  => p_object_version_number
    );

Line: 1154


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

Line: 1178


    rollback to delete_perf_mgmt_plan;

Line: 1190


    rollback to delete_perf_mgmt_plan;

Line: 1198


 end delete_perf_mgmt_plan;