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_PVT 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_PVT';
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_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
27: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

22: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_STD_ARTICLE_PVT';
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_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
27: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
28: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
29: G_CHILD_DELETE CONSTANT varchar2(200) := 'OKC_CANNOT_DELETE_MASTER';
30: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

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

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_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
27: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
28: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
29: G_CHILD_DELETE CONSTANT varchar2(200) := 'OKC_CANNOT_DELETE_MASTER';
30: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
31: ---------------------------------------------------------------------------

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

24: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
25: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
26: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
27: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
28: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
29: G_CHILD_DELETE CONSTANT varchar2(200) := 'OKC_CANNOT_DELETE_MASTER';
30: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
31: ---------------------------------------------------------------------------
32:

Line 39: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

35: PROCEDURE add_language;
36:
37: PROCEDURE Create_std_article(
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
43: p_saev_rec IN saev_rec_type,

Line 56: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

52:
53:
54: PROCEDURE Update_std_article(
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: p_saev_rec IN saev_rec_type,

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

69:
70:
71: PROCEDURE Validate_std_article(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_saev_rec IN saev_rec_type,

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

81:
82:
83: PROCEDURE create_std_article(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_saev_tbl IN saev_tbl_type,

Line 95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

91:
92:
93: PROCEDURE create_std_article(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_saev_rec IN saev_rec_type,

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

100: x_saev_rec OUT NOCOPY saev_rec_type);
101:
102: PROCEDURE lock_std_article(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_saev_tbl IN saev_tbl_type);

Line 113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

109:
110:
111: PROCEDURE lock_std_article(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_saev_rec IN saev_rec_type);

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

117: p_saev_rec IN saev_rec_type);
118:
119: PROCEDURE update_std_article(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_saev_tbl IN saev_tbl_type,

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

127:
128:
129: PROCEDURE update_std_article(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_saev_rec IN saev_rec_type,

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

136: x_saev_rec OUT NOCOPY saev_rec_type);
137:
138: PROCEDURE delete_std_article(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_saev_tbl IN saev_tbl_type);

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

145:
146:
147: PROCEDURE delete_std_article(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_saev_rec IN saev_rec_type);

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

153: p_saev_rec IN saev_rec_type);
154:
155: PROCEDURE validate_std_article(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_saev_tbl IN saev_tbl_type);

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

162:
163:
164: PROCEDURE validate_std_article(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_saev_rec IN saev_rec_type);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: p_saev_rec IN saev_rec_type);
171:
172: PROCEDURE validate_name(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_saev_rec IN saev_rec_type);

Line 187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

183:
184:
185: PROCEDURE create_std_art_version(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_savv_tbl IN savv_tbl_type,

Line 197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

193:
194:
195: PROCEDURE create_std_art_version(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_savv_rec IN savv_rec_type,

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

202: x_savv_rec OUT NOCOPY savv_rec_type);
203:
204: PROCEDURE lock_std_art_version(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_savv_tbl IN savv_tbl_type);

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

211:
212:
213: PROCEDURE lock_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 223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

229:
230:
231: PROCEDURE update_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 242: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

247:
248:
249: PROCEDURE delete_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 259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 277: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

273:
274:
275: PROCEDURE validate_sav_release(
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_rec IN savv_rec_type);

Line 285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 301: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

297: x_return_status OUT NOCOPY VARCHAR2);
298:
299: PROCEDURE validate_updatable(
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_savv_rec IN savv_rec_type);

Line 310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

306:
307: /*
308: PROCEDURE validate_short_description(
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 319: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

315:
316: */
317: PROCEDURE create_std_art_incmpt(
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_saiv_tbl IN saiv_tbl_type,

Line 329: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

325:
326:
327: PROCEDURE create_std_art_incmpt(
328: p_api_version IN NUMBER,
329: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,
333: p_saiv_rec IN saiv_rec_type,

Line 338: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

334: x_saiv_rec OUT NOCOPY saiv_rec_type);
335:
336: PROCEDURE lock_std_art_incmpt(
337: p_api_version IN NUMBER,
338: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
342: p_saiv_tbl IN saiv_tbl_type);

Line 347: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

343:
344:
345: PROCEDURE lock_std_art_incmpt(
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
348: x_return_status OUT NOCOPY VARCHAR2,
349: x_msg_count OUT NOCOPY NUMBER,
350: x_msg_data OUT NOCOPY VARCHAR2,
351: p_saiv_rec IN saiv_rec_type);

Line 355: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

351: p_saiv_rec IN saiv_rec_type);
352:
353: PROCEDURE update_std_art_incmpt(
354: p_api_version IN NUMBER,
355: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
356: x_return_status OUT NOCOPY VARCHAR2,
357: x_msg_count OUT NOCOPY NUMBER,
358: x_msg_data OUT NOCOPY VARCHAR2,
359: p_saiv_tbl IN saiv_tbl_type,

Line 364: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

360: x_saiv_tbl OUT NOCOPY saiv_tbl_type);
361:
362: PROCEDURE update_std_art_incmpt(
363: p_api_version IN NUMBER,
364: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_saiv_rec IN saiv_rec_type,

Line 373: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

369: x_saiv_rec OUT NOCOPY saiv_rec_type);
370:
371: PROCEDURE delete_std_art_incmpt(
372: p_api_version IN NUMBER,
373: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_msg_count OUT NOCOPY NUMBER,
376: x_msg_data OUT NOCOPY VARCHAR2,
377: p_saiv_tbl IN saiv_tbl_type);

Line 382: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

378:
379:
380: PROCEDURE delete_std_art_incmpt(
381: p_api_version IN NUMBER,
382: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,
386: p_saiv_rec IN saiv_rec_type);

Line 390: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

386: p_saiv_rec IN saiv_rec_type);
387:
388: PROCEDURE validate_std_art_incmpt(
389: p_api_version IN NUMBER,
390: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_saiv_tbl IN saiv_tbl_type);

Line 399: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

395:
396:
397: PROCEDURE validate_std_art_incmpt(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
403: p_saiv_rec IN saiv_rec_type);

Line 407: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

403: p_saiv_rec IN saiv_rec_type);
404:
405: PROCEDURE validate_unique(
406: p_api_version IN NUMBER,
407: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2,
411: p_saiv_rec IN saiv_rec_type);

Line 415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

411: p_saiv_rec IN saiv_rec_type);
412:
413: PROCEDURE create_std_art_classing(
414: p_api_version IN NUMBER,
415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,
419: p_sacv_tbl IN sacv_tbl_type,

Line 424: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

420: x_sacv_tbl OUT NOCOPY sacv_tbl_type);
421:
422: PROCEDURE create_std_art_classing(
423: p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,
428: p_sacv_rec IN sacv_rec_type,

Line 433: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

429: x_sacv_rec OUT NOCOPY sacv_rec_type);
430:
431: PROCEDURE lock_std_art_classing(
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
434: x_return_status OUT NOCOPY VARCHAR2,
435: x_msg_count OUT NOCOPY NUMBER,
436: x_msg_data OUT NOCOPY VARCHAR2,
437: p_sacv_tbl IN sacv_tbl_type);

Line 441: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

437: p_sacv_tbl IN sacv_tbl_type);
438:
439: PROCEDURE lock_std_art_classing(
440: p_api_version IN NUMBER,
441: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,
445: p_sacv_rec IN sacv_rec_type);

Line 449: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

445: p_sacv_rec IN sacv_rec_type);
446:
447: PROCEDURE update_std_art_classing(
448: p_api_version IN NUMBER,
449: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2,
453: p_sacv_tbl IN sacv_tbl_type,

Line 459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

455:
456:
457: PROCEDURE update_std_art_classing(
458: p_api_version IN NUMBER,
459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
463: p_sacv_rec IN sacv_rec_type,

Line 468: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

464: x_sacv_rec OUT NOCOPY sacv_rec_type);
465:
466: PROCEDURE delete_std_art_classing(
467: p_api_version IN NUMBER,
468: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2,
472: p_sacv_tbl IN sacv_tbl_type);

Line 477: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

473:
474:
475: PROCEDURE delete_std_art_classing(
476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
478: x_return_status OUT NOCOPY VARCHAR2,
479: x_msg_count OUT NOCOPY NUMBER,
480: x_msg_data OUT NOCOPY VARCHAR2,
481: p_sacv_rec IN sacv_rec_type);

Line 485: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

481: p_sacv_rec IN sacv_rec_type);
482:
483: PROCEDURE validate_std_art_classing(
484: p_api_version IN NUMBER,
485: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
486: x_return_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,
488: x_msg_data OUT NOCOPY VARCHAR2,
489: p_sacv_tbl IN sacv_tbl_type);

Line 493: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

489: p_sacv_tbl IN sacv_tbl_type);
490:
491: PROCEDURE validate_std_art_classing(
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: p_sacv_rec IN sacv_rec_type);

Line 502: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

498:
499:
500: PROCEDURE validate_price_type(
501: p_api_version IN NUMBER,
502: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
503: x_return_status OUT NOCOPY VARCHAR2,
504: x_msg_count OUT NOCOPY NUMBER,
505: x_msg_data OUT NOCOPY VARCHAR2,
506: p_sacv_rec IN sacv_rec_type);

Line 510: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

506: p_sacv_rec IN sacv_rec_type);
507:
508: PROCEDURE validate_scs_code(
509: p_api_version IN NUMBER,
510: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
511: x_return_status OUT NOCOPY VARCHAR2,
512: x_msg_count OUT NOCOPY NUMBER,
513: x_msg_data OUT NOCOPY VARCHAR2,
514: p_sacv_rec IN sacv_rec_type);

Line 520: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

516:
517:
518: PROCEDURE create_std_art_set_mem(
519: p_api_version IN NUMBER,
520: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_msg_count OUT NOCOPY NUMBER,
523: x_msg_data OUT NOCOPY VARCHAR2,
524: p_samv_tbl IN samv_tbl_type,

Line 530: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

526:
527:
528: PROCEDURE create_std_art_set_mem(
529: p_api_version IN NUMBER,
530: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
531: x_return_status OUT NOCOPY VARCHAR2,
532: x_msg_count OUT NOCOPY NUMBER,
533: x_msg_data OUT NOCOPY VARCHAR2,
534: p_samv_rec IN samv_rec_type,

Line 539: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

535: x_samv_rec OUT NOCOPY samv_rec_type);
536:
537: PROCEDURE lock_std_art_set_mem(
538: p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY VARCHAR2,
543: p_samv_tbl IN samv_tbl_type);

Line 548: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

544:
545:
546: PROCEDURE lock_std_art_set_mem(
547: p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
549: x_return_status OUT NOCOPY VARCHAR2,
550: x_msg_count OUT NOCOPY NUMBER,
551: x_msg_data OUT NOCOPY VARCHAR2,
552: p_samv_rec IN samv_rec_type);

Line 556: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

552: p_samv_rec IN samv_rec_type);
553:
554: PROCEDURE update_std_art_set_mem(
555: p_api_version IN NUMBER,
556: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
557: x_return_status OUT NOCOPY VARCHAR2,
558: x_msg_count OUT NOCOPY NUMBER,
559: x_msg_data OUT NOCOPY VARCHAR2,
560: p_samv_tbl IN samv_tbl_type,

Line 565: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

561: x_samv_tbl OUT NOCOPY samv_tbl_type);
562:
563: PROCEDURE update_std_art_set_mem(
564: p_api_version IN NUMBER,
565: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
566: x_return_status OUT NOCOPY VARCHAR2,
567: x_msg_count OUT NOCOPY NUMBER,
568: x_msg_data OUT NOCOPY VARCHAR2,
569: p_samv_rec IN samv_rec_type,

Line 574: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

570: x_samv_rec OUT NOCOPY samv_rec_type);
571:
572: PROCEDURE delete_std_art_set_mem(
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_samv_tbl IN samv_tbl_type);

Line 582: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

578: p_samv_tbl IN samv_tbl_type);
579:
580: PROCEDURE delete_std_art_set_mem(
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_samv_rec IN samv_rec_type);

Line 590: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

586: p_samv_rec IN samv_rec_type);
587:
588: PROCEDURE validate_std_art_set_mem(
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_samv_tbl IN samv_tbl_type);

Line 598: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

594: p_samv_tbl IN samv_tbl_type);
595:
596: PROCEDURE validate_std_art_set_mem(
597: p_api_version IN NUMBER,
598: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
599: x_return_status OUT NOCOPY VARCHAR2,
600: x_msg_count OUT NOCOPY NUMBER,
601: x_msg_data OUT NOCOPY VARCHAR2,
602: p_samv_rec IN samv_rec_type);

Line 606: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

602: p_samv_rec IN samv_rec_type);
603:
604: PROCEDURE validate_unique(
605: p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
607: x_return_status OUT NOCOPY VARCHAR2,
608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_samv_rec IN samv_rec_type);