Get a Table Instance ID

Use this API to get the Object ID of the table instance that is mapped to a particular table descriptor. You can invoke this function within a PLSQL program.

While transforming source data into target data in Oracle Health Sciences Data Management Workbench (DMW), it is needed at times, to flag target data. The DMW API used to assign flags to target data requires the Obj ID of the Table Instance as input. This API performs the task of getting the required Obj ID of the target Table Instance, in order that the Flag-related DMW APIs can be invoked.

Name

CDR_PUB_DF_MAPPING.Get_Tab_Inst_ID

Signature

FUNCTION GETTABINSTID( 
PI_TABDESCNAME  IN  VARCHAR2, 
)RETURN NUMBER;

Return

Type NUMBER

Parameters

This API has the following parameter:

PI_TABDESCNAME (Mandatory). Enter the Oracle Name of the Table Descriptor whose mapped Table Instance ID you want to retrieve.