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 PER_EQT_SHD

Line 22: l_api_updating := per_eqt_shd.api_updating

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: l_api_updating := per_eqt_shd.api_updating
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

Line 28: <> per_eqt_shd.g_old_rec.qualification_type_id or

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
32: not l_api_updating then

Line 36: per_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');

32: not l_api_updating then
33: --
34: -- raise error as PK not null
35: --
36: per_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');
37: --
38: end if;
39: --
40: -- check if qualification_type_id has been updated

Line 43: <> per_eqt_shd.g_old_rec.qualification_type_id

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

Line 48: per_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');

44: and l_api_updating then
45: --
46: -- raise error as update is not allowed
47: --
48: per_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');
49: --
50: end if;
51: --
52: end if;

Line 97: l_api_updating := per_eqt_shd.api_updating

93: Begin
94: --
95: hr_utility.set_location('Entering:'||l_proc, 5);
96: --
97: l_api_updating := per_eqt_shd.api_updating
98: (p_qualification_type_id => p_qualification_type_id,
99: p_object_version_number => p_object_version_number);
100: --
101: if (l_api_updating

Line 103: <> per_eqt_shd.g_old_rec.category

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

Line 239: l_api_updating := per_eqt_shd.api_updating

235: -- Only proceed with validation if :
236: -- a) The current g_old_rec is current and
237: -- b) The value for qualification_type type has changed
238: --
239: l_api_updating := per_eqt_shd.api_updating
240: (p_qualification_type_id => p_qualification_type_id
241: ,p_object_version_number => p_object_version_number);
242: --
243: if p_qual_framework_id is not null then

Line 244: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qual_framework_id,

240: (p_qualification_type_id => p_qualification_type_id
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)

Line 318: l_api_updating := per_eqt_shd.api_updating

314: -- Only proceed with validation if :
315: -- a) The current g_old_rec is current and
316: -- b) The value for qualification_type type has changed
317: --
318: l_api_updating := per_eqt_shd.api_updating
319: (p_qualification_type_id => p_qualification_type_id
320: ,p_object_version_number => p_object_version_number);
321: --
322: if p_qualification_type is not null then

Line 323: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qualification_type,

319: (p_qualification_type_id => p_qualification_type_id
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)

Line 398: l_api_updating := per_eqt_shd.api_updating

394: -- Only proceed with validation if :
395: -- a) The current g_old_rec is current and
396: -- b) The value for credit type has changed
397: --
398: l_api_updating := per_eqt_shd.api_updating
399: (p_qualification_type_id => p_qualification_type_id
400: ,p_object_version_number => p_object_version_number);
401: --
402: if p_credit_type is not null then

Line 403: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.credit_type,

399: (p_qualification_type_id => p_qualification_type_id
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)

Line 479: l_api_updating := per_eqt_shd.api_updating

475: -- Only proceed with validation if :
476: -- a) The current g_old_rec is current and
477: -- b) The value for level type has changed
478: --
479: l_api_updating := per_eqt_shd.api_updating
480: (p_qualification_type_id => p_qualification_type_id
481: ,p_object_version_number => p_object_version_number);
482: --
483: if p_level_type is not null then

Line 484: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.level_type,

480: (p_qualification_type_id => p_qualification_type_id
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)

Line 560: l_api_updating := per_eqt_shd.api_updating

556: -- Only proceed with validation if :
557: -- a) The current g_old_rec is current and
558: -- b) The value for level has changed
559: --
560: l_api_updating := per_eqt_shd.api_updating
561: (p_qualification_type_id => p_qualification_type_id
562: ,p_object_version_number => p_object_version_number);
563: --
564: if p_level_number is not null then

Line 565: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.level_number,

561: (p_qualification_type_id => p_qualification_type_id
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)

Line 641: l_api_updating := per_eqt_shd.api_updating

637: -- Only proceed with validation if :
638: -- a) The current g_old_rec is current and
639: -- b) The value for field has changed
640: --
641: l_api_updating := per_eqt_shd.api_updating
642: (p_qualification_type_id => p_qualification_type_id
643: ,p_object_version_number => p_object_version_number);
644: --
645: if p_field is not null then

Line 646: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.field,

642: (p_qualification_type_id => p_qualification_type_id
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)

Line 722: l_api_updating := per_eqt_shd.api_updating

718: -- Only proceed with validation if :
719: -- a) The current g_old_rec is current and
720: -- b) The value for sub field has changed
721: --
722: l_api_updating := per_eqt_shd.api_updating
723: (p_qualification_type_id => p_qualification_type_id
724: ,p_object_version_number => p_object_version_number);
725: --
726: if p_sub_field is not null then

Line 727: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.sub_field,

723: (p_qualification_type_id => p_qualification_type_id
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)

Line 803: l_api_updating := per_eqt_shd.api_updating

799: -- Only proceed with validation if :
800: -- a) The current g_old_rec is current and
801: -- b) The value for provider has changed
802: --
803: l_api_updating := per_eqt_shd.api_updating
804: (p_qualification_type_id => p_qualification_type_id
805: ,p_object_version_number => p_object_version_number);
806: --
807: if p_provider is not null then

Line 808: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.provider,

804: (p_qualification_type_id => p_qualification_type_id
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)

Line 884: l_api_updating := per_eqt_shd.api_updating

880: -- Only proceed with validation if :
881: -- a) The current g_old_rec is current and
882: -- b) The value for qa organization has changed
883: --
884: l_api_updating := per_eqt_shd.api_updating
885: (p_qualification_type_id => p_qualification_type_id
886: ,p_object_version_number => p_object_version_number);
887: --
888: if p_qa_organization is not null then

Line 889: if ( (l_api_updating and nvl(per_eqt_shd.g_old_rec.qa_organization,

885: (p_qualification_type_id => p_qualification_type_id
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)

Line 946: (p_rec in per_eqt_shd.g_rec_type) is

942: -- Access Status:
943: -- Internal Row Handler Use Only.
944: --
945: procedure chk_df
946: (p_rec in per_eqt_shd.g_rec_type) is
947: --
948: l_proc varchar2(72) := g_package||'chk_df';
949: --
950: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1084: (p_rec in per_eqt_shd.g_rec_type) is

1080: -- Access Status:
1081: -- Internal Row Handler Use Only.
1082: --
1083: procedure chk_ddf
1084: (p_rec in per_eqt_shd.g_rec_type) is
1085: --
1086: l_proc varchar2(72) := g_package||'chk_ddf';
1087: --
1088: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1238: Procedure insert_validate(p_rec in per_eqt_shd.g_rec_type,

1234:
1235: -- ----------------------------------------------------------------------------
1236: -- |---------------------------< insert_validate >----------------------------|
1237: -- ----------------------------------------------------------------------------
1238: Procedure insert_validate(p_rec in per_eqt_shd.g_rec_type,
1239: p_effective_date in date) is
1240: --
1241: l_proc varchar2(72) := g_package||'insert_validate';
1242: --

Line 1406: Procedure update_validate(p_rec in per_eqt_shd.g_rec_type,

1402: --
1403: -- ----------------------------------------------------------------------------
1404: -- |---------------------------< update_validate >----------------------------|
1405: -- ----------------------------------------------------------------------------
1406: Procedure update_validate(p_rec in per_eqt_shd.g_rec_type,
1407: p_effective_date in date) is
1408: --
1409: l_proc varchar2(72) := g_package||'update_validate';
1410: --

Line 1575: Procedure delete_validate(p_rec in per_eqt_shd.g_rec_type) is

1571: --
1572: -- ----------------------------------------------------------------------------
1573: -- |---------------------------< delete_validate >----------------------------|
1574: -- ----------------------------------------------------------------------------
1575: Procedure delete_validate(p_rec in per_eqt_shd.g_rec_type) is
1576: --
1577: l_proc varchar2(72) := g_package||'delete_validate';
1578: --
1579: Begin