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.