eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JPBP_API SQL Statements

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

Line: 24


    select * from per_jp_school_lookups
      where school_id = p_school_id;

Line: 28


    select * from per_jp_school_lookups
      where school_name = p_school_name
        and nvl(major,hr_api.g_varchar2)= nvl(p_major,hr_api.g_varchar2);

Line: 199


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

Line: 392


  ,p_resume_last_updated           in     date     default null
  ,p_second_passport_exists        in     varchar2 default null
  ,p_student_status                in     varchar2 default null
  ,p_work_schedule                 in     varchar2 default null
  ,p_original_date_of_hire         in     date     default null
  ,p_person_id                     out nocopy    number
  ,p_assignment_id                 out nocopy    number
  ,p_per_object_version_number     out nocopy    number
  ,p_asg_object_version_number     out nocopy    number
  ,p_per_effective_start_date      out nocopy    date
  ,p_per_effective_end_date        out nocopy    date
  ,p_full_name                     out nocopy    varchar2
  ,p_per_comment_id                out nocopy    number
  ,p_assignment_sequence           out nocopy    number
  ,p_assignment_number             out nocopy    varchar2
  ,p_name_combination_warning      out nocopy    boolean
  ,p_assign_payroll_warning        out nocopy    boolean
  ,p_orig_hire_warning             out nocopy    boolean
  --
  -- for special information
  --
  ,p_id_flex_num                   in     number
  ,p_pea_comments                  in     varchar2 default null
  ,p_date_from                     in     date     default null
  ,p_date_to                       in     date     default null
  ,p_pea_attribute_category        in     varchar2 default null
  ,p_pea_attribute1                in     varchar2 default null
  ,p_pea_attribute2                in     varchar2 default null
  ,p_pea_attribute3                in     varchar2 default null
  ,p_pea_attribute4                in     varchar2 default null
  ,p_pea_attribute5                in     varchar2 default null
  ,p_pea_attribute6                in     varchar2 default null
  ,p_pea_attribute7                in     varchar2 default null
  ,p_pea_attribute8                in     varchar2 default null
  ,p_pea_attribute9                in     varchar2 default null
  ,p_pea_attribute10               in     varchar2 default null
  ,p_pea_attribute11               in     varchar2 default null
  ,p_pea_attribute12               in     varchar2 default null
  ,p_pea_attribute13               in     varchar2 default null
  ,p_pea_attribute14               in     varchar2 default null
  ,p_pea_attribute15               in     varchar2 default null
  ,p_pea_attribute16               in     varchar2 default null
  ,p_pea_attribute17               in     varchar2 default null
  ,p_pea_attribute18               in     varchar2 default null
  ,p_pea_attribute19               in     varchar2 default null
  ,p_pea_attribute20               in     varchar2 default null
  ,p_segment1                      in     varchar2 default null
  ,p_segment2                      in     varchar2 default null
  ,p_segment3                      in     varchar2 default null
  ,p_segment4                      in     varchar2 default null
  ,p_segment5                      in     varchar2 default null
  ,p_segment6                      in     varchar2 default null
  ,p_segment7                      in     varchar2 default null
  ,p_segment8                      in     varchar2 default null
  ,p_segment9                      in     varchar2 default null
  ,p_segment10                     in     varchar2 default null
  ,p_segment11                     in     varchar2 default null
  ,p_segment12                     in     varchar2 default null
  ,p_segment13                     in     varchar2 default null
  ,p_segment14                     in     varchar2 default null
  ,p_segment15                     in     varchar2 default null
  ,p_segment16                     in     varchar2 default null
  ,p_segment17                     in     varchar2 default null
  ,p_segment18                     in     varchar2 default null
  ,p_segment19                     in     varchar2 default null
  ,p_segment20                     in     varchar2 default null
  ,p_segment21                     in     varchar2 default null
  ,p_segment22                     in     varchar2 default null
  ,p_segment23                     in     varchar2 default null
  ,p_segment24                     in     varchar2 default null
  ,p_segment25                     in     varchar2 default null
  ,p_segment26                     in     varchar2 default null
  ,p_segment27                     in     varchar2 default null
  ,p_segment28                     in     varchar2 default null
  ,p_segment29                     in     varchar2 default null
  ,p_segment30                     in     varchar2 default null
  ,p_pea_object_version_number     out nocopy    number
  ,p_analysis_criteria_id          out nocopy    number
  ,p_person_analysis_id            out nocopy    number

/* Additional parameters for Bug:4161160 */

  ,p_english_last_name		   in    varchar2 default null
  ,p_english_first_name		   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
  ) is
  --
  -- Declare cursors and local variables
  --
  l_person_id         number;

Line: 494


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

Line: 625


  ,p_resume_last_updated          => p_resume_last_updated
  ,p_second_passport_exists       => p_second_passport_exists
  ,p_student_status               => p_student_status
  ,p_work_schedule                => p_work_schedule
  ,p_original_date_of_hire        => p_original_date_of_hire
  ,p_person_id                    => l_person_id
  ,p_assignment_id                => p_assignment_id
  ,p_per_object_version_number    => p_per_object_version_number
  ,p_asg_object_version_number    => p_asg_object_version_number
  ,p_per_effective_start_date     => p_per_effective_start_date
  ,p_per_effective_end_date       => p_per_effective_end_date
  ,p_full_name                    => p_full_name
  ,p_per_comment_id               => p_per_comment_id
  ,p_assignment_sequence          => p_assignment_sequence
  ,p_assignment_number            => p_assignment_number
  ,p_name_combination_warning     => p_name_combination_warning
  ,p_assign_payroll_warning       => p_assign_payroll_warning
  ,p_orig_hire_warning            => p_orig_hire_warning

/* Additional parameters for Bug:4161160 */

  ,p_per_information21		  => p_english_last_name
  ,p_per_information22		  => p_english_first_name
  ,p_per_information23		  => p_per_information23
  ,p_per_information24	          => p_per_information24
  ,p_per_information25	          => p_per_information25
  ,p_per_information26	          => p_per_information26
  ,p_per_information27	          => p_per_information27
  ,p_per_information28	          => p_per_information28
  ,p_per_information29	          => p_per_information29
  ,p_per_information30	          => p_per_information30
 );

Line: 933


  ,p_resume_last_updated           in     date     default null
  ,p_second_passport_exists        in     varchar2 default null
  ,p_student_status                in     varchar2 default null
  ,p_work_schedule                 in     varchar2 default null
  ,p_original_date_of_hire         in     date     default null
  ,p_person_id                     out nocopy    number
  ,p_assignment_id                 out nocopy    number
  ,p_per_object_version_number     out nocopy    number
  ,p_asg_object_version_number     out nocopy    number
  ,p_per_effective_start_date      out nocopy    date
  ,p_per_effective_end_date        out nocopy    date
  ,p_full_name                     out nocopy    varchar2
  ,p_per_comment_id                out nocopy    number
  ,p_assignment_sequence           out nocopy    number
  ,p_assignment_number             out nocopy    varchar2
  ,p_name_combination_warning      out nocopy    boolean
  ,p_assign_payroll_warning        out nocopy    boolean
  ,p_orig_hire_warning             out nocopy    boolean
  --
  -- for special information
  --
  ,p_pea_comments                  in     varchar2 default null
  ,p_pea_date_from                 in     date     default null
  ,p_pea_date_to                   in     date     default null
  ,p_pea_attribute_category        in     varchar2 default null
  ,p_pea_attribute1                in     varchar2 default null
  ,p_pea_attribute2                in     varchar2 default null
  ,p_pea_attribute3                in     varchar2 default null
  ,p_pea_attribute4                in     varchar2 default null
  ,p_pea_attribute5                in     varchar2 default null
  ,p_pea_attribute6                in     varchar2 default null
  ,p_pea_attribute7                in     varchar2 default null
  ,p_pea_attribute8                in     varchar2 default null
  ,p_pea_attribute9                in     varchar2 default null
  ,p_pea_attribute10               in     varchar2 default null
  ,p_pea_attribute11               in     varchar2 default null
  ,p_pea_attribute12               in     varchar2 default null
  ,p_pea_attribute13               in     varchar2 default null
  ,p_pea_attribute14               in     varchar2 default null
  ,p_pea_attribute15               in     varchar2 default null
  ,p_pea_attribute16               in     varchar2 default null
  ,p_pea_attribute17               in     varchar2 default null
  ,p_pea_attribute18               in     varchar2 default null
  ,p_pea_attribute19               in     varchar2 default null
  ,p_pea_attribute20               in     varchar2 default null
  ,p_school_type                   in     varchar2 default null
  ,p_school_id                     in     varchar2 default null
  ,p_school_name                   in     varchar2 default null
  ,p_school_name_kana              in     varchar2 default null
  ,p_major                         in     varchar2 default null
  ,p_major_kana                    in     varchar2 default null
  ,p_advisor                       in     varchar2 default null
  ,p_graduation_date               in     varchar2 default null
  ,p_note                          in     varchar2 default null
  ,p_last_flag                     in     varchar2 default null
--  ,p_school_flag                   in     varchar2 default null
  ,p_pea_object_version_number     out nocopy    number
  ,p_analysis_criteria_id          out nocopy    number
  ,p_person_analysis_id            out nocopy    number
  --
  -- for per_addresses
  --
--  ,p_primary_flag                  in     varchar2
  ,p_add_date_from                 in     date     default null
  ,p_add_date_to                   in     date     default null
  ,p_address_type                  in     varchar2 default null
  ,p_add_comments                  in     varchar2 default null
  ,p_address_line1                 in     varchar2 default null
  ,p_address_line2                 in     varchar2 default null
  ,p_address_line3                 in     varchar2 default null
  ,p_district_code                 in     varchar2 default null
  ,p_address_line1_kana            in     varchar2 default null
  ,p_address_line2_kana            in     varchar2 default null
  ,p_address_line3_kana            in     varchar2 default null
  ,p_postcode                      in     varchar2 default null
  ,p_country                       in     varchar2 default null
  ,p_telephone_number_1            in     varchar2 default null
  ,p_telephone_number_2            in     varchar2 default null
  ,p_fax_number                    in     varchar2 default null
  ,p_addr_attribute_category       in     varchar2 default null
  ,p_addr_attribute1               in     varchar2 default null
  ,p_addr_attribute2               in     varchar2 default null
  ,p_addr_attribute3               in     varchar2 default null
  ,p_addr_attribute4               in     varchar2 default null
  ,p_addr_attribute5               in     varchar2 default null
  ,p_addr_attribute6               in     varchar2 default null
  ,p_addr_attribute7               in     varchar2 default null
  ,p_addr_attribute8               in     varchar2 default null
  ,p_addr_attribute9               in     varchar2 default null
  ,p_addr_attribute10              in     varchar2 default null
  ,p_addr_attribute11              in     varchar2 default null
  ,p_addr_attribute12              in     varchar2 default null
  ,p_addr_attribute13              in     varchar2 default null
  ,p_addr_attribute14              in     varchar2 default null
  ,p_addr_attribute15              in     varchar2 default null
  ,p_addr_attribute16              in     varchar2 default null
  ,p_addr_attribute17              in     varchar2 default null
  ,p_addr_attribute18              in     varchar2 default null
  ,p_addr_attribute19              in     varchar2 default null
  ,p_addr_attribute20              in     varchar2 default null
  ,p_address_id                    out nocopy number
  ,p_add_object_version_number     out nocopy number

/* Additional parameters for Bug:4161160 */

  ,p_english_last_name		   in    varchar2 default null
  ,p_english_first_name		   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
 ) is
  --
  l_person_id        number;

Line: 1058


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

Line: 1182


     ,p_resume_last_updated          => p_resume_last_updated
     ,p_second_passport_exists       => p_second_passport_exists
     ,p_student_status               => p_student_status
     ,p_work_schedule                => p_work_schedule
     ,p_original_date_of_hire        => p_original_date_of_hire
     ,p_person_id                    => l_person_id
     ,p_assignment_id                => p_assignment_id
     ,p_per_object_version_number    => p_per_object_version_number
     ,p_asg_object_version_number    => p_asg_object_version_number
     ,p_per_effective_start_date     => p_per_effective_start_date
     ,p_per_effective_end_date       => p_per_effective_end_date
     ,p_full_name                    => p_full_name
     ,p_per_comment_id               => p_per_comment_id
     ,p_assignment_sequence          => p_assignment_sequence
     ,p_assignment_number            => p_assignment_number
     ,p_name_combination_warning     => p_name_combination_warning
     ,p_assign_payroll_warning       => p_assign_payroll_warning
     ,p_orig_hire_warning            => p_orig_hire_warning

/* Additional parameters for Bug:4161160 */

  ,p_per_information21		  => p_english_last_name
  ,p_per_information22		  => p_english_first_name
  ,p_per_information23		  => p_per_information23
  ,p_per_information24	          => p_per_information24
  ,p_per_information25	          => p_per_information25
  ,p_per_information26	          => p_per_information26
  ,p_per_information27	          => p_per_information27
  ,p_per_information28	          => p_per_information28
  ,p_per_information29	          => p_per_information29
  ,p_per_information30	          => p_per_information30
 );

Line: 1568


  ,p_resume_last_updated           in     date     default null
  ,p_student_status                in     varchar2 default null
  ,p_work_schedule                 in     varchar2 default null
  ,p_date_of_death                 in     date     default null
  ,p_original_date_of_hire         in     date     default null
  ,p_person_id                     out nocopy    number
  ,p_assignment_id                 out nocopy    number
  ,p_application_id                out nocopy    number
  ,p_per_object_version_number     out nocopy    number
  ,p_asg_object_version_number     out nocopy    number
  ,p_apl_object_version_number     out nocopy    number
  ,p_per_effective_start_date      out nocopy    date
  ,p_per_effective_end_date        out nocopy    date
  ,p_full_name                     out nocopy    varchar2
  ,p_per_comment_id                out nocopy    number
  ,p_assignment_sequence           out nocopy    number
  ,p_name_combination_warning      out nocopy    boolean
  ,p_orig_hire_warning             out nocopy    boolean

  /* for special information */

  ,p_id_flex_num                   in     number
  ,p_pea_comments                  in     varchar2 default null
  ,p_date_from                     in     date     default null
  ,p_date_to                       in     date     default null
  ,p_pea_attribute_category        in     varchar2 default null
  ,p_pea_attribute1                in     varchar2 default null
  ,p_pea_attribute2                in     varchar2 default null
  ,p_pea_attribute3                in     varchar2 default null
  ,p_pea_attribute4                in     varchar2 default null
  ,p_pea_attribute5                in     varchar2 default null
  ,p_pea_attribute6                in     varchar2 default null
  ,p_pea_attribute7                in     varchar2 default null
  ,p_pea_attribute8                in     varchar2 default null
  ,p_pea_attribute9                in     varchar2 default null
  ,p_pea_attribute10               in     varchar2 default null
  ,p_pea_attribute11               in     varchar2 default null
  ,p_pea_attribute12               in     varchar2 default null
  ,p_pea_attribute13               in     varchar2 default null
  ,p_pea_attribute14               in     varchar2 default null
  ,p_pea_attribute15               in     varchar2 default null
  ,p_pea_attribute16               in     varchar2 default null
  ,p_pea_attribute17               in     varchar2 default null
  ,p_pea_attribute18               in     varchar2 default null
  ,p_pea_attribute19               in     varchar2 default null
  ,p_pea_attribute20               in     varchar2 default null
  ,p_segment1                      in     varchar2 default null
  ,p_segment2                      in     varchar2 default null
  ,p_segment3                      in     varchar2 default null
  ,p_segment4                      in     varchar2 default null
  ,p_segment5                      in     varchar2 default null
  ,p_segment6                      in     varchar2 default null
  ,p_segment7                      in     varchar2 default null
  ,p_segment8                      in     varchar2 default null
  ,p_segment9                      in     varchar2 default null
  ,p_segment10                     in     varchar2 default null
  ,p_segment11                     in     varchar2 default null
  ,p_segment12                     in     varchar2 default null
  ,p_segment13                     in     varchar2 default null
  ,p_segment14                     in     varchar2 default null
  ,p_segment15                     in     varchar2 default null
  ,p_segment16                     in     varchar2 default null
  ,p_segment17                     in     varchar2 default null
  ,p_segment18                     in     varchar2 default null
  ,p_segment19                     in     varchar2 default null
  ,p_segment20                     in     varchar2 default null
  ,p_segment21                     in     varchar2 default null
  ,p_segment22                     in     varchar2 default null
  ,p_segment23                     in     varchar2 default null
  ,p_segment24                     in     varchar2 default null
  ,p_segment25                     in     varchar2 default null
  ,p_segment26                     in     varchar2 default null
  ,p_segment27                     in     varchar2 default null
  ,p_segment28                     in     varchar2 default null
  ,p_segment29                     in     varchar2 default null
  ,p_segment30                     in     varchar2 default null
  ,p_pea_object_version_number     out nocopy    number
  ,p_analysis_criteria_id          out nocopy    number
  ,p_person_analysis_id            out nocopy    number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                       varchar2(72) := g_package||'create_jp_applicant_with_sit';

Line: 1659


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

Line: 1782


  ,p_resume_last_updated          => p_resume_last_updated
  ,p_student_status               => p_student_status
  ,p_work_schedule                => p_work_schedule
  ,p_date_of_death                => p_date_of_death
  ,p_original_date_of_hire        => p_original_date_of_hire
  ,p_person_id                    => l_person_id
  ,p_assignment_id                => p_assignment_id
  ,p_application_id               => p_application_id
  ,p_per_object_version_number    => p_per_object_version_number
  ,p_asg_object_version_number    => p_asg_object_version_number
  ,p_apl_object_version_number    => p_apl_object_version_number
  ,p_per_effective_start_date     => p_per_effective_start_date
  ,p_per_effective_end_date       => p_per_effective_end_date
  ,p_full_name                    => p_full_name
  ,p_per_comment_id               => p_per_comment_id
  ,p_assignment_sequence          => p_assignment_sequence
  ,p_name_combination_warning     => p_name_combination_warning
  ,p_orig_hire_warning            => p_orig_hire_warning
  );

Line: 2074


  ,p_resume_last_updated           in     date     default null
  ,p_student_status                in     varchar2 default null
  ,p_work_schedule                 in     varchar2 default null
  ,p_date_of_death                 in     date     default null
  ,p_original_date_of_hire         in     date     default null
  ,p_person_id                     out nocopy    number
  ,p_assignment_id                 out nocopy    number
  ,p_application_id                out nocopy    number
  ,p_per_object_version_number     out nocopy    number
  ,p_asg_object_version_number     out nocopy    number
  ,p_apl_object_version_number     out nocopy    number
  ,p_per_effective_start_date      out nocopy    date
  ,p_per_effective_end_date        out nocopy    date
  ,p_full_name                     out nocopy    varchar2
  ,p_per_comment_id                out nocopy    number
  ,p_assignment_sequence           out nocopy    number
  ,p_name_combination_warning      out nocopy    boolean
  ,p_orig_hire_warning             out nocopy    boolean
  --
  -- for special information
  --
  ,p_pea_comments                  in     varchar2 default null
  ,p_pea_date_from                 in     date     default null
  ,p_pea_date_to                   in     date     default null
  ,p_pea_attribute_category        in     varchar2 default null
  ,p_pea_attribute1                in     varchar2 default null
  ,p_pea_attribute2                in     varchar2 default null
  ,p_pea_attribute3                in     varchar2 default null
  ,p_pea_attribute4                in     varchar2 default null
  ,p_pea_attribute5                in     varchar2 default null
  ,p_pea_attribute6                in     varchar2 default null
  ,p_pea_attribute7                in     varchar2 default null
  ,p_pea_attribute8                in     varchar2 default null
  ,p_pea_attribute9                in     varchar2 default null
  ,p_pea_attribute10               in     varchar2 default null
  ,p_pea_attribute11               in     varchar2 default null
  ,p_pea_attribute12               in     varchar2 default null
  ,p_pea_attribute13               in     varchar2 default null
  ,p_pea_attribute14               in     varchar2 default null
  ,p_pea_attribute15               in     varchar2 default null
  ,p_pea_attribute16               in     varchar2 default null
  ,p_pea_attribute17               in     varchar2 default null
  ,p_pea_attribute18               in     varchar2 default null
  ,p_pea_attribute19               in     varchar2 default null
  ,p_pea_attribute20               in     varchar2 default null
  ,p_school_type                   in     varchar2 default null
  ,p_school_id                     in     varchar2 default null
  ,p_school_name                   in     varchar2 default null
  ,p_school_name_kana              in     varchar2 default null
  ,p_major                         in     varchar2 default null
  ,p_major_kana                    in     varchar2 default null
  ,p_advisor                       in     varchar2 default null
  ,p_graduation_date               in     varchar2 default null
  ,p_note                          in     varchar2 default null
  ,p_last_flag                     in     varchar2 default null
--  ,p_school_flag                   in     varchar2 default null
  ,p_pea_object_version_number     out nocopy    number
  ,p_analysis_criteria_id          out nocopy    number
  ,p_person_analysis_id            out nocopy    number
  --
  -- for per_addresses
  --
--  ,p_primary_flag                  in     varchar2
  ,p_add_date_from                 in     date     default null
  ,p_add_date_to                   in     date     default null
  ,p_address_type                  in     varchar2 default null
  ,p_add_comments                  in     varchar2 default null
  ,p_address_line1                 in     varchar2 default null
  ,p_address_line2                 in     varchar2 default null
  ,p_address_line3                 in     varchar2 default null
  ,p_district_code                 in     varchar2 default null
  ,p_address_line1_kana            in     varchar2 default null
  ,p_address_line2_kana            in     varchar2 default null
  ,p_address_line3_kana            in     varchar2 default null
  ,p_postcode                      in     varchar2 default null
  ,p_country                       in     varchar2 default null
  ,p_telephone_number_1            in     varchar2 default null
  ,p_telephone_number_2            in     varchar2 default null
  ,p_fax_number                    in     varchar2 default null
  ,p_addr_attribute_category       in     varchar2 default null
  ,p_addr_attribute1               in     varchar2 default null
  ,p_addr_attribute2               in     varchar2 default null
  ,p_addr_attribute3               in     varchar2 default null
  ,p_addr_attribute4               in     varchar2 default null
  ,p_addr_attribute5               in     varchar2 default null
  ,p_addr_attribute6               in     varchar2 default null
  ,p_addr_attribute7               in     varchar2 default null
  ,p_addr_attribute8               in     varchar2 default null
  ,p_addr_attribute9               in     varchar2 default null
  ,p_addr_attribute10              in     varchar2 default null
  ,p_addr_attribute11              in     varchar2 default null
  ,p_addr_attribute12              in     varchar2 default null
  ,p_addr_attribute13              in     varchar2 default null
  ,p_addr_attribute14              in     varchar2 default null
  ,p_addr_attribute15              in     varchar2 default null
  ,p_addr_attribute16              in     varchar2 default null
  ,p_addr_attribute17              in     varchar2 default null
  ,p_addr_attribute18              in     varchar2 default null
  ,p_addr_attribute19              in     varchar2 default null
  ,p_addr_attribute20              in     varchar2 default null
  ,p_address_id                    out nocopy number
  ,p_add_object_version_number     out nocopy number
  )is
  --
  l_person_id         number;

Line: 2186


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

Line: 2309


     ,p_resume_last_updated          => p_resume_last_updated
     ,p_student_status               => p_student_status
     ,p_work_schedule                => p_work_schedule
     ,p_date_of_death                => p_date_of_death
     ,p_original_date_of_hire        => p_original_date_of_hire
     ,p_person_id                    => l_person_id
     ,p_assignment_id                => p_assignment_id
     ,p_application_id               => p_application_id
     ,p_per_object_version_number    => p_per_object_version_number
     ,p_asg_object_version_number    => p_asg_object_version_number
     ,p_apl_object_version_number    => p_apl_object_version_number
     ,p_per_effective_start_date     => p_per_effective_start_date
     ,p_per_effective_end_date       => p_per_effective_end_date
     ,p_full_name                    => p_full_name
     ,p_per_comment_id               => p_per_comment_id
     ,p_assignment_sequence          => p_assignment_sequence
     ,p_name_combination_warning     => p_name_combination_warning
     ,p_orig_hire_warning            => p_orig_hire_warning
    );