DBA Data[Home] [Help]

APPS.BIS_WEIGHTED_MEASURE_PVT dependencies on BIS_WEIGHTED_MEASURE_PARAMS

Line 611: ------- APIs for table BIS_WEIGHTED_MEASURE_PARAMS

607: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
608: raise;
609: END Delete_WM_Definition;
610:
611: ------- APIs for table BIS_WEIGHTED_MEASURE_PARAMS
612:
613: /*******************************************************************
614: *******************************************************************/
615: PROCEDURE Create_WM_Parameter(

Line 628: INSERT INTO BIS_WEIGHTED_MEASURE_PARAMS(

624: BEGIN
625: SAVEPOINT CreateWMParameterPVT;
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: INSERT INTO BIS_WEIGHTED_MEASURE_PARAMS(
629: WEIGHTED_PARAMETER_ID
630: ,WEIGHTED_DEFINITION_ID
631: ,TIME_LEVEL_VALUE_ID
632: ,FILTER_LEVEL_VALUE_ID

Line 726: FROM BIS_WEIGHTED_MEASURE_PARAMS

722: ,x_Bis_WM_Rec.Created_By
723: ,x_Bis_WM_Rec.Last_Update_Date
724: ,x_Bis_WM_Rec.Last_Updated_By
725: ,x_Bis_WM_Rec.Last_Update_Login
726: FROM BIS_WEIGHTED_MEASURE_PARAMS
727: WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;
728:
729:
730:

Line 782: UPDATE BIS_WEIGHTED_MEASURE_PARAMS SET

778: BEGIN
779: SAVEPOINT bis_Update_WM_Parameter_PVT;
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: UPDATE BIS_WEIGHTED_MEASURE_PARAMS SET
783: WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id
784: ,TIME_LEVEL_VALUE_ID = p_Bis_WM_Rec.time_level_value_id
785: ,FILTER_LEVEL_VALUE_ID = p_Bis_WM_Rec.filter_level_value_id
786: ,LAST_UPDATE_DATE = p_Bis_WM_Rec.Last_Update_Date

Line 851: DELETE BIS_WEIGHTED_MEASURE_PARAMS

847: BEGIN
848: SAVEPOINT Delete_WM_Parameter_PVT;
849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850:
851: DELETE BIS_WEIGHTED_MEASURE_PARAMS
852: WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;
853:
854: IF p_commit = FND_API.G_TRUE THEN
855: COMMIT;