APPS.AMS_IBA_PL_PAGES_B_PKG dependencies on AMS_IBA_PL_PAGES_TL

Line 99: INSERT INTO ams_iba_pl_pages_tl (

95:
96: AMS_UTILITY_PVT.debug_message( 'Table Handler : Just before insert into tl table');
97: END IF;
98:
99: INSERT INTO ams_iba_pl_pages_tl (
100: page_id,
101: name,
102: description,
103: created_by,

Line 127: FROM ams_iba_pl_pages_tl t

123: FROM fnd_languages l
124: WHERE l.installed_flag in ('I', 'B')
125: AND NOT EXISTS(
126: SELECT NULL
127: FROM ams_iba_pl_pages_tl t
128: WHERE t.page_id = DECODE( px_page_id, FND_API.g_miss_num, NULL, px_page_id)
129: AND t.language = l.language_code);
130: IF (AMS_DEBUG_HIGH_ON) THEN
131:

Line 185: UPDATE ams_iba_pl_pages_tl

181: IF (SQL%NOTFOUND) THEN
182: RAISE no_data_found;
183: END IF;
184:
185: UPDATE ams_iba_pl_pages_tl
186: SET
187: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
188: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 228: DELETE FROM ams_iba_pl_pages_tL

224: IF (SQL%NOTFOUND) THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: END IF;
227:
228: DELETE FROM ams_iba_pl_pages_tL
229: WHERE PAGE_ID = p_page_id;
230:
231: IF (SQL%NOTFOUND) THEN
232: RAISE no_data_found;

Line 242: delete from AMS_IBA_PL_PAGES_TL T

238:
239: procedure ADD_LANGUAGE
240: is
241: begin
242: delete from AMS_IBA_PL_PAGES_TL T
243: where not exists
244: (select NULL
245: from AMS_IBA_PL_PAGES_B B
246: where B.PAGE_ID = T.PAGE_ID

Line 249: update AMS_IBA_PL_PAGES_TL T set (

245: from AMS_IBA_PL_PAGES_B B
246: where B.PAGE_ID = T.PAGE_ID
247: );
248:
249: update AMS_IBA_PL_PAGES_TL T set (
250: NAME,
251: description
252: ) = (select
253: B.NAME,

Line 255: from AMS_IBA_PL_PAGES_TL B

251: description
252: ) = (select
253: B.NAME,
254: B.description
255: from AMS_IBA_PL_PAGES_TL B
256: where B.PAGE_ID = T.PAGE_ID
257: and B.LANGUAGE = T.SOURCE_LANG)
258: where (
259: T.PAGE_ID,

Line 264: from AMS_IBA_PL_PAGES_TL SUBB, AMS_IBA_PL_PAGES_TL SUBT

260: T.LANGUAGE
261: ) in (select
262: SUBT.PAGE_ID,
263: SUBT.LANGUAGE
264: from AMS_IBA_PL_PAGES_TL SUBB, AMS_IBA_PL_PAGES_TL SUBT
265: where SUBB.PAGE_ID = SUBT.PAGE_ID
266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.NAME <> SUBT.NAME
268: or SUBB.LANGUAGE <> SUBT.LANGUAGE

Line 271: insert into AMS_IBA_PL_PAGES_TL (

267: and (SUBB.NAME <> SUBT.NAME
268: or SUBB.LANGUAGE <> SUBT.LANGUAGE
269: ));
270:
271: insert into AMS_IBA_PL_PAGES_TL (
272: LAST_UPDATE_DATE,
273: CREATION_DATE,
274: LAST_UPDATED_BY,
275: CREATED_BY,

Line 295: from AMS_IBA_PL_PAGES_TL B, FND_LANGUAGES L

291: B.LAST_UPDATE_LOGIN,
292: B.OBJECT_VERSION_NUMBER,
293: L.LANGUAGE_CODE,
294: B.SOURCE_LANG
295: from AMS_IBA_PL_PAGES_TL B, FND_LANGUAGES L
296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL

Line 300: from AMS_IBA_PL_PAGES_TL T

296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL
300: from AMS_IBA_PL_PAGES_TL T
301: where T.PAGE_ID = B.PAGE_ID
302: and T.LANGUAGE = L.LANGUAGE_CODE);
303: end ADD_LANGUAGE;
304:

Line 402: from ams_iba_pl_pages_tl

398: )
399: IS
400: cursor c_last_updated_by is
401: select last_updated_by
402: from ams_iba_pl_pages_tl
403: where page_id = X_page_ID
404: and USERENV('LANG') = LANGUAGE;
405:
406: l_luby number; --last updated by

Line 415: update ams_iba_pl_pages_tl set

411: close c_last_updated_by;
412:
413: if (l_luby IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
414: then
415: update ams_iba_pl_pages_tl set
416: name = nvl(x_name, name),
417: description = nvl(x_description, description),
418: source_lang = userenv('LANG'),
419: last_update_date = sysdate,