APPS.BEN_CLP_BUS dependencies on BEN_CLP_SHD

Line 102: l_api_updating := ben_clp_shd.api_updating

98: Begin
99: --
100: hr_utility.set_location('Entering:'||l_proc, 5);
101: --
102: l_api_updating := ben_clp_shd.api_updating
103: (p_effective_date => p_effective_date,
104: p_clpse_lf_evt_id => p_clpse_lf_evt_id,
105: p_object_version_number => p_object_version_number);
106: --

Line 109: <> ben_clp_shd.g_old_rec.clpse_lf_evt_id) then

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: --
113: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');

Line 113: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');

109: <> ben_clp_shd.g_old_rec.clpse_lf_evt_id) then
110: --
111: -- raise error as PK has changed
112: --
113: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');
114: --
115: elsif not l_api_updating then
116: --
117: -- check if PK is null

Line 123: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');

119: if p_clpse_lf_evt_id is not null then
120: --
121: -- raise error as PK is not null
122: --
123: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');
124: --
125: end if;
126: --
127: end if;

Line 189: l_api_updating := ben_clp_shd.api_updating

185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_clp_shd.api_updating
190: (p_effective_date => p_effective_date,
191: p_clpse_lf_evt_id => p_clpse_lf_evt_id,
192: p_object_version_number => p_object_version_number);
193: --

Line 196: <> ben_clp_shd.g_old_rec.seq)

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

Line 258: l_api_updating := ben_clp_shd.api_updating

254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: l_api_updating := ben_clp_shd.api_updating
259: (p_effective_date => p_effective_date,
260: p_clpse_lf_evt_id => p_clpse_lf_evt_id,
261: p_object_version_number => p_object_version_number);
262: --

Line 448: l_api_updating := ben_clp_shd.api_updating

444: Begin
445: --
446: hr_utility.set_location('Entering:'||l_proc, 5);
447: --
448: l_api_updating := ben_clp_shd.api_updating
449: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
450: p_effective_date => p_effective_date,
451: p_object_version_number => p_object_version_number);
452: --

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 661: l_api_updating := ben_clp_shd.api_updating

657: Begin
658: --
659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: l_api_updating := ben_clp_shd.api_updating
662: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
663: p_effective_date => p_effective_date,
664: p_object_version_number => p_object_version_number);
665: --

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 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 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 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 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 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 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 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 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 926: l_api_updating := ben_clp_shd.api_updating

922: Begin
923: --
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: l_api_updating := ben_clp_shd.api_updating
927: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
928: p_effective_date => p_effective_date,
929: p_object_version_number => p_object_version_number);
930: --

Line 933: <> ben_clp_shd.g_old_rec.eval_rl

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: --
937: -- check if value of formula rule is valid.

Line 999: l_api_updating := ben_clp_shd.api_updating

995: Begin
996: --
997: hr_utility.set_location('Entering:'||l_proc, 5);
998: --
999: l_api_updating := ben_clp_shd.api_updating
1000: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
1001: p_effective_date => p_effective_date,
1002: p_object_version_number => p_object_version_number);
1003: --

Line 1006: <> ben_clp_shd.g_old_rec.eval_ler_det_rl

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: --
1010: -- check if value of formula rule is valid.

Line 1350: l_api_updating := ben_clp_shd.api_updating

1346: Begin
1347: --
1348: hr_utility.set_location('Entering:'||l_proc, 5);
1349: --
1350: l_api_updating := ben_clp_shd.api_updating
1351: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
1352: p_effective_date => p_effective_date,
1353: p_object_version_number => p_object_version_number);
1354: --

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 1421: l_api_updating := ben_clp_shd.api_updating

1417: Begin
1418: --
1419: hr_utility.set_location('Entering:'||l_proc, 5);
1420: --
1421: l_api_updating := ben_clp_shd.api_updating
1422: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
1423: p_effective_date => p_effective_date,
1424: p_object_version_number => p_object_version_number);
1425: --

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 1770: (p_rec in ben_clp_shd.g_rec_type,

1766: -- ----------------------------------------------------------------------------
1767: -- |---------------------------< insert_validate >----------------------------|
1768: -- ----------------------------------------------------------------------------
1769: Procedure insert_validate
1770: (p_rec in ben_clp_shd.g_rec_type,
1771: p_effective_date in date,
1772: p_datetrack_mode in varchar2,
1773: p_validation_start_date in date,
1774: p_validation_end_date in date) is

Line 1913: (p_rec in ben_clp_shd.g_rec_type,

1909: -- ----------------------------------------------------------------------------
1910: -- |---------------------------< update_validate >----------------------------|
1911: -- ----------------------------------------------------------------------------
1912: Procedure update_validate
1913: (p_rec in ben_clp_shd.g_rec_type,
1914: p_effective_date in date,
1915: p_datetrack_mode in varchar2,
1916: p_validation_start_date in date,
1917: p_validation_end_date in date) is

Line 2074: (p_rec in ben_clp_shd.g_rec_type,

2070: -- ----------------------------------------------------------------------------
2071: -- |---------------------------< delete_validate >----------------------------|
2072: -- ----------------------------------------------------------------------------
2073: Procedure delete_validate
2074: (p_rec in ben_clp_shd.g_rec_type,
2075: p_effective_date in date,
2076: p_datetrack_mode in varchar2,
2077: p_validation_start_date in date,
2078: p_validation_end_date in date) is