6: g_format_name_cached hr_name_formats.format_name%TYPE := null;
7: g_format_mask_cached hr_name_formats.format_mask%TYPE := null;
8: g_user_format_choice_cached hr_name_formats.user_format_choice%TYPE := null;
9: g_legislation_code_cached hr_name_formats.legislation_code%TYPE := null;
10: g_business_group_id_cached per_all_people_f.business_group_id%TYPE := null;
11: --
12: --
13: -- ----------------------------------------------------------------------------
14: -- |------------------------< get_token_position >----------------------------|
325: ,ORDER_NAME
326: ,LOCAL_NAME
327: ,GLOBAL_NAME
328: ,BUSINESS_GROUP_ID
329: from per_all_people_f
330: where rowid = p_rowid;
331: --
332: begin
333: --
391: --
392: cursor csr_get_person_details is
393: select rowid, business_group_id, full_name, order_name
394: ,local_name, global_name
395: from per_all_people_f
396: where person_id = p_person_id
397: and p_effective_date between effective_start_date and effective_end_date;
398:
399: l_person_rec csr_get_person_details%ROWTYPE;
517: l_legislation varchar2(30);
518: --
519: cursor csr_get_leg is
520: select bg.legislation_code
521: from per_all_people_f peo
522: ,per_business_groups_perf bg
523: where peo.person_id = p_person_id
524: and p_effective_date between peo.effective_start_date and peo.effective_end_date
525: and peo.business_group_id = bg.business_group_id;
565: -- , suffix
566: -- , hr_general.decode_lookup('TITLE',title) title
567: -- , full_name
568: -- , known_as
569: -- from per_all_people_f
570: -- where person_id = p_person_id
571: -- and trunc(nvl(p_effective_date,sysdate)) between effective_start_date
572: -- and effective_end_date;
573: --
831: -- ----------------------------------------------------------------------------
832: --
833: procedure derive_person_names
834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
832: --
833: procedure derive_person_names
834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
833: procedure derive_person_names
834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
914: p_duplicate_flag OUT NOCOPY VARCHAR2
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
914: p_duplicate_flag OUT NOCOPY VARCHAR2
915: ) is
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
914: p_duplicate_flag OUT NOCOPY VARCHAR2
915: ) is
916: --
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
914: p_duplicate_flag OUT NOCOPY VARCHAR2
915: ) is
916: --
917: l_proc CONSTANT varchar2(80) := g_package||'get_derive_person_names';
1263: SELECT 'Y'
1264: INTO l_status
1265: FROM sys.dual
1266: WHERE EXISTS (SELECT /*+ no_expand */ 'Duplicate Person Exists'
1267: FROM per_all_people_f pp
1268: WHERE /* Perform case insensitive check on last name */
1269: /* trying to use the index on last name */
1270: upper(pp.last_name) = upper(p_last_name)
1271: AND ( pp.last_name like l_ul_check
1698: --
1699: --
1700: procedure derive_person_names
1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1699: --
1700: procedure derive_person_names
1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1700: procedure derive_person_names
1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1780: ) is
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1780: ) is
1781: --
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1780: ) is
1781: --
1782: l_proc CONSTANT varchar2(80) := g_package||'get_derive_person_names';
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1780: ) is
1781: --
1782: l_proc CONSTANT varchar2(80) := g_package||'get_derive_person_names';
1783: --