Update Validation Status

Use this API to modify the validation status.

Name

DME_PUB_XFORM_MAP.UpdateValStatus

Signature

PROCEDURE UPDATEVALSTATUS
(P_API_VERSION IN VARCHAR2,   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
);

Parameters

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

PIO_NAMING (Mandatory). This is a parameter of table type CDR_NAMING_VERSION_OBJ_TYPE. All attributes are required including:

• COMPANY_ID
• OBJ_ID
• OBJ_VER
• NAMESPACE_OBJ_ID
• NAMESPACE_OBJ_VER
• OBJECT_TYPE_RC
• CHECKED_OUT_FLAG_RC
• VALIDATION_STATUS_RC

The new validation status should be assigned to field VALIDATION_STATUS_RC. The possible valid values for validation status are:

• $SYSVALDNSTEPS$DEVELOPMENT
• $SYSVALDNSTEPS$QUALITYCONTROL
• $SYSVALDNSTEPS$PRODUCTION
• $SYSVALDNSTEPS$RETIRED