136: if l_principal_name is not null then
137:
138: -- Make sure that user name is not null
139: if P_USERNAME is not null then
140: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
141: ( USER_NAME => P_USERNAME,
142: ROLE_NAME => l_principal_name,
143: OWNERTABLE_NAME => 'JTF_UM_SUBSCRIPTIONS_B',
144: OWNERTABLE_KEY => l_enrltype_id
164: if l_principal_name is not null then
165:
166: -- Make sure that user name is not null
167: if P_USERNAME is not null then
168: JTF_AUTH_BULKLOAD_PKG.ASSIGN_ROLE
169: ( USER_NAME => P_USERNAME,
170: ROLE_NAME => l_principal_name,
171: OWNERTABLE_NAME => 'JTF_UM_SUBSCRIPTIONS_B',
172: OWNERTABLE_KEY => l_enrltype_id