[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_prb_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_regy_bod_id => p_pl_regy_bod_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_pl_regy_bod_id;
78: --
79: -- ----------------------------------------------------------------------------
117: where a.rptg_grp_id = p_rptg_grp_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_prb_shd.api_updating
124: (p_pl_regy_bod_id => p_pl_regy_bod_id,
125: p_effective_date => p_effective_date,
150: close c1;
151: --
152: end if;
153: --
154: hr_utility.set_location('Leaving:'||l_proc,10);
155: --
156: End chk_rptg_grp_id;
157: --
158: -- ----------------------------------------------------------------------------
199: and nvl(bnr.business_group_id,p_business_group_id) <> p_business_group_id ;
200: --
201: Begin
202: --
203: hr_utility.set_location('Entering:'||l_proc,5);
204: --
205: -- check if rptg_grp_id value exists in ben_rptg_grp table
206: --
207: open c1;
219: --
220: close c1;
221: --
222: --
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: End chk_parent_rec_exists;
226: --
227:
267: where a.organization_id = p_organization_id;
268: --
269: Begin
270: --
271: hr_utility.set_location('Entering:'||l_proc,5);
272: --
273: l_api_updating := ben_prb_shd.api_updating
274: (p_pl_regy_bod_id => p_pl_regy_bod_id,
275: p_effective_date => p_effective_date,
301: close c1;
302: --
303: end if;
304: --
305: hr_utility.set_location('Leaving:'||l_proc,10);
306: --
307: End chk_organization_id;
308: --
309: --
342: l_api_updating boolean;
343: --
344: Begin
345: --
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: l_api_updating := ben_prb_shd.api_updating
349: (p_pl_regy_bod_id => p_pl_regy_bod_id,
350: p_effective_date => p_effective_date,
371: end if;
372: --
373: end if;
374: --
375: hr_utility.set_location('Leaving:'||l_proc,10);
376: --
377: end chk_quald_flag;
378: --
379: -- ----------------------------------------------------------------------------
410: where a.pl_regy_bod_id = p_pl_regy_bod_id;
411: --
412: Begin
413: --
414: hr_utility.set_location('Entering:'||l_proc,5);
415: --
416: -- check if child rows exists in ben_pl_regy_prps.
417: --
418: open c1;
436: end if;
437: --
438: close c1;
439: --
440: hr_utility.set_location('Leaving:'||l_proc,10);
441: --
442: end prp_rows_exists;
443: -- ----------------------------------------------------------------------------
444: -- |--------------------------< dt_update_validate >--------------------------|
479: l_integrity_error Exception;
480: l_table_name all_tables.table_name%TYPE;
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: --
485: -- Ensure that the p_datetrack_mode argument is not null
486: --
487: hr_api.mandatory_arg_error
518: End If;
519: --
520: End If;
521: --
522: hr_utility.set_location(' Leaving:'||l_proc, 10);
523: Exception
524: When l_integrity_error Then
525: --
526: -- A referential integrity check was violated therefore
585: l_rows_exist Exception;
586: l_table_name all_tables.table_name%TYPE;
587: --
588: Begin
589: hr_utility.set_location('Entering:'||l_proc, 5);
590: --
591: -- Ensure that the p_datetrack_mode argument is not null
592: --
593: hr_api.mandatory_arg_error
626: --
627: --
628: End If;
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 10);
631: Exception
632: When l_rows_exist Then
633: --
634: -- A referential integrity check was violated therefore
661: --
662: l_proc varchar2(72) := g_package||'insert_validate';
663: --
664: Begin
665: hr_utility.set_location('Entering:'||l_proc, 5);
666: --
667: -- Call all supporting business operations
668: --
669: -- CWB Changes
701: p_business_group_id => p_rec.business_group_id,
702: p_effective_date => p_effective_date,
703: p_object_version_number => p_rec.object_version_number);
704:
705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: End insert_validate;
707: --
708: -- ----------------------------------------------------------------------------
709: -- |---------------------------< update_validate >----------------------------|
717: --
718: l_proc varchar2(72) := g_package||'update_validate';
719: --
720: Begin
721: hr_utility.set_location('Entering:'||l_proc, 5);
722: --
723: -- Call all supporting business operations
724: --
725: -- CWB Changes
766: p_business_group_id => p_rec.business_group_id,
767: p_effective_date => p_effective_date,
768: p_object_version_number => p_rec.object_version_number);
769: --
770: hr_utility.set_location(' Leaving:'||l_proc, 10);
771: End update_validate;
772: --
773: -- ----------------------------------------------------------------------------
774: -- |---------------------------< delete_validate >----------------------------|
782: --
783: l_proc varchar2(72) := g_package||'delete_validate';
784: --
785: Begin
786: hr_utility.set_location('Entering:'||l_proc, 5);
787: --
788: -- Call all supporting business operations
789: --
790: dt_delete_validate
792: p_validation_start_date => p_validation_start_date,
793: p_validation_end_date => p_validation_end_date,
794: p_pl_regy_bod_id => p_rec.pl_regy_bod_id);
795: --
796: hr_utility.set_location(' Leaving:'||l_proc, 10);
797: End delete_validate;
798: --
799: -- ---------------------------------------------------------------------------
800: -- |---------------------< return_legislation_code >-------------------------|
818: l_proc varchar2(72) := g_package||'return_legislation_code';
819: --
820: begin
821: --
822: hr_utility.set_location('Entering:'|| l_proc, 10);
823: --
824: -- Ensure that all the mandatory parameter are not null
825: --
826: hr_api.mandatory_arg_error(p_api_name => l_proc,
845: */
846: --
847: close csr_leg_code;
848: --
849: hr_utility.set_location(' Leaving:'|| l_proc, 20);
850: --
851: return l_legislation_code;
852: --
853: end return_legislation_code;