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.