40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ghr_nre_shd.api_updating
47: (p_noac_remark_id => p_noac_remark_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_noac_remark_id;
75: --
76: -- ----------------------------------------------------------------------------
112: where a.remark_id = p_remark_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := ghr_nre_shd.api_updating
119: (p_noac_remark_id => p_noac_remark_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_remark_id;
150: --
151: -- ----------------------------------------------------------------------------
187: where a.nature_of_action_id = p_nature_of_action_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ghr_nre_shd.api_updating
194: (p_noac_remark_id => p_noac_remark_id,
195: p_object_version_number => p_object_version_number);
218: close c1;
219: --
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc,10);
223: --
224: End chk_nature_of_action_id;
225: --
226: -- ----------------------------------------------------------------------------
258: l_api_updating boolean;
259: --
260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := ghr_nre_shd.api_updating
265: (p_noac_remark_id => p_noac_remark_id,
266: p_object_version_number => p_object_version_number);
279: p_effective_date => p_effective_date) then
280: --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: --
286: end if;
287: --
280: --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: --
286: end if;
287: --
288: end if;
286: end if;
287: --
288: end if;
289: --
290: hr_utility.set_location('Leaving:'||l_proc,10);
291: --
292: end chk_enabled_flag;
293: --
294: -- ----------------------------------------------------------------------------
326: l_api_updating boolean;
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ghr_nre_shd.api_updating
333: (p_noac_remark_id => p_noac_remark_id,
334: p_object_version_number => p_object_version_number);
347: p_effective_date => p_effective_date) then
348: --
349: -- raise error as does not exist as lookup
350: --
351: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
352: hr_utility.raise_error;
353: --
354: end if;
355: --
348: --
349: -- raise error as does not exist as lookup
350: --
351: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
352: hr_utility.raise_error;
353: --
354: end if;
355: --
356: end if;
354: end if;
355: --
356: end if;
357: --
358: hr_utility.set_location('Leaving:'||l_proc,10);
359: --
360: end chk_required_flag;
361: --
362: -- ----------------------------------------------------------------------------
397: l_api_updating boolean;
398: --
399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: l_api_updating := ghr_nre_shd.api_updating
404: (p_noac_remark_id => p_noac_remark_id,
405: p_object_version_number => p_object_version_number);
422: -- greater than or equal to date_from
423: --
424: if p_date_to is not null then
425: if trunc(p_date_from) > trunc(p_date_to) then
426: hr_utility.set_message(8301,'GHR_38196_TO_DATE_LESSER');
427: hr_utility.raise_error;
428: end if;
429: end if;
430:
423: --
424: if p_date_to is not null then
425: if trunc(p_date_from) > trunc(p_date_to) then
426: hr_utility.set_message(8301,'GHR_38196_TO_DATE_LESSER');
427: hr_utility.raise_error;
428: end if;
429: end if;
430:
431:
428: end if;
429: end if;
430:
431:
432: hr_utility.set_location('Leaving:'||l_proc,10);
433: --
434: end chk_date_from;
435: --
436: --
478: and a.remark_id = p_remark_id;
479: --
480: Begin
481: --
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: l_api_updating := ghr_nre_shd.api_updating
485: (p_noac_remark_id => p_noac_remark_id,
486: p_object_version_number => p_object_version_number);
484: l_api_updating := ghr_nre_shd.api_updating
485: (p_noac_remark_id => p_noac_remark_id,
486: p_object_version_number => p_object_version_number);
487: --
488: hr_utility.set_location('Entering:'||l_proc, 10);
489: --
490: if (l_api_updating
491: and ( p_nature_of_action_id
492: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
498: --
499: -- check if the combination of action_id and remark_id already exits
500: --
501: --
502: hr_utility.set_location('Entering:'||l_proc, 15);
503: --
504: open c1;
505: --
506: --
503: --
504: open c1;
505: --
506: --
507: hr_utility.set_location('Entering:'||l_proc, 16);
508: --
509: fetch c1 into l_dummy;
510: --
511: hr_utility.set_location('Entering:'||l_proc, 17);
507: hr_utility.set_location('Entering:'||l_proc, 16);
508: --
509: fetch c1 into l_dummy;
510: --
511: hr_utility.set_location('Entering:'||l_proc, 17);
512: --
513: if c1%found then
514: --
515: close c1;
514: --
515: close c1;
516: --
517: --
518: hr_utility.set_location('Entering:'||l_proc, 18);
519: --
520: -- raise error as the combination already exists
521: --
522: hr_utility.set_message(8301,'GHR_NOAC_REM_DUPLICATE');
518: hr_utility.set_location('Entering:'||l_proc, 18);
519: --
520: -- raise error as the combination already exists
521: --
522: hr_utility.set_message(8301,'GHR_NOAC_REM_DUPLICATE');
523: hr_utility.raise_error;
524: end if;
525: --
526: close c1;
519: --
520: -- raise error as the combination already exists
521: --
522: hr_utility.set_message(8301,'GHR_NOAC_REM_DUPLICATE');
523: hr_utility.raise_error;
524: end if;
525: --
526: close c1;
527:
526: close c1;
527:
528: end if;
529: --
530: hr_utility.set_location('Leaving:'||l_proc,25);
531: --
532: end chk_unique_act_rem_id;
533: --
534: -- ----------------------------------------------------------------------------
539: --
540: l_proc varchar2(72) := g_package||'insert_validate';
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Set up the CLIENT_INFO
546: --
547: ghr_utility.set_client_info;
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Set up the CLIENT_INFO
546: --
547: ghr_utility.set_client_info;
548: --
549: -- Call all supporting business operations
550: --
551: chk_noac_remark_id
585: p_nature_of_action_id => p_rec.nature_of_action_id,
586: p_remark_id => p_rec.remark_id,
587: p_object_version_number => p_rec.object_version_number);
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 10);
590: End insert_validate;
591: --
592: -- ----------------------------------------------------------------------------
593: -- |---------------------------< update_validate >----------------------------|
597: --
598: l_proc varchar2(72) := g_package||'update_validate';
599: --
600: Begin
601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: -- Set up the CLIENT_INFO
604: --
605: ghr_utility.set_client_info;
601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: -- Set up the CLIENT_INFO
604: --
605: ghr_utility.set_client_info;
606: --
607: -- Call all supporting business operations
608: --
609: chk_noac_remark_id
645: p_object_version_number => p_rec.object_version_number);
646: --
647: --
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: End update_validate;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< delete_validate >----------------------------|
657: --
658: l_proc varchar2(72) := g_package||'delete_validate';
659: --
660: Begin
661: hr_utility.set_location('Entering:'||l_proc, 5);
662: --
663: -- Call all supporting business operations
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 10);
661: hr_utility.set_location('Entering:'||l_proc, 5);
662: --
663: -- Call all supporting business operations
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 10);
666: End delete_validate;
667: --
668: end ghr_nre_bus;