APPS.AMS_DMPERFORMANCE_PVT dependencies on AMS_DM_PERFORMANCE

Line 57: SELECT AMS_DM_PERFORMANCE_s.NEXTVAL

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

Line 62: WHERE EXISTS (SELECT 1 FROM AMS_DM_PERFORMANCE

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

Line 145: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Insert_Row)

141:
142: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
143: END IF;
144:
145: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Insert_Row)
146: AMS_DM_PERFORMANCE_PKG.Insert_Row(
147: px_performance_id => l_performance_id,
148: p_last_update_date => SYSDATE,
149: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 146: AMS_DM_PERFORMANCE_PKG.Insert_Row(

142: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
143: END IF;
144:
145: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Insert_Row)
146: AMS_DM_PERFORMANCE_PKG.Insert_Row(
147: px_performance_id => l_performance_id,
148: p_last_update_date => SYSDATE,
149: p_last_updated_by => FND_GLOBAL.USER_ID,
150: p_creation_date => SYSDATE,

Line 255: FROM AMS_DM_PERFORMANCE

251: l_tar_performance_rec AMS_DMPerformance_PVT.performance_rec_type := P_performance_rec;
252:
253: CURSOR c_get_dmperformance(p_performance_id NUMBER) IS
254: SELECT *
255: FROM AMS_DM_PERFORMANCE
256: WHERE performance_id = p_performance_id;
257: l_ref_performance_rec c_get_Dmperformance%ROWTYPE ;
258: BEGIN
259: -- Standard Start of API savepoint

Line 354: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Update_Row)

350:
351: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352: END IF;
353:
354: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Update_Row)
355: AMS_DM_PERFORMANCE_PKG.Update_Row(
356: p_performance_id => p_performance_rec.performance_id,
357: p_last_update_date => SYSDATE,
358: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 355: AMS_DM_PERFORMANCE_PKG.Update_Row(

351: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352: END IF;
353:
354: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Update_Row)
355: AMS_DM_PERFORMANCE_PKG.Update_Row(
356: p_performance_id => p_performance_rec.performance_id,
357: p_last_update_date => SYSDATE,
358: p_last_updated_by => FND_GLOBAL.USER_ID,
359: p_creation_date => SYSDATE,

Line 492: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Delete_Row)

488:
489: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
490: END IF;
491:
492: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Delete_Row)
493: AMS_DM_PERFORMANCE_PKG.Delete_Row(
494: p_PERFORMANCE_ID => p_PERFORMANCE_ID);
495: --
496: -- End of API body

Line 493: AMS_DM_PERFORMANCE_PKG.Delete_Row(

489: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
490: END IF;
491:
492: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Delete_Row)
493: AMS_DM_PERFORMANCE_PKG.Delete_Row(
494: p_PERFORMANCE_ID => p_PERFORMANCE_ID);
495: --
496: -- End of API body
497: --

Line 584: FROM AMS_DM_PERFORMANCE

580: l_PERFORMANCE_ID NUMBER;
581:
582: CURSOR c_Dmperformance IS
583: SELECT PERFORMANCE_ID
584: FROM AMS_DM_PERFORMANCE
585: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID
586: AND object_version_number = p_object_version
587: FOR UPDATE NOWAIT;
588:

Line 706: 'AMS_DM_PERFORMANCE',

702: BEGIN
703: x_return_status := FND_API.g_ret_sts_success;
704: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
705: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
706: 'AMS_DM_PERFORMANCE',
707: 'PERFORMANCE_ID = ''' || p_performance_rec.PERFORMANCE_ID ||''''
708: );
709: ELSE
710: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 711: 'AMS_DM_PERFORMANCE',

707: 'PERFORMANCE_ID = ''' || p_performance_rec.PERFORMANCE_ID ||''''
708: );
709: ELSE
710: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
711: 'AMS_DM_PERFORMANCE',
712: 'PERFORMANCE_ID = ''' || p_performance_rec.PERFORMANCE_ID ||
713: ''' AND PERFORMANCE_ID <> ' || p_performance_rec.PERFORMANCE_ID
714: );
715: END IF;

Line 1082: FROM ams_dm_performance perf

1078: SELECT perf.predicted_value
1079: , perf. actual_value
1080: , perf.evaluated_records
1081: , model.target_positive_value
1082: FROM ams_dm_performance perf
1083: , ams_dm_models_all_b model
1084: WHERE model.model_id = p_model_id
1085: AND perf.model_id = p_model_id;
1086: l_predicted_value NUMBER;