[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_vrr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_vrbl_rt_rl_id => p_vrbl_rt_rl_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_vrbl_rt_rl_id;
78: --
79: -- ----------------------------------------------------------------------------
125:
126: --
127: Begin
128: --
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: --
131: if p_acty_base_rt_id is not null then
132: open c1;
133: fetch c1 into l_dummy;
138: end if;
139: close c1;
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc, 15);
143: --
144: End chk_vrbl_rt_rl_not_allowed;
145: --
146: -- ----------------------------------------------------------------------------
184: and effective_end_date;
185: --
186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: if p_acty_base_rt_id is not null then
191: open c1;
192: fetch c1 into l_dummy;
197: end if;
198: close c1;
199: end if;
200: --
201: hr_utility.set_location('Leaving:'||l_proc, 15);
202: --
203: End chk_vrbl_rl_rt_profile;
204: --
205: -- ----------------------------------------------------------------------------
254: and ff.effective_end_date;
255: --
256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ben_vrr_shd.api_updating
261: (p_vrbl_rt_rl_id => p_vrbl_rt_rl_id,
262: 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_formula_id;
308: --
309: -- ----------------------------------------------------------------------------
350: and p_effective_date between vrr.effective_start_date and vrr.effective_end_date;
351: --
352: Begin
353: --
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- check if the same variable rate rule is entered more than once
357: -- for the same acty_base_rt_id
358: --
370: end if;
371: --
372: close c_chk_dup_vrbl_rt_rl;
373: --
374: hr_utility.set_location('Leaving:'||l_proc,15);
375: --
376: end chk_dup_vrbl_rt_rl;
377: --
378: -- ----------------------------------------------------------------------------
415: l_integrity_error Exception;
416: l_table_name all_tables.table_name%TYPE;
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Ensure that the p_datetrack_mode argument is not null
422: --
423: hr_api.mandatory_arg_error
464: End If;
465: --
466: End If;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: Exception
470: When l_integrity_error Then
471: --
472: -- A referential integrity check was violated therefore
532: l_rows_exist Exception;
533: l_table_name all_tables.table_name%TYPE;
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Ensure that the p_datetrack_mode argument is not null
539: --
540: hr_api.mandatory_arg_error
569: --
570: --
571: End If;
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: Exception
575: When l_rows_exist Then
576: --
577: -- A referential integrity check was violated therefore
604: --
605: l_proc varchar2(72) := g_package||'insert_validate';
606: --
607: Begin
608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: -- Call all supporting business operations
611: --
612: --
644: p_formula_id => p_rec.formula_id,
645: p_business_group_id => p_rec.business_group_id,
646: p_effective_date => p_effective_date);
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
649: End insert_validate;
650: --
651: -- ----------------------------------------------------------------------------
652: -- |---------------------------< update_validate >----------------------------|
660: --
661: l_proc varchar2(72) := g_package||'update_validate';
662: --
663: Begin
664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: -- Call all supporting business operations
667: --
668: --
703: p_datetrack_mode => p_datetrack_mode,
704: p_validation_start_date => p_validation_start_date,
705: p_validation_end_date => p_validation_end_date);
706: --
707: hr_utility.set_location(' Leaving:'||l_proc, 10);
708: End update_validate;
709: --
710: -- ----------------------------------------------------------------------------
711: -- |---------------------------< delete_validate >----------------------------|
719: --
720: l_proc varchar2(72) := g_package||'delete_validate';
721: --
722: Begin
723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: -- Call all supporting business operations
726: --
727: dt_delete_validate
729: p_validation_start_date => p_validation_start_date,
730: p_validation_end_date => p_validation_end_date,
731: p_vrbl_rt_rl_id => p_rec.vrbl_rt_rl_id);
732: --
733: hr_utility.set_location(' Leaving:'||l_proc, 10);
734: End delete_validate;
735: --
736: --
737: -- ---------------------------------------------------------------------------
756: l_proc varchar2(72) := g_package||'return_legislation_code';
757: --
758: begin
759: --
760: hr_utility.set_location('Entering:'|| l_proc, 10);
761: --
762: -- Ensure that all the mandatory parameter are not null
763: --
764: hr_api.mandatory_arg_error(p_api_name => l_proc,
781: end if;
782: --
783: close csr_leg_code;
784: --
785: hr_utility.set_location(' Leaving:'|| l_proc, 20);
786: --
787: return l_legislation_code;
788: --
789: end return_legislation_code;