APPS.OTA_LST_SHD dependencies on OTA_LP_SECTIONS

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

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

49: ,language
50: ,name
51: ,description
52: ,source_lang
53: from ota_lp_sections_tl
54: where learning_path_section_id = p_learning_path_section_id
55: and language = p_language;
56: --
57: l_fct_ret boolean;

Line 120: from ota_lp_sections_tl

116: ,language
117: ,name
118: ,description
119: ,source_lang
120: from ota_lp_sections_tl
121: where learning_path_section_id = p_learning_path_section_id
122: and language = p_language
123: for update nowait;
124: --

Line 166: fnd_message.set_token('TABLE_NAME', 'ota_lp_sections_tl');

162: -- The object is locked therefore we need to supply a meaningful
163: -- error message.
164: --
165: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
166: fnd_message.set_token('TABLE_NAME', 'ota_lp_sections_tl');
167: fnd_message.raise_error;
168: End lck;
169: --
170: -- ----------------------------------------------------------------------------

Line 177: delete from OTA_LP_SECTIONS_TL T

173: -- Added for Bug#4310348
174: procedure ADD_LANGUAGE
175: is
176: begin
177: delete from OTA_LP_SECTIONS_TL T
178: where not exists
179: (select NULL
180: from OTA_LP_SECTIONS B
181: where B.LEARNING_PATH_SECTION_ID = T.LEARNING_PATH_SECTION_ID

Line 180: from OTA_LP_SECTIONS B

176: begin
177: delete from OTA_LP_SECTIONS_TL T
178: where not exists
179: (select NULL
180: from OTA_LP_SECTIONS B
181: where B.LEARNING_PATH_SECTION_ID = T.LEARNING_PATH_SECTION_ID
182: );
183:
184: update OTA_LP_SECTIONS_TL T set (

Line 184: update OTA_LP_SECTIONS_TL T set (

180: from OTA_LP_SECTIONS B
181: where B.LEARNING_PATH_SECTION_ID = T.LEARNING_PATH_SECTION_ID
182: );
183:
184: update OTA_LP_SECTIONS_TL T set (
185: NAME,
186: DESCRIPTION
187: ) = (select
188: B.NAME,

Line 190: from OTA_LP_SECTIONS_TL B

186: DESCRIPTION
187: ) = (select
188: B.NAME,
189: B.DESCRIPTION
190: from OTA_LP_SECTIONS_TL B
191: where B.LEARNING_PATH_SECTION_ID = T.LEARNING_PATH_SECTION_ID
192: and B.LANGUAGE = T.SOURCE_LANG)
193: where (
194: T.LEARNING_PATH_SECTION_ID,

Line 199: from OTA_LP_SECTIONS_TL SUBB, OTA_LP_SECTIONS_TL SUBT

195: T.LANGUAGE
196: ) in (select
197: SUBT.LEARNING_PATH_SECTION_ID,
198: SUBT.LANGUAGE
199: from OTA_LP_SECTIONS_TL SUBB, OTA_LP_SECTIONS_TL SUBT
200: where SUBB.LEARNING_PATH_SECTION_ID = SUBT.LEARNING_PATH_SECTION_ID
201: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
202: and (SUBB.NAME <> SUBT.NAME
203: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 208: insert into OTA_LP_SECTIONS_TL (

204: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
205: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
206: ));
207:
208: insert into OTA_LP_SECTIONS_TL (
209: CREATION_DATE,
210: LAST_UPDATE_DATE,
211: LAST_UPDATED_BY,
212: LAST_UPDATE_LOGIN,

Line 230: from OTA_LP_SECTIONS_TL B, FND_LANGUAGES L

226: B.CREATED_BY,
227: B.LEARNING_PATH_SECTION_ID,
228: L.LANGUAGE_CODE,
229: B.SOURCE_LANG
230: from OTA_LP_SECTIONS_TL B, FND_LANGUAGES L
231: where L.INSTALLED_FLAG in ('I', 'B')
232: and B.LANGUAGE = userenv('LANG')
233: and not exists
234: (select NULL

Line 235: from OTA_LP_SECTIONS_TL T

231: where L.INSTALLED_FLAG in ('I', 'B')
232: and B.LANGUAGE = userenv('LANG')
233: and not exists
234: (select NULL
235: from OTA_LP_SECTIONS_TL T
236: where T.LEARNING_PATH_SECTION_ID = B.LEARNING_PATH_SECTION_ID
237: and T.LANGUAGE = L.LANGUAGE_CODE);
238: end ADD_LANGUAGE;
239: --