1 package csi_counter_readings_pub_w as
2 /* $Header: csipcrws.pls 120.10 2008/03/26 09:10:21 ngoutam ship $ */
3 procedure capture_counter_reading(p_api_version NUMBER
4 , p_commit VARCHAR2
5 , p_init_msg_list VARCHAR2
6 , p_validation_level NUMBER
7 , p4_a0 in out nocopy JTF_NUMBER_TABLE
8 , p4_a1 in out nocopy JTF_DATE_TABLE
9 , p4_a2 in out nocopy JTF_DATE_TABLE
10 , p4_a3 in out nocopy JTF_NUMBER_TABLE
11 , p4_a4 in out nocopy JTF_NUMBER_TABLE
12 , p4_a5 in out nocopy JTF_NUMBER_TABLE
13 , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
14 , p4_a7 in out nocopy JTF_NUMBER_TABLE
15 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
16 , p4_a9 in out nocopy JTF_NUMBER_TABLE
17 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
18 , p4_a11 in out nocopy JTF_NUMBER_TABLE
19 , p4_a12 in out nocopy JTF_NUMBER_TABLE
20 , p4_a13 in out nocopy JTF_NUMBER_TABLE
21 , p4_a14 in out nocopy JTF_NUMBER_TABLE
22 , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100
23 , p4_a16 in out nocopy JTF_NUMBER_TABLE
24 , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_100
25 , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_100
26 , p4_a19 in out nocopy JTF_NUMBER_TABLE
27 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
28 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
29 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
30 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
31 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_200
32 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
33 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
34 , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
35 , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
36 , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
37 , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
38 , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
39 , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_200
40 , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_200
41 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_200
42 , p4_a35 in out nocopy JTF_VARCHAR2_TABLE_200
43 , p4_a36 in out nocopy JTF_NUMBER_TABLE
44 , p4_a37 in out nocopy JTF_VARCHAR2_TABLE_100
45 , p4_a38 in out nocopy JTF_DATE_TABLE
46 , p4_a39 in out nocopy JTF_NUMBER_TABLE
47 , p5_a0 in out nocopy JTF_NUMBER_TABLE
48 , p5_a1 in out nocopy JTF_NUMBER_TABLE
49 , p5_a2 in out nocopy JTF_DATE_TABLE
50 , p5_a3 in out nocopy JTF_NUMBER_TABLE
51 , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
52 , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_300
53 , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
54 , p5_a7 in out nocopy JTF_NUMBER_TABLE
55 , p5_a8 in out nocopy JTF_NUMBER_TABLE
56 , p5_a9 in out nocopy JTF_DATE_TABLE
57 , p5_a10 in out nocopy JTF_NUMBER_TABLE
58 , p5_a11 in out nocopy JTF_DATE_TABLE
59 , p5_a12 in out nocopy JTF_NUMBER_TABLE
60 , p5_a13 in out nocopy JTF_NUMBER_TABLE
61 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
62 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
63 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
64 , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
65 , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
66 , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
67 , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
68 , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
69 , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
70 , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
71 , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_200
72 , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_200
73 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_200
74 , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_200
75 , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_200
76 , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_200
77 , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_200
78 , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_200
79 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_200
80 , p5_a33 in out nocopy JTF_VARCHAR2_TABLE_200
81 , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_200
82 , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_200
83 , p5_a36 in out nocopy JTF_VARCHAR2_TABLE_200
84 , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_200
85 , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_200
86 , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_200
87 , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200
88 , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_200
89 , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_200
90 , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_200
91 , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_100
92 , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_100
93 , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_2000
94 , p5_a47 in out nocopy JTF_NUMBER_TABLE
95 , p5_a48 in out nocopy JTF_NUMBER_TABLE
96 , p5_a49 in out nocopy JTF_VARCHAR2_TABLE_100
97 , p5_a50 in out nocopy JTF_VARCHAR2_TABLE_100
98 , p5_a51 in out nocopy JTF_NUMBER_TABLE
99 , p5_a52 in out nocopy JTF_NUMBER_TABLE
100 , p5_a53 in out nocopy JTF_NUMBER_TABLE
101 , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_100
102 , p5_a55 in out nocopy JTF_VARCHAR2_TABLE_100
103 , p5_a56 in out nocopy JTF_NUMBER_TABLE
104 , p5_a57 in out nocopy JTF_NUMBER_TABLE
105 , p5_a58 in out nocopy JTF_NUMBER_TABLE
106 , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
107 , p6_a0 in out nocopy JTF_NUMBER_TABLE
108 , p6_a1 in out nocopy JTF_NUMBER_TABLE
109 , p6_a2 in out nocopy JTF_NUMBER_TABLE
110 , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_300
111 , p6_a4 in out nocopy JTF_DATE_TABLE
112 , p6_a5 in out nocopy JTF_NUMBER_TABLE
113 , p6_a6 in out nocopy JTF_DATE_TABLE
114 , p6_a7 in out nocopy JTF_NUMBER_TABLE
115 , p6_a8 in out nocopy JTF_DATE_TABLE
116 , p6_a9 in out nocopy JTF_NUMBER_TABLE
117 , p6_a10 in out nocopy JTF_NUMBER_TABLE
118 , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
119 , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
120 , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
121 , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
122 , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_200
123 , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_200
124 , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_200
125 , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_200
126 , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
127 , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
128 , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
129 , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
130 , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
131 , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
132 , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_200
133 , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_100
134 , p6_a27 in out nocopy JTF_VARCHAR2_TABLE_100
135 , p6_a28 in out nocopy JTF_NUMBER_TABLE
136 , p6_a29 in out nocopy JTF_NUMBER_TABLE
137 , x_return_status out nocopy VARCHAR2
138 , x_msg_count out nocopy NUMBER
139 , x_msg_data out nocopy VARCHAR2
140 );
141 procedure update_counter_reading(p_api_version NUMBER
142 , p_commit VARCHAR2
143 , p_init_msg_list VARCHAR2
144 , p_validation_level NUMBER
145 , p4_a0 in out nocopy JTF_NUMBER_TABLE
146 , p4_a1 in out nocopy JTF_NUMBER_TABLE
147 , p4_a2 in out nocopy JTF_DATE_TABLE
148 , p4_a3 in out nocopy JTF_NUMBER_TABLE
149 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
150 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_300
151 , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
152 , p4_a7 in out nocopy JTF_NUMBER_TABLE
153 , p4_a8 in out nocopy JTF_NUMBER_TABLE
154 , p4_a9 in out nocopy JTF_DATE_TABLE
155 , p4_a10 in out nocopy JTF_NUMBER_TABLE
156 , p4_a11 in out nocopy JTF_DATE_TABLE
157 , p4_a12 in out nocopy JTF_NUMBER_TABLE
158 , p4_a13 in out nocopy JTF_NUMBER_TABLE
159 , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_200
160 , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_200
161 , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_200
162 , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_200
163 , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_200
164 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_200
165 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_200
166 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
167 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
168 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
169 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_200
170 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
171 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
172 , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
173 , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
174 , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
175 , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
176 , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
177 , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_200
178 , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_200
179 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_200
180 , p4_a35 in out nocopy JTF_VARCHAR2_TABLE_200
181 , p4_a36 in out nocopy JTF_VARCHAR2_TABLE_200
182 , p4_a37 in out nocopy JTF_VARCHAR2_TABLE_200
183 , p4_a38 in out nocopy JTF_VARCHAR2_TABLE_200
184 , p4_a39 in out nocopy JTF_VARCHAR2_TABLE_200
185 , p4_a40 in out nocopy JTF_VARCHAR2_TABLE_200
186 , p4_a41 in out nocopy JTF_VARCHAR2_TABLE_200
187 , p4_a42 in out nocopy JTF_VARCHAR2_TABLE_200
188 , p4_a43 in out nocopy JTF_VARCHAR2_TABLE_200
189 , p4_a44 in out nocopy JTF_VARCHAR2_TABLE_100
190 , p4_a45 in out nocopy JTF_VARCHAR2_TABLE_100
191 , p4_a46 in out nocopy JTF_VARCHAR2_TABLE_2000
192 , p4_a47 in out nocopy JTF_NUMBER_TABLE
193 , p4_a48 in out nocopy JTF_NUMBER_TABLE
194 , p4_a49 in out nocopy JTF_VARCHAR2_TABLE_100
195 , p4_a50 in out nocopy JTF_VARCHAR2_TABLE_100
196 , p4_a51 in out nocopy JTF_NUMBER_TABLE
197 , p4_a52 in out nocopy JTF_NUMBER_TABLE
198 , p4_a53 in out nocopy JTF_NUMBER_TABLE
199 , p4_a54 in out nocopy JTF_VARCHAR2_TABLE_100
200 , p4_a55 in out nocopy JTF_VARCHAR2_TABLE_100
201 , p4_a56 in out nocopy JTF_NUMBER_TABLE
202 , p4_a57 in out nocopy JTF_NUMBER_TABLE
203 , p4_a58 in out nocopy JTF_NUMBER_TABLE
204 , p4_a59 in out nocopy JTF_VARCHAR2_TABLE_100
205 , x_return_status out nocopy VARCHAR2
206 , x_msg_count out nocopy NUMBER
207 , x_msg_data out nocopy VARCHAR2
208 );
209 end csi_counter_readings_pub_w;
[Home] [Help]