APPS.AMS_METRIC_PVT dependencies on AMS_METRICS_ALL_TL

Line 516: INSERT INTO ams_metrics_all_tl (

512:
513: --
514: -- Insert into the translation table.
515: --
516: INSERT INTO ams_metrics_all_tl (
517: metric_id,
518: last_update_date,
519: last_updated_by,
520: creation_date,

Line 543: FROM ams_metrics_all_tl t

539: l.language_code
540: FROM fnd_languages l
541: WHERE l.installed_flag IN ('I', 'B')
542: AND NOT EXISTS ( SELECT NULL
543: FROM ams_metrics_all_tl t
544: WHERE t.metric_id = l_metrics_rec.metric_id
545: AND t.LANGUAGE = l.language_code);
546:
547:

Line 839: -- Update AMS_METRICS_ALL_TL

835:
836: -- Debug message.
837: Ams_Utility_Pvt.debug_message(l_full_name ||': updateMetrics TL Table');
838:
839: -- Update AMS_METRICS_ALL_TL
840: UPDATE ams_metrics_all_tl
841: SET metrics_name = l_metrics_rec.metrics_name,
842: description = l_metrics_rec.description,
843: formula_display = l_metrics_rec.formula_display,

Line 840: UPDATE ams_metrics_all_tl

836: -- Debug message.
837: Ams_Utility_Pvt.debug_message(l_full_name ||': updateMetrics TL Table');
838:
839: -- Update AMS_METRICS_ALL_TL
840: UPDATE ams_metrics_all_tl
841: SET metrics_name = l_metrics_rec.metrics_name,
842: description = l_metrics_rec.description,
843: formula_display = l_metrics_rec.formula_display,
844: last_update_date = SYSDATE,

Line 1103: DELETE FROM ams_metrics_all_tl

1099: RAISE FND_API.g_exc_error;
1100: END IF;
1101:
1102:
1103: DELETE FROM ams_metrics_all_tl
1104: WHERE metric_id = p_metric_id;
1105:
1106: IF (SQL%NOTFOUND) THEN
1107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1217: FROM ams_metrics_all_tl

1213: FOR UPDATE OF metric_id NOWAIT;
1214:
1215: CURSOR c_language IS
1216: SELECT metric_id
1217: FROM ams_metrics_all_tl
1218: WHERE metric_id = p_metric_id
1219: AND USERENV('LANG') IN (LANGUAGE, source_lang)
1220: FOR UPDATE OF metric_id NOWAIT;
1221: BEGIN