APPS.IGS_EN_GEN_002 dependencies on IGS_PE_PERSON

Line 82: cp_person_id IGS_PE_PERSON.person_id%TYPE,

78: DECLARE
79: v_output VARCHAR2(25);
80: v_first_enrolment_course VARCHAR2(25);
81: CURSOR c_suav_details (
82: cp_person_id IGS_PE_PERSON.person_id%TYPE,
83: cp_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
84: SELECT IGS_EN_GEN_014.enrs_get_acad_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
85: ||'/'|| IGS_CA_GEN_001.calp_get_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
86: FROM IGS_EN_SU_ATTEMPT SUAV,

Line 97: -- IGS_PE_PERSON is first enrolled in for a specified

93: ORDER BY CI.start_dt,
94: CI.end_dt ;
95: BEGIN
96: -- This module determines the enrolment period a
97: -- IGS_PE_PERSON is first enrolled in for a specified
98: -- IGS_PS_COURSE and returns it. A null value may
99: -- also be returned.
100: -- Retrieving the student IGS_PS_UNIT attempt records for the
101: -- IGS_PE_PERSON's IGS_PS_COURSE attempt.

Line 101: -- IGS_PE_PERSON's IGS_PS_COURSE attempt.

97: -- IGS_PE_PERSON is first enrolled in for a specified
98: -- IGS_PS_COURSE and returns it. A null value may
99: -- also be returned.
100: -- Retrieving the student IGS_PS_UNIT attempt records for the
101: -- IGS_PE_PERSON's IGS_PS_COURSE attempt.
102: -- The order the records are returned will ensure that
103: -- the oldest IGS_PS_UNIT attempt record for the IGS_PE_PERSON's IGS_PS_COURSE
104: -- attempt is returned first.
105: -- modified cursor c_suav_details for performance bug 3687016

Line 103: -- the oldest IGS_PS_UNIT attempt record for the IGS_PE_PERSON's IGS_PS_COURSE

99: -- also be returned.
100: -- Retrieving the student IGS_PS_UNIT attempt records for the
101: -- IGS_PE_PERSON's IGS_PS_COURSE attempt.
102: -- The order the records are returned will ensure that
103: -- the oldest IGS_PS_UNIT attempt record for the IGS_PE_PERSON's IGS_PS_COURSE
104: -- attempt is returned first.
105: -- modified cursor c_suav_details for performance bug 3687016
106: OPEN c_suav_details(p_person_id,
107: p_course_cd);

Line 726: -- Return output parameters indicating whether or not data exists on IGS_PE_PERSON

722: p_research_exists OUT NOCOPY boolean ,
723: p_prenrol_exists OUT NOCOPY boolean )
724: AS
725: BEGIN -- enrp_get_crs_exists
726: -- Return output parameters indicating whether or not data exists on IGS_PE_PERSON
727: -- IGS_PS_COURSE attempt detail tables for the specified IGS_PE_PERSON ID.
728: DECLARE
729: v_check VARCHAR2(1);
730: CURSOR c_scan

Line 727: -- IGS_PS_COURSE attempt detail tables for the specified IGS_PE_PERSON ID.

723: p_prenrol_exists OUT NOCOPY boolean )
724: AS
725: BEGIN -- enrp_get_crs_exists
726: -- Return output parameters indicating whether or not data exists on IGS_PE_PERSON
727: -- IGS_PS_COURSE attempt detail tables for the specified IGS_PE_PERSON ID.
728: DECLARE
729: v_check VARCHAR2(1);
730: CURSOR c_scan
731: IS

Line 779: -- Check for the existence of a IGS_PE_PERSON Notes record.

775: p_hecs_exists := FALSE;
776: p_research_exists := FALSE;
777: p_prenrol_exists := FALSE;
778: IF p_check_notes = TRUE THEN
779: -- Check for the existence of a IGS_PE_PERSON Notes record.
780: OPEN c_scan;
781: FETCH c_scan INTO v_check;
782: IF c_scan%FOUND THEN
783: CLOSE c_scan;