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_LO_UTILITY dependencies on OTA_PERFORMANCES

Line 40: p_lesson_status ota_performances.lesson_status%type,

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: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
43:
44:

Line 41: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,

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: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
43:
44:
45: procedure set_performance_lesson_status(

Line 42: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_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: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
43:
44:
45: procedure set_performance_lesson_status(
46: p_lo_id ota_learning_objects.learning_object_id%type,

Line 49: p_lesson_status ota_performances.lesson_status%type,

45: procedure set_performance_lesson_status(
46: p_lo_id ota_learning_objects.learning_object_id%type,
47: p_user_id fnd_user.user_id%type,
48: p_user_type ota_attempts.user_type%type,
49: p_lesson_status ota_performances.lesson_status%type,
50: p_date date,
51: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
52: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
53:

Line 51: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,

47: p_user_id fnd_user.user_id%type,
48: p_user_type ota_attempts.user_type%type,
49: p_lesson_status ota_performances.lesson_status%type,
50: p_date date,
51: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
52: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
53:
54: --13485033
55: procedure set_performance_lesson_status(

Line 52: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);

48: p_user_type ota_attempts.user_type%type,
49: p_lesson_status ota_performances.lesson_status%type,
50: p_date date,
51: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
52: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
53:
54: --13485033
55: procedure set_performance_lesson_status(
56: p_lo_id ota_learning_objects.learning_object_id%type,

Line 59: p_lesson_status ota_performances.lesson_status%type,

55: procedure set_performance_lesson_status(
56: p_lo_id ota_learning_objects.learning_object_id%type,
57: p_user_id fnd_user.user_id%type,
58: p_user_type ota_attempts.user_type%type,
59: p_lesson_status ota_performances.lesson_status%type,
60: p_cascaded varchar2,
61: p_date date,
62: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
63: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);

Line 62: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,

58: p_user_type ota_attempts.user_type%type,
59: p_lesson_status ota_performances.lesson_status%type,
60: p_cascaded varchar2,
61: p_date date,
62: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
63: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
64:
65: procedure set_performance_time(
66: p_lo_id ota_learning_objects.learning_object_id%type,

Line 63: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);

59: p_lesson_status ota_performances.lesson_status%type,
60: p_cascaded varchar2,
61: p_date date,
62: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
63: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
64:
65: procedure set_performance_time(
66: p_lo_id ota_learning_objects.learning_object_id%type,
67: p_user_id fnd_user.user_id%type,

Line 69: p_time ota_performances.time%type,

65: procedure set_performance_time(
66: p_lo_id ota_learning_objects.learning_object_id%type,
67: p_user_id fnd_user.user_id%type,
68: p_user_type ota_attempts.user_type%type,
69: p_time ota_performances.time%type,
70: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
71: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
72:
73:

Line 70: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,

66: p_lo_id ota_learning_objects.learning_object_id%type,
67: p_user_id fnd_user.user_id%type,
68: p_user_type ota_attempts.user_type%type,
69: p_time ota_performances.time%type,
70: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
71: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
72:
73:
74: procedure set_performance_time(

Line 71: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);

67: p_user_id fnd_user.user_id%type,
68: p_user_type ota_attempts.user_type%type,
69: p_time ota_performances.time%type,
70: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
71: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
72:
73:
74: procedure set_performance_time(
75: p_lo_id ota_learning_objects.learning_object_id%type,

Line 78: p_time ota_performances.time%type,

74: procedure set_performance_time(
75: p_lo_id ota_learning_objects.learning_object_id%type,
76: p_user_id fnd_user.user_id%type,
77: p_user_type ota_attempts.user_type%type,
78: p_time ota_performances.time%type,
79: p_date date,
80: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
81: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
82:

Line 80: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,

76: p_user_id fnd_user.user_id%type,
77: p_user_type ota_attempts.user_type%type,
78: p_time ota_performances.time%type,
79: p_date date,
80: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
81: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
82:
83:
84: function get_previous_event_lo_id(

Line 81: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);

77: p_user_type ota_attempts.user_type%type,
78: p_time ota_performances.time%type,
79: p_date date,
80: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
81: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
82:
83:
84: function get_previous_event_lo_id(
85: p_event_id ota_events.event_id%type,

Line 220: p_scorm_learning_attempt_id In ota_performances.scorm_learner_attempt_id%type default null)

216: p_user_id IN NUMBER,
217: p_user_type IN ota_attempts.user_type%type,
218: p_mode IN NUMBER default 1,
219: p_active_cert_flag varchar2 default 'N',
220: p_scorm_learning_attempt_id In ota_performances.scorm_learner_attempt_id%type default null)
221: RETURN varchar2;
222:
223:
224:

Line 398: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,

394:
395: FUNCTION get_lo_completion_date(p_event_id IN ota_events.event_id%type,
396: p_user_id IN NUMBER,
397: p_user_type IN ota_attempts.user_type%type,
398: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
399: p_module_name IN VARCHAR2 default 'LEARNER')
400: RETURN varchar2;
401:
402: -- ----------------------------------------------------------------------------

Line 472: p_cert_prd_enrollment_id IN ota_performances.cert_prd_enrollment_id%type,

468:
469: FUNCTION get_cert_lo_title_for_tree(p_lo_id IN NUMBER,
470: p_user_id IN NUMBER,
471: p_user_type IN ota_attempts.user_type%type,
472: p_cert_prd_enrollment_id IN ota_performances.cert_prd_enrollment_id%type,
473: p_mode IN NUMBER default 1,
474: p_scormattempid IN ota_performances.scorm_learner_attempt_id%type default null)
475: RETURN varchar2;
476:

Line 474: p_scormattempid IN ota_performances.scorm_learner_attempt_id%type default null)

470: p_user_id IN NUMBER,
471: p_user_type IN ota_attempts.user_type%type,
472: p_cert_prd_enrollment_id IN ota_performances.cert_prd_enrollment_id%type,
473: p_mode IN NUMBER default 1,
474: p_scormattempid IN ota_performances.scorm_learner_attempt_id%type default null)
475: RETURN varchar2;
476:
477: -- ----------------------------------------------------------------
478: -- --------------------------------------

Line 622: Function format_lo_time(pTime ota_performances.time%type)

618: -- Access Status
619: -- Public
620: -- {End of Comments}
621: ------------------------------------------------------------------
622: Function format_lo_time(pTime ota_performances.time%type)
623: return varchar2;
624:
625: -- ----------------------------------------------------------------
626: -- --------------------------------------

Line 768: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,

764:
765: FUNCTION get_lo_completion_date_time(p_event_id IN ota_events.event_id%type,
766: p_user_id IN NUMBER,
767: p_user_type IN ota_attempts.user_type%type,
768: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
769: p_module_name IN VARCHAR2 default 'LEARNER')
770: RETURN date;
771: -- ----------------------------------------------------------------------------
772: -- |-------------------------< get_enroll_lo_score >--------------------------|