[Home] [Help]
504: l_error_flag varchar2(1);
505:
506: CURSOR ChannelId_Seq IS
507: select amv_c_channels_b_s.nextval
508: from dual;
509: BEGIN
510: -- Standard begin of API savepoint
511: SAVEPOINT Add_Channel_PVT;
512: -- Standard call to check for call compatibility.
2910: l_chl_content_type_id number;
2911: --
2912: CURSOR C_ChanContentType_Seq IS
2913: select amv_c_content_types_s.nextval
2914: from dual;
2915: BEGIN
2916: -- Standard begin of API savepoint
2917: SAVEPOINT Set_ChannelContent_PVT;
2918: -- Standard call to check for call compatibility.
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;
3422: -- Standard call to check for call compatibility.
3917: l_item_type_id number;
3918: --
3919: CURSOR C_ChanItemType_Seq IS
3920: select amv_c_item_types_s.nextval
3921: from dual;
3922: BEGIN
3923: -- Standard begin of API savepoint
3924: SAVEPOINT Set_ChannelItems_PVT;
3925: -- Standard call to check for call compatibility.
4419: l_keyword_id number;
4420: --
4421: CURSOR C_ChanKeywordId_Seq IS
4422: select amv_c_keywords_s.nextval
4423: from dual;
4424: --
4425: BEGIN
4426: -- Standard begin of API savepoint
4427: SAVEPOINT Set_ChannelKeywords_PVT;
4922: l_author_id number;
4923: --
4924: CURSOR C_ChanAuthorId_Seq IS
4925: select amv_c_authors_s.nextval
4926: from dual;
4927: --
4928: BEGIN
4929: -- Standard begin of API savepoint
4930: SAVEPOINT Set_ChannelAuthors_PVT;