37: := g_package || 'VALIDATE_PERSON_UPD';
38: l_effective_date DATE;
39: l_err NUMBER;
40: l_age NUMBER;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
38: l_effective_date DATE;
39: l_err NUMBER;
40: l_age NUMBER;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
39: l_err NUMBER;
40: l_age NUMBER;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
40: l_age NUMBER;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
41: l_per_information5 per_all_people_f.per_information5%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
42: l_per_information6 per_all_people_f.per_information6%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
43: l_per_information7 per_all_people_f.per_information7%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
44: l_per_information8 per_all_people_f.per_information8%TYPE;
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
52:
45: l_per_information9 per_all_people_f.per_information9%TYPE;
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
52:
53: CURSOR csr_get_mil_info (p_id NUMBER)
46: l_per_information10 per_all_people_f.per_information10%TYPE;
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
52:
53: CURSOR csr_get_mil_info (p_id NUMBER)
54: IS
47: l_per_information11 per_all_people_f.per_information11%TYPE;
48: l_per_information12 per_all_people_f.per_information12%TYPE;
49: l_per_information14 per_all_people_f.per_information14%TYPE;
50: l_per_information15 per_all_people_f.per_information15%TYPE;
51: l_per_information18 per_all_people_f.per_information18%TYPE;
52:
53: CURSOR csr_get_mil_info (p_id NUMBER)
54: IS
55: SELECT per_information5, per_information6, per_information7,
55: SELECT per_information5, per_information6, per_information7,
56: per_information8, per_information9, per_information10,
57: per_information11, per_information12, per_information13,
58: per_information14,per_information15,per_information18
59: FROM per_all_people_f papf
60: WHERE papf.person_id = p_id
61: AND p_effective_date BETWEEN papf.effective_start_date
62: AND papf.effective_end_date;
63:
784: IS
785: l_proc CONSTANT VARCHAR2 (72)
786: := g_package || 'UPDATE_RU_PERSON';
787: l_age NUMBER;
788: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
789: l_sex per_all_people_f.sex%TYPE;
790: l_per_information5 per_all_people_f.per_information5%TYPE;
791: l_system_person_type per_person_types.system_person_type%TYPE;
792: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;
785: l_proc CONSTANT VARCHAR2 (72)
786: := g_package || 'UPDATE_RU_PERSON';
787: l_age NUMBER;
788: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
789: l_sex per_all_people_f.sex%TYPE;
790: l_per_information5 per_all_people_f.per_information5%TYPE;
791: l_system_person_type per_person_types.system_person_type%TYPE;
792: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;
793: l_effective_date DATE;
786: := g_package || 'UPDATE_RU_PERSON';
787: l_age NUMBER;
788: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
789: l_sex per_all_people_f.sex%TYPE;
790: l_per_information5 per_all_people_f.per_information5%TYPE;
791: l_system_person_type per_person_types.system_person_type%TYPE;
792: l_seeded_person_type_key per_person_types.seeded_person_type_key%TYPE;
793: l_effective_date DATE;
794:
794:
795: CURSOR csr_get_person_info (p_id NUMBER)
796: IS
797: SELECT date_of_birth, sex, per_information5
798: FROM per_all_people_f papf
799: WHERE papf.person_id = p_id
800: AND p_effective_date BETWEEN papf.effective_start_date
801: AND papf.effective_end_date;
802: