APPS.AMS_METRICS_ALL_PKG dependencies on AMS_METRICS_ALL_TL

Line 117: insert into AMS_METRICS_ALL_TL (

113: X_LAST_UPDATED_BY,
114: X_LAST_UPDATE_LOGIN
115: );
116:
117: insert into AMS_METRICS_ALL_TL (
118: METRICS_NAME,
119: DESCRIPTION,
120: FORMULA_DISPLAY,
121: METRIC_ID,

Line 145: from AMS_METRICS_ALL_TL T

141: from FND_LANGUAGES L
142: where L.INSTALLED_FLAG in ('I', 'B')
143: and not exists
144: (select NULL
145: from AMS_METRICS_ALL_TL T
146: where T.METRIC_ID = X_METRIC_ID
147: and T.LANGUAGE = L.LANGUAGE_CODE);
148:
149: open c;

Line 218: from AMS_METRICS_ALL_TL

214: METRICS_NAME,
215: DESCRIPTION,
216: FORMULA_DISPLAY,
217: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
218: from AMS_METRICS_ALL_TL
219: where METRIC_ID = X_METRIC_ID
220: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
221: for update of METRIC_ID nowait;
222: begin

Line 361: update AMS_METRICS_ALL_TL set

357: if (sql%notfound) then
358: raise no_data_found;
359: end if;
360:
361: update AMS_METRICS_ALL_TL set
362: METRICS_NAME = X_METRICS_NAME,
363: DESCRIPTION = X_DESCRIPTION,
364: FORMULA_DISPLAY = X_FORMULA_DISPLAY,
365: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 381: delete from AMS_METRICS_ALL_TL

377: procedure DELETE_ROW (
378: X_METRIC_ID in NUMBER
379: ) is
380: begin
381: delete from AMS_METRICS_ALL_TL
382: where METRIC_ID = X_METRIC_ID;
383:
384: if (sql%notfound) then
385: raise no_data_found;

Line 399: delete from AMS_METRICS_ALL_TL T

395:
396: procedure ADD_LANGUAGE
397: is
398: begin
399: delete from AMS_METRICS_ALL_TL T
400: where not exists
401: (select NULL
402: from AMS_METRICS_ALL_B B
403: where B.METRIC_ID = T.METRIC_ID

Line 406: update AMS_METRICS_ALL_TL T set (

402: from AMS_METRICS_ALL_B B
403: where B.METRIC_ID = T.METRIC_ID
404: );
405:
406: update AMS_METRICS_ALL_TL T set (
407: METRICS_NAME,
408: DESCRIPTION,
409: FORMULA_DISPLAY
410: ) = (select

Line 414: from AMS_METRICS_ALL_TL B

410: ) = (select
411: B.METRICS_NAME,
412: B.DESCRIPTION,
413: B.FORMULA_DISPLAY
414: from AMS_METRICS_ALL_TL B
415: where B.METRIC_ID = T.METRIC_ID
416: and B.LANGUAGE = T.SOURCE_LANG)
417: where (
418: T.METRIC_ID,

Line 423: from AMS_METRICS_ALL_TL SUBB, AMS_METRICS_ALL_TL SUBT

419: T.LANGUAGE
420: ) in (select
421: SUBT.METRIC_ID,
422: SUBT.LANGUAGE
423: from AMS_METRICS_ALL_TL SUBB, AMS_METRICS_ALL_TL SUBT
424: where SUBB.METRIC_ID = SUBT.METRIC_ID
425: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
426: and (SUBB.METRICS_NAME <> SUBT.METRICS_NAME
427: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 435: insert into AMS_METRICS_ALL_TL (

431: or (SUBB.FORMULA_DISPLAY is null and SUBT.FORMULA_DISPLAY is not null)
432: or (SUBB.FORMULA_DISPLAY is not null and SUBT.FORMULA_DISPLAY is null)
433: ));
434:
435: insert into AMS_METRICS_ALL_TL (
436: METRICS_NAME,
437: DESCRIPTION,
438: FORMULA_DISPLAY,
439: METRIC_ID,

Line 459: from AMS_METRICS_ALL_TL B, FND_LANGUAGES L

455: B.CREATED_BY,
456: B.LAST_UPDATE_LOGIN,
457: L.LANGUAGE_CODE,
458: B.SOURCE_LANG
459: from AMS_METRICS_ALL_TL B, FND_LANGUAGES L
460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL

Line 464: from AMS_METRICS_ALL_TL T

460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL
464: from AMS_METRICS_ALL_TL T
465: where T.METRIC_ID = B.METRIC_ID
466: and T.LANGUAGE = L.LANGUAGE_CODE);
467: end ADD_LANGUAGE;
468:

Line 477: update AMS_METRICS_ALL_TL set

473: , x_formula_display in VARCHAR2
474: , x_owner in VARCHAR2
475: ) is
476: begin
477: update AMS_METRICS_ALL_TL set
478: metrics_name = nvl(x_metrics_name, metrics_name),
479: description = nvl(x_description, description),
480: formula_display = nvl(x_formula_display, formula_display),
481: source_lang = userenv('LANG'),