APPS.AMS_IBA_PL_SITES_B_PKG dependencies on AMS_IBA_PL_SITES_TL

Line 84: INSERT INTO ams_iba_pl_sites_tl (

80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:
84: INSERT INTO ams_iba_pl_sites_tl (
85: site_id,
86: name,
87: description,
88: created_by,

Line 113: FROM ams_iba_pl_sites_tl t

109: FROM fnd_languages l
110: WHERE l.installed_flag in ('I', 'B')
111: AND NOT EXISTS(
112: SELECT NULL
113: FROM ams_iba_pl_sites_tl t
114: WHERE t.site_id = DECODE( px_site_id, FND_API.g_miss_num, NULL, px_site_id)
115: AND t.language = l.language_code);
116:
117: END Insert_Row;

Line 166: UPDATE ams_iba_pl_sites_tl

162: RAISE no_data_found;
163: END IF;
164:
165:
166: UPDATE ams_iba_pl_sites_tl
167: SET
168: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
169: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
170: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 221: DELETE FROM ams_iba_pl_sites_tl

217: If (SQL%NOTFOUND) then
218: RAISE no_data_found;
219: End If;
220:
221: DELETE FROM ams_iba_pl_sites_tl
222: WHERE site_id = p_site_id
223: AND object_version_number = p_object_version_number;
224:
225: If (SQL%NOTFOUND) then

Line 233: delete from AMS_IBA_PL_SITES_TL T

229:
230: procedure ADD_LANGUAGE
231: is
232: begin
233: delete from AMS_IBA_PL_SITES_TL T
234: where not exists
235: (select NULL
236: from AMS_IBA_PL_SITES_B B
237: where B.SITE_ID = T.SITE_ID

Line 240: update AMS_IBA_PL_SITES_TL T set (

236: from AMS_IBA_PL_SITES_B B
237: where B.SITE_ID = T.SITE_ID
238: );
239:
240: update AMS_IBA_PL_SITES_TL T set (
241: NAME,
242: DESCRIPTION
243: ) = (select
244: B.NAME,

Line 246: from AMS_IBA_PL_SITES_TL B

242: DESCRIPTION
243: ) = (select
244: B.NAME,
245: B.DESCRIPTION
246: from AMS_IBA_PL_SITES_TL B
247: where B.SITE_ID = T.SITE_ID
248: and B.LANGUAGE = T.SOURCE_LANG)
249: where (
250: T.SITE_ID,

Line 255: from AMS_IBA_PL_SITES_TL SUBB, AMS_IBA_PL_SITES_TL SUBT

251: T.LANGUAGE
252: ) in (select
253: SUBT.SITE_ID,
254: SUBT.LANGUAGE
255: from AMS_IBA_PL_SITES_TL SUBB, AMS_IBA_PL_SITES_TL SUBT
256: where SUBB.SITE_ID = SUBT.SITE_ID
257: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
258: and (SUBB.NAME <> SUBT.NAME
259: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 264: insert into AMS_IBA_PL_SITES_TL (

260: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
261: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
262: ));
263:
264: insert into AMS_IBA_PL_SITES_TL (
265: LAST_UPDATED_BY,
266: LAST_UPDATE_DATE,
267: LAST_UPDATE_LOGIN,
268: SECURITY_GROUP_ID,

Line 290: from AMS_IBA_PL_SITES_TL B, FND_LANGUAGES L

286: B.CREATED_BY,
287: B.CREATION_DATE,
288: L.LANGUAGE_CODE,
289: B.SOURCE_LANG
290: from AMS_IBA_PL_SITES_TL B, FND_LANGUAGES L
291: where L.INSTALLED_FLAG in ('I', 'B')
292: and B.LANGUAGE = userenv('LANG')
293: and not exists
294: (select NULL

Line 295: from AMS_IBA_PL_SITES_TL T

291: where L.INSTALLED_FLAG in ('I', 'B')
292: and B.LANGUAGE = userenv('LANG')
293: and not exists
294: (select NULL
295: from AMS_IBA_PL_SITES_TL T
296: where T.SITE_ID = B.SITE_ID
297: and T.LANGUAGE = L.LANGUAGE_CODE);
298: end ADD_LANGUAGE;
299:

Line 396: from ams_iba_pl_sites_tl

392: )
393: IS
394: cursor c_last_updated_by is
395: select last_updated_by
396: from ams_iba_pl_sites_tl
397: where site_id = x_site_id
398: and USERENV('LANG') = LANGUAGE;
399:
400: l_luby number; --last updated by

Line 410: update ams_iba_pl_sites_tl set

406:
407: if (l_luby IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
408: then
409:
410: update ams_iba_pl_sites_tl set
411: name = nvl(x_name, name),
412: description = nvl(x_description, description),
413: source_lang = userenv('LANG'),
414: last_update_date = sysdate,