APPS.OTA_BSL_SHD dependencies on OTA_BOOKING_STATUS_TYPES_TL

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

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

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

Line 120: from ota_booking_status_types_tl

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

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

Line 182: delete from OTA_BOOKING_STATUS_TYPES_TL T

178: -- ----------------------------------------------------------------------------
179: procedure ADD_LANGUAGE
180: is
181: begin
182: delete from OTA_BOOKING_STATUS_TYPES_TL T
183: where not exists
184: (select NULL
185: from OTA_BOOKING_STATUS_TYPES B
186: where B.BOOKING_STATUS_TYPE_ID = T.BOOKING_STATUS_TYPE_ID

Line 189: update OTA_BOOKING_STATUS_TYPES_TL T set (

185: from OTA_BOOKING_STATUS_TYPES B
186: where B.BOOKING_STATUS_TYPE_ID = T.BOOKING_STATUS_TYPE_ID
187: );
188:
189: update OTA_BOOKING_STATUS_TYPES_TL T set (
190: NAME,
191: DESCRIPTION
192: ) = (select
193: B.NAME,

Line 195: from OTA_BOOKING_STATUS_TYPES_TL B

191: DESCRIPTION
192: ) = (select
193: B.NAME,
194: B.DESCRIPTION
195: from OTA_BOOKING_STATUS_TYPES_TL B
196: where B.BOOKING_STATUS_TYPE_ID = T.BOOKING_STATUS_TYPE_ID
197: and B.LANGUAGE = T.SOURCE_LANG)
198: where (
199: T.BOOKING_STATUS_TYPE_ID,

Line 204: from OTA_BOOKING_STATUS_TYPES_TL SUBB, OTA_BOOKING_STATUS_TYPES_TL SUBT

200: T.LANGUAGE
201: ) in (select
202: SUBT.BOOKING_STATUS_TYPE_ID,
203: SUBT.LANGUAGE
204: from OTA_BOOKING_STATUS_TYPES_TL SUBB, OTA_BOOKING_STATUS_TYPES_TL SUBT
205: where SUBB.BOOKING_STATUS_TYPE_ID = SUBT.BOOKING_STATUS_TYPE_ID
206: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
207: and (SUBB.NAME <> SUBT.NAME
208: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 215: insert into OTA_BOOKING_STATUS_TYPES_TL (

211: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
212: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
213: ));
214:
215: insert into OTA_BOOKING_STATUS_TYPES_TL (
216: BOOKING_STATUS_TYPE_ID,
217: NAME,
218: DESCRIPTION,
219: CREATED_BY,

Line 237: from OTA_BOOKING_STATUS_TYPES_TL B, FND_LANGUAGES L

233: B.LAST_UPDATE_DATE,
234: B.LAST_UPDATE_LOGIN,
235: L.LANGUAGE_CODE,
236: B.SOURCE_LANG
237: from OTA_BOOKING_STATUS_TYPES_TL B, FND_LANGUAGES L
238: where L.INSTALLED_FLAG in ('I', 'B')
239: and B.LANGUAGE = userenv('LANG')
240: and not exists
241: (select NULL

Line 242: from OTA_BOOKING_STATUS_TYPES_TL T

238: where L.INSTALLED_FLAG in ('I', 'B')
239: and B.LANGUAGE = userenv('LANG')
240: and not exists
241: (select NULL
242: from OTA_BOOKING_STATUS_TYPES_TL T
243: where T.BOOKING_STATUS_TYPE_ID = B.BOOKING_STATUS_TYPE_ID
244: and T.LANGUAGE = L.LANGUAGE_CODE);
245: end ADD_LANGUAGE;
246: --