40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_bpr_shd.api_updating
47: (p_budget_period_id => p_budget_period_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_budget_period_id;
75: --
76: -- ----------------------------------------------------------------------------
112: where a.time_period_id = p_end_time_period_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_bpr_shd.api_updating
119: (p_budget_period_id => p_budget_period_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_end_time_period_id;
150: --
151: -- ----------------------------------------------------------------------------
187: where a.time_period_id = p_start_time_period_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := pqh_bpr_shd.api_updating
194: (p_budget_period_id => p_budget_period_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_start_time_period_id;
225: --
226: -- ----------------------------------------------------------------------------
262: where a.budget_detail_id = p_budget_detail_id;
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc,5);
267: --
268: l_api_updating := pqh_bpr_shd.api_updating
269: (p_budget_period_id => p_budget_period_id,
270: p_object_version_number => p_object_version_number);
293: close c1;
294: --
295: end if;
296: --
297: hr_utility.set_location('Leaving:'||l_proc,10);
298: --
299: End chk_budget_detail_id;
300: --
301: --
334: l_api_updating boolean;
335: --
336: Begin
337: --
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: l_api_updating := pqh_bpr_shd.api_updating
341: (p_budget_period_id => p_budget_period_id,
342: p_object_version_number => p_object_version_number);
355: p_effective_date => p_effective_date) then
356: --
357: -- raise error as does not exist as lookup
358: --
359: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
360: hr_utility.raise_error;
361: --
362: end if;
363: --
356: --
357: -- raise error as does not exist as lookup
358: --
359: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
360: hr_utility.raise_error;
361: --
362: end if;
363: --
364: end if;
362: end if;
363: --
364: end if;
365: --
366: hr_utility.set_location('Leaving:'||l_proc,10);
367: --
368: end chk_budget_unit3_value_type_cd;
369: --
370: -- ----------------------------------------------------------------------------
402: l_api_updating boolean;
403: --
404: Begin
405: --
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: l_api_updating := pqh_bpr_shd.api_updating
409: (p_budget_period_id => p_budget_period_id,
410: p_object_version_number => p_object_version_number);
423: p_effective_date => p_effective_date) then
424: --
425: -- raise error as does not exist as lookup
426: --
427: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
428: hr_utility.raise_error;
429: --
430: end if;
431: --
424: --
425: -- raise error as does not exist as lookup
426: --
427: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
428: hr_utility.raise_error;
429: --
430: end if;
431: --
432: end if;
430: end if;
431: --
432: end if;
433: --
434: hr_utility.set_location('Leaving:'||l_proc,10);
435: --
436: end chk_budget_unit2_value_type_cd;
437: --
438: -- ----------------------------------------------------------------------------
470: l_api_updating boolean;
471: --
472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := pqh_bpr_shd.api_updating
477: (p_budget_period_id => p_budget_period_id,
478: p_object_version_number => p_object_version_number);
491: p_effective_date => p_effective_date) then
492: --
493: -- raise error as does not exist as lookup
494: --
495: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
496: hr_utility.raise_error;
497: --
498: end if;
499: --
492: --
493: -- raise error as does not exist as lookup
494: --
495: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
496: hr_utility.raise_error;
497: --
498: end if;
499: --
500: end if;
498: end if;
499: --
500: end if;
501: --
502: hr_utility.set_location('Leaving:'||l_proc,10);
503: --
504: end chk_budget_unit1_value_type_cd;
505: --
506: -- ----------------------------------------------------------------------------
510: --
511: l_proc varchar2(72) := g_package||'insert_validate';
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Call all supporting business operations
517: --
518: chk_budget_period_id
553: p_object_version_number => p_rec.object_version_number);
554: --
555: --
556: --
557: hr_utility.set_location(' Leaving:'||l_proc, 10);
558: End insert_validate;
559: --
560: -- ----------------------------------------------------------------------------
561: -- |---------------------------< update_validate >----------------------------|
564: --
565: l_proc varchar2(72) := g_package||'update_validate';
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Call all supporting business operations
571: --
572: chk_budget_period_id
607: p_object_version_number => p_rec.object_version_number);
608: --
609: --
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: End update_validate;
613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------< delete_validate >----------------------------|
618: --
619: l_proc varchar2(72) := g_package||'delete_validate';
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: End delete_validate;
628: --
629: end pqh_bpr_bus;