APPS.IEM_MIGRATION_PVT dependencies on JTF_IH_MEDIA_ITEMS

Line 293: from jtf_ih_media_items

289:
290: BEGIN
291: --added the rownum = 1 to avoid multiple records returning due to data issue on customer side
292: select media_id, creation_date INTO l_media_id, l_received_date
293: from jtf_ih_media_items
294: where media_item_type = 'EMAIL'
295: AND media_item_ref=v1.rfc822_message_id
296: AND source_id=v1.email_account_id
297: and rownum = 1;

Line 315: select creation_date into l_received_Date from jtf_ih_media_items

311:
312: ELSE --this else ends at the bottom of the code siahmed
313: --end of addition siahmed
314: BEGIN
315: select creation_date into l_received_Date from jtf_ih_media_items
316: where media_id=l_media_id;
317: l_received_date:=sysdate;
318:
319: EXCEPTION WHEN OTHERS THEN

Line 394: update jtf_ih_media_items

390: iem_migration_Store_temp where migration_id=p_migration_id and message_id=v1.message_id);
391:
392: -- Update Media Items with new message Id
393: /* commented by siahmed
394: update jtf_ih_media_items
395: set media_item_ref=l_message_id
396: where media_id=v1.ih_media_item_id;
397: */
398: --v1.ih_media_item_id could be null so we should not use the v1 cursor value but rather the

Line 400: update jtf_ih_media_items

396: where media_id=v1.ih_media_item_id;
397: */
398: --v1.ih_media_item_id could be null so we should not use the v1 cursor value but rather the
399: --variable l_media_id
400: update jtf_ih_media_items
401: set media_item_ref=l_message_id
402: where media_id=l_media_id;
403:
404: update iem_migration_store_temp

Line 502: update jtf_ih_media_items

498: null;
499: end;
500: -- Update Media Items with new message Id
501:
502: update jtf_ih_media_items
503: set media_item_ref=v1.message_id
504: where media_id=v1.ih_media_item_id;
505: -- update MIG status to "M"
506: update iem_migration_store_temp

Line 925: from jtf_ih_media_items

921: --added by siahmed if nothing found dont run this
922: IF l_mig_rec.rfc822_message_id is not null THEN
923: BEGIN
924: select media_id into l_mig_rec.ih_media_item_id
925: from jtf_ih_media_items
926: where media_item_type = 'EMAIL'
927: and direction=l_direction
928: AND source_id=l_email_account_id
929: AND media_item_ref=l_mig_rec.rfc822_message_id;