[Home] [Help]
81:
82: --Check constraint for thesis exam type
83: IF p_the_dtls_rec.thesis_exam_type IS NOT NULL THEN
84: BEGIN
85: igs_re_thesis_exam_pkg.check_constraints('thesis_exam_type',p_the_dtls_rec.thesis_exam_type);
86: EXCEPTION
87: WHEN OTHERS THEN
88: l_msg_count := FND_MSG_PUB.COUNT_MSG;
89: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
95:
96: --Check constraint for the Thesis Panel Type parameter
97: IF p_the_dtls_rec.thesis_panel_type IS NOT NULL THEN
98: BEGIN
99: igs_re_thesis_exam_pkg.check_constraints('thesis_panel_type',p_the_dtls_rec.thesis_panel_type);
100: EXCEPTION
101: WHEN OTHERS THEN
102: l_msg_count := FND_MSG_PUB.COUNT_MSG;
103: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
109:
110: --Check Constraint for the thesis result code
111: IF p_the_dtls_rec.thesis_result_cd IS NOT NULL THEN
112: BEGIN
113: igs_re_thesis_exam_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.thesis_result_cd);
114: EXCEPTION
115: WHEN OTHERS THEN
116: l_msg_count := FND_MSG_PUB.COUNT_MSG;
117: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
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;
477:
643:
644: IF l_the_exam_status <> 'INVALID' THEN --3rd level IF clause starts here
645: BEGIN
646: --insert data into thesis exam table
647: INSERT INTO igs_re_thesis_exam (
648: PERSON_ID,
649: CA_SEQUENCE_NUMBER,
650: THE_SEQUENCE_NUMBER,
651: CREATION_DT,