1 PACKAGE CSI_COUNTER_PVT AUTHID CURRENT_USER AS
2 /* $Header: csivctis.pls 120.3.12020000.1 2012/06/28 13:00:57 appldev ship $ */
3
4
5 --|---------------------------------------------------
6 --| procedure name: create_counter
7 --| description : procedure used to
8 --| create counter instance
9 --|---------------------------------------------------
10
11 PROCEDURE create_counter
12 (
13 p_api_version IN NUMBER
14 ,p_init_msg_list IN VARCHAR2
15 ,p_commit IN VARCHAR2
16 ,p_validation_level IN VARCHAR2
17 ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_msg_count OUT NOCOPY NUMBER
20 ,x_msg_data OUT NOCOPY VARCHAR2
21 ,x_ctr_id OUT NOCOPY NUMBER
22 );
23
24
25 --|---------------------------------------------------
26 --| procedure name: create_ctr_property
27 --| description : procedure used to
28 --| create counter properties
29 --|---------------------------------------------------
30
31 PROCEDURE create_ctr_property
32 (
33 p_api_version IN NUMBER
34 ,p_commit IN VARCHAR2
35 ,p_init_msg_list IN VARCHAR2
36 ,p_validation_level IN NUMBER
37 ,p_ctr_properties_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_Properties_Rec
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2
41 ,x_ctr_property_id OUT NOCOPY NUMBER
42 );
43
44 --|---------------------------------------------------
45 --| procedure name: create_ctr_associations
46 --| description : procedure used to
47 --| create counter associations
48 --|---------------------------------------------------
49
50 PROCEDURE create_ctr_associations
51 (
52 p_api_version IN NUMBER
53 ,p_commit IN VARCHAR2
54 ,p_init_msg_list IN VARCHAR2
55 ,p_validation_level IN NUMBER
56 ,P_counter_associations_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 ,x_instance_association_id OUT NOCOPY NUMBER
61 );
62
63 --|---------------------------------------------------
64 --| procedure name: create_reading_lock
65 --| description : procedure used to
66 --| create reading lock on a counter
67 --|---------------------------------------------------
68
69 PROCEDURE create_reading_lock
70 (
71 p_api_version IN NUMBER
72 ,p_commit IN VARCHAR2
73 ,p_init_msg_list IN VARCHAR2
74 ,p_validation_level IN NUMBER
75 ,p_ctr_reading_lock_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 ,x_reading_lock_id OUT NOCOPY NUMBER
80 );
81
82 --|---------------------------------------------------
83 --| procedure name: create_daily_usage
84 --| description : procedure used to
85 --| create daily usage
86 --|---------------------------------------------------
87
88 PROCEDURE create_daily_usage
89 (
90 p_api_version IN NUMBER
91 ,p_commit IN VARCHAR2
92 ,p_init_msg_list IN VARCHAR2
93 ,p_validation_level IN NUMBER
94 ,p_ctr_usage_forecast_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
95 ,x_return_status OUT NOCOPY VARCHAR2
96 ,x_msg_count OUT NOCOPY NUMBER
97 ,x_msg_data OUT NOCOPY VARCHAR2
98 ,x_instance_forecast_id OUT NOCOPY NUMBER
99 );
100
101 --|---------------------------------------------------
102 --| procedure name: update_counter
103 --| description : procedure used to
104 --| create counter instance
105 --|---------------------------------------------------
106
107 PROCEDURE update_counter
108 (
109 p_api_version IN NUMBER
110 ,p_init_msg_list IN VARCHAR2
111 ,p_commit IN VARCHAR2
112 ,p_validation_level IN VARCHAR2
113 ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
114 ,x_return_status OUT NOCOPY VARCHAR2
115 ,x_msg_count OUT NOCOPY NUMBER
116 ,x_msg_data OUT NOCOPY VARCHAR2
117 );
118
119 --|---------------------------------------------------
120 --| procedure name: update_ctr_property
121 --| description : procedure used to
122 --| update counter properties
123 --|---------------------------------------------------
124
125 PROCEDURE update_ctr_property
126 (
127 p_api_version IN NUMBER
128 ,p_commit IN VARCHAR2
129 ,p_init_msg_list IN VARCHAR2
130 ,p_validation_level IN NUMBER
131 ,P_ctr_properties_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec
132 ,x_return_status OUT NOCOPY VARCHAR2
133 ,x_msg_count OUT NOCOPY NUMBER
134 ,x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 --|---------------------------------------------------
138 --| procedure name: update_ctr_associations
139 --| description : procedure used to
140 --| update counter associations
141 --|---------------------------------------------------
142
143 PROCEDURE update_ctr_associations
144 (
145 p_api_version IN NUMBER
146 ,p_commit IN VARCHAR2
147 ,p_init_msg_list IN VARCHAR2
148 ,p_validation_level IN NUMBER
149 ,P_counter_associations_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec
150 ,x_return_status OUT NOCOPY VARCHAR2
151 ,x_msg_count OUT NOCOPY NUMBER
152 ,x_msg_data OUT NOCOPY VARCHAR2
153 );
154
155 --|---------------------------------------------------
156 --| procedure name: update_ctr_val_max_seq_no
157 --| description : procedure used to update
158 --| the ctr_val_max_seq_no for
159 --| a particular counter
160 --|---------------------------------------------------
161
162 PROCEDURE update_ctr_val_max_seq_no
163 (
164 p_api_version IN NUMBER
165 ,p_commit IN VARCHAR2
166 ,p_init_msg_list IN VARCHAR2
167 ,p_validation_level IN NUMBER
168 ,p_counter_id IN NUMBER
169 ,px_ctr_val_max_seq_no IN OUT NOCOPY NUMBER
170 ,x_return_status OUT NOCOPY VARCHAR2
171 ,x_msg_count OUT NOCOPY NUMBER
172 ,x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 END CSI_COUNTER_PVT;
[Home] [Help]