|
Package sb_scp_ruletimestat_lvl_rules Support subprograms for the SCP_RULETIMESTAT_LVL (sb_scp_ruletimestat_lvl). |
| 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_tmst_code sfrstsl.sfrstsl_tmst_code%TYPE,
p_scps_code_eff sfrstsl.sfrstsl_scps_code_eff%TYPE,
p_camp_code sfrstsl.sfrstsl_camp_code%TYPE,
p_levl_code sfrstsl.sfrstsl_levl_code%TYPE,
p_coll_code sfrstsl.sfrstsl_coll_code%TYPE,
p_majr_code sfrstsl.sfrstsl_majr_code%TYPE,
p_styp_code sfrstsl.sfrstsl_styp_code%TYPE,
p_degc_code sfrstsl.sfrstsl_degc_code%TYPE,
p_levl_code_crse sfrstsl.sfrstsl_levl_code_crse%TYPE,
p_min_credits sfrstsl.sfrstsl_min_credits%TYPE,
p_max_credits sfrstsl.sfrstsl_max_credits%TYPE,
p_tax_ind sfrstsl.sfrstsl_tax_ind%TYPE,
p_numb_credits sfrstsl.sfrstsl_numb_credits%TYPE,
p_numb_courses sfrstsl.sfrstsl_numb_courses%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_tmst_code |
Time Status Code; Valid values are in the STVTMST table. VARCHAR2(8) Required Key | |
| p_scps_code_eff |
The effective student centric period for the time status rule. VARCHAR2(24) Required Key | |
| p_camp_code |
The campus code; valid values are in the STVCAMP table. VARCHAR2(12) Key | |
| p_levl_code |
The level code; valid values arein the STVLEVL table. VARCHAR2(8) Key | |
| p_coll_code |
The college code; valid values are in the STVCOLL table. VARCHAR2(8) Key | |
| p_majr_code |
The major code; valid values arein the STVMAJR table. VARCHAR2(16) Key | |
| p_styp_code |
The student type code; valid values are in the STVSTYP table. VARCHAR2(4) Key | |
| p_degc_code |
The degree code; valid values are in the STVDEGC table. VARCHAR2(24) Key | |
| p_levl_code_crse |
The level of the courses to be included in the calculation of hours associated with the time status rule. VARCHAR2(8) Required Key | |
| p_min_credits |
The minimum credit hours associated with the time status rule. NUMBER(9,3) Key | |
| p_max_credits |
The maximum credit hours associated with the time status rule. NUMBER(9,3) Key | |
| p_tax_ind |
This field identifies a rule which will be used to determine full time status for the Education Tax Credits. VARCHAR2(4) Key | |
| p_numb_credits |
The number of credit hours a student must have in order to receive the Education Tax Credits. NUMBER(9,3) Key | |
| p_numb_courses |
The number of courses a student must take in order to receive the Education Tax Credits. NUMBER(2) Key | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
Procedure p_validate(p_tmst_code sfrstsl.sfrstsl_tmst_code%TYPE,
p_scps_code_eff sfrstsl.sfrstsl_scps_code_eff%TYPE,
p_camp_code sfrstsl.sfrstsl_camp_code%TYPE,
p_levl_code sfrstsl.sfrstsl_levl_code%TYPE,
p_coll_code sfrstsl.sfrstsl_coll_code%TYPE,
p_majr_code sfrstsl.sfrstsl_majr_code%TYPE,
p_styp_code sfrstsl.sfrstsl_styp_code%TYPE,
p_degc_code sfrstsl.sfrstsl_degc_code%TYPE,
p_levl_code_crse sfrstsl.sfrstsl_levl_code_crse%TYPE,
p_min_credits sfrstsl.sfrstsl_min_credits%TYPE,
p_max_credits sfrstsl.sfrstsl_max_credits%TYPE,
p_tax_ind sfrstsl.sfrstsl_tax_ind%TYPE,
p_numb_credits sfrstsl.sfrstsl_numb_credits%TYPE,
p_numb_courses sfrstsl.sfrstsl_numb_courses%TYPE)
Validates all data in the record.
| Parameters |
| p_tmst_code |
Time Status Code; Valid values are in the STVTMST table. VARCHAR2(8) Required Key | |
| p_scps_code_eff |
The effective student centric period for the time status rule. VARCHAR2(24) Required Key | |
| p_camp_code |
The campus code; valid values are in the STVCAMP table. VARCHAR2(12) Key | |
| p_levl_code |
The level code; valid values arein the STVLEVL table. VARCHAR2(8) Key | |
| p_coll_code |
The college code; valid values are in the STVCOLL table. VARCHAR2(8) Key | |
| p_majr_code |
The major code; valid values arein the STVMAJR table. VARCHAR2(16) Key | |
| p_styp_code |
The student type code; valid values are in the STVSTYP table. VARCHAR2(4) Key | |
| p_degc_code |
The degree code; valid values are in the STVDEGC table. VARCHAR2(24) Key | |
| p_levl_code_crse |
The level of the courses to be included in the calculation of hours associated with the time status rule. VARCHAR2(8) Required Key | |
| p_min_credits |
The minimum credit hours associated with the time status rule. NUMBER(9,3) Key | |
| p_max_credits |
The maximum credit hours associated with the time status rule. NUMBER(9,3) Key | |
| p_tax_ind |
This field identifies a rule which will be used to determine full time status for the Education Tax Credits. VARCHAR2(4) Key | |
| p_numb_credits |
The number of credit hours a student must have in order to receive the Education Tax Credits. NUMBER(9,3) Key | |
| p_numb_courses |
The number of courses a student must take in order to receive the Education Tax Credits. NUMBER(2) Key |