Modify a Constraint in a Clinical Data Model Table

Use this API to modify an existing constraint.

Name

DME_PUB_DF_DATA_MODEL.ModifyConsInDataModelTab

Signature

procedure ModifyConsInDataModelTab(p_api_version 	IN NUMBER
p_init_msg_list 	IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE
p_commit 		IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE
p_validation_level 	IN NUMBER default CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL
x_return_status 	OUT NOCOPY VARCHAR2
x_msg_count 		OUT NOCOPY NUMBER
x_msg_data 		OUT NOCOPY VARCHAR2
pio_naming 		IN OUT NOCOPY cdr_naming_version_obj_type
pio_constraint 	IN OUT NOCOPY cdr_dm_tab_cons_obj_type
pi_constraintColumns IN OUT NOCOPY cdr_table_concols_list_coll
pi_vals IN cdr_vals_coll );

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PIO_NAMING (Mandatory): Enter values for the constraint. This is a parameter of type CDR_NAMING_VERSION_OBJ_TYPE.
• PIO_CONSTRAINT(Mandatory): This is a parameter of type CDR_DM_TAB_CONS_OBJ_TYPE. Enter current or modified values for the constraint as required.
• PI_VALS. This is a parameter of type CDR_VALS_COLL that is based on CDR_VAL_OBJ_TYPE type. Enter current or modified values for a check constraint as required.