APPS.IGS_RE_VAL_RSUP dependencies on IGS_RE_CANDIDATURE

Line 29: -- on the commencement date of the research IGS_RE_CANDIDATURE.

25: p_message_name OUT NOCOPY VARCHAR2 )
26: RETURN BOOLEAN AS
27: BEGIN -- resp_val_rsup_comm
28: -- This module validates that a principal supervisor exists
29: -- on the commencement date of the research IGS_RE_CANDIDATURE.
30: -- Validatios are:
31: -- * At least one IGS_RE_SPRVSR with
32: -- IGS_RE_SPRVSR_TYPE checked as a principal
33: -- must exist fir an offer where research details

Line 40: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

36: DECLARE
37: v_commencement_dt DATE;
38: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
39: v_candidature_exists_ind VARCHAR2(1);
40: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
41: CURSOR c_ca IS
42: SELECT ca.sca_course_cd,
43: ca.acai_admission_appl_number,
44: ca.acai_nominated_course_cd,

Line 46: FROM IGS_RE_CANDIDATURE ca

42: SELECT ca.sca_course_cd,
43: ca.acai_admission_appl_number,
44: ca.acai_nominated_course_cd,
45: ca.acai_sequence_number
46: FROM IGS_RE_CANDIDATURE ca
47: WHERE ca.person_id = p_ca_person_id AND
48: ca.sequence_number = p_ca_sequence_number;
49: v_ca_rec c_ca%ROWTYPE;
50: CURSOR c_acai (

Line 167: -- This module validates IGS_RE_CANDIDATURE supervision. Validations are:

163: p_supervision_start_dt OUT NOCOPY DATE ,
164: p_message_name OUT NOCOPY VARCHAR2 )
165: RETURN BOOLEAN AS
166: BEGIN -- resp_val_rsup_perc
167: -- This module validates IGS_RE_CANDIDATURE supervision. Validations are:
168: -- * supervision exists such that research load is covered
169: -- * supervision is 100% at all times from the start onwards
170: -- * funding exists such that research load is covered
171: -- * funding is 100% at all times from the start onwards

Line 371: -- required IGS_RE_CANDIDATURE supervision start.

367: RETURN FALSE;
368: END IF;
369: IF p_parent <> 'SCA' THEN
370: -- Check that fist start date is on or prior to
371: -- required IGS_RE_CANDIDATURE supervision start.
372: -- Get start date required for supervision
373: v_first_start_dt := IGS_RE_GEN_002.RESP_GET_RSUP_START (
374: p_ca_person_id,
375: p_ca_sequence_number,

Line 466: -- This module validates that research IGS_RE_CANDIDATURE has a principal supervisor

462: p_parent IN VARCHAR2 ,
463: p_message_name OUT NOCOPY VARCHAR2 )
464: RETURN BOOLEAN AS
465: BEGIN -- resp_val_rsup_princ
466: -- This module validates that research IGS_RE_CANDIDATURE has a principal supervisor
467: -- for the required time.
468: DECLARE
469: cst_rsup CONSTANT VARCHAR2(10) := 'RSUP';
470: v_start_dt IGS_RE_SPRVSR.start_dt%TYPE;