eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_STD_ARTICLE_PUB dependencies on OKC_API

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

19: -- GLOBAL VARIABLES
20: ---------------------------------------------------------------------------
21: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
22: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_STD_ARTICLE_PUB';
23: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
24: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
25: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
26: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
27:

Line 44: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

40: PROCEDURE add_language;
41:
42: PROCEDURE Create_std_article(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: p_saev_rec IN saev_rec_type,

Line 61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

57:
58:
59: PROCEDURE Update_std_article(
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_saev_rec IN saev_rec_type,

Line 78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

74:
75:
76: PROCEDURE Validate_std_article(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_saev_rec IN saev_rec_type,

Line 90: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

86:
87:
88: PROCEDURE create_std_article(
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2,
94: p_saev_tbl IN saev_tbl_type,

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

96:
97:
98: PROCEDURE create_std_article(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_saev_rec IN saev_rec_type,

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

105: x_saev_rec OUT NOCOPY saev_rec_type);
106:
107: PROCEDURE lock_std_article(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_saev_tbl IN saev_tbl_type);

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

114:
115:
116: PROCEDURE lock_std_article(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_saev_rec IN saev_rec_type);

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

122: p_saev_rec IN saev_rec_type);
123:
124: PROCEDURE update_std_article(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_saev_tbl IN saev_tbl_type,

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

132:
133:
134: PROCEDURE update_std_article(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_saev_rec IN saev_rec_type,

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

141: x_saev_rec OUT NOCOPY saev_rec_type);
142:
143: PROCEDURE delete_std_article(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_saev_tbl IN saev_tbl_type);

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

150:
151:
152: PROCEDURE delete_std_article(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_saev_rec IN saev_rec_type);

Line 162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

158: p_saev_rec IN saev_rec_type);
159:
160: PROCEDURE validate_std_article(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_saev_tbl IN saev_tbl_type);

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

167:
168:
169: PROCEDURE validate_std_article(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_saev_rec IN saev_rec_type);

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

176:
177:
178: PROCEDURE validate_name(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_saev_rec IN saev_rec_type);

Line 188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

184: p_saev_rec IN saev_rec_type);
185:
186: PROCEDURE validate_name(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_saev_tbl IN saev_tbl_type);

Line 205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

201:
202:
203: PROCEDURE create_std_art_version(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_savv_tbl IN savv_tbl_type,

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

211:
212:
213: PROCEDURE create_std_art_version(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_savv_rec IN savv_rec_type,

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

220: x_savv_rec OUT NOCOPY savv_rec_type);
221:
222: PROCEDURE lock_std_art_version(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_savv_tbl IN savv_tbl_type);

Line 233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

229:
230:
231: PROCEDURE lock_std_art_version(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_savv_rec IN savv_rec_type);

Line 241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

237: p_savv_rec IN savv_rec_type);
238:
239: PROCEDURE update_std_art_version(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_savv_tbl IN savv_tbl_type,

Line 251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

247:
248:
249: PROCEDURE update_std_art_version(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_savv_rec IN savv_rec_type,

Line 260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

256: x_savv_rec OUT NOCOPY savv_rec_type);
257:
258: PROCEDURE delete_std_art_version(
259: p_api_version IN NUMBER,
260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_count OUT NOCOPY NUMBER,
263: x_msg_data OUT NOCOPY VARCHAR2,
264: p_savv_tbl IN savv_tbl_type);

Line 269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

265:
266:
267: PROCEDURE delete_std_art_version(
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_savv_rec IN savv_rec_type);

Line 277: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

273: p_savv_rec IN savv_rec_type);
274:
275: PROCEDURE validate_std_art_version(
276: p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
278: x_return_status OUT NOCOPY VARCHAR2,
279: x_msg_count OUT NOCOPY NUMBER,
280: x_msg_data OUT NOCOPY VARCHAR2,
281: p_savv_tbl IN savv_tbl_type);

Line 286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

282:
283:
284: PROCEDURE validate_std_art_version(
285: p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,
290: p_savv_rec IN savv_rec_type);

Line 295: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

291:
292:
293: PROCEDURE validate_sav_release(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_savv_rec IN savv_rec_type);

Line 303: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

299: p_savv_rec IN savv_rec_type);
300:
301: PROCEDURE validate_sav_release(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_savv_tbl IN savv_tbl_type);

Line 310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_savv_tbl IN savv_tbl_type);
308: PROCEDURE validate_date_active(
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_savv_rec IN savv_rec_type);

Line 318: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

314: p_savv_rec IN savv_rec_type);
315:
316: PROCEDURE validate_date_active(
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_savv_tbl IN savv_tbl_type);

Line 326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

322: p_savv_tbl IN savv_tbl_type);
323:
324: PROCEDURE validate_updatable(
325: p_api_version IN NUMBER,
326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,
330: p_savv_rec IN savv_rec_type);

Line 334: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

330: p_savv_rec IN savv_rec_type);
331:
332: PROCEDURE validate_updatable(
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
335: x_return_status OUT NOCOPY VARCHAR2,
336: x_msg_count OUT NOCOPY NUMBER,
337: x_msg_data OUT NOCOPY VARCHAR2,
338: p_savv_tbl IN savv_tbl_type);

Line 359: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

355:
356: /*
357: PROCEDURE validate_short_description(
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_savv_rec IN savv_rec_type);

Line 367: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

363: p_savv_rec IN savv_rec_type);
364:
365: PROCEDURE validate_short_description(
366: p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
368: x_return_status OUT NOCOPY VARCHAR2,
369: x_msg_count OUT NOCOPY NUMBER,
370: x_msg_data OUT NOCOPY VARCHAR2,
371: p_savv_tbl IN savv_tbl_type);

Line 376: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

372: */
373:
374: PROCEDURE create_std_art_incmpt(
375: p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
379: x_msg_data OUT NOCOPY VARCHAR2,
380: p_saiv_tbl IN saiv_tbl_type,

Line 386: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

382:
383:
384: PROCEDURE create_std_art_incmpt(
385: p_api_version IN NUMBER,
386: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,
389: x_msg_data OUT NOCOPY VARCHAR2,
390: p_saiv_rec IN saiv_rec_type,

Line 395: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

391: x_saiv_rec OUT NOCOPY saiv_rec_type);
392:
393: PROCEDURE lock_std_art_incmpt(
394: p_api_version IN NUMBER,
395: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
396: x_return_status OUT NOCOPY VARCHAR2,
397: x_msg_count OUT NOCOPY NUMBER,
398: x_msg_data OUT NOCOPY VARCHAR2,
399: p_saiv_tbl IN saiv_tbl_type);

Line 404: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

400:
401:
402: PROCEDURE lock_std_art_incmpt(
403: p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: p_saiv_rec IN saiv_rec_type);

Line 412: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

408: p_saiv_rec IN saiv_rec_type);
409:
410: PROCEDURE update_std_art_incmpt(
411: p_api_version IN NUMBER,
412: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
413: x_return_status OUT NOCOPY VARCHAR2,
414: x_msg_count OUT NOCOPY NUMBER,
415: x_msg_data OUT NOCOPY VARCHAR2,
416: p_saiv_tbl IN saiv_tbl_type,

Line 421: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

417: x_saiv_tbl OUT NOCOPY saiv_tbl_type);
418:
419: PROCEDURE update_std_art_incmpt(
420: p_api_version IN NUMBER,
421: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: p_saiv_rec IN saiv_rec_type,

Line 430: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

426: x_saiv_rec OUT NOCOPY saiv_rec_type);
427:
428: PROCEDURE delete_std_art_incmpt(
429: p_api_version IN NUMBER,
430: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_msg_count OUT NOCOPY NUMBER,
433: x_msg_data OUT NOCOPY VARCHAR2,
434: p_saiv_tbl IN saiv_tbl_type);

Line 439: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

435:
436:
437: PROCEDURE delete_std_art_incmpt(
438: p_api_version IN NUMBER,
439: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
440: x_return_status OUT NOCOPY VARCHAR2,
441: x_msg_count OUT NOCOPY NUMBER,
442: x_msg_data OUT NOCOPY VARCHAR2,
443: p_saiv_rec IN saiv_rec_type);

Line 447: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

443: p_saiv_rec IN saiv_rec_type);
444:
445: PROCEDURE validate_std_art_incmpt(
446: p_api_version IN NUMBER,
447: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
448: x_return_status OUT NOCOPY VARCHAR2,
449: x_msg_count OUT NOCOPY NUMBER,
450: x_msg_data OUT NOCOPY VARCHAR2,
451: p_saiv_tbl IN saiv_tbl_type);

Line 456: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

452:
453:
454: PROCEDURE validate_std_art_incmpt(
455: p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
457: x_return_status OUT NOCOPY VARCHAR2,
458: x_msg_count OUT NOCOPY NUMBER,
459: x_msg_data OUT NOCOPY VARCHAR2,
460: p_saiv_rec IN saiv_rec_type);

Line 464: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

460: p_saiv_rec IN saiv_rec_type);
461:
462: PROCEDURE validate_unique(
463: p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
465: x_return_status OUT NOCOPY VARCHAR2,
466: x_msg_count OUT NOCOPY NUMBER,
467: x_msg_data OUT NOCOPY VARCHAR2,
468: p_saiv_rec IN saiv_rec_type);

Line 472: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

468: p_saiv_rec IN saiv_rec_type);
469:
470: PROCEDURE validate_unique(
471: p_api_version IN NUMBER,
472: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
473: x_return_status OUT NOCOPY VARCHAR2,
474: x_msg_count OUT NOCOPY NUMBER,
475: x_msg_data OUT NOCOPY VARCHAR2,
476: p_saiv_tbl IN saiv_tbl_type);

Line 480: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

476: p_saiv_tbl IN saiv_tbl_type);
477:
478: PROCEDURE create_std_art_classing(
479: p_api_version IN NUMBER,
480: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
481: x_return_status OUT NOCOPY VARCHAR2,
482: x_msg_count OUT NOCOPY NUMBER,
483: x_msg_data OUT NOCOPY VARCHAR2,
484: p_sacv_tbl IN sacv_tbl_type,

Line 489: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

485: x_sacv_tbl OUT NOCOPY sacv_tbl_type);
486:
487: PROCEDURE create_std_art_classing(
488: p_api_version IN NUMBER,
489: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
490: x_return_status OUT NOCOPY VARCHAR2,
491: x_msg_count OUT NOCOPY NUMBER,
492: x_msg_data OUT NOCOPY VARCHAR2,
493: p_sacv_rec IN sacv_rec_type,

Line 498: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

494: x_sacv_rec OUT NOCOPY sacv_rec_type);
495:
496: PROCEDURE lock_std_art_classing(
497: p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
499: x_return_status OUT NOCOPY VARCHAR2,
500: x_msg_count OUT NOCOPY NUMBER,
501: x_msg_data OUT NOCOPY VARCHAR2,
502: p_sacv_tbl IN sacv_tbl_type);

Line 506: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

502: p_sacv_tbl IN sacv_tbl_type);
503:
504: PROCEDURE lock_std_art_classing(
505: p_api_version IN NUMBER,
506: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
507: x_return_status OUT NOCOPY VARCHAR2,
508: x_msg_count OUT NOCOPY NUMBER,
509: x_msg_data OUT NOCOPY VARCHAR2,
510: p_sacv_rec IN sacv_rec_type);

Line 514: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

510: p_sacv_rec IN sacv_rec_type);
511:
512: PROCEDURE update_std_art_classing(
513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
515: x_return_status OUT NOCOPY VARCHAR2,
516: x_msg_count OUT NOCOPY NUMBER,
517: x_msg_data OUT NOCOPY VARCHAR2,
518: p_sacv_tbl IN sacv_tbl_type,

Line 524: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

520:
521:
522: PROCEDURE update_std_art_classing(
523: p_api_version IN NUMBER,
524: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
525: x_return_status OUT NOCOPY VARCHAR2,
526: x_msg_count OUT NOCOPY NUMBER,
527: x_msg_data OUT NOCOPY VARCHAR2,
528: p_sacv_rec IN sacv_rec_type,

Line 533: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

529: x_sacv_rec OUT NOCOPY sacv_rec_type);
530:
531: PROCEDURE delete_std_art_classing(
532: p_api_version IN NUMBER,
533: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,
537: p_sacv_tbl IN sacv_tbl_type);

Line 542: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

538:
539:
540: PROCEDURE delete_std_art_classing(
541: p_api_version IN NUMBER,
542: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
543: x_return_status OUT NOCOPY VARCHAR2,
544: x_msg_count OUT NOCOPY NUMBER,
545: x_msg_data OUT NOCOPY VARCHAR2,
546: p_sacv_rec IN sacv_rec_type);

Line 550: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

546: p_sacv_rec IN sacv_rec_type);
547:
548: PROCEDURE validate_std_art_classing(
549: p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,
553: x_msg_data OUT NOCOPY VARCHAR2,
554: p_sacv_tbl IN sacv_tbl_type);

Line 558: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

554: p_sacv_tbl IN sacv_tbl_type);
555:
556: PROCEDURE validate_std_art_classing(
557: p_api_version IN NUMBER,
558: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
559: x_return_status OUT NOCOPY VARCHAR2,
560: x_msg_count OUT NOCOPY NUMBER,
561: x_msg_data OUT NOCOPY VARCHAR2,
562: p_sacv_rec IN sacv_rec_type);

Line 566: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

562: p_sacv_rec IN sacv_rec_type);
563:
564: PROCEDURE validate_price_type(
565: p_api_version IN NUMBER,
566: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
567: x_return_status OUT NOCOPY VARCHAR2,
568: x_msg_count OUT NOCOPY NUMBER,
569: x_msg_data OUT NOCOPY VARCHAR2,
570: p_sacv_rec IN sacv_rec_type);

Line 574: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

570: p_sacv_rec IN sacv_rec_type);
571:
572: PROCEDURE validate_price_type(
573: p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
575: x_return_status OUT NOCOPY VARCHAR2,
576: x_msg_count OUT NOCOPY NUMBER,
577: x_msg_data OUT NOCOPY VARCHAR2,
578: p_sacv_tbl IN sacv_tbl_type);

Line 582: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

578: p_sacv_tbl IN sacv_tbl_type);
579:
580: PROCEDURE validate_scs_code(
581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,
585: x_msg_data OUT NOCOPY VARCHAR2,
586: p_sacv_rec IN sacv_rec_type);

Line 590: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

586: p_sacv_rec IN sacv_rec_type);
587:
588: PROCEDURE validate_scs_code(
589: p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
591: x_return_status OUT NOCOPY VARCHAR2,
592: x_msg_count OUT NOCOPY NUMBER,
593: x_msg_data OUT NOCOPY VARCHAR2,
594: p_sacv_tbl IN sacv_tbl_type);

Line 599: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

595:
596:
597: PROCEDURE create_std_art_set_mem(
598: p_api_version IN NUMBER,
599: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
600: x_return_status OUT NOCOPY VARCHAR2,
601: x_msg_count OUT NOCOPY NUMBER,
602: x_msg_data OUT NOCOPY VARCHAR2,
603: p_samv_tbl IN samv_tbl_type,

Line 609: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

605:
606:
607: PROCEDURE create_std_art_set_mem(
608: p_api_version IN NUMBER,
609: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,
613: p_samv_rec IN samv_rec_type,

Line 618: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

614: x_samv_rec OUT NOCOPY samv_rec_type);
615:
616: PROCEDURE lock_std_art_set_mem(
617: p_api_version IN NUMBER,
618: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
619: x_return_status OUT NOCOPY VARCHAR2,
620: x_msg_count OUT NOCOPY NUMBER,
621: x_msg_data OUT NOCOPY VARCHAR2,
622: p_samv_tbl IN samv_tbl_type);

Line 627: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

623:
624:
625: PROCEDURE lock_std_art_set_mem(
626: p_api_version IN NUMBER,
627: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
628: x_return_status OUT NOCOPY VARCHAR2,
629: x_msg_count OUT NOCOPY NUMBER,
630: x_msg_data OUT NOCOPY VARCHAR2,
631: p_samv_rec IN samv_rec_type);

Line 635: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

631: p_samv_rec IN samv_rec_type);
632:
633: PROCEDURE update_std_art_set_mem(
634: p_api_version IN NUMBER,
635: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
636: x_return_status OUT NOCOPY VARCHAR2,
637: x_msg_count OUT NOCOPY NUMBER,
638: x_msg_data OUT NOCOPY VARCHAR2,
639: p_samv_tbl IN samv_tbl_type,

Line 644: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

640: x_samv_tbl OUT NOCOPY samv_tbl_type);
641:
642: PROCEDURE update_std_art_set_mem(
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
645: x_return_status OUT NOCOPY VARCHAR2,
646: x_msg_count OUT NOCOPY NUMBER,
647: x_msg_data OUT NOCOPY VARCHAR2,
648: p_samv_rec IN samv_rec_type,

Line 653: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

649: x_samv_rec OUT NOCOPY samv_rec_type);
650:
651: PROCEDURE delete_std_art_set_mem(
652: p_api_version IN NUMBER,
653: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
654: x_return_status OUT NOCOPY VARCHAR2,
655: x_msg_count OUT NOCOPY NUMBER,
656: x_msg_data OUT NOCOPY VARCHAR2,
657: p_samv_tbl IN samv_tbl_type);

Line 661: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

657: p_samv_tbl IN samv_tbl_type);
658:
659: PROCEDURE delete_std_art_set_mem(
660: p_api_version IN NUMBER,
661: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
662: x_return_status OUT NOCOPY VARCHAR2,
663: x_msg_count OUT NOCOPY NUMBER,
664: x_msg_data OUT NOCOPY VARCHAR2,
665: p_samv_rec IN samv_rec_type);

Line 669: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

665: p_samv_rec IN samv_rec_type);
666:
667: PROCEDURE validate_std_art_set_mem(
668: p_api_version IN NUMBER,
669: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
670: x_return_status OUT NOCOPY VARCHAR2,
671: x_msg_count OUT NOCOPY NUMBER,
672: x_msg_data OUT NOCOPY VARCHAR2,
673: p_samv_tbl IN samv_tbl_type);

Line 677: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

673: p_samv_tbl IN samv_tbl_type);
674:
675: PROCEDURE validate_std_art_set_mem(
676: p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
678: x_return_status OUT NOCOPY VARCHAR2,
679: x_msg_count OUT NOCOPY NUMBER,
680: x_msg_data OUT NOCOPY VARCHAR2,
681: p_samv_rec IN samv_rec_type);

Line 685: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

681: p_samv_rec IN samv_rec_type);
682:
683: PROCEDURE validate_unique(
684: p_api_version IN NUMBER,
685: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
686: x_return_status OUT NOCOPY VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2,
689: p_samv_rec IN samv_rec_type);

Line 693: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

689: p_samv_rec IN samv_rec_type);
690:
691: PROCEDURE validate_unique(
692: p_api_version IN NUMBER,
693: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
694: x_return_status OUT NOCOPY VARCHAR2,
695: x_msg_count OUT NOCOPY NUMBER,
696: x_msg_data OUT NOCOPY VARCHAR2,
697: p_samv_tbl IN samv_tbl_type);