41: l_api_updating boolean;
42: --
43: Begin
44: --
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := ben_drr_shd.api_updating
48: (p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id,
49: p_object_version_number => p_object_version_number);
69: end if;
70: --
71: end if;
72: --
73: hr_utility.set_location('Leaving:'||l_proc, 10);
74: --
75: End chk_dsgn_rqmt_rlshp_typ_id;
76: --
77: -- ----------------------------------------------------------------------------
118: and a.effective_end_date;
119: --
120: Begin
121: --
122: hr_utility.set_location('Entering:'||l_proc,5);
123: --
124: l_api_updating := ben_drr_shd.api_updating
125: (p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id,
126: p_object_version_number => p_object_version_number);
149: close c1;
150: --
151: end if;
152: --
153: hr_utility.set_location('Leaving:'||l_proc,10);
154: --
155: End chk_dsgn_rqmt_id;
156: --
157: -- ----------------------------------------------------------------------------
222: );
223: --
224: Begin
225: --
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: l_api_updating := ben_drr_shd.api_updating
229: (p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id,
230: p_object_version_number => p_object_version_number);
244: p_effective_date => p_effective_date) then
245: --
246: -- raise error as does not exist as lookup
247: --
248: --Bug 2736727 Changed parameter to 805 frm 'BEN' in hr_utility call.
249:
250: hr_utility.set_message(805,'BEN_91964_INVLD_RLSHP_TYP');
251: hr_utility.raise_error;
252: --
246: -- raise error as does not exist as lookup
247: --
248: --Bug 2736727 Changed parameter to 805 frm 'BEN' in hr_utility call.
249:
250: hr_utility.set_message(805,'BEN_91964_INVLD_RLSHP_TYP');
251: hr_utility.raise_error;
252: --
253: end if;
254: */
247: --
248: --Bug 2736727 Changed parameter to 805 frm 'BEN' in hr_utility call.
249:
250: hr_utility.set_message(805,'BEN_91964_INVLD_RLSHP_TYP');
251: hr_utility.raise_error;
252: --
253: end if;
254: */
255: open c_lookup_exists (cv_business_group_id => p_business_group_id,
271: close c_lookup_exists;
272: --
273: end if;
274: --
275: hr_utility.set_location('Leaving:'||l_proc,10);
276: --
277: end chk_rlshp_typ_cd;
278: --
279: --
325: and dsgn_rqmt_rlshp_typ_id <> nvl(p_dsgn_rqmt_rlshp_typ_id, -999);
326: --
327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc,5);
330: --
331: --
332: -- check if dsgn_rqmt_id value exists in ben_dsgn_rqmt_f table
333: --
346: --
347: end if;
348: --
349: --
350: hr_utility.set_location('Leaving:'||l_proc,10);
351: --
352: End chk_dsgn_rqmt_rlshp_uniq;
353: --
354: -- end bug 2837189
361: --
362: l_proc varchar2(72) := g_package||'insert_validate';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: -- Call all supporting business operations
368: --
369: --
387: p_dsgn_rqmt_id => p_rec.dsgn_rqmt_id,
388: p_business_group_id => p_rec.business_group_id,
389: p_object_version_number => p_rec.object_version_number );
390: --
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: End insert_validate;
393: --
394: -- ----------------------------------------------------------------------------
395: -- |---------------------------< update_validate >----------------------------|
399: --
400: l_proc varchar2(72) := g_package||'update_validate';
401: --
402: Begin
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: -- Call all supporting business operations
406: --
407: --
425: p_dsgn_rqmt_id => p_rec.dsgn_rqmt_id,
426: p_business_group_id => p_rec.business_group_id,
427: p_object_version_number => p_rec.object_version_number );
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 10);
430: End update_validate;
431: --
432: -- ----------------------------------------------------------------------------
433: -- |---------------------------< delete_validate >----------------------------|
437: --
438: l_proc varchar2(72) := g_package||'delete_validate';
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc, 5);
442: --
443: -- Call all supporting business operations
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: hr_utility.set_location('Entering:'||l_proc, 5);
442: --
443: -- Call all supporting business operations
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 10);
446: End delete_validate;
447: --
448: --
449: -- ---------------------------------------------------------------------------
468: l_proc varchar2(72) := g_package||'return_legislation_code';
469: --
470: begin
471: --
472: hr_utility.set_location('Entering:'|| l_proc, 10);
473: --
474: -- Ensure that all the mandatory parameter are not null
475: --
476: hr_api.mandatory_arg_error(p_api_name => l_proc,
486: close csr_leg_code;
487: --
488: -- The primary key is invalid therefore we must error
489: --
490: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
491: hr_utility.raise_error;
492: --
493: end if;
494: --
487: --
488: -- The primary key is invalid therefore we must error
489: --
490: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
491: hr_utility.raise_error;
492: --
493: end if;
494: --
495: close csr_leg_code;
493: end if;
494: --
495: close csr_leg_code;
496: --
497: hr_utility.set_location(' Leaving:'|| l_proc, 20);
498: --
499: return l_legislation_code;
500: --
501: end return_legislation_code;