[Home] [Help]
67:
68: function compute_default_lesson_status(
69: p_lo_id ota_learning_objects.learning_object_id%type,
70: p_user_id fnd_user.user_id%type,
71: p_user_type ota_attempts.user_type%type,
72: p_old_lesson_status ota_performances.lesson_status%type,
73: p_starting_url ota_learning_objects.starting_url%type,
74: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
75: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) return ota_performances.lesson_status%type is
76:
77: cursor child_los(
78: p_lo_id ota_learning_objects.learning_object_id%type,
79: p_user_id fnd_user.user_id%type,
80: p_user_type ota_attempts.user_type%type) is
81: select lo.learning_object_id, nvl(p.lesson_status, 'N') as lesson_status
82: from ota_learning_objects lo, ota_performances p
83: where lo.parent_learning_object_id = p_lo_id and
84: lo.published_flag = 'Y' and
129:
130: function compute_lesson_status(
131: p_lo_id ota_learning_objects.learning_object_id%type,
132: p_user_id fnd_user.user_id%type,
133: p_user_type ota_attempts.user_type%type,
134: p_old_lesson_status ota_performances.lesson_status%type,
135: p_starting_url ota_learning_objects.starting_url%type,
136: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
137: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) return ota_performances.lesson_status%type is
139: /* Completion reqs not yet implemented - GDHUTTON 12/24/03
140: cursor completion_requirements(
141: p_lo_id ota_learning_objects.learning_object_id%type,
142: p_user_id fnd_user.user_id%type,
143: p_user_type ota_attempts.user_type%type,
144: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type) is
145: select cr.parent_learning_object_id as learning_object_id, cr.assigned_lesson_status as assigned_lesson_status,
146: null as match_lesson_status, nvl(p.lesson_status, 'N') as user_lesson_status
147: from ota_performances p, ota_completion_requirements cr
501: --Added for updating the enrollment status to 'Attended'
502: --for the learners who have completed the mandatory evaluation.
503: procedure update_enrollment_status(
504: p_user_id fnd_user.user_id%type,
505: p_user_type ota_attempts.user_type%type,
506: p_event_id ota_events.event_id%type) is
507:
508: -- This cursor finds all events in all offerings which offer the LO and in
509: -- which the person is enrolled with a status of 'PENDING EVALUATION'.
623:
624: procedure update_enroll_status_for_lo(
625: p_lo_id ota_learning_objects.learning_object_id%type,
626: p_user_id fnd_user.user_id%type,
627: p_user_type ota_attempts.user_type%type,
628: p_date date) is
629:
630:
631:
642:
643: procedure update_enroll_status_for_lo(
644: p_lo_id ota_learning_objects.learning_object_id%type,
645: p_user_id fnd_user.user_id%type,
646: p_user_type ota_attempts.user_type%type,
647: p_date date,
648: p_failed varchar2) is
649:
650: -- This cursor finds all events in all offerings which offer the LO and in
728:
729: l_event_id OTA_EVENTS.EVENT_ID%TYPE:= null;
730: l_test_id OTA_TESTS.TEST_ID%type:=null;
731: Cursor csr_attempt_info is
732: select attempt_id from ota_attempts where
733: event_id = l_event_id
734: and test_id = l_test_id
735: and user_id = p_user_id
736: and user_type = p_user_type;
780: l_proc varchar2(72) := g_package||'update_enroll_status_for_lo';
781: l_act_eval_id OTA_TESTS.TEST_ID%TYPE:=null;
782: l_evt_eval_id OTA_TESTS.TEST_ID%TYPE:=null;
783: l_eval_mand_flag varchar2(1);
784: l_dummy ota_attempts.attempt_id%type;
785: l_is_attempted boolean :=false;
786: l_status varchar2(80) :='ATTENDED';
787: l_user_type ota_attempts.user_type%type;
788: l_new_sign_eval_status varchar2(2):= null;
783: l_eval_mand_flag varchar2(1);
784: l_dummy ota_attempts.attempt_id%type;
785: l_is_attempted boolean :=false;
786: l_status varchar2(80) :='ATTENDED';
787: l_user_type ota_attempts.user_type%type;
788: l_new_sign_eval_status varchar2(2):= null;
789: l_member_in varchar2(30);
790: l_cert_status OTA_CERT_ENROLLMENTS.CERTIFICATION_STATUS_CODE%type;
791: begin
869:
870: procedure set_performance_lesson_status(
871: p_lo_id ota_learning_objects.learning_object_id%type,
872: p_user_id fnd_user.user_id%type,
873: p_user_type ota_attempts.user_type%type,
874: p_lesson_status ota_performances.lesson_status%type,
875: p_cascaded boolean,
876: p_date date,
877: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
879:
880: cursor affected_los(
881: p_lo_id ota_learning_objects.learning_object_id%type,
882: p_user_id fnd_user.user_id%type,
883: p_user_type ota_attempts.user_type%type,
884: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type) is
885: select parent.learning_object_id as learning_object_id,
886: nvl(perf.lesson_status, 'N') as lesson_status,
887: parent.starting_url as starting_url
1044: --13485033
1045: procedure set_performance_lesson_status(
1046: p_lo_id ota_learning_objects.learning_object_id%type,
1047: p_user_id fnd_user.user_id%type,
1048: p_user_type ota_attempts.user_type%type,
1049: p_lesson_status ota_performances.lesson_status%type,
1050: p_cascaded varchar2,
1051: p_date date,
1052: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
1063:
1064: procedure set_performance_lesson_status(
1065: p_lo_id ota_learning_objects.learning_object_id%type,
1066: p_user_id fnd_user.user_id%type,
1067: p_user_type ota_attempts.user_type%type,
1068: p_lesson_status ota_performances.lesson_status%type,
1069: p_date date,
1070: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
1071: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) is
1076:
1077: procedure set_performance_lesson_status(
1078: p_lo_id ota_learning_objects.learning_object_id%type,
1079: p_user_id fnd_user.user_id%type,
1080: p_user_type ota_attempts.user_type%type,
1081: p_lesson_status ota_performances.lesson_status%type,
1082: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
1083: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) is
1084: begin
1088:
1089: procedure set_performance_time(
1090: p_lo_id ota_learning_objects.learning_object_id%type,
1091: p_user_id fnd_user.user_id%type,
1092: p_user_type ota_attempts.user_type%type,
1093: p_time ota_performances.time%type,
1094: p_cascaded boolean,
1095: p_date date,
1096: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
1098:
1099: cursor parent_los(
1100: p_lo_id ota_learning_objects.learning_object_id%type,
1101: p_user_id fnd_user.user_id%type,
1102: p_user_type ota_attempts.user_type%type,
1103: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type) is
1104: select parent.learning_object_id, parent.starting_url, nvl(perf.time, 0) as time
1105: from ota_learning_objects child, ota_learning_objects parent, ota_performances perf
1106: where child.source_learning_object_id = p_lo_id and
1115:
1116: cursor distinct_child_los(
1117: p_lo_id ota_learning_objects.learning_object_id%type,
1118: p_user_id fnd_user.user_id%type,
1119: p_user_type ota_attempts.user_type%type,
1120: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type) is
1121: select lo.source_learning_object_id as learning_object_id, nvl(p.time, 0) as time
1122: from ota_performances p,
1123: (select distinct learning_object_id, source_learning_object_id, starting_url
1211:
1212: procedure set_performance_time(
1213: p_lo_id ota_learning_objects.learning_object_id%type,
1214: p_user_id fnd_user.user_id%type,
1215: p_user_type ota_attempts.user_type%type,
1216: p_time ota_performances.time%type,
1217: p_date date,
1218: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
1219: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) is
1224:
1225: procedure set_performance_time(
1226: p_lo_id ota_learning_objects.learning_object_id%type,
1227: p_user_id fnd_user.user_id%type,
1228: p_user_type ota_attempts.user_type%type,
1229: p_time ota_performances.time%type,
1230: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
1231: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) is
1232: begin
1235:
1236:
1237: function lo_is_attemptable(
1238: p_lo_id ota_learning_objects.learning_object_id%type,
1239: p_launch_type ota_attempts.launch_type%type,
1240: p_reason out nocopy number) return boolean is
1241:
1242: v_published_flag ota_learning_objects.published_flag%type;
1243: v_starting_url ota_learning_objects.starting_url%type;
1305:
1306: function user_meets_prerequisites(
1307: p_lo_id ota_learning_objects.learning_object_id%type,
1308: p_user_id fnd_user.user_id%type,
1309: p_user_type ota_attempts.user_type%type) return boolean is
1310:
1311: --Commented for Bug#3582893
1312: -- The cursor below is replaced with two cursor since the below query causes a Full Table Scan
1313: /*
1369:
1370: function user_exceeded_attempt_limit(
1371: p_lo_id ota_learning_objects.learning_object_id%type,
1372: p_user_id fnd_user.user_id%type,
1373: p_user_type ota_attempts.user_type%type,
1374: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return boolean is
1375:
1376: v_max_attempts ota_tests.max_attempts%type;
1377: v_user_attempts number;
1370: function user_exceeded_attempt_limit(
1371: p_lo_id ota_learning_objects.learning_object_id%type,
1372: p_user_id fnd_user.user_id%type,
1373: p_user_type ota_attempts.user_type%type,
1374: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return boolean is
1375:
1376: v_max_attempts ota_tests.max_attempts%type;
1377: v_user_attempts number;
1378: begin
1394: -- Count the user's attempts
1395: begin
1396: select count(*)
1397: into v_user_attempts
1398: from ota_attempts a, ota_tests t
1399: where a.user_id = p_user_id and
1400: a.user_type = p_user_type and
1401: a.learning_object_id = p_lo_id and
1402: nvl(a.cert_prd_enrollment_id, -1) = nvl(p_cert_prd_enrollment_id, -1) and
1421:
1422: function get_next_attempt_date_for_lo(
1423: p_lo_id ota_learning_objects.learning_object_id%type,
1424: p_user_id fnd_user.user_id%type,
1425: p_user_type ota_attempts.user_type%type,
1426: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return date is
1427:
1428: v_earliest_attempt_date date;
1429: begin
1422: function get_next_attempt_date_for_lo(
1423: p_lo_id ota_learning_objects.learning_object_id%type,
1424: p_user_id fnd_user.user_id%type,
1425: p_user_type ota_attempts.user_type%type,
1426: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return date is
1427:
1428: v_earliest_attempt_date date;
1429: begin
1430: select nvl(max(a.timestamp), sysdate) + nvl(t.duration_between_attempt, 0)
1429: begin
1430: select nvl(max(a.timestamp), sysdate) + nvl(t.duration_between_attempt, 0)
1431: into v_earliest_attempt_date
1432: from ota_tests t,
1433: ota_attempts a
1434: where t.test_id = a.test_id
1435: and a.initialized_flag = 'Y'
1436: and a.internal_state <> 'A' --14598945
1437: and ((t.resume_flag = 'Y'
1457:
1458: function user_must_wait_to_attempt(
1459: p_lo_id ota_learning_objects.learning_object_id%type,
1460: p_user_id fnd_user.user_id%type,
1461: p_user_type ota_attempts.user_type%type,
1462: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return boolean is
1463:
1464: v_earliest_attempt_date date;
1465: begin
1458: function user_must_wait_to_attempt(
1459: p_lo_id ota_learning_objects.learning_object_id%type,
1460: p_user_id fnd_user.user_id%type,
1461: p_user_type ota_attempts.user_type%type,
1462: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return boolean is
1463:
1464: v_earliest_attempt_date date;
1465: begin
1466: v_earliest_attempt_date := get_next_attempt_date_for_lo(
1475:
1476: function user_can_attempt_lo(
1477: p_lo_id ota_learning_objects.learning_object_id%type,
1478: p_user_id fnd_user.user_id%type,
1479: p_user_type ota_attempts.user_type%type,
1480: p_launch_type ota_attempts.launch_type%type,
1481: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
1482: p_reason out nocopy number) return boolean is
1483: begin
1476: function user_can_attempt_lo(
1477: p_lo_id ota_learning_objects.learning_object_id%type,
1478: p_user_id fnd_user.user_id%type,
1479: p_user_type ota_attempts.user_type%type,
1480: p_launch_type ota_attempts.launch_type%type,
1481: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
1482: p_reason out nocopy number) return boolean is
1483: begin
1484: if not lo_is_attemptable(p_lo_id, p_launch_type, p_reason) then
1477: p_lo_id ota_learning_objects.learning_object_id%type,
1478: p_user_id fnd_user.user_id%type,
1479: p_user_type ota_attempts.user_type%type,
1480: p_launch_type ota_attempts.launch_type%type,
1481: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
1482: p_reason out nocopy number) return boolean is
1483: begin
1484: if not lo_is_attemptable(p_lo_id, p_launch_type, p_reason) then
1485: return false;
1514:
1515: function user_can_attempt_lo(
1516: p_lo_id ota_learning_objects.learning_object_id%type,
1517: p_user_id fnd_user.user_id%type,
1518: p_user_type ota_attempts.user_type%type,
1519: p_launch_type ota_attempts.launch_type%type default '',
1520: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
1521:
1522: l_reason number;
1515: function user_can_attempt_lo(
1516: p_lo_id ota_learning_objects.learning_object_id%type,
1517: p_user_id fnd_user.user_id%type,
1518: p_user_type ota_attempts.user_type%type,
1519: p_launch_type ota_attempts.launch_type%type default '',
1520: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
1521:
1522: l_reason number;
1523: begin
1516: p_lo_id ota_learning_objects.learning_object_id%type,
1517: p_user_id fnd_user.user_id%type,
1518: p_user_type ota_attempts.user_type%type,
1519: p_launch_type ota_attempts.launch_type%type default '',
1520: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
1521:
1522: l_reason number;
1523: begin
1524: if user_can_attempt_lo(p_lo_id, p_user_id, p_user_type, p_launch_type, p_cert_prd_enrollment_id, l_reason) then
1532: function user_can_attempt_lo_3(
1533: p_lo_id ota_learning_objects.learning_object_id%type,
1534: p_event_id ota_events.event_id%type,
1535: p_user_id fnd_user.user_id%type,
1536: p_user_type ota_attempts.user_type%type,
1537: p_launch_type ota_attempts.launch_type%type,
1538: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
1539: p_reason out nocopy number) return boolean is
1540: begin
1533: p_lo_id ota_learning_objects.learning_object_id%type,
1534: p_event_id ota_events.event_id%type,
1535: p_user_id fnd_user.user_id%type,
1536: p_user_type ota_attempts.user_type%type,
1537: p_launch_type ota_attempts.launch_type%type,
1538: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
1539: p_reason out nocopy number) return boolean is
1540: begin
1541: if not lo_is_in_event(p_event_id, p_lo_id) then
1534: p_event_id ota_events.event_id%type,
1535: p_user_id fnd_user.user_id%type,
1536: p_user_type ota_attempts.user_type%type,
1537: p_launch_type ota_attempts.launch_type%type,
1538: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
1539: p_reason out nocopy number) return boolean is
1540: begin
1541: if not lo_is_in_event(p_event_id, p_lo_id) then
1542: p_reason := LO_REASON_NOT_IN_EVENT;
1584: function user_can_attempt_lo(
1585: p_lo_id ota_learning_objects.learning_object_id%type,
1586: p_event_id ota_events.event_id%type,
1587: p_user_id fnd_user.user_id%type,
1588: p_user_type ota_attempts.user_type%type,
1589: p_launch_type ota_attempts.launch_type%type,
1590: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
1591: p_reason out nocopy number) return boolean is
1592: begin
1585: p_lo_id ota_learning_objects.learning_object_id%type,
1586: p_event_id ota_events.event_id%type,
1587: p_user_id fnd_user.user_id%type,
1588: p_user_type ota_attempts.user_type%type,
1589: p_launch_type ota_attempts.launch_type%type,
1590: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
1591: p_reason out nocopy number) return boolean is
1592: begin
1593: if p_cert_prd_enroll_id is not null and not lo_is_in_cert(p_cert_prd_enroll_id, p_lo_id) then
1586: p_event_id ota_events.event_id%type,
1587: p_user_id fnd_user.user_id%type,
1588: p_user_type ota_attempts.user_type%type,
1589: p_launch_type ota_attempts.launch_type%type,
1590: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
1591: p_reason out nocopy number) return boolean is
1592: begin
1593: if p_cert_prd_enroll_id is not null and not lo_is_in_cert(p_cert_prd_enroll_id, p_lo_id) then
1594: p_reason := LO_REASON_LO_NOT_IN_CERT;
1604:
1605: function event_is_attemptable(
1606: p_event_id ota_events.event_id%type,
1607: p_date date,
1608: p_launch_type ota_attempts.launch_type%type,
1609: p_reason out nocopy number) return boolean is
1610:
1611: v_course_start_date ota_events.course_start_date%type;
1612: v_course_start_time ota_events.course_start_time%type;
1647:
1648: function user_is_enrolled(
1649: p_event_id ota_events.event_id%type,
1650: p_user_id fnd_user.user_id%type,
1651: p_user_type ota_attempts.user_type%type,
1652: p_date date,
1653: p_reason out nocopy number) return boolean is
1654:
1655: cursor person_bookings(
1712:
1713: function user_is_instructor(
1714: p_event_id ota_events.event_id%type,
1715: p_user_id fnd_user.user_id%type,
1716: p_user_type ota_attempts.user_type%type,
1717: p_date date,
1718: p_reason out nocopy number) return boolean is
1719: begin
1720:
1752:
1753: function user_can_attempt_event(
1754: p_event_id ota_events.event_id%type,
1755: p_user_id fnd_user.user_id%type,
1756: p_user_type ota_attempts.user_type%type,
1757: p_launch_type ota_attempts.launch_type%type,
1758: p_reason out nocopy number) return varchar2 is
1759:
1760: v_now date := trunc(sysdate);--Bug 3554773
1753: function user_can_attempt_event(
1754: p_event_id ota_events.event_id%type,
1755: p_user_id fnd_user.user_id%type,
1756: p_user_type ota_attempts.user_type%type,
1757: p_launch_type ota_attempts.launch_type%type,
1758: p_reason out nocopy number) return varchar2 is
1759:
1760: v_now date := trunc(sysdate);--Bug 3554773
1761: begin
1816:
1817: function user_is_enrolled_in_cert(
1818: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1819: p_user_id fnd_user.user_id%type,
1820: p_user_type ota_attempts.user_type%type,
1821: p_date date,
1822: p_reason out nocopy number) return boolean is
1823:
1824: v_cert_unsubscribe_date ota_cert_enrollments.unenrollment_date%type;
1856:
1857: function user_can_attempt_cert(
1858: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1859: p_user_id fnd_user.user_id%type,
1860: p_user_type ota_attempts.user_type%type,
1861: p_reason out nocopy number) return varchar2 is
1862:
1863: v_now date := trunc(sysdate);--Bug 3554773
1864: begin
1910: function get_previous_lo_id(
1911: p_root_lo_id ota_learning_objects.learning_object_id%type,
1912: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1913: p_user_id fnd_user.user_id%type,
1914: p_user_type ota_attempts.user_type%type,
1915: p_launch_type ota_attempts.launch_type%type,
1916: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1917:
1918: v_starting_url ota_learning_objects.starting_url%type :=null;
1911: p_root_lo_id ota_learning_objects.learning_object_id%type,
1912: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1913: p_user_id fnd_user.user_id%type,
1914: p_user_type ota_attempts.user_type%type,
1915: p_launch_type ota_attempts.launch_type%type,
1916: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1917:
1918: v_starting_url ota_learning_objects.starting_url%type :=null;
1919: v_previous_lo_id ota_learning_objects.learning_object_id%type := null;
1912: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1913: p_user_id fnd_user.user_id%type,
1914: p_user_type ota_attempts.user_type%type,
1915: p_launch_type ota_attempts.launch_type%type,
1916: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1917:
1918: v_starting_url ota_learning_objects.starting_url%type :=null;
1919: v_previous_lo_id ota_learning_objects.learning_object_id%type := null;
1920: v_reason number;
1939: function get_previous_event_lo_id(
1940: p_event_id ota_events.event_id%type,
1941: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1942: p_user_id fnd_user.user_id%type,
1943: p_user_type ota_attempts.user_type%type,
1944: p_launch_type ota_attempts.launch_type%type,
1945: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1946:
1947: v_root_lo_id ota_learning_objects.learning_object_id%type;
1940: p_event_id ota_events.event_id%type,
1941: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1942: p_user_id fnd_user.user_id%type,
1943: p_user_type ota_attempts.user_type%type,
1944: p_launch_type ota_attempts.launch_type%type,
1945: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1946:
1947: v_root_lo_id ota_learning_objects.learning_object_id%type;
1948: begin
1941: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1942: p_user_id fnd_user.user_id%type,
1943: p_user_type ota_attempts.user_type%type,
1944: p_launch_type ota_attempts.launch_type%type,
1945: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1946:
1947: v_root_lo_id ota_learning_objects.learning_object_id%type;
1948: begin
1949: select o.learning_object_id
1992: function get_next_lo_id(
1993: p_root_lo_id ota_learning_objects.learning_object_id%type,
1994: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1995: p_user_id fnd_user.user_id%type,
1996: p_user_type ota_attempts.user_type%type,
1997: p_launch_type ota_attempts.launch_type%type,
1998: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1999:
2000:
1993: p_root_lo_id ota_learning_objects.learning_object_id%type,
1994: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1995: p_user_id fnd_user.user_id%type,
1996: p_user_type ota_attempts.user_type%type,
1997: p_launch_type ota_attempts.launch_type%type,
1998: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1999:
2000:
2001: v_starting_url ota_learning_objects.starting_url%type := null;
1994: p_starting_lo_id ota_learning_objects.learning_object_id%type,
1995: p_user_id fnd_user.user_id%type,
1996: p_user_type ota_attempts.user_type%type,
1997: p_launch_type ota_attempts.launch_type%type,
1998: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
1999:
2000:
2001: v_starting_url ota_learning_objects.starting_url%type := null;
2002: v_next_lo_id ota_learning_objects.learning_object_id%type := null;
2012: p_root_lo_id ota_learning_objects.learning_object_id%type,
2013: p_root_starting_url ota_learning_objects.starting_url%type,
2014: p_starting_lo_id ota_learning_objects.learning_object_id%type,
2015: p_user_id fnd_user.user_id%type,
2016: p_user_type ota_attempts.user_type%type,
2017: p_launch_type ota_attempts.launch_type%type,
2018: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2019:
2020: v_starting_url ota_learning_objects.starting_url%type := null;
2013: p_root_starting_url ota_learning_objects.starting_url%type,
2014: p_starting_lo_id ota_learning_objects.learning_object_id%type,
2015: p_user_id fnd_user.user_id%type,
2016: p_user_type ota_attempts.user_type%type,
2017: p_launch_type ota_attempts.launch_type%type,
2018: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2019:
2020: v_starting_url ota_learning_objects.starting_url%type := null;
2021: v_next_lo_id ota_learning_objects.learning_object_id%type := null;
2014: p_starting_lo_id ota_learning_objects.learning_object_id%type,
2015: p_user_id fnd_user.user_id%type,
2016: p_user_type ota_attempts.user_type%type,
2017: p_launch_type ota_attempts.launch_type%type,
2018: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2019:
2020: v_starting_url ota_learning_objects.starting_url%type := null;
2021: v_next_lo_id ota_learning_objects.learning_object_id%type := null;
2022: v_false boolean := false;
2048: function get_next_event_lo_id(
2049: p_event_id ota_events.event_id%type,
2050: p_starting_lo_id ota_learning_objects.learning_object_id%type,
2051: p_user_id fnd_user.user_id%type,
2052: p_user_type ota_attempts.user_type%type,
2053: p_launch_type ota_attempts.launch_type%type,
2054: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2055:
2056: v_root_lo_id ota_learning_objects.learning_object_id%type;
2049: p_event_id ota_events.event_id%type,
2050: p_starting_lo_id ota_learning_objects.learning_object_id%type,
2051: p_user_id fnd_user.user_id%type,
2052: p_user_type ota_attempts.user_type%type,
2053: p_launch_type ota_attempts.launch_type%type,
2054: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2055:
2056: v_root_lo_id ota_learning_objects.learning_object_id%type;
2057: begin
2050: p_starting_lo_id ota_learning_objects.learning_object_id%type,
2051: p_user_id fnd_user.user_id%type,
2052: p_user_type ota_attempts.user_type%type,
2053: p_launch_type ota_attempts.launch_type%type,
2054: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2055:
2056: v_root_lo_id ota_learning_objects.learning_object_id%type;
2057: begin
2058: select o.learning_object_id
2067:
2068: function get_most_recent_lo_id(
2069: p_event_id ota_events.event_id%type,
2070: p_user_id fnd_user.user_id%type,
2071: p_user_type ota_attempts.user_type%type,
2072: p_launch_type ota_attempts.launch_type%type,
2073: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type is
2074:
2075: cursor ordered_los(
2068: function get_most_recent_lo_id(
2069: p_event_id ota_events.event_id%type,
2070: p_user_id fnd_user.user_id%type,
2071: p_user_type ota_attempts.user_type%type,
2072: p_launch_type ota_attempts.launch_type%type,
2073: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type is
2074:
2075: cursor ordered_los(
2076: p_root_lo_id ota_learning_objects.learning_object_id%type,
2069: p_event_id ota_events.event_id%type,
2070: p_user_id fnd_user.user_id%type,
2071: p_user_type ota_attempts.user_type%type,
2072: p_launch_type ota_attempts.launch_type%type,
2073: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type is
2074:
2075: cursor ordered_los(
2076: p_root_lo_id ota_learning_objects.learning_object_id%type,
2077: p_user_id fnd_user.user_id%type,
2074:
2075: cursor ordered_los(
2076: p_root_lo_id ota_learning_objects.learning_object_id%type,
2077: p_user_id fnd_user.user_id%type,
2078: p_user_type ota_attempts.user_type%type,
2079: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) is
2080: select a.learning_object_id, max(a.attempt_id) max_attempt
2081: from ota_attempts a,
2082: (select learning_object_id, starting_url
2075: cursor ordered_los(
2076: p_root_lo_id ota_learning_objects.learning_object_id%type,
2077: p_user_id fnd_user.user_id%type,
2078: p_user_type ota_attempts.user_type%type,
2079: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) is
2080: select a.learning_object_id, max(a.attempt_id) max_attempt
2081: from ota_attempts a,
2082: (select learning_object_id, starting_url
2083: from ota_learning_objects
2077: p_user_id fnd_user.user_id%type,
2078: p_user_type ota_attempts.user_type%type,
2079: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) is
2080: select a.learning_object_id, max(a.attempt_id) max_attempt
2081: from ota_attempts a,
2082: (select learning_object_id, starting_url
2083: from ota_learning_objects
2084: start with learning_object_id = p_root_lo_id
2085: connect by parent_learning_object_id = prior learning_object_id) lo
2115:
2116: function get_first_lo_id(
2117: p_event_id ota_events.event_id%type,
2118: p_user_id fnd_user.user_id%type,
2119: p_user_type ota_attempts.user_type%type,
2120: p_launch_type ota_attempts.launch_type%type,
2121: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2122:
2123: v_root_lo_id ota_learning_objects.learning_object_id%type;
2116: function get_first_lo_id(
2117: p_event_id ota_events.event_id%type,
2118: p_user_id fnd_user.user_id%type,
2119: p_user_type ota_attempts.user_type%type,
2120: p_launch_type ota_attempts.launch_type%type,
2121: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2122:
2123: v_root_lo_id ota_learning_objects.learning_object_id%type;
2124: v_first_lo_id ota_learning_objects.learning_object_id%type;
2117: p_event_id ota_events.event_id%type,
2118: p_user_id fnd_user.user_id%type,
2119: p_user_type ota_attempts.user_type%type,
2120: p_launch_type ota_attempts.launch_type%type,
2121: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type is
2122:
2123: v_root_lo_id ota_learning_objects.learning_object_id%type;
2124: v_first_lo_id ota_learning_objects.learning_object_id%type;
2125: v_reason number;
2136: function get_jump_lo_id(
2137: p_lo_id ota_learning_objects.learning_object_id%type,
2138: p_event_id ota_events.event_id%type,
2139: p_user_id fnd_user.user_id%type,
2140: p_user_type ota_attempts.user_type%type,
2141: p_launch_type ota_attempts.launch_type%type,
2142: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type is
2143: begin
2144: return get_jump_lo_id(p_lo_id, p_event_id, p_user_id, p_user_type, p_launch_type, null, p_reason);
2137: p_lo_id ota_learning_objects.learning_object_id%type,
2138: p_event_id ota_events.event_id%type,
2139: p_user_id fnd_user.user_id%type,
2140: p_user_type ota_attempts.user_type%type,
2141: p_launch_type ota_attempts.launch_type%type,
2142: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type is
2143: begin
2144: return get_jump_lo_id(p_lo_id, p_event_id, p_user_id, p_user_type, p_launch_type, null, p_reason);
2145: end get_jump_lo_id;
2147: function get_jump_lo_id(
2148: p_lo_id ota_learning_objects.learning_object_id%type,
2149: p_event_id ota_events.event_id%type,
2150: p_user_id fnd_user.user_id%type,
2151: p_user_type ota_attempts.user_type%type,
2152: p_launch_type ota_attempts.launch_type%type,
2153: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
2154: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type is
2155: begin
2148: p_lo_id ota_learning_objects.learning_object_id%type,
2149: p_event_id ota_events.event_id%type,
2150: p_user_id fnd_user.user_id%type,
2151: p_user_type ota_attempts.user_type%type,
2152: p_launch_type ota_attempts.launch_type%type,
2153: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
2154: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type is
2155: begin
2156: if user_can_attempt_lo(p_lo_id, p_event_id, p_user_id, p_user_type, p_launch_type, p_cert_prd_enroll_id, p_reason) then
2149: p_event_id ota_events.event_id%type,
2150: p_user_id fnd_user.user_id%type,
2151: p_user_type ota_attempts.user_type%type,
2152: p_launch_type ota_attempts.launch_type%type,
2153: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
2154: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type is
2155: begin
2156: if user_can_attempt_lo(p_lo_id, p_event_id, p_user_id, p_user_type, p_launch_type, p_cert_prd_enroll_id, p_reason) then
2157: return p_lo_id;
2187:
2188: function user_can_attempt_event(
2189: p_event_id ota_events.event_id%type,
2190: p_user_id fnd_user.user_id%type,
2191: p_user_type ota_attempts.user_type%type) return varchar2 is
2192:
2193: l_reason number;
2194: begin
2195: return user_can_attempt_event(p_event_id, p_user_id, p_user_type, '', l_reason);
2198:
2199: function user_can_attempt_event(
2200: p_event_id ota_events.event_id%type,
2201: p_user_id fnd_user.user_id%type,
2202: p_user_type ota_attempts.user_type%type,
2203: p_launch_type ota_attempts.launch_type%type) return varchar2 is
2204:
2205: l_reason number;
2206: begin
2199: function user_can_attempt_event(
2200: p_event_id ota_events.event_id%type,
2201: p_user_id fnd_user.user_id%type,
2202: p_user_type ota_attempts.user_type%type,
2203: p_launch_type ota_attempts.launch_type%type) return varchar2 is
2204:
2205: l_reason number;
2206: begin
2207: return user_can_attempt_event(p_event_id, p_user_id, p_user_type, p_launch_type, l_reason);
2233: -- {End of Comments}
2234: ------------------------------------------------------------------
2235: FUNCTION get_lo_title_for_tree(p_lo_id IN NUMBER,
2236: p_user_id IN NUMBER,
2237: p_user_type IN ota_attempts.user_type%type,
2238: p_mode IN NUMBER default 1,
2239: p_active_cert_flag varchar2 default 'N',
2240: p_scorm_learning_attempt_id In ota_performances.scorm_learner_attempt_id%type default null)
2241: RETURN varchar2
2462: End get_lo_title_for_tree;
2463:
2464: function get_play_button(
2465: p_user_id fnd_user.user_id%type,
2466: p_user_type ota_attempts.user_type%type,
2467: p_is_manager varchar2,
2468: p_event_id ota_events.event_id%type,
2469: p_event_type ota_events.event_type%type,
2470: p_synchronous_flag ota_category_usages.synchronous_flag%type,
2471: p_online_flag ota_category_usages.online_flag%type,
2472: p_course_start_date ota_events.course_start_date%type,
2473: p_course_end_date ota_events.course_end_date%type,
2474: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
2475: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
2476: p_contact_id ota_cert_enrollments.contact_id%type default null,
2477: p_chk_active_cert_flag varchar2 default 'N') return varchar2 is
2478:
2479:
2672:
2673:
2674: function get_play_button_for_test(
2675: p_user_id fnd_user.user_id%type,
2676: p_user_type ota_attempts.user_type%type,
2677: p_event_id ota_events.event_id%type,
2678: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
2679:
2680: v_lo_id ota_learning_objects.learning_object_id%type;
2674: function get_play_button_for_test(
2675: p_user_id fnd_user.user_id%type,
2676: p_user_type ota_attempts.user_type%type,
2677: p_event_id ota_events.event_id%type,
2678: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
2679:
2680: v_lo_id ota_learning_objects.learning_object_id%type;
2681: begin
2682: select offr.learning_object_id
2763: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2764:
2765: CURSOR c_attempts_info is
2766: Select attempt_id
2767: From ota_attempts
2768: Where event_id = p_event_id
2769: and user_id = p_user_id
2770: and (act_eval_id = l_act_eval_id
2771: or test_id = p_test_id)
2919: -- [End of Comments]
2920: -- ---------------------------------------------------------------------------
2921: function get_wait_duration_for_lo(
2922: p_user_id fnd_user.user_id%type,
2923: p_user_type ota_attempts.user_type%type,
2924: p_lo_id ota_learning_objects.learning_object_id%type,
2925: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
2926:
2927: v_earliest_attempt_date date;
2921: function get_wait_duration_for_lo(
2922: p_user_id fnd_user.user_id%type,
2923: p_user_type ota_attempts.user_type%type,
2924: p_lo_id ota_learning_objects.learning_object_id%type,
2925: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
2926:
2927: v_earliest_attempt_date date;
2928: begin
2929: v_earliest_attempt_date :=
2949: -- [End of Comments]
2950: -- ---------------------------------------------------------------------------
2951: function get_wait_duration_for_test(
2952: p_user_id fnd_user.user_id%type,
2953: p_user_type ota_attempts.user_type%type,
2954: p_event_id ota_events.event_id%type,
2955: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
2956:
2957: v_lo_id ota_learning_objects.learning_object_id%type;
2951: function get_wait_duration_for_test(
2952: p_user_id fnd_user.user_id%type,
2953: p_user_type ota_attempts.user_type%type,
2954: p_event_id ota_events.event_id%type,
2955: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2 is
2956:
2957: v_lo_id ota_learning_objects.learning_object_id%type;
2958: v_wait_duration varchar2(80);
2959: --Bug 5166350
3060: -- {End Of Comments}
3061: ----------------------------------------------------------------------------
3062: --
3063: FUNCTION get_player_status(p_user_id IN NUMBER,
3064: p_user_type IN ota_attempts.user_type%type,
3065: p_event_id IN ota_events.event_id%TYPE,
3066: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
3067: RETURN VARCHAR2 IS
3068:
3160: -- {End Of Comments}
3161: ----------------------------------------------------------------------------
3162: --
3163: FUNCTION get_enroll_lo_time(p_user_id IN NUMBER,
3164: p_user_type IN ota_attempts.user_type%type,
3165: p_event_id IN ota_events.event_id%TYPE,
3166: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
3167: RETURN VARCHAR2 IS
3168:
3260: -- {End Of Comments}
3261: ----------------------------------------------------------------------------
3262: --
3263: FUNCTION get_enroll_lo_score(p_user_id IN NUMBER,
3264: p_user_type IN ota_attempts.user_type%type,
3265: p_event_id IN ota_events.event_id%TYPE,
3266: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
3267: RETURN VARCHAR2 IS
3268:
3366: -- {End Of Comments}
3367: ----------------------------------------------------------------------------
3368: --
3369: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
3370: p_user_type IN ota_attempts.user_type%type,
3371: p_event_id IN ota_events.event_id%TYPE,
3372: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
3373: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
3374: p_mode IN number default null,
3804: ------------------------------------------------------------------
3805: --Added method get_lo_completion_date_time,similar to get_lo_completion_date but returns a date allowing UI sort
3806: FUNCTION get_lo_completion_date(p_event_id IN ota_events.event_id%type,
3807: p_user_id IN NUMBER,
3808: p_user_type IN ota_attempts.user_type%type,
3809: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
3810: p_module_name IN VARCHAR2 default 'LEARNER')
3811: RETURN varchar2
3812: IS
3911: --Similar to get_lo_completion_date,but the return type is date.Called from admin side
3912:
3913: FUNCTION get_lo_completion_date_time(p_event_id IN ota_events.event_id%type,
3914: p_user_id IN NUMBER,
3915: p_user_type IN ota_attempts.user_type%type,
3916: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
3917: p_module_name IN VARCHAR2 default 'LEARNER')
3918: RETURN date
3919: IS
4043: ----------------------------------------------------------------------------
4044:
4045:
4046: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
4047: p_user_type IN ota_attempts.user_type%type,
4048: p_event_id IN ota_events.event_id%TYPE,
4049: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
4050: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
4051: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
4170: ------------------------------------------------------------------
4171:
4172: FUNCTION get_cert_lo_title_for_tree(p_lo_id IN NUMBER,
4173: p_user_id IN NUMBER,
4174: p_user_type IN ota_attempts.user_type%type,
4175: p_cert_prd_enrollment_id IN ota_performances.cert_prd_enrollment_id%type,
4176: p_mode IN NUMBER default 1,
4177: p_scormattempid IN ota_performances.scorm_learner_attempt_id%type default null)
4178: RETURN varchar2
4383: RETURN l_return_tree_title;
4384: End get_cert_lo_title_for_tree;
4385:
4386: function get_cme_online_event_id(p_user_id in fnd_user.user_id%type,
4387: p_user_type in ota_attempts.user_type%type,
4388: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4389: return varchar2 is
4390: CURSOR csr_cme_info IS
4391: SELECT cme.cert_mbr_enrollment_id,
4524:
4525: End get_cme_online_event_id;
4526:
4527: function get_cme_play_button(p_user_id in fnd_user.user_id%type,
4528: p_user_type in ota_attempts.user_type%type,
4529: p_is_manager in varchar2,
4530: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4531: return varchar2 is
4532:
4596: End get_cme_play_button;
4597:
4598:
4599: function get_cme_player_toolbar_flag(p_user_id in fnd_user.user_id%type,
4600: p_user_type in ota_attempts.user_type%type,
4601: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4602: return varchar2 is
4603:
4604: cursor csr_toolbar_flag(csr_event_id ota_events.event_id%type) is
4643:
4644: End get_cme_player_toolbar_flag;
4645:
4646: function get_cert_lo_status(p_user_id in fnd_user.user_id%type,
4647: p_user_type in ota_attempts.user_type%type,
4648: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4649: return varchar2 is
4650:
4651: CURSOR csr_event(csr_event_id ota_events.event_id%type) IS
4799:
4800: End get_cert_lo_status;
4801:
4802: function get_cme_onl_evt_count(p_user_id in fnd_user.user_id%type,
4803: p_user_type in ota_attempts.user_type%type,
4804: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4805: return varchar2 is
4806: CURSOR csr_cme_info IS
4807: SELECT cme.cert_mbr_enrollment_id,
5103:
5104: End get_lme_online_event_id;
5105:
5106: function get_lme_play_button(p_user_id in fnd_user.user_id%type,
5107: p_user_type in ota_attempts.user_type%type,
5108: p_is_manager in varchar2,
5109: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
5110: return varchar2 is
5111:
5210:
5211: End get_lme_player_toolbar_flag;
5212:
5213: function get_lpe_lo_status(p_user_id in fnd_user.user_id%type,
5214: p_user_type in ota_attempts.user_type%type,
5215: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
5216: return varchar2 is
5217:
5218: CURSOR csr_event(csr_event_id ota_events.event_id%type) IS
5634: ----------------------------------------------------------------------------
5635: --
5636: --modified for 14000818
5637: FUNCTION get_num_of_online_records(p_user_id IN NUMBER,
5638: p_user_type IN ota_attempts.user_type%type,
5639: p_event_id IN ota_events.event_id%TYPE,
5640: p_mode IN number default null,
5641: p_chk_active_cert_flag varchar2 default 'N')
5642: RETURN INTEGER IS