[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_cqb_shd.api_updating
47: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_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_quald_bnf_id;
75: --
76: -- ----------------------------------------------------------------------------
112: where a.pgm_id = p_pgm_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := ben_cqb_shd.api_updating
119: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_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_pgm_id;
150: --
151: -- ----------------------------------------------------------------------------
187: where a.ptip_id = p_ptip_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ben_cqb_shd.api_updating
194: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_id,
195: p_object_version_number => p_object_version_number);
219: close c1;
220: --
221: end if;
222: --
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: End chk_ptip_id;
226: --
227: -- ----------------------------------------------------------------------------
263: where a.pl_typ_id = p_pl_typ_id;
264: --
265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc,5);
268: --
269: l_api_updating := ben_cqb_shd.api_updating
270: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_id,
271: p_object_version_number => p_object_version_number);
295: close c1;
296: --
297: end if;
298: --
299: hr_utility.set_location('Leaving:'||l_proc,10);
300: --
301: End chk_pl_typ_id;
302: --
303: -- ----------------------------------------------------------------------------
337: l_api_updating boolean;
338: --
339: Begin
340: --
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: --
343: l_api_updating := ben_cqb_shd.api_updating
344: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_id,
345: p_object_version_number => p_object_version_number);
380: end if;
381: --
382: end if;
383: --
384: hr_utility.set_location('Leaving:'||l_proc,10);
385: --
386: end chk_quald_bnf_flag;
387: --
388: -- ----------------------------------------------------------------------------
420: l_api_updating boolean;
421: --
422: Begin
423: --
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: l_api_updating := ben_cqb_shd.api_updating
427: (p_cbr_quald_bnf_id => p_cbr_quald_bnf_id,
428: p_object_version_number => p_object_version_number);
451: end if;
452: --
453: end if;
454: --
455: hr_utility.set_location('Leaving:'||l_proc,10);
456: --
457: end chk_cbr_inelg_rsn_cd;
458: --
459: -- ----------------------------------------------------------------------------
464: --
465: l_proc varchar2(72) := g_package||'insert_validate';
466: --
467: Begin
468: hr_utility.set_location('Entering:'||l_proc, 5);
469: --
470: -- Call all supporting business operations
471: --
472: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
503: p_cbr_inelg_rsn_cd => p_rec.cbr_inelg_rsn_cd,
504: p_effective_date => p_effective_date,
505: p_object_version_number => p_rec.object_version_number);
506: --
507: hr_utility.set_location(' Leaving:'||l_proc, 10);
508: End insert_validate;
509: --
510: -- ----------------------------------------------------------------------------
511: -- |---------------------------< update_validate >----------------------------|
515: --
516: l_proc varchar2(72) := g_package||'update_validate';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520: --
521: -- Call all supporting business operations
522: --
523: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
554: p_cbr_inelg_rsn_cd => p_rec.cbr_inelg_rsn_cd,
555: p_effective_date => p_effective_date,
556: p_object_version_number => p_rec.object_version_number);
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End update_validate;
560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------< delete_validate >----------------------------|
566: --
567: l_proc varchar2(72) := g_package||'delete_validate';
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Call all supporting business operations
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Call all supporting business operations
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: End delete_validate;
576: --
577: --
578: -- ---------------------------------------------------------------------------
597: l_proc varchar2(72) := g_package||'return_legislation_code';
598: --
599: begin
600: --
601: hr_utility.set_location('Entering:'|| l_proc, 10);
602: --
603: -- Ensure that all the mandatory parameter are not null
604: --
605: hr_api.mandatory_arg_error(p_api_name => l_proc,
622: end if;
623: --
624: close csr_leg_code;
625: --
626: hr_utility.set_location(' Leaving:'|| l_proc, 20);
627: --
628: return l_legislation_code;
629: --
630: end return_legislation_code;