Create New User in Globus One Portal DB

SET SERVEROUTPUT ON;
DECLARE
party_id     t101_user.c101_party_id%TYPE;
 
BEGIN
globus_app.gm_pkg_it_vendor_user.gm_sav_vendor_user('Jernic',     --First Name
                                         'Roy',   -- Last Name
                                         'jroy-c@globusmedical.com',   --email
                                         'jroy-c',    --username
                                         '4613707',   --created userid
                                         'jroy-c',
                                          2006,
                                          4,
                                          311,    --Active
                                          300,    --Employee
                                          7006,   --Globus Employee
                                          NULL,
                                          NULL,
                                         'manual',     --Password
                                          321,
                                          1);
 
SELECT
    c101_party_id
INTO party_id
FROM
    globus_app.t101_user
WHERE
        c101_user_sh_name = 'jroy-c';
 
INSERT INTO globus_app.t1019_party_company_map (
    c1019_party_company_map_id,
    c101_party_id,
    c1900_company_id,
    c901_party_mapping_type,
    c1019_last_updated_by,
    c1019_last_updated_date
) VALUES (
    s1019_party_company_map.NEXTVAL,
    party_id,
    1000,            --US
    105400,          --Primary
    4613707,        --created userid
    current_date
);
END;
/