index

Package sb_learnermodule_rules

This package provides support subprograms for the Learner Module API (sb_learnermodule).


Program units
p_register_entity  
p_validate  


p_register_entity

Procedure p_register_entity(
      p_operation_type             NUMBER,
      p_lmod_code                 soblmod.soblmod_lmod_code%TYPE,
      p_sys_req_ind               soblmod.soblmod_sys_req_ind%TYPE,
      p_max_curricula             soblmod.soblmod_max_curricula%TYPE,
      p_max_majors                soblmod.soblmod_max_majors%TYPE,
      p_max_minors                soblmod.soblmod_max_minors%TYPE,
      p_max_concentrations        soblmod.soblmod_max_concentrations%TYPE,
      p_user_id                   soblmod.soblmod_user_id%TYPE DEFAULT
        gb_common.f_sct_user,
      p_internal_record_id         VARCHAR2)

Registers the attribute/value pairs to the message cache.
This signature registers all parameters.

Parameters
p_lmod_code   Banner learner module code.  VARCHAR2(15) Required Key
p_sys_req_ind   Curriculum module system-required indicator. VARCHAR2(1) Required
Y   Data is required for the system.
N   Data is not required for the system.

p_max_curricula   Count of curricula allowed per module.  Must be a valid integer greater than 0.  NUMBER(8) Required
p_max_majors   Number moved to Number of Field of Study Allowed (SORLMFS).  NUMBER(8)
p_max_minors   Number moved to Number of Field of Study Allowed (SORLMFS).  NUMBER(8)
p_max_concentrations   Number moved to Number of Field of Study Allowed (SORLMFS).  NUMBER(8)
p_user_id   Oracle ID of the most recent user to create or update a record.  VARCHAR2(30) Required
p_internal_record_id   Database ROWID.  VARCHAR2(18) Required


p_validate

Procedure p_validate(
      p_lmod_code                 soblmod.soblmod_lmod_code%TYPE,
      p_sys_req_ind               soblmod.soblmod_sys_req_ind%TYPE,
      p_max_curricula             soblmod.soblmod_max_curricula%TYPE,
      p_max_majors                soblmod.soblmod_max_majors%TYPE,
      p_max_minors                soblmod.soblmod_max_minors%TYPE,
      p_max_concentrations        soblmod.soblmod_max_concentrations%TYPE,
      p_user_id                   soblmod.soblmod_user_id%TYPE DEFAULT
        gb_common.f_sct_user)

Validates all the data in the record.

Parameters
p_lmod_code   Banner learner module code.  VARCHAR2(15)  Required Key
p_sys_req_ind   Curriculum module system-required indicator. VARCHAR(1) Required
Y   Data is required for the system.
N   Data is not required for the system.

p_max_curricula   Count of curricula allowed per module. Must be a valid integer greater than 0.  NUMBER(8) Required
p_max_majors   Number moved to Number of Field of Study Allowed (SORLMFS).  NUMBER(8)
p_max_minors   Number moved to Number of Field of Study Allowed (SORLMFS).  NUMBER(8)
p_max_concentrations   Number moved to Number of Field of Study Allowed (SORLMFS).  NUMBER(8)
p_user_id   Oracle ID of the most recent user to create or update a record.  VARCHAR2(30) Required