eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_CHANNEL_PVT dependencies on AMV_C_KEYWORDS

Line 2063: DELETE FROM amv_c_keywords

2059: -- Remove channel from authors
2060: DELETE FROM amv_c_authors
2061: WHERE channel_id = l_channel_id;
2062: -- Remove channel from keywords
2063: DELETE FROM amv_c_keywords
2064: WHERE channel_id = l_channel_id;
2065: -- Remove channel from content type
2066: DELETE FROM amv_c_content_types
2067: WHERE channel_id = l_channel_id;

Line 4422: select amv_c_keywords_s.nextval

4418: l_update_channel_flag Varchar2(1);
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

Line 4547: DELETE FROM amv_c_keywords

4543:
4544: -- update channels if user has privilege
4545: IF l_update_channel_flag = FND_API.G_TRUE THEN
4546: -- remove old keywords for the channel
4547: DELETE FROM amv_c_keywords
4548: WHERE channel_id = l_channel_id;
4549:
4550: -- set match on flag in channel table
4551: IF p_keywords_array.count > 0 THEN

Line 4577: INSERT INTO amv_c_keywords

4573: FOR i in 1..p_keywords_array.count LOOP
4574: OPEN C_ChanKeywordId_Seq;
4575: FETCH C_ChanKeywordId_Seq INTO l_keyword_id;
4576: CLOSE C_ChanKeywordId_Seq;
4577: INSERT INTO amv_c_keywords
4578: (
4579: channel_keyword_id,
4580: object_version_number,
4581: last_update_date,

Line 4725: from amv_c_keywords

4721: l_keywords varchar2(200);
4722: --
4723: CURSOR Get_Keywords IS
4724: select keyword
4725: from amv_c_keywords
4726: where channel_id = l_channel_id;
4727: --
4728: BEGIN
4729: -- Standard begin of API savepoint