BANINST1@S10B80

index

Package sb_estimated_grades_rules

Support subprograms for the ESTIMATED_GRADES (sb_estimated_grades).

Program units
p_validate   Validates all data in the record.

p_validate 

Procedure p_validate(p_surrogate_id sfrffst.sfrffst_surrogate_id%TYPE,
                     p_sfbffsc_id   sfrffst.sfrffst_sfbffsc_id%TYPE,
                     p_student_pidm sfrffst.sfrffst_student_pidm%TYPE,
                     p_crn          sfrffst.sfrffst_crn%TYPE,
                     p_faculty_pidm sfrffst.sfrffst_faculty_pidm%TYPE DEFAULT NULL,
                     p_status_cde   sfrffst.sfrffst_status_cde%TYPE,
                     p_grde_code    sfrffst.sfrffst_grde_code%TYPE DEFAULT NULL,
                     p_comments     sfrffst.sfrffst_comments%TYPE DEFAULT NULL,
                     p_version      sfrffst.sfrffst_version%TYPE,
                     p_data_origin  sfrffst.sfrffst_data_origin%TYPE,
                     p_user_id      sfrffst.sfrffst_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all data in the record.

Parameters
p_surrogate_id   Surrogate ID for sfrffst. NUMBER(19) Required Key
p_sfbffsc_id   Surrogate ID from the session control table for which this feedback is being entered. NUMBER(19) Required
p_student_pidm   The pidm of the student about whom the feedback is entered. NUMBER(8) Required
p_crn   The course number of the course the student has been registered. VARCHAR2(5) Required
p_faculty_pidm   The pidm of the faculty person entering the feedback. NUMBER(8)
p_status_cde   (M)onitored, (O)ptional, (C)ompleted. Completed is per CRN/Faculty. VARCHAR2(1) Required
p_grde_code   VARCHAR2(6)
p_comments   Free-form overall comments entered by the faculty. VARCHAR2(4000)
p_version   Optimistic lock token for sfrffst. NUMBER(19) Required
p_data_origin   This system maintained field specifies the origin of the data. VARCHAR2(30) Required
p_user_id   Oracle User who created or updated the record. VARCHAR2(30) Required