[Home] [Help]
46: l_api_updating boolean;
47: --
48: Begin
49: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: l_api_updating := ben_pty_shd.api_updating
53: (p_pl_pcp_typ_id => p_pl_pcp_typ_id,
54: p_object_version_number => p_object_version_number);
74: end if;
75: --
76: end if;
77: --
78: hr_utility.set_location('Leaving:'||l_proc, 10);
79: --
80: End chk_pl_pcp_typ_id;
81: --
82: -- ----------------------------------------------------------------------------
118: where a.pl_pcp_id = p_pl_pcp_id;
119: --
120: Begin
121: --
122: hr_utility.set_location('Entering:'||l_proc,5);
123: --
124: l_api_updating := ben_pty_shd.api_updating
125: (p_pl_pcp_typ_id => p_pl_pcp_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_pl_pcp_id;
156: --
157: -- ----------------------------------------------------------------------------
189: l_api_updating boolean;
190: --
191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: l_api_updating := ben_pty_shd.api_updating
196: (p_pl_pcp_typ_id => p_pl_pcp_typ_id,
197: p_object_version_number => p_object_version_number);
223: end if;
224: --
225: end if;
226: --
227: hr_utility.set_location('Leaving:'||l_proc,10);
228: --
229: end chk_pcp_typ_cd ;
230: --
231: --
266: l_api_updating boolean;
267: --
268: Begin
269: --
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: l_api_updating := ben_pty_shd.api_updating
273: (p_pl_pcp_typ_id => p_pl_pcp_typ_id,
274: p_object_version_number => p_object_version_number);
301: end if;
302: --
303: end if;
304: --
305: hr_utility.set_location('Leaving:'||l_proc,10);
306: --
307: end chk_gndr_alwd_cd ;
308: --
309: --
344: Where pl_pcp_id = p_pl_pcp_id;
345:
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: --- when the rate is imputing chek the plan in imputing
351: open c1;
352: fetch c1 into l_dummy;
355: fnd_message.raise_error;
356: end if;
357: close c1;
358:
359: hr_utility.set_location('Leaving:'||l_proc, 15);
360: End chk_pl_pcp_typ_record;
361: --
362: -- ---------------------------------------------------------------------------
363: -- |----------------------< set_security_group_id >--------------------------|
382: l_proc varchar2(72) := g_package||'set_security_group_id';
383: --
384: begin
385: --
386: hr_utility.set_location('Entering:'|| l_proc, 10);
387: --
388: -- Ensure that all the mandatory parameter are not null
389: --
390: hr_api.mandatory_arg_error
413: hr_api.set_security_group_id
414: (p_security_group_id => l_security_group_id
415: );
416: --
417: hr_utility.set_location(' Leaving:'|| l_proc, 20);
418: --
419: end set_security_group_id;
420: --
421: -- ---------------------------------------------------------------------------
442: l_proc varchar2(72) := g_package||'return_legislation_code';
443: --
444: Begin
445: --
446: hr_utility.set_location('Entering:'|| l_proc, 10);
447: --
448: -- Ensure that all the mandatory parameter are not null
449: --
450: hr_api.mandatory_arg_error
460: -- call to this function. Just return the value in the global
461: -- variable.
462: --
463: l_legislation_code := ben_pty_bus.g_legislation_code;
464: hr_utility.set_location(l_proc, 20);
465: else
466: --
467: -- The ID is different to the last call to this function
468: -- or this is the first call to this function.
477: close csr_leg_code;
478: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
479: fnd_message.raise_error;
480: end if;
481: hr_utility.set_location(l_proc,30);
482: --
483: -- Set the global variables so the values are
484: -- available for the next call to this function.
485: --
486: close csr_leg_code;
487: ben_pty_bus.g_pl_pcp_typ_id := p_pl_pcp_typ_id;
488: ben_pty_bus.g_legislation_code := l_legislation_code;
489: end if;
490: hr_utility.set_location(' Leaving:'|| l_proc, 40);
491: return l_legislation_code;
492: end return_legislation_code;
493: --
494: -- ----------------------------------------------------------------------------
525: --
526: l_proc varchar2(72) := g_package || 'chk_df';
527: --
528: begin
529: hr_utility.set_location('Entering:'||l_proc,10);
530: --
531: if ((p_rec.pl_pcp_typ_id is not null) and (
532: nvl(ben_pty_shd.g_old_rec.pty_attribute_category, hr_api.g_varchar2) <>
533: nvl(p_rec.pty_attribute_category, hr_api.g_varchar2) or
664: ,p_attribute30_value => p_rec.pty_attribute30
665: );
666: end if;
667: --
668: hr_utility.set_location(' Leaving:'||l_proc,20);
669: end chk_df;
670: --
671: -- ----------------------------------------------------------------------------
672: -- |-----------------------< chk_non_updateable_args >------------------------|
739: --
740: l_proc varchar2(72) := g_package||'insert_validate';
741: --
742: Begin
743: hr_utility.set_location('Entering:'||l_proc, 5);
744: --
745: -- Call all supporting business operations
746: --
747:
771: --
772: --
773: --ben_pty_bus.chk_df(p_rec);
774: --
775: hr_utility.set_location(' Leaving:'||l_proc, 10);
776: End insert_validate;
777: --
778: -- ----------------------------------------------------------------------------
779: -- |---------------------------< update_validate >----------------------------|
784: --
785: l_proc varchar2(72) := g_package||'update_validate';
786: --
787: Begin
788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: -- Call all supporting business operations
791: --
792: chk_pl_pcp_typ_id(p_pl_pcp_typ_id => p_rec.pl_pcp_typ_id
819: --
820: --
821: --ben_pty_bus.chk_df(p_rec);
822: --
823: hr_utility.set_location(' Leaving:'||l_proc, 10);
824: End update_validate;
825: --
826: -- ----------------------------------------------------------------------------
827: -- |---------------------------< delete_validate >----------------------------|
832: --
833: l_proc varchar2(72) := g_package||'delete_validate';
834: --
835: Begin
836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: -- Call all supporting business operations
839: --
840: hr_utility.set_location(' Leaving:'||l_proc, 10);
836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: -- Call all supporting business operations
839: --
840: hr_utility.set_location(' Leaving:'||l_proc, 10);
841: End delete_validate;
842: --
843: end ben_pty_bus;