APPS.AMS_MET_TPL_HEADERS_B_PKG dependencies on AMS_MET_TPL_HEADERS_TL

Line 97: INSERT INTO AMS_MET_TPL_HEADERS_TL (

93: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
94: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code));
95:
96:
97: INSERT INTO AMS_MET_TPL_HEADERS_TL (
98: METRIC_TPL_HEADER_ID ,
99: LAST_UPDATE_DATE ,
100: LAST_UPDATED_BY ,
101: CREATION_DATE ,

Line 123: FROM AMS_MET_TPL_HEADERS_TL T

119: FROM FND_LANGUAGES L
120: WHERE L.INSTALLED_FLAG IN ('I', 'B')
121: AND NOT EXISTS
122: (SELECT NULL
123: FROM AMS_MET_TPL_HEADERS_TL T
124: WHERE T.METRIC_TPL_HEADER_ID = px_metric_tpl_header_id
125: AND T.LANGUAGE = L.LANGUAGE_CODE);
126: END Insert_Row;
127:

Line 188: UPDATE AMS_MET_TPL_HEADERS_TL SET

184: IF (SQL%NOTFOUND) THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187:
188: UPDATE AMS_MET_TPL_HEADERS_TL SET
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: SOURCE_LANG = USERENV('LANG'),

Line 230: DELETE FROM AMS_MET_TPL_HEADERS_TL

226: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
227: IF (SQL%NOTFOUND) THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: END IF;
230: DELETE FROM AMS_MET_TPL_HEADERS_TL
231: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
232: IF (SQL%NOTFOUND) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;

Line 419: delete from AMS_MET_TPL_HEADERS_TL T

415: -- MLS compatibility.
416: procedure ADD_LANGUAGE
417: is
418: begin
419: delete from AMS_MET_TPL_HEADERS_TL T
420: where not exists
421: (select NULL
422: from AMS_MET_TPL_HEADERS_B B
423: where B.METRIC_TPL_HEADER_ID = T.METRIC_TPL_HEADER_ID

Line 426: update AMS_MET_TPL_HEADERS_TL T set (

422: from AMS_MET_TPL_HEADERS_B B
423: where B.METRIC_TPL_HEADER_ID = T.METRIC_TPL_HEADER_ID
424: );
425:
426: update AMS_MET_TPL_HEADERS_TL T set (
427: METRIC_TPL_HEADER_NAME,
428: DESCRIPTION
429: ) = (select
430: B.METRIC_TPL_HEADER_NAME,

Line 432: from AMS_MET_TPL_HEADERS_TL B

428: DESCRIPTION
429: ) = (select
430: B.METRIC_TPL_HEADER_NAME,
431: B.description
432: from AMS_MET_TPL_HEADERS_TL B
433: where B.METRIC_TPL_HEADER_ID = T.METRIC_TPL_HEADER_ID
434: and B.LANGUAGE = T.SOURCE_LANG)
435: where (
436: T.METRIC_TPL_HEADER_ID,

Line 441: from AMS_MET_TPL_HEADERS_TL SUBB, AMS_MET_TPL_HEADERS_TL SUBT

437: T.LANGUAGE
438: ) in (select
439: SUBT.METRIC_TPL_HEADER_ID,
440: SUBT.LANGUAGE
441: from AMS_MET_TPL_HEADERS_TL SUBB, AMS_MET_TPL_HEADERS_TL SUBT
442: where SUBB.METRIC_TPL_HEADER_ID = SUBT.METRIC_TPL_HEADER_ID
443: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
444: and (SUBB.METRIC_TPL_HEADER_NAME <> SUBT.METRIC_TPL_HEADER_NAME
445: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 450: insert into AMS_MET_TPL_HEADERS_TL (

446: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
447: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
448: ));
449:
450: insert into AMS_MET_TPL_HEADERS_TL (
451: LAST_UPDATE_DATE,
452: CREATION_DATE,
453: LAST_UPDATED_BY,
454: CREATED_BY,

Line 472: from AMS_MET_TPL_HEADERS_TL B, FND_LANGUAGES L

468: B.DESCRIPTION,
469: B.LAST_UPDATE_LOGIN,
470: L.LANGUAGE_CODE,
471: B.SOURCE_LANG
472: from AMS_MET_TPL_HEADERS_TL B, FND_LANGUAGES L
473: where L.INSTALLED_FLAG in ('I', 'B')
474: and B.LANGUAGE = userenv('LANG')
475: and not exists
476: (select NULL

Line 477: from AMS_MET_TPL_HEADERS_TL T

473: where L.INSTALLED_FLAG in ('I', 'B')
474: and B.LANGUAGE = userenv('LANG')
475: and not exists
476: (select NULL
477: from AMS_MET_TPL_HEADERS_TL T
478: where T.METRIC_TPL_HEADER_ID = B.METRIC_TPL_HEADER_ID
479: and T.LANGUAGE = L.LANGUAGE_CODE);
480: end ADD_LANGUAGE;
481:

Line 489: update AMS_MET_TPL_HEADERS_TL set

485: , X_DESCRIPTION in VARCHAR2
486: , x_owner in VARCHAR2
487: ) is
488: begin
489: update AMS_MET_TPL_HEADERS_TL set
490: METRIC_TPL_HEADER_NAME = nvl(X_METRIC_TPL_HEADER_NAME, METRIC_TPL_HEADER_NAME),
491: description = nvl(x_description, description),
492: source_lang = userenv('LANG'),
493: last_update_date = sysdate,