create table org_demographics ( 
    name VARCHAR2(255 BYTE), 
    descr VARCHAR2(255 BYTE) 
);

create table party_roles ( 
    pr_seq_no NUMBER(12,0), 
    identifier VARCHAR2(32 BYTE) 
);

create or replace package testPackage 
as 
    procedure testProc ( 
            p_nt_user_id					IN	VARCHAR2, 
            p_group_pr_seq_no				IN	party_roles.pr_seq_no%TYPE, 
            p_group_name					IN	org_demographics.name%TYPE, 
            p_parent_cbo_pr_seq_no			IN	party_roles.pr_seq_no%TYPE, 
            p_group_manager_pr_seq_no		IN	party_roles.pr_seq_no%TYPE, 
            p_group_id						IN	party_roles.identifier%TYPE, 
            p_group_descr					IN	org_demographics.descr%TYPE, 
            p_status						OUT NUMBER, 
            p_message						OUT	VARCHAR2 
    );   
end;