885: CURSOR cur_re_prg(p_prg_type igs_ps_type.course_type%TYPE) IS
886: SELECT research_type_ind FROM igs_ps_type
887: WHERE course_type = p_prg_type;
888: --Cursor is to get the sequence number for the candidature.
889: CURSOR cur_re_seq IS SELECT igs_re_candidature_seq_num_s.NEXTVAL FROM DUAL;
890:
891: --local variables for flags
892: l_err_derive_flag VARCHAR2(1);
893: l_execution_flag1 VARCHAR2(1);