APPS.OTA_MLS_MIGRATION dependencies on OTA_ACTIVITY_VERSIONS_TL

Line 131: delete from ota_activity_versions_tl

127: ** Clear out any existing data for this range of records
128: **
129: ** Don't delete just yet.
130: **
131: delete from ota_activity_versions_tl
132: where activity_version_id between p_start_pkid
133: and p_end_pkid;
134: */
135:

Line 152: Insert into OTA_ACTIVITY_VERSIONS_TL

148:
149: /*
150: ** Insert the TL rows.
151: */
152: Insert into OTA_ACTIVITY_VERSIONS_TL
153: (Activity_Version_Id,
154: Language,
155: Version_Name,
156: Description,

Line 181: From OTA_ACTIVITY_VERSIONS_TL T

177: M.Last_Update_Login
178: From OTA_ACTIVITY_VERSIONS M
179: Where M.Activity_version_id Between P_start_pkid and P_end_pkid
180: And Not Exists (Select '1'
181: From OTA_ACTIVITY_VERSIONS_TL T
182: Where T.Activity_version_Id = M.Activity_version_Id
183: And T.Language = L_Current_Language ) ;
184:
185: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;