I need some help on how to apply theme style of an application(app_id=101) from another application(app_id=100).
On both the apps I have the same authentication schemes and have enabled session sharing to workspace level. Also the option to modify application(this and other) is enabled under Runtime API Usage on both the apps.
Created a process through a button which picks up app_id and theme_style_id from lov’s.
This is what I have on the page process.
declare
l_theme number;
begin
apex_session.create_session (
p_app_id => :P1_APP_ID,
p_page_id => 1,
p_username => 'ADMIN' );
select theme_number into l_theme from apex_application_themes where application_id = :P1_APP_ID and ui_type_name = 'DESKTOP';
apex_theme.set_current_style (
p_theme_number => l_theme,
p_id => :P1_DESKTOP_THEME_STYLE_ID
);
end;
What happens when I click the button is it takes me to the login page of app-101 and applies the theme style after successful login. Is there anyway that it can be done without having to enter the credentials?