APPS.OTA_ENT_SHD dependencies on OTA_EVENTS

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

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

48: event_id
49: ,language
50: ,title
51: ,source_lang
52: from ota_events_tl
53: where event_id = p_event_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from ota_events_tl

114: event_id
115: ,language
116: ,title
117: ,source_lang
118: from ota_events_tl
119: where event_id = p_event_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'ota_events_tl');

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

Line 179: delete from OTA_EVENTS_TL T

175: -- ----------------------------------------------------------------------------
176: procedure ADD_LANGUAGE
177: is
178: begin
179: delete from OTA_EVENTS_TL T
180: where not exists
181: (select NULL
182: from OTA_EVENTS B
183: where B.EVENT_ID = T.EVENT_ID

Line 182: from OTA_EVENTS B

178: begin
179: delete from OTA_EVENTS_TL T
180: where not exists
181: (select NULL
182: from OTA_EVENTS B
183: where B.EVENT_ID = T.EVENT_ID
184: );
185:
186: update OTA_EVENTS_TL T set (

Line 186: update OTA_EVENTS_TL T set (

182: from OTA_EVENTS B
183: where B.EVENT_ID = T.EVENT_ID
184: );
185:
186: update OTA_EVENTS_TL T set (
187: TITLE
188: ) = (select
189: B.TITLE
190: from OTA_EVENTS_TL B

Line 190: from OTA_EVENTS_TL B

186: update OTA_EVENTS_TL T set (
187: TITLE
188: ) = (select
189: B.TITLE
190: from OTA_EVENTS_TL B
191: where B.EVENT_ID = T.EVENT_ID
192: and B.LANGUAGE = T.SOURCE_LANG)
193: where (
194: T.EVENT_ID,

Line 199: from OTA_EVENTS_TL SUBB, OTA_EVENTS_TL SUBT

195: T.LANGUAGE
196: ) in (select
197: SUBT.EVENT_ID,
198: SUBT.LANGUAGE
199: from OTA_EVENTS_TL SUBB, OTA_EVENTS_TL SUBT
200: where SUBB.EVENT_ID = SUBT.EVENT_ID
201: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
202: and (SUBB.TITLE <> SUBT.TITLE
203: ));

Line 205: insert into OTA_EVENTS_TL (

201: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
202: and (SUBB.TITLE <> SUBT.TITLE
203: ));
204:
205: insert into OTA_EVENTS_TL (
206: EVENT_ID,
207: TITLE,
208: CREATED_BY,
209: CREATION_DATE,

Line 225: from OTA_EVENTS_TL B, FND_LANGUAGES L

221: B.LAST_UPDATED_BY,
222: B.LAST_UPDATE_LOGIN,
223: L.LANGUAGE_CODE,
224: B.SOURCE_LANG
225: from OTA_EVENTS_TL B, FND_LANGUAGES L
226: where L.INSTALLED_FLAG in ('I', 'B')
227: and B.LANGUAGE = userenv('LANG')
228: and not exists
229: (select NULL

Line 230: from OTA_EVENTS_TL T

226: where L.INSTALLED_FLAG in ('I', 'B')
227: and B.LANGUAGE = userenv('LANG')
228: and not exists
229: (select NULL
230: from OTA_EVENTS_TL T
231: where T.EVENT_ID = B.EVENT_ID
232: and T.LANGUAGE = L.LANGUAGE_CODE);
233: end ADD_LANGUAGE;
234: