Accept Column Mappings
Use this API to create persistent Auto Maps by accepting the auto generated column transformation mappings.
Name
DME_PUB_XFORM_MAP.AcceptColumnAutoMappings
Signature
PROCEDURE ACCEPTCOLUMNAUTOMAPPINGS (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_COLUMNAUTOMAPCOLL IN OUT NOCOPY DME_XFORM_AUTO_MAP_COLL );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
PIO_COLUMNAUTOMAPCOLL (Mandatory). This is a parameter of table type collection DME_XFORM_AUTO_MAP_COLL of DME_XFORM_AUTO_MAP_TYPE table type. All attributes are required including:
- COMPANY_ID
- MAP_ID
- MAP_VER
- MAP_ENTITY_ID
- MAP_ENTITY_VER
- CANDIDATE_FLAG_RC - with the possible values:
- $YESNO$YES
- $YESNO$NO - use this value for auto map suggestions which are applicable to save as real maps.
Parent topic: Create and Modify Transformation Maps