1 PACKAGE BIS_MEASURE_SECURITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVMSES.pls 115.26 2003/12/01 08:39:25 gramasam ship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISVMSES.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Public API for creating and managing Performance Measurements
14 REM |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | 28-NOV-98 irchen Creation |
19 REM | Sep-2000 JPRABHUD Added new procedure Retrieve_Measure_Sec_Sorted |
20 REM | 25-NOV-03 gramasam Included a new procedure for deleting |
21 REM | responsibilities at target level |
22 REM +=======================================================================+
23 */
24 --
25 --
26 -- creates one Measure_Security, with the dimensions sequenced in the order
27 -- they are passed in
28 Procedure Create_Measure_Security
29 ( p_api_version IN NUMBER
30 , p_commit IN VARCHAR2 := FND_API.G_FALSE
31 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
32 ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
33 , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER --2465354
34 , x_return_status OUT NOCOPY VARCHAR2
35 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
36 );
37 --
38 --
39 -- Gets All Performance Measure_Securitys
40 -- If information about the dimensions are not required, set all_info to
41 -- FALSE
42 --
43 PROCEDURE Retrieve_Measure_Securities
44 ( p_api_version IN NUMBER
45 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
46 , x_Measure_Security_tbl OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
49 );
50 --
51 --
52 -- added this procedure
53 -- Gets All Performance Measure_Securities in a sorted order
54 -- If information about the dimensions are not required, set all_info to
55 -- FALSE
56 --
57 PROCEDURE Retrieve_Measure_Sec_Sorted
58 ( p_api_version IN NUMBER
59 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
60 , x_Measure_Security_tbl OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
61 , x_return_status OUT NOCOPY VARCHAR2
62 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
63 );
64 -- Gets Information for One Performance Measure_Security
65 -- If information about the dimension are not required, set all_info to FALSE.
66 --
67 --
68 PROCEDURE Retrieve_Measure_Security
69 ( p_api_version IN NUMBER
70 , p_Measure_Security_Rec IN BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
71 , x_Measure_Security_Rec OUT NOCOPY BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
72 , x_return_status OUT NOCOPY VARCHAR2
73 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
74 );
75 --
76 Procedure Update_Measure_Security
77 ( p_api_version IN NUMBER
78 , p_commit IN VARCHAR2 := FND_API.G_FALSE
79 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
80 , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
81 , x_return_status OUT NOCOPY VARCHAR2
82 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
83 );
84 --
85 --
86 -- PLEASE VERIFY COMMENT BELOW
87 -- Deletes ALL responsibilities associated with a target level
88 Procedure Delete_Measure_Security
89 ( p_api_version IN NUMBER
90 , p_commit IN VARCHAR2 := FND_API.G_FALSE
91 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
92 , x_return_status OUT NOCOPY VARCHAR2
93 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
94 );
95 --
96 Procedure Delete_Measure_Security
97 ( p_api_version IN NUMBER
98 , p_commit IN VARCHAR2 := FND_API.G_FALSE
99 ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
100 , x_return_status OUT NOCOPY VARCHAR2
101 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
102 );
103 --
104 -- Validates Measure_Security
105 PROCEDURE Validate_Measure_Security
106 ( p_api_version IN NUMBER
107 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108 ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
109 , x_return_status OUT NOCOPY VARCHAR2
110 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
111 );
112 --
113 -- Value - ID conversion
114 PROCEDURE Value_ID_Conversion
115 ( p_api_version IN NUMBER
116 , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
117 , x_Measure_Security_Rec OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
118 , x_return_status OUT NOCOPY VARCHAR2
119 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
120 );
121 --
122 -- This procedure retrieves the responsibility which the user has AND
123 -- has access to this indicator level
124 Procedure Retrieve_Tar_Level_User_Resps
125 ( p_api_version IN NUMBER
126 , p_user_id IN NUMBER
127 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
128 , x_Measure_security_Tbl OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
129 , x_return_status OUT NOCOPY VARCHAR2
130 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
131 );
132
133 -- new API to validate Measure Security for bug 1716213
134 -- Validates Measure_Security
135 PROCEDURE Validate_Measure_Security
136 ( p_api_version IN NUMBER
137 , p_user_id IN NUMBER
138 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
139 , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
140 , x_return_status OUT NOCOPY VARCHAR2
141 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
142 );
143
144 -- new API to delete the responsibilities attached to the target levels
145 -- pertaining to the measure specified by the measure short name
146 PROCEDURE Delete_TargetLevel_Resp
147 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
148 , p_measure_short_name IN VARCHAR2
149 , x_return_status OUT NOCOPY VARCHAR2
150 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
151 );
152
153 END BIS_MEASURE_SECURITY_PVT;
[Home] [Help]