APPS.HR_PL_CONTINGENT_WORKER_API SQL Statements

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

Line: 48

  ,p_resume_last_updated           in     date     default null
  ,p_second_passport_exists        in     varchar2 default null
  ,p_sex                           in     varchar2 default null
  ,p_student_status                in     varchar2 default null
  ,p_suffix                        in     varchar2 default null
  ,p_title                         in     varchar2 default null
  ,p_town_of_birth                 in     varchar2 default null
  ,p_uses_tobacco_flag             in     varchar2 default null
  ,p_vendor_id                     in     number   default null
  ,p_work_schedule                 in     varchar2 default null
  ,p_work_telephone                in     varchar2 default null
  ,p_exp_check_send_to_address     in     varchar2 default null
  ,p_hold_applicant_date_until     in     date     default null
  ,p_date_employee_data_verified   in     date     default null
  ,p_benefit_group_id              in     number   default null
  ,p_coord_ben_med_pln_no          in     varchar2 default null
  ,p_coord_ben_no_cvg_flag         in     varchar2 default null
  ,p_original_date_of_hire         in     date     default null
  ,p_attribute_category            in     varchar2 default null
  ,p_attribute1                    in     varchar2 default null
  ,p_attribute2                    in     varchar2 default null
  ,p_attribute3                    in     varchar2 default null
  ,p_attribute4                    in     varchar2 default null
  ,p_attribute5                    in     varchar2 default null
  ,p_attribute6                    in     varchar2 default null
  ,p_attribute7                    in     varchar2 default null
  ,p_attribute8                    in     varchar2 default null
  ,p_attribute9                    in     varchar2 default null
  ,p_attribute10                   in     varchar2 default null
  ,p_attribute11                   in     varchar2 default null
  ,p_attribute12                   in     varchar2 default null
  ,p_attribute13                   in     varchar2 default null
  ,p_attribute14                   in     varchar2 default null
  ,p_attribute15                   in     varchar2 default null
  ,p_attribute16                   in     varchar2 default null
  ,p_attribute17                   in     varchar2 default null
  ,p_attribute18                   in     varchar2 default null
  ,p_attribute19                   in     varchar2 default null
  ,p_attribute20                   in     varchar2 default null
  ,p_attribute21                   in     varchar2 default null
  ,p_attribute22                   in     varchar2 default null
  ,p_attribute23                   in     varchar2 default null
  ,p_attribute24                   in     varchar2 default null
  ,p_attribute25                   in     varchar2 default null
  ,p_attribute26                   in     varchar2 default null
  ,p_attribute27                   in     varchar2 default null
  ,p_attribute28                   in     varchar2 default null
  ,p_attribute29                   in     varchar2 default null
  ,p_attribute30                   in     varchar2 default null
  ,p_per_information_category      in     varchar2 default null
  ,p_nip_number                    in     varchar2 default null
  ,p_per_information2              in     varchar2 default null
  ,p_per_information3              in     varchar2 default null
  ,p_per_information4              in     varchar2 default null
  ,p_per_information5              in     varchar2 default null
  ,p_per_information6              in     varchar2 default null
  ,p_per_information7              in     varchar2 default null
  ,p_per_information8              in     varchar2 default null
  ,p_per_information9              in     varchar2 default null
  ,p_per_information10             in     varchar2 default null
  ,p_per_information11             in     varchar2 default null
  ,p_per_information12             in     varchar2 default null
  ,p_per_information13             in     varchar2 default null
  ,p_per_information14             in     varchar2 default null
  ,p_per_information15             in     varchar2 default null
  ,p_per_information16             in       varchar2 default null
  ,p_per_information17             in       varchar2 default null
  ,p_per_information18             in       varchar2 default null
  ,p_per_information19             in       varchar2 default null
  ,p_per_information20             in       varchar2 default null
  ,p_per_information21             in       varchar2 default null
  ,p_per_information22             in       varchar2 default null
  ,p_per_information23             in       varchar2 default null
  ,p_per_information24             in       varchar2 default null
  ,p_per_information25             in       varchar2 default null
  ,p_per_information26             in       varchar2 default null
  ,p_per_information27             in       varchar2 default null
  ,p_per_information28             in       varchar2 default null
  ,p_per_information29             in       varchar2 default null
  ,p_per_information30             in       varchar2 default null
  ,p_person_id                        out nocopy   number
  ,p_per_object_version_number        out nocopy   number
  ,p_per_effective_start_date         out nocopy   date
  ,p_per_effective_end_date           out nocopy   date
  ,p_pdp_object_version_number        out nocopy   number
  ,p_full_name                        out nocopy   varchar2
  ,p_comment_id                       out nocopy   number
  ,p_assignment_id                    out nocopy   number
  ,p_asg_object_version_number        out nocopy   number
  ,p_assignment_sequence              out nocopy   number
  ,p_assignment_number                out nocopy   varchar2
  ,p_name_combination_warning         out nocopy   boolean
  ) is

  -- Declare cursors and local variables
  --
  l_proc                 varchar2(72);

Line: 148

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

Line: 228

  ,p_resume_last_updated           =>p_resume_last_updated
  ,p_second_passport_exists        =>p_second_passport_exists
  ,p_sex                           =>p_sex
  ,p_student_status                =>p_student_status
  ,p_suffix                        =>p_suffix
  ,p_title                         =>p_title
  ,p_town_of_birth                 =>p_town_of_birth
  ,p_uses_tobacco_flag             =>p_uses_tobacco_flag
  ,p_vendor_id                     =>p_vendor_id
  ,p_work_schedule                 =>p_work_schedule
  ,p_work_telephone                =>p_work_telephone
  ,p_exp_check_send_to_address     =>p_exp_check_send_to_address
  ,p_hold_applicant_date_until     =>p_hold_applicant_date_until
  ,p_date_employee_data_verified   =>p_date_employee_data_verified
  ,p_benefit_group_id              =>p_benefit_group_id
  ,p_coord_ben_med_pln_no          =>p_coord_ben_med_pln_no
  ,p_coord_ben_no_cvg_flag         =>p_coord_ben_no_cvg_flag
  ,p_original_date_of_hire         =>p_original_date_of_hire
  ,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_per_information_category      =>p_per_information_category
  ,p_nip                           =>p_nip_number
  ,p_oldage_pension_rights         =>p_per_information4
  ,p_national_fund_of_health       =>p_per_information5
  ,p_tax_office                    =>p_per_information6
  ,p_legal_employer                =>p_per_information7
  ,p_citizenship                   =>p_per_information8
  ,p_person_id                     =>p_person_id
  ,p_per_object_version_number     =>p_per_object_version_number
  ,p_per_effective_start_date      =>p_per_effective_start_date
  ,p_per_effective_end_date        =>p_per_effective_end_date
  ,p_pdp_object_version_number     =>p_pdp_object_version_number
  ,p_full_name                     =>p_full_name
  ,p_comment_id                    =>p_comment_id
  ,p_assignment_id                 =>p_assignment_id
  ,p_asg_object_version_number     =>p_asg_object_version_number
  ,p_assignment_sequence           =>p_assignment_sequence
  ,p_assignment_number             =>p_assignment_number
  ,p_name_combination_warning      =>p_name_combination_warning
  );

Line: 343

  ,p_resume_last_updated           in     date     default null
  ,p_second_passport_exists        in     varchar2 default null
  ,p_sex                           in     varchar2 default null
  ,p_student_status                in     varchar2 default null
  ,p_suffix                        in     varchar2 default null
  ,p_title                         in     varchar2 default null
  ,p_town_of_birth                 in     varchar2 default null
  ,p_uses_tobacco_flag             in     varchar2 default null
  ,p_vendor_id                     in     number   default null
  ,p_work_schedule                 in     varchar2 default null
  ,p_work_telephone                in     varchar2 default null
  ,p_exp_check_send_to_address     in     varchar2 default null
  ,p_hold_applicant_date_until     in     date     default null
  ,p_date_employee_data_verified   in     date     default null
  ,p_benefit_group_id              in     number   default null
  ,p_coord_ben_med_pln_no          in     varchar2 default null
  ,p_coord_ben_no_cvg_flag         in     varchar2 default null
  ,p_original_date_of_hire         in     date     default null
  ,p_attribute_category            in     varchar2 default null
  ,p_attribute1                    in     varchar2 default null
  ,p_attribute2                    in     varchar2 default null
  ,p_attribute3                    in     varchar2 default null
  ,p_attribute4                    in     varchar2 default null
  ,p_attribute5                    in     varchar2 default null
  ,p_attribute6                    in     varchar2 default null
  ,p_attribute7                    in     varchar2 default null
  ,p_attribute8                    in     varchar2 default null
  ,p_attribute9                    in     varchar2 default null
  ,p_attribute10                   in     varchar2 default null
  ,p_attribute11                   in     varchar2 default null
  ,p_attribute12                   in     varchar2 default null
  ,p_attribute13                   in     varchar2 default null
  ,p_attribute14                   in     varchar2 default null
  ,p_attribute15                   in     varchar2 default null
  ,p_attribute16                   in     varchar2 default null
  ,p_attribute17                   in     varchar2 default null
  ,p_attribute18                   in     varchar2 default null
  ,p_attribute19                   in     varchar2 default null
  ,p_attribute20                   in     varchar2 default null
  ,p_attribute21                   in     varchar2 default null
  ,p_attribute22                   in     varchar2 default null
  ,p_attribute23                   in     varchar2 default null
  ,p_attribute24                   in     varchar2 default null
  ,p_attribute25                   in     varchar2 default null
  ,p_attribute26                   in     varchar2 default null
  ,p_attribute27                   in     varchar2 default null
  ,p_attribute28                   in     varchar2 default null
  ,p_attribute29                   in     varchar2 default null
  ,p_attribute30                   in     varchar2 default null
  ,p_per_information_category      in     varchar2 default null
  ,p_nip                           in     varchar2 default null
  ,p_oldage_pension_rights         in     varchar2 default null
  ,p_national_fund_of_health       in     varchar2 default null
  ,p_tax_office                    in     varchar2 default null
  ,p_legal_employer                in     varchar2 default null
  ,p_citizenship                   in     varchar2 default null
  ,p_person_id                        out nocopy   number
  ,p_per_object_version_number        out nocopy   number
  ,p_per_effective_start_date         out nocopy   date
  ,p_per_effective_end_date           out nocopy   date
  ,p_pdp_object_version_number        out nocopy   number
  ,p_full_name                        out nocopy   varchar2
  ,p_comment_id                       out nocopy   number
  ,p_assignment_id                    out nocopy   number
  ,p_asg_object_version_number        out nocopy   number
  ,p_assignment_sequence              out nocopy   number
  ,p_assignment_number                out nocopy   varchar2
  ,p_name_combination_warning         out nocopy   boolean
  ) is
  l_proc                 varchar2(72);

Line: 416

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

Line: 493

  ,p_resume_last_updated          => p_resume_last_updated
  ,p_second_passport_exists       => p_second_passport_exists
  ,p_sex                          => p_sex
  ,p_student_status               => p_student_status
  ,p_suffix                       => p_suffix
  ,p_title                        => p_title
  ,p_town_of_birth                => p_town_of_birth
  ,p_uses_tobacco_flag            => p_uses_tobacco_flag
  ,p_vendor_id                    => p_vendor_id
  ,p_work_schedule                => p_work_schedule
  ,p_work_telephone               => p_work_telephone
  ,p_exp_check_send_to_address    => p_exp_check_send_to_address
  ,p_hold_applicant_date_until    => p_hold_applicant_date_until
  ,p_date_employee_data_verified  => p_date_employee_data_verified
  ,p_benefit_group_id             => p_benefit_group_id
  ,p_coord_ben_med_pln_no         => p_coord_ben_med_pln_no
  ,p_coord_ben_no_cvg_flag        => p_coord_ben_no_cvg_flag
  ,p_original_date_of_hire        => p_original_date_of_hire
  ,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_per_information_category     => 'PL'
  ,p_per_information1             => p_nip
  ,p_per_information4             => p_oldage_pension_rights
  ,p_per_information5             => p_national_fund_of_health
  ,p_per_information6             => p_tax_office
  ,p_per_information7             => p_legal_employer
  ,p_per_information8             => p_citizenship
  ,p_person_id                    =>p_person_id
  ,p_per_object_version_number    => p_per_object_version_number
  ,p_per_effective_start_date     => p_per_effective_start_date
  ,p_per_effective_end_date       => p_per_effective_end_date
  ,p_pdp_object_version_number    => p_pdp_object_version_number
  ,p_full_name                    => p_full_name
  ,p_comment_id                   => p_comment_id
  ,p_assignment_id                => p_assignment_id
  ,p_asg_object_version_number    => p_asg_object_version_number
  ,p_assignment_sequence          => p_assignment_sequence
  ,p_assignment_number            => p_assignment_number
  ,p_name_combination_warning     => p_name_combination_warning
  );