500: -- delete from fem_
501: delete from fem_channels_attr
502: where channel_id in (
503: select channel_id
504: from fem_channels_b
505: where personal_flag = 'Y'
506: and created_by = p_user_id
507: );
508:
509: -- delete from fem_
510: delete from fem_channels_tl
511: where channel_id in (
512: select channel_id
513: from fem_channels_b
514: where personal_flag = 'Y'
515: and created_by = p_user_id
516: );
517:
515: and created_by = p_user_id
516: );
517:
518: -- delete from fem_
519: delete from fem_channels_b
520: where personal_flag = 'Y'
521: and created_by = p_user_id;
522:
523: elsif (l_dimension_varchar_label = 'LINE_ITEM') then