APPS.JTF_IH_IEC_PVT dependencies on JTF_IH_MEDIA_ITEMS

Line 65: SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;

61:
62: for L in 1..P_COUNT
63: Loop
64:
65: SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;
66: -- dbms_output.put_line('Media ID Returned: ' || to_char(l_media_id));
67:
68: INSERT INTO jtf_ih_media_items
69: (

Line 68: INSERT INTO jtf_ih_media_items

64:
65: SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;
66: -- dbms_output.put_line('Media ID Returned: ' || to_char(l_media_id));
67:
68: INSERT INTO jtf_ih_media_items
69: (
70: CREATED_BY,
71: CREATION_DATE,
72: LAST_UPDATED_BY,

Line 207: FROM JTF_IH_MEDIA_ITEMS WHERE Media_Id = p_Media_id;

203: -- Get current ao_update_pending and soft_closed values for current Media_Id
204: --
205: SELECT ao_update_pending, soft_closed, start_date_time, end_date_time
206: INTO l_ao_update_pending, l_soft_closed, l_start_date_time, l_end_date_time
207: FROM JTF_IH_MEDIA_ITEMS WHERE Media_Id = p_Media_id;
208:
209: -- Set up parameters for Media Item.
210: --
211: p_Media.media_id := p_Media_id;

Line 234: UPDATE jtf_ih_media_items SET ao_update_pending = l_ao_update_pending_perf

230:
231: -- Update AO_UPDATE_PENDING flag to 'N' for Media Item ID passed
232: --
233: -- l_ao_update_pending_perf
234: UPDATE jtf_ih_media_items SET ao_update_pending = l_ao_update_pending_perf
235: WHERE Media_ID = p_Media_id;
236:
237: -- If MI should be hard closed then call JTF_IH_PUB.Close_MediaItem
238: -- else JTF_IH_PUB.Update_MediaItem