APPS.BIS_WEIGHTED_MEASURE_PVT dependencies on BIS_WEIGHTED_MEASURE_DEFNS

Line 302: ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS

298: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
299: raise;
300: END Delete_WM_Dependency;
301:
302: ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
303:
304: /*******************************************************************
305: *******************************************************************/
306: PROCEDURE Create_WM_Definition(

Line 319: INSERT INTO BIS_WEIGHTED_MEASURE_DEFNS(

315: BEGIN
316: SAVEPOINT CreateWMDefinitionPVT;
317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: INSERT INTO BIS_WEIGHTED_MEASURE_DEFNS(
320: WEIGHTED_DEFINITION_ID
321: ,WEIGHTED_MEASURE_ID
322: ,VIEWBY_DIMENSION_SHORT_NAME
323: ,VIEWBY_DIM_LEVEL_SHORT_NAME

Line 433: FROM BIS_WEIGHTED_MEASURE_DEFNS

429: ,x_Bis_WM_Rec.Created_By
430: ,x_Bis_WM_Rec.Last_Update_Date
431: ,x_Bis_WM_Rec.Last_Updated_By
432: ,x_Bis_WM_Rec.Last_Update_Login
433: FROM BIS_WEIGHTED_MEASURE_DEFNS
434: WHERE WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN

Line 496: UPDATE BIS_WEIGHTED_MEASURE_DEFNS SET

492: BEGIN
493: SAVEPOINT bis_Update_WM_Definition_PVT;
494: x_return_status := FND_API.G_RET_STS_SUCCESS;
495:
496: UPDATE BIS_WEIGHTED_MEASURE_DEFNS SET
497: WEIGHTED_MEASURE_ID = p_Bis_WM_Rec.weighted_measure_id
498: ,VIEWBY_DIMENSION_SHORT_NAME = p_Bis_WM_Rec.VIEWBY_dimension_SN
499: ,VIEWBY_DIM_LEVEL_SHORT_NAME = p_Bis_WM_Rec.VIEWBY_dim_level_SN
500: ,FILTER_DIMENSION_SHORT_NAME = p_Bis_WM_Rec.FILTER_dimension_SN

Line 566: DELETE BIS_WEIGHTED_MEASURE_DEFNS

562: BEGIN
563: SAVEPOINT Delete_WM_Definition_PVT;
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565:
566: DELETE BIS_WEIGHTED_MEASURE_DEFNS
567: WHERE WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;
568:
569: IF p_commit = FND_API.G_TRUE THEN
570: COMMIT;