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_AST_BUS dependencies on PER_AST_SHD

Line 26: Procedure chk_non_updateable_args(p_rec in per_ast_shd.g_rec_type) is

22: -- group. Certain other arguments : rating_scale_id, weighting_scale_id and
23: -- assessment_classification can only be updated if they are not being used
24: -- by an assessment.
25: --
26: Procedure chk_non_updateable_args(p_rec in per_ast_shd.g_rec_type) is
27: --
28: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
29: l_error exception;
30: l_argument varchar2(30);

Line 39: if not per_ast_shd.api_updating

35: --
36: -- Only proceed with validation if a row exists for
37: -- the current record in the HR Schema.
38: --
39: if not per_ast_shd.api_updating
40: (p_assessment_type_id => p_rec.assessment_type_id
41: ,p_object_version_number => p_rec.object_version_number
42: ) then
43: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 50: if p_rec.business_group_id <> per_ast_shd.g_old_rec.business_group_id then

46: end if;
47: --
48: hr_utility.set_location (l_proc, 6);
49: --
50: if p_rec.business_group_id <> per_ast_shd.g_old_rec.business_group_id then
51: l_argument := 'business_group_id';
52: raise l_error;
53: end if;
54: --

Line 130: l_api_updating := per_ast_shd.api_updating

126: -- a) The current g_old_rec is current and
127: -- b) The value for name has changed.
128: -- c) The value is being inserted.
129: --
130: l_api_updating := per_ast_shd.api_updating
131: (p_assessment_type_id => p_assessment_type_id
132: ,p_object_version_number => p_object_version_number
133: );
134: --

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 238: l_api_updating := per_ast_shd.api_updating

234: -- a) The current g_old_rec is current
235: -- b) The value has changed.
236: -- c) A record is being inserted
237: --
238: l_api_updating := per_ast_shd.api_updating
239: (p_assessment_type_id => p_assessment_type_id
240: ,p_object_version_number => p_object_version_number
241: );
242: --

Line 243: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.display_assessment_comments,

239: (p_assessment_type_id => p_assessment_type_id
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

Line 331: l_api_updating := per_ast_shd.api_updating

327: -- b) The date_from has changed.
328: -- c) The date_to has changed.
329: -- d) a record is being inserted.
330: --
331: l_api_updating := per_ast_shd.api_updating
332: (p_assessment_type_id => p_assessment_type_id
333: ,p_object_version_number => p_object_version_number
334: );
335: --

Line 336: if (((l_api_updating and nvl(per_ast_shd.g_old_rec.date_from,

332: (p_assessment_type_id => p_assessment_type_id
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,

Line 340: (l_api_updating and nvl(per_ast_shd.g_old_rec.date_to,

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))
343: )
344: or

Line 460: l_api_updating := per_ast_shd.api_updating

456: -- changed check to see whether the assessment_type is being used or not by an
457: -- assessment. If it is, then the assessment_classification cannot be
458: -- updated.
459: --
460: l_api_updating := per_ast_shd.api_updating
461: (p_assessment_type_id => p_assessment_type_id
462: ,p_object_version_number => p_object_version_number
463: );
464: --

Line 467: if (l_api_updating and nvl(per_ast_shd.g_old_rec.assessment_classification,

463: );
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

Line 590: l_api_updating := per_ast_shd.api_updating

586: -- assessment. If it is, then the weighting_scale_id cannot be updated.
587: -- Even if the value hasn't changed for the weighting_scale_id, the validation
588: -- still takes place as compatibility with other columns is checked
589: --
590: l_api_updating := per_ast_shd.api_updating
591: (p_assessment_type_id => p_assessment_type_id
592: ,p_object_version_number => p_object_version_number
593: );
594: --

Line 595: if (l_api_updating and nvl(per_ast_shd.g_old_rec.weighting_scale_id,

591: (p_assessment_type_id => p_assessment_type_id
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

Line 640: per_ast_shd.constraint_error

636: -- Bug#885806
637: -- dbms_output.put_line('and weighting_scale_id doesnt exist in other tab');
638: hr_utility.trace('and weighting_scale_id doesnt exist in other tab');
639: hr_utility.set_location(l_proc,20);
640: per_ast_shd.constraint_error
641: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK3');
642: --
643: --
644: -- Check if the weighting_scale_id is of the wrong type

Line 656: per_ast_shd.constraint_error

652: -- table per_rating_scales can be used again, because as far as the api
653: -- is concerned the value doesn't exist even if it does but is of a
654: -- different type.
655: --
656: per_ast_shd.constraint_error
657: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK3');
658: --
659: end if;
660: --

Line 792: l_api_updating := per_ast_shd.api_updating

788: -- assessment. If it is, then the rating_scale_id cannot be updated.
789: -- Even if the value hasn't changed for the rating_scale_id, the validation
790: -- still takes place as compatibility with other columns is checked
791: --
792: l_api_updating := per_ast_shd.api_updating
793: (p_assessment_type_id => p_assessment_type_id
794: ,p_object_version_number => p_object_version_number
795: );
796: --

Line 797: if (l_api_updating and nvl(per_ast_shd.g_old_rec.rating_scale_id,

793: (p_assessment_type_id => p_assessment_type_id
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

Line 830: per_ast_shd.constraint_error

826: -- Bug#885806
827: -- dbms_output.put_line('chk_rating_scale_id:AssessClass not in Per or Bo');
828: hr_utility.trace('chk_rating_scale_id:AssessClass not in Per or Bo or FF');
829: hr_utility.set_location(l_proc,10);
830: per_ast_shd.constraint_error
831: (p_constraint_name => 'PER_ASS_TYPES_RATE_NOTNULL_CHK');
832: --
833: end if;
834: --

Line 854: per_ast_shd.constraint_error

850: -- Bug#885806
851: -- dbms_output.put_line('chk_rating_scale_id:Rating scale not found');
852: hr_utility.trace('chk_rating_scale_id:Rating scale not found');
853: hr_utility.set_location(l_proc,20);
854: per_ast_shd.constraint_error
855: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK2');
856: --
857: -- Check if the rating_scale_id is of the wrong type.
858: -- ie if the type of the rating_scale in per_rating_scales

Line 876: per_ast_shd.constraint_error

872: -- value entered exists it is of the wrong type therefore it may as well
873: -- not exist.
874: --
875:
876: per_ast_shd.constraint_error
877: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK2');
878:
879: --
880: end if;

Line 893: per_ast_shd.constraint_error

889: if((p_assessment_classification <> 'FASTFORMULA')) then
890: hr_utility.trace('chk_rating_scale_id:Rating scale NULL, type not FastFormula');
891:
892:
893: per_ast_shd.constraint_error
894: (p_constraint_name => 'PER_ASS_TYPES_RATE_NULL_CHK');
895: end if;
896: end if;
897: --

Line 1128: l_api_updating := per_ast_shd.api_updating

1124: -- a) The current g_old_rec is current.
1125: -- b) The total_score_formula has changed.
1126: -- c) A record is being inserted.
1127: --
1128: l_api_updating := per_ast_shd.api_updating
1129: (p_assessment_type_id => p_assessment_type_id
1130: ,p_object_version_number => p_object_version_number
1131: );
1132: --

Line 1133: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.total_score_formula,

1129: (p_assessment_type_id => p_assessment_type_id
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

Line 1207: l_api_updating := per_ast_shd.api_updating

1203: -- a) The current g_old_rec is current.
1204: -- b) The type has changed.
1205: -- c) A record is being inserted.
1206: --
1207: l_api_updating := per_ast_shd.api_updating
1208: (p_assessment_type_id => p_assessment_type_id
1209: ,p_object_version_number => p_object_version_number
1210: );
1211: --

Line 1212: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.type,

1208: (p_assessment_type_id => p_assessment_type_id
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

Line 1359: l_api_updating := per_ast_shd.api_updating

1355: -- b) The value has changed.
1356: -- c) A record is being inserted
1357: --
1358:
1359: l_api_updating := per_ast_shd.api_updating
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,

Line 1363: if ((l_api_updating and nvl(per_ast_shd.g_old_rec.available_flag,

1359: l_api_updating := per_ast_shd.api_updating
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

Line 1416: (p_rec in per_ast_shd.g_rec_type) is

1412: -- Access Status:
1413: -- Internal Row Handler Use Only.
1414: --
1415: procedure chk_df
1416: (p_rec in per_ast_shd.g_rec_type) is
1417: --
1418: l_proc varchar2(72) := g_package||'chk_df';
1419: --
1420: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1529: (p_rec in per_ast_shd.g_rec_type

1525: -- ----------------------------------------------------------------------------
1526: -- |---------------------------< insert_validate >----------------------------|
1527: -- ----------------------------------------------------------------------------
1528: Procedure insert_validate
1529: (p_rec in per_ast_shd.g_rec_type
1530: ,p_effective_date in date) is
1531: --
1532: l_proc varchar2(72) := g_package||'insert_validate';
1533: --

Line 1780: (p_rec in per_ast_shd.g_rec_type

1776: -- ----------------------------------------------------------------------------
1777: -- |---------------------------< update_validate >----------------------------|
1778: -- ----------------------------------------------------------------------------
1779: Procedure update_validate
1780: (p_rec in per_ast_shd.g_rec_type
1781: ,p_effective_date in date
1782: ) is
1783: --
1784: l_proc varchar2(72) := g_package||'update_validate';

Line 2002: Procedure delete_validate(p_rec in per_ast_shd.g_rec_type) is

1998: --
1999: -- ----------------------------------------------------------------------------
2000: -- |---------------------------< delete_validate >----------------------------|
2001: -- ----------------------------------------------------------------------------
2002: Procedure delete_validate(p_rec in per_ast_shd.g_rec_type) is
2003: --
2004: l_proc varchar2(72) := g_package||'delete_validate';
2005: --
2006: Begin