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 16: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

12: -- |-----------------------------------------------|
13: -- ----------------------------------------------------------------------------
14: --
15: Procedure chk_tp_measurement_type_id
16: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
17: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
18: ) is
19: --
20: l_cost_level varchar2(30);

Line 17: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

13: -- ----------------------------------------------------------------------------
14: --
15: Procedure chk_tp_measurement_type_id
16: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
17: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
18: ) is
19: --
20: l_cost_level varchar2(30);
21: l_proc varchar2(72) := g_package|| 'chk_tp_measurement_type_id';

Line 72: (p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE

68: -- |-----------------------------------------------------|
69: -- ----------------------------------------------------------------------------
70: --
71: Procedure chk_training_plan_id
72: (p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
73: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
74: ) is
75: --
76: l_exists varchar2(1);

Line 73: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

69: -- ----------------------------------------------------------------------------
70: --
71: Procedure chk_training_plan_id
72: (p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
73: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
74: ) is
75: --
76: l_exists varchar2(1);
77: l_proc varchar2(72) := g_package|| 'chk_training_plan_id';

Line 123: (p_booking_id in ota_training_plan_costs.booking_id%TYPE

119: -- |----------------------------------------------------------|
120: -- ----------------------------------------------------------------------------
121: --
122: Procedure chk_booking_id
123: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
124: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
125: ) is
126: --
127: l_business_group_id ota_training_plan_costs.business_group_id%TYPE;

Line 124: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

120: -- ----------------------------------------------------------------------------
121: --
122: Procedure chk_booking_id
123: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
124: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
125: ) is
126: --
127: l_business_group_id ota_training_plan_costs.business_group_id%TYPE;
128: l_proc varchar2(72) := g_package|| 'chk_booking_id';

Line 127: l_business_group_id ota_training_plan_costs.business_group_id%TYPE;

123: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
124: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
125: ) is
126: --
127: l_business_group_id ota_training_plan_costs.business_group_id%TYPE;
128: l_proc varchar2(72) := g_package|| 'chk_booking_id';
129: --
130: cursor csr_booking_id is
131: select business_group_id

Line 173: (p_booking_id in ota_training_plan_costs.booking_id%TYPE

169: -- |--------------------------------------------------------|
170: -- ----------------------------------------------------------------------------
171: --
172: Procedure chk_booking_event
173: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
174: ,p_event_id in ota_training_plan_costs.event_id%TYPE
175: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
176: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
177: ) is

Line 174: ,p_event_id in ota_training_plan_costs.event_id%TYPE

170: -- ----------------------------------------------------------------------------
171: --
172: Procedure chk_booking_event
173: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
174: ,p_event_id in ota_training_plan_costs.event_id%TYPE
175: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
176: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
177: ) is
178: --

Line 175: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

171: --
172: Procedure chk_booking_event
173: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
174: ,p_event_id in ota_training_plan_costs.event_id%TYPE
175: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
176: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
177: ) is
178: --
179: l_cost_level ota_tp_measurement_types.cost_level%TYPE;

Line 176: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

172: Procedure chk_booking_event
173: (p_booking_id in ota_training_plan_costs.booking_id%TYPE
174: ,p_event_id in ota_training_plan_costs.event_id%TYPE
175: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
176: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
177: ) is
178: --
179: l_cost_level ota_tp_measurement_types.cost_level%TYPE;
180: l_proc varchar2(72) := g_package|| 'chk_booking_event';

Line 252: (p_event_id in ota_training_plan_costs.event_id%TYPE

248: -- |-------------------------------------------------------------|
249: -- ----------------------------------------------------------------------------
250: --
251: Procedure chk_event_id
252: (p_event_id in ota_training_plan_costs.event_id%TYPE
253: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
254: ,p_training_plan_id in ota_training_plans.training_plan_id%TYPE
255: ) is
256: --

Line 253: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

249: -- ----------------------------------------------------------------------------
250: --
251: Procedure chk_event_id
252: (p_event_id in ota_training_plan_costs.event_id%TYPE
253: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
254: ,p_training_plan_id in ota_training_plans.training_plan_id%TYPE
255: ) is
256: --
257: l_business_group_id ota_training_plan_costs.business_group_id%TYPE;

Line 257: l_business_group_id ota_training_plan_costs.business_group_id%TYPE;

253: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
254: ,p_training_plan_id in ota_training_plans.training_plan_id%TYPE
255: ) is
256: --
257: l_business_group_id ota_training_plan_costs.business_group_id%TYPE;
258: l_plan_start_date per_time_periods.start_date%TYPE;
259: l_event_start_date ota_events.course_start_date%TYPE;
260: l_proc varchar2(72) := g_package|| 'chk_event_id';
261: --

Line 334: (p_currency_code in ota_training_plan_costs.currency_code%TYPE

330: -- |-------------------------------------------------------|
331: -- ----------------------------------------------------------------------------
332: --
333: Procedure chk_currency_value
334: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
335: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
336: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
337: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
338: ,p_amount in ota_training_plan_costs.amount%TYPE

Line 335: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE

331: -- ----------------------------------------------------------------------------
332: --
333: Procedure chk_currency_value
334: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
335: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
336: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
337: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
338: ,p_amount in ota_training_plan_costs.amount%TYPE
339: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

Line 336: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE

332: --
333: Procedure chk_currency_value
334: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
335: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
336: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
337: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
338: ,p_amount in ota_training_plan_costs.amount%TYPE
339: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
340: )is

Line 337: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE

333: Procedure chk_currency_value
334: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
335: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
336: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
337: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
338: ,p_amount in ota_training_plan_costs.amount%TYPE
339: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
340: )is
341: --

Line 338: ,p_amount in ota_training_plan_costs.amount%TYPE

334: (p_currency_code in ota_training_plan_costs.currency_code%TYPE
335: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
336: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
337: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
338: ,p_amount in ota_training_plan_costs.amount%TYPE
339: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
340: )is
341: --
342: l_exists varchar2(1);

Line 339: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

335: ,p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
336: ,p_object_version_number in ota_training_plan_costs.object_version_number%TYPE
337: ,p_business_group_id in ota_training_plan_costs.business_group_id%TYPE
338: ,p_amount in ota_training_plan_costs.amount%TYPE
339: ,p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
340: )is
341: --
342: l_exists varchar2(1);
343: l_proc varchar2(72) := g_package|| 'chk_currency_value';

Line 454: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE

450: -- |---------------------------------------------------------------|
451: -- ----------------------------------------------------------------------------
452: --
453: Procedure chk_unique
454: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
455: ,p_event_id in ota_training_plan_costs.event_id%TYPE
456: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE
457: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
458: ) is

Line 455: ,p_event_id in ota_training_plan_costs.event_id%TYPE

451: -- ----------------------------------------------------------------------------
452: --
453: Procedure chk_unique
454: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
455: ,p_event_id in ota_training_plan_costs.event_id%TYPE
456: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE
457: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
458: ) is
459: --

Line 456: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE

452: --
453: Procedure chk_unique
454: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
455: ,p_event_id in ota_training_plan_costs.event_id%TYPE
456: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE
457: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
458: ) is
459: --
460: l_proc varchar2(72) := g_package|| 'chk_unique';

Line 457: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE

453: Procedure chk_unique
454: (p_tp_measurement_type_id in ota_training_plan_costs.tp_measurement_type_id%TYPE
455: ,p_event_id in ota_training_plan_costs.event_id%TYPE
456: ,p_booking_id in ota_training_plan_costs.booking_id%TYPE
457: ,p_training_plan_id in ota_training_plan_costs.training_plan_id%TYPE
458: ) is
459: --
460: l_proc varchar2(72) := g_package|| 'chk_unique';
461: l_exists varchar2(1);

Line 465: from OTA_TRAINING_PLAN_COSTS

461: l_exists varchar2(1);
462: --
463: cursor csr_unique is
464: select null
465: from OTA_TRAINING_PLAN_COSTS
466: where tp_measurement_type_id = p_tp_measurement_type_id
467: and training_plan_id = p_training_plan_id
468: and((p_event_id is not null and event_id = p_event_id)
469: or p_event_id is null)