APPS.IGS_RE_VAL_RSUP dependencies on IGS_PS_COURSE

Line 34: -- are mandatory or where the IGS_PS_COURSE is defined as

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
34: -- are mandatory or where the IGS_PS_COURSE is defined as
35: -- a research supervisor.
36: DECLARE
37: v_commencement_dt DATE;
38: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 65: cp_course_cd IGS_PS_COURSE.course_cd%TYPE) IS

61: acai.nominated_course_cd = cp_nom_course_cd AND
62: acai.sequence_number = cp_seq_number;
63: v_acai_rec c_acai%ROWTYPE;
64: CURSOR c_sca(
65: cp_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
66: SELECT sca.version_number
67: FROM IGS_EN_STDNT_PS_ATT sca
68: WHERE sca.person_id = p_ca_person_id AND
69: sca.course_cd = cp_course_cd;

Line 84: -- Get IGS_PS_COURSE attempt IGS_PS_COURSE version

80: v_ca_rec.acai_nominated_course_cd,
81: v_ca_rec.acai_sequence_number);
82: IF v_commencement_dt IS NOT NULL THEN
83: IF v_ca_rec.sca_course_cd IS NOT NULL THEN
84: -- Get IGS_PS_COURSE attempt IGS_PS_COURSE version
85: OPEN c_sca(v_ca_rec.sca_course_cd);
86: FETCH c_sca INTO v_crv_version_number;
87: IF c_sca%NOTFOUND THEN
88: CLOSE c_sca;