Accept Table Mappings
Use this API to create persistent Auto Maps by accepting the auto generated table and column transformation mappings created from dme_pub_xform_map.autoMapTables public API. User refers to DME_PUB_XFM_AUTOMAPS_V view to populate the attributes of input collection required as a parameter.
Name
DME_PUB_XFORM_MAP.AcceptTableAutoMappings
Signature
PROCEDURE ACCEPTTABLEAUTOMAPPINGS (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_TABLEAUTOMAPCOLL IN OUT NOCOPY DME_XFORM_AUTO_MAP_COLL );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PIO_TABLEAUTOMAPCOLL (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