|
Package gb_prior_college_rules Support subprograms for the PRIOR COLLEGE API (gb_prior_college). |
| Program units |
| f_check_stvsbgi_type | This function checks to make sure the valid source background institution code has a STVSBGI type indicator of C for college. |
| f_check_stvsbgi_admr | This function checks to make sure the admission checklist request item code is valid for the corresponding prior college code. |
| f_admr_code_in_use | This function implements the rule that the admission checklist request item code for a SORPCOL record must be a valid code and cannot be used in other SORPCOL records for this PIDM. |
| p_finaid_recon | If the Financial Aid product is not installed, adds or updates the SORFADR row for the person. |
| 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 the data in the record. |
f_check_stvsbgi_type
FUNCTION f_check_stvsbgi_type(p_sbgi_code stvsbgi.stvsbgi_code%TYPE) RETURN VARCHAR2
This function checks to make sure the valid source background institution code has a STVSBGI type indicator of C for college.
Return Y/N indicator for existence of a sbgi code with an stvsbgi type ind of C in the table.
| Parameters |
| p_sbgi_code |
The prior college code of the prospect or applicant. VARCHAR2(6) Required Key |
f_check_stvsbgi_admr
FUNCTION f_check_stvsbgi_admr(p_sbgi_code stvsbgi.stvsbgi_code%TYPE,
p_admr_code stvsbgi.stvsbgi_admr_code%TYPE)
RETURN VARCHAR2
This function checks to make sure the admission checklist request item code is valid for the corresponding prior college code.
Return Y/N indicator for existence of an sbgi code with a corresponding admr code in the stvsbgi table.
| Parameters |
| p_pidm |
Internal identification number of the student. NUMBER(8) Required Key | |
| p_admr_code |
The admission checklist request item code which may be cross referenced, i.e., receipt of transcript here updates admissions checklist received date. VARCHAR2(4) |
f_admr_code_in_use
FUNCTION f_admr_code_in_use(p_pidm sorpcol.sorpcol_pidm%TYPE,
p_sbgi_code sorpcol.sorpcol_sbgi_code%TYPE,
p_admr_code sorpcol.sorpcol_admr_code%TYPE)
RETURN BOOLEAN
This function implements the rule that the admission checklist request item code for a SORPCOL record must be a valid code and cannot be used in other SORPCOL records for this PIDM.
| Parameters |
| p_pidm |
Internal identification number of the student. NUMBER(8) Required Key | |
| p_sbgi_code |
The prior college code of the prospect or applicant. VARCHAR2(6) Required Key | |
| p_admr_code |
The admission checklist request item code which may be cross referenced, i.e., receipt of transcript here updates admissions checklist received date. VARCHAR2(4) |
p_finaid_recon
PROCEDURE p_finaid_recon(p_pidm spriden.spriden_pidm%TYPE)
If the Financial Aid product is not installed, adds or updates the SORFADR row for the person.
Sorfadr is a common table.
| Parameters |
| p_pidm |
Internal identification number of the student. NUMBER(8) Required Key |
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, or 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 sorpcol.sorpcol_pidm%TYPE,
p_sbgi_code sorpcol.sorpcol_sbgi_code%TYPE,
p_trans_recv_date sorpcol.sorpcol_trans_recv_date%TYPE,
p_trans_rev_date sorpcol.sorpcol_trans_rev_date%TYPE,
p_official_trans sorpcol.sorpcol_official_trans%TYPE,
p_admr_code sorpcol.sorpcol_admr_code%TYPE,
p_data_origin sorpcol.sorpcol_data_origin%TYPE,
p_user_id sorpcol.sorpcol_user_id%TYPE DEFAULT gb_common.f_sct_user,
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 the parameters.
| Parameters |
| p_operation_type |
Type of DML operation: create, update, or delete. NUMBER Required | |
| p_pidm |
Internal identification number of the student. NUMBER(8) Required Key | |
| p_sbgi_code |
The prior college code of the prospect or applicant. VARCHAR2(6) Required Key | |
| p_trans_recv_date |
The date an academic transcript was received from the prior college. DATE | |
| p_trans_rev_date |
The date an academic transcript was reviewed by the institution. DATE | |
| p_official_trans |
Designates the transcript received was an official transcript. Y denotes yes. VARCHAR2(1) | |
| p_admr_code |
The admission checklist request item code which may be cross referenced, i.e., receipt of transcript here updates admissions checklist received date. VARCHAR2(4) | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) | |
| p_user_id |
The Oracle ID of the user who changed the record. VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
PROCEDURE p_validate(p_pidm sorpcol.sorpcol_pidm%TYPE,
p_sbgi_code sorpcol.sorpcol_sbgi_code%TYPE,
p_trans_recv_date sorpcol.sorpcol_trans_recv_date%TYPE DEFAULT NULL,
p_trans_rev_date sorpcol.sorpcol_trans_rev_date%TYPE DEFAULT NULL,
p_official_trans sorpcol.sorpcol_official_trans%TYPE DEFAULT NULL,
p_admr_code sorpcol.sorpcol_admr_code%TYPE DEFAULT NULL,
p_data_origin sorpcol.sorpcol_data_origin%TYPE DEFAULT NULL,
p_user_id sorpcol.sorpcol_user_id%TYPE DEFAULT gb_common.f_sct_user)
Validates all the data in the record.
Internal identification number and source background institution code are required as the primary key for each record. If a value is passed for prior college official transcript, the value must be a Y or null.
| Parameters |
| p_pidm |
Internal identification number of the student. NUMBER(8) Required Key | |
| p_sbgi_code |
The prior college code of the prospect or applicant. VARCHAR2(6) Required Key | |
| p_trans_recv_date |
The date an academic transcript was received from the prior college. DATE | |
| p_trans_rev_date |
The date an academic transcript was reviewed by the institution. DATE | |
| p_official_trans |
Designates the transcript received was an official transcript. Y denotes yes. VARCHAR2(1) | |
| p_admr_code |
The admission checklist request item code which may be cross referenced, i.e., receipt of transcript here updates admissions checklist received date. VARCHAR2(4) | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) | |
| p_user_id |
The Oracle ID of the user who changed the record. VARCHAR2(30) |