index

Package sb_curriculum_default_rules

Support subprograms for the Curriculum Default API  (sb_curriculum_default).

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 that mandatory items are not missing:

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_user_id            sorlcdf.sorlcdf_user_id%TYPE,
                            p_lmod_code          sorlcdf.sorlcdf_lmod_code%TYPE,
                            p_camp_code          sorlcdf.sorlcdf_camp_code%TYPE,
                            p_coll_code          sorlcdf.sorlcdf_coll_code%TYPE,
                            p_levl_code          sorlcdf.sorlcdf_levl_code%TYPE,
                            p_program            sorlcdf.sorlcdf_program%TYPE,
                            p_degc_code          sorlcdf.sorlcdf_degc_code%TYPE,
                            p_majr_code          sorlcdf.sorlcdf_majr_code%TYPE,
                            p_dept_code          sorlcdf.sorlcdf_dept_code%TYPE,
                            p_data_origin        sorlcdf.sorlcdf_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_user_id   Oracle user ID of the user to whom the curriculum preferences belong. VARCHAR2(30) Required Key
p_lmod_code   Learner module code for the curriculum preferences. VARCHAR2(15) Required Key
p_camp_code   Campus code for the curriculum user preference. VARCHAR2(3)
p_coll_code   College code for the curriculum user preference. VARCHAR2(2)
p_levl_code   Level code for the curriculum user preference. VARCHAR2(2)
p_program   Program for the curriculum user preference. VARCHAR2(12)
p_degc_code   Degree code for the curriculum user preference. VARCHAR2(6)
p_majr_code   Primary major field of study code for the curriculum user preference. VARCHAR2(4)
p_dept_code   Department code for the primary major for the curriculum user preference. VARCHAR2(4)
p_data_origin   Source system that created or updated the row. VARCHAR2(30) Required
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_user_id     sorlcdf.sorlcdf_user_id%TYPE,
                     p_lmod_code   sorlcdf.sorlcdf_lmod_code%TYPE,
                     p_camp_code   sorlcdf.sorlcdf_camp_code%TYPE DEFAULT NULL,
                     p_coll_code   sorlcdf.sorlcdf_coll_code%TYPE DEFAULT NULL,
                     p_levl_code   sorlcdf.sorlcdf_levl_code%TYPE DEFAULT NULL,
                     p_program     sorlcdf.sorlcdf_program%TYPE DEFAULT NULL,
                     p_degc_code   sorlcdf.sorlcdf_degc_code%TYPE DEFAULT NULL,
                     p_majr_code   sorlcdf.sorlcdf_majr_code%TYPE DEFAULT NULL,
                     p_dept_code   sorlcdf.sorlcdf_dept_code%TYPE DEFAULT NULL,
                     p_data_origin sorlcdf.sorlcdf_data_origin%TYPE)

Validates that mandatory items are not missing:
  User ID
  Learner module code may not be null and must be valid in table STVLMOD
 
Validates foreign keys if the value is not null:
  College code must exist in table STVCOLL
  Campus code must exist in table STVCAMP
  College code must exist in table STVCOLL
  Level code must exist in  table STVLEVL
  Program must exist in SMRPRLE
  Major code must exist in STVMAJR and have a major type indicator
  Department code must exist in STVDEPT

Parameters
p_user_id   Oracle user ID of the user to whom the curriculum preferences belong. VARCHAR2(30) Required Key
p_lmod_code   Learner module code for the curriculum preferences. VARCHAR2(15) Required Key
p_camp_code   Campus code for the curriculum user preference. VARCHAR2(3)
p_coll_code   College code for the curriculum user preference. VARCHAR2(2)
p_levl_code   Level code for the curriculum user preference. VARCHAR2(2)
p_program   Program for the curriculum user preference. VARCHAR2(12)
p_degc_code   Degree code for the curriculum user preference. VARCHAR2(6)
p_majr_code   Primary major field of study code for the curriculum user preference. VARCHAR2(4)
p_dept_code   Department code for the primary major for the curriculum user preference. VARCHAR2(4)
p_data_origin   Source system that created or updated the row. VARCHAR2(30) Required