1 PACKAGE BIS_MEASURE_SECURITY_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPMSES.pls 115.27 2003/12/01 08:34:38 gramasam noship $ */
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 | BISPMSES.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 |
20 REM +=======================================================================+
21 */
22 --
23 -- Data Types: Records
24 --
25 TYPE Measure_Security_Rec_Type IS RECORD (
26 Target_Level_ID NUMBER ,
27 Target_Level_Short_Name VARCHAR2(80) ,
28 Target_Level_Name VARCHAR2(80) ,
29 Responsibility_ID NUMBER ,
30 Responsibility_Short_Name VARCHAR2(30) ,
31 Responsibility_Name VARCHAR2(100) );
32
33
34 -- Data Types: Tables
35
36 TYPE Measure_Security_Tbl_Type is TABLE of Measure_Security_Rec_Type
37 INDEX BY BINARY_INTEGER;
38
39 -- Global Missing Composite Types
40
41 G_MISS_MEAS_SECURITY_REC Measure_Security_Rec_Type;
42 G_MISS_MEAS_SECURITY_TBL Measure_Security_Tbl_Type;
43
44 -- PROCEDUREs
45 --
46 -- creates one Measure, with the dimensions sequenced in the order
47 -- they are passed in
48 PROCEDURE Create_Measure_Security
49 ( p_api_version IN NUMBER
50 , p_commit IN VARCHAR2 := FND_API.G_FALSE
51 ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
52 , x_return_status OUT NOCOPY VARCHAR2
53 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
54 );
55 --
56 --
57 PROCEDURE Retrieve_Measure_Securities
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 --
65 --
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 --
77 -- PLEASE VERIFY COMMENT BELOW
78 -- Update_Measure_Securitys one Measure if
79 -- 1) no Measure levels or targets exist
80 -- 2) no users have selected to see actuals for the Measure
81 PROCEDURE Update_Measure_Security
82 ( p_api_version IN NUMBER
83 , p_commit IN VARCHAR2 := FND_API.G_FALSE
84 ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
85 , x_return_status OUT NOCOPY VARCHAR2
86 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
87 );
88 --
89 --
90 -- PLEASE VERIFY COMMENT BELOW
91 -- deletes one Measure if
92 -- 1) no Measure levels, targets exist and
93 -- 2) the Measure access has not been granted to a resonsibility
94 -- 3) no users have selected to see actuals for the Measure
95 PROCEDURE Delete_Measure_Security
96 ( p_api_version IN NUMBER
97 , p_commit IN VARCHAR2 := FND_API.G_FALSE
98 ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
99 , x_return_status OUT NOCOPY VARCHAR2
100 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
101 );
102 --
103 -- Validates measure
104 PROCEDURE Validate_Measure_Security
105 ( p_api_version IN NUMBER
106 ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
107 , x_return_status OUT NOCOPY VARCHAR2
108 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
109 );
110 --
111
112 -- new API to validate Measure Security for bug 1716213
113 -- Validates measure securtity
114 PROCEDURE Validate_Measure_Security
115 ( p_api_version IN NUMBER
116 , p_user_id IN NUMBER
117 , p_Measure_Security_Rec IN 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 --
123 -- new API to delete the responsibilities attached to the target levels
124 -- pertaining to the measure specified by the measure short name
125 PROCEDURE Delete_TargetLevel_Resp
126 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
127 , p_measure_short_name IN VARCHAR2
128 , x_return_status OUT NOCOPY VARCHAR2
129 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
130 );
131
132
133 END BIS_MEASURE_SECURITY_PUB;