APPS.PER_SUC_BUS dependencies on HR_API

Line 51: and nvl(p_succession_plan_id,hr_api.g_number)

47: (p_succession_plan_id => p_succession_plan_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_succession_plan_id,hr_api.g_number)
52: <> per_suc_shd.g_old_rec.succession_plan_id) then
53: --
54: -- raise error as PK has changed
55: --

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

127: (p_succession_plan_id => p_succession_plan_id,
128: p_object_version_number => p_object_version_number);
129: --
130: if (l_api_updating
131: and nvl(p_person_id,hr_api.g_number)
132: <> nvl(per_suc_shd.g_old_rec.person_id,hr_api.g_number)
133: or not l_api_updating) then
134: --
135: -- check if person_id is null

Line 132: <> nvl(per_suc_shd.g_old_rec.person_id,hr_api.g_number)

128: p_object_version_number => p_object_version_number);
129: --
130: if (l_api_updating
131: and nvl(p_person_id,hr_api.g_number)
132: <> nvl(per_suc_shd.g_old_rec.person_id,hr_api.g_number)
133: or not l_api_updating) then
134: --
135: -- check if person_id is null
136: --

Line 225: and nvl(hr_general.get_position_date_end(per.position_id),hr_api.g_eot);

221: between per.effective_start_date
222: and per.effective_end_date
223: and p_effective_date
224: between per.date_effective
225: and nvl(hr_general.get_position_date_end(per.position_id),hr_api.g_eot);
226: --
227: Begin
228: --
229: hr_utility.set_location('Entering:'||l_proc, 5);

Line 236: and nvl(p_position_id,hr_api.g_number)

232: (p_succession_plan_id => p_succession_plan_id,
233: p_object_version_number => p_object_version_number);
234: --
235: if (l_api_updating
236: and nvl(p_position_id,hr_api.g_number)
237: <> nvl(per_suc_shd.g_old_rec.position_id,hr_api.g_number)
238: or not l_api_updating) then
239: --
240: -- check if position_id is null

Line 237: <> nvl(per_suc_shd.g_old_rec.position_id,hr_api.g_number)

233: p_object_version_number => p_object_version_number);
234: --
235: if (l_api_updating
236: and nvl(p_position_id,hr_api.g_number)
237: <> nvl(per_suc_shd.g_old_rec.position_id,hr_api.g_number)
238: or not l_api_updating) then
239: --
240: -- check if position_id is null
241: --

Line 337: and nvl(p_job_id,hr_api.g_number)

333: (p_succession_plan_id => p_succession_plan_id,
334: p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating
337: and nvl(p_job_id,hr_api.g_number)
338: <> nvl(per_suc_shd.g_old_rec.job_id,hr_api.g_number)
339: or not l_api_updating) then
340: --
341: -- check if job_id is null

Line 338: <> nvl(per_suc_shd.g_old_rec.job_id,hr_api.g_number)

334: p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating
337: and nvl(p_job_id,hr_api.g_number)
338: <> nvl(per_suc_shd.g_old_rec.job_id,hr_api.g_number)
339: or not l_api_updating) then
340: --
341: -- check if job_id is null
342: --

Line 437: and nvl(p_successee_person_id,hr_api.g_number)

433: (p_succession_plan_id => p_succession_plan_id,
434: p_object_version_number => p_object_version_number);
435: --
436: if (l_api_updating
437: and nvl(p_successee_person_id,hr_api.g_number)
438: <> nvl(per_suc_shd.g_old_rec.successee_person_id,hr_api.g_number) )
439: then
440: --
441: -- raise error as the person can not be updated.

Line 438: <> nvl(per_suc_shd.g_old_rec.successee_person_id,hr_api.g_number) )

434: p_object_version_number => p_object_version_number);
435: --
436: if (l_api_updating
437: and nvl(p_successee_person_id,hr_api.g_number)
438: <> nvl(per_suc_shd.g_old_rec.successee_person_id,hr_api.g_number) )
439: then
440: --
441: -- raise error as the person can not be updated.
442: --

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

544: (p_succession_plan_id => p_succession_plan_id,
545: p_object_version_number => p_object_version_number);
546: --
547: if (l_api_updating
548: and nvl(p_person_id,hr_api.g_number)
549: <> nvl(per_suc_shd.g_old_rec.person_id,hr_api.g_number)
550: or not l_api_updating) then
551: --
552:

Line 549: <> nvl(per_suc_shd.g_old_rec.person_id,hr_api.g_number)

545: p_object_version_number => p_object_version_number);
546: --
547: if (l_api_updating
548: and nvl(p_person_id,hr_api.g_number)
549: <> nvl(per_suc_shd.g_old_rec.person_id,hr_api.g_number)
550: or not l_api_updating) then
551: --
552:
553: --

Line 634: and nvl(p_time_scale,hr_api.g_varchar2)

630: (p_succession_plan_id => p_succession_plan_id,
631: p_object_version_number => p_object_version_number);
632: --
633: if (l_api_updating
634: and nvl(p_time_scale,hr_api.g_varchar2)
635: <> nvl(per_suc_shd.g_old_rec.time_scale,hr_api.g_varchar2)
636: or not l_api_updating) then
637: --
638: -- check if value of time scale lookup falls within lookup.

Line 635: <> nvl(per_suc_shd.g_old_rec.time_scale,hr_api.g_varchar2)

631: p_object_version_number => p_object_version_number);
632: --
633: if (l_api_updating
634: and nvl(p_time_scale,hr_api.g_varchar2)
635: <> nvl(per_suc_shd.g_old_rec.time_scale,hr_api.g_varchar2)
636: or not l_api_updating) then
637: --
638: -- check if value of time scale lookup falls within lookup.
639: --

Line 640: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'PER_TIME_SCALES',

636: or not l_api_updating) then
637: --
638: -- check if value of time scale lookup falls within lookup.
639: --
640: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'PER_TIME_SCALES',
641: p_lookup_code => p_time_scale,
642: p_effective_date => p_effective_date) then
643: --
644: -- raise error as does not exist as lookup

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

691: (p_succession_plan_id => p_succession_plan_id,
692: p_object_version_number => p_object_version_number);
693: --
694: if (l_api_updating
695: and nvl(p_start_date,hr_api.g_date)
696: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
697: or not l_api_updating) then
698: --
699: -- check if start date is null

Line 696: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)

692: p_object_version_number => p_object_version_number);
693: --
694: if (l_api_updating
695: and nvl(p_start_date,hr_api.g_date)
696: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
697: or not l_api_updating) then
698: --
699: -- check if start date is null
700: --

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

753: (p_succession_plan_id => p_succession_plan_id,
754: p_object_version_number => p_object_version_number);
755: --
756: if (l_api_updating
757: and (nvl(p_start_date,hr_api.g_date)
758: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
759: or nvl(p_end_date,hr_api.g_date)
760: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))
761: or not l_api_updating) then

Line 758: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)

754: p_object_version_number => p_object_version_number);
755: --
756: if (l_api_updating
757: and (nvl(p_start_date,hr_api.g_date)
758: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
759: or nvl(p_end_date,hr_api.g_date)
760: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))
761: or not l_api_updating) then
762: --

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

755: --
756: if (l_api_updating
757: and (nvl(p_start_date,hr_api.g_date)
758: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
759: or nvl(p_end_date,hr_api.g_date)
760: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))
761: or not l_api_updating) then
762: --
763: -- check if end date is greater than start date

Line 760: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))

756: if (l_api_updating
757: and (nvl(p_start_date,hr_api.g_date)
758: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
759: or nvl(p_end_date,hr_api.g_date)
760: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))
761: or not l_api_updating) then
762: --
763: -- check if end date is greater than start date
764: --

Line 765: if p_start_date > nvl(p_end_date,hr_api.g_eot) then

761: or not l_api_updating) then
762: --
763: -- check if end date is greater than start date
764: --
765: if p_start_date > nvl(p_end_date,hr_api.g_eot) then
766: --
767: -- raise error as start date should be less than or equal to end date.
768: --
769: hr_utility.set_message(801,'HR_52003_SUC_CHK_END_DATE');

Line 823: and nvl(p_available_for_promotion,hr_api.g_varchar2)

819: (p_succession_plan_id => p_succession_plan_id,
820: p_object_version_number => p_object_version_number);
821: --
822: if (l_api_updating
823: and nvl(p_available_for_promotion,hr_api.g_varchar2)
824: <> per_suc_shd.g_old_rec.available_for_promotion
825: or not l_api_updating) then
826: --
827: -- check if value of available for promotion scale lookup falls within

Line 832: if hr_api.not_exists_in_hr_lookups

828: -- lookup.
829: --
830: if p_available_for_promotion is not null then
831: --
832: if hr_api.not_exists_in_hr_lookups
833: (p_lookup_type => 'YES_NO',
834: p_lookup_code => p_available_for_promotion,
835: p_effective_date => p_effective_date) then
836: --

Line 964: and nvl(p_end_date,hr_api.g_eot)

960: (p_successee_person_id is not null and per.successee_person_id = p_successee_person_id)
961: )
962: and (per.start_date
963: between p_start_date
964: and nvl(p_end_date,hr_api.g_eot)
965: or nvl(per.end_date,hr_api.g_eot)
966: between p_start_date
967: and nvl(p_end_date,hr_api.g_eot));
968: --

Line 965: or nvl(per.end_date,hr_api.g_eot)

961: )
962: and (per.start_date
963: between p_start_date
964: and nvl(p_end_date,hr_api.g_eot)
965: or nvl(per.end_date,hr_api.g_eot)
966: between p_start_date
967: and nvl(p_end_date,hr_api.g_eot));
968: --
969: Begin

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

963: between p_start_date
964: and nvl(p_end_date,hr_api.g_eot)
965: or nvl(per.end_date,hr_api.g_eot)
966: between p_start_date
967: and nvl(p_end_date,hr_api.g_eot));
968: --
969: Begin
970: --
971: hr_utility.set_location('Entering:'||l_proc, 5);

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

974: (p_succession_plan_id => p_succession_plan_id,
975: p_object_version_number => p_object_version_number);
976: --
977: if (l_api_updating
978: and (nvl(p_start_date,hr_api.g_date)
979: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
980: or nvl(p_end_date,hr_api.g_date)
981: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))
982: or not l_api_updating) then

Line 979: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)

975: p_object_version_number => p_object_version_number);
976: --
977: if (l_api_updating
978: and (nvl(p_start_date,hr_api.g_date)
979: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
980: or nvl(p_end_date,hr_api.g_date)
981: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))
982: or not l_api_updating) then
983: --

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

976: --
977: if (l_api_updating
978: and (nvl(p_start_date,hr_api.g_date)
979: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
980: or nvl(p_end_date,hr_api.g_date)
981: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))
982: or not l_api_updating) then
983: --
984: -- check if succession plans overlap

Line 981: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))

977: if (l_api_updating
978: and (nvl(p_start_date,hr_api.g_date)
979: <> nvl(per_suc_shd.g_old_rec.start_date,hr_api.g_date)
980: or nvl(p_end_date,hr_api.g_date)
981: <> nvl(per_suc_shd.g_old_rec.end_date,hr_api.g_date))
982: or not l_api_updating) then
983: --
984: -- check if succession plans overlap
985: --

Line 1047: nvl(per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1043: begin
1044: hr_utility.set_location('Entering:'||l_proc, 10);
1045: --
1046: if ((p_rec.succession_plan_id is not null) and (
1047: nvl(per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1049: nvl(per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1044: hr_utility.set_location('Entering:'||l_proc, 10);
1045: --
1046: if ((p_rec.succession_plan_id is not null) and (
1047: nvl(per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1049: nvl(per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1049: nvl(per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1045: --
1046: if ((p_rec.succession_plan_id is not null) and (
1047: nvl(per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1049: nvl(per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1046: if ((p_rec.succession_plan_id is not null) and (
1047: nvl(per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1049: nvl(per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1047: nvl(per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1049: nvl(per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1048: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1049: nvl(per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1049: nvl(per_suc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1050: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1051: nvl(per_suc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1052: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1053: nvl(per_suc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1054: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1055: nvl(per_suc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1056: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1057: nvl(per_suc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1058: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1059: nvl(per_suc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1060: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1061: nvl(per_suc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1062: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1063: nvl(per_suc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1064: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1065: nvl(per_suc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1066: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1067: nvl(per_suc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1068: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1069: nvl(per_suc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1070: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1071: nvl(per_suc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1072: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1073: nvl(per_suc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1074: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1075: nvl(per_suc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1076: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1077: nvl(per_suc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1078: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1086: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1079: nvl(per_suc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1086: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1087: nvl(per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1080: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1086: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1087: nvl(per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1088: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1081: nvl(per_suc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1086: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1087: nvl(per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1088: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1089: or

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

1082: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1086: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1087: nvl(per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1088: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1089: or
1090: (p_rec.succession_plan_id is null) then

Line 1087: nvl(per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1083: nvl(per_suc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1086: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1087: nvl(per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1088: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1089: or
1090: (p_rec.succession_plan_id is null) then
1091: --

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

1084: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1085: nvl(per_suc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1086: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1087: nvl(per_suc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1088: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1089: or
1090: (p_rec.succession_plan_id is null) then
1091: --
1092: -- Only execute the validation if absolutely necessary:

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

1153: --
1154: Begin
1155: hr_utility.set_location('Entering:'||l_proc, 5);
1156: --
1157: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1158: --
1159: -- Call all supporting business operations
1160: --
1161: -- Business Rule Mapping

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

1270: --
1271: Begin
1272: hr_utility.set_location('Entering:'||l_proc, 5);
1273: --
1274: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1275: --
1276: -- Call all supporting business operations
1277: --
1278: -- Business Rule Mapping