APPS.IEM_MIGRATION_PVT dependencies on JTF_IH_MEDIA_ITEMS

Line 254: select creation_date into l_received_Date from jtf_ih_media_items

250: l_mail_type:=1;
251: end if;
252: -- Retrieve Resouce Party etc from IH
253: l_media_id:=v1.ih_media_item_id;
254: select creation_date into l_received_Date from jtf_ih_media_items
255: where media_id=l_media_id;
256: l_received_date:=sysdate;
257: select iem_ms_base_headers_s1.nextval into l_message_id from dual;
258:

Line 323: update jtf_ih_media_items

319: (select decode(message_id,message_id,l_message_id),message_content,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN from
320: iem_migration_Store_temp where migration_id=p_migration_id and message_id=v1.message_id);
321:
322: -- Update Media Items with new message Id
323: update jtf_ih_media_items
324: set media_item_ref=l_message_id
325: where media_id=v1.ih_media_item_id;
326: update iem_migration_store_temp
327: set mig_Status='M'

Line 397: update jtf_ih_media_items

393: null;
394: end;
395: -- Update Media Items with new message Id
396:
397: update jtf_ih_media_items
398: set media_item_ref=v1.message_id
399: where media_id=v1.ih_media_item_id;
400: -- update MIG status to "M"
401: update iem_migration_store_temp

Line 772: from jtf_ih_media_items

768: l_mig_Status:='E';
769: END;
770: BEGIN
771: select media_id into l_mig_rec.ih_media_item_id
772: from jtf_ih_media_items
773: where media_item_type = 'EMAIL'
774: AND media_item_ref=l_mig_rec.rfc822_message_id
775: AND source_id=l_email_account_id;
776: EXCEPTION WHEN OTHERS THEN