APPS.BIS_WEIGHTED_MEASURE_PVT dependencies on BIS_WEIGHTED_MEASURE_DEPENDS

Line 30: ------- APIs for tables BIS_WEIGHTED_MEASURE_DEPENDS

26: -- Abbreviation Used"
27: -- WM -> Weighted Measure
28: -- SN -> Short Name
29:
30: ------- APIs for tables BIS_WEIGHTED_MEASURE_DEPENDS
31: /*******************************************************************
32: *******************************************************************/
33: PROCEDURE Create_WM_Dependency(
34: p_commit IN VARCHAR2 --:= FND_API.G_FALSE

Line 45: INSERT INTO BIS_WEIGHTED_MEASURE_DEPENDS(

41: BEGIN
42: SAVEPOINT CreateWMDependencyPVT;
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: INSERT INTO BIS_WEIGHTED_MEASURE_DEPENDS(
46: WEIGHTED_MEASURE_ID
47: ,DEPENDENT_MEASURE_ID
48: ,CREATION_DATE
49: ,CREATED_BY

Line 135: FROM BIS_WEIGHTED_MEASURE_DEPENDS

131: ,x_Bis_WM_Rec.Created_By
132: ,x_Bis_WM_Rec.Last_Update_Date
133: ,x_Bis_WM_Rec.Last_Updated_By
134: ,x_Bis_WM_Rec.Last_Update_Login
135: FROM BIS_WEIGHTED_MEASURE_DEPENDS
136: WHERE WEIGHTED_MEASURE_ID = p_Bis_WM_Rec.weighted_measure_id
137: AND DEPENDENT_MEASURE_ID = p_Bis_WM_Rec.dependent_measure_id;
138:
139:

Line 192: UPDATE BIS_WEIGHTED_MEASURE_DEPENDS SET

188: BEGIN
189: SAVEPOINT bis_Update_WM_Dependency_PVT;
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191:
192: UPDATE BIS_WEIGHTED_MEASURE_DEPENDS SET
193: LAST_UPDATE_DATE = p_Bis_WM_Rec.Last_Update_Date
194: ,LAST_UPDATED_BY = p_Bis_WM_Rec.Last_Updated_By
195: ,LAST_UPDATE_LOGIN = p_Bis_WM_Rec.Last_Update_Login
196: WHERE WEIGHTED_MEASURE_ID = p_Bis_WM_Rec.weighted_measure_id

Line 255: DELETE BIS_WEIGHTED_MEASURE_DEPENDS

251: BEGIN
252: SAVEPOINT Delete_WM_Dependency_PVT;
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: DELETE BIS_WEIGHTED_MEASURE_DEPENDS
256: WHERE WEIGHTED_MEASURE_ID = p_Bis_WM_Rec.weighted_measure_id
257: AND DEPENDENT_MEASURE_ID = p_Bis_WM_Rec.dependent_measure_id;
258:
259: