Create a Table Descriptor

Use this API to create a Table Descriptor. Table Descriptors are owned by executable object definitions and Business Area definitions and are required to map to source and target Table instances. You must check out the parent object to create a Table Descriptor.

Name

CDR_PUB_DF_TABLE.CreateTableDescriptor

Signature

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
, pio_naming IN OUT NOCOPY cdr_naming_version_obj_type
, pio_table_descriptor IN OUT NOCOPY cdr_table_desc_obj_type
, pi_createType IN VARCHAR2
, pi_instanceSubTypeId IN NUMBER
, pi_defClassificationColl IN CDR_CLASSIFICATIONS_COLL
, pi_InstClassificationColl IN CDR_CLASSIFICATIONS_COLL
) ;

Parameters

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

• PIO_NAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSION_OBJ_TYPE. Enter values to identify the Table Descriptor and enter new values for the attributes you want to create. All attributes are required. See CDR Naming Version Object Type. For OBJECT_TYPE_RC enter $OBJTYPES$TABLEDESCRIPTOR.

  If you are creating a Table Descriptor from an existing Table definition, enter values for the table definition in the CDR naming attributes. REF_COMPANY_ID, REF_OBJ_ID, REF_OBJ_VER.

  If you are creating a new Table definition, leave these attributes blank.

• PIO_TABLE_DESCRIPTOR (Mandatory) This is a parameter of table type CDR_TABLE_OBJ_TYPE that contains attributes specific to Table Descriptors, including:
  • LIBREF: Enter Target or Source.
  • TARGET_OPER_FLAG_RC: Enter $YESNO$YES
  • TARGET_AS_DATASET_FLAG_RC: Enter $YESNO$NO
  • PROCESS_TYPE_RC: Enter $PROCESSTYPES$STAGINGWAUDIT
  • REVEAL_AUDIT_FLAG_RC: Enter $PROCESSTYPES$STAGINGWAUDIT
  • SEQ: Enter 1.
• PI_CREATETYPE (Mandatory)
  • Enter INST to create a Table instance of an existing Table definition.
  • Enter BOTH to create a Table definition and a Table instance of it.
• PI_INSTANCESUBTYPEID (Mandatory) Enter NULL.
• PI_DEFCLASSIFICATIONCOLL (Optional) To inherit its classifications for a particular level from its parent, enter the classification level ID and, for the CLASSIFICATION_ID, enter 0 (zero). The PAR_ attributes are not relevant. Do not enter any values for them.

  Or enter NULL.

• PI_INSTCLASSIFICATIONCOLL (Mandatory) Enter NULL because you are creating a Table definition.