53: (p_deployment_factor_id => p_deployment_factor_id,
54: p_object_version_number => p_object_version_number);
55: --
56: if (l_api_updating
57: and nvl(p_deployment_factor_id,hr_api.g_number)
58: <> per_dpf_shd.g_old_rec.deployment_factor_id) then
59: --
60: -- raise error as PK has changed
61: --
120: from per_people_f per
121: where per.person_id = p_person_id
122: and p_effective_date
123: between per.effective_start_date
124: and nvl(per.effective_end_date,hr_api.g_eot);
125: --
126: Begin
127: --
128: hr_utility.set_location('Entering:'||l_proc, 5);
131: (p_deployment_factor_id => p_deployment_factor_id,
132: p_object_version_number => p_object_version_number);
133: --
134: if (l_api_updating
135: and nvl(p_person_id,hr_api.g_number)
136: <> per_dpf_shd.g_old_rec.person_id) then
137: --
138: -- raise error as person_id has changed
139: --
213: between effective_start_date
214: and effective_end_date
215: and p_effective_date
216: between per.date_effective
217: and nvl(per.date_end,hr_api.g_eot);
218: --
219: Begin
220: --
221: hr_utility.set_location('Entering:'||l_proc, 5);
224: (p_deployment_factor_id => p_deployment_factor_id,
225: p_object_version_number => p_object_version_number);
226: --
227: if (l_api_updating
228: and nvl(p_position_id,hr_api.g_number)
229: <> per_dpf_shd.g_old_rec.position_id) then
230: --
231: -- raise error as position_id has changed
232: --
299: from per_jobs_v per
300: where per.job_id = p_job_id
301: and p_effective_date
302: between per.date_from
303: and nvl(per.date_to,hr_api.g_eot);
304: --
305: Begin
306: --
307: hr_utility.set_location('Entering:'||l_proc, 5);
310: (p_deployment_factor_id => p_deployment_factor_id,
311: p_object_version_number => p_object_version_number);
312: --
313: if (l_api_updating
314: and nvl(p_job_id,hr_api.g_number)
315: <> per_dpf_shd.g_old_rec.job_id) then
316: --
317: -- raise error as job_id has changed
318: --
396: (p_deployment_factor_id => p_deployment_factor_id,
397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating
400: and (nvl(p_work_any_country,hr_api.g_varchar2)
401: <> nvl(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
402: or nvl(p_work_any_location,hr_api.g_varchar2)
403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating
400: and (nvl(p_work_any_country,hr_api.g_varchar2)
401: <> nvl(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
402: or nvl(p_work_any_location,hr_api.g_varchar2)
403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
398: --
399: if (l_api_updating
400: and (nvl(p_work_any_country,hr_api.g_varchar2)
401: <> nvl(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
402: or nvl(p_work_any_location,hr_api.g_varchar2)
403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
406: or nvl(p_relocate_internationally,hr_api.g_varchar2)
399: if (l_api_updating
400: and (nvl(p_work_any_country,hr_api.g_varchar2)
401: <> nvl(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
402: or nvl(p_work_any_location,hr_api.g_varchar2)
403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
406: or nvl(p_relocate_internationally,hr_api.g_varchar2)
407: <> nvl(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
400: and (nvl(p_work_any_country,hr_api.g_varchar2)
401: <> nvl(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
402: or nvl(p_work_any_location,hr_api.g_varchar2)
403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
406: or nvl(p_relocate_internationally,hr_api.g_varchar2)
407: <> nvl(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
408: or nvl(p_travel_required,hr_api.g_varchar2)
401: <> nvl(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
402: or nvl(p_work_any_location,hr_api.g_varchar2)
403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
406: or nvl(p_relocate_internationally,hr_api.g_varchar2)
407: <> nvl(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
408: or nvl(p_travel_required,hr_api.g_varchar2)
409: <> nvl(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2))
402: or nvl(p_work_any_location,hr_api.g_varchar2)
403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
406: or nvl(p_relocate_internationally,hr_api.g_varchar2)
407: <> nvl(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
408: or nvl(p_travel_required,hr_api.g_varchar2)
409: <> nvl(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2))
410: or not l_api_updating) then
403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
406: or nvl(p_relocate_internationally,hr_api.g_varchar2)
407: <> nvl(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
408: or nvl(p_travel_required,hr_api.g_varchar2)
409: <> nvl(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2))
410: or not l_api_updating) then
411: --
404: or nvl(p_relocate_domestically,hr_api.g_varchar2)
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
406: or nvl(p_relocate_internationally,hr_api.g_varchar2)
407: <> nvl(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
408: or nvl(p_travel_required,hr_api.g_varchar2)
409: <> nvl(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2))
410: or not l_api_updating) then
411: --
412: -- check if any lookup that has changed still exists in its lookup type
405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
406: or nvl(p_relocate_internationally,hr_api.g_varchar2)
407: <> nvl(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
408: or nvl(p_travel_required,hr_api.g_varchar2)
409: <> nvl(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2))
410: or not l_api_updating) then
411: --
412: -- check if any lookup that has changed still exists in its lookup type
413: --
414: -- Check if lookup exists in YES_NO lookup type.
415: --
416: -- Work any country lookup.
417: --
418: if hr_api.not_exists_in_hr_lookups
419: (p_lookup_type => 'YES_NO',
420: p_lookup_code => p_work_any_country,
421: p_effective_date => p_effective_date) then
422: --
425: end if;
426: --
427: -- Work any location lookup.
428: --
429: if hr_api.not_exists_in_hr_lookups
430: (p_lookup_type => 'YES_NO',
431: p_lookup_code => p_work_any_location,
432: p_effective_date => p_effective_date) then
433: --
436: end if;
437: --
438: -- Relocate Domestically lookup.
439: --
440: if hr_api.not_exists_in_hr_lookups
441: (p_lookup_type => 'YES_NO',
442: p_lookup_code => p_relocate_domestically,
443: p_effective_date => p_effective_date) then
444: --
447: end if;
448: --
449: -- Relocate Internationally lookup.
450: --
451: if hr_api.not_exists_in_hr_lookups
452: (p_lookup_type => 'YES_NO',
453: p_lookup_code => p_relocate_internationally,
454: p_effective_date => p_effective_date) then
455: --
458: end if;
459: --
460: -- Travel Required lookup.
461: --
462: if hr_api.not_exists_in_hr_lookups
463: (p_lookup_type => 'YES_NO',
464: p_lookup_code => p_travel_required,
465: p_effective_date => p_effective_date) then
466: --
531: (p_deployment_factor_id => p_deployment_factor_id,
532: p_object_version_number => p_object_version_number);
533: --
534: if (l_api_updating
535: and (nvl(p_country1,hr_api.g_varchar2)
536: <> per_dpf_shd.g_old_rec.country1
537: or nvl(p_country2,hr_api.g_varchar2)
538: <> per_dpf_shd.g_old_rec.country2
539: or nvl(p_country3,hr_api.g_varchar2)
533: --
534: if (l_api_updating
535: and (nvl(p_country1,hr_api.g_varchar2)
536: <> per_dpf_shd.g_old_rec.country1
537: or nvl(p_country2,hr_api.g_varchar2)
538: <> per_dpf_shd.g_old_rec.country2
539: or nvl(p_country3,hr_api.g_varchar2)
540: <> per_dpf_shd.g_old_rec.country3
541: or nvl(p_no_country1,hr_api.g_varchar2)
535: and (nvl(p_country1,hr_api.g_varchar2)
536: <> per_dpf_shd.g_old_rec.country1
537: or nvl(p_country2,hr_api.g_varchar2)
538: <> per_dpf_shd.g_old_rec.country2
539: or nvl(p_country3,hr_api.g_varchar2)
540: <> per_dpf_shd.g_old_rec.country3
541: or nvl(p_no_country1,hr_api.g_varchar2)
542: <> per_dpf_shd.g_old_rec.no_country1
543: or nvl(p_no_country2,hr_api.g_varchar2)
537: or nvl(p_country2,hr_api.g_varchar2)
538: <> per_dpf_shd.g_old_rec.country2
539: or nvl(p_country3,hr_api.g_varchar2)
540: <> per_dpf_shd.g_old_rec.country3
541: or nvl(p_no_country1,hr_api.g_varchar2)
542: <> per_dpf_shd.g_old_rec.no_country1
543: or nvl(p_no_country2,hr_api.g_varchar2)
544: <> per_dpf_shd.g_old_rec.no_country2
545: or nvl(p_no_country3,hr_api.g_varchar2)
539: or nvl(p_country3,hr_api.g_varchar2)
540: <> per_dpf_shd.g_old_rec.country3
541: or nvl(p_no_country1,hr_api.g_varchar2)
542: <> per_dpf_shd.g_old_rec.no_country1
543: or nvl(p_no_country2,hr_api.g_varchar2)
544: <> per_dpf_shd.g_old_rec.no_country2
545: or nvl(p_no_country3,hr_api.g_varchar2)
546: <> per_dpf_shd.g_old_rec.no_country3)
547: or not l_api_updating) then
541: or nvl(p_no_country1,hr_api.g_varchar2)
542: <> per_dpf_shd.g_old_rec.no_country1
543: or nvl(p_no_country2,hr_api.g_varchar2)
544: <> per_dpf_shd.g_old_rec.no_country2
545: or nvl(p_no_country3,hr_api.g_varchar2)
546: <> per_dpf_shd.g_old_rec.no_country3)
547: or not l_api_updating) then
548: --
549: -- Check if country code exists in FND_TERRITORIES.
549: -- Check if country code exists in FND_TERRITORIES.
550: --
551: if p_country1 is not null then
552: --
553: if nvl(p_country1,hr_api.g_varchar2) <>
554: per_dpf_shd.g_old_rec.country1 or
555: not l_api_updating then
556: --
557: -- check if country exists
574: end if;
575: --
576: if p_country2 is not null then
577: --
578: if nvl(p_country2,hr_api.g_varchar2) <>
579: per_dpf_shd.g_old_rec.country2 or
580: not l_api_updating then
581: --
582: -- check if country exists
599: end if;
600: --
601: if p_country3 is not null then
602: --
603: if nvl(p_country3,hr_api.g_varchar2) <>
604: per_dpf_shd.g_old_rec.country3 or
605: not l_api_updating then
606: --
607: -- check if country exists
624: end if;
625: --
626: if p_no_country1 is not null then
627: --
628: if nvl(p_no_country1,hr_api.g_varchar2) <>
629: per_dpf_shd.g_old_rec.no_country1 or
630: not l_api_updating then
631: --
632: -- check if country exists
649: end if;
650: --
651: if p_no_country2 is not null then
652: --
653: if nvl(p_no_country2,hr_api.g_varchar2) <>
654: per_dpf_shd.g_old_rec.no_country2 or
655: not l_api_updating then
656: --
657: -- check if country exists
674: end if;
675: --
676: if p_no_country3 is not null then
677: --
678: if nvl(p_no_country3,hr_api.g_varchar2) <>
679: per_dpf_shd.g_old_rec.no_country3 or
680: not l_api_updating then
681: --
682: -- check if country exists
753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating
756: and (p_work_duration
757: <> nvl(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
758: or p_work_schedule
759: <> nvl(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
760: or p_work_hours
761: <> nvl(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
755: if (l_api_updating
756: and (p_work_duration
757: <> nvl(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
758: or p_work_schedule
759: <> nvl(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
760: or p_work_hours
761: <> nvl(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
762: or p_fte_capacity
763: <> nvl(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2))
757: <> nvl(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
758: or p_work_schedule
759: <> nvl(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
760: or p_work_hours
761: <> nvl(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
762: or p_fte_capacity
763: <> nvl(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2))
764: or not l_api_updating) then
765: --
759: <> nvl(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
760: or p_work_hours
761: <> nvl(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
762: or p_fte_capacity
763: <> nvl(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2))
764: or not l_api_updating) then
765: --
766: -- check if any lookup that has changed still exists in its lookup type
767: --
767: --
768: if p_work_duration is not null then
769: --
770: if p_work_duration <>
771: nvl(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2) or
772: not l_api_updating then
773: --
774: -- Check if lookup exists in PER_TIME_SCALES lookup type.
775: --
774: -- Check if lookup exists in PER_TIME_SCALES lookup type.
775: --
776: -- Work Duration lookup.
777: --
778: if hr_api.not_exists_in_hr_lookups
779: (p_lookup_type => 'PER_TIME_SCALES',
780: p_lookup_code => p_work_duration,
781: p_effective_date => p_effective_date) then
782: --
791: --
792: if p_work_schedule is not null then
793: --
794: if p_work_schedule <>
795: nvl(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2) or
796: not l_api_updating then
797: --
798: -- Check if lookup exists in PER_WORK_SCHEDULE lookup type.
799: --
798: -- Check if lookup exists in PER_WORK_SCHEDULE lookup type.
799: --
800: -- Work Schedule lookup.
801: --
802: if hr_api.not_exists_in_hr_lookups
803: (p_lookup_type => 'PER_WORK_SCHEDULE',
804: p_lookup_code => p_work_schedule,
805: p_effective_date => p_effective_date) then
806: --
815: --
816: if p_work_hours is not null then
817: --
818: if p_work_hours <>
819: nvl(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2) or
820: not l_api_updating then
821: --
822: -- Check if lookup exists in PER_WORK_HOURS lookup type.
823: --
822: -- Check if lookup exists in PER_WORK_HOURS lookup type.
823: --
824: -- Work Hours lookup.
825: --
826: if hr_api.not_exists_in_hr_lookups
827: (p_lookup_type => 'PER_WORK_HOURS',
828: p_lookup_code => p_work_hours,
829: p_effective_date => p_effective_date) then
830: --
839: --
840: if p_fte_capacity is not null then
841: --
842: if p_fte_capacity <>
843: nvl(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2) or
844: not l_api_updating then
845: --
846: -- Check if lookup exists in PER_FTE_CAPACITY lookup type.
847: --
846: -- Check if lookup exists in PER_FTE_CAPACITY lookup type.
847: --
848: -- FTE Capacity lookup.
849: --
850: if hr_api.not_exists_in_hr_lookups
851: (p_lookup_type => 'PER_FTE_CAPACITY',
852: p_lookup_code => p_fte_capacity,
853: p_effective_date => p_effective_date) then
854: --
916: (p_deployment_factor_id => p_deployment_factor_id,
917: p_object_version_number => p_object_version_number);
918: --
919: if (l_api_updating
920: and (nvl(p_visit_internationally,hr_api.g_varchar2)
921: <> nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
922: or nvl(p_only_current_location,hr_api.g_varchar2)
923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
924: or nvl(p_available_for_transfer,hr_api.g_varchar2)
917: p_object_version_number => p_object_version_number);
918: --
919: if (l_api_updating
920: and (nvl(p_visit_internationally,hr_api.g_varchar2)
921: <> nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
922: or nvl(p_only_current_location,hr_api.g_varchar2)
923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
924: or nvl(p_available_for_transfer,hr_api.g_varchar2)
925: <> nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
918: --
919: if (l_api_updating
920: and (nvl(p_visit_internationally,hr_api.g_varchar2)
921: <> nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
922: or nvl(p_only_current_location,hr_api.g_varchar2)
923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
924: or nvl(p_available_for_transfer,hr_api.g_varchar2)
925: <> nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
926: or nvl(p_relocation_preference,hr_api.g_varchar2)
919: if (l_api_updating
920: and (nvl(p_visit_internationally,hr_api.g_varchar2)
921: <> nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
922: or nvl(p_only_current_location,hr_api.g_varchar2)
923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
924: or nvl(p_available_for_transfer,hr_api.g_varchar2)
925: <> nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
926: or nvl(p_relocation_preference,hr_api.g_varchar2)
927: <> nvl(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2))
920: and (nvl(p_visit_internationally,hr_api.g_varchar2)
921: <> nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
922: or nvl(p_only_current_location,hr_api.g_varchar2)
923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
924: or nvl(p_available_for_transfer,hr_api.g_varchar2)
925: <> nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
926: or nvl(p_relocation_preference,hr_api.g_varchar2)
927: <> nvl(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2))
928: or not l_api_updating) then
921: <> nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
922: or nvl(p_only_current_location,hr_api.g_varchar2)
923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
924: or nvl(p_available_for_transfer,hr_api.g_varchar2)
925: <> nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
926: or nvl(p_relocation_preference,hr_api.g_varchar2)
927: <> nvl(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2))
928: or not l_api_updating) then
929: --
922: or nvl(p_only_current_location,hr_api.g_varchar2)
923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
924: or nvl(p_available_for_transfer,hr_api.g_varchar2)
925: <> nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
926: or nvl(p_relocation_preference,hr_api.g_varchar2)
927: <> nvl(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2))
928: or not l_api_updating) then
929: --
930: -- check if any lookup that has changed still exists in its lookup type
923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
924: or nvl(p_available_for_transfer,hr_api.g_varchar2)
925: <> nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
926: or nvl(p_relocation_preference,hr_api.g_varchar2)
927: <> nvl(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2))
928: or not l_api_updating) then
929: --
930: -- check if any lookup that has changed still exists in its lookup type
931: --
930: -- check if any lookup that has changed still exists in its lookup type
931: --
932: if p_visit_internationally is not null then
933: --
934: if nvl(p_visit_internationally,hr_api.g_varchar2) <>
935: nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2) or
936: not l_api_updating then
937: --
938: -- Check if lookup exists in YES_NO lookup type.
931: --
932: if p_visit_internationally is not null then
933: --
934: if nvl(p_visit_internationally,hr_api.g_varchar2) <>
935: nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2) or
936: not l_api_updating then
937: --
938: -- Check if lookup exists in YES_NO lookup type.
939: --
938: -- Check if lookup exists in YES_NO lookup type.
939: --
940: -- Visit Internationally lookup.
941: --
942: if hr_api.not_exists_in_hr_lookups
943: (p_lookup_type => 'YES_NO',
944: p_lookup_code => p_visit_internationally,
945: p_effective_date => p_effective_date) then
946: --
953: end if;
954: --
955: if p_only_current_location is not null then
956: --
957: if nvl(p_only_current_location,hr_api.g_varchar2) <>
958: nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2) or
959: not l_api_updating then
960: --
961: -- Check if lookup exists in YES_NO lookup type.
954: --
955: if p_only_current_location is not null then
956: --
957: if nvl(p_only_current_location,hr_api.g_varchar2) <>
958: nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2) or
959: not l_api_updating then
960: --
961: -- Check if lookup exists in YES_NO lookup type.
962: --
961: -- Check if lookup exists in YES_NO lookup type.
962: --
963: -- Only Current Location lookup.
964: --
965: if hr_api.not_exists_in_hr_lookups
966: (p_lookup_type => 'YES_NO',
967: p_lookup_code => p_only_current_location,
968: p_effective_date => p_effective_date) then
969: --
976: end if;
977: --
978: if p_available_for_transfer is not null then
979: --
980: if nvl(p_available_for_transfer,hr_api.g_varchar2) <>
981: nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2) or
982: not l_api_updating then
983: --
984: -- Check if lookup exists in YES_NO lookup type.
977: --
978: if p_available_for_transfer is not null then
979: --
980: if nvl(p_available_for_transfer,hr_api.g_varchar2) <>
981: nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2) or
982: not l_api_updating then
983: --
984: -- Check if lookup exists in YES_NO lookup type.
985: --
984: -- Check if lookup exists in YES_NO lookup type.
985: --
986: -- Available for transfer lookup.
987: --
988: if hr_api.not_exists_in_hr_lookups
989: (p_lookup_type => 'YES_NO',
990: p_lookup_code => p_available_for_transfer,
991: p_effective_date => p_effective_date) then
992: --
999: end if;
1000: --
1001: if p_relocation_preference is not null then
1002: --
1003: if nvl(p_relocation_preference,hr_api.g_varchar2) <>
1004: nvl(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2) or
1005: not l_api_updating then
1006: --
1007: -- Check if lookup exists in PER_RELOCATION_PREFERENCES lookup type.
1000: --
1001: if p_relocation_preference is not null then
1002: --
1003: if nvl(p_relocation_preference,hr_api.g_varchar2) <>
1004: nvl(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2) or
1005: not l_api_updating then
1006: --
1007: -- Check if lookup exists in PER_RELOCATION_PREFERENCES lookup type.
1008: --
1007: -- Check if lookup exists in PER_RELOCATION_PREFERENCES lookup type.
1008: --
1009: -- Relocation Preference lookup.
1010: --
1011: if hr_api.not_exists_in_hr_lookups
1012: (p_lookup_type => 'PER_RELOCATION_PREFERENCES',
1013: p_lookup_code => p_relocation_preference,
1014: p_effective_date => p_effective_date) then
1015: --
1076: (p_deployment_factor_id => p_deployment_factor_id,
1077: p_object_version_number => p_object_version_number);
1078: --
1079: if (l_api_updating
1080: and (nvl(p_relocation_required,hr_api.g_varchar2)
1081: <> nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2)
1082: or nvl(p_passport_required,hr_api.g_varchar2)
1083: <> nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2)
1084: or nvl(p_service_minimum,hr_api.g_varchar2)
1077: p_object_version_number => p_object_version_number);
1078: --
1079: if (l_api_updating
1080: and (nvl(p_relocation_required,hr_api.g_varchar2)
1081: <> nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2)
1082: or nvl(p_passport_required,hr_api.g_varchar2)
1083: <> nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2)
1084: or nvl(p_service_minimum,hr_api.g_varchar2)
1085: <> nvl(per_dpf_shd.g_old_rec.service_minimum,hr_api.g_varchar2))
1078: --
1079: if (l_api_updating
1080: and (nvl(p_relocation_required,hr_api.g_varchar2)
1081: <> nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2)
1082: or nvl(p_passport_required,hr_api.g_varchar2)
1083: <> nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2)
1084: or nvl(p_service_minimum,hr_api.g_varchar2)
1085: <> nvl(per_dpf_shd.g_old_rec.service_minimum,hr_api.g_varchar2))
1086: or not l_api_updating) then
1079: if (l_api_updating
1080: and (nvl(p_relocation_required,hr_api.g_varchar2)
1081: <> nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2)
1082: or nvl(p_passport_required,hr_api.g_varchar2)
1083: <> nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2)
1084: or nvl(p_service_minimum,hr_api.g_varchar2)
1085: <> nvl(per_dpf_shd.g_old_rec.service_minimum,hr_api.g_varchar2))
1086: or not l_api_updating) then
1087: --
1080: and (nvl(p_relocation_required,hr_api.g_varchar2)
1081: <> nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2)
1082: or nvl(p_passport_required,hr_api.g_varchar2)
1083: <> nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2)
1084: or nvl(p_service_minimum,hr_api.g_varchar2)
1085: <> nvl(per_dpf_shd.g_old_rec.service_minimum,hr_api.g_varchar2))
1086: or not l_api_updating) then
1087: --
1088: -- check if any lookup that has changed still exists in its lookup type
1081: <> nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2)
1082: or nvl(p_passport_required,hr_api.g_varchar2)
1083: <> nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2)
1084: or nvl(p_service_minimum,hr_api.g_varchar2)
1085: <> nvl(per_dpf_shd.g_old_rec.service_minimum,hr_api.g_varchar2))
1086: or not l_api_updating) then
1087: --
1088: -- check if any lookup that has changed still exists in its lookup type
1089: --
1088: -- check if any lookup that has changed still exists in its lookup type
1089: --
1090: if p_relocation_required is not null then
1091: --
1092: if nvl(p_relocation_required,hr_api.g_varchar2) <>
1093: nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2) or
1094: not l_api_updating then
1095: --
1096: -- Check if lookup exists in YES_NO lookup type.
1089: --
1090: if p_relocation_required is not null then
1091: --
1092: if nvl(p_relocation_required,hr_api.g_varchar2) <>
1093: nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2) or
1094: not l_api_updating then
1095: --
1096: -- Check if lookup exists in YES_NO lookup type.
1097: --
1096: -- Check if lookup exists in YES_NO lookup type.
1097: --
1098: -- Relocation Required lookup.
1099: --
1100: if hr_api.not_exists_in_hr_lookups
1101: (p_lookup_type => 'YES_NO',
1102: p_lookup_code => p_relocation_required,
1103: p_effective_date => p_effective_date) then
1104: --
1111: end if;
1112: --
1113: if p_passport_required is not null then
1114: --
1115: if nvl(p_passport_required,hr_api.g_varchar2) <>
1116: nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2) or
1117: not l_api_updating then
1118: --
1119: -- Check if lookup exists in YES_NO lookup type.
1112: --
1113: if p_passport_required is not null then
1114: --
1115: if nvl(p_passport_required,hr_api.g_varchar2) <>
1116: nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2) or
1117: not l_api_updating then
1118: --
1119: -- Check if lookup exists in YES_NO lookup type.
1120: --
1119: -- Check if lookup exists in YES_NO lookup type.
1120: --
1121: -- Passport Required lookup.
1122: --
1123: if hr_api.not_exists_in_hr_lookups
1124: (p_lookup_type => 'YES_NO',
1125: p_lookup_code => p_passport_required,
1126: p_effective_date => p_effective_date) then
1127: --
1134: end if;
1135: --
1136: if p_service_minimum is not null then
1137: --
1138: if nvl(p_service_minimum,hr_api.g_varchar2) <>
1139: nvl(per_dpf_shd.g_old_rec.service_minimum,hr_api.g_varchar2) or
1140: not l_api_updating then
1141: --
1142: -- Check if lookup exists in PER_LENGTHS_OF_SERVICE lookup type.
1135: --
1136: if p_service_minimum is not null then
1137: --
1138: if nvl(p_service_minimum,hr_api.g_varchar2) <>
1139: nvl(per_dpf_shd.g_old_rec.service_minimum,hr_api.g_varchar2) or
1140: not l_api_updating then
1141: --
1142: -- Check if lookup exists in PER_LENGTHS_OF_SERVICE lookup type.
1143: --
1142: -- Check if lookup exists in PER_LENGTHS_OF_SERVICE lookup type.
1143: --
1144: -- Service Minimum lookup.
1145: --
1146: if hr_api.not_exists_in_hr_lookups
1147: (p_lookup_type => 'PER_LENGTHS_OF_SERVICE',
1148: p_lookup_code => p_service_minimum,
1149: p_effective_date => p_effective_date) then
1150: --
1214: (p_deployment_factor_id => p_deployment_factor_id,
1215: p_object_version_number => p_object_version_number);
1216: --
1217: if (l_api_updating
1218: and (nvl(p_location1,hr_api.g_varchar2)
1219: <> per_dpf_shd.g_old_rec.location1
1220: or nvl(p_location2,hr_api.g_varchar2)
1221: <> per_dpf_shd.g_old_rec.location2
1222: or nvl(p_location3,hr_api.g_varchar2)
1216: --
1217: if (l_api_updating
1218: and (nvl(p_location1,hr_api.g_varchar2)
1219: <> per_dpf_shd.g_old_rec.location1
1220: or nvl(p_location2,hr_api.g_varchar2)
1221: <> per_dpf_shd.g_old_rec.location2
1222: or nvl(p_location3,hr_api.g_varchar2)
1223: <> per_dpf_shd.g_old_rec.location3)
1224: or not l_api_updating) then
1218: and (nvl(p_location1,hr_api.g_varchar2)
1219: <> per_dpf_shd.g_old_rec.location1
1220: or nvl(p_location2,hr_api.g_varchar2)
1221: <> per_dpf_shd.g_old_rec.location2
1222: or nvl(p_location3,hr_api.g_varchar2)
1223: <> per_dpf_shd.g_old_rec.location3)
1224: or not l_api_updating) then
1225: --
1226: -- check if any location that has changed exists in HR_LOCATIONS table.
1226: -- check if any location that has changed exists in HR_LOCATIONS table.
1227: --
1228: if p_location1 is not null then
1229: --
1230: if nvl(p_location1,hr_api.g_varchar2) <>
1231: per_dpf_shd.g_old_rec.location1 or
1232: not l_api_updating then
1233: --
1234: open c1(p_location1);
1249: end if;
1250: --
1251: if p_location2 is not null then
1252: --
1253: if nvl(p_location2,hr_api.g_varchar2) <>
1254: per_dpf_shd.g_old_rec.location2 or
1255: not l_api_updating then
1256: --
1257: open c1(p_location2);
1272: end if;
1273: --
1274: if p_location3 is not null then
1275: --
1276: if nvl(p_location3,hr_api.g_varchar2) <>
1277: per_dpf_shd.g_old_rec.location3 or
1278: not l_api_updating then
1279: --
1280: open c1(p_location3);
1344: (p_deployment_factor_id => p_deployment_factor_id,
1345: p_object_version_number => p_object_version_number);
1346: --
1347: if (l_api_updating
1348: and (nvl(p_person_id,hr_api.g_number)
1349: <> per_dpf_shd.g_old_rec.person_id
1350: or nvl(p_position_id,hr_api.g_number)
1351: <> per_dpf_shd.g_old_rec.position_id
1352: or nvl(p_job_id,hr_api.g_number)
1346: --
1347: if (l_api_updating
1348: and (nvl(p_person_id,hr_api.g_number)
1349: <> per_dpf_shd.g_old_rec.person_id
1350: or nvl(p_position_id,hr_api.g_number)
1351: <> per_dpf_shd.g_old_rec.position_id
1352: or nvl(p_job_id,hr_api.g_number)
1353: <> per_dpf_shd.g_old_rec.job_id)
1354: or not l_api_updating) then
1348: and (nvl(p_person_id,hr_api.g_number)
1349: <> per_dpf_shd.g_old_rec.person_id
1350: or nvl(p_position_id,hr_api.g_number)
1351: <> per_dpf_shd.g_old_rec.position_id
1352: or nvl(p_job_id,hr_api.g_number)
1353: <> per_dpf_shd.g_old_rec.job_id)
1354: or not l_api_updating) then
1355: --
1356: -- Check if only one of the Job, Position, Person Id's is populated
1438: (p_deployment_factor_id => p_deployment_factor_id,
1439: p_object_version_number => p_object_version_number);
1440: --
1441: if (l_api_updating
1442: and (nvl(p_relocation_required,hr_api.g_varchar2)
1443: <> per_dpf_shd.g_old_rec.relocation_required
1444: or nvl(p_passport_required,hr_api.g_varchar2)
1445: <> per_dpf_shd.g_old_rec.passport_required
1446: or nvl(p_location1,hr_api.g_varchar2)
1440: --
1441: if (l_api_updating
1442: and (nvl(p_relocation_required,hr_api.g_varchar2)
1443: <> per_dpf_shd.g_old_rec.relocation_required
1444: or nvl(p_passport_required,hr_api.g_varchar2)
1445: <> per_dpf_shd.g_old_rec.passport_required
1446: or nvl(p_location1,hr_api.g_varchar2)
1447: <> per_dpf_shd.g_old_rec.location1
1448: or nvl(p_location2,hr_api.g_varchar2)
1442: and (nvl(p_relocation_required,hr_api.g_varchar2)
1443: <> per_dpf_shd.g_old_rec.relocation_required
1444: or nvl(p_passport_required,hr_api.g_varchar2)
1445: <> per_dpf_shd.g_old_rec.passport_required
1446: or nvl(p_location1,hr_api.g_varchar2)
1447: <> per_dpf_shd.g_old_rec.location1
1448: or nvl(p_location2,hr_api.g_varchar2)
1449: <> per_dpf_shd.g_old_rec.location2
1450: or nvl(p_location3,hr_api.g_varchar2)
1444: or nvl(p_passport_required,hr_api.g_varchar2)
1445: <> per_dpf_shd.g_old_rec.passport_required
1446: or nvl(p_location1,hr_api.g_varchar2)
1447: <> per_dpf_shd.g_old_rec.location1
1448: or nvl(p_location2,hr_api.g_varchar2)
1449: <> per_dpf_shd.g_old_rec.location2
1450: or nvl(p_location3,hr_api.g_varchar2)
1451: <> per_dpf_shd.g_old_rec.location3
1452: or nvl(p_other_requirements,hr_api.g_varchar2)
1446: or nvl(p_location1,hr_api.g_varchar2)
1447: <> per_dpf_shd.g_old_rec.location1
1448: or nvl(p_location2,hr_api.g_varchar2)
1449: <> per_dpf_shd.g_old_rec.location2
1450: or nvl(p_location3,hr_api.g_varchar2)
1451: <> per_dpf_shd.g_old_rec.location3
1452: or nvl(p_other_requirements,hr_api.g_varchar2)
1453: <> per_dpf_shd.g_old_rec.other_requirements
1454: or nvl(p_service_minimum,hr_api.g_varchar2)
1448: or nvl(p_location2,hr_api.g_varchar2)
1449: <> per_dpf_shd.g_old_rec.location2
1450: or nvl(p_location3,hr_api.g_varchar2)
1451: <> per_dpf_shd.g_old_rec.location3
1452: or nvl(p_other_requirements,hr_api.g_varchar2)
1453: <> per_dpf_shd.g_old_rec.other_requirements
1454: or nvl(p_service_minimum,hr_api.g_varchar2)
1455: <> per_dpf_shd.g_old_rec.service_minimum)
1456: or not l_api_updating) then
1450: or nvl(p_location3,hr_api.g_varchar2)
1451: <> per_dpf_shd.g_old_rec.location3
1452: or nvl(p_other_requirements,hr_api.g_varchar2)
1453: <> per_dpf_shd.g_old_rec.other_requirements
1454: or nvl(p_service_minimum,hr_api.g_varchar2)
1455: <> per_dpf_shd.g_old_rec.service_minimum)
1456: or not l_api_updating) then
1457: --
1458: -- Check if any of the following attributes are set to not null values
1541: (p_deployment_factor_id => p_deployment_factor_id,
1542: p_object_version_number => p_object_version_number);
1543: --
1544: if (l_api_updating
1545: and (nvl(p_visit_internationally,hr_api.g_varchar2)
1546: <> per_dpf_shd.g_old_rec.visit_internationally
1547: or nvl(p_only_current_location,hr_api.g_varchar2)
1548: <> per_dpf_shd.g_old_rec.only_current_location
1549: or nvl(p_no_country1,hr_api.g_varchar2)
1543: --
1544: if (l_api_updating
1545: and (nvl(p_visit_internationally,hr_api.g_varchar2)
1546: <> per_dpf_shd.g_old_rec.visit_internationally
1547: or nvl(p_only_current_location,hr_api.g_varchar2)
1548: <> per_dpf_shd.g_old_rec.only_current_location
1549: or nvl(p_no_country1,hr_api.g_varchar2)
1550: <> per_dpf_shd.g_old_rec.no_country1
1551: or nvl(p_no_country2,hr_api.g_varchar2)
1545: and (nvl(p_visit_internationally,hr_api.g_varchar2)
1546: <> per_dpf_shd.g_old_rec.visit_internationally
1547: or nvl(p_only_current_location,hr_api.g_varchar2)
1548: <> per_dpf_shd.g_old_rec.only_current_location
1549: or nvl(p_no_country1,hr_api.g_varchar2)
1550: <> per_dpf_shd.g_old_rec.no_country1
1551: or nvl(p_no_country2,hr_api.g_varchar2)
1552: <> per_dpf_shd.g_old_rec.no_country2
1553: or nvl(p_no_country3,hr_api.g_varchar2)
1547: or nvl(p_only_current_location,hr_api.g_varchar2)
1548: <> per_dpf_shd.g_old_rec.only_current_location
1549: or nvl(p_no_country1,hr_api.g_varchar2)
1550: <> per_dpf_shd.g_old_rec.no_country1
1551: or nvl(p_no_country2,hr_api.g_varchar2)
1552: <> per_dpf_shd.g_old_rec.no_country2
1553: or nvl(p_no_country3,hr_api.g_varchar2)
1554: <> per_dpf_shd.g_old_rec.no_country3
1555: or nvl(p_comments,hr_api.g_varchar2)
1549: or nvl(p_no_country1,hr_api.g_varchar2)
1550: <> per_dpf_shd.g_old_rec.no_country1
1551: or nvl(p_no_country2,hr_api.g_varchar2)
1552: <> per_dpf_shd.g_old_rec.no_country2
1553: or nvl(p_no_country3,hr_api.g_varchar2)
1554: <> per_dpf_shd.g_old_rec.no_country3
1555: or nvl(p_comments,hr_api.g_varchar2)
1556: <> per_dpf_shd.g_old_rec.comments
1557: or nvl(p_earliest_available_date,hr_api.g_date)
1551: or nvl(p_no_country2,hr_api.g_varchar2)
1552: <> per_dpf_shd.g_old_rec.no_country2
1553: or nvl(p_no_country3,hr_api.g_varchar2)
1554: <> per_dpf_shd.g_old_rec.no_country3
1555: or nvl(p_comments,hr_api.g_varchar2)
1556: <> per_dpf_shd.g_old_rec.comments
1557: or nvl(p_earliest_available_date,hr_api.g_date)
1558: <> per_dpf_shd.g_old_rec.earliest_available_date
1559: or nvl(p_available_for_transfer,hr_api.g_varchar2)
1553: or nvl(p_no_country3,hr_api.g_varchar2)
1554: <> per_dpf_shd.g_old_rec.no_country3
1555: or nvl(p_comments,hr_api.g_varchar2)
1556: <> per_dpf_shd.g_old_rec.comments
1557: or nvl(p_earliest_available_date,hr_api.g_date)
1558: <> per_dpf_shd.g_old_rec.earliest_available_date
1559: or nvl(p_available_for_transfer,hr_api.g_varchar2)
1560: <> per_dpf_shd.g_old_rec.available_for_transfer
1561: or nvl(p_relocation_preference,hr_api.g_varchar2)
1555: or nvl(p_comments,hr_api.g_varchar2)
1556: <> per_dpf_shd.g_old_rec.comments
1557: or nvl(p_earliest_available_date,hr_api.g_date)
1558: <> per_dpf_shd.g_old_rec.earliest_available_date
1559: or nvl(p_available_for_transfer,hr_api.g_varchar2)
1560: <> per_dpf_shd.g_old_rec.available_for_transfer
1561: or nvl(p_relocation_preference,hr_api.g_varchar2)
1562: <> per_dpf_shd.g_old_rec.relocation_preference)
1563: or not l_api_updating) then
1557: or nvl(p_earliest_available_date,hr_api.g_date)
1558: <> per_dpf_shd.g_old_rec.earliest_available_date
1559: or nvl(p_available_for_transfer,hr_api.g_varchar2)
1560: <> per_dpf_shd.g_old_rec.available_for_transfer
1561: or nvl(p_relocation_preference,hr_api.g_varchar2)
1562: <> per_dpf_shd.g_old_rec.relocation_preference)
1563: or not l_api_updating) then
1564: --
1565: -- Check if any of the following attributes are set to not null values
1645: (p_deployment_factor_id => p_deployment_factor_id,
1646: p_object_version_number => p_object_version_number);
1647: --
1648: if (l_api_updating
1649: and (nvl(p_person_id,hr_api.g_number)
1650: <> per_dpf_shd.g_old_rec.person_id
1651: or nvl(p_position_id,hr_api.g_number)
1652: <> per_dpf_shd.g_old_rec.position_id
1653: or nvl(p_job_id,hr_api.g_number)
1647: --
1648: if (l_api_updating
1649: and (nvl(p_person_id,hr_api.g_number)
1650: <> per_dpf_shd.g_old_rec.person_id
1651: or nvl(p_position_id,hr_api.g_number)
1652: <> per_dpf_shd.g_old_rec.position_id
1653: or nvl(p_job_id,hr_api.g_number)
1654: <> per_dpf_shd.g_old_rec.job_id)
1655: or not l_api_updating) then
1649: and (nvl(p_person_id,hr_api.g_number)
1650: <> per_dpf_shd.g_old_rec.person_id
1651: or nvl(p_position_id,hr_api.g_number)
1652: <> per_dpf_shd.g_old_rec.position_id
1653: or nvl(p_job_id,hr_api.g_number)
1654: <> per_dpf_shd.g_old_rec.job_id)
1655: or not l_api_updating) then
1656: --
1657: -- Check if the record being inserted conflicts with a previously created
1743: (p_deployment_factor_id => p_deployment_factor_id,
1744: p_object_version_number => p_object_version_number);
1745: --
1746: if (l_api_updating
1747: and (nvl(p_person_id,hr_api.g_number)
1748: <> per_dpf_shd.g_old_rec.person_id
1749: or nvl(p_position_id,hr_api.g_number)
1750: <> per_dpf_shd.g_old_rec.position_id
1751: or nvl(p_job_id,hr_api.g_number)
1745: --
1746: if (l_api_updating
1747: and (nvl(p_person_id,hr_api.g_number)
1748: <> per_dpf_shd.g_old_rec.person_id
1749: or nvl(p_position_id,hr_api.g_number)
1750: <> per_dpf_shd.g_old_rec.position_id
1751: or nvl(p_job_id,hr_api.g_number)
1752: <> per_dpf_shd.g_old_rec.job_id)
1753: or not l_api_updating) then
1747: and (nvl(p_person_id,hr_api.g_number)
1748: <> per_dpf_shd.g_old_rec.person_id
1749: or nvl(p_position_id,hr_api.g_number)
1750: <> per_dpf_shd.g_old_rec.position_id
1751: or nvl(p_job_id,hr_api.g_number)
1752: <> per_dpf_shd.g_old_rec.job_id)
1753: or not l_api_updating) then
1754: --
1755: -- Check if the record being inserted conflicts with a previously created
1844: begin
1845: hr_utility.set_location('Entering:'||l_proc, 10);
1846: --
1847: if ((p_rec.deployment_factor_id is not null) and (
1848: nvl(per_dpf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1849: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1850: nvl(per_dpf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1851: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1845: hr_utility.set_location('Entering:'||l_proc, 10);
1846: --
1847: if ((p_rec.deployment_factor_id is not null) and (
1848: nvl(per_dpf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1849: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1850: nvl(per_dpf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1851: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1846: --
1847: if ((p_rec.deployment_factor_id is not null) and (
1848: nvl(per_dpf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1849: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1850: nvl(per_dpf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1851: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1847: if ((p_rec.deployment_factor_id is not null) and (
1848: nvl(per_dpf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1849: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1850: nvl(per_dpf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1851: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1848: nvl(per_dpf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1849: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1850: nvl(per_dpf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1851: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1849: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1850: nvl(per_dpf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1851: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1850: nvl(per_dpf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1851: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1851: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1853: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1855: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1857: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1859: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1861: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1863: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1865: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1867: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1869: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1871: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1873: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1875: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1877: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1886: nvl(per_dpf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1879: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1886: nvl(per_dpf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1887: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1886: nvl(per_dpf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1887: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1888: nvl(per_dpf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1881: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1886: nvl(per_dpf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1887: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1888: nvl(per_dpf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1886: nvl(per_dpf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1887: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1888: nvl(per_dpf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1890: or
1883: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1886: nvl(per_dpf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1887: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1888: nvl(per_dpf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1890: or
1891: (p_rec.deployment_factor_id is null) then
1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1886: nvl(per_dpf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1887: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1888: nvl(per_dpf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1890: or
1891: (p_rec.deployment_factor_id is null) then
1892: --
1885: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1886: nvl(per_dpf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1887: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1888: nvl(per_dpf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1890: or
1891: (p_rec.deployment_factor_id is null) then
1892: --
1893: -- Only execute the validation if absolutely necessary:
1954: --
1955: Begin
1956: hr_utility.set_location('Entering:'||l_proc, 5);
1957: --
1958: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1959: --
1960: -- Call all supporting business operations
1961: --
1962: -- Business Rule Mapping
2148: --
2149: Begin
2150: hr_utility.set_location('Entering:'||l_proc, 5);
2151: --
2152: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2153: --
2154: -- Call all supporting business operations
2155: --
2156: -- Business Rule Mapping
2370: hr_utility.set_location('Entering:'|| l_proc, 10);
2371: --
2372: -- Ensure that all the mandatory parameter are not null
2373: --
2374: hr_api.mandatory_arg_error(p_api_name => l_proc,
2375: p_argument => 'deployment_factor_id',
2376: p_argument_value => p_deployment_factor_id);
2377: --
2378: if nvl(g_deployment_factor_id, hr_api.g_number) = p_deployment_factor_id then
2374: hr_api.mandatory_arg_error(p_api_name => l_proc,
2375: p_argument => 'deployment_factor_id',
2376: p_argument_value => p_deployment_factor_id);
2377: --
2378: if nvl(g_deployment_factor_id, hr_api.g_number) = p_deployment_factor_id then
2379: --
2380: -- The legislation has already been found with a previous
2381: -- call to this function. Just return the value in the global
2382: -- variable.