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_SCORERESULT_PVT dependencies on AMS_DM_SCORE_RESULTS

Line 123: SELECT AMS_DM_SCORE_RESULTS_s.NEXTVAL

119: l_SCORE_RESULT_ID NUMBER;
120: l_dummy NUMBER;
121:
122: CURSOR c_id IS
123: SELECT AMS_DM_SCORE_RESULTS_s.NEXTVAL
124: FROM dual;
125:
126: CURSOR c_id_exists (l_id IN NUMBER) IS
127: SELECT 1 FROM dual

Line 128: WHERE EXISTS (SELECT 1 FROM AMS_DM_SCORE_RESULTS

124: FROM dual;
125:
126: CURSOR c_id_exists (l_id IN NUMBER) IS
127: SELECT 1 FROM dual
128: WHERE EXISTS (SELECT 1 FROM AMS_DM_SCORE_RESULTS
129: WHERE SCORE_RESULT_ID = l_id);
130:
131: BEGIN
132: -- Standard Start of API savepoint

Line 208: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Insert_Row)

204:
205: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
206: END IF;
207:
208: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Insert_Row)
209: AMS_DM_SCORE_RESULTS_PKG.Insert_Row(
210: px_score_result_id => l_score_result_id,
211: p_last_update_date => SYSDATE,
212: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 209: AMS_DM_SCORE_RESULTS_PKG.Insert_Row(

205: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
206: END IF;
207:
208: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Insert_Row)
209: AMS_DM_SCORE_RESULTS_PKG.Insert_Row(
210: px_score_result_id => l_score_result_id,
211: p_last_update_date => SYSDATE,
212: p_last_updated_by => FND_GLOBAL.USER_ID,
213: p_creation_date => SYSDATE,

Line 316: FROM AMS_DM_SCORE_RESULTS

312: l_tar_scoreresult_rec AMS_Scoreresult_PVT.scoreresult_rec_type := P_scoreresult_rec;
313:
314: CURSOR c_get_scoreresult(p_score_result_id NUMBER) IS
315: SELECT *
316: FROM AMS_DM_SCORE_RESULTS
317: WHERE score_result_id = p_score_result_id;
318: l_ref_scoreresult_rec c_get_Scoreresult%ROWTYPE ;
319: BEGIN
320: -- Standard Start of API savepoint

Line 406: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Update_Row)

402:
403: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
404: END IF;
405:
406: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Update_Row)
407: AMS_DM_SCORE_RESULTS_PKG.Update_Row(
408: p_score_result_id => p_scoreresult_rec.score_result_id,
409: p_last_update_date => SYSDATE,
410: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 407: AMS_DM_SCORE_RESULTS_PKG.Update_Row(

403: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
404: END IF;
405:
406: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Update_Row)
407: AMS_DM_SCORE_RESULTS_PKG.Update_Row(
408: p_score_result_id => p_scoreresult_rec.score_result_id,
409: p_last_update_date => SYSDATE,
410: p_last_updated_by => FND_GLOBAL.USER_ID,
411: p_creation_date => SYSDATE,

Line 537: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Delete_Row)

533:
534: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
535: END IF;
536:
537: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Delete_Row)
538: AMS_DM_SCORE_RESULTS_PKG.Delete_Row(
539: p_SCORE_RESULT_ID => p_SCORE_RESULT_ID);
540: --
541: -- End of API body

Line 538: AMS_DM_SCORE_RESULTS_PKG.Delete_Row(

534: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
535: END IF;
536:
537: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Delete_Row)
538: AMS_DM_SCORE_RESULTS_PKG.Delete_Row(
539: p_SCORE_RESULT_ID => p_SCORE_RESULT_ID);
540: --
541: -- End of API body
542: --

Line 625: FROM AMS_DM_SCORE_RESULTS

621: l_SCORE_RESULT_ID NUMBER;
622:
623: CURSOR c_Scoreresult IS
624: SELECT SCORE_RESULT_ID
625: FROM AMS_DM_SCORE_RESULTS
626: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID
627: AND object_version_number = p_object_version
628: FOR UPDATE NOWAIT;
629:

Line 744: 'AMS_DM_SCORE_RESULTS',

740: BEGIN
741: x_return_status := FND_API.g_ret_sts_success;
742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
744: 'AMS_DM_SCORE_RESULTS',
745: 'SCORE_RESULT_ID = ''' || p_scoreresult_rec.SCORE_RESULT_ID ||''''
746: );
747: ELSE
748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 749: 'AMS_DM_SCORE_RESULTS',

745: 'SCORE_RESULT_ID = ''' || p_scoreresult_rec.SCORE_RESULT_ID ||''''
746: );
747: ELSE
748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
749: 'AMS_DM_SCORE_RESULTS',
750: 'SCORE_RESULT_ID = ''' || p_scoreresult_rec.SCORE_RESULT_ID ||
751: ''' AND SCORE_RESULT_ID <> ' || p_scoreresult_rec.SCORE_RESULT_ID
752: );
753: END IF;

Line 1493: DELETE FROM ams_dm_score_results

1489: -- Initialize API return status to SUCCESS
1490: x_return_status := FND_API.G_RET_STS_SUCCESS;
1491:
1492: -- clear results from any previous execution
1493: DELETE FROM ams_dm_score_results
1494: WHERE score_id = p_score_id;
1495:
1496: FOR l_result_rec IN c_results (p_score_id) LOOP
1497: -- can't batch insert because of group by

Line 1499: INSERT INTO ams_dm_score_results (

1495:
1496: FOR l_result_rec IN c_results (p_score_id) LOOP
1497: -- can't batch insert because of group by
1498: -- constraints on the sequence.
1499: INSERT INTO ams_dm_score_results (
1500: score_result_id,
1501: last_update_date,
1502: last_updated_by,
1503: creation_date,

Line 1513: ams_dm_score_results_s.NEXTVAL,

1509: num_records,
1510: score,
1511: confidence
1512: ) VALUES (
1513: ams_dm_score_results_s.NEXTVAL,
1514: SYSDATE,
1515: FND_GLOBAL.user_id,
1516: SYSDATE,
1517: FND_GLOBAL.user_id,