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_CPR_INS dependencies on OTA_COURSE_PREREQUISITES

Line 90: -- Insert the row into: ota_course_prerequisites

86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: --
89: --
90: -- Insert the row into: ota_course_prerequisites
91: --
92: insert into ota_course_prerequisites
93: (activity_version_id
94: ,prerequisite_course_id

Line 92: insert into ota_course_prerequisites

88: --
89: --
90: -- Insert the row into: ota_course_prerequisites
91: --
92: insert into ota_course_prerequisites
93: (activity_version_id
94: ,prerequisite_course_id
95: ,business_group_id
96: ,prerequisite_type

Line 178: from ota_course_prerequisites

174: --
175: /*
176: Cursor C_Sel2 is
177: Select null
178: from ota_course_prerequisites
179: where activity_version_id =
180: ota_cpr_ins.g_activity_version_id_i
181: or prerequisite_course_id =
182: ota_cpr_ins.g_prerequisite_course_id_i;*/

Line 205: fnd_message.set_token('TABLE_NAME','ota_course_prerequisites');

201: --
202: -- The primary key values are already in use.
203: --
204: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
205: fnd_message.set_token('TABLE_NAME','ota_course_prerequisites');
206: fnd_message.raise_error;
207: End If;
208: Close C_Sel2;*/
209: --

Line 300: (p_module_name => 'OTA_COURSE_PREREQUISITES'

296: --
297: when hr_api.cannot_find_prog_unit then
298: --
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'OTA_COURSE_PREREQUISITES'
301: ,p_hook_type => 'AI');
302: --
303: end;
304: --

Line 317: l_activity_version_id OTA_COURSE_PREREQUISITES.activity_version_id%TYPE;

313: ,p_rec in out nocopy ota_cpr_shd.g_rec_type
314: ) is
315: --
316: l_proc varchar2(72) := g_package||'ins';
317: l_activity_version_id OTA_COURSE_PREREQUISITES.activity_version_id%TYPE;
318: l_prerequisite_course_id OTA_COURSE_PREREQUISITES.prerequisite_course_id%TYPE;
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);

Line 318: l_prerequisite_course_id OTA_COURSE_PREREQUISITES.prerequisite_course_id%TYPE;

314: ) is
315: --
316: l_proc varchar2(72) := g_package||'ins';
317: l_activity_version_id OTA_COURSE_PREREQUISITES.activity_version_id%TYPE;
318: l_prerequisite_course_id OTA_COURSE_PREREQUISITES.prerequisite_course_id%TYPE;
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --Bug 5586350: Calling set_base_key_value to set global location. Coding standard for elbow tables.