Line 1390: v_cori_sequence_number IGS_CO_ITM.reference_number%TYPE;
1386: v_um_rec c_um%ROWTYPE;
1387: v_ai_rec c_ai%ROWTYPE;
1388: v_record VARCHAR2(2000);
1389: v_message_name VARCHAR2(30); 1390: v_cori_sequence_number IGS_CO_ITM.reference_number%TYPE; 1391: v_ocr_sequence_number IGS_CO_OU_CO_REF.sequence_number%TYPE;
1392: BEGIN
1393: -- Select students who are enrolled and have an assignment assessment type.
1394: -- If p_reproduce = 'Y' then are interested only in the records that have had