APPS.PER_PDM_BUS dependencies on HR_API

Line 47: hr_api.argument_changed_error

43: hr_utility.set_location(l_proc, 50);
44: --
45: exception
46: when l_error then
47: hr_api.argument_changed_error
48: (p_api_name => l_proc
49: ,p_argument => l_argument
50: );
51: when others then

Line 186: hr_api.mandatory_arg_error

182: -----------------------------------
183: -- Check that person id is not null
184: -----------------------------------
185: --
186: hr_api.mandatory_arg_error
187: (p_api_name => l_proc
188: ,p_argument => 'person_id'
189: ,p_argument_value => p_person_id
190: );

Line 194: <> nvl(per_pdm_shd.g_old_rec.comm_dlvry_method,hr_api.g_varchar2) )

190: );
191:
192: --
193: if (p_comm_dlvry_method
194: <> nvl(per_pdm_shd.g_old_rec.comm_dlvry_method,hr_api.g_varchar2) )
195: and p_comm_dlvry_method is not null then
196: --
197: -- check if value of lookup falls within lookup type.
198: --

Line 199: if hr_api.not_exists_in_hr_lookups

195: and p_comm_dlvry_method is not null then
196: --
197: -- check if value of lookup falls within lookup type.
198: --
199: if hr_api.not_exists_in_hr_lookups
200: (p_lookup_type => 'PER_CM_MTHD',
201: p_lookup_code => p_comm_dlvry_method,
202: p_effective_date => p_effective_date) then
203: --

Line 284: if ((nvl(per_pdm_shd.g_old_rec.date_start,hr_api.g_date)

280: -- Only proceed with validation if :
281: -- a) The current g_old_rec is current and
282: -- b) The date_start or date_start value has changed
283: --
284: if ((nvl(per_pdm_shd.g_old_rec.date_start,hr_api.g_date)
285: <> nvl(p_date_start,hr_api.g_date)
286: or nvl(per_pdm_shd.g_old_rec.date_end,hr_api.g_date)
287: <> nvl(p_date_end,hr_api.g_date)))
288: then

Line 285: <> nvl(p_date_start,hr_api.g_date)

281: -- a) The current g_old_rec is current and
282: -- b) The date_start or date_start value has changed
283: --
284: if ((nvl(per_pdm_shd.g_old_rec.date_start,hr_api.g_date)
285: <> nvl(p_date_start,hr_api.g_date)
286: or nvl(per_pdm_shd.g_old_rec.date_end,hr_api.g_date)
287: <> nvl(p_date_end,hr_api.g_date)))
288: then
289: hr_utility.set_location(l_proc, 2);

Line 286: or nvl(per_pdm_shd.g_old_rec.date_end,hr_api.g_date)

282: -- b) The date_start or date_start value has changed
283: --
284: if ((nvl(per_pdm_shd.g_old_rec.date_start,hr_api.g_date)
285: <> nvl(p_date_start,hr_api.g_date)
286: or nvl(per_pdm_shd.g_old_rec.date_end,hr_api.g_date)
287: <> nvl(p_date_end,hr_api.g_date)))
288: then
289: hr_utility.set_location(l_proc, 2);
290: --

Line 287: <> nvl(p_date_end,hr_api.g_date)))

283: --
284: if ((nvl(per_pdm_shd.g_old_rec.date_start,hr_api.g_date)
285: <> nvl(p_date_start,hr_api.g_date)
286: or nvl(per_pdm_shd.g_old_rec.date_end,hr_api.g_date)
287: <> nvl(p_date_end,hr_api.g_date)))
288: then
289: hr_utility.set_location(l_proc, 2);
290: --
291: -- Check that the date_start value is less than or equal to the date_start

Line 294: if p_date_start > nvl(p_date_end,hr_api.g_eot)then

290: --
291: -- Check that the date_start value is less than or equal to the date_start
292: -- value for the current record
293: --
294: if p_date_start > nvl(p_date_end,hr_api.g_eot)then
295: hr_utility.set_message(801,'PER_7004_ALL_DATE_TO_FROM');
296: hr_utility.raise_error;
297: end if;
298: end if;

Line 353: if (nvl(p_preferred_flag, hr_api.g_varchar2)

349: Begin
350: --
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: if (nvl(p_preferred_flag, hr_api.g_varchar2)
354: <> nvl(per_pdm_shd.g_old_rec.preferred_flag,hr_api.g_varchar2))
355: and p_preferred_flag is not null then
356: --
357: -- check if value of lookup falls within lookup type.

Line 354: <> nvl(per_pdm_shd.g_old_rec.preferred_flag,hr_api.g_varchar2))

350: --
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: if (nvl(p_preferred_flag, hr_api.g_varchar2)
354: <> nvl(per_pdm_shd.g_old_rec.preferred_flag,hr_api.g_varchar2))
355: and p_preferred_flag is not null then
356: --
357: -- check if value of lookup falls within lookup type.
358: --

Line 359: if hr_api.not_exists_in_hr_lookups

355: and p_preferred_flag is not null then
356: --
357: -- check if value of lookup falls within lookup type.
358: --
359: if hr_api.not_exists_in_hr_lookups
360: (p_lookup_type => 'YES_NO',
361: p_lookup_code => p_preferred_flag,
362: p_effective_date => p_effective_date) then
363: --

Line 429: nvl(per_pdm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

425: begin
426: hr_utility.set_location('Entering:'||l_proc, 10);
427: --
428: if ((p_rec.delivery_method_id is not null) and (
429: nvl(per_pdm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
430: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
431: nvl(per_pdm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
432: nvl(p_rec.attribute1, hr_api.g_varchar2) or
433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 430: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

426: hr_utility.set_location('Entering:'||l_proc, 10);
427: --
428: if ((p_rec.delivery_method_id is not null) and (
429: nvl(per_pdm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
430: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
431: nvl(per_pdm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
432: nvl(p_rec.attribute1, hr_api.g_varchar2) or
433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
434: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 431: nvl(per_pdm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

427: --
428: if ((p_rec.delivery_method_id is not null) and (
429: nvl(per_pdm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
430: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
431: nvl(per_pdm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
432: nvl(p_rec.attribute1, hr_api.g_varchar2) or
433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
434: nvl(p_rec.attribute2, hr_api.g_varchar2) or
435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 432: nvl(p_rec.attribute1, hr_api.g_varchar2) or

428: if ((p_rec.delivery_method_id is not null) and (
429: nvl(per_pdm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
430: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
431: nvl(per_pdm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
432: nvl(p_rec.attribute1, hr_api.g_varchar2) or
433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
434: nvl(p_rec.attribute2, hr_api.g_varchar2) or
435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

429: nvl(per_pdm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
430: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
431: nvl(per_pdm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
432: nvl(p_rec.attribute1, hr_api.g_varchar2) or
433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
434: nvl(p_rec.attribute2, hr_api.g_varchar2) or
435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute3, hr_api.g_varchar2) or
437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 434: nvl(p_rec.attribute2, hr_api.g_varchar2) or

430: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
431: nvl(per_pdm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
432: nvl(p_rec.attribute1, hr_api.g_varchar2) or
433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
434: nvl(p_rec.attribute2, hr_api.g_varchar2) or
435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute3, hr_api.g_varchar2) or
437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

431: nvl(per_pdm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
432: nvl(p_rec.attribute1, hr_api.g_varchar2) or
433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
434: nvl(p_rec.attribute2, hr_api.g_varchar2) or
435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute3, hr_api.g_varchar2) or
437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute4, hr_api.g_varchar2) or
439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 436: nvl(p_rec.attribute3, hr_api.g_varchar2) or

432: nvl(p_rec.attribute1, hr_api.g_varchar2) or
433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
434: nvl(p_rec.attribute2, hr_api.g_varchar2) or
435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute3, hr_api.g_varchar2) or
437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute4, hr_api.g_varchar2) or
439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

433: nvl(per_pdm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
434: nvl(p_rec.attribute2, hr_api.g_varchar2) or
435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute3, hr_api.g_varchar2) or
437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute4, hr_api.g_varchar2) or
439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute5, hr_api.g_varchar2) or
441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 438: nvl(p_rec.attribute4, hr_api.g_varchar2) or

434: nvl(p_rec.attribute2, hr_api.g_varchar2) or
435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute3, hr_api.g_varchar2) or
437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute4, hr_api.g_varchar2) or
439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute5, hr_api.g_varchar2) or
441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

435: nvl(per_pdm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute3, hr_api.g_varchar2) or
437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute4, hr_api.g_varchar2) or
439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute5, hr_api.g_varchar2) or
441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute6, hr_api.g_varchar2) or
443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 440: nvl(p_rec.attribute5, hr_api.g_varchar2) or

436: nvl(p_rec.attribute3, hr_api.g_varchar2) or
437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute4, hr_api.g_varchar2) or
439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute5, hr_api.g_varchar2) or
441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute6, hr_api.g_varchar2) or
443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

437: nvl(per_pdm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute4, hr_api.g_varchar2) or
439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute5, hr_api.g_varchar2) or
441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute6, hr_api.g_varchar2) or
443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute7, hr_api.g_varchar2) or
445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 442: nvl(p_rec.attribute6, hr_api.g_varchar2) or

438: nvl(p_rec.attribute4, hr_api.g_varchar2) or
439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute5, hr_api.g_varchar2) or
441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute6, hr_api.g_varchar2) or
443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute7, hr_api.g_varchar2) or
445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

439: nvl(per_pdm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute5, hr_api.g_varchar2) or
441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute6, hr_api.g_varchar2) or
443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute7, hr_api.g_varchar2) or
445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute8, hr_api.g_varchar2) or
447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 444: nvl(p_rec.attribute7, hr_api.g_varchar2) or

440: nvl(p_rec.attribute5, hr_api.g_varchar2) or
441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute6, hr_api.g_varchar2) or
443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute7, hr_api.g_varchar2) or
445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute8, hr_api.g_varchar2) or
447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

441: nvl(per_pdm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute6, hr_api.g_varchar2) or
443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute7, hr_api.g_varchar2) or
445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute8, hr_api.g_varchar2) or
447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute9, hr_api.g_varchar2) or
449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 446: nvl(p_rec.attribute8, hr_api.g_varchar2) or

442: nvl(p_rec.attribute6, hr_api.g_varchar2) or
443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute7, hr_api.g_varchar2) or
445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute8, hr_api.g_varchar2) or
447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute9, hr_api.g_varchar2) or
449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

443: nvl(per_pdm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute7, hr_api.g_varchar2) or
445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute8, hr_api.g_varchar2) or
447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute9, hr_api.g_varchar2) or
449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute10, hr_api.g_varchar2) or
451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 448: nvl(p_rec.attribute9, hr_api.g_varchar2) or

444: nvl(p_rec.attribute7, hr_api.g_varchar2) or
445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute8, hr_api.g_varchar2) or
447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute9, hr_api.g_varchar2) or
449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute10, hr_api.g_varchar2) or
451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

445: nvl(per_pdm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute8, hr_api.g_varchar2) or
447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute9, hr_api.g_varchar2) or
449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute10, hr_api.g_varchar2) or
451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute11, hr_api.g_varchar2) or
453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 450: nvl(p_rec.attribute10, hr_api.g_varchar2) or

446: nvl(p_rec.attribute8, hr_api.g_varchar2) or
447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute9, hr_api.g_varchar2) or
449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute10, hr_api.g_varchar2) or
451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute11, hr_api.g_varchar2) or
453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

447: nvl(per_pdm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute9, hr_api.g_varchar2) or
449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute10, hr_api.g_varchar2) or
451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute11, hr_api.g_varchar2) or
453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute12, hr_api.g_varchar2) or
455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 452: nvl(p_rec.attribute11, hr_api.g_varchar2) or

448: nvl(p_rec.attribute9, hr_api.g_varchar2) or
449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute10, hr_api.g_varchar2) or
451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute11, hr_api.g_varchar2) or
453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute12, hr_api.g_varchar2) or
455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

449: nvl(per_pdm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute10, hr_api.g_varchar2) or
451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute11, hr_api.g_varchar2) or
453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute12, hr_api.g_varchar2) or
455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute13, hr_api.g_varchar2) or
457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 454: nvl(p_rec.attribute12, hr_api.g_varchar2) or

450: nvl(p_rec.attribute10, hr_api.g_varchar2) or
451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute11, hr_api.g_varchar2) or
453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute12, hr_api.g_varchar2) or
455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute13, hr_api.g_varchar2) or
457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

451: nvl(per_pdm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute11, hr_api.g_varchar2) or
453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute12, hr_api.g_varchar2) or
455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute13, hr_api.g_varchar2) or
457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute14, hr_api.g_varchar2) or
459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 456: nvl(p_rec.attribute13, hr_api.g_varchar2) or

452: nvl(p_rec.attribute11, hr_api.g_varchar2) or
453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute12, hr_api.g_varchar2) or
455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute13, hr_api.g_varchar2) or
457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute14, hr_api.g_varchar2) or
459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

453: nvl(per_pdm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute12, hr_api.g_varchar2) or
455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute13, hr_api.g_varchar2) or
457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute14, hr_api.g_varchar2) or
459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute15, hr_api.g_varchar2) or
461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 458: nvl(p_rec.attribute14, hr_api.g_varchar2) or

454: nvl(p_rec.attribute12, hr_api.g_varchar2) or
455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute13, hr_api.g_varchar2) or
457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute14, hr_api.g_varchar2) or
459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute15, hr_api.g_varchar2) or
461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

455: nvl(per_pdm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute13, hr_api.g_varchar2) or
457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute14, hr_api.g_varchar2) or
459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute15, hr_api.g_varchar2) or
461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute16, hr_api.g_varchar2) or
463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 460: nvl(p_rec.attribute15, hr_api.g_varchar2) or

456: nvl(p_rec.attribute13, hr_api.g_varchar2) or
457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute14, hr_api.g_varchar2) or
459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute15, hr_api.g_varchar2) or
461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute16, hr_api.g_varchar2) or
463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

457: nvl(per_pdm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute14, hr_api.g_varchar2) or
459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute15, hr_api.g_varchar2) or
461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute16, hr_api.g_varchar2) or
463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute17, hr_api.g_varchar2) or
465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 462: nvl(p_rec.attribute16, hr_api.g_varchar2) or

458: nvl(p_rec.attribute14, hr_api.g_varchar2) or
459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute15, hr_api.g_varchar2) or
461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute16, hr_api.g_varchar2) or
463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute17, hr_api.g_varchar2) or
465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

459: nvl(per_pdm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute15, hr_api.g_varchar2) or
461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute16, hr_api.g_varchar2) or
463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute17, hr_api.g_varchar2) or
465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute18, hr_api.g_varchar2) or
467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 464: nvl(p_rec.attribute17, hr_api.g_varchar2) or

460: nvl(p_rec.attribute15, hr_api.g_varchar2) or
461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute16, hr_api.g_varchar2) or
463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute17, hr_api.g_varchar2) or
465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute18, hr_api.g_varchar2) or
467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

461: nvl(per_pdm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute16, hr_api.g_varchar2) or
463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute17, hr_api.g_varchar2) or
465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute18, hr_api.g_varchar2) or
467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute19, hr_api.g_varchar2) or
469: nvl(per_pdm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 466: nvl(p_rec.attribute18, hr_api.g_varchar2) or

462: nvl(p_rec.attribute16, hr_api.g_varchar2) or
463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute17, hr_api.g_varchar2) or
465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute18, hr_api.g_varchar2) or
467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute19, hr_api.g_varchar2) or
469: nvl(per_pdm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

463: nvl(per_pdm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute17, hr_api.g_varchar2) or
465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute18, hr_api.g_varchar2) or
467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute19, hr_api.g_varchar2) or
469: nvl(per_pdm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute20, hr_api.g_varchar2)))
471: or

Line 468: nvl(p_rec.attribute19, hr_api.g_varchar2) or

464: nvl(p_rec.attribute17, hr_api.g_varchar2) or
465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute18, hr_api.g_varchar2) or
467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute19, hr_api.g_varchar2) or
469: nvl(per_pdm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute20, hr_api.g_varchar2)))
471: or
472: (p_rec.delivery_method_id is null) then

Line 469: nvl(per_pdm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

465: nvl(per_pdm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute18, hr_api.g_varchar2) or
467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute19, hr_api.g_varchar2) or
469: nvl(per_pdm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute20, hr_api.g_varchar2)))
471: or
472: (p_rec.delivery_method_id is null) then
473: --

Line 470: nvl(p_rec.attribute20, hr_api.g_varchar2)))

466: nvl(p_rec.attribute18, hr_api.g_varchar2) or
467: nvl(per_pdm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute19, hr_api.g_varchar2) or
469: nvl(per_pdm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute20, hr_api.g_varchar2)))
471: or
472: (p_rec.delivery_method_id is null) then
473: --
474: -- Only execute the validation if absolutely necessary:

Line 669: hr_api.mandatory_arg_error(p_api_name => l_proc,

665: hr_utility.set_location('Entering:'|| l_proc, 10);
666: --
667: -- Ensure that all the mandatory parameter are not null
668: --
669: hr_api.mandatory_arg_error(p_api_name => l_proc,
670: p_argument => 'delivery_method_id',
671: p_argument_value => p_delivery_method_id);
672: --
673: if nvl(g_delivery_method_id, hr_api.g_number) = p_delivery_method_id then

Line 673: if nvl(g_delivery_method_id, hr_api.g_number) = p_delivery_method_id then

669: hr_api.mandatory_arg_error(p_api_name => l_proc,
670: p_argument => 'delivery_method_id',
671: p_argument_value => p_delivery_method_id);
672: --
673: if nvl(g_delivery_method_id, hr_api.g_number) = p_delivery_method_id then
674: --
675: -- The legislation code has already been found with a previous
676: -- call to this function. Just return the value in the global
677: -- variable.