[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_pcu_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_per_cm_usg_id => p_per_cm_usg_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_per_cm_usg_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
165: End If;
166: --
167: End If;
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: Exception
171: When l_integrity_error Then
172: --
173: -- 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
301: --
302: l_proc varchar2(72) := g_package||'insert_validate';
303: --
304: Begin
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: -- Call all supporting business operations
308: --
309: --
313: (p_per_cm_usg_id => p_rec.per_cm_usg_id,
314: p_effective_date => p_effective_date,
315: p_object_version_number => p_rec.object_version_number);
316: --
317: hr_utility.set_location(' Leaving:'||l_proc, 10);
318: End insert_validate;
319: --
320: -- ----------------------------------------------------------------------------
321: -- |---------------------------< update_validate >----------------------------|
329: --
330: l_proc varchar2(72) := g_package||'update_validate';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call all supporting business operations
336: --
337: --
350: p_datetrack_mode => p_datetrack_mode,
351: p_validation_start_date => p_validation_start_date,
352: p_validation_end_date => p_validation_end_date);
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: End update_validate;
356: --
357: -- ----------------------------------------------------------------------------
358: -- |---------------------------< delete_validate >----------------------------|
366: --
367: l_proc varchar2(72) := g_package||'delete_validate';
368: --
369: Begin
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: -- Call all supporting business operations
373: --
374: dt_delete_validate
376: p_validation_start_date => p_validation_start_date,
377: p_validation_end_date => p_validation_end_date,
378: p_per_cm_usg_id => p_rec.per_cm_usg_id);
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: End delete_validate;
382: --
383: --
384: -- ---------------------------------------------------------------------------
403: l_proc varchar2(72) := g_package||'return_legislation_code';
404: --
405: begin
406: --
407: hr_utility.set_location('Entering:'|| l_proc, 10);
408: --
409: -- Ensure that all the mandatory parameter are not null
410: --
411: hr_api.mandatory_arg_error(p_api_name => l_proc,
428: end if;
429: --
430: close csr_leg_code;
431: --
432: hr_utility.set_location(' Leaving:'|| l_proc, 20);
433: --
434: return l_legislation_code;
435: --
436: end return_legislation_code;