index

Package sb_mealassignment_rules

This package provides the support subprograms for the Meal Assignment API.

Program units
p_register_entity  
p_validate  

p_register_entity 

Procedure p_register_entity(
      p_operation_type       NUMBER,
      p_pidm                 slrmasg.slrmasg_pidm%TYPE,
      p_term_code            slrmasg.slrmasg_term_code%TYPE,
      p_mrcd_code            slrmasg.slrmasg_mrcd_code%TYPE,
      p_begin_date           slrmasg.slrmasg_begin_date%TYPE,
      p_end_date             slrmasg.slrmasg_end_date%TYPE,
      p_total_days           slrmasg.slrmasg_total_days%TYPE,
      p_total_months         slrmasg.slrmasg_total_months%TYPE,
      p_total_terms          slrmasg.slrmasg_total_terms%TYPE,
      p_mscd_code            slrmasg.slrmasg_mscd_code%TYPE,
      p_mscd_date            slrmasg.slrmasg_mscd_date%TYPE,
      p_onl_or_bat           slrmasg.slrmasg_onl_or_bat%TYPE,
      p_ar_ind               slrmasg.slrmasg_ar_ind%TYPE,
      p_roll_ind             slrmasg.slrmasg_roll_ind%TYPE,
      p_assess_needed        slrmasg.slrmasg_assess_needed%TYPE,
      p_data_origin          slrmasg.slrmasg_data_origin%TYPE,
      p_user_id              slrmasg.slrmasg_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 the parameters.

Parameters
p_pidm   Internal identifier associated with the meal assignment.  NUMBER(8) Required
p_term_code   Term code associated with the meal assignment. VARCHAR2(8) Required
p_mrcd_code   Meal plan code.  VARCHAR2(4) Required
p_begin_date   First day of the meal assignment.  DATE Required
p_end_date   Last day of the meal assignment.  DATE Required
p_total_days   Total number of days of the meal assignment.  NUMBER(9,5) Required
p_total_months   Total number of months of the meal assignment.  NUMBER(7,5) Required
p_total_terms   Total number of terms of the meal assignment.  NUMBER(7,5)
p_mscd_code   Meal plan status code of the meal assignment.  VARCHAR2(2) Required
p_mscd_date   Date the meal plan status code was last updated.  DATE Required
p_onl_or_bat   Specifies whether the meal assignment was created online or in batch using the batch scheduler.  VARCHAR2(1) Required
p_ar_ind   Specifies whether the meal assignment charges have been processed.  VARCHAR2(1) Required
p_roll_ind   Controls whether the meal assignment can be rolled using the roll forward process.  VARCHAR2(1) Required
p_assess_needed   Specifies whether fee assessment is needed for the meal assignment.  VARCHAR2(1) Required
p_data_origin   Source system that generated the data.  VARCHAR2(30) Required
p_user_id   Oracle ID of the user who inserted or last updated the data.
p_internal_record_id   Database ROWID.  VARCHAR2(18) Required

p_validate 

Procedure p_validate(
      p_pidm            slrmasg.slrmasg_pidm%TYPE,
      p_term_code       slrmasg.slrmasg_term_code%TYPE,
      p_mrcd_code       slrmasg.slrmasg_mrcd_code%TYPE,
      p_begin_date      slrmasg.slrmasg_begin_date%TYPE,
      p_end_date        slrmasg.slrmasg_end_date%TYPE,
      p_total_days      slrmasg.slrmasg_total_days%TYPE,
      p_total_months    slrmasg.slrmasg_total_months%TYPE,
      p_total_terms     slrmasg.slrmasg_total_terms%TYPE,
      p_mscd_code       slrmasg.slrmasg_mscd_code%TYPE,
      p_mscd_date       slrmasg.slrmasg_mscd_date%TYPE,
      p_onl_or_bat      slrmasg.slrmasg_onl_or_bat%TYPE,
      p_ar_ind          slrmasg.slrmasg_ar_ind%TYPE,
      p_roll_ind        slrmasg.slrmasg_roll_ind%TYPE DEFAULT NULL,
      p_assess_needed   slrmasg.slrmasg_assess_needed%TYPE,
      p_data_origin     slrmasg.slrmasg_data_origin%TYPE DEFAULT NULL,
      p_user_id         slrmasg.slrmasg_user_id%TYPE DEFAULT gb_common.f_sct_user
   )

Validates all the data in the record.

Parameters
p_pidm   Internal identifier associated with the meal assignment.  NUMBER(8) Required
p_term_code   Term code associated with the meal assignment.  VARCHAR2(6) Required
p_mrcd_code   Meal plan code.  VARCHAR2(4) Required
p_begin_date   First day of the meal assignment.  DATE Required
p_end_date   Last day of the meal assignment.  DATE Required
p_total_days   Total number of days of the meal assignment.  NUMBER(9,5) Required
p_total_months   Total number of months of the meal assignment.  NUMBER(7,5) Required
p_total_terms   Total number of terms of the meal assignment.  NUMBER(7,5) Required
p_mscd_code   Meal plan status code of the meal assignment.  VARCHAR2(2) Required
p_mscd_date   Date the meal plan status code was last updated. DATE Required
p_onl_or_bat   Specifies whether the meal assignment was created online or in batch using the batch scheduler.  VARCHAR2(1) Required
p_ar_ind   Specifies whether the meal assignment charges have been processed.  VARCHAR2(1) Required
p_roll_ind   Controls whether the meal assignment can be rolled using the roll forward process.  VARCHAR2(1)
p_assess_needed   Specifies whether fee assessment is needed for the meal assignment.  VARCHAR2(1) Required
p_data_origin   Source system that generated the data.  VARCHAR2(30)
p_user_id   Oracle ID of the user who inserted or last updated the data.  VARCHAR2(30)