APPS.PER_QUA_BUS dependencies on HR_API

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

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error(p_api_name => l_proc,
48: p_argument => 'qualification_id',
49: p_argument_value => p_qualification_id);
50: --
51: open csr_sec_grp;

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: end if;
71: --

Line 105: hr_api.mandatory_arg_error

101: hr_utility.set_location('Entering:'|| l_proc, 10);
102: --
103: -- Ensure that all the mandatory parameter are not null
104: --
105: hr_api.mandatory_arg_error
106: (p_api_name => l_proc
107: ,p_argument => 'qualification_id'
108: ,p_argument_value => p_qualification_id
109: );

Line 111: if ( nvl(per_qua_bus.g_qualification_id, hr_api.g_number)

107: ,p_argument => 'qualification_id'
108: ,p_argument_value => p_qualification_id
109: );
110: --
111: if ( nvl(per_qua_bus.g_qualification_id, hr_api.g_number)
112: = p_qualification_id) then
113: --
114: -- The legislation code has already been found with a previous
115: -- call to this function. Just return the value in the global

Line 189: and nvl(p_qualification_id,hr_api.g_number)

185: (p_qualification_id => p_qualification_id,
186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating
189: and nvl(p_qualification_id,hr_api.g_number)
190: <> nvl(per_qua_shd.g_old_rec.qualification_id,hr_api.g_number)) then
191: --
192: -- raise error as PK has changed
193: --

Line 190: <> nvl(per_qua_shd.g_old_rec.qualification_id,hr_api.g_number)) then

186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating
189: and nvl(p_qualification_id,hr_api.g_number)
190: <> nvl(per_qua_shd.g_old_rec.qualification_id,hr_api.g_number)) then
191: --
192: -- raise error as PK has changed
193: --
194: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');

Line 262: and nvl(p_qualification_type_id,hr_api.g_number)

258: (p_qualification_id => p_qualification_id,
259: p_object_version_number => p_object_version_number);
260: --
261: if (l_api_updating
262: and nvl(p_qualification_type_id,hr_api.g_number)
263: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
264: or not l_api_updating) then
265: --
266: -- check if qualification type exist in per_qualification_types table

Line 263: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)

259: p_object_version_number => p_object_version_number);
260: --
261: if (l_api_updating
262: and nvl(p_qualification_type_id,hr_api.g_number)
263: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
264: or not l_api_updating) then
265: --
266: -- check if qualification type exist in per_qualification_types table
267: --

Line 338: and nvl(per.effective_end_date,hr_api.g_eot);

334: from per_all_people_f per -- Bug 3148893. Replaced per_all_people_f with per_people_f
335: where per.person_id = p_person_id
336: and p_effective_date
337: between per.effective_start_date
338: and nvl(per.effective_end_date,hr_api.g_eot);
339: --
340: cursor c2 is
341: select null
342: from per_establishment_attendances per

Line 354: and (nvl(p_person_id,hr_api.g_number)

350: (p_qualification_id => p_qualification_id,
351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and (nvl(p_person_id,hr_api.g_number)
355: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
356: or nvl(p_attendance_id,hr_api.g_number)
357: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number))
358: or not l_api_updating) then

Line 355: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and (nvl(p_person_id,hr_api.g_number)
355: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
356: or nvl(p_attendance_id,hr_api.g_number)
357: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number))
358: or not l_api_updating) then
359: --

Line 356: or nvl(p_attendance_id,hr_api.g_number)

352: --
353: if (l_api_updating
354: and (nvl(p_person_id,hr_api.g_number)
355: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
356: or nvl(p_attendance_id,hr_api.g_number)
357: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number))
358: or not l_api_updating) then
359: --
360: -- check if attendance_id or person_id are populated and not both.

Line 357: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number))

353: if (l_api_updating
354: and (nvl(p_person_id,hr_api.g_number)
355: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
356: or nvl(p_attendance_id,hr_api.g_number)
357: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number))
358: or not l_api_updating) then
359: --
360: -- check if attendance_id or person_id are populated and not both.
361: --

Line 424: and nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number

420: --
421: --UPDATE of person id not allowed unless currently null(U)
422: --
423: if (l_api_updating
424: and nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number
425: and per_qua_shd.g_old_rec.person_id <> p_person_id
426: ) then
427: --
428: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');

Line 486: and nvl(per.effective_end_date,hr_api.g_eot);

482: from per_all_people_f per
483: where per.person_id = p_rec.person_id
484: and p_effective_date
485: between per.effective_start_date
486: and nvl(per.effective_end_date,hr_api.g_eot);
487: --
488: cursor csr_valid_party_id is
489: select party_id
490: from hz_parties hzp

Line 633: and nvl(p_status,hr_api.g_varchar2)

629: --
630: if p_status is not null then
631: --
632: if (l_api_updating
633: and nvl(p_status,hr_api.g_varchar2)
634: <> nvl(per_qua_shd.g_old_rec.status,hr_api.g_varchar2)
635: or not l_api_updating) then
636: --
637: -- check if status value exists in PER_SUBJECT_STATUSES lookup.

Line 634: <> nvl(per_qua_shd.g_old_rec.status,hr_api.g_varchar2)

630: if p_status is not null then
631: --
632: if (l_api_updating
633: and nvl(p_status,hr_api.g_varchar2)
634: <> nvl(per_qua_shd.g_old_rec.status,hr_api.g_varchar2)
635: or not l_api_updating) then
636: --
637: -- check if status value exists in PER_SUBJECT_STATUSES lookup.
638: --

Line 639: if hr_api.not_exists_in_hr_lookups

635: or not l_api_updating) then
636: --
637: -- check if status value exists in PER_SUBJECT_STATUSES lookup.
638: --
639: if hr_api.not_exists_in_hr_lookups
640: (p_effective_date => p_effective_date,
641: p_lookup_type => 'PER_SUBJECT_STATUSES',
642: p_lookup_code => p_status) then
643: --

Line 777: and (nvl(p_awarded_date,hr_api.g_date)

773: hr_utility.set_location('Proj Comp Date= '||p_projected_completion_date,80);
774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);
775: --
776: if (l_api_updating
777: and (nvl(p_awarded_date,hr_api.g_date)
778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)

Line 778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)

774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);
775: --
776: if (l_api_updating
777: and (nvl(p_awarded_date,hr_api.g_date)
778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)

Line 779: or nvl(p_start_date,hr_api.g_date)

775: --
776: if (l_api_updating
777: and (nvl(p_awarded_date,hr_api.g_date)
778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)

Line 780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)

776: if (l_api_updating
777: and (nvl(p_awarded_date,hr_api.g_date)
778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)
784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))

Line 781: or nvl(p_projected_completion_date,hr_api.g_date)

777: and (nvl(p_awarded_date,hr_api.g_date)
778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)
784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))
785: or not l_api_updating) then

Line 782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)

778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)
784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))
785: or not l_api_updating) then
786: --

Line 783: or nvl(p_end_date,hr_api.g_date)

779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)
784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))
785: or not l_api_updating) then
786: --
787: -- check if awarded_date is after the start_date and greater than or

Line 784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))

780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)
784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))
785: or not l_api_updating) then
786: --
787: -- check if awarded_date is after the start_date and greater than or
788: -- equal to the projected/actual completion date.

Line 792: hr_utility.set_location('start of time= '||hr_api.g_sot,110);

788: -- equal to the projected/actual completion date.
789: --
790:
791: hr_utility.set_location('enter check for invalid dates',100);
792: hr_utility.set_location('start of time= '||hr_api.g_sot,110);
793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);
794:
795:
796: hr_utility.set_location('Start Date= '||p_start_date,20);

Line 793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);

789: --
790:
791: hr_utility.set_location('enter check for invalid dates',100);
792: hr_utility.set_location('start of time= '||hr_api.g_sot,110);
793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);
794:
795:
796: hr_utility.set_location('Start Date= '||p_start_date,20);
797: hr_utility.set_location('Awarded Date= '||p_awarded_date,20);

Line 908: and (nvl(p_fee,hr_api.g_number)

904: (p_qualification_id => p_qualification_id,
905: p_object_version_number => p_object_version_number);
906: --
907: if (l_api_updating
908: and (nvl(p_fee,hr_api.g_number)
909: <> nvl(per_qua_shd.g_old_rec.fee,hr_api.g_number)
910: or nvl(p_fee_currency,hr_api.g_varchar2)
911: <> nvl(per_qua_shd.g_old_rec.fee_currency,hr_api.g_varchar2))
912: or not l_api_updating) then

Line 909: <> nvl(per_qua_shd.g_old_rec.fee,hr_api.g_number)

905: p_object_version_number => p_object_version_number);
906: --
907: if (l_api_updating
908: and (nvl(p_fee,hr_api.g_number)
909: <> nvl(per_qua_shd.g_old_rec.fee,hr_api.g_number)
910: or nvl(p_fee_currency,hr_api.g_varchar2)
911: <> nvl(per_qua_shd.g_old_rec.fee_currency,hr_api.g_varchar2))
912: or not l_api_updating) then
913: --

Line 910: or nvl(p_fee_currency,hr_api.g_varchar2)

906: --
907: if (l_api_updating
908: and (nvl(p_fee,hr_api.g_number)
909: <> nvl(per_qua_shd.g_old_rec.fee,hr_api.g_number)
910: or nvl(p_fee_currency,hr_api.g_varchar2)
911: <> nvl(per_qua_shd.g_old_rec.fee_currency,hr_api.g_varchar2))
912: or not l_api_updating) then
913: --
914: -- This if statement forces one of the following conditions

Line 911: <> nvl(per_qua_shd.g_old_rec.fee_currency,hr_api.g_varchar2))

907: if (l_api_updating
908: and (nvl(p_fee,hr_api.g_number)
909: <> nvl(per_qua_shd.g_old_rec.fee,hr_api.g_number)
910: or nvl(p_fee_currency,hr_api.g_varchar2)
911: <> nvl(per_qua_shd.g_old_rec.fee_currency,hr_api.g_varchar2))
912: or not l_api_updating) then
913: --
914: -- This if statement forces one of the following conditions
915: -- a) FEE is NOT NULL and FEE CURRENCY is NOT NULL

Line 1028: and nvl(p_start_date,nvl(per.attended_start_date,hr_api.g_sot))

1024: cursor c1 is
1025: select null
1026: from per_establishment_attendances per
1027: where per.attendance_id = p_attendance_id
1028: and nvl(p_start_date,nvl(per.attended_start_date,hr_api.g_sot))
1029: between nvl(per.attended_start_date,hr_api.g_sot)
1030: and nvl(per.attended_end_date,hr_api.g_eot)
1031: and nvl(p_end_date,nvl(per.attended_end_date,hr_api.g_eot))
1032: between nvl(per.attended_start_date,hr_api.g_sot)

Line 1029: between nvl(per.attended_start_date,hr_api.g_sot)

1025: select null
1026: from per_establishment_attendances per
1027: where per.attendance_id = p_attendance_id
1028: and nvl(p_start_date,nvl(per.attended_start_date,hr_api.g_sot))
1029: between nvl(per.attended_start_date,hr_api.g_sot)
1030: and nvl(per.attended_end_date,hr_api.g_eot)
1031: and nvl(p_end_date,nvl(per.attended_end_date,hr_api.g_eot))
1032: between nvl(per.attended_start_date,hr_api.g_sot)
1033: and nvl(per.attended_end_date,hr_api.g_eot);

Line 1030: and nvl(per.attended_end_date,hr_api.g_eot)

1026: from per_establishment_attendances per
1027: where per.attendance_id = p_attendance_id
1028: and nvl(p_start_date,nvl(per.attended_start_date,hr_api.g_sot))
1029: between nvl(per.attended_start_date,hr_api.g_sot)
1030: and nvl(per.attended_end_date,hr_api.g_eot)
1031: and nvl(p_end_date,nvl(per.attended_end_date,hr_api.g_eot))
1032: between nvl(per.attended_start_date,hr_api.g_sot)
1033: and nvl(per.attended_end_date,hr_api.g_eot);
1034: --

Line 1031: and nvl(p_end_date,nvl(per.attended_end_date,hr_api.g_eot))

1027: where per.attendance_id = p_attendance_id
1028: and nvl(p_start_date,nvl(per.attended_start_date,hr_api.g_sot))
1029: between nvl(per.attended_start_date,hr_api.g_sot)
1030: and nvl(per.attended_end_date,hr_api.g_eot)
1031: and nvl(p_end_date,nvl(per.attended_end_date,hr_api.g_eot))
1032: between nvl(per.attended_start_date,hr_api.g_sot)
1033: and nvl(per.attended_end_date,hr_api.g_eot);
1034: --
1035: -- This cursor is used to check that the subjects taken are within the

Line 1032: between nvl(per.attended_start_date,hr_api.g_sot)

1028: and nvl(p_start_date,nvl(per.attended_start_date,hr_api.g_sot))
1029: between nvl(per.attended_start_date,hr_api.g_sot)
1030: and nvl(per.attended_end_date,hr_api.g_eot)
1031: and nvl(p_end_date,nvl(per.attended_end_date,hr_api.g_eot))
1032: between nvl(per.attended_start_date,hr_api.g_sot)
1033: and nvl(per.attended_end_date,hr_api.g_eot);
1034: --
1035: -- This cursor is used to check that the subjects taken are within the
1036: -- dates of the qualification.

Line 1033: and nvl(per.attended_end_date,hr_api.g_eot);

1029: between nvl(per.attended_start_date,hr_api.g_sot)
1030: and nvl(per.attended_end_date,hr_api.g_eot)
1031: and nvl(p_end_date,nvl(per.attended_end_date,hr_api.g_eot))
1032: between nvl(per.attended_start_date,hr_api.g_sot)
1033: and nvl(per.attended_end_date,hr_api.g_eot);
1034: --
1035: -- This cursor is used to check that the subjects taken are within the
1036: -- dates of the qualification.
1037: --

Line 1043: not between nvl(p_start_date,hr_api.g_sot)

1039: select null
1040: from per_subjects_taken per
1041: where per.qualification_id = p_qualification_id
1042: and per.start_date
1043: not between nvl(p_start_date,hr_api.g_sot)
1044: and nvl(p_end_date,hr_api.g_eot);
1045: --
1046: -- Bug: 1664055 Starts here.
1047: --

Line 1044: and nvl(p_end_date,hr_api.g_eot);

1040: from per_subjects_taken per
1041: where per.qualification_id = p_qualification_id
1042: and per.start_date
1043: not between nvl(p_start_date,hr_api.g_sot)
1044: and nvl(p_end_date,hr_api.g_eot);
1045: --
1046: -- Bug: 1664055 Starts here.
1047: --
1048: cursor c3 is

Line 1054: and nvl(per.effective_end_date,hr_api.g_eot)

1050: from per_all_people_f per
1051: where per.person_id = p_person_id
1052: and p_effective_date
1053: between per.effective_start_date
1054: and nvl(per.effective_end_date,hr_api.g_eot)
1055: and date_of_birth is not null;
1056: --
1057: -- Bug: 1664055 Ends here.
1058: --

Line 1094: if nvl(p_start_date,hr_api.g_sot) >

1090: --
1091: -- Check that the end date of the qualification is later than the start
1092: -- date for the qualification.
1093: --
1094: if nvl(p_start_date,hr_api.g_sot) >
1095: nvl(p_end_date,hr_api.g_eot) then
1096: --
1097: -- raise error as the qualification start date is after the qualification
1098: -- end date.

Line 1095: nvl(p_end_date,hr_api.g_eot) then

1091: -- Check that the end date of the qualification is later than the start
1092: -- date for the qualification.
1093: --
1094: if nvl(p_start_date,hr_api.g_sot) >
1095: nvl(p_end_date,hr_api.g_eot) then
1096: --
1097: -- raise error as the qualification start date is after the qualification
1098: -- end date.
1099: --

Line 1231: and nvl(per.end_date,per.start_date) > nvl(p_end_date,hr_api.g_eot);

1227: cursor c1 is
1228: select null
1229: from per_subjects_taken per
1230: where per.qualification_id = p_qualification_id
1231: and nvl(per.end_date,per.start_date) > nvl(p_end_date,hr_api.g_eot);
1232:
1233: Begin
1234: --
1235: hr_utility.set_location('Entering:'||l_proc,5);

Line 1312: and (nvl(p_start_date,hr_api.g_date)

1308: (p_qualification_id => p_qualification_id,
1309: p_object_version_number => p_object_version_number);
1310: --
1311: if (l_api_updating
1312: and (nvl(p_start_date,hr_api.g_date)
1313: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
1314: or nvl(p_projected_completion_date,hr_api.g_date)
1315: <> nvl(per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date))
1316: or not l_api_updating) then

Line 1313: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)

1309: p_object_version_number => p_object_version_number);
1310: --
1311: if (l_api_updating
1312: and (nvl(p_start_date,hr_api.g_date)
1313: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
1314: or nvl(p_projected_completion_date,hr_api.g_date)
1315: <> nvl(per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date))
1316: or not l_api_updating) then
1317: --

Line 1314: or nvl(p_projected_completion_date,hr_api.g_date)

1310: --
1311: if (l_api_updating
1312: and (nvl(p_start_date,hr_api.g_date)
1313: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
1314: or nvl(p_projected_completion_date,hr_api.g_date)
1315: <> nvl(per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date))
1316: or not l_api_updating) then
1317: --
1318: -- Check that if the projected completion date has been entered that it is

Line 1315: <> nvl(per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date))

1311: if (l_api_updating
1312: and (nvl(p_start_date,hr_api.g_date)
1313: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
1314: or nvl(p_projected_completion_date,hr_api.g_date)
1315: <> nvl(per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date))
1316: or not l_api_updating) then
1317: --
1318: -- Check that if the projected completion date has been entered that it is
1319: -- later than the start date.

Line 1398: and (nvl(p_tuition_method,hr_api.g_varchar2)

1394: (p_qualification_id => p_qualification_id,
1395: p_object_version_number => p_object_version_number);
1396: --
1397: if (l_api_updating
1398: and (nvl(p_tuition_method,hr_api.g_varchar2)
1399: <> nvl(per_qua_shd.g_old_rec.tuition_method,hr_api.g_varchar2))
1400: or not l_api_updating) then
1401: --
1402: if p_tuition_method is not null then

Line 1399: <> nvl(per_qua_shd.g_old_rec.tuition_method,hr_api.g_varchar2))

1395: p_object_version_number => p_object_version_number);
1396: --
1397: if (l_api_updating
1398: and (nvl(p_tuition_method,hr_api.g_varchar2)
1399: <> nvl(per_qua_shd.g_old_rec.tuition_method,hr_api.g_varchar2))
1400: or not l_api_updating) then
1401: --
1402: if p_tuition_method is not null then
1403: --

Line 1406: if hr_api.not_exists_in_hr_lookups

1402: if p_tuition_method is not null then
1403: --
1404: -- Check if tuition method exists in lookup PER_TUITION_METHODS
1405: --
1406: if hr_api.not_exists_in_hr_lookups
1407: (p_effective_date => p_effective_date,
1408: p_lookup_type => 'PER_TUITION_METHODS',
1409: p_lookup_code => p_tuition_method) then
1410: --

Line 1492: and (nvl(p_attendance_id,hr_api.g_number)

1488: (p_qualification_id => p_qualification_id,
1489: p_object_version_number => p_object_version_number);
1490: --
1491: if (l_api_updating
1492: and (nvl(p_attendance_id,hr_api.g_number)
1493: <> per_qua_shd.g_old_rec.attendance_id
1494: or nvl(p_business_group_id,hr_api.g_number)
1495: <> per_qua_shd.g_old_rec.business_group_id)
1496: or not l_api_updating) then

Line 1494: or nvl(p_business_group_id,hr_api.g_number)

1490: --
1491: if (l_api_updating
1492: and (nvl(p_attendance_id,hr_api.g_number)
1493: <> per_qua_shd.g_old_rec.attendance_id
1494: or nvl(p_business_group_id,hr_api.g_number)
1495: <> per_qua_shd.g_old_rec.business_group_id)
1496: or not l_api_updating) then
1497: --
1498: if p_attendance_id is not null then

Line 1588: and nvl(per.effective_end_date,hr_api.g_eot);

1584: and per.business_group_id +0 = nvl(p_business_group_id,
1585: per.business_group_id)
1586: and p_effective_date
1587: between per.effective_start_date
1588: and nvl(per.effective_end_date,hr_api.g_eot);
1589: --
1590: Begin
1591: --
1592: hr_utility.set_location('Entering:'||l_proc,5);

Line 1603: and (nvl(p_person_id,hr_api.g_number)

1599: (p_qualification_id => p_qualification_id,
1600: p_object_version_number => p_object_version_number);
1601: --
1602: if (l_api_updating
1603: and (nvl(p_person_id,hr_api.g_number)
1604: <> per_qua_shd.g_old_rec.person_id
1605: or nvl(p_business_group_id,hr_api.g_number)
1606: <> per_qua_shd.g_old_rec.business_group_id)
1607: or not l_api_updating) then

Line 1605: or nvl(p_business_group_id,hr_api.g_number)

1601: --
1602: if (l_api_updating
1603: and (nvl(p_person_id,hr_api.g_number)
1604: <> per_qua_shd.g_old_rec.person_id
1605: or nvl(p_business_group_id,hr_api.g_number)
1606: <> per_qua_shd.g_old_rec.business_group_id)
1607: or not l_api_updating) then
1608: --
1609: if p_person_id is not null then

Line 1639: and nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number

1635: --
1636: --UPDATE of BG_ID not allowed unless currently null(U)
1637: --
1638: if (l_api_updating
1639: and nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number
1640: and per_qua_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1641: --
1642: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1643: hr_utility.raise_error;

Line 1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1845: begin
1846: hr_utility.set_location('Entering:'||l_proc, 10);
1847: --
1848: if ((p_rec.qualification_id is not null) and (
1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1846: hr_utility.set_location('Entering:'||l_proc, 10);
1847: --
1848: if ((p_rec.qualification_id is not null) and (
1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1847: --
1848: if ((p_rec.qualification_id is not null) and (
1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1848: if ((p_rec.qualification_id is not null) and (
1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1891: or

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

1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1891: or
1892: (p_rec.qualification_id is null) then

Line 1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1891: or
1892: (p_rec.qualification_id is null) then
1893: --

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

1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1891: or
1892: (p_rec.qualification_id is null) then
1893: --
1894: -- Only execute the validation if absolutely necessary:

Line 1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>

1981: begin
1982: hr_utility.set_location('Entering:'||l_proc,10);
1983: --
1984: if ((p_rec.qualification_id is not null) and (
1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>

Line 1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or

1982: hr_utility.set_location('Entering:'||l_proc,10);
1983: --
1984: if ((p_rec.qualification_id is not null) and (
1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or

Line 1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>

1983: --
1984: if ((p_rec.qualification_id is not null) and (
1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>

Line 1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or

1984: if ((p_rec.qualification_id is not null) and (
1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or

Line 1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>

1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>

Line 1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or

1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or

Line 1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>

1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>

Line 1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or

1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or

Line 1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>

1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>

Line 1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or

1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or

Line 1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>

1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>

Line 1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or

1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or

Line 1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>

1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>

Line 1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or

1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or

Line 1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>

1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>

Line 2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or

1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or

Line 2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>

1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>

Line 2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or

1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or

Line 2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>

1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>

Line 2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or

2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or

Line 2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>

2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>

Line 2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or

2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or

Line 2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>

2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>

Line 2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or

2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or

Line 2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>

2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>

Line 2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or

2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or

Line 2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>

2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>

Line 2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or

2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or

Line 2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>

2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>

Line 2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or

2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or

Line 2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>

2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>

Line 2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or

2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or

Line 2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>

2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>

Line 2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or

2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or

Line 2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>

2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>

Line 2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or

2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or

Line 2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>

2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>

Line 2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or

2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>
2026: nvl(p_rec.qua_information20, hr_api.g_varchar2) ))

Line 2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>

2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>
2026: nvl(p_rec.qua_information20, hr_api.g_varchar2) ))
2027: or (p_rec.qualification_id is null) then

Line 2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or

2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>
2026: nvl(p_rec.qua_information20, hr_api.g_varchar2) ))
2027: or (p_rec.qualification_id is null) then
2028: --

Line 2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>

2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>
2026: nvl(p_rec.qua_information20, hr_api.g_varchar2) ))
2027: or (p_rec.qualification_id is null) then
2028: --
2029: -- Only execute the validation if absolutely necessary:

Line 2026: nvl(p_rec.qua_information20, hr_api.g_varchar2) ))

2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>
2026: nvl(p_rec.qua_information20, hr_api.g_varchar2) ))
2027: or (p_rec.qualification_id is null) then
2028: --
2029: -- Only execute the validation if absolutely necessary:
2030: -- a) During update, the structure column value or any

Line 2104: hr_api.validate_bus_grp_id

2100: -- HR/TCA merge
2101: -- if party_id is not null, business_group_id is not mandatory parameter
2102: --
2103: if p_rec.party_id is null and p_rec.business_group_id is not null then
2104: hr_api.validate_bus_grp_id
2105: (p_business_group_id => p_rec.business_group_id
2106: ,p_associated_column1 => per_qua_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
2107: ); -- Validate Bus Grp
2108: end if;

Line 2282: hr_api.validate_bus_grp_id

2278: -- CHK_BUSINESS_GROUP_ID
2279: -- if party_id is not null, business_group_id is not mandatory parameter
2280: --
2281: if p_rec.party_id is null and p_rec.business_group_id is not null then
2282: hr_api.validate_bus_grp_id
2283: (p_business_group_id => p_rec.business_group_id
2284: ,p_associated_column1 => per_qua_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
2285: ); -- Validate Bus Grp
2286: end if;