APPS.BIS_WEIGHTED_MEASURE_PVT dependencies on BIS_WEIGHTED_MEASURE_WEIGHTS

Line 896: ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS

892: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
893: raise;
894: END Delete_WM_Parameter;
895:
896: ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS
897:
898: /*******************************************************************
899: *******************************************************************/
900: PROCEDURE Create_WM_Weight(

Line 912: INSERT INTO BIS_WEIGHTED_MEASURE_WEIGHTS(

908: BEGIN
909: SAVEPOINT CreateWMDependencyPVT;
910: x_return_status := FND_API.G_RET_STS_SUCCESS;
911:
912: INSERT INTO BIS_WEIGHTED_MEASURE_WEIGHTS(
913: WEIGHT_ID
914: ,WEIGHTED_PARAMETER_ID
915: ,DEPENDENT_MEASURE_ID
916: ,WEIGHT

Line 1009: FROM BIS_WEIGHTED_MEASURE_WEIGHTS

1005: ,x_Bis_WM_Rec.Created_By
1006: ,x_Bis_WM_Rec.Last_Update_Date
1007: ,x_Bis_WM_Rec.Last_Updated_By
1008: ,x_Bis_WM_Rec.Last_Update_Login
1009: FROM BIS_WEIGHTED_MEASURE_WEIGHTS
1010: WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
1011:
1012:
1013: EXCEPTION

Line 1071: UPDATE BIS_WEIGHTED_MEASURE_WEIGHTS SET

1067:
1068: SAVEPOINT bis_Update_WM_Weight_PVT;
1069: x_return_status := FND_API.G_RET_STS_SUCCESS;
1070:
1071: UPDATE BIS_WEIGHTED_MEASURE_WEIGHTS SET
1072: WEIGHT_ID = p_Bis_WM_Rec.weight_id
1073: ,WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id
1074: ,DEPENDENT_MEASURE_ID = p_Bis_WM_Rec.dependent_measure_id
1075: ,WEIGHT = p_Bis_WM_Rec.weight

Line 1137: DELETE BIS_WEIGHTED_MEASURE_WEIGHTS

1133: BEGIN
1134: SAVEPOINT Delete_WM_Weight_PVT;
1135: x_return_status := FND_API.G_RET_STS_SUCCESS;
1136:
1137: DELETE BIS_WEIGHTED_MEASURE_WEIGHTS
1138: WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
1139:
1140: IF p_commit = FND_API.G_TRUE THEN
1141: COMMIT;