APPS.AMS_IBA_PL_PARAMETERS_B_PKG dependencies on AMS_IBA_PL_PARAMETERS_TL

Line 84: insert into AMS_IBA_PL_PARAMETERS_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_PARAMETERS_TL (
85: PARAMETER_ID,
86: NAME,
87: DESCRIPTION,
88: CREATED_BY,

Line 111: from AMS_IBA_PL_PARAMETERS_TL T

107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists
110: (select NULL
111: from AMS_IBA_PL_PARAMETERS_TL T
112: where T.PARAMETER_ID = DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id)
113: and T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: END Insert_Row;

Line 169: UPDATE ams_iba_pl_parameters_tl

165: IF (SQL%NOTFOUND) THEN
166: RAISE no_data_found;
167: END IF;
168:
169: UPDATE ams_iba_pl_parameters_tl
170: SET
171: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
172: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
173: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 218: delete from AMS_IBA_PL_PARAMETERS_TL T

214:
215: procedure ADD_LANGUAGE
216: is
217: begin
218: delete from AMS_IBA_PL_PARAMETERS_TL T
219: where not exists
220: (select NULL
221: from AMS_IBA_PL_PARAMETERS_B B
222: where B.PARAMETER_ID = T.PARAMETER_ID

Line 225: update AMS_IBA_PL_PARAMETERS_TL T set (

221: from AMS_IBA_PL_PARAMETERS_B B
222: where B.PARAMETER_ID = T.PARAMETER_ID
223: );
224:
225: update AMS_IBA_PL_PARAMETERS_TL T set (
226: NAME,
227: description
228: ) = (select
229: B.NAME,

Line 231: from AMS_IBA_PL_PARAMETERS_TL B

227: description
228: ) = (select
229: B.NAME,
230: B.description
231: from AMS_IBA_PL_PARAMETERS_TL B
232: where B.PARAMETER_ID = T.PARAMETER_ID
233: and B.LANGUAGE = T.SOURCE_LANG)
234: where (
235: T.PARAMETER_ID,

Line 240: from AMS_IBA_PL_PARAMETERS_TL SUBB, AMS_IBA_PL_PARAMETERS_TL SUBT

236: T.LANGUAGE
237: ) in (select
238: SUBT.PARAMETER_ID,
239: SUBT.LANGUAGE
240: from AMS_IBA_PL_PARAMETERS_TL SUBB, AMS_IBA_PL_PARAMETERS_TL SUBT
241: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
242: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
243: and (SUBB.NAME <> SUBT.NAME
244: or SUBB.LANGUAGE <> SUBT.LANGUAGE

Line 247: insert into AMS_IBA_PL_PARAMETERS_TL (

243: and (SUBB.NAME <> SUBT.NAME
244: or SUBB.LANGUAGE <> SUBT.LANGUAGE
245: ));
246:
247: insert into AMS_IBA_PL_PARAMETERS_TL (
248: CREATION_DATE,
249: LAST_UPDATED_BY,
250: LAST_UPDATE_DATE,
251: LAST_UPDATE_LOGIN,

Line 271: from AMS_IBA_PL_PARAMETERS_TL B, FND_LANGUAGES L

267: B.DESCRIPTION,
268: B.CREATED_BY,
269: L.LANGUAGE_CODE,
270: B.SOURCE_LANG
271: from AMS_IBA_PL_PARAMETERS_TL B, FND_LANGUAGES L
272: where L.INSTALLED_FLAG in ('I', 'B')
273: and B.LANGUAGE = userenv('LANG')
274: and not exists
275: (select NULL

Line 276: from AMS_IBA_PL_PARAMETERS_TL T

272: where L.INSTALLED_FLAG in ('I', 'B')
273: and B.LANGUAGE = userenv('LANG')
274: and not exists
275: (select NULL
276: from AMS_IBA_PL_PARAMETERS_TL T
277: where T.PARAMETER_ID = B.PARAMETER_ID
278: and T.LANGUAGE = L.LANGUAGE_CODE);
279: end ADD_LANGUAGE;
280:

Line 378: from ams_iba_pl_parameters_tl

374: )
375: IS
376: cursor c_last_updated_by is
377: select last_updated_by
378: from ams_iba_pl_parameters_tl
379: where parameter_id = x_parameter_id
380: and USERENV('LANG') = LANGUAGE;
381:
382: l_luby number; --last updated by

Line 392: update ams_iba_pl_parameters_tl set

388:
389: if (l_luby IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
390: then
391:
392: update ams_iba_pl_parameters_tl set
393: name = nvl(x_name, name),
394: description = nvl(x_description, description),
395: source_lang = userenv('LANG'),
396: last_update_date = sysdate,