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_ASN_BUS dependencies on HR_API

Line 65: hr_api.argument_changed_error

61: end if;
62: --
63: exception
64: when l_error then
65: hr_api.argument_changed_error
66: (p_api_name => l_proc
67: ,p_argument => l_argument
68: ,p_base_table => per_asn_shd.g_tab_nam);
69: when others then

Line 151: hr_api.g_number)

147: ,p_object_version_number => p_object_version_number
148: );
149: --
150: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_type_id,
151: hr_api.g_number)
152: <> nvl(p_assessment_type_id, hr_api.g_number))
153: or (not l_api_updating)) then
154: --
155: -- If updating, check whether rows exist in PER_COMPETENCE_ELEMENTS

Line 152: <> nvl(p_assessment_type_id, hr_api.g_number))

148: );
149: --
150: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_type_id,
151: hr_api.g_number)
152: <> nvl(p_assessment_type_id, hr_api.g_number))
153: or (not l_api_updating)) then
154: --
155: -- If updating, check whether rows exist in PER_COMPETENCE_ELEMENTS
156: --

Line 256: hr_api.g_date)

252: );
253:
254: --
255: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_date,
256: hr_api.g_date)
257: <> nvl(p_assessment_date, hr_api.g_date))
258: or (not l_api_updating)) then
259:
260: if (p_assessment_date is NULL) then

Line 257: <> nvl(p_assessment_date, hr_api.g_date))

253:
254: --
255: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_date,
256: hr_api.g_date)
257: <> nvl(p_assessment_date, hr_api.g_date))
258: or (not l_api_updating)) then
259:
260: if (p_assessment_date is NULL) then
261: hr_utility.set_message(801, 'HR_51784_ASN_DATE_NULL');

Line 534: hr_api.g_number)

530: ,p_object_version_number => p_object_version_number
531: );
532:
533: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.group_initiator_id,
534: hr_api.g_number)
535: <> nvl(p_group_initiator_id, hr_api.g_number))
536: or (not l_api_updating)) then
537:
538: If ((p_group_initiator_id is not null And p_group_date is null) Or

Line 535: <> nvl(p_group_initiator_id, hr_api.g_number))

531: );
532:
533: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.group_initiator_id,
534: hr_api.g_number)
535: <> nvl(p_group_initiator_id, hr_api.g_number))
536: or (not l_api_updating)) then
537:
538: If ((p_group_initiator_id is not null And p_group_date is null) Or
539: (p_group_initiator_id is null And p_group_date is not null)) Then

Line 621: hr_api.g_number)

617: --
618: -- Tests are carried out on insert only.
619: --
620: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.group_initiator_id,
621: hr_api.g_number)
622: <> nvl(p_group_initiator_id, hr_api.g_number))
623: or (not l_api_updating)) then
624:
625: IF p_group_initiator_id is not null THEN

Line 622: <> nvl(p_group_initiator_id, hr_api.g_number))

618: -- Tests are carried out on insert only.
619: --
620: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.group_initiator_id,
621: hr_api.g_number)
622: <> nvl(p_group_initiator_id, hr_api.g_number))
623: or (not l_api_updating)) then
624:
625: IF p_group_initiator_id is not null THEN
626: --

Line 719: hr_api.g_varchar2)

715: (p_assessment_id => p_assessment_id
716: ,p_object_version_number => p_object_version_number
717: );
718: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.status,
719: hr_api.g_varchar2)
720: <> nvl(p_status, hr_api.g_varchar2))
721: or (not l_api_updating)) then
722:
723: --

Line 720: <> nvl(p_status, hr_api.g_varchar2))

716: ,p_object_version_number => p_object_version_number
717: );
718: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.status,
719: hr_api.g_varchar2)
720: <> nvl(p_status, hr_api.g_varchar2))
721: or (not l_api_updating)) then
722:
723: --
724: -- Check that the value in p_status exist in hr_lookups

Line 728: if hr_api.not_exists_in_hr_lookups

724: -- Check that the value in p_status exist in hr_lookups
725: --
726: if p_status is not Null Then
727: hr_utility.set_location(l_proc||':Value>'||p_status, 5);
728: if hr_api.not_exists_in_hr_lookups
729: (p_effective_date => p_effective_date
730: ,p_lookup_type => 'APPRAISAL_ASSESSMENT_STATUS'
731: ,p_lookup_code => p_status
732: ) then

Line 798: hr_api.g_date)

794:
795: --
796: if ((l_api_updating
797: and (nvl(per_asn_shd.g_old_rec.assessment_period_start_date,
798: hr_api.g_date)
799: <> nvl(p_assessment_period_start_date, hr_api.g_date)
800: or nvl(per_asn_shd.g_old_rec.assessment_period_end_date,
801: hr_api.g_date)
802: <> nvl(p_assessment_period_end_date, hr_api.g_date)))

Line 799: <> nvl(p_assessment_period_start_date, hr_api.g_date)

795: --
796: if ((l_api_updating
797: and (nvl(per_asn_shd.g_old_rec.assessment_period_start_date,
798: hr_api.g_date)
799: <> nvl(p_assessment_period_start_date, hr_api.g_date)
800: or nvl(per_asn_shd.g_old_rec.assessment_period_end_date,
801: hr_api.g_date)
802: <> nvl(p_assessment_period_end_date, hr_api.g_date)))
803: or (not l_api_updating)) then

Line 801: hr_api.g_date)

797: and (nvl(per_asn_shd.g_old_rec.assessment_period_start_date,
798: hr_api.g_date)
799: <> nvl(p_assessment_period_start_date, hr_api.g_date)
800: or nvl(per_asn_shd.g_old_rec.assessment_period_end_date,
801: hr_api.g_date)
802: <> nvl(p_assessment_period_end_date, hr_api.g_date)))
803: or (not l_api_updating)) then
804:
805: if (p_assessment_period_end_date is not null) then

Line 802: <> nvl(p_assessment_period_end_date, hr_api.g_date)))

798: hr_api.g_date)
799: <> nvl(p_assessment_period_start_date, hr_api.g_date)
800: or nvl(per_asn_shd.g_old_rec.assessment_period_end_date,
801: hr_api.g_date)
802: <> nvl(p_assessment_period_end_date, hr_api.g_date)))
803: or (not l_api_updating)) then
804:
805: if (p_assessment_period_end_date is not null) then
806: --

Line 986: hr_api.g_number)

982: (p_assessment_id => p_assessment_id
983: ,p_object_version_number => p_object_version_number
984: );
985: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_group_id,
986: hr_api.g_number)
987: <> nvl(p_assessment_group_id, hr_api.g_number))
988: or (not l_api_updating)) then
989:
990: --

Line 987: <> nvl(p_assessment_group_id, hr_api.g_number))

983: ,p_object_version_number => p_object_version_number
984: );
985: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_group_id,
986: hr_api.g_number)
987: <> nvl(p_assessment_group_id, hr_api.g_number))
988: or (not l_api_updating)) then
989:
990: --
991: if (p_assessment_group_id is not null) then

Line 1072: hr_api.g_number)

1068: (p_assessment_id => p_assessment_id
1069: ,p_object_version_number => p_object_version_number
1070: );
1071: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.appraisal_id,
1072: hr_api.g_number)
1073: <> nvl(p_appraisal_id, hr_api.g_number))
1074: or (not l_api_updating)) then
1075:
1076: --

Line 1073: <> nvl(p_appraisal_id, hr_api.g_number))

1069: ,p_object_version_number => p_object_version_number
1070: );
1071: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.appraisal_id,
1072: hr_api.g_number)
1073: <> nvl(p_appraisal_id, hr_api.g_number))
1074: or (not l_api_updating)) then
1075:
1076: --
1077: if (p_appraisal_id is NOT NULL) then

Line 1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1196: begin
1197: hr_utility.set_location('Entering:'||l_proc, 10);
1198: --
1199: if ((p_rec.assessment_id is not null) and (
1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1197: hr_utility.set_location('Entering:'||l_proc, 10);
1198: --
1199: if ((p_rec.assessment_id is not null) and (
1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1198: --
1199: if ((p_rec.assessment_id is not null) and (
1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1199: if ((p_rec.assessment_id is not null) and (
1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1242: or

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

1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1242: or
1243: (p_rec.assessment_id is null) then

Line 1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1242: or
1243: (p_rec.assessment_id is null) then
1244: --

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

1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1242: or
1243: (p_rec.assessment_id is null) then
1244: --
1245: -- Only execute the validation if absolutely necessary:

Line 1321: hr_api.validate_bus_grp_id(p_rec.business_group_id

1317: -- Business Rule Mapping
1318: -- =====================
1319: -- Rule CHK_BUSINESS_GROUP_ID a
1320: --
1321: hr_api.validate_bus_grp_id(p_rec.business_group_id
1322: ,p_associated_column1 => per_asn_shd.g_tab_nam ||
1323: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1324:
1325:

Line 1482: hr_api.validate_bus_grp_id(p_rec.business_group_id

1478: -- Call all supporting business operations. Mapping to the appropiate
1479: -- business rules provided.
1480: --
1481: --
1482: hr_api.validate_bus_grp_id(p_rec.business_group_id
1483: ,p_associated_column1 => per_asn_shd.g_tab_nam ||
1484: '.BUSINESS_GROUP_ID'); -- Validate Business Group
1485: hr_multi_message.end_validation_set;
1486: --

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

1621: hr_utility.set_location('Entering:'||l_proc, 5);
1622: --
1623: -- Ensure that all the mandatory parameters are not null
1624: --
1625: hr_api.mandatory_arg_error (p_api_name => l_proc,
1626: p_argument => 'assessment_id',
1627: p_argument_value => p_assessment_id );
1628:
1629: if nvl(g_assessment_id, hr_api.g_number) = p_assessment_id then

Line 1629: if nvl(g_assessment_id, hr_api.g_number) = p_assessment_id then

1625: hr_api.mandatory_arg_error (p_api_name => l_proc,
1626: p_argument => 'assessment_id',
1627: p_argument_value => p_assessment_id );
1628:
1629: if nvl(g_assessment_id, hr_api.g_number) = p_assessment_id then
1630: --
1631: -- The legislation code has already been found with a previous
1632: -- call to this function. Just return the value in the global
1633: -- variable.