DBA Data[Home] [Help]

APPS.AMV_CATEGORY_PVT dependencies on AMV_U_MY_CHANNELS

Line 1061: DELETE FROM amv_u_my_channels

1057: FETCH Get_CategoryChannels INTO l_channel_id;
1058: EXIT WHEN Get_CategoryChannels%NOTFOUND;
1059:
1060: -- Remove channel from mychannels
1061: DELETE FROM amv_u_my_channels
1062: WHERE subscribing_to_id = l_channel_id
1063: AND subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;
1064:
1065: -- Remove access given to this channel

Line 1095: DELETE FROM amv_u_my_channels

1091: DELETE FROM amv_c_chl_item_match
1092: WHERE channel_category_id = l_category_id;
1093:
1094: -- Remove category from my channels
1095: DELETE FROM amv_u_my_channels
1096: --WHERE subscribing_to_id = l_category_id pls refer the bug# 2626331,2720397
1097: WHERE subscribing_to_id = l_category_hr(i).id
1098: AND subscribing_to_type = AMV_UTILITY_PVT.G_CATEGORY;
1099: