40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_rtm_shd.api_updating
47: (p_role_template_id => p_role_template_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_role_template_id;
75: --
76: -- ----------------------------------------------------------------------------
112: where a.template_id = p_template_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_rtm_shd.api_updating
119: (p_role_template_id => p_role_template_id,
120: p_object_version_number => p_object_version_number);
144: close c1;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: End chk_template_id;
151: --
152: -- ----------------------------------------------------------------------------
188: where a.transaction_category_id = p_transaction_category_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_rtm_shd.api_updating
195: (p_role_template_id => p_role_template_id,
196: 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_transaction_category_id;
226: --
227: -- ----------------------------------------------------------------------------
263: where a.role_id = p_role_id;
264: --
265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc,5);
268: --
269: l_api_updating := pqh_rtm_shd.api_updating
270: (p_role_template_id => p_role_template_id,
271: p_object_version_number => p_object_version_number);
294: close c1;
295: --
296: end if;
297: --
298: hr_utility.set_location('Leaving:'||l_proc,10);
299: --
300: End chk_role_id;
301: --
302: -- ----------------------------------------------------------------------------
340: from pqh_roles
341: where role_id=p_role_id;
342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: l_api_updating := pqh_rtm_shd.api_updating
347: (p_role_template_id => p_role_template_id,
348: p_object_version_number => p_object_version_number);
361: p_effective_date => p_effective_date) then
362: --
363: -- raise error as does not exist as lookup
364: --
365: hr_utility.set_message(8302,'PQH_ENABLE_LOOKUP_DOES_NOT_EXIST');
366: hr_utility.raise_error;
367: --
368: if p_enable_flag = 'Y' then
369: open c_role_enable_flag(p_role_id);
362: --
363: -- raise error as does not exist as lookup
364: --
365: hr_utility.set_message(8302,'PQH_ENABLE_LOOKUP_DOES_NOT_EXIST');
366: hr_utility.raise_error;
367: --
368: if p_enable_flag = 'Y' then
369: open c_role_enable_flag(p_role_id);
370: fetch c_role_enable_flag into l_role_enable_flag;
369: open c_role_enable_flag(p_role_id);
370: fetch c_role_enable_flag into l_role_enable_flag;
371: close c_role_enable_flag;
372: if nvl(l_role_enable_flag,'N') = 'N' then
373: hr_utility.set_message(8302,'PQH_ROLE_DIS_CANT_ENABLE_RTM');
374: hr_utility.raise_error;
375: end if;
376: end if;
377: end if;
370: fetch c_role_enable_flag into l_role_enable_flag;
371: close c_role_enable_flag;
372: if nvl(l_role_enable_flag,'N') = 'N' then
373: hr_utility.set_message(8302,'PQH_ROLE_DIS_CANT_ENABLE_RTM');
374: hr_utility.raise_error;
375: end if;
376: end if;
377: end if;
378: --
377: end if;
378: --
379: end if;
380: --
381: hr_utility.set_location('Leaving:'||l_proc,10);
382: --
383: end chk_enable_flag;
384: --
385: --
408: and rct.transaction_category_id=ptc.transaction_category_id;
409: --
410: Begin
411: --
412: hr_utility.set_location('Entering:'||l_proc, 5);
413: --
414: for r_txn_cat in c_txn_cats(p_role_id)
415: loop
416: --
430: end if;
431: --
432: end loop;
433: --
434: hr_utility.set_location('Leaving:'||l_proc,10);
435: --
436: return 'N';
437: end chk_for_pending_txns;
438: --
478: and a.template_id = p_template_id;
479: --
480: Begin
481: --
482: hr_utility.set_location('Entering:'||l_proc,5);
483: --
484: l_api_updating := pqh_rtm_shd.api_updating
485: (p_role_template_id => p_role_template_id,
486: p_object_version_number => p_object_version_number);
513: close c1;
514: --
515: end if;
516: --
517: hr_utility.set_location('Leaving:'||l_proc,10);
518: --
519: End chk_category_template_id;
520: --
521: --
551: l_dummy varchar2(1);
552: --
553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc,5);
556: --
557: l_api_updating := pqh_rtm_shd.api_updating
558: (p_role_template_id => p_rec.role_template_id,
559: p_object_version_number => p_rec.object_version_number);
558: (p_role_template_id => p_rec.role_template_id,
559: p_object_version_number => p_rec.object_version_number);
560: --
561: if (not l_api_updating ) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message('PROCEDURE', l_proc);
564: hr_utility.set_message('STEP', '10');
565: end if;
566: --
559: p_object_version_number => p_rec.object_version_number);
560: --
561: if (not l_api_updating ) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message('PROCEDURE', l_proc);
564: hr_utility.set_message('STEP', '10');
565: end if;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);
560: --
561: if (not l_api_updating ) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message('PROCEDURE', l_proc);
564: hr_utility.set_message('STEP', '10');
565: end if;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);
568:
563: hr_utility.set_message('PROCEDURE', l_proc);
564: hr_utility.set_message('STEP', '10');
565: end if;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);
568:
569: if nvl(p_rec.transaction_category_id,hr_api.g_number) <>
570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then
571: l_argument := 'transaction_category_id';
570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then
571: l_argument := 'transaction_category_id';
572: raise l_error;
573: end if;
574: hr_utility.set_location(l_proc,30);
575: exception
576: when l_error then
577: hr_api.argument_changed_error
578: (p_api_name => l_proc
579: ,p_argument => l_argument
580: );
581: when others then
582: raise;
583: hr_utility.set_location(' Leaving:'||l_proc,50);
584: --
585: End chk_non_updateable_args;
586: --
587: --
593: --
594: l_proc varchar2(72) := g_package||'insert_validate';
595: --
596: Begin
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: -- Call all supporting business operations
600: --
601: chk_role_template_id
631: p_object_version_number => p_rec.object_version_number);
632: --
633: --
634: --
635: hr_utility.set_location(' Leaving:'||l_proc, 10);
636: End insert_validate;
637: --
638: -- ----------------------------------------------------------------------------
639: -- |---------------------------< update_validate >----------------------------|
643: --
644: l_proc varchar2(72) := g_package||'update_validate';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- Call all supporting business operations
650: --
651: chk_non_updateable_args(p_rec);
682: p_effective_date => p_effective_date,
683: p_object_version_number => p_rec.object_version_number);
684: --
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 10);
687: End update_validate;
688: --
689: -- ----------------------------------------------------------------------------
690: -- |---------------------------< delete_validate >----------------------------|
694: --
695: l_proc varchar2(72) := g_package||'delete_validate';
696: --
697: Begin
698: hr_utility.set_location('Entering:'||l_proc, 5);
699: --
700: -- Call all supporting business operations
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 10);
698: hr_utility.set_location('Entering:'||l_proc, 5);
699: --
700: -- Call all supporting business operations
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 10);
703: End delete_validate;
704: --
705: end pqh_rtm_bus;