APPS.OKC_OCE_PVT dependencies on OKC_OUTCOMES_TLH

Line 105: DELETE FROM OKC_OUTCOMES_TLH T

101: FROM OKC_OUTCOMES_TL T
102: WHERE T.ID = B.ID
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105: DELETE FROM OKC_OUTCOMES_TLH T
106: WHERE NOT EXISTS (
107: SELECT NULL
108: FROM OKC_OUTCOMES_BH B
109: WHERE B.ID = T.ID

Line 113: UPDATE OKC_OUTCOMES_TLH T SET (

109: WHERE B.ID = T.ID
110: AND B.MAJOR_VERSION = T.MAJOR_VERSION
111: );
112:
113: UPDATE OKC_OUTCOMES_TLH T SET (
114: COMMENTS) = (SELECT
115: B.COMMENTS
116: FROM OKC_OUTCOMES_TLH B
117: WHERE B.ID = T.ID

Line 116: FROM OKC_OUTCOMES_TLH B

112:
113: UPDATE OKC_OUTCOMES_TLH T SET (
114: COMMENTS) = (SELECT
115: B.COMMENTS
116: FROM OKC_OUTCOMES_TLH B
117: WHERE B.ID = T.ID
118: AND B.MAJOR_VERSION = T.MAJOR_VERSION
119: AND B.LANGUAGE = T.SOURCE_LANG)
120: WHERE (

Line 128: FROM OKC_OUTCOMES_TLH SUBB, OKC_OUTCOMES_TLH SUBT

124: IN (SELECT
125: SUBT.ID,
126: SUBT.MAJOR_VERSION,
127: SUBT.LANGUAGE
128: FROM OKC_OUTCOMES_TLH SUBB, OKC_OUTCOMES_TLH SUBT
129: WHERE SUBB.ID = SUBT.ID
130: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
131: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
132: AND (SUBB.COMMENTS <> SUBT.COMMENTS

Line 137: INSERT INTO OKC_OUTCOMES_TLH (

133: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
134: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
135: ));
136:
137: INSERT INTO OKC_OUTCOMES_TLH (
138: ID,
139: LANGUAGE,
140: MAJOR_VERSION,
141: SOURCE_LANG,

Line 161: FROM OKC_OUTCOMES_TLH B, FND_LANGUAGES L

157: B.CREATION_DATE,
158: B.LAST_UPDATED_BY,
159: B.LAST_UPDATE_DATE,
160: B.LAST_UPDATE_LOGIN
161: FROM OKC_OUTCOMES_TLH B, FND_LANGUAGES L
162: WHERE L.INSTALLED_FLAG IN ('I', 'B')
163: AND B.LANGUAGE = USERENV('LANG')
164: AND NOT EXISTS(
165: SELECT NULL

Line 166: FROM OKC_OUTCOMES_TLH T

162: WHERE L.INSTALLED_FLAG IN ('I', 'B')
163: AND B.LANGUAGE = USERENV('LANG')
164: AND NOT EXISTS(
165: SELECT NULL
166: FROM OKC_OUTCOMES_TLH T
167: WHERE T.ID = B.ID
168: AND T.MAJOR_VERSION = B.MAJOR_VERSION
169: AND T.LANGUAGE = L.LANGUAGE_CODE
170: );

Line 4036: INSERT INTO okc_outcomes_tlh

4032: ------------------------------
4033: -- Versioning TL Table
4034: ------------------------------
4035:
4036: INSERT INTO okc_outcomes_tlh
4037: (
4038: major_version,
4039: id,
4040: language,

Line 4119: FROM okc_outcomes_tlh

4115: creation_date,
4116: last_updated_by,
4117: last_update_date,
4118: last_update_login
4119: FROM okc_outcomes_tlh
4120: WHERE id in (select id from okc_outcomes_b where dnz_chr_id = p_chr_id)
4121: AND major_version = p_major_version;
4122:
4123: --------------------------------------