43: FROM dual;
44:
45: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
46:
47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
48: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
49: SELECT *
50: FROM igs_re_thesis_all
51: WHERE person_id = cp_person_id
44:
45: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
46:
47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
48: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
49: SELECT *
50: FROM igs_re_thesis_all
51: WHERE person_id = cp_person_id
52: AND ca_sequence_number = cp_ca_sequence_number;
46:
47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
48: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
49: SELECT *
50: FROM igs_re_thesis_all
51: WHERE person_id = cp_person_id
52: AND ca_sequence_number = cp_ca_sequence_number;
53:
54: CURSOR c_get_thesis_sequence IS
54: CURSOR c_get_thesis_sequence IS
55: SELECT igs_re_thesis_seq_num_s.nextval
56: FROM dual;
57:
58: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
59:
60: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,
61: cp_ca_sequence_number igs_re_cdt_fld_of_sy.ca_sequence_number%TYPE) IS
62: SELECT *