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_TPM_BUS1 dependencies on OTA_TPM_SHD

Line 107: l_api_updating := ota_tpm_shd.api_updating

103: ,p_argument => 'p_business_group_id'
104: ,p_argument_value => p_business_group_id
105: );
106: --
107: l_api_updating := ota_tpm_shd.api_updating
108: (p_training_plan_member_id => p_training_plan_member_id
109: ,p_object_version_number => p_object_version_number
110: );
111: --

Line 116: NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>

112: -- If this is a changing update, or a new insert, test
113: --
114: IF p_activity_definition_id IS NOT NULL THEN
115: IF ((l_api_updating AND
116: NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
117: NVL(p_activity_definition_id, hr_api.g_number) )
118: OR (NOT l_api_updating) )
119: THEN
120: -- Check that the definition exists

Line 210: l_api_updating := ota_tpm_shd.api_updating

206: fnd_message.raise_error;
207: END IF;
208: --
209: --
210: l_api_updating := ota_tpm_shd.api_updating
211: (p_training_plan_member_id => p_training_plan_member_id
212: ,p_object_version_number => p_object_version_number
213: );
214: --

Line 218: (NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>

214: --
215: -- If this is a changing update, no budget records are allowed
216: --
217: IF (l_api_updating AND
218: (NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
219: NVL(p_activity_version_id, hr_api.g_number)
220: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
221: NVL(p_activity_definition_id, hr_api.g_number) )) THEN
222: --

Line 220: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>

216: --
217: IF (l_api_updating AND
218: (NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
219: NVL(p_activity_version_id, hr_api.g_number)
220: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
221: NVL(p_activity_definition_id, hr_api.g_number) )) THEN
222: --
223: hr_utility.set_location(' Step:'|| l_proc, 50);
224: OPEN csr_version_definition;

Line 321: l_api_updating := ota_tpm_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_tpm_shd.api_updating
322: (p_training_plan_member_id => p_training_plan_member_id
323: ,p_object_version_number => p_object_version_number
324: );
325: --

Line 330: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>

326: -- If this is a changing update, or a new insert, test
327: --
328: IF p_activity_version_id IS NOT NULL THEN
329: IF (l_api_updating AND
330: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
331: NVL(p_activity_version_id, hr_api.g_number) )
332: OR (NOT l_api_updating)
333: THEN
334: -- Check that the definition exists

Line 509: l_api_updating := ota_tpm_shd.api_updating

505: ,p_argument => 'p_training_plan_id'
506: ,p_argument_value => p_training_plan_id
507: );
508: --
509: l_api_updating := ota_tpm_shd.api_updating
510: (p_training_plan_member_id => p_training_plan_member_id
511: ,p_object_version_number => p_object_version_number
512: );
513: --

Line 517: NVL(ota_tpm_shd.g_old_rec.member_status_type_id, hr_api.g_VARCHAR2) <>

513: --
514: -- If this is a changing update, or a new insert, test status is valid
515: --
516: IF (l_api_updating AND
517: NVL(ota_tpm_shd.g_old_rec.member_status_type_id, hr_api.g_VARCHAR2) <>
518: NVL(p_member_status_type_id, hr_api.g_VARCHAR2) )
519: OR (NOT l_api_updating)
520: THEN
521: -- Check that the lookup code is valid

Line 630: l_api_updating := ota_tpm_shd.api_updating

626: ,p_argument => 'p_training_plan_id'
627: ,p_argument_value => p_training_plan_id
628: );
629:
630: l_api_updating := ota_tpm_shd.api_updating
631: (p_training_plan_member_id => p_training_plan_member_id
632: ,p_object_version_number => p_object_version_number);
633: --
634: -- Check if anything is changing, or this is an insert

Line 637: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>

633: --
634: -- Check if anything is changing, or this is an insert
635: --
636: IF (l_api_updating AND
637: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
638: NVL(p_activity_version_id, hr_api.g_number)
639: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
640: NVL(p_activity_definition_id, hr_api.g_number))
641: OR (NOT l_api_updating) THEN

Line 639: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>

635: --
636: IF (l_api_updating AND
637: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
638: NVL(p_activity_version_id, hr_api.g_number)
639: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
640: NVL(p_activity_definition_id, hr_api.g_number))
641: OR (NOT l_api_updating) THEN
642: --
643: -- check the combination is unique

Line 731: l_api_updating := ota_tpm_shd.api_updating

727: ,p_argument => 'p_training_plan_id'
728: ,p_argument_value => p_training_plan_id
729: );
730:
731: l_api_updating := ota_tpm_shd.api_updating
732: (p_training_plan_member_id => p_training_plan_member_id
733: ,p_object_version_number => p_object_version_number);
734: --
735: -- Check if anything is changing, or this is an insert

Line 738: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>

734: --
735: -- Check if anything is changing, or this is an insert
736: --
737: IF (l_api_updating AND
738: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
739: NVL(p_activity_version_id, hr_api.g_number)
740: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
741: NVL(p_activity_definition_id, hr_api.g_number)
742: OR NVL(ota_tpm_shd.g_old_rec.target_completion_date, hr_api.g_date) <>

Line 740: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>

736: --
737: IF (l_api_updating AND
738: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
739: NVL(p_activity_version_id, hr_api.g_number)
740: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
741: NVL(p_activity_definition_id, hr_api.g_number)
742: OR NVL(ota_tpm_shd.g_old_rec.target_completion_date, hr_api.g_date) <>
743: NVL(p_target_completion_date, hr_api.g_date))
744: OR (NOT l_api_updating) THEN

Line 742: OR NVL(ota_tpm_shd.g_old_rec.target_completion_date, hr_api.g_date) <>

738: NVL(ota_tpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
739: NVL(p_activity_version_id, hr_api.g_number)
740: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
741: NVL(p_activity_definition_id, hr_api.g_number)
742: OR NVL(ota_tpm_shd.g_old_rec.target_completion_date, hr_api.g_date) <>
743: NVL(p_target_completion_date, hr_api.g_date))
744: OR (NOT l_api_updating) THEN
745: --
746: -- check the combination is unique

Line 891: NVL(ota_tpm_shd.g_old_rec.source_function,hr_api.g_VARCHAR2) <>

887: ,p_argument => 'effective_date'
888: ,p_argument_value => p_effective_date);
889:
890: IF (((p_training_plan_member_id IS NOT NULL) AND
891: NVL(ota_tpm_shd.g_old_rec.source_function,hr_api.g_VARCHAR2) <>
892: NVL(p_source_function,hr_api.g_VARCHAR2))
893: OR
894: (p_training_plan_member_id IS NULL)) THEN
895:

Line 952: NVL(ota_tpm_shd.g_old_rec.cancellation_reason,hr_api.g_VARCHAR2) <>

948: ,p_argument => 'effective_date'
949: ,p_argument_value => p_effective_date);
950:
951: IF (((p_training_plan_member_id IS NOT NULL) AND
952: NVL(ota_tpm_shd.g_old_rec.cancellation_reason,hr_api.g_VARCHAR2) <>
953: NVL(p_cancellation_reason,hr_api.g_VARCHAR2))
954: OR
955: (p_training_plan_member_id IS NULL)) THEN
956:

Line 1050: l_api_updating := ota_tpm_shd.api_updating

1046: ,p_argument => 'p_training_plan_id'
1047: ,p_argument_value => p_training_plan_id
1048: );
1049:
1050: l_api_updating := ota_tpm_shd.api_updating
1051: (p_training_plan_member_id => p_training_plan_member_id
1052: ,p_object_version_number => p_object_version_number
1053: );
1054: --

Line 1059: NVL(ota_tpm_shd.g_old_rec.earliest_start_date, hr_api.g_date) <>

1055: --
1056: -- If this is a changing update, or a new insert, test
1057: --
1058: IF ((l_api_updating AND
1059: NVL(ota_tpm_shd.g_old_rec.earliest_start_date, hr_api.g_date) <>
1060: NVL(p_earliest_start_date, hr_api.g_date)
1061: OR NVL(ota_tpm_shd.g_old_rec.target_completion_date, hr_api.g_date) <>
1062: NVL(p_target_completion_date, hr_api.g_date) )
1063: OR (NOT l_api_updating))

Line 1061: OR NVL(ota_tpm_shd.g_old_rec.target_completion_date, hr_api.g_date) <>

1057: --
1058: IF ((l_api_updating AND
1059: NVL(ota_tpm_shd.g_old_rec.earliest_start_date, hr_api.g_date) <>
1060: NVL(p_earliest_start_date, hr_api.g_date)
1061: OR NVL(ota_tpm_shd.g_old_rec.target_completion_date, hr_api.g_date) <>
1062: NVL(p_target_completion_date, hr_api.g_date) )
1063: OR (NOT l_api_updating))
1064: THEN
1065: hr_utility.set_location(' Step:'|| l_proc, 20);

Line 1068: or NVL(ota_tpm_shd.g_old_rec.earliest_start_date, hr_api.g_date) <>

1064: THEN
1065: hr_utility.set_location(' Step:'|| l_proc, 20);
1066:
1067: /* IF( NOT l_api_updating
1068: or NVL(ota_tpm_shd.g_old_rec.earliest_start_date, hr_api.g_date) <>
1069: NVL(p_earliest_start_date, hr_api.g_date)) THEN
1070:
1071: IF ( p_earliest_start_date < TRUNC(SYSDATE))THEN
1072: l_flag := 'START_DATE';