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_ITEM_TYPES

Line 2072: DELETE FROM amv_c_item_types

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;
2074: -- Remove channel from item match
2075: DELETE FROM amv_c_chl_item_match
2076: WHERE channel_id = l_channel_id;

Line 3920: select amv_c_item_types_s.nextval

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

Line 4044: DELETE FROM amv_c_item_types

4040:
4041: -- update channels if user has privilege
4042: IF l_update_channel_flag = FND_API.G_TRUE THEN
4043: -- remove old groups for the channel
4044: DELETE FROM amv_c_item_types
4045: WHERE channel_id = l_channel_id;
4046:
4047: -- set match on flag in channel table
4048: IF p_item_type_array.count > 0 THEN

Line 4075: INSERT INTO amv_c_item_types

4071: OPEN C_ChanItemType_Seq;
4072: FETCH C_ChanItemType_Seq INTO l_item_type_id;
4073: CLOSE C_ChanItemType_Seq;
4074:
4075: INSERT INTO amv_c_item_types
4076: (
4077: channel_item_type_id,
4078: object_version_number,
4079: last_update_date,

Line 4222: from amv_c_item_types

4218: l_item_type varchar2(30);
4219: --
4220: CURSOR Get_ItemTypes IS
4221: select item_type
4222: from amv_c_item_types
4223: where channel_id = l_channel_id;
4224: --
4225: BEGIN
4226: -- Standard begin of API savepoint