APPS.IRC_APS_BUS dependencies on PER_ALL_PEOPLE_F

Line 223: -- Verifies that the person_id exists in PER_ALL_PEOPLE_F.

219: -- |---------------------------< chk_person_id >-----------------------------|
220: -- ----------------------------------------------------------------------------
221: --
222: -- Description:
223: -- Verifies that the person_id exists in PER_ALL_PEOPLE_F.
224: --
225: -- Prerequisites:
226: -- Must be called as the first step in insert_validate.
227: --

Line 232: -- If person_id exists in PER_ALL_PEOPLE_F, then continue.

228: -- In Arguments:
229: -- p_person_id
230: --
231: -- Post Success:
232: -- If person_id exists in PER_ALL_PEOPLE_F, then continue.
233: --
234: -- Post Failure:
235: -- If the person_id does not exists in PER_ALL_PEOPLE_F, then throw
236: -- an error indicating the same.

Line 235: -- If the person_id does not exists in PER_ALL_PEOPLE_F, then throw

231: -- Post Success:
232: -- If person_id exists in PER_ALL_PEOPLE_F, then continue.
233: --
234: -- Post Failure:
235: -- If the person_id does not exists in PER_ALL_PEOPLE_F, then throw
236: -- an error indicating the same.
237: --
238: -- Access Status:
239: -- Internal Row Handler Use Only.

Line 257: from per_all_people_f

253: l_dummy varchar2(1);
254: --
255: cursor person_exists(p_person_id number) is
256: select null
257: from per_all_people_f
258: where person_id = p_person_id;
259: --
260: Begin
261: --

Line 279: -- p_person_id must exist in PER_ALL_PEOPLE_F

275: -- Check if p_person_id is not null
276: --
277: if p_person_id IS NOT NULL then
278: --
279: -- p_person_id must exist in PER_ALL_PEOPLE_F
280: --
281: open person_exists(p_person_id);
282: fetch person_exists into l_dummy;
283: --