[Home] [Help]
PACKAGE: APPS.OKL_STREAMS_PUB
Source
1 PACKAGE Okl_Streams_Pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPSTMS.pls 120.1 2005/05/30 12:27:39 kthiruva noship $ */
3
4
5
6 SUBTYPE stmv_rec_type IS Okl_Streams_Pvt.stmv_rec_type;
7
8 SUBTYPE stmv_tbl_type IS Okl_Streams_Pvt.stmv_tbl_type;
9
10
11
12 SUBTYPE selv_rec_type IS Okl_Streams_Pvt.selv_rec_type;
13
14 SUBTYPE selv_tbl_type IS Okl_Streams_Pvt.selv_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_STREAMS_PUB';
69
70 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
71
72 ---------------------------------------------------------------------------------
73
74
75
76 g_stmv_rec stmv_rec_type;
77
78 g_selv_rec selv_rec_type;
79
80
81
82 PROCEDURE create_streams(
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_stmv_rec IN stmv_rec_type
95
96 ,p_selv_tbl IN selv_tbl_type
97
98 ,x_stmv_rec OUT NOCOPY stmv_rec_type
99
100 ,x_selv_tbl OUT NOCOPY selv_tbl_type
101
102 );
103
104
105 --Object type procedure for insert(master-table,detail-table)
106 PROCEDURE create_streams(
107 p_api_version IN NUMBER
108
109 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
110
111 ,x_return_status OUT NOCOPY VARCHAR2
112
113 ,x_msg_count OUT NOCOPY NUMBER
114
115 ,x_msg_data OUT NOCOPY VARCHAR2
116
117 ,p_stmv_tbl IN stmv_tbl_type
118
119 ,p_selv_tbl IN selv_tbl_type
120
121 ,x_stmv_tbl OUT NOCOPY stmv_tbl_type
122
123 ,x_selv_tbl OUT NOCOPY selv_tbl_type
124 );
125
126
127 --Added by kthiruva on 12-May-2005 for Streams Performance
128 --Bug 4346646-Start of Changes
129 PROCEDURE create_streams_perf(
130 p_api_version IN NUMBER
131
132 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
133
134 ,x_return_status OUT NOCOPY VARCHAR2
135
136 ,x_msg_count OUT NOCOPY NUMBER
137
138 ,x_msg_data OUT NOCOPY VARCHAR2
139
140 ,p_stmv_tbl IN stmv_tbl_type
141
142 ,p_selv_tbl IN selv_tbl_type
143
144 ,x_stmv_tbl OUT NOCOPY stmv_tbl_type
145
146 ,x_selv_tbl OUT NOCOPY selv_tbl_type
147 );
148 --Bug 4346646-End of Changes
149
150 --Object type procedure for update
151
152 PROCEDURE update_streams(
153
154 p_api_version IN NUMBER
155
156 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
157
158 ,x_return_status OUT NOCOPY VARCHAR2
159
160 ,x_msg_count OUT NOCOPY NUMBER
161
162 ,x_msg_data OUT NOCOPY VARCHAR2
163
164 ,p_stmv_rec IN stmv_rec_type
165
166 ,p_selv_tbl IN selv_tbl_type
167
168 ,x_stmv_rec OUT NOCOPY stmv_rec_type
169
170 ,x_selv_tbl OUT NOCOPY selv_tbl_type
171
172 );
173
174
175
176 --Object type procedure for validate
177
178 PROCEDURE validate_streams(
179
180 p_api_version IN NUMBER
181
182 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
183
184 ,x_return_status OUT NOCOPY VARCHAR2
185
186 ,x_msg_count OUT NOCOPY NUMBER
187
188 ,x_msg_data OUT NOCOPY VARCHAR2
189
190 ,p_stmv_rec IN stmv_rec_type
191
192 ,p_selv_tbl IN selv_tbl_type
193
194 );
195
196
197
198
199
200
201
202 PROCEDURE create_streams(
203
204 p_api_version IN NUMBER,
205
206 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207
208 x_return_status OUT NOCOPY VARCHAR2,
209
210 x_msg_count OUT NOCOPY NUMBER,
211
212 x_msg_data OUT NOCOPY VARCHAR2,
213
214 p_stmv_tbl IN stmv_tbl_type,
215
216 x_stmv_tbl OUT NOCOPY stmv_tbl_type);
217
218
219
220 PROCEDURE create_streams(
221
222 p_api_version IN NUMBER,
223
224 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225
226 x_return_status OUT NOCOPY VARCHAR2,
227
228 x_msg_count OUT NOCOPY NUMBER,
229
230 x_msg_data OUT NOCOPY VARCHAR2,
231
232 p_stmv_rec IN stmv_rec_type,
233
234 x_stmv_rec OUT NOCOPY stmv_rec_type);
235
236
237
238 PROCEDURE lock_streams(
239
240 p_api_version IN NUMBER,
241
242 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
243
244 x_return_status OUT NOCOPY VARCHAR2,
245
246 x_msg_count OUT NOCOPY NUMBER,
247
248 x_msg_data OUT NOCOPY VARCHAR2,
249
250 p_stmv_tbl IN stmv_tbl_type);
251
252
253
254 PROCEDURE lock_streams(
255
256 p_api_version IN NUMBER,
257
258 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259
260 x_return_status OUT NOCOPY VARCHAR2,
261
262 x_msg_count OUT NOCOPY NUMBER,
263
264 x_msg_data OUT NOCOPY VARCHAR2,
265
266 p_stmv_rec IN stmv_rec_type);
267
268
269
270 PROCEDURE update_streams(
271
272 p_api_version IN NUMBER,
273
274 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
275
276 x_return_status OUT NOCOPY VARCHAR2,
277
278 x_msg_count OUT NOCOPY NUMBER,
279
280 x_msg_data OUT NOCOPY VARCHAR2,
281
282 p_stmv_tbl IN stmv_tbl_type,
283
284 x_stmv_tbl OUT NOCOPY stmv_tbl_type);
285
286
287
288 PROCEDURE update_streams(
289
290 p_api_version IN NUMBER,
291
292 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
293
294 x_return_status OUT NOCOPY VARCHAR2,
295
296 x_msg_count OUT NOCOPY NUMBER,
297
298 x_msg_data OUT NOCOPY VARCHAR2,
299
300 p_stmv_rec IN stmv_rec_type,
301
302 x_stmv_rec OUT NOCOPY stmv_rec_type);
303
304
305
306 PROCEDURE delete_streams(
307
308 p_api_version IN NUMBER,
309
310 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311
312 x_return_status OUT NOCOPY VARCHAR2,
313
314 x_msg_count OUT NOCOPY NUMBER,
315
316 x_msg_data OUT NOCOPY VARCHAR2,
317
318 p_stmv_tbl IN stmv_tbl_type);
319
320
321
322 PROCEDURE delete_streams(
323
324 p_api_version IN NUMBER,
325
326 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327
328 x_return_status OUT NOCOPY VARCHAR2,
329
330 x_msg_count OUT NOCOPY NUMBER,
331
332 x_msg_data OUT NOCOPY VARCHAR2,
333
334 p_stmv_rec IN stmv_rec_type);
335
336
337
338 PROCEDURE validate_streams(
339
340 p_api_version IN NUMBER,
341
342 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
343
344 x_return_status OUT NOCOPY VARCHAR2,
345
346 x_msg_count OUT NOCOPY NUMBER,
347
348 x_msg_data OUT NOCOPY VARCHAR2,
349
350 p_stmv_tbl IN stmv_tbl_type);
351
352
353
354 PROCEDURE validate_streams(
355
356 p_api_version IN NUMBER,
357
358 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
359
360 x_return_status OUT NOCOPY VARCHAR2,
361
362 x_msg_count OUT NOCOPY NUMBER,
363
364 x_msg_data OUT NOCOPY VARCHAR2,
365
366 p_stmv_rec IN stmv_rec_type);
367
368
369
370
371
372 PROCEDURE create_stream_elements(
373
374 p_api_version IN NUMBER,
375
376 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
377
378 x_return_status OUT NOCOPY VARCHAR2,
379
380 x_msg_count OUT NOCOPY NUMBER,
381
382 x_msg_data OUT NOCOPY VARCHAR2,
383
384 p_selv_tbl IN selv_tbl_type,
385
386 x_selv_tbl OUT NOCOPY selv_tbl_type);
387
388
389
390 PROCEDURE create_stream_elements(
391
392 p_api_version IN NUMBER,
393
394 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
395
396 x_return_status OUT NOCOPY VARCHAR2,
397
398 x_msg_count OUT NOCOPY NUMBER,
399
400 x_msg_data OUT NOCOPY VARCHAR2,
401
402 p_selv_rec IN selv_rec_type,
403
404 x_selv_rec OUT NOCOPY selv_rec_type);
405
406
407
408 PROCEDURE lock_stream_elements(
409
410 p_api_version IN NUMBER,
411
412 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
413
414 x_return_status OUT NOCOPY VARCHAR2,
415
416 x_msg_count OUT NOCOPY NUMBER,
417
418 x_msg_data OUT NOCOPY VARCHAR2,
419
420 p_selv_tbl IN selv_tbl_type);
421
422
423
424 PROCEDURE lock_stream_elements(
425
426 p_api_version IN NUMBER,
427
428 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
429
430 x_return_status OUT NOCOPY VARCHAR2,
431
432 x_msg_count OUT NOCOPY NUMBER,
433
434 x_msg_data OUT NOCOPY VARCHAR2,
435
436 p_selv_rec IN selv_rec_type);
437
438
439
440 PROCEDURE update_stream_elements(
441
442 p_api_version IN NUMBER,
443
444 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
445
446 x_return_status OUT NOCOPY VARCHAR2,
447
448 x_msg_count OUT NOCOPY NUMBER,
449
450 x_msg_data OUT NOCOPY VARCHAR2,
451
452 p_selv_tbl IN selv_tbl_type,
453
454 x_selv_tbl OUT NOCOPY selv_tbl_type);
455
456
457
458 PROCEDURE update_stream_elements(
459
460 p_api_version IN NUMBER,
461
462 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
463
464 x_return_status OUT NOCOPY VARCHAR2,
465
466 x_msg_count OUT NOCOPY NUMBER,
467
468 x_msg_data OUT NOCOPY VARCHAR2,
469
470 p_selv_rec IN selv_rec_type,
471
472 x_selv_rec OUT NOCOPY selv_rec_type);
473
474
475
476 PROCEDURE delete_stream_elements(
477
478 p_api_version IN NUMBER,
479
480 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
481
482 x_return_status OUT NOCOPY VARCHAR2,
483
484 x_msg_count OUT NOCOPY NUMBER,
485
486 x_msg_data OUT NOCOPY VARCHAR2,
487
488 p_selv_tbl IN selv_tbl_type);
489
490
491
492 PROCEDURE delete_stream_elements(
493
494 p_api_version IN NUMBER,
495
496 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
497
498 x_return_status OUT NOCOPY VARCHAR2,
499
500 x_msg_count OUT NOCOPY NUMBER,
501
502 x_msg_data OUT NOCOPY VARCHAR2,
503
504 p_selv_rec IN selv_rec_type);
505
506
507
508 PROCEDURE validate_stream_elements(
509
510 p_api_version IN NUMBER,
511
512 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
513
514 x_return_status OUT NOCOPY VARCHAR2,
515
516 x_msg_count OUT NOCOPY NUMBER,
517
518 x_msg_data OUT NOCOPY VARCHAR2,
519
520 p_selv_tbl IN selv_tbl_type);
521
522
523
524 PROCEDURE validate_stream_elements(
525
526 p_api_version IN NUMBER,
527
528 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
529
530 x_return_status OUT NOCOPY VARCHAR2,
531
532 x_msg_count OUT NOCOPY NUMBER,
533
534 x_msg_data OUT NOCOPY VARCHAR2,
535
536 p_selv_rec IN selv_rec_type);
537
538
539
540 END Okl_Streams_Pub;