42: hr_utility.raise_error;
43: end if;
44: hr_utility.set_location(l_proc, 30);
45: --
46: if nvl(p_rec.person_id, hr_api.g_number) <>
47: nvl(per_sha_shd.g_old_rec.person_id
48: ,hr_api.g_number
49: ) then
50: l_argument := 'person_id';
44: hr_utility.set_location(l_proc, 30);
45: --
46: if nvl(p_rec.person_id, hr_api.g_number) <>
47: nvl(per_sha_shd.g_old_rec.person_id
48: ,hr_api.g_number
49: ) then
50: l_argument := 'person_id';
51: raise l_error;
52: end if;
53: --
54: hr_utility.set_location(l_proc, 40);
55: exception
56: when l_error then
57: hr_api.argument_changed_error
58: (p_api_name => l_proc
59: ,p_argument => l_argument
60: );
61: when others then
111: --
112: -- Check mandatory parameters have been set
113: --
114: BEGIN
115: hr_api.mandatory_arg_error
116: (p_api_name => l_proc
117: ,p_argument => 'date_not_taken'
118: ,p_argument_value => p_date_not_taken
119: );
195: hr_utility.set_location('Entering:'||l_proc, 10);
196: --
197: -- Check mandatory parameters have been set
198: --
199: hr_api.mandatory_arg_error
200: (p_api_name => l_proc
201: ,p_argument => 'person_id'
202: ,p_argument_value => p_person_id
203: );
267: hr_utility.set_location('Entering:'||l_proc, 10);
268: --
269: -- Check mandatory parameters have been set
270: --
271: hr_api.mandatory_arg_error
272: (p_api_name => l_proc
273: ,p_argument => 'standard_holiday_id'
274: ,p_argument_value => p_standard_holiday_id
275: );
373: (p_std_holiday_absences_id => p_std_holiday_absences_id,
374: p_object_version_number => p_object_version_number);
375: --
376: if ((l_api_updating AND
377: nvl(per_sha_shd.g_old_rec.actual_date_taken, hr_api.g_date) <>
378: nvl(p_actual_date_taken, hr_api.g_date))
379: OR
380: (NOT l_api_updating AND p_actual_date_taken IS NOT NULL)) then
381: --
374: p_object_version_number => p_object_version_number);
375: --
376: if ((l_api_updating AND
377: nvl(per_sha_shd.g_old_rec.actual_date_taken, hr_api.g_date) <>
378: nvl(p_actual_date_taken, hr_api.g_date))
379: OR
380: (NOT l_api_updating AND p_actual_date_taken IS NOT NULL)) then
381: --
382: -- Check that the EXPIRED flag is not checked
451: (p_std_holiday_absences_id => p_std_holiday_absences_id,
452: p_object_version_number => p_object_version_number);
453:
454: if ((l_api_updating AND
455: nvl(per_sha_shd.g_old_rec.expired, hr_api.g_varchar2) <>
456: nvl(p_expired, hr_api.g_varchar2))
457: OR
458: NOT l_api_updating) then
459: --
452: p_object_version_number => p_object_version_number);
453:
454: if ((l_api_updating AND
455: nvl(per_sha_shd.g_old_rec.expired, hr_api.g_varchar2) <>
456: nvl(p_expired, hr_api.g_varchar2))
457: OR
458: NOT l_api_updating) then
459: --
460: -- The EXPIRED flag can only be set if the ACTUAL_DATE_TAKEN is NULL
505: begin
506: hr_utility.set_location('Entering:'||l_proc, 10);
507: --
508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
506: hr_utility.set_location('Entering:'||l_proc, 10);
507: --
508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
507: --
508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
551: or
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
551: or
552: (p_rec.std_holiday_absences_id is null) then
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
551: or
552: (p_rec.std_holiday_absences_id is null) then
553: --
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
551: or
552: (p_rec.std_holiday_absences_id is null) then
553: --
554: -- Only execute the validation if absolutely necessary:
620: -- As this data is not within the context of a business group
621: -- the set_security_group_id procedure has zero passed
622: -- to it as the default security_group_id.
623: --
624: hr_api.set_security_group_id(p_security_group_id => 0);
625: --
626: hr_utility.set_location('Entering:'||l_proc, 7);
627: --
628: -- Validate Standard Holiday Dates not taken
689: -- As this data is not within the context of a business group
690: -- the set_security_group_id procedure has zero passed
691: -- to it as the default security_group_id.
692: --
693: hr_api.set_security_group_id(p_security_group_id => 0);
694: --
695: hr_utility.set_location('Entering:'||l_proc, 7);
696: --
697: -- Check no non-updateable arguments have been updated
789: hr_utility.set_location('Entering:'|| l_proc, 10);
790: --
791: -- Ensure that all the mandatory parameter are not null
792: --
793: hr_api.mandatory_arg_error(p_api_name => l_proc,
794: p_argument => 'std_holiday_absences_id',
795: p_argument_value => p_std_holiday_absences_id);
796: --
797: if nvl(g_std_holiday_absences_id, hr_api.g_number) = p_std_holiday_absences_id then
793: hr_api.mandatory_arg_error(p_api_name => l_proc,
794: p_argument => 'std_holiday_absences_id',
795: p_argument_value => p_std_holiday_absences_id);
796: --
797: if nvl(g_std_holiday_absences_id, hr_api.g_number) = p_std_holiday_absences_id then
798: --
799: -- The legislation code has already been found with a previous
800: -- call to this function. Just return the value in the global
801: -- variable.