APPS.AMS_SCORERESULT_PVT dependencies on AMS_DM_SCORE_PCT_RESULTS

Line 33: -- run results by percentile in AMS_DM_SCORE_PCT_RESULTS table.

29: -- 19-Mar-2003 choang Bug 2856138 - Added return status for OSOException in JSP.
30: -- 04-Apr-2003 choang Bug 2888007 - fixed primary_key param in list create API
31: -- invocation.
32: -- 17-Jun-2003 nyostos Added procedure insert_percentile_results to summarize scoring
33: -- run results by percentile in AMS_DM_SCORE_PCT_RESULTS table.
34: -- These results are used in calculating the Optimal Targeting Chart.
35: -- 31-Jul-2003 nyostos Fixed logic in insert_percentile_results to account for having fewer
36: -- than 100 records.
37: -- 12-Aug-2003 kbasavar For Customer profitability

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 1159: DELETE FROM ams_dm_score_pct_results

1155: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1156: END IF;
1157:
1158: -- clear results from any previous execution
1159: DELETE FROM ams_dm_score_pct_results
1160: WHERE score_id = l_score_id;
1161:
1162: -- First get the total number of parties in ams_dm_scource
1163: OPEN c_total_records (l_score_id);

Line 1241: /*INSERT INTO ams_dm_score_pct_results (

1237: l_num_recs_cum_list(l_ctr_2) := l_num_records_cum;
1238: l_avg_conf_list(l_ctr_2) := l_avg_confidence;
1239: l_avg_conf_cum_list(l_ctr_2) := l_avg_confidence_cum;
1240:
1241: /*INSERT INTO ams_dm_score_pct_results (
1242: score_result_id,
1243: last_update_date,
1244: last_updated_by,
1245: creation_date,

Line 1257: ams_dm_score_pct_results_s.NEXTVAL,

1253: confidence,
1254: confidence_cum,
1255: random_result
1256: ) VALUES (
1257: ams_dm_score_pct_results_s.NEXTVAL,
1258: SYSDATE,
1259: FND_GLOBAL.user_id,
1260: SYSDATE,
1261: FND_GLOBAL.user_id,

Line 1327: INSERT INTO ams_dm_score_pct_results (

1323: -- If some records were inserted, then insert a record for the zero percentile
1324: -- to start the graph from the origin
1325: IF l_total_records > 0 THEN
1326: FORALL h IN 1..l_percentile_list.COUNT
1327: INSERT INTO ams_dm_score_pct_results (
1328: score_result_id,
1329: last_update_date,
1330: last_updated_by,
1331: creation_date,

Line 1343: ams_dm_score_pct_results_s.NEXTVAL,

1339: confidence,
1340: confidence_cum,
1341: random_result
1342: ) VALUES (
1343: ams_dm_score_pct_results_s.NEXTVAL,
1344: SYSDATE,
1345: FND_GLOBAL.user_id,
1346: SYSDATE,
1347: FND_GLOBAL.user_id,

Line 1358: INSERT INTO ams_dm_score_pct_results (

1354: l_avg_conf_list(h),
1355: l_avg_conf_cum_list(h),
1356: 0
1357: );
1358: INSERT INTO ams_dm_score_pct_results (
1359: score_result_id,
1360: last_update_date,
1361: last_updated_by,
1362: creation_date,

Line 1374: ams_dm_score_pct_results_s.NEXTVAL,

1370: confidence,
1371: confidence_cum,
1372: random_result
1373: ) VALUES (
1374: ams_dm_score_pct_results_s.NEXTVAL,
1375: SYSDATE,
1376: FND_GLOBAL.user_id,
1377: SYSDATE,
1378: FND_GLOBAL.user_id,

Line 1401: UPDATE ams_dm_score_pct_results

1397: AMS_UTILITY_PVT.debug_message('Inserted record for zeroth percentile: ');
1398: AMS_UTILITY_PVT.debug_message('Cumulative Average Confidence for 100th percentile: ' || l_avg_confidence_cum );
1399: END IF;
1400:
1401: UPDATE ams_dm_score_pct_results
1402: SET RANDOM_RESULT = l_avg_confidence_cum
1403: WHERE score_id = l_score_id
1404: AND percentile > 0;
1405: END IF;