APPS.IRC_IVC_BUS dependencies on PER_ALL_PEOPLE_F

Line 266: -- If the person id is not found in per_all_people_f an error is generated.

262: -- {Start Of Comments}
263: --
264: -- Description:
265: -- This procedure is used to ensure that mandatory parameters have been set.
266: -- If the person id is not found in per_all_people_f an error is generated.
267: --
268: -- Pre Conditions:
269: -- g_old_rec has been populated with details of the values currently in
270: -- the database.

Line 295: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.

291: l_party_id irc_notification_preferences.party_id%type;
292: l_var varchar2(30);
293: --
294: --
295: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.
296: --
297: cursor csr_person_id is
298: select party_id
299: from per_all_people_f

Line 299: from per_all_people_f

295: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.
296: --
297: cursor csr_person_id is
298: select party_id
299: from per_all_people_f
300: where person_id = p_person_id;
301: --
302: -- Cursor to check that the Person can be contacted ie., to check
303: -- if the ALLOW_ACCESS = 'Y' in irc_notification_preferences

Line 314: -- Check if the person_id exists in PER_ALL_PEOPLE_F.

310: Begin
311: --
312: hr_utility.set_location(' Entering:'||l_proc,10);
313: --
314: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
315: --
316: open csr_person_id;
317: fetch csr_person_id into l_party_id;
318: hr_utility.set_location(l_proc, 30);