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_CONDITIONS_PUB dependencies on OKC_API

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

18: ---------------------------------------------------------------------------------------
19: -- GLOBAL VARIABLES
20: ---------------------------------------------------------------------------------------
21: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONDITIONS_PUB';
22: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26:

Line 50: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

46:
47: --Object type procedure for insert
48: PROCEDURE create_cond_hdrs(
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: p_cnhv_rec IN cnhv_rec_type,

Line 62: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

58:
59: --Object type procedure for update
60: PROCEDURE update_cond_hdrs(
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,
66: p_cnhv_rec IN cnhv_rec_type,

Line 74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

70:
71: --Object type procedure for validate
72: PROCEDURE validate_cond_hdrs(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
78: p_cnhv_rec IN cnhv_rec_type,

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

81: --Procedures for condition Headers
82:
83: PROCEDURE create_cond_hdrs(
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_cnhv_tbl IN cnhv_tbl_type,

Line 94: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

90: x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
91:
92: PROCEDURE create_cond_hdrs(
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_cnhv_rec IN cnhv_rec_type,

Line 103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

99: x_cnhv_rec OUT NOCOPY cnhv_rec_type);
100:
101: PROCEDURE lock_cond_hdrs(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_cnhv_tbl IN cnhv_tbl_type);

Line 111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

107: p_cnhv_tbl IN cnhv_tbl_type);
108:
109: PROCEDURE lock_cond_hdrs(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_cnhv_rec IN cnhv_rec_type);

Line 119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

115: p_cnhv_rec IN cnhv_rec_type);
116:
117: PROCEDURE update_cond_hdrs(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_cnhv_tbl IN cnhv_tbl_type,

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

124: x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
125:
126: PROCEDURE update_cond_hdrs(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_cnhv_rec IN cnhv_rec_type,

Line 137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

133: x_cnhv_rec OUT NOCOPY cnhv_rec_type);
134:
135: PROCEDURE delete_cond_hdrs(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_cnhv_tbl IN cnhv_tbl_type);

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

141: p_cnhv_tbl IN cnhv_tbl_type);
142:
143: PROCEDURE delete_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type);

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

149: p_cnhv_rec IN cnhv_rec_type);
150:
151: PROCEDURE validate_cond_hdrs(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_cnhv_tbl IN cnhv_tbl_type);

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

157: p_cnhv_tbl IN cnhv_tbl_type);
158:
159: PROCEDURE validate_cond_hdrs(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_cnhv_rec IN cnhv_rec_type);

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

167: --Procedures for Condition Lines
168:
169: PROCEDURE create_cond_lines(
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_cnlv_tbl IN cnlv_tbl_type,

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

176: x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
177:
178: PROCEDURE create_cond_lines(
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_cnlv_rec IN cnlv_rec_type,

Line 189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

185: x_cnlv_rec OUT NOCOPY cnlv_rec_type);
186:
187: PROCEDURE lock_cond_lines(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_cnlv_tbl IN cnlv_tbl_type);

Line 197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

193: p_cnlv_tbl IN cnlv_tbl_type);
194:
195: PROCEDURE lock_cond_lines(
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_cnlv_rec IN cnlv_rec_type);

Line 205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

201: p_cnlv_rec IN cnlv_rec_type);
202:
203: PROCEDURE update_cond_lines(
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_cnlv_tbl IN cnlv_tbl_type,

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

210: x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
211:
212: PROCEDURE update_cond_lines(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_cnlv_rec IN cnlv_rec_type,

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

219: x_cnlv_rec OUT NOCOPY cnlv_rec_type);
220:
221: PROCEDURE delete_cond_lines(
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_cnlv_rec IN cnlv_rec_type);

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

227: p_cnlv_rec IN cnlv_rec_type);
228:
229: PROCEDURE delete_cond_lines(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_cnlv_tbl IN cnlv_tbl_type);

Line 239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

235: p_cnlv_tbl IN cnlv_tbl_type);
236:
237: PROCEDURE validate_cond_lines(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_cnlv_tbl IN cnlv_tbl_type);

Line 247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

243: p_cnlv_tbl IN cnlv_tbl_type);
244:
245: PROCEDURE validate_cond_lines(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_cnlv_rec IN cnlv_rec_type);

Line 257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

253: --Procedures for Condition Occurrence
254:
255: PROCEDURE create_cond_occurs(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_coev_tbl IN coev_tbl_type,

Line 266: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

262: x_coev_tbl OUT NOCOPY coev_tbl_type);
263:
264: PROCEDURE create_cond_occurs(
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270: p_coev_rec IN coev_rec_type,

Line 275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

271: x_coev_rec OUT NOCOPY coev_rec_type);
272:
273: PROCEDURE delete_cond_occurs(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_coev_rec IN coev_rec_type);

Line 283: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

279: p_coev_rec IN coev_rec_type);
280:
281: PROCEDURE delete_cond_occurs(
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_coev_tbl IN coev_tbl_type);

Line 291: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

287: p_coev_tbl IN coev_tbl_type);
288:
289: PROCEDURE validate_cond_occurs(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_coev_tbl IN coev_tbl_type);

Line 299: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

295: p_coev_tbl IN coev_tbl_type);
296:
297: PROCEDURE validate_cond_occurs(
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,
303: p_coev_rec IN coev_rec_type);

Line 309: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

305: --Procedures for Action Attribute Values
306:
307: PROCEDURE create_act_att_vals(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,
312: x_msg_data OUT NOCOPY VARCHAR2,
313: p_aavv_tbl IN aavv_tbl_type,

Line 318: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

314: x_aavv_tbl OUT NOCOPY aavv_tbl_type);
315:
316: PROCEDURE create_act_att_vals(
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_aavv_rec IN aavv_rec_type,

Line 327: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

323: x_aavv_rec OUT NOCOPY aavv_rec_type);
324:
325: PROCEDURE delete_act_att_vals(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2,
331: p_aavv_rec IN aavv_rec_type);

Line 335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

331: p_aavv_rec IN aavv_rec_type);
332:
333: PROCEDURE delete_act_att_vals(
334: p_api_version IN NUMBER,
335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,
339: p_aavv_tbl IN aavv_tbl_type);

Line 343: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

339: p_aavv_tbl IN aavv_tbl_type);
340:
341: PROCEDURE validate_act_att_vals(
342: p_api_version IN NUMBER,
343: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,
347: p_aavv_tbl IN aavv_tbl_type);

Line 351: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

347: p_aavv_tbl IN aavv_tbl_type);
348:
349: PROCEDURE validate_act_att_vals(
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
354: x_msg_data OUT NOCOPY VARCHAR2,
355: p_aavv_rec IN aavv_rec_type);

Line 361: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

357: --Procedures for Action Attribute Lookups
358:
359: PROCEDURE create_act_att_lkps(
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
362: x_return_status OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY NUMBER,
364: x_msg_data OUT NOCOPY VARCHAR2,
365: p_aalv_tbl IN aalv_tbl_type,

Line 370: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

366: x_aalv_tbl OUT NOCOPY aalv_tbl_type);
367:
368: PROCEDURE create_act_att_lkps(
369: p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2,
374: p_aalv_rec IN aalv_rec_type,

Line 379: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

375: x_aalv_rec OUT NOCOPY aalv_rec_type);
376:
377: PROCEDURE lock_act_att_lkps(
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
380: x_return_status OUT NOCOPY VARCHAR2,
381: x_msg_count OUT NOCOPY NUMBER,
382: x_msg_data OUT NOCOPY VARCHAR2,
383: p_aalv_tbl IN aalv_tbl_type);

Line 387: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

383: p_aalv_tbl IN aalv_tbl_type);
384:
385: PROCEDURE lock_act_att_lkps(
386: p_api_version IN NUMBER,
387: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
388: x_return_status OUT NOCOPY VARCHAR2,
389: x_msg_count OUT NOCOPY NUMBER,
390: x_msg_data OUT NOCOPY VARCHAR2,
391: p_aalv_rec IN aalv_rec_type);

Line 395: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

391: p_aalv_rec IN aalv_rec_type);
392:
393: PROCEDURE update_act_att_lkps(
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_aalv_tbl IN aalv_tbl_type,

Line 404: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

400: x_aalv_tbl OUT NOCOPY aalv_tbl_type);
401:
402: PROCEDURE update_act_att_lkps(
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_aalv_rec IN aalv_rec_type,

Line 413: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

409: x_aalv_rec OUT NOCOPY aalv_rec_type);
410:
411: PROCEDURE delete_act_att_lkps(
412: p_api_version IN NUMBER,
413: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
414: x_return_status OUT NOCOPY VARCHAR2,
415: x_msg_count OUT NOCOPY NUMBER,
416: x_msg_data OUT NOCOPY VARCHAR2,
417: p_aalv_rec IN aalv_rec_type);

Line 421: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

417: p_aalv_rec IN aalv_rec_type);
418:
419: PROCEDURE delete_act_att_lkps(
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_aalv_tbl IN aalv_tbl_type);

Line 429: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

425: p_aalv_tbl IN aalv_tbl_type);
426:
427: PROCEDURE validate_act_att_lkps(
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,
432: x_msg_data OUT NOCOPY VARCHAR2,
433: p_aalv_tbl IN aalv_tbl_type);

Line 437: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

433: p_aalv_tbl IN aalv_tbl_type);
434:
435: PROCEDURE validate_act_att_lkps(
436: p_api_version IN NUMBER,
437: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_aalv_rec IN aalv_rec_type);

Line 447: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

443: --Procedures for Function Expression Parameters
444:
445: PROCEDURE create_func_exprs(
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_fepv_tbl IN fepv_tbl_type,

Line 456: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

452: x_fepv_tbl OUT NOCOPY fepv_tbl_type);
453:
454: PROCEDURE create_func_exprs(
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_fepv_rec IN fepv_rec_type,

Line 465: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

461: x_fepv_rec OUT NOCOPY fepv_rec_type);
462:
463: PROCEDURE lock_func_exprs(
464: p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
466: x_return_status OUT NOCOPY VARCHAR2,
467: x_msg_count OUT NOCOPY NUMBER,
468: x_msg_data OUT NOCOPY VARCHAR2,
469: p_fepv_tbl IN fepv_tbl_type);

Line 473: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

469: p_fepv_tbl IN fepv_tbl_type);
470:
471: PROCEDURE lock_func_exprs(
472: p_api_version IN NUMBER,
473: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
474: x_return_status OUT NOCOPY VARCHAR2,
475: x_msg_count OUT NOCOPY NUMBER,
476: x_msg_data OUT NOCOPY VARCHAR2,
477: p_fepv_rec IN fepv_rec_type);

Line 481: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

477: p_fepv_rec IN fepv_rec_type);
478:
479: PROCEDURE update_func_exprs(
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,
484: x_msg_data OUT NOCOPY VARCHAR2,
485: p_fepv_tbl IN fepv_tbl_type,

Line 490: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

486: x_fepv_tbl OUT NOCOPY fepv_tbl_type);
487:
488: PROCEDURE update_func_exprs(
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
491: x_return_status OUT NOCOPY VARCHAR2,
492: x_msg_count OUT NOCOPY NUMBER,
493: x_msg_data OUT NOCOPY VARCHAR2,
494: p_fepv_rec IN fepv_rec_type,

Line 499: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

495: x_fepv_rec OUT NOCOPY fepv_rec_type);
496:
497: PROCEDURE delete_func_exprs(
498: p_api_version IN NUMBER,
499: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,
502: x_msg_data OUT NOCOPY VARCHAR2,
503: p_fepv_rec IN fepv_rec_type);

Line 507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

503: p_fepv_rec IN fepv_rec_type);
504:
505: PROCEDURE delete_func_exprs(
506: p_api_version IN NUMBER,
507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2,
511: p_fepv_tbl IN fepv_tbl_type);

Line 515: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

511: p_fepv_tbl IN fepv_tbl_type);
512:
513: PROCEDURE validate_func_exprs(
514: p_api_version IN NUMBER,
515: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2,
519: p_fepv_tbl IN fepv_tbl_type);

Line 523: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

519: p_fepv_tbl IN fepv_tbl_type);
520:
521: PROCEDURE validate_func_exprs(
522: p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
524: x_return_status OUT NOCOPY VARCHAR2,
525: x_msg_count OUT NOCOPY NUMBER,
526: x_msg_data OUT NOCOPY VARCHAR2,
527: p_fepv_rec IN fepv_rec_type);