APPS.HR_SA_PERIODS_OF_SERVICE_API SQL Statements

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

Line: 14

procedure update_sa_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_hijrah_termination_date       in varchar2     default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_business_group_id    per_periods_of_service.business_group_id%TYPE;

Line: 52

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

Line: 56

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

Line: 61

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

Line: 71

  savepoint update_sa_pds_details;

Line: 118

  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_object_version_number         =>   p_object_version_number
    ,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      =>   'SA'
    ,p_pds_information1              =>   p_hijrah_termination_date);

Line: 155

end update_sa_pds_details;