APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_THESIS_EXAM

Line 73: -- To validate IGS_RE_THESIS examination submission date

69: IGS_GE_MSG_STACK.ADD;
70: App_Exception.Raise_Exception;
71: END genp_val_pe_deceased;
72: --
73: -- To validate IGS_RE_THESIS examination submission date
74: FUNCTION RESP_VAL_TEX_SBMSN(
75: p_person_id IN NUMBER ,
76: p_ca_sequence_number IN NUMBER ,
77: p_the_sequence_number IN NUMBER ,

Line 152: FROM IGS_RE_THESIS_EXAM tex

148: sca.course_cd = ca.sca_course_cd;
149: v_sca_rec c_sca%ROWTYPE;
150: CURSOR c_tex IS
151: SELECT 'x'
152: FROM IGS_RE_THESIS_EXAM tex
153: WHERE tex.person_id = p_person_id AND
154: tex.ca_sequence_number = p_ca_sequence_number AND
155: tex.the_sequence_number = p_the_sequence_number AND
156: tex.creation_dt < p_creation_dt AND

Line 189: FROM IGS_RE_THESIS_EXAM tex

185: csc.ca_sequence_number = p_ca_sequence_number;
186: v_csc_rec c_csc%ROWTYPE;
187: CURSOR c_tex2 IS
188: SELECT 'x'
189: FROM IGS_RE_THESIS_EXAM tex
190: WHERE tex.person_id = p_person_id AND
191: tex.ca_sequence_number = p_ca_sequence_number AND
192: tex.the_sequence_number = p_the_sequence_number AND
193: tex.creation_dt < p_creation_dt AND

Line 306: -- 3. Cannot be set if previous submitted IGS_RE_THESIS examination

302: p_message_name := 'IGS_RE_CANT_SUB_UNLES_CUR_ENR';
303: RETURN FALSE;
304: END IF;
305: CLOSE c_sca;
306: -- 3. Cannot be set if previous submitted IGS_RE_THESIS examination
307: -- records exist with no result.
308: OPEN c_tex;
309: FETCH c_tex INTO v_tex_exists;
310: IF c_tex%FOUND THEN

Line 484: -- To validate the IGS_RE_THESIS examination update

480: IGS_GE_MSG_STACK.ADD;
481: App_Exception.Raise_Exception;
482: END resp_val_tex_sbmsn;
483: --
484: -- To validate the IGS_RE_THESIS examination update
485: FUNCTION RESP_VAL_TEX_UPD(
486: p_person_id IN NUMBER ,
487: p_ca_sequence_number IN NUMBER ,
488: p_the_sequence_number IN NUMBER ,

Line 611: -- To validate IGS_RE_THESIS examination type

607: IGS_GE_MSG_STACK.ADD;
608: App_Exception.Raise_Exception;
609: END resp_val_tex_upd;
610: --
611: -- To validate IGS_RE_THESIS examination type
612: FUNCTION RESP_VAL_TEX_TET(
613: p_thesis_exam_type IN VARCHAR2 ,
614: p_message_name OUT NOCOPY VARCHAR2 )
615: RETURN BOOLEAN AS

Line 634: p_message_name := 'IGS_RE_THESIS_EXAM_TYPE_CLOSE';

630: OPEN c_tet;
631: FETCH c_tet INTO v_dummy;
632: IF c_tet%FOUND THEN
633: CLOSE c_tet;
634: p_message_name := 'IGS_RE_THESIS_EXAM_TYPE_CLOSE';
635: RETURN FALSE;
636: END IF;
637: CLOSE c_tet;
638: RETURN TRUE;

Line 653: -- To validate IGS_RE_THESIS examination result code

649: IGS_GE_MSG_STACK.ADD;
650: App_Exception.Raise_Exception;
651: END; -- resp_val_tex_tet
652: --
653: -- To validate IGS_RE_THESIS examination result code
654: FUNCTION RESP_VAL_TEX_THR(
655: p_person_id IN NUMBER ,
656: p_ca_sequence_number IN NUMBER ,
657: p_the_sequence_number IN NUMBER ,

Line 665: -- Validate IGS_RE_THESIS_EXAM.thesis_result_cd, checking for :

661: p_thesis_panel_type IN VARCHAR2 ,
662: p_message_name OUT NOCOPY VARCHAR2 )
663: RETURN BOOLEAN AS
664: BEGIN -- resp_val_tex_thr
665: -- Validate IGS_RE_THESIS_EXAM.thesis_result_cd, checking for :
666: -- Code cannot be closed
667: -- Code cannot be specified if submission_dt is not set
668: -- Warning if code does not match any of the panel members results
669: -- (if any results exist)

Line 713: FROM IGS_RE_THESIS_EXAM tex

709: thev.sequence_number = p_the_sequence_number AND
710: thev.thesis_status = cst_examined;
711: CURSOR c_tex IS
712: SELECT 'x'
713: FROM IGS_RE_THESIS_EXAM tex
714: WHERE tex.person_id = p_person_id AND
715: tex.ca_sequence_number = p_ca_sequence_number AND
716: tex.the_sequence_number = p_the_sequence_number AND
717: tex.creation_dt > p_creation_dt AND

Line 851: p_message_name := 'IGS_RE_THESIS_EXAM_TYP_CLOSED';

847: OPEN c_tpt;
848: FETCH c_tpt INTO v_dummy;
849: IF c_tpt%FOUND THEN
850: CLOSE c_tpt;
851: p_message_name := 'IGS_RE_THESIS_EXAM_TYP_CLOSED';
852: RETURN FALSE;
853: END IF;
854: CLOSE c_tpt;
855: RETURN TRUE;