Call the Create Work Area API

To create a Work Area, call the API CDR_PUB_DF_WORKAREA.CREATEWORKAREA.

Its signature is:

PROCEDURE CREATEWORKAREA( 
     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_SOURCECDRNAMING       IN OUT    CDR_NAMING_VERSION_OBJ_TYPE, 
     PIO_WORKAREAOBJTYPE       IN OUT    CDR_WORKAREA_OBJ_TYPE, 
     PI_DEFCLASSIFICATIONCOLL  IN    CDR_CLASSIFICATIONS_COLL 
); 

Enter Parameter values as follows:

• PIO_SOURCECDRNAMING. Enter CDR_NAMING_VERSION_OBJ_TYPE values for the Work Area, as follows:
  • company_id = Enter_your_company_ID
  • obj_id = null
  • obj_ver = null
  • object_type_rc = '$OBJTYPES$WORKAREA'
  • name = 'Enter_a_name_for_the_Work_Area'
  • namespace_obj_id = 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_Work_Area'
  • 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_WORKAREAOBJTYPE. Enter CDR_WORKAREA_OBJ_TYPE values as follows:

  • company_id = Enter_your_company_ID
  • obj_id = null
  • obj_ver = 1
  • label = 'Standard'
  • workarea_status_rc =null
  • last_status_change_ts = sysdate
  • usage_intent_rc = '$SYSVALDNSTEPS$PRODUCTION'

    Note:

    If you set the Usage Intent to Production, you can still modify your source code and defined objects as necessary and reinstall the Work Area. Then when you have finished developing the adapter, if you want to upgrade all objects' validation status to Production, you can do so. If you prefer, set Usage Intent to Development now and use the API CDR_PUB_DF_WORKAREA.UPDATEUSAGEINTENT to change it to Production later.

    An Adapter Area can contain only one Work Area.

  • cloned_from_company_id = null
  • cloned_from_obj_id = null
  • cloned_from_obj_ver = null
  • wa_runtime_status_rc = null