[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_resume_last_updated in per_people_f.resume_last_updated%type default null,
p_registered_disabled_flag in per_people_f.registered_disabled_flag%type default null,
p_second_passport_exists in per_people_f.second_passport_exists%type default null,
p_sex in per_people_f.sex%type default null,
p_student_status in per_people_f.student_status%type default null,
p_suffix in per_people_f.suffix%type default null,
p_title in per_people_f.title%type default null,
p_vendor_id in per_people_f.vendor_id%type default null,
p_work_schedule in per_people_f.work_schedule%type default null,
p_work_telephone in per_people_f.work_telephone%type default null,
p_request_id in per_people_f.request_id%type default null,
p_program_application_id in per_people_f.program_application_id%type default null,
p_program_id in per_people_f.program_id%type default null,
p_program_update_date in per_people_f.program_update_date%type default null,
p_attribute_category in per_people_f.attribute_category%type default null,
p_attribute1 in per_people_f.attribute1%type default null,
p_attribute2 in per_people_f.attribute2%type default null,
p_attribute3 in per_people_f.attribute3%type default null,
p_attribute4 in per_people_f.attribute4%type default null,
p_attribute5 in per_people_f.attribute5%type default null,
p_attribute6 in per_people_f.attribute6%type default null,
p_attribute7 in per_people_f.attribute7%type default null,
p_attribute8 in per_people_f.attribute8%type default null,
p_attribute9 in per_people_f.attribute9%type default null,
p_attribute10 in per_people_f.attribute10%type default null,
p_attribute11 in per_people_f.attribute11%type default null,
p_attribute12 in per_people_f.attribute12%type default null,
p_attribute13 in per_people_f.attribute13%type default null,
p_attribute14 in per_people_f.attribute14%type default null,
p_attribute15 in per_people_f.attribute15%type default null,
p_attribute16 in per_people_f.attribute16%type default null,
p_attribute17 in per_people_f.attribute17%type default null,
p_attribute18 in per_people_f.attribute18%type default null,
p_attribute19 in per_people_f.attribute19%type default null,
p_attribute20 in per_people_f.attribute20%type default null,
p_attribute21 in per_people_f.attribute21%type default null,
p_attribute22 in per_people_f.attribute22%type default null,
p_attribute23 in per_people_f.attribute23%type default null,
p_attribute24 in per_people_f.attribute24%type default null,
p_attribute25 in per_people_f.attribute25%type default null,
p_attribute26 in per_people_f.attribute26%type default null,
p_attribute27 in per_people_f.attribute27%type default null,
p_attribute28 in per_people_f.attribute28%type default null,
p_attribute29 in per_people_f.attribute29%type default null,
p_attribute30 in per_people_f.attribute30%type default null,
p_per_information_category in per_people_f.per_information_category%type default null,
p_per_information1 in per_people_f.per_information1%type default null,
p_per_information2 in per_people_f.per_information2%type default null,
p_per_information3 in per_people_f.per_information3%type default null,
p_per_information4 in per_people_f.per_information4%type default null,
p_per_information5 in per_people_f.per_information5%type default null,
p_per_information6 in per_people_f.per_information6%type default null,
p_per_information7 in per_people_f.per_information7%type default null,
p_per_information8 in per_people_f.per_information8%type default null,
p_per_information9 in per_people_f.per_information9%type default null,
p_per_information10 in per_people_f.per_information10%type default null,
p_per_information11 in per_people_f.per_information11%type default null,
p_per_information12 in per_people_f.per_information12%type default null,
p_per_information13 in per_people_f.per_information13%type default null,
p_per_information14 in per_people_f.per_information14%type default null,
p_per_information15 in per_people_f.per_information15%type default null,
p_per_information16 in per_people_f.per_information16%type default null,
p_per_information17 in per_people_f.per_information17%type default null,
p_per_information18 in per_people_f.per_information18%type default null,
p_per_information19 in per_people_f.per_information19%type default null,
p_per_information20 in per_people_f.per_information20%type default null,
p_per_information21 in per_people_f.per_information21%type default null,
p_per_information22 in per_people_f.per_information22%type default null,
p_per_information23 in per_people_f.per_information23%type default null,
p_per_information24 in per_people_f.per_information24%type default null,
p_per_information25 in per_people_f.per_information25%type default null,
p_per_information26 in per_people_f.per_information26%type default null,
p_per_information27 in per_people_f.per_information27%type default null,
p_per_information28 in per_people_f.per_information28%type default null,
p_per_information29 in per_people_f.per_information29%type default null,
p_per_information30 in per_people_f.per_information30%type default null,
-- p_object_version_number in per_people_f.object_version_number%type default null,
p_date_of_death in per_people_f.date_of_death%type default null,
p_rehire_reason in per_people_f.rehire_reason%type default null,
p_people_data in out nocopy per_all_people_f%rowtype ) is
l_proc varchar2(30):='conv_to_people_rg';
copy_field_value( p_source_field => p_resume_last_updated,
p_target_field => p_people_data.resume_last_updated);
copy_field_value( p_source_field => p_program_update_date,
p_target_field => p_people_data.program_update_date);
p_resume_last_updated => p_people_h_v.resume_last_updated ,
p_registered_disabled_flag => p_people_h_v.registered_disabled_flag ,
p_second_passport_exists => p_people_h_v.second_passport_exists ,
p_sex => p_people_h_v.sex ,
p_student_status => p_people_h_v.student_status ,
p_suffix => p_people_h_v.suffix ,
p_title => p_people_h_v.title ,
p_vendor_id => p_people_h_v.vendor_id ,
p_work_schedule => p_people_h_v.work_schedule ,
p_work_telephone => p_people_h_v.work_telephone ,
p_request_id => p_people_h_v.request_id ,
p_program_application_id => p_people_h_v.program_application_id ,
p_program_id => p_people_h_v.program_id ,
p_program_update_date => p_people_h_v.program_update_date ,
p_attribute_category => p_people_h_v.attribute_category ,
p_attribute1 => p_people_h_v.attribute1 ,
p_attribute2 => p_people_h_v.attribute2 ,
p_attribute3 => p_people_h_v.attribute3 ,
p_attribute4 => p_people_h_v.attribute4 ,
p_attribute5 => p_people_h_v.attribute5 ,
p_attribute6 => p_people_h_v.attribute6 ,
p_attribute7 => p_people_h_v.attribute7 ,
p_attribute8 => p_people_h_v.attribute8 ,
p_attribute9 => p_people_h_v.attribute9 ,
p_attribute10 => p_people_h_v.attribute10 ,
p_attribute11 => p_people_h_v.attribute11 ,
p_attribute12 => p_people_h_v.attribute12 ,
p_attribute13 => p_people_h_v.attribute13 ,
p_attribute14 => p_people_h_v.attribute14 ,
p_attribute15 => p_people_h_v.attribute15 ,
p_attribute16 => p_people_h_v.attribute16 ,
p_attribute17 => p_people_h_v.attribute17 ,
p_attribute18 => p_people_h_v.attribute18 ,
p_attribute19 => p_people_h_v.attribute19 ,
p_attribute20 => p_people_h_v.attribute20 ,
p_attribute21 => p_people_h_v.attribute21 ,
p_attribute22 => p_people_h_v.attribute22 ,
p_attribute23 => p_people_h_v.attribute23 ,
p_attribute24 => p_people_h_v.attribute24 ,
p_attribute25 => p_people_h_v.attribute25 ,
p_attribute26 => p_people_h_v.attribute26 ,
p_attribute27 => p_people_h_v.attribute27 ,
p_attribute28 => p_people_h_v.attribute28 ,
p_attribute29 => p_people_h_v.attribute29 ,
p_attribute30 => p_people_h_v.attribute30 ,
p_per_information_category => p_people_h_v.per_information_category ,
p_per_information1 => p_people_h_v.per_information1 ,
p_per_information2 => p_people_h_v.per_information2 ,
p_per_information3 => p_people_h_v.per_information3 ,
p_per_information4 => p_people_h_v.per_information4 ,
p_per_information5 => p_people_h_v.per_information5 ,
p_per_information6 => p_people_h_v.per_information6 ,
p_per_information7 => p_people_h_v.per_information7 ,
p_per_information8 => p_people_h_v.per_information8 ,
p_per_information9 => p_people_h_v.per_information9 ,
p_per_information10 => p_people_h_v.per_information10 ,
p_per_information11 => p_people_h_v.per_information11 ,
p_per_information12 => p_people_h_v.per_information12 ,
p_per_information13 => p_people_h_v.per_information13 ,
p_per_information14 => p_people_h_v.per_information14 ,
p_per_information15 => p_people_h_v.per_information15 ,
p_per_information16 => p_people_h_v.per_information16 ,
p_per_information17 => p_people_h_v.per_information17 ,
p_per_information18 => p_people_h_v.per_information18 ,
p_per_information19 => p_people_h_v.per_information19 ,
p_per_information20 => p_people_h_v.per_information20 ,
p_per_information21 => p_people_h_v.per_information21 ,
p_per_information22 => p_people_h_v.per_information22 ,
p_per_information23 => p_people_h_v.per_information23 ,
p_per_information24 => p_people_h_v.per_information24 ,
p_per_information25 => p_people_h_v.per_information25 ,
p_per_information26 => p_people_h_v.per_information26 ,
p_per_information27 => p_people_h_v.per_information27 ,
p_per_information28 => p_people_h_v.per_information28 ,
p_per_information29 => p_people_h_v.per_information29 ,
p_per_information30 => p_people_h_v.per_information30 ,
-- p_object_version_number => p_people_h_v.object_version_number ,
p_date_of_death => p_people_h_v.date_of_death ,
p_rehire_reason => p_people_h_v.rehire_reason ,
p_people_data => l_people_data);
p_history_data.information46 := to_char(p_people_data.resume_last_updated, g_hist_date_format) ;
p_history_data.information124 := to_char(p_people_data.program_update_date, g_hist_date_format) ;
p_people_data.resume_last_updated := to_date(p_history_data.information46, g_hist_date_format) ;
p_people_data.program_update_date := to_date(p_history_data.information124, g_hist_date_format) ;
p_program_update_date => p_asgnei_h_v.program_update_date ,
p_aei_attribute_category => p_asgnei_h_v.aei_attribute_category ,
p_aei_attribute1 => p_asgnei_h_v.aei_attribute1 ,
p_aei_attribute2 => p_asgnei_h_v.aei_attribute2 ,
p_aei_attribute3 => p_asgnei_h_v.aei_attribute3 ,
p_aei_attribute4 => p_asgnei_h_v.aei_attribute4 ,
p_aei_attribute5 => p_asgnei_h_v.aei_attribute5 ,
p_aei_attribute6 => p_asgnei_h_v.aei_attribute6 ,
p_aei_attribute7 => p_asgnei_h_v.aei_attribute7 ,
p_aei_attribute8 => p_asgnei_h_v.aei_attribute8 ,
p_aei_attribute9 => p_asgnei_h_v.aei_attribute9 ,
p_aei_attribute10 => p_asgnei_h_v.aei_attribute10 ,
p_aei_attribute11 => p_asgnei_h_v.aei_attribute11 ,
p_aei_attribute12 => p_asgnei_h_v.aei_attribute12 ,
p_aei_attribute13 => p_asgnei_h_v.aei_attribute13 ,
p_aei_attribute14 => p_asgnei_h_v.aei_attribute14 ,
p_aei_attribute15 => p_asgnei_h_v.aei_attribute15 ,
p_aei_attribute16 => p_asgnei_h_v.aei_attribute16 ,
p_aei_attribute17 => p_asgnei_h_v.aei_attribute17 ,
p_aei_attribute18 => p_asgnei_h_v.aei_attribute18 ,
p_aei_attribute19 => p_asgnei_h_v.aei_attribute19 ,
p_aei_attribute20 => p_asgnei_h_v.aei_attribute20 ,
p_aei_information_category => p_asgnei_h_v.aei_information_category ,
p_aei_information1 => p_asgnei_h_v.aei_information1 ,
p_aei_information2 => p_asgnei_h_v.aei_information2 ,
p_aei_information3 => p_asgnei_h_v.aei_information3 ,
p_aei_information4 => p_asgnei_h_v.aei_information4 ,
p_aei_information5 => p_asgnei_h_v.aei_information5 ,
p_aei_information6 => p_asgnei_h_v.aei_information6 ,
p_aei_information7 => p_asgnei_h_v.aei_information7 ,
p_aei_information8 => p_asgnei_h_v.aei_information8 ,
p_aei_information9 => p_asgnei_h_v.aei_information9 ,
p_aei_information10 => p_asgnei_h_v.aei_information10 ,
p_aei_information11 => p_asgnei_h_v.aei_information11 ,
p_aei_information12 => p_asgnei_h_v.aei_information12 ,
p_aei_information13 => p_asgnei_h_v.aei_information13 ,
p_aei_information14 => p_asgnei_h_v.aei_information14 ,
p_aei_information15 => p_asgnei_h_v.aei_information15 ,
p_aei_information16 => p_asgnei_h_v.aei_information16 ,
p_aei_information17 => p_asgnei_h_v.aei_information17 ,
p_aei_information18 => p_asgnei_h_v.aei_information18 ,
p_aei_information19 => p_asgnei_h_v.aei_information19 ,
p_aei_information20 => p_asgnei_h_v.aei_information20 ,
p_aei_information21 => p_asgnei_h_v.aei_information21 ,
p_aei_information22 => p_asgnei_h_v.aei_information22 ,
p_aei_information23 => p_asgnei_h_v.aei_information23 ,
p_aei_information24 => p_asgnei_h_v.aei_information24 ,
p_aei_information25 => p_asgnei_h_v.aei_information25 ,
p_aei_information26 => p_asgnei_h_v.aei_information26 ,
p_aei_information27 => p_asgnei_h_v.aei_information27 ,
p_aei_information28 => p_asgnei_h_v.aei_information28 ,
p_aei_information29 => p_asgnei_h_v.aei_information29 ,
p_aei_information30 => p_asgnei_h_v.aei_information30 ,
-- p_object_version_number => p_asgnei_h_v.object_version_number ,
p_asgnei_data => l_asgnei_data);
p_program_update_date in per_assignment_extra_info.program_update_date%type default NULL,
p_aei_attribute_category in per_assignment_extra_info.aei_attribute_category%type default NULL,
p_aei_attribute1 in per_assignment_extra_info.aei_attribute1%type default NULL,
p_aei_attribute2 in per_assignment_extra_info.aei_attribute2%type default NULL,
p_aei_attribute3 in per_assignment_extra_info.aei_attribute3%type default NULL,
p_aei_attribute4 in per_assignment_extra_info.aei_attribute4%type default NULL,
p_aei_attribute5 in per_assignment_extra_info.aei_attribute5%type default NULL,
p_aei_attribute6 in per_assignment_extra_info.aei_attribute6%type default NULL,
p_aei_attribute7 in per_assignment_extra_info.aei_attribute7%type default NULL,
p_aei_attribute8 in per_assignment_extra_info.aei_attribute8%type default NULL,
p_aei_attribute9 in per_assignment_extra_info.aei_attribute9%type default NULL,
p_aei_attribute10 in per_assignment_extra_info.aei_attribute10%type default NULL,
p_aei_attribute11 in per_assignment_extra_info.aei_attribute11%type default NULL,
p_aei_attribute12 in per_assignment_extra_info.aei_attribute12%type default NULL,
p_aei_attribute13 in per_assignment_extra_info.aei_attribute13%type default NULL,
p_aei_attribute14 in per_assignment_extra_info.aei_attribute14%type default NULL,
p_aei_attribute15 in per_assignment_extra_info.aei_attribute15%type default NULL,
p_aei_attribute16 in per_assignment_extra_info.aei_attribute16%type default NULL,
p_aei_attribute17 in per_assignment_extra_info.aei_attribute17%type default NULL,
p_aei_attribute18 in per_assignment_extra_info.aei_attribute18%type default NULL,
p_aei_attribute19 in per_assignment_extra_info.aei_attribute19%type default NULL,
p_aei_attribute20 in per_assignment_extra_info.aei_attribute20 %type default NULL,
-- p_object_version_number in per_assignment_extra_info.object_version_number%type default NULL,
p_asgnei_data in out nocopy per_assignment_extra_info%rowtype ) is
l_proc varchar2(30):='conv_to_asgnei_rg';
copy_field_value( p_source_field => p_program_update_date ,
p_target_field => p_asgnei_data.program_update_date );
p_history_data.information124 := to_char(p_asgnei_data.program_update_date, g_hist_date_format);
p_asgnei_data.program_update_date := to_date(p_history_data.information124, g_hist_date_format);
p_program_update_date in per_assignments_f.program_update_date%type default null,
p_ass_attribute_category in per_assignments_f.ass_attribute_category%type default null,
p_ass_attribute1 in per_assignments_f.ass_attribute1%type default null,
p_ass_attribute2 in per_assignments_f.ass_attribute2%type default null,
p_ass_attribute3 in per_assignments_f.ass_attribute3%type default null,
p_ass_attribute4 in per_assignments_f.ass_attribute4%type default null,
p_ass_attribute5 in per_assignments_f.ass_attribute5%type default null,
p_ass_attribute6 in per_assignments_f.ass_attribute6%type default null,
p_ass_attribute7 in per_assignments_f.ass_attribute7%type default null,
p_ass_attribute8 in per_assignments_f.ass_attribute8%type default null,
p_ass_attribute9 in per_assignments_f.ass_attribute9%type default null,
p_ass_attribute10 in per_assignments_f.ass_attribute10%type default null,
p_ass_attribute11 in per_assignments_f.ass_attribute11%type default null,
p_ass_attribute12 in per_assignments_f.ass_attribute12%type default null,
p_ass_attribute13 in per_assignments_f.ass_attribute13%type default null,
p_ass_attribute14 in per_assignments_f.ass_attribute14%type default null,
p_ass_attribute15 in per_assignments_f.ass_attribute15%type default null,
p_ass_attribute16 in per_assignments_f.ass_attribute16%type default null,
p_ass_attribute17 in per_assignments_f.ass_attribute17%type default null,
p_ass_attribute18 in per_assignments_f.ass_attribute18%type default null,
p_ass_attribute19 in per_assignments_f.ass_attribute19%type default null,
p_ass_attribute20 in per_assignments_f.ass_attribute20%type default null,
p_ass_attribute21 in per_assignments_f.ass_attribute21%type default null,
p_ass_attribute22 in per_assignments_f.ass_attribute22%type default null,
p_ass_attribute23 in per_assignments_f.ass_attribute23%type default null,
p_ass_attribute24 in per_assignments_f.ass_attribute24%type default null,
p_ass_attribute25 in per_assignments_f.ass_attribute25%type default null,
p_ass_attribute26 in per_assignments_f.ass_attribute26%type default null,
p_ass_attribute27 in per_assignments_f.ass_attribute27%type default null,
p_ass_attribute28 in per_assignments_f.ass_attribute28%type default null,
p_ass_attribute29 in per_assignments_f.ass_attribute29%type default null,
p_ass_attribute30 in per_assignments_f.ass_attribute30%type default null,
p_title in per_assignments_f.title%type default null,
-- p_object_version_number in per_assignments_f.object_version_number%type default null,
p_asgn_data in out nocopy per_all_assignments_f%rowtype ) as
l_proc varchar2(30):='conv_to_asgn_rg';
copy_field_value( p_source_field => p_program_update_date,
p_target_field => p_asgn_data.program_update_date);
p_program_update_date => p_asgn_h_v.program_update_date ,
p_ass_attribute_category => p_asgn_h_v.ass_attribute_category ,
p_ass_attribute1 => p_asgn_h_v.ass_attribute1 ,
p_ass_attribute2 => p_asgn_h_v.ass_attribute2 ,
p_ass_attribute3 => p_asgn_h_v.ass_attribute3 ,
p_ass_attribute4 => p_asgn_h_v.ass_attribute4 ,
p_ass_attribute5 => p_asgn_h_v.ass_attribute5 ,
p_ass_attribute6 => p_asgn_h_v.ass_attribute6 ,
p_ass_attribute7 => p_asgn_h_v.ass_attribute7 ,
p_ass_attribute8 => p_asgn_h_v.ass_attribute8 ,
p_ass_attribute9 => p_asgn_h_v.ass_attribute9 ,
p_ass_attribute10 => p_asgn_h_v.ass_attribute10 ,
p_ass_attribute11 => p_asgn_h_v.ass_attribute11 ,
p_ass_attribute12 => p_asgn_h_v.ass_attribute12 ,
p_ass_attribute13 => p_asgn_h_v.ass_attribute13 ,
p_ass_attribute14 => p_asgn_h_v.ass_attribute14 ,
p_ass_attribute15 => p_asgn_h_v.ass_attribute15 ,
p_ass_attribute16 => p_asgn_h_v.ass_attribute16 ,
p_ass_attribute17 => p_asgn_h_v.ass_attribute17 ,
p_ass_attribute18 => p_asgn_h_v.ass_attribute18 ,
p_ass_attribute19 => p_asgn_h_v.ass_attribute19 ,
p_ass_attribute20 => p_asgn_h_v.ass_attribute20 ,
p_ass_attribute21 => p_asgn_h_v.ass_attribute21 ,
p_ass_attribute22 => p_asgn_h_v.ass_attribute22 ,
p_ass_attribute23 => p_asgn_h_v.ass_attribute23 ,
p_ass_attribute24 => p_asgn_h_v.ass_attribute24 ,
p_ass_attribute25 => p_asgn_h_v.ass_attribute25 ,
p_ass_attribute26 => p_asgn_h_v.ass_attribute26 ,
p_ass_attribute27 => p_asgn_h_v.ass_attribute27 ,
p_ass_attribute28 => p_asgn_h_v.ass_attribute28 ,
p_ass_attribute29 => p_asgn_h_v.ass_attribute29 ,
p_ass_attribute30 => p_asgn_h_v.ass_attribute30 ,
p_title => p_asgn_h_v.title ,
-- p_object_version_number => p_asgn_h_v.object_version_number ,
p_asgn_data => l_asgn_data);
p_history_data.information125 := p_assignment_data.program_update_date ;
p_assignment_data.program_update_date := p_history_data.information125 ;
p_program_update_date => p_peopleei_h_v.program_update_date ,
p_pei_attribute_category => p_peopleei_h_v.pei_attribute_category ,
p_pei_attribute1 => p_peopleei_h_v.pei_attribute1 ,
p_pei_attribute2 => p_peopleei_h_v.pei_attribute2 ,
p_pei_attribute3 => p_peopleei_h_v.pei_attribute3 ,
p_pei_attribute4 => p_peopleei_h_v.pei_attribute4 ,
p_pei_attribute5 => p_peopleei_h_v.pei_attribute5 ,
p_pei_attribute6 => p_peopleei_h_v.pei_attribute6 ,
p_pei_attribute7 => p_peopleei_h_v.pei_attribute7 ,
p_pei_attribute8 => p_peopleei_h_v.pei_attribute8 ,
p_pei_attribute9 => p_peopleei_h_v.pei_attribute9 ,
p_pei_attribute10 => p_peopleei_h_v.pei_attribute10 ,
p_pei_attribute11 => p_peopleei_h_v.pei_attribute11 ,
p_pei_attribute12 => p_peopleei_h_v.pei_attribute12 ,
p_pei_attribute13 => p_peopleei_h_v.pei_attribute13 ,
p_pei_attribute14 => p_peopleei_h_v.pei_attribute14 ,
p_pei_attribute15 => p_peopleei_h_v.pei_attribute15 ,
p_pei_attribute16 => p_peopleei_h_v.pei_attribute16 ,
p_pei_attribute17 => p_peopleei_h_v.pei_attribute17 ,
p_pei_attribute18 => p_peopleei_h_v.pei_attribute18 ,
p_pei_attribute19 => p_peopleei_h_v.pei_attribute19 ,
p_pei_attribute20 => p_peopleei_h_v.pei_attribute20 ,
p_pei_information_category => p_peopleei_h_v.pei_information_category ,
p_pei_information1 => p_peopleei_h_v.pei_information1 ,
p_pei_information2 => p_peopleei_h_v.pei_information2 ,
p_pei_information3 => p_peopleei_h_v.pei_information3 ,
p_pei_information4 => p_peopleei_h_v.pei_information4 ,
p_pei_information5 => p_peopleei_h_v.pei_information5 ,
p_pei_information6 => p_peopleei_h_v.pei_information6 ,
p_pei_information7 => p_peopleei_h_v.pei_information7 ,
p_pei_information8 => p_peopleei_h_v.pei_information8 ,
p_pei_information9 => p_peopleei_h_v.pei_information9 ,
p_pei_information10 => p_peopleei_h_v.pei_information10 ,
p_pei_information11 => p_peopleei_h_v.pei_information11 ,
p_pei_information12 => p_peopleei_h_v.pei_information12 ,
p_pei_information13 => p_peopleei_h_v.pei_information13 ,
p_pei_information14 => p_peopleei_h_v.pei_information14 ,
p_pei_information15 => p_peopleei_h_v.pei_information15 ,
p_pei_information16 => p_peopleei_h_v.pei_information16 ,
p_pei_information17 => p_peopleei_h_v.pei_information17 ,
p_pei_information18 => p_peopleei_h_v.pei_information18 ,
p_pei_information19 => p_peopleei_h_v.pei_information19 ,
p_pei_information20 => p_peopleei_h_v.pei_information20 ,
p_pei_information21 => p_peopleei_h_v.pei_information21 ,
p_pei_information22 => p_peopleei_h_v.pei_information22 ,
p_pei_information23 => p_peopleei_h_v.pei_information23 ,
p_pei_information24 => p_peopleei_h_v.pei_information24 ,
p_pei_information25 => p_peopleei_h_v.pei_information25 ,
p_pei_information26 => p_peopleei_h_v.pei_information26 ,
p_pei_information27 => p_peopleei_h_v.pei_information27 ,
p_pei_information28 => p_peopleei_h_v.pei_information28 ,
p_pei_information29 => p_peopleei_h_v.pei_information29 ,
p_pei_information30 => p_peopleei_h_v.pei_information30 ,
-- p_object_version_number => p_peopleei_h_v.object_version_number ,
p_peopleei_data => l_peopleei_data);
p_program_update_date in per_people_extra_info.program_update_date%type default null,
p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
p_pei_information1 in per_people_extra_info.pei_information1%type default null,
p_pei_information2 in per_people_extra_info.pei_information2%type default null,
p_pei_information3 in per_people_extra_info.pei_information3%type default null,
p_pei_information4 in per_people_extra_info.pei_information4%type default null,
p_pei_information5 in per_people_extra_info.pei_information5%type default null,
p_pei_information6 in per_people_extra_info.pei_information6%type default null,
p_pei_information7 in per_people_extra_info.pei_information7%type default null,
p_pei_information8 in per_people_extra_info.pei_information8%type default null,
p_pei_information9 in per_people_extra_info.pei_information9%type default null,
p_pei_information10 in per_people_extra_info.pei_information10%type default null,
p_pei_information11 in per_people_extra_info.pei_information11%type default null,
p_pei_information12 in per_people_extra_info.pei_information12%type default null,
p_pei_information13 in per_people_extra_info.pei_information13%type default null,
p_pei_information14 in per_people_extra_info.pei_information14%type default null,
p_pei_information15 in per_people_extra_info.pei_information15%type default null,
p_pei_information16 in per_people_extra_info.pei_information16%type default null,
p_pei_information17 in per_people_extra_info.pei_information17%type default null,
p_pei_information18 in per_people_extra_info.pei_information18%type default null,
p_pei_information19 in per_people_extra_info.pei_information19%type default null,
p_pei_information20 in per_people_extra_info.pei_information20%type default null,
p_pei_information21 in per_people_extra_info.pei_information21%type default null,
p_pei_information22 in per_people_extra_info.pei_information22%type default null,
p_pei_information23 in per_people_extra_info.pei_information23%type default null,
p_pei_information24 in per_people_extra_info.pei_information24%type default null,
p_pei_information25 in per_people_extra_info.pei_information25%type default null,
p_pei_information26 in per_people_extra_info.pei_information26%type default null,
p_pei_information27 in per_people_extra_info.pei_information27%type default null,
p_pei_information28 in per_people_extra_info.pei_information28%type default null,
p_pei_information29 in per_people_extra_info.pei_information29%type default null,
p_pei_information30 in per_people_extra_info.pei_information30%type default null,
-- p_object_version_number in per_people_extra_info.object_version_number%type default null,
p_peopleei_data in out nocopy per_people_extra_info%rowtype ) as
l_proc varchar2(30):= 'conv_to_peopleei_rg ';
copy_field_value( p_source_field => p_program_update_date,
p_target_field => p_peopleei_data.program_update_date);
p_history_data.information124 := to_char(p_people_ei_data.program_update_date, g_hist_date_format) ;
p_people_ei_data.program_update_date := to_date(p_history_data.information124, g_hist_date_format);
p_program_update_date in per_position_extra_info.program_update_date%type default null,
p_poei_attribute_category in per_position_extra_info.poei_attribute_category%type default null,
p_poei_attribute1 in per_position_extra_info.poei_attribute1%type default null,
p_poei_attribute2 in per_position_extra_info.poei_attribute2%type default null,
p_poei_attribute3 in per_position_extra_info.poei_attribute3%type default null,
p_poei_attribute4 in per_position_extra_info.poei_attribute4%type default null,
p_poei_attribute5 in per_position_extra_info.poei_attribute5%type default null,
p_poei_attribute6 in per_position_extra_info.poei_attribute6%type default null,
p_poei_attribute7 in per_position_extra_info.poei_attribute7%type default null,
p_poei_attribute8 in per_position_extra_info.poei_attribute8%type default null,
p_poei_attribute9 in per_position_extra_info.poei_attribute9%type default null,
p_poei_attribute10 in per_position_extra_info.poei_attribute10%type default null,
p_poei_attribute11 in per_position_extra_info.poei_attribute11%type default null,
p_poei_attribute12 in per_position_extra_info.poei_attribute12%type default null,
p_poei_attribute13 in per_position_extra_info.poei_attribute13%type default null,
p_poei_attribute14 in per_position_extra_info.poei_attribute14%type default null,
p_poei_attribute15 in per_position_extra_info.poei_attribute15%type default null,
p_poei_attribute16 in per_position_extra_info.poei_attribute16%type default null,
p_poei_attribute17 in per_position_extra_info.poei_attribute17%type default null,
p_poei_attribute18 in per_position_extra_info.poei_attribute18%type default null,
p_poei_attribute19 in per_position_extra_info.poei_attribute19%type default null,
p_poei_attribute20 in per_position_extra_info.poei_attribute20%type default null,
p_poei_information_category in per_position_extra_info.poei_information_category%type default null,
p_poei_information1 in per_position_extra_info.poei_information1%type default null,
p_poei_information2 in per_position_extra_info.poei_information2%type default null,
p_poei_information3 in per_position_extra_info.poei_information3%type default null,
p_poei_information4 in per_position_extra_info.poei_information4%type default null,
p_poei_information5 in per_position_extra_info.poei_information5%type default null,
p_poei_information6 in per_position_extra_info.poei_information6%type default null,
p_poei_information7 in per_position_extra_info.poei_information7%type default null,
p_poei_information8 in per_position_extra_info.poei_information8%type default null,
p_poei_information9 in per_position_extra_info.poei_information9%type default null,
p_poei_information10 in per_position_extra_info.poei_information10%type default null,
p_poei_information11 in per_position_extra_info.poei_information11%type default null,
p_poei_information12 in per_position_extra_info.poei_information12%type default null,
p_poei_information13 in per_position_extra_info.poei_information13%type default null,
p_poei_information14 in per_position_extra_info.poei_information14%type default null,
p_poei_information15 in per_position_extra_info.poei_information15%type default null,
p_poei_information16 in per_position_extra_info.poei_information16%type default null,
p_poei_information17 in per_position_extra_info.poei_information17%type default null,
p_poei_information18 in per_position_extra_info.poei_information18%type default null,
p_poei_information19 in per_position_extra_info.poei_information19%type default null,
p_poei_information20 in per_position_extra_info.poei_information20%type default null,
p_poei_information21 in per_position_extra_info.poei_information21%type default null,
p_poei_information22 in per_position_extra_info.poei_information22%type default null,
p_poei_information23 in per_position_extra_info.poei_information23%type default null,
p_poei_information24 in per_position_extra_info.poei_information24%type default null,
p_poei_information25 in per_position_extra_info.poei_information25%type default null,
p_poei_information26 in per_position_extra_info.poei_information26%type default null,
p_poei_information27 in per_position_extra_info.poei_information27%type default null,
p_poei_information28 in per_position_extra_info.poei_information28%type default null,
p_poei_information29 in per_position_extra_info.poei_information29%type default null,
p_poei_information30 in per_position_extra_info.poei_information30%type default null,
-- p_object_version_number in per_position_extra_info.object_version_number%type default null,
p_position_extra_info_data in out nocopy per_position_extra_info%rowtype ) as
l_proc varchar2(30):='conv_to_positionei_rg';
copy_field_value( p_source_field => p_program_update_date,
p_target_field => p_position_extra_info_data.program_update_date);
p_program_update_date => p_positionei_h_v.program_update_date ,
p_poei_attribute_category => p_positionei_h_v.poei_attribute_category ,
p_poei_attribute1 => p_positionei_h_v.poei_attribute1 ,
p_poei_attribute2 => p_positionei_h_v.poei_attribute2 ,
p_poei_attribute3 => p_positionei_h_v.poei_attribute3 ,
p_poei_attribute4 => p_positionei_h_v.poei_attribute4 ,
p_poei_attribute5 => p_positionei_h_v.poei_attribute5 ,
p_poei_attribute6 => p_positionei_h_v.poei_attribute6 ,
p_poei_attribute7 => p_positionei_h_v.poei_attribute7 ,
p_poei_attribute8 => p_positionei_h_v.poei_attribute8 ,
p_poei_attribute9 => p_positionei_h_v.poei_attribute9 ,
p_poei_attribute10 => p_positionei_h_v.poei_attribute10 ,
p_poei_attribute11 => p_positionei_h_v.poei_attribute11 ,
p_poei_attribute12 => p_positionei_h_v.poei_attribute12 ,
p_poei_attribute13 => p_positionei_h_v.poei_attribute13 ,
p_poei_attribute14 => p_positionei_h_v.poei_attribute14 ,
p_poei_attribute15 => p_positionei_h_v.poei_attribute15 ,
p_poei_attribute16 => p_positionei_h_v.poei_attribute16 ,
p_poei_attribute17 => p_positionei_h_v.poei_attribute17 ,
p_poei_attribute18 => p_positionei_h_v.poei_attribute18 ,
p_poei_attribute19 => p_positionei_h_v.poei_attribute19 ,
p_poei_attribute20 => p_positionei_h_v.poei_attribute20 ,
p_poei_information_category => p_positionei_h_v.poei_information_category ,
p_poei_information1 => p_positionei_h_v.poei_information1 ,
p_poei_information2 => p_positionei_h_v.poei_information2 ,
p_poei_information3 => p_positionei_h_v.poei_information3 ,
p_poei_information4 => p_positionei_h_v.poei_information4 ,
p_poei_information5 => p_positionei_h_v.poei_information5 ,
p_poei_information6 => p_positionei_h_v.poei_information6 ,
p_poei_information7 => p_positionei_h_v.poei_information7 ,
p_poei_information8 => p_positionei_h_v.poei_information8 ,
p_poei_information9 => p_positionei_h_v.poei_information9 ,
p_poei_information10 => p_positionei_h_v.poei_information10 ,
p_poei_information11 => p_positionei_h_v.poei_information11 ,
p_poei_information12 => p_positionei_h_v.poei_information12 ,
p_poei_information13 => p_positionei_h_v.poei_information13 ,
p_poei_information14 => p_positionei_h_v.poei_information14 ,
p_poei_information15 => p_positionei_h_v.poei_information15 ,
p_poei_information16 => p_positionei_h_v.poei_information16 ,
p_poei_information17 => p_positionei_h_v.poei_information17 ,
p_poei_information18 => p_positionei_h_v.poei_information18 ,
p_poei_information19 => p_positionei_h_v.poei_information19 ,
p_poei_information20 => p_positionei_h_v.poei_information20 ,
p_poei_information21 => p_positionei_h_v.poei_information21 ,
p_poei_information22 => p_positionei_h_v.poei_information22 ,
p_poei_information23 => p_positionei_h_v.poei_information23 ,
p_poei_information24 => p_positionei_h_v.poei_information24 ,
p_poei_information25 => p_positionei_h_v.poei_information25 ,
p_poei_information26 => p_positionei_h_v.poei_information26 ,
p_poei_information27 => p_positionei_h_v.poei_information27 ,
p_poei_information28 => p_positionei_h_v.poei_information28 ,
p_poei_information29 => p_positionei_h_v.poei_information29 ,
p_poei_information30 => p_positionei_h_v.poei_information30 ,
-- p_object_version_number => p_positionei_h_v.object_version_number ,
p_position_extra_info_data => l_positionei_data );
p_history_data.information124 := to_char(p_position_ei_data.program_update_date, g_hist_date_format) ;
p_position_ei_data.program_update_date := to_date(p_history_data.information124, g_hist_date_format) ;
p_program_update_date in per_addresses.program_update_date%type default null,
p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
p_addr_attribute20 in per_addresses.addr_attribute20%type default null,
-- p_object_version_number in per_addresses.object_version_number%type default null,
p_addresses_data in out nocopy per_addresses%rowtype ) as
l_proc varchar2(30):='conv_to_addresses_rg';
copy_field_value( p_source_field => p_program_update_date,
p_target_field => p_addresses_data.program_update_date);
p_program_update_date => p_addresses_h_v.program_update_date ,
p_addr_attribute_category => p_addresses_h_v.addr_attribute_category ,
p_addr_attribute1 => p_addresses_h_v.addr_attribute1 ,
p_addr_attribute2 => p_addresses_h_v.addr_attribute2 ,
p_addr_attribute3 => p_addresses_h_v.addr_attribute3 ,
p_addr_attribute4 => p_addresses_h_v.addr_attribute4 ,
p_addr_attribute5 => p_addresses_h_v.addr_attribute5 ,
p_addr_attribute6 => p_addresses_h_v.addr_attribute6 ,
p_addr_attribute7 => p_addresses_h_v.addr_attribute7 ,
p_addr_attribute8 => p_addresses_h_v.addr_attribute8 ,
p_addr_attribute9 => p_addresses_h_v.addr_attribute9 ,
p_addr_attribute10 => p_addresses_h_v.addr_attribute10 ,
p_addr_attribute11 => p_addresses_h_v.addr_attribute11 ,
p_addr_attribute12 => p_addresses_h_v.addr_attribute12 ,
p_addr_attribute13 => p_addresses_h_v.addr_attribute13 ,
p_addr_attribute14 => p_addresses_h_v.addr_attribute14 ,
p_addr_attribute15 => p_addresses_h_v.addr_attribute15 ,
p_addr_attribute16 => p_addresses_h_v.addr_attribute16 ,
p_addr_attribute17 => p_addresses_h_v.addr_attribute17 ,
p_addr_attribute18 => p_addresses_h_v.addr_attribute18 ,
p_addr_attribute19 => p_addresses_h_v.addr_attribute19 ,
p_addr_attribute20 => p_addresses_h_v.addr_attribute20 ,
-- p_object_version_number => p_addresses_h_v.object_version_number ,
p_addresses_data => l_addresses_data);
p_history_data.information124 := to_char(p_addresses_data.program_update_date,g_hist_date_format) ;
p_addresses_data.program_update_date := to_date(p_history_data.information124,g_hist_date_format) ;
p_history_data.information124 := to_char(p_peranalyses_data.PROGRAM_UPDATE_DATE,g_hist_date_format) ;
p_peranalyses_data.PROGRAM_UPDATE_DATE := to_date(p_history_data.information124,g_hist_date_format);
p_PROGRAM_UPDATE_DATE => p_peranalyses_h_v.PROGRAM_UPDATE_DATE ,
p_ATTRIBUTE_CATEGORY => p_peranalyses_h_v.ATTRIBUTE_CATEGORY ,
p_ATTRIBUTE1 => p_peranalyses_h_v.ATTRIBUTE1 ,
p_ATTRIBUTE2 => p_peranalyses_h_v.ATTRIBUTE2 ,
p_ATTRIBUTE3 => P_peranalyses_H_V.ATTRIBUTE3 ,
p_ATTRIBUTE4 => P_peranalyses_H_V.ATTRIBUTE4 ,
p_ATTRIBUTE5 => P_peranalyses_H_V.ATTRIBUTE5 ,
p_ATTRIBUTE6 => P_peranalyses_H_V.ATTRIBUTE6 ,
p_ATTRIBUTE7 => P_peranalyses_H_V.ATTRIBUTE7 ,
p_ATTRIBUTE8 => P_peranalyses_H_V.ATTRIBUTE8 ,
p_ATTRIBUTE9 => P_peranalyses_H_V.ATTRIBUTE9 ,
p_ATTRIBUTE10 => P_peranalyses_H_V.ATTRIBUTE10 ,
p_ATTRIBUTE11 => P_peranalyses_H_V.ATTRIBUTE11 ,
p_ATTRIBUTE12 => P_peranalyses_H_V.ATTRIBUTE12 ,
p_ATTRIBUTE13 => P_peranalyses_H_V.ATTRIBUTE13 ,
p_ATTRIBUTE14 => P_peranalyses_H_V.ATTRIBUTE14 ,
p_ATTRIBUTE15 => P_peranalyses_H_V.ATTRIBUTE15 ,
p_ATTRIBUTE16 => P_peranalyses_H_V.ATTRIBUTE16 ,
p_ATTRIBUTE17 => P_peranalyses_H_V.ATTRIBUTE17 ,
p_ATTRIBUTE18 => P_peranalyses_H_V.ATTRIBUTE18 ,
p_ATTRIBUTE19 => P_peranalyses_H_V.ATTRIBUTE19 ,
p_ATTRIBUTE20 => P_peranalyses_H_V.ATTRIBUTE20 ,
p_peranalyses_data => l_peranalyses_data);
p_program_update_date in per_person_analyses.program_update_date%type default null,
p_attribute_category in per_person_analyses.attribute_category%type default null,
p_attribute1 in per_person_analyses.attribute1%type default null,
p_attribute2 in per_person_analyses.attribute2%type default null,
p_attribute3 in per_person_analyses.attribute3%type default null,
p_attribute4 in per_person_analyses.attribute4%type default null,
p_attribute5 in per_person_analyses.attribute5%type default null,
p_attribute6 in per_person_analyses.attribute6%type default null,
p_attribute7 in per_person_analyses.attribute7%type default null,
p_attribute8 in per_person_analyses.attribute8%type default null,
p_attribute9 in per_person_analyses.attribute9%type default null,
p_attribute10 in per_person_analyses.attribute10%type default null,
p_attribute11 in per_person_analyses.attribute11%type default null,
p_attribute12 in per_person_analyses.attribute12%type default null,
p_attribute13 in per_person_analyses.attribute13%type default null,
p_attribute14 in per_person_analyses.attribute14%type default null,
p_attribute15 in per_person_analyses.attribute15%type default null,
p_attribute16 in per_person_analyses.attribute16%type default null,
p_attribute17 in per_person_analyses.attribute17%type default null,
p_attribute18 in per_person_analyses.attribute18%type default null,
p_attribute19 in per_person_analyses.attribute19%type default null,
p_attribute20 in per_person_analyses.attribute20%type default null,
p_peranalyses_data in out nocopy per_person_analyses%rowtype ) as
l_proc varchar2(30):='conv_to_peranalyses_rg';
copy_field_value( p_source_field => p_program_update_date,
p_target_field => p_peranalyses_data.program_update_date);
/* Deleted for New Position table functions (date tracked)
-- Procedure conv_to_position_rg. Copies the individual fields supplied as parameters
-- to the per_position type record.
Procedure conv_to_position_rg(
p_position_id in per_positions.position_id%type default null,
p_business_group_id in per_positions.business_group_id%type default null,
p_job_id in per_positions.job_id%type default null,
p_organization_id in per_positions.organization_id%type default null,
p_successor_position_id in per_positions.successor_position_id%type default null,
p_relief_position_id in per_positions.relief_position_id%type default null,
p_location_id in per_positions.location_id%type default null,
p_position_definition_id in per_positions.position_definition_id%type default null,
p_date_effective in per_positions.date_effective%type default null,
p_date_end in per_positions.date_end%type default null,
p_frequency in per_positions.frequency%type default null,
p_name in per_positions.name%type default null,
p_probation_period in per_positions.probation_period%type default null,
p_probation_period_units in per_positions.probation_period_units%type default null,
p_replacement_required_flag in per_positions.replacement_required_flag%type default null,
p_time_normal_finish in per_positions.time_normal_finish%type default null,
p_time_normal_start in per_positions.time_normal_start%type default null,
p_working_hours in per_positions.working_hours%type default null,
p_request_id in per_positions.request_id%type default null,
p_program_application_id in per_positions.program_application_id%type default null,
p_program_id in per_positions.program_id%type default null,
p_program_update_date in per_positions.program_update_date%type default null,
p_attribute_category in per_positions.attribute_category%type default null,
p_attribute1 in per_positions.attribute1%type default null,
p_attribute2 in per_positions.attribute2%type default null,
p_attribute3 in per_positions.attribute3%type default null,
p_attribute4 in per_positions.attribute4%type default null,
p_attribute5 in per_positions.attribute5%type default null,
p_attribute6 in per_positions.attribute6%type default null,
p_attribute7 in per_positions.attribute7%type default null,
p_attribute8 in per_positions.attribute8%type default null,
p_attribute9 in per_positions.attribute9%type default null,
p_attribute10 in per_positions.attribute10%type default null,
p_attribute11 in per_positions.attribute11%type default null,
p_attribute12 in per_positions.attribute12%type default null,
p_attribute13 in per_positions.attribute13%type default null,
p_attribute14 in per_positions.attribute14%type default null,
p_attribute15 in per_positions.attribute15%type default null,
p_attribute16 in per_positions.attribute16%type default null,
p_attribute17 in per_positions.attribute17%type default null,
p_attribute18 in per_positions.attribute18%type default null,
p_attribute19 in per_positions.attribute19%type default null,
p_attribute20 in per_positions.attribute20%type default null,
p_status in per_positions.status%type default null,
p_position_data in out per_positions%rowtype ) is
l_proc varchar2(30):='conv_to_position_rg';
copy_field_value( p_source_field => p_program_update_date,
p_target_field => p_position_data.program_update_date);
p_program_update_date => p_position_h_v.program_update_date ,
p_attribute_category => p_position_h_v.attribute_category ,
p_attribute1 => p_position_h_v.attribute1 ,
p_attribute2 => p_position_h_v.attribute2 ,
p_attribute3 => p_position_h_v.attribute3 ,
p_attribute4 => p_position_h_v.attribute4 ,
p_attribute5 => p_position_h_v.attribute5 ,
p_attribute6 => p_position_h_v.attribute6 ,
p_attribute7 => p_position_h_v.attribute7 ,
p_attribute8 => p_position_h_v.attribute8 ,
p_attribute9 => p_position_h_v.attribute9 ,
p_attribute10 => p_position_h_v.attribute10 ,
p_attribute11 => p_position_h_v.attribute11 ,
p_attribute12 => p_position_h_v.attribute12 ,
p_attribute13 => p_position_h_v.attribute13 ,
p_attribute14 => p_position_h_v.attribute14 ,
p_attribute15 => p_position_h_v.attribute15 ,
p_attribute16 => p_position_h_v.attribute16 ,
p_attribute17 => p_position_h_v.attribute17 ,
p_attribute18 => p_position_h_v.attribute18 ,
p_attribute19 => p_position_h_v.attribute19 ,
p_attribute20 => p_position_h_v.attribute20 ,
p_status => p_position_h_v.status ,
p_position_data => l_position_data
);
p_history_data.information126 := to_char(p_position_data.program_update_date, g_hist_date_format);
p_position_data.program_update_date := to_date(p_history_data.information126, g_hist_date_format);
p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
p_information1 in hr_all_positions_f.information1%TYPE default NULL,
p_information2 in hr_all_positions_f.information2%TYPE default NULL,
p_information3 in hr_all_positions_f.information3%TYPE default NULL,
p_information4 in hr_all_positions_f.information4%TYPE default NULL,
p_information5 in hr_all_positions_f.information5%TYPE default NULL,
p_information6 in hr_all_positions_f.information6%TYPE default NULL,
p_information7 in hr_all_positions_f.information7%TYPE default NULL,
p_information8 in hr_all_positions_f.information8%TYPE default NULL,
p_information9 in hr_all_positions_f.information9%TYPE default NULL,
p_information10 in hr_all_positions_f.information10%TYPE default NULL,
p_information11 in hr_all_positions_f.information11%TYPE default NULL,
p_information12 in hr_all_positions_f.information12%TYPE default NULL,
p_information13 in hr_all_positions_f.information13%TYPE default NULL,
p_information14 in hr_all_positions_f.information14%TYPE default NULL,
p_information15 in hr_all_positions_f.information15%TYPE default NULL,
p_information16 in hr_all_positions_f.information16%TYPE default NULL,
p_information17 in hr_all_positions_f.information17%TYPE default NULL,
p_information18 in hr_all_positions_f.information18%TYPE default NULL,
p_information19 in hr_all_positions_f.information19%TYPE default NULL,
p_information20 in hr_all_positions_f.information20%TYPE default NULL,
p_information21 in hr_all_positions_f.information21%TYPE default NULL,
p_information22 in hr_all_positions_f.information22%TYPE default NULL,
p_information23 in hr_all_positions_f.information23%TYPE default NULL,
p_information24 in hr_all_positions_f.information24%TYPE default NULL,
p_information25 in hr_all_positions_f.information25%TYPE default NULL,
p_information26 in hr_all_positions_f.information26%TYPE default NULL,
p_information27 in hr_all_positions_f.information27%TYPE default NULL,
p_information28 in hr_all_positions_f.information28%TYPE default NULL,
p_information29 in hr_all_positions_f.information29%TYPE default NULL,
p_information30 in hr_all_positions_f.information30%TYPE default NULL,
p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,
p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,
p_position_data in out nocopy hr_all_positions_f%rowtype ) is
l_proc varchar2(30):='conv_to_position_rg';
copy_field_value( p_source_field => p_update_source_cd,
p_target_field => p_position_data.update_source_cd);
copy_field_value( p_source_field => p_program_update_date,
p_target_field => p_position_data.program_update_date);
p_update_source_cd => p_position_h_v.update_source_cd,
p_works_council_approval_flag => p_position_h_v.works_council_approval_flag,
p_work_period_type_cd => p_position_h_v.work_period_type_cd,
p_work_term_end_day_cd => p_position_h_v.work_term_end_day_cd,
p_work_term_end_month_cd => p_position_h_v.work_term_end_month_cd,
p_current_job_prop_end_date => p_position_h_v.current_job_prop_end_date,
p_current_org_prop_end_date => p_position_h_v.current_org_prop_end_date,
p_proposed_date_for_layoff => p_position_h_v.proposed_date_for_layoff,
p_proposed_fte_for_layoff => p_position_h_v.proposed_fte_for_layoff,
p_status => p_position_h_v.status,
p_business_group_id => p_position_h_v.business_group_id,
p_request_id => p_position_h_v.request_id,
p_program_application_id => p_position_h_v.program_application_id,
p_program_id => p_position_h_v.program_id,
p_program_update_date => p_position_h_v.program_update_date,
p_attribute_category => p_position_h_v.attribute_category,
p_attribute1 => p_position_h_v.attribute1,
p_attribute2 => p_position_h_v.attribute2,
p_attribute3 => p_position_h_v.attribute3,
p_attribute4 => p_position_h_v.attribute4,
p_attribute5 => p_position_h_v.attribute5,
p_attribute6 => p_position_h_v.attribute6,
p_attribute7 => p_position_h_v.attribute7,
p_attribute8 => p_position_h_v.attribute8,
p_attribute9 => p_position_h_v.attribute9,
p_attribute10 => p_position_h_v.attribute10,
p_attribute11 => p_position_h_v.attribute11,
p_attribute12 => p_position_h_v.attribute12,
p_attribute13 => p_position_h_v.attribute13,
p_attribute14 => p_position_h_v.attribute14,
p_attribute15 => p_position_h_v.attribute15,
p_attribute16 => p_position_h_v.attribute16,
p_attribute17 => p_position_h_v.attribute17,
p_attribute18 => p_position_h_v.attribute18,
p_attribute19 => p_position_h_v.attribute19,
p_attribute20 => p_position_h_v.attribute20,
p_attribute21 => p_position_h_v.attribute21,
p_attribute22 => p_position_h_v.attribute22,
p_attribute23 => p_position_h_v.attribute23,
p_attribute24 => p_position_h_v.attribute24,
p_attribute25 => p_position_h_v.attribute25,
p_attribute26 => p_position_h_v.attribute26,
p_attribute27 => p_position_h_v.attribute27,
p_attribute28 => p_position_h_v.attribute28,
p_attribute29 => p_position_h_v.attribute29,
p_attribute30 => p_position_h_v.attribute30,
p_information_category => p_position_h_v.information_category,
p_information1 => p_position_h_v.information1,
p_information2 => p_position_h_v.information2,
p_information3 => p_position_h_v.information3,
p_information4 => p_position_h_v.information4,
p_information5 => p_position_h_v.information5,
p_information6 => p_position_h_v.information6,
p_information7 => p_position_h_v.information7,
p_information8 => p_position_h_v.information8,
p_information9 => p_position_h_v.information9,
p_information10 => p_position_h_v.information10,
p_information11 => p_position_h_v.information11,
p_information12 => p_position_h_v.information12,
p_information13 => p_position_h_v.information13,
p_information14 => p_position_h_v.information14,
p_information15 => p_position_h_v.information15,
p_information16 => p_position_h_v.information16,
p_information17 => p_position_h_v.information17,
p_information18 => p_position_h_v.information18,
p_information19 => p_position_h_v.information19,
p_information20 => p_position_h_v.information20,
p_information21 => p_position_h_v.information21,
p_information22 => p_position_h_v.information22,
p_information23 => p_position_h_v.information23,
p_information24 => p_position_h_v.information24,
p_information25 => p_position_h_v.information25,
p_information26 => p_position_h_v.information26,
p_information27 => p_position_h_v.information27,
p_information28 => p_position_h_v.information28,
p_information29 => p_position_h_v.information29,
p_information30 => p_position_h_v.information30,
p_position_data => l_position_data
);
p_history_data.information54 := p_position_data.update_source_cd;
p_history_data.information126 := FND_DATE.DATE_TO_CANONICAL(p_position_data.program_update_date);
p_position_data.update_source_cd := p_history_data.information54;
p_position_data.program_update_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information126);