APPS.BEN_CLP_BUS dependencies on HR_API

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

33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Ensure that all the mandatory parameter are not null
36: --
37: hr_api.mandatory_arg_error(p_api_name => l_proc,
38: p_argument => 'clpse_lf_evt_id',
39: p_argument_value => p_clpse_lf_evt_id);
40: --
41: open csr_leg_code;

Line 108: and nvl(p_clpse_lf_evt_id,hr_api.g_number)

104: p_clpse_lf_evt_id => p_clpse_lf_evt_id,
105: p_object_version_number => p_object_version_number);
106: --
107: if (l_api_updating
108: and nvl(p_clpse_lf_evt_id,hr_api.g_number)
109: <> ben_clp_shd.g_old_rec.clpse_lf_evt_id) then
110: --
111: -- raise error as PK has changed
112: --

Line 195: and nvl(p_seq,hr_api.g_number)

191: p_clpse_lf_evt_id => p_clpse_lf_evt_id,
192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and nvl(p_seq,hr_api.g_number)
196: <> ben_clp_shd.g_old_rec.seq)
197: or not l_api_updating then
198: --
199: -- Check if sequence is unique within this business group.

Line 455: <> nvl(ben_clp_shd.g_old_rec.ler1_id,hr_api.g_number)

451: p_object_version_number => p_object_version_number);
452: --
453: if (l_api_updating
454: and p_ler1_id
455: <> nvl(ben_clp_shd.g_old_rec.ler1_id,hr_api.g_number)
456: or p_bool1_cd
457: <> nvl(ben_clp_shd.g_old_rec.bool1_cd,hr_api.g_varchar2)
458: or p_ler2_id
459: <> nvl(ben_clp_shd.g_old_rec.ler2_id,hr_api.g_number)

Line 457: <> nvl(ben_clp_shd.g_old_rec.bool1_cd,hr_api.g_varchar2)

453: if (l_api_updating
454: and p_ler1_id
455: <> nvl(ben_clp_shd.g_old_rec.ler1_id,hr_api.g_number)
456: or p_bool1_cd
457: <> nvl(ben_clp_shd.g_old_rec.bool1_cd,hr_api.g_varchar2)
458: or p_ler2_id
459: <> nvl(ben_clp_shd.g_old_rec.ler2_id,hr_api.g_number)
460: or p_bool2_cd
461: <> nvl(ben_clp_shd.g_old_rec.bool2_cd,hr_api.g_varchar2)

Line 459: <> nvl(ben_clp_shd.g_old_rec.ler2_id,hr_api.g_number)

455: <> nvl(ben_clp_shd.g_old_rec.ler1_id,hr_api.g_number)
456: or p_bool1_cd
457: <> nvl(ben_clp_shd.g_old_rec.bool1_cd,hr_api.g_varchar2)
458: or p_ler2_id
459: <> nvl(ben_clp_shd.g_old_rec.ler2_id,hr_api.g_number)
460: or p_bool2_cd
461: <> nvl(ben_clp_shd.g_old_rec.bool2_cd,hr_api.g_varchar2)
462: or p_ler3_id
463: <> nvl(ben_clp_shd.g_old_rec.ler3_id,hr_api.g_number)

Line 461: <> nvl(ben_clp_shd.g_old_rec.bool2_cd,hr_api.g_varchar2)

457: <> nvl(ben_clp_shd.g_old_rec.bool1_cd,hr_api.g_varchar2)
458: or p_ler2_id
459: <> nvl(ben_clp_shd.g_old_rec.ler2_id,hr_api.g_number)
460: or p_bool2_cd
461: <> nvl(ben_clp_shd.g_old_rec.bool2_cd,hr_api.g_varchar2)
462: or p_ler3_id
463: <> nvl(ben_clp_shd.g_old_rec.ler3_id,hr_api.g_number)
464: or p_bool3_cd
465: <> nvl(ben_clp_shd.g_old_rec.bool3_cd,hr_api.g_varchar2)

Line 463: <> nvl(ben_clp_shd.g_old_rec.ler3_id,hr_api.g_number)

459: <> nvl(ben_clp_shd.g_old_rec.ler2_id,hr_api.g_number)
460: or p_bool2_cd
461: <> nvl(ben_clp_shd.g_old_rec.bool2_cd,hr_api.g_varchar2)
462: or p_ler3_id
463: <> nvl(ben_clp_shd.g_old_rec.ler3_id,hr_api.g_number)
464: or p_bool3_cd
465: <> nvl(ben_clp_shd.g_old_rec.bool3_cd,hr_api.g_varchar2)
466: or p_ler4_id
467: <> nvl(ben_clp_shd.g_old_rec.ler4_id,hr_api.g_number)

Line 465: <> nvl(ben_clp_shd.g_old_rec.bool3_cd,hr_api.g_varchar2)

461: <> nvl(ben_clp_shd.g_old_rec.bool2_cd,hr_api.g_varchar2)
462: or p_ler3_id
463: <> nvl(ben_clp_shd.g_old_rec.ler3_id,hr_api.g_number)
464: or p_bool3_cd
465: <> nvl(ben_clp_shd.g_old_rec.bool3_cd,hr_api.g_varchar2)
466: or p_ler4_id
467: <> nvl(ben_clp_shd.g_old_rec.ler4_id,hr_api.g_number)
468: or p_bool4_cd
469: <> nvl(ben_clp_shd.g_old_rec.bool4_cd,hr_api.g_varchar2)

Line 467: <> nvl(ben_clp_shd.g_old_rec.ler4_id,hr_api.g_number)

463: <> nvl(ben_clp_shd.g_old_rec.ler3_id,hr_api.g_number)
464: or p_bool3_cd
465: <> nvl(ben_clp_shd.g_old_rec.bool3_cd,hr_api.g_varchar2)
466: or p_ler4_id
467: <> nvl(ben_clp_shd.g_old_rec.ler4_id,hr_api.g_number)
468: or p_bool4_cd
469: <> nvl(ben_clp_shd.g_old_rec.bool4_cd,hr_api.g_varchar2)
470: or p_ler5_id
471: <> nvl(ben_clp_shd.g_old_rec.ler5_id,hr_api.g_number)

Line 469: <> nvl(ben_clp_shd.g_old_rec.bool4_cd,hr_api.g_varchar2)

465: <> nvl(ben_clp_shd.g_old_rec.bool3_cd,hr_api.g_varchar2)
466: or p_ler4_id
467: <> nvl(ben_clp_shd.g_old_rec.ler4_id,hr_api.g_number)
468: or p_bool4_cd
469: <> nvl(ben_clp_shd.g_old_rec.bool4_cd,hr_api.g_varchar2)
470: or p_ler5_id
471: <> nvl(ben_clp_shd.g_old_rec.ler5_id,hr_api.g_number)
472: or p_bool5_cd
473: <> nvl(ben_clp_shd.g_old_rec.bool5_cd,hr_api.g_varchar2)

Line 471: <> nvl(ben_clp_shd.g_old_rec.ler5_id,hr_api.g_number)

467: <> nvl(ben_clp_shd.g_old_rec.ler4_id,hr_api.g_number)
468: or p_bool4_cd
469: <> nvl(ben_clp_shd.g_old_rec.bool4_cd,hr_api.g_varchar2)
470: or p_ler5_id
471: <> nvl(ben_clp_shd.g_old_rec.ler5_id,hr_api.g_number)
472: or p_bool5_cd
473: <> nvl(ben_clp_shd.g_old_rec.bool5_cd,hr_api.g_varchar2)
474: or p_ler6_id
475: <> nvl(ben_clp_shd.g_old_rec.ler6_id,hr_api.g_number)

Line 473: <> nvl(ben_clp_shd.g_old_rec.bool5_cd,hr_api.g_varchar2)

469: <> nvl(ben_clp_shd.g_old_rec.bool4_cd,hr_api.g_varchar2)
470: or p_ler5_id
471: <> nvl(ben_clp_shd.g_old_rec.ler5_id,hr_api.g_number)
472: or p_bool5_cd
473: <> nvl(ben_clp_shd.g_old_rec.bool5_cd,hr_api.g_varchar2)
474: or p_ler6_id
475: <> nvl(ben_clp_shd.g_old_rec.ler6_id,hr_api.g_number)
476: or p_bool6_cd
477: <> nvl(ben_clp_shd.g_old_rec.bool6_cd,hr_api.g_varchar2)

Line 475: <> nvl(ben_clp_shd.g_old_rec.ler6_id,hr_api.g_number)

471: <> nvl(ben_clp_shd.g_old_rec.ler5_id,hr_api.g_number)
472: or p_bool5_cd
473: <> nvl(ben_clp_shd.g_old_rec.bool5_cd,hr_api.g_varchar2)
474: or p_ler6_id
475: <> nvl(ben_clp_shd.g_old_rec.ler6_id,hr_api.g_number)
476: or p_bool6_cd
477: <> nvl(ben_clp_shd.g_old_rec.bool6_cd,hr_api.g_varchar2)
478: or p_ler7_id
479: <> nvl(ben_clp_shd.g_old_rec.ler7_id,hr_api.g_number)

Line 477: <> nvl(ben_clp_shd.g_old_rec.bool6_cd,hr_api.g_varchar2)

473: <> nvl(ben_clp_shd.g_old_rec.bool5_cd,hr_api.g_varchar2)
474: or p_ler6_id
475: <> nvl(ben_clp_shd.g_old_rec.ler6_id,hr_api.g_number)
476: or p_bool6_cd
477: <> nvl(ben_clp_shd.g_old_rec.bool6_cd,hr_api.g_varchar2)
478: or p_ler7_id
479: <> nvl(ben_clp_shd.g_old_rec.ler7_id,hr_api.g_number)
480: or p_bool7_cd
481: <> nvl(ben_clp_shd.g_old_rec.bool7_cd,hr_api.g_varchar2)

Line 479: <> nvl(ben_clp_shd.g_old_rec.ler7_id,hr_api.g_number)

475: <> nvl(ben_clp_shd.g_old_rec.ler6_id,hr_api.g_number)
476: or p_bool6_cd
477: <> nvl(ben_clp_shd.g_old_rec.bool6_cd,hr_api.g_varchar2)
478: or p_ler7_id
479: <> nvl(ben_clp_shd.g_old_rec.ler7_id,hr_api.g_number)
480: or p_bool7_cd
481: <> nvl(ben_clp_shd.g_old_rec.bool7_cd,hr_api.g_varchar2)
482: or p_ler8_id
483: <> nvl(ben_clp_shd.g_old_rec.ler8_id,hr_api.g_number)

Line 481: <> nvl(ben_clp_shd.g_old_rec.bool7_cd,hr_api.g_varchar2)

477: <> nvl(ben_clp_shd.g_old_rec.bool6_cd,hr_api.g_varchar2)
478: or p_ler7_id
479: <> nvl(ben_clp_shd.g_old_rec.ler7_id,hr_api.g_number)
480: or p_bool7_cd
481: <> nvl(ben_clp_shd.g_old_rec.bool7_cd,hr_api.g_varchar2)
482: or p_ler8_id
483: <> nvl(ben_clp_shd.g_old_rec.ler8_id,hr_api.g_number)
484: or p_bool8_cd
485: <> nvl(ben_clp_shd.g_old_rec.bool8_cd,hr_api.g_varchar2)

Line 483: <> nvl(ben_clp_shd.g_old_rec.ler8_id,hr_api.g_number)

479: <> nvl(ben_clp_shd.g_old_rec.ler7_id,hr_api.g_number)
480: or p_bool7_cd
481: <> nvl(ben_clp_shd.g_old_rec.bool7_cd,hr_api.g_varchar2)
482: or p_ler8_id
483: <> nvl(ben_clp_shd.g_old_rec.ler8_id,hr_api.g_number)
484: or p_bool8_cd
485: <> nvl(ben_clp_shd.g_old_rec.bool8_cd,hr_api.g_varchar2)
486: or p_ler9_id
487: <> nvl(ben_clp_shd.g_old_rec.ler9_id,hr_api.g_number)

Line 485: <> nvl(ben_clp_shd.g_old_rec.bool8_cd,hr_api.g_varchar2)

481: <> nvl(ben_clp_shd.g_old_rec.bool7_cd,hr_api.g_varchar2)
482: or p_ler8_id
483: <> nvl(ben_clp_shd.g_old_rec.ler8_id,hr_api.g_number)
484: or p_bool8_cd
485: <> nvl(ben_clp_shd.g_old_rec.bool8_cd,hr_api.g_varchar2)
486: or p_ler9_id
487: <> nvl(ben_clp_shd.g_old_rec.ler9_id,hr_api.g_number)
488: or p_bool9_cd
489: <> nvl(ben_clp_shd.g_old_rec.bool9_cd,hr_api.g_varchar2)

Line 487: <> nvl(ben_clp_shd.g_old_rec.ler9_id,hr_api.g_number)

483: <> nvl(ben_clp_shd.g_old_rec.ler8_id,hr_api.g_number)
484: or p_bool8_cd
485: <> nvl(ben_clp_shd.g_old_rec.bool8_cd,hr_api.g_varchar2)
486: or p_ler9_id
487: <> nvl(ben_clp_shd.g_old_rec.ler9_id,hr_api.g_number)
488: or p_bool9_cd
489: <> nvl(ben_clp_shd.g_old_rec.bool9_cd,hr_api.g_varchar2)
490: or p_ler10_id
491: <> nvl(ben_clp_shd.g_old_rec.ler10_id,hr_api.g_number))

Line 489: <> nvl(ben_clp_shd.g_old_rec.bool9_cd,hr_api.g_varchar2)

485: <> nvl(ben_clp_shd.g_old_rec.bool8_cd,hr_api.g_varchar2)
486: or p_ler9_id
487: <> nvl(ben_clp_shd.g_old_rec.ler9_id,hr_api.g_number)
488: or p_bool9_cd
489: <> nvl(ben_clp_shd.g_old_rec.bool9_cd,hr_api.g_varchar2)
490: or p_ler10_id
491: <> nvl(ben_clp_shd.g_old_rec.ler10_id,hr_api.g_number))
492: or not l_api_updating then
493: --

Line 491: <> nvl(ben_clp_shd.g_old_rec.ler10_id,hr_api.g_number))

487: <> nvl(ben_clp_shd.g_old_rec.ler9_id,hr_api.g_number)
488: or p_bool9_cd
489: <> nvl(ben_clp_shd.g_old_rec.bool9_cd,hr_api.g_varchar2)
490: or p_ler10_id
491: <> nvl(ben_clp_shd.g_old_rec.ler10_id,hr_api.g_number))
492: or not l_api_updating then
493: --
494: -- We need to check that any bool_cd that has a value is surrounded by
495: -- its adjacent life event reasons

Line 668: <> nvl(ben_clp_shd.g_old_rec.bool1_cd,hr_api.g_varchar2)

664: p_object_version_number => p_object_version_number);
665: --
666: if (l_api_updating
667: and p_bool1_cd
668: <> nvl(ben_clp_shd.g_old_rec.bool1_cd,hr_api.g_varchar2)
669: or not l_api_updating)
670: and p_bool1_cd is not null then
671: --
672: -- check if value of lookup falls within lookup type.

Line 674: if hr_api.not_exists_in_hr_lookups

670: and p_bool1_cd is not null then
671: --
672: -- check if value of lookup falls within lookup type.
673: --
674: if hr_api.not_exists_in_hr_lookups
675: (p_lookup_type => 'BEN_BOOL',
676: p_lookup_code => p_bool1_cd,
677: p_effective_date => p_effective_date) then
678: --

Line 692: <> nvl(ben_clp_shd.g_old_rec.bool2_cd,hr_api.g_varchar2)

688: end if;
689: --
690: if (l_api_updating
691: and p_bool2_cd
692: <> nvl(ben_clp_shd.g_old_rec.bool2_cd,hr_api.g_varchar2)
693: or not l_api_updating)
694: and p_bool2_cd is not null then
695: --
696: -- check if value of lookup falls within lookup type.

Line 698: if hr_api.not_exists_in_hr_lookups

694: and p_bool2_cd is not null then
695: --
696: -- check if value of lookup falls within lookup type.
697: --
698: if hr_api.not_exists_in_hr_lookups
699: (p_lookup_type => 'BEN_BOOL',
700: p_lookup_code => p_bool2_cd,
701: p_effective_date => p_effective_date) then
702: --

Line 716: <> nvl(ben_clp_shd.g_old_rec.bool3_cd,hr_api.g_varchar2)

712: end if;
713: --
714: if (l_api_updating
715: and p_bool3_cd
716: <> nvl(ben_clp_shd.g_old_rec.bool3_cd,hr_api.g_varchar2)
717: or not l_api_updating)
718: and p_bool3_cd is not null then
719: --
720: -- check if value of lookup falls within lookup type.

Line 722: if hr_api.not_exists_in_hr_lookups

718: and p_bool3_cd is not null then
719: --
720: -- check if value of lookup falls within lookup type.
721: --
722: if hr_api.not_exists_in_hr_lookups
723: (p_lookup_type => 'BEN_BOOL',
724: p_lookup_code => p_bool3_cd,
725: p_effective_date => p_effective_date) then
726: --

Line 740: <> nvl(ben_clp_shd.g_old_rec.bool4_cd,hr_api.g_varchar2)

736: end if;
737: --
738: if (l_api_updating
739: and p_bool4_cd
740: <> nvl(ben_clp_shd.g_old_rec.bool4_cd,hr_api.g_varchar2)
741: or not l_api_updating)
742: and p_bool4_cd is not null then
743: --
744: -- check if value of lookup falls within lookup type.

Line 746: if hr_api.not_exists_in_hr_lookups

742: and p_bool4_cd is not null then
743: --
744: -- check if value of lookup falls within lookup type.
745: --
746: if hr_api.not_exists_in_hr_lookups
747: (p_lookup_type => 'BEN_BOOL',
748: p_lookup_code => p_bool4_cd,
749: p_effective_date => p_effective_date) then
750: --

Line 764: <> nvl(ben_clp_shd.g_old_rec.bool5_cd,hr_api.g_varchar2)

760: end if;
761: --
762: if (l_api_updating
763: and p_bool5_cd
764: <> nvl(ben_clp_shd.g_old_rec.bool5_cd,hr_api.g_varchar2)
765: or not l_api_updating)
766: and p_bool5_cd is not null then
767: --
768: -- check if value of lookup falls within lookup type.

Line 770: if hr_api.not_exists_in_hr_lookups

766: and p_bool5_cd is not null then
767: --
768: -- check if value of lookup falls within lookup type.
769: --
770: if hr_api.not_exists_in_hr_lookups
771: (p_lookup_type => 'BEN_BOOL',
772: p_lookup_code => p_bool5_cd,
773: p_effective_date => p_effective_date) then
774: --

Line 788: <> nvl(ben_clp_shd.g_old_rec.bool6_cd,hr_api.g_varchar2)

784: end if;
785: --
786: if (l_api_updating
787: and p_bool6_cd
788: <> nvl(ben_clp_shd.g_old_rec.bool6_cd,hr_api.g_varchar2)
789: or not l_api_updating)
790: and p_bool6_cd is not null then
791: --
792: -- check if value of lookup falls within lookup type.

Line 794: if hr_api.not_exists_in_hr_lookups

790: and p_bool6_cd is not null then
791: --
792: -- check if value of lookup falls within lookup type.
793: --
794: if hr_api.not_exists_in_hr_lookups
795: (p_lookup_type => 'BEN_BOOL',
796: p_lookup_code => p_bool6_cd,
797: p_effective_date => p_effective_date) then
798: --

Line 812: <> nvl(ben_clp_shd.g_old_rec.bool7_cd,hr_api.g_varchar2)

808: end if;
809: --
810: if (l_api_updating
811: and p_bool7_cd
812: <> nvl(ben_clp_shd.g_old_rec.bool7_cd,hr_api.g_varchar2)
813: or not l_api_updating)
814: and p_bool7_cd is not null then
815: --
816: -- check if value of lookup falls within lookup type.

Line 818: if hr_api.not_exists_in_hr_lookups

814: and p_bool7_cd is not null then
815: --
816: -- check if value of lookup falls within lookup type.
817: --
818: if hr_api.not_exists_in_hr_lookups
819: (p_lookup_type => 'BEN_BOOL',
820: p_lookup_code => p_bool7_cd,
821: p_effective_date => p_effective_date) then
822: --

Line 836: <> nvl(ben_clp_shd.g_old_rec.bool8_cd,hr_api.g_varchar2)

832: end if;
833: --
834: if (l_api_updating
835: and p_bool8_cd
836: <> nvl(ben_clp_shd.g_old_rec.bool8_cd,hr_api.g_varchar2)
837: or not l_api_updating)
838: and p_bool8_cd is not null then
839: --
840: -- check if value of lookup falls within lookup type.

Line 842: if hr_api.not_exists_in_hr_lookups

838: and p_bool8_cd is not null then
839: --
840: -- check if value of lookup falls within lookup type.
841: --
842: if hr_api.not_exists_in_hr_lookups
843: (p_lookup_type => 'BEN_BOOL',
844: p_lookup_code => p_bool8_cd,
845: p_effective_date => p_effective_date) then
846: --

Line 860: <> nvl(ben_clp_shd.g_old_rec.bool9_cd,hr_api.g_varchar2)

856: end if;
857: --
858: if (l_api_updating
859: and p_bool9_cd
860: <> nvl(ben_clp_shd.g_old_rec.bool9_cd,hr_api.g_varchar2)
861: or not l_api_updating)
862: and p_bool9_cd is not null then
863: --
864: -- check if value of lookup falls within lookup type.

Line 866: if hr_api.not_exists_in_hr_lookups

862: and p_bool9_cd is not null then
863: --
864: -- check if value of lookup falls within lookup type.
865: --
866: if hr_api.not_exists_in_hr_lookups
867: (p_lookup_type => 'BEN_BOOL',
868: p_lookup_code => p_bool9_cd,
869: p_effective_date => p_effective_date) then
870: --

Line 932: and nvl(p_eval_rl,hr_api.g_number)

928: p_effective_date => p_effective_date,
929: p_object_version_number => p_object_version_number);
930: --
931: if (l_api_updating
932: and nvl(p_eval_rl,hr_api.g_number)
933: <> ben_clp_shd.g_old_rec.eval_rl
934: or not l_api_updating)
935: and p_eval_rl is not null then
936: --

Line 1005: and nvl(p_eval_ler_det_rl,hr_api.g_number)

1001: p_effective_date => p_effective_date,
1002: p_object_version_number => p_object_version_number);
1003: --
1004: if (l_api_updating
1005: and nvl(p_eval_ler_det_rl,hr_api.g_number)
1006: <> ben_clp_shd.g_old_rec.eval_ler_det_rl
1007: or not l_api_updating)
1008: and p_eval_ler_det_rl is not null then
1009: --

Line 1357: <> nvl(ben_clp_shd.g_old_rec.eval_cd,hr_api.g_varchar2)

1353: p_object_version_number => p_object_version_number);
1354: --
1355: if (l_api_updating
1356: and p_eval_cd
1357: <> nvl(ben_clp_shd.g_old_rec.eval_cd,hr_api.g_varchar2)
1358: or not l_api_updating) then
1359: --
1360: -- check if value of lookup falls within lookup type.
1361: --

Line 1362: if hr_api.not_exists_in_hr_lookups

1358: or not l_api_updating) then
1359: --
1360: -- check if value of lookup falls within lookup type.
1361: --
1362: if hr_api.not_exists_in_hr_lookups
1363: (p_lookup_type => 'BEN_EVAL',
1364: p_lookup_code => p_eval_cd,
1365: p_effective_date => p_effective_date) then
1366: --

Line 1428: <> nvl(ben_clp_shd.g_old_rec.eval_cd,hr_api.g_varchar2)

1424: p_object_version_number => p_object_version_number);
1425: --
1426: if (l_api_updating
1427: and p_eval_ler_det_cd
1428: <> nvl(ben_clp_shd.g_old_rec.eval_cd,hr_api.g_varchar2)
1429: or not l_api_updating) then
1430: --
1431: -- check if value of lookup falls within lookup type.
1432: --

Line 1433: if hr_api.not_exists_in_hr_lookups

1429: or not l_api_updating) then
1430: --
1431: -- check if value of lookup falls within lookup type.
1432: --
1433: if hr_api.not_exists_in_hr_lookups
1434: (p_lookup_type => 'BEN_EVAL_DET',
1435: p_lookup_code => p_eval_ler_det_cd,
1436: p_effective_date => p_effective_date) then
1437: --

Line 1482: (p_ler1_id in number default hr_api.g_number,

1478: --
1479: -- {End Of Comments}
1480: -- ----------------------------------------------------------------------------
1481: Procedure dt_update_validate
1482: (p_ler1_id in number default hr_api.g_number,
1483: p_ler2_id in number default hr_api.g_number,
1484: p_ler3_id in number default hr_api.g_number,
1485: p_ler4_id in number default hr_api.g_number,
1486: p_ler5_id in number default hr_api.g_number,

Line 1483: p_ler2_id in number default hr_api.g_number,

1479: -- {End Of Comments}
1480: -- ----------------------------------------------------------------------------
1481: Procedure dt_update_validate
1482: (p_ler1_id in number default hr_api.g_number,
1483: p_ler2_id in number default hr_api.g_number,
1484: p_ler3_id in number default hr_api.g_number,
1485: p_ler4_id in number default hr_api.g_number,
1486: p_ler5_id in number default hr_api.g_number,
1487: p_ler6_id in number default hr_api.g_number,

Line 1484: p_ler3_id in number default hr_api.g_number,

1480: -- ----------------------------------------------------------------------------
1481: Procedure dt_update_validate
1482: (p_ler1_id in number default hr_api.g_number,
1483: p_ler2_id in number default hr_api.g_number,
1484: p_ler3_id in number default hr_api.g_number,
1485: p_ler4_id in number default hr_api.g_number,
1486: p_ler5_id in number default hr_api.g_number,
1487: p_ler6_id in number default hr_api.g_number,
1488: p_ler7_id in number default hr_api.g_number,

Line 1485: p_ler4_id in number default hr_api.g_number,

1481: Procedure dt_update_validate
1482: (p_ler1_id in number default hr_api.g_number,
1483: p_ler2_id in number default hr_api.g_number,
1484: p_ler3_id in number default hr_api.g_number,
1485: p_ler4_id in number default hr_api.g_number,
1486: p_ler5_id in number default hr_api.g_number,
1487: p_ler6_id in number default hr_api.g_number,
1488: p_ler7_id in number default hr_api.g_number,
1489: p_ler8_id in number default hr_api.g_number,

Line 1486: p_ler5_id in number default hr_api.g_number,

1482: (p_ler1_id in number default hr_api.g_number,
1483: p_ler2_id in number default hr_api.g_number,
1484: p_ler3_id in number default hr_api.g_number,
1485: p_ler4_id in number default hr_api.g_number,
1486: p_ler5_id in number default hr_api.g_number,
1487: p_ler6_id in number default hr_api.g_number,
1488: p_ler7_id in number default hr_api.g_number,
1489: p_ler8_id in number default hr_api.g_number,
1490: p_ler9_id in number default hr_api.g_number,

Line 1487: p_ler6_id in number default hr_api.g_number,

1483: p_ler2_id in number default hr_api.g_number,
1484: p_ler3_id in number default hr_api.g_number,
1485: p_ler4_id in number default hr_api.g_number,
1486: p_ler5_id in number default hr_api.g_number,
1487: p_ler6_id in number default hr_api.g_number,
1488: p_ler7_id in number default hr_api.g_number,
1489: p_ler8_id in number default hr_api.g_number,
1490: p_ler9_id in number default hr_api.g_number,
1491: p_ler10_id in number default hr_api.g_number,

Line 1488: p_ler7_id in number default hr_api.g_number,

1484: p_ler3_id in number default hr_api.g_number,
1485: p_ler4_id in number default hr_api.g_number,
1486: p_ler5_id in number default hr_api.g_number,
1487: p_ler6_id in number default hr_api.g_number,
1488: p_ler7_id in number default hr_api.g_number,
1489: p_ler8_id in number default hr_api.g_number,
1490: p_ler9_id in number default hr_api.g_number,
1491: p_ler10_id in number default hr_api.g_number,
1492: p_eval_ler_id in number default hr_api.g_number,

Line 1489: p_ler8_id in number default hr_api.g_number,

1485: p_ler4_id in number default hr_api.g_number,
1486: p_ler5_id in number default hr_api.g_number,
1487: p_ler6_id in number default hr_api.g_number,
1488: p_ler7_id in number default hr_api.g_number,
1489: p_ler8_id in number default hr_api.g_number,
1490: p_ler9_id in number default hr_api.g_number,
1491: p_ler10_id in number default hr_api.g_number,
1492: p_eval_ler_id in number default hr_api.g_number,
1493: p_datetrack_mode in varchar2,

Line 1490: p_ler9_id in number default hr_api.g_number,

1486: p_ler5_id in number default hr_api.g_number,
1487: p_ler6_id in number default hr_api.g_number,
1488: p_ler7_id in number default hr_api.g_number,
1489: p_ler8_id in number default hr_api.g_number,
1490: p_ler9_id in number default hr_api.g_number,
1491: p_ler10_id in number default hr_api.g_number,
1492: p_eval_ler_id in number default hr_api.g_number,
1493: p_datetrack_mode in varchar2,
1494: p_validation_start_date in date,

Line 1491: p_ler10_id in number default hr_api.g_number,

1487: p_ler6_id in number default hr_api.g_number,
1488: p_ler7_id in number default hr_api.g_number,
1489: p_ler8_id in number default hr_api.g_number,
1490: p_ler9_id in number default hr_api.g_number,
1491: p_ler10_id in number default hr_api.g_number,
1492: p_eval_ler_id in number default hr_api.g_number,
1493: p_datetrack_mode in varchar2,
1494: p_validation_start_date in date,
1495: p_validation_end_date in date) Is

Line 1492: p_eval_ler_id in number default hr_api.g_number,

1488: p_ler7_id in number default hr_api.g_number,
1489: p_ler8_id in number default hr_api.g_number,
1490: p_ler9_id in number default hr_api.g_number,
1491: p_ler10_id in number default hr_api.g_number,
1492: p_eval_ler_id in number default hr_api.g_number,
1493: p_datetrack_mode in varchar2,
1494: p_validation_start_date in date,
1495: p_validation_end_date in date) Is
1496: --

Line 1506: hr_api.mandatory_arg_error

1502: hr_utility.set_location('Entering:'||l_proc, 5);
1503: --
1504: -- Ensure that the p_datetrack_mode argument is not null
1505: --
1506: hr_api.mandatory_arg_error
1507: (p_api_name => l_proc,
1508: p_argument => 'datetrack_mode',
1509: p_argument_value => p_datetrack_mode);
1510: --

Line 1518: hr_api.mandatory_arg_error

1514: --
1515: --
1516: -- Ensure the arguments are not null
1517: --
1518: hr_api.mandatory_arg_error
1519: (p_api_name => l_proc,
1520: p_argument => 'validation_start_date',
1521: p_argument_value => p_validation_start_date);
1522: --

Line 1523: hr_api.mandatory_arg_error

1519: (p_api_name => l_proc,
1520: p_argument => 'validation_start_date',
1521: p_argument_value => p_validation_start_date);
1522: --
1523: hr_api.mandatory_arg_error
1524: (p_api_name => l_proc,
1525: p_argument => 'validation_end_date',
1526: p_argument_value => p_validation_end_date);
1527: --

Line 1528: If ((nvl(p_ler1_id, hr_api.g_number) <> hr_api.g_number) and

1524: (p_api_name => l_proc,
1525: p_argument => 'validation_end_date',
1526: p_argument_value => p_validation_end_date);
1527: --
1528: If ((nvl(p_ler1_id, hr_api.g_number) <> hr_api.g_number) and
1529: NOT (dt_api.check_min_max_dates
1530: (p_base_table_name => 'ben_ler_f',
1531: p_base_key_column => 'ler_id',
1532: p_base_key_value => p_ler1_id,

Line 1538: If ((nvl(p_ler2_id, hr_api.g_number) <> hr_api.g_number) and

1534: p_to_date => p_validation_end_date))) Then
1535: l_table_name := 'ben_ler_f';
1536: Raise l_integrity_error;
1537: End If;
1538: If ((nvl(p_ler2_id, hr_api.g_number) <> hr_api.g_number) and
1539: NOT (dt_api.check_min_max_dates
1540: (p_base_table_name => 'ben_ler_f',
1541: p_base_key_column => 'ler_id',
1542: p_base_key_value => p_ler2_id,

Line 1548: If ((nvl(p_ler3_id, hr_api.g_number) <> hr_api.g_number) and

1544: p_to_date => p_validation_end_date))) Then
1545: l_table_name := 'ben_ler_f';
1546: Raise l_integrity_error;
1547: End If;
1548: If ((nvl(p_ler3_id, hr_api.g_number) <> hr_api.g_number) and
1549: NOT (dt_api.check_min_max_dates
1550: (p_base_table_name => 'ben_ler_f',
1551: p_base_key_column => 'ler_id',
1552: p_base_key_value => p_ler3_id,

Line 1558: If ((nvl(p_ler4_id, hr_api.g_number) <> hr_api.g_number) and

1554: p_to_date => p_validation_end_date))) Then
1555: l_table_name := 'ben_ler_f';
1556: Raise l_integrity_error;
1557: End If;
1558: If ((nvl(p_ler4_id, hr_api.g_number) <> hr_api.g_number) and
1559: NOT (dt_api.check_min_max_dates
1560: (p_base_table_name => 'ben_ler_f',
1561: p_base_key_column => 'ler_id',
1562: p_base_key_value => p_ler4_id,

Line 1568: If ((nvl(p_ler5_id, hr_api.g_number) <> hr_api.g_number) and

1564: p_to_date => p_validation_end_date))) Then
1565: l_table_name := 'ben_ler_f';
1566: Raise l_integrity_error;
1567: End If;
1568: If ((nvl(p_ler5_id, hr_api.g_number) <> hr_api.g_number) and
1569: NOT (dt_api.check_min_max_dates
1570: (p_base_table_name => 'ben_ler_f',
1571: p_base_key_column => 'ler_id',
1572: p_base_key_value => p_ler5_id,

Line 1578: If ((nvl(p_ler6_id, hr_api.g_number) <> hr_api.g_number) and

1574: p_to_date => p_validation_end_date))) Then
1575: l_table_name := 'ben_ler_f';
1576: Raise l_integrity_error;
1577: End If;
1578: If ((nvl(p_ler6_id, hr_api.g_number) <> hr_api.g_number) and
1579: NOT (dt_api.check_min_max_dates
1580: (p_base_table_name => 'ben_ler_f',
1581: p_base_key_column => 'ler_id',
1582: p_base_key_value => p_ler6_id,

Line 1588: If ((nvl(p_ler7_id, hr_api.g_number) <> hr_api.g_number) and

1584: p_to_date => p_validation_end_date))) Then
1585: l_table_name := 'ben_ler_f';
1586: Raise l_integrity_error;
1587: End If;
1588: If ((nvl(p_ler7_id, hr_api.g_number) <> hr_api.g_number) and
1589: NOT (dt_api.check_min_max_dates
1590: (p_base_table_name => 'ben_ler_f',
1591: p_base_key_column => 'ler_id',
1592: p_base_key_value => p_ler7_id,

Line 1598: If ((nvl(p_ler8_id, hr_api.g_number) <> hr_api.g_number) and

1594: p_to_date => p_validation_end_date))) Then
1595: l_table_name := 'ben_ler_f';
1596: Raise l_integrity_error;
1597: End If;
1598: If ((nvl(p_ler8_id, hr_api.g_number) <> hr_api.g_number) and
1599: NOT (dt_api.check_min_max_dates
1600: (p_base_table_name => 'ben_ler_f',
1601: p_base_key_column => 'ler_id',
1602: p_base_key_value => p_ler8_id,

Line 1608: If ((nvl(p_ler9_id, hr_api.g_number) <> hr_api.g_number) and

1604: p_to_date => p_validation_end_date))) Then
1605: l_table_name := 'ben_ler_f';
1606: Raise l_integrity_error;
1607: End If;
1608: If ((nvl(p_ler9_id, hr_api.g_number) <> hr_api.g_number) and
1609: NOT (dt_api.check_min_max_dates
1610: (p_base_table_name => 'ben_ler_f',
1611: p_base_key_column => 'ler_id',
1612: p_base_key_value => p_ler9_id,

Line 1618: If ((nvl(p_ler10_id, hr_api.g_number) <> hr_api.g_number) and

1614: p_to_date => p_validation_end_date))) Then
1615: l_table_name := 'ben_ler_f';
1616: Raise l_integrity_error;
1617: End If;
1618: If ((nvl(p_ler10_id, hr_api.g_number) <> hr_api.g_number) and
1619: NOT (dt_api.check_min_max_dates
1620: (p_base_table_name => 'ben_ler_f',
1621: p_base_key_column => 'ler_id',
1622: p_base_key_value => p_ler10_id,

Line 1628: If ((nvl(p_eval_ler_id, hr_api.g_number) <> hr_api.g_number) and

1624: p_to_date => p_validation_end_date))) Then
1625: l_table_name := 'ben_ler_f';
1626: Raise l_integrity_error;
1627: End If;
1628: If ((nvl(p_eval_ler_id, hr_api.g_number) <> hr_api.g_number) and
1629: NOT (dt_api.check_min_max_dates
1630: (p_base_table_name => 'ben_ler_f',
1631: p_base_key_column => 'ler_id',
1632: p_base_key_value => p_eval_ler_id,

Line 1712: hr_api.mandatory_arg_error

1708: hr_utility.set_location('Entering:'||l_proc, 5);
1709: --
1710: -- Ensure that the p_datetrack_mode argument is not null
1711: --
1712: hr_api.mandatory_arg_error
1713: (p_api_name => l_proc,
1714: p_argument => 'datetrack_mode',
1715: p_argument_value => p_datetrack_mode);
1716: --

Line 1726: hr_api.mandatory_arg_error

1722: --
1723: --
1724: -- Ensure the arguments are not null
1725: --
1726: hr_api.mandatory_arg_error
1727: (p_api_name => l_proc,
1728: p_argument => 'validation_start_date',
1729: p_argument_value => p_validation_start_date);
1730: --

Line 1731: hr_api.mandatory_arg_error

1727: (p_api_name => l_proc,
1728: p_argument => 'validation_start_date',
1729: p_argument_value => p_validation_start_date);
1730: --
1731: hr_api.mandatory_arg_error
1732: (p_api_name => l_proc,
1733: p_argument => 'validation_end_date',
1734: p_argument_value => p_validation_end_date);
1735: --

Line 1736: hr_api.mandatory_arg_error

1732: (p_api_name => l_proc,
1733: p_argument => 'validation_end_date',
1734: p_argument_value => p_validation_end_date);
1735: --
1736: hr_api.mandatory_arg_error
1737: (p_api_name => l_proc,
1738: p_argument => 'clpse_lf_evt_id',
1739: p_argument_value => p_clpse_lf_evt_id);
1740: --

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

1780: --
1781: -- Call all supporting business operations
1782: --
1783: --
1784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1785: --
1786: chk_clpse_lf_evt_id
1787: (p_clpse_lf_evt_id => p_rec.clpse_lf_evt_id,
1788: p_effective_date => p_effective_date,

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

1923: --
1924: -- Call all supporting business operations
1925: --
1926: --
1927: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1928: --
1929: chk_clpse_lf_evt_id
1930: (p_clpse_lf_evt_id => p_rec.clpse_lf_evt_id,
1931: p_effective_date => p_effective_date,