1: PACKAGE BODY BIS_MEASURE_SECURITY_PUB AS
2: /* $Header: BISPMSEB.pls 115.25 2003/12/01 08:36:41 gramasam noship $ */
3: --
4: /*
5: REM +=======================================================================+
22: REM | responsibilities at target level |
23: REM +=======================================================================+
24: */
25: --
26: G_PKG_NAME CONSTANT VARCHAR2(30):= 'BIS_MEASURE_SECURITY_PUB';
27: -- creates one Measure, with the dimensions sequenced in the order
28: -- they are passed in
29: PROCEDURE Create_Measure_Security
30: ( p_api_version IN NUMBER
28: -- they are passed in
29: PROCEDURE Create_Measure_Security
30: ( p_api_version IN NUMBER
31: , p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
33: , x_return_status OUT NOCOPY VARCHAR2
34: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
35: )
36: is
33: , x_return_status OUT NOCOPY VARCHAR2
34: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
35: )
36: is
37: l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
38: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
39: begin
40:
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
90: --
91: PROCEDURE Retrieve_Measure_Securities
92: ( p_api_version IN NUMBER
93: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
94: , x_Measure_Security_tbl OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
95: , x_return_status OUT NOCOPY VARCHAR2
96: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
97: )
98: is
96: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
97: )
98: is
99: --added this
100: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
101: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
102: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
103: l_meas_rec_p BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
104: begin
99: --added this
100: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
101: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
102: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
103: l_meas_rec_p BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
104: begin
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106: /*
107: BIS_Target_Level_PVT.Value_ID_Conversion( p_api_version
174: --
175: --
176: PROCEDURE Retrieve_Measure_Security
177: ( p_api_version IN NUMBER
178: , p_Measure_Security_Rec IN BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
179: , x_Measure_Security_Rec OUT NOCOPY BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
180: , x_return_status OUT NOCOPY VARCHAR2
181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
182: )
175: --
176: PROCEDURE Retrieve_Measure_Security
177: ( p_api_version IN NUMBER
178: , p_Measure_Security_Rec IN BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
179: , x_Measure_Security_Rec OUT NOCOPY BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
180: , x_return_status OUT NOCOPY VARCHAR2
181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
182: )
183: is
180: , x_return_status OUT NOCOPY VARCHAR2
181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
182: )
183: is
184: l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
185: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
186: begin
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188: BIS_MEASURE_SECURITY_PVT.Value_ID_Conversion( p_api_version
242: -- 2) no users have selected to see actuals for the Measure
243: PROCEDURE Update_Measure_Security
244: ( p_api_version IN NUMBER
245: , p_commit IN VARCHAR2 := FND_API.G_FALSE
246: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
247: , x_return_status OUT NOCOPY VARCHAR2
248: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
249: )
250: is
247: , x_return_status OUT NOCOPY VARCHAR2
248: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
249: )
250: is
251: l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
252: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
253: begin
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255: BIS_MEASURE_SECURITY_PVT.Value_ID_Conversion( p_api_version
309: -- 3) no users have selected to see actuals for the Measure
310: PROCEDURE Delete_Measure_Security
311: ( p_api_version IN NUMBER
312: , p_commit IN VARCHAR2 := FND_API.G_FALSE
313: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
314: , x_return_status OUT NOCOPY VARCHAR2
315: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
316: )
317: is
314: , x_return_status OUT NOCOPY VARCHAR2
315: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
316: )
317: is
318: l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
319: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
320: begin
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: BIS_MEASURE_SECURITY_PVT.Value_ID_Conversion( p_api_version
370: --
371: -- Validates measure
372: PROCEDURE Validate_Measure_Security
373: ( p_api_version IN NUMBER
374: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
377: )
378: is
375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
377: )
378: is
379: l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
380: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
381: begin
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383: BIS_MEASURE_SECURITY_PVT.Value_ID_Conversion( p_api_version
433: -- Validates measure
434: PROCEDURE Validate_Measure_Security
435: ( p_api_version IN NUMBER
436: , p_user_id IN NUMBER
437: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
438: , x_return_status OUT NOCOPY VARCHAR2
439: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
440: )
441: is
438: , x_return_status OUT NOCOPY VARCHAR2
439: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
440: )
441: is
442: l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
443: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
444: begin
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446: BIS_MEASURE_SECURITY_PVT.Value_ID_Conversion( p_api_version
532: );
533: END Delete_TargetLevel_Resp;
534:
535:
536: END BIS_MEASURE_SECURITY_PUB;