APPS.IBW_PAGES_PUB dependencies on IBW_PAGES_TL

Line 88: INSERT INTO ibw_pages_tl(page_id, language, source_lang, page_name, description, created_by, creation_date,

84: l_prog_appl_id -- Code Added,Not generated by AFTBLGEN
85: );
86:
87:
88: INSERT INTO ibw_pages_tl(page_id, language, source_lang, page_name, description, created_by, creation_date,
89: last_updated_by, last_update_date, last_update_login, object_version_number,
90: program_id, program_login_id, program_application_id, request_id)
91: SELECT M.page_id, l.language_code, b.language_code, x_page_name, x_description, M.created_by, M.creation_date,
92: M.last_updated_by, M.last_update_date, M.last_update_login, M.object_version_number,

Line 147: FROM IBW_PAGES_TL

143: DECODE (LANGUAGE,
144: USERENV ('LANG'), 'Y',
145: 'N'
146: ) baselang
147: FROM IBW_PAGES_TL
148: WHERE page_id = x_page_id
149: AND USERENV ('LANG') IN (LANGUAGE, source_lang)
150: FOR UPDATE OF page_id NOWAIT;
151: BEGIN

Line 283: UPDATE IBW_PAGES_TL

279: THEN
280: RAISE NO_DATA_FOUND;
281: END IF;
282:
283: UPDATE IBW_PAGES_TL
284: SET page_name = x_page_name,
285: description = x_description,
286: last_update_date = x_last_update_date,
287: last_updated_by = x_last_updated_by,

Line 303: DELETE FROM ibw_pages_tl

299:
300: PROCEDURE DELETE_ROW (x_page_id IN NUMBER)
301: IS
302: BEGIN
303: DELETE FROM ibw_pages_tl
304: WHERE page_id = x_page_id;
305:
306: IF (SQL%NOTFOUND)
307: THEN

Line 323: DELETE FROM IBW_PAGES_TL t

319:
320: PROCEDURE ADD_LANGUAGE
321: IS
322: BEGIN
323: DELETE FROM IBW_PAGES_TL t
324: WHERE NOT EXISTS (SELECT NULL
325: FROM IBW_PAGES_B b
326: WHERE b.page_id = t.page_id);
327:

Line 328: UPDATE IBW_PAGES_TL t

324: WHERE NOT EXISTS (SELECT NULL
325: FROM IBW_PAGES_B b
326: WHERE b.page_id = t.page_id);
327:
328: UPDATE IBW_PAGES_TL t
329: SET (page_name, description) =
330: (SELECT b.page_name, b.description
331: FROM IBW_PAGES_TL b
332: WHERE b.page_id = t.page_id AND b.LANGUAGE = t.source_lang)

Line 331: FROM IBW_PAGES_TL b

327:
328: UPDATE IBW_PAGES_TL t
329: SET (page_name, description) =
330: (SELECT b.page_name, b.description
331: FROM IBW_PAGES_TL b
332: WHERE b.page_id = t.page_id AND b.LANGUAGE = t.source_lang)
333: WHERE (t.page_id, t.LANGUAGE) IN (
334: SELECT subt.page_id, subt.LANGUAGE
335: FROM IBW_PAGES_TL subb, IBW_PAGES_TL subt

Line 335: FROM IBW_PAGES_TL subb, IBW_PAGES_TL subt

331: FROM IBW_PAGES_TL b
332: WHERE b.page_id = t.page_id AND b.LANGUAGE = t.source_lang)
333: WHERE (t.page_id, t.LANGUAGE) IN (
334: SELECT subt.page_id, subt.LANGUAGE
335: FROM IBW_PAGES_TL subb, IBW_PAGES_TL subt
336: WHERE subb.page_id = subt.page_id
337: AND subb.LANGUAGE = subt.source_lang
338: AND ( subb.page_name <> subt.page_name
339: OR subb.description <> subt.description

Line 348: INSERT INTO IBW_PAGES_TL

344: AND subt.description IS NULL
345: )
346: ));
347:
348: INSERT INTO IBW_PAGES_TL
349: (page_id, page_name, description, created_by, creation_date,
350: last_updated_by, last_update_date, last_update_login,
351: object_version_number, program_id, program_login_id,
352: program_application_id, request_id, LANGUAGE, source_lang)

Line 359: FROM IBW_PAGES_TL b, FND_LANGUAGES l

355: b.creation_date, b.last_updated_by, b.last_update_date,
356: b.last_update_login, b.object_version_number, b.program_id,
357: b.program_login_id, b.program_application_id, b.request_id,
358: l.language_code, b.source_lang
359: FROM IBW_PAGES_TL b, FND_LANGUAGES l
360: WHERE l.installed_flag IN ('I', 'B')
361: AND b.LANGUAGE = USERENV ('LANG')
362: AND NOT EXISTS (
363: SELECT NULL

Line 364: FROM ibw_pages_tl t

360: WHERE l.installed_flag IN ('I', 'B')
361: AND b.LANGUAGE = USERENV ('LANG')
362: AND NOT EXISTS (
363: SELECT NULL
364: FROM ibw_pages_tl t
365: WHERE t.page_id = b.page_id
366: AND t.LANGUAGE = l.language_code);
367: END ADD_LANGUAGE;
368:

Line 390: FROM IBW_PAGES_TL

386: f_ludate := NVL (TO_DATE (x_last_update_date, 'YYYY/MM/DD'), SYSDATE);
387:
388: SELECT last_updated_by, last_update_date
389: INTO db_luby, db_ludate
390: FROM IBW_PAGES_TL
391: WHERE page_id = x_page_id AND USERENV ('LANG') = LANGUAGE;
392:
393: IF (fnd_load_util.upload_test (f_luby,
394: f_ludate,

Line 401: UPDATE IBW_PAGES_TL

397: x_custom_mode
398: )
399: )
400: THEN
401: UPDATE IBW_PAGES_TL
402: SET page_name = x_page_name,
403: description = x_description,
404: last_update_date = f_ludate,
405: last_updated_by = f_luby,