148: -- {End of Comments}
149: --
150: -- ---------------------------------------------------------------------------
151: Procedure chk_routing_group_info
152: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
153: ,p_information_type in per_people_extra_info.information_type%TYPE
154: ,p_person_id in per_people_extra_info.person_id%TYPE
155: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
149: --
150: -- ---------------------------------------------------------------------------
151: Procedure chk_routing_group_info
152: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
153: ,p_information_type in per_people_extra_info.information_type%TYPE
154: ,p_person_id in per_people_extra_info.person_id%TYPE
155: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
150: -- ---------------------------------------------------------------------------
151: Procedure chk_routing_group_info
152: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
153: ,p_information_type in per_people_extra_info.information_type%TYPE
154: ,p_person_id in per_people_extra_info.person_id%TYPE
155: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
151: Procedure chk_routing_group_info
152: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
153: ,p_information_type in per_people_extra_info.information_type%TYPE
154: ,p_person_id in per_people_extra_info.person_id%TYPE
155: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
152: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
153: ,p_information_type in per_people_extra_info.information_type%TYPE
154: ,p_person_id in per_people_extra_info.person_id%TYPE
155: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
160: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
153: ,p_information_type in per_people_extra_info.information_type%TYPE
154: ,p_person_id in per_people_extra_info.person_id%TYPE
155: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
160: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
161: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
154: ,p_person_id in per_people_extra_info.person_id%TYPE
155: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
160: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
161: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
162: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
155: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
160: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
161: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
162: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
163: );
156: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
160: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
161: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
162: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
163: );
164: --
157: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
160: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
161: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
162: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
163: );
164: --
165: Procedure chk_oghr_roles
158: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
159: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
160: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
161: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
162: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
163: );
164: --
165: Procedure chk_oghr_roles
166: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
162: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
163: );
164: --
165: Procedure chk_oghr_roles
166: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
167: ,p_information_type in per_people_extra_info.information_type%TYPE
168: ,p_person_id in per_people_extra_info.person_id%TYPE
169: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
163: );
164: --
165: Procedure chk_oghr_roles
166: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
167: ,p_information_type in per_people_extra_info.information_type%TYPE
168: ,p_person_id in per_people_extra_info.person_id%TYPE
169: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
164: --
165: Procedure chk_oghr_roles
166: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
167: ,p_information_type in per_people_extra_info.information_type%TYPE
168: ,p_person_id in per_people_extra_info.person_id%TYPE
169: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
165: Procedure chk_oghr_roles
166: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
167: ,p_information_type in per_people_extra_info.information_type%TYPE
168: ,p_person_id in per_people_extra_info.person_id%TYPE
169: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
166: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
167: ,p_information_type in per_people_extra_info.information_type%TYPE
168: ,p_person_id in per_people_extra_info.person_id%TYPE
169: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
174: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
167: ,p_information_type in per_people_extra_info.information_type%TYPE
168: ,p_person_id in per_people_extra_info.person_id%TYPE
169: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
174: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
175: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
168: ,p_person_id in per_people_extra_info.person_id%TYPE
169: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
174: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
175: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
176: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
169: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
174: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
175: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
176: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
177: );
170: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
174: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
175: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
176: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
177: );
178: --
171: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
174: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
175: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
176: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
177: );
178: --
179: --
172: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
173: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
174: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
175: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
176: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
177: );
178: --
179: --
180: end ghr_pei_flex_ddf;