20: -- ---------------------------------------------------------------------------
21: --
22: procedure set_security_group_id
23: (
24: p_person_id in per_all_people_f.person_id%TYPE
25: ,p_associated_column1 in varchar2 default null
26: ) as
27: --
28: -- Declare cursor
28: -- Declare cursor
29: --
30: -- Bug Number : 3009266.
31: -- Description : To let Phones row handler access person row hanlder for all persons
32: -- replaced per_people_f with per_all_people_f in this cursor.
33: --
34: cursor csr_sec_grp is
35: select hoi.org_information14, hoi.org_information9
36: from hr_organization_information hoi
33: --
34: cursor csr_sec_grp is
35: select hoi.org_information14, hoi.org_information9
36: from hr_organization_information hoi
37: , per_all_people_f per
38: where per.person_id = p_person_id
39: and hoi.organization_id = per.business_group_id
40: and hoi.org_information_context||'' = 'Business Group Information';
41: --
113: -- Access Status:
114: -- Internal Table Handler Use Only.
115: --
116: function return_system_person_type
117: (p_person_type_id in per_all_people_f.person_type_id%TYPE
118: ,p_business_group_id in per_all_people_f.business_group_id%TYPE)
119: return varchar2 is
120: --
121: l_person_type varchar2(30);
114: -- Internal Table Handler Use Only.
115: --
116: function return_system_person_type
117: (p_person_type_id in per_all_people_f.person_type_id%TYPE
118: ,p_business_group_id in per_all_people_f.business_group_id%TYPE)
119: return varchar2 is
120: --
121: l_person_type varchar2(30);
122: l_proc varchar2(72) := g_package||'return_system_person_type';
180: return g_previous_sys_per_type;
181: exception
182: when app_exception.application_exception then
183: if hr_multi_message.exception_add
184: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
185: ) then
186: if g_debug then
187: hr_utility.set_location(' Leaving:'||l_proc, 6);
188: end if;
248: -- Access Status:
249: -- Internal Table Handler Use Only.
250: --
251: procedure set_current_flags
252: (p_person_id in per_all_people_f.person_id%TYPE
253: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
254: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
255: ,p_current_employee_flag out nocopy per_all_people_f.current_employee_flag%TYPE
256: ,p_current_applicant_flag out nocopy per_all_people_f.current_applicant_flag%TYPE
249: -- Internal Table Handler Use Only.
250: --
251: procedure set_current_flags
252: (p_person_id in per_all_people_f.person_id%TYPE
253: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
254: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
255: ,p_current_employee_flag out nocopy per_all_people_f.current_employee_flag%TYPE
256: ,p_current_applicant_flag out nocopy per_all_people_f.current_applicant_flag%TYPE
257: ,p_current_emp_or_apl_flag out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
250: --
251: procedure set_current_flags
252: (p_person_id in per_all_people_f.person_id%TYPE
253: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
254: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
255: ,p_current_employee_flag out nocopy per_all_people_f.current_employee_flag%TYPE
256: ,p_current_applicant_flag out nocopy per_all_people_f.current_applicant_flag%TYPE
257: ,p_current_emp_or_apl_flag out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
258: ,p_effective_date in date
251: procedure set_current_flags
252: (p_person_id in per_all_people_f.person_id%TYPE
253: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
254: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
255: ,p_current_employee_flag out nocopy per_all_people_f.current_employee_flag%TYPE
256: ,p_current_applicant_flag out nocopy per_all_people_f.current_applicant_flag%TYPE
257: ,p_current_emp_or_apl_flag out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
258: ,p_effective_date in date
259: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
252: (p_person_id in per_all_people_f.person_id%TYPE
253: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
254: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
255: ,p_current_employee_flag out nocopy per_all_people_f.current_employee_flag%TYPE
256: ,p_current_applicant_flag out nocopy per_all_people_f.current_applicant_flag%TYPE
257: ,p_current_emp_or_apl_flag out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
258: ,p_effective_date in date
259: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
260: --
253: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
254: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
255: ,p_current_employee_flag out nocopy per_all_people_f.current_employee_flag%TYPE
256: ,p_current_applicant_flag out nocopy per_all_people_f.current_applicant_flag%TYPE
257: ,p_current_emp_or_apl_flag out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
258: ,p_effective_date in date
259: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
260: --
261: l_proc varchar2(72) := g_package||'set_current_flags';
255: ,p_current_employee_flag out nocopy per_all_people_f.current_employee_flag%TYPE
256: ,p_current_applicant_flag out nocopy per_all_people_f.current_applicant_flag%TYPE
257: ,p_current_emp_or_apl_flag out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
258: ,p_effective_date in date
259: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
260: --
261: l_proc varchar2(72) := g_package||'set_current_flags';
262: l_api_updating boolean;
263: l_system_person_type varchar2(30);
470: -- Access Status:
471: -- Internal Table Handler Use Only.
472: --
473: procedure chk_person_type_id
474: (p_person_id in per_all_people_f.person_id%TYPE
475: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
476: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
477: ,p_old_person_type_id in per_all_people_f.person_type_id%TYPE
478: ,p_current_employee_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
471: -- Internal Table Handler Use Only.
472: --
473: procedure chk_person_type_id
474: (p_person_id in per_all_people_f.person_id%TYPE
475: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
476: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
477: ,p_old_person_type_id in per_all_people_f.person_type_id%TYPE
478: ,p_current_employee_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
479: ,p_current_applicant_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
472: --
473: procedure chk_person_type_id
474: (p_person_id in per_all_people_f.person_id%TYPE
475: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
476: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
477: ,p_old_person_type_id in per_all_people_f.person_type_id%TYPE
478: ,p_current_employee_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
479: ,p_current_applicant_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
480: ,p_current_emp_or_apl_flag in out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
473: procedure chk_person_type_id
474: (p_person_id in per_all_people_f.person_id%TYPE
475: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
476: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
477: ,p_old_person_type_id in per_all_people_f.person_type_id%TYPE
478: ,p_current_employee_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
479: ,p_current_applicant_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
480: ,p_current_emp_or_apl_flag in out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
481: ,p_effective_date in date
474: (p_person_id in per_all_people_f.person_id%TYPE
475: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
476: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
477: ,p_old_person_type_id in per_all_people_f.person_type_id%TYPE
478: ,p_current_employee_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
479: ,p_current_applicant_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
480: ,p_current_emp_or_apl_flag in out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
481: ,p_effective_date in date
482: ,p_validation_start_date in date
475: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
476: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
477: ,p_old_person_type_id in per_all_people_f.person_type_id%TYPE
478: ,p_current_employee_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
479: ,p_current_applicant_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
480: ,p_current_emp_or_apl_flag in out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
481: ,p_effective_date in date
482: ,p_validation_start_date in date
483: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
476: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
477: ,p_old_person_type_id in per_all_people_f.person_type_id%TYPE
478: ,p_current_employee_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
479: ,p_current_applicant_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
480: ,p_current_emp_or_apl_flag in out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
481: ,p_effective_date in date
482: ,p_validation_start_date in date
483: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
484: ,p_datetrack_mode in varchar2) is
479: ,p_current_applicant_flag in out nocopy per_all_people_f.current_employee_flag%TYPE
480: ,p_current_emp_or_apl_flag in out nocopy per_all_people_f.current_emp_or_apl_flag%TYPE
481: ,p_effective_date in date
482: ,p_validation_start_date in date
483: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
484: ,p_datetrack_mode in varchar2) is
485: --
486: l_exists varchar2(1);
487: l_new_system_person_type varchar2(30);
497: l_discard_number number;
498: l_original_sys_type per_person_types.system_person_type%type;
499: --
500: cursor
501: csr_person_type(l_person_type_id in per_all_people_f.person_type_id%type) is
502: select pet.system_person_type,
503: pet.business_group_id,
504: pet.active_flag
505: from per_person_types pet
507: --
508: /*
509: cursor csr_system_type(l_start_date in date) is
510: select pet.system_person_type
511: from per_all_people_f per,
512: per_person_types pet
513: where per.person_id = p_person_id
514: and l_start_date between per.effective_start_date
515: and per.effective_end_date
722: end if;
723: exception
724: when app_exception.application_exception then
725: if hr_multi_message.exception_add
726: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
727: ) then
728: if g_debug then
729: hr_utility.set_location(' Leaving:'||l_proc, 14);
730: end if;
784: -- Access Status:
785: -- Internal Table Handler Use Only.
786: --
787: procedure chk_date_of_birth
788: (p_person_id in per_all_people_f.person_id%TYPE
789: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
790: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
791: ,p_start_date in date
792: ,p_date_of_birth in date
785: -- Internal Table Handler Use Only.
786: --
787: procedure chk_date_of_birth
788: (p_person_id in per_all_people_f.person_id%TYPE
789: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
790: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
791: ,p_start_date in date
792: ,p_date_of_birth in date
793: ,p_dob_null_warning out nocopy boolean
786: --
787: procedure chk_date_of_birth
788: (p_person_id in per_all_people_f.person_id%TYPE
789: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
790: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
791: ,p_start_date in date
792: ,p_date_of_birth in date
793: ,p_dob_null_warning out nocopy boolean
794: ,p_effective_date in date
793: ,p_dob_null_warning out nocopy boolean
794: ,p_effective_date in date
795: ,p_validation_start_date in date
796: ,p_validation_end_date in date
797: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
798: --
799: l_exists varchar2(1);
800: l_proc varchar2(72) := g_package||'chk_date_of_birth';
801: l_api_updating boolean;
826: --
827: -- Check mandatory parameters have been set
828: --
829: if hr_multi_message.no_exclusive_error
830: (p_check_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
831: )
832: then
833: hr_api.mandatory_arg_error
834: (p_api_name => l_proc
989: exception
990: when app_exception.application_exception then
991: If not l_dob_st then
992: if hr_multi_message.exception_add
993: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
994: ) then
995: if g_debug then
996: hr_utility.set_location(' Leaving:'||l_proc, 9);
997: end if;
998: raise;
999: end if;
1000: Else
1001: if hr_multi_message.exception_add
1002: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1003: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
1004: ) then
1005: if g_debug then
1006: hr_utility.set_location(' Leaving:'||l_proc, 10);
999: end if;
1000: Else
1001: if hr_multi_message.exception_add
1002: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1003: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
1004: ) then
1005: if g_debug then
1006: hr_utility.set_location(' Leaving:'||l_proc, 10);
1007: end if;
1051: -- Access Status:
1052: -- Internal Table Handler Use Only.
1053: --
1054: procedure chk_marital_status
1055: (p_person_id in per_all_people_f.person_id%TYPE
1056: ,p_marital_status in per_all_people_f.marital_status%TYPE
1057: ,p_effective_date in date
1058: ,p_validation_start_date in date
1059: ,p_validation_end_date in date
1052: -- Internal Table Handler Use Only.
1053: --
1054: procedure chk_marital_status
1055: (p_person_id in per_all_people_f.person_id%TYPE
1056: ,p_marital_status in per_all_people_f.marital_status%TYPE
1057: ,p_effective_date in date
1058: ,p_validation_start_date in date
1059: ,p_validation_end_date in date
1060: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1056: ,p_marital_status in per_all_people_f.marital_status%TYPE
1057: ,p_effective_date in date
1058: ,p_validation_start_date in date
1059: ,p_validation_end_date in date
1060: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1061: )
1062: is
1063: --
1064: l_exists varchar2(1);
1146: end if;
1147: exception
1148: when app_exception.application_exception then
1149: if hr_multi_message.exception_add
1150: (p_associated_column1 => 'PER_ALL_PEOPLE_F.MARITAL_STATUS'
1151: ) then
1152: if g_debug then
1153: hr_utility.set_location(' Leaving:'||l_proc, 80);
1154: end if;
1186: -- Access Status:
1187: -- Internal Table Handler Use Only.
1188: --
1189: procedure chk_party_id
1190: (p_person_id in per_all_people_f.person_id%TYPE
1191: ,p_party_id in number
1192: ,p_effective_date in date
1193: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1194: )
1189: procedure chk_party_id
1190: (p_person_id in per_all_people_f.person_id%TYPE
1191: ,p_party_id in number
1192: ,p_effective_date in date
1193: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1194: )
1195: is
1196: --
1197: l_exists varchar2(1);
1270: end if;
1271: exception
1272: when app_exception.application_exception then
1273: if hr_multi_message.exception_add
1274: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PARTY_ID'
1275: ) then
1276: if g_debug then
1277: hr_utility.set_location(' Leaving:'||l_proc, 80);
1278: end if;
1322: -- Access Status:
1323: -- Internal Table Handler Use Only.
1324: --
1325: procedure chk_nationality
1326: (p_person_id in per_all_people_f.person_id%TYPE
1327: ,p_nationality in per_all_people_f.nationality%TYPE
1328: ,p_effective_date in date
1329: ,p_validation_start_date in date
1330: ,p_validation_end_date in date
1323: -- Internal Table Handler Use Only.
1324: --
1325: procedure chk_nationality
1326: (p_person_id in per_all_people_f.person_id%TYPE
1327: ,p_nationality in per_all_people_f.nationality%TYPE
1328: ,p_effective_date in date
1329: ,p_validation_start_date in date
1330: ,p_validation_end_date in date
1331: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1327: ,p_nationality in per_all_people_f.nationality%TYPE
1328: ,p_effective_date in date
1329: ,p_validation_start_date in date
1330: ,p_validation_end_date in date
1331: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1332: )
1333: is
1334: --
1335: l_exists varchar2(1);
1413: end if;
1414: exception
1415: when app_exception.application_exception then
1416: if hr_multi_message.exception_add
1417: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONALITY'
1418: ) then
1419: if g_debug then
1420: hr_utility.set_location(' Leaving:'||l_proc, 70);
1421: end if;
1429: -- start for bug 6241572, a new overloaded procedure is created with
1430: -- p_region_of_birth, p_country_of_birth and p_nationality parameters.
1431:
1432: procedure chk_national_identifier
1433: (p_person_id in per_all_people_f.person_id%TYPE
1434: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1435: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1436: ,p_date_of_birth in date
1437: ,p_sex in per_all_people_f.sex%TYPE
1430: -- p_region_of_birth, p_country_of_birth and p_nationality parameters.
1431:
1432: procedure chk_national_identifier
1433: (p_person_id in per_all_people_f.person_id%TYPE
1434: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1435: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1436: ,p_date_of_birth in date
1437: ,p_sex in per_all_people_f.sex%TYPE
1438: ,p_effective_date in date
1431:
1432: procedure chk_national_identifier
1433: (p_person_id in per_all_people_f.person_id%TYPE
1434: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1435: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1436: ,p_date_of_birth in date
1437: ,p_sex in per_all_people_f.sex%TYPE
1438: ,p_effective_date in date
1439: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1433: (p_person_id in per_all_people_f.person_id%TYPE
1434: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1435: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1436: ,p_date_of_birth in date
1437: ,p_sex in per_all_people_f.sex%TYPE
1438: ,p_effective_date in date
1439: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1440: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1441: ,p_person_type_id in per_all_people_f.person_type_id%TYPE) is
1435: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1436: ,p_date_of_birth in date
1437: ,p_sex in per_all_people_f.sex%TYPE
1438: ,p_effective_date in date
1439: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1440: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1441: ,p_person_type_id in per_all_people_f.person_type_id%TYPE) is
1442:
1443: -- declaring those variable which are not present in the previous
1437: ,p_sex in per_all_people_f.sex%TYPE
1438: ,p_effective_date in date
1439: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1440: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1441: ,p_person_type_id in per_all_people_f.person_type_id%TYPE) is
1442:
1443: -- declaring those variable which are not present in the previous
1444: -- chk_national_identifier
1445:
1442:
1443: -- declaring those variable which are not present in the previous
1444: -- chk_national_identifier
1445:
1446: l_region_of_birth per_all_people_f.region_of_birth%TYPE;
1447: l_country_of_birth per_all_people_f.country_of_birth%TYPE;
1448: l_nationality per_all_people_f.nationality%TYPE;
1449:
1450: begin
1443: -- declaring those variable which are not present in the previous
1444: -- chk_national_identifier
1445:
1446: l_region_of_birth per_all_people_f.region_of_birth%TYPE;
1447: l_country_of_birth per_all_people_f.country_of_birth%TYPE;
1448: l_nationality per_all_people_f.nationality%TYPE;
1449:
1450: begin
1451: --calling chk_nation_identifier
1444: -- chk_national_identifier
1445:
1446: l_region_of_birth per_all_people_f.region_of_birth%TYPE;
1447: l_country_of_birth per_all_people_f.country_of_birth%TYPE;
1448: l_nationality per_all_people_f.nationality%TYPE;
1449:
1450: begin
1451: --calling chk_nation_identifier
1452:
1500: -- Access Status:
1501: -- Internal Table Handler Use Only.
1502: --
1503: procedure chk_national_identifier
1504: (p_person_id in per_all_people_f.person_id%TYPE
1505: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1506: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1507: ,p_date_of_birth in date
1508: ,p_sex in per_all_people_f.sex%TYPE
1501: -- Internal Table Handler Use Only.
1502: --
1503: procedure chk_national_identifier
1504: (p_person_id in per_all_people_f.person_id%TYPE
1505: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1506: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1507: ,p_date_of_birth in date
1508: ,p_sex in per_all_people_f.sex%TYPE
1509: ,p_effective_date in date
1502: --
1503: procedure chk_national_identifier
1504: (p_person_id in per_all_people_f.person_id%TYPE
1505: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1506: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1507: ,p_date_of_birth in date
1508: ,p_sex in per_all_people_f.sex%TYPE
1509: ,p_effective_date in date
1510: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1504: (p_person_id in per_all_people_f.person_id%TYPE
1505: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1506: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1507: ,p_date_of_birth in date
1508: ,p_sex in per_all_people_f.sex%TYPE
1509: ,p_effective_date in date
1510: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1511: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1512: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1506: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1507: ,p_date_of_birth in date
1508: ,p_sex in per_all_people_f.sex%TYPE
1509: ,p_effective_date in date
1510: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1511: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1512: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1513:
1514: --added new parameter for bug 6241572
1508: ,p_sex in per_all_people_f.sex%TYPE
1509: ,p_effective_date in date
1510: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1511: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1512: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1513:
1514: --added new parameter for bug 6241572
1515: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
1516: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
1511: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1512: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1513:
1514: --added new parameter for bug 6241572
1515: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
1516: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
1517: ,p_nationality in per_all_people_f.nationality%TYPE) is
1518:
1519: --
1512: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1513:
1514: --added new parameter for bug 6241572
1515: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
1516: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
1517: ,p_nationality in per_all_people_f.nationality%TYPE) is
1518:
1519: --
1520: l_exists varchar2(1);
1513:
1514: --added new parameter for bug 6241572
1515: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
1516: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
1517: ,p_nationality in per_all_people_f.nationality%TYPE) is
1518:
1519: --
1520: l_exists varchar2(1);
1521: l_proc varchar2(72) := g_package||'chk_national_identifier';
1615: end if;
1616: exception
1617: when app_exception.application_exception then
1618: if hr_multi_message.exception_add
1619: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1620: ) then
1621: if g_debug then
1622: hr_utility.set_location(' Leaving:'||l_proc, 4);
1623: end if;
1683: -- Access Status:
1684: -- Internal Table Handler Use Only.
1685: --
1686: procedure chk_employee_number
1687: (p_person_id in per_all_people_f.person_id%TYPE
1688: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1689: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1690: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1691: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1684: -- Internal Table Handler Use Only.
1685: --
1686: procedure chk_employee_number
1687: (p_person_id in per_all_people_f.person_id%TYPE
1688: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1689: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1690: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1691: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1692: ,p_effective_date in date
1685: --
1686: procedure chk_employee_number
1687: (p_person_id in per_all_people_f.person_id%TYPE
1688: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1689: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1690: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1691: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1692: ,p_effective_date in date
1693: ,p_object_version_number in per_all_people_f.object_version_number%TYPE)
1686: procedure chk_employee_number
1687: (p_person_id in per_all_people_f.person_id%TYPE
1688: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1689: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1690: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1691: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1692: ,p_effective_date in date
1693: ,p_object_version_number in per_all_people_f.object_version_number%TYPE)
1694: is
1687: (p_person_id in per_all_people_f.person_id%TYPE
1688: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1689: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1690: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1691: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1692: ,p_effective_date in date
1693: ,p_object_version_number in per_all_people_f.object_version_number%TYPE)
1694: is
1695: begin
1689: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1690: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1691: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1692: ,p_effective_date in date
1693: ,p_object_version_number in per_all_people_f.object_version_number%TYPE)
1694: is
1695: begin
1696: chk_employee_number
1697: (p_person_id => p_person_id
1709: --
1710: -- Overloaded
1711: --
1712: procedure chk_employee_number
1713: (p_person_id in per_all_people_f.person_id%TYPE
1714: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1715: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1716: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1717: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1710: -- Overloaded
1711: --
1712: procedure chk_employee_number
1713: (p_person_id in per_all_people_f.person_id%TYPE
1714: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1715: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1716: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1717: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1718: ,p_effective_date in date
1711: --
1712: procedure chk_employee_number
1713: (p_person_id in per_all_people_f.person_id%TYPE
1714: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1715: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1716: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1717: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1718: ,p_effective_date in date
1719: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1712: procedure chk_employee_number
1713: (p_person_id in per_all_people_f.person_id%TYPE
1714: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1715: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1716: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1717: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1718: ,p_effective_date in date
1719: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1720: ,p_party_id in per_all_people_f.party_id%TYPE
1713: (p_person_id in per_all_people_f.person_id%TYPE
1714: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1715: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1716: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1717: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1718: ,p_effective_date in date
1719: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1720: ,p_party_id in per_all_people_f.party_id%TYPE
1721: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1715: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1716: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1717: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1718: ,p_effective_date in date
1719: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1720: ,p_party_id in per_all_people_f.party_id%TYPE
1721: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1722: ,p_start_date in per_periods_of_service.date_start%TYPE)
1723: is
1716: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1717: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1718: ,p_effective_date in date
1719: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1720: ,p_party_id in per_all_people_f.party_id%TYPE
1721: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1722: ,p_start_date in per_periods_of_service.date_start%TYPE)
1723: is
1724: --
1717: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1718: ,p_effective_date in date
1719: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1720: ,p_party_id in per_all_people_f.party_id%TYPE
1721: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1722: ,p_start_date in per_periods_of_service.date_start%TYPE)
1723: is
1724: --
1725: l_exists varchar2(1);
1724: --
1725: l_exists varchar2(1);
1726: l_proc varchar2(72) := g_package||'chk_employee_number';
1727: l_api_updating boolean;
1728: l_applicant_number per_all_people_f.applicant_number%TYPE;
1729: l_npw_number per_all_people_f.npw_number%TYPE;
1730: l_gen_method varchar2(1);
1731: l_emp_ni boolean := false;
1732: --
1725: l_exists varchar2(1);
1726: l_proc varchar2(72) := g_package||'chk_employee_number';
1727: l_api_updating boolean;
1728: l_applicant_number per_all_people_f.applicant_number%TYPE;
1729: l_npw_number per_all_people_f.npw_number%TYPE;
1730: l_gen_method varchar2(1);
1731: l_emp_ni boolean := false;
1732: --
1733: cursor csr_gen_method is
1856: if g_debug then
1857: hr_utility.set_location('Entering:'|| l_proc, 10);
1858: end if;
1859: if hr_multi_message.no_exclusive_error
1860: (p_check_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1861: )
1862: then
1863: --
1864: -- Check mandatory parameters have been set
2098: -- if error is not because of national identifier
2099: if not l_emp_ni
2100: then
2101: if hr_multi_message.exception_add
2102: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2103: ) then
2104: if g_debug then
2105: hr_utility.set_location(' Leaving:'||l_proc, 150);
2106: end if;
2107: raise;
2108: end if;
2109: else
2110: if hr_multi_message.exception_add
2111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2113: ) then
2114: if g_debug then
2115: hr_utility.set_location(' Leaving:'||l_proc, 160);
2108: end if;
2109: else
2110: if hr_multi_message.exception_add
2111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2113: ) then
2114: if g_debug then
2115: hr_utility.set_location(' Leaving:'||l_proc, 160);
2116: end if;
2176: -- Access Status:
2177: -- Internal Development Use Only.
2178: --
2179: procedure chk_npw_number
2180: (p_person_id in per_all_people_f.person_id%TYPE
2181: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2182: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2183: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2184: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2177: -- Internal Development Use Only.
2178: --
2179: procedure chk_npw_number
2180: (p_person_id in per_all_people_f.person_id%TYPE
2181: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2182: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2183: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2184: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2185: ,p_effective_date in date
2178: --
2179: procedure chk_npw_number
2180: (p_person_id in per_all_people_f.person_id%TYPE
2181: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2182: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2183: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2184: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2185: ,p_effective_date in date
2186: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2179: procedure chk_npw_number
2180: (p_person_id in per_all_people_f.person_id%TYPE
2181: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2182: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2183: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2184: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2185: ,p_effective_date in date
2186: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2187: )
2180: (p_person_id in per_all_people_f.person_id%TYPE
2181: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2182: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2183: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2184: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2185: ,p_effective_date in date
2186: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2187: )
2188: is
2182: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2183: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2184: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2185: ,p_effective_date in date
2186: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2187: )
2188: is
2189: begin
2190: chk_npw_number
2201: );
2202: end chk_npw_number;
2203: --
2204: procedure chk_npw_number
2205: (p_person_id in per_all_people_f.person_id%TYPE
2206: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2207: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2208: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2209: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2202: end chk_npw_number;
2203: --
2204: procedure chk_npw_number
2205: (p_person_id in per_all_people_f.person_id%TYPE
2206: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2207: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2208: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2209: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2210: ,p_effective_date in date
2203: --
2204: procedure chk_npw_number
2205: (p_person_id in per_all_people_f.person_id%TYPE
2206: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2207: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2208: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2209: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2210: ,p_effective_date in date
2211: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2204: procedure chk_npw_number
2205: (p_person_id in per_all_people_f.person_id%TYPE
2206: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2207: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2208: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2209: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2210: ,p_effective_date in date
2211: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2212: ,p_party_id in per_all_people_f.party_id%TYPE
2205: (p_person_id in per_all_people_f.person_id%TYPE
2206: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2207: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2208: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2209: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2210: ,p_effective_date in date
2211: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2212: ,p_party_id in per_all_people_f.party_id%TYPE
2213: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
2207: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2208: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2209: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2210: ,p_effective_date in date
2211: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2212: ,p_party_id in per_all_people_f.party_id%TYPE
2213: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
2214: ,p_start_date in date
2215: )
2208: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2209: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2210: ,p_effective_date in date
2211: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2212: ,p_party_id in per_all_people_f.party_id%TYPE
2213: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
2214: ,p_start_date in date
2215: )
2216: is
2209: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2210: ,p_effective_date in date
2211: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2212: ,p_party_id in per_all_people_f.party_id%TYPE
2213: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
2214: ,p_start_date in date
2215: )
2216: is
2217: --
2217: --
2218: l_proc varchar2(72) := g_package||'chk_npw_number';
2219: l_exists varchar2(1);
2220: l_api_updating boolean;
2221: l_applicant_number per_all_people_f.applicant_number%TYPE;
2222: l_employee_number per_all_people_f.employee_number%TYPE;
2223: l_gen_method varchar2(1);
2224: l_npw_ni boolean := false;
2225: --
2218: l_proc varchar2(72) := g_package||'chk_npw_number';
2219: l_exists varchar2(1);
2220: l_api_updating boolean;
2221: l_applicant_number per_all_people_f.applicant_number%TYPE;
2222: l_employee_number per_all_people_f.employee_number%TYPE;
2223: l_gen_method varchar2(1);
2224: l_npw_ni boolean := false;
2225: --
2226: cursor csr_gen_method is
2261: if g_debug then
2262: hr_utility.set_location('Entering:'|| l_proc, 10);
2263: end if;
2264: if hr_multi_message.no_exclusive_error
2265: (p_check_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2266: )
2267: then
2268: --
2269: -- Check mandatory parameters have been set
2479: -- if error is not because of national identifier
2480: if not l_npw_ni
2481: then
2482: if hr_multi_message.exception_add
2483: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2484: ) then
2485: if g_debug then
2486: hr_utility.set_location(' Leaving:'||l_proc, 150);
2487: end if;
2488: raise;
2489: end if;
2490: else
2491: if hr_multi_message.exception_add
2492: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2493: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2494: ) then
2495: if g_debug then
2496: hr_utility.set_location(' Leaving:'||l_proc, 160);
2489: end if;
2490: else
2491: if hr_multi_message.exception_add
2492: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2493: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2494: ) then
2495: if g_debug then
2496: hr_utility.set_location(' Leaving:'||l_proc, 160);
2497: end if;
2540: -- Access Status:
2541: -- Internal Table Handler Use Only.
2542: --
2543: procedure chk_expense_check_send_to_addr
2544: (p_person_id in per_all_people_f.person_id%TYPE
2545: ,p_expense_check_send_to_addres in per_all_people_f.expense_check_send_to_address%TYPE
2546: ,p_effective_date in date
2547: ,p_validation_start_date in date
2548: ,p_validation_end_date in date
2541: -- Internal Table Handler Use Only.
2542: --
2543: procedure chk_expense_check_send_to_addr
2544: (p_person_id in per_all_people_f.person_id%TYPE
2545: ,p_expense_check_send_to_addres in per_all_people_f.expense_check_send_to_address%TYPE
2546: ,p_effective_date in date
2547: ,p_validation_start_date in date
2548: ,p_validation_end_date in date
2549: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2545: ,p_expense_check_send_to_addres in per_all_people_f.expense_check_send_to_address%TYPE
2546: ,p_effective_date in date
2547: ,p_validation_start_date in date
2548: ,p_validation_end_date in date
2549: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2550: )
2551: is
2552: --
2553: l_exists varchar2(1);
2644: end if;
2645: exception
2646: when app_exception.application_exception then
2647: if hr_multi_message.exception_add
2648: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS'
2649: ) then
2650: if g_debug then
2651: hr_utility.set_location(' Leaving:'||l_proc, 80);
2652: end if;
2720: -- Access Status:
2721: -- Internal Table Handler Use Only.
2722: --
2723: procedure chk_sex_title
2724: (p_person_id in per_all_people_f.person_id%TYPE
2725: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2726: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2727: ,p_title in per_all_people_f.title%TYPE
2728: ,p_sex in per_all_people_f.sex%TYPE
2721: -- Internal Table Handler Use Only.
2722: --
2723: procedure chk_sex_title
2724: (p_person_id in per_all_people_f.person_id%TYPE
2725: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2726: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2727: ,p_title in per_all_people_f.title%TYPE
2728: ,p_sex in per_all_people_f.sex%TYPE
2729: ,p_effective_date in date
2722: --
2723: procedure chk_sex_title
2724: (p_person_id in per_all_people_f.person_id%TYPE
2725: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2726: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2727: ,p_title in per_all_people_f.title%TYPE
2728: ,p_sex in per_all_people_f.sex%TYPE
2729: ,p_effective_date in date
2730: ,p_validation_start_date in date
2723: procedure chk_sex_title
2724: (p_person_id in per_all_people_f.person_id%TYPE
2725: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2726: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2727: ,p_title in per_all_people_f.title%TYPE
2728: ,p_sex in per_all_people_f.sex%TYPE
2729: ,p_effective_date in date
2730: ,p_validation_start_date in date
2731: ,p_validation_end_date in date
2724: (p_person_id in per_all_people_f.person_id%TYPE
2725: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2726: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2727: ,p_title in per_all_people_f.title%TYPE
2728: ,p_sex in per_all_people_f.sex%TYPE
2729: ,p_effective_date in date
2730: ,p_validation_start_date in date
2731: ,p_validation_end_date in date
2732: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2728: ,p_sex in per_all_people_f.sex%TYPE
2729: ,p_effective_date in date
2730: ,p_validation_start_date in date
2731: ,p_validation_end_date in date
2732: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2733: )
2734: is
2735: --
2736: l_exists varchar2(1);
2813: then
2814: --
2815: hr_utility.set_message(801, 'HR_7512_PER_TITLE_INVALID');
2816: hr_multi_message.add
2817: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2818: );
2819: --
2820: end if;
2821: if g_debug then
2843: then
2844: --
2845: hr_utility.set_message(801, 'HR_7511_PER_SEX_INVALID');
2846: hr_multi_message.add
2847: (p_associated_column1 => 'PER_ALL_PEOPLE_F.SEX'
2848: );
2849: --
2850: end if;
2851: if g_debug then
2862: p_title in ('MISS','MRS.','MS.') then
2863: -- Error: Values for Sex and Title are inconsistent.
2864: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2865: hr_multi_message.add
2866: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2867: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2868: );
2869: end if;
2870: if g_debug then
2863: -- Error: Values for Sex and Title are inconsistent.
2864: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2865: hr_multi_message.add
2866: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2867: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2868: );
2869: end if;
2870: if g_debug then
2871: hr_utility.set_location(l_proc, 70);
2875: p_title = 'MR.' then
2876: -- Error: Values for Sex and Title are inconsistent.
2877: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2878: hr_multi_message.add
2879: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2880: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2881: );
2882: end if;
2883: if g_debug then
2876: -- Error: Values for Sex and Title are inconsistent.
2877: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2878: hr_multi_message.add
2879: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2880: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2881: );
2882: end if;
2883: if g_debug then
2884: hr_utility.set_location(l_proc, 80);
2893: p_business_group_id),'EMP') <> 0 then
2894: -- Error: You must enter sex for an employee.
2895: hr_utility.set_message(801, 'HR_6524_EMP_MANDATORY_SEX');
2896: hr_multi_message.add
2897: (p_associated_column1 => 'PER_ALL_PEOPLE_F.SEX'
2898: );
2899: end if;
2900: if g_debug then
2901: hr_utility.set_location(l_proc, 90);
2940: -- Access Status:
2941: -- Internal Row Handler Use Only.
2942: --
2943: procedure chk_town_of_birth
2944: (p_person_id in per_all_people_f.person_id%TYPE,
2945: p_town_of_birth in per_all_people_f.town_of_birth%TYPE,
2946: p_effective_date in date,
2947: p_validation_start_date in date,
2948: p_validation_end_date in date,
2941: -- Internal Row Handler Use Only.
2942: --
2943: procedure chk_town_of_birth
2944: (p_person_id in per_all_people_f.person_id%TYPE,
2945: p_town_of_birth in per_all_people_f.town_of_birth%TYPE,
2946: p_effective_date in date,
2947: p_validation_start_date in date,
2948: p_validation_end_date in date,
2949: p_legislation_code in per_business_groups.legislation_code%TYPE) is
3009: end if;
3010: exception
3011: when app_exception.application_exception then
3012: if hr_multi_message.exception_add
3013: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TOWN_OF_BIRTH'
3014: ) then
3015: if g_debug then
3016: hr_utility.set_location(' Leaving:'||l_proc, 4);
3017: end if;
3054: -- Access Status:
3055: -- Internal Row Handler Use Only.
3056: --
3057: procedure chk_region_of_birth
3058: (p_person_id in per_all_people_f.person_id%TYPE,
3059: p_region_of_birth in per_all_people_f.region_of_birth%TYPE,
3060: p_effective_date in date,
3061: p_validation_start_date in date,
3062: p_validation_end_date in date,
3055: -- Internal Row Handler Use Only.
3056: --
3057: procedure chk_region_of_birth
3058: (p_person_id in per_all_people_f.person_id%TYPE,
3059: p_region_of_birth in per_all_people_f.region_of_birth%TYPE,
3060: p_effective_date in date,
3061: p_validation_start_date in date,
3062: p_validation_end_date in date,
3063: p_legislation_code in per_business_groups.legislation_code%TYPE) is
3123: end if;
3124: exception
3125: when app_exception.application_exception then
3126: if hr_multi_message.exception_add
3127: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGION_OF_BIRTH'
3128: ) then
3129: if g_debug then
3130: hr_utility.set_location(' Leaving:'||l_proc, 4);
3131: end if;
3161: -- Access Status:
3162: -- Internal Row Handler Use Only.
3163: --
3164: procedure chk_country_of_birth
3165: (p_person_id in per_all_people_f.person_id%TYPE,
3166: p_country_of_birth in per_all_people_f.country_of_birth%TYPE) is
3167: --
3168: l_exists varchar2(1);
3169: l_proc varchar2(72);
3162: -- Internal Row Handler Use Only.
3163: --
3164: procedure chk_country_of_birth
3165: (p_person_id in per_all_people_f.person_id%TYPE,
3166: p_country_of_birth in per_all_people_f.country_of_birth%TYPE) is
3167: --
3168: l_exists varchar2(1);
3169: l_proc varchar2(72);
3170: --
3213: end if;
3214: exception
3215: when app_exception.application_exception then
3216: if hr_multi_message.exception_add
3217: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH'
3218: ) then
3219: if g_debug then
3220: hr_utility.set_location(' Leaving:'||l_proc, 4);
3221: end if;
3260: -- Access Status:
3261: -- Internal Table Handler Use Only.
3262: --
3263: procedure chk_start_date
3264: (p_person_id in per_all_people_f.person_id%TYPE
3265: ,p_start_date in date
3266: ,p_effective_date in date
3267: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
3268: --
3263: procedure chk_start_date
3264: (p_person_id in per_all_people_f.person_id%TYPE
3265: ,p_start_date in date
3266: ,p_effective_date in date
3267: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
3268: --
3269: l_exists varchar2(1);
3270: l_proc varchar2(72) := g_package||'chk_start_date';
3271: l_api_updating boolean;
3274: -- Find the earliest effective start date for the person
3275: --
3276: cursor csr_chk_min_date is
3277: Select min(effective_start_date)
3278: from per_all_people_f
3279: where p_person_id = person_id;
3280: --
3281: begin
3282: if g_debug then
3346: end if;
3347: exception
3348: when app_exception.application_exception then
3349: if hr_multi_message.exception_add
3350: (p_associated_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
3351: ) then
3352: if g_debug then
3353: hr_utility.set_location(' Leaving:'||l_proc, 5);
3354: end if;
3404: -- Access Status:
3405: -- Internal Table Handler Use Only.
3406: --
3407: procedure chk_orig_and_start_dates
3408: (p_person_id in per_all_people_f.person_id%TYPE
3409: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3410: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3411: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3412: ,p_start_date in per_all_people_f.start_date%TYPE
3405: -- Internal Table Handler Use Only.
3406: --
3407: procedure chk_orig_and_start_dates
3408: (p_person_id in per_all_people_f.person_id%TYPE
3409: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3410: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3411: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3412: ,p_start_date in per_all_people_f.start_date%TYPE
3413: ,p_effective_date in date
3406: --
3407: procedure chk_orig_and_start_dates
3408: (p_person_id in per_all_people_f.person_id%TYPE
3409: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3410: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3411: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3412: ,p_start_date in per_all_people_f.start_date%TYPE
3413: ,p_effective_date in date
3414: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3407: procedure chk_orig_and_start_dates
3408: (p_person_id in per_all_people_f.person_id%TYPE
3409: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3410: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3411: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3412: ,p_start_date in per_all_people_f.start_date%TYPE
3413: ,p_effective_date in date
3414: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3415: ,p_orig_hire_warning out nocopy boolean
3408: (p_person_id in per_all_people_f.person_id%TYPE
3409: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3410: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3411: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3412: ,p_start_date in per_all_people_f.start_date%TYPE
3413: ,p_effective_date in date
3414: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3415: ,p_orig_hire_warning out nocopy boolean
3416: ) is
3410: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3411: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3412: ,p_start_date in per_all_people_f.start_date%TYPE
3413: ,p_effective_date in date
3414: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3415: ,p_orig_hire_warning out nocopy boolean
3416: ) is
3417: --
3418: l_proc varchar2(72) ;
3428:
3429: -- added for the bug 5402099
3430: l_earliest_date1 date;
3431: cursor original_date_of_hire_ppf is
3432: select original_date_of_hire from per_all_people_f where
3433: person_id=p_person_id and
3434: p_original_date_of_hire between effective_start_date and effective_end_date ;
3435: -- end of bug 5402099
3436: --
3453: if (p_person_id is null and
3454: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3455: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3456: hr_multi_message.add
3457: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3458: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
3459: );
3460: --
3461: elsif p_person_id is not null then
3454: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3455: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3456: hr_multi_message.add
3457: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3458: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
3459: );
3460: --
3461: elsif p_person_id is not null then
3462: open csr_earliest_date;
3482: */
3483: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3484: close csr_earliest_date;
3485: hr_multi_message.add
3486: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3487: );
3488: else
3489: close csr_earliest_date;
3490: end if;
3584: -- Access Status:
3585: -- Internal Table Handler Use Only.
3586: --
3587: procedure chk_GB_per_information
3588: (p_person_id in per_all_people_f.person_id%TYPE
3589: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3590: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3591: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3585: -- Internal Table Handler Use Only.
3586: --
3587: procedure chk_GB_per_information
3588: (p_person_id in per_all_people_f.person_id%TYPE
3589: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3590: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3591: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3586: --
3587: procedure chk_GB_per_information
3588: (p_person_id in per_all_people_f.person_id%TYPE
3589: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3590: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3591: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3587: procedure chk_GB_per_information
3588: (p_person_id in per_all_people_f.person_id%TYPE
3589: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3590: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3591: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3588: (p_person_id in per_all_people_f.person_id%TYPE
3589: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3590: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3591: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3589: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3590: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3591: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3590: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3591: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3591: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3592: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3593: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3594: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3595: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3596: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3597: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3598: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3599: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3600: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3601: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3602: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3603: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3604: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3605: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3606: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3607: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3608: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3616: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3609: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3616: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3617: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3610: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3616: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3617: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3618: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3611: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3616: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3617: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3618: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3619: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3612: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3616: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3617: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3618: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3619: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3620: ,p_effective_date in date
3613: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3616: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3617: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3618: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3619: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3620: ,p_effective_date in date
3621: ,p_validation_start_date in date
3614: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3616: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3617: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3618: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3619: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3620: ,p_effective_date in date
3621: ,p_validation_start_date in date
3622: ,p_validation_end_date in date
3615: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3616: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3617: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3618: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3619: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3620: ,p_effective_date in date
3621: ,p_validation_start_date in date
3622: ,p_validation_end_date in date
3623: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3619: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3620: ,p_effective_date in date
3621: ,p_validation_start_date in date
3622: ,p_validation_end_date in date
3623: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3624: )
3625: is
3626: --
3627: l_exists varchar2(1);
3629: l_proc varchar2(72) := g_package||'chk_GB_per_information';
3630: l_api_updating boolean;
3631: l_lookup_type varchar2(30);
3632: l_info_attribute number(2);
3633: l_per_information6 per_all_people_f.per_information6%TYPE;
3634: l_per_information7 per_all_people_f.per_information7%TYPE;
3635: l_per_information8 per_all_people_f.per_information8%TYPE;
3636: l_output varchar2(150);
3637: l_rgeflg varchar2(10);
3630: l_api_updating boolean;
3631: l_lookup_type varchar2(30);
3632: l_info_attribute number(2);
3633: l_per_information6 per_all_people_f.per_information6%TYPE;
3634: l_per_information7 per_all_people_f.per_information7%TYPE;
3635: l_per_information8 per_all_people_f.per_information8%TYPE;
3636: l_output varchar2(150);
3637: l_rgeflg varchar2(10);
3638: --
3631: l_lookup_type varchar2(30);
3632: l_info_attribute number(2);
3633: l_per_information6 per_all_people_f.per_information6%TYPE;
3634: l_per_information7 per_all_people_f.per_information7%TYPE;
3635: l_per_information8 per_all_people_f.per_information8%TYPE;
3636: l_output varchar2(150);
3637: l_rgeflg varchar2(10);
3638: --
3639: begin
4207: -- Access Status:
4208: -- Internal Table Handler Use Only.
4209: --
4210: procedure chk_US_per_information
4211: (p_person_id in per_all_people_f.person_id%TYPE
4212: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4213: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4214: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4208: -- Internal Table Handler Use Only.
4209: --
4210: procedure chk_US_per_information
4211: (p_person_id in per_all_people_f.person_id%TYPE
4212: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4213: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4214: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4209: --
4210: procedure chk_US_per_information
4211: (p_person_id in per_all_people_f.person_id%TYPE
4212: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4213: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4214: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4210: procedure chk_US_per_information
4211: (p_person_id in per_all_people_f.person_id%TYPE
4212: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4213: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4214: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4211: (p_person_id in per_all_people_f.person_id%TYPE
4212: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4213: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4214: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4212: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4213: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4214: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4213: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4214: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4214: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4215: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4216: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4217: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4218: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4219: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4220: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4221: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4222: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4223: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4224: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4225: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4226: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4227: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4228: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4229: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4230: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4231: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4239: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4232: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4239: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4240: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4233: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4239: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4240: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4241: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4234: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4239: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4240: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4241: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4242: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4235: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4239: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4240: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4241: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4242: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4243: ,p_effective_date in date
4236: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4239: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4240: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4241: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4242: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4243: ,p_effective_date in date
4244: ,p_validation_start_date in date
4237: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4239: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4240: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4241: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4242: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4243: ,p_effective_date in date
4244: ,p_validation_start_date in date
4245: ,p_validation_end_date in date
4238: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4239: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4240: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4241: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4242: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4243: ,p_effective_date in date
4244: ,p_validation_start_date in date
4245: ,p_validation_end_date in date
4246: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
4242: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4243: ,p_effective_date in date
4244: ,p_validation_start_date in date
4245: ,p_validation_end_date in date
4246: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
4247: ,p_api_updating in boolean
4248: )
4249: is
4250: --
4253: l_temp_error exception;
4254: l_proc varchar2(72) := g_package||'chk_US_per_information';
4255: l_lookup_type varchar2(30);
4256: l_info_attribute number(2);
4257: l_per_information3 per_all_people_f.per_information3%TYPE;
4258: l_output varchar2(150);
4259: l_rgeflg varchar2(10);
4260: --
4261: begin
4748: -- |------------------------
4749: -- ----------------------------------------------------------------------------
4750:
4751: procedure chk_JP_per_information
4752: (p_person_id in per_all_people_f.person_id%TYPE
4753: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4754: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4755: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4749: -- ----------------------------------------------------------------------------
4750:
4751: procedure chk_JP_per_information
4752: (p_person_id in per_all_people_f.person_id%TYPE
4753: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4754: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4755: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4750:
4751: procedure chk_JP_per_information
4752: (p_person_id in per_all_people_f.person_id%TYPE
4753: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4754: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4755: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4751: procedure chk_JP_per_information
4752: (p_person_id in per_all_people_f.person_id%TYPE
4753: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4754: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4755: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4752: (p_person_id in per_all_people_f.person_id%TYPE
4753: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4754: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4755: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4753: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4754: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4755: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4754: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4755: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4755: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4756: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4757: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4758: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4759: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4760: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4761: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4762: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4763: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4764: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4765: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4766: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4767: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4768: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4769: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4770: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4771: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4772: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4780: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4773: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4780: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4781: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4774: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4780: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4781: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4782: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4775: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4780: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4781: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4782: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4783: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4776: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4780: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4781: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4782: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4783: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4784: ,p_effective_date in date
4777: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4780: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4781: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4782: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4783: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4784: ,p_effective_date in date
4785: ,p_validation_start_date in date
4778: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4780: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4781: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4782: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4783: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4784: ,p_effective_date in date
4785: ,p_validation_start_date in date
4786: ,p_validation_end_date in date
4779: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4780: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4781: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4782: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4783: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4784: ,p_effective_date in date
4785: ,p_validation_start_date in date
4786: ,p_validation_end_date in date
4787: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
4783: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4784: ,p_effective_date in date
4785: ,p_validation_start_date in date
4786: ,p_validation_end_date in date
4787: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
4788: ) is
4789:
4790: l_error exception;
4791: l_proc varchar2(72) := g_package||'chk_JP_per_information';
5518: -- Access Status:
5519: -- Internal Table Handler Use Only.
5520: --
5521: procedure chk_JP_names
5522: (p_person_id in per_all_people_f.person_id%TYPE
5523: ,p_effective_date in date
5524: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5525: ,p_first_name in per_all_people_f.first_name%TYPE
5526: ,p_last_name in per_all_people_f.last_name%TYPE
5520: --
5521: procedure chk_JP_names
5522: (p_person_id in per_all_people_f.person_id%TYPE
5523: ,p_effective_date in date
5524: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5525: ,p_first_name in per_all_people_f.first_name%TYPE
5526: ,p_last_name in per_all_people_f.last_name%TYPE
5527: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5528: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5521: procedure chk_JP_names
5522: (p_person_id in per_all_people_f.person_id%TYPE
5523: ,p_effective_date in date
5524: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5525: ,p_first_name in per_all_people_f.first_name%TYPE
5526: ,p_last_name in per_all_people_f.last_name%TYPE
5527: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5528: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5529: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5522: (p_person_id in per_all_people_f.person_id%TYPE
5523: ,p_effective_date in date
5524: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5525: ,p_first_name in per_all_people_f.first_name%TYPE
5526: ,p_last_name in per_all_people_f.last_name%TYPE
5527: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5528: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5529: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5530: --
5523: ,p_effective_date in date
5524: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5525: ,p_first_name in per_all_people_f.first_name%TYPE
5526: ,p_last_name in per_all_people_f.last_name%TYPE
5527: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5528: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5529: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5530: --
5531: l_last_name per_all_people_f.last_name%TYPE;
5524: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5525: ,p_first_name in per_all_people_f.first_name%TYPE
5526: ,p_last_name in per_all_people_f.last_name%TYPE
5527: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5528: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5529: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5530: --
5531: l_last_name per_all_people_f.last_name%TYPE;
5532: l_first_name per_all_people_f.first_name%TYPE;
5525: ,p_first_name in per_all_people_f.first_name%TYPE
5526: ,p_last_name in per_all_people_f.last_name%TYPE
5527: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5528: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5529: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5530: --
5531: l_last_name per_all_people_f.last_name%TYPE;
5532: l_first_name per_all_people_f.first_name%TYPE;
5533: l_proc varchar2(72) ;
5527: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5528: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5529: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5530: --
5531: l_last_name per_all_people_f.last_name%TYPE;
5532: l_first_name per_all_people_f.first_name%TYPE;
5533: l_proc varchar2(72) ;
5534: l_api_updating boolean;
5535: l_output varchar2(150);
5528: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5529: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5530: --
5531: l_last_name per_all_people_f.last_name%TYPE;
5532: l_first_name per_all_people_f.first_name%TYPE;
5533: l_proc varchar2(72) ;
5534: l_api_updating boolean;
5535: l_output varchar2(150);
5536: l_rgeflg varchar2(10);
5541: hr_utility.set_location('Entering:'|| l_proc, 1);
5542: end if;
5543: --
5544: if hr_multi_message.no_exclusive_error
5545: (p_check_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5546: )
5547: then
5548: l_api_updating := per_per_shd.api_updating
5549: (p_person_id => p_person_id
5608: end if;
5609: exception
5610: when app_exception.application_exception then
5611: if hr_multi_message.exception_add
5612: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5613: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.FIRST_NAME'
5614: ) then
5615: if g_debug then
5616: hr_utility.set_location(' Leaving:'||l_proc, 6);
5609: exception
5610: when app_exception.application_exception then
5611: if hr_multi_message.exception_add
5612: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5613: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.FIRST_NAME'
5614: ) then
5615: if g_debug then
5616: hr_utility.set_location(' Leaving:'||l_proc, 6);
5617: end if;
5668: --
5669: -- For bug # 2689366, added p_per_information18 and p_per_information19
5670: --
5671: procedure return_full_name
5672: (p_person_id in per_all_people_f.person_id%TYPE
5673: ,p_business_group_id in per_all_people_f.business_group_id%type
5674: ,p_first_name in per_all_people_f.first_name%TYPE
5675: ,p_middle_names in per_all_people_f.middle_names%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5669: -- For bug # 2689366, added p_per_information18 and p_per_information19
5670: --
5671: procedure return_full_name
5672: (p_person_id in per_all_people_f.person_id%TYPE
5673: ,p_business_group_id in per_all_people_f.business_group_id%type
5674: ,p_first_name in per_all_people_f.first_name%TYPE
5675: ,p_middle_names in per_all_people_f.middle_names%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5670: --
5671: procedure return_full_name
5672: (p_person_id in per_all_people_f.person_id%TYPE
5673: ,p_business_group_id in per_all_people_f.business_group_id%type
5674: ,p_first_name in per_all_people_f.first_name%TYPE
5675: ,p_middle_names in per_all_people_f.middle_names%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5678: ,p_title in per_all_people_f.title%TYPE
5671: procedure return_full_name
5672: (p_person_id in per_all_people_f.person_id%TYPE
5673: ,p_business_group_id in per_all_people_f.business_group_id%type
5674: ,p_first_name in per_all_people_f.first_name%TYPE
5675: ,p_middle_names in per_all_people_f.middle_names%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5678: ,p_title in per_all_people_f.title%TYPE
5679: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5672: (p_person_id in per_all_people_f.person_id%TYPE
5673: ,p_business_group_id in per_all_people_f.business_group_id%type
5674: ,p_first_name in per_all_people_f.first_name%TYPE
5675: ,p_middle_names in per_all_people_f.middle_names%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5678: ,p_title in per_all_people_f.title%TYPE
5679: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5680: ,p_suffix in per_all_people_f.suffix%TYPE
5673: ,p_business_group_id in per_all_people_f.business_group_id%type
5674: ,p_first_name in per_all_people_f.first_name%TYPE
5675: ,p_middle_names in per_all_people_f.middle_names%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5678: ,p_title in per_all_people_f.title%TYPE
5679: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5680: ,p_suffix in per_all_people_f.suffix%TYPE
5681: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5674: ,p_first_name in per_all_people_f.first_name%TYPE
5675: ,p_middle_names in per_all_people_f.middle_names%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5678: ,p_title in per_all_people_f.title%TYPE
5679: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5680: ,p_suffix in per_all_people_f.suffix%TYPE
5681: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5682: ,p_effective_date in date
5675: ,p_middle_names in per_all_people_f.middle_names%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5678: ,p_title in per_all_people_f.title%TYPE
5679: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5680: ,p_suffix in per_all_people_f.suffix%TYPE
5681: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5682: ,p_effective_date in date
5683: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5676: ,p_last_name in per_all_people_f.last_name%TYPE
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5678: ,p_title in per_all_people_f.title%TYPE
5679: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5680: ,p_suffix in per_all_people_f.suffix%TYPE
5681: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5682: ,p_effective_date in date
5683: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5684: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5677: ,p_known_as in per_all_people_f.known_as%TYPE
5678: ,p_title in per_all_people_f.title%TYPE
5679: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5680: ,p_suffix in per_all_people_f.suffix%TYPE
5681: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5682: ,p_effective_date in date
5683: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5684: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5685: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5679: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5680: ,p_suffix in per_all_people_f.suffix%TYPE
5681: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5682: ,p_effective_date in date
5683: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5684: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5685: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5686: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5680: ,p_suffix in per_all_people_f.suffix%TYPE
5681: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5682: ,p_effective_date in date
5683: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5684: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5685: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5686: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5681: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5682: ,p_effective_date in date
5683: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5684: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5685: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5686: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5682: ,p_effective_date in date
5683: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5684: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5685: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5686: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5683: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5684: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5685: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5686: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5684: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5685: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5686: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5685: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5686: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5686: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5687: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5688: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5689: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5690: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5691: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5692: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5693: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5694: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5695: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5696: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5697: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5698: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5699: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5700: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5701: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5702: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5703: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5704: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5705: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5706: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5707: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5708: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5709: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5710: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5711: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5712: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5713: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5714: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5715: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5716: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5717: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5718: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5719: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5720: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5721: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5722: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5723: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5724: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5725: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5726: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5727: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5728: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5729: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5730: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5731: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5732: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5733: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5734: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5735: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5736: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5737: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5738: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5739: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5740: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5741: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5749: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5742: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5749: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5750: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5743: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5749: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5750: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5751: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5744: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5749: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5750: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5751: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5752: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5745: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5749: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5750: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5751: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5752: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5753: ,p_duplicate_flag OUT NOCOPY VARCHAR2
5746: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5749: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5750: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5751: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5752: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5753: ,p_duplicate_flag OUT NOCOPY VARCHAR2
5754: ,p_name_combination_warning out nocopy boolean) is
5747: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5749: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5750: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5751: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5752: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5753: ,p_duplicate_flag OUT NOCOPY VARCHAR2
5754: ,p_name_combination_warning out nocopy boolean) is
5755: --
5748: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5749: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5750: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5751: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5752: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5753: ,p_duplicate_flag OUT NOCOPY VARCHAR2
5754: ,p_name_combination_warning out nocopy boolean) is
5755: --
5756: l_exists varchar2(1);
5790: --
5791: end if;
5792: --
5793: if hr_multi_message.no_all_inclusive_error
5794: (p_check_column1 => 'PER_ALL_PEOPLE_F.TITLE'
5795: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
5796: )
5797: then
5798: p_name_combination_warning := false;
5791: end if;
5792: --
5793: if hr_multi_message.no_all_inclusive_error
5794: (p_check_column1 => 'PER_ALL_PEOPLE_F.TITLE'
5795: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
5796: )
5797: then
5798: p_name_combination_warning := false;
5799: --
6168: end if;
6169: exception
6170: when app_exception.application_exception then
6171: if hr_multi_message.exception_add
6172: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
6173: ) then
6174: if g_debug then
6175: hr_utility.set_location(' Leaving:'||l_proc, 50);
6176: end if;
6252: -- Access Status:
6253: -- Internal Table Handler Use Only.
6254: --
6255: procedure chk_applicant_number
6256: (p_person_id in per_all_people_f.person_id%TYPE
6257: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6258: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6259: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6260: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6253: -- Internal Table Handler Use Only.
6254: --
6255: procedure chk_applicant_number
6256: (p_person_id in per_all_people_f.person_id%TYPE
6257: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6258: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6259: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6260: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6261: ,p_effective_date in date
6254: --
6255: procedure chk_applicant_number
6256: (p_person_id in per_all_people_f.person_id%TYPE
6257: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6258: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6259: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6260: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6261: ,p_effective_date in date
6262: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6255: procedure chk_applicant_number
6256: (p_person_id in per_all_people_f.person_id%TYPE
6257: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6258: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6259: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6260: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6261: ,p_effective_date in date
6262: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6263: )
6256: (p_person_id in per_all_people_f.person_id%TYPE
6257: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6258: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6259: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6260: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6261: ,p_effective_date in date
6262: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6263: )
6264: is
6258: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6259: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6260: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6261: ,p_effective_date in date
6262: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6263: )
6264: is
6265: begin
6266: chk_applicant_number
6278: end chk_applicant_number;
6279: --
6280: --
6281: procedure chk_applicant_number
6282: (p_person_id in per_all_people_f.person_id%TYPE
6283: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6284: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6285: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6286: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6279: --
6280: --
6281: procedure chk_applicant_number
6282: (p_person_id in per_all_people_f.person_id%TYPE
6283: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6284: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6285: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6286: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6287: ,p_effective_date in date
6280: --
6281: procedure chk_applicant_number
6282: (p_person_id in per_all_people_f.person_id%TYPE
6283: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6284: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6285: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6286: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6287: ,p_effective_date in date
6288: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6281: procedure chk_applicant_number
6282: (p_person_id in per_all_people_f.person_id%TYPE
6283: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6284: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6285: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6286: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6287: ,p_effective_date in date
6288: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6289: ,p_party_id in per_all_people_f.party_id%TYPE
6282: (p_person_id in per_all_people_f.person_id%TYPE
6283: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6284: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6285: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6286: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6287: ,p_effective_date in date
6288: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6289: ,p_party_id in per_all_people_f.party_id%TYPE
6290: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
6284: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6285: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6286: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6287: ,p_effective_date in date
6288: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6289: ,p_party_id in per_all_people_f.party_id%TYPE
6290: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
6291: ,p_start_date in date
6292: )
6285: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6286: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6287: ,p_effective_date in date
6288: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6289: ,p_party_id in per_all_people_f.party_id%TYPE
6290: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
6291: ,p_start_date in date
6292: )
6293: is
6286: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6287: ,p_effective_date in date
6288: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6289: ,p_party_id in per_all_people_f.party_id%TYPE
6290: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
6291: ,p_start_date in date
6292: )
6293: is
6294: --
6295: l_proc varchar2(72) := g_package||'chk_applicant_number';
6296: l_api_updating boolean;
6297: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;
6298: l_system_person_type per_person_types.system_person_type%TYPE;
6299: l_employee_number per_all_people_f.employee_number%TYPE;
6300: l_npw_number per_all_people_f.npw_number%TYPE;
6301: l_apl_sys boolean := false;
6302: --
6303: -- Cursor to get number generation method for Bus Group
6296: l_api_updating boolean;
6297: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;
6298: l_system_person_type per_person_types.system_person_type%TYPE;
6299: l_employee_number per_all_people_f.employee_number%TYPE;
6300: l_npw_number per_all_people_f.npw_number%TYPE;
6301: l_apl_sys boolean := false;
6302: --
6303: -- Cursor to get number generation method for Bus Group
6304: --
6596: when app_exception.application_exception then
6597: if not l_apl_sys
6598: then
6599: if hr_multi_message.exception_add
6600: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6601: ) then
6602: if g_debug then
6603: hr_utility.set_location(' Leaving:'||l_proc, 17);
6604: end if;
6605: raise;
6606: end if;
6607: else
6608: if hr_multi_message.exception_add
6609: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6610: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
6611: ) then
6612: if g_debug then
6613: hr_utility.set_location(' Leaving:'||l_proc, 17);
6606: end if;
6607: else
6608: if hr_multi_message.exception_add
6609: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6610: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
6611: ) then
6612: if g_debug then
6613: hr_utility.set_location(' Leaving:'||l_proc, 17);
6614: end if;
6652: -- Access Status:
6653: -- Internal Table Handler Use Only.
6654: --
6655: procedure chk_date_emp_data_verified
6656: (p_person_id in per_all_people_f.person_id%TYPE
6657: ,p_date_employee_data_verified in
6658: per_all_people_f.date_employee_data_verified%TYPE
6659: ,p_effective_start_date in date
6660: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6654: --
6655: procedure chk_date_emp_data_verified
6656: (p_person_id in per_all_people_f.person_id%TYPE
6657: ,p_date_employee_data_verified in
6658: per_all_people_f.date_employee_data_verified%TYPE
6659: ,p_effective_start_date in date
6660: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6661: )
6662: is
6656: (p_person_id in per_all_people_f.person_id%TYPE
6657: ,p_date_employee_data_verified in
6658: per_all_people_f.date_employee_data_verified%TYPE
6659: ,p_effective_start_date in date
6660: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6661: )
6662: is
6663: --
6664: l_proc varchar2(72);
6711: end if;
6712: exception
6713: when app_exception.application_exception then
6714: if hr_multi_message.exception_add
6715: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED'
6716: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE'
6717: ) then
6718: if g_debug then
6719: hr_utility.set_location(' Leaving:'||l_proc, 6);
6712: exception
6713: when app_exception.application_exception then
6714: if hr_multi_message.exception_add
6715: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED'
6716: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE'
6717: ) then
6718: if g_debug then
6719: hr_utility.set_location(' Leaving:'||l_proc, 6);
6720: end if;
6758: -- Access Status:
6759: -- Internal Table Handler Use Only.
6760: --
6761: procedure chk_vendor_id
6762: (p_person_id in per_all_people_f.person_id%TYPE
6763: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6764: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6765: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6766: ,p_effective_date in date
6759: -- Internal Table Handler Use Only.
6760: --
6761: procedure chk_vendor_id
6762: (p_person_id in per_all_people_f.person_id%TYPE
6763: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6764: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6765: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6766: ,p_effective_date in date
6767: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6760: --
6761: procedure chk_vendor_id
6762: (p_person_id in per_all_people_f.person_id%TYPE
6763: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6764: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6765: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6766: ,p_effective_date in date
6767: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6768: ) is
6761: procedure chk_vendor_id
6762: (p_person_id in per_all_people_f.person_id%TYPE
6763: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6764: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6765: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6766: ,p_effective_date in date
6767: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6768: ) is
6769: --
6763: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6764: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6765: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6766: ,p_effective_date in date
6767: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6768: ) is
6769: --
6770: l_proc varchar2(72);
6771: l_api_updating boolean;
6856: end if;
6857: exception
6858: when app_exception.application_exception then
6859: if hr_multi_message.exception_add
6860: (p_associated_column1 => 'PER_ALL_PEOPLE_F.VENDOR_ID'
6861: ) then
6862: if g_debug then
6863: hr_utility.set_location(' Leaving:'||l_proc, 90);
6864: end if;
6894: -- Access Status:
6895: -- Internal Table Handler Use Only.
6896: --
6897: procedure chk_suffix
6898: (p_person_id in per_all_people_f.person_id%TYPE
6899: ,p_suffix in per_all_people_f.suffix%TYPE
6900: ,p_effective_date in date
6901: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6902: )
6895: -- Internal Table Handler Use Only.
6896: --
6897: procedure chk_suffix
6898: (p_person_id in per_all_people_f.person_id%TYPE
6899: ,p_suffix in per_all_people_f.suffix%TYPE
6900: ,p_effective_date in date
6901: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6902: )
6903: is
6897: procedure chk_suffix
6898: (p_person_id in per_all_people_f.person_id%TYPE
6899: ,p_suffix in per_all_people_f.suffix%TYPE
6900: ,p_effective_date in date
6901: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6902: )
6903: is
6904: --
6905: l_exists varchar2(1);
6976: -- Access Status:
6977: -- Internal Table Handler Use Only.
6978: --
6979: procedure chk_work_telephone
6980: (p_person_id in per_all_people_f.person_id%TYPE
6981: ,p_work_telephone in per_all_people_f.work_telephone%TYPE
6982: ,p_effective_date in date
6983: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6984: )
6977: -- Internal Table Handler Use Only.
6978: --
6979: procedure chk_work_telephone
6980: (p_person_id in per_all_people_f.person_id%TYPE
6981: ,p_work_telephone in per_all_people_f.work_telephone%TYPE
6982: ,p_effective_date in date
6983: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6984: )
6985: is
6979: procedure chk_work_telephone
6980: (p_person_id in per_all_people_f.person_id%TYPE
6981: ,p_work_telephone in per_all_people_f.work_telephone%TYPE
6982: ,p_effective_date in date
6983: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6984: )
6985: is
6986: --
6987: l_proc varchar2(72);
7024: end if;
7025: exception
7026: when app_exception.application_exception then
7027: if hr_multi_message.exception_add
7028: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_TELEPHONE'
7029: ) then
7030: if g_debug then
7031: hr_utility.set_location(' Leaving:'||l_proc, 80);
7032: end if;
7065: -- Access Status:
7066: -- Internal Table Handler Use Only.
7067: --
7068: procedure chk_per_information_category
7069: (p_per_information_category in out nocopy per_all_people_f.per_information_category%TYPE
7070: ,p_legislation_code in per_business_groups.legislation_code%TYPE
7071: ) is
7072: --
7073: l_ddf_exists varchar2(1);
7094: -- |------------------------< chk_delete >----------------------------|
7095: -- ---------------------------------------------------------------------------
7096: --
7097: -- Description:
7098: -- Validates that rows may be deleted from per_all_people_f
7099: --
7100: -- Pre-conditions:
7101: -- None
7102: --
7123: -- Access Status:
7124: -- Internal Table Handler Use Only.
7125: --
7126: procedure chk_delete
7127: (p_person_id in per_all_people_f.person_id%TYPE
7128: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
7129: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
7130: ,p_effective_date in date
7131: ,p_datetrack_mode in varchar2) is
7124: -- Internal Table Handler Use Only.
7125: --
7126: procedure chk_delete
7127: (p_person_id in per_all_people_f.person_id%TYPE
7128: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
7129: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
7130: ,p_effective_date in date
7131: ,p_datetrack_mode in varchar2) is
7132: --
7125: --
7126: procedure chk_delete
7127: (p_person_id in per_all_people_f.person_id%TYPE
7128: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
7129: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
7130: ,p_effective_date in date
7131: ,p_datetrack_mode in varchar2) is
7132: --
7133: l_exists varchar2(1);
7143: select null
7144: from sys.dual
7145: where exists
7146: (select null
7147: from per_all_people_f ppf,
7148: per_person_types ppt
7149: where ppf.effective_start_date > p_effective_date
7150: and ppf.person_id = p_person_id
7151: and ppt.person_type_id = ppf.person_type_id
7733: --
7734: l_proc varchar2(72);
7735: l_legislation_code per_business_groups.legislation_code%TYPE;
7736: --
7737: l_first_name per_all_people_f.first_name%TYPE;
7738: l_last_name per_all_people_f.last_name%TYPE;
7739: l_output varchar2(150);
7740: l_rgeflg varchar2(10);
7741: l_duplicate_flag varchar2(1);
7734: l_proc varchar2(72);
7735: l_legislation_code per_business_groups.legislation_code%TYPE;
7736: --
7737: l_first_name per_all_people_f.first_name%TYPE;
7738: l_last_name per_all_people_f.last_name%TYPE;
7739: l_output varchar2(150);
7740: l_rgeflg varchar2(10);
7741: l_duplicate_flag varchar2(1);
7742: --
8456: --
8457: l_proc varchar2(72);
8458: l_legislation_code per_business_groups.legislation_code%TYPE;
8459: --
8460: l_first_name per_all_people_f.first_name%TYPE;
8461: l_last_name per_all_people_f.last_name%TYPE;
8462: l_output varchar2(150);
8463: l_rgeflg varchar2(10);
8464: l_duplicate_flag varchar2(1);
8457: l_proc varchar2(72);
8458: l_legislation_code per_business_groups.legislation_code%TYPE;
8459: --
8460: l_first_name per_all_people_f.first_name%TYPE;
8461: l_last_name per_all_people_f.last_name%TYPE;
8462: l_output varchar2(150);
8463: l_rgeflg varchar2(10);
8464: l_duplicate_flag varchar2(1);
8465: --
9304: --
9305: cursor csr_leg_code is
9306: select pbg.legislation_code
9307: from per_business_groups pbg
9308: , per_all_people_f per
9309: where per.person_id = p_person_id
9310: and pbg.business_group_id = per.business_group_id
9311: order by per.effective_start_date;
9312: --
9396: l_proc varchar2(72) := g_package||'chk_system_pers_type';
9397: --
9398: cursor csr_get_system_person_type is
9399: select ppt.system_person_type
9400: from per_all_people_f ppf
9401: , per_person_types ppt
9402: where p_effective_date between ppf.effective_start_date
9403: and ppf.effective_end_date
9404: and ppf.person_id = p_person_id
9407: cursor csr_chk_future_changes is
9408: select null
9409: from sys.dual
9410: where exists(select null
9411: from per_all_people_f ppf
9412: , per_person_types ppt
9413: where ppf.effective_start_date between
9414: p_validation_start_date
9415: and p_validation_end_date