DBA Data[Home] [Help]

APPS.BIS_MEASURE_SECURITY_PUB dependencies on BIS_MEASURE_SECURITY_PUB

Line 1: PACKAGE BODY BIS_MEASURE_SECURITY_PUB AS

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 +=======================================================================+

Line 26: G_PKG_NAME CONSTANT VARCHAR2(30):= 'BIS_MEASURE_SECURITY_PUB';

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

Line 32: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

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

Line 37: l_Measure_Security_Rec 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
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;

Line 94: , x_Measure_Security_tbl OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type

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

Line 100: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;

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

Line 103: l_meas_rec_p BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;

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

Line 178: , p_Measure_Security_Rec IN BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type

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: )

Line 179: , x_Measure_Security_Rec OUT NOCOPY BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type

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

Line 184: l_Measure_Security_Rec 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
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

Line 246: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

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

Line 251: l_Measure_Security_Rec 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
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

Line 313: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

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

Line 318: l_Measure_Security_Rec 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
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

Line 374: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

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

Line 379: l_Measure_Security_Rec 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
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

Line 437: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

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

Line 442: l_Measure_Security_Rec 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
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

Line 536: END BIS_MEASURE_SECURITY_PUB;

532: );
533: END Delete_TargetLevel_Resp;
534:
535:
536: END BIS_MEASURE_SECURITY_PUB;