302: gv_other_detail VARCHAR2(255);
303: BEGIN -- assp_val_sgcmt_clsd
304: -- Validate the System Grade Creation Method Type closed indicator.
305: DECLARE
306: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
307: v_ret_val BOOLEAN DEFAULT TRUE;
308: CURSOR c_sgcmt IS
309: SELECT closed_ind
310: FROM IGS_LOOKUPS_VIEW
306: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
307: v_ret_val BOOLEAN DEFAULT TRUE;
308: CURSOR c_sgcmt IS
309: SELECT closed_ind
310: FROM IGS_LOOKUPS_VIEW
311: WHERE LOOKUP_TYPE = p_s_grade_creation_method_type;
312: BEGIN
313: p_message_name := NULL;
314: OPEN c_sgcmt;