DBA Data[Home] [Help]

APPS.OKL_TMPT_SET_PUB dependencies on OKC_API

Line 27: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

23: -- GLOBAL MESSAGE CONSTANTS
24:
25: ---------------------------------------------------------------------------------
26:
27: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
28:
29: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
30:
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

Line 29: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

25: ---------------------------------------------------------------------------------
26:
27: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
28:
29: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
30:
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
32:
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

Line 31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

27: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
28:
29: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
30:
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
32:
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
34:
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

29: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
30:
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
32:
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
34:
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36:
37: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
32:
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
34:
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36:
37: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
38:
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 37: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
34:
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36:
37: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
38:
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40:
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36:
37: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
38:
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40:
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42:
43: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

37: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
38:
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40:
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42:
43: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
44:
45: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 43: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40:
41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42:
43: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
44:
45: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
46:
47: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';

Line 45: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

41: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42:
43: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
44:
45: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
46:
47: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
48:
49: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 75: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

71: ---------------------------------------------------------------------------------
72:
73: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TMPT_SET_PUB';
74:
75: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
76:
77: ---------------------------------------------------------------------------------
78:
79:

Line 91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

87: PROCEDURE create_tmpt_set(
88:
89: p_api_version IN NUMBER
90:
91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
92:
93: ,x_return_status OUT NOCOPY VARCHAR2
94:
95: ,x_msg_count OUT NOCOPY NUMBER

Line 119: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

115: PROCEDURE update_tmpt_set(
116:
117: p_api_version IN NUMBER
118:
119: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
120:
121: ,x_return_status OUT NOCOPY VARCHAR2
122:
123: ,x_msg_count OUT NOCOPY NUMBER

Line 149: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

145: PROCEDURE validate_tmpt_set(
146:
147: p_api_version IN NUMBER
148:
149: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
150:
151: ,x_return_status OUT NOCOPY VARCHAR2
152:
153: ,x_msg_count OUT NOCOPY NUMBER

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

166: PROCEDURE create_tmpt_set(
167:
168: p_api_version IN NUMBER,
169:
170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171:
172: x_return_status OUT NOCOPY VARCHAR2,
173:
174: x_msg_count OUT NOCOPY NUMBER,

Line 188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

184: PROCEDURE create_tmpt_set(
185:
186: p_api_version IN NUMBER,
187:
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189:
190: x_return_status OUT NOCOPY VARCHAR2,
191:
192: x_msg_count OUT NOCOPY NUMBER,

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

202: PROCEDURE lock_tmpt_set(
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,

Line 222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

218: PROCEDURE lock_tmpt_set(
219:
220: p_api_version IN NUMBER,
221:
222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223:
224: x_return_status OUT NOCOPY VARCHAR2,
225:
226: x_msg_count OUT NOCOPY NUMBER,

Line 238: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

234: PROCEDURE update_tmpt_set(
235:
236: p_api_version IN NUMBER,
237:
238: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
239:
240: x_return_status OUT NOCOPY VARCHAR2,
241:
242: x_msg_count OUT NOCOPY NUMBER,

Line 256: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

252: PROCEDURE update_tmpt_set(
253:
254: p_api_version IN NUMBER,
255:
256: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
257:
258: x_return_status OUT NOCOPY VARCHAR2,
259:
260: x_msg_count OUT NOCOPY NUMBER,

Line 274: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

270: PROCEDURE delete_tmpt_set(
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,

Line 290: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

286: PROCEDURE delete_tmpt_set(
287:
288: p_api_version IN NUMBER,
289:
290: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
291:
292: x_return_status OUT NOCOPY VARCHAR2,
293:
294: x_msg_count OUT NOCOPY NUMBER,

Line 306: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

302: PROCEDURE validate_tmpt_set(
303:
304: p_api_version IN NUMBER,
305:
306: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
307:
308: x_return_status OUT NOCOPY VARCHAR2,
309:
310: x_msg_count OUT NOCOPY NUMBER,

Line 322: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

318: PROCEDURE validate_tmpt_set(
319:
320: p_api_version IN NUMBER,
321:
322: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
323:
324: x_return_status OUT NOCOPY VARCHAR2,
325:
326: x_msg_count OUT NOCOPY NUMBER,

Line 340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

336: PROCEDURE create_template(
337:
338: p_api_version IN NUMBER,
339:
340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
341:
342: x_return_status OUT NOCOPY VARCHAR2,
343:
344: x_msg_count OUT NOCOPY NUMBER,

Line 358: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

354: PROCEDURE create_template(
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,

Line 376: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

372: PROCEDURE lock_template(
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,

Line 392: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

388: PROCEDURE lock_template(
389:
390: p_api_version IN NUMBER,
391:
392: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
393:
394: x_return_status OUT NOCOPY VARCHAR2,
395:
396: x_msg_count OUT NOCOPY NUMBER,

Line 408: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

404: PROCEDURE update_template(
405:
406: p_api_version IN NUMBER,
407:
408: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
409:
410: x_return_status OUT NOCOPY VARCHAR2,
411:
412: x_msg_count OUT NOCOPY NUMBER,

Line 426: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

422: PROCEDURE update_template(
423:
424: p_api_version IN NUMBER,
425:
426: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
427:
428: x_return_status OUT NOCOPY VARCHAR2,
429:
430: x_msg_count OUT NOCOPY NUMBER,

Line 444: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

440: PROCEDURE delete_template(
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,

Line 460: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

456: PROCEDURE delete_template(
457:
458: p_api_version IN NUMBER,
459:
460: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
461:
462: x_return_status OUT NOCOPY VARCHAR2,
463:
464: x_msg_count OUT NOCOPY NUMBER,

Line 476: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

472: PROCEDURE validate_template(
473:
474: p_api_version IN NUMBER,
475:
476: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
477:
478: x_return_status OUT NOCOPY VARCHAR2,
479:
480: x_msg_count OUT NOCOPY NUMBER,

Line 492: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

488: PROCEDURE validate_template(
489:
490: p_api_version IN NUMBER,
491:
492: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
493:
494: x_return_status OUT NOCOPY VARCHAR2,
495:
496: x_msg_count OUT NOCOPY NUMBER,

Line 507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

503: PROCEDURE create_tmpt_lines(
504:
505: p_api_version IN NUMBER,
506:
507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
508:
509: x_return_status OUT NOCOPY VARCHAR2,
510:
511: x_msg_count OUT NOCOPY NUMBER,

Line 525: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

521: PROCEDURE create_tmpt_lines(
522:
523: p_api_version IN NUMBER,
524:
525: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
526:
527: x_return_status OUT NOCOPY VARCHAR2,
528:
529: x_msg_count OUT NOCOPY NUMBER,

Line 543: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

539: PROCEDURE lock_tmpt_lines(
540:
541: p_api_version IN NUMBER,
542:
543: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
544:
545: x_return_status OUT NOCOPY VARCHAR2,
546:
547: x_msg_count OUT NOCOPY NUMBER,

Line 559: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

555: PROCEDURE lock_tmpt_lines(
556:
557: p_api_version IN NUMBER,
558:
559: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
560:
561: x_return_status OUT NOCOPY VARCHAR2,
562:
563: x_msg_count OUT NOCOPY NUMBER,

Line 575: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

571: PROCEDURE update_tmpt_lines(
572:
573: p_api_version IN NUMBER,
574:
575: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
576:
577: x_return_status OUT NOCOPY VARCHAR2,
578:
579: x_msg_count OUT NOCOPY NUMBER,

Line 593: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

589: PROCEDURE update_tmpt_lines(
590:
591: p_api_version IN NUMBER,
592:
593: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
594:
595: x_return_status OUT NOCOPY VARCHAR2,
596:
597: x_msg_count OUT NOCOPY NUMBER,

Line 611: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

607: PROCEDURE delete_tmpt_lines(
608:
609: p_api_version IN NUMBER,
610:
611: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
612:
613: x_return_status OUT NOCOPY VARCHAR2,
614:
615: x_msg_count OUT NOCOPY NUMBER,

Line 627: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

623: PROCEDURE delete_tmpt_lines(
624:
625: p_api_version IN NUMBER,
626:
627: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
628:
629: x_return_status OUT NOCOPY VARCHAR2,
630:
631: x_msg_count OUT NOCOPY NUMBER,

Line 643: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

639: PROCEDURE validate_tmpt_lines(
640:
641: p_api_version IN NUMBER,
642:
643: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
644:
645: x_return_status OUT NOCOPY VARCHAR2,
646:
647: x_msg_count OUT NOCOPY NUMBER,

Line 659: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

655: PROCEDURE validate_tmpt_lines(
656:
657: p_api_version IN NUMBER,
658:
659: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
660:
661: x_return_status OUT NOCOPY VARCHAR2,
662:
663: x_msg_count OUT NOCOPY NUMBER,