APPS.IRC_IDO_BUS dependencies on PER_ALL_PEOPLE_F

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

130: -- {Start Of Comments}
131: --
132: -- Description:
133: -- This procedure is used to ensure that mandatory parameters have been set.
134: -- If the person id is not found in per_all_people_f an error is generated.
135: --
136: -- Pre Conditions:
137: -- None.
138: --

Line 149: -- 1: p_rec.p_person_id does not exist in PER_ALL_PEOPLE_F

145: -- Processing continues.
146: --
147: -- Post Failure:
148: -- An application error will be raised for the following faliure conditions:
149: -- 1: p_rec.p_person_id does not exist in PER_ALL_PEOPLE_F
150: --
151: -- Access Status:
152: -- Internal Table Handler Use Only.
153: Procedure chk_person_id

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

159: l_party_id irc_documents.party_id%type;
160: l_var varchar2(30);
161: --
162: --
163: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.
164: --
165: cursor csr_person_id is
166: select per.party_id
167: from per_all_people_f per

Line 167: from per_all_people_f per

163: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.
164: --
165: cursor csr_person_id is
166: select per.party_id
167: from per_all_people_f per
168: where per.person_id = p_person_id
169: and p_effective_date between effective_start_date and effective_end_date;
170: Begin
171: --

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

170: Begin
171: --
172: hr_utility.set_location(' Entering:'||l_proc,10);
173: --
174: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
175: --
176: open csr_person_id;
177: fetch csr_person_id into l_party_id;
178: hr_utility.set_location(l_proc, 30);