|
Package sb_gradapp_eligible_rules Support subprograms for the Graduation Application Eligibility Rules API (sb_gradapp_eligible). |
| Program units |
| p_register_entity |
| p_register_entity |
| p_validate |
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_seqno shbgelr.shbgelr_seqno%TYPE,
p_lmod_cde shbgelr.shbgelr_lmod_cde%TYPE,
p_user_id shbgelr.shbgelr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_levl_code shbgelr.shbgelr_levl_code%TYPE,
p_camp_code shbgelr.shbgelr_camp_code%TYPE,
p_coll_code shbgelr.shbgelr_coll_code%TYPE,
p_degc_code shbgelr.shbgelr_degc_code%TYPE,
p_program shbgelr.shbgelr_program%TYPE,
p_lfst_code shbgelr.shbgelr_lfst_code%TYPE,
p_majr_code shbgelr.shbgelr_majr_code%TYPE,
p_dept_code shbgelr.shbgelr_dept_code%TYPE,
p_term_code_matric shbgelr.shbgelr_term_code_matric%TYPE,
p_term_code_admit shbgelr.shbgelr_term_code_admit%TYPE,
p_exp_grad_from_date shbgelr.shbgelr_exp_grad_from_date%TYPE,
p_exp_grad_to_date shbgelr.shbgelr_exp_grad_to_date%TYPE,
p_term_code_grad shbgelr.shbgelr_term_code_grad%TYPE,
p_stst_code shbgelr.shbgelr_stst_code%TYPE,
p_clas_code shbgelr.shbgelr_clas_code%TYPE,
p_atts_code shbgelr.shbgelr_atts_code%TYPE,
p_chrt_code shbgelr.shbgelr_chrt_code%TYPE,
p_stdn_term_code_grad shbgelr.shbgelr_stdn_term_code_grad%TYPE,
p_stdn_grad_from_date shbgelr.shbgelr_stdn_grad_from_date%TYPE,
p_stdn_grad_to_date shbgelr.shbgelr_stdn_grad_to_date%TYPE,
p_astd_code shbgelr.shbgelr_astd_code%TYPE,
p_cast_code shbgelr.shbgelr_cast_code%TYPE,
p_dgmr_term_code_grad shbgelr.shbgelr_dgmr_term_code_grad%TYPE,
p_dgmr_grad_from_date shbgelr.shbgelr_dgmr_grad_from_date%TYPE,
p_dgmr_grad_to_date shbgelr.shbgelr_dgmr_grad_to_date%TYPE,
p_grst_code shbgelr.shbgelr_grst_code%TYPE,
p_degs_code shbgelr.shbgelr_degs_code%TYPE,
p_levl_code_gpa_calc shbgelr.shbgelr_levl_code_gpa_calc%TYPE,
p_in_progress_ind shbgelr.shbgelr_in_progress_ind%TYPE,
p_inst_hours_earned shbgelr.shbgelr_inst_hours_earned%TYPE,
p_inst_gpa_hours shbgelr.shbgelr_inst_gpa_hours%TYPE,
p_inst_gpa shbgelr.shbgelr_inst_gpa%TYPE,
p_hours_earned shbgelr.shbgelr_hours_earned%TYPE,
p_gpa_hours shbgelr.shbgelr_gpa_hours%TYPE,
p_gpa shbgelr.shbgelr_gpa%TYPE,
p_data_origin shbgelr.shbgelr_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_seqno |
One-up number to define the row. NUMBER(8) Required Key | |
| p_lmod_cde |
Module code required for eligibility for graduation application selection. VARCHAR2(1) Required | |
| p_user_id |
ID of the most recent user to create or update the row in the SHBGELR table. VARCHAR2(30) Required | |
| p_levl_code |
Level code of the curriculum. VARCHAR2(2) | |
| p_camp_code |
Campus code of the curriculum. VARCHAR2(3) | |
| p_coll_code |
College code of the curriculum. VARCHAR2(2) | |
| p_degc_code |
Degree code of the curriculum. VARCHAR2(6) | |
| p_program |
Program of the curriculum. VARCHAR2(12) | |
| p_lfst_code |
Learner field of study type code of the curriculum. VARCHAR2(15) | |
| p_majr_code |
Major code for the field of study of the curriculum. VARCHAR2(4) | |
| p_dept_code |
Department code associated with the major field of study of the curriculum. VARCHAR2(4) | |
| p_term_code_matric |
Code of the term in which the learner matriculated into the curriculum. VARCHAR2(6) | |
| p_term_code_admit |
Code of the term in which the learner was admitted to curriculum. VARCHAR2(6) | |
| p_exp_grad_from_date |
First date of the range in which the learner is expected to graduate from the curriculum. DATE | |
| p_exp_grad_to_date |
Last date of the range in which the learner is expected to graduate from the curriculum. DATE | |
| p_term_code_grad |
Code of the term in which the learner expects to graduate. VARCHAR2(6) | |
| p_stst_code |
Code of the student's status for the effective term. VARCHAR2(2) | |
| p_clas_code |
Class to which the student belongs. VARCHAR2(2) | |
| p_atts_code |
Student's general student attribute code. VARCHAR2(4) | |
| p_chrt_code |
Student's cohort code. VARCHAR2(10) | |
| p_stdn_term_code_grad |
Code of the term in which the learner expects to graduate as recorded on the student record. VARCHAR2(6) | |
| p_stdn_grad_from_date |
First date of the range of the expected graduation date on the student record. DATE | |
| p_stdn_grad_to_date |
Last date of the range of the expected graduation date on the student record. DATE | |
| p_astd_code |
Code of an academic standing override for a student for the effective term. VARCHAR2(2) | |
| p_cast_code |
Combined academic standing code for student. VARCHAR2(2) | |
| p_dgmr_term_code_grad |
Code of the term in which the learner expects to graduate as recorded on the degree record. VARCHAR2(6) | |
| p_dgmr_grad_from_date |
First date of the range of the expected graduation date on the degree record. DATE | |
| p_dgmr_grad_to_date |
Last date of the range of the expected graduation date on the degree record. DATE | |
| p_grst_code |
Graduation status code. VARCHAR2(3) | |
| p_degs_code |
Status code of the student's degree, for example sought, awarded, etc. VARCHAR2(2) | |
| p_levl_code_gpa_calc |
Level that the eligibility rule will use to calculate GPA information. VARCHAR2(2) | |
| p_in_progress_ind |
Indicator for whether in-progress courses should be considered for the institutional and overall calculations. VARCHAR2(1) | |
| p_inst_hours_earned |
Minimum institutional earned hours that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_inst_gpa_hours |
Minimum institutional GPA hours that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_inst_gpa |
Minimum overall GPA that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_hours_earned |
Minimum overall earned hours that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_gpa_hours |
Minimum overall GPA hours that the learner must meet in order for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_gpa |
Minimum overall GPA that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| 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_seqno shbgelr.shbgelr_seqno%TYPE,
p_lmod_cde shbgelr.shbgelr_lmod_cde%TYPE,
p_user_id shbgelr.shbgelr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_levl_code shbgelr.shbgelr_levl_code%TYPE DEFAULT NULL,
p_camp_code shbgelr.shbgelr_camp_code%TYPE DEFAULT NULL,
p_coll_code shbgelr.shbgelr_coll_code%TYPE DEFAULT NULL,
p_degc_code shbgelr.shbgelr_degc_code%TYPE DEFAULT NULL,
p_program shbgelr.shbgelr_program%TYPE DEFAULT NULL,
p_lfst_code shbgelr.shbgelr_lfst_code%TYPE DEFAULT NULL,
p_majr_code shbgelr.shbgelr_majr_code%TYPE DEFAULT NULL,
p_dept_code shbgelr.shbgelr_dept_code%TYPE DEFAULT NULL,
p_term_code_matric shbgelr.shbgelr_term_code_matric%TYPE DEFAULT NULL,
p_term_code_admit shbgelr.shbgelr_term_code_admit%TYPE DEFAULT NULL,
p_exp_grad_from_date shbgelr.shbgelr_exp_grad_from_date%TYPE DEFAULT NULL,
p_exp_grad_to_date shbgelr.shbgelr_exp_grad_to_date%TYPE DEFAULT NULL,
p_term_code_grad shbgelr.shbgelr_term_code_grad%TYPE DEFAULT NULL,
p_stst_code shbgelr.shbgelr_stst_code%TYPE DEFAULT NULL,
p_clas_code shbgelr.shbgelr_clas_code%TYPE DEFAULT NULL,
p_atts_code shbgelr.shbgelr_atts_code%TYPE DEFAULT NULL,
p_chrt_code shbgelr.shbgelr_chrt_code%TYPE DEFAULT NULL,
p_stdn_term_code_grad shbgelr.shbgelr_stdn_term_code_grad%TYPE DEFAULT NULL,
p_stdn_grad_from_date shbgelr.shbgelr_stdn_grad_from_date%TYPE DEFAULT NULL,
p_stdn_grad_to_date shbgelr.shbgelr_stdn_grad_to_date%TYPE DEFAULT NULL,
p_astd_code shbgelr.shbgelr_astd_code%TYPE DEFAULT NULL,
p_cast_code shbgelr.shbgelr_cast_code%TYPE DEFAULT NULL,
p_dgmr_term_code_grad shbgelr.shbgelr_dgmr_term_code_grad%TYPE DEFAULT NULL,
p_dgmr_grad_from_date shbgelr.shbgelr_dgmr_grad_from_date%TYPE DEFAULT NULL,
p_dgmr_grad_to_date shbgelr.shbgelr_dgmr_grad_to_date%TYPE DEFAULT NULL,
p_grst_code shbgelr.shbgelr_grst_code%TYPE DEFAULT NULL,
p_degs_code shbgelr.shbgelr_degs_code%TYPE DEFAULT NULL,
p_levl_code_gpa_calc shbgelr.shbgelr_levl_code_gpa_calc%TYPE DEFAULT NULL,
p_in_progress_ind shbgelr.shbgelr_in_progress_ind%TYPE DEFAULT NULL,
p_inst_hours_earned shbgelr.shbgelr_inst_hours_earned%TYPE DEFAULT NULL,
p_inst_gpa_hours shbgelr.shbgelr_inst_gpa_hours%TYPE DEFAULT NULL,
p_inst_gpa shbgelr.shbgelr_inst_gpa%TYPE DEFAULT NULL,
p_hours_earned shbgelr.shbgelr_hours_earned%TYPE DEFAULT NULL,
p_gpa_hours shbgelr.shbgelr_gpa_hours%TYPE DEFAULT NULL,
p_gpa shbgelr.shbgelr_gpa%TYPE DEFAULT NULL,
p_data_origin shbgelr.shbgelr_data_origin%TYPE DEFAULT NULL)
Validates all data in the record.
| Parameters |
| p_seqno |
One-up number to define the row. NUMBER(8) Required Key | |
| p_lmod_cde |
Module code required for eligibility for graduation application selection. VARCHAR2(1) Required | |
| p_user_id |
ID of the most recent user to create or update the row in the SHBGELR table. VARCHAR2(30) Required | |
| p_levl_code |
Level code of the curriculum. VARCHAR2(2) | |
| p_camp_code |
Campus code of the curriculum. VARCHAR2(3) | |
| p_coll_code |
College code of the curriculum. VARCHAR2(2) | |
| p_degc_code |
Degree code of the curriculum. VARCHAR2(6) | |
| p_program |
Program of the curriculum. VARCHAR2(12) | |
| p_lfst_code |
Learner field of study type code of the curriculum. VARCHAR2(15) | |
| p_majr_code |
Major code for the field of study of the curriculum. VARCHAR2(4) | |
| p_dept_code |
Department code associated with the major field of study of the curriculum. VARCHAR2(4) | |
| p_term_code_matric |
Code of the term in which the learner matriculated into the curriculum. VARCHAR2(6) | |
| p_term_code_admit |
Code of the term in which the learner was admitted to curriculum. VARCHAR2(6) | |
| p_exp_grad_from_date |
First date of the range in which the learner is expected to graduate from the curriculum. DATE | |
| p_exp_grad_to_date |
Last date of the range in which the learner is expected to graduate from the curriculum. DATE | |
| p_term_code_grad |
Code of the term in which the learner expects to graduate. VARCHAR2(6) | |
| p_stst_code |
Code of the student's status for the effective term. VARCHAR2(2) | |
| p_clas_code |
Class to which the student belongs. VARCHAR2(2) | |
| p_atts_code |
Student's general student attribute code. VARCHAR2(4) | |
| p_chrt_code |
Student's cohort code. VARCHAR2(10) | |
| p_stdn_term_code_grad |
Code of the term in which the learner expects to graduate as recorded on the student record. VARCHAR2(6) | |
| p_stdn_grad_from_date |
First date of the range of the expected graduation date on the student record. DATE | |
| p_stdn_grad_to_date |
Last date of the range of the expected graduation date on the student record. DATE | |
| p_astd_code |
Code of an academic standing override for a student for the effective term. VARCHAR2(2) | |
| p_cast_code |
Combined academic standing code for student. VARCHAR2(2) | |
| p_dgmr_term_code_grad |
Code of the term in which the learner expects to graduate as recorded on the degree record. VARCHAR2(6) | |
| p_dgmr_grad_from_date |
First date of the range of the expected graduation date on the degree record. DATE | |
| p_dgmr_grad_to_date |
Last date of the range of the expected graduation date on the degree record. DATE | |
| p_grst_code |
Graduation status code. VARCHAR2(3) | |
| p_degs_code |
Status code of the student's degree, for example sought, awarded, etc. VARCHAR2(2) | |
| p_levl_code_gpa_calc |
Level that the eligibility rule will use to calculate GPA information. VARCHAR2(2) | |
| p_in_progress_ind |
Indicator for whether in-progress courses should be considered for the institutional and overall calculations. VARCHAR2(1) | |
| p_inst_hours_earned |
Minimum institutional earned hours that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_inst_gpa_hours |
Minimum institutional GPA hours that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_inst_gpa |
Minimum overall GPA that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_hours_earned |
Minimum overall earned hours that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_gpa_hours |
Minimum overall GPA hours that the learner must meet in order for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_gpa |
Minimum overall GPA that the learner must meet for the eligibility rule to be considered matching. NUMBER(11,3) | |
| p_data_origin |
Value of the source system that inserted or updated the row. VARCHAR2(30) |