775: -- delete from fem_
776: delete from fem_user_dim4_attr
777: where user_dim4_id in (
778: select user_dim4_id
779: from fem_user_dim4_b
780: where personal_flag = 'Y'
781: and created_by = p_user_id
782: );
783:
784: -- delete from fem_
785: delete from fem_user_dim4_tl
786: where user_dim4_id in (
787: select user_dim4_id
788: from fem_user_dim4_b
789: where personal_flag = 'Y'
790: and created_by = p_user_id
791: );
792:
790: and created_by = p_user_id
791: );
792:
793: -- delete from fem_
794: delete from fem_user_dim4_b
795: where personal_flag = 'Y'
796: and created_by = p_user_id;
797:
798: elsif (l_dimension_varchar_label = 'USER_DIM5') then