|
|
Package sb_curriculum_archive_rules Support subprograms for the Curriculum Archive API (sb_curriculum_archive). |
| 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 sorhcur.sorhcur_pidm%TYPE,
p_seqno sorhcur.sorhcur_seqno%TYPE,
p_lmod_cde sorhcur.sorhcur_lmod_cde%TYPE,
p_term_cde sorhcur.sorhcur_term_cde%TYPE,
p_key_seqno sorhcur.sorhcur_key_seqno%TYPE,
p_priority_no sorhcur.sorhcur_priority_no%TYPE,
p_roll_ind sorhcur.sorhcur_roll_ind%TYPE,
p_cact_cde sorhcur.sorhcur_cact_cde%TYPE,
p_user_id sorhcur.sorhcur_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_data_origin sorhcur.sorhcur_data_origin%TYPE,
p_levl_cde sorhcur.sorhcur_levl_cde%TYPE,
p_coll_cde sorhcur.sorhcur_coll_cde%TYPE,
p_degc_cde sorhcur.sorhcur_degc_cde%TYPE,
p_term_cde_ctlg sorhcur.sorhcur_term_cde_ctlg%TYPE,
p_term_cde_end sorhcur.sorhcur_term_cde_end%TYPE,
p_term_cde_matric sorhcur.sorhcur_term_cde_matric%TYPE,
p_term_cde_admit sorhcur.sorhcur_term_cde_admit%TYPE,
p_admt_cde sorhcur.sorhcur_admt_cde%TYPE,
p_camp_cde sorhcur.sorhcur_camp_cde%TYPE,
p_program sorhcur.sorhcur_program%TYPE,
p_start_date sorhcur.sorhcur_start_date%TYPE,
p_end_date sorhcur.sorhcur_end_date%TYPE,
p_curr_rule sorhcur.sorhcur_curr_rule%TYPE,
p_rolled_seqno sorhcur.sorhcur_rolled_seqno%TYPE,
p_styp_cde sorhcur.sorhcur_styp_cde%TYPE,
p_rate_cde sorhcur.sorhcur_rate_cde%TYPE,
p_leav_cde sorhcur.sorhcur_leav_cde%TYPE,
p_leav_from_date sorhcur.sorhcur_leav_from_date%TYPE,
p_leav_to_date sorhcur.sorhcur_leav_to_date%TYPE,
p_exp_grad_date sorhcur.sorhcur_exp_grad_date%TYPE,
p_term_cde_grad sorhcur.sorhcur_term_cde_grad%TYPE,
p_acyr_cde sorhcur.sorhcur_acyr_cde%TYPE,
p_site_cde sorhcur.sorhcur_site_cde%TYPE,
p_appl_seqno sorhcur.sorhcur_appl_seqno%TYPE,
p_appl_key_seqno sorhcur.sorhcur_appl_key_seqno%TYPE,
p_key_seqno_rolled sorhcur.sorhcur_key_seqno_rolled%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 |
Unique internal ID for an individual who has records in the system. NUMBER(8) Required Key | |
| p_seqno |
One-up number to define the row. NUMBER(4) Required Key | |
| p_lmod_cde |
Learner module code. VARCHAR2(15) Required | |
| p_term_cde |
Term code. VARCHAR2(6) Required | |
| p_key_seqno |
Sequence number of the key record. NUMBER(2) Required | |
| p_priority_no |
Priority of the curriculum within the module. NUMBER(4) Required | |
| p_roll_ind |
Y/N indicator for whether the learner curriculum should roll to academic history when courses are rolled. VARCHAR2(1) Required | |
| p_cact_cde |
Activity status code for the curriculum. VARCHAR2(15) Required | |
| p_user_id |
Most recent user to create or update the record. VARCHAR2(30) Required | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) Required | |
| p_levl_cde |
Level code of the curriculum. VARCHAR2(2) Required | |
| p_coll_cde |
College code of the curriculum. VARCHAR2(2) Required | |
| p_degc_cde |
Degree code of the curriculum. VARCHAR2(6) Required | |
| p_term_cde_ctlg |
Catalog term code of the curriculum. VARCHAR2(6) | |
| p_term_cde_end |
End term code of the curriculum. VARCHAR2(6) | |
| p_term_cde_matric |
Term code in which the learner matriculated into the curriculum. VARCHAR2(6) | |
| p_term_cde_admit |
Term code in which the learner was admitted to the curriculum. VARCHAR2(6) | |
| p_admt_cde |
Admit code for the learner's admission to the curriculum. VARCHAR2(2) | |
| p_camp_cde |
Campus code of the curriculum. VARCHAR2(3) | |
| p_program |
Program of the curriculum. VARCHAR2(12) | |
| p_start_date |
Date on which the curriculum starts. DATE | |
| p_end_date |
Date on which the curriculum ends. DATE | |
| p_curr_rule |
Rule number of the curriculum. NUMBER(8) | |
| p_rolled_seqno |
Sequence number of the outcome created during the grade roll. NUMBER(4) | |
| p_styp_cde |
Type of student. VARCHAR2(1) | |
| p_rate_cde |
Fee assessment rate code. VARCHAR2(5) | |
| p_leav_cde |
Reason for the leave of absence. VARCHAR2(1) | |
| p_leav_from_date |
End date of the leave. DATE | |
| p_leav_to_date |
Start date of the leave. DATE | |
| p_exp_grad_date |
Date on which the learner is expected to graduate from the curriculum. DATE | |
| p_term_cde_grad |
Expected term the learner will graduate. VARCHAR2(6) | |
| p_acyr_cde |
Academic year for the graduation. VARCHAR2(4) | |
| p_site_cde |
Site of the student. VARCHAR2(3) | |
| p_appl_seqno |
Sequence number of the application curriculum from which the learner curriculum was created. NUMBER(4) | |
| p_appl_key_seqno |
Application number from which the learner curriculum was created. NUMBER(2) | |
| p_key_seqno_rolled |
Sequence number of the application curriculum from which the history was rolled. NUMBER(2) | |
| p_internal_record_id |
Database ROWID. VARCHAR2(18) required |
p_validate
Procedure p_validate(p_pidm sorhcur.sorhcur_pidm%TYPE,
p_seqno sorhcur.sorhcur_seqno%TYPE,
p_lmod_cde sorhcur.sorhcur_lmod_cde%TYPE,
p_term_cde sorhcur.sorhcur_term_cde%TYPE,
p_key_seqno sorhcur.sorhcur_key_seqno%TYPE,
p_priority_no sorhcur.sorhcur_priority_no%TYPE,
p_roll_ind sorhcur.sorhcur_roll_ind%TYPE,
p_cact_cde sorhcur.sorhcur_cact_cde%TYPE,
p_user_id sorhcur.sorhcur_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_data_origin sorhcur.sorhcur_data_origin%TYPE,
p_levl_cde sorhcur.sorhcur_levl_cde%TYPE,
p_coll_cde sorhcur.sorhcur_coll_cde%TYPE,
p_degc_cde sorhcur.sorhcur_degc_cde%TYPE,
p_term_cde_ctlg sorhcur.sorhcur_term_cde_ctlg%TYPE DEFAULT NULL,
p_term_cde_end sorhcur.sorhcur_term_cde_end%TYPE DEFAULT NULL,
p_term_cde_matric sorhcur.sorhcur_term_cde_matric%TYPE DEFAULT NULL,
p_term_cde_admit sorhcur.sorhcur_term_cde_admit%TYPE DEFAULT NULL,
p_admt_cde sorhcur.sorhcur_admt_cde%TYPE DEFAULT NULL,
p_camp_cde sorhcur.sorhcur_camp_cde%TYPE DEFAULT NULL,
p_program sorhcur.sorhcur_program%TYPE DEFAULT NULL,
p_start_date sorhcur.sorhcur_start_date%TYPE DEFAULT NULL,
p_end_date sorhcur.sorhcur_end_date%TYPE DEFAULT NULL,
p_curr_rule sorhcur.sorhcur_curr_rule%TYPE DEFAULT NULL,
p_rolled_seqno sorhcur.sorhcur_rolled_seqno%TYPE DEFAULT NULL,
p_styp_cde sorhcur.sorhcur_styp_cde%TYPE DEFAULT NULL,
p_rate_cde sorhcur.sorhcur_rate_cde%TYPE DEFAULT NULL,
p_leav_cde sorhcur.sorhcur_leav_cde%TYPE DEFAULT NULL,
p_leav_from_date sorhcur.sorhcur_leav_from_date%TYPE DEFAULT NULL,
p_leav_to_date sorhcur.sorhcur_leav_to_date%TYPE DEFAULT NULL,
p_exp_grad_date sorhcur.sorhcur_exp_grad_date%TYPE DEFAULT NULL,
p_term_cde_grad sorhcur.sorhcur_term_cde_grad%TYPE DEFAULT NULL,
p_acyr_cde sorhcur.sorhcur_acyr_cde%TYPE DEFAULT NULL,
p_site_cde sorhcur.sorhcur_site_cde%TYPE DEFAULT NULL,
p_appl_seqno sorhcur.sorhcur_appl_seqno%TYPE DEFAULT NULL,
p_appl_key_seqno sorhcur.sorhcur_appl_key_seqno%TYPE DEFAULT NULL,
p_key_seqno_rolled sorhcur.sorhcur_key_seqno_rolled%TYPE DEFAULT NULL)
Validates all data in the record.
| Parameters |
| p_pidm |
Unique internal ID for an individual who has records in the system. NUMBER(8) Required Key | |
| p_seqno |
One-up number to define the row. NUMBER(4) Required Key | |
| p_lmod_cde |
Learner module code. VARCHAR2(15) Required | |
| p_term_cde |
Term code. VARCHAR2(6) Required | |
| p_key_seqno |
Sequence number of the key record. NUMBER(2) Required | |
| p_priority_no |
Priority of the curriculum within the module. NUMBER(4) Required | |
| p_roll_ind |
Y/N indicator for whether the learner curriculum should roll to academic history when courses are rolled. VARCHAR2(1) Required | |
| p_cact_cde |
Activity status code for the curriculum. VARCHAR2(15) Required | |
| p_user_id |
Most recent user to create or update the record. VARCHAR2(30) Required | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) Required | |
| p_levl_cde |
Level code of the curriculum. VARCHAR2(2) Required | |
| p_coll_cde |
College code of the curriculum. VARCHAR2(2) Required | |
| p_degc_cde |
Degree code of the curriculum. VARCHAR2(6) Required | |
| p_term_cde_ctlg |
Catalog term code of the curriculum. VARCHAR2(6) | |
| p_term_cde_end |
End term code of the curriculum. VARCHAR2(6) | |
| p_term_cde_matric |
Term code in which the learner matriculated into the curriculum. VARCHAR2(6) | |
| p_term_cde_admit |
Term code in which the learner was admitted to the curriculum. VARCHAR2(6) | |
| p_admt_cde |
Admit code for the learner's admission to the curriculum. VARCHAR2(2) | |
| p_camp_cde |
Campus code of the curriculum. VARCHAR2(3) | |
| p_program |
Program of the curriculum. VARCHAR2(12) | |
| p_start_date |
Date on which the curriculum starts. DATE | |
| p_end_date |
Date on which the curriculum ends. DATE | |
| p_curr_rule |
Rule number of the curriculum. NUMBER(8) | |
| p_rolled_seqno |
Sequence number of the outcome created during the grade roll. NUMBER(4) | |
| p_styp_cde |
Type of student. VARCHAR2(1) | |
| p_rate_cde |
Fee assessment rate code. VARCHAR2(5) | |
| p_leav_cde |
Reason for the leave of absence. VARCHAR2(1) | |
| p_leav_from_date |
End date of the leave. DATE | |
| p_leav_to_date |
Start date of the leave. DATE | |
| p_exp_grad_date |
Date on which the learner is expected to graduate from the curriculum. DATE | |
| p_term_cde_grad |
Expected term the learner will graduate. VARCHAR2(6) | |
| p_acyr_cde |
Academic year for the graduation. VARCHAR2(4) | |
| p_site_cde |
Site of the student. VARCHAR2(3) | |
| p_appl_seqno |
Sequence number of the application curriculum from which the learner curriculum was created. NUMBER(4) | |
| p_appl_key_seqno |
Application number from which the learner curriculum was created. NUMBER(2) | |
| p_key_seqno_rolled |
Sequence number of the application curriculum from which the history was rolled. NUMBER(2) |