APPS.AMS_METRIC_TEMPLATE_PVT dependencies on AMS_MET_TPL_HEADERS_VL

Line 275: FROM AMS_MET_TPL_HEADERS_VL

271: ASSOCIATION_TYPE,
272: USED_BY_ID,
273: USED_BY_CODE
274:
275: FROM AMS_MET_TPL_HEADERS_VL
276: WHERE metric_tpl_header_id = l_metric_tpl_header_id;
277:
278: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Metric_Template';
279: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 800: FROM AMS_MET_TPL_HEADERS_VL

796: /* CREATING template WITH THE WORD "AND" RATHER THAN "&" CREATES ERROR */
797:
798: CURSOR c_check_header_name(p_met_tpl_header_name VARCHAR2) IS
799: SELECT count(1)
800: FROM AMS_MET_TPL_HEADERS_VL
801: WHERE METRIC_TPL_HEADER_NAME = p_met_tpl_header_name;
802:
803: CURSOR c_check_header_detail(p_met_tpl_header_id number,
804: p_met_tpl_header_name VARCHAR2) IS

Line 806: FROM AMS_MET_TPL_HEADERS_VL

802:
803: CURSOR c_check_header_detail(p_met_tpl_header_id number,
804: p_met_tpl_header_name VARCHAR2) IS
805: SELECT 1
806: FROM AMS_MET_TPL_HEADERS_VL
807: WHERE METRIC_TPL_HEADER_ID <> p_met_tpl_header_id
808: AND METRIC_TPL_HEADER_NAME = p_met_tpl_header_name;
809:
810: /*ENd Changes sunkumar */

Line 833: 'AMS_MET_TPL_HEADERS_VL',

829:
830: -- Validate the PK ID is unique.
831: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
832: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
833: 'AMS_MET_TPL_HEADERS_VL',
834: 'METRIC_TPL_HEADER_ID = ' || p_metric_tpl_header_rec.METRIC_TPL_HEADER_ID
835: );
836: IF l_valid_flag = FND_API.g_false THEN
837: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_ID_DUPLICATE');

Line 843: -- 'AMS_MET_TPL_HEADERS_VL',

839: RETURN;
840: END IF;
841: -- ELSE
842: -- l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
843: -- 'AMS_MET_TPL_HEADERS_VL',
844: -- 'METRIC_TPL_HEADER_ID = ' || p_metric_tpl_header_rec.METRIC_TPL_HEADER_ID ||
845: -- ' AND METRIC_TPL_HEADER_ID <> ' || p_metric_tpl_header_rec.METRIC_TPL_HEADER_ID
846: -- );
847: END IF;

Line 1192: -- FROM ams_met_tpl_headers_vl

1188: -- l_return_status VARCHAR2(1);
1189:
1190: -- CURSOR c_complete IS
1191: -- SELECT *
1192: -- FROM ams_met_tpl_headers_vl
1193: -- WHERE metric_tpl_header_id = p_metric_tpl_header_rec.metric_tpl_header_id;
1194: -- l_metric_tpl_header_rec c_complete%ROWTYPE;
1195: BEGIN
1196: -- x_complete_rec := p_metric_tpl_header_rec;