APPS.OTA_AVT_SHD dependencies on OTA_ACTIVITY_VERSIONS

Line 21: If (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_TL_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 56: from ota_activity_versions_tl

52: ,description
53: ,intended_audience
54: ,objectives
55: ,keywords
56: from ota_activity_versions_tl
57: where activity_version_id = p_activity_version_id
58: and language = p_language;
59: --
60: l_fct_ret boolean;

Line 126: from ota_activity_versions_tl

122: ,description
123: ,intended_audience
124: ,objectives
125: ,keywords
126: from ota_activity_versions_tl
127: where activity_version_id = p_activity_version_id
128: and language = p_language
129: for update nowait;
130: --

Line 172: fnd_message.set_token('TABLE_NAME', 'ota_activity_versions_tl');

168: -- The object is locked therefore we need to supply a meaningful
169: -- error message.
170: --
171: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
172: fnd_message.set_token('TABLE_NAME', 'ota_activity_versions_tl');
173: fnd_message.raise_error;
174: End lck;
175: --
176: -- ----------------------------------------------------------------------------

Line 187: delete from OTA_ACTIVITY_VERSIONS_TL T

183: -- ----------------------------------------------------------------------------
184: procedure ADD_LANGUAGE
185: is
186: begin
187: delete from OTA_ACTIVITY_VERSIONS_TL T
188: where not exists
189: (select NULL
190: from OTA_ACTIVITY_VERSIONS B
191: where B.ACTIVITY_VERSION_ID = T.ACTIVITY_VERSION_ID

Line 190: from OTA_ACTIVITY_VERSIONS B

186: begin
187: delete from OTA_ACTIVITY_VERSIONS_TL T
188: where not exists
189: (select NULL
190: from OTA_ACTIVITY_VERSIONS B
191: where B.ACTIVITY_VERSION_ID = T.ACTIVITY_VERSION_ID
192: );
193:
194: update OTA_ACTIVITY_VERSIONS_TL T set (

Line 194: update OTA_ACTIVITY_VERSIONS_TL T set (

190: from OTA_ACTIVITY_VERSIONS B
191: where B.ACTIVITY_VERSION_ID = T.ACTIVITY_VERSION_ID
192: );
193:
194: update OTA_ACTIVITY_VERSIONS_TL T set (
195: VERSION_NAME,
196: DESCRIPTION,
197: INTENDED_AUDIENCE,
198: OBJECTIVES,

Line 206: from OTA_ACTIVITY_VERSIONS_TL B

202: B.DESCRIPTION,
203: B.INTENDED_AUDIENCE,
204: B.OBJECTIVES,
205: B.KEYWORDS
206: from OTA_ACTIVITY_VERSIONS_TL B
207: where B.ACTIVITY_VERSION_ID = T.ACTIVITY_VERSION_ID
208: and B.LANGUAGE = T.SOURCE_LANG)
209: where (
210: T.ACTIVITY_VERSION_ID,

Line 215: from OTA_ACTIVITY_VERSIONS_TL SUBB, OTA_ACTIVITY_VERSIONS_TL SUBT

211: T.LANGUAGE
212: ) in (select
213: SUBT.ACTIVITY_VERSION_ID,
214: SUBT.LANGUAGE
215: from OTA_ACTIVITY_VERSIONS_TL SUBB, OTA_ACTIVITY_VERSIONS_TL SUBT
216: where SUBB.ACTIVITY_VERSION_ID = SUBT.ACTIVITY_VERSION_ID
217: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
218: and (SUBB.VERSION_NAME <> SUBT.VERSION_NAME
219: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 233: insert into OTA_ACTIVITY_VERSIONS_TL (

229: or (SUBB.KEYWORDS is null and SUBT.KEYWORDS is not null)
230: or (SUBB.KEYWORDS is not null and SUBT.KEYWORDS is null)
231: ));
232:
233: insert into OTA_ACTIVITY_VERSIONS_TL (
234: ACTIVITY_VERSION_ID,
235: VERSION_NAME,
236: DESCRIPTION,
237: INTENDED_AUDIENCE,

Line 261: from OTA_ACTIVITY_VERSIONS_TL B, FND_LANGUAGES L

257: B.CREATED_BY,
258: B.CREATION_DATE,
259: L.LANGUAGE_CODE,
260: B.SOURCE_LANG
261: from OTA_ACTIVITY_VERSIONS_TL B, FND_LANGUAGES L
262: where L.INSTALLED_FLAG in ('I', 'B')
263: and B.LANGUAGE = userenv('LANG')
264: and not exists
265: (select NULL

Line 266: from OTA_ACTIVITY_VERSIONS_TL T

262: where L.INSTALLED_FLAG in ('I', 'B')
263: and B.LANGUAGE = userenv('LANG')
264: and not exists
265: (select NULL
266: from OTA_ACTIVITY_VERSIONS_TL T
267: where T.ACTIVITY_VERSION_ID = B.ACTIVITY_VERSION_ID
268: and T.LANGUAGE = L.LANGUAGE_CODE);
269: end ADD_LANGUAGE;
270: