[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_cpc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cntnu_prtn_ctfn_typ_id => p_cntnu_prtn_ctfn_typ_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_cntnu_prtn_ctfn_typ_id;
78: --
79: -- ----------------------------------------------------------------------------
111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_cpc_shd.api_updating
118: (p_cntnu_prtn_ctfn_typ_id => p_cntnu_prtn_ctfn_typ_id,
119: p_effective_date => p_effective_date,
142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_prtn_ctfn_typ_cd;
149: --
150: -- ----------------------------------------------------------------------------
183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_cpc_shd.api_updating
190: (p_cntnu_prtn_ctfn_typ_id => p_cntnu_prtn_ctfn_typ_id,
191: p_effective_date => p_effective_date,
214: end if;
215: --
216: end if;
217: --
218: hr_utility.set_location('Leaving:'||l_proc,10);
219: --
220: end chk_ctfn_rqd_when_rl;
221: --
222: -- ----------------------------------------------------------------------------
254: l_api_updating boolean;
255: --
256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ben_cpc_shd.api_updating
261: (p_cntnu_prtn_ctfn_typ_id => p_cntnu_prtn_ctfn_typ_id,
262: p_effective_date => p_effective_date,
285: end if;
286: --
287: end if;
288: --
289: hr_utility.set_location('Leaving:'||l_proc,10);
290: --
291: end chk_lack_ctfn_sspnd_elig_flag;
292: --
293: -- ----------------------------------------------------------------------------
325: l_api_updating boolean;
326: --
327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: l_api_updating := ben_cpc_shd.api_updating
332: (p_cntnu_prtn_ctfn_typ_id => p_cntnu_prtn_ctfn_typ_id,
333: p_effective_date => p_effective_date,
356: end if;
357: --
358: end if;
359: --
360: hr_utility.set_location('Leaving:'||l_proc,10);
361: --
362: end chk_pfd_flag;
363: --
364: -- ----------------------------------------------------------------------------
400: l_integrity_error Exception;
401: l_table_name all_tables.table_name%TYPE;
402: --
403: Begin
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: -- Ensure that the p_datetrack_mode argument is not null
407: --
408: hr_api.mandatory_arg_error
439: End If;
440: --
441: End If;
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 10);
444: Exception
445: When l_integrity_error Then
446: --
447: -- A referential integrity check was violated therefore
506: l_rows_exist Exception;
507: l_table_name all_tables.table_name%TYPE;
508: --
509: Begin
510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512: -- Ensure that the p_datetrack_mode argument is not null
513: --
514: hr_api.mandatory_arg_error
543: --
544: --
545: End If;
546: --
547: hr_utility.set_location(' Leaving:'||l_proc, 10);
548: Exception
549: When l_rows_exist Then
550: --
551: -- A referential integrity check was violated therefore
577: --
578: l_proc varchar2(72) := g_package||'insert_validate';
579: --
580: Begin
581: hr_utility.set_location('Entering:'||l_proc, 5);
582: --
583: -- Call all supporting business operations
584: --
585: --
614: p_pfd_flag => p_rec.pfd_flag,
615: p_effective_date => p_effective_date,
616: p_object_version_number => p_rec.object_version_number);
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 10);
619: End insert_validate;
620: --
621: -- ----------------------------------------------------------------------------
622: -- |---------------------------< update_validate >----------------------------|
630: --
631: l_proc varchar2(72) := g_package||'update_validate';
632: --
633: Begin
634: hr_utility.set_location('Entering:'||l_proc, 5);
635: --
636: -- Call all supporting business operations
637: --
638: --
675: p_datetrack_mode => p_datetrack_mode,
676: p_validation_start_date => p_validation_start_date,
677: p_validation_end_date => p_validation_end_date);
678: --
679: hr_utility.set_location(' Leaving:'||l_proc, 10);
680: End update_validate;
681: --
682: -- ----------------------------------------------------------------------------
683: -- |---------------------------< delete_validate >----------------------------|
691: --
692: l_proc varchar2(72) := g_package||'delete_validate';
693: --
694: Begin
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --
697: -- Call all supporting business operations
698: --
699: dt_delete_validate
701: p_validation_start_date => p_validation_start_date,
702: p_validation_end_date => p_validation_end_date,
703: p_cntnu_prtn_ctfn_typ_id => p_rec.cntnu_prtn_ctfn_typ_id);
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: End delete_validate;
707: --
708: --
709: -- ---------------------------------------------------------------------------
728: l_proc varchar2(72) := g_package||'return_legislation_code';
729: --
730: begin
731: --
732: hr_utility.set_location('Entering:'|| l_proc, 10);
733: --
734: -- Ensure that all the mandatory parameter are not null
735: --
736: hr_api.mandatory_arg_error(p_api_name => l_proc,
753: end if;
754: --
755: close csr_leg_code;
756: --
757: hr_utility.set_location(' Leaving:'|| l_proc, 20);
758: --
759: return l_legislation_code;
760: --
761: end return_legislation_code;