[Home] [Help]
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,
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
138:
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,
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,
878: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) is
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,
912: v_source_lo_id ota_learning_objects.learning_object_id%type;
913: v_business_group_id ota_learning_objects.business_group_id%type;
914: v_old_lesson_status ota_performances.lesson_status%type;
915: v_new_lesson_status ota_performances.lesson_status%type;
916: v_performance_source ota_performances.source%type;
917: begin
918: -- The performance is actually stored on the source learning object, so get that ID.
919: -- Also get the business group in case we have to create a new performance record.
920: select source_learning_object_id, business_group_id
1016: lesson_status, score, time, completed_date,
1017: created_by, creation_date, last_updated_by, last_update_date,
1018: source, object_version_number, business_group_id, cert_prd_enrollment_id)
1019: values
1020: (ota_performances_s.nextval, p_user_id, p_user_type, v_source_lo_id,
1021: p_lesson_status, -1000, -1001, v_completed_date,
1022: p_user_id, p_date, p_user_id, p_date,
1023: v_performance_source, 0, v_business_group_id, p_cert_prd_enroll_id);
1024: else
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,
1053: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) is
1054: l_cascaded boolean := false;
1055: begin
1056: if(p_cascaded = 'Y') then
1057: l_cascaded:=true;
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
1072: begin
1073: set_performance_lesson_status(p_lo_id, p_user_id, p_user_type, p_lesson_status, false, p_date, p_cert_prd_enroll_id, p_scorm_learner_attempt_id);
1074: end set_performance_lesson_status;
1075:
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
1085: set_performance_lesson_status(p_lo_id, p_user_id, p_user_type, p_lesson_status, sysdate, p_cert_prd_enroll_id, p_scorm_learner_attempt_id);
1086: end set_performance_lesson_status;
1087:
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,
1097: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type) is
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,
1135: v_source_lo_id ota_learning_objects.learning_object_id%type;
1136: v_business_group_id ota_learning_objects.business_group_id%type;
1137: v_old_time ota_performances.time%type;
1138: v_new_time ota_performances.time%type;
1139: v_performance_source ota_performances.source%type;
1140: begin
1141: -- The performance is actually stored on the source learning object, so get that ID.
1142: -- Also get the business group in case we have to create a new performance record.
1143: select source_learning_object_id, business_group_id
1183: lesson_status, score, time,
1184: created_by, creation_date, last_updated_by, last_update_date,
1185: source, object_version_number, business_group_id, cert_prd_enrollment_id)
1186: values
1187: (ota_performances_s.nextval, p_user_id, p_user_type, v_source_lo_id,
1188: 'N', -1000, p_time,
1189: p_user_id, p_date, p_user_id, p_date,
1190: v_performance_source, 0, v_business_group_id, p_cert_prd_enroll_id);
1191: else
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
1220: begin
1221: set_performance_time(p_lo_id, p_user_id, p_user_type, p_time, false, p_date, p_cert_prd_enroll_id, p_scorm_learner_attempt_id);
1222: end set_performance_time;
1223:
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
1233: set_performance_time(p_lo_id, p_user_id, p_user_type, p_time, sysdate, p_cert_prd_enroll_id, p_scorm_learner_attempt_id);
1234: end set_performance_time;
1235:
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
2242: IS
2243: l_proc VARCHAR2(72) := g_package||'get_lo_title_for_tree';
2244: l_lo_name varchar(240);
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
4179: IS
4180: l_proc VARCHAR2(72) := g_package||'get_cert_lo_title_for_tree';
4181: l_lo_name varchar(240);