[Home] [Help]
42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_ads_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_acty_rt_ded_sched_id => p_acty_rt_ded_sched_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_acty_rt_ded_sched_id;
78: --
79: -- ----------------------------------------------------------------------------
117: where a.ded_sched_py_freq_id = p_ded_sched_py_freq_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_ads_shd.api_updating
124: (p_acty_rt_ded_sched_id => p_acty_rt_ded_sched_id,
125: p_effective_date => p_effective_date,
151: end if;
152: --
153: end if;
154: --
155: hr_utility.set_location('Leaving:'||l_proc,10);
156: --
157: End chk_ded_sched_py_freq_id;
158: --
159: -- ----------------------------------------------------------------------------
191: l_api_updating boolean;
192: --
193: Begin
194: --
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: l_api_updating := ben_ads_shd.api_updating
198: (p_acty_rt_ded_sched_id => p_acty_rt_ded_sched_id,
199: p_effective_date => p_effective_date,
220: end if;
221: --
222: end if;
223: --
224: hr_utility.set_location('Leaving:'||l_proc,10);
225: --
226: end chk_ded_sched_cd;
227: --
228: -- ----------------------------------------------------------------------------
277: and ff.effective_end_date;
278: --
279: Begin
280: --
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: l_api_updating := ben_ads_shd.api_updating
284: (p_acty_rt_ded_sched_id => p_acty_rt_ded_sched_id,
285: p_effective_date => p_effective_date,
315: close c1;
316: --
317: end if;
318: --
319: hr_utility.set_location('Leaving:'||l_proc,10);
320: --
321: end chk_ded_sched_rl;
322: --
323: -- ----------------------------------------------------------------------------
355: where a.acty_rt_ded_sched_id = p_acty_rt_ded_sched_id;
356: --
357: Begin
358: --
359: hr_utility.set_location('Entering:'||l_proc,5);
360: --
361: -- check if child rows exist in ben_ded_sched_py_freq
362: --
363: open c1;
377: --
378: Return(false);
379: End if;
380: --
381: hr_utility.set_location('Leaving:'||l_proc,10);
382: --
383: End chk_dsq_rows_exist;
384: --
385: -- ----------------------------------------------------------------------------
421: l_integrity_error Exception;
422: l_table_name all_tables.table_name%TYPE;
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: -- Ensure that the p_datetrack_mode argument is not null
428: --
429: hr_api.mandatory_arg_error
460: End If;
461: --
462: End If;
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 10);
465: Exception
466: When l_integrity_error Then
467: --
468: -- A referential integrity check was violated therefore
526: l_rows_exist Exception;
527: l_table_name all_tables.table_name%TYPE;
528: --
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 5);
531: --
532: -- Ensure that the p_datetrack_mode argument is not null
533: --
534: hr_api.mandatory_arg_error
570: --
571: --
572: End If;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: Exception
576: When l_rows_exist Then
577: --
578: -- A referential integrity check was violated therefore
603: --
604: l_proc varchar2(72) := g_package||'insert_validate';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: -- Call all supporting business operations
610: --
611: --
634: p_business_group_id => p_rec.business_group_id,
635: p_effective_date => p_effective_date,
636: p_object_version_number => p_rec.object_version_number);
637: --
638: hr_utility.set_location(' Leaving:'||l_proc, 10);
639: End insert_validate;
640: --
641: -- ----------------------------------------------------------------------------
642: -- |---------------------------< update_validate >----------------------------|
650: --
651: l_proc varchar2(72) := g_package||'update_validate';
652: --
653: Begin
654: hr_utility.set_location('Entering:'||l_proc, 5);
655: --
656: -- Call all supporting business operations
657: --
658: --
689: p_datetrack_mode => p_datetrack_mode,
690: p_validation_start_date => p_validation_start_date,
691: p_validation_end_date => p_validation_end_date);
692: --
693: hr_utility.set_location(' Leaving:'||l_proc, 10);
694: End update_validate;
695: --
696: -- ----------------------------------------------------------------------------
697: -- |---------------------------< delete_validate >----------------------------|
705: --
706: l_proc varchar2(72) := g_package||'delete_validate';
707: --
708: Begin
709: hr_utility.set_location('Entering:'||l_proc, 5);
710: --
711: -- Call all supporting business operations
712: --
713: dt_delete_validate
715: p_validation_start_date => p_validation_start_date,
716: p_validation_end_date => p_validation_end_date,
717: p_acty_rt_ded_sched_id => p_rec.acty_rt_ded_sched_id);
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 10);
720: End delete_validate;
721: --
722: --
723: -- ---------------------------------------------------------------------------
742: l_proc varchar2(72) := g_package||'return_legislation_code';
743: --
744: begin
745: --
746: hr_utility.set_location('Entering:'|| l_proc, 10);
747: --
748: -- Ensure that all the mandatory parameter are not null
749: --
750: hr_api.mandatory_arg_error(p_api_name => l_proc,
767: end if;
768: --
769: close csr_leg_code;
770: --
771: hr_utility.set_location(' Leaving:'|| l_proc, 20);
772: --
773: return l_legislation_code;
774: --
775: end return_legislation_code;