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
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: );
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: --
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: --
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
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);
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: --
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
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;
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.
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: --
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: --
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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)))
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
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
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: --
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:
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
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.