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_OPTION_RULES_PUB';
69:
70: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
71:
72: ---------------------------------------------------------------------------------
73:
74:
82: PROCEDURE create_option_rules(
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
108: PROCEDURE update_option_rules(
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
134: PROCEDURE validate_option_rules(
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
158: PROCEDURE create_option_rules(
159:
160: p_api_version IN NUMBER,
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,
176: PROCEDURE create_option_rules(
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,
194: PROCEDURE lock_option_rules(
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,
210: PROCEDURE lock_option_rules(
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,
226: PROCEDURE update_option_rules(
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,
244: PROCEDURE update_option_rules(
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,
262: PROCEDURE delete_option_rules(
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,
278: PROCEDURE delete_option_rules(
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,
294: PROCEDURE validate_option_rules(
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,
310: PROCEDURE validate_option_rules(
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,
328: PROCEDURE create_option_val_rules(
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,
346: PROCEDURE create_option_val_rules(
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,
364: PROCEDURE lock_option_val_rules(
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,
380: PROCEDURE lock_option_val_rules(
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,
396: PROCEDURE update_option_val_rules(
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,
414: PROCEDURE update_option_val_rules(
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,
432: PROCEDURE delete_option_val_rules(
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,
448: PROCEDURE delete_option_val_rules(
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,
464: PROCEDURE validate_option_val_rules(
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,
480: PROCEDURE validate_option_val_rules(
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,