APPS.OTA_CFT_SHD dependencies on OTA_CONFERENCE_SERVERS_TL

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

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

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

Line 120: from ota_conference_servers_tl

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

Line 166: fnd_message.set_token('TABLE_NAME', 'ota_conference_servers_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_conference_servers_tl');
167: fnd_message.raise_error;
168: End lck;
169: --
170: -- ----------------------------------------------------------------------------

Line 178: delete from OTA_CONFERENCE_SERVERS_TL T

174: -- Added for Bug#4310348
175: procedure ADD_LANGUAGE
176: is
177: begin
178: delete from OTA_CONFERENCE_SERVERS_TL T
179: where not exists
180: (select NULL
181: from OTA_CONFERENCE_SERVERS_B B
182: where B.CONFERENCE_SERVER_ID = T.CONFERENCE_SERVER_ID);

Line 184: update OTA_CONFERENCE_SERVERS_TL T set ( NAME,

180: (select NULL
181: from OTA_CONFERENCE_SERVERS_B B
182: where B.CONFERENCE_SERVER_ID = T.CONFERENCE_SERVER_ID);
183:
184: update OTA_CONFERENCE_SERVERS_TL T set ( NAME,
185: DESCRIPTION
186: ) = (select
187: B.NAME,
188: B.DESCRIPTION

Line 189: from OTA_CONFERENCE_SERVERS_TL B

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

Line 198: from OTA_CONFERENCE_SERVERS_TL SUBB, OTA_CONFERENCE_SERVERS_TL SUBT

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

Line 207: insert into OTA_CONFERENCE_SERVERS_TL (

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

Line 229: from OTA_CONFERENCE_SERVERS_TL B, FND_LANGUAGES L

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

Line 234: from OTA_CONFERENCE_SERVERS_TL T

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