180:
181: -- check if duplicate
182: BEGIN
183: IF x_srp_plan_assigns_row.srp_plan_assign_id IS NULL THEN 184: SELECT 1 INTO l_dummy FROM dual 185: WHERE NOT EXISTS
186: (SELECT 1
187: FROM cn_srp_plan_assigns
188: WHERE role_plan_id = p_role_plan_id