DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS2_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 158: l_per_ei_data per_people_extra_info%rowtype;

154: ,p_information28 IN OUT NOCOPY VARCHAR2
155: ,p_information29 IN OUT NOCOPY VARCHAR2
156: ,p_information30 IN OUT NOCOPY VARCHAR2) IS
157:
158: l_per_ei_data per_people_extra_info%rowtype;
159: -- NOCOPY Variables
160: l_information1 per_people_extra_info.pei_information1%type:= p_information1 ;
161: l_information2 per_people_extra_info.pei_information2%type:= p_information2 ;
162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;

Line 160: l_information1 per_people_extra_info.pei_information1%type:= p_information1 ;

156: ,p_information30 IN OUT NOCOPY VARCHAR2) IS
157:
158: l_per_ei_data per_people_extra_info%rowtype;
159: -- NOCOPY Variables
160: l_information1 per_people_extra_info.pei_information1%type:= p_information1 ;
161: l_information2 per_people_extra_info.pei_information2%type:= p_information2 ;
162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;
163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;
164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;

Line 161: l_information2 per_people_extra_info.pei_information2%type:= p_information2 ;

157:
158: l_per_ei_data per_people_extra_info%rowtype;
159: -- NOCOPY Variables
160: l_information1 per_people_extra_info.pei_information1%type:= p_information1 ;
161: l_information2 per_people_extra_info.pei_information2%type:= p_information2 ;
162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;
163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;
164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;
165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;

Line 162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;

158: l_per_ei_data per_people_extra_info%rowtype;
159: -- NOCOPY Variables
160: l_information1 per_people_extra_info.pei_information1%type:= p_information1 ;
161: l_information2 per_people_extra_info.pei_information2%type:= p_information2 ;
162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;
163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;
164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;
165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;
166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;

Line 163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;

159: -- NOCOPY Variables
160: l_information1 per_people_extra_info.pei_information1%type:= p_information1 ;
161: l_information2 per_people_extra_info.pei_information2%type:= p_information2 ;
162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;
163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;
164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;
165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;
166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;
167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;

Line 164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;

160: l_information1 per_people_extra_info.pei_information1%type:= p_information1 ;
161: l_information2 per_people_extra_info.pei_information2%type:= p_information2 ;
162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;
163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;
164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;
165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;
166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;
167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;
168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;

Line 165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;

161: l_information2 per_people_extra_info.pei_information2%type:= p_information2 ;
162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;
163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;
164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;
165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;
166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;
167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;
168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;
169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;

Line 166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;

162: l_information3 per_people_extra_info.pei_information3%type:= p_information3 ;
163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;
164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;
165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;
166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;
167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;
168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;
169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;
170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;

Line 167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;

163: l_information4 per_people_extra_info.pei_information4%type:= p_information4 ;
164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;
165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;
166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;
167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;
168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;
169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;
170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;
171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;

Line 168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;

164: l_information5 per_people_extra_info.pei_information5%type:= p_information5 ;
165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;
166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;
167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;
168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;
169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;
170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;
171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;
172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;

Line 169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;

165: l_information6 per_people_extra_info.pei_information6%type:= p_information6 ;
166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;
167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;
168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;
169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;
170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;
171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;
172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;
173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;

Line 170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;

166: l_information7 per_people_extra_info.pei_information7%type:= p_information7 ;
167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;
168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;
169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;
170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;
171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;
172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;
173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;
174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;

Line 171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;

167: l_information8 per_people_extra_info.pei_information8%type:= p_information8 ;
168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;
169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;
170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;
171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;
172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;
173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;
174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;
175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;

Line 172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;

168: l_information9 per_people_extra_info.pei_information9%type:= p_information9 ;
169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;
170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;
171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;
172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;
173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;
174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;
175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;
176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;

Line 173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;

169: l_information10 per_people_extra_info.pei_information10%type:= p_information10;
170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;
171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;
172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;
173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;
174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;
175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;
176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;
177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;

Line 174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;

170: l_information11 per_people_extra_info.pei_information11%type:= p_information11;
171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;
172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;
173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;
174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;
175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;
176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;
177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;
178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;

Line 175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;

171: l_information12 per_people_extra_info.pei_information12%type:= p_information12;
172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;
173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;
174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;
175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;
176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;
177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;
178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;
179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;

Line 176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;

172: l_information13 per_people_extra_info.pei_information13%type:= p_information13;
173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;
174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;
175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;
176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;
177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;
178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;
179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;
180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;

Line 177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;

173: l_information14 per_people_extra_info.pei_information14%type:= p_information14;
174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;
175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;
176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;
177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;
178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;
179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;
180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;
181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;

Line 178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;

174: l_information15 per_people_extra_info.pei_information15%type:= p_information15;
175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;
176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;
177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;
178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;
179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;
180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;
181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;
182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;

Line 179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;

175: l_information16 per_people_extra_info.pei_information16%type:= p_information16;
176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;
177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;
178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;
179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;
180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;
181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;
182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;
183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;

Line 180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;

176: l_information17 per_people_extra_info.pei_information17%type:= p_information17;
177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;
178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;
179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;
180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;
181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;
182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;
183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;
184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;

Line 181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;

177: l_information18 per_people_extra_info.pei_information18%type:= p_information18;
178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;
179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;
180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;
181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;
182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;
183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;
184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;
185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;

Line 182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;

178: l_information19 per_people_extra_info.pei_information19%type:= p_information19;
179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;
180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;
181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;
182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;
183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;
184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;
185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;
186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;

Line 183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;

179: l_information20 per_people_extra_info.pei_information20%type:= p_information20;
180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;
181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;
182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;
183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;
184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;
185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;
186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;
187: l_information28 per_people_extra_info.pei_information28%type:= p_information28;

Line 184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;

180: l_information21 per_people_extra_info.pei_information21%type:= p_information21;
181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;
182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;
183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;
184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;
185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;
186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;
187: l_information28 per_people_extra_info.pei_information28%type:= p_information28;
188: l_information29 per_people_extra_info.pei_information29%type:= p_information29;

Line 185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;

181: l_information22 per_people_extra_info.pei_information22%type:= p_information22;
182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;
183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;
184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;
185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;
186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;
187: l_information28 per_people_extra_info.pei_information28%type:= p_information28;
188: l_information29 per_people_extra_info.pei_information29%type:= p_information29;
189: l_information30 per_people_extra_info.pei_information30%type:= p_information30;

Line 186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;

182: l_information23 per_people_extra_info.pei_information23%type:= p_information23;
183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;
184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;
185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;
186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;
187: l_information28 per_people_extra_info.pei_information28%type:= p_information28;
188: l_information29 per_people_extra_info.pei_information29%type:= p_information29;
189: l_information30 per_people_extra_info.pei_information30%type:= p_information30;
190:

Line 187: l_information28 per_people_extra_info.pei_information28%type:= p_information28;

183: l_information24 per_people_extra_info.pei_information24%type:= p_information24;
184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;
185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;
186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;
187: l_information28 per_people_extra_info.pei_information28%type:= p_information28;
188: l_information29 per_people_extra_info.pei_information29%type:= p_information29;
189: l_information30 per_people_extra_info.pei_information30%type:= p_information30;
190:
191: BEGIN

Line 188: l_information29 per_people_extra_info.pei_information29%type:= p_information29;

184: l_information25 per_people_extra_info.pei_information25%type:= p_information25;
185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;
186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;
187: l_information28 per_people_extra_info.pei_information28%type:= p_information28;
188: l_information29 per_people_extra_info.pei_information29%type:= p_information29;
189: l_information30 per_people_extra_info.pei_information30%type:= p_information30;
190:
191: BEGIN
192: ghr_history_fetch.fetch_peopleei(

Line 189: l_information30 per_people_extra_info.pei_information30%type:= p_information30;

185: l_information26 per_people_extra_info.pei_information26%type:= p_information26;
186: l_information27 per_people_extra_info.pei_information27%type:= p_information27;
187: l_information28 per_people_extra_info.pei_information28%type:= p_information28;
188: l_information29 per_people_extra_info.pei_information29%type:= p_information29;
189: l_information30 per_people_extra_info.pei_information30%type:= p_information30;
190:
191: BEGIN
192: ghr_history_fetch.fetch_peopleei(
193: p_person_id => p_person_id