[Home] [Help]
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
726: end if;
727: exception
728: when app_exception.application_exception then
729: if hr_multi_message.exception_add
730: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
731: ) then
732: if g_debug then
733: hr_utility.set_location(' Leaving:'||l_proc, 14);
734: end if;
788: -- Access Status:
789: -- Internal Table Handler Use Only.
790: --
791: procedure chk_date_of_birth
792: (p_person_id in per_all_people_f.person_id%TYPE
793: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
794: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
795: ,p_start_date in date
796: ,p_date_of_birth in date
789: -- Internal Table Handler Use Only.
790: --
791: procedure chk_date_of_birth
792: (p_person_id in per_all_people_f.person_id%TYPE
793: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
794: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
795: ,p_start_date in date
796: ,p_date_of_birth in date
797: ,p_dob_null_warning out nocopy boolean
790: --
791: procedure chk_date_of_birth
792: (p_person_id in per_all_people_f.person_id%TYPE
793: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
794: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
795: ,p_start_date in date
796: ,p_date_of_birth in date
797: ,p_dob_null_warning out nocopy boolean
798: ,p_effective_date in date
797: ,p_dob_null_warning out nocopy boolean
798: ,p_effective_date in date
799: ,p_validation_start_date in date
800: ,p_validation_end_date in date
801: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
802: --
803: l_exists varchar2(1);
804: l_proc varchar2(72) := g_package||'chk_date_of_birth';
805: l_api_updating boolean;
830: --
831: -- Check mandatory parameters have been set
832: --
833: if hr_multi_message.no_exclusive_error
834: (p_check_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
835: )
836: then
837: hr_api.mandatory_arg_error
838: (p_api_name => l_proc
993: exception
994: when app_exception.application_exception then
995: If not l_dob_st then
996: if hr_multi_message.exception_add
997: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
998: ) then
999: if g_debug then
1000: hr_utility.set_location(' Leaving:'||l_proc, 9);
1001: end if;
1002: raise;
1003: end if;
1004: Else
1005: if hr_multi_message.exception_add
1006: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1007: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
1008: ) then
1009: if g_debug then
1010: hr_utility.set_location(' Leaving:'||l_proc, 10);
1003: end if;
1004: Else
1005: if hr_multi_message.exception_add
1006: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1007: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
1008: ) then
1009: if g_debug then
1010: hr_utility.set_location(' Leaving:'||l_proc, 10);
1011: end if;
1055: -- Access Status:
1056: -- Internal Table Handler Use Only.
1057: --
1058: procedure chk_marital_status
1059: (p_person_id in per_all_people_f.person_id%TYPE
1060: ,p_marital_status in per_all_people_f.marital_status%TYPE
1061: ,p_effective_date in date
1062: ,p_validation_start_date in date
1063: ,p_validation_end_date in date
1056: -- Internal Table Handler Use Only.
1057: --
1058: procedure chk_marital_status
1059: (p_person_id in per_all_people_f.person_id%TYPE
1060: ,p_marital_status in per_all_people_f.marital_status%TYPE
1061: ,p_effective_date in date
1062: ,p_validation_start_date in date
1063: ,p_validation_end_date in date
1064: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1060: ,p_marital_status in per_all_people_f.marital_status%TYPE
1061: ,p_effective_date in date
1062: ,p_validation_start_date in date
1063: ,p_validation_end_date in date
1064: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1065: )
1066: is
1067: --
1068: l_exists varchar2(1);
1150: end if;
1151: exception
1152: when app_exception.application_exception then
1153: if hr_multi_message.exception_add
1154: (p_associated_column1 => 'PER_ALL_PEOPLE_F.MARITAL_STATUS'
1155: ) then
1156: if g_debug then
1157: hr_utility.set_location(' Leaving:'||l_proc, 80);
1158: end if;
1190: -- Access Status:
1191: -- Internal Table Handler Use Only.
1192: --
1193: procedure chk_party_id
1194: (p_person_id in per_all_people_f.person_id%TYPE
1195: ,p_party_id in number
1196: ,p_effective_date in date
1197: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1198: )
1193: procedure chk_party_id
1194: (p_person_id in per_all_people_f.person_id%TYPE
1195: ,p_party_id in number
1196: ,p_effective_date in date
1197: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1198: )
1199: is
1200: --
1201: l_exists varchar2(1);
1274: end if;
1275: exception
1276: when app_exception.application_exception then
1277: if hr_multi_message.exception_add
1278: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PARTY_ID'
1279: ) then
1280: if g_debug then
1281: hr_utility.set_location(' Leaving:'||l_proc, 80);
1282: end if;
1326: -- Access Status:
1327: -- Internal Table Handler Use Only.
1328: --
1329: procedure chk_nationality
1330: (p_person_id in per_all_people_f.person_id%TYPE
1331: ,p_nationality in per_all_people_f.nationality%TYPE
1332: ,p_effective_date in date
1333: ,p_validation_start_date in date
1334: ,p_validation_end_date in date
1327: -- Internal Table Handler Use Only.
1328: --
1329: procedure chk_nationality
1330: (p_person_id in per_all_people_f.person_id%TYPE
1331: ,p_nationality in per_all_people_f.nationality%TYPE
1332: ,p_effective_date in date
1333: ,p_validation_start_date in date
1334: ,p_validation_end_date in date
1335: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1331: ,p_nationality in per_all_people_f.nationality%TYPE
1332: ,p_effective_date in date
1333: ,p_validation_start_date in date
1334: ,p_validation_end_date in date
1335: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1336: )
1337: is
1338: --
1339: l_exists varchar2(1);
1417: end if;
1418: exception
1419: when app_exception.application_exception then
1420: if hr_multi_message.exception_add
1421: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONALITY'
1422: ) then
1423: if g_debug then
1424: hr_utility.set_location(' Leaving:'||l_proc, 70);
1425: end if;
1433: -- start for bug 6241572, a new overloaded procedure is created with
1434: -- p_region_of_birth, p_country_of_birth and p_nationality parameters.
1435:
1436: procedure chk_national_identifier
1437: (p_person_id in per_all_people_f.person_id%TYPE
1438: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1439: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1440: ,p_date_of_birth in date
1441: ,p_sex in per_all_people_f.sex%TYPE
1434: -- p_region_of_birth, p_country_of_birth and p_nationality parameters.
1435:
1436: procedure chk_national_identifier
1437: (p_person_id in per_all_people_f.person_id%TYPE
1438: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1439: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1440: ,p_date_of_birth in date
1441: ,p_sex in per_all_people_f.sex%TYPE
1442: ,p_effective_date in date
1435:
1436: procedure chk_national_identifier
1437: (p_person_id in per_all_people_f.person_id%TYPE
1438: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1439: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1440: ,p_date_of_birth in date
1441: ,p_sex in per_all_people_f.sex%TYPE
1442: ,p_effective_date in date
1443: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1437: (p_person_id in per_all_people_f.person_id%TYPE
1438: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1439: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1440: ,p_date_of_birth in date
1441: ,p_sex in per_all_people_f.sex%TYPE
1442: ,p_effective_date in date
1443: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1444: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1445: ,p_person_type_id in per_all_people_f.person_type_id%TYPE) is
1439: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1440: ,p_date_of_birth in date
1441: ,p_sex in per_all_people_f.sex%TYPE
1442: ,p_effective_date in date
1443: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1444: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1445: ,p_person_type_id in per_all_people_f.person_type_id%TYPE) is
1446:
1447: -- declaring those variable which are not present in the previous
1441: ,p_sex in per_all_people_f.sex%TYPE
1442: ,p_effective_date in date
1443: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1444: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1445: ,p_person_type_id in per_all_people_f.person_type_id%TYPE) is
1446:
1447: -- declaring those variable which are not present in the previous
1448: -- chk_national_identifier
1449:
1446:
1447: -- declaring those variable which are not present in the previous
1448: -- chk_national_identifier
1449:
1450: l_region_of_birth per_all_people_f.region_of_birth%TYPE;
1451: l_country_of_birth per_all_people_f.country_of_birth%TYPE;
1452: l_nationality per_all_people_f.nationality%TYPE;
1453:
1454: begin
1447: -- declaring those variable which are not present in the previous
1448: -- chk_national_identifier
1449:
1450: l_region_of_birth per_all_people_f.region_of_birth%TYPE;
1451: l_country_of_birth per_all_people_f.country_of_birth%TYPE;
1452: l_nationality per_all_people_f.nationality%TYPE;
1453:
1454: begin
1455: --calling chk_nation_identifier
1448: -- chk_national_identifier
1449:
1450: l_region_of_birth per_all_people_f.region_of_birth%TYPE;
1451: l_country_of_birth per_all_people_f.country_of_birth%TYPE;
1452: l_nationality per_all_people_f.nationality%TYPE;
1453:
1454: begin
1455: --calling chk_nation_identifier
1456:
1504: -- Access Status:
1505: -- Internal Table Handler Use Only.
1506: --
1507: procedure chk_national_identifier
1508: (p_person_id in per_all_people_f.person_id%TYPE
1509: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1510: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1511: ,p_date_of_birth in date
1512: ,p_sex in per_all_people_f.sex%TYPE
1505: -- Internal Table Handler Use Only.
1506: --
1507: procedure chk_national_identifier
1508: (p_person_id in per_all_people_f.person_id%TYPE
1509: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1510: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1511: ,p_date_of_birth in date
1512: ,p_sex in per_all_people_f.sex%TYPE
1513: ,p_effective_date in date
1506: --
1507: procedure chk_national_identifier
1508: (p_person_id in per_all_people_f.person_id%TYPE
1509: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1510: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1511: ,p_date_of_birth in date
1512: ,p_sex in per_all_people_f.sex%TYPE
1513: ,p_effective_date in date
1514: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1508: (p_person_id in per_all_people_f.person_id%TYPE
1509: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1510: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1511: ,p_date_of_birth in date
1512: ,p_sex in per_all_people_f.sex%TYPE
1513: ,p_effective_date in date
1514: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1515: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1516: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1510: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1511: ,p_date_of_birth in date
1512: ,p_sex in per_all_people_f.sex%TYPE
1513: ,p_effective_date in date
1514: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1515: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1516: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1517:
1518: --added new parameter for bug 6241572
1512: ,p_sex in per_all_people_f.sex%TYPE
1513: ,p_effective_date in date
1514: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1515: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1516: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1517:
1518: --added new parameter for bug 6241572
1519: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
1520: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
1515: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1516: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1517:
1518: --added new parameter for bug 6241572
1519: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
1520: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
1521: ,p_nationality in per_all_people_f.nationality%TYPE) is
1522:
1523: --
1516: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1517:
1518: --added new parameter for bug 6241572
1519: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
1520: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
1521: ,p_nationality in per_all_people_f.nationality%TYPE) is
1522:
1523: --
1524: l_exists varchar2(1);
1517:
1518: --added new parameter for bug 6241572
1519: ,p_region_of_birth in per_all_people_f.region_of_birth%TYPE default NULL
1520: ,p_country_of_birth in per_all_people_f.country_of_birth%TYPE default NULL
1521: ,p_nationality in per_all_people_f.nationality%TYPE) is
1522:
1523: --
1524: l_exists varchar2(1);
1525: l_proc varchar2(72) := g_package||'chk_national_identifier';
1619: end if;
1620: exception
1621: when app_exception.application_exception then
1622: if hr_multi_message.exception_add
1623: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1624: ) then
1625: if g_debug then
1626: hr_utility.set_location(' Leaving:'||l_proc, 4);
1627: end if;
1687: -- Access Status:
1688: -- Internal Table Handler Use Only.
1689: --
1690: procedure chk_employee_number
1691: (p_person_id in per_all_people_f.person_id%TYPE
1692: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1693: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1694: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1695: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1688: -- Internal Table Handler Use Only.
1689: --
1690: procedure chk_employee_number
1691: (p_person_id in per_all_people_f.person_id%TYPE
1692: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1693: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1694: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1695: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1696: ,p_effective_date in date
1689: --
1690: procedure chk_employee_number
1691: (p_person_id in per_all_people_f.person_id%TYPE
1692: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1693: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1694: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1695: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1696: ,p_effective_date in date
1697: ,p_object_version_number in per_all_people_f.object_version_number%TYPE)
1690: procedure chk_employee_number
1691: (p_person_id in per_all_people_f.person_id%TYPE
1692: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1693: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1694: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1695: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1696: ,p_effective_date in date
1697: ,p_object_version_number in per_all_people_f.object_version_number%TYPE)
1698: is
1691: (p_person_id in per_all_people_f.person_id%TYPE
1692: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1693: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1694: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1695: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1696: ,p_effective_date in date
1697: ,p_object_version_number in per_all_people_f.object_version_number%TYPE)
1698: is
1699: begin
1693: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1694: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1695: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1696: ,p_effective_date in date
1697: ,p_object_version_number in per_all_people_f.object_version_number%TYPE)
1698: is
1699: begin
1700: chk_employee_number
1701: (p_person_id => p_person_id
1713: --
1714: -- Overloaded
1715: --
1716: procedure chk_employee_number
1717: (p_person_id in per_all_people_f.person_id%TYPE
1718: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1719: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1720: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1721: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1714: -- Overloaded
1715: --
1716: procedure chk_employee_number
1717: (p_person_id in per_all_people_f.person_id%TYPE
1718: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1719: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1720: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1721: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1722: ,p_effective_date in date
1715: --
1716: procedure chk_employee_number
1717: (p_person_id in per_all_people_f.person_id%TYPE
1718: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1719: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1720: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1721: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1722: ,p_effective_date in date
1723: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1716: procedure chk_employee_number
1717: (p_person_id in per_all_people_f.person_id%TYPE
1718: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1719: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1720: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1721: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1722: ,p_effective_date in date
1723: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1724: ,p_party_id in per_all_people_f.party_id%TYPE
1717: (p_person_id in per_all_people_f.person_id%TYPE
1718: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1719: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1720: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1721: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1722: ,p_effective_date in date
1723: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1724: ,p_party_id in per_all_people_f.party_id%TYPE
1725: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1719: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
1720: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1721: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1722: ,p_effective_date in date
1723: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1724: ,p_party_id in per_all_people_f.party_id%TYPE
1725: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1726: ,p_start_date in per_periods_of_service.date_start%TYPE)
1727: is
1720: ,p_employee_number in out nocopy per_all_people_f.employee_number%TYPE
1721: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1722: ,p_effective_date in date
1723: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1724: ,p_party_id in per_all_people_f.party_id%TYPE
1725: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1726: ,p_start_date in per_periods_of_service.date_start%TYPE)
1727: is
1728: --
1721: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
1722: ,p_effective_date in date
1723: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
1724: ,p_party_id in per_all_people_f.party_id%TYPE
1725: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
1726: ,p_start_date in per_periods_of_service.date_start%TYPE)
1727: is
1728: --
1729: l_exists varchar2(1);
1728: --
1729: l_exists varchar2(1);
1730: l_proc varchar2(72) := g_package||'chk_employee_number';
1731: l_api_updating boolean;
1732: l_applicant_number per_all_people_f.applicant_number%TYPE;
1733: l_npw_number per_all_people_f.npw_number%TYPE;
1734: l_gen_method varchar2(1);
1735: l_emp_ni boolean := false;
1736: --
1729: l_exists varchar2(1);
1730: l_proc varchar2(72) := g_package||'chk_employee_number';
1731: l_api_updating boolean;
1732: l_applicant_number per_all_people_f.applicant_number%TYPE;
1733: l_npw_number per_all_people_f.npw_number%TYPE;
1734: l_gen_method varchar2(1);
1735: l_emp_ni boolean := false;
1736: --
1737: cursor csr_gen_method is
1860: if g_debug then
1861: hr_utility.set_location('Entering:'|| l_proc, 10);
1862: end if;
1863: if hr_multi_message.no_exclusive_error
1864: (p_check_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1865: )
1866: then
1867: --
1868: -- Check mandatory parameters have been set
2102: -- if error is not because of national identifier
2103: if not l_emp_ni
2104: then
2105: if hr_multi_message.exception_add
2106: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2107: ) then
2108: if g_debug then
2109: hr_utility.set_location(' Leaving:'||l_proc, 150);
2110: end if;
2111: raise;
2112: end if;
2113: else
2114: if hr_multi_message.exception_add
2115: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2116: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2117: ) then
2118: if g_debug then
2119: hr_utility.set_location(' Leaving:'||l_proc, 160);
2112: end if;
2113: else
2114: if hr_multi_message.exception_add
2115: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2116: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2117: ) then
2118: if g_debug then
2119: hr_utility.set_location(' Leaving:'||l_proc, 160);
2120: end if;
2180: -- Access Status:
2181: -- Internal Development Use Only.
2182: --
2183: procedure chk_npw_number
2184: (p_person_id in per_all_people_f.person_id%TYPE
2185: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2186: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2187: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2188: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2181: -- Internal Development Use Only.
2182: --
2183: procedure chk_npw_number
2184: (p_person_id in per_all_people_f.person_id%TYPE
2185: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2186: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2187: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2188: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2189: ,p_effective_date in date
2182: --
2183: procedure chk_npw_number
2184: (p_person_id in per_all_people_f.person_id%TYPE
2185: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2186: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2187: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2188: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2189: ,p_effective_date in date
2190: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2183: procedure chk_npw_number
2184: (p_person_id in per_all_people_f.person_id%TYPE
2185: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2186: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2187: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2188: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2189: ,p_effective_date in date
2190: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2191: )
2184: (p_person_id in per_all_people_f.person_id%TYPE
2185: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2186: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2187: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2188: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2189: ,p_effective_date in date
2190: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2191: )
2192: is
2186: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2187: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2188: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2189: ,p_effective_date in date
2190: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2191: )
2192: is
2193: begin
2194: chk_npw_number
2205: );
2206: end chk_npw_number;
2207: --
2208: procedure chk_npw_number
2209: (p_person_id in per_all_people_f.person_id%TYPE
2210: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2211: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2212: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2213: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2206: end chk_npw_number;
2207: --
2208: procedure chk_npw_number
2209: (p_person_id in per_all_people_f.person_id%TYPE
2210: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2211: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2212: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2213: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2214: ,p_effective_date in date
2207: --
2208: procedure chk_npw_number
2209: (p_person_id in per_all_people_f.person_id%TYPE
2210: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2211: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2212: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2213: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2214: ,p_effective_date in date
2215: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2208: procedure chk_npw_number
2209: (p_person_id in per_all_people_f.person_id%TYPE
2210: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2211: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2212: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2213: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2214: ,p_effective_date in date
2215: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2216: ,p_party_id in per_all_people_f.party_id%TYPE
2209: (p_person_id in per_all_people_f.person_id%TYPE
2210: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2211: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2212: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2213: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2214: ,p_effective_date in date
2215: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2216: ,p_party_id in per_all_people_f.party_id%TYPE
2217: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
2211: ,p_current_npw_flag in per_all_people_f.current_npw_flag%TYPE
2212: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2213: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2214: ,p_effective_date in date
2215: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2216: ,p_party_id in per_all_people_f.party_id%TYPE
2217: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
2218: ,p_start_date in date
2219: )
2212: ,p_npw_number in out nocopy per_all_people_f.npw_number%TYPE
2213: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2214: ,p_effective_date in date
2215: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2216: ,p_party_id in per_all_people_f.party_id%TYPE
2217: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
2218: ,p_start_date in date
2219: )
2220: is
2213: ,p_national_identifier in per_all_people_f.national_identifier%TYPE
2214: ,p_effective_date in date
2215: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2216: ,p_party_id in per_all_people_f.party_id%TYPE
2217: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
2218: ,p_start_date in date
2219: )
2220: is
2221: --
2221: --
2222: l_proc varchar2(72) := g_package||'chk_npw_number';
2223: l_exists varchar2(1);
2224: l_api_updating boolean;
2225: l_applicant_number per_all_people_f.applicant_number%TYPE;
2226: l_employee_number per_all_people_f.employee_number%TYPE;
2227: l_gen_method varchar2(1);
2228: l_npw_ni boolean := false;
2229: --
2222: l_proc varchar2(72) := g_package||'chk_npw_number';
2223: l_exists varchar2(1);
2224: l_api_updating boolean;
2225: l_applicant_number per_all_people_f.applicant_number%TYPE;
2226: l_employee_number per_all_people_f.employee_number%TYPE;
2227: l_gen_method varchar2(1);
2228: l_npw_ni boolean := false;
2229: --
2230: cursor csr_gen_method is
2265: if g_debug then
2266: hr_utility.set_location('Entering:'|| l_proc, 10);
2267: end if;
2268: if hr_multi_message.no_exclusive_error
2269: (p_check_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2270: )
2271: then
2272: --
2273: -- Check mandatory parameters have been set
2489: -- if error is not because of national identifier
2490: if not l_npw_ni
2491: then
2492: if hr_multi_message.exception_add
2493: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2494: ) then
2495: if g_debug then
2496: hr_utility.set_location(' Leaving:'||l_proc, 150);
2497: end if;
2498: raise;
2499: end if;
2500: else
2501: if hr_multi_message.exception_add
2502: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2503: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2504: ) then
2505: if g_debug then
2506: hr_utility.set_location(' Leaving:'||l_proc, 160);
2499: end if;
2500: else
2501: if hr_multi_message.exception_add
2502: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2503: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2504: ) then
2505: if g_debug then
2506: hr_utility.set_location(' Leaving:'||l_proc, 160);
2507: end if;
2550: -- Access Status:
2551: -- Internal Table Handler Use Only.
2552: --
2553: procedure chk_expense_check_send_to_addr
2554: (p_person_id in per_all_people_f.person_id%TYPE
2555: ,p_expense_check_send_to_addres in per_all_people_f.expense_check_send_to_address%TYPE
2556: ,p_effective_date in date
2557: ,p_validation_start_date in date
2558: ,p_validation_end_date in date
2551: -- Internal Table Handler Use Only.
2552: --
2553: procedure chk_expense_check_send_to_addr
2554: (p_person_id in per_all_people_f.person_id%TYPE
2555: ,p_expense_check_send_to_addres in per_all_people_f.expense_check_send_to_address%TYPE
2556: ,p_effective_date in date
2557: ,p_validation_start_date in date
2558: ,p_validation_end_date in date
2559: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2555: ,p_expense_check_send_to_addres in per_all_people_f.expense_check_send_to_address%TYPE
2556: ,p_effective_date in date
2557: ,p_validation_start_date in date
2558: ,p_validation_end_date in date
2559: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2560: )
2561: is
2562: --
2563: l_exists varchar2(1);
2654: end if;
2655: exception
2656: when app_exception.application_exception then
2657: if hr_multi_message.exception_add
2658: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS'
2659: ) then
2660: if g_debug then
2661: hr_utility.set_location(' Leaving:'||l_proc, 80);
2662: end if;
2730: -- Access Status:
2731: -- Internal Table Handler Use Only.
2732: --
2733: procedure chk_sex_title
2734: (p_person_id in per_all_people_f.person_id%TYPE
2735: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2736: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2737: ,p_title in per_all_people_f.title%TYPE
2738: ,p_sex in per_all_people_f.sex%TYPE
2731: -- Internal Table Handler Use Only.
2732: --
2733: procedure chk_sex_title
2734: (p_person_id in per_all_people_f.person_id%TYPE
2735: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2736: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2737: ,p_title in per_all_people_f.title%TYPE
2738: ,p_sex in per_all_people_f.sex%TYPE
2739: ,p_effective_date in date
2732: --
2733: procedure chk_sex_title
2734: (p_person_id in per_all_people_f.person_id%TYPE
2735: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2736: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2737: ,p_title in per_all_people_f.title%TYPE
2738: ,p_sex in per_all_people_f.sex%TYPE
2739: ,p_effective_date in date
2740: ,p_validation_start_date in date
2733: procedure chk_sex_title
2734: (p_person_id in per_all_people_f.person_id%TYPE
2735: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2736: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2737: ,p_title in per_all_people_f.title%TYPE
2738: ,p_sex in per_all_people_f.sex%TYPE
2739: ,p_effective_date in date
2740: ,p_validation_start_date in date
2741: ,p_validation_end_date in date
2734: (p_person_id in per_all_people_f.person_id%TYPE
2735: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2736: ,p_person_type_id in per_all_people_f.person_type_id%TYPe
2737: ,p_title in per_all_people_f.title%TYPE
2738: ,p_sex in per_all_people_f.sex%TYPE
2739: ,p_effective_date in date
2740: ,p_validation_start_date in date
2741: ,p_validation_end_date in date
2742: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2738: ,p_sex in per_all_people_f.sex%TYPE
2739: ,p_effective_date in date
2740: ,p_validation_start_date in date
2741: ,p_validation_end_date in date
2742: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
2743: )
2744: is
2745: --
2746: l_exists varchar2(1);
2823: then
2824: --
2825: hr_utility.set_message(801, 'HR_7512_PER_TITLE_INVALID');
2826: hr_multi_message.add
2827: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2828: );
2829: --
2830: end if;
2831: if g_debug then
2853: then
2854: --
2855: hr_utility.set_message(801, 'HR_7511_PER_SEX_INVALID');
2856: hr_multi_message.add
2857: (p_associated_column1 => 'PER_ALL_PEOPLE_F.SEX'
2858: );
2859: --
2860: end if;
2861: if g_debug then
2872: p_title in ('MISS','MRS.','MS.') then
2873: -- Error: Values for Sex and Title are inconsistent.
2874: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2875: hr_multi_message.add
2876: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2877: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2878: );
2879: end if;
2880: if g_debug then
2873: -- Error: Values for Sex and Title are inconsistent.
2874: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2875: hr_multi_message.add
2876: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2877: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2878: );
2879: end if;
2880: if g_debug then
2881: hr_utility.set_location(l_proc, 70);
2885: p_title = 'MR.' then
2886: -- Error: Values for Sex and Title are inconsistent.
2887: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2888: hr_multi_message.add
2889: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2890: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2891: );
2892: end if;
2893: if g_debug then
2886: -- Error: Values for Sex and Title are inconsistent.
2887: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2888: hr_multi_message.add
2889: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2890: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2891: );
2892: end if;
2893: if g_debug then
2894: hr_utility.set_location(l_proc, 80);
2903: p_business_group_id),'EMP') <> 0 then
2904: -- Error: You must enter sex for an employee.
2905: hr_utility.set_message(801, 'HR_6524_EMP_MANDATORY_SEX');
2906: hr_multi_message.add
2907: (p_associated_column1 => 'PER_ALL_PEOPLE_F.SEX'
2908: );
2909: end if;
2910: if g_debug then
2911: hr_utility.set_location(l_proc, 90);
2950: -- Access Status:
2951: -- Internal Row Handler Use Only.
2952: --
2953: procedure chk_town_of_birth
2954: (p_person_id in per_all_people_f.person_id%TYPE,
2955: p_town_of_birth in per_all_people_f.town_of_birth%TYPE,
2956: p_effective_date in date,
2957: p_validation_start_date in date,
2958: p_validation_end_date in date,
2951: -- Internal Row Handler Use Only.
2952: --
2953: procedure chk_town_of_birth
2954: (p_person_id in per_all_people_f.person_id%TYPE,
2955: p_town_of_birth in per_all_people_f.town_of_birth%TYPE,
2956: p_effective_date in date,
2957: p_validation_start_date in date,
2958: p_validation_end_date in date,
2959: p_legislation_code in per_business_groups.legislation_code%TYPE) is
3019: end if;
3020: exception
3021: when app_exception.application_exception then
3022: if hr_multi_message.exception_add
3023: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TOWN_OF_BIRTH'
3024: ) then
3025: if g_debug then
3026: hr_utility.set_location(' Leaving:'||l_proc, 4);
3027: end if;
3064: -- Access Status:
3065: -- Internal Row Handler Use Only.
3066: --
3067: procedure chk_region_of_birth
3068: (p_person_id in per_all_people_f.person_id%TYPE,
3069: p_region_of_birth in per_all_people_f.region_of_birth%TYPE,
3070: p_effective_date in date,
3071: p_validation_start_date in date,
3072: p_validation_end_date in date,
3065: -- Internal Row Handler Use Only.
3066: --
3067: procedure chk_region_of_birth
3068: (p_person_id in per_all_people_f.person_id%TYPE,
3069: p_region_of_birth in per_all_people_f.region_of_birth%TYPE,
3070: p_effective_date in date,
3071: p_validation_start_date in date,
3072: p_validation_end_date in date,
3073: p_legislation_code in per_business_groups.legislation_code%TYPE) is
3133: end if;
3134: exception
3135: when app_exception.application_exception then
3136: if hr_multi_message.exception_add
3137: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGION_OF_BIRTH'
3138: ) then
3139: if g_debug then
3140: hr_utility.set_location(' Leaving:'||l_proc, 4);
3141: end if;
3171: -- Access Status:
3172: -- Internal Row Handler Use Only.
3173: --
3174: procedure chk_country_of_birth
3175: (p_person_id in per_all_people_f.person_id%TYPE,
3176: p_country_of_birth in per_all_people_f.country_of_birth%TYPE) is
3177: --
3178: l_exists varchar2(1);
3179: l_proc varchar2(72);
3172: -- Internal Row Handler Use Only.
3173: --
3174: procedure chk_country_of_birth
3175: (p_person_id in per_all_people_f.person_id%TYPE,
3176: p_country_of_birth in per_all_people_f.country_of_birth%TYPE) is
3177: --
3178: l_exists varchar2(1);
3179: l_proc varchar2(72);
3180: --
3223: end if;
3224: exception
3225: when app_exception.application_exception then
3226: if hr_multi_message.exception_add
3227: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH'
3228: ) then
3229: if g_debug then
3230: hr_utility.set_location(' Leaving:'||l_proc, 4);
3231: end if;
3270: -- Access Status:
3271: -- Internal Table Handler Use Only.
3272: --
3273: procedure chk_start_date
3274: (p_person_id in per_all_people_f.person_id%TYPE
3275: ,p_start_date in date
3276: ,p_effective_date in date
3277: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
3278: --
3273: procedure chk_start_date
3274: (p_person_id in per_all_people_f.person_id%TYPE
3275: ,p_start_date in date
3276: ,p_effective_date in date
3277: ,p_object_version_number in per_all_people_f.object_version_number%TYPE) is
3278: --
3279: l_exists varchar2(1);
3280: l_proc varchar2(72) := g_package||'chk_start_date';
3281: l_api_updating boolean;
3284: -- Find the earliest effective start date for the person
3285: --
3286: cursor csr_chk_min_date is
3287: Select min(effective_start_date)
3288: from per_all_people_f
3289: where p_person_id = person_id;
3290: --
3291: begin
3292: if g_debug then
3356: end if;
3357: exception
3358: when app_exception.application_exception then
3359: if hr_multi_message.exception_add
3360: (p_associated_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
3361: ) then
3362: if g_debug then
3363: hr_utility.set_location(' Leaving:'||l_proc, 5);
3364: end if;
3414: -- Access Status:
3415: -- Internal Table Handler Use Only.
3416: --
3417: procedure chk_orig_and_start_dates
3418: (p_person_id in per_all_people_f.person_id%TYPE
3419: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3420: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3421: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3422: ,p_start_date in per_all_people_f.start_date%TYPE
3415: -- Internal Table Handler Use Only.
3416: --
3417: procedure chk_orig_and_start_dates
3418: (p_person_id in per_all_people_f.person_id%TYPE
3419: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3420: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3421: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3422: ,p_start_date in per_all_people_f.start_date%TYPE
3423: ,p_effective_date in date
3416: --
3417: procedure chk_orig_and_start_dates
3418: (p_person_id in per_all_people_f.person_id%TYPE
3419: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3420: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3421: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3422: ,p_start_date in per_all_people_f.start_date%TYPE
3423: ,p_effective_date in date
3424: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3417: procedure chk_orig_and_start_dates
3418: (p_person_id in per_all_people_f.person_id%TYPE
3419: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3420: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3421: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3422: ,p_start_date in per_all_people_f.start_date%TYPE
3423: ,p_effective_date in date
3424: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3425: ,p_orig_hire_warning out nocopy boolean
3418: (p_person_id in per_all_people_f.person_id%TYPE
3419: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
3420: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3421: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3422: ,p_start_date in per_all_people_f.start_date%TYPE
3423: ,p_effective_date in date
3424: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3425: ,p_orig_hire_warning out nocopy boolean
3426: ) is
3420: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
3421: ,p_original_date_of_hire in per_all_people_f.original_date_of_hire%TYPE
3422: ,p_start_date in per_all_people_f.start_date%TYPE
3423: ,p_effective_date in date
3424: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3425: ,p_orig_hire_warning out nocopy boolean
3426: ) is
3427: --
3428: l_proc varchar2(72) ;
3438:
3439: -- added for the bug 5402099
3440: l_earliest_date1 date;
3441: cursor original_date_of_hire_ppf is
3442: select original_date_of_hire from per_all_people_f where
3443: person_id=p_person_id and
3444: p_original_date_of_hire between effective_start_date and effective_end_date ;
3445: -- end of bug 5402099
3446: --
3463: if (p_person_id is null and
3464: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3465: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3466: hr_multi_message.add
3467: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3468: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
3469: );
3470: --
3471: elsif p_person_id is not null then
3464: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3465: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3466: hr_multi_message.add
3467: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3468: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
3469: );
3470: --
3471: elsif p_person_id is not null then
3472: open csr_earliest_date;
3492: */
3493: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3494: close csr_earliest_date;
3495: hr_multi_message.add
3496: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3497: );
3498: else
3499: close csr_earliest_date;
3500: end if;
3594: -- Access Status:
3595: -- Internal Table Handler Use Only.
3596: --
3597: procedure chk_GB_per_information
3598: (p_person_id in per_all_people_f.person_id%TYPE
3599: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3600: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3601: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3595: -- Internal Table Handler Use Only.
3596: --
3597: procedure chk_GB_per_information
3598: (p_person_id in per_all_people_f.person_id%TYPE
3599: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3600: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3601: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3596: --
3597: procedure chk_GB_per_information
3598: (p_person_id in per_all_people_f.person_id%TYPE
3599: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3600: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3601: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3597: procedure chk_GB_per_information
3598: (p_person_id in per_all_people_f.person_id%TYPE
3599: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3600: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3601: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3598: (p_person_id in per_all_people_f.person_id%TYPE
3599: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3600: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3601: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3599: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
3600: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3601: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3600: ,p_per_information1 in per_all_people_f.per_information1%TYPE
3601: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3601: ,p_per_information2 in per_all_people_f.per_information2%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3602: ,p_per_information3 in per_all_people_f.per_information3%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3603: ,p_per_information4 in per_all_people_f.per_information4%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3604: ,p_per_information5 in per_all_people_f.per_information5%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3605: ,p_per_information6 in per_all_people_f.per_information6%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3606: ,p_per_information7 in per_all_people_f.per_information7%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3607: ,p_per_information8 in per_all_people_f.per_information8%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3608: ,p_per_information9 in per_all_people_f.per_information9%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3609: ,p_per_information10 in per_all_people_f.per_information10%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3610: ,p_per_information11 in per_all_people_f.per_information11%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3611: ,p_per_information12 in per_all_people_f.per_information12%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3612: ,p_per_information13 in per_all_people_f.per_information13%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3613: ,p_per_information14 in per_all_people_f.per_information14%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3614: ,p_per_information15 in per_all_people_f.per_information15%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3615: ,p_per_information16 in per_all_people_f.per_information16%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3616: ,p_per_information17 in per_all_people_f.per_information17%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3617: ,p_per_information18 in per_all_people_f.per_information18%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3618: ,p_per_information19 in per_all_people_f.per_information19%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3626: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3619: ,p_per_information20 in per_all_people_f.per_information20%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3626: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3627: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3620: ,p_per_information21 in per_all_people_f.per_information21%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3626: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3627: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3628: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3621: ,p_per_information22 in per_all_people_f.per_information22%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3626: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3627: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3628: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3629: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3622: ,p_per_information23 in per_all_people_f.per_information23%TYPE
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3626: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3627: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3628: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3629: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3630: ,p_effective_date in date
3623: ,p_per_information24 in per_all_people_f.per_information24%TYPE
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3626: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3627: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3628: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3629: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3630: ,p_effective_date in date
3631: ,p_validation_start_date in date
3624: ,p_per_information25 in per_all_people_f.per_information25%TYPE
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3626: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3627: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3628: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3629: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3630: ,p_effective_date in date
3631: ,p_validation_start_date in date
3632: ,p_validation_end_date in date
3625: ,p_per_information26 in per_all_people_f.per_information26%TYPE
3626: ,p_per_information27 in per_all_people_f.per_information27%TYPE
3627: ,p_per_information28 in per_all_people_f.per_information28%TYPE
3628: ,p_per_information29 in per_all_people_f.per_information29%TYPE
3629: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3630: ,p_effective_date in date
3631: ,p_validation_start_date in date
3632: ,p_validation_end_date in date
3633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3629: ,p_per_information30 in per_all_people_f.per_information30%TYPE
3630: ,p_effective_date in date
3631: ,p_validation_start_date in date
3632: ,p_validation_end_date in date
3633: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
3634: )
3635: is
3636: --
3637: l_exists varchar2(1);
3639: l_proc varchar2(72) := g_package||'chk_GB_per_information';
3640: l_api_updating boolean;
3641: l_lookup_type varchar2(30);
3642: l_info_attribute number(2);
3643: l_per_information6 per_all_people_f.per_information6%TYPE;
3644: l_per_information7 per_all_people_f.per_information7%TYPE;
3645: l_per_information8 per_all_people_f.per_information8%TYPE;
3646: l_output varchar2(150);
3647: l_rgeflg varchar2(10);
3640: l_api_updating boolean;
3641: l_lookup_type varchar2(30);
3642: l_info_attribute number(2);
3643: l_per_information6 per_all_people_f.per_information6%TYPE;
3644: l_per_information7 per_all_people_f.per_information7%TYPE;
3645: l_per_information8 per_all_people_f.per_information8%TYPE;
3646: l_output varchar2(150);
3647: l_rgeflg varchar2(10);
3648: --
3641: l_lookup_type varchar2(30);
3642: l_info_attribute number(2);
3643: l_per_information6 per_all_people_f.per_information6%TYPE;
3644: l_per_information7 per_all_people_f.per_information7%TYPE;
3645: l_per_information8 per_all_people_f.per_information8%TYPE;
3646: l_output varchar2(150);
3647: l_rgeflg varchar2(10);
3648: --
3649: begin
4217: -- Access Status:
4218: -- Internal Table Handler Use Only.
4219: --
4220: procedure chk_US_per_information
4221: (p_person_id in per_all_people_f.person_id%TYPE
4222: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4223: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4224: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4218: -- Internal Table Handler Use Only.
4219: --
4220: procedure chk_US_per_information
4221: (p_person_id in per_all_people_f.person_id%TYPE
4222: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4223: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4224: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4219: --
4220: procedure chk_US_per_information
4221: (p_person_id in per_all_people_f.person_id%TYPE
4222: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4223: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4224: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4220: procedure chk_US_per_information
4221: (p_person_id in per_all_people_f.person_id%TYPE
4222: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4223: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4224: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4221: (p_person_id in per_all_people_f.person_id%TYPE
4222: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4223: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4224: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4222: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4223: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4224: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4223: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4224: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4224: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4225: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4226: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4227: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4228: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4229: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4230: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4231: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4232: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4233: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4234: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4235: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4236: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4237: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4238: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4239: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4240: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4241: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4249: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4242: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4249: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4250: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4243: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4249: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4250: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4251: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4244: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4249: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4250: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4251: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4252: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4245: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4249: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4250: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4251: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4252: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4253: ,p_effective_date in date
4246: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4249: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4250: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4251: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4252: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4253: ,p_effective_date in date
4254: ,p_validation_start_date in date
4247: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4249: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4250: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4251: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4252: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4253: ,p_effective_date in date
4254: ,p_validation_start_date in date
4255: ,p_validation_end_date in date
4248: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4249: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4250: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4251: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4252: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4253: ,p_effective_date in date
4254: ,p_validation_start_date in date
4255: ,p_validation_end_date in date
4256: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
4252: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4253: ,p_effective_date in date
4254: ,p_validation_start_date in date
4255: ,p_validation_end_date in date
4256: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
4257: ,p_api_updating in boolean
4258: )
4259: is
4260: --
4263: l_temp_error exception;
4264: l_proc varchar2(72) := g_package||'chk_US_per_information';
4265: l_lookup_type varchar2(30);
4266: l_info_attribute number(2);
4267: l_per_information3 per_all_people_f.per_information3%TYPE;
4268: l_output varchar2(150);
4269: l_rgeflg varchar2(10);
4270: --
4271: begin
4759: -- |------------------------
4760: -- ----------------------------------------------------------------------------
4761:
4762: procedure chk_JP_per_information
4763: (p_person_id in per_all_people_f.person_id%TYPE
4764: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4765: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4766: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4760: -- ----------------------------------------------------------------------------
4761:
4762: procedure chk_JP_per_information
4763: (p_person_id in per_all_people_f.person_id%TYPE
4764: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4765: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4766: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4761:
4762: procedure chk_JP_per_information
4763: (p_person_id in per_all_people_f.person_id%TYPE
4764: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4765: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4766: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4762: procedure chk_JP_per_information
4763: (p_person_id in per_all_people_f.person_id%TYPE
4764: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4765: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4766: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4763: (p_person_id in per_all_people_f.person_id%TYPE
4764: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4765: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4766: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4764: ,p_per_information_category in per_all_people_f.per_information_category%TYPE
4765: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4766: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4765: ,p_per_information1 in per_all_people_f.per_information1%TYPE
4766: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4766: ,p_per_information2 in per_all_people_f.per_information2%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4767: ,p_per_information3 in per_all_people_f.per_information3%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4768: ,p_per_information4 in per_all_people_f.per_information4%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4769: ,p_per_information5 in per_all_people_f.per_information5%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4770: ,p_per_information6 in per_all_people_f.per_information6%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4771: ,p_per_information7 in per_all_people_f.per_information7%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4772: ,p_per_information8 in per_all_people_f.per_information8%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4773: ,p_per_information9 in per_all_people_f.per_information9%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4774: ,p_per_information10 in per_all_people_f.per_information10%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4775: ,p_per_information11 in per_all_people_f.per_information11%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4776: ,p_per_information12 in per_all_people_f.per_information12%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4777: ,p_per_information13 in per_all_people_f.per_information13%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4778: ,p_per_information14 in per_all_people_f.per_information14%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4779: ,p_per_information15 in per_all_people_f.per_information15%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4780: ,p_per_information16 in per_all_people_f.per_information16%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4781: ,p_per_information17 in per_all_people_f.per_information17%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4782: ,p_per_information18 in per_all_people_f.per_information18%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4783: ,p_per_information19 in per_all_people_f.per_information19%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4791: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4784: ,p_per_information20 in per_all_people_f.per_information20%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4791: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4792: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4785: ,p_per_information21 in per_all_people_f.per_information21%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4791: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4792: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4793: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4786: ,p_per_information22 in per_all_people_f.per_information22%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4791: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4792: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4793: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4794: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4787: ,p_per_information23 in per_all_people_f.per_information23%TYPE
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4791: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4792: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4793: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4794: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4795: ,p_effective_date in date
4788: ,p_per_information24 in per_all_people_f.per_information24%TYPE
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4791: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4792: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4793: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4794: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4795: ,p_effective_date in date
4796: ,p_validation_start_date in date
4789: ,p_per_information25 in per_all_people_f.per_information25%TYPE
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4791: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4792: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4793: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4794: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4795: ,p_effective_date in date
4796: ,p_validation_start_date in date
4797: ,p_validation_end_date in date
4790: ,p_per_information26 in per_all_people_f.per_information26%TYPE
4791: ,p_per_information27 in per_all_people_f.per_information27%TYPE
4792: ,p_per_information28 in per_all_people_f.per_information28%TYPE
4793: ,p_per_information29 in per_all_people_f.per_information29%TYPE
4794: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4795: ,p_effective_date in date
4796: ,p_validation_start_date in date
4797: ,p_validation_end_date in date
4798: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
4794: ,p_per_information30 in per_all_people_f.per_information30%TYPE
4795: ,p_effective_date in date
4796: ,p_validation_start_date in date
4797: ,p_validation_end_date in date
4798: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
4799: ) is
4800:
4801: l_error exception;
4802: l_proc varchar2(72) := g_package||'chk_JP_per_information';
5529: -- Access Status:
5530: -- Internal Table Handler Use Only.
5531: --
5532: procedure chk_JP_names
5533: (p_person_id in per_all_people_f.person_id%TYPE
5534: ,p_effective_date in date
5535: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5536: ,p_first_name in per_all_people_f.first_name%TYPE
5537: ,p_last_name in per_all_people_f.last_name%TYPE
5531: --
5532: procedure chk_JP_names
5533: (p_person_id in per_all_people_f.person_id%TYPE
5534: ,p_effective_date in date
5535: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5536: ,p_first_name in per_all_people_f.first_name%TYPE
5537: ,p_last_name in per_all_people_f.last_name%TYPE
5538: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5539: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5532: procedure chk_JP_names
5533: (p_person_id in per_all_people_f.person_id%TYPE
5534: ,p_effective_date in date
5535: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5536: ,p_first_name in per_all_people_f.first_name%TYPE
5537: ,p_last_name in per_all_people_f.last_name%TYPE
5538: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5539: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5540: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5533: (p_person_id in per_all_people_f.person_id%TYPE
5534: ,p_effective_date in date
5535: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5536: ,p_first_name in per_all_people_f.first_name%TYPE
5537: ,p_last_name in per_all_people_f.last_name%TYPE
5538: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5539: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5540: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5541: --
5534: ,p_effective_date in date
5535: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5536: ,p_first_name in per_all_people_f.first_name%TYPE
5537: ,p_last_name in per_all_people_f.last_name%TYPE
5538: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5539: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5540: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5541: --
5542: l_last_name per_all_people_f.last_name%TYPE;
5535: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5536: ,p_first_name in per_all_people_f.first_name%TYPE
5537: ,p_last_name in per_all_people_f.last_name%TYPE
5538: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5539: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5540: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5541: --
5542: l_last_name per_all_people_f.last_name%TYPE;
5543: l_first_name per_all_people_f.first_name%TYPE;
5536: ,p_first_name in per_all_people_f.first_name%TYPE
5537: ,p_last_name in per_all_people_f.last_name%TYPE
5538: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5539: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5540: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5541: --
5542: l_last_name per_all_people_f.last_name%TYPE;
5543: l_first_name per_all_people_f.first_name%TYPE;
5544: l_proc varchar2(72) ;
5538: ,p_per_information18 in per_all_people_f.per_information18%TYPE
5539: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5540: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5541: --
5542: l_last_name per_all_people_f.last_name%TYPE;
5543: l_first_name per_all_people_f.first_name%TYPE;
5544: l_proc varchar2(72) ;
5545: l_api_updating boolean;
5546: l_output varchar2(150);
5539: ,p_per_information19 in per_all_people_f.per_information19%TYPE) is
5540: --,p_full_name out nocopy per_all_people_f.full_name%TYPE) is -- bug# 2689366
5541: --
5542: l_last_name per_all_people_f.last_name%TYPE;
5543: l_first_name per_all_people_f.first_name%TYPE;
5544: l_proc varchar2(72) ;
5545: l_api_updating boolean;
5546: l_output varchar2(150);
5547: l_rgeflg varchar2(10);
5552: hr_utility.set_location('Entering:'|| l_proc, 1);
5553: end if;
5554: --
5555: if hr_multi_message.no_exclusive_error
5556: (p_check_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5557: )
5558: then
5559: l_api_updating := per_per_shd.api_updating
5560: (p_person_id => p_person_id
5619: end if;
5620: exception
5621: when app_exception.application_exception then
5622: if hr_multi_message.exception_add
5623: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5624: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.FIRST_NAME'
5625: ) then
5626: if g_debug then
5627: hr_utility.set_location(' Leaving:'||l_proc, 6);
5620: exception
5621: when app_exception.application_exception then
5622: if hr_multi_message.exception_add
5623: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5624: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.FIRST_NAME'
5625: ) then
5626: if g_debug then
5627: hr_utility.set_location(' Leaving:'||l_proc, 6);
5628: end if;
5679: --
5680: -- For bug # 2689366, added p_per_information18 and p_per_information19
5681: --
5682: procedure return_full_name
5683: (p_person_id in per_all_people_f.person_id%TYPE
5684: ,p_business_group_id in per_all_people_f.business_group_id%type
5685: ,p_first_name in per_all_people_f.first_name%TYPE
5686: ,p_middle_names in per_all_people_f.middle_names%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5680: -- For bug # 2689366, added p_per_information18 and p_per_information19
5681: --
5682: procedure return_full_name
5683: (p_person_id in per_all_people_f.person_id%TYPE
5684: ,p_business_group_id in per_all_people_f.business_group_id%type
5685: ,p_first_name in per_all_people_f.first_name%TYPE
5686: ,p_middle_names in per_all_people_f.middle_names%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5681: --
5682: procedure return_full_name
5683: (p_person_id in per_all_people_f.person_id%TYPE
5684: ,p_business_group_id in per_all_people_f.business_group_id%type
5685: ,p_first_name in per_all_people_f.first_name%TYPE
5686: ,p_middle_names in per_all_people_f.middle_names%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5689: ,p_title in per_all_people_f.title%TYPE
5682: procedure return_full_name
5683: (p_person_id in per_all_people_f.person_id%TYPE
5684: ,p_business_group_id in per_all_people_f.business_group_id%type
5685: ,p_first_name in per_all_people_f.first_name%TYPE
5686: ,p_middle_names in per_all_people_f.middle_names%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5689: ,p_title in per_all_people_f.title%TYPE
5690: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5683: (p_person_id in per_all_people_f.person_id%TYPE
5684: ,p_business_group_id in per_all_people_f.business_group_id%type
5685: ,p_first_name in per_all_people_f.first_name%TYPE
5686: ,p_middle_names in per_all_people_f.middle_names%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5689: ,p_title in per_all_people_f.title%TYPE
5690: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5691: ,p_suffix in per_all_people_f.suffix%TYPE
5684: ,p_business_group_id in per_all_people_f.business_group_id%type
5685: ,p_first_name in per_all_people_f.first_name%TYPE
5686: ,p_middle_names in per_all_people_f.middle_names%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5689: ,p_title in per_all_people_f.title%TYPE
5690: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5691: ,p_suffix in per_all_people_f.suffix%TYPE
5692: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5685: ,p_first_name in per_all_people_f.first_name%TYPE
5686: ,p_middle_names in per_all_people_f.middle_names%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5689: ,p_title in per_all_people_f.title%TYPE
5690: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5691: ,p_suffix in per_all_people_f.suffix%TYPE
5692: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5693: ,p_effective_date in date
5686: ,p_middle_names in per_all_people_f.middle_names%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5689: ,p_title in per_all_people_f.title%TYPE
5690: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5691: ,p_suffix in per_all_people_f.suffix%TYPE
5692: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5693: ,p_effective_date in date
5694: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5687: ,p_last_name in per_all_people_f.last_name%TYPE
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5689: ,p_title in per_all_people_f.title%TYPE
5690: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5691: ,p_suffix in per_all_people_f.suffix%TYPE
5692: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5693: ,p_effective_date in date
5694: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5695: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5688: ,p_known_as in per_all_people_f.known_as%TYPE
5689: ,p_title in per_all_people_f.title%TYPE
5690: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5691: ,p_suffix in per_all_people_f.suffix%TYPE
5692: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5693: ,p_effective_date in date
5694: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5695: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5696: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5690: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
5691: ,p_suffix in per_all_people_f.suffix%TYPE
5692: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5693: ,p_effective_date in date
5694: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5695: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5696: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5697: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5691: ,p_suffix in per_all_people_f.suffix%TYPE
5692: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5693: ,p_effective_date in date
5694: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5695: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5696: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5697: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5692: ,p_pre_name_adjunct in per_all_people_f.pre_name_adjunct%TYPE
5693: ,p_effective_date in date
5694: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5695: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5696: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5697: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5693: ,p_effective_date in date
5694: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5695: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5696: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5697: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5694: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
5695: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5696: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5697: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5695: ,p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL
5696: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5697: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5696: ,p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL
5697: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5697: ,p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5698: ,p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5699: ,p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5700: ,p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5701: ,p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5702: ,p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5703: ,p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5704: ,p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5705: ,p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5706: ,p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5707: ,p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5708: ,p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5709: ,p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5710: ,p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5711: ,p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5712: ,p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5713: ,p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5714: ,p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5715: ,p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5716: ,p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5717: ,p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5718: ,p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5719: ,p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5720: ,p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5721: ,p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5722: ,p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5723: ,p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5724: ,p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5725: ,p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5726: ,p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5727: ,p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5728: ,p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5729: ,p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5730: ,p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5731: ,p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5732: ,p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5733: ,p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5734: ,p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5735: ,p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5736: ,p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5737: ,p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5738: ,p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5739: ,p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5740: ,p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5741: ,p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5742: ,p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5743: ,p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5744: ,p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5745: ,p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5746: ,p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5747: ,p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5748: ,p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5749: ,p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5750: ,p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5751: ,p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5752: ,p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5753: ,p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5761: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5754: ,p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5761: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5762: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5755: ,p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5761: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5762: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5763: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5756: ,p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5761: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5762: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5763: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5764: ,p_duplicate_flag OUT NOCOPY VARCHAR2
5757: ,p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5761: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5762: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5763: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5764: ,p_duplicate_flag OUT NOCOPY VARCHAR2
5765: ,p_name_combination_warning out nocopy boolean) is
5758: ,p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5761: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5762: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5763: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5764: ,p_duplicate_flag OUT NOCOPY VARCHAR2
5765: ,p_name_combination_warning out nocopy boolean) is
5766: --
5759: ,p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL
5760: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
5761: ,p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE
5762: ,p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE
5763: ,p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
5764: ,p_duplicate_flag OUT NOCOPY VARCHAR2
5765: ,p_name_combination_warning out nocopy boolean) is
5766: --
5767: l_exists varchar2(1);
5801: --
5802: end if;
5803: --
5804: if hr_multi_message.no_all_inclusive_error
5805: (p_check_column1 => 'PER_ALL_PEOPLE_F.TITLE'
5806: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
5807: )
5808: then
5809: p_name_combination_warning := false;
5802: end if;
5803: --
5804: if hr_multi_message.no_all_inclusive_error
5805: (p_check_column1 => 'PER_ALL_PEOPLE_F.TITLE'
5806: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
5807: )
5808: then
5809: p_name_combination_warning := false;
5810: --
6179: end if;
6180: exception
6181: when app_exception.application_exception then
6182: if hr_multi_message.exception_add
6183: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
6184: ) then
6185: if g_debug then
6186: hr_utility.set_location(' Leaving:'||l_proc, 50);
6187: end if;
6263: -- Access Status:
6264: -- Internal Table Handler Use Only.
6265: --
6266: procedure chk_applicant_number
6267: (p_person_id in per_all_people_f.person_id%TYPE
6268: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6269: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6270: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6271: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6264: -- Internal Table Handler Use Only.
6265: --
6266: procedure chk_applicant_number
6267: (p_person_id in per_all_people_f.person_id%TYPE
6268: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6269: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6270: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6271: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6272: ,p_effective_date in date
6265: --
6266: procedure chk_applicant_number
6267: (p_person_id in per_all_people_f.person_id%TYPE
6268: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6269: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6270: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6271: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6272: ,p_effective_date in date
6273: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6266: procedure chk_applicant_number
6267: (p_person_id in per_all_people_f.person_id%TYPE
6268: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6269: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6270: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6271: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6272: ,p_effective_date in date
6273: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6274: )
6267: (p_person_id in per_all_people_f.person_id%TYPE
6268: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6269: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6270: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6271: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6272: ,p_effective_date in date
6273: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6274: )
6275: is
6269: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6270: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6271: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6272: ,p_effective_date in date
6273: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6274: )
6275: is
6276: begin
6277: chk_applicant_number
6289: end chk_applicant_number;
6290: --
6291: --
6292: procedure chk_applicant_number
6293: (p_person_id in per_all_people_f.person_id%TYPE
6294: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6295: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6296: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6297: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6290: --
6291: --
6292: procedure chk_applicant_number
6293: (p_person_id in per_all_people_f.person_id%TYPE
6294: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6295: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6296: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6297: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6298: ,p_effective_date in date
6291: --
6292: procedure chk_applicant_number
6293: (p_person_id in per_all_people_f.person_id%TYPE
6294: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6295: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6296: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6297: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6298: ,p_effective_date in date
6299: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6292: procedure chk_applicant_number
6293: (p_person_id in per_all_people_f.person_id%TYPE
6294: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6295: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6296: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6297: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6298: ,p_effective_date in date
6299: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6300: ,p_party_id in per_all_people_f.party_id%TYPE
6293: (p_person_id in per_all_people_f.person_id%TYPE
6294: ,p_applicant_number in out nocopy per_all_people_f.applicant_number%TYPE
6295: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6296: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6297: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6298: ,p_effective_date in date
6299: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6300: ,p_party_id in per_all_people_f.party_id%TYPE
6301: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
6295: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6296: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6297: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6298: ,p_effective_date in date
6299: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6300: ,p_party_id in per_all_people_f.party_id%TYPE
6301: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
6302: ,p_start_date in date
6303: )
6296: ,p_current_applicant in per_all_people_f.current_applicant_flag%TYPE
6297: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6298: ,p_effective_date in date
6299: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6300: ,p_party_id in per_all_people_f.party_id%TYPE
6301: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
6302: ,p_start_date in date
6303: )
6304: is
6297: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6298: ,p_effective_date in date
6299: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6300: ,p_party_id in per_all_people_f.party_id%TYPE
6301: ,p_date_of_birth in per_all_people_f.date_of_birth%TYPE
6302: ,p_start_date in date
6303: )
6304: is
6305: --
6306: l_proc varchar2(72) := g_package||'chk_applicant_number';
6307: l_api_updating boolean;
6308: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;
6309: l_system_person_type per_person_types.system_person_type%TYPE;
6310: l_employee_number per_all_people_f.employee_number%TYPE;
6311: l_npw_number per_all_people_f.npw_number%TYPE;
6312: l_apl_sys boolean := false;
6313: --
6314: -- Cursor to get number generation method for Bus Group
6307: l_api_updating boolean;
6308: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;
6309: l_system_person_type per_person_types.system_person_type%TYPE;
6310: l_employee_number per_all_people_f.employee_number%TYPE;
6311: l_npw_number per_all_people_f.npw_number%TYPE;
6312: l_apl_sys boolean := false;
6313: --
6314: -- Cursor to get number generation method for Bus Group
6315: --
6607: when app_exception.application_exception then
6608: if not l_apl_sys
6609: then
6610: if hr_multi_message.exception_add
6611: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6612: ) then
6613: if g_debug then
6614: hr_utility.set_location(' Leaving:'||l_proc, 17);
6615: end if;
6616: raise;
6617: end if;
6618: else
6619: if hr_multi_message.exception_add
6620: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6621: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
6622: ) then
6623: if g_debug then
6624: hr_utility.set_location(' Leaving:'||l_proc, 17);
6617: end if;
6618: else
6619: if hr_multi_message.exception_add
6620: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6621: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
6622: ) then
6623: if g_debug then
6624: hr_utility.set_location(' Leaving:'||l_proc, 17);
6625: end if;
6663: -- Access Status:
6664: -- Internal Table Handler Use Only.
6665: --
6666: procedure chk_date_emp_data_verified
6667: (p_person_id in per_all_people_f.person_id%TYPE
6668: ,p_date_employee_data_verified in
6669: per_all_people_f.date_employee_data_verified%TYPE
6670: ,p_effective_start_date in date
6671: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6665: --
6666: procedure chk_date_emp_data_verified
6667: (p_person_id in per_all_people_f.person_id%TYPE
6668: ,p_date_employee_data_verified in
6669: per_all_people_f.date_employee_data_verified%TYPE
6670: ,p_effective_start_date in date
6671: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6672: )
6673: is
6667: (p_person_id in per_all_people_f.person_id%TYPE
6668: ,p_date_employee_data_verified in
6669: per_all_people_f.date_employee_data_verified%TYPE
6670: ,p_effective_start_date in date
6671: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6672: )
6673: is
6674: --
6675: l_proc varchar2(72);
6722: end if;
6723: exception
6724: when app_exception.application_exception then
6725: if hr_multi_message.exception_add
6726: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED'
6727: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE'
6728: ) then
6729: if g_debug then
6730: hr_utility.set_location(' Leaving:'||l_proc, 6);
6723: exception
6724: when app_exception.application_exception then
6725: if hr_multi_message.exception_add
6726: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED'
6727: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE'
6728: ) then
6729: if g_debug then
6730: hr_utility.set_location(' Leaving:'||l_proc, 6);
6731: end if;
6769: -- Access Status:
6770: -- Internal Table Handler Use Only.
6771: --
6772: procedure chk_vendor_id
6773: (p_person_id in per_all_people_f.person_id%TYPE
6774: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6775: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6776: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6777: ,p_effective_date in date
6770: -- Internal Table Handler Use Only.
6771: --
6772: procedure chk_vendor_id
6773: (p_person_id in per_all_people_f.person_id%TYPE
6774: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6775: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6776: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6777: ,p_effective_date in date
6778: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6771: --
6772: procedure chk_vendor_id
6773: (p_person_id in per_all_people_f.person_id%TYPE
6774: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6775: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6776: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6777: ,p_effective_date in date
6778: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6779: ) is
6772: procedure chk_vendor_id
6773: (p_person_id in per_all_people_f.person_id%TYPE
6774: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6775: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6776: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6777: ,p_effective_date in date
6778: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6779: ) is
6780: --
6774: ,p_vendor_id in per_all_people_f.vendor_id%TYPE
6775: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
6776: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
6777: ,p_effective_date in date
6778: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6779: ) is
6780: --
6781: l_proc varchar2(72);
6782: l_api_updating boolean;
6867: end if;
6868: exception
6869: when app_exception.application_exception then
6870: if hr_multi_message.exception_add
6871: (p_associated_column1 => 'PER_ALL_PEOPLE_F.VENDOR_ID'
6872: ) then
6873: if g_debug then
6874: hr_utility.set_location(' Leaving:'||l_proc, 90);
6875: end if;
6905: -- Access Status:
6906: -- Internal Table Handler Use Only.
6907: --
6908: procedure chk_suffix
6909: (p_person_id in per_all_people_f.person_id%TYPE
6910: ,p_suffix in per_all_people_f.suffix%TYPE
6911: ,p_effective_date in date
6912: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6913: )
6906: -- Internal Table Handler Use Only.
6907: --
6908: procedure chk_suffix
6909: (p_person_id in per_all_people_f.person_id%TYPE
6910: ,p_suffix in per_all_people_f.suffix%TYPE
6911: ,p_effective_date in date
6912: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6913: )
6914: is
6908: procedure chk_suffix
6909: (p_person_id in per_all_people_f.person_id%TYPE
6910: ,p_suffix in per_all_people_f.suffix%TYPE
6911: ,p_effective_date in date
6912: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6913: )
6914: is
6915: --
6916: l_exists varchar2(1);
6987: -- Access Status:
6988: -- Internal Table Handler Use Only.
6989: --
6990: procedure chk_work_telephone
6991: (p_person_id in per_all_people_f.person_id%TYPE
6992: ,p_work_telephone in per_all_people_f.work_telephone%TYPE
6993: ,p_effective_date in date
6994: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6995: )
6988: -- Internal Table Handler Use Only.
6989: --
6990: procedure chk_work_telephone
6991: (p_person_id in per_all_people_f.person_id%TYPE
6992: ,p_work_telephone in per_all_people_f.work_telephone%TYPE
6993: ,p_effective_date in date
6994: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6995: )
6996: is
6990: procedure chk_work_telephone
6991: (p_person_id in per_all_people_f.person_id%TYPE
6992: ,p_work_telephone in per_all_people_f.work_telephone%TYPE
6993: ,p_effective_date in date
6994: ,p_object_version_number in per_all_people_f.object_version_number%TYPE
6995: )
6996: is
6997: --
6998: l_proc varchar2(72);
7035: end if;
7036: exception
7037: when app_exception.application_exception then
7038: if hr_multi_message.exception_add
7039: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_TELEPHONE'
7040: ) then
7041: if g_debug then
7042: hr_utility.set_location(' Leaving:'||l_proc, 80);
7043: end if;
7076: -- Access Status:
7077: -- Internal Table Handler Use Only.
7078: --
7079: procedure chk_per_information_category
7080: (p_per_information_category in out nocopy per_all_people_f.per_information_category%TYPE
7081: ,p_legislation_code in per_business_groups.legislation_code%TYPE
7082: ) is
7083: --
7084: l_ddf_exists varchar2(1);
7105: -- |------------------------< chk_delete >----------------------------|
7106: -- ---------------------------------------------------------------------------
7107: --
7108: -- Description:
7109: -- Validates that rows may be deleted from per_all_people_f
7110: --
7111: -- Pre-conditions:
7112: -- None
7113: --
7134: -- Access Status:
7135: -- Internal Table Handler Use Only.
7136: --
7137: procedure chk_delete
7138: (p_person_id in per_all_people_f.person_id%TYPE
7139: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
7140: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
7141: ,p_effective_date in date
7142: ,p_datetrack_mode in varchar2) is
7135: -- Internal Table Handler Use Only.
7136: --
7137: procedure chk_delete
7138: (p_person_id in per_all_people_f.person_id%TYPE
7139: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
7140: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
7141: ,p_effective_date in date
7142: ,p_datetrack_mode in varchar2) is
7143: --
7136: --
7137: procedure chk_delete
7138: (p_person_id in per_all_people_f.person_id%TYPE
7139: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
7140: ,p_person_type_id in per_all_people_f.person_type_id%TYPE
7141: ,p_effective_date in date
7142: ,p_datetrack_mode in varchar2) is
7143: --
7144: l_exists varchar2(1);
7154: select null
7155: from sys.dual
7156: where exists
7157: (select null
7158: from per_all_people_f ppf,
7159: per_person_types ppt
7160: where ppf.effective_start_date > p_effective_date
7161: and ppf.person_id = p_person_id
7162: and ppt.person_type_id = ppf.person_type_id
7744: --
7745: l_proc varchar2(72);
7746: l_legislation_code per_business_groups.legislation_code%TYPE;
7747: --
7748: l_first_name per_all_people_f.first_name%TYPE;
7749: l_last_name per_all_people_f.last_name%TYPE;
7750: l_output varchar2(150);
7751: l_rgeflg varchar2(10);
7752: l_duplicate_flag varchar2(1);
7745: l_proc varchar2(72);
7746: l_legislation_code per_business_groups.legislation_code%TYPE;
7747: --
7748: l_first_name per_all_people_f.first_name%TYPE;
7749: l_last_name per_all_people_f.last_name%TYPE;
7750: l_output varchar2(150);
7751: l_rgeflg varchar2(10);
7752: l_duplicate_flag varchar2(1);
7753: --
8467: --
8468: l_proc varchar2(72);
8469: l_legislation_code per_business_groups.legislation_code%TYPE;
8470: --
8471: l_first_name per_all_people_f.first_name%TYPE;
8472: l_last_name per_all_people_f.last_name%TYPE;
8473: l_output varchar2(150);
8474: l_rgeflg varchar2(10);
8475: l_duplicate_flag varchar2(1);
8468: l_proc varchar2(72);
8469: l_legislation_code per_business_groups.legislation_code%TYPE;
8470: --
8471: l_first_name per_all_people_f.first_name%TYPE;
8472: l_last_name per_all_people_f.last_name%TYPE;
8473: l_output varchar2(150);
8474: l_rgeflg varchar2(10);
8475: l_duplicate_flag varchar2(1);
8476: --
9319: WHERE o3.org_information_context = 'Business Group Information'
9320: AND o3.organization_id IN
9321: (
9322: SELECT business_group_id
9323: FROM per_all_people_f
9324: WHERE person_id = p_person_id
9325: and rownum = 1);
9326: --
9327: -- Declare local variables
9410: l_proc varchar2(72) := g_package||'chk_system_pers_type';
9411: --
9412: cursor csr_get_system_person_type is
9413: select ppt.system_person_type
9414: from per_all_people_f ppf
9415: , per_person_types ppt
9416: where p_effective_date between ppf.effective_start_date
9417: and ppf.effective_end_date
9418: and ppf.person_id = p_person_id
9421: cursor csr_chk_future_changes is
9422: select null
9423: from sys.dual
9424: where exists(select null
9425: from per_all_people_f ppf
9426: , per_person_types ppt
9427: where ppf.effective_start_date between
9428: p_validation_start_date
9429: and p_validation_end_date