index

Package gb_bldgdefinition_rules

This package provides support subprograms for the Building Definition API (gb_bldgdefinition).

Program units
p_register_entity   Registers the attribute/value pairs to the message cache for delete operations.
p_register_entity   Register 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 for registering 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          slbbldg.slbbldg_bldg_code%TYPE,
                            p_camp_code          slbbldg.slbbldg_camp_code%TYPE,
                            p_capacity           slbbldg.slbbldg_capacity%TYPE,
                            p_maximum_capacity   slbbldg.slbbldg_maximum_capacity%TYPE,
                            p_rrcd_code          slbbldg.slbbldg_rrcd_code%TYPE,
                            p_prcd_code          slbbldg.slbbldg_prcd_code%TYPE,
                            p_site_code          slbbldg.slbbldg_site_code%TYPE,
                            p_street_line1       slbbldg.slbbldg_street_line1%TYPE,
                            p_street_line2       slbbldg.slbbldg_street_line2%TYPE,
                            p_street_line3       slbbldg.slbbldg_street_line3%TYPE,
                            p_city               slbbldg.slbbldg_city%TYPE,
                            p_stat_code          slbbldg.slbbldg_stat_code%TYPE,
                            p_zip                slbbldg.slbbldg_zip%TYPE,
                            p_cnty_code          slbbldg.slbbldg_cnty_code%TYPE,
                            p_phone_area         slbbldg.slbbldg_phone_area%TYPE,
                            p_phone_number       slbbldg.slbbldg_phone_number%TYPE,
                            p_phone_extension    slbbldg.slbbldg_phone_extension%TYPE,
                            p_sex                slbbldg.slbbldg_sex%TYPE,
                            p_coll_code          slbbldg.slbbldg_coll_code%TYPE,
                            p_dept_code          slbbldg.slbbldg_dept_code%TYPE,
                            p_key_number         slbbldg.slbbldg_key_number%TYPE,
                            p_pars_code          slbbldg.slbbldg_pars_code%TYPE,
                            p_data_origin        slbbldg.slbbldg_data_origin%TYPE,
                            p_user_id            slbbldg.slbbldg_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_ctry_code_phone    slbbldg.slbbldg_ctry_code_phone%TYPE,
                            p_house_number       slbbldg.slbbldg_house_number%TYPE,
                            p_street_line4       slbbldg.slbbldg_street_line4%TYPE,
                            p_internal_record_id VARCHAR2)

Register 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 operation for registering entity.  NUMBER Required
p_bldg_code   Building code associated with the building record. VARCHAR2(6) Required Key
p_camp_code   Campus in which the building is located.  VARCHAR2(3) Required
p_capacity   Capacity of the building.  NUMBER(5) Required
p_maximum_capacity   Maximum capacity of the building. NUMBER(5) Required
p_rrcd_code   Default room rate for all rooms defined for the building.  VARCHAR2(4) Required
p_prcd_code   Default phone rate for all rooms defined for the building.  VARCHAR2(4) Required
p_site_code   Site of the building.  VARCHAR2(3) Required
p_street_line1   First street line for the address of the building.  VARCHAR2(75) Required
p_street_line2   Second street line of the address of the building.  VARCHAR2(75) Required
p_street_line3   Third street line of the address of the building.  VARCHAR2(75) Required
p_city   City where the building is located.  VARCHAR2(20) Required
p_stat_code   State or province code of the building's address. Validated against the STVSTAT table.  VARCHAR2(3) Required
p_zip   ZIP code of the building.  VARCHAR2(10) Required
p_cnty_code   County code of the building.  VARCHAR2(5) Required
p_phone_area   Area code of the phone number for the building.  VARCHAR2(6) Required
p_phone_number   Phone number for the building.  VARCHAR2(12) Required
p_phone_extension   Phone extension of the phone number for the building.  VARCHAR2(10) Required
p_sex   Gender associated with the building.  VARCHAR2(1) Required
p_coll_code   College associated with the building.  VARCHAR2(2) Required
p_dept_code   Department that is associated with the building.  VARCHAR2(4) Required
p_key_number   Number of the key to the building.  VARCHAR2(5) Required
p_pars_code   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_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.   VARCHAR2(30) Required
p_house_number   Building number in a street or area.  VARCHAR2(10) Required
p_ctry_code_phone   Telephone code designating the region and country  VARCHAR2(4) Required
p_street_line4   Fourth street line of the address of the building.  VARCHAR2(75) Required
p_internal_record_id   Database ROWID.  VARCHAR2(18) Required

p_validate 

PROCEDURE p_validate(p_bldg_code        slbbldg.slbbldg_bldg_code%TYPE,
                     p_camp_code        slbbldg.slbbldg_camp_code%TYPE,
                     p_capacity         slbbldg.slbbldg_capacity%TYPE,
                     p_maximum_capacity slbbldg.slbbldg_maximum_capacity%TYPE DEFAULT NULL,
                     p_rrcd_code        slbbldg.slbbldg_rrcd_code%TYPE DEFAULT NULL,
                     p_prcd_code        slbbldg.slbbldg_prcd_code%TYPE DEFAULT NULL,
                     p_site_code        slbbldg.slbbldg_site_code%TYPE DEFAULT NULL,
                     p_street_line1     slbbldg.slbbldg_street_line1%TYPE DEFAULT NULL,
                     p_street_line2     slbbldg.slbbldg_street_line2%TYPE DEFAULT NULL,
                     p_street_line3     slbbldg.slbbldg_street_line3%TYPE DEFAULT NULL,
                     p_city             slbbldg.slbbldg_city%TYPE DEFAULT NULL,
                     p_stat_code        slbbldg.slbbldg_stat_code%TYPE DEFAULT NULL,
                     p_zip              slbbldg.slbbldg_zip%TYPE DEFAULT NULL,
                     p_cnty_code        slbbldg.slbbldg_cnty_code%TYPE DEFAULT NULL,
                     p_phone_area       slbbldg.slbbldg_phone_area%TYPE DEFAULT NULL,
                     p_phone_number     slbbldg.slbbldg_phone_number%TYPE DEFAULT NULL,
                     p_phone_extension  slbbldg.slbbldg_phone_extension%TYPE DEFAULT NULL,
                     p_sex              slbbldg.slbbldg_sex%TYPE DEFAULT NULL,
                     p_coll_code        slbbldg.slbbldg_coll_code%TYPE DEFAULT NULL,
                     p_dept_code        slbbldg.slbbldg_dept_code%TYPE DEFAULT NULL,
                     p_key_number       slbbldg.slbbldg_key_number%TYPE DEFAULT NULL,
                     p_pars_code        slbbldg.slbbldg_pars_code%TYPE DEFAULT NULL,
                     p_data_origin      slbbldg.slbbldg_data_origin%TYPE DEFAULT NULL,
                     p_user_id          slbbldg.slbbldg_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_ctry_code_phone  slbbldg.slbbldg_ctry_code_phone%TYPE DEFAULT NULL,
                     p_house_number     slbbldg.slbbldg_house_number%TYPE DEFAULT NULL,
                     p_street_line4     slbbldg.slbbldg_street_line4%TYPE DEFAULT NULL)

Validates all the data in the record.

Parameters
p_bldg_code   Building code associated with the building record.  VARCHAR(6) Required Key
p_camp_code   Campus in which the building is located.  VARCHAR2(3) Required
p_capacity   Capacity of the building.  NUMBER(5) Required
p_maximum_capacity   Maximum capacity of the building. NUMBER(5)
p_rrcd_code   Default room rate for all rooms defined for the building.  VARCHAR2(4)
p_prcd_code   Default phone rate for all rooms defined for the building.  VARCHAR2(4)
p_site_code   Site of the building.  VARCHAR2(3)
p_street_line1   First street line for the address of the building.  VARCHAR2(75)
p_street_line2   Second street line of the address of the building.  VARCHAR2(75)
p_street_line3   Third street line of the address of the building.  VARCHAR2(75)
p_city   City where the building is located.  VARCHAR2(20)
p_stat_code   State or province code of the building's address. Validated against the STVSTAT table.  VARCHAR2(3)
p_zip   ZIP code of the building.  VARCHAR2(10)
p_cnty_code   County code of the building.  VARCHAR2(5)
p_phone_area   Area code of the phone number for the building.  VARCHAR2(6)
p_phone_number   Phone number for the building.  VARCHAR2(12)
p_phone_extension   Phone extension of the phone number for the building.  VARCHAR2(10)
p_sex   Gender associated with the building.  VARCHAR2(1)
p_coll_code   College that is associated with the building.  VARCHAR2(2)
p_dept_code   Department that is associated with the building.  VARCHAR2(4)
p_key_number   Number of the key to the building.  VARCHAR2(5)
p_pars_code   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_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.  Default Oracle id.  VARCHAR2(30)
p_house_number   Building number in a street or area.  VARCHAR2(10) Required
p_ctry_code_phone   Telephone code designating the region and country  VARCHAR2(4) Required
p_street_line4   Fourth street line of the address of the building.  VARCHAR2(75) Required