319: end if;
320: --
321: l_count := 1;
322: while l_count > 0 loop
323: select hz_org_contact_roles_s.nextval into x_contact_role_id from dual;
324:
325: select count(*) into l_count from hz_org_contact_roles
326: where org_contact_role_id = x_contact_role_id ;
327:
321: l_count := 1;
322: while l_count > 0 loop
323: select hz_org_contact_roles_s.nextval into x_contact_role_id from dual;
324:
325: select count(*) into l_count from hz_org_contact_roles
326: where org_contact_role_id = x_contact_role_id ;
327:
328: END LOOP;
329: --