eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_DPF_BUS dependencies on HR_API

Line 57: and nvl(p_deployment_factor_id,hr_api.g_number)

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: --

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

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

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

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: --

Line 217: and nvl(per.date_end,hr_api.g_eot);

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

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

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: --

Line 303: and nvl(per.date_to,hr_api.g_eot);

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

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

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: --

Line 400: and (nvl(p_work_any_country,hr_api.g_varchar2)

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)

Line 401: <> nvl(per_dpf_shd.g_old_rec.work_any_country,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)

Line 402: or nvl(p_work_any_location,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)

Line 403: <> nvl(per_dpf_shd.g_old_rec.work_any_location,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)

Line 404: or nvl(p_relocate_domestically,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)

Line 405: <> nvl(per_dpf_shd.g_old_rec.relocate_domestically,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))

Line 406: or nvl(p_relocate_internationally,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

Line 407: <> nvl(per_dpf_shd.g_old_rec.relocate_internationally,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
411: --

Line 408: or nvl(p_travel_required,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: --
412: -- check if any lookup that has changed still exists in its lookup type

Line 409: <> nvl(per_dpf_shd.g_old_rec.travel_required,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
413: --

Line 418: if hr_api.not_exists_in_hr_lookups

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: --

Line 429: if hr_api.not_exists_in_hr_lookups

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: --

Line 440: if hr_api.not_exists_in_hr_lookups

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: --

Line 451: if hr_api.not_exists_in_hr_lookups

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: --

Line 462: if hr_api.not_exists_in_hr_lookups

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: --

Line 535: and (nvl(p_country1,hr_api.g_varchar2)

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)

Line 537: or nvl(p_country2,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)

Line 539: or nvl(p_country3,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)

Line 541: or nvl(p_no_country1,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)

Line 543: or nvl(p_no_country2,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

Line 545: or nvl(p_no_country3,hr_api.g_varchar2)

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.

Line 553: if nvl(p_country1,hr_api.g_varchar2) <>

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

Line 578: if nvl(p_country2,hr_api.g_varchar2) <>

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

Line 603: if nvl(p_country3,hr_api.g_varchar2) <>

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

Line 628: if nvl(p_no_country1,hr_api.g_varchar2) <>

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

Line 653: if nvl(p_no_country2,hr_api.g_varchar2) <>

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

Line 678: if nvl(p_no_country3,hr_api.g_varchar2) <>

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

Line 757: <> nvl(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)

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)

Line 759: <> nvl(per_dpf_shd.g_old_rec.work_schedule,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))

Line 761: <> nvl(per_dpf_shd.g_old_rec.work_hours,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: --

Line 763: <> nvl(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2))

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: --

Line 771: nvl(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2) or

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: --

Line 778: if hr_api.not_exists_in_hr_lookups

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: --

Line 795: nvl(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2) or

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: --

Line 802: if hr_api.not_exists_in_hr_lookups

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: --

Line 819: nvl(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2) or

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: --

Line 826: if hr_api.not_exists_in_hr_lookups

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: --

Line 843: nvl(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2) or

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: --

Line 850: if hr_api.not_exists_in_hr_lookups

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: --

Line 920: and (nvl(p_visit_internationally,hr_api.g_varchar2)

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)

Line 921: <> nvl(per_dpf_shd.g_old_rec.visit_internationally,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)

Line 922: or nvl(p_only_current_location,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)

Line 923: <> nvl(per_dpf_shd.g_old_rec.only_current_location,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))

Line 924: or nvl(p_available_for_transfer,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

Line 925: <> nvl(per_dpf_shd.g_old_rec.available_for_transfer,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
929: --

Line 926: or nvl(p_relocation_preference,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: --
930: -- check if any lookup that has changed still exists in its lookup type

Line 927: <> nvl(per_dpf_shd.g_old_rec.relocation_preference,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
931: --

Line 934: if nvl(p_visit_internationally,hr_api.g_varchar2) <>

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.

Line 935: nvl(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2) or

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: --

Line 942: if hr_api.not_exists_in_hr_lookups

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: --

Line 957: if nvl(p_only_current_location,hr_api.g_varchar2) <>

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.

Line 958: nvl(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2) or

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: --

Line 965: if hr_api.not_exists_in_hr_lookups

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: --

Line 980: if nvl(p_available_for_transfer,hr_api.g_varchar2) <>

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.

Line 981: nvl(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2) or

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: --

Line 988: if hr_api.not_exists_in_hr_lookups

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: --

Line 1003: if nvl(p_relocation_preference,hr_api.g_varchar2) <>

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.

Line 1004: nvl(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2) or

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: --

Line 1011: if hr_api.not_exists_in_hr_lookups

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: --

Line 1080: and (nvl(p_relocation_required,hr_api.g_varchar2)

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)

Line 1081: <> nvl(per_dpf_shd.g_old_rec.relocation_required,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))

Line 1082: or nvl(p_passport_required,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

Line 1083: <> nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2)

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: --

Line 1084: or nvl(p_service_minimum,hr_api.g_varchar2)

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

Line 1085: <> nvl(per_dpf_shd.g_old_rec.service_minimum,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
1089: --

Line 1092: if nvl(p_relocation_required,hr_api.g_varchar2) <>

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.

Line 1093: nvl(per_dpf_shd.g_old_rec.relocation_required,hr_api.g_varchar2) or

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: --

Line 1100: if hr_api.not_exists_in_hr_lookups

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: --

Line 1115: if nvl(p_passport_required,hr_api.g_varchar2) <>

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.

Line 1116: nvl(per_dpf_shd.g_old_rec.passport_required,hr_api.g_varchar2) or

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: --

Line 1123: if hr_api.not_exists_in_hr_lookups

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: --

Line 1138: if nvl(p_service_minimum,hr_api.g_varchar2) <>

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.

Line 1139: nvl(per_dpf_shd.g_old_rec.service_minimum,hr_api.g_varchar2) or

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: --

Line 1146: if hr_api.not_exists_in_hr_lookups

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: --

Line 1218: and (nvl(p_location1,hr_api.g_varchar2)

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)

Line 1220: or nvl(p_location2,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

Line 1222: or nvl(p_location3,hr_api.g_varchar2)

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.

Line 1230: if nvl(p_location1,hr_api.g_varchar2) <>

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

Line 1253: if nvl(p_location2,hr_api.g_varchar2) <>

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

Line 1276: if nvl(p_location3,hr_api.g_varchar2) <>

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

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

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)

Line 1350: or nvl(p_position_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

Line 1352: or nvl(p_job_id,hr_api.g_number)

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

Line 1442: and (nvl(p_relocation_required,hr_api.g_varchar2)

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)

Line 1444: or nvl(p_passport_required,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)

Line 1446: or nvl(p_location1,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)

Line 1448: or nvl(p_location2,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)

Line 1450: or nvl(p_location3,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)

Line 1452: or nvl(p_other_requirements,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

Line 1454: or nvl(p_service_minimum,hr_api.g_varchar2)

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

Line 1545: and (nvl(p_visit_internationally,hr_api.g_varchar2)

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)

Line 1547: or nvl(p_only_current_location,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)

Line 1549: or nvl(p_no_country1,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)

Line 1551: or nvl(p_no_country2,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)

Line 1553: or nvl(p_no_country3,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)

Line 1555: or nvl(p_comments,hr_api.g_varchar2)

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)

Line 1557: or nvl(p_earliest_available_date,hr_api.g_date)

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)

Line 1559: or nvl(p_available_for_transfer,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

Line 1561: or nvl(p_relocation_preference,hr_api.g_varchar2)

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

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

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)

Line 1651: or nvl(p_position_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

Line 1653: or nvl(p_job_id,hr_api.g_number)

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

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

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)

Line 1749: or nvl(p_position_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

Line 1751: or nvl(p_job_id,hr_api.g_number)

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

Line 1848: nvl(per_dpf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

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

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

Line 1850: nvl(per_dpf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

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

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

Line 1852: nvl(per_dpf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

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

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

Line 1854: nvl(per_dpf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

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

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

Line 1856: nvl(per_dpf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

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

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

Line 1858: nvl(per_dpf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

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

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

Line 1860: nvl(per_dpf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

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

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

Line 1862: nvl(per_dpf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

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

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

Line 1864: nvl(per_dpf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

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

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

Line 1866: nvl(per_dpf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

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

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

Line 1868: nvl(per_dpf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

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

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

Line 1870: nvl(per_dpf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

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

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

Line 1872: nvl(per_dpf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

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

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

Line 1874: nvl(per_dpf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

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

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

Line 1876: nvl(per_dpf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

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

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

Line 1878: nvl(per_dpf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

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

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

Line 1880: nvl(per_dpf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

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

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

Line 1882: nvl(per_dpf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

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

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

Line 1884: nvl(per_dpf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

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

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)))

Line 1886: nvl(per_dpf_shd.g_old_rec.attribute19, 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

Line 1887: nvl(p_rec.attribute19, hr_api.g_varchar2) 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

Line 1888: nvl(per_dpf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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: --

Line 1889: nvl(p_rec.attribute20, 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: --
1893: -- Only execute the validation if absolutely necessary:

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

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

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

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

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

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

Line 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.