Call the Create Table API

To create a Table definition, call the API CDR_PUB_DF_TABLE.CREATETABLEDEFINITION.

Enter parameter values as follows:

PROCEDURE CREATETABLEDEFINITION( 
  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, 
  PIO_NAMING           IN OUT      CDR_NAMING_VERSION_OBJ_TYPE, 
  PIO_TABLE            IN OUT      CDR_TABLE_OBJ_TYPE, 
  PI_INSTANCESUBTYPEID       IN    NUMBER, 
  PI_DEFCLASSIFICATIONCOLL   IN    CDR_CLASSIFICATIONS_COLL, 
  PI_INSTCLASSIFICATIONCOLL  IN    CDR_CLASSIFICATIONS_COLL 
); 

• PIO_NAMING. Enter CDR_NAMING_VERSION_OBJ_TYPE values that apply to the Program definition, as follows:
  • company_id = Enter_your_company_ID
  • obj_id = null
  • obj_ver = null
  • object_type_rc = '$OBJTYPES$TABLE'
  • name = 'Enter_a_name_for_the_Table'
  • namespace_obj_id = Enter_your_Adapter_Area's_obj_id
  • namespace_obj_ver = 1
  • namespace_start_obj_ver = 1
  • namespace_end_obj_ver= cdr_def_constants.cdr_max_def_object_version
  • owning_location_rc = null
  • checked_out_flag_rc = '$YESNO$NO'
  • checked_out_id = null
  • object_subtype_id = null
  • description = 'Enter_a_Description_for_the_Table'
  • copied_from_company_id = null
  • copied_from_obj_id = null
  • copied_from_obj_ver = null
  • ref_company_id = null
  • ref_obj_ver = null
  • object_version_number = 1
  • status_rc = '$NAMING_STATUS$INSTALLABLE'
  • validation_status_rc = null
  • version_label = null
• PI_TABLE. Enter CDR_TABLE_OBJ_TYPE values as follows:
  • company_id = Enter_your_company_ID
  • obj_id = null
  • obj_ver = 1
  • oracle_name = 'Enter_an_Oracle_name_for_the_Table'
  • sas_name = 'Enter_a_SAS_name_for_the_Table'
  • sas_label = 'Enter_a_SAS_label_for_the_Table'
  • sas_v6_flag = '$YESNO$YES' if you are using SAS v6 or '$YESNO$NO' if you are using a more recent SAS version
  • audit_tabc_company_id = null
  • audit_tabc_obj_id = null
  • audit_tabc_obj_ver = null
  • snapshot_flag_rc = 'set_to_$YESNO$YES_to_allow_snapshots or $YESNO$NO_prevent_them'
  • process_type_rc = Valid values are: $PROCESSTYPES$RELOAD (Reload), $PROCESSTYPES$STAGINGWAUDIT (Staging with Audit), $PROCESSTYPES$STAGINGWOAUDIT (Staging without Audit), $PROCESSTYPES$TRANSWOAUDIT (Transactional without Audit), $PROCESSTYPES$TRANSWAUDIT (Transactional with Audit)
  • blinding_flag_rc = Enter_$YESNO$YES_if_the_adapter_will_load_blinded_data_or_$YESNO$NO_if_it_will_not
• PI_INSTANCESUBTYPEID. Null
• PI_DEFCLASSIFICATIONCOLL. Null
• PI_INSTCLASSIFICATIONCOLL. Null