45: (p_subjects_taken_id => p_subjects_taken_id,
46: p_object_version_number => p_object_version_number);
47: --
48: if (l_api_updating
49: and nvl(p_subjects_taken_id,hr_api.g_number)
50: <> per_sub_shd.g_old_rec.subjects_taken_id) then
51: --
52: -- raise error as PK has changed
53: --
117: (p_subjects_taken_id => p_subjects_taken_id,
118: p_object_version_number => p_object_version_number);
119: --
120: if (l_api_updating
121: and nvl(p_qualification_id,hr_api.g_number)
122: <> per_sub_shd.g_old_rec.qualification_id
123: or not l_api_updating) then
124: --
125: -- check if qualification id exists in per_qualifications table.
195: cursor c1 is
196: select null
197: from per_qualifications per
198: where per.qualification_id = p_qualification_id
199: and p_start_date between nvl(per.start_date,hr_api.g_sot)
200: and nvl(per.end_date,p_start_date)
201: and (p_start_date <= nvl(per.end_date,hr_api.g_eot));
202:
203: --
197: from per_qualifications per
198: where per.qualification_id = p_qualification_id
199: and p_start_date between nvl(per.start_date,hr_api.g_sot)
200: and nvl(per.end_date,p_start_date)
201: and (p_start_date <= nvl(per.end_date,hr_api.g_eot));
202:
203: --
204: Begin
205: --
216: --
217: if (l_api_updating
218: /*
219: WWBUG 2502284 backport drove this.
220: and (nvl(p_start_date,hr_api.g_date)
221: <> per_sub_shd.g_old_rec.start_date
222: or nvl(p_end_date,hr_api.g_date)
223: <> per_sub_shd.g_old_rec.end_date)
224: */
218: /*
219: WWBUG 2502284 backport drove this.
220: and (nvl(p_start_date,hr_api.g_date)
221: <> per_sub_shd.g_old_rec.start_date
222: or nvl(p_end_date,hr_api.g_date)
223: <> per_sub_shd.g_old_rec.end_date)
224: */
225: or not l_api_updating) then
226: --
320: cursor c1 is
321: select null
322: from per_qualifications per
323: where per.qualification_id = p_qualification_id
324: and nvl(p_end_date,nvl(per.end_date,hr_api.g_eot))
325: between nvl(per.start_date,hr_api.g_sot)
326: and nvl(per.end_date,hr_api.g_eot);
327:
328: --
321: select null
322: from per_qualifications per
323: where per.qualification_id = p_qualification_id
324: and nvl(p_end_date,nvl(per.end_date,hr_api.g_eot))
325: between nvl(per.start_date,hr_api.g_sot)
326: and nvl(per.end_date,hr_api.g_eot);
327:
328: --
329: Begin
322: from per_qualifications per
323: where per.qualification_id = p_qualification_id
324: and nvl(p_end_date,nvl(per.end_date,hr_api.g_eot))
325: between nvl(per.start_date,hr_api.g_sot)
326: and nvl(per.end_date,hr_api.g_eot);
327:
328: --
329: Begin
330: --
406: p_object_version_number => p_object_version_number);
407: --
408: if p_major is not null then --p_major is optional field.
409: if (l_api_updating
410: and nvl(p_major,hr_api.g_varchar2)
411: <> per_sub_shd.g_old_rec.major
412: or not l_api_updating) then
413: --
414: -- check if major exists in the lookup YES_NO.
412: or not l_api_updating) then
413: --
414: -- check if major exists in the lookup YES_NO.
415: --
416: if hr_api.not_exists_in_hr_lookups
417: (p_effective_date => p_effective_date,
418: p_lookup_type => 'YES_NO',
419: p_lookup_code => p_major) then
420: --
471: (p_subjects_taken_id => p_subjects_taken_id,
472: p_object_version_number => p_object_version_number);
473: --
474: if (l_api_updating
475: and nvl(p_subject_status,hr_api.g_varchar2)
476: <> per_sub_shd.g_old_rec.subject_status
477: or not l_api_updating) then
478: --
479: -- check if subject_status exists in the lookup PER_SUBJECT_STATUSES.
477: or not l_api_updating) then
478: --
479: -- check if subject_status exists in the lookup PER_SUBJECT_STATUSES.
480: --
481: if hr_api.not_exists_in_hr_lookups
482: (p_effective_date => p_effective_date,
483: p_lookup_type => 'PER_SUBJECT_STATUSES',
484: p_lookup_code => p_subject_status) then
485: --
543: where per.qualification_id = p_qualification_id
544: and per.subject = p_subject
545: and (p_start_date
546: between per.start_date
547: and nvl(per.end_date,hr_api.g_eot)
548: or p_end_date
549: between per.start_date
550: and nvl(per.end_date,hr_api.g_eot))
551: and per.subjects_taken_id <> nvl(p_subjects_taken_id,-1);
546: between per.start_date
547: and nvl(per.end_date,hr_api.g_eot)
548: or p_end_date
549: between per.start_date
550: and nvl(per.end_date,hr_api.g_eot))
551: and per.subjects_taken_id <> nvl(p_subjects_taken_id,-1);
552: --
553: Begin
554: --
558: (p_subjects_taken_id => p_subjects_taken_id,
559: p_object_version_number => p_object_version_number);
560: --
561: if (l_api_updating
562: and (nvl(p_subject,hr_api.g_varchar2)
563: <> per_sub_shd.g_old_rec.subject
564: or nvl(p_start_date,hr_api.g_date)
565: <> per_sub_shd.g_old_rec.start_date
566: or nvl(p_end_date,hr_api.g_date)
560: --
561: if (l_api_updating
562: and (nvl(p_subject,hr_api.g_varchar2)
563: <> per_sub_shd.g_old_rec.subject
564: or nvl(p_start_date,hr_api.g_date)
565: <> per_sub_shd.g_old_rec.start_date
566: or nvl(p_end_date,hr_api.g_date)
567: <> per_sub_shd.g_old_rec.end_date
568: or nvl(p_qualification_id,hr_api.g_number)
562: and (nvl(p_subject,hr_api.g_varchar2)
563: <> per_sub_shd.g_old_rec.subject
564: or nvl(p_start_date,hr_api.g_date)
565: <> per_sub_shd.g_old_rec.start_date
566: or nvl(p_end_date,hr_api.g_date)
567: <> per_sub_shd.g_old_rec.end_date
568: or nvl(p_qualification_id,hr_api.g_number)
569: <> per_sub_shd.g_old_rec.qualification_id)
570: or not l_api_updating) then
564: or nvl(p_start_date,hr_api.g_date)
565: <> per_sub_shd.g_old_rec.start_date
566: or nvl(p_end_date,hr_api.g_date)
567: <> per_sub_shd.g_old_rec.end_date
568: or nvl(p_qualification_id,hr_api.g_number)
569: <> per_sub_shd.g_old_rec.qualification_id)
570: or not l_api_updating) then
571: --
572: -- check if subject exists in the lookup PER_SUBJECTS.
570: or not l_api_updating) then
571: --
572: -- check if subject exists in the lookup PER_SUBJECTS.
573: --
574: if hr_api.not_exists_in_hr_lookups
575: (p_effective_date => p_effective_date,
576: p_lookup_type => 'PER_SUBJECTS',
577: p_lookup_code => p_subject) then
578: --
645: begin
646: hr_utility.set_location('Entering:'||l_proc, 10);
647: --
648: if ((p_rec.subjects_taken_id is not null) and (
649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
646: hr_utility.set_location('Entering:'||l_proc, 10);
647: --
648: if ((p_rec.subjects_taken_id is not null) and (
649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
647: --
648: if ((p_rec.subjects_taken_id is not null) and (
649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
648: if ((p_rec.subjects_taken_id is not null) and (
649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute1, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute2, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute3, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute4, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute5, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute6, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute7, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute8, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute9, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute10, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute11, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute12, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute13, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute14, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute15, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute16, hr_api.g_varchar2) or
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute20, hr_api.g_varchar2)))
683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute20, hr_api.g_varchar2)))
691: or
684: nvl(p_rec.attribute17, hr_api.g_varchar2) or
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute20, hr_api.g_varchar2)))
691: or
692: (p_rec.subjects_taken_id is null) then
685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute20, hr_api.g_varchar2)))
691: or
692: (p_rec.subjects_taken_id is null) then
693: --
686: nvl(p_rec.attribute18, hr_api.g_varchar2) or
687: nvl(per_sub_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute19, hr_api.g_varchar2) or
689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute20, hr_api.g_varchar2)))
691: or
692: (p_rec.subjects_taken_id is null) then
693: --
694: -- Only execute the validation if absolutely necessary:
781: begin
782: hr_utility.set_location('Entering:'||l_proc,10);
783: --
784: if ((p_rec.subjects_taken_id is not null) and (
785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
782: hr_utility.set_location('Entering:'||l_proc,10);
783: --
784: if ((p_rec.subjects_taken_id is not null) and (
785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
783: --
784: if ((p_rec.subjects_taken_id is not null) and (
785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
784: if ((p_rec.subjects_taken_id is not null) and (
785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>
818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>
826: nvl(p_rec.sub_information20, hr_api.g_varchar2) ))
819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>
826: nvl(p_rec.sub_information20, hr_api.g_varchar2) ))
827: or (p_rec.subjects_taken_id is null) then
820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>
826: nvl(p_rec.sub_information20, hr_api.g_varchar2) ))
827: or (p_rec.subjects_taken_id is null) then
828: --
821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>
826: nvl(p_rec.sub_information20, hr_api.g_varchar2) ))
827: or (p_rec.subjects_taken_id is null) then
828: --
829: -- Only execute the validation if absolutely necessary:
822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or
823: nvl(per_sub_shd.g_old_rec.sub_information19, hr_api.g_varchar2) <>
824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or
825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>
826: nvl(p_rec.sub_information20, hr_api.g_varchar2) ))
827: or (p_rec.subjects_taken_id is null) then
828: --
829: -- Only execute the validation if absolutely necessary:
830: -- a) During update, the structure column value or any