APPS.OKL_SIL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLISILS.pls 120.2 2005/10/11 06:37:57 rgooty noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sil_pvt.sil_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100

Line 17: , a14 JTF_VARCHAR2_TABLE_100

13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE

Line 18: , a15 JTF_VARCHAR2_TABLE_100

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_VARCHAR2_TABLE_500
37: , a34 JTF_NUMBER_TABLE

Line 56: , a53 JTF_VARCHAR2_TABLE_100

52: , a49 JTF_DATE_TABLE
53: , a50 JTF_NUMBER_TABLE
54: , a51 JTF_NUMBER_TABLE
55: , a52 JTF_NUMBER_TABLE
56: , a53 JTF_VARCHAR2_TABLE_100
57: , a54 JTF_NUMBER_TABLE
58: , a55 JTF_NUMBER_TABLE
59: , a56 JTF_DATE_TABLE
60: , a57 JTF_DATE_TABLE

Line 64: , a61 JTF_VARCHAR2_TABLE_100

60: , a57 JTF_DATE_TABLE
61: , a58 JTF_NUMBER_TABLE
62: , a59 JTF_VARCHAR2_TABLE_200
63: , a60 JTF_NUMBER_TABLE
64: , a61 JTF_VARCHAR2_TABLE_100
65: );
66: procedure rosetta_table_copy_out_p2(t okl_sil_pvt.sil_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE
68: , a2 out nocopy JTF_NUMBER_TABLE

Line 69: , a3 out nocopy JTF_VARCHAR2_TABLE_100

65: );
66: procedure rosetta_table_copy_out_p2(t okl_sil_pvt.sil_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE
68: , a2 out nocopy JTF_NUMBER_TABLE
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: , a4 out nocopy JTF_DATE_TABLE
71: , a5 out nocopy JTF_NUMBER_TABLE
72: , a6 out nocopy JTF_NUMBER_TABLE
73: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 73: , a7 out nocopy JTF_VARCHAR2_TABLE_100

69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: , a4 out nocopy JTF_DATE_TABLE
71: , a5 out nocopy JTF_NUMBER_TABLE
72: , a6 out nocopy JTF_NUMBER_TABLE
73: , a7 out nocopy JTF_VARCHAR2_TABLE_100
74: , a8 out nocopy JTF_NUMBER_TABLE
75: , a9 out nocopy JTF_VARCHAR2_TABLE_100
76: , a10 out nocopy JTF_VARCHAR2_TABLE_100
77: , a11 out nocopy JTF_NUMBER_TABLE

Line 75: , a9 out nocopy JTF_VARCHAR2_TABLE_100

71: , a5 out nocopy JTF_NUMBER_TABLE
72: , a6 out nocopy JTF_NUMBER_TABLE
73: , a7 out nocopy JTF_VARCHAR2_TABLE_100
74: , a8 out nocopy JTF_NUMBER_TABLE
75: , a9 out nocopy JTF_VARCHAR2_TABLE_100
76: , a10 out nocopy JTF_VARCHAR2_TABLE_100
77: , a11 out nocopy JTF_NUMBER_TABLE
78: , a12 out nocopy JTF_NUMBER_TABLE
79: , a13 out nocopy JTF_NUMBER_TABLE

Line 76: , a10 out nocopy JTF_VARCHAR2_TABLE_100

72: , a6 out nocopy JTF_NUMBER_TABLE
73: , a7 out nocopy JTF_VARCHAR2_TABLE_100
74: , a8 out nocopy JTF_NUMBER_TABLE
75: , a9 out nocopy JTF_VARCHAR2_TABLE_100
76: , a10 out nocopy JTF_VARCHAR2_TABLE_100
77: , a11 out nocopy JTF_NUMBER_TABLE
78: , a12 out nocopy JTF_NUMBER_TABLE
79: , a13 out nocopy JTF_NUMBER_TABLE
80: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , a14 out nocopy JTF_VARCHAR2_TABLE_100

76: , a10 out nocopy JTF_VARCHAR2_TABLE_100
77: , a11 out nocopy JTF_NUMBER_TABLE
78: , a12 out nocopy JTF_NUMBER_TABLE
79: , a13 out nocopy JTF_NUMBER_TABLE
80: , a14 out nocopy JTF_VARCHAR2_TABLE_100
81: , a15 out nocopy JTF_VARCHAR2_TABLE_100
82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 out nocopy JTF_NUMBER_TABLE
84: , a18 out nocopy JTF_DATE_TABLE

Line 81: , a15 out nocopy JTF_VARCHAR2_TABLE_100

77: , a11 out nocopy JTF_NUMBER_TABLE
78: , a12 out nocopy JTF_NUMBER_TABLE
79: , a13 out nocopy JTF_NUMBER_TABLE
80: , a14 out nocopy JTF_VARCHAR2_TABLE_100
81: , a15 out nocopy JTF_VARCHAR2_TABLE_100
82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 out nocopy JTF_NUMBER_TABLE
84: , a18 out nocopy JTF_DATE_TABLE
85: , a19 out nocopy JTF_NUMBER_TABLE

Line 86: , a20 out nocopy JTF_VARCHAR2_TABLE_100

82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 out nocopy JTF_NUMBER_TABLE
84: , a18 out nocopy JTF_DATE_TABLE
85: , a19 out nocopy JTF_NUMBER_TABLE
86: , a20 out nocopy JTF_VARCHAR2_TABLE_100
87: , a21 out nocopy JTF_NUMBER_TABLE
88: , a22 out nocopy JTF_NUMBER_TABLE
89: , a23 out nocopy JTF_NUMBER_TABLE
90: , a24 out nocopy JTF_DATE_TABLE

Line 96: , a30 out nocopy JTF_VARCHAR2_TABLE_100

92: , a26 out nocopy JTF_NUMBER_TABLE
93: , a27 out nocopy JTF_DATE_TABLE
94: , a28 out nocopy JTF_DATE_TABLE
95: , a29 out nocopy JTF_DATE_TABLE
96: , a30 out nocopy JTF_VARCHAR2_TABLE_100
97: , a31 out nocopy JTF_VARCHAR2_TABLE_500
98: , a32 out nocopy JTF_VARCHAR2_TABLE_500
99: , a33 out nocopy JTF_VARCHAR2_TABLE_500
100: , a34 out nocopy JTF_NUMBER_TABLE

Line 119: , a53 out nocopy JTF_VARCHAR2_TABLE_100

115: , a49 out nocopy JTF_DATE_TABLE
116: , a50 out nocopy JTF_NUMBER_TABLE
117: , a51 out nocopy JTF_NUMBER_TABLE
118: , a52 out nocopy JTF_NUMBER_TABLE
119: , a53 out nocopy JTF_VARCHAR2_TABLE_100
120: , a54 out nocopy JTF_NUMBER_TABLE
121: , a55 out nocopy JTF_NUMBER_TABLE
122: , a56 out nocopy JTF_DATE_TABLE
123: , a57 out nocopy JTF_DATE_TABLE

Line 127: , a61 out nocopy JTF_VARCHAR2_TABLE_100

123: , a57 out nocopy JTF_DATE_TABLE
124: , a58 out nocopy JTF_NUMBER_TABLE
125: , a59 out nocopy JTF_VARCHAR2_TABLE_200
126: , a60 out nocopy JTF_NUMBER_TABLE
127: , a61 out nocopy JTF_VARCHAR2_TABLE_100
128: );
129:
130: procedure rosetta_table_copy_in_p5(t out nocopy okl_sil_pvt.silv_tbl_type, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE

Line 133: , a3 JTF_VARCHAR2_TABLE_100

129:
130: procedure rosetta_table_copy_in_p5(t out nocopy okl_sil_pvt.silv_tbl_type, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_NUMBER_TABLE
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_DATE_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_NUMBER_TABLE
137: , a7 JTF_VARCHAR2_TABLE_100

Line 137: , a7 JTF_VARCHAR2_TABLE_100

133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_DATE_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_NUMBER_TABLE
137: , a7 JTF_VARCHAR2_TABLE_100
138: , a8 JTF_NUMBER_TABLE
139: , a9 JTF_VARCHAR2_TABLE_100
140: , a10 JTF_VARCHAR2_TABLE_100
141: , a11 JTF_NUMBER_TABLE

Line 139: , a9 JTF_VARCHAR2_TABLE_100

135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_NUMBER_TABLE
137: , a7 JTF_VARCHAR2_TABLE_100
138: , a8 JTF_NUMBER_TABLE
139: , a9 JTF_VARCHAR2_TABLE_100
140: , a10 JTF_VARCHAR2_TABLE_100
141: , a11 JTF_NUMBER_TABLE
142: , a12 JTF_NUMBER_TABLE
143: , a13 JTF_NUMBER_TABLE

Line 140: , a10 JTF_VARCHAR2_TABLE_100

136: , a6 JTF_NUMBER_TABLE
137: , a7 JTF_VARCHAR2_TABLE_100
138: , a8 JTF_NUMBER_TABLE
139: , a9 JTF_VARCHAR2_TABLE_100
140: , a10 JTF_VARCHAR2_TABLE_100
141: , a11 JTF_NUMBER_TABLE
142: , a12 JTF_NUMBER_TABLE
143: , a13 JTF_NUMBER_TABLE
144: , a14 JTF_VARCHAR2_TABLE_100

Line 144: , a14 JTF_VARCHAR2_TABLE_100

140: , a10 JTF_VARCHAR2_TABLE_100
141: , a11 JTF_NUMBER_TABLE
142: , a12 JTF_NUMBER_TABLE
143: , a13 JTF_NUMBER_TABLE
144: , a14 JTF_VARCHAR2_TABLE_100
145: , a15 JTF_VARCHAR2_TABLE_100
146: , a16 JTF_NUMBER_TABLE
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_DATE_TABLE

Line 145: , a15 JTF_VARCHAR2_TABLE_100

141: , a11 JTF_NUMBER_TABLE
142: , a12 JTF_NUMBER_TABLE
143: , a13 JTF_NUMBER_TABLE
144: , a14 JTF_VARCHAR2_TABLE_100
145: , a15 JTF_VARCHAR2_TABLE_100
146: , a16 JTF_NUMBER_TABLE
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_DATE_TABLE
149: , a19 JTF_NUMBER_TABLE

Line 150: , a20 JTF_VARCHAR2_TABLE_100

146: , a16 JTF_NUMBER_TABLE
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_DATE_TABLE
149: , a19 JTF_NUMBER_TABLE
150: , a20 JTF_VARCHAR2_TABLE_100
151: , a21 JTF_NUMBER_TABLE
152: , a22 JTF_NUMBER_TABLE
153: , a23 JTF_NUMBER_TABLE
154: , a24 JTF_DATE_TABLE

Line 160: , a30 JTF_VARCHAR2_TABLE_100

156: , a26 JTF_NUMBER_TABLE
157: , a27 JTF_DATE_TABLE
158: , a28 JTF_DATE_TABLE
159: , a29 JTF_DATE_TABLE
160: , a30 JTF_VARCHAR2_TABLE_100
161: , a31 JTF_VARCHAR2_TABLE_500
162: , a32 JTF_VARCHAR2_TABLE_500
163: , a33 JTF_VARCHAR2_TABLE_500
164: , a34 JTF_NUMBER_TABLE

Line 183: , a53 JTF_VARCHAR2_TABLE_100

179: , a49 JTF_DATE_TABLE
180: , a50 JTF_NUMBER_TABLE
181: , a51 JTF_NUMBER_TABLE
182: , a52 JTF_NUMBER_TABLE
183: , a53 JTF_VARCHAR2_TABLE_100
184: , a54 JTF_NUMBER_TABLE
185: , a55 JTF_NUMBER_TABLE
186: , a56 JTF_DATE_TABLE
187: , a57 JTF_DATE_TABLE

Line 191: , a61 JTF_VARCHAR2_TABLE_100

187: , a57 JTF_DATE_TABLE
188: , a58 JTF_NUMBER_TABLE
189: , a59 JTF_VARCHAR2_TABLE_200
190: , a60 JTF_NUMBER_TABLE
191: , a61 JTF_VARCHAR2_TABLE_100
192: );
193: procedure rosetta_table_copy_out_p5(t okl_sil_pvt.silv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_NUMBER_TABLE

Line 196: , a3 out nocopy JTF_VARCHAR2_TABLE_100

192: );
193: procedure rosetta_table_copy_out_p5(t okl_sil_pvt.silv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_NUMBER_TABLE
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_DATE_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_NUMBER_TABLE
200: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 200: , a7 out nocopy JTF_VARCHAR2_TABLE_100

196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_DATE_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_NUMBER_TABLE
200: , a7 out nocopy JTF_VARCHAR2_TABLE_100
201: , a8 out nocopy JTF_NUMBER_TABLE
202: , a9 out nocopy JTF_VARCHAR2_TABLE_100
203: , a10 out nocopy JTF_VARCHAR2_TABLE_100
204: , a11 out nocopy JTF_NUMBER_TABLE

Line 202: , a9 out nocopy JTF_VARCHAR2_TABLE_100

198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_NUMBER_TABLE
200: , a7 out nocopy JTF_VARCHAR2_TABLE_100
201: , a8 out nocopy JTF_NUMBER_TABLE
202: , a9 out nocopy JTF_VARCHAR2_TABLE_100
203: , a10 out nocopy JTF_VARCHAR2_TABLE_100
204: , a11 out nocopy JTF_NUMBER_TABLE
205: , a12 out nocopy JTF_NUMBER_TABLE
206: , a13 out nocopy JTF_NUMBER_TABLE

Line 203: , a10 out nocopy JTF_VARCHAR2_TABLE_100

199: , a6 out nocopy JTF_NUMBER_TABLE
200: , a7 out nocopy JTF_VARCHAR2_TABLE_100
201: , a8 out nocopy JTF_NUMBER_TABLE
202: , a9 out nocopy JTF_VARCHAR2_TABLE_100
203: , a10 out nocopy JTF_VARCHAR2_TABLE_100
204: , a11 out nocopy JTF_NUMBER_TABLE
205: , a12 out nocopy JTF_NUMBER_TABLE
206: , a13 out nocopy JTF_NUMBER_TABLE
207: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 207: , a14 out nocopy JTF_VARCHAR2_TABLE_100

203: , a10 out nocopy JTF_VARCHAR2_TABLE_100
204: , a11 out nocopy JTF_NUMBER_TABLE
205: , a12 out nocopy JTF_NUMBER_TABLE
206: , a13 out nocopy JTF_NUMBER_TABLE
207: , a14 out nocopy JTF_VARCHAR2_TABLE_100
208: , a15 out nocopy JTF_VARCHAR2_TABLE_100
209: , a16 out nocopy JTF_NUMBER_TABLE
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_DATE_TABLE

Line 208: , a15 out nocopy JTF_VARCHAR2_TABLE_100

204: , a11 out nocopy JTF_NUMBER_TABLE
205: , a12 out nocopy JTF_NUMBER_TABLE
206: , a13 out nocopy JTF_NUMBER_TABLE
207: , a14 out nocopy JTF_VARCHAR2_TABLE_100
208: , a15 out nocopy JTF_VARCHAR2_TABLE_100
209: , a16 out nocopy JTF_NUMBER_TABLE
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_DATE_TABLE
212: , a19 out nocopy JTF_NUMBER_TABLE

Line 213: , a20 out nocopy JTF_VARCHAR2_TABLE_100

209: , a16 out nocopy JTF_NUMBER_TABLE
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_DATE_TABLE
212: , a19 out nocopy JTF_NUMBER_TABLE
213: , a20 out nocopy JTF_VARCHAR2_TABLE_100
214: , a21 out nocopy JTF_NUMBER_TABLE
215: , a22 out nocopy JTF_NUMBER_TABLE
216: , a23 out nocopy JTF_NUMBER_TABLE
217: , a24 out nocopy JTF_DATE_TABLE

Line 223: , a30 out nocopy JTF_VARCHAR2_TABLE_100

219: , a26 out nocopy JTF_NUMBER_TABLE
220: , a27 out nocopy JTF_DATE_TABLE
221: , a28 out nocopy JTF_DATE_TABLE
222: , a29 out nocopy JTF_DATE_TABLE
223: , a30 out nocopy JTF_VARCHAR2_TABLE_100
224: , a31 out nocopy JTF_VARCHAR2_TABLE_500
225: , a32 out nocopy JTF_VARCHAR2_TABLE_500
226: , a33 out nocopy JTF_VARCHAR2_TABLE_500
227: , a34 out nocopy JTF_NUMBER_TABLE

Line 246: , a53 out nocopy JTF_VARCHAR2_TABLE_100

242: , a49 out nocopy JTF_DATE_TABLE
243: , a50 out nocopy JTF_NUMBER_TABLE
244: , a51 out nocopy JTF_NUMBER_TABLE
245: , a52 out nocopy JTF_NUMBER_TABLE
246: , a53 out nocopy JTF_VARCHAR2_TABLE_100
247: , a54 out nocopy JTF_NUMBER_TABLE
248: , a55 out nocopy JTF_NUMBER_TABLE
249: , a56 out nocopy JTF_DATE_TABLE
250: , a57 out nocopy JTF_DATE_TABLE

Line 254: , a61 out nocopy JTF_VARCHAR2_TABLE_100

250: , a57 out nocopy JTF_DATE_TABLE
251: , a58 out nocopy JTF_NUMBER_TABLE
252: , a59 out nocopy JTF_VARCHAR2_TABLE_200
253: , a60 out nocopy JTF_NUMBER_TABLE
254: , a61 out nocopy JTF_VARCHAR2_TABLE_100
255: );
256:
257: procedure insert_row(p_api_version NUMBER
258: , p_init_msg_list VARCHAR2

Line 395: , p5_a3 JTF_VARCHAR2_TABLE_100

391: , x_msg_data out nocopy VARCHAR2
392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_NUMBER_TABLE
394: , p5_a2 JTF_NUMBER_TABLE
395: , p5_a3 JTF_VARCHAR2_TABLE_100
396: , p5_a4 JTF_DATE_TABLE
397: , p5_a5 JTF_NUMBER_TABLE
398: , p5_a6 JTF_NUMBER_TABLE
399: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 399: , p5_a7 JTF_VARCHAR2_TABLE_100

395: , p5_a3 JTF_VARCHAR2_TABLE_100
396: , p5_a4 JTF_DATE_TABLE
397: , p5_a5 JTF_NUMBER_TABLE
398: , p5_a6 JTF_NUMBER_TABLE
399: , p5_a7 JTF_VARCHAR2_TABLE_100
400: , p5_a8 JTF_NUMBER_TABLE
401: , p5_a9 JTF_VARCHAR2_TABLE_100
402: , p5_a10 JTF_VARCHAR2_TABLE_100
403: , p5_a11 JTF_NUMBER_TABLE

Line 401: , p5_a9 JTF_VARCHAR2_TABLE_100

397: , p5_a5 JTF_NUMBER_TABLE
398: , p5_a6 JTF_NUMBER_TABLE
399: , p5_a7 JTF_VARCHAR2_TABLE_100
400: , p5_a8 JTF_NUMBER_TABLE
401: , p5_a9 JTF_VARCHAR2_TABLE_100
402: , p5_a10 JTF_VARCHAR2_TABLE_100
403: , p5_a11 JTF_NUMBER_TABLE
404: , p5_a12 JTF_NUMBER_TABLE
405: , p5_a13 JTF_NUMBER_TABLE

Line 402: , p5_a10 JTF_VARCHAR2_TABLE_100

398: , p5_a6 JTF_NUMBER_TABLE
399: , p5_a7 JTF_VARCHAR2_TABLE_100
400: , p5_a8 JTF_NUMBER_TABLE
401: , p5_a9 JTF_VARCHAR2_TABLE_100
402: , p5_a10 JTF_VARCHAR2_TABLE_100
403: , p5_a11 JTF_NUMBER_TABLE
404: , p5_a12 JTF_NUMBER_TABLE
405: , p5_a13 JTF_NUMBER_TABLE
406: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 406: , p5_a14 JTF_VARCHAR2_TABLE_100

402: , p5_a10 JTF_VARCHAR2_TABLE_100
403: , p5_a11 JTF_NUMBER_TABLE
404: , p5_a12 JTF_NUMBER_TABLE
405: , p5_a13 JTF_NUMBER_TABLE
406: , p5_a14 JTF_VARCHAR2_TABLE_100
407: , p5_a15 JTF_VARCHAR2_TABLE_100
408: , p5_a16 JTF_NUMBER_TABLE
409: , p5_a17 JTF_NUMBER_TABLE
410: , p5_a18 JTF_DATE_TABLE

Line 407: , p5_a15 JTF_VARCHAR2_TABLE_100

403: , p5_a11 JTF_NUMBER_TABLE
404: , p5_a12 JTF_NUMBER_TABLE
405: , p5_a13 JTF_NUMBER_TABLE
406: , p5_a14 JTF_VARCHAR2_TABLE_100
407: , p5_a15 JTF_VARCHAR2_TABLE_100
408: , p5_a16 JTF_NUMBER_TABLE
409: , p5_a17 JTF_NUMBER_TABLE
410: , p5_a18 JTF_DATE_TABLE
411: , p5_a19 JTF_NUMBER_TABLE

Line 412: , p5_a20 JTF_VARCHAR2_TABLE_100

408: , p5_a16 JTF_NUMBER_TABLE
409: , p5_a17 JTF_NUMBER_TABLE
410: , p5_a18 JTF_DATE_TABLE
411: , p5_a19 JTF_NUMBER_TABLE
412: , p5_a20 JTF_VARCHAR2_TABLE_100
413: , p5_a21 JTF_NUMBER_TABLE
414: , p5_a22 JTF_NUMBER_TABLE
415: , p5_a23 JTF_NUMBER_TABLE
416: , p5_a24 JTF_DATE_TABLE

Line 422: , p5_a30 JTF_VARCHAR2_TABLE_100

418: , p5_a26 JTF_NUMBER_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_DATE_TABLE
421: , p5_a29 JTF_DATE_TABLE
422: , p5_a30 JTF_VARCHAR2_TABLE_100
423: , p5_a31 JTF_VARCHAR2_TABLE_500
424: , p5_a32 JTF_VARCHAR2_TABLE_500
425: , p5_a33 JTF_VARCHAR2_TABLE_500
426: , p5_a34 JTF_NUMBER_TABLE

Line 445: , p5_a53 JTF_VARCHAR2_TABLE_100

441: , p5_a49 JTF_DATE_TABLE
442: , p5_a50 JTF_NUMBER_TABLE
443: , p5_a51 JTF_NUMBER_TABLE
444: , p5_a52 JTF_NUMBER_TABLE
445: , p5_a53 JTF_VARCHAR2_TABLE_100
446: , p5_a54 JTF_NUMBER_TABLE
447: , p5_a55 JTF_NUMBER_TABLE
448: , p5_a56 JTF_DATE_TABLE
449: , p5_a57 JTF_DATE_TABLE

Line 453: , p5_a61 JTF_VARCHAR2_TABLE_100

449: , p5_a57 JTF_DATE_TABLE
450: , p5_a58 JTF_NUMBER_TABLE
451: , p5_a59 JTF_VARCHAR2_TABLE_200
452: , p5_a60 JTF_NUMBER_TABLE
453: , p5_a61 JTF_VARCHAR2_TABLE_100
454: , p6_a0 out nocopy JTF_NUMBER_TABLE
455: , p6_a1 out nocopy JTF_NUMBER_TABLE
456: , p6_a2 out nocopy JTF_NUMBER_TABLE
457: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 457: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

453: , p5_a61 JTF_VARCHAR2_TABLE_100
454: , p6_a0 out nocopy JTF_NUMBER_TABLE
455: , p6_a1 out nocopy JTF_NUMBER_TABLE
456: , p6_a2 out nocopy JTF_NUMBER_TABLE
457: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
458: , p6_a4 out nocopy JTF_DATE_TABLE
459: , p6_a5 out nocopy JTF_NUMBER_TABLE
460: , p6_a6 out nocopy JTF_NUMBER_TABLE
461: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 461: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

457: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
458: , p6_a4 out nocopy JTF_DATE_TABLE
459: , p6_a5 out nocopy JTF_NUMBER_TABLE
460: , p6_a6 out nocopy JTF_NUMBER_TABLE
461: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a8 out nocopy JTF_NUMBER_TABLE
463: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
465: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 463: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

459: , p6_a5 out nocopy JTF_NUMBER_TABLE
460: , p6_a6 out nocopy JTF_NUMBER_TABLE
461: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a8 out nocopy JTF_NUMBER_TABLE
463: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
465: , p6_a11 out nocopy JTF_NUMBER_TABLE
466: , p6_a12 out nocopy JTF_NUMBER_TABLE
467: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 464: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

460: , p6_a6 out nocopy JTF_NUMBER_TABLE
461: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a8 out nocopy JTF_NUMBER_TABLE
463: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
465: , p6_a11 out nocopy JTF_NUMBER_TABLE
466: , p6_a12 out nocopy JTF_NUMBER_TABLE
467: , p6_a13 out nocopy JTF_NUMBER_TABLE
468: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 468: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

464: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
465: , p6_a11 out nocopy JTF_NUMBER_TABLE
466: , p6_a12 out nocopy JTF_NUMBER_TABLE
467: , p6_a13 out nocopy JTF_NUMBER_TABLE
468: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a16 out nocopy JTF_NUMBER_TABLE
471: , p6_a17 out nocopy JTF_NUMBER_TABLE
472: , p6_a18 out nocopy JTF_DATE_TABLE

Line 469: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

465: , p6_a11 out nocopy JTF_NUMBER_TABLE
466: , p6_a12 out nocopy JTF_NUMBER_TABLE
467: , p6_a13 out nocopy JTF_NUMBER_TABLE
468: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a16 out nocopy JTF_NUMBER_TABLE
471: , p6_a17 out nocopy JTF_NUMBER_TABLE
472: , p6_a18 out nocopy JTF_DATE_TABLE
473: , p6_a19 out nocopy JTF_NUMBER_TABLE

Line 474: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

470: , p6_a16 out nocopy JTF_NUMBER_TABLE
471: , p6_a17 out nocopy JTF_NUMBER_TABLE
472: , p6_a18 out nocopy JTF_DATE_TABLE
473: , p6_a19 out nocopy JTF_NUMBER_TABLE
474: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
475: , p6_a21 out nocopy JTF_NUMBER_TABLE
476: , p6_a22 out nocopy JTF_NUMBER_TABLE
477: , p6_a23 out nocopy JTF_NUMBER_TABLE
478: , p6_a24 out nocopy JTF_DATE_TABLE

Line 484: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

480: , p6_a26 out nocopy JTF_NUMBER_TABLE
481: , p6_a27 out nocopy JTF_DATE_TABLE
482: , p6_a28 out nocopy JTF_DATE_TABLE
483: , p6_a29 out nocopy JTF_DATE_TABLE
484: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
485: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
486: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
487: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
488: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 507: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100

503: , p6_a49 out nocopy JTF_DATE_TABLE
504: , p6_a50 out nocopy JTF_NUMBER_TABLE
505: , p6_a51 out nocopy JTF_NUMBER_TABLE
506: , p6_a52 out nocopy JTF_NUMBER_TABLE
507: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a54 out nocopy JTF_NUMBER_TABLE
509: , p6_a55 out nocopy JTF_NUMBER_TABLE
510: , p6_a56 out nocopy JTF_DATE_TABLE
511: , p6_a57 out nocopy JTF_DATE_TABLE

Line 515: , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100

511: , p6_a57 out nocopy JTF_DATE_TABLE
512: , p6_a58 out nocopy JTF_NUMBER_TABLE
513: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
514: , p6_a60 out nocopy JTF_NUMBER_TABLE
515: , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
516: );
517: procedure lock_row(p_api_version NUMBER
518: , p_init_msg_list VARCHAR2
519: , x_return_status out nocopy VARCHAR2

Line 593: , p5_a3 JTF_VARCHAR2_TABLE_100

589: , x_msg_data out nocopy VARCHAR2
590: , p5_a0 JTF_NUMBER_TABLE
591: , p5_a1 JTF_NUMBER_TABLE
592: , p5_a2 JTF_NUMBER_TABLE
593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_DATE_TABLE
595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 597: , p5_a7 JTF_VARCHAR2_TABLE_100

593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_DATE_TABLE
595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_VARCHAR2_TABLE_100
598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_VARCHAR2_TABLE_100
600: , p5_a10 JTF_VARCHAR2_TABLE_100
601: , p5_a11 JTF_NUMBER_TABLE

Line 599: , p5_a9 JTF_VARCHAR2_TABLE_100

595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_VARCHAR2_TABLE_100
598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_VARCHAR2_TABLE_100
600: , p5_a10 JTF_VARCHAR2_TABLE_100
601: , p5_a11 JTF_NUMBER_TABLE
602: , p5_a12 JTF_NUMBER_TABLE
603: , p5_a13 JTF_NUMBER_TABLE

Line 600: , p5_a10 JTF_VARCHAR2_TABLE_100

596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_VARCHAR2_TABLE_100
598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_VARCHAR2_TABLE_100
600: , p5_a10 JTF_VARCHAR2_TABLE_100
601: , p5_a11 JTF_NUMBER_TABLE
602: , p5_a12 JTF_NUMBER_TABLE
603: , p5_a13 JTF_NUMBER_TABLE
604: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 604: , p5_a14 JTF_VARCHAR2_TABLE_100

600: , p5_a10 JTF_VARCHAR2_TABLE_100
601: , p5_a11 JTF_NUMBER_TABLE
602: , p5_a12 JTF_NUMBER_TABLE
603: , p5_a13 JTF_NUMBER_TABLE
604: , p5_a14 JTF_VARCHAR2_TABLE_100
605: , p5_a15 JTF_VARCHAR2_TABLE_100
606: , p5_a16 JTF_NUMBER_TABLE
607: , p5_a17 JTF_NUMBER_TABLE
608: , p5_a18 JTF_DATE_TABLE

Line 605: , p5_a15 JTF_VARCHAR2_TABLE_100

601: , p5_a11 JTF_NUMBER_TABLE
602: , p5_a12 JTF_NUMBER_TABLE
603: , p5_a13 JTF_NUMBER_TABLE
604: , p5_a14 JTF_VARCHAR2_TABLE_100
605: , p5_a15 JTF_VARCHAR2_TABLE_100
606: , p5_a16 JTF_NUMBER_TABLE
607: , p5_a17 JTF_NUMBER_TABLE
608: , p5_a18 JTF_DATE_TABLE
609: , p5_a19 JTF_NUMBER_TABLE

Line 610: , p5_a20 JTF_VARCHAR2_TABLE_100

606: , p5_a16 JTF_NUMBER_TABLE
607: , p5_a17 JTF_NUMBER_TABLE
608: , p5_a18 JTF_DATE_TABLE
609: , p5_a19 JTF_NUMBER_TABLE
610: , p5_a20 JTF_VARCHAR2_TABLE_100
611: , p5_a21 JTF_NUMBER_TABLE
612: , p5_a22 JTF_NUMBER_TABLE
613: , p5_a23 JTF_NUMBER_TABLE
614: , p5_a24 JTF_DATE_TABLE

Line 620: , p5_a30 JTF_VARCHAR2_TABLE_100

616: , p5_a26 JTF_NUMBER_TABLE
617: , p5_a27 JTF_DATE_TABLE
618: , p5_a28 JTF_DATE_TABLE
619: , p5_a29 JTF_DATE_TABLE
620: , p5_a30 JTF_VARCHAR2_TABLE_100
621: , p5_a31 JTF_VARCHAR2_TABLE_500
622: , p5_a32 JTF_VARCHAR2_TABLE_500
623: , p5_a33 JTF_VARCHAR2_TABLE_500
624: , p5_a34 JTF_NUMBER_TABLE

Line 643: , p5_a53 JTF_VARCHAR2_TABLE_100

639: , p5_a49 JTF_DATE_TABLE
640: , p5_a50 JTF_NUMBER_TABLE
641: , p5_a51 JTF_NUMBER_TABLE
642: , p5_a52 JTF_NUMBER_TABLE
643: , p5_a53 JTF_VARCHAR2_TABLE_100
644: , p5_a54 JTF_NUMBER_TABLE
645: , p5_a55 JTF_NUMBER_TABLE
646: , p5_a56 JTF_DATE_TABLE
647: , p5_a57 JTF_DATE_TABLE

Line 651: , p5_a61 JTF_VARCHAR2_TABLE_100

647: , p5_a57 JTF_DATE_TABLE
648: , p5_a58 JTF_NUMBER_TABLE
649: , p5_a59 JTF_VARCHAR2_TABLE_200
650: , p5_a60 JTF_NUMBER_TABLE
651: , p5_a61 JTF_VARCHAR2_TABLE_100
652: );
653: procedure update_row(p_api_version NUMBER
654: , p_init_msg_list VARCHAR2
655: , x_return_status out nocopy VARCHAR2

Line 791: , p5_a3 JTF_VARCHAR2_TABLE_100

787: , x_msg_data out nocopy VARCHAR2
788: , p5_a0 JTF_NUMBER_TABLE
789: , p5_a1 JTF_NUMBER_TABLE
790: , p5_a2 JTF_NUMBER_TABLE
791: , p5_a3 JTF_VARCHAR2_TABLE_100
792: , p5_a4 JTF_DATE_TABLE
793: , p5_a5 JTF_NUMBER_TABLE
794: , p5_a6 JTF_NUMBER_TABLE
795: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 795: , p5_a7 JTF_VARCHAR2_TABLE_100

791: , p5_a3 JTF_VARCHAR2_TABLE_100
792: , p5_a4 JTF_DATE_TABLE
793: , p5_a5 JTF_NUMBER_TABLE
794: , p5_a6 JTF_NUMBER_TABLE
795: , p5_a7 JTF_VARCHAR2_TABLE_100
796: , p5_a8 JTF_NUMBER_TABLE
797: , p5_a9 JTF_VARCHAR2_TABLE_100
798: , p5_a10 JTF_VARCHAR2_TABLE_100
799: , p5_a11 JTF_NUMBER_TABLE

Line 797: , p5_a9 JTF_VARCHAR2_TABLE_100

793: , p5_a5 JTF_NUMBER_TABLE
794: , p5_a6 JTF_NUMBER_TABLE
795: , p5_a7 JTF_VARCHAR2_TABLE_100
796: , p5_a8 JTF_NUMBER_TABLE
797: , p5_a9 JTF_VARCHAR2_TABLE_100
798: , p5_a10 JTF_VARCHAR2_TABLE_100
799: , p5_a11 JTF_NUMBER_TABLE
800: , p5_a12 JTF_NUMBER_TABLE
801: , p5_a13 JTF_NUMBER_TABLE

Line 798: , p5_a10 JTF_VARCHAR2_TABLE_100

794: , p5_a6 JTF_NUMBER_TABLE
795: , p5_a7 JTF_VARCHAR2_TABLE_100
796: , p5_a8 JTF_NUMBER_TABLE
797: , p5_a9 JTF_VARCHAR2_TABLE_100
798: , p5_a10 JTF_VARCHAR2_TABLE_100
799: , p5_a11 JTF_NUMBER_TABLE
800: , p5_a12 JTF_NUMBER_TABLE
801: , p5_a13 JTF_NUMBER_TABLE
802: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 802: , p5_a14 JTF_VARCHAR2_TABLE_100

798: , p5_a10 JTF_VARCHAR2_TABLE_100
799: , p5_a11 JTF_NUMBER_TABLE
800: , p5_a12 JTF_NUMBER_TABLE
801: , p5_a13 JTF_NUMBER_TABLE
802: , p5_a14 JTF_VARCHAR2_TABLE_100
803: , p5_a15 JTF_VARCHAR2_TABLE_100
804: , p5_a16 JTF_NUMBER_TABLE
805: , p5_a17 JTF_NUMBER_TABLE
806: , p5_a18 JTF_DATE_TABLE

Line 803: , p5_a15 JTF_VARCHAR2_TABLE_100

799: , p5_a11 JTF_NUMBER_TABLE
800: , p5_a12 JTF_NUMBER_TABLE
801: , p5_a13 JTF_NUMBER_TABLE
802: , p5_a14 JTF_VARCHAR2_TABLE_100
803: , p5_a15 JTF_VARCHAR2_TABLE_100
804: , p5_a16 JTF_NUMBER_TABLE
805: , p5_a17 JTF_NUMBER_TABLE
806: , p5_a18 JTF_DATE_TABLE
807: , p5_a19 JTF_NUMBER_TABLE

Line 808: , p5_a20 JTF_VARCHAR2_TABLE_100

804: , p5_a16 JTF_NUMBER_TABLE
805: , p5_a17 JTF_NUMBER_TABLE
806: , p5_a18 JTF_DATE_TABLE
807: , p5_a19 JTF_NUMBER_TABLE
808: , p5_a20 JTF_VARCHAR2_TABLE_100
809: , p5_a21 JTF_NUMBER_TABLE
810: , p5_a22 JTF_NUMBER_TABLE
811: , p5_a23 JTF_NUMBER_TABLE
812: , p5_a24 JTF_DATE_TABLE

Line 818: , p5_a30 JTF_VARCHAR2_TABLE_100

814: , p5_a26 JTF_NUMBER_TABLE
815: , p5_a27 JTF_DATE_TABLE
816: , p5_a28 JTF_DATE_TABLE
817: , p5_a29 JTF_DATE_TABLE
818: , p5_a30 JTF_VARCHAR2_TABLE_100
819: , p5_a31 JTF_VARCHAR2_TABLE_500
820: , p5_a32 JTF_VARCHAR2_TABLE_500
821: , p5_a33 JTF_VARCHAR2_TABLE_500
822: , p5_a34 JTF_NUMBER_TABLE

Line 841: , p5_a53 JTF_VARCHAR2_TABLE_100

837: , p5_a49 JTF_DATE_TABLE
838: , p5_a50 JTF_NUMBER_TABLE
839: , p5_a51 JTF_NUMBER_TABLE
840: , p5_a52 JTF_NUMBER_TABLE
841: , p5_a53 JTF_VARCHAR2_TABLE_100
842: , p5_a54 JTF_NUMBER_TABLE
843: , p5_a55 JTF_NUMBER_TABLE
844: , p5_a56 JTF_DATE_TABLE
845: , p5_a57 JTF_DATE_TABLE

Line 849: , p5_a61 JTF_VARCHAR2_TABLE_100

845: , p5_a57 JTF_DATE_TABLE
846: , p5_a58 JTF_NUMBER_TABLE
847: , p5_a59 JTF_VARCHAR2_TABLE_200
848: , p5_a60 JTF_NUMBER_TABLE
849: , p5_a61 JTF_VARCHAR2_TABLE_100
850: , p6_a0 out nocopy JTF_NUMBER_TABLE
851: , p6_a1 out nocopy JTF_NUMBER_TABLE
852: , p6_a2 out nocopy JTF_NUMBER_TABLE
853: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 853: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

849: , p5_a61 JTF_VARCHAR2_TABLE_100
850: , p6_a0 out nocopy JTF_NUMBER_TABLE
851: , p6_a1 out nocopy JTF_NUMBER_TABLE
852: , p6_a2 out nocopy JTF_NUMBER_TABLE
853: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a4 out nocopy JTF_DATE_TABLE
855: , p6_a5 out nocopy JTF_NUMBER_TABLE
856: , p6_a6 out nocopy JTF_NUMBER_TABLE
857: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 857: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

853: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a4 out nocopy JTF_DATE_TABLE
855: , p6_a5 out nocopy JTF_NUMBER_TABLE
856: , p6_a6 out nocopy JTF_NUMBER_TABLE
857: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
858: , p6_a8 out nocopy JTF_NUMBER_TABLE
859: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 859: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

855: , p6_a5 out nocopy JTF_NUMBER_TABLE
856: , p6_a6 out nocopy JTF_NUMBER_TABLE
857: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
858: , p6_a8 out nocopy JTF_NUMBER_TABLE
859: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a11 out nocopy JTF_NUMBER_TABLE
862: , p6_a12 out nocopy JTF_NUMBER_TABLE
863: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 860: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

856: , p6_a6 out nocopy JTF_NUMBER_TABLE
857: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
858: , p6_a8 out nocopy JTF_NUMBER_TABLE
859: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a11 out nocopy JTF_NUMBER_TABLE
862: , p6_a12 out nocopy JTF_NUMBER_TABLE
863: , p6_a13 out nocopy JTF_NUMBER_TABLE
864: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 864: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

860: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a11 out nocopy JTF_NUMBER_TABLE
862: , p6_a12 out nocopy JTF_NUMBER_TABLE
863: , p6_a13 out nocopy JTF_NUMBER_TABLE
864: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
865: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a16 out nocopy JTF_NUMBER_TABLE
867: , p6_a17 out nocopy JTF_NUMBER_TABLE
868: , p6_a18 out nocopy JTF_DATE_TABLE

Line 865: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

861: , p6_a11 out nocopy JTF_NUMBER_TABLE
862: , p6_a12 out nocopy JTF_NUMBER_TABLE
863: , p6_a13 out nocopy JTF_NUMBER_TABLE
864: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
865: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a16 out nocopy JTF_NUMBER_TABLE
867: , p6_a17 out nocopy JTF_NUMBER_TABLE
868: , p6_a18 out nocopy JTF_DATE_TABLE
869: , p6_a19 out nocopy JTF_NUMBER_TABLE

Line 870: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

866: , p6_a16 out nocopy JTF_NUMBER_TABLE
867: , p6_a17 out nocopy JTF_NUMBER_TABLE
868: , p6_a18 out nocopy JTF_DATE_TABLE
869: , p6_a19 out nocopy JTF_NUMBER_TABLE
870: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a21 out nocopy JTF_NUMBER_TABLE
872: , p6_a22 out nocopy JTF_NUMBER_TABLE
873: , p6_a23 out nocopy JTF_NUMBER_TABLE
874: , p6_a24 out nocopy JTF_DATE_TABLE

Line 880: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

876: , p6_a26 out nocopy JTF_NUMBER_TABLE
877: , p6_a27 out nocopy JTF_DATE_TABLE
878: , p6_a28 out nocopy JTF_DATE_TABLE
879: , p6_a29 out nocopy JTF_DATE_TABLE
880: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
881: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
882: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
883: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
884: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 903: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100

899: , p6_a49 out nocopy JTF_DATE_TABLE
900: , p6_a50 out nocopy JTF_NUMBER_TABLE
901: , p6_a51 out nocopy JTF_NUMBER_TABLE
902: , p6_a52 out nocopy JTF_NUMBER_TABLE
903: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a54 out nocopy JTF_NUMBER_TABLE
905: , p6_a55 out nocopy JTF_NUMBER_TABLE
906: , p6_a56 out nocopy JTF_DATE_TABLE
907: , p6_a57 out nocopy JTF_DATE_TABLE

Line 911: , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100

907: , p6_a57 out nocopy JTF_DATE_TABLE
908: , p6_a58 out nocopy JTF_NUMBER_TABLE
909: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
910: , p6_a60 out nocopy JTF_NUMBER_TABLE
911: , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
912: );
913: procedure delete_row(p_api_version NUMBER
914: , p_init_msg_list VARCHAR2
915: , x_return_status out nocopy VARCHAR2

Line 989: , p5_a3 JTF_VARCHAR2_TABLE_100

985: , x_msg_data out nocopy VARCHAR2
986: , p5_a0 JTF_NUMBER_TABLE
987: , p5_a1 JTF_NUMBER_TABLE
988: , p5_a2 JTF_NUMBER_TABLE
989: , p5_a3 JTF_VARCHAR2_TABLE_100
990: , p5_a4 JTF_DATE_TABLE
991: , p5_a5 JTF_NUMBER_TABLE
992: , p5_a6 JTF_NUMBER_TABLE
993: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 993: , p5_a7 JTF_VARCHAR2_TABLE_100

989: , p5_a3 JTF_VARCHAR2_TABLE_100
990: , p5_a4 JTF_DATE_TABLE
991: , p5_a5 JTF_NUMBER_TABLE
992: , p5_a6 JTF_NUMBER_TABLE
993: , p5_a7 JTF_VARCHAR2_TABLE_100
994: , p5_a8 JTF_NUMBER_TABLE
995: , p5_a9 JTF_VARCHAR2_TABLE_100
996: , p5_a10 JTF_VARCHAR2_TABLE_100
997: , p5_a11 JTF_NUMBER_TABLE

Line 995: , p5_a9 JTF_VARCHAR2_TABLE_100

991: , p5_a5 JTF_NUMBER_TABLE
992: , p5_a6 JTF_NUMBER_TABLE
993: , p5_a7 JTF_VARCHAR2_TABLE_100
994: , p5_a8 JTF_NUMBER_TABLE
995: , p5_a9 JTF_VARCHAR2_TABLE_100
996: , p5_a10 JTF_VARCHAR2_TABLE_100
997: , p5_a11 JTF_NUMBER_TABLE
998: , p5_a12 JTF_NUMBER_TABLE
999: , p5_a13 JTF_NUMBER_TABLE

Line 996: , p5_a10 JTF_VARCHAR2_TABLE_100

992: , p5_a6 JTF_NUMBER_TABLE
993: , p5_a7 JTF_VARCHAR2_TABLE_100
994: , p5_a8 JTF_NUMBER_TABLE
995: , p5_a9 JTF_VARCHAR2_TABLE_100
996: , p5_a10 JTF_VARCHAR2_TABLE_100
997: , p5_a11 JTF_NUMBER_TABLE
998: , p5_a12 JTF_NUMBER_TABLE
999: , p5_a13 JTF_NUMBER_TABLE
1000: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 1000: , p5_a14 JTF_VARCHAR2_TABLE_100

996: , p5_a10 JTF_VARCHAR2_TABLE_100
997: , p5_a11 JTF_NUMBER_TABLE
998: , p5_a12 JTF_NUMBER_TABLE
999: , p5_a13 JTF_NUMBER_TABLE
1000: , p5_a14 JTF_VARCHAR2_TABLE_100
1001: , p5_a15 JTF_VARCHAR2_TABLE_100
1002: , p5_a16 JTF_NUMBER_TABLE
1003: , p5_a17 JTF_NUMBER_TABLE
1004: , p5_a18 JTF_DATE_TABLE

Line 1001: , p5_a15 JTF_VARCHAR2_TABLE_100

997: , p5_a11 JTF_NUMBER_TABLE
998: , p5_a12 JTF_NUMBER_TABLE
999: , p5_a13 JTF_NUMBER_TABLE
1000: , p5_a14 JTF_VARCHAR2_TABLE_100
1001: , p5_a15 JTF_VARCHAR2_TABLE_100
1002: , p5_a16 JTF_NUMBER_TABLE
1003: , p5_a17 JTF_NUMBER_TABLE
1004: , p5_a18 JTF_DATE_TABLE
1005: , p5_a19 JTF_NUMBER_TABLE

Line 1006: , p5_a20 JTF_VARCHAR2_TABLE_100

1002: , p5_a16 JTF_NUMBER_TABLE
1003: , p5_a17 JTF_NUMBER_TABLE
1004: , p5_a18 JTF_DATE_TABLE
1005: , p5_a19 JTF_NUMBER_TABLE
1006: , p5_a20 JTF_VARCHAR2_TABLE_100
1007: , p5_a21 JTF_NUMBER_TABLE
1008: , p5_a22 JTF_NUMBER_TABLE
1009: , p5_a23 JTF_NUMBER_TABLE
1010: , p5_a24 JTF_DATE_TABLE

Line 1016: , p5_a30 JTF_VARCHAR2_TABLE_100

1012: , p5_a26 JTF_NUMBER_TABLE
1013: , p5_a27 JTF_DATE_TABLE
1014: , p5_a28 JTF_DATE_TABLE
1015: , p5_a29 JTF_DATE_TABLE
1016: , p5_a30 JTF_VARCHAR2_TABLE_100
1017: , p5_a31 JTF_VARCHAR2_TABLE_500
1018: , p5_a32 JTF_VARCHAR2_TABLE_500
1019: , p5_a33 JTF_VARCHAR2_TABLE_500
1020: , p5_a34 JTF_NUMBER_TABLE

Line 1039: , p5_a53 JTF_VARCHAR2_TABLE_100

1035: , p5_a49 JTF_DATE_TABLE
1036: , p5_a50 JTF_NUMBER_TABLE
1037: , p5_a51 JTF_NUMBER_TABLE
1038: , p5_a52 JTF_NUMBER_TABLE
1039: , p5_a53 JTF_VARCHAR2_TABLE_100
1040: , p5_a54 JTF_NUMBER_TABLE
1041: , p5_a55 JTF_NUMBER_TABLE
1042: , p5_a56 JTF_DATE_TABLE
1043: , p5_a57 JTF_DATE_TABLE

Line 1047: , p5_a61 JTF_VARCHAR2_TABLE_100

1043: , p5_a57 JTF_DATE_TABLE
1044: , p5_a58 JTF_NUMBER_TABLE
1045: , p5_a59 JTF_VARCHAR2_TABLE_200
1046: , p5_a60 JTF_NUMBER_TABLE
1047: , p5_a61 JTF_VARCHAR2_TABLE_100
1048: );
1049: procedure validate_row(p_api_version NUMBER
1050: , p_init_msg_list VARCHAR2
1051: , x_return_status out nocopy VARCHAR2

Line 1125: , p5_a3 JTF_VARCHAR2_TABLE_100

1121: , x_msg_data out nocopy VARCHAR2
1122: , p5_a0 JTF_NUMBER_TABLE
1123: , p5_a1 JTF_NUMBER_TABLE
1124: , p5_a2 JTF_NUMBER_TABLE
1125: , p5_a3 JTF_VARCHAR2_TABLE_100
1126: , p5_a4 JTF_DATE_TABLE
1127: , p5_a5 JTF_NUMBER_TABLE
1128: , p5_a6 JTF_NUMBER_TABLE
1129: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1129: , p5_a7 JTF_VARCHAR2_TABLE_100

1125: , p5_a3 JTF_VARCHAR2_TABLE_100
1126: , p5_a4 JTF_DATE_TABLE
1127: , p5_a5 JTF_NUMBER_TABLE
1128: , p5_a6 JTF_NUMBER_TABLE
1129: , p5_a7 JTF_VARCHAR2_TABLE_100
1130: , p5_a8 JTF_NUMBER_TABLE
1131: , p5_a9 JTF_VARCHAR2_TABLE_100
1132: , p5_a10 JTF_VARCHAR2_TABLE_100
1133: , p5_a11 JTF_NUMBER_TABLE

Line 1131: , p5_a9 JTF_VARCHAR2_TABLE_100

1127: , p5_a5 JTF_NUMBER_TABLE
1128: , p5_a6 JTF_NUMBER_TABLE
1129: , p5_a7 JTF_VARCHAR2_TABLE_100
1130: , p5_a8 JTF_NUMBER_TABLE
1131: , p5_a9 JTF_VARCHAR2_TABLE_100
1132: , p5_a10 JTF_VARCHAR2_TABLE_100
1133: , p5_a11 JTF_NUMBER_TABLE
1134: , p5_a12 JTF_NUMBER_TABLE
1135: , p5_a13 JTF_NUMBER_TABLE

Line 1132: , p5_a10 JTF_VARCHAR2_TABLE_100

1128: , p5_a6 JTF_NUMBER_TABLE
1129: , p5_a7 JTF_VARCHAR2_TABLE_100
1130: , p5_a8 JTF_NUMBER_TABLE
1131: , p5_a9 JTF_VARCHAR2_TABLE_100
1132: , p5_a10 JTF_VARCHAR2_TABLE_100
1133: , p5_a11 JTF_NUMBER_TABLE
1134: , p5_a12 JTF_NUMBER_TABLE
1135: , p5_a13 JTF_NUMBER_TABLE
1136: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 1136: , p5_a14 JTF_VARCHAR2_TABLE_100

1132: , p5_a10 JTF_VARCHAR2_TABLE_100
1133: , p5_a11 JTF_NUMBER_TABLE
1134: , p5_a12 JTF_NUMBER_TABLE
1135: , p5_a13 JTF_NUMBER_TABLE
1136: , p5_a14 JTF_VARCHAR2_TABLE_100
1137: , p5_a15 JTF_VARCHAR2_TABLE_100
1138: , p5_a16 JTF_NUMBER_TABLE
1139: , p5_a17 JTF_NUMBER_TABLE
1140: , p5_a18 JTF_DATE_TABLE

Line 1137: , p5_a15 JTF_VARCHAR2_TABLE_100

1133: , p5_a11 JTF_NUMBER_TABLE
1134: , p5_a12 JTF_NUMBER_TABLE
1135: , p5_a13 JTF_NUMBER_TABLE
1136: , p5_a14 JTF_VARCHAR2_TABLE_100
1137: , p5_a15 JTF_VARCHAR2_TABLE_100
1138: , p5_a16 JTF_NUMBER_TABLE
1139: , p5_a17 JTF_NUMBER_TABLE
1140: , p5_a18 JTF_DATE_TABLE
1141: , p5_a19 JTF_NUMBER_TABLE

Line 1142: , p5_a20 JTF_VARCHAR2_TABLE_100

1138: , p5_a16 JTF_NUMBER_TABLE
1139: , p5_a17 JTF_NUMBER_TABLE
1140: , p5_a18 JTF_DATE_TABLE
1141: , p5_a19 JTF_NUMBER_TABLE
1142: , p5_a20 JTF_VARCHAR2_TABLE_100
1143: , p5_a21 JTF_NUMBER_TABLE
1144: , p5_a22 JTF_NUMBER_TABLE
1145: , p5_a23 JTF_NUMBER_TABLE
1146: , p5_a24 JTF_DATE_TABLE

Line 1152: , p5_a30 JTF_VARCHAR2_TABLE_100

1148: , p5_a26 JTF_NUMBER_TABLE
1149: , p5_a27 JTF_DATE_TABLE
1150: , p5_a28 JTF_DATE_TABLE
1151: , p5_a29 JTF_DATE_TABLE
1152: , p5_a30 JTF_VARCHAR2_TABLE_100
1153: , p5_a31 JTF_VARCHAR2_TABLE_500
1154: , p5_a32 JTF_VARCHAR2_TABLE_500
1155: , p5_a33 JTF_VARCHAR2_TABLE_500
1156: , p5_a34 JTF_NUMBER_TABLE

Line 1175: , p5_a53 JTF_VARCHAR2_TABLE_100

1171: , p5_a49 JTF_DATE_TABLE
1172: , p5_a50 JTF_NUMBER_TABLE
1173: , p5_a51 JTF_NUMBER_TABLE
1174: , p5_a52 JTF_NUMBER_TABLE
1175: , p5_a53 JTF_VARCHAR2_TABLE_100
1176: , p5_a54 JTF_NUMBER_TABLE
1177: , p5_a55 JTF_NUMBER_TABLE
1178: , p5_a56 JTF_DATE_TABLE
1179: , p5_a57 JTF_DATE_TABLE

Line 1183: , p5_a61 JTF_VARCHAR2_TABLE_100

1179: , p5_a57 JTF_DATE_TABLE
1180: , p5_a58 JTF_NUMBER_TABLE
1181: , p5_a59 JTF_VARCHAR2_TABLE_200
1182: , p5_a60 JTF_NUMBER_TABLE
1183: , p5_a61 JTF_VARCHAR2_TABLE_100
1184: );
1185: end okl_sil_pvt_w;