468: l_api_name CONSTANT VARCHAR2(30) := 'Thesis Details';
469: l_api_version CONSTANT NUMBER := 1.0;
470: l_the_exam_status VARCHAR2(15) := 'VALID';
471: l_person_id igs_re_thesis.person_id%TYPE := NULL;
472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;
476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;