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

Line 193: l_api_updating := ota_tmt_shd.api_updating

189: ,p_argument => 'p_effective_date'
190: ,p_argument_value => p_effective_date
191: );
192: --
193: l_api_updating := ota_tmt_shd.api_updating
194: (p_tp_measurement_type_id => p_tp_measurement_type_id
195: ,p_object_version_number => p_object_version_number
196: );
197: --

Line 201: nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>

197: --
198: -- If this is a changing update, or a new insert, test
199: --
200: if ((l_api_updating and
201: nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>
202: nvl(p_unit, hr_api.g_varchar2))
203: or (NOT l_api_updating))
204: then
205: hr_utility.set_location(l_proc, 50);

Line 231: and nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>

227: --
228: -- but changes are only allowed if there are no current recs in costs
229: --
230: If l_api_updating
231: and nvl(ota_tmt_shd.g_old_rec.unit, hr_api.g_varchar2) <>
232: nvl(p_unit, hr_api.g_varchar2) then
233: hr_utility.set_location(' Step:'|| l_proc, 80);
234: open csr_chk_no_cost_recs;
235: fetch csr_chk_no_cost_recs into l_exists;

Line 305: l_api_updating := ota_tmt_shd.api_updating

301: ,p_argument => 'p_budget_level'
302: ,p_argument_value => p_budget_level
303: );
304: --
305: l_api_updating := ota_tmt_shd.api_updating
306: (p_tp_measurement_type_id => p_tp_measurement_type_id
307: ,p_object_version_number => p_object_version_number
308: );
309: --

Line 313: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>

309: --
310: -- If this is a changing update, or a new insert, test
311: --
312: if (l_api_updating and
313: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
314: nvl(p_budget_level, hr_api.g_varchar2))
315: or (NOT l_api_updating)
316: then
317: hr_utility.set_location(l_proc, 60);

Line 337: and nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>

333: --
334: -- but changes are only allowed if there are no current recs in budget elements
335: --
336: If l_api_updating
337: and nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
338: nvl(p_budget_level, hr_api.g_varchar2) then
339: hr_utility.set_location(' Step:'|| l_proc, 80);
340: open csr_upd_tp_budget_level;
341: fetch csr_upd_tp_budget_level into l_exists;

Line 388: l_api_updating := ota_tmt_shd.api_updating

384: ,p_argument_value => p_cost_level
385: );
386: hr_utility.set_location(' Step:'|| l_proc, 30);
387:
388: l_api_updating := ota_tmt_shd.api_updating
389: (p_tp_measurement_type_id => p_tp_measurement_type_id
390: ,p_object_version_number => p_object_version_number
391: );
392: --

Line 397: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>

393: -- If either budget level or cost level is changing, or this is an
394: -- insert, check the combinations
395: --
396: if ((l_api_updating and
397: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
398: nvl(p_budget_level, hr_api.g_varchar2)
399: or
400: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
401: nvl(p_cost_level, hr_api.g_varchar2))

Line 400: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>

396: if ((l_api_updating and
397: nvl(ota_tmt_shd.g_old_rec.budget_level, hr_api.g_varchar2) <>
398: nvl(p_budget_level, hr_api.g_varchar2)
399: or
400: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
401: nvl(p_cost_level, hr_api.g_varchar2))
402: or (NOT l_api_updating))
403: then
404: hr_utility.set_location(l_proc, 50);

Line 465: l_api_updating := ota_tmt_shd.api_updating

461: ,p_argument => 'p_cost_level'
462: ,p_argument_value => p_cost_level
463: );
464: --
465: l_api_updating := ota_tmt_shd.api_updating
466: (p_tp_measurement_type_id => p_tp_measurement_type_id
467: ,p_object_version_number => p_object_version_number
468: );
469: --

Line 473: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>

469: --
470: -- If this is a changing update, or a new insert, test
471: --
472: if (l_api_updating and
473: nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
474: nvl(p_cost_level, hr_api.g_varchar2))
475: or (NOT l_api_updating)
476: then
477: hr_utility.set_location(l_proc, 60);

Line 497: and nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>

493: --
494: -- but changes are only allowed if there are no current recs in cost table
495: --
496: If l_api_updating
497: and nvl(ota_tmt_shd.g_old_rec.cost_level, hr_api.g_varchar2) <>
498: nvl(p_cost_level, hr_api.g_varchar2) then
499: hr_utility.set_location(' Step:'|| l_proc, 80);
500: open csr_upd_cost_level;
501: fetch csr_upd_cost_level into l_exists;

Line 577: l_api_updating := ota_tmt_shd.api_updating

573: ,p_argument => 'p_many_budget_values_flag'
574: ,p_argument_value => p_many_budget_values_flag
575: );
576: --
577: l_api_updating := ota_tmt_shd.api_updating
578: (p_tp_measurement_type_id => p_tp_measurement_type_id
579: ,p_object_version_number => p_object_version_number
580: );
581: --

Line 585: nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>

581: --
582: -- If this is a changing update, or a new insert, test
583: --
584: if ((l_api_updating and
585: nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>
586: nvl(p_many_budget_values_flag, hr_api.g_varchar2))
587: or (NOT l_api_updating))
588: then
589: hr_utility.set_location(l_proc, 60);

Line 610: and (nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>

606: -- but changes to 'N' are only allowed if there zero or 1 recs in budget elements
607: --
608: If l_api_updating
609: and p_many_budget_values_flag = 'N'
610: and (nvl(ota_tmt_shd.g_old_rec.many_budget_values_flag, hr_api.g_varchar2) <>
611: nvl(p_many_budget_values_flag, hr_api.g_varchar2)) then
612: hr_utility.set_location(' Step:'|| l_proc, 80);
613: open csr_upd_tp_budget_flag;
614: fetch csr_upd_tp_budget_flag into l_exists;

Line 657: l_api_updating := ota_tmt_shd.api_updating

653: (p_api_name => l_proc
654: ,p_argument => 'p_business_group_id'
655: ,p_argument_value => p_business_group_id
656: );
657: l_api_updating := ota_tmt_shd.api_updating
658: (p_tp_measurement_type_id => p_tp_measurement_type_id
659: ,p_object_version_number => p_object_version_number
660: );
661: --

Line 667: nvl(ota_tmt_shd.g_old_rec.item_type_usage_id, hr_api.g_number) <>

663: -- If this is a changing update, or a new insert, test
664: --
665: If p_item_type_usage_id is not null then
666: If ((l_api_updating and
667: nvl(ota_tmt_shd.g_old_rec.item_type_usage_id, hr_api.g_number) <>
668: nvl(p_item_type_usage_id, hr_api.g_number))
669: or (NOT l_api_updating))
670: Then
671: -- Test that it exists in hr_summary