APPS.PER_SUB_BUS dependencies on HR_API

Line 49: and nvl(p_subjects_taken_id,hr_api.g_number)

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: --

Line 121: and nvl(p_qualification_id,hr_api.g_number)

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.

Line 199: and p_start_date between nvl(per.start_date,hr_api.g_sot)

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: --

Line 201: and (p_start_date <= nvl(per.end_date,hr_api.g_eot));

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: --

Line 220: and (nvl(p_start_date,hr_api.g_date)

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: */

Line 222: or nvl(p_end_date,hr_api.g_date)

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: --

Line 324: and nvl(p_end_date,nvl(per.end_date,hr_api.g_eot))

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: --

Line 325: between nvl(per.start_date,hr_api.g_sot)

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

Line 326: and nvl(per.end_date,hr_api.g_eot);

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: --

Line 410: and nvl(p_major,hr_api.g_varchar2)

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.

Line 416: if hr_api.not_exists_in_hr_lookups

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: --

Line 475: and nvl(p_subject_status,hr_api.g_varchar2)

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.

Line 481: if hr_api.not_exists_in_hr_lookups

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: --

Line 547: and nvl(per.end_date,hr_api.g_eot)

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

Line 550: and nvl(per.end_date,hr_api.g_eot))

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: --

Line 562: and (nvl(p_subject,hr_api.g_varchar2)

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)

Line 564: or nvl(p_start_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)

Line 566: or nvl(p_end_date,hr_api.g_date)

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

Line 568: or nvl(p_qualification_id,hr_api.g_number)

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.

Line 574: if hr_api.not_exists_in_hr_lookups

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: --

Line 649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

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

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

Line 651: nvl(per_sub_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

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

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

Line 653: nvl(per_sub_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

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

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

Line 655: nvl(per_sub_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

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

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

Line 657: nvl(per_sub_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

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

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

Line 659: nvl(per_sub_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

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

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

Line 661: nvl(per_sub_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

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

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

Line 663: nvl(per_sub_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

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

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

Line 665: nvl(per_sub_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

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

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

Line 667: nvl(per_sub_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

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

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

Line 669: nvl(per_sub_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

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

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

Line 671: nvl(per_sub_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

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

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

Line 673: nvl(per_sub_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

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

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

Line 675: nvl(per_sub_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

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

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

Line 677: nvl(per_sub_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

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

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

Line 679: nvl(per_sub_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

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

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

Line 681: nvl(per_sub_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

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

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

Line 683: nvl(per_sub_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

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

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

Line 685: nvl(per_sub_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

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

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)))

Line 687: nvl(per_sub_shd.g_old_rec.attribute19, 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

Line 688: nvl(p_rec.attribute19, hr_api.g_varchar2) 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

Line 689: nvl(per_sub_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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: --

Line 690: nvl(p_rec.attribute20, 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: --
694: -- Only execute the validation if absolutely necessary:

Line 785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>

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) <>

Line 786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or

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

Line 787: nvl(per_sub_shd.g_old_rec.sub_information1, hr_api.g_varchar2) <>

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) <>

Line 788: nvl(p_rec.sub_information1, hr_api.g_varchar2) or

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

Line 789: nvl(per_sub_shd.g_old_rec.sub_information2, hr_api.g_varchar2) <>

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) <>

Line 790: nvl(p_rec.sub_information2, hr_api.g_varchar2) or

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

Line 791: nvl(per_sub_shd.g_old_rec.sub_information3, hr_api.g_varchar2) <>

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) <>

Line 792: nvl(p_rec.sub_information3, hr_api.g_varchar2) or

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

Line 793: nvl(per_sub_shd.g_old_rec.sub_information4, hr_api.g_varchar2) <>

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) <>

Line 794: nvl(p_rec.sub_information4, hr_api.g_varchar2) or

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

Line 795: nvl(per_sub_shd.g_old_rec.sub_information5, hr_api.g_varchar2) <>

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) <>

Line 796: nvl(p_rec.sub_information5, hr_api.g_varchar2) or

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

Line 797: nvl(per_sub_shd.g_old_rec.sub_information6, hr_api.g_varchar2) <>

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) <>

Line 798: nvl(p_rec.sub_information6, hr_api.g_varchar2) or

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

Line 799: nvl(per_sub_shd.g_old_rec.sub_information7, hr_api.g_varchar2) <>

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) <>

Line 800: nvl(p_rec.sub_information7, hr_api.g_varchar2) or

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

Line 801: nvl(per_sub_shd.g_old_rec.sub_information8, hr_api.g_varchar2) <>

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) <>

Line 802: nvl(p_rec.sub_information8, hr_api.g_varchar2) or

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

Line 803: nvl(per_sub_shd.g_old_rec.sub_information9, hr_api.g_varchar2) <>

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) <>

Line 804: nvl(p_rec.sub_information9, hr_api.g_varchar2) or

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

Line 805: nvl(per_sub_shd.g_old_rec.sub_information10, hr_api.g_varchar2) <>

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) <>

Line 806: nvl(p_rec.sub_information10, hr_api.g_varchar2) or

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

Line 807: nvl(per_sub_shd.g_old_rec.sub_information11, hr_api.g_varchar2) <>

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) <>

Line 808: nvl(p_rec.sub_information11, hr_api.g_varchar2) or

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

Line 809: nvl(per_sub_shd.g_old_rec.sub_information12, hr_api.g_varchar2) <>

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) <>

Line 810: nvl(p_rec.sub_information12, hr_api.g_varchar2) or

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

Line 811: nvl(per_sub_shd.g_old_rec.sub_information13, hr_api.g_varchar2) <>

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) <>

Line 812: nvl(p_rec.sub_information13, hr_api.g_varchar2) or

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

Line 813: nvl(per_sub_shd.g_old_rec.sub_information14, hr_api.g_varchar2) <>

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) <>

Line 814: nvl(p_rec.sub_information14, hr_api.g_varchar2) or

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

Line 815: nvl(per_sub_shd.g_old_rec.sub_information15, hr_api.g_varchar2) <>

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) <>

Line 816: nvl(p_rec.sub_information15, hr_api.g_varchar2) or

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

Line 817: nvl(per_sub_shd.g_old_rec.sub_information16, hr_api.g_varchar2) <>

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) <>

Line 818: nvl(p_rec.sub_information16, hr_api.g_varchar2) or

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

Line 819: nvl(per_sub_shd.g_old_rec.sub_information17, hr_api.g_varchar2) <>

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) <>

Line 820: nvl(p_rec.sub_information17, hr_api.g_varchar2) or

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

Line 821: nvl(per_sub_shd.g_old_rec.sub_information18, hr_api.g_varchar2) <>

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) <>

Line 822: nvl(p_rec.sub_information18, hr_api.g_varchar2) or

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) ))

Line 823: nvl(per_sub_shd.g_old_rec.sub_information19, 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

Line 824: nvl(p_rec.sub_information19, hr_api.g_varchar2) or

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: --

Line 825: nvl(per_sub_shd.g_old_rec.sub_information20, hr_api.g_varchar2) <>

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:

Line 826: nvl(p_rec.sub_information20, 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:
830: -- a) During update, the structure column value or any