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.