create or replace 
function        cm_login 
(
  username in varchar2  
, password in varchar2  
) return number as
  vc_arr OWA.vc_arr;
  session_id number;
begin
    vc_arr(1) := 'TEST';
    OWA.init_cgi_env(vc_arr);
    
    wwv_flow_api.set_security_group_id(wwv_flow_application_install.get_workspace_id());
    
    session_id := apex_custom_auth.get_next_session_id();

    apex_custom_auth.login(
        p_uname => username,
        p_password => password,
        p_session_id => session_id,
        p_app_page => 113,
        p_entry_point => null,
        p_preserve_case => null
    );
    
    apex_custom_auth.set_session_id(session_id);
    apex_custom_auth.set_user(username);
    apex_application.g_flow_id := 113;
    
    return session_id;
end cm_login;