DBA Data[Home] [Help]

APPS.PER_SUCCESSOR_IN_PLAN_API SQL Statements

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

Line: 353

procedure update_successor_in_plan
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_successor_in_plan_id         in     number
  ,p_object_version_number        in out nocopy number
  ,p_plan_id                      in     number    default hr_api.g_number
  ,p_successor_id                 in     number    default hr_api.g_number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_status                       in     varchar2  default hr_api.g_varchar2
  ,p_rank                         in     number    default hr_api.g_number
  ,p_potential                    in     varchar2  default hr_api.g_varchar2
  ,p_performance_rating           in     varchar2  default hr_api.g_varchar2
  ,p_risk_of_loss                 in     varchar2  default hr_api.g_varchar2
  ,p_impact_of_loss               in     varchar2  default hr_api.g_varchar2
  ,p_readiness_pct                in     number    default hr_api.g_number
  ,p_eligible_for_promotion       in     varchar2  default hr_api.g_varchar2
  ,p_earliest_succession_date     in     date      default hr_api.g_date
  ,p_latest_succession_date       in     date      default hr_api.g_date
  ,p_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_planned_date                 in     date      default hr_api.g_date
  ,p_assignment_id                in     number    default hr_api.g_number
  ,p_supervisor_id                in     number    default hr_api.g_number
  ,p_grade_id                     in     number    default hr_api.g_number
  ,p_grade_ladder_id              in     number    default hr_api.g_number
  ,p_grade_step_id                in     number    default hr_api.g_number
  ,p_grade_point_id               in     number    default hr_api.g_number
  ,p_position_id                  in     number    default hr_api.g_number
  ,p_job_id                       in     number    default hr_api.g_number
  ,p_assignment_status_type_id    in     number    default hr_api.g_number
  ,p_organization_id              in     number    default hr_api.g_number
  ,p_people_group_id              in     number    default hr_api.g_number
  ,p_pay_basis_id                 in     number    default hr_api.g_number
  ,p_employee_category            in     varchar2  default hr_api.g_varchar2
  ,p_bargaining_unit_code         in     varchar2  default hr_api.g_varchar2
  ,p_labour_union_member_flag     in     varchar2  default hr_api.g_varchar2
  ,p_collective_agreement_id      in     number    default hr_api.g_number
  ,p_assignment_category          in     varchar2  default hr_api.g_varchar2
  ,p_location_id                  in     number    default hr_api.g_number
  ,p_contract_id                  in     number    default hr_api.g_number)
 is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;
Line: 418

  l_proc                varchar2(72) := g_package||'update_successor_in_plan';
Line: 425

  savepoint update_successor_in_plan;
Line: 439

    per_successor_in_plan_bk2.update_successor_in_plan_b
  (p_effective_date                =>  l_effective_date
  ,p_successor_in_plan_id          =>  p_successor_in_plan_id
  ,p_plan_id                       =>  p_plan_id
  ,p_successor_id                  =>  p_successor_id
  ,p_business_group_id             =>  p_business_group_id
  ,p_status                        =>  p_status
  ,p_rank                          =>  p_rank
  ,p_potential                     =>  p_potential
  ,p_performance_rating            =>  p_performance_rating
  ,p_risk_of_loss                  =>  p_risk_of_loss
  ,p_impact_of_loss                =>  p_impact_of_loss
  ,p_readiness_pct                 =>  p_readiness_pct
  ,p_eligible_for_promotion        =>  p_eligible_for_promotion
  ,p_earliest_succession_date      =>  p_earliest_succession_date
  ,p_latest_succession_date        =>  p_latest_succession_date
  ,p_comments                      =>  p_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_planned_date                  =>  p_planned_date
  ,p_assignment_id                 =>  p_assignment_id
  ,p_supervisor_id                 =>  p_supervisor_id
  ,p_grade_id                      =>  p_grade_id
  ,p_grade_ladder_id               =>  p_grade_ladder_id
  ,p_grade_step_id                 =>  p_grade_step_id
  ,p_grade_point_id                =>  p_grade_point_id
  ,p_position_id                   =>  p_position_id
  ,p_job_id                        =>  p_job_id
  ,p_assignment_status_type_id     =>  p_assignment_status_type_id
  ,p_organization_id               =>  p_organization_id
  ,p_people_group_id               =>  p_people_group_id
  ,p_pay_basis_id                  =>  p_pay_basis_id
  ,p_employee_category             =>  p_employee_category
  ,p_bargaining_unit_code          =>  p_bargaining_unit_code
  ,p_labour_union_member_flag      =>  p_labour_union_member_flag
  ,p_collective_agreement_id       =>  p_collective_agreement_id
  ,p_assignment_category           =>  p_assignment_category
  ,p_location_id                   =>  p_location_id
  ,p_contract_id                   =>  p_contract_id    );
Line: 500

        (p_module_name => 'update_successor_in_plan_b'
        ,p_hook_type   => 'BP'
        );
Line: 579

    per_successor_in_plan_bk2.update_successor_in_plan_a
      (   p_effective_date                =>  l_effective_date
  ,p_successor_in_plan_id          =>  p_successor_in_plan_id
  ,p_plan_id                       =>  p_plan_id
  ,p_successor_id                  =>  p_successor_id
  ,p_business_group_id             =>  p_business_group_id
  ,p_status                        =>  p_status
  ,p_rank                          =>  p_rank
  ,p_potential                     =>  p_potential
  ,p_performance_rating            =>  p_performance_rating
  ,p_risk_of_loss                  =>  p_risk_of_loss
  ,p_impact_of_loss                =>  p_impact_of_loss
  ,p_readiness_pct                 =>  p_readiness_pct
  ,p_eligible_for_promotion        =>  p_eligible_for_promotion
  ,p_earliest_succession_date      =>  p_earliest_succession_date
  ,p_latest_succession_date        =>  p_latest_succession_date
  ,p_comments                      =>  p_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_planned_date                  =>  p_planned_date
  ,p_assignment_id                 =>  p_assignment_id
  ,p_supervisor_id                 =>  p_supervisor_id
  ,p_grade_id                      =>  p_grade_id
  ,p_grade_ladder_id               =>  p_grade_ladder_id
  ,p_grade_step_id                 =>  p_grade_step_id
  ,p_grade_point_id                =>  p_grade_point_id
  ,p_position_id                   =>  p_position_id
  ,p_job_id                        =>  p_job_id
  ,p_assignment_status_type_id     =>  p_assignment_status_type_id
  ,p_organization_id               =>  p_organization_id
  ,p_people_group_id               =>  p_people_group_id
  ,p_pay_basis_id                  =>  p_pay_basis_id
  ,p_employee_category             =>  p_employee_category
  ,p_bargaining_unit_code          =>  p_bargaining_unit_code
  ,p_labour_union_member_flag      =>  p_labour_union_member_flag
  ,p_collective_agreement_id       =>  p_collective_agreement_id
  ,p_assignment_category           =>  p_assignment_category
  ,p_location_id                   =>  p_location_id
  ,p_contract_id                   =>  p_contract_id  );
Line: 640

        (p_module_name => 'update_successor_in_plan_b'
        ,p_hook_type   => 'AP'
        );
Line: 664

    rollback to update_successor_in_plan;
Line: 676

    rollback to update_successor_in_plan;
Line: 684

end update_successor_in_plan;
Line: 687

procedure delete_successor_in_plan
  (p_validate                             in     boolean  default false
  ,p_successor_in_plan_id                 in     number
  ,p_object_version_number                in     number)  is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_successor_in_plan';
Line: 700

  savepoint delete_successor_in_plan;
Line: 702

  per_successor_in_plan_bk3.delete_successor_in_plan_b(p_successor_in_plan_id => p_successor_in_plan_id);
Line: 707

  per_successor_in_plan_bk3.delete_successor_in_plan_a(p_successor_in_plan_id => p_successor_in_plan_id);
Line: 726

    rollback to delete_successor_in_plan;
Line: 737

    rollback to delete_successor_in_plan;
Line: 745

end delete_successor_in_plan;