APPS.IEM_MAILITEM_PUB dependencies on JTF_IH_MEDIA_ITEMS

Line 773: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;

769: x_msg_data OUT NOCOPY VARCHAR2) IS
770: l_api_name VARCHAR2(255):='DisposeMailItem';
771: l_api_version_number NUMBER:=1.0;
772: l_media_rec JTF_IH_PUB.media_rec_type;
773: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;
774: l_ret_status varchar2(10);
775: l_msg_data varchar2(300);
776: l_msg_count number;
777: l_media_id number;

Line 795: FROM JTF_IH_MEDIA_ITEMS

791: SELECT IH_MEDIA_ITEM_ID into l_media_id
792: FROM iem_rt_proc_emails
793: WHERE MESSAGE_ID=p_message_id;
794: SELECT * into l_media_data
795: FROM JTF_IH_MEDIA_ITEMS
796: WHERE MEDIA_ID=l_media_id;
797: l_media_rec.media_id := l_media_id;
798: l_media_rec.source_id := l_media_data.source_id;
799: l_media_rec.direction:= l_media_data.direction;

Line 1437: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;

1433: order by score asc;
1434: l_api_version_number number:=1.0;
1435: l_api_name varchar2(30):='ResolvedMessage';
1436: l_media_rec JTF_IH_PUB.media_rec_type;
1437: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;
1438: ERROR_CLOSING_MEDIA EXCEPTION;
1439: BEGIN
1440: -- Standard call to check for call compatibility.
1441: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1455: FROM JTF_IH_MEDIA_ITEMS

1451: where message_id=p_message_id;
1452: -- Close The Media Item
1453: BEGIN
1454: SELECT * into l_media_data
1455: FROM JTF_IH_MEDIA_ITEMS
1456: WHERE MEDIA_ID=l_msg_rec.ih_media_item_id;
1457: l_media_rec.media_id := l_media_data.media_id;
1458: l_media_rec.source_id := l_media_data.source_id;
1459: l_media_rec.direction:= l_media_data.direction;