APPS.AMS_DM_TARGETS_B_PKG dependencies on AMS_DM_TARGETS_TL

Line 97: INSERT INTO ams_dm_targets_tl(

93: DECODE( p_source_field_id, FND_API.g_miss_num, NULL, p_source_field_id),
94: DECODE( p_target_source_id, FND_API.g_miss_num, NULL, p_target_source_id));
95:
96: -- Insert target_name and description into TL table
97: INSERT INTO ams_dm_targets_tl(
98: target_id,
99: language,
100: last_update_date,
101: last_updated_by,

Line 124: FROM ams_dm_targets_tl t

120: FROM fnd_languages l
121: WHERE l.installed_flag in ('I', 'B')
122: AND NOT EXISTS(
123: SELECT NULL
124: FROM ams_dm_targets_tl t
125: WHERE t.target_id = decode( px_target_id, FND_API.G_MISS_NUM, NULL, px_target_id)
126: AND t.language = l.language_code );
127:
128:

Line 207: AMS_UTILITY_PVT.debug_message('Table Handler Update going to Update ams_dm_targets_tl' );

203: IF (AMS_DEBUG_HIGH_ON) THEN
204:
205:
206:
207: AMS_UTILITY_PVT.debug_message('Table Handler Update going to Update ams_dm_targets_tl' );
208:
209: END IF;
210:
211: -- update target name and description in TL table

Line 212: update ams_dm_targets_tl set

208:
209: END IF;
210:
211: -- update target name and description in TL table
212: update ams_dm_targets_tl set
213: target_name = decode( p_target_name, FND_API.G_MISS_CHAR, TARGET_NAME, p_target_name),
214: description = decode( p_description, FND_API.G_MISS_CHAR, DESCRIPTION, p_description),
215: last_update_date = SYSDATE,
216: last_updated_by = p_last_updated_by,

Line 249: DELETE FROM ams_dm_targets_tl

245: If (SQL%NOTFOUND) then
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: End If;
248:
249: DELETE FROM ams_dm_targets_tl
250: WHERE TARGET_ID = p_TARGET_ID;
251: If (SQL%NOTFOUND) then
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: End If;

Line 347: delete from AMS_DM_TARGETS_TL T

343:
344: PROCEDURE add_language
345: IS
346: BEGIN
347: delete from AMS_DM_TARGETS_TL T
348: where not exists
349: (select NULL
350: from AMS_DM_TARGETS_B B
351: where B.TARGET_ID = T.TARGET_ID

Line 354: update AMS_DM_TARGETS_TL T set (

350: from AMS_DM_TARGETS_B B
351: where B.TARGET_ID = T.TARGET_ID
352: );
353:
354: update AMS_DM_TARGETS_TL T set (
355: TARGET_NAME,
356: DESCRIPTION
357: ) = (select
358: B.TARGET_NAME,

Line 360: from AMS_DM_TARGETS_TL B

356: DESCRIPTION
357: ) = (select
358: B.TARGET_NAME,
359: B.DESCRIPTION
360: from AMS_DM_TARGETS_TL B
361: where B.TARGET_ID = T.TARGET_ID
362: and B.LANGUAGE = T.SOURCE_LANG)
363: where (
364: T.TARGET_ID,

Line 369: from AMS_DM_TARGETS_TL SUBB, AMS_DM_TARGETS_TL SUBT

365: T.LANGUAGE
366: ) in (select
367: SUBT.TARGET_ID,
368: SUBT.LANGUAGE
369: from AMS_DM_TARGETS_TL SUBB, AMS_DM_TARGETS_TL SUBT
370: where SUBB.TARGET_ID = SUBT.TARGET_ID
371: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
372: and (SUBB.TARGET_NAME <> SUBT.TARGET_NAME
373: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 378: insert into AMS_DM_TARGETS_TL (

374: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
375: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
376: ));
377:
378: insert into AMS_DM_TARGETS_TL (
379: TARGET_ID,
380: LAST_UPDATE_DATE,
381: LAST_UPDATED_BY,
382: CREATION_DATE,

Line 400: from AMS_DM_TARGETS_TL B, FND_LANGUAGES L

396: B.TARGET_NAME,
397: B.DESCRIPTION,
398: L.LANGUAGE_CODE,
399: B.SOURCE_LANG
400: from AMS_DM_TARGETS_TL B, FND_LANGUAGES L
401: where L.INSTALLED_FLAG in ('I', 'B')
402: and B.LANGUAGE = userenv('LANG')
403: and not exists
404: (select NULL

Line 405: from AMS_DM_TARGETS_TL T

401: where L.INSTALLED_FLAG in ('I', 'B')
402: and B.LANGUAGE = userenv('LANG')
403: and not exists
404: (select NULL
405: from AMS_DM_TARGETS_TL T
406: where T.TARGET_ID = B.TARGET_ID
407: and T.LANGUAGE = L.LANGUAGE_CODE);
408: END add_language;
409:

Line 418: update ams_dm_targets_tl set

414: x_owner IN VARCHAR2
415: )
416: IS
417: BEGIN
418: update ams_dm_targets_tl set
419: target_name = nvl(x_target_name, target_name),
420: description = nvl(x_description, description),
421: source_lang = userenv('LANG'),
422: last_update_date = sysdate,