[Home] [Help]
2065: -- Remove channel from content type
2066: DELETE FROM amv_c_content_types
2067: WHERE channel_id = l_channel_id;
2068: -- Remove channel from perspectives
2069: DELETE FROM amv_c_chl_perspectives
2070: WHERE channel_id = l_channel_id;
2071: -- Remove channel from item types
2072: DELETE FROM amv_c_item_types
2073: WHERE channel_id = l_channel_id;
3413: l_update_channel_flag Varchar2(1);
3414: l_chl_perspective_id number;
3415: --
3416: CURSOR C_ChanPerspective_Seq IS
3417: select amv_c_chl_perspectives_s.nextval
3418: from dual;
3419: BEGIN
3420: -- Standard begin of API savepoint
3421: SAVEPOINT Set_ChannelPerspectives_PVT;
3537:
3538: -- update channels if user has privilege
3539: IF l_update_channel_flag = FND_API.G_TRUE THEN
3540: -- remove old perspectives for the channel
3541: DELETE FROM amv_c_chl_perspectives
3542: WHERE channel_id = l_channel_id;
3543:
3544: -- set match on flag in channel table
3545: IF p_perspective_id_array.count > 0 THEN
3569: OPEN C_ChanPerspective_Seq;
3570: FETCH C_ChanPerspective_Seq INTO l_chl_perspective_id;
3571: CLOSE C_ChanPerspective_Seq;
3572:
3573: INSERT INTO amv_c_chl_perspectives
3574: (
3575: channel_perspective_id,
3576: object_version_number,
3577: last_update_date,
3716: l_perspective_id number;
3717: --
3718: CURSOR Get_Perspectives IS
3719: select perspective_id
3720: from amv_c_chl_perspectives
3721: where channel_id = l_channel_id;
3722: --
3723: BEGIN
3724: -- Standard begin of API savepoint