[Home] [Help]
187: --
188: -- check that the consultation date is
189: -- before the next consultation date
190: --
191: IF p_consultation_date > nvl(p_next_consultation_date,hr_api.g_eot) THEN
192: --
193: hr_utility.set_message(800, 'HR_52735_MEA_INV_DATE_COMB');
194: hr_utility.raise_error;
195: --
330: cursor csr_org is
331: select business_group_id
332: from hr_all_organization_units hou
333: where hou.organization_id = p_organization_id
334: and p_effective_date between hou.date_from and nvl(hou.date_to, hr_api.g_eot);
335: --
336: cursor csr_org_inf is
337: select null
338: from hr_organization_information hoi
350: hr_utility.set_location('Entering:'|| l_proc, 10);
351: --
352: -- Check mandatory parameters have been set
353: --
354: hr_api.mandatory_arg_error
355: (p_api_name => l_proc
356: ,p_argument => 'business_group_id'
357: ,p_argument_value => p_business_group_id);
358: --
355: (p_api_name => l_proc
356: ,p_argument => 'business_group_id'
357: ,p_argument_value => p_business_group_id);
358: --
359: hr_api.mandatory_arg_error
360: (p_api_name => l_proc
361: ,p_argument => 'effective_date'
362: ,p_argument_value => p_effective_date);
363: --
463: hr_utility.set_location('Entering:'|| l_proc, 10);
464: --
465: -- Check mandatory parameters have been set
466: --
467: hr_api.mandatory_arg_error
468: (p_api_name => l_proc
469: ,p_argument => 'consultation_date'
470: ,p_argument_value => p_consultation_date);
471: --
527: hr_utility.set_location('Entering:'||l_proc, 10);
528: --
529: -- Check mandatory parameters have been set
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc
533: ,p_argument => 'consultation_type'
534: ,p_argument_value => p_consultation_type);
535: --
546: hr_utility.set_location(l_proc, 30);
547: --
548: -- Check that the consultation type exists in HR_LOOKUPS
549: --
550: IF hr_api.not_exists_in_hr_lookups
551: (p_effective_date => p_effective_date
552: ,p_lookup_type => 'CONSULTATION_TYPE'
553: ,p_lookup_code => p_consultation_type) THEN
554: --
628: hr_utility.set_location(l_proc, 20);
629: --
630: -- Check that the consultation result exists in HR_LOOKUPS
631: --
632: IF hr_api.not_exists_in_hr_lookups
633: (p_effective_date => p_effective_date
634: ,p_lookup_type => 'CONSULTATION_RESULT'
635: ,p_lookup_code => p_consultation_result) THEN
636: --
1122: hr_utility.set_location('Entering:'|| l_proc, 10);
1123: --
1124: -- Ensure that all the mandatory parameter are not null
1125: --
1126: hr_api.mandatory_arg_error
1127: (p_api_name => l_proc
1128: ,p_argument => 'medical_assessment_id'
1129: ,p_argument_value => p_medical_assessment_id
1130: );
1145: close csr_sec_grp;
1146: --
1147: -- Set the security_group_id in CLIENT_INFO
1148: --
1149: hr_api.set_security_group_id
1150: (p_security_group_id => l_security_group_id
1151: );
1152: --
1153: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1184: hr_utility.set_location('Entering:'|| l_proc, 10);
1185: --
1186: -- Ensure that all the mandatory parameter are not null
1187: --
1188: hr_api.mandatory_arg_error
1189: (p_api_name => l_proc
1190: ,p_argument => 'medical_assessment_id'
1191: ,p_argument_value => p_medical_assessment_id
1192: );
1190: ,p_argument => 'medical_assessment_id'
1191: ,p_argument_value => p_medical_assessment_id
1192: );
1193: --
1194: if ( nvl(per_mea_bus.g_medical_assessment_id, hr_api.g_number)
1195: = p_medical_assessment_id) then
1196: --
1197: -- The legislation code has already been found with a previous
1198: -- call to this function. Just return the value in the global
1267: BEGIN
1268: hr_utility.set_location('Entering:'||l_proc,10);
1269: --
1270: if ((p_rec.medical_assessment_id is not null) and (
1271: nvl(per_mea_shd.g_old_rec.mea_information_category, hr_api.g_varchar2) <>
1272: nvl(p_rec.mea_information_category, hr_api.g_varchar2) or
1273: nvl(per_mea_shd.g_old_rec.mea_information1, hr_api.g_varchar2) <>
1274: nvl(p_rec.mea_information1, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1268: hr_utility.set_location('Entering:'||l_proc,10);
1269: --
1270: if ((p_rec.medical_assessment_id is not null) and (
1271: nvl(per_mea_shd.g_old_rec.mea_information_category, hr_api.g_varchar2) <>
1272: nvl(p_rec.mea_information_category, hr_api.g_varchar2) or
1273: nvl(per_mea_shd.g_old_rec.mea_information1, hr_api.g_varchar2) <>
1274: nvl(p_rec.mea_information1, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1269: --
1270: if ((p_rec.medical_assessment_id is not null) and (
1271: nvl(per_mea_shd.g_old_rec.mea_information_category, hr_api.g_varchar2) <>
1272: nvl(p_rec.mea_information_category, hr_api.g_varchar2) or
1273: nvl(per_mea_shd.g_old_rec.mea_information1, hr_api.g_varchar2) <>
1274: nvl(p_rec.mea_information1, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1270: if ((p_rec.medical_assessment_id is not null) and (
1271: nvl(per_mea_shd.g_old_rec.mea_information_category, hr_api.g_varchar2) <>
1272: nvl(p_rec.mea_information_category, hr_api.g_varchar2) or
1273: nvl(per_mea_shd.g_old_rec.mea_information1, hr_api.g_varchar2) <>
1274: nvl(p_rec.mea_information1, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1271: nvl(per_mea_shd.g_old_rec.mea_information_category, hr_api.g_varchar2) <>
1272: nvl(p_rec.mea_information_category, hr_api.g_varchar2) or
1273: nvl(per_mea_shd.g_old_rec.mea_information1, hr_api.g_varchar2) <>
1274: nvl(p_rec.mea_information1, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1272: nvl(p_rec.mea_information_category, hr_api.g_varchar2) or
1273: nvl(per_mea_shd.g_old_rec.mea_information1, hr_api.g_varchar2) <>
1274: nvl(p_rec.mea_information1, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1273: nvl(per_mea_shd.g_old_rec.mea_information1, hr_api.g_varchar2) <>
1274: nvl(p_rec.mea_information1, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1274: nvl(p_rec.mea_information1, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1276: nvl(p_rec.mea_information2, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1278: nvl(p_rec.mea_information3, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1280: nvl(p_rec.mea_information4, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1282: nvl(p_rec.mea_information5, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1284: nvl(p_rec.mea_information6, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1286: nvl(p_rec.mea_information7, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1288: nvl(p_rec.mea_information8, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1290: nvl(p_rec.mea_information9, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1292: nvl(p_rec.mea_information10, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1294: nvl(p_rec.mea_information11, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1296: nvl(p_rec.mea_information12, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1298: nvl(p_rec.mea_information13, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1300: nvl(p_rec.mea_information14, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1302: nvl(p_rec.mea_information15, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1304: nvl(p_rec.mea_information16, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1306: nvl(p_rec.mea_information17, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1308: nvl(p_rec.mea_information18, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1310: nvl(p_rec.mea_information19, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1312: nvl(p_rec.mea_information20, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1314: nvl(p_rec.mea_information21, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1316: nvl(p_rec.mea_information22, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1318: nvl(p_rec.mea_information23, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1320: nvl(p_rec.mea_information24, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1329: nvl(per_mea_shd.g_old_rec.mea_information29, hr_api.g_varchar2) <>
1322: nvl(p_rec.mea_information25, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1329: nvl(per_mea_shd.g_old_rec.mea_information29, hr_api.g_varchar2) <>
1330: nvl(p_rec.mea_information29, hr_api.g_varchar2) or
1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1329: nvl(per_mea_shd.g_old_rec.mea_information29, hr_api.g_varchar2) <>
1330: nvl(p_rec.mea_information29, hr_api.g_varchar2) or
1331: nvl(per_mea_shd.g_old_rec.mea_information30, hr_api.g_varchar2) <>
1324: nvl(p_rec.mea_information26, hr_api.g_varchar2) or
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1329: nvl(per_mea_shd.g_old_rec.mea_information29, hr_api.g_varchar2) <>
1330: nvl(p_rec.mea_information29, hr_api.g_varchar2) or
1331: nvl(per_mea_shd.g_old_rec.mea_information30, hr_api.g_varchar2) <>
1332: nvl(p_rec.mea_information30, hr_api.g_varchar2) ))
1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1329: nvl(per_mea_shd.g_old_rec.mea_information29, hr_api.g_varchar2) <>
1330: nvl(p_rec.mea_information29, hr_api.g_varchar2) or
1331: nvl(per_mea_shd.g_old_rec.mea_information30, hr_api.g_varchar2) <>
1332: nvl(p_rec.mea_information30, hr_api.g_varchar2) ))
1333: or (p_rec.medical_assessment_id is null) then
1326: nvl(p_rec.mea_information27, hr_api.g_varchar2) or
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1329: nvl(per_mea_shd.g_old_rec.mea_information29, hr_api.g_varchar2) <>
1330: nvl(p_rec.mea_information29, hr_api.g_varchar2) or
1331: nvl(per_mea_shd.g_old_rec.mea_information30, hr_api.g_varchar2) <>
1332: nvl(p_rec.mea_information30, hr_api.g_varchar2) ))
1333: or (p_rec.medical_assessment_id is null) then
1334: --
1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1329: nvl(per_mea_shd.g_old_rec.mea_information29, hr_api.g_varchar2) <>
1330: nvl(p_rec.mea_information29, hr_api.g_varchar2) or
1331: nvl(per_mea_shd.g_old_rec.mea_information30, hr_api.g_varchar2) <>
1332: nvl(p_rec.mea_information30, hr_api.g_varchar2) ))
1333: or (p_rec.medical_assessment_id is null) then
1334: --
1335: -- Only execute the validation if absolutely necessary:
1328: nvl(p_rec.mea_information28, hr_api.g_varchar2) or
1329: nvl(per_mea_shd.g_old_rec.mea_information29, hr_api.g_varchar2) <>
1330: nvl(p_rec.mea_information29, hr_api.g_varchar2) or
1331: nvl(per_mea_shd.g_old_rec.mea_information30, hr_api.g_varchar2) <>
1332: nvl(p_rec.mea_information30, hr_api.g_varchar2) ))
1333: or (p_rec.medical_assessment_id is null) then
1334: --
1335: -- Only execute the validation if absolutely necessary:
1336: -- a) During update, the structure column value or any
1444: BEGIN
1445: hr_utility.set_location('Entering:'||l_proc,10);
1446: --
1447: if ((p_rec.medical_assessment_id is not null) and (
1448: nvl(per_mea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1450: nvl(per_mea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1445: hr_utility.set_location('Entering:'||l_proc,10);
1446: --
1447: if ((p_rec.medical_assessment_id is not null) and (
1448: nvl(per_mea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1450: nvl(per_mea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1446: --
1447: if ((p_rec.medical_assessment_id is not null) and (
1448: nvl(per_mea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1450: nvl(per_mea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1447: if ((p_rec.medical_assessment_id is not null) and (
1448: nvl(per_mea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1450: nvl(per_mea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1448: nvl(per_mea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1450: nvl(per_mea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1450: nvl(per_mea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1450: nvl(per_mea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1467: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1469: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1471: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1473: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1475: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1477: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1479: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1481: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1483: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1485: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1487: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1489: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1491: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1493: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1495: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1497: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1506: nvl(per_mea_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1499: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1506: nvl(per_mea_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1507: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1506: nvl(per_mea_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1507: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1508: nvl(per_mea_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1501: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1506: nvl(per_mea_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1507: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1508: nvl(per_mea_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1509: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1506: nvl(per_mea_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1507: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1508: nvl(per_mea_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1509: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1510: or (p_rec.medical_assessment_id is null) then
1503: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1506: nvl(per_mea_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1507: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1508: nvl(per_mea_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1509: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1510: or (p_rec.medical_assessment_id is null) then
1511: --
1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1506: nvl(per_mea_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1507: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1508: nvl(per_mea_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1509: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1510: or (p_rec.medical_assessment_id is null) then
1511: --
1512: -- Only execute the validation if absolutely necessary:
1505: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1506: nvl(per_mea_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1507: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1508: nvl(per_mea_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1509: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1510: or (p_rec.medical_assessment_id is null) then
1511: --
1512: -- Only execute the validation if absolutely necessary:
1513: -- a) During update, the structure column value or any
1636: fnd_message.raise_error;
1637: --
1638: END IF;
1639: --
1640: IF nvl(p_rec.person_id, hr_api.g_number) <>
1641: nvl(per_mea_shd.g_old_rec.person_id,hr_api.g_number) THEN
1642: --
1643: l_argument := 'person_id';
1644: RAISE l_error;
1637: --
1638: END IF;
1639: --
1640: IF nvl(p_rec.person_id, hr_api.g_number) <>
1641: nvl(per_mea_shd.g_old_rec.person_id,hr_api.g_number) THEN
1642: --
1643: l_argument := 'person_id';
1644: RAISE l_error;
1645: --
1646: END IF;
1647: --
1648: EXCEPTION
1649: WHEN l_error THEN
1650: hr_api.argument_changed_error
1651: (p_api_name => l_proc
1652: ,p_argument => l_argument);
1653: WHEN OTHERS THEN
1654: RAISE;