APPS.IBE_MSITE_RESP_PKG dependencies on IBE_MSITE_RESPS_TL

Line 105: INSERT INTO ibe_msite_resps_tl

101: -- insert tl
102: IF ((p_msite_resp_id IS NULL) OR
103: (p_msite_resp_id = FND_API.G_MISS_NUM))
104: THEN
105: INSERT INTO ibe_msite_resps_tl
106: (
107: msite_resp_id,
108: object_version_number,
109: created_by,

Line 138: FROM ibe_msite_resps_tl T

134: FROM fnd_languages L
135: WHERE L.installed_flag IN ('I', 'B')
136: AND NOT EXISTS
137: (SELECT NULL
138: FROM ibe_msite_resps_tl T
139: WHERE T.msite_resp_id = x_msite_resp_id
140: AND T.language = L.language_code);
141:
142: OPEN c;

Line 198: UPDATE ibe_msite_resps_tl SET

194: RAISE NO_DATA_FOUND;
195: END IF;
196:
197: -- update tl
198: UPDATE ibe_msite_resps_tl SET
199: object_version_number = object_version_number + 1,
200: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
201: display_name, p_display_name),
202: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 232: DELETE FROM ibe_msite_resps_tl

228: p_msite_resp_id IN NUMBER
229: )
230: IS
231: BEGIN
232: DELETE FROM ibe_msite_resps_tl
233: WHERE msite_resp_id = p_msite_resp_id;
234:
235: IF (sql%NOTFOUND) THEN
236: RAISE NO_DATA_FOUND;

Line 251: delete FROM ibe_msite_resps_tl T

247:
248: PROCEDURE add_language
249: IS
250: BEGIN
251: delete FROM ibe_msite_resps_tl T
252: WHERE NOT EXISTS
253: (SELECT NULL
254: FROM ibe_msite_resps_b B
255: WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID

Line 258: UPDATE ibe_msite_resps_tl T SET

254: FROM ibe_msite_resps_b B
255: WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID
256: );
257:
258: UPDATE ibe_msite_resps_tl T SET
259: (
260: DISPLAY_NAME
261: ) = (SELECT
262: B.DISPLAY_NAME

Line 263: FROM ibe_msite_resps_tl B

259: (
260: DISPLAY_NAME
261: ) = (SELECT
262: B.DISPLAY_NAME
263: FROM ibe_msite_resps_tl B
264: WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID
265: AND B.LANGUAGE = T.SOURCE_LANG)
266: WHERE
267: (

Line 273: FROM ibe_msite_resps_tl SUBB, ibe_msite_resps_tl SUBT

269: T.LANGUAGE
270: ) IN (select
271: SUBT.MSITE_RESP_ID,
272: SUBT.LANGUAGE
273: FROM ibe_msite_resps_tl SUBB, ibe_msite_resps_tl SUBT
274: WHERE SUBB.MSITE_RESP_ID = SUBT.MSITE_RESP_ID
275: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
276: AND (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
277: ));

Line 279: INSERT INTO ibe_msite_resps_tl

275: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
276: AND (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
277: ));
278:
279: INSERT INTO ibe_msite_resps_tl
280: (
281: MSITE_RESP_ID,
282: OBJECT_VERSION_NUMBER,
283: CREATED_BY,

Line 302: from ibe_msite_resps_tl b, fnd_languages l

298: b.last_update_login,
299: b.display_name,
300: l.language_code,
301: b.source_lang
302: from ibe_msite_resps_tl b, fnd_languages l
303: where l.installed_flag in ('I', 'B')
304: and b.language = userenv('LANG')
305: and not exists
306: (select null

Line 307: from ibe_msite_resps_tl t

303: where l.installed_flag in ('I', 'B')
304: and b.language = userenv('LANG')
305: and not exists
306: (select null
307: from ibe_msite_resps_tl t
308: where t.msite_resp_id = b.msite_resp_id
309: and t.language = l.language_code);
310: END add_language;
311: