Create a Table Instance from a Table Descriptor
Use this API to create a Table instance from a Table Descriptor and map the two.
Name
CDR_PUB_DF_MAPPING.CreateTabInstFromTabDesc
Signature
PROCEDURE CREATETABINSTFROMTABDESC( 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_INSTANCESUBTYPEID IN CDR_NAMINGS.OBJECT_SUBTYPE_ID%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 instance—Program, Load Set, Data Mart, OR Business Area instance that owns the Table Descriptors that you want to map. (Use other APIs in this package to get this value.)
- PI_PRREFVER (Mandatory) Enter the PRREF_VER of the executable object instance or Business Area instance that owns the Table Descriptors that you want to map. (Use other APIs in this package to get this value.)
- PI_TDOBJ (Mandatory) This is a parameter of table type
CDR_NAMING_VERSIONS_OBJ_TYPE that contains CDR Naming Version attributes.
Enter values for the Table Descriptor from which you want to create a Table Descriptor. The required attributes are: COMPANY_ID, OBJ_ID, OBJ_VER.
- PI_INSTANCESUBTYPEID (Mandatory) Enter a value for the Table instance's subtype.
Parent topic: Create and Modify Mappings