APPS.IGS_RE_VAL_TPM dependencies on IGS_RE_THESIS_RESULT

Line 352: -- To validate the thesis panel member IGS_RE_THESIS result code

348: IGS_GE_MSG_STACK.ADD;
349: App_Exception.Raise_Exception;
350: END resp_val_tpm_pe;
351: --
352: -- To validate the thesis panel member IGS_RE_THESIS result code
353: FUNCTION RESP_VAL_TPM_THR(
354: p_ca_person_id IN NUMBER ,
355: p_ca_sequence_number IN NUMBER ,
356: p_the_sequence_number IN NUMBER ,

Line 366: -- * Cannot be a closed IGS_RE_THESIS result code

362: RETURN BOOLEAN AS
363: BEGIN -- resp_val_tpm_thr
364: -- Description: Validate the IGS_RE_THS_PNL_MBR.thesis_result_cd
365: -- recommendation_summary fields, checking for :
366: -- * Cannot be a closed IGS_RE_THESIS result code
367: -- * Cannot set if parent thesis_examination has not been submitted
368: -- * Cannot set if panel member has not confirmed
369: DECLARE
370: v_tex_rec IGS_RE_THESIS_EXAM.submission_dt%TYPE;

Line 371: v_thr_rec IGS_RE_THESIS_RESULT.closed_ind%TYPE;

367: -- * Cannot set if parent thesis_examination has not been submitted
368: -- * Cannot set if panel member has not confirmed
369: DECLARE
370: v_tex_rec IGS_RE_THESIS_EXAM.submission_dt%TYPE;
371: v_thr_rec IGS_RE_THESIS_RESULT.closed_ind%TYPE;
372: CURSOR c_tex IS
373: SELECT tex.submission_dt
374: FROM IGS_RE_THESIS_EXAM tex
375: WHERE tex.person_id = p_ca_person_id AND

Line 381: FROM IGS_RE_THESIS_RESULT thr

377: tex.the_sequence_number = p_the_sequence_number AND
378: tex.creation_dt = p_creation_dt;
379: CURSOR c_thr IS
380: SELECT thr.closed_ind
381: FROM IGS_RE_THESIS_RESULT thr
382: WHERE thr.thesis_result_cd = p_thesis_result_cd;
383: BEGIN
384: p_message_name := NULL;
385: IF p_thesis_result_cd IS NOT NULL OR