|
|
Package sb_fieldofstudy_archive_rules Support subprograms for the Field of Study Archive API (sb_fieldofstudy_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 sorhfos.sorhfos_pidm%TYPE,
p_lcur_seqno sorhfos.sorhfos_lcur_seqno%TYPE,
p_seqno sorhfos.sorhfos_seqno%TYPE,
p_lfst_cde sorhfos.sorhfos_lfst_cde%TYPE,
p_term_cde sorhfos.sorhfos_term_cde%TYPE,
p_priority_no sorhfos.sorhfos_priority_no%TYPE,
p_csts_cde sorhfos.sorhfos_csts_cde%TYPE,
p_cact_cde sorhfos.sorhfos_cact_cde%TYPE,
p_data_origin sorhfos.sorhfos_data_origin%TYPE,
p_user_id sorhfos.sorhfos_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_majr_cde sorhfos.sorhfos_majr_cde%TYPE,
p_term_cde_ctlg sorhfos.sorhfos_term_cde_ctlg%TYPE,
p_term_cde_end sorhfos.sorhfos_term_cde_end%TYPE,
p_dept_cde sorhfos.sorhfos_dept_cde%TYPE,
p_lfos_rule sorhfos.sorhfos_lfos_rule%TYPE,
p_conc_attach_rule sorhfos.sorhfos_conc_attach_rule%TYPE,
p_start_date sorhfos.sorhfos_start_date%TYPE,
p_end_date sorhfos.sorhfos_end_date%TYPE,
p_tmst_cde sorhfos.sorhfos_tmst_cde%TYPE,
p_rolled_seqno sorhfos.sorhfos_rolled_seqno%TYPE,
p_majr_cde_attach sorhfos.sorhfos_majr_cde_attach%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_lcur_seqno |
Sequence number of the parent learner curriculum base record. NUMBER(4) Required Key | |
| p_seqno |
Sequence number of the learner field of study. NUMBER(4) Required Key | |
| p_lfst_cde |
Field of study type code, for example MAJOR, MINOR, CONC. VARCHAR2(15) Required | |
| p_term_cde |
Term code for which the field of study is active. VARCHAR2(6) Required | |
| p_priority_no |
Priority number, or ranking, of the field of study. NUMBER(4) Required | |
| p_csts_cde |
Status of the curriculum. VARCHAR2(15) Required | |
| p_cact_cde |
Curriculum activity status. VARCHAR2(15) Required | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) Required | |
| p_user_id |
Most recent user to create or update the record. VARCHAR2(30) Required | |
| p_majr_cde |
Major code for the field of study. VARCHAR2(4) Required | |
| p_term_cde_ctlg |
Term code identifying the catalog for the curriculum. VARCHAR2(6) | |
| p_term_cde_end |
End term code for which the curriculum is active. VARCHAR2(6) | |
| p_dept_cde |
Department code associated with the major field of study. VARCHAR2(4) | |
| p_lfos_rule |
Curriculum rule from the curriculum table. NUMBER(8) | |
| p_conc_attach_rule |
Major curriculum rule from the SORCCMN table for concentrations attached to a major. NUMBER(8) | |
| p_start_date |
Start date of the field of study. DATE | |
| p_end_date |
End date of the field of study. DATE | |
| p_tmst_cde |
Time status code to indicate the intent of the student's pursuit of the field of study. VARCHAR2(2) | |
| p_rolled_seqno |
Outcome sequence number that was created from the history roll process. NUMBER(4) | |
| p_majr_cde_attach |
Major code to which the concentration is attached. VARCHAR2(4) | |
| p_internal_record_id |
Database ROWID. VARCHAR2(18) required |
p_validate
Procedure p_validate(p_pidm sorhfos.sorhfos_pidm%TYPE,
p_lcur_seqno sorhfos.sorhfos_lcur_seqno%TYPE,
p_seqno sorhfos.sorhfos_seqno%TYPE,
p_lfst_cde sorhfos.sorhfos_lfst_cde%TYPE,
p_term_cde sorhfos.sorhfos_term_cde%TYPE,
p_priority_no sorhfos.sorhfos_priority_no%TYPE,
p_csts_cde sorhfos.sorhfos_csts_cde%TYPE,
p_cact_cde sorhfos.sorhfos_cact_cde%TYPE,
p_data_origin sorhfos.sorhfos_data_origin%TYPE,
p_user_id sorhfos.sorhfos_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_majr_cde sorhfos.sorhfos_majr_cde%TYPE,
p_term_cde_ctlg sorhfos.sorhfos_term_cde_ctlg%TYPE DEFAULT NULL,
p_term_cde_end sorhfos.sorhfos_term_cde_end%TYPE DEFAULT NULL,
p_dept_cde sorhfos.sorhfos_dept_cde%TYPE DEFAULT NULL,
p_lfos_rule sorhfos.sorhfos_lfos_rule%TYPE DEFAULT NULL,
p_conc_attach_rule sorhfos.sorhfos_conc_attach_rule%TYPE DEFAULT NULL,
p_start_date sorhfos.sorhfos_start_date%TYPE DEFAULT NULL,
p_end_date sorhfos.sorhfos_end_date%TYPE DEFAULT NULL,
p_tmst_cde sorhfos.sorhfos_tmst_cde%TYPE DEFAULT NULL,
p_rolled_seqno sorhfos.sorhfos_rolled_seqno%TYPE DEFAULT NULL,
p_majr_cde_attach sorhfos.sorhfos_majr_cde_attach%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_lcur_seqno |
Sequence number of the parent learner curriculum base record. NUMBER(4) Required Key | |
| p_seqno |
Sequence number of the learner field of study. NUMBER(4) Required Key | |
| p_lfst_cde |
Field of study type code, for example MAJOR, MINOR, CONC. VARCHAR2(15) Required | |
| p_term_cde |
Term code for which the field of study is active. VARCHAR2(6) Required | |
| p_priority_no |
Priority number, or ranking, of the field of study. NUMBER(4) Required | |
| p_csts_cde |
Status of the curriculum. VARCHAR2(15) Required | |
| p_cact_cde |
Curriculum activity status. VARCHAR2(15) Required | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) Required | |
| p_user_id |
Most recent user to create or update the record. VARCHAR2(30) Required | |
| p_majr_cde |
Major code for the field of study. VARCHAR2(4) Required | |
| p_term_cde_ctlg |
Term code identifying the catalog for the curriculum. VARCHAR2(6) | |
| p_term_cde_end |
End term code for which the curriculum is active. VARCHAR2(6) | |
| p_dept_cde |
Department code associated with the major field of study. VARCHAR2(4) | |
| p_lfos_rule |
Curriculum rule from the curriculum table. NUMBER(8) | |
| p_conc_attach_rule |
Major curriculum rule from the SORCCMN table for concentrations attached to a major. NUMBER(8) | |
| p_start_date |
Start date of the field of study. DATE | |
| p_end_date |
End date of the field of study. DATE | |
| p_tmst_cde |
Time status code to indicate the intent of the student's pursuit of the field of study. VARCHAR2(2) | |
| p_rolled_seqno |
Outcome sequence number that was created from the history roll process. NUMBER(4) | |
| p_majr_cde_attach |
Major code to which the concentration is attached. VARCHAR2(4) |