APPS.OTA_CTL_SHD dependencies on OTA_CERTIFICATIONS_TL

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

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

55: ,end_date_comments
56: ,initial_period_comments
57: ,renewal_period_comments
58: ,source_lang
59: from ota_certifications_tl
60: where certification_id = p_certification_id
61: and language = p_language;
62: --
63: l_fct_ret boolean;

Line 132: from ota_certifications_tl

128: ,end_date_comments
129: ,initial_period_comments
130: ,renewal_period_comments
131: ,source_lang
132: from ota_certifications_tl
133: where certification_id = p_certification_id
134: and language = p_language
135: for update nowait;
136: --

Line 178: fnd_message.set_token('TABLE_NAME', 'ota_certifications_tl');

174: -- The object is locked therefore we need to supply a meaningful
175: -- error message.
176: --
177: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
178: fnd_message.set_token('TABLE_NAME', 'ota_certifications_tl');
179: fnd_message.raise_error;
180: End lck;
181: --
182: -- ----------------------------------------------------------------------------

Line 191: delete from OTA_CERTIFICATIONS_TL T

187: -- ----------------------------------------------------------------------------
188: procedure ADD_LANGUAGE
189: is
190: begin
191: delete from OTA_CERTIFICATIONS_TL T
192: where not exists
193: (select NULL
194: from OTA_CERTIFICATIONS_B B
195: where B.CERTIFICATION_ID = T.CERTIFICATION_ID

Line 198: update OTA_CERTIFICATIONS_TL T set (

194: from OTA_CERTIFICATIONS_B B
195: where B.CERTIFICATION_ID = T.CERTIFICATION_ID
196: );
197:
198: update OTA_CERTIFICATIONS_TL T set (
199: NAME,
200: DESCRIPTION,
201: OBJECTIVES,
202: PURPOSE,

Line 216: from OTA_CERTIFICATIONS_TL B

212: B.KEYWORDS,
213: B.END_DATE_COMMENTS,
214: B.INITIAL_PERIOD_COMMENTS,
215: B.RENEWAL_PERIOD_COMMENTS
216: from OTA_CERTIFICATIONS_TL B
217: where B.CERTIFICATION_ID = T.CERTIFICATION_ID
218: and B.LANGUAGE = T.SOURCE_LANG)
219: where (
220: T.CERTIFICATION_ID,

Line 225: from OTA_CERTIFICATIONS_TL SUBB, OTA_CERTIFICATIONS_TL SUBT

221: T.LANGUAGE
222: ) in (select
223: SUBT.CERTIFICATION_ID,
224: SUBT.LANGUAGE
225: from OTA_CERTIFICATIONS_TL SUBB, OTA_CERTIFICATIONS_TL SUBT
226: where SUBB.CERTIFICATION_ID = SUBT.CERTIFICATION_ID
227: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
228: and (SUBB.NAME <> SUBT.NAME
229: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 252: insert into OTA_CERTIFICATIONS_TL (

248: or (SUBB.RENEWAL_PERIOD_COMMENTS is null and SUBT.RENEWAL_PERIOD_COMMENTS is not null)
249: or (SUBB.RENEWAL_PERIOD_COMMENTS is not null and SUBT.RENEWAL_PERIOD_COMMENTS is null)
250: ));
251:
252: insert into OTA_CERTIFICATIONS_TL (
253: LAST_UPDATE_DATE,
254: OBJECTIVES,
255: PURPOSE,
256: KEYWORDS,

Line 286: from OTA_CERTIFICATIONS_TL B, FND_LANGUAGES L

282: B.CERTIFICATION_ID,
283: B.LAST_UPDATED_BY,
284: L.LANGUAGE_CODE,
285: B.SOURCE_LANG
286: from OTA_CERTIFICATIONS_TL B, FND_LANGUAGES L
287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL

Line 291: from OTA_CERTIFICATIONS_TL T

287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL
291: from OTA_CERTIFICATIONS_TL T
292: where T.CERTIFICATION_ID = B.CERTIFICATION_ID
293: and T.LANGUAGE = L.LANGUAGE_CODE);
294: end ADD_LANGUAGE;
295: --