create table user_info
(id varchar2(15),
 entity_name varchar2(1000),
);

i have inserted a data as follows.

ID            Entity_Name
-------------------------
1              State1
2              State1, Dist1
3              state2, Dist1, Vlg1
4              State3, Dist2, Vilg2
5              State3, Dist2, Vilg3
6              State4, Dist3
7              ,Dist4
8              , , VIlg5
9              , dist5
10             , , US
11             UK
12             UAE,IND
13              , PAK
...
      

ID            Entity_Name    LVL
----------------------------------
1              State1         0
2              State1         0
3              Dist1          1
4              state2         0
5              Dist1          1
6              Vlg1           2
7              State3         0
8              Dist2          1
9              Vilg2          2
10             State3         0
11             Dist2          1
12             Vilg3          2
13             State4         0
14             Dist3          1
15             Dist4          1
16             null 
17             null
18             VIlg5          2
19             null
20             dist5          1
21             null
22             US             1
23             UK             0
24             UAE            0
25             IND            1
26             null
27             PAK            0
...
..

Insert into user_info values('1','State1');
Insert into user_info values('2',"State1, Dist1");
Insert into user_info values('3',"state2, Dist1, Vlg1");
Insert into user_info values('4',"State3, Dist2, Vilg2");
Insert into user_info values('5',"State3, Dist2, Vilg3");
Insert into user_info values('6',"State4, Dist3");
Insert into user_info values('7'," ,Dist4");
Insert into user_info values('8'," , , VIlg5");
Insert into user_info values('9'," , dist5");
Insert into user_info values('10'," , , US");
Insert into user_info values('11',"UK"");
Insert into user_info values('12',"UAE,IND");
Insert into user_info values('13',", PAK");

WITH DATA AS
      ( SELECT entity_name FROM user_info
    )
  SELECT trim(regexp_substr(entity_name, '[^,]+', 1, LEVEL)) entity_name
  FROM DATA
 CONNECT BY instr(entity_name, ',', 1, LEVEL - 1) > 0

          A
       /     \
      B       C
    /   \   / | \
    D    E  F  G  H
         |
         I

Father       SON    
====================
A             B
A             C
B             D
B             E
C             F
C             G
C             H
I             E

Name         Level
==================
A             0
B             1
C             1
D             2
E             2
F             2
G             2 
H             2
I             3

Name         Level
==================
A             0
B             1
C             1
D             2
E             2
F             2
G             2 
H             2
I             I_E
I             I_F

 
create table user_parent
(
divname   varchar2(30),
regionName  varchar2(30),
Teamname varchar2(30)
);
 

insert into user_parent values('D1',R1','T1');
insert into user_parent values('D1',R1','T2');
insert into user_parent values('D1',R2','T3');
insert into user_parent values('D1',R2','T4');
insert into user_parent values('D2',R3','T5');
insert into user_parent values('D3',R6','T9');
insert into user_parent values('D4',R6','T10');
...
...

DIVNAME    RegionName    TeamName
------------------------------------------------------------
D1                   R1                   T1
D1                   R1                   T2
D1                   R2                    T3
D1                   R2                    T4
D2                   R3                    T5
D3                   R6                    T9
D4                   R6                    T10
...
....

Create table Parent_Info
(
id   varchar2(20),
NAME varchar2(30),
Parent_ID     varchar2(30)
);

create sequence parent_info_seq
start with 1
increment by 1
minvalue 1
maxvalue 999999

ID    NAME              Parent
=====================
1       D1                     0
2       D2                     0
3       D3                     0
4       D4                     0
5       R1                     1 ( R1 has parent D1 and D1's ID is 1 here ..)
6       R2                     1 ( R2 has parent D1 and D1's ID is 1 here..)
7       R3                     2 ( R3 has parent D2 and D2's ID is 2 here)
8       R6                     R6_D3 ( R6 has two parents --> D3 and D4. so to define the difference we need to mention R6 _ ( respective parent)
9       R6                     R6_D4 ( R6 has two parents --> D3 and D4. so to define the difference we need to mention R6 _ ( respective parent)
10     T1                     5  ( T1 has Parent R1 and R1 ID value is 5 here)
11     T2                     5  ( T2 has parent R1 and R1 ID value is 5 Here)
12      T3                    6 ( T3 has parent R2 and R2 ID value is 6 here)
13      T4                    6   (T4 has parent R2 and R2 ID value is 6 here)
14      T5                    7 ( T5 has parent R3 and the ID of R3 is 7 here)
15      T9                    T9_R6 ( T9 has parent R6. so define the difference need to mention T9_ (respective parent)
16       T10                  T10_R6 ( T10 has parent R6. So to make the difference need to mention T10_ respective parent)
......
...
....

-- Insert the rows based on DIVNAME column
insert into parent_info ( name, parent_id )
select distinct divname, '0'
from user_parent;

-- Insert the rows based on REGIONNAME column
insert into parent_info ( name, parent_id )
select distinct name, parent_id
from ( select up.regionname name,
         case when count( distinct pi.id ) over ( partition by up.regionname ) = 1
              then pi.id
              else up.regionname||'_'||up.divname
         end parent_id
       from user_parent up
         inner join parent_info pi on pi.name = up.divname);

from the 2nd query 
In the parent_ID column it is displaying regionname||'_'||up.divname value ( whihc is character value). 
But here in this column it needs to display ID value ( which is number) of the DIVNAME..

Can you have a look and let me know where do I need to do the modification.