[Home] [Help]
15: | amuthu 18-May-2006 Modified the spec for ENRP_VAL_ENR_ENCMB to pass the |
16: | the effective date |
17: |-----------------------------------------------------------------------------*/
18: --
19: -- Validate whether a IGS_PE_PERSON is excluded from a IGS_PS_UNIT.
20: FUNCTION enrp_val_excld_unit(
21: p_person_id IN NUMBER ,
22: p_course_cd IN VARCHAR2 ,
23: p_unit_cd IN VARCHAR2 ,
44: pue.pee_start_dt = pee.pee_start_dt AND
45: pue.pee_sequence_number = pee.sequence_number AND
46: pue.unit_cd = p_unit_cd;
47: BEGIN
48: -- This function validates whether or not a IGS_PE_PERSON is
49: -- excluded from admission or enrolment in a specific IGS_PS_UNIT.
50: p_message_name := null;
51: -- Validate the input parameters
52: IF p_person_id IS NULL OR
99:
100:
101: END enrp_val_excld_unit;
102: --
103: -- Validate whether or not a IGS_PE_PERSON is excluded from the university.
104: FUNCTION enrp_val_excld_prsn(
105: p_person_id IN NUMBER ,
106: p_course_cd IN VARCHAR2 ,
107: p_effective_dt IN DATE ,
276: App_Exception.Raise_Exception;
277: */
278: END enrp_val_excld_prsn;
279: --
280: -- Validate whether a IGS_PE_PERSON is excluded from a IGS_PS_COURSE.
281: FUNCTION enrp_val_excld_crs(
282: p_person_id IN NUMBER ,
283: p_course_cd IN VARCHAR2 ,
284: p_effective_dt IN DATE ,
285: p_message_name OUT NOCOPY VARCHAR2)
286: RETURN BOOLEAN AS
287:
288: BEGIN -- enrp_val_excld_crs
289: -- Validate whether or not a IGS_PE_PERSON is excluded from admission or enrolment
290: -- in a specific IGS_PS_COURSE.
291: DECLARE
292: cst_excluded CONSTANT VARCHAR2(10) := 'EXC_COURSE';
293: cst_excluded_grp CONSTANT VARCHAR2(10) := 'EXC_CRS_GP';
386:
387: */
388: END enrp_val_excld_crs;
389: --
390: -- Validate whether a IGS_PE_PERSON is excluded from a IGS_PS_UNIT set.
391: FUNCTION enrp_val_excld_us(
392: p_person_id IN NUMBER ,
393: p_course_cd IN VARCHAR2 ,
394: p_unit_set_cd IN VARCHAR2 ,
417: puse.pee_sequence_number = pee.sequence_number AND
418: puse.unit_set_cd = p_unit_set_cd AND
419: puse.us_version_number = p_us_version_number;
420: BEGIN
421: -- This function validates whether or not a IGS_PE_PERSON is
422: -- excluded from admission or enrolment in a specific IGS_PS_UNIT set.
423: p_message_name := null;
424: -- Validate the input parameters
425: IF p_person_id IS NULL OR
473:
474:
475: END enrp_val_excld_us;
476: --
477: -- Validate whether a IGS_PE_PERSON is enrolled in all required units.
478: FUNCTION enrp_val_rqrd_units(
479: p_person_id IN NUMBER ,
480: p_course_cd IN VARCHAR2 ,
481: p_effective_dt IN DATE ,
529: -- Cursor validates which units a student is enrolled in,
530: -- for a particular IGS_PS_COURSE.
531: CURSOR c_sua (
532: cp_unit_cd IGS_PE_UNT_REQUIRMNT.unit_cd%TYPE,
533: cp_p_person_id IGS_PE_PERSON.person_id%TYPE,
534: cp_p_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
535: SELECT sua.ci_start_dt,
536: sua.ci_end_dt,
537: sua.unit_attempt_status
543: 'DUPLICATE',
544: 'ENROLLED',
545: 'DISCONTIN');
546: BEGIN
547: -- This function validates whether or not a IGS_PE_PERSON is enrolled
548: -- in all units they are required to enrol in.
549: -- Validate the input parameters
550: IF p_person_id IS NULL OR
551: p_course_cd IS NULL OR
729:
730:
731: END enrp_val_rqrd_units;
732: --
733: -- Validate whether or not a IGS_PE_PERSON is restricted to an attendance type.
734: FUNCTION enrp_val_rstrct_atyp(
735: p_person_id IN NUMBER ,
736: p_course_cd IN VARCHAR2 ,
737: p_effective_dt IN DATE ,
766: s_encmb_effect_type = 'RSTR_AT_TY' AND
767: course_cd = p_course_cd;
768: BEGIN
769: -- This module validates whether or not
770: -- a IGS_PE_PERSON is restricted to an attendance type.
771: p_message_name := null;
772: -- validating the input parameters
773: IF (p_person_id IS NULL OR p_effective_dt IS NULL) THEN
774: RETURN TRUE;
849:
850: END;
851: END enrp_val_rstrct_atyp;
852: --
853: -- Validate whether or not a IGS_PE_PERSON is restricted to an enrolment cp.
854: FUNCTION enrp_val_rstrct_cp(
855: p_person_id IN NUMBER ,
856: p_course_cd IN VARCHAR2 ,
857: p_effective_dt IN DATE ,
915: restricted_enrolment_cp IS NOT NULL
916: ORDER BY PEE.restricted_enrolment_cp ASC;
917: BEGIN
918: -- This module validates whether or not
919: -- a IGS_PE_PERSON is restricted to an enrolment credit point value.
920: v_message_name := null;
921: -- validating the input parameters
922: IF (p_person_id IS NULL OR p_effective_dt IS NULL) THEN
923: p_message_name := v_message_name;
1072:
1073: END;
1074: END enrp_val_rstrct_cp;
1075: --
1076: -- Validate whether a IGS_PE_PERSON has an encumbrance blocking IGS_PS_COURSE material.
1077: FUNCTION enrp_val_blk_crsmtrl(
1078: p_person_id IN NUMBER ,
1079: p_course_cd VARCHAR2 ,
1080: p_effective_dt IN DATE ,
1104: s_encmb_effect_type = cst_crsmtrl_blk AND
1105: course_cd = p_course_cd;
1106: BEGIN
1107: -- This module validates whether or not
1108: -- a IGS_PE_PERSON has an encumbracne blocking the
1109: -- issue of IGS_PS_COURSE materials
1110: p_message_name := null;
1111: -- validating the input parameters
1112: IF (p_person_id IS NULL OR p_effective_dt IS NULL) THEN
1182:
1183: END;
1184: END enrp_val_blk_crsmtrl;
1185: --
1186: -- Validate whether a IGS_PE_PERSON has an encumbrance blocking graduation.
1187: FUNCTION enrp_val_blk_grd(
1188: p_person_id IN NUMBER ,
1189: p_course_cd IN VARCHAR2 ,
1190: p_effective_dt IN DATE ,
1214: s_encmb_effect_type = cst_grad_blk AND
1215: course_cd = p_course_cd;
1216: BEGIN
1217: -- This module validates whether or not
1218: -- a IGS_PE_PERSON has an encumbrance blocking
1219: -- graduation
1220: p_message_name := null;
1221: -- validating the input parameters
1222: IF (p_person_id IS NULL OR p_effective_dt IS NULL) THEN
1292:
1293: END;
1294: END enrp_val_blk_grd;
1295: --
1296: -- Validate whether a IGS_PE_PERSON has an encumbrance blocking their ID card.
1297: FUNCTION enrp_val_blk_id_card(
1298: p_person_id IN NUMBER ,
1299: p_course_cd IN VARCHAR2 ,
1300: p_effective_dt IN DATE ,
1324: s_encmb_effect_type = cst_idcard_blk AND
1325: course_cd = p_course_cd;
1326: BEGIN
1327: -- This module validates whether or not
1328: -- a IGS_PE_PERSON has an encumbracne blocking the
1329: -- issue of an ID card
1330: p_message_name := null;
1331: -- validating the input parameters
1332: IF (p_person_id IS NULL OR p_effective_dt IS NULL) THEN
1402:
1403: END;
1404: END enrp_val_blk_id_card;
1405: --
1406: -- Validate whether a IGS_PE_PERSON has an encumbrance blocking the info booth.
1407: FUNCTION enrp_val_blk_inf_bth(
1408: p_person_id IN NUMBER ,
1409: p_course_cd IN VARCHAR2 ,
1410: p_effective_dt IN DATE ,
1434: s_encmb_effect_type = cst_infbth_blk AND
1435: course_cd = p_course_cd;
1436: BEGIN
1437: -- This module validates whether or not
1438: -- a IGS_PE_PERSON has an encumbracne blocking the
1439: -- secure services of the Information Booth
1440: -- (ie. services accessed via a PIN)
1441: p_message_name := null;
1442: -- validating the input parameters
1514:
1515: END;
1516: END enrp_val_blk_inf_bth;
1517: --
1518: -- Validate whether a IGS_PE_PERSON has an encumbrance blocking issue of results
1519: FUNCTION enrp_val_blk_result(
1520: p_person_id IN NUMBER ,
1521: p_course_cd IN VARCHAR2 ,
1522: p_effective_dt IN DATE ,
1546: s_encmb_effect_type = cst_result_blk AND
1547: course_cd = p_course_cd;
1548: BEGIN
1549: -- This module validates whether or not
1550: -- a IGS_PE_PERSON has an encumbracne blocking the
1551: -- issue of results
1552: p_message_name := null;
1553: -- validating the input parameters
1554: IF (p_person_id IS NULL OR p_effective_dt IS NULL) THEN
1623:
1624: END;
1625: END enrp_val_blk_result;
1626: --
1627: -- Validate whether a IGS_PE_PERSON has an encumbrance blocking system corresp.
1628: FUNCTION enrp_val_blk_sys_cor(
1629: p_person_id IN NUMBER ,
1630: p_course_cd IN VARCHAR2 ,
1631: p_effective_dt IN DATE ,
1655: s_encmb_effect_type = cst_cor_blk AND
1656: course_cd = p_course_cd;
1657: BEGIN
1658: -- This module validates whether or not
1659: -- a IGS_PE_PERSON has an encumbracne blocking the
1660: -- issue of systme generated correspondence
1661: p_message_name := null;
1662: -- validating the input parameters
1663: IF (p_person_id IS NULL OR p_effective_dt IS NULL) THEN
1733:
1734: END;
1735: END enrp_val_blk_sys_cor;
1736: --
1737: -- Validate whether a IGS_PE_PERSON has an encumbrance blocking acad transcript.
1738: FUNCTION enrp_val_blk_trscrpt(
1739: p_person_id IN NUMBER ,
1740: p_course_cd IN VARCHAR2 ,
1741: p_effective_dt IN DATE ,
1765: s_encmb_effect_type = cst_trans_blk AND
1766: course_cd = p_course_cd;
1767: BEGIN
1768: -- This module validates whether or not
1769: -- a IGS_PE_PERSON has an encumbrance blocking the
1770: -- issue of an academic transcript
1771: p_message_name := null;
1772: -- validating the input parameters
1773: IF (p_person_id IS NULL OR p_effective_dt IS NULL) THEN