48.4 GET_ID Function Signature 2

This function gets the region ID based on the region name.

Syntax

APEX_REGION.GET_ID (
    p_application_id IN NUMBER  DEFAULT apex.g_flow_id,
    p_page_id        IN NUMBER,
    p_name           IN VARCHAR2 )
    RETURN NUMBER;

Parameters

Parameter	Description
p_application_id	ID of the application which contains the region.
p_page_id	ID of the page which contains the region.
p_name	Name of the desired region. Note: The p_name is not unique and raises a too_many_rows error if multiple regions exist with the same region name.

Example

The following example gets the ID of the region whose name is "Test" in app 100 on page 1.

DECLARE
    l_region_id apex_application_page_regions.region_id%type;
BEGIN
    ...
    l_region_id := apex_region.get_id(
                       p_application_id => 100,
                       p_page_id        => 1,
                       p_name           => 'Test' );
    ...
END;