APPS.AMS_IBA_PL_STYLESHTS_B_PKG dependencies on AMS_IBA_PL_STYLESHTS_TL

Line 99: insert into AMS_IBA_PL_STYLESHTS_TL (

95: AMS_UTILITY_PVT.debug_message( 'table handler : after insert into B table');
96:
97: END IF;
98:
99: insert into AMS_IBA_PL_STYLESHTS_TL (
100: LAST_UPDATE_LOGIN,
101: OBJECT_VERSION_NUMBER,
102: STYLESHEET_ID,
103: NAME,

Line 127: from AMS_IBA_PL_STYLESHTS_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_STYLESHTS_TL T
128: where T.STYLESHEET_ID = DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id)
129: and T.LANGUAGE = L.LANGUAGE_CODE);
130:
131: IF (AMS_DEBUG_HIGH_ON) THEN

Line 189: UPDATE ams_iba_pl_styleshts_tl SET

185: IF (SQL%NOTFOUND) THEN
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188:
189: UPDATE ams_iba_pl_styleshts_tl SET
190: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
191: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
192: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
193: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 233: DELETE FROM ams_iba_pl_styleshts_tl

229: If (SQL%NOTFOUND) then
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: End If;
232:
233: DELETE FROM ams_iba_pl_styleshts_tl
234: WHERE stylesheet_id = p_stylesheet_id;
235:
236: END Delete_Row ;
237:

Line 241: delete from AMS_IBA_PL_STYLESHTS_TL T

237:
238: procedure ADD_LANGUAGE
239: is
240: begin
241: delete from AMS_IBA_PL_STYLESHTS_TL T
242: where not exists
243: (select NULL
244: from AMS_IBA_PL_STYLESHTS_B B
245: where B.STYLESHEET_ID = T.STYLESHEET_ID

Line 248: update AMS_IBA_PL_STYLESHTS_TL T set (

244: from AMS_IBA_PL_STYLESHTS_B B
245: where B.STYLESHEET_ID = T.STYLESHEET_ID
246: );
247:
248: update AMS_IBA_PL_STYLESHTS_TL T set (
249: NAME,
250: DESCRIPTION
251: ) = (select
252: B.NAME,

Line 254: from AMS_IBA_PL_STYLESHTS_TL B

250: DESCRIPTION
251: ) = (select
252: B.NAME,
253: B.DESCRIPTION
254: from AMS_IBA_PL_STYLESHTS_TL B
255: where B.STYLESHEET_ID = T.STYLESHEET_ID
256: and B.LANGUAGE = T.SOURCE_LANG)
257: where (
258: T.STYLESHEET_ID,

Line 263: from AMS_IBA_PL_STYLESHTS_TL SUBB, AMS_IBA_PL_STYLESHTS_TL SUBT

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

Line 272: insert into AMS_IBA_PL_STYLESHTS_TL (

268: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
269: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
270: ));
271:
272: insert into AMS_IBA_PL_STYLESHTS_TL (
273: OBJECT_VERSION_NUMBER,
274: CREATED_BY,
275: CREATION_DATE,
276: LAST_UPDATED_BY,

Line 296: from AMS_IBA_PL_STYLESHTS_TL B, FND_LANGUAGES L

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

Line 301: from AMS_IBA_PL_STYLESHTS_TL T

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

Line 398: from AMS_IBA_PL_STYLESHTS_TL

394: )
395: IS
396: cursor c_last_updated_by is
397: select last_updated_by
398: from AMS_IBA_PL_STYLESHTS_TL
399: where stylesheet_id = x_stylesheet_id
400: and USERENV('LANG') = LANGUAGE;
401:
402: l_luby number; --last updated by

Line 412: update AMS_IBA_PL_STYLESHTS_TL set

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