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_AUTHORS

Line 2060: DELETE FROM amv_c_authors

2056: WHERE access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
2057: AND access_to_table_record_id = l_channel_id;
2058:
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;

Line 4925: select amv_c_authors_s.nextval

4921: l_channel_exist_flag varchar2(1);
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

Line 5050: DELETE FROM amv_c_authors

5046:
5047: -- update channels if user has privilege
5048: IF l_update_channel_flag = FND_API.G_TRUE THEN
5049: -- remove old authors for the channel
5050: DELETE FROM amv_c_authors
5051: WHERE channel_id = l_channel_id;
5052:
5053: -- set match on flag in channel table
5054: IF p_authors_array.count > 0 THEN

Line 5080: INSERT INTO amv_c_authors

5076: FOR i in 1..p_authors_array.count LOOP
5077: OPEN C_ChanAuthorId_Seq;
5078: FETCH C_ChanAuthorId_Seq INTO l_author_id;
5079: CLOSE C_ChanAuthorId_Seq;
5080: INSERT INTO amv_c_authors
5081: (
5082: channel_author_id,
5083: object_version_number,
5084: last_update_date,

Line 5227: from amv_c_authors

5223: l_authors varchar2(200);
5224: --
5225: CURSOR Get_Authors IS
5226: select author
5227: from amv_c_authors
5228: where channel_id = l_channel_id;
5229: --
5230: BEGIN
5231: -- Standard begin of API savepoint