[Home] [Help]
231: cme.cert_prd_enrollment_id,
232: nvl(act.eres_enabled,'N') sign_enabled,
233: cm.object_id
234: from ota_certification_members cm, ota_cert_mbr_enrollments cme,
235: ota_offerings o, ota_cert_prd_enrollments cpe, ota_activity_versions act
236: where
237: cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
238: and cme.cert_member_id = cm.certification_member_id
239: and cm.object_id = o.activity_version_id
319: --Added cursor to check whether update is needed for the enrollment in case of online classes
320: --after learner has signed the course.
321: cursor csr_book_details is
322: select odb.delegate_person_id, odb.delegate_contact_id, offer.learning_object_id
323: from ota_delegate_bookings odb, ota_events evt, ota_offerings offer
324: where odb.event_id = evt.event_id
325: and evt.parent_offering_id = offer.offering_id
326: and booking_id = p_booking_id;
327:
331: where booking_id = p_booking_id;
332:
333: l_person_id ota_delegate_bookings.delegate_person_id%type;
334: l_contact_id ota_delegate_bookings.delegate_contact_id%type;
335: l_lo_id ota_offerings.learning_object_id%type;
336: l_cert_prd_enr_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
337: l_member_in varchar2(10);
338: l_booking_successful_att_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
339: l_booking_failure_reason ota_delegate_bookings.failure_reason%Type;
561: cursor perf_lesson_status is
562: select per.lesson_status,
563: offe.learning_object_id
564: from ota_performances per,
565: ota_offerings offe,
566: ota_events evt
567: where evt.parent_offering_id = offe.offering_id and
568: offe.learning_object_id = per.learning_object_id(+) and
569: evt.event_id = p_event_id and
573:
574: l_proc varchar2(72) := g_package||'update_enrollment_status';
575: l_status varchar2(80) :='ATTENDED';
576: l_perf_status varchar2(1);
577: l_learning_object_id ota_offerings.learning_object_id%type;
578: l_failed varchar2(1):= null;
579: l_new_sign_eval_status varchar2(2) := null;
580:
581: begin
664: act.eres_enabled,
665: book.delegate_person_id,
666: book.successful_attendance_flag
667: from ota_events ev,
668: ota_offerings offr,
669: ota_learning_objects lo,
670: ota_delegate_bookings book,
671: ota_booking_status_types stype,
672: ota_activity_versions act
700: act.eres_enabled,
701: book.delegate_contact_id,
702: book.successful_attendance_flag
703: from ota_events ev,
704: ota_offerings offr,
705: ota_learning_objects lo,
706: ota_delegate_bookings book,
707: ota_booking_status_types stype,
708: hz_cust_account_roles acct_role,
1284: v_root_lo_id ota_learning_objects.learning_object_id%type;
1285: begin
1286: select o.learning_object_id
1287: into v_root_lo_id
1288: from ota_events e, ota_offerings o
1289: where e.event_id = p_event_id and
1290: e.parent_offering_id = o.offering_id;
1291:
1292: select 'X'
1555: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1556:
1557: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1558: select o.learning_object_id
1559: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme
1560: where o.activity_version_id = cm.object_id
1561: and cm.certification_member_id = cme.cert_member_id
1562: and cme.cert_prd_enrollment_id = p_cert_prd_enroll_id;
1563:
1947: v_root_lo_id ota_learning_objects.learning_object_id%type;
1948: begin
1949: select o.learning_object_id
1950: into v_root_lo_id
1951: from ota_events e, ota_offerings o
1952: where e.event_id = p_event_id and
1953: e.parent_offering_id = o.offering_id;
1954:
1955: return get_previous_lo_id(v_root_lo_id, p_starting_lo_id, p_user_id, p_user_type, p_launch_type, p_cert_prd_enrollment_id);
2056: v_root_lo_id ota_learning_objects.learning_object_id%type;
2057: begin
2058: select o.learning_object_id
2059: into v_root_lo_id
2060: from ota_events e, ota_offerings o
2061: where e.event_id = p_event_id and
2062: e.parent_offering_id = o.offering_id;
2063:
2064: return get_next_lo_id(v_root_lo_id, p_starting_lo_id, p_user_id, p_user_type, p_launch_type, p_cert_prd_enrollment_id);
2097: v_reason number;
2098: begin
2099: select o.learning_object_id
2100: into v_root_lo_id
2101: from ota_events e, ota_offerings o
2102: where e.event_id = p_event_id and
2103: e.parent_offering_id = o.offering_id;
2104:
2105:
2125: v_reason number;
2126: begin
2127: select o.learning_object_id
2128: into v_root_lo_id
2129: from ota_events e, ota_offerings o
2130: where e.event_id = p_event_id and
2131: e.parent_offering_id = o.offering_id;
2132:
2133: return get_next_lo_id(v_root_lo_id, null, p_user_id, p_user_type, p_launch_type, p_cert_prd_enrollment_id);
2602: ,v_published_flag
2603: from ota_learning_objects
2604: start with learning_object_id =
2605: (select learning_object_id
2606: from ota_offerings o
2607: ,ota_events e
2608: where o.offering_id = e.parent_offering_id
2609: and event_id = p_event_id)
2610: connect by parent_learning_object_id = prior learning_object_id;
2680: v_lo_id ota_learning_objects.learning_object_id%type;
2681: begin
2682: select offr.learning_object_id
2683: into v_lo_id
2684: from ota_offerings offr, ota_events evt
2685: where evt.event_id = p_event_id and
2686: evt.parent_offering_id = offr.offering_id;
2687:
2688: /*===============================================
2962:
2963: begin
2964: select offr.learning_object_id
2965: into v_lo_id
2966: from ota_offerings offr, ota_events evt
2967: where evt.event_id = p_event_id and
2968: evt.parent_offering_id = offr.offering_id;
2969:
2970: v_wait_duration := get_wait_duration_for_lo(p_user_id, p_user_type, v_lo_id, p_cert_prd_enrollment_id);
3067: RETURN VARCHAR2 IS
3068:
3069: CURSOR c_learning_object IS
3070: SELECT ofr.learning_object_id
3071: FROM ota_events oev, ota_offerings ofr
3072: WHERE oev.parent_offering_id = ofr.offering_id
3073: AND oev.event_id = p_event_id;
3074:
3075: CURSOR c_learning_object_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3071: FROM ota_events oev, ota_offerings ofr
3072: WHERE oev.parent_offering_id = ofr.offering_id
3073: AND oev.event_id = p_event_id;
3074:
3075: CURSOR c_learning_object_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3076: SELECT lesson_status
3077: FROM ota_performances
3078: WHERE user_id = p_user_id
3079: AND user_type = p_user_type
3091: WHERE event_id = p_event_id;
3092:
3093: l_proc VARCHAR2(72) := g_package|| 'get_player_status';
3094:
3095: l_learning_object_id ota_offerings.learning_object_id%TYPE;
3096:
3097: l_status VARCHAR2(30) := null;
3098:
3099: l_imported_offering ota_events.offering_id%TYPE := null;
3167: RETURN VARCHAR2 IS
3168:
3169: CURSOR c_learning_object IS
3170: SELECT ofr.learning_object_id
3171: FROM ota_events oev, ota_offerings ofr
3172: WHERE oev.parent_offering_id = ofr.offering_id
3173: AND oev.event_id = p_event_id;
3174:
3175: CURSOR c_learning_object_time(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3171: FROM ota_events oev, ota_offerings ofr
3172: WHERE oev.parent_offering_id = ofr.offering_id
3173: AND oev.event_id = p_event_id;
3174:
3175: CURSOR c_learning_object_time(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3176: SELECT TO_CHAR(TRUNC(SYSDATE)+(time)/86400, 'HH24:Mi:SS')
3177: FROM ota_performances
3178: WHERE user_id = p_user_id
3179: AND user_type = p_user_type
3191: WHERE event_id = p_event_id;
3192:
3193: l_proc VARCHAR2(72) := g_package|| 'get_enroll_lo_time';
3194:
3195: l_learning_object_id ota_offerings.learning_object_id%TYPE;
3196:
3197: l_time VARCHAR2(30) := null;
3198:
3199: l_imported_offering ota_events.offering_id%TYPE := null;
3267: RETURN VARCHAR2 IS
3268:
3269: CURSOR c_learning_object IS
3270: SELECT ofr.learning_object_id
3271: FROM ota_events oev, ota_offerings ofr
3272: WHERE oev.parent_offering_id = ofr.offering_id
3273: AND oev.event_id = p_event_id;
3274:
3275: CURSOR c_learning_object_score(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3271: FROM ota_events oev, ota_offerings ofr
3272: WHERE oev.parent_offering_id = ofr.offering_id
3273: AND oev.event_id = p_event_id;
3274:
3275: CURSOR c_learning_object_score(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3276: SELECT score
3277: FROM ota_performances
3278: WHERE user_id = p_user_id
3279: AND user_type = p_user_type
3291: WHERE event_id = p_event_id;
3292:
3293: l_proc VARCHAR2(72) := g_package|| 'get_enroll_lo_score';
3294:
3295: l_learning_object_id ota_offerings.learning_object_id%TYPE;
3296:
3297: l_score VARCHAR2(30) := null;
3298:
3299: l_imported_offering ota_events.offering_id%TYPE := null;
3380: CURSOR c_delivery_mode IS
3381: SELECT ocu.online_flag, ofr.learning_object_id,
3382: to_date(to_char(nvl(oev.course_end_date, to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || nvl(oev.course_end_time, '23:59'), 'YYYY/MM/DD HH24:MI'),
3383: ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, oev.timezone)
3384: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu
3385: WHERE oev.parent_offering_id = ofr.offering_id
3386: AND ofr.delivery_mode_id = ocu.category_usage_id
3387: AND oev.event_id = p_event_id;
3388:
3390: SELECT BST.type, BST.name
3391: FROM ota_booking_status_types_vl BST
3392: WHERE BST.booking_status_type_id = p_booking_status_type_id;
3393:
3394: CURSOR c_learning_object_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3395: SELECT lesson_status,
3396: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
3397: FROM ota_performances
3398: WHERE user_id = p_user_id
3411: FROM ota_events
3412: WHERE event_id = p_event_id;
3413:
3414: -- Bug 13496386
3415: cursor c_learning_object_tracktype (l_lo_id in ota_offerings.learning_object_id%type) IS
3416: select Tracking_type
3417: from OTA_Learning_objects
3418: where learning_object_id = l_lo_id;
3419:
3417: from OTA_Learning_objects
3418: where learning_object_id = l_lo_id;
3419:
3420: --modified for 14000818.
3421: cursor csr_noof_perf_recs (l_lo_id in ota_offerings.learning_object_id%type) is
3422: select count(p.PERFORMANCE_ID)
3423: from
3424: ota_performances p, ota_learning_objects lo
3425: where lo.learning_object_id = p.learning_object_id
3428: and lo.learning_object_id = l_lo_id
3429: and p.cert_prd_enrollment_id is null;
3430:
3431: --added for 14000818
3432: cursor csr_noof_perf_recs_cert(l_lo_id in ota_offerings.learning_object_id%type,
3433: l_cert_prd_enr_id in ota_performances.cert_prd_enrollment_id%type) is
3434: select count(p.PERFORMANCE_ID)
3435: from
3436: ota_performances p, ota_learning_objects lo
3440: and lo.learning_object_id = l_lo_id
3441: and p.cert_prd_enrollment_id = l_cert_prd_enr_id;
3442:
3443: -- Bug 4665032
3444: CURSOR csr_best_prf (l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3445: SELECT decode(prf.lesson_status, 'P', '1',
3446: 'C', '2',
3447: 'F', '3',
3448: 'I', '4',
3470:
3471: l_proc VARCHAR2(72) := g_package|| 'get_enroll_lo_status';
3472:
3473: l_online_flag ota_category_usages.online_flag%TYPE;
3474: l_learning_object_id ota_offerings.learning_object_id%TYPE;
3475: l_course_end_date ota_events.course_end_date%TYPE;
3476: l_sysdate ota_events.course_end_date%TYPE;
3477:
3478: l_status VARCHAR2(30) := null;
3838: 'N', '6') decode_lesson_status,
3839: ocu.Synchronous_Flag Sync_Flag,
3840: ocu.Online_Flag Online_Flag,
3841: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
3842: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3843: Where
3844: oev.parent_offering_id = ofr.offering_id
3845: And ofr.learning_object_id = opf.learning_object_id(+)
3846: And oev.event_id = p_event_id
3858: opf.lesson_status,
3859: ocu.Synchronous_Flag Sync_Flag,
3860: ocu.Online_Flag Online_Flag,
3861: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
3862: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3863: Where
3864: oev.parent_offering_id = ofr.offering_id
3865: And ofr.learning_object_id = opf.learning_object_id(+)
3866: And oev.event_id = p_event_id
3946: ocu.Synchronous_Flag Sync_Flag,
3947: ocu.Online_Flag Online_Flag,
3948: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz,
3949: ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) Comp_Date
3950: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3951: Where
3952: oev.parent_offering_id = ofr.offering_id
3953: And ofr.learning_object_id = opf.learning_object_id(+)
3954: And oev.event_id = p_event_id
3967: ocu.Synchronous_Flag Sync_Flag,
3968: ocu.Online_Flag Online_Flag,
3969: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz,
3970: ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) Comp_Date
3971: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3972: Where
3973: oev.parent_offering_id = ofr.offering_id
3974: And ofr.learning_object_id = opf.learning_object_id(+)
3975: And oev.event_id = p_event_id
4054:
4055:
4056: CURSOR c_delivery_mode IS
4057: SELECT ocu.online_flag, ofr.learning_object_id, nvl(oev.course_end_date, trunc(sysdate))
4058: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu
4059: WHERE oev.parent_offering_id = ofr.offering_id
4060: AND ofr.delivery_mode_id = ocu.category_usage_id
4061: AND oev.event_id = p_event_id;
4062:
4064: SELECT BST.type, BST.name
4065: FROM ota_booking_status_types_vl BST
4066: WHERE BST.booking_status_type_id = p_booking_status_type_id;
4067:
4068: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
4069: SELECT lesson_status,
4070: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
4071: FROM ota_performances
4072: WHERE user_id = p_user_id
4081:
4082: l_proc VARCHAR2(72) := g_package|| 'get_cert_lo_status';
4083:
4084: l_online_flag ota_category_usages.online_flag%TYPE;
4085: l_learning_object_id ota_offerings.learning_object_id%TYPE;
4086: l_course_end_date ota_events.course_end_date%TYPE;
4087:
4088: l_status VARCHAR2(30) := null;
4089: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4424: bst.type
4425: FROM ota_events evt,
4426: ota_delegate_bookings tdb,
4427: ota_booking_status_types bst,
4428: ota_offerings ofr,
4429: ota_category_usages ocu
4430: WHERE evt.event_id = tdb.event_id
4431: AND bst.booking_status_type_id = tdb.booking_status_type_id
4432: /* AND (
4538: ocu.online_flag,
4539: evt.course_start_date,
4540: evt.course_end_date
4541: FROM ota_events evt,
4542: ota_offerings ofr,
4543: ota_category_usages ocu
4544: WHERE evt.event_id = csr_event_id
4545: AND evt.parent_offering_id = ofr.offering_id
4546: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4603:
4604: cursor csr_toolbar_flag(csr_event_id ota_events.event_id%type) is
4605: select ofr.player_toolbar_flag
4606: from ota_events evt,
4607: ota_offerings ofr
4608: where evt.parent_offering_id = ofr.offering_id
4609: and evt.event_id = csr_event_id;
4610:
4611: l_proc VARCHAR2(72) := g_package||'get_cme_Player_Toolbar_Flag';
4609: and evt.event_id = csr_event_id;
4610:
4611: l_proc VARCHAR2(72) := g_package||'get_cme_Player_Toolbar_Flag';
4612:
4613: l_player_toolbar_flag ota_offerings.player_toolbar_flag%type;
4614:
4615: l_online_event_id ota_events.event_id%type;
4616: l_online_evt_count number;
4617:
4657: evt.course_start_date,
4658: evt.course_end_date,
4659: ofr.learning_object_id
4660: FROM ota_events evt,
4661: ota_offerings ofr,
4662: ota_category_usages ocu
4663: WHERE evt.event_id = csr_event_id
4664: AND evt.parent_offering_id = ofr.offering_id
4665: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4669: from ota_cert_mbr_enrollments
4670: where cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
4671:
4672:
4673: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE,
4674: csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
4675: SELECT lesson_status,
4676: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
4677: FROM ota_performances
4702: 'N', '6') decode_lesson_status,
4703: prf.lesson_status lesson_status,
4704: prf.performance_id
4705: FROM ota_performances prf,
4706: ota_offerings ofr,
4707: ota_learning_objects lo
4708: WHERE
4709: prf.user_id = p_user_id
4710: and prf.user_type = p_user_type
4840: bst.type
4841: FROM ota_events evt,
4842: ota_delegate_bookings tdb,
4843: ota_booking_status_types bst,
4844: ota_offerings ofr,
4845: ota_category_usages ocu
4846: WHERE evt.event_id = tdb.event_id
4847: AND bst.booking_status_type_id = tdb.booking_status_type_id
4848: /* AND (
5036: bst.type
5037: FROM ota_events evt,
5038: ota_delegate_bookings tdb,
5039: ota_booking_status_types bst,
5040: ota_offerings ofr,
5041: ota_category_usages ocu
5042: WHERE evt.event_id = tdb.event_id
5043: AND bst.booking_status_type_id = tdb.booking_status_type_id
5044: AND evt.activity_version_id = csr_activity_version_id
5117: ocu.online_flag,
5118: evt.course_start_date,
5119: evt.course_end_date
5120: FROM ota_events evt,
5121: ota_offerings ofr,
5122: ota_category_usages ocu
5123: WHERE evt.event_id = csr_event_id
5124: AND evt.parent_offering_id = ofr.offering_id
5125: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
5170:
5171: cursor csr_toolbar_flag(csr_event_id ota_events.event_id%type) is
5172: select ofr.player_toolbar_flag
5173: from ota_events evt,
5174: ota_offerings ofr
5175: where evt.parent_offering_id = ofr.offering_id
5176: and evt.event_id = csr_event_id;
5177:
5178: l_proc VARCHAR2(72) := g_package||'get_lme_player_toolbar_flag';
5176: and evt.event_id = csr_event_id;
5177:
5178: l_proc VARCHAR2(72) := g_package||'get_lme_player_toolbar_flag';
5179:
5180: l_player_toolbar_flag ota_offerings.player_toolbar_flag%type;
5181:
5182: l_online_event_id ota_events.event_id%type;
5183: l_online_evt_count number;
5184:
5224: evt.course_start_date,
5225: evt.course_end_date,
5226: ofr.learning_object_id
5227: FROM ota_events evt,
5228: ota_offerings ofr,
5229: ota_category_usages ocu
5230: WHERE evt.event_id = csr_event_id
5231: AND evt.parent_offering_id = ofr.offering_id
5232: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
5252: 'N', '6') decode_lesson_status,
5253: prf.lesson_status lesson_status,
5254: prf.performance_id
5255: FROM ota_performances prf,
5256: ota_offerings ofr,
5257: ota_learning_objects lo
5258: WHERE
5259: prf.user_id = p_user_id
5260: and prf.user_type = p_user_type
5356: bst.type
5357: FROM ota_events evt,
5358: ota_delegate_bookings tdb,
5359: ota_booking_status_types bst,
5360: ota_offerings ofr,
5361: ota_category_usages ocu
5362: WHERE evt.event_id = tdb.event_id
5363: AND bst.booking_status_type_id = tdb.booking_status_type_id
5364: AND evt.activity_version_id = csr_activity_version_id
5644:
5645: --Added for Performance Multiple record Learner page -aswani
5646: cursor c_learning_object_tracktype is
5647: select lo.Tracking_type , lo.learning_object_id
5648: from ota_learning_objects lo, ota_offerings ofr, ota_events oev
5649: where ofr.Learning_object_id = lo.learning_object_id
5650: and oev.parent_offering_id = ofr.offering_id
5651: and oev.event_id = p_event_id ;
5652:
5649: where ofr.Learning_object_id = lo.learning_object_id
5650: and oev.parent_offering_id = ofr.offering_id
5651: and oev.event_id = p_event_id ;
5652:
5653: cursor csr_noof_perf_recs (l_lo_id in ota_offerings.learning_object_id%type) is
5654: select count(p.PERFORMANCE_ID)
5655: from
5656: ota_performances p, ota_learning_objects lo
5657: where lo.learning_object_id = p.learning_object_id
5659: and p.user_type = p_user_type
5660: and lo.learning_object_id = l_lo_id
5661: and p.cert_prd_enrollment_id is null;
5662:
5663: cursor csr_noof_perf_recs_cert(l_lo_id in ota_offerings.learning_object_id%type, l_cert_prd_enr_id ota_performances.cert_prd_enrollment_id%type) is
5664: select count(p.PERFORMANCE_ID)
5665: from
5666: ota_performances p, ota_learning_objects lo
5667: where lo.learning_object_id = p.learning_object_id
5673:
5674: l_proc VARCHAR2(72) := g_package|| 'get_num_of_online_records';
5675:
5676: l_online_flag ota_category_usages.online_flag%TYPE;
5677: l_learning_object_id ota_offerings.learning_object_id%TYPE;
5678: l_course_end_date ota_events.course_end_date%TYPE;
5679: l_sysdate ota_events.course_end_date%TYPE;
5680:
5681: l_trackingtype ota_learning_objects.tracking_type %TYPE;