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

Line 34: , ota_course_prerequisites cpr

30: cursor csr_sec_grp is
31: select pbg.security_group_id,
32: pbg.legislation_code
33: from per_business_groups_perf pbg
34: , ota_course_prerequisites cpr
35: where cpr.activity_version_id = p_activity_version_id
36: and cpr.prerequisite_course_id = p_prerequisite_course_id
37: and pbg.business_group_id = cpr.business_group_id;
38: --

Line 113: , ota_course_prerequisites cpr

109: --
110: cursor csr_leg_code is
111: select pbg.legislation_code
112: from per_business_groups_perf pbg
113: , ota_course_prerequisites cpr
114: where cpr.activity_version_id = p_activity_version_id
115: and cpr.prerequisite_course_id = p_prerequisite_course_id
116: and pbg.business_group_id = cpr.business_group_id;
117: --

Line 257: from OTA_COURSE_PREREQUISITES cpr

253: l_proc varchar2(72) := g_package||'check_unique_key';
254: --
255: cursor sel_unique_key is
256: select 'Y'
257: from OTA_COURSE_PREREQUISITES cpr
258: where cpr.activity_version_id = p_activity_version_id
259: and cpr.prerequisite_course_id = p_prerequisite_course_id;
260: --
261: Begin

Line 279: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',

275: hr_utility.set_location(' Leaving:'|| l_proc, 10);
276: Exception
277: WHEN app_exception.application_exception THEN
278: IF hr_multi_message.exception_add(
279: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
280: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
281: THEN
282: hr_utility.set_location(' Leaving:'||l_proc, 22);
283: RAISE;

Line 280: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')

276: Exception
277: WHEN app_exception.application_exception THEN
278: IF hr_multi_message.exception_add(
279: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
280: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
281: THEN
282: hr_utility.set_location(' Leaving:'||l_proc, 22);
283: RAISE;
284:

Line 328: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')

324:
325: Exception
326: WHEN app_exception.application_exception THEN
327: IF hr_multi_message.exception_add(
328: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
329: THEN
330:
331: hr_utility.set_location(' Leaving:'||l_proc, 22);
332: RAISE;

Line 385: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',

381:
382: Exception
383: WHEN app_exception.application_exception THEN
384: IF hr_multi_message.exception_add(
385: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
386: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
387: THEN
388:
389: hr_utility.set_location(' Leaving:'||l_proc, 22);

Line 386: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')

382: Exception
383: WHEN app_exception.application_exception THEN
384: IF hr_multi_message.exception_add(
385: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
386: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
387: THEN
388:
389: hr_utility.set_location(' Leaving:'||l_proc, 22);
390: RAISE;

Line 444: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')

440: Exception
441: WHEN app_exception.application_exception THEN
442:
443: IF hr_multi_message.exception_add(
444: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
445: THEN
446:
447: hr_utility.set_location(' Leaving:'||l_proc, 22);
448: RAISE;

Line 471: from OTA_COURSE_PREREQUISITES cpr

467: ) is
468: --
469: cursor is_course_chained is
470: select 'Y'
471: from OTA_COURSE_PREREQUISITES cpr
472: where cpr.PREREQUISITE_COURSE_ID = p_activity_version_id
473: and cpr.PREREQUISITE_COURSE_ID in
474: (select PREREQUISITE_COURSE_ID
475: from ota_course_prerequisites

Line 475: from ota_course_prerequisites

471: from OTA_COURSE_PREREQUISITES cpr
472: where cpr.PREREQUISITE_COURSE_ID = p_activity_version_id
473: and cpr.PREREQUISITE_COURSE_ID in
474: (select PREREQUISITE_COURSE_ID
475: from ota_course_prerequisites
476: start with ACTIVITY_VERSION_ID = p_prerequisite_course_id
477: connect by prior PREREQUISITE_COURSE_ID = ACTIVITY_VERSION_ID);
478:
479: l_proc varchar2(72) := g_package||'check_course_chaining';

Line 509: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',

505: Exception
506: WHEN app_exception.application_exception THEN
507:
508: IF hr_multi_message.exception_add(
509: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
510: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
511: THEN
512:
513: hr_utility.set_location(' Leaving:'||l_proc, 22);

Line 510: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')

506: WHEN app_exception.application_exception THEN
507:
508: IF hr_multi_message.exception_add(
509: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
510: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
511: THEN
512:
513: hr_utility.set_location(' Leaving:'||l_proc, 22);
514: RAISE;