[Home] [Help]
40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_crp_shd.api_updating
47: (p_cbr_per_in_ler_id => p_cbr_per_in_ler_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_cbr_per_in_ler_id;
75: --
76: -- ----------------------------------------------------------------------------
112: where a.cbr_quald_bnf_id = p_cbr_quald_bnf_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := ben_crp_shd.api_updating
119: (p_cbr_per_in_ler_id => p_cbr_per_in_ler_id,
120: p_object_version_number => p_object_version_number);
143: close c1;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: End chk_cbr_quald_bnf_id;
150: --
151: -- ----------------------------------------------------------------------------
183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_crp_shd.api_updating
190: (p_cbr_per_in_ler_id => p_cbr_per_in_ler_id,
191: p_object_version_number => p_object_version_number);
214: end if;
215: --
216: end if;
217: --
218: hr_utility.set_location('Leaving:'||l_proc,10);
219: --
220: end chk_init_evt_flag;
221: --
222: -- ----------------------------------------------------------------------------
227: --
228: l_proc varchar2(72) := g_package||'insert_validate';
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: --
233: -- Call all supporting business operations
234: --
235: --
249: p_init_evt_flag => p_rec.init_evt_flag,
250: p_effective_date => p_effective_date,
251: p_object_version_number => p_rec.object_version_number);
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: End insert_validate;
255: --
256: -- ----------------------------------------------------------------------------
257: -- |---------------------------< update_validate >----------------------------|
261: --
262: l_proc varchar2(72) := g_package||'update_validate';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: -- Call all supporting business operations
268: --
269: --
283: p_init_evt_flag => p_rec.init_evt_flag,
284: p_effective_date => p_effective_date,
285: p_object_version_number => p_rec.object_version_number);
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: End update_validate;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |---------------------------< delete_validate >----------------------------|
295: --
296: l_proc varchar2(72) := g_package||'delete_validate';
297: --
298: Begin
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: -- Call all supporting business operations
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: -- Call all supporting business operations
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: End delete_validate;
305: --
306: --
307: -- ---------------------------------------------------------------------------
326: l_proc varchar2(72) := g_package||'return_legislation_code';
327: --
328: begin
329: --
330: hr_utility.set_location('Entering:'|| l_proc, 10);
331: --
332: -- Ensure that all the mandatory parameter are not null
333: --
334: hr_api.mandatory_arg_error(p_api_name => l_proc,
351: end if;
352: --
353: close csr_leg_code;
354: --
355: hr_utility.set_location(' Leaving:'|| l_proc, 20);
356: --
357: return l_legislation_code;
358: --
359: end return_legislation_code;