40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_bbp_shd.api_updating
47: (p_batch_parameter_id => p_batch_parameter_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_batch_parameter_id;
75: --
76: -- ----------------------------------------------------------------------------
108: l_api_updating boolean;
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_bbp_shd.api_updating
115: (p_batch_parameter_id => p_batch_parameter_id,
116: p_object_version_number => p_object_version_number);
138: end if;
139: --
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc,10);
143: --
144: end chk_batch_exe_cd;
145: -- ----------------------------------------------------------------------------
146: -- |-------------------------< chk_batch_parameters >-------------------------|
179: l_api_updating boolean;
180: --
181: Begin
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: l_api_updating := ben_bbp_shd.api_updating
186: (p_batch_parameter_id => p_batch_parameter_id,
187: p_object_version_number => p_object_version_number);
242: end if;
243: --
244: end if;
245: --
246: hr_utility.set_location('Leaving:'||l_proc,10);
247: --
248: End chk_batch_parameters;
249: --
250: -- ----------------------------------------------------------------------------
291: and batch_parameter_id <> nvl(p_batch_parameter_id,-1);
292: --
293: Begin
294: --
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: l_api_updating := ben_bbp_shd.api_updating
298: (p_batch_parameter_id => p_batch_parameter_id,
299: p_object_version_number => p_object_version_number);
318: close c1;
319: --
320: end if;
321: --
322: hr_utility.set_location('Leaving:'||l_proc,10);
323: --
324: End chk_batch_exe_cd_unique;
325: --
326: -- ----------------------------------------------------------------------------
331: --
332: l_proc varchar2(72) := g_package||'insert_validate';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- Call all supporting business operations
338: --
339: --
361: p_object_version_number => p_rec.object_version_number,
362: p_business_group_id => p_rec.business_group_id,
363: p_batch_exe_cd => p_rec.batch_exe_cd);
364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 10);
366: End insert_validate;
367: --
368: -- ----------------------------------------------------------------------------
369: -- |---------------------------< update_validate >----------------------------|
373: --
374: l_proc varchar2(72) := g_package||'update_validate';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call all supporting business operations
380: --
381: --
403: p_object_version_number => p_rec.object_version_number,
404: p_business_group_id => p_rec.business_group_id,
405: p_batch_exe_cd => p_rec.batch_exe_cd);
406: --
407: hr_utility.set_location(' Leaving:'||l_proc, 10);
408: End update_validate;
409: --
410: -- ----------------------------------------------------------------------------
411: -- |---------------------------< delete_validate >----------------------------|
415: --
416: l_proc varchar2(72) := g_package||'delete_validate';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Call all supporting business operations
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 10);
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Call all supporting business operations
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 10);
424: End delete_validate;
425: --
426: --
427: -- ---------------------------------------------------------------------------
446: l_proc varchar2(72) := g_package||'return_legislation_code';
447: --
448: begin
449: --
450: hr_utility.set_location('Entering:'|| l_proc, 10);
451: --
452: -- Ensure that all the mandatory parameter are not null
453: --
454: hr_api.mandatory_arg_error(p_api_name => l_proc,
464: close csr_leg_code;
465: --
466: -- The primary key is invalid therefore we must error
467: --
468: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
469: hr_utility.raise_error;
470: --
471: end if;
472: --
465: --
466: -- The primary key is invalid therefore we must error
467: --
468: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
469: hr_utility.raise_error;
470: --
471: end if;
472: --
473: close csr_leg_code;
471: end if;
472: --
473: close csr_leg_code;
474: --
475: hr_utility.set_location(' Leaving:'|| l_proc, 20);
476: --
477: return l_legislation_code;
478: --
479: end return_legislation_code;