[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_apl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_acty_rt_ptd_lmt_id => p_acty_rt_ptd_lmt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_acty_rt_ptd_lmt_id;
78: --
79: -- ----------------------------------------------------------------------------
116: l_integrity_error Exception;
117: l_table_name all_tables.table_name%TYPE;
118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: -- Ensure that the p_datetrack_mode argument is not null
123: --
124: hr_api.mandatory_arg_error
166: End If;
167: --
168: End If;
169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When l_integrity_error Then
173: --
174: -- A referential integrity check was violated therefore
231: l_rows_exist Exception;
232: l_table_name all_tables.table_name%TYPE;
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: -- Ensure that the p_datetrack_mode argument is not null
238: --
239: hr_api.mandatory_arg_error
268: --
269: --
270: End If;
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 10);
273: Exception
274: When l_rows_exist Then
275: --
276: -- A referential integrity check was violated therefore
303: --
304: l_proc varchar2(72) := g_package||'insert_validate';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- Call all supporting business operations
310: --
311: --
315: (p_acty_rt_ptd_lmt_id => p_rec.acty_rt_ptd_lmt_id,
316: p_effective_date => p_effective_date,
317: p_object_version_number => p_rec.object_version_number);
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);
320: End insert_validate;
321: --
322: -- ----------------------------------------------------------------------------
323: -- |---------------------------< update_validate >----------------------------|
331: --
332: l_proc varchar2(72) := g_package||'update_validate';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- Call all supporting business operations
338: --
339: --
352: p_datetrack_mode => p_datetrack_mode,
353: p_validation_start_date => p_validation_start_date,
354: p_validation_end_date => p_validation_end_date);
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: End update_validate;
358: --
359: -- ----------------------------------------------------------------------------
360: -- |---------------------------< delete_validate >----------------------------|
368: --
369: l_proc varchar2(72) := g_package||'delete_validate';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- Call all supporting business operations
375: --
376: dt_delete_validate
378: p_validation_start_date => p_validation_start_date,
379: p_validation_end_date => p_validation_end_date,
380: p_acty_rt_ptd_lmt_id => p_rec.acty_rt_ptd_lmt_id);
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 10);
383: End delete_validate;
384: --
385: --
386: -- ---------------------------------------------------------------------------
405: l_proc varchar2(72) := g_package||'return_legislation_code';
406: --
407: begin
408: --
409: hr_utility.set_location('Entering:'|| l_proc, 10);
410: --
411: -- Ensure that all the mandatory parameter are not null
412: --
413: hr_api.mandatory_arg_error(p_api_name => l_proc,
430: end if;
431: --
432: close csr_leg_code;
433: --
434: hr_utility.set_location(' Leaving:'|| l_proc, 20);
435: --
436: return l_legislation_code;
437: --
438: end return_legislation_code;