36: procedure set_performance_lesson_status(
37: p_lo_id ota_learning_objects.learning_object_id%type,
38: p_user_id fnd_user.user_id%type,
39: p_user_type ota_attempts.user_type%type,
40: p_lesson_status ota_performances.lesson_status%type,
41: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
42:
43:
44: procedure set_performance_lesson_status(
37: p_lo_id ota_learning_objects.learning_object_id%type,
38: p_user_id fnd_user.user_id%type,
39: p_user_type ota_attempts.user_type%type,
40: p_lesson_status ota_performances.lesson_status%type,
41: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
42:
43:
44: procedure set_performance_lesson_status(
45: p_lo_id ota_learning_objects.learning_object_id%type,
44: procedure set_performance_lesson_status(
45: p_lo_id ota_learning_objects.learning_object_id%type,
46: p_user_id fnd_user.user_id%type,
47: p_user_type ota_attempts.user_type%type,
48: p_lesson_status ota_performances.lesson_status%type,
49: p_date date,
50: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
51:
52: procedure set_performance_time(
46: p_user_id fnd_user.user_id%type,
47: p_user_type ota_attempts.user_type%type,
48: p_lesson_status ota_performances.lesson_status%type,
49: p_date date,
50: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
51:
52: procedure set_performance_time(
53: p_lo_id ota_learning_objects.learning_object_id%type,
54: p_user_id fnd_user.user_id%type,
52: procedure set_performance_time(
53: p_lo_id ota_learning_objects.learning_object_id%type,
54: p_user_id fnd_user.user_id%type,
55: p_user_type ota_attempts.user_type%type,
56: p_time ota_performances.time%type,
57: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
58:
59:
60: procedure set_performance_time(
53: p_lo_id ota_learning_objects.learning_object_id%type,
54: p_user_id fnd_user.user_id%type,
55: p_user_type ota_attempts.user_type%type,
56: p_time ota_performances.time%type,
57: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
58:
59:
60: procedure set_performance_time(
61: p_lo_id ota_learning_objects.learning_object_id%type,
60: procedure set_performance_time(
61: p_lo_id ota_learning_objects.learning_object_id%type,
62: p_user_id fnd_user.user_id%type,
63: p_user_type ota_attempts.user_type%type,
64: p_time ota_performances.time%type,
65: p_date date,
66: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
67:
68:
62: p_user_id fnd_user.user_id%type,
63: p_user_type ota_attempts.user_type%type,
64: p_time ota_performances.time%type,
65: p_date date,
66: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
67:
68:
69: function get_previous_event_lo_id(
70: p_event_id ota_events.event_id%type,
378:
379: FUNCTION get_lo_completion_date(p_event_id IN ota_events.event_id%type,
380: p_user_id IN NUMBER,
381: p_user_type IN ota_attempts.user_type%type,
382: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
383: p_module_name IN VARCHAR2 default 'LEARNER')
384: RETURN varchar2;
385:
386: -- ----------------------------------------------------------------------------
452:
453: FUNCTION get_cert_lo_title_for_tree(p_lo_id IN NUMBER,
454: p_user_id IN NUMBER,
455: p_user_type IN ota_attempts.user_type%type,
456: p_cert_prd_enrollment_id IN ota_performances.cert_prd_enrollment_id%type,
457: p_mode IN NUMBER default 1)
458: RETURN varchar2;
459:
460: -- ----------------------------------------------------------------
601: -- Access Status
602: -- Public
603: -- {End of Comments}
604: ------------------------------------------------------------------
605: Function format_lo_time(pTime ota_performances.time%type)
606: return varchar2;
607:
608: -- ----------------------------------------------------------------
609: -- ------------------
747:
748: FUNCTION get_lo_completion_date_time(p_event_id IN ota_events.event_id%type,
749: p_user_id IN NUMBER,
750: p_user_type IN ota_attempts.user_type%type,
751: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
752: p_module_name IN VARCHAR2 default 'LEARNER')
753: RETURN date;
754: -- ----------------------------------------------------------------------------
755: -- |-------------------------< get_enroll_lo_score >--------------------------|