[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_lou_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_chg_oipl_enrt_rl_id => p_ler_chg_oipl_enrt_rl_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ler_chg_oipl_enrt_rl_id;
78: --
79: -- ----------------------------------------------------------------------------
128: and ff.effective_end_date;
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_lou_shd.api_updating
135: (p_ler_chg_oipl_enrt_rl_id => p_ler_chg_oipl_enrt_rl_id,
136: p_effective_date => p_effective_date,
165: close c1;
166: --
167: end if;
168: --
169: hr_utility.set_location('Leaving:'||l_proc,10);
170: --
171: end chk_formula_id;
172: --
173: -- ----------------------------------------------------------------------------
209: l_integrity_error Exception;
210: l_table_name all_tables.table_name%TYPE;
211: --
212: Begin
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- Ensure that the p_datetrack_mode argument is not null
216: --
217: hr_api.mandatory_arg_error
248: End If;
249: --
250: End If;
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: Exception
254: When l_integrity_error Then
255: --
256: -- A referential integrity check was violated therefore
314: l_rows_exist Exception;
315: l_table_name all_tables.table_name%TYPE;
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- Ensure that the p_datetrack_mode argument is not null
321: --
322: hr_api.mandatory_arg_error
351: --
352: --
353: End If;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 10);
356: Exception
357: When l_rows_exist Then
358: --
359: -- A referential integrity check was violated therefore
384: --
385: l_proc varchar2(72) := g_package||'insert_validate';
386: --
387: Begin
388: hr_utility.set_location('Entering:'||l_proc, 5);
389: --
390: -- Call all supporting business operations
391: --
392: --
403: p_business_group_id => p_rec.business_group_id,
404: p_effective_date => p_effective_date,
405: p_object_version_number => p_rec.object_version_number);
406: --
407: hr_utility.set_location(' Leaving:'||l_proc, 10);
408: End insert_validate;
409: --
410: -- ----------------------------------------------------------------------------
411: -- |---------------------------< update_validate >----------------------------|
419: --
420: l_proc varchar2(72) := g_package||'update_validate';
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: -- Call all supporting business operations
426: --
427: --
446: p_datetrack_mode => p_datetrack_mode,
447: p_validation_start_date => p_validation_start_date,
448: p_validation_end_date => p_validation_end_date);
449: --
450: hr_utility.set_location(' Leaving:'||l_proc, 10);
451: End update_validate;
452: --
453: -- ----------------------------------------------------------------------------
454: -- |---------------------------< delete_validate >----------------------------|
462: --
463: l_proc varchar2(72) := g_package||'delete_validate';
464: --
465: Begin
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: -- Call all supporting business operations
469: --
470: dt_delete_validate
472: p_validation_start_date => p_validation_start_date,
473: p_validation_end_date => p_validation_end_date,
474: p_ler_chg_oipl_enrt_rl_id => p_rec.ler_chg_oipl_enrt_rl_id);
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 10);
477: End delete_validate;
478: --
479: --
480: -- ---------------------------------------------------------------------------
499: l_proc varchar2(72) := g_package||'return_legislation_code';
500: --
501: begin
502: --
503: hr_utility.set_location('Entering:'|| l_proc, 10);
504: --
505: -- Ensure that all the mandatory parameter are not null
506: --
507: hr_api.mandatory_arg_error(p_api_name => l_proc,
524: end if;
525: --
526: close csr_leg_code;
527: --
528: hr_utility.set_location(' Leaving:'|| l_proc, 20);
529: --
530: return l_legislation_code;
531: --
532: end return_legislation_code;