APPS.JTF_IH_PURGE dependencies on JTF_IH_MEDIA_ITEMS

Line 286: DELETE FROM JTF_IH_MEDIA_ITEMS WHERE MEDIA_ID = n_Media_Id;

282: -- Delete Media Item If they aren't
283: -- related to other Activities.
284: --
285: IF nCountMedia = 0 THEN
286: DELETE FROM JTF_IH_MEDIA_ITEMS WHERE MEDIA_ID = n_Media_Id;
287: nCountMediaItems := nCountMediaItems + 1;
288: -- And Related to MediaID Media Item LifeCycle.
289: BEGIN
290: DELETE FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE MEDIA_ID = n_Media_Id;

Line 750: FROM JTF_IH_MEDIA_ITEMS

746: --
747: IF l_media_ids.COUNT > 0 THEN
748: FORALL j IN l_media_ids.FIRST..l_media_ids.LAST
749: DELETE
750: FROM JTF_IH_MEDIA_ITEMS
751: WHERE media_id IS NOT NULL
752: AND media_id <> fnd_api.g_miss_num
753: AND media_id = l_media_ids(j)
754: AND