[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_pcr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_per_cm_trgr_id => p_per_cm_trgr_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_per_cm_trgr_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
155: End If;
156: --
157: End If;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: Exception
161: When l_integrity_error Then
162: --
163: -- A referential integrity check was violated therefore
221: l_rows_exist Exception;
222: l_table_name all_tables.table_name%TYPE;
223: --
224: Begin
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: -- Ensure that the p_datetrack_mode argument is not null
228: --
229: hr_api.mandatory_arg_error
258: --
259: --
260: End If;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: Exception
264: When l_rows_exist Then
265: --
266: -- A referential integrity check was violated therefore
291: --
292: l_proc varchar2(72) := g_package||'insert_validate';
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Call all supporting business operations
298: --
299: --
303: (p_per_cm_trgr_id => p_rec.per_cm_trgr_id,
304: p_effective_date => p_effective_date,
305: p_object_version_number => p_rec.object_version_number);
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: End insert_validate;
309: --
310: -- ----------------------------------------------------------------------------
311: -- |---------------------------< update_validate >----------------------------|
319: --
320: l_proc varchar2(72) := g_package||'update_validate';
321: --
322: Begin
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: --
325: -- Call all supporting business operations
326: --
327: --
340: p_datetrack_mode => p_datetrack_mode,
341: p_validation_start_date => p_validation_start_date,
342: p_validation_end_date => p_validation_end_date);
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: End update_validate;
346: --
347: -- ----------------------------------------------------------------------------
348: -- |---------------------------< delete_validate >----------------------------|
356: --
357: l_proc varchar2(72) := g_package||'delete_validate';
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: -- Call all supporting business operations
363: --
364: dt_delete_validate
366: p_validation_start_date => p_validation_start_date,
367: p_validation_end_date => p_validation_end_date,
368: p_per_cm_trgr_id => p_rec.per_cm_trgr_id);
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: End delete_validate;
372: --
373: --
374: -- ---------------------------------------------------------------------------
393: l_proc varchar2(72) := g_package||'return_legislation_code';
394: --
395: begin
396: --
397: hr_utility.set_location('Entering:'|| l_proc, 10);
398: --
399: -- Ensure that all the mandatory parameter are not null
400: --
401: hr_api.mandatory_arg_error(p_api_name => l_proc,
418: end if;
419: --
420: close csr_leg_code;
421: --
422: hr_utility.set_location(' Leaving:'|| l_proc, 20);
423: --
424: return l_legislation_code;
425: --
426: end return_legislation_code;