[Home] [Help]
PACKAGE: APPS.BIS_PMF_ALERT_REG_PVT
Source
1 PACKAGE BIS_PMF_ALERT_REG_PVT AS
2 /* $Header: BISVARTS.pls 120.0 2005/06/01 17:30:31 appldev noship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISVARTS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Private API for managing Alert Registration Repository
14 REM |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | 17-May-2000 jradhakr Creation
19 REM | Jun-2000 irchen added manage_alert_registeration
20 REM | 27-Oct-2004 aguwalan Bug#3909131, added Add_Users_To_Role |
21 REM +=======================================================================+
22 */
23
24 G_BIS_ALERT_ROLE CONSTANT VARCHAR2(30):='BIS_ALERT';
25
26 --
27 -- PROCEDUREs
28 --
29
30 --
31 -- creates one parameter set
32 --
33 PROCEDURE Create_Parameter_set
34 ( p_api_version IN NUMBER
35 , p_commit IN VARCHAR2 := FND_API.G_FALSE
36 , p_Param_Set_Rec IN OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
37 , x_return_status OUT NOCOPY VARCHAR2
38 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
39 );
40
41 --
42 -- Delete one parameter set.
43 --
44 PROCEDURE Delete_Parameter_set
45 ( p_api_version IN NUMBER
46 , p_commit IN VARCHAR2 := FND_API.G_FALSE
47 , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
48 , x_return_status OUT NOCOPY VARCHAR2
49 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
50 );
51
52 PROCEDURE Delete_Parameter_Set
53 ( p_registration_ID IN NUMBER
54 , x_return_status OUT NOCOPY VARCHAR2
55 );
56
57 --
58 -- Retrieve a Table of parmeter set.
59 --
60 PROCEDURE Retrieve_Parameter_set
61 ( p_api_version IN NUMBER
62 , p_measure_id IN NUMBER
63 , p_time_dimension_level_id IN NUMBER
64 , p_current_row IN VARCHAR2 := NULL
65 , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
66 , x_return_status OUT NOCOPY VARCHAR2
67 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
68 );
69
70 PROCEDURE Retrieve_Parameter_set
71 ( p_api_version IN NUMBER
72 , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
73 , p_current_row IN VARCHAR2 := NULL
74 , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
75 , x_return_status OUT NOCOPY VARCHAR2
76 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
77 );
78
79 --
80 -- Retrieves the adHocRole
81 --
82 PROCEDURE Retrieve_Notifiers_Code
83 ( p_api_version IN NUMBER
84 , p_performance_measure_id IN NUMBER := NULL
85 , p_target_level_id IN NUMBER := NULL
86 , p_time_dimension_level_id IN NUMBER := NULL
87 , p_plan_id IN NUMBER := NULL
88 , p_parameter1_value IN VARCHAR2 := NULL
89 , p_parameter2_value IN VARCHAR2 := NULL
90 , p_parameter3_value IN VARCHAR2 := NULL
91 , p_parameter4_value IN VARCHAR2 := NULL
92 , p_parameter5_value IN VARCHAR2 := NULL
93 , p_parameter6_value IN VARCHAR2 := NULL
94 , p_parameter7_value IN VARCHAR2 := NULL
95 , p_current_row IN VARCHAR2 := NULL
96 , x_Notifiers_Code OUT NOCOPY VARCHAR2
97 , x_return_status OUT NOCOPY VARCHAR2
98 );
99
100 --
101 -- Retrieves the adHocRole
102 --
103 PROCEDURE Retrieve_Notifiers_Code
104 ( p_api_version IN NUMBER
105 , p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
106 , x_Notifiers_Code OUT NOCOPY VARCHAR2
107 , x_return_status OUT NOCOPY VARCHAR2
108 );
109
110
111 --
112 -- Checks if request is scheduled to run again. If not, the request
113 -- is deleted from the Registration table and the ad hoc workflow role
114 -- is removed.
115 --
116 PROCEDURE Manage_Alert_Registrations
117 ( p_Param_Set_Tbl IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
118 , x_request_scheduled OUT NOCOPY VARCHAR2
119 , x_return_status OUT NOCOPY VARCHAR2
120 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
121 );
122
123 PROCEDURE Manage_Alert_Registrations
124 ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
125 , x_request_scheduled OUT NOCOPY VARCHAR2
126 , x_return_status OUT NOCOPY VARCHAR2
127 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
128 );
129
130 PROCEDURE Manage_Alert_Registrations
131 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
132 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
133 , x_request_scheduled OUT NOCOPY VARCHAR2
134 , x_return_status OUT NOCOPY VARCHAR2
135 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
136 );
137
138 Procedure Form_Param_Set_Rec
139 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
140 , x_Param_Set_Rec OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
141 );
142
143 Procedure Form_Param_Set_Rec
144 ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
145 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
146 , x_Param_Set_Rec OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
147 );
148
149 --
150 -- Function which will return a boolean varible, if parameter set exist
151 -- and will also return the notifiers_code
152 --
153 FUNCTION Parameter_set_exist
154 ( p_api_version IN NUMBER
155 , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
156 , x_notifiers_code OUT NOCOPY VARCHAR2
157 , x_return_status OUT NOCOPY VARCHAR2
158 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
159 ) return boolean;
160
161
162 PROCEDURE Validate_Parameter_set
163 ( p_api_version IN NUMBER
164 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
165 , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
166 , x_return_status OUT NOCOPY VARCHAR2
167 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
168 );
169
170 PROCEDURE BuildAlertRegistrationURL
171 ( p_measure_id IN NUMBER
172 , p_target_level_id IN NUMBER := NULL
173 , p_plan_id IN VARCHAR2 := NULL
174 , p_parameter1levelId IN NUMBER := NULL
175 , p_parameter1ValueId IN VARCHAR2 := NULL
176 , p_parameter2levelId IN NUMBER := NULL
177 , p_parameter2ValueId IN VARCHAR2 := NULL
178 , p_parameter3levelId IN NUMBER := NULL
179 , p_parameter3ValueId IN VARCHAR2 := NULL
180 , p_parameter4levelId IN NUMBER := NULL
181 , p_parameter4ValueId IN VARCHAR2 := NULL
182 , p_parameter5levelId IN NUMBER := NULL
183 , p_parameter5ValueId IN VARCHAR2 := NULL
184 , p_parameter6levelId IN NUMBER := NULL
185 , p_parameter6ValueId IN VARCHAR2 := NULL
186 , p_parameter7levelId IN NUMBER := NULL
187 , p_parameter7ValueId IN VARCHAR2 := NULL
188 , p_viewByLevelId IN VARCHAR2 := NULL
189 , p_alertTip IN VARCHAR2 := NULL
190 , p_returnPageUrl IN VARCHAR2 := NULL
191 , x_alert_url OUT NOCOPY VARCHAR2
192 );
193
194 PROCEDURE BuildAlertRegistrationURL
195 ( p_measure_id IN NUMBER
196 , p_timelevel_id IN NUMBER
197 , p_viewByLevelId IN VARCHAR2 := NULL
198 , p_alertTip IN VARCHAR2 := NULL
199 , p_returnPageUrl IN VARCHAR2 := NULL
200 , x_alert_url OUT NOCOPY VARCHAR2
201 );
202
203 PROCEDURE BuildScheduleReportURL
204 ( p_RegionCode IN VARCHAR2
205 , p_FunctionName IN VARCHAR2
206 , p_ApplicationId IN VARCHAR2 := NULL
207 , p_plan_id IN VARCHAR2 := NULL
208 , p_parameter1levelId IN NUMBER := NULL
209 , p_parameter1ValueId IN VARCHAR2 := NULL
210 , p_parameter2levelId IN NUMBER := NULL
211 , p_parameter2ValueId IN VARCHAR2 := NULL
212 , p_parameter3levelId IN NUMBER := NULL
213 , p_parameter3ValueId IN VARCHAR2 := NULL
214 , p_parameter4levelId IN NUMBER := NULL
215 , p_parameter4ValueId IN VARCHAR2 := NULL
216 , p_parameter5levelId IN NUMBER := NULL
217 , p_parameter5ValueId IN VARCHAR2 := NULL
218 , p_parameter6levelId IN NUMBER := NULL
219 , p_parameter6ValueId IN VARCHAR2 := NULL
220 , p_parameter7levelId IN NUMBER := NULL
221 , p_parameter7ValueId IN VARCHAR2 := NULL
222 , p_viewByLevelId IN VARCHAR2 := NULL
223 , p_alertTip IN VARCHAR2 := NULL
224 , p_returnPageUrl IN VARCHAR2 := NULL
225 , x_alert_url OUT NOCOPY VARCHAR2
226 );
227
228
229 PROCEDURE Add_Users_To_Role
230 ( p_role_name IN VARCHAR2
231 , p_user_names IN VARCHAR2
232 );
233
234 END BIS_PMF_ALERT_REG_PVT;