[Home] [Help]
PACKAGE: APPS.AR_CHARGE_SCHEDULE_PKG
Source
1 PACKAGE ar_charge_schedule_pkg AS
2 /* $Header: ARSCAMTS.pls 120.2 2006/03/30 19:42:21 hyu noship $ */
3
4 ---------------
5 --Table Handler
6 ---------------
7 PROCEDURE Insert_schedule_Row
8 (P_SCHEDULE_ID IN NUMBER,
9 P_SCHEDULE_NAME IN VARCHAR2,
10 P_SCHEDULE_DESCRIPTION IN VARCHAR2,
11 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
12 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
13 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
14 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
15 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
16 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
17 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
18 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
19 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
20 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
21 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
22 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
23 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
24 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
25 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
26 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
27 P_OBJECT_VERSION_NUMBER IN NUMBER,
28 x_return_status IN OUT NOCOPY VARCHAR2);
29
30 PROCEDURE Update_schedule_Row
31 (P_SCHEDULE_ID IN NUMBER,
32 P_SCHEDULE_DESCRIPTION IN VARCHAR2,
33 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
34 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
35 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
36 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
37 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
38 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
39 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
40 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
41 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
42 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
43 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
44 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
45 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
46 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
47 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
48 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
49 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
50 x_return_status IN OUT NOCOPY VARCHAR2);
51
52 PROCEDURE Insert_Head_Row
53 (P_SCHEDULE_HEADER_ID IN NUMBER,
54 P_SCHEDULE_ID IN NUMBER,
55 P_SCHEDULE_HEADER_TYPE IN VARCHAR2,
56 P_AGING_BUCKET_ID IN NUMBER,
57 P_START_DATE IN DATE,
58 P_END_DATE IN DATE,
59 P_STATUS IN VARCHAR2,
60 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
61 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
62 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
63 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
64 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
65 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
66 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
67 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
68 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
69 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
70 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
71 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
72 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
73 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
74 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
75 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
76 P_OBJECT_VERSION_NUMBER IN NUMBER,
77 x_return_status IN OUT NOCOPY VARCHAR2);
78
79 PROCEDURE Update_Head_Row
80 (P_SCHEDULE_HEADER_ID IN NUMBER,
81 P_END_DATE IN DATE,
82 P_STATUS IN VARCHAR2,
83 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
84 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
85 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
86 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
87 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
88 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
89 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
90 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
91 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
92 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
93 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
94 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
95 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
96 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
97 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
98 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
99 x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
100 x_return_status IN OUT NOCOPY VARCHAR2);
101
102 PROCEDURE Insert_Line_Row
103 (P_SCHEDULE_LINE_ID IN NUMBER,
104 P_SCHEDULE_HEADER_ID IN NUMBER,
105 P_SCHEDULE_ID IN NUMBER,
106 P_AGING_BUCKET_ID IN NUMBER,
107 P_AGING_BUCKET_LINE_ID IN NUMBER,
108 P_AMOUNT IN NUMBER,
109 P_RATE IN NUMBER,
110 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
111 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
112 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
113 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
114 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
115 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
116 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
117 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
118 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
119 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
120 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
121 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
122 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
123 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
124 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
125 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
126 P_OBJECT_VERSION_NUMBER IN NUMBER,
127 x_return_status IN OUT NOCOPY VARCHAR2);
128
129
130 PROCEDURE update_Line_Row
131 (P_SCHEDULE_LINE_ID IN NUMBER,
132 P_AMOUNT IN NUMBER,
133 P_RATE IN NUMBER,
134 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
135 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
136 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
137 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
138 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
139 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
140 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
141 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
142 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
143 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
144 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
145 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
146 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
147 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
148 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
149 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
150 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
151 x_return_status IN OUT NOCOPY VARCHAR2);
152
153 -----------------
154 -- Validation API
155 -----------------
156 FUNCTION validate_lookup
157 (p_type IN VARCHAR2,
158 p_code IN VARCHAR2)
159 RETURN BOOLEAN;
160
161 FUNCTION compare
162 (date1 DATE,
163 date2 DATE)
164 RETURN NUMBER;
165
166 PROCEDURE validate_schedule
167 (P_SCHEDULE_NAME IN VARCHAR2,
168 P_SCHEDULE_DESCRIPTION IN VARCHAR2,
169 P_MODE IN VARCHAR2,
170 x_return_status IN OUT NOCOPY VARCHAR2);
171
172 PROCEDURE validate_schedule_header
173 (P_SCHEDULE_HEADER_ID IN NUMBER,
174 P_SCHEDULE_ID IN NUMBER,
175 P_SCHEDULE_HEADER_TYPE IN VARCHAR2,
176 P_AGING_BUCKET_ID IN NUMBER,
177 P_START_DATE IN DATE,
178 P_END_DATE IN DATE,
179 P_STATUS IN VARCHAR2,
180 P_OLD_STATUS IN VARCHAR2,
181 p_mode IN VARCHAR2,
182 x_return_status IN OUT NOCOPY VARCHAR2);
183
184 PROCEDURE validate_schedule_line
185 (P_SCHEDULE_LINE_ID IN NUMBER,
186 P_SCHEDULE_HEADER_ID IN NUMBER,
187 P_SCHEDULE_ID IN NUMBER,
188 P_AGING_BUCKET_ID IN NUMBER,
189 P_AGING_BUCKET_LINE_ID IN NUMBER,
190 P_AMOUNT IN NUMBER,
191 P_RATE IN NUMBER,
192 P_MODE IN VARCHAR2,
193 x_return_status IN OUT NOCOPY VARCHAR2);
194
195
196
197 --------------
198 -- Public APIS
199 --------------
200 PROCEDURE create_schedule
201 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
202 P_SCHEDULE_NAME IN VARCHAR2,
203 P_SCHEDULE_DESCRIPTION IN VARCHAR2,
204 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
205 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
206 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
207 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
208 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
209 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
210 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
211 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
212 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
213 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
214 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
215 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
216 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
217 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
218 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
219 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
220 P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT 1,
221 x_schedule_id OUT NOCOPY NUMBER,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2);
225
226 PROCEDURE update_schedule
227 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
228 P_SCHEDULE_ID IN NUMBER,
229 P_SCHEDULE_DESCRIPTION IN VARCHAR2,
230 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
231 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
232 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
233 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
234 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
235 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
236 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
237 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
238 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
239 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
240 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
241 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
242 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
243 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
244 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
245 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
246 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2);
250
251 PROCEDURE create_schedule_header
252 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
253 P_SCHEDULE_ID IN NUMBER,
254 P_SCHEDULE_HEADER_TYPE IN VARCHAR2,
255 P_AGING_BUCKET_ID IN NUMBER,
256 P_START_DATE IN DATE,
257 P_END_DATE IN DATE,
258 P_STATUS IN VARCHAR2,
259 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
260 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
261 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
262 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
263 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
264 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
265 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
266 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
267 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
268 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
269 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
270 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
271 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
272 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
273 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
274 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
275 P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT 1,
276 x_schedule_header_id OUT NOCOPY NUMBER,
277 x_return_status OUT NOCOPY VARCHAR2,
278 x_msg_count OUT NOCOPY NUMBER,
279 x_msg_data OUT NOCOPY VARCHAR2);
280
281 PROCEDURE Update_schedule_header
282 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
283 P_SCHEDULE_HEADER_ID IN NUMBER,
284 P_END_DATE IN DATE,
285 P_STATUS IN VARCHAR2,
286 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
287 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
288 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
289 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
290 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
291 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
292 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
293 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
294 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
295 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
296 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
297 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
298 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
299 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
300 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
301 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
302 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2);
306
307 PROCEDURE create_schedule_line
308 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
309 P_SCHEDULE_HEADER_ID IN NUMBER,
310 P_SCHEDULE_ID IN NUMBER,
311 P_AGING_BUCKET_ID IN NUMBER,
312 P_AGING_BUCKET_LINE_ID IN NUMBER,
313 P_AMOUNT IN NUMBER,
314 P_RATE IN NUMBER,
315 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
316 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
320 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
317 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
318 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
319 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
321 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
322 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
323 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
324 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
325 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
326 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
327 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
328 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
329 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
330 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
331 P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT 1,
332 X_SCHEDULE_LINE_ID OUT NOCOPY NUMBER,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2);
336
337 PROCEDURE Update_schedule_line
338 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
339 P_SCHEDULE_line_ID IN NUMBER,
340 P_amount IN NUMBER,
341 P_rate IN NUMBER,
342 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
343 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
344 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
345 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
346 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
347 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
348 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
349 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
350 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
351 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
352 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
353 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
354 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
355 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
356 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
357 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
358 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361 x_msg_data OUT NOCOPY VARCHAR2);
362
363 END;