8.61 SET_SUBSCRIPTION_MAPPING Procedure

Use this procedure to update subscriptions from one application to another during the application installation process. You can invoke the procedure multiple times, accommodating scenarios where components are subscribed from various Component Library Apps or Theme Apps.

Note:

You cannot use this API to switch a theme subscription from the built-in Universal Theme to other local themes or vice versa.

Syntax

APEX_APPLICATION_INSTALL.SET_SUBSCRIPTION_MAPPING (
    p_from_application_id    IN              NUMBER,
    p_to_application_id      IN              NUMBER);

Parameters

Parameter	Description
p_from_application_id	The Application ID of the current subscription source.
p_to_application_id	The Application ID of the new target application to which the subscription is remapped. This application must exist within the target workspace.

Example

The following example demonstrates installing an application and changing subscription source from 100 to 200 and from 110 to 210.

begin
    apex_application_install.clear_all;
    apex_application_install.set_workspace('TARGET_WORKSPACE');

    apex_application_install.set_subscription_mapping(
        p_from_application_id => 100,
        p_to_application_id   => 200 );

    apex_application_install.set_subscription_mapping(
        p_from_application_id => 110,
        p_to_application_id   => 210 );
end;