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 1623: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;

1619: order by score asc;
1620: l_api_version_number number:=1.0;
1621: l_api_name varchar2(30):='ResolvedMessage';
1622: l_media_rec JTF_IH_PUB.media_rec_type;
1623: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;
1624: ERROR_CLOSING_MEDIA EXCEPTION;
1625: BEGIN
1626: -- Standard call to check for call compatibility.
1627: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1641: FROM JTF_IH_MEDIA_ITEMS

1637: where message_id=p_message_id;
1638: -- Close The Media Item
1639: BEGIN
1640: SELECT * into l_media_data
1641: FROM JTF_IH_MEDIA_ITEMS
1642: WHERE MEDIA_ID=l_msg_rec.ih_media_item_id;
1643: l_media_rec.media_id := l_media_data.media_id;
1644: l_media_rec.source_id := l_media_data.source_id;
1645: l_media_rec.direction:= l_media_data.direction;