|
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) |