eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TMT_BUS dependencies on OTA_TMT_BUS

Line 1: Package Body ota_tmt_bus as

1: Package Body ota_tmt_bus as
2: /* $Header: ottmtrhi.pkb 115.6 2002/11/26 17:09:48 hwinsor noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_tmt_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_tmt_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 112: if ( nvl(ota_tmt_bus.g_tp_measurement_type_id, hr_api.g_number)

108: ,p_argument => 'tp_measurement_type_id'
109: ,p_argument_value => p_tp_measurement_type_id
110: );
111: --
112: if ( nvl(ota_tmt_bus.g_tp_measurement_type_id, hr_api.g_number)
113: = p_tp_measurement_type_id) then
114: --
115: -- The legislation code has already been found with a previous
116: -- call to this function. Just return the value in the global

Line 119: l_legislation_code := ota_tmt_bus.g_legislation_code;

115: -- The legislation code has already been found with a previous
116: -- call to this function. Just return the value in the global
117: -- variable.
118: --
119: l_legislation_code := ota_tmt_bus.g_legislation_code;
120: hr_utility.set_location(l_proc, 20);
121: else
122: --
123: -- The ID is different to the last call to this function

Line 143: ota_tmt_bus.g_tp_measurement_type_id := p_tp_measurement_type_id;

139: -- Set the global variables so the values are
140: -- available for the next call to this function.
141: --
142: close csr_leg_code;
143: ota_tmt_bus.g_tp_measurement_type_id := p_tp_measurement_type_id;
144: ota_tmt_bus.g_legislation_code := l_legislation_code;
145: end if;
146: hr_utility.set_location(' Leaving:'|| l_proc, 40);
147: return l_legislation_code;

Line 144: ota_tmt_bus.g_legislation_code := l_legislation_code;

140: -- available for the next call to this function.
141: --
142: close csr_leg_code;
143: ota_tmt_bus.g_tp_measurement_type_id := p_tp_measurement_type_id;
144: ota_tmt_bus.g_legislation_code := l_legislation_code;
145: end if;
146: hr_utility.set_location(' Leaving:'|| l_proc, 40);
147: return l_legislation_code;
148: end return_legislation_code;

Line 432: ota_tmt_bus1.chk_tp_measurement_code(

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: --

Line 438: ota_tmt_bus1.chk_unit(

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

Line 445: ota_tmt_bus1.chk_budget_level(

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

Line 453: ota_tmt_bus1.chk_cost_level(

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

Line 460: ota_tmt_bus1.chk_budget_cost_combination(

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);

Line 466: ota_tmt_bus1.chk_many_budget_values_flag(

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

Line 474: ota_tmt_bus1.chk_item_type_usage_id(

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);

Line 485: ota_tmt_bus1.chk_legislative_setup(

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

Line 495: ota_tmt_bus.chk_df(p_rec);

491: ,p_many_budget_values_flag => p_rec.many_budget_values_flag
492: ,p_object_version_number => p_rec.object_version_number
493: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
494: --
495: ota_tmt_bus.chk_df(p_rec);
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 100);
498: End insert_validate;
499: --

Line 527: ota_tmt_bus1.chk_unit(

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

Line 534: ota_tmt_bus1.chk_budget_level(

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

Line 542: ota_tmt_bus1.chk_cost_level(

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

Line 549: ota_tmt_bus1.chk_budget_cost_combination(

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);

Line 555: ota_tmt_bus1.chk_many_budget_values_flag(

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

Line 563: ota_tmt_bus1.chk_item_type_usage_id(

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);

Line 574: ota_tmt_bus1.chk_legislative_setup(

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

Line 584: ota_tmt_bus.chk_df(p_rec);

580: ,p_many_budget_values_flag => p_rec.many_budget_values_flag
581: ,p_object_version_number => p_rec.object_version_number
582: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
583: --
584: ota_tmt_bus.chk_df(p_rec);
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 90);
587: End update_validate;
588: --

Line 604: ota_tmt_bus1.chk_del_tp_measurement_code(

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);

Line 609: ota_tmt_bus1.chk_del_tp_measurement_type_id(

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: --

Line 614: end ota_tmt_bus;

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: --
614: end ota_tmt_bus;