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 PER_DPF_SHD

Line 52: l_api_updating := per_dpf_shd.api_updating

48: Begin
49: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: l_api_updating := per_dpf_shd.api_updating
53: (p_deployment_factor_id => p_deployment_factor_id,
54: p_object_version_number => p_object_version_number);
55: --
56: if (l_api_updating

Line 58: <> per_dpf_shd.g_old_rec.deployment_factor_id) then

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: --
62: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_PK');

Line 62: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_PK');

58: <> per_dpf_shd.g_old_rec.deployment_factor_id) then
59: --
60: -- raise error as PK has changed
61: --
62: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_PK');
63: --
64: elsif not l_api_updating then
65: --
66: -- check if PK is null

Line 130: l_api_updating := per_dpf_shd.api_updating

126: Begin
127: --
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: l_api_updating := per_dpf_shd.api_updating
131: (p_deployment_factor_id => p_deployment_factor_id,
132: p_object_version_number => p_object_version_number);
133: --
134: if (l_api_updating

Line 136: <> per_dpf_shd.g_old_rec.person_id) then

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: --
140: hr_utility.set_message(801,'HR_52022_DPF_CHK_PERSON_UPD');

Line 223: l_api_updating := per_dpf_shd.api_updating

219: Begin
220: --
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: l_api_updating := per_dpf_shd.api_updating
224: (p_deployment_factor_id => p_deployment_factor_id,
225: p_object_version_number => p_object_version_number);
226: --
227: if (l_api_updating

Line 229: <> per_dpf_shd.g_old_rec.position_id) then

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: --
233: hr_utility.set_message(801,'HR_52023_DPF_CHK_POSITION_UPD');

Line 248: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_FK2');

244: fetch c1 into l_dummy;
245: if c1%notfound then
246: --
247: close c1;
248: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_FK2');
249: --
250: end if;
251: --
252: close c1;

Line 309: l_api_updating := per_dpf_shd.api_updating

305: Begin
306: --
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: l_api_updating := per_dpf_shd.api_updating
310: (p_deployment_factor_id => p_deployment_factor_id,
311: p_object_version_number => p_object_version_number);
312: --
313: if (l_api_updating

Line 315: <> per_dpf_shd.g_old_rec.job_id) then

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: --
319: hr_utility.set_message(801,'HR_52025_DPF_CHK_JOB_UPD');

Line 334: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_FK1');

330: fetch c1 into l_dummy;
331: if c1%notfound then
332: --
333: close c1;
334: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_FK1');
335: --
336: end if;
337: --
338: close c1;

Line 395: l_api_updating := per_dpf_shd.api_updating

391: Begin
392: --
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: --
395: l_api_updating := per_dpf_shd.api_updating
396: (p_deployment_factor_id => p_deployment_factor_id,
397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating

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 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 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 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 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 423: per_dpf_shd.constraint_error('PER_DPF_WORK_ANY_COUNTRY');

419: (p_lookup_type => 'YES_NO',
420: p_lookup_code => p_work_any_country,
421: p_effective_date => p_effective_date) then
422: --
423: per_dpf_shd.constraint_error('PER_DPF_WORK_ANY_COUNTRY');
424: --
425: end if;
426: --
427: -- Work any location lookup.

Line 434: per_dpf_shd.constraint_error('PER_DPF_WORK_ANY_LOCATION');

430: (p_lookup_type => 'YES_NO',
431: p_lookup_code => p_work_any_location,
432: p_effective_date => p_effective_date) then
433: --
434: per_dpf_shd.constraint_error('PER_DPF_WORK_ANY_LOCATION');
435: --
436: end if;
437: --
438: -- Relocate Domestically lookup.

Line 445: per_dpf_shd.constraint_error('PER_DPF_RELOCATE_DOMESTICALLY');

441: (p_lookup_type => 'YES_NO',
442: p_lookup_code => p_relocate_domestically,
443: p_effective_date => p_effective_date) then
444: --
445: per_dpf_shd.constraint_error('PER_DPF_RELOCATE_DOMESTICALLY');
446: --
447: end if;
448: --
449: -- Relocate Internationally lookup.

Line 456: per_dpf_shd.constraint_error('PER_DPF_RELOCATE_INTERNATIONALLY');

452: (p_lookup_type => 'YES_NO',
453: p_lookup_code => p_relocate_internationally,
454: p_effective_date => p_effective_date) then
455: --
456: per_dpf_shd.constraint_error('PER_DPF_RELOCATE_INTERNATIONALLY');
457: --
458: end if;
459: --
460: -- Travel Required lookup.

Line 467: per_dpf_shd.constraint_error('PER_DPF_TRAVEL_REQUIRED');

463: (p_lookup_type => 'YES_NO',
464: p_lookup_code => p_travel_required,
465: p_effective_date => p_effective_date) then
466: --
467: per_dpf_shd.constraint_error('PER_DPF_TRAVEL_REQUIRED');
468: --
469: end if;
470: --
471: end if;

Line 530: l_api_updating := per_dpf_shd.api_updating

526: Begin
527: --
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: l_api_updating := per_dpf_shd.api_updating
531: (p_deployment_factor_id => p_deployment_factor_id,
532: p_object_version_number => p_object_version_number);
533: --
534: if (l_api_updating

Line 536: <> per_dpf_shd.g_old_rec.country1

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)
540: <> per_dpf_shd.g_old_rec.country3

Line 538: <> per_dpf_shd.g_old_rec.country2

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)
542: <> per_dpf_shd.g_old_rec.no_country1

Line 540: <> per_dpf_shd.g_old_rec.country3

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)
544: <> per_dpf_shd.g_old_rec.no_country2

Line 542: <> per_dpf_shd.g_old_rec.no_country1

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)
546: <> per_dpf_shd.g_old_rec.no_country3)

Line 544: <> per_dpf_shd.g_old_rec.no_country2

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

Line 546: <> per_dpf_shd.g_old_rec.no_country3)

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

Line 554: per_dpf_shd.g_old_rec.country1 or

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

Line 579: per_dpf_shd.g_old_rec.country2 or

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

Line 604: per_dpf_shd.g_old_rec.country3 or

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

Line 629: per_dpf_shd.g_old_rec.no_country1 or

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

Line 654: per_dpf_shd.g_old_rec.no_country2 or

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

Line 679: per_dpf_shd.g_old_rec.no_country3 or

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

Line 751: l_api_updating := per_dpf_shd.api_updating

747: Begin
748: --
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: l_api_updating := per_dpf_shd.api_updating
752: (p_deployment_factor_id => p_deployment_factor_id,
753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating

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 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 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 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 915: l_api_updating := per_dpf_shd.api_updating

911: Begin
912: --
913: hr_utility.set_location('Entering:'||l_proc, 5);
914: --
915: l_api_updating := per_dpf_shd.api_updating
916: (p_deployment_factor_id => p_deployment_factor_id,
917: p_object_version_number => p_object_version_number);
918: --
919: if (l_api_updating

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 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 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 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 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 947: per_dpf_shd.constraint_error('PER_DPF_VISIT_INTERNATIONALLY');

943: (p_lookup_type => 'YES_NO',
944: p_lookup_code => p_visit_internationally,
945: p_effective_date => p_effective_date) then
946: --
947: per_dpf_shd.constraint_error('PER_DPF_VISIT_INTERNATIONALLY');
948: --
949: end if;
950: --
951: end if;

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 970: per_dpf_shd.constraint_error('PER_DPF_ONLY_CURRENT_LOCATION');

966: (p_lookup_type => 'YES_NO',
967: p_lookup_code => p_only_current_location,
968: p_effective_date => p_effective_date) then
969: --
970: per_dpf_shd.constraint_error('PER_DPF_ONLY_CURRENT_LOCATION');
971: --
972: end if;
973: --
974: end if;

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 993: per_dpf_shd.constraint_error('PER_DPF_AVAILABLE_FOR_TRANSFER');

989: (p_lookup_type => 'YES_NO',
990: p_lookup_code => p_available_for_transfer,
991: p_effective_date => p_effective_date) then
992: --
993: per_dpf_shd.constraint_error('PER_DPF_AVAILABLE_FOR_TRANSFER');
994: --
995: end if;
996: --
997: end if;

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 1075: l_api_updating := per_dpf_shd.api_updating

1071: Begin
1072: --
1073: hr_utility.set_location('Entering:'||l_proc, 5);
1074: --
1075: l_api_updating := per_dpf_shd.api_updating
1076: (p_deployment_factor_id => p_deployment_factor_id,
1077: p_object_version_number => p_object_version_number);
1078: --
1079: if (l_api_updating

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 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 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 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 1105: per_dpf_shd.constraint_error('PER_DPF_RELOCATION_REQUIRED');

1101: (p_lookup_type => 'YES_NO',
1102: p_lookup_code => p_relocation_required,
1103: p_effective_date => p_effective_date) then
1104: --
1105: per_dpf_shd.constraint_error('PER_DPF_RELOCATION_REQUIRED');
1106: --
1107: end if;
1108: --
1109: end if;

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 1128: per_dpf_shd.constraint_error('PER_DPF_PASSPORT_REQUIRED');

1124: (p_lookup_type => 'YES_NO',
1125: p_lookup_code => p_passport_required,
1126: p_effective_date => p_effective_date) then
1127: --
1128: per_dpf_shd.constraint_error('PER_DPF_PASSPORT_REQUIRED');
1129: --
1130: end if;
1131: --
1132: end if;

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 1213: l_api_updating := per_dpf_shd.api_updating

1209: Begin
1210: --
1211: hr_utility.set_location('Entering:'||l_proc, 5);
1212: --
1213: l_api_updating := per_dpf_shd.api_updating
1214: (p_deployment_factor_id => p_deployment_factor_id,
1215: p_object_version_number => p_object_version_number);
1216: --
1217: if (l_api_updating

Line 1219: <> per_dpf_shd.g_old_rec.location1

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)
1223: <> per_dpf_shd.g_old_rec.location3)

Line 1221: <> per_dpf_shd.g_old_rec.location2

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

Line 1223: <> per_dpf_shd.g_old_rec.location3)

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

Line 1231: per_dpf_shd.g_old_rec.location1 or

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

Line 1254: per_dpf_shd.g_old_rec.location2 or

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

Line 1277: per_dpf_shd.g_old_rec.location3 or

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

Line 1343: l_api_updating := per_dpf_shd.api_updating

1339: Begin
1340: --
1341: hr_utility.set_location('Entering:'||l_proc, 5);
1342: --
1343: l_api_updating := per_dpf_shd.api_updating
1344: (p_deployment_factor_id => p_deployment_factor_id,
1345: p_object_version_number => p_object_version_number);
1346: --
1347: if (l_api_updating

Line 1349: <> per_dpf_shd.g_old_rec.person_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)
1353: <> per_dpf_shd.g_old_rec.job_id)

Line 1351: <> per_dpf_shd.g_old_rec.position_id

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

Line 1353: <> per_dpf_shd.g_old_rec.job_id)

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

Line 1437: l_api_updating := per_dpf_shd.api_updating

1433: Begin
1434: --
1435: hr_utility.set_location('Entering:'||l_proc, 5);
1436: --
1437: l_api_updating := per_dpf_shd.api_updating
1438: (p_deployment_factor_id => p_deployment_factor_id,
1439: p_object_version_number => p_object_version_number);
1440: --
1441: if (l_api_updating

Line 1443: <> per_dpf_shd.g_old_rec.relocation_required

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)
1447: <> per_dpf_shd.g_old_rec.location1

Line 1445: <> per_dpf_shd.g_old_rec.passport_required

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)
1449: <> per_dpf_shd.g_old_rec.location2

Line 1447: <> per_dpf_shd.g_old_rec.location1

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)
1451: <> per_dpf_shd.g_old_rec.location3

Line 1449: <> per_dpf_shd.g_old_rec.location2

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)
1453: <> per_dpf_shd.g_old_rec.other_requirements

Line 1451: <> per_dpf_shd.g_old_rec.location3

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)
1455: <> per_dpf_shd.g_old_rec.service_minimum)

Line 1453: <> per_dpf_shd.g_old_rec.other_requirements

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

Line 1455: <> per_dpf_shd.g_old_rec.service_minimum)

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
1459: -- RELOCATION_REQUIRED, PASSPORT_REQUIRED, LOCATION1, LOCATION2,

Line 1540: l_api_updating := per_dpf_shd.api_updating

1536: Begin
1537: --
1538: hr_utility.set_location('Entering:'||l_proc, 5);
1539: --
1540: l_api_updating := per_dpf_shd.api_updating
1541: (p_deployment_factor_id => p_deployment_factor_id,
1542: p_object_version_number => p_object_version_number);
1543: --
1544: if (l_api_updating

Line 1546: <> per_dpf_shd.g_old_rec.visit_internationally

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)
1550: <> per_dpf_shd.g_old_rec.no_country1

Line 1548: <> per_dpf_shd.g_old_rec.only_current_location

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)
1552: <> per_dpf_shd.g_old_rec.no_country2

Line 1550: <> per_dpf_shd.g_old_rec.no_country1

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)
1554: <> per_dpf_shd.g_old_rec.no_country3

Line 1552: <> per_dpf_shd.g_old_rec.no_country2

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)
1556: <> per_dpf_shd.g_old_rec.comments

Line 1554: <> per_dpf_shd.g_old_rec.no_country3

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)
1558: <> per_dpf_shd.g_old_rec.earliest_available_date

Line 1556: <> per_dpf_shd.g_old_rec.comments

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)
1560: <> per_dpf_shd.g_old_rec.available_for_transfer

Line 1558: <> per_dpf_shd.g_old_rec.earliest_available_date

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)
1562: <> per_dpf_shd.g_old_rec.relocation_preference)

Line 1560: <> per_dpf_shd.g_old_rec.available_for_transfer

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

Line 1562: <> per_dpf_shd.g_old_rec.relocation_preference)

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
1566: -- VISIT_INTERNATIONALLY, ONLY_CURRENT_LOCATION, NO_COUNTRY1, NO_COUNTRY2,

Line 1644: l_api_updating := per_dpf_shd.api_updating

1640: Begin
1641: --
1642: hr_utility.set_location('Entering:'||l_proc, 5);
1643: --
1644: l_api_updating := per_dpf_shd.api_updating
1645: (p_deployment_factor_id => p_deployment_factor_id,
1646: p_object_version_number => p_object_version_number);
1647: --
1648: if (l_api_updating

Line 1650: <> per_dpf_shd.g_old_rec.person_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)
1654: <> per_dpf_shd.g_old_rec.job_id)

Line 1652: <> per_dpf_shd.g_old_rec.position_id

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

Line 1654: <> per_dpf_shd.g_old_rec.job_id)

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
1658: -- one.

Line 1666: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_UK');

1662: fetch c1 into l_dummy;
1663: if c1%found then
1664: --
1665: close c1;
1666: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_UK');
1667: --
1668: end if;
1669: --
1670: close c1;

Line 1742: l_api_updating := per_dpf_shd.api_updating

1738: Begin
1739: --
1740: hr_utility.set_location('Entering:'||l_proc, 5);
1741: --
1742: l_api_updating := per_dpf_shd.api_updating
1743: (p_deployment_factor_id => p_deployment_factor_id,
1744: p_object_version_number => p_object_version_number);
1745: --
1746: if (l_api_updating

Line 1748: <> per_dpf_shd.g_old_rec.person_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)
1752: <> per_dpf_shd.g_old_rec.job_id)

Line 1750: <> per_dpf_shd.g_old_rec.position_id

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

Line 1752: <> per_dpf_shd.g_old_rec.job_id)

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
1756: -- one.

Line 1840: (p_rec in per_dpf_shd.g_rec_type) is

1836: -- Access Status:
1837: -- Internal Row Handler Use Only.
1838: --
1839: procedure chk_df
1840: (p_rec in per_dpf_shd.g_rec_type) is
1841: --
1842: l_proc varchar2(72) := g_package||'chk_df';
1843: --
1844: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1950: Procedure insert_validate(p_rec in per_dpf_shd.g_rec_type,

1946: end chk_df;
1947: -- ----------------------------------------------------------------------------
1948: -- |---------------------------< insert_validate >----------------------------|
1949: -- ----------------------------------------------------------------------------
1950: Procedure insert_validate(p_rec in per_dpf_shd.g_rec_type,
1951: p_effective_date in date) is
1952: --
1953: l_proc varchar2(72) := g_package||'insert_validate';
1954: --

Line 2144: Procedure update_validate(p_rec in per_dpf_shd.g_rec_type,

2140: --
2141: -- ----------------------------------------------------------------------------
2142: -- |---------------------------< update_validate >----------------------------|
2143: -- ----------------------------------------------------------------------------
2144: Procedure update_validate(p_rec in per_dpf_shd.g_rec_type,
2145: p_effective_date in date) is
2146: --
2147: l_proc varchar2(72) := g_package||'update_validate';
2148: --

Line 2336: Procedure delete_validate(p_rec in per_dpf_shd.g_rec_type) is

2332: --
2333: -- ----------------------------------------------------------------------------
2334: -- |---------------------------< delete_validate >----------------------------|
2335: -- ----------------------------------------------------------------------------
2336: Procedure delete_validate(p_rec in per_dpf_shd.g_rec_type) is
2337: --
2338: l_proc varchar2(72) := g_package||'delete_validate';
2339: --
2340: Begin