Get MappedTo Target Columns

Use this API to find all the target columns for particular source column in a table map.

Name

DME_PUB_XFORM_MAP.GetMappedToTargetColumns

Signature

PROCEDURE GetMappedToTargetColumns (
  p_api_version IN NUMBER,
  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,
  p_companyId  in cdr_namings.company_id%type,
  pi_tabMapId  in cdr_namings.obj_id%type,
  pi_tabMapVer in cdr_naming_versions.obj_ver%type,
  pi_columnId  in cdr_namings.obj_id%type,
  pi_columnVer in cdr_naming_versions.obj_ver%type,
  po_targetColumnsColl                OUT NOCOPY  dme_char_coll
);

Parameters

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

• P_COMPANYID (Mandatory). Enter the company ID of the object.
• PI_TABMAPID (Mandatory). Enter the table map object ID.
• PI_TABMAPVER (Mandatory). Enter the table map object version.
• PI_COLUMNID (Mandatory). Enter the column object ID.
• PI_COLUMNVER (Mandatory). Enter the column object version.
• PO_TARGETCOLUMNSCOLL. Output collection of target columns in the format of Model_NAME.Table_NAME.Column_NAME.