eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_EQT_BUS dependencies on HR_API

Line 27: nvl(p_qualification_type_id,hr_api.g_number)

23: (p_qualification_type_id => p_qualification_type_id,
24: p_object_version_number => p_object_version_number);
25: --
26: if (l_api_updating and
27: nvl(p_qualification_type_id,hr_api.g_number)
28: <> per_eqt_shd.g_old_rec.qualification_type_id or
29: not l_api_updating) then
30: --
31: if p_qualification_type_id is not null and

Line 42: if nvl(p_qualification_type_id,hr_api.g_number)

38: end if;
39: --
40: -- check if qualification_type_id has been updated
41: --
42: if nvl(p_qualification_type_id,hr_api.g_number)
43: <> per_eqt_shd.g_old_rec.qualification_type_id
44: and l_api_updating then
45: --
46: -- raise error as update is not allowed

Line 102: and nvl(p_category,hr_api.g_varchar2)

98: (p_qualification_type_id => p_qualification_type_id,
99: p_object_version_number => p_object_version_number);
100: --
101: if (l_api_updating
102: and nvl(p_category,hr_api.g_varchar2)
103: <> per_eqt_shd.g_old_rec.category
104: or not l_api_updating) then
105: --
106: -- check if value of category exists in lookup 'PER_CATEGORIES'

Line 108: if hr_api.not_exists_in_leg_lookups(p_lookup_type => 'PER_CATEGORIES',

104: or not l_api_updating) then
105: --
106: -- check if value of category exists in lookup 'PER_CATEGORIES'
107: --
108: if hr_api.not_exists_in_leg_lookups(p_lookup_type => 'PER_CATEGORIES',
109: p_lookup_code => p_category,
110: p_effective_date => p_effective_date) then
111: --
112: -- raise error as does not exist as lookup

Line 245: hr_api.g_number)

241: ,p_object_version_number => p_object_version_number);
242: --
243: if p_qual_framework_id is not null then
244: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qual_framework_id,
245: hr_api.g_number)
246: <> nvl(p_qual_framework_id,hr_api.g_number)
247: ) or
248: (NOT l_api_updating)
249: ) then

Line 246: <> nvl(p_qual_framework_id,hr_api.g_number)

242: --
243: if p_qual_framework_id is not null then
244: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qual_framework_id,
245: hr_api.g_number)
246: <> nvl(p_qual_framework_id,hr_api.g_number)
247: ) or
248: (NOT l_api_updating)
249: ) then
250: --

Line 324: hr_api.g_varchar2)

320: ,p_object_version_number => p_object_version_number);
321: --
322: if p_qualification_type is not null then
323: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qualification_type,
324: hr_api.g_varchar2)
325: <> nvl(p_qualification_type,hr_api.g_varchar2)
326: ) or
327: (NOT l_api_updating)
328: ) then

Line 325: <> nvl(p_qualification_type,hr_api.g_varchar2)

321: --
322: if p_qualification_type is not null then
323: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qualification_type,
324: hr_api.g_varchar2)
325: <> nvl(p_qualification_type,hr_api.g_varchar2)
326: ) or
327: (NOT l_api_updating)
328: ) then
329: --

Line 334: IF hr_api.not_exists_in_hr_lookups

330: hr_utility.set_location(l_proc, 20);
331: --
332: -- Check that the category exists in HR_LOOKUPS
333: --
334: IF hr_api.not_exists_in_hr_lookups
335: (p_effective_date => p_effective_date
336: ,p_lookup_type => 'PER_QUAL_FWK_QUAL_TYPE'
337: ,p_lookup_code => p_qualification_type) THEN
338: --

Line 404: hr_api.g_varchar2)

400: ,p_object_version_number => p_object_version_number);
401: --
402: if p_credit_type is not null then
403: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.credit_type,
404: hr_api.g_varchar2)
405: <> nvl(p_credit_type,hr_api.g_varchar2)
406: ) or
407: (NOT l_api_updating)
408: ) then

Line 405: <> nvl(p_credit_type,hr_api.g_varchar2)

401: --
402: if p_credit_type is not null then
403: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.credit_type,
404: hr_api.g_varchar2)
405: <> nvl(p_credit_type,hr_api.g_varchar2)
406: ) or
407: (NOT l_api_updating)
408: ) then
409: --

Line 414: IF hr_api.not_exists_in_hr_lookups

410: hr_utility.set_location(l_proc, 20);
411: --
412: -- Check that the category exists in HR_LOOKUPS
413: --
414: IF hr_api.not_exists_in_hr_lookups
415: (p_effective_date => p_effective_date
416: ,p_lookup_type => 'PER_QUAL_FWK_CREDIT_TYPE'
417: ,p_lookup_code => p_credit_type) THEN
418: --

Line 485: hr_api.g_varchar2)

481: ,p_object_version_number => p_object_version_number);
482: --
483: if p_level_type is not null then
484: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.level_type,
485: hr_api.g_varchar2)
486: <> nvl(p_level_type,hr_api.g_varchar2)
487: ) or
488: (NOT l_api_updating)
489: ) then

Line 486: <> nvl(p_level_type,hr_api.g_varchar2)

482: --
483: if p_level_type is not null then
484: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.level_type,
485: hr_api.g_varchar2)
486: <> nvl(p_level_type,hr_api.g_varchar2)
487: ) or
488: (NOT l_api_updating)
489: ) then
490: --

Line 495: IF hr_api.not_exists_in_hr_lookups

491: hr_utility.set_location(l_proc, 20);
492: --
493: -- Check that the category exists in HR_LOOKUPS
494: --
495: IF hr_api.not_exists_in_hr_lookups
496: (p_effective_date => p_effective_date
497: ,p_lookup_type => 'PER_QUAL_FWK_LEVEL_TYPE'
498: ,p_lookup_code => p_level_type) THEN
499: --

Line 566: hr_api.g_number)

562: ,p_object_version_number => p_object_version_number);
563: --
564: if p_level_number is not null then
565: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.level_number,
566: hr_api.g_number)
567: <> nvl(p_level_number,hr_api.g_number)
568: ) or
569: (NOT l_api_updating)
570: ) then

Line 567: <> nvl(p_level_number,hr_api.g_number)

563: --
564: if p_level_number is not null then
565: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.level_number,
566: hr_api.g_number)
567: <> nvl(p_level_number,hr_api.g_number)
568: ) or
569: (NOT l_api_updating)
570: ) then
571: --

Line 576: IF hr_api.not_exists_in_hr_lookups

572: hr_utility.set_location(l_proc, 20);
573: --
574: -- Check that the category exists in HR_LOOKUPS
575: --
576: IF hr_api.not_exists_in_hr_lookups
577: (p_effective_date => p_effective_date
578: ,p_lookup_type => 'PER_QUAL_FWK_LEVEL'
579: ,p_lookup_code => p_level_number) THEN
580: --

Line 647: hr_api.g_varchar2)

643: ,p_object_version_number => p_object_version_number);
644: --
645: if p_field is not null then
646: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.field,
647: hr_api.g_varchar2)
648: <> nvl(p_field,hr_api.g_varchar2)
649: ) or
650: (NOT l_api_updating)
651: ) then

Line 648: <> nvl(p_field,hr_api.g_varchar2)

644: --
645: if p_field is not null then
646: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.field,
647: hr_api.g_varchar2)
648: <> nvl(p_field,hr_api.g_varchar2)
649: ) or
650: (NOT l_api_updating)
651: ) then
652: --

Line 657: IF hr_api.not_exists_in_hr_lookups

653: hr_utility.set_location(l_proc, 20);
654: --
655: -- Check that the category exists in HR_LOOKUPS
656: --
657: IF hr_api.not_exists_in_hr_lookups
658: (p_effective_date => p_effective_date
659: ,p_lookup_type => 'PER_QUAL_FWK_FIELD'
660: ,p_lookup_code => p_field) THEN
661: --

Line 728: hr_api.g_varchar2)

724: ,p_object_version_number => p_object_version_number);
725: --
726: if p_sub_field is not null then
727: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.sub_field,
728: hr_api.g_varchar2)
729: <> nvl(p_sub_field,hr_api.g_varchar2)
730: ) or
731: (NOT l_api_updating)
732: ) then

Line 729: <> nvl(p_sub_field,hr_api.g_varchar2)

725: --
726: if p_sub_field is not null then
727: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.sub_field,
728: hr_api.g_varchar2)
729: <> nvl(p_sub_field,hr_api.g_varchar2)
730: ) or
731: (NOT l_api_updating)
732: ) then
733: --

Line 738: IF hr_api.not_exists_in_hr_lookups

734: hr_utility.set_location(l_proc, 20);
735: --
736: -- Check that the category exists in HR_LOOKUPS
737: --
738: IF hr_api.not_exists_in_hr_lookups
739: (p_effective_date => p_effective_date
740: ,p_lookup_type => 'PER_QUAL_FWK_SUB_FIELD'
741: ,p_lookup_code => p_sub_field) THEN
742: --

Line 809: hr_api.g_varchar2)

805: ,p_object_version_number => p_object_version_number);
806: --
807: if p_provider is not null then
808: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.provider,
809: hr_api.g_varchar2)
810: <> nvl(p_provider,hr_api.g_varchar2)
811: ) or
812: (NOT l_api_updating)
813: ) then

Line 810: <> nvl(p_provider,hr_api.g_varchar2)

806: --
807: if p_provider is not null then
808: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.provider,
809: hr_api.g_varchar2)
810: <> nvl(p_provider,hr_api.g_varchar2)
811: ) or
812: (NOT l_api_updating)
813: ) then
814: --

Line 819: IF hr_api.not_exists_in_hr_lookups

815: hr_utility.set_location(l_proc, 20);
816: --
817: -- Check that the category exists in HR_LOOKUPS
818: --
819: IF hr_api.not_exists_in_hr_lookups
820: (p_effective_date => p_effective_date
821: ,p_lookup_type => 'PER_QUAL_FWK_PROVIDER'
822: ,p_lookup_code => p_provider) THEN
823: --

Line 890: hr_api.g_varchar2)

886: ,p_object_version_number => p_object_version_number);
887: --
888: if p_qa_organization is not null then
889: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qa_organization,
890: hr_api.g_varchar2)
891: <> nvl(p_qa_organization,hr_api.g_varchar2)
892: ) or
893: (NOT l_api_updating)
894: ) then

Line 891: <> nvl(p_qa_organization,hr_api.g_varchar2)

887: --
888: if p_qa_organization is not null then
889: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qa_organization,
890: hr_api.g_varchar2)
891: <> nvl(p_qa_organization,hr_api.g_varchar2)
892: ) or
893: (NOT l_api_updating)
894: ) then
895: --

Line 900: IF hr_api.not_exists_in_hr_lookups

896: hr_utility.set_location(l_proc, 20);
897: --
898: -- Check that the category exists in HR_LOOKUPS
899: --
900: IF hr_api.not_exists_in_hr_lookups
901: (p_effective_date => p_effective_date
902: ,p_lookup_type => 'PER_QUAL_FWK_QA_ORG'
903: ,p_lookup_code => p_qa_organization) THEN
904: --

Line 954: nvl(per_eqt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

950: begin
951: hr_utility.set_location('Entering:'||l_proc, 10);
952: --
953: if ((p_rec.qualification_type_id is not null) and (
954: nvl(per_eqt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
956: nvl(per_eqt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute1, hr_api.g_varchar2) or
958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

951: hr_utility.set_location('Entering:'||l_proc, 10);
952: --
953: if ((p_rec.qualification_type_id is not null) and (
954: nvl(per_eqt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
956: nvl(per_eqt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute1, hr_api.g_varchar2) or
958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 956: nvl(per_eqt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

952: --
953: if ((p_rec.qualification_type_id is not null) and (
954: nvl(per_eqt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
956: nvl(per_eqt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute1, hr_api.g_varchar2) or
958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute2, hr_api.g_varchar2) or
960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

953: if ((p_rec.qualification_type_id is not null) and (
954: nvl(per_eqt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
956: nvl(per_eqt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute1, hr_api.g_varchar2) or
958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute2, hr_api.g_varchar2) or
960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

954: nvl(per_eqt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
956: nvl(per_eqt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute1, hr_api.g_varchar2) or
958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute2, hr_api.g_varchar2) or
960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute3, hr_api.g_varchar2) or
962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

955: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
956: nvl(per_eqt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute1, hr_api.g_varchar2) or
958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute2, hr_api.g_varchar2) or
960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute3, hr_api.g_varchar2) or
962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

956: nvl(per_eqt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute1, hr_api.g_varchar2) or
958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute2, hr_api.g_varchar2) or
960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute3, hr_api.g_varchar2) or
962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute4, hr_api.g_varchar2) or
964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

957: nvl(p_rec.attribute1, hr_api.g_varchar2) or
958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute2, hr_api.g_varchar2) or
960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute3, hr_api.g_varchar2) or
962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute4, hr_api.g_varchar2) or
964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

958: nvl(per_eqt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute2, hr_api.g_varchar2) or
960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute3, hr_api.g_varchar2) or
962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute4, hr_api.g_varchar2) or
964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute5, hr_api.g_varchar2) or
966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

959: nvl(p_rec.attribute2, hr_api.g_varchar2) or
960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute3, hr_api.g_varchar2) or
962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute4, hr_api.g_varchar2) or
964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute5, hr_api.g_varchar2) or
966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

960: nvl(per_eqt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute3, hr_api.g_varchar2) or
962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute4, hr_api.g_varchar2) or
964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute5, hr_api.g_varchar2) or
966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute6, hr_api.g_varchar2) or
968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

961: nvl(p_rec.attribute3, hr_api.g_varchar2) or
962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute4, hr_api.g_varchar2) or
964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute5, hr_api.g_varchar2) or
966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute6, hr_api.g_varchar2) or
968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

962: nvl(per_eqt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute4, hr_api.g_varchar2) or
964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute5, hr_api.g_varchar2) or
966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute6, hr_api.g_varchar2) or
968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute7, hr_api.g_varchar2) or
970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

963: nvl(p_rec.attribute4, hr_api.g_varchar2) or
964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute5, hr_api.g_varchar2) or
966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute6, hr_api.g_varchar2) or
968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute7, hr_api.g_varchar2) or
970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

964: nvl(per_eqt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute5, hr_api.g_varchar2) or
966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute6, hr_api.g_varchar2) or
968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute7, hr_api.g_varchar2) or
970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute8, hr_api.g_varchar2) or
972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

965: nvl(p_rec.attribute5, hr_api.g_varchar2) or
966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute6, hr_api.g_varchar2) or
968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute7, hr_api.g_varchar2) or
970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute8, hr_api.g_varchar2) or
972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

966: nvl(per_eqt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute6, hr_api.g_varchar2) or
968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute7, hr_api.g_varchar2) or
970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute8, hr_api.g_varchar2) or
972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute9, hr_api.g_varchar2) or
974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

967: nvl(p_rec.attribute6, hr_api.g_varchar2) or
968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute7, hr_api.g_varchar2) or
970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute8, hr_api.g_varchar2) or
972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute9, hr_api.g_varchar2) or
974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

968: nvl(per_eqt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute7, hr_api.g_varchar2) or
970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute8, hr_api.g_varchar2) or
972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute9, hr_api.g_varchar2) or
974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute10, hr_api.g_varchar2) or
976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

969: nvl(p_rec.attribute7, hr_api.g_varchar2) or
970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute8, hr_api.g_varchar2) or
972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute9, hr_api.g_varchar2) or
974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute10, hr_api.g_varchar2) or
976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

970: nvl(per_eqt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute8, hr_api.g_varchar2) or
972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute9, hr_api.g_varchar2) or
974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute10, hr_api.g_varchar2) or
976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute11, hr_api.g_varchar2) or
978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

971: nvl(p_rec.attribute8, hr_api.g_varchar2) or
972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute9, hr_api.g_varchar2) or
974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute10, hr_api.g_varchar2) or
976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute11, hr_api.g_varchar2) or
978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

972: nvl(per_eqt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute9, hr_api.g_varchar2) or
974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute10, hr_api.g_varchar2) or
976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute11, hr_api.g_varchar2) or
978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute12, hr_api.g_varchar2) or
980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

973: nvl(p_rec.attribute9, hr_api.g_varchar2) or
974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute10, hr_api.g_varchar2) or
976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute11, hr_api.g_varchar2) or
978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute12, hr_api.g_varchar2) or
980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

974: nvl(per_eqt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute10, hr_api.g_varchar2) or
976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute11, hr_api.g_varchar2) or
978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute12, hr_api.g_varchar2) or
980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute13, hr_api.g_varchar2) or
982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

975: nvl(p_rec.attribute10, hr_api.g_varchar2) or
976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute11, hr_api.g_varchar2) or
978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute12, hr_api.g_varchar2) or
980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute13, hr_api.g_varchar2) or
982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

976: nvl(per_eqt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute11, hr_api.g_varchar2) or
978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute12, hr_api.g_varchar2) or
980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute13, hr_api.g_varchar2) or
982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute14, hr_api.g_varchar2) or
984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

977: nvl(p_rec.attribute11, hr_api.g_varchar2) or
978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute12, hr_api.g_varchar2) or
980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute13, hr_api.g_varchar2) or
982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute14, hr_api.g_varchar2) or
984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

978: nvl(per_eqt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute12, hr_api.g_varchar2) or
980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute13, hr_api.g_varchar2) or
982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute14, hr_api.g_varchar2) or
984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute15, hr_api.g_varchar2) or
986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

979: nvl(p_rec.attribute12, hr_api.g_varchar2) or
980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute13, hr_api.g_varchar2) or
982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute14, hr_api.g_varchar2) or
984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute15, hr_api.g_varchar2) or
986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

980: nvl(per_eqt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute13, hr_api.g_varchar2) or
982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute14, hr_api.g_varchar2) or
984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute15, hr_api.g_varchar2) or
986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute16, hr_api.g_varchar2) or
988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

981: nvl(p_rec.attribute13, hr_api.g_varchar2) or
982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute14, hr_api.g_varchar2) or
984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute15, hr_api.g_varchar2) or
986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute16, hr_api.g_varchar2) or
988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

982: nvl(per_eqt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute14, hr_api.g_varchar2) or
984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute15, hr_api.g_varchar2) or
986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute16, hr_api.g_varchar2) or
988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute17, hr_api.g_varchar2) or
990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

983: nvl(p_rec.attribute14, hr_api.g_varchar2) or
984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute15, hr_api.g_varchar2) or
986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute16, hr_api.g_varchar2) or
988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute17, hr_api.g_varchar2) or
990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

984: nvl(per_eqt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute15, hr_api.g_varchar2) or
986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute16, hr_api.g_varchar2) or
988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute17, hr_api.g_varchar2) or
990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute18, hr_api.g_varchar2) or
992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

985: nvl(p_rec.attribute15, hr_api.g_varchar2) or
986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute16, hr_api.g_varchar2) or
988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute17, hr_api.g_varchar2) or
990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute18, hr_api.g_varchar2) or
992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

986: nvl(per_eqt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute16, hr_api.g_varchar2) or
988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute17, hr_api.g_varchar2) or
990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute18, hr_api.g_varchar2) or
992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute19, hr_api.g_varchar2) or
994: nvl(per_eqt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

987: nvl(p_rec.attribute16, hr_api.g_varchar2) or
988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute17, hr_api.g_varchar2) or
990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute18, hr_api.g_varchar2) or
992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute19, hr_api.g_varchar2) or
994: nvl(per_eqt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
995: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

988: nvl(per_eqt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute17, hr_api.g_varchar2) or
990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute18, hr_api.g_varchar2) or
992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute19, hr_api.g_varchar2) or
994: nvl(per_eqt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
995: nvl(p_rec.attribute20, hr_api.g_varchar2)))
996: or

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

989: nvl(p_rec.attribute17, hr_api.g_varchar2) or
990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute18, hr_api.g_varchar2) or
992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute19, hr_api.g_varchar2) or
994: nvl(per_eqt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
995: nvl(p_rec.attribute20, hr_api.g_varchar2)))
996: or
997: (p_rec.qualification_type_id is null) then

Line 994: nvl(per_eqt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

990: nvl(per_eqt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute18, hr_api.g_varchar2) or
992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute19, hr_api.g_varchar2) or
994: nvl(per_eqt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
995: nvl(p_rec.attribute20, hr_api.g_varchar2)))
996: or
997: (p_rec.qualification_type_id is null) then
998: --

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

991: nvl(p_rec.attribute18, hr_api.g_varchar2) or
992: nvl(per_eqt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute19, hr_api.g_varchar2) or
994: nvl(per_eqt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
995: nvl(p_rec.attribute20, hr_api.g_varchar2)))
996: or
997: (p_rec.qualification_type_id is null) then
998: --
999: -- Only execute the validation if absolutely necessary:

Line 1093: nvl(per_eqt_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

1089: hr_utility.set_location('Entering:'||l_proc, 10);
1090: --
1091:
1092: if ((p_rec.qualification_type_id is not null) and (
1093: nvl(per_eqt_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1094: nvl(p_rec.information_category, hr_api.g_varchar2) or
1095: nvl(per_eqt_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1096: nvl(p_rec.information1, hr_api.g_varchar2) or
1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 1094: nvl(p_rec.information_category, hr_api.g_varchar2) or

1090: --
1091:
1092: if ((p_rec.qualification_type_id is not null) and (
1093: nvl(per_eqt_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1094: nvl(p_rec.information_category, hr_api.g_varchar2) or
1095: nvl(per_eqt_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1096: nvl(p_rec.information1, hr_api.g_varchar2) or
1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1098: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 1095: nvl(per_eqt_shd.g_old_rec.information1, hr_api.g_varchar2) <>

1091:
1092: if ((p_rec.qualification_type_id is not null) and (
1093: nvl(per_eqt_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1094: nvl(p_rec.information_category, hr_api.g_varchar2) or
1095: nvl(per_eqt_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1096: nvl(p_rec.information1, hr_api.g_varchar2) or
1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1098: nvl(p_rec.information2, hr_api.g_varchar2) or
1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 1096: nvl(p_rec.information1, hr_api.g_varchar2) or

1092: if ((p_rec.qualification_type_id is not null) and (
1093: nvl(per_eqt_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1094: nvl(p_rec.information_category, hr_api.g_varchar2) or
1095: nvl(per_eqt_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1096: nvl(p_rec.information1, hr_api.g_varchar2) or
1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1098: nvl(p_rec.information2, hr_api.g_varchar2) or
1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1100: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>

1093: nvl(per_eqt_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1094: nvl(p_rec.information_category, hr_api.g_varchar2) or
1095: nvl(per_eqt_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1096: nvl(p_rec.information1, hr_api.g_varchar2) or
1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1098: nvl(p_rec.information2, hr_api.g_varchar2) or
1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1100: nvl(p_rec.information3, hr_api.g_varchar2) or
1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 1098: nvl(p_rec.information2, hr_api.g_varchar2) or

1094: nvl(p_rec.information_category, hr_api.g_varchar2) or
1095: nvl(per_eqt_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1096: nvl(p_rec.information1, hr_api.g_varchar2) or
1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1098: nvl(p_rec.information2, hr_api.g_varchar2) or
1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1100: nvl(p_rec.information3, hr_api.g_varchar2) or
1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1102: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>

1095: nvl(per_eqt_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1096: nvl(p_rec.information1, hr_api.g_varchar2) or
1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1098: nvl(p_rec.information2, hr_api.g_varchar2) or
1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1100: nvl(p_rec.information3, hr_api.g_varchar2) or
1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1102: nvl(p_rec.information4, hr_api.g_varchar2) or
1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 1100: nvl(p_rec.information3, hr_api.g_varchar2) or

1096: nvl(p_rec.information1, hr_api.g_varchar2) or
1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1098: nvl(p_rec.information2, hr_api.g_varchar2) or
1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1100: nvl(p_rec.information3, hr_api.g_varchar2) or
1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1102: nvl(p_rec.information4, hr_api.g_varchar2) or
1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1104: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>

1097: nvl(per_eqt_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1098: nvl(p_rec.information2, hr_api.g_varchar2) or
1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1100: nvl(p_rec.information3, hr_api.g_varchar2) or
1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1102: nvl(p_rec.information4, hr_api.g_varchar2) or
1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1104: nvl(p_rec.information5, hr_api.g_varchar2) or
1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 1102: nvl(p_rec.information4, hr_api.g_varchar2) or

1098: nvl(p_rec.information2, hr_api.g_varchar2) or
1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1100: nvl(p_rec.information3, hr_api.g_varchar2) or
1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1102: nvl(p_rec.information4, hr_api.g_varchar2) or
1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1104: nvl(p_rec.information5, hr_api.g_varchar2) or
1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1106: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>

1099: nvl(per_eqt_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1100: nvl(p_rec.information3, hr_api.g_varchar2) or
1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1102: nvl(p_rec.information4, hr_api.g_varchar2) or
1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1104: nvl(p_rec.information5, hr_api.g_varchar2) or
1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1106: nvl(p_rec.information6, hr_api.g_varchar2) or
1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 1104: nvl(p_rec.information5, hr_api.g_varchar2) or

1100: nvl(p_rec.information3, hr_api.g_varchar2) or
1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1102: nvl(p_rec.information4, hr_api.g_varchar2) or
1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1104: nvl(p_rec.information5, hr_api.g_varchar2) or
1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1106: nvl(p_rec.information6, hr_api.g_varchar2) or
1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1108: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>

1101: nvl(per_eqt_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1102: nvl(p_rec.information4, hr_api.g_varchar2) or
1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1104: nvl(p_rec.information5, hr_api.g_varchar2) or
1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1106: nvl(p_rec.information6, hr_api.g_varchar2) or
1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1108: nvl(p_rec.information7, hr_api.g_varchar2) or
1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 1106: nvl(p_rec.information6, hr_api.g_varchar2) or

1102: nvl(p_rec.information4, hr_api.g_varchar2) or
1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1104: nvl(p_rec.information5, hr_api.g_varchar2) or
1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1106: nvl(p_rec.information6, hr_api.g_varchar2) or
1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1108: nvl(p_rec.information7, hr_api.g_varchar2) or
1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1110: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>

1103: nvl(per_eqt_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1104: nvl(p_rec.information5, hr_api.g_varchar2) or
1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1106: nvl(p_rec.information6, hr_api.g_varchar2) or
1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1108: nvl(p_rec.information7, hr_api.g_varchar2) or
1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1110: nvl(p_rec.information8, hr_api.g_varchar2) or
1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 1108: nvl(p_rec.information7, hr_api.g_varchar2) or

1104: nvl(p_rec.information5, hr_api.g_varchar2) or
1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1106: nvl(p_rec.information6, hr_api.g_varchar2) or
1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1108: nvl(p_rec.information7, hr_api.g_varchar2) or
1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1110: nvl(p_rec.information8, hr_api.g_varchar2) or
1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1112: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>

1105: nvl(per_eqt_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1106: nvl(p_rec.information6, hr_api.g_varchar2) or
1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1108: nvl(p_rec.information7, hr_api.g_varchar2) or
1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1110: nvl(p_rec.information8, hr_api.g_varchar2) or
1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1112: nvl(p_rec.information9, hr_api.g_varchar2) or
1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 1110: nvl(p_rec.information8, hr_api.g_varchar2) or

1106: nvl(p_rec.information6, hr_api.g_varchar2) or
1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1108: nvl(p_rec.information7, hr_api.g_varchar2) or
1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1110: nvl(p_rec.information8, hr_api.g_varchar2) or
1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1112: nvl(p_rec.information9, hr_api.g_varchar2) or
1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1114: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>

1107: nvl(per_eqt_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1108: nvl(p_rec.information7, hr_api.g_varchar2) or
1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1110: nvl(p_rec.information8, hr_api.g_varchar2) or
1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1112: nvl(p_rec.information9, hr_api.g_varchar2) or
1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1114: nvl(p_rec.information10, hr_api.g_varchar2) or
1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 1112: nvl(p_rec.information9, hr_api.g_varchar2) or

1108: nvl(p_rec.information7, hr_api.g_varchar2) or
1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1110: nvl(p_rec.information8, hr_api.g_varchar2) or
1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1112: nvl(p_rec.information9, hr_api.g_varchar2) or
1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1114: nvl(p_rec.information10, hr_api.g_varchar2) or
1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1116: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>

1109: nvl(per_eqt_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1110: nvl(p_rec.information8, hr_api.g_varchar2) or
1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1112: nvl(p_rec.information9, hr_api.g_varchar2) or
1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1114: nvl(p_rec.information10, hr_api.g_varchar2) or
1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1116: nvl(p_rec.information11, hr_api.g_varchar2) or
1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 1114: nvl(p_rec.information10, hr_api.g_varchar2) or

1110: nvl(p_rec.information8, hr_api.g_varchar2) or
1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1112: nvl(p_rec.information9, hr_api.g_varchar2) or
1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1114: nvl(p_rec.information10, hr_api.g_varchar2) or
1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1116: nvl(p_rec.information11, hr_api.g_varchar2) or
1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1118: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>

1111: nvl(per_eqt_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1112: nvl(p_rec.information9, hr_api.g_varchar2) or
1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1114: nvl(p_rec.information10, hr_api.g_varchar2) or
1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1116: nvl(p_rec.information11, hr_api.g_varchar2) or
1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1118: nvl(p_rec.information12, hr_api.g_varchar2) or
1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 1116: nvl(p_rec.information11, hr_api.g_varchar2) or

1112: nvl(p_rec.information9, hr_api.g_varchar2) or
1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1114: nvl(p_rec.information10, hr_api.g_varchar2) or
1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1116: nvl(p_rec.information11, hr_api.g_varchar2) or
1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1118: nvl(p_rec.information12, hr_api.g_varchar2) or
1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1120: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>

1113: nvl(per_eqt_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1114: nvl(p_rec.information10, hr_api.g_varchar2) or
1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1116: nvl(p_rec.information11, hr_api.g_varchar2) or
1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1118: nvl(p_rec.information12, hr_api.g_varchar2) or
1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1120: nvl(p_rec.information13, hr_api.g_varchar2) or
1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 1118: nvl(p_rec.information12, hr_api.g_varchar2) or

1114: nvl(p_rec.information10, hr_api.g_varchar2) or
1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1116: nvl(p_rec.information11, hr_api.g_varchar2) or
1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1118: nvl(p_rec.information12, hr_api.g_varchar2) or
1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1120: nvl(p_rec.information13, hr_api.g_varchar2) or
1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1122: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>

1115: nvl(per_eqt_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1116: nvl(p_rec.information11, hr_api.g_varchar2) or
1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1118: nvl(p_rec.information12, hr_api.g_varchar2) or
1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1120: nvl(p_rec.information13, hr_api.g_varchar2) or
1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1122: nvl(p_rec.information14, hr_api.g_varchar2) or
1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 1120: nvl(p_rec.information13, hr_api.g_varchar2) or

1116: nvl(p_rec.information11, hr_api.g_varchar2) or
1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1118: nvl(p_rec.information12, hr_api.g_varchar2) or
1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1120: nvl(p_rec.information13, hr_api.g_varchar2) or
1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1122: nvl(p_rec.information14, hr_api.g_varchar2) or
1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1124: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>

1117: nvl(per_eqt_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1118: nvl(p_rec.information12, hr_api.g_varchar2) or
1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1120: nvl(p_rec.information13, hr_api.g_varchar2) or
1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1122: nvl(p_rec.information14, hr_api.g_varchar2) or
1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1124: nvl(p_rec.information15, hr_api.g_varchar2) or
1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 1122: nvl(p_rec.information14, hr_api.g_varchar2) or

1118: nvl(p_rec.information12, hr_api.g_varchar2) or
1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1120: nvl(p_rec.information13, hr_api.g_varchar2) or
1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1122: nvl(p_rec.information14, hr_api.g_varchar2) or
1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1124: nvl(p_rec.information15, hr_api.g_varchar2) or
1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1126: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>

1119: nvl(per_eqt_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1120: nvl(p_rec.information13, hr_api.g_varchar2) or
1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1122: nvl(p_rec.information14, hr_api.g_varchar2) or
1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1124: nvl(p_rec.information15, hr_api.g_varchar2) or
1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1126: nvl(p_rec.information16, hr_api.g_varchar2) or
1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 1124: nvl(p_rec.information15, hr_api.g_varchar2) or

1120: nvl(p_rec.information13, hr_api.g_varchar2) or
1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1122: nvl(p_rec.information14, hr_api.g_varchar2) or
1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1124: nvl(p_rec.information15, hr_api.g_varchar2) or
1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1126: nvl(p_rec.information16, hr_api.g_varchar2) or
1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1128: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>

1121: nvl(per_eqt_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1122: nvl(p_rec.information14, hr_api.g_varchar2) or
1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1124: nvl(p_rec.information15, hr_api.g_varchar2) or
1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1126: nvl(p_rec.information16, hr_api.g_varchar2) or
1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1128: nvl(p_rec.information17, hr_api.g_varchar2) or
1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 1126: nvl(p_rec.information16, hr_api.g_varchar2) or

1122: nvl(p_rec.information14, hr_api.g_varchar2) or
1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1124: nvl(p_rec.information15, hr_api.g_varchar2) or
1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1126: nvl(p_rec.information16, hr_api.g_varchar2) or
1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1128: nvl(p_rec.information17, hr_api.g_varchar2) or
1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1130: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>

1123: nvl(per_eqt_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1124: nvl(p_rec.information15, hr_api.g_varchar2) or
1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1126: nvl(p_rec.information16, hr_api.g_varchar2) or
1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1128: nvl(p_rec.information17, hr_api.g_varchar2) or
1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1130: nvl(p_rec.information18, hr_api.g_varchar2) or
1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 1128: nvl(p_rec.information17, hr_api.g_varchar2) or

1124: nvl(p_rec.information15, hr_api.g_varchar2) or
1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1126: nvl(p_rec.information16, hr_api.g_varchar2) or
1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1128: nvl(p_rec.information17, hr_api.g_varchar2) or
1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1130: nvl(p_rec.information18, hr_api.g_varchar2) or
1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1132: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>

1125: nvl(per_eqt_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1126: nvl(p_rec.information16, hr_api.g_varchar2) or
1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1128: nvl(p_rec.information17, hr_api.g_varchar2) or
1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1130: nvl(p_rec.information18, hr_api.g_varchar2) or
1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1132: nvl(p_rec.information19, hr_api.g_varchar2) or
1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 1130: nvl(p_rec.information18, hr_api.g_varchar2) or

1126: nvl(p_rec.information16, hr_api.g_varchar2) or
1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1128: nvl(p_rec.information17, hr_api.g_varchar2) or
1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1130: nvl(p_rec.information18, hr_api.g_varchar2) or
1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1132: nvl(p_rec.information19, hr_api.g_varchar2) or
1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1134: nvl(p_rec.information20, hr_api.g_varchar2) or

Line 1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>

1127: nvl(per_eqt_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1128: nvl(p_rec.information17, hr_api.g_varchar2) or
1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1130: nvl(p_rec.information18, hr_api.g_varchar2) or
1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1132: nvl(p_rec.information19, hr_api.g_varchar2) or
1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1134: nvl(p_rec.information20, hr_api.g_varchar2) or
1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 1132: nvl(p_rec.information19, hr_api.g_varchar2) or

1128: nvl(p_rec.information17, hr_api.g_varchar2) or
1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1130: nvl(p_rec.information18, hr_api.g_varchar2) or
1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1132: nvl(p_rec.information19, hr_api.g_varchar2) or
1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1134: nvl(p_rec.information20, hr_api.g_varchar2) or
1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1136: nvl(p_rec.information21, hr_api.g_varchar2) or

Line 1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>

1129: nvl(per_eqt_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1130: nvl(p_rec.information18, hr_api.g_varchar2) or
1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1132: nvl(p_rec.information19, hr_api.g_varchar2) or
1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1134: nvl(p_rec.information20, hr_api.g_varchar2) or
1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1136: nvl(p_rec.information21, hr_api.g_varchar2) or
1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 1134: nvl(p_rec.information20, hr_api.g_varchar2) or

1130: nvl(p_rec.information18, hr_api.g_varchar2) or
1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1132: nvl(p_rec.information19, hr_api.g_varchar2) or
1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1134: nvl(p_rec.information20, hr_api.g_varchar2) or
1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1136: nvl(p_rec.information21, hr_api.g_varchar2) or
1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1138: nvl(p_rec.information22, hr_api.g_varchar2) or

Line 1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>

1131: nvl(per_eqt_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1132: nvl(p_rec.information19, hr_api.g_varchar2) or
1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1134: nvl(p_rec.information20, hr_api.g_varchar2) or
1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1136: nvl(p_rec.information21, hr_api.g_varchar2) or
1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1138: nvl(p_rec.information22, hr_api.g_varchar2) or
1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 1136: nvl(p_rec.information21, hr_api.g_varchar2) or

1132: nvl(p_rec.information19, hr_api.g_varchar2) or
1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1134: nvl(p_rec.information20, hr_api.g_varchar2) or
1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1136: nvl(p_rec.information21, hr_api.g_varchar2) or
1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1138: nvl(p_rec.information22, hr_api.g_varchar2) or
1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1140: nvl(p_rec.information23, hr_api.g_varchar2) or

Line 1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>

1133: nvl(per_eqt_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1134: nvl(p_rec.information20, hr_api.g_varchar2) or
1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1136: nvl(p_rec.information21, hr_api.g_varchar2) or
1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1138: nvl(p_rec.information22, hr_api.g_varchar2) or
1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1140: nvl(p_rec.information23, hr_api.g_varchar2) or
1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 1138: nvl(p_rec.information22, hr_api.g_varchar2) or

1134: nvl(p_rec.information20, hr_api.g_varchar2) or
1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1136: nvl(p_rec.information21, hr_api.g_varchar2) or
1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1138: nvl(p_rec.information22, hr_api.g_varchar2) or
1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1140: nvl(p_rec.information23, hr_api.g_varchar2) or
1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1142: nvl(p_rec.information24, hr_api.g_varchar2) or

Line 1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>

1135: nvl(per_eqt_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1136: nvl(p_rec.information21, hr_api.g_varchar2) or
1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1138: nvl(p_rec.information22, hr_api.g_varchar2) or
1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1140: nvl(p_rec.information23, hr_api.g_varchar2) or
1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1142: nvl(p_rec.information24, hr_api.g_varchar2) or
1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 1140: nvl(p_rec.information23, hr_api.g_varchar2) or

1136: nvl(p_rec.information21, hr_api.g_varchar2) or
1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1138: nvl(p_rec.information22, hr_api.g_varchar2) or
1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1140: nvl(p_rec.information23, hr_api.g_varchar2) or
1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1142: nvl(p_rec.information24, hr_api.g_varchar2) or
1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1144: nvl(p_rec.information25, hr_api.g_varchar2) or

Line 1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>

1137: nvl(per_eqt_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1138: nvl(p_rec.information22, hr_api.g_varchar2) or
1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1140: nvl(p_rec.information23, hr_api.g_varchar2) or
1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1142: nvl(p_rec.information24, hr_api.g_varchar2) or
1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1144: nvl(p_rec.information25, hr_api.g_varchar2) or
1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 1142: nvl(p_rec.information24, hr_api.g_varchar2) or

1138: nvl(p_rec.information22, hr_api.g_varchar2) or
1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1140: nvl(p_rec.information23, hr_api.g_varchar2) or
1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1142: nvl(p_rec.information24, hr_api.g_varchar2) or
1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1144: nvl(p_rec.information25, hr_api.g_varchar2) or
1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1146: nvl(p_rec.information26, hr_api.g_varchar2) or

Line 1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>

1139: nvl(per_eqt_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1140: nvl(p_rec.information23, hr_api.g_varchar2) or
1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1142: nvl(p_rec.information24, hr_api.g_varchar2) or
1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1144: nvl(p_rec.information25, hr_api.g_varchar2) or
1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1146: nvl(p_rec.information26, hr_api.g_varchar2) or
1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 1144: nvl(p_rec.information25, hr_api.g_varchar2) or

1140: nvl(p_rec.information23, hr_api.g_varchar2) or
1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1142: nvl(p_rec.information24, hr_api.g_varchar2) or
1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1144: nvl(p_rec.information25, hr_api.g_varchar2) or
1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1146: nvl(p_rec.information26, hr_api.g_varchar2) or
1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1148: nvl(p_rec.information27, hr_api.g_varchar2) or

Line 1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>

1141: nvl(per_eqt_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1142: nvl(p_rec.information24, hr_api.g_varchar2) or
1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1144: nvl(p_rec.information25, hr_api.g_varchar2) or
1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1146: nvl(p_rec.information26, hr_api.g_varchar2) or
1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1148: nvl(p_rec.information27, hr_api.g_varchar2) or
1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 1146: nvl(p_rec.information26, hr_api.g_varchar2) or

1142: nvl(p_rec.information24, hr_api.g_varchar2) or
1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1144: nvl(p_rec.information25, hr_api.g_varchar2) or
1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1146: nvl(p_rec.information26, hr_api.g_varchar2) or
1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1148: nvl(p_rec.information27, hr_api.g_varchar2) or
1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1150: nvl(p_rec.information28, hr_api.g_varchar2) or

Line 1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>

1143: nvl(per_eqt_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1144: nvl(p_rec.information25, hr_api.g_varchar2) or
1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1146: nvl(p_rec.information26, hr_api.g_varchar2) or
1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1148: nvl(p_rec.information27, hr_api.g_varchar2) or
1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1150: nvl(p_rec.information28, hr_api.g_varchar2) or
1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 1148: nvl(p_rec.information27, hr_api.g_varchar2) or

1144: nvl(p_rec.information25, hr_api.g_varchar2) or
1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1146: nvl(p_rec.information26, hr_api.g_varchar2) or
1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1148: nvl(p_rec.information27, hr_api.g_varchar2) or
1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1150: nvl(p_rec.information28, hr_api.g_varchar2) or
1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1152: nvl(p_rec.information29, hr_api.g_varchar2) or

Line 1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>

1145: nvl(per_eqt_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1146: nvl(p_rec.information26, hr_api.g_varchar2) or
1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1148: nvl(p_rec.information27, hr_api.g_varchar2) or
1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1150: nvl(p_rec.information28, hr_api.g_varchar2) or
1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1152: nvl(p_rec.information29, hr_api.g_varchar2) or
1153: nvl(per_eqt_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 1150: nvl(p_rec.information28, hr_api.g_varchar2) or

1146: nvl(p_rec.information26, hr_api.g_varchar2) or
1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1148: nvl(p_rec.information27, hr_api.g_varchar2) or
1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1150: nvl(p_rec.information28, hr_api.g_varchar2) or
1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1152: nvl(p_rec.information29, hr_api.g_varchar2) or
1153: nvl(per_eqt_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1154: nvl(p_rec.information30, hr_api.g_varchar2)))

Line 1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>

1147: nvl(per_eqt_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1148: nvl(p_rec.information27, hr_api.g_varchar2) or
1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1150: nvl(p_rec.information28, hr_api.g_varchar2) or
1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1152: nvl(p_rec.information29, hr_api.g_varchar2) or
1153: nvl(per_eqt_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1154: nvl(p_rec.information30, hr_api.g_varchar2)))
1155: or

Line 1152: nvl(p_rec.information29, hr_api.g_varchar2) or

1148: nvl(p_rec.information27, hr_api.g_varchar2) or
1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1150: nvl(p_rec.information28, hr_api.g_varchar2) or
1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1152: nvl(p_rec.information29, hr_api.g_varchar2) or
1153: nvl(per_eqt_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1154: nvl(p_rec.information30, hr_api.g_varchar2)))
1155: or
1156: (p_rec.qualification_type_id is null) then

Line 1153: nvl(per_eqt_shd.g_old_rec.information30, hr_api.g_varchar2) <>

1149: nvl(per_eqt_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1150: nvl(p_rec.information28, hr_api.g_varchar2) or
1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1152: nvl(p_rec.information29, hr_api.g_varchar2) or
1153: nvl(per_eqt_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1154: nvl(p_rec.information30, hr_api.g_varchar2)))
1155: or
1156: (p_rec.qualification_type_id is null) then
1157: --

Line 1154: nvl(p_rec.information30, hr_api.g_varchar2)))

1150: nvl(p_rec.information28, hr_api.g_varchar2) or
1151: nvl(per_eqt_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1152: nvl(p_rec.information29, hr_api.g_varchar2) or
1153: nvl(per_eqt_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1154: nvl(p_rec.information30, hr_api.g_varchar2)))
1155: or
1156: (p_rec.qualification_type_id is null) then
1157: --
1158: -- Only execute the validation if absolutely necessary:

Line 1253: -- hr_api.set_security_group_id(p_security_group_id => 0);

1249: -- to it as the default security_group_id.
1250: --
1251: -- Fix for bug 2723065
1252: -- Commented line which hardcodes security profile to '0'
1253: -- hr_api.set_security_group_id(p_security_group_id => 0);
1254: --
1255: hr_utility.set_location('Entering:'||l_proc, 7);
1256: --
1257: -- Call all supporting business operations

Line 1421: --hr_api.set_security_group_id(p_security_group_id => 0);

1417: -- to it as the default security_group_id.
1418: --
1419: -- Fix for bug 2723065
1420: -- Commented line which hardcodes security profile to '0'
1421: --hr_api.set_security_group_id(p_security_group_id => 0);
1422: --
1423: -- Call all supporting business operations
1424: --
1425: -- Business Rule Mapping