eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_MET_TPL_ASSOC_PVT dependencies on AMS_MET_TPL_ASSOCS

Line 56: SELECT AMS_MET_TPL_ASSOCS_s.NEXTVAL

52: l_METRIC_TPL_ASSOC_ID NUMBER;
53: l_dummy NUMBER;
54:
55: CURSOR c_id IS
56: SELECT AMS_MET_TPL_ASSOCS_s.NEXTVAL
57: FROM dual;
58:
59: CURSOR c_id_exists (l_id IN NUMBER) IS
60: SELECT 1

Line 61: FROM AMS_MET_TPL_ASSOCS

57: FROM dual;
58:
59: CURSOR c_id_exists (l_id IN NUMBER) IS
60: SELECT 1
61: FROM AMS_MET_TPL_ASSOCS
62: WHERE METRIC_TPL_ASSOC_ID = l_id;
63:
64: BEGIN
65: -- Standard Start of API savepoint

Line 164: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Insert_Row)

160:
161: Ams_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
162: END IF;
163:
164: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Insert_Row)
165: Ams_Met_Tpl_Assocs_Pkg.Insert_Row(
166: p_metric_tpl_assoc_id => l_METRIC_TPL_ASSOC_ID,
167: p_last_update_date => SYSDATE,
168: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 165: Ams_Met_Tpl_Assocs_Pkg.Insert_Row(

161: Ams_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
162: END IF;
163:
164: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Insert_Row)
165: Ams_Met_Tpl_Assocs_Pkg.Insert_Row(
166: p_metric_tpl_assoc_id => l_METRIC_TPL_ASSOC_ID,
167: p_last_update_date => SYSDATE,
168: p_last_updated_by => FND_GLOBAL.USER_ID,
169: p_creation_date => SYSDATE,

Line 277: FROM AMS_MET_TPL_ASSOCS

273: ASSOCIATION_TYPE,
274: USED_BY_ID,
275: USED_BY_CODE,
276: ENABLED_FLAG
277: FROM AMS_MET_TPL_ASSOCS
278: WHERE metric_tpl_assoc_id = l_metric_tpl_assoc_id;
279: -- Hint: Developer need to provide Where clause
280:
281: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Met_Tpl_Assoc';

Line 414: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Update_Row)

410:
411: Ams_Utility_Pvt.debug_message('Private API: Calling update table handler');
412: END IF;
413:
414: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Update_Row)
415: Ams_Met_Tpl_Assocs_Pkg.Update_Row(
416: p_metric_tpl_assoc_id => p_met_tpl_assoc_rec.metric_tpl_assoc_id,
417: p_last_update_date => SYSDATE,
418: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 415: Ams_Met_Tpl_Assocs_Pkg.Update_Row(

411: Ams_Utility_Pvt.debug_message('Private API: Calling update table handler');
412: END IF;
413:
414: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Update_Row)
415: Ams_Met_Tpl_Assocs_Pkg.Update_Row(
416: p_metric_tpl_assoc_id => p_met_tpl_assoc_rec.metric_tpl_assoc_id,
417: p_last_update_date => SYSDATE,
418: p_last_updated_by => FND_GLOBAL.USER_ID,
419: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 557: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Delete_Row)

553:
554: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
555: END IF;
556:
557: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Delete_Row)
558: Ams_Met_Tpl_Assocs_Pkg.Delete_Row(
559: p_METRIC_TPL_ASSOC_ID => p_METRIC_TPL_ASSOC_ID);
560: --
561: -- End of API body

Line 558: Ams_Met_Tpl_Assocs_Pkg.Delete_Row(

554: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
555: END IF;
556:
557: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Delete_Row)
558: Ams_Met_Tpl_Assocs_Pkg.Delete_Row(
559: p_METRIC_TPL_ASSOC_ID => p_METRIC_TPL_ASSOC_ID);
560: --
561: -- End of API body
562: --

Line 645: FROM AMS_MET_TPL_ASSOCS

641: l_METRIC_TPL_ASSOC_ID NUMBER;
642:
643: CURSOR c_Met_Tpl_Assoc IS
644: SELECT METRIC_TPL_ASSOC_ID
645: FROM AMS_MET_TPL_ASSOCS
646: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID
647: AND object_version_number = p_object_version
648: FOR UPDATE NOWAIT;
649:

Line 762: FROM AMS_MET_TPL_ASSOCS

758: l_valid_flag VARCHAR2(1);
759: CURSOR c_dup_assoc (p_met_tpl_hdr_id NUMBER, p_assoc_type VARCHAR2,
760: p_used_by_id NUMBER, p_used_by_code VARCHAR2) IS
761: SELECT FND_API.G_FALSE
762: FROM AMS_MET_TPL_ASSOCS
763: WHERE METRIC_TPL_HEADER_ID = p_met_tpl_hdr_id
764: AND ASSOCIATION_TYPE = p_assoc_type
765: AND NVL(p_used_by_id,-1) = NVL(used_by_id,-1)
766: AND NVL(p_used_by_code, '0') = NVL(used_by_code, '0');

Line 772: 'AMS_MET_TPL_ASSOCS',

768: BEGIN
769: x_return_status := FND_API.g_ret_sts_success;
770: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
771: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
772: 'AMS_MET_TPL_ASSOCS',
773: 'METRIC_TPL_ASSOC_ID = ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID
774: );
775: -- ELSE
776: -- l_valid_flag := Ams_Utility_Pvt.check_uniqueness(

Line 777: -- 'AMS_MET_TPL_ASSOCS',

773: 'METRIC_TPL_ASSOC_ID = ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID
774: );
775: -- ELSE
776: -- l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
777: -- 'AMS_MET_TPL_ASSOCS',
778: -- 'METRIC_TPL_ASSOC_ID = ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID ||
779: -- ' AND METRIC_TPL_ASSOC_ID <> ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID
780: -- );
781: END IF;

Line 1067: FROM ams_met_tpl_assocs

1063: l_return_status VARCHAR2(1);
1064: /*
1065: CURSOR c_complete IS
1066: SELECT *
1067: FROM ams_met_tpl_assocs
1068: WHERE METRIC_TPL_ASSOC_ID = p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID;
1069: l_met_tpl_assoc_rec c_complete%ROWTYPE;
1070: */
1071: BEGIN