APPS.HR_FR_PERIODS_OF_SERVICE_API SQL Statements

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

Line: 12

procedure update_fr_pds_details
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_period_of_service_id          in     number
  ,p_termination_accepted_person   in     number   default hr_api.g_number
  ,p_accepted_termination_date     in     date     default hr_api.g_date
  ,p_object_version_number         in out nocopy number
  ,p_comments                      in     varchar2 default hr_api.g_varchar2
  ,p_leaving_reason                in     varchar2 default hr_api.g_varchar2
  ,p_notified_termination_date     in     date     default hr_api.g_date
  ,p_projected_termination_date    in     date     default hr_api.g_date
  ,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_starting_reason               in varchar2     default hr_api.g_varchar2
  ,p_ending_reason                 in varchar2     default hr_api.g_varchar2
  ,p_qualification_level           in varchar2     default hr_api.g_varchar2
  ,p_type_work                     in varchar2     default hr_api.g_varchar2
  ,p_employee_status               in varchar2     default hr_api.g_varchar2
  ,p_affiliated_alsace_moselle     in varchar2     default hr_api.g_varchar2
  ,p_relationship_MD               in varchar2     default hr_api.g_varchar2
  ,p_final_payment_schedule        in varchar2     default hr_api.g_varchar2
  ,p_social_plan                   in varchar2     default hr_api.g_varchar2
 ) is
  --
  -- Declare cursors and local variables
  --
  l_business_group_id per_contracts_f.business_group_id%TYPE;

Line: 58

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

Line: 63

    select pds.business_group_id
    from per_periods_of_service pds
    where pds.period_of_service_id = p_period_of_service_id;

Line: 68

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = l_business_group_id;

Line: 128

   hr_periods_of_service_api.update_pds_details
    ( p_validate 		      => p_validate
     ,p_effective_date                => p_effective_date
     ,p_period_of_service_id          => p_period_of_service_id
     ,p_termination_accepted_person   => p_termination_accepted_person
     ,p_accepted_termination_date     => p_accepted_termination_date
     ,p_comments                      => p_comments
     ,p_leaving_reason                => p_leaving_reason
     ,p_notified_termination_date     => p_notified_termination_date
     ,p_projected_termination_date    => p_projected_termination_date
     ,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_pds_information_category      => 'FR'
     ,p_pds_information1              => p_starting_reason
     ,p_pds_information2              => p_ending_reason
     ,p_pds_information3              => p_qualification_level
     ,p_pds_information4              => p_type_work
     ,p_pds_information5              => p_employee_status
     ,p_pds_information6              => p_affiliated_alsace_moselle
     ,p_pds_information7              => p_relationship_MD
     ,p_pds_information11             => p_final_payment_schedule
     ,p_pds_information12             => p_social_plan
     ,p_object_version_number         => p_object_version_number
     );

Line: 173

end update_fr_pds_details;