index

Package sb_athletic_eligibility_rules

Support subprograms for the Athletic Eligibility API (sb_athletic_eligibility).


Program units
p_register_entity   Registers the attribute value pairs to the message cache for delete operations.
p_register_entity   Registers the attribute/value pairs to the message cache for create and update operations.
p_validate   Validates all data in the record.


p_register_entity

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id gb_common.internal_record_id_type);

Registers the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only for delete operations.

Parameters
p_operation_type   Type of DML operation: create, update, delete. NUMBER Required
p_internal_record_id   Database ROWID VARCHAR2(18) required


p_register_entity

PROCEDURE p_register_entity(p_operation_type      NUMBER,
                            p_pidm                sgrathe.sgrathe_pidm%TYPE,
                            p_user_id             sgrathe.sgrathe_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_recruit_ind         sgrathe.sgrathe_recruit_ind%TYPE,
                            p_attend_from_date    sgrathe.sgrathe_attend_from_date%TYPE,
                            p_initial_enroll_date sgrathe.sgrathe_initial_enroll_date%TYPE,
                            p_total_terms_attend  sgrathe.sgrathe_total_terms_attend%TYPE,
                            p_data_origin         sgrathe.sgrathe_data_origin%TYPE,
                            p_internal_record_id  gb_common.internal_record_id_type);

Registers the attribute/value pairs to the message cache for create and update operations.
 
This signature registers all parameters.

Parameters
p_operation_type   Type of DML operation: create, update, delete. NUMBER Required
p_pidm   Internal identification number (PIDM) of the athlete for which the eligibility information belongs. NUMBER(8) Required Key
p_user_id   ID of the most recent user to create or update the row in the SGRATHE table. VARCHAR2(30) Required
p_recruit_ind   Indicator for whether the athlete was recruited. VARCHAR2(1) Required
p_attend_from_date   Date the athlete first attended an institution. DATE
p_initial_enroll_date   Date the athlete first enrolled at this institution. DATE
p_total_terms_attend   Number of terms the athlete has attended. NUMBER(4)
p_data_origin   Value of the source system that inserted or updated the row. VARCHAR2(30)
p_internal_record_id   Database ROWID VARCHAR2(18) required


p_validate

PROCEDURE p_validate(p_pidm                sgrathe.sgrathe_pidm%TYPE,
                     p_user_id             sgrathe.sgrathe_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_recruit_ind         sgrathe.sgrathe_recruit_ind%TYPE,
                     p_attend_from_date    sgrathe.sgrathe_attend_from_date%TYPE DEFAULT NULL,
                     p_initial_enroll_date sgrathe.sgrathe_initial_enroll_date%TYPE DEFAULT NULL,
                     p_total_terms_attend  sgrathe.sgrathe_total_terms_attend%TYPE DEFAULT NULL,
                     p_data_origin         sgrathe.sgrathe_data_origin%TYPE DEFAULT NULL);

Validates all data in the record.

Parameters
p_pidm   Internal identification number (PIDM) of the athlete for which the eligibility information belongs. NUMBER(8) Required Key
p_user_id   ID of the most recent user to create or update the row in the SGRATHE table. VARCHAR2(30) Required
p_recruit_ind   Indicator for whether the athlete was recruited. VARCHAR2(1) Required
p_attend_from_date   Date the athlete first attended an institution. DATE
p_initial_enroll_date   Date the athlete first enrolled at this institution. DATE
p_total_terms_attend   Number of terms the athlete has attended. NUMBER(4)
p_data_origin   Value of the source system that inserted or updated the row. VARCHAR2(30)