index

Package ab_donor_category_rules

This Package provides the messaging support and field validation for DONOR CATEGORY
 
The validation procedure is called by the API, but may be called directly by an application if data validation is needed prior to calling the API.
Regardless, the API will always run the validation checks.

Program units
p_register_entity   Registers the attribute/value pairs to the message cache.
p_register_entity   Registers the attribute/value pairs to the message cache.
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.
This procedure passes the operation type and a set of constant strings and data values to the messaging system. The constants represent the name of each data element and are defined in the DML package specification.
The procedure is overloaded so the API p_delete has a signature to call that only requires operation and ROWID.
This signature uses the ROWID only, for the delete operations.

Parameters
p_internal_record_id   Database ROWID

p_register_entity 

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_pidm               aprcatg.aprcatg_pidm%TYPE,
                            p_donr_code          aprcatg.aprcatg_donr_code%TYPE,
                            p_data_origin        aprcatg.aprcatg_data_origin%TYPE,
                            p_user_id            aprcatg.aprcatg_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 uses all fields for the create operation.

Parameters
p_pidm   Internal system-generated identification number. NUMBER(8) Required Key
p_donr_code   Constituent donor classification(s).  Allows the institution to classify a constituent in multiple categories. VARCHAR2(4) Required Key
p_data_origin   Source system that generated or updated the data. VARCHAR2(30)
p_user_id   User who inserted or last updated the data. VARCHAR2(30)
p_internal_record_id   Database ROWID of record created. VARCHAR2(18)

p_validate 

Procedure p_validate(p_pidm        aprcatg.aprcatg_pidm%TYPE,
                     p_donr_code   aprcatg.aprcatg_donr_code%TYPE,
                     p_data_origin aprcatg.aprcatg_data_origin%TYPE DEFAULT NULL,
                     p_user_id     aprcatg.aprcatg_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all the data in the record.
 
The following edits are performed. All failed edit messages are appended and issued in a single application exception.


Parameters
p_pidm   Internal system-generated identification number. NUMBER(8) Required Key
p_donr_code   Constituent donor classification(s).  Allows the institution to classify a constituent in multiple categories. VARCHAR2(4) Required Key
p_data_origin   Source system that generated or updated the data. VARCHAR2(30)
p_user_id   User who inserted or last update the data. VARCHAR2(30)