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_TPS_BUS1 dependencies on OTA_TPS_SHD

Line 59: l_api_updating := ota_tps_shd.api_updating

55: --
56: -- if time period is changing or is an insert,
57: -- check the combination is unique
58: --
59: l_api_updating := ota_tps_shd.api_updating
60: (p_training_plan_id => p_training_plan_id
61: ,p_object_version_number => p_object_version_number
62: );
63: --

Line 68: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

64: -- If the time_period is changing
65: -- or this is an insert
66: --
67: IF (l_api_updating AND
68: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
69: NVL(p_time_period_id, hr_api.g_number) )
70: OR (NOT l_api_updating)
71: THEN
72: hr_utility.set_location(' Step:'|| l_proc, 50);

Line 321: l_api_updating := ota_tps_shd.api_updating

317: ,p_argument => 'p_business_group_id'
318: ,p_argument_value => p_business_group_id
319: );
320: --
321: l_api_updating := ota_tps_shd.api_updating
322: (p_training_plan_id => p_training_plan_id
323: ,p_object_version_number => p_object_version_number
324: );
325: --

Line 330: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

326: -- If the time_period is changing
327: -- or this is an insert
328: --
329: IF (l_api_updating AND
330: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
331: NVL(p_time_period_id, hr_api.g_number) )
332: OR (NOT l_api_updating))
333: THEN
334: --

Line 354: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

350: -- in OTA_TRAINING_PLAN_MEMBERS
351: --
352: hr_utility.set_location(' Step:'|| l_proc, 40);
353: IF l_api_updating AND
354: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
355: NVL(p_time_period_id, hr_api.g_number) THEN
356: hr_utility.set_location(' Step:'|| l_proc, 50);
357: OPEN csr_members;
358: FETCH csr_members INTO l_exists;

Line 525: l_api_updating := ota_tps_shd.api_updating

521: );
522: --
523: hr_utility.set_location(' Step:'|| l_proc, 30);
524: --
525: l_api_updating := ota_tps_shd.api_updating
526: (p_training_plan_id => p_training_plan_id
527: ,p_object_version_number => p_object_version_number
528: );
529: --

Line 535: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

531: -- or the time period is changing
532: -- or this is an insert and its not cancelled
533: --
534: IF (l_api_updating AND
535: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
536: NVL(p_time_period_id, hr_api.g_number)
537: AND p_plan_status_type_id <> 'CANCELLED' )
538: OR (NVL(ota_tps_shd.g_old_rec.plan_status_type_id, hr_api.g_varchar2) <>
539: NVL(p_plan_status_type_id, hr_api.g_varchar2)

Line 538: OR (NVL(ota_tps_shd.g_old_rec.plan_status_type_id, hr_api.g_varchar2) <>

534: IF (l_api_updating AND
535: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
536: NVL(p_time_period_id, hr_api.g_number)
537: AND p_plan_status_type_id <> 'CANCELLED' )
538: OR (NVL(ota_tps_shd.g_old_rec.plan_status_type_id, hr_api.g_varchar2) <>
539: NVL(p_plan_status_type_id, hr_api.g_varchar2)
540: AND
541: (p_plan_status_type_id <> 'CANCELLED') )
542: OR (NOT l_api_updating AND p_plan_status_type_id <> 'CANCELLED'))

Line 624: l_api_updating := ota_tps_shd.api_updating

620: ,p_argument => 'p_budget_currency'
621: ,p_argument_value => p_budget_currency
622: );
623: --
624: l_api_updating := ota_tps_shd.api_updating
625: (p_training_plan_id => p_training_plan_id
626: ,p_object_version_number => p_object_version_number
627: );
628: --

Line 632: NVL(ota_tps_shd.g_old_rec.budget_currency, hr_api.g_varchar2) <>

628: --
629: -- If this is a changing update, or a new insert, test
630: --
631: IF ((l_api_updating AND
632: NVL(ota_tps_shd.g_old_rec.budget_currency, hr_api.g_varchar2) <>
633: NVL(p_budget_currency, hr_api.g_varchar2) )
634: OR (NOT l_api_updating))
635: THEN
636: hr_utility.set_location(' Step:'|| l_proc, 50);

Line 716: l_api_updating := ota_tps_shd.api_updating

712: ,p_argument_value => p_name
713: );
714: --
715: --
716: l_api_updating := ota_tps_shd.api_updating
717: (p_training_plan_id => p_training_plan_id
718: ,p_object_version_number => p_object_version_number
719: );
720: --

Line 725: NVL(ota_tps_shd.g_old_rec.name, hr_api.g_varchar2) <>

721: --
722: -- If this is a changing update, or a new insert, test
723: --
724: IF ((l_api_updating AND
725: NVL(ota_tps_shd.g_old_rec.name, hr_api.g_varchar2) <>
726: NVL(p_name, hr_api.g_varchar2) )
727: OR (NOT l_api_updating))
728: THEN
729: hr_utility.set_location(' Step:'|| l_proc, 50);

Line 846: NVL(ota_tps_shd.g_old_rec.plan_source,hr_api.g_varchar2) <>

842: ,p_argument => 'effective_date'
843: ,p_argument_value => p_effective_date);
844:
845: IF (((p_training_plan_id IS NOT NULL) AND
846: NVL(ota_tps_shd.g_old_rec.plan_source,hr_api.g_varchar2) <>
847: NVL(p_plan_source,hr_api.g_varchar2))
848: OR
849: (p_training_plan_id IS NULL)) THEN
850:

Line 932: l_api_updating := ota_tps_shd.api_updating

928: ,p_argument => 'p_start_date'
929: ,p_argument_value => p_start_date
930: );
931:
932: l_api_updating := ota_tps_shd.api_updating
933: (p_training_plan_id => p_training_plan_id
934: ,p_object_version_number => p_object_version_number
935: );
936: --

Line 941: NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>

937: --
938: -- If this is a changing update, or a new insert, test
939: --
940: IF ((l_api_updating AND
941: NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
942: NVL( p_start_date, hr_api.g_date )
943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>
944: NVL( p_end_date, hr_api.g_date) )
945: OR ( NOT l_api_updating) )

Line 943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>

939: --
940: IF ((l_api_updating AND
941: NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
942: NVL( p_start_date, hr_api.g_date )
943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>
944: NVL( p_end_date, hr_api.g_date) )
945: OR ( NOT l_api_updating) )
946: THEN
947: hr_utility.set_location(' Step:'|| l_proc, 20);

Line 950: or NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>

946: THEN
947: hr_utility.set_location(' Step:'|| l_proc, 20);
948:
949: /* IF ( NOT l_api_updating
950: or NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
951: NVL( p_start_date, hr_api.g_date )) THEN
952:
953: IF ( p_start_date < TRUNC(SYSDATE) ) THEN
954: l_flag :='START_DATE';