[Home] [Help]
642: v_source_lo_id ota_learning_objects.learning_object_id%type;
643: v_business_group_id ota_learning_objects.business_group_id%type;
644: v_old_lesson_status ota_performances.lesson_status%type;
645: v_new_lesson_status ota_performances.lesson_status%type;
646: v_performance_source ota_performances.source%type;
647: begin
648: -- The performance is actually stored on the source learning object, so get that ID.
649: -- Also get the business group in case we have to create a new performance record.
650: select source_learning_object_id, business_group_id
737: lesson_status, score, time, completed_date,
738: created_by, creation_date, last_updated_by, last_update_date,
739: source, object_version_number, business_group_id, cert_prd_enrollment_id)
740: values
741: (ota_performances_s.nextval, p_user_id, p_user_type, v_source_lo_id,
742: p_lesson_status, -1000, -1001, v_completed_date,
743: p_user_id, p_date, p_user_id, p_date,
744: v_performance_source, 0, v_business_group_id, p_cert_prd_enroll_id);
745: else
832: v_source_lo_id ota_learning_objects.learning_object_id%type;
833: v_business_group_id ota_learning_objects.business_group_id%type;
834: v_old_time ota_performances.time%type;
835: v_new_time ota_performances.time%type;
836: v_performance_source ota_performances.source%type;
837: begin
838: -- The performance is actually stored on the source learning object, so get that ID.
839: -- Also get the business group in case we have to create a new performance record.
840: select source_learning_object_id, business_group_id
878: lesson_status, score, time,
879: created_by, creation_date, last_updated_by, last_update_date,
880: source, object_version_number, business_group_id, cert_prd_enrollment_id)
881: values
882: (ota_performances_s.nextval, p_user_id, p_user_type, v_source_lo_id,
883: 'N', -1000, p_time,
884: p_user_id, p_date, p_user_id, p_date,
885: v_performance_source, 0, v_business_group_id, p_cert_prd_enroll_id);
886: else