1 PACKAGE CSI_COUNTER_TEMPLATE_PUB AS
2 /* $Header: csipctts.pls 120.3.12010000.1 2008/07/25 08:11:02 appldev ship $ */
3
4 -- --------------------------------------------------------
5 -- Define global variables
6 -- --------------------------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_TEMPLATE_PUB';
9 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csipctts.pls';
10
11 TYPE ctr_template_autoinst_rec IS RECORD
12 (COUNTER_ID NUMBER
13 ,GROUP_ID NUMBER
14 );
15 TYPE ctr_template_autoinst_tbl IS TABLE OF ctr_template_autoinst_rec INDEX BY BINARY_INTEGER;
16
17 TYPE counter_autoinstantiate_rec IS RECORD
18 (COUNTER_ID NUMBER
19 ,GROUP_ID NUMBER
20 );
21 TYPE counter_autoinstantiate_tbl IS TABLE OF counter_autoinstantiate_rec INDEX BY BINARY_INTEGER;
22
23 --|---------------------------------------------------
24 --| procedure name: create_counter_group
25 --| description : procedure used to
26 --| create counter group
27 --|---------------------------------------------------
28
29
30 PROCEDURE create_counter_group
31 (p_api_version IN NUMBER
32 ,p_commit IN VARCHAR2
33 ,p_init_msg_list IN VARCHAR2
34 ,p_validation_level IN NUMBER
35 ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
36 ,p_ctr_item_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2
40 );
41
42 --|---------------------------------------------------
43 --| procedure name: create_item_association
44 --| description : procedure used to
45 --| create item association to
46 --| counter group or counters
47 --|---------------------------------------------------
48
49 PROCEDURE create_item_association
50 (
51 p_api_version IN NUMBER
52 ,p_commit IN VARCHAR2
53 ,p_init_msg_list IN VARCHAR2
54 ,p_validation_level IN NUMBER
55 ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 --|---------------------------------------------------
62 --| procedure name: create_counter_template
63 --| description : procedure used to
64 --| create counter template
65 --|---------------------------------------------------
66
67 PROCEDURE create_counter_template
68 (
69 p_api_version IN NUMBER
70 ,p_commit IN VARCHAR2
71 ,p_init_msg_list IN VARCHAR2
72 ,p_validation_level IN NUMBER
73 ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
74 ,p_ctr_item_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
75 ,p_ctr_property_template_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl
76 ,p_counter_relationships_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
77 ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 --|---------------------------------------------------
84 --| procedure name: create_ctr_property_template
85 --| description : procedure used to
86 --| create counter properties
87 --|---------------------------------------------------
88
89 PROCEDURE create_ctr_property_template
90 (
91 p_api_version IN NUMBER
92 ,p_commit IN VARCHAR2
93 ,p_init_msg_list IN VARCHAR2
94 ,p_validation_level IN NUMBER
95 ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
96 ,x_return_status OUT NOCOPY VARCHAR2
97 ,x_msg_count OUT NOCOPY NUMBER
98 ,x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101
102 --|---------------------------------------------------
103 --| procedure name: create_counter_relationship
104 --| description : procedure used to
105 --| create counter relationship
106 --|---------------------------------------------------
107
108 PROCEDURE create_counter_relationship
109 (
110 p_api_version IN NUMBER
111 ,p_commit IN VARCHAR2
112 ,p_init_msg_list IN VARCHAR2
113 ,p_validation_level IN NUMBER
114 ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
115 ,x_return_status OUT NOCOPY VARCHAR2
116 ,x_msg_count OUT NOCOPY NUMBER
117 ,x_msg_data OUT NOCOPY VARCHAR2
118 );
119
120 --|---------------------------------------------------
121 --| procedure name: create_derived_filters
122 --| description : procedure used to
123 --| create derived filters
124 --|---------------------------------------------------
125
126 PROCEDURE create_derived_filters
127 (
128 p_api_version IN NUMBER
129 ,p_commit IN VARCHAR2
130 ,p_init_msg_list IN VARCHAR2
131 ,p_validation_level IN NUMBER
132 ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
133 ,x_return_status OUT NOCOPY VARCHAR2
134 ,x_msg_count OUT NOCOPY NUMBER
135 ,x_msg_data OUT NOCOPY VARCHAR2
136 );
137
138 --|---------------------------------------------------
139 --| procedure name: update_counter_group
140 --| description : procedure used to
141 --| update counter group
142 --|---------------------------------------------------
143
144 PROCEDURE update_counter_group
145 (
146 p_api_version IN NUMBER
147 ,p_commit IN VARCHAR2
148 ,p_init_msg_list IN VARCHAR2
149 ,p_validation_level IN NUMBER
150 ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
151 ,p_ctr_item_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2
155 );
156
157 --|---------------------------------------------------
158 --| procedure name: update_item_association
159 --| description : procedure used to
160 --| update item association to
161 --| counter group or counters
162 --|---------------------------------------------------
163
164 PROCEDURE update_item_association
165 (
166 p_api_version IN NUMBER
167 ,p_commit IN VARCHAR2
168 ,p_init_msg_list IN VARCHAR2
169 ,p_validation_level IN NUMBER
170 ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
171 ,x_return_status OUT NOCOPY VARCHAR2
172 ,x_msg_count OUT NOCOPY NUMBER
173 ,x_msg_data OUT NOCOPY VARCHAR2
174 );
175
176 --|---------------------------------------------------
177 --| procedure name: update_counter_template
178 --| description : procedure used to
179 --| update counter template
180 --|---------------------------------------------------
181
182 PROCEDURE update_counter_template
183 (
184 p_api_version IN NUMBER
185 ,p_commit IN VARCHAR2
186 ,p_init_msg_list IN VARCHAR2
187 ,p_validation_level IN NUMBER
188 ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
189 ,p_ctr_item_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
190 ,p_ctr_property_template_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl
191 ,p_counter_relationships_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
192 ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
193 ,x_return_status OUT NOCOPY VARCHAR2
194 ,x_msg_count OUT NOCOPY NUMBER
195 ,x_msg_data OUT NOCOPY VARCHAR2
196 );
197
198 --|---------------------------------------------------
199 --| procedure name: update_ctr_property_template
200 --| description : procedure used to
201 --| create counter properties
202 --|---------------------------------------------------
203
204 PROCEDURE update_ctr_property_template
205 (
206 p_api_version IN NUMBER
207 ,p_commit IN VARCHAR2
208 ,p_init_msg_list IN VARCHAR2
209 ,p_validation_level IN NUMBER
210 ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
211 ,x_return_status OUT NOCOPY VARCHAR2
212 ,x_msg_count OUT NOCOPY NUMBER
213 ,x_msg_data OUT NOCOPY VARCHAR2
214 );
215
216 --|---------------------------------------------------
217 --| procedure name: update_counter_relationship
218 --| description : procedure used to
219 --| update counter relationship
220 --|---------------------------------------------------
221
222 PROCEDURE update_counter_relationship
223 (
224 p_api_version IN NUMBER
225 ,p_commit IN VARCHAR2
226 ,p_init_msg_list IN VARCHAR2
227 ,p_validation_level IN NUMBER
228 ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
229 ,x_return_status OUT NOCOPY VARCHAR2
230 ,x_msg_count OUT NOCOPY NUMBER
231 ,x_msg_data OUT NOCOPY VARCHAR2
232 );
233
234 --|---------------------------------------------------
235 --| procedure name: update_derived_filters
236 --| description : procedure used to
237 --| update derived filters
238 --|---------------------------------------------------
239
240 PROCEDURE update_derived_filters
241 (
242 p_api_version IN NUMBER
243 ,p_commit IN VARCHAR2
244 ,p_init_msg_list IN VARCHAR2
245 ,p_validation_level IN NUMBER
246 ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
247 ,x_return_status OUT NOCOPY VARCHAR2
248 ,x_msg_count OUT NOCOPY NUMBER
249 ,x_msg_data OUT NOCOPY VARCHAR2
250 );
251
252
253 PROCEDURE Create_Estimation_Method
254 (
255 p_api_version IN NUMBER
256 ,p_init_msg_list IN VARCHAR2
257 ,p_commit IN VARCHAR2
258 ,p_validation_level IN NUMBER
259 ,x_return_status OUT NOCOPY VARCHAR2
260 ,x_msg_count OUT NOCOPY NUMBER
261 ,x_msg_data OUT NOCOPY VARCHAR2
262 ,p_ctr_estimation_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
263 );
264
265 PROCEDURE Update_Estimation_Method
266 (
267 p_api_version IN NUMBER
268 ,p_init_msg_list IN VARCHAR2
269 ,p_commit IN VARCHAR2
270 ,p_validation_level IN NUMBER
271 ,x_return_status OUT NOCOPY VARCHAR2
272 ,x_msg_count OUT NOCOPY NUMBER
273 ,x_msg_data OUT NOCOPY VARCHAR2
274 ,p_ctr_estimation_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
275 );
276
277 PROCEDURE AutoInstantiate_Counters
278 (
279 p_api_version IN NUMBER
280 ,p_init_msg_list IN VARCHAR2
281 ,p_commit IN VARCHAR2
282 ,x_return_status OUT NOCOPY VARCHAR2
283 ,x_msg_count OUT NOCOPY NUMBER
284 ,x_msg_data OUT NOCOPY VARCHAR2
285 ,p_source_object_id_template IN NUMBER
286 ,p_source_object_id_instance IN NUMBER
287 ,x_ctr_id_template IN OUT NOCOPY ctr_template_autoinst_tbl
288 ,x_ctr_id_instance IN OUT NOCOPY counter_autoinstantiate_tbl
289 ,x_ctr_grp_id_template IN OUT NOCOPY NUMBER
290 ,x_ctr_grp_id_instance IN OUT NOCOPY NUMBER
291 ,p_organization_id IN NUMBER
292 );
293
294 PROCEDURE Instantiate_Grp_Counters
295 (
296 p_api_version IN NUMBER
297 ,p_init_msg_list IN VARCHAR2
298 ,p_commit IN VARCHAR2
299 ,x_return_status OUT NOCOPY VARCHAR2
300 ,x_msg_count OUT NOCOPY NUMBER
301 ,x_msg_data OUT NOCOPY VARCHAR2
302 ,p_group_id_template IN NUMBER
303 ,p_source_object_code_instance IN VARCHAR2
304 ,p_source_object_id_instance IN NUMBER
305 ,x_ctr_grp_id_instance OUT NOCOPY NUMBER
306 ,p_maint_org_id IN NUMBER
307 ,p_primary_failure_flag IN VARCHAR2
308 );
309
310 PROCEDURE Instantiate_Counters
311 (
312 p_api_version IN NUMBER
313 ,p_init_msg_list IN VARCHAR2
314 ,p_commit IN VARCHAR2
315 ,x_return_status OUT NOCOPY VARCHAR2
316 ,x_msg_count OUT NOCOPY NUMBER
317 ,x_msg_data OUT NOCOPY VARCHAR2
318 ,p_counter_id_template IN NUMBER
319 ,p_source_object_code_instance IN VARCHAR2
320 ,p_source_object_id_instance IN NUMBER
321 ,x_ctr_id_template OUT NOCOPY NUMBER
322 ,x_ctr_id_instance OUT NOCOPY NUMBER
323 );
324
325 --|---------------------------------------------------
326 --| procedure name: create_item_association
327 --| description : procedure used to
328 --| create item association to
329 --| counter group or counters
330 --|---------------------------------------------------
331
332 PROCEDURE delete_item_association
333 (
334 p_api_version IN NUMBER
335 ,p_commit IN VARCHAR2
336 ,p_init_msg_list IN VARCHAR2
337 ,p_validation_level IN NUMBER
338 ,p_ctr_associations_id IN NUMBER
339 ,x_return_status OUT NOCOPY VARCHAR2
340 ,x_msg_count OUT NOCOPY NUMBER
341 ,x_msg_data OUT NOCOPY VARCHAR2
342 );
343
344 END CSI_COUNTER_TEMPLATE_PUB;