|
|
Package sb_athletic_competition_rules Support subprograms for the Athletic Competition API (sb_athletic_competition). |
| 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 sgrathc.sgrathc_pidm%TYPE,
p_term_code sgrathc.sgrathc_term_code%TYPE,
p_actc_code sgrathc.sgrathc_actc_code%TYPE,
p_seq_no sgrathc.sgrathc_seq_no%TYPE,
p_current_ind sgrathc.sgrathc_current_ind%TYPE,
p_seasons_available sgrathc.sgrathc_seasons_available%TYPE,
p_season_used_ind sgrathc.sgrathc_season_used_ind%TYPE,
p_user_id sgrathc.sgrathc_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_activity_date sgrathc.sgrathc_create_activity_date%TYPE,
p_create_user_id sgrathc.sgrathc_create_user_id%TYPE,
p_sare_code sgrathc.sgrathc_sare_code%TYPE,
p_elig_begin_term_code sgrathc.sgrathc_elig_begin_term_code%TYPE,
p_elig_end_term_code sgrathc.sgrathc_elig_end_term_code%TYPE,
p_data_origin sgrathc.sgrathc_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 competition information belongs. NUMBER(8) Required Key | |
| p_term_code |
Term code for the athletic competition. VARCHAR2(6) Required Key | |
| p_actc_code |
Code for the sport activity. VARCHAR2(8) Required Key | |
| p_seq_no |
Sequence number of the competition record for the athlete for the sport. NUMBER(8) Required Key | |
| p_current_ind |
Indicator for whether the record is the current record (Y) or a previous record (N). VARCHAR2(1) Required | |
| p_seasons_available |
Number of seasons of competition available. NUMBER(2) Required | |
| p_season_used_ind |
Indicator that athlete has used a season of competition in this term. VARCHAR2(1) Required | |
| p_user_id |
ID of the user who created or updated the row in the SGRATHC table. VARCHAR2(30) Required | |
| p_create_activity_date |
Date that the information for the row was inserted in the SGRATHC table. DATE | |
| p_create_user_id |
ID of the user who created the row in the SGRATHC table. VARCHAR2(30) | |
| p_sare_code |
Reason code for a change to the number of seasons available. VARCHAR2(4) | |
| p_elig_begin_term_code |
Starting eligibility term code for the athletic competition. VARCHAR2(6) | |
| p_elig_end_term_code |
Ending eligibility term code for the athletic competition. VARCHAR2(6) | |
| p_data_origin |
Value of the source system that inserted the row. VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
PROCEDURE p_validate(p_pidm sgrathc.sgrathc_pidm%TYPE,
p_term_code sgrathc.sgrathc_term_code%TYPE,
p_actc_code sgrathc.sgrathc_actc_code%TYPE,
p_seq_no sgrathc.sgrathc_seq_no%TYPE,
p_current_ind sgrathc.sgrathc_current_ind%TYPE,
p_seasons_available sgrathc.sgrathc_seasons_available%TYPE,
p_season_used_ind sgrathc.sgrathc_season_used_ind%TYPE,
p_user_id sgrathc.sgrathc_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_activity_date sgrathc.sgrathc_create_activity_date%TYPE,
p_create_user_id sgrathc.sgrathc_create_user_id%TYPE,
p_sare_code sgrathc.sgrathc_sare_code%TYPE DEFAULT NULL,
p_elig_begin_term_code sgrathc.sgrathc_elig_begin_term_code%TYPE DEFAULT NULL,
p_elig_end_term_code sgrathc.sgrathc_elig_end_term_code%TYPE DEFAULT NULL,
p_data_origin sgrathc.sgrathc_data_origin%TYPE DEFAULT NULL);
Validates all data in the record.
| Parameters |
| p_pidm |
Internal identification number (PIDM) of the athlete for which the competition information belongs. NUMBER(8) Required Key | |
| p_term_code |
Term code for the athletic competition. VARCHAR2(6) Required Key | |
| p_actc_code |
Code for the sport activity. VARCHAR2(8) Required Key | |
| p_seq_no |
Sequence number of the competition record for the athlete for the sport. NUMBER(8) Required Key | |
| p_current_ind |
Indicator for whether the record is the current record (Y) or a previous record (N). VARCHAR2(1) Required | |
| p_seasons_available |
Number of seasons of competition available. NUMBER(2) Required | |
| p_season_used_ind |
Indicator that athlete has used a season of competition in this term. VARCHAR2(1) Required | |
| p_user_id |
ID of the user who created or updated the row in the SGRATHC table. VARCHAR2(30) Required | |
| p_create_activity_date |
Date that the information for the row was inserted in the SGRATHC table. DATE | |
| p_create_user_id |
ID of the user who created the row in the SGRATHC table. VARCHAR2(30) | |
| p_sare_code |
Reason code for a change to the number of seasons available. VARCHAR2(4) | |
| p_elig_begin_term_code |
Starting eligibility term code for the athletic competition. VARCHAR2(6) | |
| p_elig_end_term_code |
Ending eligibility term code for the athletic competition. VARCHAR2(6) | |
| p_data_origin |
Value of the source system that inserted the row. VARCHAR2(30) |