[Home] [Help]
1266: surname,
1267: given_names,
1268: preferred_given_name
1269: FROM
1270: igs_pe_person
1271: WHERE
1272: person_id = cp_person_id;
1273:
1274: -- Retrieve the record only if the person has a valid person address (exists in table and igs_pe_person_addr)
1270: igs_pe_person
1271: WHERE
1272: person_id = cp_person_id;
1273:
1274: -- Retrieve the record only if the person has a valid person address (exists in table and igs_pe_person_addr)
1275: -- and current date (sysdate) is :-
1276: -- Greater than start date and end date is null
1277: -- OR
1278: -- Between the start date and end date
1286: pa.addr_line_4,
1287: pa.postal_code,
1288: pa.correspondence_ind
1289: FROM
1290: igs_pe_person_addr pa
1291: WHERE
1292: pa.person_id = cp_person_id
1293: AND
1294: ( pa.status = 'A'
1429: );
1430:
1431: FETCH c_suv INTO v_suv_rec;
1432:
1433: -- Only produce an attachment if the assessment item is still valid for the IGS_PE_PERSON.
1434: IF c_suv%NOTFOUND THEN -- Start of if 1
1435:
1436: /************************************* Validation 4.1.1 **************************************************************/
1437:
1455:
1456: /************************************* Validation 4.3 **************************************************************/
1457:
1458: -- If the person id is not the last person id then get the details of the person such as title ,surname given_names,preferred_given_name
1459: -- Get the IGS_PE_PERSON name and address details if processing a new id.
1460: IF v_last_person_id <> v_enrolled_rec.person_id THEN --Start of if 3
1461:
1462: OPEN c_pe(v_enrolled_rec.person_id);
1463: FETCH c_pe INTO v_pe_rec;
1490: v_ignore_rec := TRUE;
1491: ELSE
1492: CLOSE c_pa;
1493: v_last_person_id := v_enrolled_rec.person_id;
1494: -- Reset the last IGS_PS_COURSE and IGS_PS_UNIT codes so that if it is a new IGS_PE_PERSON,
1495: -- then the appropriate IGS_PS_COURSE and unit version is retrieved.
1496: v_last_course_cd := NULL;
1497: v_last_unit_cd := NULL;
1498:
2054: --The module will be called from ASSF4630 and with two scenarios:
2055: --1. Default a supervisor to sessions within a IGS_GR_VENUE. (p_person_id not null)
2056: --2. Default supervisors to Off-campus venues. (p_person_id is null)
2057: --It will provide the ability to enforce that if warnings exist
2058: --when validating the IGS_PE_PERSON, then either allocate (p_ignore_warnings = 'Y')
2059: --or do not allocate (p_ignore_warnings = 'N') the supervisor.
2060: --This module will return a general message indicating that warnings
2061: --or errors where encountered during the processing if that is the case.
2062: DECLARE
2139: RETURN FALSE;
2140: -- At a later date, this may insert an IGS_GE_S_LOG_ENTRY for a report.
2141: END IF;
2142: --Check the following warnings:
2143: -- Validate if the IGS_PE_PERSON is not an active student.
2144: -- Warning only.
2145: IF (IGS_AS_VAL_EIS.assp_val_actv_stdnt(
2146: p_person_id,
2147: v_local_message_name) = FALSE) THEN
2150: RETURN FALSE;
2151: END IF;
2152: -- At a later date, this may insert an IGS_GE_S_LOG_ENTRY for a report.
2153: END IF;
2154: -- Validate the IGS_PE_PERSON is a staff member.
2155: -- Warning only.
2156: IF (igs_ad_val_acai.genp_val_staff_prsn(
2157: p_person_id,
2158: v_local_message_name) = FALSE) THEN
2170: v_dai_sequence_number,
2171: v_start_time,
2172: v_end_time,
2173: p_ese_id);
2174: -- Validate if the IGS_PE_PERSON is allocated to different exam locations for the
2175: -- same day.
2176: -- Warning only.
2177: IF (IGS_AS_VAL_ESVS.assp_val_esu_ese_el(
2178: p_person_id,
2208: RETURN FALSE;
2209: END IF;
2210: -- At a later date, this may insert an IGS_GE_S_LOG_ENTRY for a report.
2211: END IF;
2212: -- Validate IGS_PE_PERSON cannot be allocated concurrent sessions at different
2213: -- venues.
2214: -- Warning only.
2215: IF (IGS_AS_VAL_ESVS.assp_val_esu_ese_ve(
2216: p_person_id,
2241: RETURN FALSE;
2242: END IF;
2243: -- At a later date, this may insert an IGS_GE_S_LOG_ENTRY for a report.
2244: END IF;
2245: -- Validate if more than one IGS_PE_PERSON in-charge at a session and IGS_GR_VENUE.
2246: -- Warning only.
2247: IF IGS_AS_VAL_EIS.assp_val_ese_inchrg(
2248: p_person_id,
2249: v_exam_cal_type,
2260: RETURN FALSE;
2261: END IF;
2262: -- At a later date, this may insert an IGS_GE_S_LOG_ENTRY for a report.
2263: END IF;
2264: -- Validate if IGS_PE_PERSON is allocated as in-charge when not normally.
2265: -- Warning only.
2266: IF IGS_AS_VAL_EIS.assp_val_est_inchrg(
2267: p_person_id,
2268: v_exam_supervisor_type,
2305: ELSE
2306: v_exam_supervisor_type := p_exam_supervisor_type;
2307: END IF;
2308: IF (p_session_venue_ind = 'Y') THEN
2309: -- Insert IGS_PE_PERSON into the IGS_AS_EXM_SES_VN_SP table.
2310: x_rowid := NULL;
2311: IGS_AS_EXM_SES_VN_SP_PKG.INSERT_ROW(
2312: X_ROWID => x_rowid,
2313: X_PERSON_ID => p_person_id,
2326: );
2327: -- At a later date, a IGS_GE_S_LOG_ENTRY may be created to indicate successful
2328: -- insertion.
2329: ELSE
2330: -- Insert IGS_PE_PERSON into the IGS_AS_EXM_INS_SPVSR table. Put them into all exams
2331: -- for the IGS_GR_VENUE and session.
2332: FOR v_ei_rec IN c_ei LOOP
2333: BEGIN
2334: IGS_AS_EXM_INS_SPVSR_PKG.INSERT_ROW(
2389: --For each IGS_GR_VENUE, select the supervisors for which
2390: -- the exam venues are within their nominated exam locations.
2391: FOR v_els_rec IN c_els(
2392: v_esvv_rec.venue_cd) LOOP
2393: --Call a local function to validate the IGS_PE_PERSON being allocated
2394: IF (asspl_val_sprvsr(
2395: v_els_rec.person_id,
2396: v_esvv_rec.ese_id,
2397: v_esvv_rec.venue_cd,
2415: CLOSE c_lr;
2416: END IF;
2417: END LOOP;
2418: ELSE
2419: --p_person_id is not null so default the IGS_PE_PERSON for all sessions at the IGS_GR_VENUE.
2420: --Select all exam sessions for p_venue_cd within the exam period.
2421: FOR v_ve_rec IN c_ve LOOP
2422: --Call a local function to validate the IGS_PE_PERSON being allocated.
2423: IF (asspl_val_sprvsr(
2418: ELSE
2419: --p_person_id is not null so default the IGS_PE_PERSON for all sessions at the IGS_GR_VENUE.
2420: --Select all exam sessions for p_venue_cd within the exam period.
2421: FOR v_ve_rec IN c_ve LOOP
2422: --Call a local function to validate the IGS_PE_PERSON being allocated.
2423: IF (asspl_val_sprvsr(
2424: p_person_id,
2425: v_ve_rec.ese_id,
2426: v_ve_rec.venue_cd,