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_SOURCE

Line 43: -- 17-Dec-2003 rosharma Fixed to update ams_dm_source when inserting percentiles in AMS_DM_SCORE_PCT_RESULTS

39: -- 10-Sep-2003 kbasavar Changes made to check for seeded targets for Customer profitability
40: -- 15-Sep-2003 nyostos Changes related to parallel mining processes using Global Temp Tables.
41: -- 20-Oct-2003 nyostos Added check if no records found in insert_percentile_results.
42: -- 06-Nov-2003 rosharma Renamed ams_dm_org_contacts_stg to ams_dm_org_contacts
43: -- 17-Dec-2003 rosharma Fixed to update ams_dm_source when inserting percentiles in AMS_DM_SCORE_PCT_RESULTS
44: -- 30-Dec-2003 kbasavar Call insert_percentile_results only for models enabled for Optimal Targeting
45: -- 20-Jan-2004 rosharma bug # 3380057
46: -- 22-Jan-2004 kbasavar If List Generation is successful then insert into AMS_DM_SCORE_LISTS.
47: -- 23-Jan-2004 kbasavar Org Product Affinity Changes.

Line 65: G_LIST_SOURCE_NAME VARCHAR2(30) := 'AMS_DM_SOURCE';

61: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
62: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
63: ***/
64:
65: G_LIST_SOURCE_NAME VARCHAR2(30) := 'AMS_DM_SOURCE';
66:
67: -- package global types
68: TYPE tree_node_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
69:

Line 1109: FROM ams_dm_source s

1105: L_API_NAME VARCHAR2(30) := 'insert_percentile_results';
1106:
1107: CURSOR c_total_records (p_score_id IN NUMBER) IS
1108: SELECT count(*)
1109: FROM ams_dm_source s
1110: WHERE s.arc_used_for_object = 'SCOR'
1111: AND s.used_for_object_id = p_score_id
1112: AND s.continuous_score IS NOT NULL;
1113:

Line 1116: FROM ams_dm_source s

1112: AND s.continuous_score IS NOT NULL;
1113:
1114: CURSOR c_results (p_score_id IN NUMBER) IS
1115: SELECT (s.continuous_score/100) confidence , party_id
1116: FROM ams_dm_source s
1117: WHERE s.arc_used_for_object = 'SCOR'
1118: AND s.used_for_object_id = p_score_id
1119: AND s.continuous_score IS NOT NULL
1120: ORDER BY s.continuous_score desc;

Line 1170: AMS_UTILITY_PVT.debug_message('No score results found in AMS_DM_SOURCE. Exiting.' );

1166:
1167: -- If there are no records return
1168: IF l_total_records <= 0 THEN
1169: IF (AMS_DEBUG_HIGH_ON) THEN
1170: AMS_UTILITY_PVT.debug_message('No score results found in AMS_DM_SOURCE. Exiting.' );
1171: END IF;
1172: RETURN;
1173: END IF;
1174:

Line 1273: --update ams_dm_source set percentile = l_percentile

1269: l_avg_confidence_cum,
1270: 0
1271: ); */
1272:
1273: --update ams_dm_source set percentile = l_percentile
1274: --WHERE arc_used_for_object = 'SCOR'
1275: --AND used_for_object_id = p_score_id
1276: --AND to_char(party_id) IN (l_party_ids);
1277: /*** reverting to old code until batch solution can be implemented

Line 1279: l_sql_str := 'update ams_dm_source set percentile = :1' ;

1275: --AND used_for_object_id = p_score_id
1276: --AND to_char(party_id) IN (l_party_ids);
1277: /*** reverting to old code until batch solution can be implemented
1278: target build 38
1279: l_sql_str := 'update ams_dm_source set percentile = :1' ;
1280: l_sql_str := l_sql_str || ' WHERE arc_used_for_object = ''SCOR''';
1281: l_sql_str := l_sql_str || ' AND used_for_object_id = :2';
1282: l_sql_str := l_sql_str || ' AND party_id IN (:3)' ;
1283: ***/

Line 1284: /* l_sql_str := 'update ams_dm_source set percentile = :1' ;

1280: l_sql_str := l_sql_str || ' WHERE arc_used_for_object = ''SCOR''';
1281: l_sql_str := l_sql_str || ' AND used_for_object_id = :2';
1282: l_sql_str := l_sql_str || ' AND party_id IN (:3)' ;
1283: ***/
1284: /* l_sql_str := 'update ams_dm_source set percentile = :1' ;
1285: l_sql_str := l_sql_str || ' WHERE arc_used_for_object = ''SCOR''';
1286: l_sql_str := l_sql_str || ' AND used_for_object_id = :2';
1287: l_sql_str := l_sql_str || ' AND party_id IN (' || l_party_ids || ')' ; */
1288:

Line 1296: update ams_dm_source set percentile = l_percentile

1292: -- EXECUTE IMMEDIATE l_sql_str using l_percentile, p_score_id, l_party_ids;
1293: -- EXECUTE IMMEDIATE l_sql_str using l_percentile, p_score_id;
1294:
1295: FORALL k in 1..l_temp_party_id_list.COUNT
1296: update ams_dm_source set percentile = l_percentile
1297: WHERE arc_used_for_object = 'SCOR' AND used_for_object_id = l_score_id AND party_id = l_temp_party_id_list(k) ;
1298:
1299: -- reset record counter and confidence
1300: l_record_count := 0;

Line 1449: FROM ams_dm_source s

1445: SELECT s.decile,
1446: s.score_result,
1447: AVG (s.continuous_score) confidence,
1448: COUNT(*) row_count
1449: FROM ams_dm_source s
1450: WHERE s.arc_used_for_object = 'SCOR'
1451: AND s.used_for_object_id = p_score_id
1452: AND s.decile IS NOT NULL
1453: AND s.continuous_score IS NOT NULL

Line 1719: -- l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts_stg, ams_dm_source';

1715: IF l_is_b2b AND l_seeded_target AND l_model_type = 'CUSTOMER_PROFITABILITY' THEN
1716: -- end change rosharma 20-jan-2004 bug # 3380057
1717: -- nyostos Sep 15, 2003 - Use Global Temporary Table
1718: -- l_sql_str := 'SELECT ams_dm_org_contacts_stg.party_id, '''|| l_master_type || '''';
1719: -- l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts_stg, ams_dm_source';
1720: -- l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts_stg.arc_object_used_by= ''SCOR''';
1721: -- l_sql_str := l_sql_str || ' AND ams_dm_org_contacts_stg.object_used_by_id = '|| p_score_id;
1722: -- l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1723: -- l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;

Line 1722: -- l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';

1718: -- l_sql_str := 'SELECT ams_dm_org_contacts_stg.party_id, '''|| l_master_type || '''';
1719: -- l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts_stg, ams_dm_source';
1720: -- l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts_stg.arc_object_used_by= ''SCOR''';
1721: -- l_sql_str := l_sql_str || ' AND ams_dm_org_contacts_stg.object_used_by_id = '|| p_score_id;
1722: -- l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1723: -- l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1724: -- l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts_stg.org_party_id';
1725: -- l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1726: l_sql_str := 'SELECT ams_dm_org_contacts.party_id, '''|| l_master_type || '''';

Line 1723: -- l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;

1719: -- l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts_stg, ams_dm_source';
1720: -- l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts_stg.arc_object_used_by= ''SCOR''';
1721: -- l_sql_str := l_sql_str || ' AND ams_dm_org_contacts_stg.object_used_by_id = '|| p_score_id;
1722: -- l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1723: -- l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1724: -- l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts_stg.org_party_id';
1725: -- l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1726: l_sql_str := 'SELECT ams_dm_org_contacts.party_id, '''|| l_master_type || '''';
1727: l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts, ams_dm_source';

Line 1724: -- l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts_stg.org_party_id';

1720: -- l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts_stg.arc_object_used_by= ''SCOR''';
1721: -- l_sql_str := l_sql_str || ' AND ams_dm_org_contacts_stg.object_used_by_id = '|| p_score_id;
1722: -- l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1723: -- l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1724: -- l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts_stg.org_party_id';
1725: -- l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1726: l_sql_str := 'SELECT ams_dm_org_contacts.party_id, '''|| l_master_type || '''';
1727: l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts, ams_dm_source';
1728: l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts.arc_object_used_by= ''SCOR''';

Line 1725: -- l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';

1721: -- l_sql_str := l_sql_str || ' AND ams_dm_org_contacts_stg.object_used_by_id = '|| p_score_id;
1722: -- l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1723: -- l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1724: -- l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts_stg.org_party_id';
1725: -- l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1726: l_sql_str := 'SELECT ams_dm_org_contacts.party_id, '''|| l_master_type || '''';
1727: l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts, ams_dm_source';
1728: l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts.arc_object_used_by= ''SCOR''';
1729: l_sql_str := l_sql_str || ' AND ams_dm_org_contacts.object_used_by_id = '|| p_score_id;

Line 1727: l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts, ams_dm_source';

1723: -- l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1724: -- l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts_stg.org_party_id';
1725: -- l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1726: l_sql_str := 'SELECT ams_dm_org_contacts.party_id, '''|| l_master_type || '''';
1727: l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts, ams_dm_source';
1728: l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts.arc_object_used_by= ''SCOR''';
1729: l_sql_str := l_sql_str || ' AND ams_dm_org_contacts.object_used_by_id = '|| p_score_id;
1730: l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1731: l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;

Line 1730: l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';

1726: l_sql_str := 'SELECT ams_dm_org_contacts.party_id, '''|| l_master_type || '''';
1727: l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts, ams_dm_source';
1728: l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts.arc_object_used_by= ''SCOR''';
1729: l_sql_str := l_sql_str || ' AND ams_dm_org_contacts.object_used_by_id = '|| p_score_id;
1730: l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1731: l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1732: l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts.org_party_id';
1733: l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1734:

Line 1731: l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;

1727: l_sql_str := l_sql_str || ' FROM ams_dm_org_contacts, ams_dm_source';
1728: l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts.arc_object_used_by= ''SCOR''';
1729: l_sql_str := l_sql_str || ' AND ams_dm_org_contacts.object_used_by_id = '|| p_score_id;
1730: l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1731: l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1732: l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts.org_party_id';
1733: l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1734:
1735: -- G_LIST_SOURCE_NAME := 'AMS_DM_ORG_CONTACTS_STG';

Line 1732: l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts.org_party_id';

1728: l_sql_str := l_sql_str || ' WHERE ams_dm_org_contacts.arc_object_used_by= ''SCOR''';
1729: l_sql_str := l_sql_str || ' AND ams_dm_org_contacts.object_used_by_id = '|| p_score_id;
1730: l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1731: l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1732: l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts.org_party_id';
1733: l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1734:
1735: -- G_LIST_SOURCE_NAME := 'AMS_DM_ORG_CONTACTS_STG';
1736: G_LIST_SOURCE_NAME := 'ams_dm_org_contacts';

Line 1733: l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';

1729: l_sql_str := l_sql_str || ' AND ams_dm_org_contacts.object_used_by_id = '|| p_score_id;
1730: l_sql_str := l_sql_str || ' AND ams_dm_source.arc_used_for_object = ''SCOR''';
1731: l_sql_str := l_sql_str || ' AND ams_dm_source.used_for_object_id = '|| p_score_id;
1732: l_sql_str := l_sql_str || ' AND ams_dm_source.party_id = ams_dm_org_contacts.org_party_id';
1733: l_sql_str := l_sql_str || ' AND ams_dm_source.decile IN (' || p_tree_node_str || ')';
1734:
1735: -- G_LIST_SOURCE_NAME := 'AMS_DM_ORG_CONTACTS_STG';
1736: G_LIST_SOURCE_NAME := 'ams_dm_org_contacts';
1737:

Line 1740: l_sql_str := l_sql_str || ' FROM ams_dm_source';

1736: G_LIST_SOURCE_NAME := 'ams_dm_org_contacts';
1737:
1738: ELSE
1739: l_sql_str := 'SELECT party_id, '''|| l_master_type || '''';
1740: l_sql_str := l_sql_str || ' FROM ams_dm_source';
1741: l_sql_str := l_sql_str || ' WHERE arc_used_for_object = ''SCOR''';
1742: l_sql_str := l_sql_str || ' AND used_for_object_id = '|| p_score_id;
1743: l_sql_str := l_sql_str || ' AND decile IN (' || p_tree_node_str || ')';
1744: END IF;

Line 1752: -- p_primary_key is the party_id from ams_dm_source which

1748: END IF;
1749:
1750: --
1751: -- choang - 03-apr-2003
1752: -- p_primary_key is the party_id from ams_dm_source which
1753: -- holds the primary key defined from the data source. For
1754: -- seeded data sources, this holds the party id from TCA.
1755: AMS_LISTGENERATION_PKG.CREATE_LIST (
1756: p_api_version => 1.0,