40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_xre_shd.api_updating
47: (p_ext_rslt_err_id => p_ext_rslt_err_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_ext_rslt_err_id;
75: --
76: -- ----------------------------------------------------------------------------
117: and a.effective_end_date;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_xre_shd.api_updating
124: (p_ext_rslt_err_id => p_ext_rslt_err_id,
125: p_object_version_number => p_object_version_number);
148: close c1;
149: --
150: end if;
151: --
152: hr_utility.set_location('Leaving:'||l_proc,10);
153: --
154: End chk_person_id;
155: --
156: -- ----------------------------------------------------------------------------
188: l_api_updating boolean;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: l_api_updating := ben_xre_shd.api_updating
195: (p_ext_rslt_err_id => p_ext_rslt_err_id,
196: p_object_version_number => p_object_version_number);
218: end if;
219: --
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc,10);
223: --
224: end chk_typ_cd;
225: --
226: -- ---------------------------------------------------------------------------
262: where a.ext_rslt_id = p_ext_rslt_id;
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: if p_ext_rslt_id is not null then
269: l_api_updating := ben_xre_shd.api_updating
270: (p_ext_rslt_err_id => p_ext_rslt_err_id,
295: end if;
296: --
297: end if;
298: --
299: hr_utility.set_location('Leaving:'||l_proc, 10);
300: --
301: End chk_ext_rslt_id;
302: --
303: -- ----------------------------------------------------------------------------
308: --
309: l_proc varchar2(72) := g_package||'insert_validate';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: -- Call all supporting business operations
315: --
316: --
330: (p_ext_rslt_err_id => p_rec.ext_rslt_err_id,
331: p_ext_rslt_id => p_rec.ext_rslt_id,
332: p_object_version_number => p_rec.object_version_number);
333: --
334: hr_utility.set_location(' Leaving:'||l_proc, 10);
335: End insert_validate;
336: --
337: -- ----------------------------------------------------------------------------
338: -- |---------------------------< update_validate >----------------------------|
342: --
343: l_proc varchar2(72) := g_package||'update_validate';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Call all supporting business operations
349: --
350: --
364: (p_ext_rslt_err_id => p_rec.ext_rslt_err_id,
365: p_ext_rslt_id => p_rec.ext_rslt_id,
366: p_object_version_number => p_rec.object_version_number);
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 10);
369: End update_validate;
370: --
371: -- ----------------------------------------------------------------------------
372: -- |---------------------------< delete_validate >----------------------------|
376: --
377: l_proc varchar2(72) := g_package||'delete_validate';
378: --
379: Begin
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: -- Call all supporting business operations
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: -- Call all supporting business operations
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 10);
385: End delete_validate;
386: --
387: --
388: -- ---------------------------------------------------------------------------
407: l_proc varchar2(72) := g_package||'return_legislation_code';
408: --
409: begin
410: --
411: hr_utility.set_location('Entering:'|| l_proc, 10);
412: --
413: -- Ensure that all the mandatory parameter are not null
414: --
415: hr_api.mandatory_arg_error(p_api_name => l_proc,
432: end if;
433: --
434: close csr_leg_code;
435: --
436: hr_utility.set_location(' Leaving:'|| l_proc, 20);
437: --
438: return l_legislation_code;
439: --
440: end return_legislation_code;