eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PEI_FLEX_DDF dependencies on PER_PEOPLE_EXTRA_INFO

Line 202: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE

198: -- {End of Comments}
199: --
200: -- ---------------------------------------------------------------------------
201: Procedure chk_routing_group_info
202: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
203: ,p_information_type in per_people_extra_info.information_type%TYPE
204: ,p_person_id in per_people_extra_info.person_id%TYPE
205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE

Line 203: ,p_information_type in per_people_extra_info.information_type%TYPE

199: --
200: -- ---------------------------------------------------------------------------
201: Procedure chk_routing_group_info
202: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
203: ,p_information_type in per_people_extra_info.information_type%TYPE
204: ,p_person_id in per_people_extra_info.person_id%TYPE
205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE

Line 204: ,p_person_id in per_people_extra_info.person_id%TYPE

200: -- ---------------------------------------------------------------------------
201: Procedure chk_routing_group_info
202: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
203: ,p_information_type in per_people_extra_info.information_type%TYPE
204: ,p_person_id in per_people_extra_info.person_id%TYPE
205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE

Line 205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE

201: Procedure chk_routing_group_info
202: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
203: ,p_information_type in per_people_extra_info.information_type%TYPE
204: ,p_person_id in per_people_extra_info.person_id%TYPE
205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE

Line 206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE

202: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
203: ,p_information_type in per_people_extra_info.information_type%TYPE
204: ,p_person_id in per_people_extra_info.person_id%TYPE
205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
210: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE

Line 207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE

203: ,p_information_type in per_people_extra_info.information_type%TYPE
204: ,p_person_id in per_people_extra_info.person_id%TYPE
205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
210: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
211: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE

Line 208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE

204: ,p_person_id in per_people_extra_info.person_id%TYPE
205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
210: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
211: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
212: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE

Line 209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE

205: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
210: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
211: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
212: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
213: ) is

Line 210: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE

206: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
210: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
211: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
212: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
213: ) is
214: --

Line 211: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE

207: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
210: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
211: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
212: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
213: ) is
214: --
215: -- Declare local variables

Line 212: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE

208: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
209: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
210: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
211: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
212: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
213: ) is
214: --
215: -- Declare local variables
216: --

Line 224: FROM per_people_extra_info

220: Begin
221: --
222: SELECT count(*)
223: INTO l_count
224: FROM per_people_extra_info
225: WHERE information_type = p_information_type
226: AND person_id = p_person_id
227: AND pei_information3 = p_pei_information3
228: AND person_extra_info_id <> nvl(p_person_extra_info_id,-9999);

Line 248: FROM per_people_extra_info

244: --
245: if p_pei_information10 in ('Y','y') then
246: SELECT count(*)
247: INTO l_count
248: FROM per_people_extra_info
249: WHERE information_type = p_information_type
250: AND person_id = p_person_id
251: AND pei_information10 = p_pei_information10
252: AND person_extra_info_id <> nvl(p_person_extra_info_id,-9999);

Line 272: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE

268: --
269: End chk_routing_group_info;
270:
271: Procedure chk_oghr_roles
272: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
273: ,p_information_type in per_people_extra_info.information_type%TYPE
274: ,p_person_id in per_people_extra_info.person_id%TYPE
275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE

Line 273: ,p_information_type in per_people_extra_info.information_type%TYPE

269: End chk_routing_group_info;
270:
271: Procedure chk_oghr_roles
272: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
273: ,p_information_type in per_people_extra_info.information_type%TYPE
274: ,p_person_id in per_people_extra_info.person_id%TYPE
275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE

Line 274: ,p_person_id in per_people_extra_info.person_id%TYPE

270:
271: Procedure chk_oghr_roles
272: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
273: ,p_information_type in per_people_extra_info.information_type%TYPE
274: ,p_person_id in per_people_extra_info.person_id%TYPE
275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE

Line 275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE

271: Procedure chk_oghr_roles
272: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
273: ,p_information_type in per_people_extra_info.information_type%TYPE
274: ,p_person_id in per_people_extra_info.person_id%TYPE
275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE

Line 276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE

272: (p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
273: ,p_information_type in per_people_extra_info.information_type%TYPE
274: ,p_person_id in per_people_extra_info.person_id%TYPE
275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
280: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE

Line 277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE

273: ,p_information_type in per_people_extra_info.information_type%TYPE
274: ,p_person_id in per_people_extra_info.person_id%TYPE
275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
280: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
281: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE

Line 278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE

274: ,p_person_id in per_people_extra_info.person_id%TYPE
275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
280: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
281: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
282: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE

Line 279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE

275: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
280: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
281: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
282: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
283: ) is

Line 280: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE

276: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
280: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
281: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
282: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
283: ) is
284: --

Line 281: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE

277: ,p_pei_information5 in per_people_extra_info.pei_information5%TYPE
278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
280: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
281: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
282: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
283: ) is
284: --
285: -- Declare local variables

Line 282: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE

278: ,p_pei_information6 in per_people_extra_info.pei_information6%TYPE
279: ,p_pei_information7 in per_people_extra_info.pei_information7%TYPE
280: ,p_pei_information8 in per_people_extra_info.pei_information8%TYPE
281: ,p_pei_information9 in per_people_extra_info.pei_information9%TYPE
282: ,p_pei_information10 in per_people_extra_info.pei_information10%TYPE
283: ) is
284: --
285: -- Declare local variables
286: --

Line 329: FROM per_people_extra_info

325: ,p_pei_information7 varchar2
326: ,p_pei_information8 varchar2) IS
327: CURSOR c_rno(c_person_id per_all_people_f.person_id%type) IS
328: SELECT pei_information5 race
329: FROM per_people_extra_info
330: WHERE person_id = c_person_id
331: AND information_type = 'GHR_US_PER_GROUP1';
332: l_race per_people_extra_info.pei_information5%type;
333: l_ethnicity varchar2(250);

Line 332: l_race per_people_extra_info.pei_information5%type;

328: SELECT pei_information5 race
329: FROM per_people_extra_info
330: WHERE person_id = c_person_id
331: AND information_type = 'GHR_US_PER_GROUP1';
332: l_race per_people_extra_info.pei_information5%type;
333: l_ethnicity varchar2(250);
334:
335: BEGIN
336: l_ethnicity := NULL;