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_BUS1 dependencies on OTA_TRAINING_PLAN_COSTS

Line 35: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

31: --
32: -- {End Of Comments}
33: -- ----------------------------------------------------------------------------
34: Procedure chk_tp_measurement_type_id
35: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
36: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
37: );
38: -- ----------------------------------------------------------------------------
39: -- |----------------------------------------------------|

Line 36: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

32: -- {End Of Comments}
33: -- ----------------------------------------------------------------------------
34: Procedure chk_tp_measurement_type_id
35: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
36: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
37: );
38: -- ----------------------------------------------------------------------------
39: -- |----------------------------------------------------|
40: -- ----------------------------------------------------------------------------

Line 69: (p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE

65: --
66: -- {End Of Comments}
67: -- ----------------------------------------------------------------------------
68: Procedure chk_training_plan_id
69: (p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
70: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
71: );
72: -- ----------------------------------------------------------------------------
73: -- |----------------------------------------------------------|

Line 70: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

66: -- {End Of Comments}
67: -- ----------------------------------------------------------------------------
68: Procedure chk_training_plan_id
69: (p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
70: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
71: );
72: -- ----------------------------------------------------------------------------
73: -- |----------------------------------------------------------|
74: -- ----------------------------------------------------------------------------

Line 103: (p_booking_id in ota_training_plan_costs.booking_id%TYPE

99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure chk_booking_id
103: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
104: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
105: );
106: -- ----------------------------------------------------------------------------
107: -- |--------------------------------------------------------|

Line 104: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure chk_booking_id
103: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
104: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
105: );
106: -- ----------------------------------------------------------------------------
107: -- |--------------------------------------------------------|
108: -- ----------------------------------------------------------------------------

Line 141: (p_booking_id in ota_training_plan_costs.booking_id%TYPE

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure chk_booking_event
141: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
142: ,p_event_id in ota_training_plan_costs.event_id%TYPE
143: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
144: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
145: );

Line 142: ,p_event_id in ota_training_plan_costs.event_id%TYPE

138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure chk_booking_event
141: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
142: ,p_event_id in ota_training_plan_costs.event_id%TYPE
143: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
144: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
145: );
146: -- ----------------------------------------------------------------------------

Line 143: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

139: -- ----------------------------------------------------------------------------
140: Procedure chk_booking_event
141: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
142: ,p_event_id in ota_training_plan_costs.event_id%TYPE
143: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
144: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
145: );
146: -- ----------------------------------------------------------------------------
147: -- |------------------------------------------------------------|

Line 144: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

140: Procedure chk_booking_event
141: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
142: ,p_event_id in ota_training_plan_costs.event_id%TYPE
143: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
144: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
145: );
146: -- ----------------------------------------------------------------------------
147: -- |------------------------------------------------------------|
148: -- ----------------------------------------------------------------------------

Line 178: (p_event_id in ota_training_plan_costs.event_id%TYPE

174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure chk_event_id
178: (p_event_id in ota_training_plan_costs.event_id%TYPE
179: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
180: ,p_training_plan_id in ota_training_plans.training_plan_id%TYPE
181: );
182: -- ----------------------------------------------------------------------------

Line 179: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure chk_event_id
178: (p_event_id in ota_training_plan_costs.event_id%TYPE
179: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
180: ,p_training_plan_id in ota_training_plans.training_plan_id%TYPE
181: );
182: -- ----------------------------------------------------------------------------
183: -- |-------------------------------------------------------|

Line 220: (p_currency_code in ota_training_plan_costs.currency_code%TYPE

216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure chk_currency_value
220: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
221: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
222: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
223: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
224: ,p_amount in ota_training_plan_costs.amount%TYPE

Line 221: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE

217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure chk_currency_value
220: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
221: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
222: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
223: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
224: ,p_amount in ota_training_plan_costs.amount%TYPE
225: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

Line 222: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE

218: -- ----------------------------------------------------------------------------
219: Procedure chk_currency_value
220: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
221: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
222: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
223: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
224: ,p_amount in ota_training_plan_costs.amount%TYPE
225: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
226: );

Line 223: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

219: Procedure chk_currency_value
220: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
221: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
222: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
223: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
224: ,p_amount in ota_training_plan_costs.amount%TYPE
225: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
226: );
227: -- ----------------------------------------------------------------------------

Line 224: ,p_amount in ota_training_plan_costs.amount%TYPE

220: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
221: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
222: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
223: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
224: ,p_amount in ota_training_plan_costs.amount%TYPE
225: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
226: );
227: -- ----------------------------------------------------------------------------
228: -- |--------------------------------------------------------------|

Line 225: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

221: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
222: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
223: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
224: ,p_amount in ota_training_plan_costs.amount%TYPE
225: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
226: );
227: -- ----------------------------------------------------------------------------
228: -- |--------------------------------------------------------------|
229: -- ----------------------------------------------------------------------------

Line 266: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

262: --
263: -- {End Of Comments}
264: -- ----------------------------------------------------------------------------
265: Procedure chk_unique
266: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
267: ,p_event_id in ota_training_plan_costs.event_id%TYPE
268: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE
269: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
270: );

Line 267: ,p_event_id in ota_training_plan_costs.event_id%TYPE

263: -- {End Of Comments}
264: -- ----------------------------------------------------------------------------
265: Procedure chk_unique
266: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
267: ,p_event_id in ota_training_plan_costs.event_id%TYPE
268: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE
269: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
270: );
271: end ota_tpc_bus1;

Line 268: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE

264: -- ----------------------------------------------------------------------------
265: Procedure chk_unique
266: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
267: ,p_event_id in ota_training_plan_costs.event_id%TYPE
268: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE
269: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
270: );
271: end ota_tpc_bus1;

Line 269: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE

265: Procedure chk_unique
266: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
267: ,p_event_id in ota_training_plan_costs.event_id%TYPE
268: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE
269: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
270: );
271: end ota_tpc_bus1;