900: -- delete from fem_
901: delete from fem_user_dim9_attr
902: where user_dim9_id in (
903: select user_dim9_id
904: from fem_user_dim9_b
905: where personal_flag = 'Y'
906: and created_by = p_user_id
907: );
908:
909: -- delete from fem_
910: delete from fem_user_dim9_tl
911: where user_dim9_id in (
912: select user_dim9_id
913: from fem_user_dim9_b
914: where personal_flag = 'Y'
915: and created_by = p_user_id
916: );
917:
915: and created_by = p_user_id
916: );
917:
918: -- delete from fem_
919: delete from fem_user_dim9_b
920: where personal_flag = 'Y'
921: and created_by = p_user_id;
922:
923: elsif (l_dimension_varchar_label = 'USER_DIM10') then