APPS.OKC_CNH_PVT dependencies on OKC_CONDITION_HEADERS_TLH

Line 128: DELETE FROM OKC_CONDITION_HEADERS_TLH T

124: FROM OKC_CONDITION_HEADERS_TL T
125: WHERE T.ID = B.ID
126: AND T.LANGUAGE = L.LANGUAGE_CODE
127: );
128: DELETE FROM OKC_CONDITION_HEADERS_TLH T
129: WHERE NOT EXISTS (
130: SELECT NULL
131: FROM OKC_CONDITION_HEADERS_BH B
132: WHERE B.ID = T.ID

Line 135: UPDATE OKC_CONDITION_HEADERS_TLH T SET (

131: FROM OKC_CONDITION_HEADERS_BH B
132: WHERE B.ID = T.ID
133: AND B.MAJOR_VERSION = T.MAJOR_VERSION
134: );
135: UPDATE OKC_CONDITION_HEADERS_TLH T SET (
136: NAME,
137: DESCRIPTION,
138: SHORT_DESCRIPTION,
139: COMMENTS) = (SELECT

Line 144: FROM OKC_CONDITION_HEADERS_TLH B

140: B.NAME,
141: B.DESCRIPTION,
142: B.SHORT_DESCRIPTION,
143: B.COMMENTS
144: FROM OKC_CONDITION_HEADERS_TLH B
145: WHERE B.ID = T.ID
146: AND B.MAJOR_VERSION = T.MAJOR_VERSION
147: AND B.LANGUAGE = T.SOURCE_LANG)
148: WHERE (

Line 156: FROM OKC_CONDITION_HEADERS_TLH SUBB, OKC_CONDITION_HEADERS_TLH SUBT

152: IN (SELECT
153: SUBT.ID,
154: SUBT.MAJOR_VERSION,
155: SUBT.LANGUAGE
156: FROM OKC_CONDITION_HEADERS_TLH SUBB, OKC_CONDITION_HEADERS_TLH SUBT
157: WHERE SUBB.ID = SUBT.ID
158: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
159: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
160: AND (SUBB.NAME <> SUBT.NAME

Line 171: INSERT INTO OKC_CONDITION_HEADERS_TLH (

167: OR (SUBB.SHORT_DESCRIPTION IS NOT NULL AND SUBT.SHORT_DESCRIPTION IS NULL)
168: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
169: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
170: ));
171: INSERT INTO OKC_CONDITION_HEADERS_TLH (
172: ID,
173: LANGUAGE,
174: MAJOR_VERSION,
175: SOURCE_LANG,

Line 201: FROM OKC_CONDITION_HEADERS_TLH B, FND_LANGUAGES L

197: B.CREATION_DATE,
198: B.LAST_UPDATED_BY,
199: B.LAST_UPDATE_DATE,
200: B.LAST_UPDATE_LOGIN
201: FROM OKC_CONDITION_HEADERS_TLH B, FND_LANGUAGES L
202: WHERE L.INSTALLED_FLAG IN ('I', 'B')
203: AND B.LANGUAGE = USERENV('LANG')
204: AND NOT EXISTS(
205: SELECT NULL

Line 206: FROM OKC_CONDITION_HEADERS_TLH T

202: WHERE L.INSTALLED_FLAG IN ('I', 'B')
203: AND B.LANGUAGE = USERENV('LANG')
204: AND NOT EXISTS(
205: SELECT NULL
206: FROM OKC_CONDITION_HEADERS_TLH T
207: WHERE T.ID = B.ID
208: AND T.MAJOR_VERSION = B.MAJOR_VERSION
209: AND T.LANGUAGE = L.LANGUAGE_CODE
210: );

Line 5410: INSERT INTO okc_condition_headers_tlh

5406: ------------------------------
5407: -- Versioning TL Table
5408: ------------------------------
5409:
5410: INSERT INTO okc_condition_headers_tlh
5411: (
5412: major_version,
5413: id,
5414: language,

Line 5505: FROM okc_condition_headers_tlh

5501: last_updated_by,
5502: last_update_date,
5503: last_update_login,
5504: name
5505: FROM okc_condition_headers_tlh
5506: WHERE id in (SELECT id
5507: FROM okc_condition_headers_bh
5508: WHERE dnz_chr_id = p_chr_id)
5509: AND major_version = p_major_version;