APPS.OKC_CAT_PVT dependencies on OKC_K_ARTICLES_TLH

Line 155: DELETE FROM OKC_K_ARTICLES_TLH T

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

Line 163: UPDATE OKC_K_ARTICLES_TLH T SET (

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,

Line 174: FROM OKC_K_ARTICLES_TLH B

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 (

Line 186: FROM OKC_K_ARTICLES_TLH SUBB, OKC_K_ARTICLES_TLH SUBT

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

Line 208: INSERT INTO OKC_K_ARTICLES_TLH (

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,

Line 242: FROM OKC_K_ARTICLES_TLH B, FND_LANGUAGES L

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

Line 247: FROM OKC_K_ARTICLES_TLH T

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: );

Line 4605: INSERT INTO okc_k_articles_tlh

4601: --------------------------------
4602: -- Versioning TL Table
4603: -------------------------------
4604:
4605: INSERT INTO okc_k_articles_tlh
4606: (
4607: major_version,
4608: id,
4609: language,

Line 4727: FROM okc_k_articles_tlh

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;