[Home] [Help]
PACKAGE: APPS.OKL_OPTIONS_PUB
Source
1 PACKAGE OKL_OPTIONS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPOPTS.pls 115.4 2002/02/18 20:15:34 pkm ship $ */
3
4
5
6 SUBTYPE optv_rec_type IS okl_options_pvt.optv_rec_type;
7
8 SUBTYPE optv_tbl_type IS okl_options_pvt.optv_tbl_type;
9
10
11
12 SUBTYPE ovev_rec_type IS okl_options_pvt.ovev_rec_type;
13
14 SUBTYPE ovev_tbl_type IS okl_options_pvt.ovev_tbl_type;
15
16
17
18 -- GLOBAL MESSAGE CONSTANTS
19
20 ---------------------------------------------------------------------------------
21
22 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
23
24 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
25
26 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27
28 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
29
30 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
31
32 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
33
34 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
35
36 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
37
38 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
39
40 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
41
42 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
43
44 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45
46 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
47
48 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
49
50 ---------------------------------------------------------------------------------
51
52
53
54 -- GLOBAL EXCEPTION
55
56 ---------------------------------------------------------------------------------
57
58 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
59
60 ---------------------------------------------------------------------------------
61
62
63
64 -- GLOBAL VARIABLES
65
66 ---------------------------------------------------------------------------------
67
68 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OPTIONS_PUB';
69
70 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
71
72 ---------------------------------------------------------------------------------
73
74
75
76 g_optv_rec optv_rec_type;
77
78 g_ovev_rec ovev_rec_type;
79
80
81
82 PROCEDURE create_options(
83
84 p_api_version IN NUMBER
85
86 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
87
88 ,x_return_status OUT NOCOPY VARCHAR2
89
90 ,x_msg_count OUT NOCOPY NUMBER
91
92 ,x_msg_data OUT NOCOPY VARCHAR2
93
94 ,p_optv_rec IN optv_rec_type
95
96 ,p_ovev_tbl IN ovev_tbl_type
97
98 ,x_optv_rec OUT NOCOPY optv_rec_type
99
100 ,x_ovev_tbl OUT NOCOPY ovev_tbl_type
101
102 );
103
104
105
106 --Object type procedure for update
107
108 PROCEDURE update_options(
109
110 p_api_version IN NUMBER
111
112 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
113
114 ,x_return_status OUT NOCOPY VARCHAR2
115
116 ,x_msg_count OUT NOCOPY NUMBER
117
118 ,x_msg_data OUT NOCOPY VARCHAR2
119
120 ,p_optv_rec IN optv_rec_type
121
122 ,p_ovev_tbl IN ovev_tbl_type
123
124 ,x_optv_rec OUT NOCOPY optv_rec_type
125
126 ,x_ovev_tbl OUT NOCOPY ovev_tbl_type
127
128 );
129
130
131
132 --Object type procedure for validate
133
134 PROCEDURE validate_options(
135
136 p_api_version IN NUMBER
137
138 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
139
140 ,x_return_status OUT NOCOPY VARCHAR2
141
142 ,x_msg_count OUT NOCOPY NUMBER
143
144 ,x_msg_data OUT NOCOPY VARCHAR2
145
146 ,p_optv_rec IN optv_rec_type
147
148 ,p_ovev_tbl IN ovev_tbl_type
149
150 );
151
152
153
154
155
156
160 p_api_version IN NUMBER,
157
158 PROCEDURE create_options(
159
161
162 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163
164 x_return_status OUT NOCOPY VARCHAR2,
165
166 x_msg_count OUT NOCOPY NUMBER,
167
168 x_msg_data OUT NOCOPY VARCHAR2,
169
170 p_optv_tbl IN optv_tbl_type,
171
172 x_optv_tbl OUT NOCOPY optv_tbl_type);
173
174
175
176 PROCEDURE create_options(
177
178 p_api_version IN NUMBER,
179
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181
182 x_return_status OUT NOCOPY VARCHAR2,
183
184 x_msg_count OUT NOCOPY NUMBER,
185
186 x_msg_data OUT NOCOPY VARCHAR2,
187
188 p_optv_rec IN optv_rec_type,
189
190 x_optv_rec OUT NOCOPY optv_rec_type);
191
192
193
194 PROCEDURE lock_options(
195
196 p_api_version IN NUMBER,
197
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199
200 x_return_status OUT NOCOPY VARCHAR2,
201
202 x_msg_count OUT NOCOPY NUMBER,
203
204 x_msg_data OUT NOCOPY VARCHAR2,
205
206 p_optv_tbl IN optv_tbl_type);
207
208
209
210 PROCEDURE lock_options(
211
212 p_api_version IN NUMBER,
213
214 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215
216 x_return_status OUT NOCOPY VARCHAR2,
217
218 x_msg_count OUT NOCOPY NUMBER,
219
220 x_msg_data OUT NOCOPY VARCHAR2,
221
222 p_optv_rec IN optv_rec_type);
223
224
225
226 PROCEDURE update_options(
227
228 p_api_version IN NUMBER,
229
230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231
232 x_return_status OUT NOCOPY VARCHAR2,
233
234 x_msg_count OUT NOCOPY NUMBER,
235
236 x_msg_data OUT NOCOPY VARCHAR2,
237
238 p_optv_tbl IN optv_tbl_type,
239
240 x_optv_tbl OUT NOCOPY optv_tbl_type);
241
242
243
244 PROCEDURE update_options(
245
246 p_api_version IN NUMBER,
247
248 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
249
250 x_return_status OUT NOCOPY VARCHAR2,
251
252 x_msg_count OUT NOCOPY NUMBER,
253
254 x_msg_data OUT NOCOPY VARCHAR2,
255
256 p_optv_rec IN optv_rec_type,
257
258 x_optv_rec OUT NOCOPY optv_rec_type);
259
260
261
262 PROCEDURE delete_options(
263
264 p_api_version IN NUMBER,
265
266 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
267
268 x_return_status OUT NOCOPY VARCHAR2,
269
270 x_msg_count OUT NOCOPY NUMBER,
271
272 x_msg_data OUT NOCOPY VARCHAR2,
273
274 p_optv_tbl IN optv_tbl_type);
275
276
277
278 PROCEDURE delete_options(
279
280 p_api_version IN NUMBER,
281
282 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
283
284 x_return_status OUT NOCOPY VARCHAR2,
285
286 x_msg_count OUT NOCOPY NUMBER,
287
288 x_msg_data OUT NOCOPY VARCHAR2,
289
290 p_optv_rec IN optv_rec_type);
291
292
293
294 PROCEDURE validate_options(
295
296 p_api_version IN NUMBER,
297
298 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
299
300 x_return_status OUT NOCOPY VARCHAR2,
301
302 x_msg_count OUT NOCOPY NUMBER,
303
304 x_msg_data OUT NOCOPY VARCHAR2,
305
306 p_optv_tbl IN optv_tbl_type);
307
308
309
310 PROCEDURE validate_options(
311
312 p_api_version IN NUMBER,
313
314 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
315
316 x_return_status OUT NOCOPY VARCHAR2,
317
318 x_msg_count OUT NOCOPY NUMBER,
319
320 x_msg_data OUT NOCOPY VARCHAR2,
321
322 p_optv_rec IN optv_rec_type);
323
324
325
326
327
328 PROCEDURE create_option_values(
329
330 p_api_version IN NUMBER,
331
332 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
333
334 x_return_status OUT NOCOPY VARCHAR2,
335
336 x_msg_count OUT NOCOPY NUMBER,
337
338 x_msg_data OUT NOCOPY VARCHAR2,
339
340 p_ovev_tbl IN ovev_tbl_type,
341
342 x_ovev_tbl OUT NOCOPY ovev_tbl_type);
343
344
345
346 PROCEDURE create_option_values(
347
348 p_api_version IN NUMBER,
349
350 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
351
352 x_return_status OUT NOCOPY VARCHAR2,
353
354 x_msg_count OUT NOCOPY NUMBER,
355
356 x_msg_data OUT NOCOPY VARCHAR2,
357
358 p_ovev_rec IN ovev_rec_type,
359
360 x_ovev_rec OUT NOCOPY ovev_rec_type);
361
362
363
364 PROCEDURE lock_option_values(
365
366 p_api_version IN NUMBER,
367
368 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
369
370 x_return_status OUT NOCOPY VARCHAR2,
371
372 x_msg_count OUT NOCOPY NUMBER,
373
374 x_msg_data OUT NOCOPY VARCHAR2,
375
376 p_ovev_tbl IN ovev_tbl_type);
377
378
379
380 PROCEDURE lock_option_values(
381
382 p_api_version IN NUMBER,
383
384 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
385
386 x_return_status OUT NOCOPY VARCHAR2,
387
388 x_msg_count OUT NOCOPY NUMBER,
389
390 x_msg_data OUT NOCOPY VARCHAR2,
391
392 p_ovev_rec IN ovev_rec_type);
393
394
395
396 PROCEDURE update_option_values(
397
398 p_api_version IN NUMBER,
399
400 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
401
402 x_return_status OUT NOCOPY VARCHAR2,
403
404 x_msg_count OUT NOCOPY NUMBER,
405
406 x_msg_data OUT NOCOPY VARCHAR2,
407
408 p_ovev_tbl IN ovev_tbl_type,
409
410 x_ovev_tbl OUT NOCOPY ovev_tbl_type);
411
412
413
414 PROCEDURE update_option_values(
415
416 p_api_version IN NUMBER,
417
418 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
419
420 x_return_status OUT NOCOPY VARCHAR2,
421
422 x_msg_count OUT NOCOPY NUMBER,
423
424 x_msg_data OUT NOCOPY VARCHAR2,
425
426 p_ovev_rec IN ovev_rec_type,
427
428 x_ovev_rec OUT NOCOPY ovev_rec_type);
429
430
431
432 PROCEDURE delete_option_values(
433
434 p_api_version IN NUMBER,
435
436 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
437
438 x_return_status OUT NOCOPY VARCHAR2,
439
440 x_msg_count OUT NOCOPY NUMBER,
441
442 x_msg_data OUT NOCOPY VARCHAR2,
443
444 p_ovev_tbl IN ovev_tbl_type);
445
446
447
448 PROCEDURE delete_option_values(
449
450 p_api_version IN NUMBER,
451
452 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
453
454 x_return_status OUT NOCOPY VARCHAR2,
455
456 x_msg_count OUT NOCOPY NUMBER,
457
458 x_msg_data OUT NOCOPY VARCHAR2,
459
460 p_ovev_rec IN ovev_rec_type);
461
462
463
464 PROCEDURE validate_option_values(
465
466 p_api_version IN NUMBER,
467
468 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
469
470 x_return_status OUT NOCOPY VARCHAR2,
471
472 x_msg_count OUT NOCOPY NUMBER,
473
474 x_msg_data OUT NOCOPY VARCHAR2,
475
476 p_ovev_tbl IN ovev_tbl_type);
477
478
479
480 PROCEDURE validate_option_values(
481
482 p_api_version IN NUMBER,
483
484 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
485
486 x_return_status OUT NOCOPY VARCHAR2,
487
488 x_msg_count OUT NOCOPY NUMBER,
489
490 x_msg_data OUT NOCOPY VARCHAR2,
491
492 p_ovev_rec IN ovev_rec_type);
493
494
495
496 END OKL_OPTIONS_PUB;
497