337: -- delete from fem_
338: delete from fem_products_attr
339: where product_id in (
340: select product_id
341: from fem_products_b
342: where personal_flag = 'Y'
343: and created_by = p_user_id
344: );
345:
346: -- delete from fem_
347: delete from fem_products_tl
348: where product_id in (
349: select product_id
350: from fem_products_b
351: where personal_flag = 'Y'
352: and created_by = p_user_id
353: );
354:
352: and created_by = p_user_id
353: );
354:
355: -- delete from fem_
356: delete from fem_products_b
357: where personal_flag = 'Y'
358: and created_by = p_user_id;
359:
360: elsif (l_dimension_varchar_label = 'OBJECT') then