19.12 GET_BP_TABLE_ID Function

This function returns the table_id for a given blueprint ID and table name (case-sensitive). If not found, it searches with UPPERCASE p_table_name automatically.

Syntax

APEX_DG_DATA_GEN.GET_BP_TABLE_ID (
    p_bp_id         IN NUMBER,
    p_table_name    IN VARCHAR2 )
    RETURN NUMBER;

Parameters

Table 19-12 GET_BP_TABLE_ID Parameters

Parameter	Description
p_bp_id	The blueprint ID.
p_table_name	The name of the table.

Returns

The table ID.

Example

DECLARE
 v_table_id number;
BEGIN
 l_table_id := apex_dg_data_gen.get_bp_table_id
     (p_bp_id         => 12345,
      p_table_name    => 'DEPT'
     );
END;