DBA Data[Home] [Help]

APPS.GHR_PEI_FLEX_DDF dependencies on PER_PEOPLE_EXTRA_INFO

Line 152: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE

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

Line 153: ,p_information_type in per_people_extra_info.information_type%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

Line 154: ,p_person_id in per_people_extra_info.person_id%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

Line 155: ,p_pei_information3 in per_people_extra_info.pei_information3%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

Line 156: ,p_pei_information4 in per_people_extra_info.pei_information4%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

Line 157: ,p_pei_information5 in per_people_extra_info.pei_information5%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

Line 158: ,p_pei_information6 in per_people_extra_info.pei_information6%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

Line 159: ,p_pei_information7 in per_people_extra_info.pei_information7%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: );

Line 160: ,p_pei_information8 in per_people_extra_info.pei_information8%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: );
164: --

Line 161: ,p_pei_information9 in per_people_extra_info.pei_information9%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: --
165: Procedure chk_oghr_roles

Line 162: ,p_pei_information10 in per_people_extra_info.pei_information10%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
166: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE

Line 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

Line 167: ,p_information_type in per_people_extra_info.information_type%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

Line 168: ,p_person_id in per_people_extra_info.person_id%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

Line 169: ,p_pei_information3 in per_people_extra_info.pei_information3%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

Line 170: ,p_pei_information4 in per_people_extra_info.pei_information4%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

Line 171: ,p_pei_information5 in per_people_extra_info.pei_information5%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

Line 172: ,p_pei_information6 in per_people_extra_info.pei_information6%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

Line 173: ,p_pei_information7 in per_people_extra_info.pei_information7%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: );

Line 174: ,p_pei_information8 in per_people_extra_info.pei_information8%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: );
178: --

Line 175: ,p_pei_information9 in per_people_extra_info.pei_information9%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: --
179: --

Line 176: ,p_pei_information10 in per_people_extra_info.pei_information10%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: --
180: end ghr_pei_flex_ddf;