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;
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;
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;
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;
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;
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;
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;
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;
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';
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';
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:
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
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
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
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,