index

Package gb_roomdefinition_rules

This package provides support subprograms for the Room Definition API (gb_roomdefinition).

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 all the data in the record

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id VARCHAR2)

Registers the attribute/value pairs to the message cache for delete operations.
This signature uses the ROWID only for the delete operations.

Parameters
p_operation_type   Type of operation to be performed for registering the entity.  NUMBER Required
p_internal_record_id   Database ROWID.  VARCHAR2(18) Required

p_register_entity 

PROCEDURE p_register_entity(p_operation_type      NUMBER,
                            p_bldg_code           slbrdef.slbrdef_bldg_code%TYPE,
                            p_room_number         slbrdef.slbrdef_room_number%TYPE,
                            p_desc                slbrdef.slbrdef_desc%TYPE,
                            p_capacity            slbrdef.slbrdef_capacity%TYPE,
                            p_maximum_capacity    slbrdef.slbrdef_maximum_capacity%TYPE,
                            p_rmst_code           slbrdef.slbrdef_rmst_code%TYPE,
                            p_rrcd_code           slbrdef.slbrdef_rrcd_code%TYPE,
                            p_prcd_code           slbrdef.slbrdef_prcd_code%TYPE,
                            p_utility_rate        slbrdef.slbrdef_utility_rate%TYPE,
                            p_utility_rate_period slbrdef.slbrdef_utility_rate_period%TYPE,
                            p_phone_area          slbrdef.slbrdef_phone_area%TYPE,
                            p_phone_number        slbrdef.slbrdef_phone_number%TYPE,
                            p_phone_extension     slbrdef.slbrdef_phone_extension%TYPE,
                            p_bcat_code           slbrdef.slbrdef_bcat_code%TYPE,
                            p_sex                 slbrdef.slbrdef_sex%TYPE,
                            p_room_type           slbrdef.slbrdef_room_type%TYPE,
                            p_priority            slbrdef.slbrdef_priority%TYPE,
                            p_coll_code           slbrdef.slbrdef_coll_code%TYPE,
                            p_dept_code           slbrdef.slbrdef_dept_code%TYPE,
                            p_key_number          slbrdef.slbrdef_key_number%TYPE,
                            p_width               slbrdef.slbrdef_width%TYPE,
                            p_length              slbrdef.slbrdef_length%TYPE,
                            p_area                slbrdef.slbrdef_area%TYPE,
                            p_term_code_eff       slbrdef.slbrdef_term_code_eff%TYPE,
                            p_pars_code           slbrdef.slbrdef_pars_code%TYPE,
                            p_ctry_code_phone     slbrdef.slbrdef_ctry_code_phone%TYPE,
                            p_internal_record_id  VARCHAR2)

Registers the attribute/value pairs to the message cache for create and update operations.
This signature registers all of the parameters.

Parameters
p_bldg_code   Building code associated with the room.  VARCHAR2(6) Required key
p_room_number   Room number associated with the room.  VARCHAR2(6) Required key
p_desc   Description associated with the room.  VARCHAR2(50) Required
p_capacity   Capacity of the room.   NUMBER(5) Required
p_maximum_capacity   Maximum capacity of the room.  NUMBER(5) Required
p_rmst_code   Status code associated with the room. VARCHAR2(2) Required
p_rrcd_code   Room rate code associated with the room.  VARCHAR2(4) Required
p_prcd_code   Phone rate code associated with the room.  VARCHAR2(4) Required
p_utility_rate   Utility rate associated with the room.  NUMBER(9) Required
p_utility_rate_period   Time period for which the utility rate is associated with the room.  VARCHAR2(2) Required
p_phone_area   Area code of the room.  VARCHAR2(3) Required
p_phone_number   Phone number of the room. VARCHAR2(7) Required
p_phone_extension   Phone extension number of the room.  VARCHAR2(4) Required
p_bcat_code   Building category associated with the room. VARCHAR2(4) Required
p_sex   Gender associated with the room. VARCHAR2(1) Required
p_room_type   Room type of the building, for example, dorm, class, or other.  VARCHAR2(1) Required
p_priority   Priority of the room, used by the scheduler to determine which rooms are used first. VARCHAR2(8) Required
p_coll_code   College associated with the room.  VARCHAR2(2) Required
p_dept_code   Department associated with the room.  VARCHAR2(4) Required
p_key_number   Number of the key to the room.  VARCHAR2(5) Required
p_width   Width, in feet, of the room.  NUMBER(8) Required
p_length   Length, in feet, of the room.  NUMBER(8) Required
p_area   Area, in square feet, of the room.  NUMBER(12) Required
p_term_code_eff   Term code effective date.  VARCHAR2(6) Required key
p_pars_code   Partition code associated with the room. Partition codes define campus zones, which are categories or groupings of rooms. Partitions can be defined on buildings, rooms, subjects, courses and sections. VARCHAR2(7) Required
p_ctry_code_phone   Telephone code designating the region and country  VARCHAR2(4) Required
p_rowid   Database ROWID of the record to be updated.  VARCHAR2(18) Required

p_validate 

PROCEDURE p_validate(p_bldg_code           slbrdef.slbrdef_bldg_code%TYPE,
                     p_room_number         slbrdef.slbrdef_room_number%TYPE,
                     p_desc                slbrdef.slbrdef_desc%TYPE DEFAULT NULL,
                     p_capacity            slbrdef.slbrdef_capacity%TYPE,
                     p_maximum_capacity    slbrdef.slbrdef_maximum_capacity%TYPE DEFAULT NULL,
                     p_rmst_code           slbrdef.slbrdef_rmst_code%TYPE DEFAULT NULL,
                     p_rrcd_code           slbrdef.slbrdef_rrcd_code%TYPE DEFAULT NULL,
                     p_prcd_code           slbrdef.slbrdef_prcd_code%TYPE DEFAULT NULL,
                     p_utility_rate        slbrdef.slbrdef_utility_rate%TYPE DEFAULT NULL,
                     p_utility_rate_period slbrdef.slbrdef_utility_rate_period%TYPE DEFAULT NULL,
                     p_phone_area          slbrdef.slbrdef_phone_area%TYPE DEFAULT NULL,
                     p_phone_number        slbrdef.slbrdef_phone_number%TYPE DEFAULT NULL,
                     p_phone_extension     slbrdef.slbrdef_phone_extension%TYPE DEFAULT NULL,
                     p_bcat_code           slbrdef.slbrdef_bcat_code%TYPE DEFAULT NULL,
                     p_sex                 slbrdef.slbrdef_sex%TYPE DEFAULT NULL,
                     p_room_type           slbrdef.slbrdef_room_type%TYPE,
                     p_priority            slbrdef.slbrdef_priority%TYPE DEFAULT NULL,
                     p_coll_code           slbrdef.slbrdef_coll_code%TYPE DEFAULT NULL,
                     p_dept_code           slbrdef.slbrdef_dept_code%TYPE DEFAULT NULL,
                     p_key_number          slbrdef.slbrdef_key_number%TYPE DEFAULT NULL,
                     p_width               slbrdef.slbrdef_width%TYPE DEFAULT NULL,
                     p_length              slbrdef.slbrdef_length%TYPE DEFAULT NULL,
                     p_area                slbrdef.slbrdef_area%TYPE DEFAULT NULL,
                     p_term_code_eff       slbrdef.slbrdef_term_code_eff%TYPE,
                     p_pars_code           slbrdef.slbrdef_pars_code%TYPE DEFAULT NULL,
                     p_ctry_code_phone     slbrdef.slbrdef_ctry_code_phone%TYPE DEFAULT NULL)

Validates all the data in the record

Parameters
p_bldg_code   Building code associated with the room.  VARCHAR2(6) Required key
p_room_number   Room number associated with the room.  VARCHAR2(6) Required key
p_desc   Description associated with the room.  VARCHAR2(50)
p_capacity   Capacity of the room.   NUMBER(5) Required
p_maximum_capacity   Maximum capacity of the room.  NUMBER(5)
p_rmst_code   Status code associated with the room. VARCHAR2(2)
p_rrcd_code   Room rate code associated with the room.  VARCHAR2(4)
p_prcd_code   Phone rate code associated with the room.  VARCHAR2(4)
p_utility_rate   Utility rate associated with the room.  NUMBER(9)
p_utility_rate_period   Time period for which the utility rate is associated with the room.  VARCHAR2(2)
p_phone_area   Area code of the room.  VARCHAR2(3)
p_phone_number   Phone number of the room. VARCHAR2(7)
p_phone_extension   Phone extension number of the room.  VARCHAR2(4)
p_bcat_code   Building category associated with the room. VARCHAR2(4)
p_sex   Gender associated with the room. VARCHAR2(1)
p_room_type   Room type of the building, for example, dorm, class, or other.  VARCHAR2(1) Required
p_priority   Priority of the room, used by the scheduler to determine which rooms are used first. VARCHAR2(8)
p_coll_code   College associated with the room.  VARCHAR2(2)
p_dept_code   Department associated with the room.  VARCHAR2(4)
p_key_number   Number of the key to the room.  VARCHAR2(5)
p_width   Width, in feet, of the room.  NUMBER(8)
p_length   Length, in feet, of the room.  NUMBER(8)
p_area   Area, in square feet, of the room.  NUMBER(12)
p_term_code_eff   Term code effective date.  VARCHAR2(6) Required key
p_pars_code   Partition code associated with the room. Partition codes define campus zones, which are categories or groupings of rooms. Partitions can be defined on buildings, rooms, subjects, courses and sections. VARCHAR2(7)
p_ctry_code_phone   Telephone code designating the region and country  VARCHAR2(4) Required