APPS.AMV_CHANNEL_PVT dependencies on AMV_C_CHL_ITEM_MATCH

Line 2075: DELETE FROM amv_c_chl_item_match

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;
2077:
2078: -- Remove channel from channels
2079: AMV_C_CHANNELS_PKG.DELETE_ROW (l_channel_id);

Line 5435: from amv_c_chl_item_match cim

5431: l_total_record_count NUMBER;
5432: --
5433: CURSOR C_PendingItmCount IS
5434: select count(cim.item_id)
5435: from amv_c_chl_item_match cim
5436: , jtf_amv_items_vl ib
5437: where cim.channel_id = p_channel_id
5438: and cim.approval_status_type = p_item_status
5439: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

Line 5445: from amv_c_chl_item_match cim

5441: and cim.item_id = ib.item_id;
5442:
5443: CURSOR Get_PendingItems IS
5444: select ib.item_id
5445: from amv_c_chl_item_match cim
5446: , jtf_amv_items_vl ib
5447: where cim.channel_id = p_channel_id
5448: and cim.approval_status_type = p_item_status
5449: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

Line 5455: from amv_c_chl_item_match cim

5451: order by ib.effective_start_date;
5452:
5453: CURSOR C_TotalItmCount IS
5454: select count(cim.item_id)
5455: from amv_c_chl_item_match cim
5456: , jtf_amv_items_vl ib
5457: where cim.channel_id = p_channel_id
5458: and cim.approval_status_type = p_item_status
5459: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

Line 5467: from amv_c_chl_item_match cim

5463: and nvl(ib.expiration_date, sysdate) >= sysdate;
5464:
5465: CURSOR Get_Items IS
5466: select ib.item_id
5467: from amv_c_chl_item_match cim
5468: , jtf_amv_items_vl ib
5469: where cim.channel_id = p_channel_id
5470: and cim.approval_status_type = p_item_status
5471: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

Line 5808: UPDATE amv_c_chl_item_match

5804: FND_MSG_PUB.Add;
5805: END IF;
5806: RAISE FND_API.G_EXC_ERROR;
5807: ELSE
5808: UPDATE amv_c_chl_item_match
5809: SET approval_status_type = p_approval_status
5810: , approval_date = sysdate
5811: , last_update_date = sysdate
5812: , last_updated_by = l_user_id