index

Package sp_grading_rules

NOTE: Please be advised that this API is currently intended to only support internal operations.
To ensure data integrity, this API is not supported when called by external applications or interfaces to manipulate data. The recommendation for external applications is to use message level integration to integrate with this entitity in Banner.

This package provides the support subprograms for the Grading API (sp_grading)

Program units
p_validate   Validates all the data in the record.

p_validate 

Procedure p_validate(p_term_code             sfrstcr.sfrstcr_term_code%TYPE,
                     p_student_pidm          sfrstcr.sfrstcr_pidm%TYPE,
                     p_faculty_pidm          sfrstcr.sfrstcr_pidm%TYPE,
                     p_crn                   sfrstcr.sfrstcr_crn%TYPE,
                     p_grade_type            VARCHAR2,
                     p_grade_assigned        sfrstcr.sfrstcr_grde_code%TYPE DEFAULT NULL,
                     p_grde_code_incmp_final sfrstcr.sfrstcr_grde_code_incmp_final%TYPE DEFAULT NULL,
                     p_incomplete_ext_date   sfrstcr.sfrstcr_incomplete_ext_date%TYPE DEFAULT NULL)

Validates all the data in the record.
Validates the parameter values.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_student_pidm   Internal Identification Number of the student. NUMBER(8) Required Key
p_faculty_pidm   Internal Identification Number of the faculty member. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key
p_grde_type   Indicates whether the provided grade is a midterm or final grade. VARCHAR2(2) Required Key
p_grde_assigned   Actual grade value assigned for the student by the faculty member. VARCHAR2(6) Required Key
p_grde_code_incmp_final   Actual Grade code to identify default final grade for incomplete coursework. VARCHAR2(6)
p_incomplete_ext_date   Date to identify when the default final grade will be applied if coursework is incomplete. DATE