index

Package gb_cm_source_rules_rules

This package provides support subprograms for Common Matching Source Rules API (gb_cm_source_rules).
 
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.
The API will always run the validation checks regardless.

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 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_operation_type   Type of DML operation: create, update, or delete. NUMBER Required
p_internal_record_id   Database ROWID

p_register_entity 

PROCEDURE p_register_entity(p_operation_type      NUMBER,
                            p_cmsc_code           gorcmsc.gorcmsc_cmsc_code%TYPE,
                            p_online_match_ind    gorcmsc.gorcmsc_online_match_ind%TYPE,
                            p_entity_cde          gorcmsc.gorcmsc_entity_cde%TYPE,
                            p_user_id             gorcmsc.gorcmsc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_atyp_code           gorcmsc.gorcmsc_atyp_code%TYPE,
                            p_tele_code           gorcmsc.gorcmsc_tele_code%TYPE,
                            p_emal_code           gorcmsc.gorcmsc_emal_code%TYPE,
                            p_data_origin         gorcmsc.gorcmsc_data_origin%TYPE,
                            p_transpose_date_ind  gorcmsc.gorcmsc_transpose_date_ind%TYPE,
                            p_transpose_name_ind  gorcmsc.gorcmsc_transpose_name_ind%TYPE,
                            p_alias_wildcard_ind  gorcmsc.gorcmsc_alias_wildcard_ind%TYPE,
                            p_length_override_ind gorcmsc.gorcmsc_length_override_ind%TYPE,
                            p_api_failure_ind     gorcmsc.gorcmsc_api_failure_ind%TYPE,
                            p_internal_record_id  VARCHAR2)

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

Parameters
p_operation_type   Type of DML operation: create, update, or delete. NUMBER Required
p_cmsc_code   Common Matching Source Code associated with these rules.
p_online_match_ind   Indicates if Source Code and associated rules (GOBCMSR) will be used for Common Matching when run online from a form.
p_entity_cde   Entity Code. Defines what entity type to match when selecting SPRIDEN records.
P   The Source will be matching a person.
C   The Source will be matching a non person.
B   The Source will be matching both a person and non person.

p_user_id   User ID of the User who created or last updated the record.
p_atyp_code   Address type to use when creating a new address record for this source.
p_tele_code   Telephone type code to use when creating a new telephone record for this source.
p_emal_code   E-mail type code to use when creating a new email record for this source.
p_data_origin   Application source for this database row.
p_transpose_date_ind   Option to allow birthdate day / month to be additionally checked in month / day combination to improve matching.
Y   Allow date transposition.
N   Do not allow date transposition.

p_transpose_name_ind   Option to allow First Name / Last Name to be additionally checked in Last Name / First Name combination to improve matching.
Y   Allow name transposition.
N   Do not allow name transposition.

p_alias_wildcard_ind   Option to allow use of wildcard searching in person and non-person name alias lookups.
Y   Allow wildcard searching.
N   Do not allow wildcard searching.

p_length_override_ind   Option to allow length of data entered to override lenght provided on rule is the length of data enetered is less than rule length.
Y   Allow length override.
N   Do not allow length override.

p_api_failure_ind   Indicates whether or not the creation of an ID is allowed if any API fails in the Create ID process.
Y   Continue to create the ID.
N   Do not create the ID.

p_internal_record_id   Database ROWID

p_validate 

PROCEDURE p_validate(p_cmsc_code           gorcmsc.gorcmsc_cmsc_code%TYPE,
                     p_online_match_ind    gorcmsc.gorcmsc_online_match_ind%TYPE,
                     p_entity_cde          gorcmsc.gorcmsc_entity_cde%TYPE,
                     p_user_id             gorcmsc.gorcmsc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_atyp_code           gorcmsc.gorcmsc_atyp_code%TYPE DEFAULT NULL,
                     p_tele_code           gorcmsc.gorcmsc_tele_code%TYPE DEFAULT NULL,
                     p_emal_code           gorcmsc.gorcmsc_emal_code%TYPE DEFAULT NULL,
                     p_data_origin         gorcmsc.gorcmsc_data_origin%TYPE DEFAULT NULL,
                     p_transpose_date_ind  gorcmsc.gorcmsc_transpose_date_ind%TYPE,
                     p_transpose_name_ind  gorcmsc.gorcmsc_transpose_name_ind%TYPE,
                     p_alias_wildcard_ind  gorcmsc.gorcmsc_alias_wildcard_ind%TYPE,
                     p_length_override_ind gorcmsc.gorcmsc_length_override_ind%TYPE,
                     p_api_failure_ind     gorcmsc.gorcmsc_api_failure_ind%TYPE)

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_cmsc_code   Common Matching Source Code associated with these rules.
p_online_match_ind   Indicates if Source Code and associated rules (GOBCMSR) will be used for Common Matching when run online from a form.
p_entity_cde   Entity Code. Defines what entity type to match when selecting SPRIDEN records.
P   The Source will be matching a person.
C   The Source will be matching a non person.
B   The Source will be matching both a person and non person.

p_user_id   Oracle user ID of the User who created or last updated the record.
p_atyp_code   Address type to use when creating a new address record for this source.
p_tele_code   Telephone type code to use when creating a new telephone record for this source.
p_emal_code   E-mail type code to use when creating a new email record for this source.
p_data_origin   Application source for this database row.
p_transpose_date_ind   Option to allow birthdate day / month to be additionally checked in month / day combination to improve matching.
Y   Allow date transposition.
N   Do not allow date transposition.

p_transpose_name_ind   Option to allow First Name / Last Name to be additionally checked in Last Name / First Name combination to improve matching.
Y   Allow name transposition.
N   Do not allow name transposition.

p_alias_wildcard_ind   Option to allow use of wildcard searching in person and non-person name alias lookups.
Y   Allow wildcard searching.
N   Do not allow wildcard searching.

p_length_override_ind   Option to allow length of data entered to override lenght provided on rule is the length of data enetered is less than rule length.
Y   Allow length override.
N   Do not allow length override.

p_api_failure_ind   Indicates whether or not the creation of an ID is allowed if any API fails in the Create ID process.
Y   Continue to create the ID.
N   Do not create the ID.