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:
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
278: SELECT cpr.prerequisite_course_id
279: FROM ota_course_prerequisites cpr
280: WHERE cpr.activity_version_id = p_act_ver_id
281: and cpr.prerequisite_type = 'M'

Line 279: FROM ota_course_prerequisites cpr

275: ) RETURN varchar2 is
276:
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
278: SELECT cpr.prerequisite_course_id
279: FROM ota_course_prerequisites cpr
280: WHERE cpr.activity_version_id = p_act_ver_id
281: and cpr.prerequisite_type = 'M'
282: and cpr.enforcement_mode in ('B', p_enforcement_mode);
283:

Line 293: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;

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

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

330: p_user_type in ota_attempts.user_type%type,
331: p_act_ver_id in ota_activity_versions.activity_version_id%type
332: ) RETURN varchar2 is
333:
334: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
335: SELECT cpr.prerequisite_course_id
336: FROM ota_course_prerequisites cpr
337: WHERE cpr.activity_version_id = p_act_ver_id
338: and cpr.prerequisite_type = 'A'

Line 336: FROM ota_course_prerequisites cpr

332: ) RETURN varchar2 is
333:
334: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
335: SELECT cpr.prerequisite_course_id
336: FROM ota_course_prerequisites cpr
337: WHERE cpr.activity_version_id = p_act_ver_id
338: and cpr.prerequisite_type = 'A'
339: and cpr.enforcement_mode in ('B', p_enforcement_mode);
340:

Line 350: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;

346: and ( cpe.mandatory = 'N' or cpe.mandatory is null )
347: and cpe.type = 'OTA_COMP_PREREQ';
348:
349: l_completed_status varchar2(1);
350: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;
351: Begin
352: l_completed_status := 'Y';
353: If ( p_user_type = 'C') Then --Customer
354: l_enforcement_mode := 'E'; --External

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

489: p_act_ver_id in ota_activity_versions.activity_version_id%type
490: ) RETURN varchar2
491: IS
492:
493: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
494: SELECT cpr.prerequisite_course_id
495: FROM ota_course_prerequisites cpr
496: WHERE cpr.activity_version_id = p_act_ver_id
497: and cpr.prerequisite_type = 'M'

Line 495: FROM ota_course_prerequisites cpr

491: IS
492:
493: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
494: SELECT cpr.prerequisite_course_id
495: FROM ota_course_prerequisites cpr
496: WHERE cpr.activity_version_id = p_act_ver_id
497: and cpr.prerequisite_type = 'M'
498: and cpr.enforcement_mode in ('B', p_enforcement_mode);
499:

Line 501: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;

497: and cpr.prerequisite_type = 'M'
498: and cpr.enforcement_mode in ('B', p_enforcement_mode);
499:
500: l_completed_status varchar2(1):= 'Y';
501: l_enforcement_mode ota_course_prerequisites.enforcement_mode%TYPE;
502: BEGIN
503: If ( p_user_type = 'C') Then --Customer
504: l_enforcement_mode := 'E'; --External
505: Else -- Employee