APPS.OKL_OPT_RUL_TMP_PUB_W dependencies on JTF_NUMBER_TABLE

Line 10: , p6_a1 JTF_NUMBER_TABLE

6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p_ovd_id NUMBER
9: , p6_a0 JTF_VARCHAR2_TABLE_100
10: , p6_a1 JTF_NUMBER_TABLE
11: , p6_a2 JTF_NUMBER_TABLE
12: , p6_a3 JTF_VARCHAR2_TABLE_100
13: , p6_a4 JTF_VARCHAR2_TABLE_100
14: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 11: , p6_a2 JTF_NUMBER_TABLE

7: , x_msg_data out nocopy VARCHAR2
8: , p_ovd_id NUMBER
9: , p6_a0 JTF_VARCHAR2_TABLE_100
10: , p6_a1 JTF_NUMBER_TABLE
11: , p6_a2 JTF_NUMBER_TABLE
12: , p6_a3 JTF_VARCHAR2_TABLE_100
13: , p6_a4 JTF_VARCHAR2_TABLE_100
14: , p6_a5 JTF_VARCHAR2_TABLE_100
15: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 22: , p6_a13 JTF_NUMBER_TABLE

18: , p6_a9 JTF_VARCHAR2_TABLE_200
19: , p6_a10 JTF_VARCHAR2_TABLE_100
20: , p6_a11 JTF_VARCHAR2_TABLE_100
21: , p6_a12 JTF_VARCHAR2_TABLE_100
22: , p6_a13 JTF_NUMBER_TABLE
23: , p6_a14 JTF_NUMBER_TABLE
24: , p6_a15 JTF_NUMBER_TABLE
25: , p6_a16 JTF_VARCHAR2_TABLE_100
26: , p6_a17 JTF_VARCHAR2_TABLE_2000

Line 23: , p6_a14 JTF_NUMBER_TABLE

19: , p6_a10 JTF_VARCHAR2_TABLE_100
20: , p6_a11 JTF_VARCHAR2_TABLE_100
21: , p6_a12 JTF_VARCHAR2_TABLE_100
22: , p6_a13 JTF_NUMBER_TABLE
23: , p6_a14 JTF_NUMBER_TABLE
24: , p6_a15 JTF_NUMBER_TABLE
25: , p6_a16 JTF_VARCHAR2_TABLE_100
26: , p6_a17 JTF_VARCHAR2_TABLE_2000
27: , p6_a18 JTF_VARCHAR2_TABLE_100

Line 24: , p6_a15 JTF_NUMBER_TABLE

20: , p6_a11 JTF_VARCHAR2_TABLE_100
21: , p6_a12 JTF_VARCHAR2_TABLE_100
22: , p6_a13 JTF_NUMBER_TABLE
23: , p6_a14 JTF_NUMBER_TABLE
24: , p6_a15 JTF_NUMBER_TABLE
25: , p6_a16 JTF_VARCHAR2_TABLE_100
26: , p6_a17 JTF_VARCHAR2_TABLE_2000
27: , p6_a18 JTF_VARCHAR2_TABLE_100
28: , p6_a19 JTF_VARCHAR2_TABLE_100

Line 44: , p6_a35 JTF_NUMBER_TABLE

40: , p6_a31 JTF_VARCHAR2_TABLE_500
41: , p6_a32 JTF_VARCHAR2_TABLE_500
42: , p6_a33 JTF_VARCHAR2_TABLE_500
43: , p6_a34 JTF_VARCHAR2_TABLE_500
44: , p6_a35 JTF_NUMBER_TABLE
45: , p6_a36 JTF_DATE_TABLE
46: , p6_a37 JTF_NUMBER_TABLE
47: , p6_a38 JTF_DATE_TABLE
48: , p6_a39 JTF_NUMBER_TABLE

Line 46: , p6_a37 JTF_NUMBER_TABLE

42: , p6_a33 JTF_VARCHAR2_TABLE_500
43: , p6_a34 JTF_VARCHAR2_TABLE_500
44: , p6_a35 JTF_NUMBER_TABLE
45: , p6_a36 JTF_DATE_TABLE
46: , p6_a37 JTF_NUMBER_TABLE
47: , p6_a38 JTF_DATE_TABLE
48: , p6_a39 JTF_NUMBER_TABLE
49: , p6_a40 JTF_VARCHAR2_TABLE_100
50: , p6_a41 JTF_VARCHAR2_TABLE_500

Line 48: , p6_a39 JTF_NUMBER_TABLE

44: , p6_a35 JTF_NUMBER_TABLE
45: , p6_a36 JTF_DATE_TABLE
46: , p6_a37 JTF_NUMBER_TABLE
47: , p6_a38 JTF_DATE_TABLE
48: , p6_a39 JTF_NUMBER_TABLE
49: , p6_a40 JTF_VARCHAR2_TABLE_100
50: , p6_a41 JTF_VARCHAR2_TABLE_500
51: , p6_a42 JTF_VARCHAR2_TABLE_500
52: , p6_a43 JTF_VARCHAR2_TABLE_500

Line 69: , p6_a60 JTF_NUMBER_TABLE

65: , p6_a56 JTF_VARCHAR2_TABLE_100
66: , p6_a57 JTF_VARCHAR2_TABLE_100
67: , p6_a58 JTF_VARCHAR2_TABLE_100
68: , p6_a59 JTF_VARCHAR2_TABLE_100
69: , p6_a60 JTF_NUMBER_TABLE
70: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
71: , p7_a1 out nocopy JTF_NUMBER_TABLE
72: , p7_a2 out nocopy JTF_NUMBER_TABLE
73: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 71: , p7_a1 out nocopy JTF_NUMBER_TABLE

67: , p6_a58 JTF_VARCHAR2_TABLE_100
68: , p6_a59 JTF_VARCHAR2_TABLE_100
69: , p6_a60 JTF_NUMBER_TABLE
70: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
71: , p7_a1 out nocopy JTF_NUMBER_TABLE
72: , p7_a2 out nocopy JTF_NUMBER_TABLE
73: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
75: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 72: , p7_a2 out nocopy JTF_NUMBER_TABLE

68: , p6_a59 JTF_VARCHAR2_TABLE_100
69: , p6_a60 JTF_NUMBER_TABLE
70: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
71: , p7_a1 out nocopy JTF_NUMBER_TABLE
72: , p7_a2 out nocopy JTF_NUMBER_TABLE
73: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
75: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
76: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 83: , p7_a13 out nocopy JTF_NUMBER_TABLE

79: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_200
80: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
81: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
82: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a13 out nocopy JTF_NUMBER_TABLE
84: , p7_a14 out nocopy JTF_NUMBER_TABLE
85: , p7_a15 out nocopy JTF_NUMBER_TABLE
86: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
87: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 84: , p7_a14 out nocopy JTF_NUMBER_TABLE

80: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
81: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
82: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a13 out nocopy JTF_NUMBER_TABLE
84: , p7_a14 out nocopy JTF_NUMBER_TABLE
85: , p7_a15 out nocopy JTF_NUMBER_TABLE
86: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
87: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
88: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , p7_a15 out nocopy JTF_NUMBER_TABLE

81: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
82: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a13 out nocopy JTF_NUMBER_TABLE
84: , p7_a14 out nocopy JTF_NUMBER_TABLE
85: , p7_a15 out nocopy JTF_NUMBER_TABLE
86: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
87: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
88: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
89: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 105: , p7_a35 out nocopy JTF_NUMBER_TABLE

101: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_500
102: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_500
103: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
104: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
105: , p7_a35 out nocopy JTF_NUMBER_TABLE
106: , p7_a36 out nocopy JTF_DATE_TABLE
107: , p7_a37 out nocopy JTF_NUMBER_TABLE
108: , p7_a38 out nocopy JTF_DATE_TABLE
109: , p7_a39 out nocopy JTF_NUMBER_TABLE

Line 107: , p7_a37 out nocopy JTF_NUMBER_TABLE

103: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
104: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
105: , p7_a35 out nocopy JTF_NUMBER_TABLE
106: , p7_a36 out nocopy JTF_DATE_TABLE
107: , p7_a37 out nocopy JTF_NUMBER_TABLE
108: , p7_a38 out nocopy JTF_DATE_TABLE
109: , p7_a39 out nocopy JTF_NUMBER_TABLE
110: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
111: , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 109: , p7_a39 out nocopy JTF_NUMBER_TABLE

105: , p7_a35 out nocopy JTF_NUMBER_TABLE
106: , p7_a36 out nocopy JTF_DATE_TABLE
107: , p7_a37 out nocopy JTF_NUMBER_TABLE
108: , p7_a38 out nocopy JTF_DATE_TABLE
109: , p7_a39 out nocopy JTF_NUMBER_TABLE
110: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
111: , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500
112: , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
113: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 130: , p7_a60 out nocopy JTF_NUMBER_TABLE

126: , p7_a56 out nocopy JTF_VARCHAR2_TABLE_100
127: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
128: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
129: , p7_a59 out nocopy JTF_VARCHAR2_TABLE_100
130: , p7_a60 out nocopy JTF_NUMBER_TABLE
131: );
132: procedure insert_opt_rul_tmp(p_api_version NUMBER
133: , p_init_msg_list VARCHAR2
134: , x_return_status out nocopy VARCHAR2

Line 267: , p5_a1 JTF_NUMBER_TABLE

263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_VARCHAR2_TABLE_100
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_VARCHAR2_TABLE_100
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 268: , p5_a2 JTF_NUMBER_TABLE

264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_VARCHAR2_TABLE_100
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_VARCHAR2_TABLE_100
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_100
272: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 279: , p5_a13 JTF_NUMBER_TABLE

275: , p5_a9 JTF_VARCHAR2_TABLE_200
276: , p5_a10 JTF_VARCHAR2_TABLE_100
277: , p5_a11 JTF_VARCHAR2_TABLE_100
278: , p5_a12 JTF_VARCHAR2_TABLE_100
279: , p5_a13 JTF_NUMBER_TABLE
280: , p5_a14 JTF_NUMBER_TABLE
281: , p5_a15 JTF_NUMBER_TABLE
282: , p5_a16 JTF_VARCHAR2_TABLE_100
283: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 280: , p5_a14 JTF_NUMBER_TABLE

276: , p5_a10 JTF_VARCHAR2_TABLE_100
277: , p5_a11 JTF_VARCHAR2_TABLE_100
278: , p5_a12 JTF_VARCHAR2_TABLE_100
279: , p5_a13 JTF_NUMBER_TABLE
280: , p5_a14 JTF_NUMBER_TABLE
281: , p5_a15 JTF_NUMBER_TABLE
282: , p5_a16 JTF_VARCHAR2_TABLE_100
283: , p5_a17 JTF_VARCHAR2_TABLE_2000
284: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 281: , p5_a15 JTF_NUMBER_TABLE

277: , p5_a11 JTF_VARCHAR2_TABLE_100
278: , p5_a12 JTF_VARCHAR2_TABLE_100
279: , p5_a13 JTF_NUMBER_TABLE
280: , p5_a14 JTF_NUMBER_TABLE
281: , p5_a15 JTF_NUMBER_TABLE
282: , p5_a16 JTF_VARCHAR2_TABLE_100
283: , p5_a17 JTF_VARCHAR2_TABLE_2000
284: , p5_a18 JTF_VARCHAR2_TABLE_100
285: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 301: , p5_a35 JTF_NUMBER_TABLE

297: , p5_a31 JTF_VARCHAR2_TABLE_500
298: , p5_a32 JTF_VARCHAR2_TABLE_500
299: , p5_a33 JTF_VARCHAR2_TABLE_500
300: , p5_a34 JTF_VARCHAR2_TABLE_500
301: , p5_a35 JTF_NUMBER_TABLE
302: , p5_a36 JTF_DATE_TABLE
303: , p5_a37 JTF_NUMBER_TABLE
304: , p5_a38 JTF_DATE_TABLE
305: , p5_a39 JTF_NUMBER_TABLE

Line 303: , p5_a37 JTF_NUMBER_TABLE

299: , p5_a33 JTF_VARCHAR2_TABLE_500
300: , p5_a34 JTF_VARCHAR2_TABLE_500
301: , p5_a35 JTF_NUMBER_TABLE
302: , p5_a36 JTF_DATE_TABLE
303: , p5_a37 JTF_NUMBER_TABLE
304: , p5_a38 JTF_DATE_TABLE
305: , p5_a39 JTF_NUMBER_TABLE
306: , p5_a40 JTF_VARCHAR2_TABLE_100
307: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 305: , p5_a39 JTF_NUMBER_TABLE

301: , p5_a35 JTF_NUMBER_TABLE
302: , p5_a36 JTF_DATE_TABLE
303: , p5_a37 JTF_NUMBER_TABLE
304: , p5_a38 JTF_DATE_TABLE
305: , p5_a39 JTF_NUMBER_TABLE
306: , p5_a40 JTF_VARCHAR2_TABLE_100
307: , p5_a41 JTF_VARCHAR2_TABLE_500
308: , p5_a42 JTF_VARCHAR2_TABLE_500
309: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 326: , p5_a60 JTF_NUMBER_TABLE

322: , p5_a56 JTF_VARCHAR2_TABLE_100
323: , p5_a57 JTF_VARCHAR2_TABLE_100
324: , p5_a58 JTF_VARCHAR2_TABLE_100
325: , p5_a59 JTF_VARCHAR2_TABLE_100
326: , p5_a60 JTF_NUMBER_TABLE
327: );
328: procedure lock_opt_rul_tmp(p_api_version NUMBER
329: , p_init_msg_list VARCHAR2
330: , x_return_status out nocopy VARCHAR2

Line 401: , p5_a1 JTF_NUMBER_TABLE

397: , x_return_status out nocopy VARCHAR2
398: , x_msg_count out nocopy NUMBER
399: , x_msg_data out nocopy VARCHAR2
400: , p5_a0 JTF_VARCHAR2_TABLE_100
401: , p5_a1 JTF_NUMBER_TABLE
402: , p5_a2 JTF_NUMBER_TABLE
403: , p5_a3 JTF_VARCHAR2_TABLE_100
404: , p5_a4 JTF_VARCHAR2_TABLE_100
405: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 402: , p5_a2 JTF_NUMBER_TABLE

398: , x_msg_count out nocopy NUMBER
399: , x_msg_data out nocopy VARCHAR2
400: , p5_a0 JTF_VARCHAR2_TABLE_100
401: , p5_a1 JTF_NUMBER_TABLE
402: , p5_a2 JTF_NUMBER_TABLE
403: , p5_a3 JTF_VARCHAR2_TABLE_100
404: , p5_a4 JTF_VARCHAR2_TABLE_100
405: , p5_a5 JTF_VARCHAR2_TABLE_100
406: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 413: , p5_a13 JTF_NUMBER_TABLE

409: , p5_a9 JTF_VARCHAR2_TABLE_200
410: , p5_a10 JTF_VARCHAR2_TABLE_100
411: , p5_a11 JTF_VARCHAR2_TABLE_100
412: , p5_a12 JTF_VARCHAR2_TABLE_100
413: , p5_a13 JTF_NUMBER_TABLE
414: , p5_a14 JTF_NUMBER_TABLE
415: , p5_a15 JTF_NUMBER_TABLE
416: , p5_a16 JTF_VARCHAR2_TABLE_100
417: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 414: , p5_a14 JTF_NUMBER_TABLE

410: , p5_a10 JTF_VARCHAR2_TABLE_100
411: , p5_a11 JTF_VARCHAR2_TABLE_100
412: , p5_a12 JTF_VARCHAR2_TABLE_100
413: , p5_a13 JTF_NUMBER_TABLE
414: , p5_a14 JTF_NUMBER_TABLE
415: , p5_a15 JTF_NUMBER_TABLE
416: , p5_a16 JTF_VARCHAR2_TABLE_100
417: , p5_a17 JTF_VARCHAR2_TABLE_2000
418: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 415: , p5_a15 JTF_NUMBER_TABLE

411: , p5_a11 JTF_VARCHAR2_TABLE_100
412: , p5_a12 JTF_VARCHAR2_TABLE_100
413: , p5_a13 JTF_NUMBER_TABLE
414: , p5_a14 JTF_NUMBER_TABLE
415: , p5_a15 JTF_NUMBER_TABLE
416: , p5_a16 JTF_VARCHAR2_TABLE_100
417: , p5_a17 JTF_VARCHAR2_TABLE_2000
418: , p5_a18 JTF_VARCHAR2_TABLE_100
419: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 435: , p5_a35 JTF_NUMBER_TABLE

431: , p5_a31 JTF_VARCHAR2_TABLE_500
432: , p5_a32 JTF_VARCHAR2_TABLE_500
433: , p5_a33 JTF_VARCHAR2_TABLE_500
434: , p5_a34 JTF_VARCHAR2_TABLE_500
435: , p5_a35 JTF_NUMBER_TABLE
436: , p5_a36 JTF_DATE_TABLE
437: , p5_a37 JTF_NUMBER_TABLE
438: , p5_a38 JTF_DATE_TABLE
439: , p5_a39 JTF_NUMBER_TABLE

Line 437: , p5_a37 JTF_NUMBER_TABLE

433: , p5_a33 JTF_VARCHAR2_TABLE_500
434: , p5_a34 JTF_VARCHAR2_TABLE_500
435: , p5_a35 JTF_NUMBER_TABLE
436: , p5_a36 JTF_DATE_TABLE
437: , p5_a37 JTF_NUMBER_TABLE
438: , p5_a38 JTF_DATE_TABLE
439: , p5_a39 JTF_NUMBER_TABLE
440: , p5_a40 JTF_VARCHAR2_TABLE_100
441: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 439: , p5_a39 JTF_NUMBER_TABLE

435: , p5_a35 JTF_NUMBER_TABLE
436: , p5_a36 JTF_DATE_TABLE
437: , p5_a37 JTF_NUMBER_TABLE
438: , p5_a38 JTF_DATE_TABLE
439: , p5_a39 JTF_NUMBER_TABLE
440: , p5_a40 JTF_VARCHAR2_TABLE_100
441: , p5_a41 JTF_VARCHAR2_TABLE_500
442: , p5_a42 JTF_VARCHAR2_TABLE_500
443: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 460: , p5_a60 JTF_NUMBER_TABLE

456: , p5_a56 JTF_VARCHAR2_TABLE_100
457: , p5_a57 JTF_VARCHAR2_TABLE_100
458: , p5_a58 JTF_VARCHAR2_TABLE_100
459: , p5_a59 JTF_VARCHAR2_TABLE_100
460: , p5_a60 JTF_NUMBER_TABLE
461: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a1 out nocopy JTF_NUMBER_TABLE
463: , p6_a2 out nocopy JTF_NUMBER_TABLE
464: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 462: , p6_a1 out nocopy JTF_NUMBER_TABLE

458: , p5_a58 JTF_VARCHAR2_TABLE_100
459: , p5_a59 JTF_VARCHAR2_TABLE_100
460: , p5_a60 JTF_NUMBER_TABLE
461: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a1 out nocopy JTF_NUMBER_TABLE
463: , p6_a2 out nocopy JTF_NUMBER_TABLE
464: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 463: , p6_a2 out nocopy JTF_NUMBER_TABLE

459: , p5_a59 JTF_VARCHAR2_TABLE_100
460: , p5_a60 JTF_NUMBER_TABLE
461: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a1 out nocopy JTF_NUMBER_TABLE
463: , p6_a2 out nocopy JTF_NUMBER_TABLE
464: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 474: , p6_a13 out nocopy JTF_NUMBER_TABLE

470: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
471: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
473: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
474: , p6_a13 out nocopy JTF_NUMBER_TABLE
475: , p6_a14 out nocopy JTF_NUMBER_TABLE
476: , p6_a15 out nocopy JTF_NUMBER_TABLE
477: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 475: , p6_a14 out nocopy JTF_NUMBER_TABLE

471: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
473: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
474: , p6_a13 out nocopy JTF_NUMBER_TABLE
475: , p6_a14 out nocopy JTF_NUMBER_TABLE
476: , p6_a15 out nocopy JTF_NUMBER_TABLE
477: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
479: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 476: , p6_a15 out nocopy JTF_NUMBER_TABLE

472: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
473: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
474: , p6_a13 out nocopy JTF_NUMBER_TABLE
475: , p6_a14 out nocopy JTF_NUMBER_TABLE
476: , p6_a15 out nocopy JTF_NUMBER_TABLE
477: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
479: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
480: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 496: , p6_a35 out nocopy JTF_NUMBER_TABLE

492: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
493: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
494: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
495: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
496: , p6_a35 out nocopy JTF_NUMBER_TABLE
497: , p6_a36 out nocopy JTF_DATE_TABLE
498: , p6_a37 out nocopy JTF_NUMBER_TABLE
499: , p6_a38 out nocopy JTF_DATE_TABLE
500: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 498: , p6_a37 out nocopy JTF_NUMBER_TABLE

494: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
495: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
496: , p6_a35 out nocopy JTF_NUMBER_TABLE
497: , p6_a36 out nocopy JTF_DATE_TABLE
498: , p6_a37 out nocopy JTF_NUMBER_TABLE
499: , p6_a38 out nocopy JTF_DATE_TABLE
500: , p6_a39 out nocopy JTF_NUMBER_TABLE
501: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 500: , p6_a39 out nocopy JTF_NUMBER_TABLE

496: , p6_a35 out nocopy JTF_NUMBER_TABLE
497: , p6_a36 out nocopy JTF_DATE_TABLE
498: , p6_a37 out nocopy JTF_NUMBER_TABLE
499: , p6_a38 out nocopy JTF_DATE_TABLE
500: , p6_a39 out nocopy JTF_NUMBER_TABLE
501: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
503: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 521: , p6_a60 out nocopy JTF_NUMBER_TABLE

517: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
518: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
521: , p6_a60 out nocopy JTF_NUMBER_TABLE
522: );
523: procedure update_opt_rul_tmp(p_api_version NUMBER
524: , p_init_msg_list VARCHAR2
525: , x_return_status out nocopy VARCHAR2

Line 657: , p5_a1 JTF_NUMBER_TABLE

653: , x_return_status out nocopy VARCHAR2
654: , x_msg_count out nocopy NUMBER
655: , x_msg_data out nocopy VARCHAR2
656: , p5_a0 JTF_VARCHAR2_TABLE_100
657: , p5_a1 JTF_NUMBER_TABLE
658: , p5_a2 JTF_NUMBER_TABLE
659: , p5_a3 JTF_VARCHAR2_TABLE_100
660: , p5_a4 JTF_VARCHAR2_TABLE_100
661: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 658: , p5_a2 JTF_NUMBER_TABLE

654: , x_msg_count out nocopy NUMBER
655: , x_msg_data out nocopy VARCHAR2
656: , p5_a0 JTF_VARCHAR2_TABLE_100
657: , p5_a1 JTF_NUMBER_TABLE
658: , p5_a2 JTF_NUMBER_TABLE
659: , p5_a3 JTF_VARCHAR2_TABLE_100
660: , p5_a4 JTF_VARCHAR2_TABLE_100
661: , p5_a5 JTF_VARCHAR2_TABLE_100
662: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 669: , p5_a13 JTF_NUMBER_TABLE

665: , p5_a9 JTF_VARCHAR2_TABLE_200
666: , p5_a10 JTF_VARCHAR2_TABLE_100
667: , p5_a11 JTF_VARCHAR2_TABLE_100
668: , p5_a12 JTF_VARCHAR2_TABLE_100
669: , p5_a13 JTF_NUMBER_TABLE
670: , p5_a14 JTF_NUMBER_TABLE
671: , p5_a15 JTF_NUMBER_TABLE
672: , p5_a16 JTF_VARCHAR2_TABLE_100
673: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 670: , p5_a14 JTF_NUMBER_TABLE

666: , p5_a10 JTF_VARCHAR2_TABLE_100
667: , p5_a11 JTF_VARCHAR2_TABLE_100
668: , p5_a12 JTF_VARCHAR2_TABLE_100
669: , p5_a13 JTF_NUMBER_TABLE
670: , p5_a14 JTF_NUMBER_TABLE
671: , p5_a15 JTF_NUMBER_TABLE
672: , p5_a16 JTF_VARCHAR2_TABLE_100
673: , p5_a17 JTF_VARCHAR2_TABLE_2000
674: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 671: , p5_a15 JTF_NUMBER_TABLE

667: , p5_a11 JTF_VARCHAR2_TABLE_100
668: , p5_a12 JTF_VARCHAR2_TABLE_100
669: , p5_a13 JTF_NUMBER_TABLE
670: , p5_a14 JTF_NUMBER_TABLE
671: , p5_a15 JTF_NUMBER_TABLE
672: , p5_a16 JTF_VARCHAR2_TABLE_100
673: , p5_a17 JTF_VARCHAR2_TABLE_2000
674: , p5_a18 JTF_VARCHAR2_TABLE_100
675: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 691: , p5_a35 JTF_NUMBER_TABLE

687: , p5_a31 JTF_VARCHAR2_TABLE_500
688: , p5_a32 JTF_VARCHAR2_TABLE_500
689: , p5_a33 JTF_VARCHAR2_TABLE_500
690: , p5_a34 JTF_VARCHAR2_TABLE_500
691: , p5_a35 JTF_NUMBER_TABLE
692: , p5_a36 JTF_DATE_TABLE
693: , p5_a37 JTF_NUMBER_TABLE
694: , p5_a38 JTF_DATE_TABLE
695: , p5_a39 JTF_NUMBER_TABLE

Line 693: , p5_a37 JTF_NUMBER_TABLE

689: , p5_a33 JTF_VARCHAR2_TABLE_500
690: , p5_a34 JTF_VARCHAR2_TABLE_500
691: , p5_a35 JTF_NUMBER_TABLE
692: , p5_a36 JTF_DATE_TABLE
693: , p5_a37 JTF_NUMBER_TABLE
694: , p5_a38 JTF_DATE_TABLE
695: , p5_a39 JTF_NUMBER_TABLE
696: , p5_a40 JTF_VARCHAR2_TABLE_100
697: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 695: , p5_a39 JTF_NUMBER_TABLE

691: , p5_a35 JTF_NUMBER_TABLE
692: , p5_a36 JTF_DATE_TABLE
693: , p5_a37 JTF_NUMBER_TABLE
694: , p5_a38 JTF_DATE_TABLE
695: , p5_a39 JTF_NUMBER_TABLE
696: , p5_a40 JTF_VARCHAR2_TABLE_100
697: , p5_a41 JTF_VARCHAR2_TABLE_500
698: , p5_a42 JTF_VARCHAR2_TABLE_500
699: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 716: , p5_a60 JTF_NUMBER_TABLE

712: , p5_a56 JTF_VARCHAR2_TABLE_100
713: , p5_a57 JTF_VARCHAR2_TABLE_100
714: , p5_a58 JTF_VARCHAR2_TABLE_100
715: , p5_a59 JTF_VARCHAR2_TABLE_100
716: , p5_a60 JTF_NUMBER_TABLE
717: );
718: procedure delete_opt_rul_tmp(p_api_version NUMBER
719: , p_init_msg_list VARCHAR2
720: , x_return_status out nocopy VARCHAR2

Line 791: , p5_a1 JTF_NUMBER_TABLE

787: , x_return_status out nocopy VARCHAR2
788: , x_msg_count out nocopy NUMBER
789: , x_msg_data out nocopy VARCHAR2
790: , p5_a0 JTF_VARCHAR2_TABLE_100
791: , p5_a1 JTF_NUMBER_TABLE
792: , p5_a2 JTF_NUMBER_TABLE
793: , p5_a3 JTF_VARCHAR2_TABLE_100
794: , p5_a4 JTF_VARCHAR2_TABLE_100
795: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 792: , p5_a2 JTF_NUMBER_TABLE

788: , x_msg_count out nocopy NUMBER
789: , x_msg_data out nocopy VARCHAR2
790: , p5_a0 JTF_VARCHAR2_TABLE_100
791: , p5_a1 JTF_NUMBER_TABLE
792: , p5_a2 JTF_NUMBER_TABLE
793: , p5_a3 JTF_VARCHAR2_TABLE_100
794: , p5_a4 JTF_VARCHAR2_TABLE_100
795: , p5_a5 JTF_VARCHAR2_TABLE_100
796: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 803: , p5_a13 JTF_NUMBER_TABLE

799: , p5_a9 JTF_VARCHAR2_TABLE_200
800: , p5_a10 JTF_VARCHAR2_TABLE_100
801: , p5_a11 JTF_VARCHAR2_TABLE_100
802: , p5_a12 JTF_VARCHAR2_TABLE_100
803: , p5_a13 JTF_NUMBER_TABLE
804: , p5_a14 JTF_NUMBER_TABLE
805: , p5_a15 JTF_NUMBER_TABLE
806: , p5_a16 JTF_VARCHAR2_TABLE_100
807: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 804: , p5_a14 JTF_NUMBER_TABLE

800: , p5_a10 JTF_VARCHAR2_TABLE_100
801: , p5_a11 JTF_VARCHAR2_TABLE_100
802: , p5_a12 JTF_VARCHAR2_TABLE_100
803: , p5_a13 JTF_NUMBER_TABLE
804: , p5_a14 JTF_NUMBER_TABLE
805: , p5_a15 JTF_NUMBER_TABLE
806: , p5_a16 JTF_VARCHAR2_TABLE_100
807: , p5_a17 JTF_VARCHAR2_TABLE_2000
808: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 805: , p5_a15 JTF_NUMBER_TABLE

801: , p5_a11 JTF_VARCHAR2_TABLE_100
802: , p5_a12 JTF_VARCHAR2_TABLE_100
803: , p5_a13 JTF_NUMBER_TABLE
804: , p5_a14 JTF_NUMBER_TABLE
805: , p5_a15 JTF_NUMBER_TABLE
806: , p5_a16 JTF_VARCHAR2_TABLE_100
807: , p5_a17 JTF_VARCHAR2_TABLE_2000
808: , p5_a18 JTF_VARCHAR2_TABLE_100
809: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 825: , p5_a35 JTF_NUMBER_TABLE

821: , p5_a31 JTF_VARCHAR2_TABLE_500
822: , p5_a32 JTF_VARCHAR2_TABLE_500
823: , p5_a33 JTF_VARCHAR2_TABLE_500
824: , p5_a34 JTF_VARCHAR2_TABLE_500
825: , p5_a35 JTF_NUMBER_TABLE
826: , p5_a36 JTF_DATE_TABLE
827: , p5_a37 JTF_NUMBER_TABLE
828: , p5_a38 JTF_DATE_TABLE
829: , p5_a39 JTF_NUMBER_TABLE

Line 827: , p5_a37 JTF_NUMBER_TABLE

823: , p5_a33 JTF_VARCHAR2_TABLE_500
824: , p5_a34 JTF_VARCHAR2_TABLE_500
825: , p5_a35 JTF_NUMBER_TABLE
826: , p5_a36 JTF_DATE_TABLE
827: , p5_a37 JTF_NUMBER_TABLE
828: , p5_a38 JTF_DATE_TABLE
829: , p5_a39 JTF_NUMBER_TABLE
830: , p5_a40 JTF_VARCHAR2_TABLE_100
831: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 829: , p5_a39 JTF_NUMBER_TABLE

825: , p5_a35 JTF_NUMBER_TABLE
826: , p5_a36 JTF_DATE_TABLE
827: , p5_a37 JTF_NUMBER_TABLE
828: , p5_a38 JTF_DATE_TABLE
829: , p5_a39 JTF_NUMBER_TABLE
830: , p5_a40 JTF_VARCHAR2_TABLE_100
831: , p5_a41 JTF_VARCHAR2_TABLE_500
832: , p5_a42 JTF_VARCHAR2_TABLE_500
833: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 850: , p5_a60 JTF_NUMBER_TABLE

846: , p5_a56 JTF_VARCHAR2_TABLE_100
847: , p5_a57 JTF_VARCHAR2_TABLE_100
848: , p5_a58 JTF_VARCHAR2_TABLE_100
849: , p5_a59 JTF_VARCHAR2_TABLE_100
850: , p5_a60 JTF_NUMBER_TABLE
851: );
852: procedure validate_opt_rul_tmp(p_api_version NUMBER
853: , p_init_msg_list VARCHAR2
854: , x_return_status out nocopy VARCHAR2