index

Package sb_crse_mutual_exclusion_rules

This package provides the support subprograms for the Course Mutual Exclusion API (sb_crse_mutual_exclusion).

Program units
f_parent_exists   Checks for the existence of the parent course record.
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.

f_parent_exists 

Function f_parent_exists(p_subj_code scrmexc.scrmexc_subj_code%TYPE,
                         p_crse_numb scrmexc.scrmexc_crse_numb%TYPE)
  RETURN VARCHAR2

Checks for the existence of the parent course record.

Parameters
p_subj_code   Subject code of the course. VARCHAR2(4) Required
p_crse_numb   Course number of the course. VARCHAR2(5) Required

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_primary_key        scrmexc.scrmexc_primary_key%TYPE,
                            p_subj_code          scrmexc.scrmexc_subj_code%TYPE,
                            p_crse_numb          scrmexc.scrmexc_crse_numb%TYPE,
                            p_eff_term           scrmexc.scrmexc_eff_term%TYPE,
                            p_user_id            scrmexc.scrmexc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_subj_code_mexc     scrmexc.scrmexc_subj_code_mexc%TYPE,
                            p_crse_numb_mexc     scrmexc.scrmexc_crse_numb_mexc%TYPE,
                            p_levl_code          scrmexc.scrmexc_levl_code%TYPE,
                            p_grde_code          scrmexc.scrmexc_grde_code%TYPE,
                            p_start_term         scrmexc.scrmexc_start_term%TYPE,
                            p_end_term           scrmexc.scrmexc_end_term%TYPE,
                            p_data_origin        scrmexc.scrmexc_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_primary_key   Unique sequence number that identifies the record. NUMBER(9) Required Key
p_subj_code   Subject code of the course with mutual exclusions. VARCHAR2(16) Required Key
p_crse_numb   Course number of the course with mutual exclusions. VARCHAR2(20) Required Key
p_eff_term   Term code for which this exclusion becomes effective. VARCHAR2(24) Required Key
p_user_id   Oracle ID of the user who changed the record. VARCHAR2(120) Required
p_subj_code_mexc   Subject Code for the course that is considered mutually exclusive. VARCHAR2(16) Key
p_crse_numb_mexc   Course field is used to specify the course number for the course that is considered mutually exclusive. VARCHAR2(20) Key
p_levl_code   Level for which the minimum grade will be established. VARCHAR2(8) Key
p_grde_code   Minimum grade for the mutual exclusion. VARCHAR2(24)
p_start_term   Start term for mutually exclusive course definition. VARCHAR2(24) Key
p_end_term   End term for mutually exclusive course definition. VARCHAR2(24)
p_data_origin   Source system that created or updated the row. VARCHAR2(120)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_subj_code      scrmexc.scrmexc_subj_code%TYPE,
                     p_crse_numb      scrmexc.scrmexc_crse_numb%TYPE,
                     p_eff_term       scrmexc.scrmexc_eff_term%TYPE,
                     p_user_id        scrmexc.scrmexc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_subj_code_mexc scrmexc.scrmexc_subj_code_mexc%TYPE,
                     p_crse_numb_mexc scrmexc.scrmexc_crse_numb_mexc%TYPE,
                     p_levl_code      scrmexc.scrmexc_levl_code%TYPE,
                     p_grde_code      scrmexc.scrmexc_grde_code%TYPE DEFAULT NULL,
                     p_start_term     scrmexc.scrmexc_start_term%TYPE,
                     p_end_term       scrmexc.scrmexc_end_term%TYPE DEFAULT NULL,
                     p_data_origin    scrmexc.scrmexc_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters
p_subj_code   The subject code of the course with mutual exclusions. VARCHAR2(16) Required Key
p_crse_numb   The course number of the course with mutual exclusions. VARCHAR2(20) Required Key
p_eff_term   Term code for which this exclusion becomes effective. VARCHAR2(24) Required Key
p_user_id   Oracle ID of the user who changed the record. VARCHAR2(120) Required
p_subj_code_mexc   Subject Code for the course that is considered mutually exclusive. VARCHAR2(16) Key
p_crse_numb_mexc   Course field is used to specify the course number for the course that is considered mutually exclusive. VARCHAR2(20) Key
p_levl_code   The level for which the minimum grade will be established. VARCHAR2(8) Key
p_grde_code   The minimum grade for the mutual exclusion. VARCHAR2(24)
p_start_term   Start term for mutually exclusive course definition. VARCHAR2(24) Key
p_end_term   End term for mutually exclusive course definition. VARCHAR2(24)
p_data_origin   Source system that created or updated the row. VARCHAR2(120)