[Home] [Help]
PACKAGE: APPS.OKC_PRICE_ADJUSTMENT_PUB
Source
1 package okc_price_adjustment_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPPATS.pls 120.0 2005/05/25 18:34:31 appldev noship $*/
3 -- Sub types for price adjustments
4 subtype patv_rec_type is okc_price_adjustment_pvt.patv_rec_type;
5 subtype patv_tbl_type is okc_price_adjustment_pvt.patv_tbl_type;
6
7 -- Sub types for price adjustment assoc
8 subtype pacv_rec_type is okc_price_adjustment_pvt.pacv_rec_type;
9 subtype pacv_tbl_type is okc_price_adjustment_pvt.pacv_tbl_type;
10
11 -- Sub types for price adjustment attributes
12 subtype pavv_rec_type is okc_price_adjustment_pvt.pavv_rec_type;
13 subtype pavv_tbl_type is okc_price_adjustment_pvt.pavv_tbl_type;
14
15 -- Sub types for price attribute value
16 subtype paav_rec_type is okc_price_adjustment_pvt.paav_rec_type;
17 subtype paav_tbl_type is okc_price_adjustment_pvt.paav_tbl_type;
18
19
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
22 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
23 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
24 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_GROUP_PUB';
25 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
26 PROCEDURE create_price_adjustment(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_patv_rec IN patv_rec_type,
33 x_patv_rec OUT NOCOPY patv_rec_type);
34
35 PROCEDURE create_price_adjustment(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_patv_tbl IN patv_tbl_type,
42 x_patv_tbl OUT NOCOPY patv_tbl_type);
43
44 PROCEDURE update_price_adjustment(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_patv_rec IN patv_rec_type,
51 x_patv_rec OUT NOCOPY patv_rec_type);
52
53 PROCEDURE update_price_adjustment(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_patv_tbl IN patv_tbl_type,
60 x_patv_tbl OUT NOCOPY patv_tbl_type);
61
62 PROCEDURE delete_price_adjustment(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_patv_rec IN patv_rec_type);
69
70 PROCEDURE delete_price_adjustment(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_patv_tbl IN patv_tbl_type);
77
78 PROCEDURE validate_price_adjustment(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_patv_rec IN patv_rec_type);
85
86 PROCEDURE validate_price_adjustment(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_patv_tbl IN patv_tbl_type);
93
94 PROCEDURE lock_price_adjustment(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_patv_rec IN patv_rec_type);
101
102 PROCEDURE lock_price_adjustment(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_patv_tbl IN patv_tbl_type);
109
110
111
112 PROCEDURE create_price_adj_assoc(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_pacv_rec IN pacv_rec_type,
119 x_pacv_rec OUT NOCOPY pacv_rec_type);
120
121 PROCEDURE create_price_adj_assoc(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_pacv_tbl IN pacv_tbl_type,
128 x_pacv_tbl OUT NOCOPY pacv_tbl_type);
129
130 PROCEDURE update_price_adj_assoc(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_pacv_rec IN pacv_rec_type,
137 x_pacv_rec OUT NOCOPY pacv_rec_type);
138
139 PROCEDURE update_price_adj_assoc(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_pacv_tbl IN pacv_tbl_type,
146 x_pacv_tbl OUT NOCOPY pacv_tbl_type);
147
148 PROCEDURE delete_price_adj_assoc(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_pacv_rec IN pacv_rec_type);
155
156 PROCEDURE delete_price_adj_assoc(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_pacv_tbl IN pacv_tbl_type );
163
164 PROCEDURE validate_price_adj_assoc(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_pacv_rec IN pacv_rec_type);
171
172 PROCEDURE validate_price_adj_assoc(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_pacv_tbl IN pacv_tbl_type);
179
180 PROCEDURE lock_price_adj_assoc(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_pacv_rec IN pacv_rec_type );
187
188 PROCEDURE lock_price_adj_assoc(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_pacv_tbl IN pacv_tbl_type );
195
196 PROCEDURE create_price_att_value(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_pavv_rec IN pavv_rec_type,
203 x_pavv_rec OUT NOCOPY pavv_rec_type);
204
205 PROCEDURE create_price_att_value(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_pavv_tbl IN pavv_tbl_type,
212 x_pavv_tbl OUT NOCOPY pavv_tbl_type);
213
214
215 PROCEDURE update_price_att_value(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_pavv_rec IN pavv_rec_type,
222 x_pavv_rec OUT NOCOPY pavv_rec_type);
223
224 PROCEDURE update_price_att_value(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_pavv_tbl IN pavv_tbl_type,
231 x_pavv_tbl OUT NOCOPY pavv_tbl_type);
232
233 PROCEDURE delete_price_att_value(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_pavv_rec IN pavv_rec_type);
240
241 PROCEDURE delete_price_att_value(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_pavv_tbl IN pavv_tbl_type );
248
249 PROCEDURE validate_price_att_value(
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_pavv_rec IN pavv_rec_type);
256
257 PROCEDURE validate_price_att_value(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_pavv_tbl IN pavv_tbl_type );
264
265 PROCEDURE lock_price_att_value(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_pavv_rec IN pavv_rec_type );
272
273 PROCEDURE lock_price_att_value(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_pavv_tbl IN pavv_tbl_type);
280
281 PROCEDURE create_price_adj_attrib(
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
284 x_return_status OUT NOCOPY VARCHAR2,
285 x_msg_count OUT NOCOPY NUMBER,
286 x_msg_data OUT NOCOPY VARCHAR2,
287 p_paav_rec IN paav_rec_type,
288 x_paav_rec OUT NOCOPY paav_rec_type);
289
290 PROCEDURE create_price_adj_attrib(
291 p_api_version IN NUMBER,
292 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER,
295 x_msg_data OUT NOCOPY VARCHAR2,
296 p_paav_tbl IN paav_tbl_type,
297 x_paav_tbl OUT NOCOPY paav_tbl_type);
298
299 PROCEDURE update_price_adj_attrib(
300 p_api_version IN NUMBER,
301 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2,
305 p_paav_rec IN paav_rec_type,
306 x_paav_rec OUT NOCOPY paav_rec_type);
307
308 PROCEDURE update_price_adj_attrib(
309 p_api_version IN NUMBER,
310 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_paav_tbl IN paav_tbl_type,
315 x_paav_tbl OUT NOCOPY paav_tbl_type);
316
317 PROCEDURE delete_price_adj_attrib(
318 p_api_version IN NUMBER,
319 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
320 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2,
323 p_paav_rec IN paav_rec_type);
324
325 PROCEDURE delete_price_adj_attrib(
326 p_api_version IN NUMBER,
327 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
328 x_return_status OUT NOCOPY VARCHAR2,
329 x_msg_count OUT NOCOPY NUMBER,
330 x_msg_data OUT NOCOPY VARCHAR2,
331 p_paav_tbl IN paav_tbl_type);
332
333 PROCEDURE validate_price_adj_attrib(
334 p_api_version IN NUMBER,
335 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
336 x_return_status OUT NOCOPY VARCHAR2,
337 x_msg_count OUT NOCOPY NUMBER,
338 x_msg_data OUT NOCOPY VARCHAR2,
339 p_paav_rec IN paav_rec_type);
340
341 PROCEDURE validate_price_adj_attrib(
342 p_api_version IN NUMBER,
343 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
344 x_return_status OUT NOCOPY VARCHAR2,
345 x_msg_count OUT NOCOPY NUMBER,
346 x_msg_data OUT NOCOPY VARCHAR2,
347 p_paav_tbl IN paav_tbl_type );
348
349 PROCEDURE lock_price_adj_attrib(
350 p_api_version IN NUMBER,
351 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
352 x_return_status OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2,
355 p_paav_rec IN paav_rec_type);
356
357 PROCEDURE lock_price_adj_attrib(
358 p_api_version IN NUMBER,
359 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_msg_count OUT NOCOPY NUMBER,
362 x_msg_data OUT NOCOPY VARCHAR2,
363 p_paav_tbl IN paav_tbl_type);
364
365
366 END okc_price_adjustment_pub;