APPS.AMS_DM_TARGET_VALUES_B_PKG dependencies on AMS_DM_TARGET_VALUES_TL

Line 90: INSERT INTO ams_dm_target_values_tl(

86: DECODE( p_range_value, FND_API.g_miss_char, NULL, p_range_value)
87: );
88:
89: -- Insert target value description into TL table
90: INSERT INTO ams_dm_target_values_tl(
91: target_value_id,
92: language,
93: last_update_date,
94: last_updated_by,

Line 115: FROM ams_dm_target_values_tl t

111: FROM fnd_languages l
112: WHERE l.installed_flag in ('I', 'B')
113: AND NOT EXISTS(
114: SELECT NULL
115: FROM ams_dm_target_values_tl t
116: WHERE t.target_value_id = decode( px_target_value_id, FND_API.G_MISS_NUM, NULL, px_target_value_id)
117: AND t.language = l.language_code );
118: END Insert_Row;
119:

Line 165: update ams_dm_target_values_tl set

161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163:
164: -- update target value description in TL table
165: update ams_dm_target_values_tl set
166: description = decode( p_description, FND_API.G_MISS_CHAR, DESCRIPTION, p_description),
167: last_update_date = SYSDATE,
168: last_updated_by = FND_GLOBAL.user_id,
169: last_update_login = FND_GLOBAL.conc_login_id,

Line 201: DELETE FROM ams_dm_target_values_tl

197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: End If;
199:
200:
201: DELETE FROM ams_dm_target_values_tl
202: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID;
203: If (SQL%NOTFOUND) then
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205: End If;

Line 267: delete from AMS_DM_TARGET_VALUES_TL T

263: PROCEDURE add_language
264: IS
265: BEGIN
266:
267: delete from AMS_DM_TARGET_VALUES_TL T
268: where not exists
269: (select NULL
270: from AMS_DM_TARGET_VALUES_B B
271: where B.TARGET_VALUE_ID = T.TARGET_VALUE_ID

Line 274: update AMS_DM_TARGET_VALUES_TL T set (

270: from AMS_DM_TARGET_VALUES_B B
271: where B.TARGET_VALUE_ID = T.TARGET_VALUE_ID
272: );
273:
274: update AMS_DM_TARGET_VALUES_TL T set (
275: DESCRIPTION
276: ) = (select
277: B.DESCRIPTION
278: from AMS_DM_TARGET_VALUES_TL B

Line 278: from AMS_DM_TARGET_VALUES_TL B

274: update AMS_DM_TARGET_VALUES_TL T set (
275: DESCRIPTION
276: ) = (select
277: B.DESCRIPTION
278: from AMS_DM_TARGET_VALUES_TL B
279: where B.TARGET_VALUE_ID = T.TARGET_VALUE_ID
280: and B.LANGUAGE = T.SOURCE_LANG)
281: where (
282: T.TARGET_VALUE_ID,

Line 287: from AMS_DM_TARGET_VALUES_TL SUBB, AMS_DM_TARGET_VALUES_TL SUBT

283: T.LANGUAGE
284: ) in (select
285: SUBT.TARGET_VALUE_ID,
286: SUBT.LANGUAGE
287: from AMS_DM_TARGET_VALUES_TL SUBB, AMS_DM_TARGET_VALUES_TL SUBT
288: where SUBB.TARGET_VALUE_ID = SUBT.TARGET_VALUE_ID
289: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
290: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
291: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 295: insert into AMS_DM_TARGET_VALUES_TL (

291: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
292: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
293: ));
294:
295: insert into AMS_DM_TARGET_VALUES_TL (
296: TARGET_VALUE_ID,
297: LAST_UPDATE_DATE,
298: LAST_UPDATED_BY,
299: CREATION_DATE,

Line 315: from AMS_DM_TARGET_VALUES_TL B, FND_LANGUAGES L

311: B.LAST_UPDATE_LOGIN,
312: B.DESCRIPTION,
313: L.LANGUAGE_CODE,
314: B.SOURCE_LANG
315: from AMS_DM_TARGET_VALUES_TL B, FND_LANGUAGES L
316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL

Line 320: from AMS_DM_TARGET_VALUES_TL T

316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL
320: from AMS_DM_TARGET_VALUES_TL T
321: where T.TARGET_VALUE_ID = B.TARGET_VALUE_ID
322: and T.LANGUAGE = L.LANGUAGE_CODE);
323: END add_language;
324:

Line 333: update ams_dm_target_values_tl set

329: x_owner IN VARCHAR2
330: )
331: IS
332: BEGIN
333: update ams_dm_target_values_tl set
334: description = nvl(x_description, description),
335: source_lang = userenv('LANG'),
336: last_update_date = sysdate,
337: last_updated_by = decode(x_owner, 'SEED', 1, 0),