APPS.PE_PEI_BUS dependencies on PER_PEOPLE_EXTRA_INFO

Line 29: ,per_people_extra_info pei

25: --
26: cursor csr_leg_code is
27: select pbg.legislation_code
28: from per_business_groups pbg
29: ,per_people_extra_info pei
30: ,per_all_people_f per
31: where pei.person_extra_info_id = p_person_extra_info_id
32: and per.person_id = pei.person_id
33: and pbg.business_group_id = per.business_group_id;

Line 191: (p_person_id in per_people_extra_info.person_id%TYPE

187: -- {End of Comments}
188: --
189: -- ---------------------------------------------------------------------------
190: procedure chk_person_id
191: (p_person_id in per_people_extra_info.person_id%TYPE
192: -- ,p_effective_date in date
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'chk_person_id';

Line 275: (p_information_type in per_people_extra_info.information_type%TYPE

271: -- {End of Comments}
272: --
273: -- ---------------------------------------------------------------------------
274: Procedure chk_information_type
275: (p_information_type in per_people_extra_info.information_type%TYPE
276: ,p_person_id in per_people_extra_info.person_id%TYPE) is
277: --
278: -- Declare local variables
279: --

Line 276: ,p_person_id in per_people_extra_info.person_id%TYPE) is

272: --
273: -- ---------------------------------------------------------------------------
274: Procedure chk_information_type
275: (p_information_type in per_people_extra_info.information_type%TYPE
276: ,p_person_id in per_people_extra_info.person_id%TYPE) is
277: --
278: -- Declare local variables
279: --
280: l_proc varchar2(72) := g_package||'chk_information_type';

Line 290: FROM per_people_extra_info pei

286: WHERE pit.information_type = p_information_type;
287: --
288: CURSOR csr_extra_info IS
289: SELECT 1
290: FROM per_people_extra_info pei
291: WHERE pei.information_type = p_information_type
292: AND pei.person_id = p_person_id ;
293: --
294: Begin

Line 314: -- to be checked by the constraint PER_PEOPLE_EXTRA_INFO_FK1 at DML time

310: hr_utility.set_location(l_proc, 10);
311: --
312: -- We would only come here if the information type was valid if it is not
313: -- valid then we do not want to do the following checks. We will leave the FK
314: -- to be checked by the constraint PER_PEOPLE_EXTRA_INFO_FK1 at DML time
315: -- Also leave the check it is mandatory to the database
316: --
317: -- Check to see the info type is still active
318: --

Line 456: ,p_descflex_name => 'PER_PEOPLE_EXTRA_INFO'

452: -- b) During insert.
453: --
454: hr_dflex_utility.ins_or_upd_descflex_attribs
455: (p_appl_short_name => 'PER'
456: ,p_descflex_name => 'PER_PEOPLE_EXTRA_INFO'
457: ,p_attribute_category => p_rec.pei_attribute_category
458: ,p_attribute1_name => 'PEI_ATTRIBUTE1'
459: ,p_attribute1_value => p_rec.pei_attribute1
460: ,p_attribute2_name => 'PEI_ATTRIBUTE2'