APPS.PER_AST_BUS dependencies on HR_API

Line 60: hr_api.argument_changed_error

56: --
57: --
58: exception
59: when l_error then
60: hr_api.argument_changed_error
61: (p_api_name => l_proc
62: ,p_argument => l_argument);
63: when others then
64: raise;

Line 138: nvl(per_ast_shd.g_old_rec.name, hr_api.g_varchar2)

134: --
135: hr_utility.set_location (l_proc, 2);
136: --
137: if (l_api_updating AND
138: nvl(per_ast_shd.g_old_rec.name, hr_api.g_varchar2)
139: <> nvl(p_name, hr_api.g_varchar2)
140: or not l_api_updating)
141: then
142: --

Line 139: <> nvl(p_name, hr_api.g_varchar2)

135: hr_utility.set_location (l_proc, 2);
136: --
137: if (l_api_updating AND
138: nvl(per_ast_shd.g_old_rec.name, hr_api.g_varchar2)
139: <> nvl(p_name, hr_api.g_varchar2)
140: or not l_api_updating)
141: then
142: --
143: hr_utility.set_location (l_proc, 3);

Line 227: hr_api.mandatory_arg_error

223: hr_utility.set_location('Entering:'|| l_proc, 1);
224: --
225: -- Check mandatory parameters have been set
226: --
227: hr_api.mandatory_arg_error
228: (p_api_name => l_proc
229: ,p_argument => 'effective_date'
230: ,p_argument_value => p_effective_date
231: );

Line 244: hr_api.g_varchar2)

240: ,p_object_version_number => p_object_version_number
241: );
242: --
243: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.display_assessment_comments,
244: hr_api.g_varchar2)
245: <> nvl(p_display_assessment_comments, hr_api.g_varchar2))
246: or
247: (NOT l_api_updating)) then
248: --

Line 245: <> nvl(p_display_assessment_comments, hr_api.g_varchar2))

241: );
242: --
243: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.display_assessment_comments,
244: hr_api.g_varchar2)
245: <> nvl(p_display_assessment_comments, hr_api.g_varchar2))
246: or
247: (NOT l_api_updating)) then
248: --
249: hr_utility.set_location(l_proc, 2);

Line 253: if hr_api.not_exists_in_hr_lookups

249: hr_utility.set_location(l_proc, 2);
250: --
251: -- Check the value in p_display_assessment_comments exists in hr_lookups
252: --
253: if hr_api.not_exists_in_hr_lookups
254: (p_effective_date => p_effective_date
255: ,p_lookup_type => 'YES_NO'
256: ,p_lookup_code => p_display_assessment_comments
257: ) then

Line 337: hr_api.g_date)

333: ,p_object_version_number => p_object_version_number
334: );
335: --
336: if (((l_api_updating and nvl(per_ast_shd.g_old_rec.date_from,
337: hr_api.g_date)
338: <> nvl(p_date_from, hr_api.g_date))
339: or
340: (l_api_updating and nvl(per_ast_shd.g_old_rec.date_to,
341: hr_api.g_date)

Line 338: <> nvl(p_date_from, hr_api.g_date))

334: );
335: --
336: if (((l_api_updating and nvl(per_ast_shd.g_old_rec.date_from,
337: hr_api.g_date)
338: <> nvl(p_date_from, hr_api.g_date))
339: or
340: (l_api_updating and nvl(per_ast_shd.g_old_rec.date_to,
341: hr_api.g_date)
342: <> nvl(p_date_to, hr_api.g_date))

Line 341: hr_api.g_date)

337: hr_api.g_date)
338: <> nvl(p_date_from, hr_api.g_date))
339: or
340: (l_api_updating and nvl(per_ast_shd.g_old_rec.date_to,
341: hr_api.g_date)
342: <> nvl(p_date_to, hr_api.g_date))
343: )
344: or
345: (NOT l_api_updating)) then

Line 342: <> nvl(p_date_to, hr_api.g_date))

338: <> nvl(p_date_from, hr_api.g_date))
339: or
340: (l_api_updating and nvl(per_ast_shd.g_old_rec.date_to,
341: hr_api.g_date)
342: <> nvl(p_date_to, hr_api.g_date))
343: )
344: or
345: (NOT l_api_updating)) then
346: --

Line 445: hr_api.mandatory_arg_error

441: hr_utility.set_location('Entering:'|| l_proc, 1);
442: --
443: -- Check mandatory parameters have been set
444: --
445: hr_api.mandatory_arg_error
446: (p_api_name => l_proc
447: ,p_argument => 'effective_date'
448: ,p_argument_value => p_effective_date
449: );

Line 468: hr_api.g_varchar2)

464: --
465: --
466: --
467: if (l_api_updating and nvl(per_ast_shd.g_old_rec.assessment_classification,
468: hr_api.g_varchar2)
469: <> nvl(p_assessment_classification, hr_api.g_varchar2)) then
470: --
471: -- Assessment Classification is being updated
472: -- Bug#885806

Line 469: <> nvl(p_assessment_classification, hr_api.g_varchar2)) then

465: --
466: --
467: if (l_api_updating and nvl(per_ast_shd.g_old_rec.assessment_classification,
468: hr_api.g_varchar2)
469: <> nvl(p_assessment_classification, hr_api.g_varchar2)) then
470: --
471: -- Assessment Classification is being updated
472: -- Bug#885806
473: -- dbms_output.put_line('The assessment_classification is being updated');

Line 492: if hr_api.not_exists_in_hr_lookups

488: --
489: -- Check that the value in p_assessment_classifications exist in hr_lookups.
490: --
491: if(p_assessment_classification <> 'FASTFORMULA') then
492: if hr_api.not_exists_in_hr_lookups
493: (p_effective_date => p_effective_date
494: ,p_lookup_type => 'ASSESSMENT_CLASSIFICATION'
495: ,p_lookup_code => p_assessment_classification
496: ) then

Line 577: hr_api.mandatory_arg_error

573: hr_utility.set_location('Entering:'||l_proc,1);
574:
575: -- Check that the assessment_classification is not NULL
576: --
577: hr_api.mandatory_arg_error
578: (p_api_name => l_proc
579: ,p_argument => 'assessment_classification'
580: ,p_argument_value => p_assessment_classification
581: );

Line 596: hr_api.g_number)

592: ,p_object_version_number => p_object_version_number
593: );
594: --
595: if (l_api_updating and nvl(per_ast_shd.g_old_rec.weighting_scale_id,
596: hr_api.g_number)
597: <> nvl(p_weighting_scale_id, hr_api.g_number)) then
598: --
599: -- Weighting scale id is being updated, so check if it is being used
600: --

Line 597: <> nvl(p_weighting_scale_id, hr_api.g_number)) then

593: );
594: --
595: if (l_api_updating and nvl(per_ast_shd.g_old_rec.weighting_scale_id,
596: hr_api.g_number)
597: <> nvl(p_weighting_scale_id, hr_api.g_number)) then
598: --
599: -- Weighting scale id is being updated, so check if it is being used
600: --
601: open csr_assessment_type_usage;

Line 780: hr_api.mandatory_arg_error

776:
777: -- Check that assessment_classification is not null.
778: --
779:
780: hr_api.mandatory_arg_error
781: (p_api_name => l_proc
782: ,p_argument => 'assessment_classification'
783: ,p_argument_value => p_assessment_classification
784: );

Line 798: hr_api.g_number)

794: ,p_object_version_number => p_object_version_number
795: );
796: --
797: if (l_api_updating and nvl(per_ast_shd.g_old_rec.rating_scale_id,
798: hr_api.g_number)
799: <> nvl(p_rating_scale_id, hr_api.g_number)) then
800: --
801: -- Rating scale id is being updated, so check if it is being used
802: --

Line 799: <> nvl(p_rating_scale_id, hr_api.g_number)) then

795: );
796: --
797: if (l_api_updating and nvl(per_ast_shd.g_old_rec.rating_scale_id,
798: hr_api.g_number)
799: <> nvl(p_rating_scale_id, hr_api.g_number)) then
800: --
801: -- Rating scale id is being updated, so check if it is being used
802: --
803: open csr_assessment_type_usage;

Line 980: hr_api.mandatory_arg_error

976: hr_utility.set_location('Entering:'||l_proc,5);
977: --
978: -- Check assessment_classification is not null
979: --
980: hr_api.mandatory_arg_error
981: (p_api_name => l_proc
982: ,p_argument => 'assessment_classification'
983: ,p_argument_value => p_assessment_classification
984: );

Line 1062: hr_api.mandatory_arg_error

1058: hr_utility.set_location('Entering:'||l_proc,1);
1059: --
1060: -- Check mandatory parameters have been set
1061: --
1062: hr_api.mandatory_arg_error
1063: (p_api_name => l_proc
1064: ,p_argument => 'effective_date'
1065: ,p_argument_value => p_effective_date
1066: );

Line 1070: if hr_api.not_exists_in_hr_lookups

1066: );
1067: -- Check that value exists in hr_lookups
1068: --
1069: if (p_line_score_formula IS NOT NULL) then
1070: if hr_api.not_exists_in_hr_lookups
1071: (p_effective_date => p_effective_date
1072: ,p_lookup_type => 'ASSESSMENT_LINE_FORMULA'
1073: ,p_lookup_code => p_line_score_formula
1074: ) then

Line 1117: hr_api.mandatory_arg_error

1113: hr_utility.set_location('Entering:'||l_proc,1);
1114: --
1115: -- Check mandatory parameters have been set
1116: --
1117: hr_api.mandatory_arg_error
1118: (p_api_name => l_proc
1119: ,p_argument => 'effective_date'
1120: ,p_argument_value => p_effective_date
1121: );

Line 1134: hr_api.g_varchar2)

1130: ,p_object_version_number => p_object_version_number
1131: );
1132: --
1133: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.total_score_formula,
1134: hr_api.g_varchar2)
1135: <> nvl(p_total_score_formula, hr_api.g_varchar2))
1136: or
1137: (NOT l_api_updating)) then
1138: --

Line 1135: <> nvl(p_total_score_formula, hr_api.g_varchar2))

1131: );
1132: --
1133: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.total_score_formula,
1134: hr_api.g_varchar2)
1135: <> nvl(p_total_score_formula, hr_api.g_varchar2))
1136: or
1137: (NOT l_api_updating)) then
1138: --
1139: -- Check that value exists in hr_lookups

Line 1142: if hr_api.not_exists_in_hr_lookups

1138: --
1139: -- Check that value exists in hr_lookups
1140: --
1141: if (p_total_score_formula IS NOT NULL) then
1142: if hr_api.not_exists_in_hr_lookups
1143: (p_effective_date => p_effective_date
1144: ,p_lookup_type => 'ASSESSMENT_TOTAL_FORMULA'
1145: ,p_lookup_code => p_total_score_formula
1146: ) then

Line 1196: hr_api.mandatory_arg_error

1192: hr_utility.set_location('Entering:'||l_proc,1);
1193: --
1194: -- Check mandatory parameters have been set
1195: --
1196: hr_api.mandatory_arg_error
1197: (p_api_name => l_proc
1198: ,p_argument => 'effective_date'
1199: ,p_argument_value => p_effective_date
1200: );

Line 1213: hr_api.g_varchar2)

1209: ,p_object_version_number => p_object_version_number
1210: );
1211: --
1212: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.type,
1213: hr_api.g_varchar2)
1214: <> nvl(p_type, hr_api.g_varchar2))
1215: or
1216: (NOT l_api_updating)) then
1217: --

Line 1214: <> nvl(p_type, hr_api.g_varchar2))

1210: );
1211: --
1212: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.type,
1213: hr_api.g_varchar2)
1214: <> nvl(p_type, hr_api.g_varchar2))
1215: or
1216: (NOT l_api_updating)) then
1217: --
1218: -- Check that value exists in hr_lookups

Line 1221: if hr_api.not_exists_in_hr_lookups

1217: --
1218: -- Check that value exists in hr_lookups
1219: --
1220: if (p_type IS NOT NULL) then
1221: if hr_api.not_exists_in_hr_lookups
1222: (p_effective_date => p_effective_date
1223: ,p_lookup_type => 'ASSESSMENT_TYPE'
1224: ,p_lookup_code => p_type
1225: ) then

Line 1347: hr_api.mandatory_arg_error

1343:
1344: --
1345: -- Check mandatory parameters have been set
1346: --
1347: hr_api.mandatory_arg_error
1348: (p_api_name => l_proc
1349: ,p_argument => 'effective_date'
1350: ,p_argument_value => p_effective_date
1351: );

Line 1364: hr_api.g_varchar2)

1360: (p_assessment_type_id => p_assessment_type_id
1361: ,p_object_version_number => p_object_version_number);
1362: --
1363: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.available_flag,
1364: hr_api.g_varchar2)
1365: <> nvl(p_available_flag, hr_api.g_varchar2))
1366: or
1367: (NOT l_api_updating)) then
1368: --

Line 1365: <> nvl(p_available_flag, hr_api.g_varchar2))

1361: ,p_object_version_number => p_object_version_number);
1362: --
1363: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.available_flag,
1364: hr_api.g_varchar2)
1365: <> nvl(p_available_flag, hr_api.g_varchar2))
1366: or
1367: (NOT l_api_updating)) then
1368: --
1369: hr_utility.set_location(l_proc, 5);

Line 1373: if hr_api.not_exists_in_hr_lookups

1369: hr_utility.set_location(l_proc, 5);
1370: --
1371: -- Check the value in p_available_flag exists in hr_lookups
1372: --
1373: if hr_api.not_exists_in_hr_lookups
1374: (p_effective_date => p_effective_date
1375: ,p_lookup_type => 'TEMPLATE_AVAILABILITY_FLAG'
1376: ,p_lookup_code => p_available_flag
1377: ) then

Line 1424: nvl(per_ast_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1420: begin
1421: hr_utility.set_location('Entering:'||l_proc, 10);
1422: --
1423: if ((p_rec.assessment_type_id is not null) and (
1424: nvl(per_ast_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1425: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1426: nvl(per_ast_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1427: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1421: hr_utility.set_location('Entering:'||l_proc, 10);
1422: --
1423: if ((p_rec.assessment_type_id is not null) and (
1424: nvl(per_ast_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1425: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1426: nvl(per_ast_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1427: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1426: nvl(per_ast_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1422: --
1423: if ((p_rec.assessment_type_id is not null) and (
1424: nvl(per_ast_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1425: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1426: nvl(per_ast_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1427: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1423: if ((p_rec.assessment_type_id is not null) and (
1424: nvl(per_ast_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1425: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1426: nvl(per_ast_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1427: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1424: nvl(per_ast_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1425: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1426: nvl(per_ast_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1427: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1425: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1426: nvl(per_ast_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1427: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1426: nvl(per_ast_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1427: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1427: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1428: nvl(per_ast_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1429: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1430: nvl(per_ast_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1431: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1432: nvl(per_ast_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1433: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1434: nvl(per_ast_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1435: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1436: nvl(per_ast_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1437: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1438: nvl(per_ast_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1439: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1440: nvl(per_ast_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1441: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1442: nvl(per_ast_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1443: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1444: nvl(per_ast_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1445: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1446: nvl(per_ast_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1447: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1448: nvl(per_ast_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1449: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1450: nvl(per_ast_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1451: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1452: nvl(per_ast_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1453: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1454: nvl(per_ast_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1455: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1456: nvl(per_ast_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1464: nvl(per_ast_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1457: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1464: nvl(per_ast_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1458: nvl(per_ast_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1464: nvl(per_ast_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1466: or

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

1459: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1464: nvl(per_ast_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1466: or
1467: (p_rec.assessment_type_id is null) then

Line 1464: nvl(per_ast_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1460: nvl(per_ast_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1464: nvl(per_ast_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1466: or
1467: (p_rec.assessment_type_id is null) then
1468: --

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

1461: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1462: nvl(per_ast_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1463: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1464: nvl(per_ast_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1465: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1466: or
1467: (p_rec.assessment_type_id is null) then
1468: --
1469: -- Only execute the validation if absolutely necessary:

Line 1551: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1547: hr_utility.trace('AST_bus grp id = '||p_rec.business_group_id);
1548: --
1549: if p_rec.business_group_id is not null then
1550:
1551: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1552: end if;
1553: --
1554: hr_utility.set_location(' Location:'||l_proc, 10);
1555:

Line 1794: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1790: -- Business Rules in perast.bru is provided.
1791: --
1792: --
1793: if p_rec.business_group_id is not null then
1794: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1795: end if;
1796: --
1797: --Validate available_flag
1798: -- rule Chk_Available_flag

Line 2048: hr_api.mandatory_arg_error (p_api_name => l_proc,

2044: hr_utility.set_location('Entering:'||l_proc, 5);
2045: --
2046: -- Ensure that all the mandatory parameters are not null
2047: --
2048: hr_api.mandatory_arg_error (p_api_name => l_proc,
2049: p_argument => 'assessment_type_id',
2050: p_argument_value => p_assessment_type_id );
2051: --
2052: if nvl(g_assessment_type_id, hr_api.g_number) = p_assessment_type_id then

Line 2052: if nvl(g_assessment_type_id, hr_api.g_number) = p_assessment_type_id then

2048: hr_api.mandatory_arg_error (p_api_name => l_proc,
2049: p_argument => 'assessment_type_id',
2050: p_argument_value => p_assessment_type_id );
2051: --
2052: if nvl(g_assessment_type_id, hr_api.g_number) = p_assessment_type_id then
2053: --
2054: -- The legislation code has already been found with a previous
2055: -- call to this function. Just return the value in the global
2056: -- variable.