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_DMSOURCE_PVT dependencies on AMS_DM_SOURCE

Line 172: FROM ams_dm_source

168: l_SOURCE_ID NUMBER;
169:
170: CURSOR c_Source IS
171: SELECT SOURCE_ID
172: FROM ams_dm_source
173: WHERE SOURCE_ID = p_SOURCE_ID
174: AND object_version_number = p_object_version
175: FOR UPDATE NOWAIT;
176:

Line 309: SELECT AMS_dm_source_s.NEXTVAL

305: l_SOURCE_ID NUMBER;
306: l_dummy NUMBER;
307:
308: CURSOR c_id IS
309: SELECT AMS_dm_source_s.NEXTVAL
310: FROM dual;
311:
312: CURSOR c_id_exists (l_id IN NUMBER) IS
313: SELECT 1 FROM dual

Line 314: WHERE EXISTS (SELECT 1 FROM ams_dm_source

310: FROM dual;
311:
312: CURSOR c_id_exists (l_id IN NUMBER) IS
313: SELECT 1 FROM dual
314: WHERE EXISTS (SELECT 1 FROM ams_dm_source
315: WHERE SOURCE_ID = l_id);
316:
317: BEGIN
318: -- Standard Start of API savepoint

Line 395: -- Invoke table handler(ams_dm_source_PKG.Insert_Row)

391:
392: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
393: END IF;
394:
395: -- Invoke table handler(ams_dm_source_PKG.Insert_Row)
396: BEGIN
397: ams_dm_source_PKG.Insert_Row(
398: px_SOURCE_ID => l_SOURCE_ID,
399: p_LAST_UPDATE_DATE => SYSDATE,

Line 397: ams_dm_source_PKG.Insert_Row(

393: END IF;
394:
395: -- Invoke table handler(ams_dm_source_PKG.Insert_Row)
396: BEGIN
397: ams_dm_source_PKG.Insert_Row(
398: px_SOURCE_ID => l_SOURCE_ID,
399: p_LAST_UPDATE_DATE => SYSDATE,
400: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
401: p_CREATION_DATE => SYSDATE,

Line 506: FROM ams_dm_source

502: l_api_version_number CONSTANT NUMBER := 1.0;
503:
504: CURSOR c_reference (p_source_id IN NUMBER) IS
505: SELECT *
506: FROM ams_dm_source
507: WHERE source_id = p_source_id;
508:
509: -- Local Variables
510: l_object_version_number NUMBER;

Line 608: -- Invoke table handler(ams_dm_source_PKG.Update_Row)

604:
605: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler', FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
606: END IF;
607:
608: -- Invoke table handler(ams_dm_source_PKG.Update_Row)
609: ams_dm_source_PKG.Update_Row(
610: p_source_id => p_source_rec.source_id,
611: p_last_update_date => SYSDATE,
612: p_last_updated_by => FND_GLOBAL.user_id,

Line 609: ams_dm_source_PKG.Update_Row(

605: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler', FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
606: END IF;
607:
608: -- Invoke table handler(ams_dm_source_PKG.Update_Row)
609: ams_dm_source_PKG.Update_Row(
610: p_source_id => p_source_rec.source_id,
611: p_last_update_date => SYSDATE,
612: p_last_updated_by => FND_GLOBAL.user_id,
613: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 706: FROM ams_dm_source

702: )
703: IS
704: CURSOR c_obj_version(c_id NUMBER) IS
705: SELECT object_version_number
706: FROM ams_dm_source
707: WHERE source_id = c_id;
708:
709: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Source';
710: l_api_version_number CONSTANT NUMBER := 1.0;

Line 774: ams_dm_source_pkg.Delete_Row(

770: END IF;
771:
772: -- Invoke table handler(AMS_DM_MODEL_SCORES_B_PKG.Delete_Row)
773: BEGIN
774: ams_dm_source_pkg.Delete_Row(
775: p_source_id => p_source_id);
776: EXCEPTION
777: WHEN NO_DATA_FOUND THEN
778: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');

Line 872: 'ams_dm_source',

868: END IF;
869: x_return_status := FND_API.g_ret_sts_success;
870: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
871: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
872: 'ams_dm_source',
873: 'SOURCE_ID = ''' || p_source_rec.SOURCE_ID ||''''
874: );
875: ELSE
876: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 877: 'ams_dm_source',

873: 'SOURCE_ID = ''' || p_source_rec.SOURCE_ID ||''''
874: );
875: ELSE
876: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
877: 'ams_dm_source',
878: 'SOURCE_ID = ''' || p_source_rec.SOURCE_ID ||
879: ''' AND SOURCE_ID <> ' || p_source_rec.SOURCE_ID
880: );
881: END IF;

Line 885: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_ID_DUPLICATE');

881: END IF;
882:
883: IF l_valid_flag = FND_API.g_false THEN
884: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
885: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_ID_DUPLICATE');
886: FND_MSG_PUB.add;
887: END IF;
888: x_return_status := FND_API.g_ret_sts_error;
889: END IF;

Line 927: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');

923:
924:
925: IF p_source_rec.PARTY_ID = FND_API.g_miss_num OR p_source_rec.PARTY_ID IS NULL THEN
926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
928: FND_MSG_PUB.add;
929: END IF;
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;

Line 935: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_SOURCE_ID');

931: END IF;
932: ELSE -- update mode
933: IF p_source_rec.SOURCE_ID IS NULL THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
935: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_SOURCE_ID');
936: FND_MSG_PUB.add;
937: END IF;
938: x_return_status := FND_API.g_ret_sts_error;
939: END IF;

Line 961: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');

957:
958:
959: IF p_source_rec.PARTY_ID IS NULL THEN
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
961: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
962: FND_MSG_PUB.add;
963: END IF;
964: x_return_status := FND_API.g_ret_sts_error;
965: END IF;

Line 992: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_MODEL_ID');

988: p_source_rec.used_for_object_id
989: ) = FND_API.g_false
990: THEN
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_MODEL_ID');
993: FND_MSG_PUB.add;
994: END IF;
995: x_return_status := FND_API.g_ret_sts_error;
996: END IF;

Line 1007: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_SCORE_ID');

1003: p_source_rec.used_for_object_id
1004: ) = FND_API.g_false
1005: THEN
1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1007: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_SCORE_ID');
1008: FND_MSG_PUB.add;
1009: END IF;
1010: x_return_status := FND_API.g_ret_sts_error;
1011: END IF;

Line 1275: UPDATE ams_dm_source

1271: IF FND_API.to_Boolean (p_init_msg_list) THEN
1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:
1275: UPDATE ams_dm_source
1276: SET decile = (10 - FLOOR (LEAST (99, continuous_score)/10))
1277: WHERE arc_used_for_object = 'SCOR'
1278: AND used_for_object_id = p_score_id
1279: AND continuous_score IS NOT NULL;

Line 1281: UPDATE ams_dm_source

1277: WHERE arc_used_for_object = 'SCOR'
1278: AND used_for_object_id = p_score_id
1279: AND continuous_score IS NOT NULL;
1280:
1281: UPDATE ams_dm_source
1282: SET percentile = (100 - FLOOR (LEAST (99, continuous_score)))
1283: WHERE arc_used_for_object = 'SCOR'
1284: AND used_for_object_id = p_score_id
1285: AND continuous_score IS NOT NULL;

Line 1432: UPDATE ams_dm_source s

1428: OPEN c_target_positive_value (p_score_id);
1429: FETCH c_target_positive_value INTO l_target_positive_value;
1430: CLOSE c_target_positive_value;
1431:
1432: UPDATE ams_dm_source s
1433: SET (score_result, confidence, continuous_score) = (SELECT score, probability * 100, DECODE (score, l_target_positive_value, probability, 1 - probability) * 100
1434: -- FROM ams_dm_apply_stg stg
1435: FROM ams_dm_apply_stg_gt stg
1436: WHERE stg.source_id = s.source_id)

Line 1784: SELECT COUNT(*) FROM ams_dm_source

1780:
1781: )
1782: IS
1783: CURSOR c_check_targets(data_flag VARCHAR2) IS
1784: SELECT COUNT(*) FROM ams_dm_source
1785: WHERE training_data_flag = data_flag
1786: AND arc_used_for_object = p_object_type
1787: AND used_for_object_id = p_object_id
1788: AND TARGET_VALUE = '1';

Line 1797: -- UPDATE ams_dm_source

1793:
1794: -- choang - 09-may-2002
1795: -- per ODM development, changed build data split as:
1796: -- 70% training data, 30% test data.
1797: -- UPDATE ams_dm_source
1798: -- SET training_data_flag = DECODE (MOD (DBMS_RANDOM.random, 2), 0, 'N', 'Y')
1799: -- SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')
1800: -- WHERE arc_used_for_object = p_object_type
1801: -- AND used_for_object_id = p_object_id;

Line 1805: UPDATE ams_dm_source

1801: -- AND used_for_object_id = p_object_id;
1802:
1803: -- kbasavar - 24-June-2003
1804: -- per 11.5.10 enhancements changed to split the positive and negative targets by 70-30
1805: UPDATE ams_dm_source
1806: SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')
1807: WHERE arc_used_for_object = p_object_type
1808: AND used_for_object_id = p_object_id
1809: AND TARGET_VALUE = '0';

Line 1811: UPDATE ams_dm_source

1807: WHERE arc_used_for_object = p_object_type
1808: AND used_for_object_id = p_object_id
1809: AND TARGET_VALUE = '0';
1810:
1811: UPDATE ams_dm_source
1812: SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')
1813: WHERE arc_used_for_object = p_object_type
1814: AND used_for_object_id = p_object_id
1815: AND TARGET_VALUE = '1';

Line 2364: x_from_clause := ' FROM ' || l_ams_schema || '.ams_dm_source s, ';

2360: l_industry,
2361: l_ams_schema
2362: );
2363:
2364: x_from_clause := ' FROM ' || l_ams_schema || '.ams_dm_source s, ';
2365: x_from_clause := x_from_clause || l_object_name_full;
2366: IF l_model_type = 'CUSTOMER_PROFITABILITY' AND l_is_b2b AND l_is_seeded THEN
2367: x_where_clause := ' WHERE s.party_id = ' || l_object_name || '.ORGANIZATION_ID';
2368: ELSE