|
Package sb_scp_ruletimestat_rules Support subprograms for the SCP_RULETIMESTAT (sb_scp_ruletimestat). |
| 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 sfrstst.sfrstst_tmst_code%TYPE,
p_scps_code_eff sfrstst.sfrstst_scps_code_eff%TYPE,
p_camp_code sfrstst.sfrstst_camp_code%TYPE,
p_levl_code sfrstst.sfrstst_levl_code%TYPE,
p_coll_code sfrstst.sfrstst_coll_code%TYPE,
p_majr_code sfrstst.sfrstst_majr_code%TYPE,
p_styp_code sfrstst.sfrstst_styp_code%TYPE,
p_degc_code sfrstst.sfrstst_degc_code%TYPE,
p_min_credits sfrstst.sfrstst_min_credits%TYPE,
p_max_credits sfrstst.sfrstst_max_credits%TYPE,
p_rule_numb sfrstst.sfrstst_rule_numb%TYPE,
p_tax_ind sfrstst.sfrstst_tax_ind%TYPE,
p_numb_credits sfrstst.sfrstst_numb_credits%TYPE,
p_numb_courses sfrstst.sfrstst_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_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_rule_numb |
Rule number. NUMBER(5) | |
| 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 sfrstst.sfrstst_tmst_code%TYPE,
p_scps_code_eff sfrstst.sfrstst_scps_code_eff%TYPE,
p_camp_code sfrstst.sfrstst_camp_code%TYPE,
p_levl_code sfrstst.sfrstst_levl_code%TYPE,
p_coll_code sfrstst.sfrstst_coll_code%TYPE,
p_majr_code sfrstst.sfrstst_majr_code%TYPE,
p_styp_code sfrstst.sfrstst_styp_code%TYPE,
p_degc_code sfrstst.sfrstst_degc_code%TYPE,
p_min_credits sfrstst.sfrstst_min_credits%TYPE,
p_max_credits sfrstst.sfrstst_max_credits%TYPE,
p_rule_numb sfrstst.sfrstst_rule_numb%TYPE DEFAULT NULL,
p_tax_ind sfrstst.sfrstst_tax_ind%TYPE,
p_numb_credits sfrstst.sfrstst_numb_credits%TYPE,
p_numb_courses sfrstst.sfrstst_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_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_rule_numb |
Rule number. NUMBER(5) | |
| 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 |