APPS.HR_PERF_MGMT_PLAN_API SQL Statements

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

Line: 528

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
  ) is

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

Line: 700

  savepoint update_perf_mgmt_plan;

Line: 720

   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
  );

Line: 789

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

Line: 806

    l_status_code := 'UPDATED';

Line: 886

  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
  );

Line: 957

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

Line: 1021

      ROLLBACK TO update_perf_mgmt_plan;

Line: 1038

    rollback to update_perf_mgmt_plan;

Line: 1051

end update_perf_mgmt_plan;

Line: 1057

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: 1095

     savepoint delete_perf_mgmt_plan;

Line: 1101

    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: 1108

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

Line: 1131

  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: 1138

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

Line: 1162

    rollback to delete_perf_mgmt_plan;

Line: 1174

    rollback to delete_perf_mgmt_plan;

Line: 1182

 end delete_perf_mgmt_plan;