index

Package sb_roommate_rules

This package provides the support subprograms for the Roommate API.

Program units
p_register_entity  
p_validate  

p_register_entity 

Procedure p_register_entity(
      p_operation_type             NUMBER,
      p_term_code          slrrmat.slrrmat_term_code%TYPE,
      p_oneup              slrrmat.slrrmat_oneup%TYPE,
      p_pidm               slrrmat.slrrmat_pidm%TYPE,
      p_accept_ind         slrrmat.slrrmat_accept_ind%TYPE,
      p_data_origin        slrrmat.slrrmat_data_origin%TYPE,
      p_user_id            slrrmat.slrrmat_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_term_code   Term code associated with the roommate application.  VARCHAR2(6) Required key
p_oneup   Roommate sequence number of the roommate application. VARCHAR2(5) Required key
p_pidm   Internal identifier of the person who has a roommate application. NUMBER(8) Required key
p_accept_ind   Indicates whether the person and/or institution has accepted the person as a roommate. VARCHAR2(1) Required
p_data_origin   Source system that generated the data. VARCHAR2(30) Required
p_user_id   User who inserted or last updated the data. VARCHAR2(30)
p_internal_record_id   Database ROWID.  VARCHAR2(18) Required

p_validate 

Procedure p_validate(
      p_term_code          slrrmat.slrrmat_term_code%TYPE,
      p_oneup              slrrmat.slrrmat_oneup%TYPE,
      p_pidm               slrrmat.slrrmat_pidm%TYPE,
      p_accept_ind         slrrmat.slrrmat_accept_ind%TYPE DEFAULT NULL,
      p_data_origin        slrrmat.slrrmat_data_origin%TYPE DEFAULT NULL,
      p_user_id            slrrmat.slrrmat_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all the data in the record

Parameters
p_term_code   Term code associated with the roommate application.  VARCHAR2(6) Required key
p_oneup   Roommate sequence number of the roommate application. VARCHAR2(5) Required key
p_pidm   Internal identifier of the person who has a roommate application. NUMBER(8) Required key
p_accept_ind   Indicates whether the person and/or institution has accepted the person as a roommate. VARCHAR2(1)
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_user_id   User who inserted or last updated the data. VARCHAR2(30)