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_MEA_BUS dependencies on PER_MEA_SHD

Line 365: per_mea_shd.g_old_rec.organization_id <> p_organization_id THEN

361: ,p_argument => 'effective_date'
362: ,p_argument_value => p_effective_date);
363: --
364: IF p_organization_id is not null AND
365: per_mea_shd.g_old_rec.organization_id <> p_organization_id THEN
366: --
367: hr_utility.set_location(l_proc, 20);
368: --
369: -- check org exists in hr_all_organization_units (fk) for the persons bg

Line 544: (per_mea_shd.g_old_rec.consultation_type <> p_consultation_type))) THEN

540: -- b) The value for consultation type has changed
541: --
542: IF ( (p_medical_assessment_id is null) OR
543: ((p_medical_assessment_id is not null) AND
544: (per_mea_shd.g_old_rec.consultation_type <> p_consultation_type))) THEN
545: --
546: hr_utility.set_location(l_proc, 30);
547: --
548: -- Check that the consultation type exists in HR_LOOKUPS

Line 626: per_mea_shd.g_old_rec.consultation_result <> p_consultation_result THEN

622: -- a) Consultation_result is not null
623: -- b) The value for consultation result has changed
624: --
625: IF p_consultation_result IS NOT NULL OR
626: per_mea_shd.g_old_rec.consultation_result <> p_consultation_result THEN
627: --
628: hr_utility.set_location(l_proc, 20);
629: --
630: -- Check that the consultation result exists in HR_LOOKUPS

Line 710: per_mea_shd.g_old_rec.incident_id <> p_incident_id THEN

706: -- a) Incident ID is not blank
707: -- b) The value for incident_id has changed
708: --
709: IF p_incident_id IS NOT NULL OR
710: per_mea_shd.g_old_rec.incident_id <> p_incident_id THEN
711: --
712: hr_utility.set_location(l_proc, 20);
713: --
714: -- Check to see if a work incident record

Line 807: IF per_mea_shd.g_old_rec.disability_id <> p_disability_id OR

803: --
804: -- Only continue if the disability_id or incident_id have
805: -- changed
806: --
807: IF per_mea_shd.g_old_rec.disability_id <> p_disability_id OR
808: per_mea_shd.g_old_rec.incident_id <> p_incident_id THEN
809: --
810: hr_utility.set_location(l_proc, 30);
811: --

Line 808: per_mea_shd.g_old_rec.incident_id <> p_incident_id THEN

804: -- Only continue if the disability_id or incident_id have
805: -- changed
806: --
807: IF per_mea_shd.g_old_rec.disability_id <> p_disability_id OR
808: per_mea_shd.g_old_rec.incident_id <> p_incident_id THEN
809: --
810: hr_utility.set_location(l_proc, 30);
811: --
812: -- Check to see if a medical assessment record exists

Line 913: IF per_mea_shd.g_old_rec.disability_id <> p_disability_id OR

909: --
910: -- Only continue if the disability_id or incident_id have
911: -- changed
912: --
913: IF per_mea_shd.g_old_rec.disability_id <> p_disability_id OR
914: per_mea_shd.g_old_rec.incident_id <> p_incident_id THEN
915: --
916: hr_utility.set_location(l_proc, 30);
917: --

Line 914: per_mea_shd.g_old_rec.incident_id <> p_incident_id THEN

910: -- Only continue if the disability_id or incident_id have
911: -- changed
912: --
913: IF per_mea_shd.g_old_rec.disability_id <> p_disability_id OR
914: per_mea_shd.g_old_rec.incident_id <> p_incident_id THEN
915: --
916: hr_utility.set_location(l_proc, 30);
917: --
918: -- Check to see if the work incident record has been assigned

Line 1262: (p_rec in per_mea_shd.g_rec_type

1258: -- Internal Row Handler Use Only.
1259: --
1260: -- ----------------------------------------------------------------------------
1261: PROCEDURE chk_ddf
1262: (p_rec in per_mea_shd.g_rec_type
1263: ) is
1264: --
1265: l_proc varchar2(72) := g_package || 'chk_ddf';
1266: --

Line 1271: nvl(per_mea_shd.g_old_rec.mea_information_category, hr_api.g_varchar2) <>

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

Line 1273: nvl(per_mea_shd.g_old_rec.mea_information1, hr_api.g_varchar2) <>

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

Line 1275: nvl(per_mea_shd.g_old_rec.mea_information2, hr_api.g_varchar2) <>

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

Line 1277: nvl(per_mea_shd.g_old_rec.mea_information3, hr_api.g_varchar2) <>

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

Line 1279: nvl(per_mea_shd.g_old_rec.mea_information4, hr_api.g_varchar2) <>

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

Line 1281: nvl(per_mea_shd.g_old_rec.mea_information5, hr_api.g_varchar2) <>

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

Line 1283: nvl(per_mea_shd.g_old_rec.mea_information6, hr_api.g_varchar2) <>

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

Line 1285: nvl(per_mea_shd.g_old_rec.mea_information7, hr_api.g_varchar2) <>

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

Line 1287: nvl(per_mea_shd.g_old_rec.mea_information8, hr_api.g_varchar2) <>

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

Line 1289: nvl(per_mea_shd.g_old_rec.mea_information9, hr_api.g_varchar2) <>

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

Line 1291: nvl(per_mea_shd.g_old_rec.mea_information10, hr_api.g_varchar2) <>

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

Line 1293: nvl(per_mea_shd.g_old_rec.mea_information11, hr_api.g_varchar2) <>

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

Line 1295: nvl(per_mea_shd.g_old_rec.mea_information12, hr_api.g_varchar2) <>

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

Line 1297: nvl(per_mea_shd.g_old_rec.mea_information13, hr_api.g_varchar2) <>

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

Line 1299: nvl(per_mea_shd.g_old_rec.mea_information14, hr_api.g_varchar2) <>

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

Line 1301: nvl(per_mea_shd.g_old_rec.mea_information15, hr_api.g_varchar2) <>

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

Line 1303: nvl(per_mea_shd.g_old_rec.mea_information16, hr_api.g_varchar2) <>

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

Line 1305: nvl(per_mea_shd.g_old_rec.mea_information17, hr_api.g_varchar2) <>

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

Line 1307: nvl(per_mea_shd.g_old_rec.mea_information18, hr_api.g_varchar2) <>

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

Line 1309: nvl(per_mea_shd.g_old_rec.mea_information19, hr_api.g_varchar2) <>

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

Line 1311: nvl(per_mea_shd.g_old_rec.mea_information20, hr_api.g_varchar2) <>

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

Line 1313: nvl(per_mea_shd.g_old_rec.mea_information21, hr_api.g_varchar2) <>

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

Line 1315: nvl(per_mea_shd.g_old_rec.mea_information22, hr_api.g_varchar2) <>

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

Line 1317: nvl(per_mea_shd.g_old_rec.mea_information23, hr_api.g_varchar2) <>

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

Line 1319: nvl(per_mea_shd.g_old_rec.mea_information24, hr_api.g_varchar2) <>

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

Line 1321: nvl(per_mea_shd.g_old_rec.mea_information25, hr_api.g_varchar2) <>

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

Line 1323: nvl(per_mea_shd.g_old_rec.mea_information26, hr_api.g_varchar2) <>

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

Line 1325: nvl(per_mea_shd.g_old_rec.mea_information27, hr_api.g_varchar2) <>

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

Line 1327: nvl(per_mea_shd.g_old_rec.mea_information28, hr_api.g_varchar2) <>

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

Line 1329: nvl(per_mea_shd.g_old_rec.mea_information29, 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

Line 1331: nvl(per_mea_shd.g_old_rec.mea_information30, hr_api.g_varchar2) <>

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:

Line 1439: (p_rec in per_mea_shd.g_rec_type

1435: -- Internal Row Handler Use Only.
1436: --
1437: -- ----------------------------------------------------------------------------
1438: PROCEDURE chk_df
1439: (p_rec in per_mea_shd.g_rec_type
1440: ) is
1441: --
1442: l_proc varchar2(72) := g_package || 'chk_df';
1443: --

Line 1448: nvl(per_mea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

Line 1450: nvl(per_mea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

Line 1452: nvl(per_mea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 1454: nvl(per_mea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 1456: nvl(per_mea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 1458: nvl(per_mea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 1460: nvl(per_mea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 1462: nvl(per_mea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 1464: nvl(per_mea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 1466: nvl(per_mea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 1468: nvl(per_mea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 1470: nvl(per_mea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 1472: nvl(per_mea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 1474: nvl(per_mea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 1476: nvl(per_mea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 1478: nvl(per_mea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 1480: nvl(per_mea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 1482: nvl(per_mea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 1484: nvl(per_mea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

Line 1486: nvl(per_mea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

Line 1488: nvl(per_mea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 1490: nvl(per_mea_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

Line 1492: nvl(per_mea_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

Line 1494: nvl(per_mea_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

Line 1496: nvl(per_mea_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

Line 1498: nvl(per_mea_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

Line 1500: nvl(per_mea_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

Line 1502: nvl(per_mea_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

Line 1504: nvl(per_mea_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

Line 1506: nvl(per_mea_shd.g_old_rec.attribute29, 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

Line 1508: nvl(per_mea_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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:

Line 1617: ,p_rec IN per_mea_shd.g_rec_type

1613: -- {End Of Comments}
1614: -- ----------------------------------------------------------------------------
1615: PROCEDURE chk_non_updateable_args
1616: (p_effective_date IN DATE
1617: ,p_rec IN per_mea_shd.g_rec_type
1618: ) IS
1619: --
1620: l_proc VARCHAR2(72) := g_package || 'chk_non_updateable_args';
1621: l_error EXCEPTION;

Line 1629: IF NOT per_mea_shd.api_updating

1625: --
1626: -- Only proceed with the validation if a row exists for the current
1627: -- record in the HR Schema.
1628: --
1629: IF NOT per_mea_shd.api_updating
1630: (p_medical_assessment_id => p_rec.medical_assessment_id
1631: ,p_object_version_number => p_rec.object_version_number) THEN
1632: --
1633: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1641: nvl(per_mea_shd.g_old_rec.person_id,hr_api.g_number) THEN

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

Line 1663: ,p_rec IN per_mea_shd.g_rec_type) IS

1659: -- ----------------------------------------------------------------------------
1660: --
1661: PROCEDURE insert_validate
1662: (p_effective_date IN DATE
1663: ,p_rec IN per_mea_shd.g_rec_type) IS
1664: --
1665: -- Declare cursors
1666: --
1667: CURSOR csr_business_group is

Line 1832: ,p_rec IN per_mea_shd.g_rec_type

1828: -- ----------------------------------------------------------------------------
1829: --
1830: PROCEDURE update_validate
1831: (p_effective_date IN DATE
1832: ,p_rec IN per_mea_shd.g_rec_type
1833: ) IS
1834: --
1835: -- Declare cursors
1836: --

Line 1994: (p_rec IN per_mea_shd.g_rec_type) IS

1990: -- |---------------------------< delete_validate >----------------------------|
1991: -- ----------------------------------------------------------------------------
1992: --
1993: PROCEDURE delete_validate
1994: (p_rec IN per_mea_shd.g_rec_type) IS
1995: --
1996: l_proc VARCHAR2(72) := g_package||'delete_validate';
1997: --
1998: BEGIN