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

Line 277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is

273: p_user_type in ota_attempts.user_type%type,
274: p_act_ver_id in ota_activity_versions.activity_version_id%type
275: ) RETURN varchar2 is
276: -- Bug 13035257
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
278: select ocp.prerequisite_course_id
279: from ota_activity_versions oav,
280: ota_course_prerequisites ocp
281: where ocp.activity_version_id = p_act_ver_id

Line 280: ota_course_prerequisites ocp

276: -- Bug 13035257
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
278: select ocp.prerequisite_course_id
279: from ota_activity_versions oav,
280: ota_course_prerequisites ocp
281: where ocp.activity_version_id = p_act_ver_id
282: and ocp.enforcement_mode in ('B', p_enforcement_mode)
283: and ocp.prerequisite_type = 'M'
284: and ocp.prerequisite_course_id = oav.activity_version_id

Line 296: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;

292: and cpe.mandatory = 'Y'
293: and cpe.type = 'OTA_COMP_PREREQ';
294:
295: l_completed_status varchar2(1);
296: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;
297: Begin
298: l_completed_status := 'Y';
299: If ( p_user_type = 'C') Then --Customer
300: l_enforcement_mode := 'E'; --External

Line 337: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is

333: p_user_type in ota_attempts.user_type%type,
334: p_act_ver_id in ota_activity_versions.activity_version_id%type
335: ) RETURN varchar2 is
336:
337: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
338: select ocp.prerequisite_course_id
339: from ota_activity_versions oav,
340: ota_course_prerequisites ocp
341: where ocp.activity_version_id = p_act_ver_id

Line 340: ota_course_prerequisites ocp

336:
337: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
338: select ocp.prerequisite_course_id
339: from ota_activity_versions oav,
340: ota_course_prerequisites ocp
341: where ocp.activity_version_id = p_act_ver_id
342: and ocp.enforcement_mode in ('B', p_enforcement_mode)
343: and ocp.prerequisite_type = 'A'
344: and ocp.prerequisite_course_id = oav.activity_version_id

Line 356: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;

352: and ( cpe.mandatory = 'N' or cpe.mandatory is null )
353: and cpe.type = 'OTA_COMP_PREREQ';
354:
355: l_completed_status varchar2(1);
356: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;
357: Begin
358: l_completed_status := 'Y';
359: If ( p_user_type = 'C') Then --Customer
360: l_enforcement_mode := 'E'; --External

Line 499: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is

495: p_act_ver_id in ota_activity_versions.activity_version_id%type
496: ) RETURN varchar2
497: IS
498:
499: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
500: SELECT cpr.prerequisite_course_id
501: FROM ota_course_prerequisites cpr
502: WHERE cpr.activity_version_id = p_act_ver_id
503: and cpr.prerequisite_type = 'M'

Line 501: FROM ota_course_prerequisites cpr

497: IS
498:
499: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
500: SELECT cpr.prerequisite_course_id
501: FROM ota_course_prerequisites cpr
502: WHERE cpr.activity_version_id = p_act_ver_id
503: and cpr.prerequisite_type = 'M'
504: and cpr.enforcement_mode in ('B', p_enforcement_mode);
505:

Line 507: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;

503: and cpr.prerequisite_type = 'M'
504: and cpr.enforcement_mode in ('B', p_enforcement_mode);
505:
506: l_completed_status varchar2(1):= 'Y';
507: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;
508: BEGIN
509: If ( p_user_type = 'C') Then --Customer
510: l_enforcement_mode := 'E'; --External
511: Else -- Employee

Line 852: ota_course_prerequisites ocp

848: ocp.activity_version_id Dependant_Course_Id,
849: ocp.business_group_id Business_Group_Id
850: from ota_activity_versions oav,
851: ota_activity_versions_tl oavt,
852: ota_course_prerequisites ocp
853: where ocp.activity_version_id = oav.activity_version_id
854: and oav.activity_version_id = oavt.activity_version_id
855: and oavt.language = userenv('LANG')
856: and ocp.prerequisite_course_id = p_act_ver_id