APPS.IEM_CLIENTLAUNCH_PUB dependencies on IEM_RT_MEDIA_ITEMS

Line 182: l_rt_media_item_id IEM_RT_MEDIA_ITEMS.rt_media_item_id%type;

178:
179: l_classification_id iem_route_classifications.route_classification_id%type;
180: l_class_name iem_route_classifications.name%type;
181:
182: l_rt_media_item_id IEM_RT_MEDIA_ITEMS.rt_media_item_id%type;
183:
184: l_return_status VARCHAR2(200) := FND_API.G_RET_STS_SUCCESS;
185: l_msg_count NUMBER := 0;
186: l_msg_data VARCHAR2(2000);

Line 223: from IEM_RT_MEDIA_ITEMs

219: and b.message_id = l_msg_id;
220:
221: select rt_media_item_id
222: into l_rt_media_item_id
223: from IEM_RT_MEDIA_ITEMs
224: where message_id = l_msg_id
225: and expire='N';
226:
227: if( FND_LOG.LEVEL_STATEMENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 254: logMessage := '[NO data found when query iem_account_route_class,IEM_RT_MEDIA_ITEMs with l_msg_id='||l_msg_id||']';

250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: ROLLBACK TO launchInbound_pvt;
253: if( FND_LOG.LEVEL_STATEMENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
254: logMessage := '[NO data found when query iem_account_route_class,IEM_RT_MEDIA_ITEMs with l_msg_id='||l_msg_id||']';
255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
256: end if;
257:
258: WHEN FND_API.G_EXC_ERROR THEN