index

Package sb_fieldofstudy_allowed_rules

Support subprograms for the Field of Study Maximum Allowed API (sb_fieldofstudy_allowed).

Program units
p_register_entity  
p_validate  

p_register_entity 

Procedure p_register_entity(
    p_operation_type            NUMBER,
    p_lmod_code                 sorlmfs.sorlmfs_lmod_code%TYPE,
    p_lfst_code                 sorlmfs.sorlmfs_lfst_code%TYPE,
    p_tran_web_ind              sorlmfs.sorlmfs_tran_web_ind%TYPE,
    p_sys_req_ind               sorlmfs.sorlmfs_sys_req_ind%TYPE,
    p_max_number                sorlmfs.sorlmfs_max_number%TYPE,
    p_user_id                   sorlmfs.sorlmfs_user_id%TYPE DEFAULT gb_common.f_sct_user,
    p_data_origin               sorlmfs.sorlmfs_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 the all parameters.

Parameters
p_operation_type   Type of DML operation: create, update, delete. NUMBER Required
p_lmod_code   Banner learner module code. VARCHAR2(15) Required Key
p_lfst_code   Learner field of study type code. VARCHAR2(15) Required Key
p_tran_web_ind   Y/N indicator for whether the field of study will be printed on the transcript. VARCHAR2(1) Required
p_sys_req_ind   Y/N indicator for whether the curriculum module is required. VARCHAR2(1) Required
p_max_number   Count of current and active fields of study per module. NUMBER(8) Required
p_user_id   Most recent user to create or update the record. VARCHAR2(30) Required
p_data_origin   Data origin of the insert or update to the record. VARCHAR2(30) Required
p_internal_record_id   Database ROWID. VARCHAR2(18) required

p_validate 

Procedure p_validate(
    p_lmod_code                 sorlmfs.sorlmfs_lmod_code%TYPE,
    p_lfst_code                 sorlmfs.sorlmfs_lfst_code%TYPE,
    p_tran_web_ind              sorlmfs.sorlmfs_tran_web_ind%TYPE,
    p_sys_req_ind               sorlmfs.sorlmfs_sys_req_ind%TYPE,
    p_max_number                sorlmfs.sorlmfs_max_number%TYPE,
    p_user_id                   sorlmfs.sorlmfs_user_id%TYPE DEFAULT gb_common.f_sct_user,
    p_data_origin               sorlmfs.sorlmfs_data_origin%TYPE)

Validates all the data in the record.
Validates that all required columns are filled in:
  learner module code
  field of study type code
  transcript display indicator
  system required indicator
  maximum number
  user ID
  data origin
 
Validates that foreign key constraints are met:
  learner module code must exist on the STVLMOD table
  field of study type code must exist on the GTVLFST table
 
Validates indicators:
   display on transcript indicator is Y or N
   system required indicator is Y or N

Parameters
p_lmod_code   Banner learner module code. VARCHAR2(15) Required Key
p_lfst_code   Learner field of study type code. VARCHAR2(15) Required Key
p_tran_web_ind   Y/N indicator for whether the field of study will be printed on the transcript. VARCHAR2(1) Required
p_sys_req_ind   Y/N indicator for whether the curriculum module is required. VARCHAR2(1) Required
p_max_number   Count of current and active fields of study per module. NUMBER(8) Required
p_user_id   Most recent user to create or update the record. VARCHAR2(30) Required
p_data_origin   Data origin of the insert or update to the record. VARCHAR2(30) Required