APPS.AMS_METRIC_PVT dependencies on AMS_METRICS_ALL_TL

Line 509: INSERT INTO ams_metrics_all_tl (

505:
506: --
507: -- Insert into the translation table.
508: --
509: INSERT INTO ams_metrics_all_tl (
510: metric_id,
511: last_update_date,
512: last_updated_by,
513: creation_date,

Line 536: FROM ams_metrics_all_tl t

532: l.language_code
533: FROM fnd_languages l
534: WHERE l.installed_flag IN ('I', 'B')
535: AND NOT EXISTS ( SELECT NULL
536: FROM ams_metrics_all_tl t
537: WHERE t.metric_id = l_metrics_rec.metric_id
538: AND t.LANGUAGE = l.language_code);
539:
540:

Line 832: -- Update AMS_METRICS_ALL_TL

828:
829: -- Debug message.
830: Ams_Utility_Pvt.debug_message(l_full_name ||': updateMetrics TL Table');
831:
832: -- Update AMS_METRICS_ALL_TL
833: UPDATE ams_metrics_all_tl
834: SET metrics_name = l_metrics_rec.metrics_name,
835: description = l_metrics_rec.description,
836: formula_display = l_metrics_rec.formula_display,

Line 833: UPDATE ams_metrics_all_tl

829: -- Debug message.
830: Ams_Utility_Pvt.debug_message(l_full_name ||': updateMetrics TL Table');
831:
832: -- Update AMS_METRICS_ALL_TL
833: UPDATE ams_metrics_all_tl
834: SET metrics_name = l_metrics_rec.metrics_name,
835: description = l_metrics_rec.description,
836: formula_display = l_metrics_rec.formula_display,
837: last_update_date = SYSDATE,

Line 1096: DELETE FROM ams_metrics_all_tl

1092: RAISE FND_API.g_exc_error;
1093: END IF;
1094:
1095:
1096: DELETE FROM ams_metrics_all_tl
1097: WHERE metric_id = p_metric_id;
1098:
1099: IF (SQL%NOTFOUND) THEN
1100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1210: FROM ams_metrics_all_tl

1206: FOR UPDATE OF metric_id NOWAIT;
1207:
1208: CURSOR c_language IS
1209: SELECT metric_id
1210: FROM ams_metrics_all_tl
1211: WHERE metric_id = p_metric_id
1212: AND USERENV('LANG') IN (LANGUAGE, source_lang)
1213: FOR UPDATE OF metric_id NOWAIT;
1214: BEGIN