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_TPC_BUS dependencies on OTA_TPC_BUS

Line 1: Package Body ota_tpc_bus as

1: Package Body ota_tpc_bus as
2: /* $Header: ottpcrhi.pkb 115.5 2003/06/17 14:27:43 sfmorris noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_tpc_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_tpc_bus.g_training_plan_cost_id, hr_api.g_number)

108: ,p_argument => 'training_plan_cost_id'
109: ,p_argument_value => p_training_plan_cost_id
110: );
111: --
112: if ( nvl(ota_tpc_bus.g_training_plan_cost_id, hr_api.g_number)
113: = p_training_plan_cost_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_tpc_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_tpc_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_tpc_bus.g_training_plan_cost_id := p_training_plan_cost_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_tpc_bus.g_training_plan_cost_id := p_training_plan_cost_id;
144: ota_tpc_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_tpc_bus.g_legislation_code := l_legislation_code;

140: -- available for the next call to this function.
141: --
142: close csr_leg_code;
143: ota_tpc_bus.g_training_plan_cost_id := p_training_plan_cost_id;
144: ota_tpc_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 619: ota_tpc_bus1.chk_tp_measurement_type_id(

615: --
616: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
617: --
618: hr_utility.set_location(' Step:'|| l_proc, 10);
619: ota_tpc_bus1.chk_tp_measurement_type_id(
620: p_tp_measurement_type_id => p_rec.tp_measurement_type_id
621: ,p_business_group_id => p_rec.business_group_id);
622: --
623: hr_utility.set_location(' Step:'|| l_proc, 20);

Line 624: ota_tpc_bus1.chk_training_plan_id (

620: p_tp_measurement_type_id => p_rec.tp_measurement_type_id
621: ,p_business_group_id => p_rec.business_group_id);
622: --
623: hr_utility.set_location(' Step:'|| l_proc, 20);
624: ota_tpc_bus1.chk_training_plan_id (
625: p_training_plan_id => p_rec.training_plan_id
626: ,p_business_group_id => p_rec.business_group_id);
627: --
628: hr_utility.set_location(' Step:'|| l_proc, 30);

Line 629: ota_tpc_bus1.chk_booking_id (

625: p_training_plan_id => p_rec.training_plan_id
626: ,p_business_group_id => p_rec.business_group_id);
627: --
628: hr_utility.set_location(' Step:'|| l_proc, 30);
629: ota_tpc_bus1.chk_booking_id (
630: p_booking_id => p_rec.booking_id
631: ,p_business_group_id => p_rec.business_group_id);
632: --
633: hr_utility.set_location(' Step:'|| l_proc, 40);

Line 634: ota_tpc_bus1.chk_event_id (

630: p_booking_id => p_rec.booking_id
631: ,p_business_group_id => p_rec.business_group_id);
632: --
633: hr_utility.set_location(' Step:'|| l_proc, 40);
634: ota_tpc_bus1.chk_event_id (
635: p_event_id => p_rec.event_id
636: ,p_training_plan_id => p_rec.training_plan_id
637: ,p_business_group_id => p_rec.business_group_id);
638: --

Line 640: ota_tpc_bus1.chk_booking_event (

636: ,p_training_plan_id => p_rec.training_plan_id
637: ,p_business_group_id => p_rec.business_group_id);
638: --
639: hr_utility.set_location(' Step:'|| l_proc, 50);
640: ota_tpc_bus1.chk_booking_event (
641: p_booking_id => p_rec.booking_id
642: ,p_event_id => p_rec.event_id
643: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id
644: ,p_business_group_id => p_rec.business_group_id);

Line 647: ota_tpc_bus1.chk_unique (

643: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id
644: ,p_business_group_id => p_rec.business_group_id);
645: --
646: hr_utility.set_location(' Step:'|| l_proc, 60);
647: ota_tpc_bus1.chk_unique (
648: p_event_id => p_rec.event_id
649: ,p_booking_id => p_rec.booking_id
650: ,p_training_plan_id => p_rec.training_plan_id
651: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);

Line 654: ota_tpc_bus1.chk_currency_value (

650: ,p_training_plan_id => p_rec.training_plan_id
651: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
652: --
653: hr_utility.set_location(' Step:'|| l_proc, 70);
654: ota_tpc_bus1.chk_currency_value (
655: p_currency_code => p_rec.currency_code
656: ,p_training_plan_cost_id => p_rec.training_plan_cost_id
657: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id
658: ,p_business_group_id => p_rec.business_group_id

Line 663: ota_tpc_bus.chk_ddf(p_rec);

659: ,p_object_version_number => p_rec.object_version_number
660: ,p_amount => p_rec.amount);
661: --
662: --
663: ota_tpc_bus.chk_ddf(p_rec);
664: --
665: ota_tpc_bus.chk_df(p_rec);
666: --
667: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 665: ota_tpc_bus.chk_df(p_rec);

661: --
662: --
663: ota_tpc_bus.chk_ddf(p_rec);
664: --
665: ota_tpc_bus.chk_df(p_rec);
666: --
667: hr_utility.set_location(' Leaving:'||l_proc, 10);
668: End insert_validate;
669: --

Line 695: ota_tpc_bus1.chk_currency_value (

691: --
692: hr_utility.set_location(' Step:'|| l_proc, 10);
693: --
694: hr_utility.set_location(' Step:'|| l_proc, 20);
695: ota_tpc_bus1.chk_currency_value (
696: p_currency_code => p_rec.currency_code
697: ,p_training_plan_cost_id => p_rec.training_plan_cost_id
698: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id
699: ,p_business_group_id => p_rec.business_group_id

Line 704: ota_tpc_bus.chk_ddf(p_rec);

700: ,p_object_version_number => p_rec.object_version_number
701: ,p_amount => p_rec.amount);
702: --
703: --
704: ota_tpc_bus.chk_ddf(p_rec);
705: --
706: ota_tpc_bus.chk_df(p_rec);
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 706: ota_tpc_bus.chk_df(p_rec);

702: --
703: --
704: ota_tpc_bus.chk_ddf(p_rec);
705: --
706: ota_tpc_bus.chk_df(p_rec);
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 30);
709: End update_validate;
710: --

Line 728: end ota_tpc_bus;

724: --
725: hr_utility.set_location(' Leaving:'||l_proc, 10);
726: End delete_validate;
727: --
728: end ota_tpc_bus;