[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SQLstmt:=' SELECT rowid
FROM igs_pe_visit_histry
WHERE port_of_entry = :1
AND cntry_entry_form_num = :2';
,p_resume_last_updated IN Date
,p_second_passport_exists IN Varchar2
,p_student_status IN Varchar2
,p_work_schedule IN Varchar2
,p_benefit_group_id IN Number
,p_receipt_of_death_cert_date IN Date
,p_coord_ben_med_pln_no IN Varchar2
,p_coord_ben_no_cvg_flag IN Varchar2
,p_coord_ben_med_ext_er IN Varchar2
,p_coord_ben_med_pl_name IN Varchar2
,p_coord_ben_med_insr_crr_name IN Varchar2
,p_coord_ben_med_insr_crr_ident IN Varchar2
,p_coord_ben_med_cvg_strt_dt IN Date
,p_coord_ben_med_cvg_end_dt IN Date
,p_uses_tobacco_flag IN Varchar2
,p_dpdnt_adoption_date IN Date
,p_dpdnt_vlntry_svce_flag IN Varchar2
,p_original_date_of_hire IN Date
,p_adjusted_svc_date IN Date
,p_town_of_birth IN Varchar2
,p_region_of_birth IN Varchar2
,p_country_of_birth IN Varchar2
,p_global_person_id IN Varchar2
-- Person DF
,p_per_attribute_category IN Varchar2
,p_per_attribute1 IN Varchar2
,p_per_attribute2 IN Varchar2
,p_per_attribute3 IN Varchar2
,p_per_attribute4 IN Varchar2
,p_per_attribute5 IN Varchar2
,p_per_attribute6 IN Varchar2
,p_per_attribute7 IN Varchar2
,p_per_attribute8 IN Varchar2
,p_per_attribute9 IN Varchar2
,p_per_attribute10 IN Varchar2
,p_per_attribute11 IN Varchar2
,p_per_attribute12 IN Varchar2
,p_per_attribute13 IN Varchar2
,p_per_attribute14 IN Varchar2
,p_per_attribute15 IN Varchar2
,p_per_attribute16 IN Varchar2
,p_per_attribute17 IN Varchar2
,p_per_attribute18 IN Varchar2
,p_per_attribute19 IN Varchar2
,p_per_attribute20 IN Varchar2
,p_per_attribute21 IN Varchar2
,p_per_attribute22 IN Varchar2
,p_per_attribute23 IN Varchar2
,p_per_attribute24 IN Varchar2
,p_per_attribute25 IN Varchar2
,p_per_attribute26 IN Varchar2
,p_per_attribute27 IN Varchar2
,p_per_attribute28 IN Varchar2
,p_per_attribute29 IN Varchar2
,p_per_attribute30 IN Varchar2
-- Person DDF
,p_per_information_category IN Varchar2
,p_per_information1 IN Varchar2
,p_per_information2 IN Varchar2
,p_per_information3 IN Varchar2
,p_per_information4 IN Varchar2
,p_per_information5 IN Varchar2
,p_per_information6 IN Varchar2
,p_per_information7 IN Varchar2
,p_per_information8 IN Varchar2
,p_per_information9 IN Varchar2
,p_per_information10 IN Varchar2
,p_per_information11 IN Varchar2
,p_per_information12 IN Varchar2
,p_per_information13 IN Varchar2
,p_per_information14 IN Varchar2
,p_per_information15 IN Varchar2
,p_per_information16 IN Varchar2
,p_per_information17 IN Varchar2
,p_per_information18 IN Varchar2
,p_per_information19 IN Varchar2
,p_per_information20 IN Varchar2
,p_per_information21 IN Varchar2
,p_per_information22 IN Varchar2
,p_per_information23 IN Varchar2
,p_per_information24 IN Varchar2
,p_per_information25 IN Varchar2
,p_per_information26 IN Varchar2
,p_per_information27 IN Varchar2
,p_per_information28 IN Varchar2
,p_per_information29 IN Varchar2
,p_per_information30 IN Varchar2
-- Primary Address: Per_Addresses
,p_pradd_ovlapval_override IN Varchar2
,p_address_type IN Varchar2
,p_adr_comments IN Varchar2
,p_primary_flag IN Varchar2
,p_address_style IN Varchar2
,p_address_line1 IN Varchar2
,p_address_line2 IN Varchar2
,p_address_line3 IN Varchar2
,p_region1 IN Varchar2
,p_region2 IN Varchar2
,p_region3 IN Varchar2
,p_town_or_city IN Varchar2
,p_country IN Varchar2
,p_postal_code IN Varchar2
,p_telephone_no1 IN Varchar2
,p_telephone_no2 IN Varchar2
,p_telephone_no3 IN Varchar2
,p_address_date_from IN Date
,p_address_date_to IN Date
,p_adr_attribute_category IN Varchar2
,p_adr_attribute1 IN Varchar2
,p_adr_attribute2 IN Varchar2
,p_adr_attribute3 IN Varchar2
,p_adr_attribute4 IN Varchar2
,p_adr_attribute5 IN Varchar2
,p_adr_attribute6 IN Varchar2
,p_adr_attribute7 IN Varchar2
,p_adr_attribute8 IN Varchar2
,p_adr_attribute9 IN Varchar2
,p_adr_attribute10 IN Varchar2
,p_adr_attribute11 IN Varchar2
,p_adr_attribute12 IN Varchar2
,p_adr_attribute13 IN Varchar2
,p_adr_attribute14 IN Varchar2
,p_adr_attribute15 IN Varchar2
,p_adr_attribute16 IN Varchar2
,p_adr_attribute17 IN Varchar2
,p_adr_attribute18 IN Varchar2
,p_adr_attribute19 IN Varchar2
,p_adr_attribute20 IN Varchar2
,p_add_information13 IN Varchar2
,p_add_information14 IN Varchar2
,p_add_information15 IN Varchar2
,p_add_information16 IN Varchar2
,p_add_information17 IN Varchar2
,p_add_information18 IN Varchar2
,p_add_information19 IN Varchar2
,p_add_information20 IN Varchar2
-- Person Phones: Per_Phones
,p_phone_type IN Varchar2
,p_phone_number IN Varchar2
,p_phone_date_from IN Date
,p_phone_date_to IN Date
-- Person Contact: Per_Contact_Relationships
,p_contact_type IN Varchar2
,p_contact_name IN Varchar2
,p_primary_contact IN Varchar2
,p_primary_relationship IN Varchar2
,p_contact_date_from IN Date
,p_contact_date_to IN Date
,p_return_status OUT NOCOPY Varchar2
,p_dup_asg_id IN Number
,p_mode_type IN Varchar2
) AS
--
-- Variables for IN/OUT parameters
--
l_proc CONSTANT Varchar2(150) := g_package ||'Create_OSS_Person';
,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_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
-- Person DF
,p_per_attribute_category => p_per_attribute_category
,p_per_attribute1 => p_per_attribute1
,p_per_attribute2 => p_per_attribute2
,p_per_attribute3 => p_per_attribute3
,p_per_attribute4 => p_per_attribute4
,p_per_attribute5 => p_per_attribute5
,p_per_attribute6 => p_per_attribute6
,p_per_attribute7 => p_per_attribute7
,p_per_attribute8 => p_per_attribute8
,p_per_attribute9 => p_per_attribute9
,p_per_attribute10 => p_per_attribute10
,p_per_attribute11 => p_per_attribute11
,p_per_attribute12 => p_per_attribute12
,p_per_attribute13 => p_per_attribute13
,p_per_attribute14 => p_per_attribute14
,p_per_attribute15 => p_per_attribute15
,p_per_attribute16 => p_per_attribute16
,p_per_attribute17 => p_per_attribute17
,p_per_attribute18 => p_per_attribute18
,p_per_attribute19 => p_per_attribute19
,p_per_attribute20 => p_per_attribute20
,p_per_attribute21 => p_per_attribute21
,p_per_attribute22 => p_per_attribute22
,p_per_attribute23 => p_per_attribute23
,p_per_attribute24 => p_per_attribute24
,p_per_attribute25 => p_per_attribute25
,p_per_attribute26 => p_per_attribute26
,p_per_attribute27 => p_per_attribute27
,p_per_attribute28 => p_per_attribute28
,p_per_attribute29 => p_per_attribute29
,p_per_attribute30 => p_per_attribute30
-- Person DDF
,p_per_information_category => p_per_information_category
,p_per_information1 => p_per_information1
,p_per_information2 => p_per_information2
,p_per_information3 => p_per_information3
,p_per_information4 => p_per_information4
,p_per_information5 => p_per_information5
,p_per_information6 => p_per_information6
,p_per_information7 => p_per_information7
,p_per_information8 => p_per_information8
,p_per_information9 => p_per_information9
,p_per_information10 => p_per_information10
,p_per_information11 => p_per_information11
,p_per_information12 => p_per_information12
,p_per_information13 => p_per_information13
,p_per_information14 => p_per_information14
,p_per_information15 => p_per_information15
,p_per_information16 => p_per_information16
,p_per_information17 => p_per_information17
,p_per_information18 => p_per_information18
,p_per_information19 => p_per_information19
,p_per_information20 => p_per_information20
,p_per_information21 => p_per_information21
,p_per_information22 => p_per_information22
,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
-- Primary Address: Per_Addresses
,p_pradd_ovlapval_override => p_pradd_ovlapval_override
,p_address_type => p_address_type
,p_adr_comments => p_adr_comments
,p_primary_flag => p_primary_flag
,p_address_style => p_address_style
,p_address_line1 => p_address_line1
,p_address_line2 => p_address_line2
,p_address_line3 => p_address_line3
,p_region1 => p_region1
,p_region2 => p_region2
,p_region3 => p_region3
,p_town_or_city => p_town_or_city
,p_country => p_country
,p_postal_code => p_postal_code
,p_telephone_no1 => p_telephone_no1
,p_telephone_no2 => p_telephone_no2
,p_telephone_no3 => p_telephone_no3
,p_address_date_from => p_address_date_from
,p_address_date_to => p_address_date_to
,p_adr_attribute_category => p_adr_attribute_category
,p_adr_attribute1 => p_adr_attribute1
,p_adr_attribute2 => p_adr_attribute2
,p_adr_attribute3 => p_adr_attribute3
,p_adr_attribute4 => p_adr_attribute4
,p_adr_attribute5 => p_adr_attribute5
,p_adr_attribute6 => p_adr_attribute6
,p_adr_attribute7 => p_adr_attribute7
,p_adr_attribute8 => p_adr_attribute8
,p_adr_attribute9 => p_adr_attribute9
,p_adr_attribute10 => p_adr_attribute10
,p_adr_attribute11 => p_adr_attribute11
,p_adr_attribute12 => p_adr_attribute12
,p_adr_attribute13 => p_adr_attribute13
,p_adr_attribute14 => p_adr_attribute14
,p_adr_attribute15 => p_adr_attribute15
,p_adr_attribute16 => p_adr_attribute16
,p_adr_attribute17 => p_adr_attribute17
,p_adr_attribute18 => p_adr_attribute18
,p_adr_attribute19 => p_adr_attribute19
,p_adr_attribute20 => p_adr_attribute20
,p_add_information13 => p_add_information13
,p_add_information14 => p_add_information14
,p_add_information15 => p_add_information15
,p_add_information16 => p_add_information16
,p_add_information17 => p_add_information17
,p_add_information18 => p_add_information18
,p_add_information19 => p_add_information19
,p_add_information20 => p_add_information20
-- Person Phones: Per_Phones
,p_phone_type => p_phone_type
,p_phone_number => p_phone_number
,p_phone_date_from => p_phone_date_from
,p_phone_date_to => p_phone_date_to
-- Person Contact: Per_Contact_Relationships
,p_contact_type => p_contact_type
,p_contact_name => p_contact_name
,p_primary_contact => p_primary_contact
,p_primary_relationship => p_primary_relationship
,p_contact_date_from => p_contact_date_from
,p_contact_date_to => p_contact_date_to
,p_return_status => p_return_status
,p_dup_asg_id => p_dup_asg_id
,p_mode_type => p_mode_type
);
,p_datetrack_update_mode IN Varchar2
,p_assignment_id IN Number
,p_party_id IN Number
,p_business_group_id IN Number
,p_valiDate IN Boolean
,p_called_from_mass_upDate IN Boolean
--
,p_grade_id IN Number
,p_position_id IN Number
,p_job_id IN Number
,p_payroll_id IN Number
,p_location_id IN Number
,p_organization_id IN Number
,p_pay_basis_id IN Number
,p_employment_category IN Varchar2
,p_assignment_category IN Varchar2
--
,p_supervisor_id IN Number
,p_assignment_number IN Varchar2
,p_change_reason IN Varchar2
,p_assignment_status_type_id IN Number
,p_comments IN Varchar2
,p_Date_probation_end IN Date
,p_default_code_comb_id IN Number
,p_frequency IN Varchar2
,p_internal_address_line IN Varchar2
,p_manager_flag IN Varchar2
,p_normal_hours IN Number
,p_perf_review_period IN Number
,p_perf_review_period_frequency IN Varchar2
,p_probation_period IN Number
,p_probation_unit IN Varchar2
,p_sal_review_period IN Number
,p_sal_review_period_frequency IN Varchar2
,p_set_of_books_id IN Number
,p_source_type IN Varchar2
,p_time_normal_finish IN Varchar2
,p_time_normal_start IN Varchar2
,p_bargaining_unit_code IN Varchar2
,p_labour_union_member_flag IN Varchar2
,p_hourly_salaried_code IN Varchar2
,p_title IN Varchar2
,p_notice_period IN Number
,p_notice_period_uom IN Varchar2
,p_employee_category IN Varchar2
,p_work_at_home IN Varchar2
,p_job_post_source_name IN Varchar2
,p_supervisor_assignment_id IN Number
--People Group Keyflex Field
,p_people_group_id IN Number
,p_pgrp_segment1 IN Varchar2
,p_pgrp_segment2 IN Varchar2
,p_pgrp_segment3 IN Varchar2
,p_pgrp_segment4 IN Varchar2
,p_pgrp_segment5 IN Varchar2
,p_pgrp_segment6 IN Varchar2
,p_pgrp_segment7 IN Varchar2
,p_pgrp_segment8 IN Varchar2
,p_pgrp_segment9 IN Varchar2
,p_pgrp_segment10 IN Varchar2
,p_pgrp_segment11 IN Varchar2
,p_pgrp_segment12 IN Varchar2
,p_pgrp_segment13 IN Varchar2
,p_pgrp_segment14 IN Varchar2
,p_pgrp_segment15 IN Varchar2
,p_pgrp_segment16 IN Varchar2
,p_pgrp_segment17 IN Varchar2
,p_pgrp_segment18 IN Varchar2
,p_pgrp_segment19 IN Varchar2
,p_pgrp_segment20 IN Varchar2
,p_pgrp_segment21 IN Varchar2
,p_pgrp_segment22 IN Varchar2
,p_pgrp_segment23 IN Varchar2
,p_pgrp_segment24 IN Varchar2
,p_pgrp_segment25 IN Varchar2
,p_pgrp_segment26 IN Varchar2
,p_pgrp_segment27 IN Varchar2
,p_pgrp_segment28 IN Varchar2
,p_pgrp_segment29 IN Varchar2
,p_pgrp_segment30 IN Varchar2
,p_pgrp_concat_segments IN Varchar2
--Soft Coding KeyflexId
,p_soft_coding_keyflex_id IN Number
,p_soft_concat_segments IN Varchar2
,p_scl_segment1 IN Varchar2
,p_scl_segment2 IN Varchar2
,p_scl_segment3 IN Varchar2
,p_scl_segment4 IN Varchar2
,p_scl_segment5 IN Varchar2
,p_scl_segment6 IN Varchar2
,p_scl_segment7 IN Varchar2
,p_scl_segment8 IN Varchar2
,p_scl_segment9 IN Varchar2
,p_scl_segment10 IN Varchar2
,p_scl_segment11 IN Varchar2
,p_scl_segment12 IN Varchar2
,p_scl_segment13 IN Varchar2
,p_scl_segment14 IN Varchar2
,p_scl_segment15 IN Varchar2
,p_scl_segment16 IN Varchar2
,p_scl_segment17 IN Varchar2
,p_scl_segment18 IN Varchar2
,p_scl_segment19 IN Varchar2
,p_scl_segment20 IN Varchar2
,p_scl_segment21 IN Varchar2
,p_scl_segment22 IN Varchar2
,p_scl_segment23 IN Varchar2
,p_scl_segment24 IN Varchar2
,p_scl_segment25 IN Varchar2
,p_scl_segment26 IN Varchar2
,p_scl_segment27 IN Varchar2
,p_scl_segment28 IN Varchar2
,p_scl_segment29 IN Varchar2
,p_scl_segment30 IN Varchar2
-- Assignment DF Information
,p_ass_attribute_category IN Varchar2
,p_ass_attribute1 IN Varchar2
,p_ass_attribute2 IN Varchar2
,p_ass_attribute3 IN Varchar2
,p_ass_attribute4 IN Varchar2
,p_ass_attribute5 IN Varchar2
,p_ass_attribute6 IN Varchar2
,p_ass_attribute7 IN Varchar2
,p_ass_attribute8 IN Varchar2
,p_ass_attribute9 IN Varchar2
,p_ass_attribute10 IN Varchar2
,p_ass_attribute11 IN Varchar2
,p_ass_attribute12 IN Varchar2
,p_ass_attribute13 IN Varchar2
,p_ass_attribute14 IN Varchar2
,p_ass_attribute15 IN Varchar2
,p_ass_attribute16 IN Varchar2
,p_ass_attribute17 IN Varchar2
,p_ass_attribute18 IN Varchar2
,p_ass_attribute19 IN Varchar2
,p_ass_attribute20 IN Varchar2
,p_ass_attribute21 IN Varchar2
,p_ass_attribute22 IN Varchar2
,p_ass_attribute23 IN Varchar2
,p_ass_attribute24 IN Varchar2
,p_ass_attribute25 IN Varchar2
,p_ass_attribute26 IN Varchar2
,p_ass_attribute27 IN Varchar2
,p_ass_attribute28 IN Varchar2
,p_ass_attribute29 IN Varchar2
,p_ass_attribute30 IN Varchar2
--
,p_grade_ladder_pgm_id IN Number
,p_special_ceiling_step_id IN Number
,p_cagr_grade_def_id IN Number
,p_contract_id IN Number
,p_establishment_id IN Number
,p_collective_agreement_id IN Number
,p_cagr_id_flex_num IN Number
,p_cag_segment1 IN Varchar2
,p_cag_segment2 IN Varchar2
,p_cag_segment3 IN Varchar2
,p_cag_segment4 IN Varchar2
,p_cag_segment5 IN Varchar2
,p_cag_segment6 IN Varchar2
,p_cag_segment7 IN Varchar2
,p_cag_segment8 IN Varchar2
,p_cag_segment9 IN Varchar2
,p_cag_segment10 IN Varchar2
,p_cag_segment11 IN Varchar2
,p_cag_segment12 IN Varchar2
,p_cag_segment13 IN Varchar2
,p_cag_segment14 IN Varchar2
,p_cag_segment15 IN Varchar2
,p_cag_segment16 IN Varchar2
,p_cag_segment17 IN Varchar2
,p_cag_segment18 IN Varchar2
,p_cag_segment19 IN Varchar2
,p_cag_segment20 IN Varchar2
,p_return_status OUT NOCOPY Varchar2
,p_FICA_exempt IN Varchar2
) AS
--
-- Variables for IN/OUT parameters
--
l_proc CONSTANT Varchar2(150) := g_package ||'Upd_OSS_Person_Asg';
,p_datetrack_update_mode => p_datetrack_update_mode
,p_assignment_id => p_assignment_id
,p_party_id => p_party_id
,p_business_group_id => p_business_group_id
,p_valiDate => FALSE
,p_called_from_mass_upDate => FALSE
--
,p_grade_id => p_grade_id
,p_position_id => p_position_id
,p_job_id => p_job_id
,p_payroll_id => p_payroll_id
,p_location_id => p_location_id
,p_organization_id => p_organization_id
,p_pay_basis_id => p_pay_basis_id
,p_employment_category => p_employment_category
,p_assignment_category => p_assignment_category
--
,p_supervisor_id => p_supervisor_id
,p_assignment_number => p_assignment_number
,p_change_reason => p_change_reason
,p_assignment_status_type_id => p_assignment_status_type_id
,p_comments => p_comments
,p_date_probation_end => p_date_probation_end
,p_default_code_comb_id => p_default_code_comb_id
,p_frequency => p_frequency
,p_internal_address_line => p_internal_address_line
,p_manager_flag => p_manager_flag
,p_normal_hours => p_normal_hours
,p_perf_review_period => p_perf_review_period
,p_perf_review_period_frequency => p_perf_review_period_frequency
,p_probation_period => p_probation_period
,p_probation_unit => p_probation_unit
,p_sal_review_period => p_sal_review_period
,p_sal_review_period_frequency => p_sal_review_period_frequency
,p_set_of_books_id => p_set_of_books_id
,p_source_type => p_source_type
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_bargaining_unit_code => p_bargaining_unit_code
,p_labour_union_member_flag => p_labour_union_member_flag
,p_hourly_salaried_code => p_hourly_salaried_code
,p_title => p_title
,p_notice_period => p_notice_period
,p_notice_period_uom => p_notice_period_uom
,p_employee_category => p_employee_category
,p_work_at_home => p_work_at_home
,p_job_post_source_name => p_job_post_source_name
,p_supervisor_assignment_id => p_supervisor_assignment_id
--People Group Keyflex Field
,p_people_group_id => p_people_group_id
,p_pgrp_segment1 => p_pgrp_segment1
,p_pgrp_segment2 => p_pgrp_segment2
,p_pgrp_segment3 => p_pgrp_segment3
,p_pgrp_segment4 => p_pgrp_segment4
,p_pgrp_segment5 => p_pgrp_segment5
,p_pgrp_segment6 => p_pgrp_segment6
,p_pgrp_segment7 => p_pgrp_segment7
,p_pgrp_segment8 => p_pgrp_segment8
,p_pgrp_segment9 => p_pgrp_segment9
,p_pgrp_segment10 => p_pgrp_segment10
,p_pgrp_segment11 => p_pgrp_segment11
,p_pgrp_segment12 => p_pgrp_segment12
,p_pgrp_segment13 => p_pgrp_segment13
,p_pgrp_segment14 => p_pgrp_segment14
,p_pgrp_segment15 => p_pgrp_segment15
,p_pgrp_segment16 => p_pgrp_segment16
,p_pgrp_segment17 => p_pgrp_segment17
,p_pgrp_segment18 => p_pgrp_segment18
,p_pgrp_segment19 => p_pgrp_segment19
,p_pgrp_segment20 => p_pgrp_segment20
,p_pgrp_segment21 => p_pgrp_segment21
,p_pgrp_segment22 => p_pgrp_segment22
,p_pgrp_segment23 => p_pgrp_segment23
,p_pgrp_segment24 => p_pgrp_segment24
,p_pgrp_segment25 => p_pgrp_segment25
,p_pgrp_segment26 => p_pgrp_segment26
,p_pgrp_segment27 => p_pgrp_segment27
,p_pgrp_segment28 => p_pgrp_segment28
,p_pgrp_segment29 => p_pgrp_segment29
,p_pgrp_segment30 => p_pgrp_segment30
,p_pgrp_concat_segments => p_pgrp_concat_segments
-- Soft Coding KeyflexId
,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
,p_soft_concat_segments => p_soft_concat_segments
,p_scl_segment1 => p_scl_segment1
,p_scl_segment2 => p_scl_segment2
,p_scl_segment3 => p_scl_segment3
,p_scl_segment4 => p_scl_segment4
,p_scl_segment5 => p_scl_segment5
,p_scl_segment6 => p_scl_segment6
,p_scl_segment7 => p_scl_segment7
,p_scl_segment8 => p_scl_segment8
,p_scl_segment9 => p_scl_segment9
,p_scl_segment10 => p_scl_segment10
,p_scl_segment11 => p_scl_segment11
,p_scl_segment12 => p_scl_segment12
,p_scl_segment13 => p_scl_segment13
,p_scl_segment14 => p_scl_segment14
,p_scl_segment15 => p_scl_segment15
,p_scl_segment16 => p_scl_segment16
,p_scl_segment17 => p_scl_segment17
,p_scl_segment18 => p_scl_segment18
,p_scl_segment19 => p_scl_segment19
,p_scl_segment20 => p_scl_segment20
,p_scl_segment21 => p_scl_segment21
,p_scl_segment22 => p_scl_segment22
,p_scl_segment23 => p_scl_segment23
,p_scl_segment24 => p_scl_segment24
,p_scl_segment25 => p_scl_segment25
,p_scl_segment26 => p_scl_segment26
,p_scl_segment27 => p_scl_segment27
,p_scl_segment28 => p_scl_segment28
,p_scl_segment29 => p_scl_segment29
,p_scl_segment30 => p_scl_segment30
-- Assignment DF Information
,p_ass_attribute_category => p_ass_attribute_category
,p_ass_attribute1 => p_ass_attribute1
,p_ass_attribute2 => p_ass_attribute2
,p_ass_attribute3 => p_ass_attribute3
,p_ass_attribute4 => p_ass_attribute4
,p_ass_attribute5 => p_ass_attribute5
,p_ass_attribute6 => p_ass_attribute6
,p_ass_attribute7 => p_ass_attribute7
,p_ass_attribute8 => p_ass_attribute8
,p_ass_attribute9 => p_ass_attribute9
,p_ass_attribute10 => p_ass_attribute10
,p_ass_attribute11 => p_ass_attribute11
,p_ass_attribute12 => p_ass_attribute12
,p_ass_attribute13 => p_ass_attribute13
,p_ass_attribute14 => p_ass_attribute14
,p_ass_attribute15 => p_ass_attribute15
,p_ass_attribute16 => p_ass_attribute16
,p_ass_attribute17 => p_ass_attribute17
,p_ass_attribute18 => p_ass_attribute18
,p_ass_attribute19 => p_ass_attribute19
,p_ass_attribute20 => p_ass_attribute20
,p_ass_attribute21 => p_ass_attribute21
,p_ass_attribute22 => p_ass_attribute22
,p_ass_attribute23 => p_ass_attribute23
,p_ass_attribute24 => p_ass_attribute24
,p_ass_attribute25 => p_ass_attribute25
,p_ass_attribute26 => p_ass_attribute26
,p_ass_attribute27 => p_ass_attribute27
,p_ass_attribute28 => p_ass_attribute28
,p_ass_attribute29 => p_ass_attribute29
,p_ass_attribute30 => p_ass_attribute30
--
,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
,p_special_ceiling_step_id => p_special_ceiling_step_id
,p_cagr_grade_def_id => p_cagr_grade_def_id
,p_contract_id => p_contract_id
,p_establishment_id => p_establishment_id
,p_collective_agreement_id => p_collective_agreement_id
,p_cagr_id_flex_num => p_cagr_id_flex_num
,p_cag_segment1 => p_cag_segment1
,p_cag_segment2 => p_cag_segment2
,p_cag_segment3 => p_cag_segment3
,p_cag_segment4 => p_cag_segment4
,p_cag_segment5 => p_cag_segment5
,p_cag_segment6 => p_cag_segment6
,p_cag_segment7 => p_cag_segment7
,p_cag_segment8 => p_cag_segment8
,p_cag_segment9 => p_cag_segment9
,p_cag_segment10 => p_cag_segment10
,p_cag_segment11 => p_cag_segment11
,p_cag_segment12 => p_cag_segment12
,p_cag_segment13 => p_cag_segment13
,p_cag_segment14 => p_cag_segment14
,p_cag_segment15 => p_cag_segment15
,p_cag_segment16 => p_cag_segment16
,p_cag_segment17 => p_cag_segment17
,p_cag_segment18 => p_cag_segment18
,p_cag_segment19 => p_cag_segment19
,p_cag_segment20 => p_cag_segment20
,p_return_status => p_return_status
,p_FICA_exempt => l_FICA_exempt
);
ELSIF p_action IN('UPDATE','DELETE') THEN
l_extra_info_rec.assignment_id := p_assignment_id;
SELECT *
FROM per_people_extra_info pei
WHERE pei.person_id = p_person_id
AND pei.person_extra_info_id = p_person_extra_info_id
AND pei.information_type = p_information_type;
ELSIF p_action = 'UPDATE' THEN
-- If the action is update
l_extra_info_rec.person_id := p_person_id;
l_msg_data := 'Cannot Update the Port of Entry or Number for a Student Employee.';
ELSIF p_action = 'DELETE' THEN
-- If the action is delete.
l_extra_info_rec.person_id := p_person_id;
,p_program_update_date IN Date
) IS
l_proc CONSTANT Varchar2(150) := g_package ||'InsUpd_SIT_Info';