919: --
920:
921: CURSOR Get_CategoryChannels IS
922: select channel_id
923: from amv_c_channels_b
924: where channel_category_id = l_category_id;
925: --
926: BEGIN
927: -- Standard begin of API savepoint
2222: and parent_channel_category_id = l_category_id;
2223:
2224: CURSOR Count_Channels_csr IS
2225: select count(channel_id)
2226: from amv_c_channels_b
2227: where channel_category_id = l_category_id;
2228: --
2229: BEGIN
2230: -- Standard begin of API savepoint
3881: --
3882: CURSOR Get_ChannelData IS
3883: select tl.channel_name
3884: , b.channel_category_id
3885: from amv_c_channels_b b
3886: , amv_c_channels_tl tl
3887: where b.channel_id = p_channel_id
3888: and b.channel_id = tl.channel_id
3889: and tl.language = userenv('lang');