APPS.AMS_MET_TPL_DTL_PVT dependencies on AMS_MET_TPL_DETAILS

Line 56: SELECT AMS_MET_TPL_DETAILS_s.NEXTVAL

52: l_METRIC_TEMPLATE_DETAIL_ID NUMBER;
53: l_dummy NUMBER;
54:
55: CURSOR c_id IS
56: SELECT AMS_MET_TPL_DETAILS_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_DETAILS

57: FROM dual;
58:
59: CURSOR c_id_exists (l_id IN NUMBER) IS
60: SELECT 1
61: FROM AMS_MET_TPL_DETAILS
62: WHERE METRIC_TEMPLATE_DETAIL_ID = l_id;
63:
64: l_met_tpl_dtl_rec met_tpl_dtl_rec_type := p_met_tpl_dtl_rec;
65:

Line 165: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Insert_Row)

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

Line 166: Ams_Met_Tpl_Details_Pkg.Insert_Row(

162: Ams_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
163: END IF;
164:
165: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Insert_Row)
166: Ams_Met_Tpl_Details_Pkg.Insert_Row(
167: px_metric_template_detail_id => l_metric_template_detail_id,
168: p_last_update_date => SYSDATE,
169: p_last_updated_by => FND_GLOBAL.USER_ID,
170: p_creation_date => SYSDATE,

Line 272: FROM AMS_MET_TPL_DETAILS

268: OBJECT_VERSION_NUMBER,
269: METRIC_TPL_HEADER_ID,
270: METRIC_ID,
271: ENABLED_FLAG
272: FROM AMS_MET_TPL_DETAILS
273: WHERE METRIC_TEMPLATE_DETAIL_ID = l_metric_template_detail_id;
274:
275: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Met_Tpl_Dtl';
276: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 415: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Update_Row)

411:
412: Ams_Utility_Pvt.debug_message('Private API: Calling update table handler');
413: END IF;
414:
415: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Update_Row)
416: Ams_Met_Tpl_Details_Pkg.Update_Row(
417: p_metric_template_detail_id => p_met_tpl_dtl_rec.metric_template_detail_id,
418: p_last_update_date => SYSDATE,
419: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 416: Ams_Met_Tpl_Details_Pkg.Update_Row(

412: Ams_Utility_Pvt.debug_message('Private API: Calling update table handler');
413: END IF;
414:
415: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Update_Row)
416: Ams_Met_Tpl_Details_Pkg.Update_Row(
417: p_metric_template_detail_id => p_met_tpl_dtl_rec.metric_template_detail_id,
418: p_last_update_date => SYSDATE,
419: p_last_updated_by => FND_GLOBAL.USER_ID,
420: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 555: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Delete_Row)

551:
552: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
553: END IF;
554:
555: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Delete_Row)
556: Ams_Met_Tpl_Details_Pkg.Delete_Row(
557: p_METRIC_TEMPLATE_DETAIL_ID => p_METRIC_TEMPLATE_DETAIL_ID);
558: --
559: -- End of API body

Line 556: Ams_Met_Tpl_Details_Pkg.Delete_Row(

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

Line 644: FROM AMS_MET_TPL_DETAILS

640: l_METRIC_TEMPLATE_DETAIL_ID NUMBER;
641:
642: CURSOR c_Met_Tpl_Dtl IS
643: SELECT METRIC_TEMPLATE_DETAIL_ID
644: FROM AMS_MET_TPL_DETAILS
645: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID
646: AND object_version_number = p_object_version
647: FOR UPDATE NOWAIT;
648:

Line 761: SELECT 1 FROM AMS_MET_TPL_DETAILS

757: l_valid_flag VARCHAR2(1);
758: l_dummy NUMBER;
759:
760: CURSOR c_check_duplicate(p_METRIC_ID NUMBER, p_METRIC_TPL_HEADER_ID NUMBER) IS
761: SELECT 1 FROM AMS_MET_TPL_DETAILS
762: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID
763: AND METRIC_ID = p_METRIC_ID;
764:
765: BEGIN

Line 769: 'AMS_MET_TPL_DETAILS',

765: BEGIN
766: x_return_status := FND_API.g_ret_sts_success;
767: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
768: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
769: 'AMS_MET_TPL_DETAILS',
770: 'METRIC_TEMPLATE_DETAIL_ID = ' || p_met_tpl_dtl_rec.METRIC_TEMPLATE_DETAIL_ID
771: );
772: END IF;
773:

Line 976: -- FROM ams_met_tpl_details

972: -- l_return_status VARCHAR2(1);
973:
974: -- CURSOR c_complete IS
975: -- SELECT *
976: -- FROM ams_met_tpl_details
977: -- WHERE metric_template_detail_id = p_met_tpl_dtl_rec.metric_template_detail_id;
978: -- l_met_tpl_dtl_rec c_complete%ROWTYPE;
979: BEGIN
980: -- x_complete_rec := p_met_tpl_dtl_rec;