BANINST1@S10B80

index

Package sb_feedback_codes_rules

Support subprograms for the FEEDBACK_ISSUES (sb_feedback_issues).

Program units
p_validate   Validates all data in the record.

p_validate 

Procedure p_validate(p_surrogate_id stvffva.stvffva_surrogate_id%TYPE,
                     p_code         stvffva.stvffva_code%TYPE,
                     p_desc         stvffva.stvffva_desc%TYPE,
                     p_type         stvffva.stvffva_type%TYPE,
                     p_active_ind   stvffva.stvffva_active_ind%TYPE,
                     p_version      stvffva.stvffva_version%TYPE,
                     p_data_origin  stvffva.stvffva_data_origin%TYPE,
                     p_user_id      stvffva.stvffva_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all data in the record.

Parameters
p_surrogate_id   Surrogate ID for STVFFVA. NUMBER(19) Required Key
p_code   VARCHAR2(30) Required
p_desc   Faculty Issue or Recommendation Name. VARCHAR2(255) Required
p_type   ISSUE or RECOMMENDATION. VARCHAR2(20) Required
p_active_ind   Y indicates the value is active, N indicates not active and will not be available for selection. VARCHAR2(1) Required
p_version   Optimistic lock token for STVFFVA. 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