APPS.OTA_BJT_SHD dependencies on OTA_BKNG_JUSTIFICATIONS_TL

Line 52: from ota_bkng_justifications_tl

48: booking_justification_id
49: ,justification_text
50: ,source_lang
51: ,language
52: from ota_bkng_justifications_tl
53: where booking_justification_id = p_booking_justification_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 117: from ota_bkng_justifications_tl

113: booking_justification_id
114: ,justification_text
115: ,source_lang
116: ,language
117: from ota_bkng_justifications_tl
118: where booking_justification_id = p_booking_justification_id
119: and language = p_language
120: for update nowait;
121: --

Line 162: fnd_message.set_token('TABLE_NAME', 'ota_bkng_justifications_tl');

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

Line 172: delete from OTA_BKNG_JUSTIFICATIONS_TL T

168: -- ----------------------------------------------------------------------------
169: procedure ADD_LANGUAGE
170: is
171: begin
172: delete from OTA_BKNG_JUSTIFICATIONS_TL T
173: where not exists
174: (select NULL
175: from OTA_BKNG_JUSTIFICATIONS_B B
176: where B.BOOKING_JUSTIFICATION_ID = T.BOOKING_JUSTIFICATION_ID

Line 179: update OTA_BKNG_JUSTIFICATIONS_TL T set (

175: from OTA_BKNG_JUSTIFICATIONS_B B
176: where B.BOOKING_JUSTIFICATION_ID = T.BOOKING_JUSTIFICATION_ID
177: );
178:
179: update OTA_BKNG_JUSTIFICATIONS_TL T set (
180: JUSTIFICATION_TEXT
181: ) = (select
182: B.JUSTIFICATION_TEXT
183: from OTA_BKNG_JUSTIFICATIONS_TL B

Line 183: from OTA_BKNG_JUSTIFICATIONS_TL B

179: update OTA_BKNG_JUSTIFICATIONS_TL T set (
180: JUSTIFICATION_TEXT
181: ) = (select
182: B.JUSTIFICATION_TEXT
183: from OTA_BKNG_JUSTIFICATIONS_TL B
184: where B.BOOKING_JUSTIFICATION_ID = T.BOOKING_JUSTIFICATION_ID
185: and B.LANGUAGE = T.SOURCE_LANG)
186: where (
187: T.BOOKING_JUSTIFICATION_ID,

Line 192: from OTA_BKNG_JUSTIFICATIONS_TL SUBB, OTA_BKNG_JUSTIFICATIONS_TL SUBT

188: T.LANGUAGE
189: ) in (select
190: SUBT.BOOKING_JUSTIFICATION_ID,
191: SUBT.LANGUAGE
192: from OTA_BKNG_JUSTIFICATIONS_TL SUBB, OTA_BKNG_JUSTIFICATIONS_TL SUBT
193: where SUBB.BOOKING_JUSTIFICATION_ID = SUBT.BOOKING_JUSTIFICATION_ID
194: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
195: and (SUBB.JUSTIFICATION_TEXT <> SUBT.JUSTIFICATION_TEXT
196: ));

Line 198: insert into OTA_BKNG_JUSTIFICATIONS_TL (

194: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
195: and (SUBB.JUSTIFICATION_TEXT <> SUBT.JUSTIFICATION_TEXT
196: ));
197:
198: insert into OTA_BKNG_JUSTIFICATIONS_TL (
199: BOOKING_JUSTIFICATION_ID,
200: JUSTIFICATION_TEXT,
201: CREATED_BY,
202: CREATION_DATE,

Line 218: from OTA_BKNG_JUSTIFICATIONS_TL B, FND_LANGUAGES L

214: B.LAST_UPDATED_BY,
215: B.LAST_UPDATE_LOGIN,
216: L.LANGUAGE_CODE,
217: B.SOURCE_LANG
218: from OTA_BKNG_JUSTIFICATIONS_TL B, FND_LANGUAGES L
219: where L.INSTALLED_FLAG in ('I', 'B')
220: and B.LANGUAGE = userenv('LANG')
221: and not exists
222: (select NULL

Line 223: from OTA_BKNG_JUSTIFICATIONS_TL T

219: where L.INSTALLED_FLAG in ('I', 'B')
220: and B.LANGUAGE = userenv('LANG')
221: and not exists
222: (select NULL
223: from OTA_BKNG_JUSTIFICATIONS_TL T
224: where T.BOOKING_JUSTIFICATION_ID = B.BOOKING_JUSTIFICATION_ID
225: and T.LANGUAGE = L.LANGUAGE_CODE);
226: end ADD_LANGUAGE;
227: