[Home] [Help]
72: --
73: -- Function to check whether given Program Stage is completed by the given student.
74: --
75: FUNCTION enrp_val_ps_stage (
76: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
77: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
78: p_version_number NUMBER,
79: p_preference_code VARCHAR2
80: ) RETURN BOOLEAN;
73: -- Function to check whether given Program Stage is completed by the given student.
74: --
75: FUNCTION enrp_val_ps_stage (
76: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
77: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
78: p_version_number NUMBER,
79: p_preference_code VARCHAR2
80: ) RETURN BOOLEAN;
81:
83: -- Added as Part of ENCR013 DLD
84: -- This Function returns Approved Credit Points if exists for student in override table
85: --
86: FUNCTION enrp_get_appr_cr_pt(
87: p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
88: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE
89: ) RETURN NUMBER;
90:
91: --
84: -- This Function returns Approved Credit Points if exists for student in override table
85: --
86: FUNCTION enrp_get_appr_cr_pt(
87: p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
88: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE
89: ) RETURN NUMBER;
90:
91: --
92: -- Added as Part of ENCR015 DLD(Enh Bug : 2158654)