APPS.JTF_IH_PURGE dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 290: DELETE FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE MEDIA_ID = n_Media_Id;

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;
291: nCountMediaItemLC := nCountMediaItemLC + SQL%ROWCOUNT;
292: EXCEPTION
293: WHEN NO_DATA_FOUND THEN
294: NULL;

Line 776: FROM JTF_IH_MEDIA_ITEM_LC_SEGS

772: -- And Related to MediaID Media Item LifeCycle.
773: IF lc_media_ids.COUNT > 0 THEN
774: FORALL j IN lc_media_ids.FIRST..lc_media_ids.LAST
775: DELETE
776: FROM JTF_IH_MEDIA_ITEM_LC_SEGS
777: WHERE MEDIA_ID = lc_media_ids(j);
778: END IF;
779:
780: IF p_commit = FND_API.G_TRUE THEN