Map a Table Descriptor to a Table Instance
Use this API to map a Table Descriptor to a Table instance. You specify the Table Descriptor and Table instance and the API maps the columns if it is possible.
Name
CDR_PUB_DF_MAPPING.AutoMapTableDesc
Signature
PROCEDURE AUTOMAPTABLEDESC( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_PRREFID IN CDR_PROGRAM_REFS.PRREF_ID%TYPE, PI_PRREFVER IN CDR_PROGRAM_REFS.PRREF_VER%TYPE, PI_TDOBJ IN CDR_NAMING_VERSION_OBJ_TYPE, PI_TIOBJ IN CDR_NAMING_VERSION_OBJ_TYPE );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_PRREFID (Mandatory) Enter the PRREF_ID of the executable object—Program, Load Set, Data Mart, Business Area that owns the Table Descriptor that you want to map. (Use other APIs in this package to get the PRREF_ID.)
- PI_PRREFVER (Mandatory) Enter the PRREF_VER of the executable object or Business Area that owns the Table Descriptors that you want to map. (Use other APIs in this package to get the PRREF_VER.)
- PI_TDOBJ (Mandatory) This is a parameter of table type
CDR_NAMING_VERSIONS_OBJ_TYPE that contains CDR Naming Version attributes. Enter values to
identify the Table Descriptor you want to map.
The required attributes are: COMPANY_ID, OBJ_ID, OBJ_VER.
- PI_TIOBJ (Mandatory) This is a parameter of table type
CDR_NAMING_VERSIONS_OBJ_TYPE that contains CDR Naming Version attributes. Enter values to
identify the Table instance to which you want to map the Table Descriptor.
The required attributes are: COMPANY_ID, OBJ_ID, OBJ_VER.
Parent topic: Create and Modify Mappings