APPS.OTA_MLS_MIGRATION dependencies on OTA_EVENTS

Line 232: delete from ota_events_tl

228: ** Clear out any existing data for this range of records
229: **
230: ** Don't delete just yet.
231: **
232: delete from ota_events_tl
233: where event_id between p_start_pkid
234: and p_end_pkid;
235: */
236:

Line 253: Insert into OTA_EVENTS_TL

249:
250: /*
251: ** Insert the TL rows.
252: */
253: Insert into OTA_EVENTS_TL
254: (Event_Id,
255: Language,
256: Title,
257: Source_Lang,

Line 273: From OTA_EVENTS M

269: M.Creation_date,
270: M.Last_Updated_By,
271: M.Last_Update_Date,
272: M.Last_Update_Login
273: From OTA_EVENTS M
274: Where M.Event_id Between P_start_pkid and P_end_pkid
275: And Not Exists (Select '1'
276: From OTA_EVENTS_TL T
277: Where T.Event_Id = M.Event_Id

Line 276: From OTA_EVENTS_TL T

272: M.Last_Update_Login
273: From OTA_EVENTS M
274: Where M.Event_id Between P_start_pkid and P_end_pkid
275: And Not Exists (Select '1'
276: From OTA_EVENTS_TL T
277: Where T.Event_Id = M.Event_Id
278: And T.Language = L_Current_Language ) ;
279:
280: