APPS.OTA_LPT_SHD dependencies on OTA_LEARNING_PATHS

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'OTA_LEARNING_PATHS_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_learning_paths_tl

52: ,objectives
53: ,purpose
54: ,keywords
55: ,source_lang
56: from ota_learning_paths_tl
57: where learning_path_id = p_learning_path_id
58: and language = p_language;
59: --
60: l_fct_ret boolean;

Line 126: from ota_learning_paths_tl

122: ,objectives
123: ,purpose
124: ,keywords
125: ,source_lang
126: from ota_learning_paths_tl
127: where learning_path_id = p_learning_path_id
128: and language = p_language
129: for update nowait;
130: --

Line 172: fnd_message.set_token('TABLE_NAME', 'ota_learning_paths_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_learning_paths_tl');
173: fnd_message.raise_error;
174: End lck;
175: --
176: -- ----------------------------------------------------------------------------

Line 187: delete from OTA_LEARNING_PATHS_TL T

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

Line 190: from OTA_LEARNING_PATHS B

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

Line 194: update OTA_LEARNING_PATHS_TL T set (

190: from OTA_LEARNING_PATHS B
191: where B.LEARNING_PATH_ID = T.LEARNING_PATH_ID
192: );
193:
194: update OTA_LEARNING_PATHS_TL T set (
195: NAME,
196: DESCRIPTION,
197: OBJECTIVES,
198: PURPOSE,

Line 206: from OTA_LEARNING_PATHS_TL B

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

Line 215: from OTA_LEARNING_PATHS_TL SUBB, OTA_LEARNING_PATHS_TL SUBT

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

Line 233: insert into OTA_LEARNING_PATHS_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_LEARNING_PATHS_TL (
234: LEARNING_PATH_ID,
235: NAME,
236: DESCRIPTION,
237: OBJECTIVES,

Line 261: from OTA_LEARNING_PATHS_TL B, FND_LANGUAGES L

257: B.LAST_UPDATED_BY,
258: B.LAST_UPDATE_LOGIN,
259: L.LANGUAGE_CODE,
260: B.SOURCE_LANG
261: from OTA_LEARNING_PATHS_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_LEARNING_PATHS_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_LEARNING_PATHS_TL T
267: where T.LEARNING_PATH_ID = B.LEARNING_PATH_ID
268: and T.LANGUAGE = L.LANGUAGE_CODE);
269: end ADD_LANGUAGE;
270: --