index

Package gb_cm_user_setup_rules

This package provides support subprograms for Common Matching User Setup Rules

Program units
p_register_entity   Registers the attribute/value pairs to the message cache for delete operations.
p_register_entity  
p_validate   Validates all the data in the record
f_validate_cmsc_cde_option   Validates that if the cmsc option indicator is 'N', then the cmsc_code is not null.
f_validate_cm_user   Validates if the user exists in GURTPRF

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

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_cm_user_id         gobcmus.gobcmus_cm_user_id%TYPE,
                            p_cmsc_option_ind    gobcmus.gobcmus_cmsc_option_ind%TYPE,
                            p_exclude_ind        gobcmus.gobcmus_exclude_ind%TYPE,
                            p_user_id            gobcmus.gobcmus_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_cmsc_code          gobcmus.gobcmus_cmsc_code%TYPE,
                            p_data_origin        gobcmus.gobcmus_data_origin%TYPE,
                            p_internal_record_id VARCHAR2)

p_validate 

PROCEDURE p_validate(p_cm_user_id      gobcmus.gobcmus_cm_user_id%TYPE,
                     p_cmsc_option_ind gobcmus.gobcmus_cmsc_option_ind%TYPE,
                     p_exclude_ind     gobcmus.gobcmus_exclude_ind%TYPE,
                     p_user_id         gobcmus.gobcmus_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_cmsc_code       gobcmus.gobcmus_cmsc_code%TYPE DEFAULT NULL,
                     p_data_origin     gobcmus.gobcmus_data_origin%TYPE DEFAULT NULL)

Validates all the data in the record
 
The following edits are performed.


Parameters
p_cm_user_id   User ID associated with these rules for Common Matching process when creating a new person or non-person record from a form. VARCHAR2(30) Required Key
p_cmsc_option_ind   Common Matching option indicator. Controls whether user ID may select different Common Matching Source codes for on-line processing. VARCHAR2(1) Required
Y   The user may select different codes.
N   The user may not select different codes.

p_exclude_ind   Exclude indicator. Controls whether the user ID has been excluded from the Common Matching process on-line.  VARCHAR2(1) Required
Y   The user ID has been excluded.
N   The user ID has not been excluded.

p_user_id   User ID of the User who created or last updated the record. VARCHAR2(30) Required
p_cmsc_code   Source code and associated rules to use as preference for user ID when Common Matching is run on-line from a form. VARCHAR2(20)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)

f_validate_cmsc_cde_option 

FUNCTION f_validate_cmsc_cde_option(p_cmsc_option_ind gobcmus.gobcmus_cmsc_option_ind%TYPE,
                                    p_cmsc_code       gobcmus.gobcmus_cmsc_code%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Validates that if the cmsc option indicator is 'N', then the cmsc_code is not null.

Parameters
p_cmsc_option_ind   Common Matching option indicator. Controls whether user ID may select different Common Matching Source codes for on-line processing. VARCHAR2(1) Required
Y   The user may select different codes.
N   The user may not select different codes.

p_cmsc_code   Source code and associated rules to use as preference for user ID when Common Matching is run online from a form. VARCHAR2(20,

f_validate_cm_user 

FUNCTION f_validate_cm_user(p_cm_user_id gobcmus.gobcmus_cm_user_id%TYPE)
  RETURN VARCHAR2

Validates if the user exists in GURTPRF

Parameters
p_cm_user_id   User ID