428: --
429: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
430: --
431: hr_utility.set_location(' Step:'|| l_proc, 10);
432: ota_tmt_bus1.chk_tp_measurement_code(
433: p_effective_date => p_effective_date
434: ,p_tp_measurement_code => p_rec.tp_measurement_code
435: ,p_business_group_id => p_rec.business_group_id);
436: --
434: ,p_tp_measurement_code => p_rec.tp_measurement_code
435: ,p_business_group_id => p_rec.business_group_id);
436: --
437: hr_utility.set_location(' Step:'|| l_proc, 20);
438: ota_tmt_bus1.chk_unit(
439: p_effective_date => p_effective_date
440: ,p_unit => p_rec.unit
441: ,p_business_group_id => p_rec.business_group_id
442: ,p_object_version_number => p_rec.object_version_number
441: ,p_business_group_id => p_rec.business_group_id
442: ,p_object_version_number => p_rec.object_version_number
443: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
444: hr_utility.set_location(' Step:'|| l_proc, 30);
445: ota_tmt_bus1.chk_budget_level(
446: p_effective_date => p_effective_date
447: ,p_business_group_id => p_rec.business_group_id
448: ,p_budget_level => p_rec.budget_level
449: ,p_tp_measurement_code => p_rec.tp_measurement_code
449: ,p_tp_measurement_code => p_rec.tp_measurement_code
450: ,p_object_version_number => p_rec.object_version_number
451: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
452: hr_utility.set_location(' Step:'|| l_proc, 40);
453: ota_tmt_bus1.chk_cost_level(
454: p_effective_date => p_effective_date
455: ,p_business_group_id => p_rec.business_group_id
456: ,p_cost_level => p_rec.cost_level
457: ,p_object_version_number => p_rec.object_version_number
456: ,p_cost_level => p_rec.cost_level
457: ,p_object_version_number => p_rec.object_version_number
458: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
459: hr_utility.set_location(' Step:'|| l_proc, 50);
460: ota_tmt_bus1.chk_budget_cost_combination(
461: p_budget_level => p_rec.budget_level
462: ,p_cost_level => p_rec.cost_level
463: ,p_object_version_number => p_rec.object_version_number
464: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
462: ,p_cost_level => p_rec.cost_level
463: ,p_object_version_number => p_rec.object_version_number
464: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
465: hr_utility.set_location(' Step:'|| l_proc, 60);
466: ota_tmt_bus1.chk_many_budget_values_flag(
467: p_effective_date => p_effective_date
468: ,p_business_group_id => p_rec.business_group_id
469: ,p_many_budget_values_flag => p_rec.many_budget_values_flag
470: ,p_tp_measurement_code => p_rec.tp_measurement_code
470: ,p_tp_measurement_code => p_rec.tp_measurement_code
471: ,p_object_version_number => p_rec.object_version_number
472: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
473: hr_utility.set_location(' Step:'|| l_proc, 70);
474: ota_tmt_bus1.chk_item_type_usage_id(
475: p_item_type_usage_id => p_rec.item_type_usage_id
476: ,p_business_group_id => p_rec.business_group_id
477: ,p_object_version_number => p_rec.object_version_number
478: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
481: open csr_leg_code;
482: fetch csr_leg_code into l_legislation_code;
483: close csr_leg_code;
484: hr_utility.set_location(' Step:'|| l_proc, 90);
485: ota_tmt_bus1.chk_legislative_setup(
486: p_legislation_code => l_legislation_code
487: ,p_tp_measurement_code => p_rec.tp_measurement_code
488: ,p_unit => p_rec.unit
489: ,p_budget_level => p_rec.budget_level
523: ,p_rec => p_rec);
524: --
525: --
526: hr_utility.set_location(' Step:'|| l_proc, 10);
527: ota_tmt_bus1.chk_unit(
528: p_effective_date => p_effective_date
529: ,p_unit => p_rec.unit
530: ,p_business_group_id => p_rec.business_group_id
531: ,p_object_version_number => p_rec.object_version_number
530: ,p_business_group_id => p_rec.business_group_id
531: ,p_object_version_number => p_rec.object_version_number
532: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
533: hr_utility.set_location(' Step:'|| l_proc, 20);
534: ota_tmt_bus1.chk_budget_level(
535: p_effective_date => p_effective_date
536: ,p_business_group_id => p_rec.business_group_id
537: ,p_budget_level => p_rec.budget_level
538: ,p_tp_measurement_code => p_rec.tp_measurement_code
538: ,p_tp_measurement_code => p_rec.tp_measurement_code
539: ,p_object_version_number => p_rec.object_version_number
540: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
541: hr_utility.set_location(' Step:'|| l_proc, 30);
542: ota_tmt_bus1.chk_cost_level(
543: p_effective_date => p_effective_date
544: ,p_business_group_id => p_rec.business_group_id
545: ,p_cost_level => p_rec.cost_level
546: ,p_object_version_number => p_rec.object_version_number
545: ,p_cost_level => p_rec.cost_level
546: ,p_object_version_number => p_rec.object_version_number
547: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
548: hr_utility.set_location(' Step:'|| l_proc, 40);
549: ota_tmt_bus1.chk_budget_cost_combination(
550: p_budget_level => p_rec.budget_level
551: ,p_cost_level => p_rec.cost_level
552: ,p_object_version_number => p_rec.object_version_number
553: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
551: ,p_cost_level => p_rec.cost_level
552: ,p_object_version_number => p_rec.object_version_number
553: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
554: hr_utility.set_location(' Step:'|| l_proc, 50);
555: ota_tmt_bus1.chk_many_budget_values_flag(
556: p_effective_date => p_effective_date
557: ,p_business_group_id => p_rec.business_group_id
558: ,p_many_budget_values_flag => p_rec.many_budget_values_flag
559: ,p_tp_measurement_code => p_rec.tp_measurement_code
559: ,p_tp_measurement_code => p_rec.tp_measurement_code
560: ,p_object_version_number => p_rec.object_version_number
561: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
562: hr_utility.set_location(' Step:'|| l_proc, 60);
563: ota_tmt_bus1.chk_item_type_usage_id(
564: p_item_type_usage_id => p_rec.item_type_usage_id
565: ,p_business_group_id => p_rec.business_group_id
566: ,p_object_version_number => p_rec.object_version_number
567: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
570: open csr_leg_code;
571: fetch csr_leg_code into l_legislation_code;
572: close csr_leg_code;
573: hr_utility.set_location(' Step:'|| l_proc, 80);
574: ota_tmt_bus1.chk_legislative_setup(
575: p_legislation_code => l_legislation_code
576: ,p_tp_measurement_code => p_rec.tp_measurement_code
577: ,p_unit => p_rec.unit
578: ,p_budget_level => p_rec.budget_level
600: --
601: -- Call all supporting business operations
602: --
603: hr_utility.set_location(' Step:'|| l_proc, 10);
604: ota_tmt_bus1.chk_del_tp_measurement_code(
605: p_tp_measurement_code => ota_tmt_shd.g_old_rec.tp_measurement_code
606: ,p_tp_measurement_type_id => ota_tmt_shd.g_old_rec.tp_measurement_type_id
607: ,p_business_group_id => ota_tmt_shd.g_old_rec.business_group_id);
608: hr_utility.set_location(' Step:'|| l_proc, 20);
605: p_tp_measurement_code => ota_tmt_shd.g_old_rec.tp_measurement_code
606: ,p_tp_measurement_type_id => ota_tmt_shd.g_old_rec.tp_measurement_type_id
607: ,p_business_group_id => ota_tmt_shd.g_old_rec.business_group_id);
608: hr_utility.set_location(' Step:'|| l_proc, 20);
609: ota_tmt_bus1.chk_del_tp_measurement_type_id(
610: p_tp_measurement_type_id => ota_tmt_shd.g_old_rec.tp_measurement_type_id);
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: End delete_validate;
613: --