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