|
|
Package sb_athletic_transfer_rules Support subprograms for the Athletic Transfer API (sb_athletic_transfer). |
| 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 sgratht.sgratht_pidm%TYPE,
p_trans_eligible_ind sgratht.sgratht_trans_eligible_ind%TYPE,
p_res_req_ind sgratht.sgratht_res_req_ind%TYPE,
p_met_credit_yr_ind sgratht.sgratht_met_credit_yr_ind%TYPE,
p_user_id sgratht.sgratht_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_trans_quality_points sgratht.sgratht_trans_quality_points%TYPE,
p_trans_gpa sgratht.sgratht_trans_gpa%TYPE,
p_trans_terms_attended sgratht.sgratht_trans_terms_attended%TYPE,
p_trans_hours_attempted sgratht.sgratht_trans_hours_attempted%TYPE,
p_trans_hours_earned sgratht.sgratht_trans_hours_earned%TYPE,
p_trans_accept_date sgratht.sgratht_trans_accept_date%TYPE,
p_satr_code sgratht.sgratht_satr_code%TYPE,
p_sarx_code sgratht.sgratht_sarx_code%TYPE,
p_data_origin sgratht.sgratht_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 transfer information belongs. NUMBER(8) Required Key | |
| p_trans_eligible_ind |
Indicator for whether the athlete is eligible to transfer. VARCHAR2(1) Required | |
| p_res_req_ind |
Indicator for whether the athlete meets the residency requirement. VARCHAR2(1) Required | |
| p_met_credit_yr_ind |
Indicator for whether the athlete met the academic credit year requirement. VARCHAR2(1) Required | |
| p_user_id |
ID of the most recent user to create or update the row in the SGRATHT table. VARCHAR2(30) Required | |
| p_trans_quality_points |
Transfer quality points for the athlete. NUMBER(15,6) | |
| p_trans_gpa |
Transfer GPA for the athlete. NUMBER(21,9) | |
| p_trans_terms_attended |
Number of transfer terms attended. NUMBER(4) | |
| p_trans_hours_attempted |
Number of transfer hours attempted. NUMBER(9,3) | |
| p_trans_hours_earned |
Number of transfer hours earned. NUMBER(9,3) | |
| p_trans_accept_date |
Date the transfer was accepted. DATE | |
| p_satr_code |
Transfer status of the athlete. VARCHAR2(4) | |
| p_sarx_code |
Residency exception of the athlete. VARCHAR2(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 sgratht.sgratht_pidm%TYPE,
p_trans_eligible_ind sgratht.sgratht_trans_eligible_ind%TYPE,
p_res_req_ind sgratht.sgratht_res_req_ind%TYPE,
p_met_credit_yr_ind sgratht.sgratht_met_credit_yr_ind%TYPE,
p_user_id sgratht.sgratht_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_trans_quality_points sgratht.sgratht_trans_quality_points%TYPE DEFAULT NULL,
p_trans_gpa sgratht.sgratht_trans_gpa%TYPE DEFAULT NULL,
p_trans_terms_attended sgratht.sgratht_trans_terms_attended%TYPE DEFAULT NULL,
p_trans_hours_attempted sgratht.sgratht_trans_hours_attempted%TYPE DEFAULT NULL,
p_trans_hours_earned sgratht.sgratht_trans_hours_earned%TYPE DEFAULT NULL,
p_trans_accept_date sgratht.sgratht_trans_accept_date%TYPE DEFAULT NULL,
p_satr_code sgratht.sgratht_satr_code%TYPE DEFAULT NULL,
p_sarx_code sgratht.sgratht_sarx_code%TYPE DEFAULT NULL,
p_data_origin sgratht.sgratht_data_origin%TYPE DEFAULT NULL);
Validates all data in the record.
| Parameters |
| p_pidm |
Internal identification number (PIDM) of the athlete for which the transfer information belongs. NUMBER(8) Required Key | |
| p_trans_eligible_ind |
Indicator for whether the athlete is eligible to transfer. VARCHAR2(1) Required | |
| p_res_req_ind |
Indicator for whether the athlete meets the residency requirement. VARCHAR2(1) Required | |
| p_met_credit_yr_ind |
Indicator for whether the athlete met the academic credit year requirement. VARCHAR2(1) Required | |
| p_user_id |
ID of the most recent user to create or update the row in the SGRATHT table. VARCHAR2(30) Required | |
| p_trans_quality_points |
Transfer quality points for the athlete. NUMBER(15,6) | |
| p_trans_gpa |
Transfer GPA for the athlete. NUMBER(21,9) | |
| p_trans_terms_attended |
Number of transfer terms attended. NUMBER(4) | |
| p_trans_hours_attempted |
Number of transfer hours attempted. NUMBER(9,3) | |
| p_trans_hours_earned |
Number of transfer hours earned. NUMBER(9,3) | |
| p_trans_accept_date |
Date the transfer was accepted. DATE | |
| p_satr_code |
Transfer status of the athlete. VARCHAR2(4) | |
| p_sarx_code |
Residency exception of the athlete. VARCHAR2(4) | |
| p_data_origin |
Value of the source system that inserted or updated the row. VARCHAR2(30) |