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

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

20:
21: ------------------------------------------------------------------------------
22: -- Global Variables
23: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONDITIONS_PVT';
24: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
28: ------------------------------------------------------------------------------

Line 39: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

35:
36: --Object type procedure for insert
37: PROCEDURE create_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type,

Line 51: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

69:
70: --Procedures for Condition Headers
71: PROCEDURE create_cond_hdrs(
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_cnhv_tbl IN cnhv_tbl_type,

Line 82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

78: x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
79:
80: PROCEDURE create_cond_hdrs(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_cnhv_rec IN cnhv_rec_type,

Line 91: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

87: x_cnhv_rec OUT NOCOPY cnhv_rec_type);
88:
89: PROCEDURE lock_cond_hdrs(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_cnhv_tbl IN cnhv_tbl_type);

Line 99: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

95: p_cnhv_tbl IN cnhv_tbl_type);
96:
97: PROCEDURE lock_cond_hdrs(
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_cnhv_rec IN cnhv_rec_type);

Line 107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

103: p_cnhv_rec IN cnhv_rec_type);
104:
105: PROCEDURE update_cond_hdrs(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_cnhv_tbl IN cnhv_tbl_type,

Line 116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

112: x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
113:
114: PROCEDURE update_cond_hdrs(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_cnhv_rec IN cnhv_rec_type,

Line 125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

121: x_cnhv_rec OUT NOCOPY cnhv_rec_type);
122:
123: PROCEDURE delete_cond_hdrs(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_cnhv_tbl IN cnhv_tbl_type);

Line 133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

129: p_cnhv_tbl IN cnhv_tbl_type);
130:
131: PROCEDURE delete_cond_hdrs(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_cnhv_rec IN cnhv_rec_type);

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

137: p_cnhv_rec IN cnhv_rec_type);
138:
139: PROCEDURE validate_cond_hdrs(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_cnhv_tbl IN cnhv_tbl_type);

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

145: p_cnhv_tbl IN cnhv_tbl_type);
146:
147: PROCEDURE validate_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type);

Line 159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

155:
156: --Procedures for Condition Lines
157: PROCEDURE create_cond_lines(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_cnlv_tbl IN cnlv_tbl_type,

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

164: x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
165:
166: PROCEDURE create_cond_lines(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_cnlv_rec IN cnlv_rec_type,

Line 177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

173: x_cnlv_rec OUT NOCOPY cnlv_rec_type);
174:
175: PROCEDURE lock_cond_lines(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_cnlv_tbl IN cnlv_tbl_type);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

181: p_cnlv_tbl IN cnlv_tbl_type);
182:
183: PROCEDURE lock_cond_lines(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_cnlv_rec IN cnlv_rec_type);

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

189: p_cnlv_rec IN cnlv_rec_type);
190:
191: PROCEDURE update_cond_lines(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_cnlv_tbl IN cnlv_tbl_type,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

198: x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
199:
200: PROCEDURE update_cond_lines(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_cnlv_rec IN cnlv_rec_type,

Line 211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

207: x_cnlv_rec OUT NOCOPY cnlv_rec_type);
208:
209: PROCEDURE delete_cond_lines(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_cnlv_rec IN cnlv_rec_type);

Line 219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

215: p_cnlv_rec IN cnlv_rec_type);
216:
217: PROCEDURE delete_cond_lines(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_cnlv_tbl IN cnlv_tbl_type);

Line 227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

223: p_cnlv_tbl IN cnlv_tbl_type);
224:
225: PROCEDURE validate_cond_lines(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_cnlv_tbl IN cnlv_tbl_type);

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

231: p_cnlv_tbl IN cnlv_tbl_type);
232:
233: PROCEDURE validate_cond_lines(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_cnlv_rec IN cnlv_rec_type);

Line 244: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

240:
241: --Procedures for Condition Occurrences
242: PROCEDURE create_cond_occurs(
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_coev_tbl IN coev_tbl_type,

Line 253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

249: x_coev_tbl OUT NOCOPY coev_tbl_type);
250:
251: PROCEDURE create_cond_occurs(
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_coev_rec IN coev_rec_type,

Line 262: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

258: x_coev_rec OUT NOCOPY coev_rec_type);
259:
260: PROCEDURE delete_cond_occurs(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_coev_rec IN coev_rec_type);

Line 270: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

266: p_coev_rec IN coev_rec_type);
267:
268: PROCEDURE delete_cond_occurs(
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_coev_tbl IN coev_tbl_type);

Line 278: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

274: p_coev_tbl IN coev_tbl_type);
275:
276: PROCEDURE validate_cond_occurs(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_coev_tbl IN coev_tbl_type);

Line 286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

282: p_coev_tbl IN coev_tbl_type);
283:
284: PROCEDURE validate_cond_occurs(
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_coev_rec IN coev_rec_type);

Line 295: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

291:
292: --Procedures for Action Attribute Values
293: PROCEDURE create_act_att_vals(
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_aavv_tbl IN aavv_tbl_type,

Line 304: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

300: x_aavv_tbl OUT NOCOPY aavv_tbl_type);
301:
302: PROCEDURE create_act_att_vals(
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_aavv_rec IN aavv_rec_type,

Line 313: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

309: x_aavv_rec OUT NOCOPY aavv_rec_type);
310:
311: PROCEDURE delete_act_att_vals(
312: p_api_version IN NUMBER,
313: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
314: x_return_status OUT NOCOPY VARCHAR2,
315: x_msg_count OUT NOCOPY NUMBER,
316: x_msg_data OUT NOCOPY VARCHAR2,
317: p_aavv_rec IN aavv_rec_type);

Line 321: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

317: p_aavv_rec IN aavv_rec_type);
318:
319: PROCEDURE delete_act_att_vals(
320: p_api_version IN NUMBER,
321: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
322: x_return_status OUT NOCOPY VARCHAR2,
323: x_msg_count OUT NOCOPY NUMBER,
324: x_msg_data OUT NOCOPY VARCHAR2,
325: p_aavv_tbl IN aavv_tbl_type);

Line 329: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

325: p_aavv_tbl IN aavv_tbl_type);
326:
327: PROCEDURE validate_act_att_vals(
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_aavv_tbl IN aavv_tbl_type);

Line 337: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 346: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

342:
343: --Procedures for Action Attribute Lookups
344: PROCEDURE create_act_att_lkps(
345: p_api_version IN NUMBER,
346: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: p_aalv_tbl IN aalv_tbl_type,

Line 355: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

351: x_aalv_tbl OUT NOCOPY aalv_tbl_type);
352:
353: PROCEDURE create_act_att_lkps(
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_aalv_rec IN aalv_rec_type,

Line 364: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

360: x_aalv_rec OUT NOCOPY aalv_rec_type);
361:
362: PROCEDURE lock_act_att_lkps(
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_aalv_tbl IN aalv_tbl_type);

Line 372: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

368: p_aalv_tbl IN aalv_tbl_type);
369:
370: PROCEDURE lock_act_att_lkps(
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
373: x_return_status OUT NOCOPY VARCHAR2,
374: x_msg_count OUT NOCOPY NUMBER,
375: x_msg_data OUT NOCOPY VARCHAR2,
376: p_aalv_rec IN aalv_rec_type);

Line 380: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 389: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

385: x_aalv_tbl OUT NOCOPY aalv_tbl_type);
386:
387: PROCEDURE update_act_att_lkps(
388: p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2,
393: p_aalv_rec IN aalv_rec_type,

Line 398: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

394: x_aalv_rec OUT NOCOPY aalv_rec_type);
395:
396: PROCEDURE delete_act_att_lkps(
397: p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2,
402: p_aalv_rec IN aalv_rec_type);

Line 406: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

402: p_aalv_rec IN aalv_rec_type);
403:
404: PROCEDURE delete_act_att_lkps(
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,
409: x_msg_data OUT NOCOPY VARCHAR2,
410: p_aalv_tbl IN aalv_tbl_type);

Line 414: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

410: p_aalv_tbl IN aalv_tbl_type);
411:
412: PROCEDURE validate_act_att_lkps(
413: p_api_version IN NUMBER,
414: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
415: x_return_status OUT NOCOPY VARCHAR2,
416: x_msg_count OUT NOCOPY NUMBER,
417: x_msg_data OUT NOCOPY VARCHAR2,
418: p_aalv_tbl IN aalv_tbl_type);

Line 422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

418: p_aalv_tbl IN aalv_tbl_type);
419:
420: PROCEDURE validate_act_att_lkps(
421: p_api_version IN NUMBER,
422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,
425: x_msg_data OUT NOCOPY VARCHAR2,
426: p_aalv_rec IN aalv_rec_type);

Line 431: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

427:
428: --Procedures for Function Expression Parameters
429: PROCEDURE create_func_exprs(
430: p_api_version IN NUMBER,
431: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,
435: p_fepv_tbl IN fepv_tbl_type,

Line 440: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

436: x_fepv_tbl OUT NOCOPY fepv_tbl_type);
437:
438: PROCEDURE create_func_exprs(
439: p_api_version IN NUMBER,
440: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
441: x_return_status OUT NOCOPY VARCHAR2,
442: x_msg_count OUT NOCOPY NUMBER,
443: x_msg_data OUT NOCOPY VARCHAR2,
444: p_fepv_rec IN fepv_rec_type,

Line 449: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

445: x_fepv_rec OUT NOCOPY fepv_rec_type);
446:
447: PROCEDURE lock_func_exprs(
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_fepv_tbl IN fepv_tbl_type);

Line 457: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

453: p_fepv_tbl IN fepv_tbl_type);
454:
455: PROCEDURE lock_func_exprs(
456: p_api_version IN NUMBER,
457: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
458: x_return_status OUT NOCOPY VARCHAR2,
459: x_msg_count OUT NOCOPY NUMBER,
460: x_msg_data OUT NOCOPY VARCHAR2,
461: p_fepv_rec IN fepv_rec_type);

Line 465: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

461: p_fepv_rec IN fepv_rec_type);
462:
463: PROCEDURE update_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 474: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 483: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

479: x_fepv_rec OUT NOCOPY fepv_rec_type);
480:
481: PROCEDURE delete_func_exprs(
482: p_api_version IN NUMBER,
483: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
484: x_return_status OUT NOCOPY VARCHAR2,
485: x_msg_count OUT NOCOPY NUMBER,
486: x_msg_data OUT NOCOPY VARCHAR2,
487: p_fepv_rec IN fepv_rec_type);

Line 491: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 499: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

495: p_fepv_tbl IN fepv_tbl_type);
496:
497: PROCEDURE validate_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_tbl IN fepv_tbl_type);

Line 507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

503: p_fepv_tbl IN fepv_tbl_type);
504:
505: PROCEDURE validate_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_rec IN fepv_rec_type);