[Home] [Help]
1178: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1179: raise;
1180: END Delete_WM_Weight;
1181:
1182: ------- APIs for table BIS_WEIGHTED_MEASURE_SCORES
1183: /*******************************************************************
1184: *******************************************************************/
1185: PROCEDURE Create_WM_Score(
1186: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1193: BEGIN
1194: SAVEPOINT bisCreateWMScorePVT;
1195: x_return_status := FND_API.G_RET_STS_SUCCESS;
1196:
1197: INSERT INTO BIS_WEIGHTED_MEASURE_SCORES(
1198: WEIGHT_ID
1199: ,LOW_RANGE
1200: ,HIGH_RANGE
1201: ,SCORE
1290: ,x_Bis_WM_Rec.Created_By
1291: ,x_Bis_WM_Rec.Last_Update_Date
1292: ,x_Bis_WM_Rec.Last_Updated_By
1293: ,x_Bis_WM_Rec.Last_Update_Login
1294: FROM BIS_WEIGHTED_MEASURE_SCORES
1295: WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id
1296: AND LOW_RANGE = p_Bis_WM_Rec.low_range
1297: AND HIGH_RANGE = p_Bis_WM_Rec.high_range;
1298:
1356: BEGIN
1357: SAVEPOINT bis_Update_WM_Score_PVT;
1358: x_return_status := FND_API.G_RET_STS_SUCCESS;
1359:
1360: UPDATE BIS_WEIGHTED_MEASURE_SCORES SET
1361: WEIGHT_ID = p_Bis_WM_Rec.weight_id
1362: ,LOW_RANGE = p_Bis_WM_Rec.low_range
1363: ,HIGH_RANGE = p_Bis_WM_Rec.high_range
1364: ,SCORE = p_Bis_WM_Rec.score
1427:
1428: IF p_Bis_WM_Rec.low_range IS NULL AND p_Bis_WM_Rec.low_range IS NULL THEN
1429: -- delete all the Scores for a specific Weight_id
1430: -- Use for Cascading
1431: DELETE BIS_WEIGHTED_MEASURE_SCORES
1432: WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
1433: ELSE
1434: -- Delete jus one Score
1435: DELETE BIS_WEIGHTED_MEASURE_SCORES
1431: DELETE BIS_WEIGHTED_MEASURE_SCORES
1432: WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
1433: ELSE
1434: -- Delete jus one Score
1435: DELETE BIS_WEIGHTED_MEASURE_SCORES
1436: WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id
1437: AND LOW_RANGE = p_Bis_WM_Rec.low_range
1438: AND HIGH_RANGE = p_Bis_WM_Rec.high_range;
1439: END IF;