40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_bei_shd.api_updating
47: (p_batch_elig_id => p_batch_elig_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_batch_elig_id;
75: --
76: -- ----------------------------------------------------------------------------
117: and a.effective_end_date;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_bei_shd.api_updating
124: (p_batch_elig_id => p_batch_elig_id,
125: p_object_version_number => p_object_version_number);
149: close c1;
150: --
151: end if;
152: --
153: hr_utility.set_location('Leaving:'||l_proc,10);
154: --
155: End chk_oipl_id;
156: --
157: -- ----------------------------------------------------------------------------
198: and a.effective_end_date;
199: --
200: Begin
201: --
202: hr_utility.set_location('Entering:'||l_proc,5);
203: --
204: l_api_updating := ben_bei_shd.api_updating
205: (p_batch_elig_id => p_batch_elig_id,
206: p_object_version_number => p_object_version_number);
230: close c1;
231: --
232: end if;
233: --
234: hr_utility.set_location('Leaving:'||l_proc,10);
235: --
236: End chk_pl_id;
237: --
238: -- ----------------------------------------------------------------------------
279: and a.effective_end_date;
280: --
281: Begin
282: --
283: hr_utility.set_location('Entering:'||l_proc,5);
284: --
285: l_api_updating := ben_bei_shd.api_updating
286: (p_batch_elig_id => p_batch_elig_id,
287: p_object_version_number => p_object_version_number);
311: close c1;
312: --
313: end if;
314: --
315: hr_utility.set_location('Leaving:'||l_proc,10);
316: --
317: End chk_pgm_id;
318: --
319: -- ----------------------------------------------------------------------------
360: and a.effective_end_date;
361: --
362: Begin
363: --
364: hr_utility.set_location('Entering:'||l_proc,5);
365: --
366: l_api_updating := ben_bei_shd.api_updating
367: (p_batch_elig_id => p_batch_elig_id,
368: p_object_version_number => p_object_version_number);
391: close c1;
392: --
393: end if;
394: --
395: hr_utility.set_location('Leaving:'||l_proc,10);
396: --
397: End chk_person_id;
398: --
399: -- ----------------------------------------------------------------------------
435: where a.benefit_action_id = p_benefit_action_id;
436: --
437: Begin
438: --
439: hr_utility.set_location('Entering:'||l_proc,5);
440: --
441: l_api_updating := ben_bei_shd.api_updating
442: (p_batch_elig_id => p_batch_elig_id,
443: p_object_version_number => p_object_version_number);
466: close c1;
467: --
468: end if;
469: --
470: hr_utility.set_location('Leaving:'||l_proc,10);
471: --
472: End chk_benefit_action_id;
473: --
474: -- ----------------------------------------------------------------------------
506: l_api_updating boolean;
507: --
508: Begin
509: --
510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512: l_api_updating := ben_bei_shd.api_updating
513: (p_batch_elig_id => p_batch_elig_id,
514: p_object_version_number => p_object_version_number);
536: end if;
537: --
538: end if;
539: --
540: hr_utility.set_location('Leaving:'||l_proc,10);
541: --
542: end chk_elig_flag;
543: --
544: -- ----------------------------------------------------------------------------
549: --
550: l_proc varchar2(72) := g_package||'insert_validate';
551: --
552: Begin
553: hr_utility.set_location('Entering:'||l_proc, 5);
554: --
555: -- Call all supporting business operations
556: --
557: --
595: p_elig_flag => p_rec.elig_flag,
596: p_effective_date => p_effective_date,
597: p_object_version_number => p_rec.object_version_number);
598: --
599: hr_utility.set_location(' Leaving:'||l_proc, 10);
600: End insert_validate;
601: --
602: -- ----------------------------------------------------------------------------
603: -- |---------------------------< update_validate >----------------------------|
607: --
608: l_proc varchar2(72) := g_package||'update_validate';
609: --
610: Begin
611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Call all supporting business operations
614: --
615: --
653: p_elig_flag => p_rec.elig_flag,
654: p_effective_date => p_effective_date,
655: p_object_version_number => p_rec.object_version_number);
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: End update_validate;
659: --
660: -- ----------------------------------------------------------------------------
661: -- |---------------------------< delete_validate >----------------------------|
665: --
666: l_proc varchar2(72) := g_package||'delete_validate';
667: --
668: Begin
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: End delete_validate;
675: --
676: --
677: -- ---------------------------------------------------------------------------
696: l_proc varchar2(72) := g_package||'return_legislation_code';
697: --
698: begin
699: --
700: hr_utility.set_location('Entering:'|| l_proc, 10);
701: --
702: -- Ensure that all the mandatory parameter are not null
703: --
704: hr_api.mandatory_arg_error(p_api_name => l_proc,
714: close csr_leg_code;
715: --
716: -- The primary key is invalid therefore we must error
717: --
718: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
719: hr_utility.raise_error;
720: --
721: end if;
722: --
715: --
716: -- The primary key is invalid therefore we must error
717: --
718: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
719: hr_utility.raise_error;
720: --
721: end if;
722: --
723: close csr_leg_code;
721: end if;
722: --
723: close csr_leg_code;
724: --
725: hr_utility.set_location(' Leaving:'|| l_proc, 20);
726: --
727: return l_legislation_code;
728: --
729: end return_legislation_code;