APPS.OKL_OPT_RUL_TMP_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 9: , p6_a0 JTF_VARCHAR2_TABLE_100

5: , x_return_status out nocopy VARCHAR2
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

Line 12: , p6_a3 JTF_VARCHAR2_TABLE_100

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
16: , p6_a7 JTF_VARCHAR2_TABLE_200

Line 13: , p6_a4 JTF_VARCHAR2_TABLE_100

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
16: , p6_a7 JTF_VARCHAR2_TABLE_200
17: , p6_a8 JTF_VARCHAR2_TABLE_200

Line 14: , p6_a5 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
16: , p6_a7 JTF_VARCHAR2_TABLE_200
17: , p6_a8 JTF_VARCHAR2_TABLE_200
18: , p6_a9 JTF_VARCHAR2_TABLE_200

Line 15: , p6_a6 JTF_VARCHAR2_TABLE_100

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
16: , p6_a7 JTF_VARCHAR2_TABLE_200
17: , p6_a8 JTF_VARCHAR2_TABLE_200
18: , p6_a9 JTF_VARCHAR2_TABLE_200
19: , p6_a10 JTF_VARCHAR2_TABLE_100

Line 19: , p6_a10 JTF_VARCHAR2_TABLE_100

15: , p6_a6 JTF_VARCHAR2_TABLE_100
16: , p6_a7 JTF_VARCHAR2_TABLE_200
17: , p6_a8 JTF_VARCHAR2_TABLE_200
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

Line 20: , p6_a11 JTF_VARCHAR2_TABLE_100

16: , p6_a7 JTF_VARCHAR2_TABLE_200
17: , p6_a8 JTF_VARCHAR2_TABLE_200
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

Line 21: , p6_a12 JTF_VARCHAR2_TABLE_100

17: , p6_a8 JTF_VARCHAR2_TABLE_200
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

Line 25: , p6_a16 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
29: , p6_a20 JTF_VARCHAR2_TABLE_500

Line 27: , p6_a18 JTF_VARCHAR2_TABLE_100

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
29: , p6_a20 JTF_VARCHAR2_TABLE_500
30: , p6_a21 JTF_VARCHAR2_TABLE_500
31: , p6_a22 JTF_VARCHAR2_TABLE_500

Line 28: , p6_a19 JTF_VARCHAR2_TABLE_100

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
29: , p6_a20 JTF_VARCHAR2_TABLE_500
30: , p6_a21 JTF_VARCHAR2_TABLE_500
31: , p6_a22 JTF_VARCHAR2_TABLE_500
32: , p6_a23 JTF_VARCHAR2_TABLE_500

Line 49: , p6_a40 JTF_VARCHAR2_TABLE_100

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
53: , p6_a44 JTF_VARCHAR2_TABLE_500

Line 65: , p6_a56 JTF_VARCHAR2_TABLE_100

61: , p6_a52 JTF_VARCHAR2_TABLE_500
62: , p6_a53 JTF_VARCHAR2_TABLE_500
63: , p6_a54 JTF_VARCHAR2_TABLE_500
64: , p6_a55 JTF_VARCHAR2_TABLE_500
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

Line 66: , p6_a57 JTF_VARCHAR2_TABLE_100

62: , p6_a53 JTF_VARCHAR2_TABLE_500
63: , p6_a54 JTF_VARCHAR2_TABLE_500
64: , p6_a55 JTF_VARCHAR2_TABLE_500
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

Line 67: , p6_a58 JTF_VARCHAR2_TABLE_100

63: , p6_a54 JTF_VARCHAR2_TABLE_500
64: , p6_a55 JTF_VARCHAR2_TABLE_500
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

Line 68: , p6_a59 JTF_VARCHAR2_TABLE_100

64: , p6_a55 JTF_VARCHAR2_TABLE_500
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

Line 70: , p7_a0 out nocopy 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
74: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 73: , p7_a3 out nocopy 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
77: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 74: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
77: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_200
78: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 75: , p7_a5 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
77: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_200
78: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
79: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 76: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
77: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_200
78: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
79: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_200
80: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

76: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
77: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_200
78: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
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

Line 81: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100

77: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_200
78: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
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

Line 82: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100

78: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
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

Line 86: , p7_a16 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
90: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 88: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

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
90: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
91: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
92: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 89: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

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
90: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
91: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
92: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
93: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 110: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100

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
114: , p7_a44 out nocopy JTF_VARCHAR2_TABLE_500

Line 126: , p7_a56 out nocopy JTF_VARCHAR2_TABLE_100

122: , p7_a52 out nocopy JTF_VARCHAR2_TABLE_500
123: , p7_a53 out nocopy JTF_VARCHAR2_TABLE_500
124: , p7_a54 out nocopy JTF_VARCHAR2_TABLE_500
125: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_500
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

Line 127: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100

123: , p7_a53 out nocopy JTF_VARCHAR2_TABLE_500
124: , p7_a54 out nocopy JTF_VARCHAR2_TABLE_500
125: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_500
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: );

Line 128: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100

124: , p7_a54 out nocopy JTF_VARCHAR2_TABLE_500
125: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_500
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

Line 129: , p7_a59 out nocopy JTF_VARCHAR2_TABLE_100

125: , p7_a55 out nocopy JTF_VARCHAR2_TABLE_500
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

Line 266: , p5_a0 JTF_VARCHAR2_TABLE_100

262: , p_init_msg_list VARCHAR2
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

Line 269: , p5_a3 JTF_VARCHAR2_TABLE_100

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
273: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 270: , p5_a4 JTF_VARCHAR2_TABLE_100

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
273: , p5_a7 JTF_VARCHAR2_TABLE_200
274: , p5_a8 JTF_VARCHAR2_TABLE_200

Line 271: , p5_a5 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
273: , p5_a7 JTF_VARCHAR2_TABLE_200
274: , p5_a8 JTF_VARCHAR2_TABLE_200
275: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 272: , p5_a6 JTF_VARCHAR2_TABLE_100

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
273: , p5_a7 JTF_VARCHAR2_TABLE_200
274: , p5_a8 JTF_VARCHAR2_TABLE_200
275: , p5_a9 JTF_VARCHAR2_TABLE_200
276: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 276: , p5_a10 JTF_VARCHAR2_TABLE_100

272: , p5_a6 JTF_VARCHAR2_TABLE_100
273: , p5_a7 JTF_VARCHAR2_TABLE_200
274: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 277: , p5_a11 JTF_VARCHAR2_TABLE_100

273: , p5_a7 JTF_VARCHAR2_TABLE_200
274: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 278: , p5_a12 JTF_VARCHAR2_TABLE_100

274: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 282: , p5_a16 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
286: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 284: , p5_a18 JTF_VARCHAR2_TABLE_100

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
286: , p5_a20 JTF_VARCHAR2_TABLE_500
287: , p5_a21 JTF_VARCHAR2_TABLE_500
288: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 285: , p5_a19 JTF_VARCHAR2_TABLE_100

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
286: , p5_a20 JTF_VARCHAR2_TABLE_500
287: , p5_a21 JTF_VARCHAR2_TABLE_500
288: , p5_a22 JTF_VARCHAR2_TABLE_500
289: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 306: , p5_a40 JTF_VARCHAR2_TABLE_100

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
310: , p5_a44 JTF_VARCHAR2_TABLE_500

Line 322: , p5_a56 JTF_VARCHAR2_TABLE_100

318: , p5_a52 JTF_VARCHAR2_TABLE_500
319: , p5_a53 JTF_VARCHAR2_TABLE_500
320: , p5_a54 JTF_VARCHAR2_TABLE_500
321: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 323: , p5_a57 JTF_VARCHAR2_TABLE_100

319: , p5_a53 JTF_VARCHAR2_TABLE_500
320: , p5_a54 JTF_VARCHAR2_TABLE_500
321: , p5_a55 JTF_VARCHAR2_TABLE_500
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: );

Line 324: , p5_a58 JTF_VARCHAR2_TABLE_100

320: , p5_a54 JTF_VARCHAR2_TABLE_500
321: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 325: , p5_a59 JTF_VARCHAR2_TABLE_100

321: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 400: , p5_a0 JTF_VARCHAR2_TABLE_100

396: , p_init_msg_list VARCHAR2
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

Line 403: , p5_a3 JTF_VARCHAR2_TABLE_100

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
407: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 404: , p5_a4 JTF_VARCHAR2_TABLE_100

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
407: , p5_a7 JTF_VARCHAR2_TABLE_200
408: , p5_a8 JTF_VARCHAR2_TABLE_200

Line 405: , p5_a5 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
407: , p5_a7 JTF_VARCHAR2_TABLE_200
408: , p5_a8 JTF_VARCHAR2_TABLE_200
409: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 406: , p5_a6 JTF_VARCHAR2_TABLE_100

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
407: , p5_a7 JTF_VARCHAR2_TABLE_200
408: , p5_a8 JTF_VARCHAR2_TABLE_200
409: , p5_a9 JTF_VARCHAR2_TABLE_200
410: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 410: , p5_a10 JTF_VARCHAR2_TABLE_100

406: , p5_a6 JTF_VARCHAR2_TABLE_100
407: , p5_a7 JTF_VARCHAR2_TABLE_200
408: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 411: , p5_a11 JTF_VARCHAR2_TABLE_100

407: , p5_a7 JTF_VARCHAR2_TABLE_200
408: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 412: , p5_a12 JTF_VARCHAR2_TABLE_100

408: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 416: , p5_a16 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
420: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 418: , p5_a18 JTF_VARCHAR2_TABLE_100

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
420: , p5_a20 JTF_VARCHAR2_TABLE_500
421: , p5_a21 JTF_VARCHAR2_TABLE_500
422: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 419: , p5_a19 JTF_VARCHAR2_TABLE_100

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
420: , p5_a20 JTF_VARCHAR2_TABLE_500
421: , p5_a21 JTF_VARCHAR2_TABLE_500
422: , p5_a22 JTF_VARCHAR2_TABLE_500
423: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 440: , p5_a40 JTF_VARCHAR2_TABLE_100

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
444: , p5_a44 JTF_VARCHAR2_TABLE_500

Line 456: , p5_a56 JTF_VARCHAR2_TABLE_100

452: , p5_a52 JTF_VARCHAR2_TABLE_500
453: , p5_a53 JTF_VARCHAR2_TABLE_500
454: , p5_a54 JTF_VARCHAR2_TABLE_500
455: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 457: , p5_a57 JTF_VARCHAR2_TABLE_100

453: , p5_a53 JTF_VARCHAR2_TABLE_500
454: , p5_a54 JTF_VARCHAR2_TABLE_500
455: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 458: , p5_a58 JTF_VARCHAR2_TABLE_100

454: , p5_a54 JTF_VARCHAR2_TABLE_500
455: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 459: , p5_a59 JTF_VARCHAR2_TABLE_100

455: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 461: , p6_a0 out nocopy 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
465: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 464: , p6_a3 out nocopy 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
468: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 465: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
468: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
469: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 466: , p6_a5 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
468: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
469: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
470: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 467: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
468: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
469: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
470: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
471: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 471: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

467: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
469: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
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

Line 472: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

468: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
469: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
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

Line 473: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

469: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
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

Line 477: , p6_a16 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
481: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 479: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

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
481: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
482: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
483: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 480: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

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
481: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
482: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
483: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
484: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 501: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

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
505: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500

Line 517: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100

513: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
514: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
516: , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
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

Line 518: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100

514: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
516: , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
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: );

Line 519: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100

515: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
516: , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
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

Line 520: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100

516: , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
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

Line 656: , p5_a0 JTF_VARCHAR2_TABLE_100

652: , p_init_msg_list VARCHAR2
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

Line 659: , p5_a3 JTF_VARCHAR2_TABLE_100

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
663: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 660: , p5_a4 JTF_VARCHAR2_TABLE_100

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
663: , p5_a7 JTF_VARCHAR2_TABLE_200
664: , p5_a8 JTF_VARCHAR2_TABLE_200

Line 661: , p5_a5 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
663: , p5_a7 JTF_VARCHAR2_TABLE_200
664: , p5_a8 JTF_VARCHAR2_TABLE_200
665: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 662: , p5_a6 JTF_VARCHAR2_TABLE_100

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
663: , p5_a7 JTF_VARCHAR2_TABLE_200
664: , p5_a8 JTF_VARCHAR2_TABLE_200
665: , p5_a9 JTF_VARCHAR2_TABLE_200
666: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 666: , p5_a10 JTF_VARCHAR2_TABLE_100

662: , p5_a6 JTF_VARCHAR2_TABLE_100
663: , p5_a7 JTF_VARCHAR2_TABLE_200
664: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 667: , p5_a11 JTF_VARCHAR2_TABLE_100

663: , p5_a7 JTF_VARCHAR2_TABLE_200
664: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 668: , p5_a12 JTF_VARCHAR2_TABLE_100

664: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 672: , p5_a16 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
676: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 674: , p5_a18 JTF_VARCHAR2_TABLE_100

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
676: , p5_a20 JTF_VARCHAR2_TABLE_500
677: , p5_a21 JTF_VARCHAR2_TABLE_500
678: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 675: , p5_a19 JTF_VARCHAR2_TABLE_100

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
676: , p5_a20 JTF_VARCHAR2_TABLE_500
677: , p5_a21 JTF_VARCHAR2_TABLE_500
678: , p5_a22 JTF_VARCHAR2_TABLE_500
679: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 696: , p5_a40 JTF_VARCHAR2_TABLE_100

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
700: , p5_a44 JTF_VARCHAR2_TABLE_500

Line 712: , p5_a56 JTF_VARCHAR2_TABLE_100

708: , p5_a52 JTF_VARCHAR2_TABLE_500
709: , p5_a53 JTF_VARCHAR2_TABLE_500
710: , p5_a54 JTF_VARCHAR2_TABLE_500
711: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 713: , p5_a57 JTF_VARCHAR2_TABLE_100

709: , p5_a53 JTF_VARCHAR2_TABLE_500
710: , p5_a54 JTF_VARCHAR2_TABLE_500
711: , p5_a55 JTF_VARCHAR2_TABLE_500
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: );

Line 714: , p5_a58 JTF_VARCHAR2_TABLE_100

710: , p5_a54 JTF_VARCHAR2_TABLE_500
711: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 715: , p5_a59 JTF_VARCHAR2_TABLE_100

711: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 790: , p5_a0 JTF_VARCHAR2_TABLE_100

786: , p_init_msg_list VARCHAR2
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

Line 793: , p5_a3 JTF_VARCHAR2_TABLE_100

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
797: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 794: , p5_a4 JTF_VARCHAR2_TABLE_100

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
797: , p5_a7 JTF_VARCHAR2_TABLE_200
798: , p5_a8 JTF_VARCHAR2_TABLE_200

Line 795: , p5_a5 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
797: , p5_a7 JTF_VARCHAR2_TABLE_200
798: , p5_a8 JTF_VARCHAR2_TABLE_200
799: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 796: , p5_a6 JTF_VARCHAR2_TABLE_100

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
797: , p5_a7 JTF_VARCHAR2_TABLE_200
798: , p5_a8 JTF_VARCHAR2_TABLE_200
799: , p5_a9 JTF_VARCHAR2_TABLE_200
800: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 800: , p5_a10 JTF_VARCHAR2_TABLE_100

796: , p5_a6 JTF_VARCHAR2_TABLE_100
797: , p5_a7 JTF_VARCHAR2_TABLE_200
798: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 801: , p5_a11 JTF_VARCHAR2_TABLE_100

797: , p5_a7 JTF_VARCHAR2_TABLE_200
798: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 802: , p5_a12 JTF_VARCHAR2_TABLE_100

798: , p5_a8 JTF_VARCHAR2_TABLE_200
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

Line 806: , p5_a16 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
810: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 808: , p5_a18 JTF_VARCHAR2_TABLE_100

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
810: , p5_a20 JTF_VARCHAR2_TABLE_500
811: , p5_a21 JTF_VARCHAR2_TABLE_500
812: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 809: , p5_a19 JTF_VARCHAR2_TABLE_100

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
810: , p5_a20 JTF_VARCHAR2_TABLE_500
811: , p5_a21 JTF_VARCHAR2_TABLE_500
812: , p5_a22 JTF_VARCHAR2_TABLE_500
813: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 830: , p5_a40 JTF_VARCHAR2_TABLE_100

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
834: , p5_a44 JTF_VARCHAR2_TABLE_500

Line 846: , p5_a56 JTF_VARCHAR2_TABLE_100

842: , p5_a52 JTF_VARCHAR2_TABLE_500
843: , p5_a53 JTF_VARCHAR2_TABLE_500
844: , p5_a54 JTF_VARCHAR2_TABLE_500
845: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 847: , p5_a57 JTF_VARCHAR2_TABLE_100

843: , p5_a53 JTF_VARCHAR2_TABLE_500
844: , p5_a54 JTF_VARCHAR2_TABLE_500
845: , p5_a55 JTF_VARCHAR2_TABLE_500
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: );

Line 848: , p5_a58 JTF_VARCHAR2_TABLE_100

844: , p5_a54 JTF_VARCHAR2_TABLE_500
845: , p5_a55 JTF_VARCHAR2_TABLE_500
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

Line 849: , p5_a59 JTF_VARCHAR2_TABLE_100

845: , p5_a55 JTF_VARCHAR2_TABLE_500
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