151: FROM OKC_K_ARTICLES_TL T
152: WHERE T.ID = B.ID
153: AND T.LANGUAGE = L.LANGUAGE_CODE
154: );
155: DELETE FROM OKC_K_ARTICLES_TLH T
156: WHERE NOT EXISTS (
157: SELECT NULL
158: FROM OKC_K_ARTICLES_BH B
159: WHERE B.ID = T.ID
159: WHERE B.ID = T.ID
160: AND B.MAJOR_VERSION = T.MAJOR_VERSION
161: );
162:
163: UPDATE OKC_K_ARTICLES_TLH T SET (
164: COMMENTS,
165: VARIATION_DESCRIPTION,
166: NAME,
167: TEXT,
170: B.VARIATION_DESCRIPTION,
171: B.NAME,
172: B.TEXT,
173: B.SAV_SAV_RELEASE
174: FROM OKC_K_ARTICLES_TLH B
175: WHERE B.ID = T.ID
176: AND B.MAJOR_VERSION = T.MAJOR_VERSION
177: AND B.LANGUAGE = T.SOURCE_LANG)
178: WHERE (
182: IN (SELECT
183: SUBT.ID,
184: SUBT.MAJOR_VERSION,
185: SUBT.LANGUAGE
186: FROM OKC_K_ARTICLES_TLH SUBB, OKC_K_ARTICLES_TLH SUBT
187: WHERE SUBB.ID = SUBT.ID
188: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
189: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
190: AND (SUBB.COMMENTS <> SUBT.COMMENTS
204: OR (SUBB.SAV_SAV_RELEASE IS NULL AND SUBT.SAV_SAV_RELEASE IS NOT NULL)
205: OR (SUBB.SAV_SAV_RELEASE IS NOT NULL AND SUBT.SAV_SAV_RELEASE IS NULL)
206: ));
207:
208: INSERT INTO OKC_K_ARTICLES_TLH (
209: ID,
210: LANGUAGE,
211: MAJOR_VERSION,
212: SOURCE_LANG,
238: B.LAST_UPDATED_BY,
239: B.LAST_UPDATE_DATE,
240: B.LAST_UPDATE_LOGIN,
241: B.SAV_SAV_RELEASE
242: FROM OKC_K_ARTICLES_TLH B, FND_LANGUAGES L
243: WHERE L.INSTALLED_FLAG IN ('I', 'B')
244: AND B.LANGUAGE = USERENV('LANG')
245: AND NOT EXISTS(
246: SELECT NULL
243: WHERE L.INSTALLED_FLAG IN ('I', 'B')
244: AND B.LANGUAGE = USERENV('LANG')
245: AND NOT EXISTS(
246: SELECT NULL
247: FROM OKC_K_ARTICLES_TLH T
248: WHERE T.ID = B.ID
249: AND T.MAJOR_VERSION = B.MAJOR_VERSION
250: AND T.LANGUAGE = L.LANGUAGE_CODE
251: );
4601: --------------------------------
4602: -- Versioning TL Table
4603: -------------------------------
4604:
4605: INSERT INTO okc_k_articles_tlh
4606: (
4607: major_version,
4608: id,
4609: language,
4723: last_updated_by,
4724: last_update_date,
4725: last_update_login,
4726: sav_sav_release
4727: FROM okc_k_articles_tlh
4728: WHERE id in (SELECT id
4729: FROM okc_k_articles_bh
4730: WHERE dnz_chr_id = p_chr_id)
4731: AND major_version = p_major_version;