BANINST1@S10B80

index

Package sb_feedback_session_rules

Support subprograms for the FEEDBACK_SESSION (sb_feedback_session).

Program units
p_validate   Validates all data in the record.

p_validate 

Procedure p_validate(p_surrogate_id         sfbffsc.sfbffsc_surrogate_id%TYPE,
                     p_term_code            sfbffsc.sfbffsc_term_code%TYPE,
                     p_description          sfbffsc.sfbffsc_description%TYPE,
                     p_suspend_feedback_ind sfbffsc.sfbffsc_suspend_feedback_ind%TYPE,
                     p_start_date           sfbffsc.sfbffsc_start_date%TYPE,
                     p_end_date             sfbffsc.sfbffsc_end_date%TYPE,
                     p_add_comments_flag    sfbffsc.sfbffsc_add_comments_flag%TYPE,
                     p_add_recommends_flag  sfbffsc.sfbffsc_add_recommends_flag%TYPE,
                     p_data_origin          sfbffsc.sfbffsc_data_origin%TYPE,
                     p_user_id              sfbffsc.sfbffsc_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all data in the record.

Parameters
p_surrogate_id   Surrogate ID for sfbffsc. NUMBER(19) Required Key
p_term_code   Term code for which faculty feedback is being requested. VARCHAR2(6) Required
p_description   Feedback session description. VARCHAR2(30) Required
p_suspend_feedback_ind   Y indicates this session has been suspended for feedback. VARCHAR2(1) Required
p_start_date   The date within a term from which faculty can start providing feedback. DATE Required
p_end_date   The date after which no more feedback can be provided. DATE Required
p_add_comments_flag   Y indicates faculty can enter free-form comments while choosing concerns. VARCHAR2(1) Required
p_add_recommends_flag   Y indicates faculty can provide recommendations to mitigate the concerns. VARCHAR2(1) 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