BANINST1@S10B80

index

Package sb_faculty_feedback_rules

Support subprograms for the FACULTY_FEEDBACK (sb_faculty_feedback).

Program units
p_validate   Validates all data in the record.

p_validate 

Procedure p_validate(p_surrogate_id sfrffbk.sfrffbk_surrogate_id%TYPE,
                     p_sfrffst_id   sfrffbk.sfrffbk_sfrffst_id%TYPE,
                     p_stvffva_id   sfrffbk.sfrffbk_stvffva_id%TYPE,
                     p_version      sfrffbk.sfrffbk_version%TYPE,
                     p_data_origin  sfrffbk.sfrffbk_data_origin%TYPE,
                     p_user_id      sfrffbk.sfrffbk_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all data in the record.

Parameters
p_surrogate_id   Surrogate ID for sfrffbk. NUMBER(19) Required Key
p_sfrffst_id   Surrogate ID from the required students sfrffst table for which this feedback is being entered. NUMBER(19) Required
p_stvffva_id   The surrogate id of the actual issue or recommendation that the faculty has about the student. NUMBER(19) Required
p_version   Optimistic lock token for sfrffbk. 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