APPS.PER_RAA_BUS dependencies on PER_RAA_SHD

Line 182: (p_rec in per_raa_shd.g_rec_type

178: -- Internal Row Handler Use Only.
179: --
180: -- ----------------------------------------------------------------------------
181: procedure chk_df
182: (p_rec in per_raa_shd.g_rec_type
183: ) is
184: --
185: l_proc varchar2(72) := g_package || 'chk_df';
186: --

Line 191: nvl(per_raa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

187: begin
188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.recruitment_activity_id is not null) and (
191: nvl(per_raa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(per_raa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(per_raa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 193: nvl(per_raa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

189: --
190: if ((p_rec.recruitment_activity_id is not null) and (
191: nvl(per_raa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(per_raa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(per_raa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(per_raa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 195: nvl(per_raa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

191: nvl(per_raa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(per_raa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(per_raa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(per_raa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(per_raa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 197: nvl(per_raa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

193: nvl(per_raa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(per_raa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(per_raa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(per_raa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(per_raa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 199: nvl(per_raa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

195: nvl(per_raa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(per_raa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(per_raa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(per_raa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(per_raa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 201: nvl(per_raa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

197: nvl(per_raa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(per_raa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(per_raa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(per_raa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(per_raa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 203: nvl(per_raa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

199: nvl(per_raa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(per_raa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(per_raa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(per_raa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(per_raa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 205: nvl(per_raa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

201: nvl(per_raa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(per_raa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(per_raa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(per_raa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(per_raa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 207: nvl(per_raa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

203: nvl(per_raa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(per_raa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(per_raa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(per_raa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(per_raa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 209: nvl(per_raa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

205: nvl(per_raa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(per_raa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(per_raa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(per_raa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(per_raa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 211: nvl(per_raa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

207: nvl(per_raa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(per_raa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(per_raa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(per_raa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(per_raa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 213: nvl(per_raa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

209: nvl(per_raa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(per_raa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(per_raa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(per_raa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(per_raa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 215: nvl(per_raa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

211: nvl(per_raa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(per_raa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(per_raa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(per_raa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(per_raa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 217: nvl(per_raa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

213: nvl(per_raa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(per_raa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(per_raa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(per_raa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(per_raa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 219: nvl(per_raa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

215: nvl(per_raa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(per_raa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(per_raa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(per_raa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(per_raa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 221: nvl(per_raa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

217: nvl(per_raa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(per_raa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(per_raa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(per_raa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(per_raa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 223: nvl(per_raa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

219: nvl(per_raa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(per_raa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(per_raa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(per_raa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(per_raa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 225: nvl(per_raa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

221: nvl(per_raa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(per_raa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(per_raa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(per_raa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(per_raa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 227: nvl(per_raa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

223: nvl(per_raa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(per_raa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(per_raa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(per_raa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(per_raa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 229: nvl(per_raa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

225: nvl(per_raa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(per_raa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(per_raa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(per_raa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: or (p_rec.recruitment_activity_id is null) then

Line 231: nvl(per_raa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

227: nvl(per_raa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(per_raa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(per_raa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: or (p_rec.recruitment_activity_id is null) then
234: --
235: -- Only execute the validation if absolutely necessary:

Line 318: (p_rec in per_raa_shd.g_rec_type

314: --
315: -- {End Of Comments}
316: -- ----------------------------------------------------------------------------
317: Procedure chk_non_updateable_args
318: (p_rec in per_raa_shd.g_rec_type
319: ) IS
320: --
321: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
322: --

Line 328: if NOT per_raa_shd.api_updating

324: --
325: -- Only proceed with the validation if a row exists for the current
326: -- record in the HR Schema.
327: --
328: if NOT per_raa_shd.api_updating
329: (p_recruitment_activity_id => p_rec.recruitment_activity_id
330: ,p_object_version_number => p_rec.object_version_number
331: ) THEN
332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 340: if p_rec.business_group_id <> per_raa_shd.g_old_rec.business_group_id then

336: END if;
337: --
338: -- Add checks to ensure non-updateable args have
339: -- not been updated.
340: if p_rec.business_group_id <> per_raa_shd.g_old_rec.business_group_id then
341: hr_api.argument_changed_error
342: (p_api_name => l_proc
343: ,p_argument => 'BUSINESS_GROUP_ID'
344: ,p_base_table => per_raa_shd.g_tab_nam

Line 344: ,p_base_table => per_raa_shd.g_tab_nam

340: if p_rec.business_group_id <> per_raa_shd.g_old_rec.business_group_id then
341: hr_api.argument_changed_error
342: (p_api_name => l_proc
343: ,p_argument => 'BUSINESS_GROUP_ID'
344: ,p_base_table => per_raa_shd.g_tab_nam
345: );
346: end if;
347:
348: if p_rec.recruitment_activity_id <> per_raa_shd.g_old_rec.recruitment_activity_id then

Line 348: if p_rec.recruitment_activity_id <> per_raa_shd.g_old_rec.recruitment_activity_id then

344: ,p_base_table => per_raa_shd.g_tab_nam
345: );
346: end if;
347:
348: if p_rec.recruitment_activity_id <> per_raa_shd.g_old_rec.recruitment_activity_id then
349: hr_api.argument_changed_error
350: (p_api_name => l_proc
351: ,p_argument => 'RECRUITMENT_ACTIVITY_ID'
352: ,p_base_table => per_raa_shd.g_tab_nam

Line 352: ,p_base_table => per_raa_shd.g_tab_nam

348: if p_rec.recruitment_activity_id <> per_raa_shd.g_old_rec.recruitment_activity_id then
349: hr_api.argument_changed_error
350: (p_api_name => l_proc
351: ,p_argument => 'RECRUITMENT_ACTIVITY_ID'
352: ,p_base_table => per_raa_shd.g_tab_nam
353: );
354: end if;
355: --
356: End chk_non_updateable_args;

Line 408: l_api_updating := per_raa_shd.api_updating

404: ,p_argument => 'NAME'
405: ,p_argument_value => p_name
406: );
407: --
408: l_api_updating := per_raa_shd.api_updating
409: (p_recruitment_activity_id => p_recruitment_activity_id
410: ,p_object_version_number => p_object_version_number);
411: hr_utility.set_location(l_proc,20);
412: if(l_api_updating and

Line 414: NVL(per_raa_shd.g_old_rec.name,hr_api.g_varchar2)

410: ,p_object_version_number => p_object_version_number);
411: hr_utility.set_location(l_proc,20);
412: if(l_api_updating and
413: p_name <>
414: NVL(per_raa_shd.g_old_rec.name,hr_api.g_varchar2)
415: ) or (NOT l_api_updating) then
416: hr_utility.set_location(l_proc,30);
417: open csr_name;
418: fetch csr_name into l_name;

Line 506: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

502: begin
503: hr_utility.set_location('Entering:'||l_proc,10);
504: --
505: l_api_updating :=
506: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
507: hr_utility.set_location(l_proc,20);
508: if p_authorising_person_id is not null then
509: if (l_api_updating and
510: p_authorising_person_id <>

Line 511: NVL(per_raa_shd.g_old_rec.authorising_person_id,hr_api.g_number)

507: hr_utility.set_location(l_proc,20);
508: if p_authorising_person_id is not null then
509: if (l_api_updating and
510: p_authorising_person_id <>
511: NVL(per_raa_shd.g_old_rec.authorising_person_id,hr_api.g_number)
512: ) or (NOT l_api_updating) then
513:
514: -- check that authorising_person_id exists in per_all_people_f.
515: hr_utility.set_location(l_proc,30);

Line 600: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

596: begin
597: hr_utility.set_location('Entering:'||l_proc,10);
598: --
599: l_api_updating :=
600: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
601: hr_utility.set_location(l_proc,20);
602: if p_run_by_organization_id is not null then
603: if (l_api_updating and
604: p_run_by_organization_id <>

Line 605: NVL(per_raa_shd.g_old_rec.run_by_organization_id,hr_api.g_number))

601: hr_utility.set_location(l_proc,20);
602: if p_run_by_organization_id is not null then
603: if (l_api_updating and
604: p_run_by_organization_id <>
605: NVL(per_raa_shd.g_old_rec.run_by_organization_id,hr_api.g_number))
606: or (NOT l_api_updating) then
607:
608: -- check that run_by_organization_id exists in per_all_people_f.
609: hr_utility.set_location(l_proc,30);

Line 701: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

697: begin
698: hr_utility.set_location('Entering:'||l_proc,10);
699: --
700: l_api_updating :=
701: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
702: hr_utility.set_location(l_proc,20);
703: if p_internal_contact_person_id is not null then
704: if (l_api_updating and
705: p_internal_contact_person_id <>

Line 706: NVL(per_raa_shd.g_old_rec.internal_contact_person_id,hr_api.g_number))

702: hr_utility.set_location(l_proc,20);
703: if p_internal_contact_person_id is not null then
704: if (l_api_updating and
705: p_internal_contact_person_id <>
706: NVL(per_raa_shd.g_old_rec.internal_contact_person_id,hr_api.g_number))
707: or (NOT l_api_updating) then
708:
709: -- check that internal_contact_person_id exists in per_all_people_f.
710: hr_utility.set_location(l_proc,30);

Line 820: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

816: begin
817: hr_utility.set_location('Entering:'||l_proc,10);
818: --
819: l_api_updating :=
820: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
821: hr_utility.set_location(l_proc,20);
822:
823: if p_parent_recruitment_activity is not null then
824: if (l_api_updating and

Line 826: NVL(per_raa_shd.g_old_rec.parent_recruitment_activity_id,hr_api.g_number)

822:
823: if p_parent_recruitment_activity is not null then
824: if (l_api_updating and
825: (p_parent_recruitment_activity <>
826: NVL(per_raa_shd.g_old_rec.parent_recruitment_activity_id,hr_api.g_number)
827: or
828: p_recruitment_activity_id <>
829: per_raa_shd.g_old_rec.recruitment_activity_id))
830: or (NOT l_api_updating) then

Line 829: per_raa_shd.g_old_rec.recruitment_activity_id))

825: (p_parent_recruitment_activity <>
826: NVL(per_raa_shd.g_old_rec.parent_recruitment_activity_id,hr_api.g_number)
827: or
828: p_recruitment_activity_id <>
829: per_raa_shd.g_old_rec.recruitment_activity_id))
830: or (NOT l_api_updating) then
831:
832: -- Checks that parent recruitment activity id exists in
833: -- PER_RECRUITMENT_ACTIVITIES.

Line 939: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

935: begin
936: hr_utility.set_location('Entering:'||l_proc,10);
937: --
938: l_api_updating :=
939: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
940: hr_utility.set_location(l_proc,20);
941: if p_currency_code is not null then
942: if (l_api_updating and
943: p_currency_code <>

Line 944: NVL(per_raa_shd.g_old_rec.currency_code,hr_api.g_number))

940: hr_utility.set_location(l_proc,20);
941: if p_currency_code is not null then
942: if (l_api_updating and
943: p_currency_code <>
944: NVL(per_raa_shd.g_old_rec.currency_code,hr_api.g_number))
945: or (NOT l_api_updating) then
946:
947: -- check that currency_code exists in FND_CURRENCIES.
948: hr_utility.set_location(l_proc,30);

Line 1023: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

1019: begin
1020: hr_utility.set_location('Entering:'||l_proc,10);
1021: --
1022: l_api_updating :=
1023: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1024: hr_utility.set_location(l_proc,20);
1025: if p_recruiting_site_id is not null then
1026: if (l_api_updating and
1027: p_recruiting_site_id <>

Line 1028: NVL(per_raa_shd.g_old_rec.recruiting_site_id,hr_api.g_number)

1024: hr_utility.set_location(l_proc,20);
1025: if p_recruiting_site_id is not null then
1026: if (l_api_updating and
1027: p_recruiting_site_id <>
1028: NVL(per_raa_shd.g_old_rec.recruiting_site_id,hr_api.g_number)
1029: ) or (NOT l_api_updating) then
1030:
1031: -- check that recruiting_site_id exists in IRC_ALL_RECRUITING_SITES.
1032: hr_utility.set_location(l_proc,30);

Line 1106: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

1102: begin
1103: hr_utility.set_location('Entering:'||l_proc,10);
1104: --
1105: l_api_updating :=
1106: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1107: hr_utility.set_location(l_proc,20);
1108: if p_posting_content_id is not null then
1109: if (l_api_updating and
1110: p_posting_content_id <>

Line 1111: NVL(per_raa_shd.g_old_rec.posting_content_id,hr_api.g_number)

1107: hr_utility.set_location(l_proc,20);
1108: if p_posting_content_id is not null then
1109: if (l_api_updating and
1110: p_posting_content_id <>
1111: NVL(per_raa_shd.g_old_rec.posting_content_id,hr_api.g_number)
1112: ) or (NOT l_api_updating) then
1113:
1114: -- check that posting_content_id exists in IRC_POSTING_CONTENTS.
1115: hr_utility.set_location(l_proc,30);

Line 1188: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

1184: begin
1185: hr_utility.set_location('Entering:'||l_proc,10);
1186: --
1187: l_api_updating :=
1188: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1189: hr_utility.set_location(l_proc,20);
1190: if (l_api_updating and
1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start
1192: or NVL(p_date_end,hr_api.g_eot) <>

Line 1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start

1187: l_api_updating :=
1188: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1189: hr_utility.set_location(l_proc,20);
1190: if (l_api_updating and
1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start
1192: or NVL(p_date_end,hr_api.g_eot) <>
1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))
1194: ) or (NOT l_api_updating) then
1195: -- Checks that date_start is not null.

Line 1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))

1189: hr_utility.set_location(l_proc,20);
1190: if (l_api_updating and
1191: (NVL(p_date_start,hr_api.g_eot) <> per_raa_shd.g_old_rec.date_start
1192: or NVL(p_date_end,hr_api.g_eot) <>
1193: NVL(per_raa_shd.g_old_rec.date_end,hr_api.g_eot))
1194: ) or (NOT l_api_updating) then
1195: -- Checks that date_start is not null.
1196: hr_utility.set_location(l_proc,30);
1197: if p_date_start is null then

Line 1268: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

1264: begin
1265: hr_utility.set_location('Entering:'||l_proc,10);
1266: --
1267: l_api_updating :=
1268: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1269: hr_utility.set_location(l_proc,20);
1270: if p_type is not null then
1271: if (l_api_updating and
1272: p_type <> NVL(per_raa_shd.g_old_rec.type,hr_api.g_varchar2))

Line 1272: p_type <> NVL(per_raa_shd.g_old_rec.type,hr_api.g_varchar2))

1268: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1269: hr_utility.set_location(l_proc,20);
1270: if p_type is not null then
1271: if (l_api_updating and
1272: p_type <> NVL(per_raa_shd.g_old_rec.type,hr_api.g_varchar2))
1273: or (NOT l_api_updating) then
1274:
1275: -- Checks that type is validated against hr_lookups.
1276: hr_utility.set_location(l_proc,30);

Line 1348: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

1344: begin
1345: hr_utility.set_location('Entering:'||l_proc,10);
1346: --
1347: l_api_updating :=
1348: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1349: hr_utility.set_location(l_proc,20);
1350: if p_date_closing is not null then
1351: if (l_api_updating and
1352: (NVL(p_date_closing,hr_api.g_eot) <>

Line 1353: NVL(per_raa_shd.g_old_rec.date_closing,hr_api.g_eot)

1349: hr_utility.set_location(l_proc,20);
1350: if p_date_closing is not null then
1351: if (l_api_updating and
1352: (NVL(p_date_closing,hr_api.g_eot) <>
1353: NVL(per_raa_shd.g_old_rec.date_closing,hr_api.g_eot)
1354: or p_date_start <> per_raa_shd.g_old_rec.date_start))
1355: or (NOT l_api_updating) then
1356:
1357: -- Checks that date_start is not later then corresponding date_closing

Line 1354: or p_date_start <> per_raa_shd.g_old_rec.date_start))

1350: if p_date_closing is not null then
1351: if (l_api_updating and
1352: (NVL(p_date_closing,hr_api.g_eot) <>
1353: NVL(per_raa_shd.g_old_rec.date_closing,hr_api.g_eot)
1354: or p_date_start <> per_raa_shd.g_old_rec.date_start))
1355: or (NOT l_api_updating) then
1356:
1357: -- Checks that date_start is not later then corresponding date_closing
1358: hr_utility.set_location(l_proc,30);

Line 1428: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

1424: begin
1425: hr_utility.set_location('Entering:'||l_proc,10);
1426: --
1427: l_api_updating :=
1428: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1429: hr_utility.set_location(l_proc,20);
1430: if p_status is not null then
1431: if (l_api_updating and
1432: p_status <> NVL(per_raa_shd.g_old_rec.status,hr_api.g_varchar2))

Line 1432: p_status <> NVL(per_raa_shd.g_old_rec.status,hr_api.g_varchar2))

1428: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1429: hr_utility.set_location(l_proc,20);
1430: if p_status is not null then
1431: if (l_api_updating and
1432: p_status <> NVL(per_raa_shd.g_old_rec.status,hr_api.g_varchar2))
1433: or (NOT l_api_updating) then
1434:
1435: -- Checks that status is validated against hr_lookups.
1436: hr_utility.set_location(l_proc,30);

Line 1505: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

1501: begin
1502: hr_utility.set_location('Entering:'||l_proc,10);
1503: --
1504: l_api_updating :=
1505: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1506: hr_utility.set_location(l_proc,20);
1507: if p_actual_cost is not null then
1508: if (l_api_updating and
1509: p_actual_cost <>

Line 1510: NVL(per_raa_shd.g_old_rec.actual_cost,hr_api.g_number))

1506: hr_utility.set_location(l_proc,20);
1507: if p_actual_cost is not null then
1508: if (l_api_updating and
1509: p_actual_cost <>
1510: NVL(per_raa_shd.g_old_rec.actual_cost,hr_api.g_number))
1511: or (NOT l_api_updating) then
1512:
1513: -- Checks that actual_cost is greater then zero
1514: hr_utility.set_location(l_proc,30);

Line 1580: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);

1576: begin
1577: hr_utility.set_location('Entering:'||l_proc,10);
1578: --
1579: l_api_updating :=
1580: per_raa_shd.api_updating(p_recruitment_activity_id,p_object_version_number);
1581: hr_utility.set_location(l_proc,20);
1582: if p_planned_cost is not null then
1583: if (l_api_updating and
1584: p_planned_cost <>

Line 1585: NVL(per_raa_shd.g_old_rec.planned_cost,hr_api.g_number))

1581: hr_utility.set_location(l_proc,20);
1582: if p_planned_cost is not null then
1583: if (l_api_updating and
1584: p_planned_cost <>
1585: NVL(per_raa_shd.g_old_rec.planned_cost,hr_api.g_number))
1586: or (NOT l_api_updating) then
1587:
1588: -- Checks that planned_cost is greater then zero
1589: hr_utility.set_location(l_proc,30);

Line 1615: (p_rec in per_raa_shd.g_rec_type

1611: -- ----------------------------------------------------------------------------
1612: -- |---------------------------< insert_validate >----------------------------|
1613: -- ----------------------------------------------------------------------------
1614: Procedure insert_validate
1615: (p_rec in per_raa_shd.g_rec_type
1616: ) is
1617: --
1618: l_proc varchar2(72) := g_package||'insert_validate';
1619: --

Line 1630: ,p_associated_column1 => per_raa_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

1626: --
1627: -- Validate Bus Grp
1628: hr_api.validate_bus_grp_id
1629: (p_business_group_id => p_rec.business_group_id
1630: ,p_associated_column1 => per_raa_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
1631: );
1632: --
1633: -- After validating the set of important attributes,
1634: -- if Mulitple message detection is enabled and at least

Line 1747: (p_rec in per_raa_shd.g_rec_type

1743: -- ----------------------------------------------------------------------------
1744: -- |---------------------------< update_validate >----------------------------|
1745: -- ----------------------------------------------------------------------------
1746: Procedure update_validate
1747: (p_rec in per_raa_shd.g_rec_type
1748: ) is
1749: --
1750: l_proc varchar2(72) := g_package||'update_validate';
1751: --

Line 1762: ,p_associated_column1 => per_raa_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

1758: --
1759: -- Validate Bus Grp
1760: hr_api.validate_bus_grp_id(
1761: p_business_group_id => p_rec.business_group_id
1762: ,p_associated_column1 => per_raa_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
1763: );
1764: --
1765: -- After validating the set of important attributes,
1766: -- if Mulitple message detection is enabled and at least

Line 1853: per_raa_shd.g_old_rec.business_group_id

1849: =>
1850: p_rec.parent_recruitment_activity_id
1851: ,p_date_start => p_rec.date_start
1852: ,p_business_group_id =>
1853: per_raa_shd.g_old_rec.business_group_id
1854: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1855: ,p_object_version_number => p_rec.object_version_number);
1856: --
1857: hr_utility.set_location(l_proc,70);

Line 1886: (p_rec in per_raa_shd.g_rec_type

1882: -- ----------------------------------------------------------------------------
1883: -- |---------------------------< delete_validate >----------------------------|
1884: -- ----------------------------------------------------------------------------
1885: Procedure delete_validate
1886: (p_rec in per_raa_shd.g_rec_type
1887: ) is
1888: --
1889: l_proc varchar2(72) := g_package||'delete_validate';
1890: --