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_HK_EMPLOYEE_API SQL Statements

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

Line: 126


  ,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_suffix                         IN      VARCHAR2 DEFAULT NULL
  ,p_benefit_group_id               IN      NUMBER   DEFAULT NULL
  ,p_receipt_of_death_cert_date     IN      DATE     DEFAULT NULL
  ,p_coord_ben_med_pln_no           IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_no_cvg_flag          IN      VARCHAR2 DEFAULT 'N'
  ,p_coord_ben_med_ext_er           IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_med_pl_name          IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_med_insr_crr_name    IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_med_insr_crr_ident   IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_med_cvg_strt_dt      IN      DATE     DEFAULT NULL
  ,p_coord_ben_med_cvg_end_dt       IN      DATE     DEFAULT NULL
  ,p_uses_tobacco_flag              IN      VARCHAR2 DEFAULT NULL
  ,p_dpdnt_adoption_date            IN      DATE     DEFAULT NULL
  ,p_dpdnt_vlntry_svce_flag         IN      VARCHAR2 DEFAULT 'N'
  ,p_original_date_of_hire          IN      DATE     DEFAULT NULL
  ,p_adjusted_svc_date              IN      DATE     DEFAULT NULL
  ,p_town_of_birth                  IN      VARCHAR2 DEFAULT NULL
  ,p_region_of_birth                IN      VARCHAR2 DEFAULT NULL
  ,p_country_of_birth               IN      VARCHAR2 DEFAULT NULL
  ,p_global_person_id               IN      VARCHAR2 DEFAULT NULL
  ,p_party_id                       IN      NUMBER   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
  )
IS

   -- Declare cursors and local variables
    --
    l_proc                 VARCHAR2(72) := g_package||'create_hk_employee';

Line: 175


      SELECT    legislation_code
      FROM      per_business_groups pbg
      WHERE     pbg.business_group_id = p_business_group_id;

Line: 291


      ,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_suffix                       => p_suffix
      ,p_benefit_group_id             => p_benefit_group_id
      ,p_receipt_of_death_cert_date   => p_receipt_of_death_cert_date
      ,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_coord_ben_med_ext_er         => p_coord_ben_med_ext_er
      ,p_coord_ben_med_pl_name        => p_coord_ben_med_pl_name
      ,p_coord_ben_med_insr_crr_name  => p_coord_ben_med_insr_crr_name
      ,p_coord_ben_med_insr_crr_ident => p_coord_ben_med_insr_crr_ident
      ,p_coord_ben_med_cvg_strt_dt    => p_coord_ben_med_cvg_strt_dt
      ,p_coord_ben_med_cvg_end_dt     => p_coord_ben_med_cvg_end_dt
      ,p_uses_tobacco_flag            => p_uses_tobacco_flag
      ,p_dpdnt_adoption_date          => p_dpdnt_adoption_date
      ,p_dpdnt_vlntry_svce_flag       => p_dpdnt_vlntry_svce_flag
      ,p_original_date_of_hire        => p_original_date_of_hire
      ,p_adjusted_svc_date            => p_adjusted_svc_date
      --
      ,p_town_of_birth                => p_town_of_birth
      ,p_region_of_birth              => p_region_of_birth
      ,p_country_of_birth             => p_country_of_birth
      ,p_global_person_id             => p_global_person_id
      ,p_party_id                     => p_party_id
      --
      ,p_person_id                    => p_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
    );

Line: 419


  ,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_suffix                         IN      VARCHAR2 DEFAULT NULL
  ,p_benefit_group_id               IN      NUMBER   DEFAULT NULL
  ,p_receipt_of_death_cert_date     IN      DATE     DEFAULT NULL
  ,p_coord_ben_med_pln_no           IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_no_cvg_flag          IN      VARCHAR2 DEFAULT 'N'
  ,p_coord_ben_med_ext_er           IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_med_pl_name          IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_med_insr_crr_name    IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_med_insr_crr_ident   IN      VARCHAR2 DEFAULT NULL
  ,p_coord_ben_med_cvg_strt_dt      IN      DATE     DEFAULT NULL
  ,p_coord_ben_med_cvg_end_dt       IN      DATE     DEFAULT NULL
  ,p_uses_tobacco_flag              IN      VARCHAR2 DEFAULT NULL
  ,p_dpdnt_adoption_date            IN      DATE     DEFAULT NULL
  ,p_dpdnt_vlntry_svce_flag         IN      VARCHAR2 DEFAULT 'N'
  ,p_original_date_of_hire          IN      DATE     DEFAULT NULL
  ,p_adjusted_svc_date              IN      DATE     DEFAULT NULL
  ,p_town_of_birth                  IN      VARCHAR2 DEFAULT NULL
  ,p_region_of_birth                IN      VARCHAR2 DEFAULT NULL
  ,p_country_of_birth               IN      VARCHAR2 DEFAULT NULL
  ,p_global_person_id               IN      VARCHAR2 DEFAULT NULL
  ,p_party_id                       IN      NUMBER   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
  )
IS

   -- Declare cursors and local variables
    --
    l_proc                 VARCHAR2(72) := g_package||'create_hk_employee';

Line: 551


      ,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_suffix                       => p_suffix
      ,p_benefit_group_id             => p_benefit_group_id
      ,p_receipt_of_death_cert_date   => p_receipt_of_death_cert_date
      ,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_coord_ben_med_ext_er         => p_coord_ben_med_ext_er
      ,p_coord_ben_med_pl_name        => p_coord_ben_med_pl_name
      ,p_coord_ben_med_insr_crr_name  => p_coord_ben_med_insr_crr_name
      ,p_coord_ben_med_insr_crr_ident => p_coord_ben_med_insr_crr_ident
      ,p_coord_ben_med_cvg_strt_dt    => p_coord_ben_med_cvg_strt_dt
      ,p_coord_ben_med_cvg_end_dt     => p_coord_ben_med_cvg_end_dt
      ,p_uses_tobacco_flag            => p_uses_tobacco_flag
      ,p_dpdnt_adoption_date          => p_dpdnt_adoption_date
      ,p_dpdnt_vlntry_svce_flag       => p_dpdnt_vlntry_svce_flag
      ,p_original_date_of_hire        => p_original_date_of_hire
      ,p_adjusted_svc_date            => p_adjusted_svc_date
      --
      ,p_town_of_birth                => p_town_of_birth
      ,p_region_of_birth              => p_region_of_birth
      ,p_country_of_birth             => p_country_of_birth
      ,p_global_person_id             => p_global_person_id
      ,p_party_id                     => p_party_id
      --
      ,p_person_id                    => p_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            => l_orig_hire_warning
    );