APPS.OKL_TRX_CSH_BATCH_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p5_a0 JTF_NUMBER_TABLE

4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_200
12: , p5_a4 JTF_DATE_TABLE

Line 9: , p5_a1 JTF_NUMBER_TABLE

5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_200
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_DATE_TABLE

Line 15: , p5_a7 JTF_NUMBER_TABLE

11: , p5_a3 JTF_VARCHAR2_TABLE_200
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_DATE_TABLE
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_VARCHAR2_TABLE_100
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_VARCHAR2_TABLE_2000

Line 16: , p5_a8 JTF_NUMBER_TABLE

12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_DATE_TABLE
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_VARCHAR2_TABLE_100
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_VARCHAR2_TABLE_2000
20: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 18: , p5_a10 JTF_NUMBER_TABLE

14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_VARCHAR2_TABLE_100
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_VARCHAR2_TABLE_2000
20: , p5_a12 JTF_VARCHAR2_TABLE_100
21: , p5_a13 JTF_VARCHAR2_TABLE_500
22: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 36: , p5_a28 JTF_NUMBER_TABLE

32: , p5_a24 JTF_VARCHAR2_TABLE_500
33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_VARCHAR2_TABLE_500
35: , p5_a27 JTF_VARCHAR2_TABLE_500
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE

Line 37: , p5_a29 JTF_NUMBER_TABLE

33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_VARCHAR2_TABLE_500
35: , p5_a27 JTF_VARCHAR2_TABLE_500
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE

Line 38: , p5_a30 JTF_NUMBER_TABLE

34: , p5_a26 JTF_VARCHAR2_TABLE_500
35: , p5_a27 JTF_VARCHAR2_TABLE_500
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE

Line 40: , p5_a32 JTF_NUMBER_TABLE

36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE

Line 41: , p5_a33 JTF_NUMBER_TABLE

37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE

Line 43: , p5_a35 JTF_NUMBER_TABLE

39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_VARCHAR2_TABLE_100

Line 45: , p5_a37 JTF_NUMBER_TABLE

41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_NUMBER_TABLE
49: , p5_a41 JTF_DATE_TABLE

Line 48: , p5_a40 JTF_NUMBER_TABLE

44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_NUMBER_TABLE
49: , p5_a41 JTF_DATE_TABLE
50: , p5_a42 JTF_NUMBER_TABLE
51: , p6_a0 out nocopy JTF_NUMBER_TABLE
52: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 50: , p5_a42 JTF_NUMBER_TABLE

46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_NUMBER_TABLE
49: , p5_a41 JTF_DATE_TABLE
50: , p5_a42 JTF_NUMBER_TABLE
51: , p6_a0 out nocopy JTF_NUMBER_TABLE
52: , p6_a1 out nocopy JTF_NUMBER_TABLE
53: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 51: , p6_a0 out nocopy JTF_NUMBER_TABLE

47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_NUMBER_TABLE
49: , p5_a41 JTF_DATE_TABLE
50: , p5_a42 JTF_NUMBER_TABLE
51: , p6_a0 out nocopy JTF_NUMBER_TABLE
52: , p6_a1 out nocopy JTF_NUMBER_TABLE
53: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , p6_a4 out nocopy JTF_DATE_TABLE

Line 52: , p6_a1 out nocopy JTF_NUMBER_TABLE

48: , p5_a40 JTF_NUMBER_TABLE
49: , p5_a41 JTF_DATE_TABLE
50: , p5_a42 JTF_NUMBER_TABLE
51: , p6_a0 out nocopy JTF_NUMBER_TABLE
52: , p6_a1 out nocopy JTF_NUMBER_TABLE
53: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , p6_a4 out nocopy JTF_DATE_TABLE
56: , p6_a5 out nocopy JTF_DATE_TABLE

Line 58: , p6_a7 out nocopy JTF_NUMBER_TABLE

54: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , p6_a4 out nocopy JTF_DATE_TABLE
56: , p6_a5 out nocopy JTF_DATE_TABLE
57: , p6_a6 out nocopy JTF_DATE_TABLE
58: , p6_a7 out nocopy JTF_NUMBER_TABLE
59: , p6_a8 out nocopy JTF_NUMBER_TABLE
60: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a10 out nocopy JTF_NUMBER_TABLE
62: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000

Line 59: , p6_a8 out nocopy JTF_NUMBER_TABLE

55: , p6_a4 out nocopy JTF_DATE_TABLE
56: , p6_a5 out nocopy JTF_DATE_TABLE
57: , p6_a6 out nocopy JTF_DATE_TABLE
58: , p6_a7 out nocopy JTF_NUMBER_TABLE
59: , p6_a8 out nocopy JTF_NUMBER_TABLE
60: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a10 out nocopy JTF_NUMBER_TABLE
62: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
63: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , p6_a10 out nocopy JTF_NUMBER_TABLE

57: , p6_a6 out nocopy JTF_DATE_TABLE
58: , p6_a7 out nocopy JTF_NUMBER_TABLE
59: , p6_a8 out nocopy JTF_NUMBER_TABLE
60: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a10 out nocopy JTF_NUMBER_TABLE
62: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
63: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
65: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 79: , p6_a28 out nocopy JTF_NUMBER_TABLE

75: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
76: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
77: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
78: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
79: , p6_a28 out nocopy JTF_NUMBER_TABLE
80: , p6_a29 out nocopy JTF_NUMBER_TABLE
81: , p6_a30 out nocopy JTF_NUMBER_TABLE
82: , p6_a31 out nocopy JTF_DATE_TABLE
83: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 80: , p6_a29 out nocopy JTF_NUMBER_TABLE

76: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
77: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
78: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
79: , p6_a28 out nocopy JTF_NUMBER_TABLE
80: , p6_a29 out nocopy JTF_NUMBER_TABLE
81: , p6_a30 out nocopy JTF_NUMBER_TABLE
82: , p6_a31 out nocopy JTF_DATE_TABLE
83: , p6_a32 out nocopy JTF_NUMBER_TABLE
84: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 81: , p6_a30 out nocopy JTF_NUMBER_TABLE

77: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
78: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
79: , p6_a28 out nocopy JTF_NUMBER_TABLE
80: , p6_a29 out nocopy JTF_NUMBER_TABLE
81: , p6_a30 out nocopy JTF_NUMBER_TABLE
82: , p6_a31 out nocopy JTF_DATE_TABLE
83: , p6_a32 out nocopy JTF_NUMBER_TABLE
84: , p6_a33 out nocopy JTF_NUMBER_TABLE
85: , p6_a34 out nocopy JTF_DATE_TABLE

Line 83: , p6_a32 out nocopy JTF_NUMBER_TABLE

79: , p6_a28 out nocopy JTF_NUMBER_TABLE
80: , p6_a29 out nocopy JTF_NUMBER_TABLE
81: , p6_a30 out nocopy JTF_NUMBER_TABLE
82: , p6_a31 out nocopy JTF_DATE_TABLE
83: , p6_a32 out nocopy JTF_NUMBER_TABLE
84: , p6_a33 out nocopy JTF_NUMBER_TABLE
85: , p6_a34 out nocopy JTF_DATE_TABLE
86: , p6_a35 out nocopy JTF_NUMBER_TABLE
87: , p6_a36 out nocopy JTF_DATE_TABLE

Line 84: , p6_a33 out nocopy JTF_NUMBER_TABLE

80: , p6_a29 out nocopy JTF_NUMBER_TABLE
81: , p6_a30 out nocopy JTF_NUMBER_TABLE
82: , p6_a31 out nocopy JTF_DATE_TABLE
83: , p6_a32 out nocopy JTF_NUMBER_TABLE
84: , p6_a33 out nocopy JTF_NUMBER_TABLE
85: , p6_a34 out nocopy JTF_DATE_TABLE
86: , p6_a35 out nocopy JTF_NUMBER_TABLE
87: , p6_a36 out nocopy JTF_DATE_TABLE
88: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 86: , p6_a35 out nocopy JTF_NUMBER_TABLE

82: , p6_a31 out nocopy JTF_DATE_TABLE
83: , p6_a32 out nocopy JTF_NUMBER_TABLE
84: , p6_a33 out nocopy JTF_NUMBER_TABLE
85: , p6_a34 out nocopy JTF_DATE_TABLE
86: , p6_a35 out nocopy JTF_NUMBER_TABLE
87: , p6_a36 out nocopy JTF_DATE_TABLE
88: , p6_a37 out nocopy JTF_NUMBER_TABLE
89: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
90: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 88: , p6_a37 out nocopy JTF_NUMBER_TABLE

84: , p6_a33 out nocopy JTF_NUMBER_TABLE
85: , p6_a34 out nocopy JTF_DATE_TABLE
86: , p6_a35 out nocopy JTF_NUMBER_TABLE
87: , p6_a36 out nocopy JTF_DATE_TABLE
88: , p6_a37 out nocopy JTF_NUMBER_TABLE
89: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
90: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
91: , p6_a40 out nocopy JTF_NUMBER_TABLE
92: , p6_a41 out nocopy JTF_DATE_TABLE

Line 91: , p6_a40 out nocopy JTF_NUMBER_TABLE

87: , p6_a36 out nocopy JTF_DATE_TABLE
88: , p6_a37 out nocopy JTF_NUMBER_TABLE
89: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
90: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
91: , p6_a40 out nocopy JTF_NUMBER_TABLE
92: , p6_a41 out nocopy JTF_DATE_TABLE
93: , p6_a42 out nocopy JTF_NUMBER_TABLE
94: );
95: procedure insert_trx_csh_batch(p_api_version NUMBER

Line 93: , p6_a42 out nocopy JTF_NUMBER_TABLE

89: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
90: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
91: , p6_a40 out nocopy JTF_NUMBER_TABLE
92: , p6_a41 out nocopy JTF_DATE_TABLE
93: , p6_a42 out nocopy JTF_NUMBER_TABLE
94: );
95: procedure insert_trx_csh_batch(p_api_version NUMBER
96: , p_init_msg_list VARCHAR2
97: , x_return_status out nocopy VARCHAR2

Line 192: , p5_a0 JTF_NUMBER_TABLE

188: , p_init_msg_list VARCHAR2
189: , x_return_status out nocopy VARCHAR2
190: , x_msg_count out nocopy NUMBER
191: , x_msg_data out nocopy VARCHAR2
192: , p5_a0 JTF_NUMBER_TABLE
193: , p5_a1 JTF_NUMBER_TABLE
194: , p5_a2 JTF_VARCHAR2_TABLE_100
195: , p5_a3 JTF_VARCHAR2_TABLE_200
196: , p5_a4 JTF_DATE_TABLE

Line 193: , p5_a1 JTF_NUMBER_TABLE

189: , x_return_status out nocopy VARCHAR2
190: , x_msg_count out nocopy NUMBER
191: , x_msg_data out nocopy VARCHAR2
192: , p5_a0 JTF_NUMBER_TABLE
193: , p5_a1 JTF_NUMBER_TABLE
194: , p5_a2 JTF_VARCHAR2_TABLE_100
195: , p5_a3 JTF_VARCHAR2_TABLE_200
196: , p5_a4 JTF_DATE_TABLE
197: , p5_a5 JTF_DATE_TABLE

Line 199: , p5_a7 JTF_NUMBER_TABLE

195: , p5_a3 JTF_VARCHAR2_TABLE_200
196: , p5_a4 JTF_DATE_TABLE
197: , p5_a5 JTF_DATE_TABLE
198: , p5_a6 JTF_DATE_TABLE
199: , p5_a7 JTF_NUMBER_TABLE
200: , p5_a8 JTF_NUMBER_TABLE
201: , p5_a9 JTF_VARCHAR2_TABLE_100
202: , p5_a10 JTF_NUMBER_TABLE
203: , p5_a11 JTF_VARCHAR2_TABLE_2000

Line 200: , p5_a8 JTF_NUMBER_TABLE

196: , p5_a4 JTF_DATE_TABLE
197: , p5_a5 JTF_DATE_TABLE
198: , p5_a6 JTF_DATE_TABLE
199: , p5_a7 JTF_NUMBER_TABLE
200: , p5_a8 JTF_NUMBER_TABLE
201: , p5_a9 JTF_VARCHAR2_TABLE_100
202: , p5_a10 JTF_NUMBER_TABLE
203: , p5_a11 JTF_VARCHAR2_TABLE_2000
204: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 202: , p5_a10 JTF_NUMBER_TABLE

198: , p5_a6 JTF_DATE_TABLE
199: , p5_a7 JTF_NUMBER_TABLE
200: , p5_a8 JTF_NUMBER_TABLE
201: , p5_a9 JTF_VARCHAR2_TABLE_100
202: , p5_a10 JTF_NUMBER_TABLE
203: , p5_a11 JTF_VARCHAR2_TABLE_2000
204: , p5_a12 JTF_VARCHAR2_TABLE_100
205: , p5_a13 JTF_VARCHAR2_TABLE_500
206: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 220: , p5_a28 JTF_NUMBER_TABLE

216: , p5_a24 JTF_VARCHAR2_TABLE_500
217: , p5_a25 JTF_VARCHAR2_TABLE_500
218: , p5_a26 JTF_VARCHAR2_TABLE_500
219: , p5_a27 JTF_VARCHAR2_TABLE_500
220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_NUMBER_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p5_a31 JTF_DATE_TABLE
224: , p5_a32 JTF_NUMBER_TABLE

Line 221: , p5_a29 JTF_NUMBER_TABLE

217: , p5_a25 JTF_VARCHAR2_TABLE_500
218: , p5_a26 JTF_VARCHAR2_TABLE_500
219: , p5_a27 JTF_VARCHAR2_TABLE_500
220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_NUMBER_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p5_a31 JTF_DATE_TABLE
224: , p5_a32 JTF_NUMBER_TABLE
225: , p5_a33 JTF_NUMBER_TABLE

Line 222: , p5_a30 JTF_NUMBER_TABLE

218: , p5_a26 JTF_VARCHAR2_TABLE_500
219: , p5_a27 JTF_VARCHAR2_TABLE_500
220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_NUMBER_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p5_a31 JTF_DATE_TABLE
224: , p5_a32 JTF_NUMBER_TABLE
225: , p5_a33 JTF_NUMBER_TABLE
226: , p5_a34 JTF_DATE_TABLE

Line 224: , p5_a32 JTF_NUMBER_TABLE

220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_NUMBER_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p5_a31 JTF_DATE_TABLE
224: , p5_a32 JTF_NUMBER_TABLE
225: , p5_a33 JTF_NUMBER_TABLE
226: , p5_a34 JTF_DATE_TABLE
227: , p5_a35 JTF_NUMBER_TABLE
228: , p5_a36 JTF_DATE_TABLE

Line 225: , p5_a33 JTF_NUMBER_TABLE

221: , p5_a29 JTF_NUMBER_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p5_a31 JTF_DATE_TABLE
224: , p5_a32 JTF_NUMBER_TABLE
225: , p5_a33 JTF_NUMBER_TABLE
226: , p5_a34 JTF_DATE_TABLE
227: , p5_a35 JTF_NUMBER_TABLE
228: , p5_a36 JTF_DATE_TABLE
229: , p5_a37 JTF_NUMBER_TABLE

Line 227: , p5_a35 JTF_NUMBER_TABLE

223: , p5_a31 JTF_DATE_TABLE
224: , p5_a32 JTF_NUMBER_TABLE
225: , p5_a33 JTF_NUMBER_TABLE
226: , p5_a34 JTF_DATE_TABLE
227: , p5_a35 JTF_NUMBER_TABLE
228: , p5_a36 JTF_DATE_TABLE
229: , p5_a37 JTF_NUMBER_TABLE
230: , p5_a38 JTF_VARCHAR2_TABLE_100
231: , p5_a39 JTF_VARCHAR2_TABLE_100

Line 229: , p5_a37 JTF_NUMBER_TABLE

225: , p5_a33 JTF_NUMBER_TABLE
226: , p5_a34 JTF_DATE_TABLE
227: , p5_a35 JTF_NUMBER_TABLE
228: , p5_a36 JTF_DATE_TABLE
229: , p5_a37 JTF_NUMBER_TABLE
230: , p5_a38 JTF_VARCHAR2_TABLE_100
231: , p5_a39 JTF_VARCHAR2_TABLE_100
232: , p5_a40 JTF_NUMBER_TABLE
233: , p5_a41 JTF_DATE_TABLE

Line 232: , p5_a40 JTF_NUMBER_TABLE

228: , p5_a36 JTF_DATE_TABLE
229: , p5_a37 JTF_NUMBER_TABLE
230: , p5_a38 JTF_VARCHAR2_TABLE_100
231: , p5_a39 JTF_VARCHAR2_TABLE_100
232: , p5_a40 JTF_NUMBER_TABLE
233: , p5_a41 JTF_DATE_TABLE
234: , p5_a42 JTF_NUMBER_TABLE
235: );
236: procedure lock_trx_csh_batch(p_api_version NUMBER

Line 234: , p5_a42 JTF_NUMBER_TABLE

230: , p5_a38 JTF_VARCHAR2_TABLE_100
231: , p5_a39 JTF_VARCHAR2_TABLE_100
232: , p5_a40 JTF_NUMBER_TABLE
233: , p5_a41 JTF_DATE_TABLE
234: , p5_a42 JTF_NUMBER_TABLE
235: );
236: procedure lock_trx_csh_batch(p_api_version NUMBER
237: , p_init_msg_list VARCHAR2
238: , x_return_status out nocopy VARCHAR2

Line 290: , p5_a0 JTF_NUMBER_TABLE

286: , p_init_msg_list VARCHAR2
287: , x_return_status out nocopy VARCHAR2
288: , x_msg_count out nocopy NUMBER
289: , x_msg_data out nocopy VARCHAR2
290: , p5_a0 JTF_NUMBER_TABLE
291: , p5_a1 JTF_NUMBER_TABLE
292: , p5_a2 JTF_VARCHAR2_TABLE_100
293: , p5_a3 JTF_VARCHAR2_TABLE_200
294: , p5_a4 JTF_DATE_TABLE

Line 291: , p5_a1 JTF_NUMBER_TABLE

287: , x_return_status out nocopy VARCHAR2
288: , x_msg_count out nocopy NUMBER
289: , x_msg_data out nocopy VARCHAR2
290: , p5_a0 JTF_NUMBER_TABLE
291: , p5_a1 JTF_NUMBER_TABLE
292: , p5_a2 JTF_VARCHAR2_TABLE_100
293: , p5_a3 JTF_VARCHAR2_TABLE_200
294: , p5_a4 JTF_DATE_TABLE
295: , p5_a5 JTF_DATE_TABLE

Line 297: , p5_a7 JTF_NUMBER_TABLE

293: , p5_a3 JTF_VARCHAR2_TABLE_200
294: , p5_a4 JTF_DATE_TABLE
295: , p5_a5 JTF_DATE_TABLE
296: , p5_a6 JTF_DATE_TABLE
297: , p5_a7 JTF_NUMBER_TABLE
298: , p5_a8 JTF_NUMBER_TABLE
299: , p5_a9 JTF_VARCHAR2_TABLE_100
300: , p5_a10 JTF_NUMBER_TABLE
301: , p5_a11 JTF_VARCHAR2_TABLE_2000

Line 298: , p5_a8 JTF_NUMBER_TABLE

294: , p5_a4 JTF_DATE_TABLE
295: , p5_a5 JTF_DATE_TABLE
296: , p5_a6 JTF_DATE_TABLE
297: , p5_a7 JTF_NUMBER_TABLE
298: , p5_a8 JTF_NUMBER_TABLE
299: , p5_a9 JTF_VARCHAR2_TABLE_100
300: , p5_a10 JTF_NUMBER_TABLE
301: , p5_a11 JTF_VARCHAR2_TABLE_2000
302: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 300: , p5_a10 JTF_NUMBER_TABLE

296: , p5_a6 JTF_DATE_TABLE
297: , p5_a7 JTF_NUMBER_TABLE
298: , p5_a8 JTF_NUMBER_TABLE
299: , p5_a9 JTF_VARCHAR2_TABLE_100
300: , p5_a10 JTF_NUMBER_TABLE
301: , p5_a11 JTF_VARCHAR2_TABLE_2000
302: , p5_a12 JTF_VARCHAR2_TABLE_100
303: , p5_a13 JTF_VARCHAR2_TABLE_500
304: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 318: , p5_a28 JTF_NUMBER_TABLE

314: , p5_a24 JTF_VARCHAR2_TABLE_500
315: , p5_a25 JTF_VARCHAR2_TABLE_500
316: , p5_a26 JTF_VARCHAR2_TABLE_500
317: , p5_a27 JTF_VARCHAR2_TABLE_500
318: , p5_a28 JTF_NUMBER_TABLE
319: , p5_a29 JTF_NUMBER_TABLE
320: , p5_a30 JTF_NUMBER_TABLE
321: , p5_a31 JTF_DATE_TABLE
322: , p5_a32 JTF_NUMBER_TABLE

Line 319: , p5_a29 JTF_NUMBER_TABLE

315: , p5_a25 JTF_VARCHAR2_TABLE_500
316: , p5_a26 JTF_VARCHAR2_TABLE_500
317: , p5_a27 JTF_VARCHAR2_TABLE_500
318: , p5_a28 JTF_NUMBER_TABLE
319: , p5_a29 JTF_NUMBER_TABLE
320: , p5_a30 JTF_NUMBER_TABLE
321: , p5_a31 JTF_DATE_TABLE
322: , p5_a32 JTF_NUMBER_TABLE
323: , p5_a33 JTF_NUMBER_TABLE

Line 320: , p5_a30 JTF_NUMBER_TABLE

316: , p5_a26 JTF_VARCHAR2_TABLE_500
317: , p5_a27 JTF_VARCHAR2_TABLE_500
318: , p5_a28 JTF_NUMBER_TABLE
319: , p5_a29 JTF_NUMBER_TABLE
320: , p5_a30 JTF_NUMBER_TABLE
321: , p5_a31 JTF_DATE_TABLE
322: , p5_a32 JTF_NUMBER_TABLE
323: , p5_a33 JTF_NUMBER_TABLE
324: , p5_a34 JTF_DATE_TABLE

Line 322: , p5_a32 JTF_NUMBER_TABLE

318: , p5_a28 JTF_NUMBER_TABLE
319: , p5_a29 JTF_NUMBER_TABLE
320: , p5_a30 JTF_NUMBER_TABLE
321: , p5_a31 JTF_DATE_TABLE
322: , p5_a32 JTF_NUMBER_TABLE
323: , p5_a33 JTF_NUMBER_TABLE
324: , p5_a34 JTF_DATE_TABLE
325: , p5_a35 JTF_NUMBER_TABLE
326: , p5_a36 JTF_DATE_TABLE

Line 323: , p5_a33 JTF_NUMBER_TABLE

319: , p5_a29 JTF_NUMBER_TABLE
320: , p5_a30 JTF_NUMBER_TABLE
321: , p5_a31 JTF_DATE_TABLE
322: , p5_a32 JTF_NUMBER_TABLE
323: , p5_a33 JTF_NUMBER_TABLE
324: , p5_a34 JTF_DATE_TABLE
325: , p5_a35 JTF_NUMBER_TABLE
326: , p5_a36 JTF_DATE_TABLE
327: , p5_a37 JTF_NUMBER_TABLE

Line 325: , p5_a35 JTF_NUMBER_TABLE

321: , p5_a31 JTF_DATE_TABLE
322: , p5_a32 JTF_NUMBER_TABLE
323: , p5_a33 JTF_NUMBER_TABLE
324: , p5_a34 JTF_DATE_TABLE
325: , p5_a35 JTF_NUMBER_TABLE
326: , p5_a36 JTF_DATE_TABLE
327: , p5_a37 JTF_NUMBER_TABLE
328: , p5_a38 JTF_VARCHAR2_TABLE_100
329: , p5_a39 JTF_VARCHAR2_TABLE_100

Line 327: , p5_a37 JTF_NUMBER_TABLE

323: , p5_a33 JTF_NUMBER_TABLE
324: , p5_a34 JTF_DATE_TABLE
325: , p5_a35 JTF_NUMBER_TABLE
326: , p5_a36 JTF_DATE_TABLE
327: , p5_a37 JTF_NUMBER_TABLE
328: , p5_a38 JTF_VARCHAR2_TABLE_100
329: , p5_a39 JTF_VARCHAR2_TABLE_100
330: , p5_a40 JTF_NUMBER_TABLE
331: , p5_a41 JTF_DATE_TABLE

Line 330: , p5_a40 JTF_NUMBER_TABLE

326: , p5_a36 JTF_DATE_TABLE
327: , p5_a37 JTF_NUMBER_TABLE
328: , p5_a38 JTF_VARCHAR2_TABLE_100
329: , p5_a39 JTF_VARCHAR2_TABLE_100
330: , p5_a40 JTF_NUMBER_TABLE
331: , p5_a41 JTF_DATE_TABLE
332: , p5_a42 JTF_NUMBER_TABLE
333: , p6_a0 out nocopy JTF_NUMBER_TABLE
334: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 332: , p5_a42 JTF_NUMBER_TABLE

328: , p5_a38 JTF_VARCHAR2_TABLE_100
329: , p5_a39 JTF_VARCHAR2_TABLE_100
330: , p5_a40 JTF_NUMBER_TABLE
331: , p5_a41 JTF_DATE_TABLE
332: , p5_a42 JTF_NUMBER_TABLE
333: , p6_a0 out nocopy JTF_NUMBER_TABLE
334: , p6_a1 out nocopy JTF_NUMBER_TABLE
335: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 333: , p6_a0 out nocopy JTF_NUMBER_TABLE

329: , p5_a39 JTF_VARCHAR2_TABLE_100
330: , p5_a40 JTF_NUMBER_TABLE
331: , p5_a41 JTF_DATE_TABLE
332: , p5_a42 JTF_NUMBER_TABLE
333: , p6_a0 out nocopy JTF_NUMBER_TABLE
334: , p6_a1 out nocopy JTF_NUMBER_TABLE
335: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
337: , p6_a4 out nocopy JTF_DATE_TABLE

Line 334: , p6_a1 out nocopy JTF_NUMBER_TABLE

330: , p5_a40 JTF_NUMBER_TABLE
331: , p5_a41 JTF_DATE_TABLE
332: , p5_a42 JTF_NUMBER_TABLE
333: , p6_a0 out nocopy JTF_NUMBER_TABLE
334: , p6_a1 out nocopy JTF_NUMBER_TABLE
335: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
337: , p6_a4 out nocopy JTF_DATE_TABLE
338: , p6_a5 out nocopy JTF_DATE_TABLE

Line 340: , p6_a7 out nocopy JTF_NUMBER_TABLE

336: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
337: , p6_a4 out nocopy JTF_DATE_TABLE
338: , p6_a5 out nocopy JTF_DATE_TABLE
339: , p6_a6 out nocopy JTF_DATE_TABLE
340: , p6_a7 out nocopy JTF_NUMBER_TABLE
341: , p6_a8 out nocopy JTF_NUMBER_TABLE
342: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a10 out nocopy JTF_NUMBER_TABLE
344: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000

Line 341: , p6_a8 out nocopy JTF_NUMBER_TABLE

337: , p6_a4 out nocopy JTF_DATE_TABLE
338: , p6_a5 out nocopy JTF_DATE_TABLE
339: , p6_a6 out nocopy JTF_DATE_TABLE
340: , p6_a7 out nocopy JTF_NUMBER_TABLE
341: , p6_a8 out nocopy JTF_NUMBER_TABLE
342: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a10 out nocopy JTF_NUMBER_TABLE
344: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
345: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 343: , p6_a10 out nocopy JTF_NUMBER_TABLE

339: , p6_a6 out nocopy JTF_DATE_TABLE
340: , p6_a7 out nocopy JTF_NUMBER_TABLE
341: , p6_a8 out nocopy JTF_NUMBER_TABLE
342: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a10 out nocopy JTF_NUMBER_TABLE
344: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
345: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
347: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 361: , p6_a28 out nocopy JTF_NUMBER_TABLE

357: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
358: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
359: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
360: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
361: , p6_a28 out nocopy JTF_NUMBER_TABLE
362: , p6_a29 out nocopy JTF_NUMBER_TABLE
363: , p6_a30 out nocopy JTF_NUMBER_TABLE
364: , p6_a31 out nocopy JTF_DATE_TABLE
365: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 362: , p6_a29 out nocopy JTF_NUMBER_TABLE

358: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
359: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
360: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
361: , p6_a28 out nocopy JTF_NUMBER_TABLE
362: , p6_a29 out nocopy JTF_NUMBER_TABLE
363: , p6_a30 out nocopy JTF_NUMBER_TABLE
364: , p6_a31 out nocopy JTF_DATE_TABLE
365: , p6_a32 out nocopy JTF_NUMBER_TABLE
366: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 363: , p6_a30 out nocopy JTF_NUMBER_TABLE

359: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
360: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
361: , p6_a28 out nocopy JTF_NUMBER_TABLE
362: , p6_a29 out nocopy JTF_NUMBER_TABLE
363: , p6_a30 out nocopy JTF_NUMBER_TABLE
364: , p6_a31 out nocopy JTF_DATE_TABLE
365: , p6_a32 out nocopy JTF_NUMBER_TABLE
366: , p6_a33 out nocopy JTF_NUMBER_TABLE
367: , p6_a34 out nocopy JTF_DATE_TABLE

Line 365: , p6_a32 out nocopy JTF_NUMBER_TABLE

361: , p6_a28 out nocopy JTF_NUMBER_TABLE
362: , p6_a29 out nocopy JTF_NUMBER_TABLE
363: , p6_a30 out nocopy JTF_NUMBER_TABLE
364: , p6_a31 out nocopy JTF_DATE_TABLE
365: , p6_a32 out nocopy JTF_NUMBER_TABLE
366: , p6_a33 out nocopy JTF_NUMBER_TABLE
367: , p6_a34 out nocopy JTF_DATE_TABLE
368: , p6_a35 out nocopy JTF_NUMBER_TABLE
369: , p6_a36 out nocopy JTF_DATE_TABLE

Line 366: , p6_a33 out nocopy JTF_NUMBER_TABLE

362: , p6_a29 out nocopy JTF_NUMBER_TABLE
363: , p6_a30 out nocopy JTF_NUMBER_TABLE
364: , p6_a31 out nocopy JTF_DATE_TABLE
365: , p6_a32 out nocopy JTF_NUMBER_TABLE
366: , p6_a33 out nocopy JTF_NUMBER_TABLE
367: , p6_a34 out nocopy JTF_DATE_TABLE
368: , p6_a35 out nocopy JTF_NUMBER_TABLE
369: , p6_a36 out nocopy JTF_DATE_TABLE
370: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 368: , p6_a35 out nocopy JTF_NUMBER_TABLE

364: , p6_a31 out nocopy JTF_DATE_TABLE
365: , p6_a32 out nocopy JTF_NUMBER_TABLE
366: , p6_a33 out nocopy JTF_NUMBER_TABLE
367: , p6_a34 out nocopy JTF_DATE_TABLE
368: , p6_a35 out nocopy JTF_NUMBER_TABLE
369: , p6_a36 out nocopy JTF_DATE_TABLE
370: , p6_a37 out nocopy JTF_NUMBER_TABLE
371: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 370: , p6_a37 out nocopy JTF_NUMBER_TABLE

366: , p6_a33 out nocopy JTF_NUMBER_TABLE
367: , p6_a34 out nocopy JTF_DATE_TABLE
368: , p6_a35 out nocopy JTF_NUMBER_TABLE
369: , p6_a36 out nocopy JTF_DATE_TABLE
370: , p6_a37 out nocopy JTF_NUMBER_TABLE
371: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
373: , p6_a40 out nocopy JTF_NUMBER_TABLE
374: , p6_a41 out nocopy JTF_DATE_TABLE

Line 373: , p6_a40 out nocopy JTF_NUMBER_TABLE

369: , p6_a36 out nocopy JTF_DATE_TABLE
370: , p6_a37 out nocopy JTF_NUMBER_TABLE
371: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
373: , p6_a40 out nocopy JTF_NUMBER_TABLE
374: , p6_a41 out nocopy JTF_DATE_TABLE
375: , p6_a42 out nocopy JTF_NUMBER_TABLE
376: );
377: procedure update_trx_csh_batch(p_api_version NUMBER

Line 375: , p6_a42 out nocopy JTF_NUMBER_TABLE

371: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
373: , p6_a40 out nocopy JTF_NUMBER_TABLE
374: , p6_a41 out nocopy JTF_DATE_TABLE
375: , p6_a42 out nocopy JTF_NUMBER_TABLE
376: );
377: procedure update_trx_csh_batch(p_api_version NUMBER
378: , p_init_msg_list VARCHAR2
379: , x_return_status out nocopy VARCHAR2

Line 474: , p5_a0 JTF_NUMBER_TABLE

470: , p_init_msg_list VARCHAR2
471: , x_return_status out nocopy VARCHAR2
472: , x_msg_count out nocopy NUMBER
473: , x_msg_data out nocopy VARCHAR2
474: , p5_a0 JTF_NUMBER_TABLE
475: , p5_a1 JTF_NUMBER_TABLE
476: , p5_a2 JTF_VARCHAR2_TABLE_100
477: , p5_a3 JTF_VARCHAR2_TABLE_200
478: , p5_a4 JTF_DATE_TABLE

Line 475: , p5_a1 JTF_NUMBER_TABLE

471: , x_return_status out nocopy VARCHAR2
472: , x_msg_count out nocopy NUMBER
473: , x_msg_data out nocopy VARCHAR2
474: , p5_a0 JTF_NUMBER_TABLE
475: , p5_a1 JTF_NUMBER_TABLE
476: , p5_a2 JTF_VARCHAR2_TABLE_100
477: , p5_a3 JTF_VARCHAR2_TABLE_200
478: , p5_a4 JTF_DATE_TABLE
479: , p5_a5 JTF_DATE_TABLE

Line 481: , p5_a7 JTF_NUMBER_TABLE

477: , p5_a3 JTF_VARCHAR2_TABLE_200
478: , p5_a4 JTF_DATE_TABLE
479: , p5_a5 JTF_DATE_TABLE
480: , p5_a6 JTF_DATE_TABLE
481: , p5_a7 JTF_NUMBER_TABLE
482: , p5_a8 JTF_NUMBER_TABLE
483: , p5_a9 JTF_VARCHAR2_TABLE_100
484: , p5_a10 JTF_NUMBER_TABLE
485: , p5_a11 JTF_VARCHAR2_TABLE_2000

Line 482: , p5_a8 JTF_NUMBER_TABLE

478: , p5_a4 JTF_DATE_TABLE
479: , p5_a5 JTF_DATE_TABLE
480: , p5_a6 JTF_DATE_TABLE
481: , p5_a7 JTF_NUMBER_TABLE
482: , p5_a8 JTF_NUMBER_TABLE
483: , p5_a9 JTF_VARCHAR2_TABLE_100
484: , p5_a10 JTF_NUMBER_TABLE
485: , p5_a11 JTF_VARCHAR2_TABLE_2000
486: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 484: , p5_a10 JTF_NUMBER_TABLE

480: , p5_a6 JTF_DATE_TABLE
481: , p5_a7 JTF_NUMBER_TABLE
482: , p5_a8 JTF_NUMBER_TABLE
483: , p5_a9 JTF_VARCHAR2_TABLE_100
484: , p5_a10 JTF_NUMBER_TABLE
485: , p5_a11 JTF_VARCHAR2_TABLE_2000
486: , p5_a12 JTF_VARCHAR2_TABLE_100
487: , p5_a13 JTF_VARCHAR2_TABLE_500
488: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 502: , p5_a28 JTF_NUMBER_TABLE

498: , p5_a24 JTF_VARCHAR2_TABLE_500
499: , p5_a25 JTF_VARCHAR2_TABLE_500
500: , p5_a26 JTF_VARCHAR2_TABLE_500
501: , p5_a27 JTF_VARCHAR2_TABLE_500
502: , p5_a28 JTF_NUMBER_TABLE
503: , p5_a29 JTF_NUMBER_TABLE
504: , p5_a30 JTF_NUMBER_TABLE
505: , p5_a31 JTF_DATE_TABLE
506: , p5_a32 JTF_NUMBER_TABLE

Line 503: , p5_a29 JTF_NUMBER_TABLE

499: , p5_a25 JTF_VARCHAR2_TABLE_500
500: , p5_a26 JTF_VARCHAR2_TABLE_500
501: , p5_a27 JTF_VARCHAR2_TABLE_500
502: , p5_a28 JTF_NUMBER_TABLE
503: , p5_a29 JTF_NUMBER_TABLE
504: , p5_a30 JTF_NUMBER_TABLE
505: , p5_a31 JTF_DATE_TABLE
506: , p5_a32 JTF_NUMBER_TABLE
507: , p5_a33 JTF_NUMBER_TABLE

Line 504: , p5_a30 JTF_NUMBER_TABLE

500: , p5_a26 JTF_VARCHAR2_TABLE_500
501: , p5_a27 JTF_VARCHAR2_TABLE_500
502: , p5_a28 JTF_NUMBER_TABLE
503: , p5_a29 JTF_NUMBER_TABLE
504: , p5_a30 JTF_NUMBER_TABLE
505: , p5_a31 JTF_DATE_TABLE
506: , p5_a32 JTF_NUMBER_TABLE
507: , p5_a33 JTF_NUMBER_TABLE
508: , p5_a34 JTF_DATE_TABLE

Line 506: , p5_a32 JTF_NUMBER_TABLE

502: , p5_a28 JTF_NUMBER_TABLE
503: , p5_a29 JTF_NUMBER_TABLE
504: , p5_a30 JTF_NUMBER_TABLE
505: , p5_a31 JTF_DATE_TABLE
506: , p5_a32 JTF_NUMBER_TABLE
507: , p5_a33 JTF_NUMBER_TABLE
508: , p5_a34 JTF_DATE_TABLE
509: , p5_a35 JTF_NUMBER_TABLE
510: , p5_a36 JTF_DATE_TABLE

Line 507: , p5_a33 JTF_NUMBER_TABLE

503: , p5_a29 JTF_NUMBER_TABLE
504: , p5_a30 JTF_NUMBER_TABLE
505: , p5_a31 JTF_DATE_TABLE
506: , p5_a32 JTF_NUMBER_TABLE
507: , p5_a33 JTF_NUMBER_TABLE
508: , p5_a34 JTF_DATE_TABLE
509: , p5_a35 JTF_NUMBER_TABLE
510: , p5_a36 JTF_DATE_TABLE
511: , p5_a37 JTF_NUMBER_TABLE

Line 509: , p5_a35 JTF_NUMBER_TABLE

505: , p5_a31 JTF_DATE_TABLE
506: , p5_a32 JTF_NUMBER_TABLE
507: , p5_a33 JTF_NUMBER_TABLE
508: , p5_a34 JTF_DATE_TABLE
509: , p5_a35 JTF_NUMBER_TABLE
510: , p5_a36 JTF_DATE_TABLE
511: , p5_a37 JTF_NUMBER_TABLE
512: , p5_a38 JTF_VARCHAR2_TABLE_100
513: , p5_a39 JTF_VARCHAR2_TABLE_100

Line 511: , p5_a37 JTF_NUMBER_TABLE

507: , p5_a33 JTF_NUMBER_TABLE
508: , p5_a34 JTF_DATE_TABLE
509: , p5_a35 JTF_NUMBER_TABLE
510: , p5_a36 JTF_DATE_TABLE
511: , p5_a37 JTF_NUMBER_TABLE
512: , p5_a38 JTF_VARCHAR2_TABLE_100
513: , p5_a39 JTF_VARCHAR2_TABLE_100
514: , p5_a40 JTF_NUMBER_TABLE
515: , p5_a41 JTF_DATE_TABLE

Line 514: , p5_a40 JTF_NUMBER_TABLE

510: , p5_a36 JTF_DATE_TABLE
511: , p5_a37 JTF_NUMBER_TABLE
512: , p5_a38 JTF_VARCHAR2_TABLE_100
513: , p5_a39 JTF_VARCHAR2_TABLE_100
514: , p5_a40 JTF_NUMBER_TABLE
515: , p5_a41 JTF_DATE_TABLE
516: , p5_a42 JTF_NUMBER_TABLE
517: );
518: procedure delete_trx_csh_batch(p_api_version NUMBER

Line 516: , p5_a42 JTF_NUMBER_TABLE

512: , p5_a38 JTF_VARCHAR2_TABLE_100
513: , p5_a39 JTF_VARCHAR2_TABLE_100
514: , p5_a40 JTF_NUMBER_TABLE
515: , p5_a41 JTF_DATE_TABLE
516: , p5_a42 JTF_NUMBER_TABLE
517: );
518: procedure delete_trx_csh_batch(p_api_version NUMBER
519: , p_init_msg_list VARCHAR2
520: , x_return_status out nocopy VARCHAR2

Line 572: , p5_a0 JTF_NUMBER_TABLE

568: , p_init_msg_list VARCHAR2
569: , x_return_status out nocopy VARCHAR2
570: , x_msg_count out nocopy NUMBER
571: , x_msg_data out nocopy VARCHAR2
572: , p5_a0 JTF_NUMBER_TABLE
573: , p5_a1 JTF_NUMBER_TABLE
574: , p5_a2 JTF_VARCHAR2_TABLE_100
575: , p5_a3 JTF_VARCHAR2_TABLE_200
576: , p5_a4 JTF_DATE_TABLE

Line 573: , p5_a1 JTF_NUMBER_TABLE

569: , x_return_status out nocopy VARCHAR2
570: , x_msg_count out nocopy NUMBER
571: , x_msg_data out nocopy VARCHAR2
572: , p5_a0 JTF_NUMBER_TABLE
573: , p5_a1 JTF_NUMBER_TABLE
574: , p5_a2 JTF_VARCHAR2_TABLE_100
575: , p5_a3 JTF_VARCHAR2_TABLE_200
576: , p5_a4 JTF_DATE_TABLE
577: , p5_a5 JTF_DATE_TABLE

Line 579: , p5_a7 JTF_NUMBER_TABLE

575: , p5_a3 JTF_VARCHAR2_TABLE_200
576: , p5_a4 JTF_DATE_TABLE
577: , p5_a5 JTF_DATE_TABLE
578: , p5_a6 JTF_DATE_TABLE
579: , p5_a7 JTF_NUMBER_TABLE
580: , p5_a8 JTF_NUMBER_TABLE
581: , p5_a9 JTF_VARCHAR2_TABLE_100
582: , p5_a10 JTF_NUMBER_TABLE
583: , p5_a11 JTF_VARCHAR2_TABLE_2000

Line 580: , p5_a8 JTF_NUMBER_TABLE

576: , p5_a4 JTF_DATE_TABLE
577: , p5_a5 JTF_DATE_TABLE
578: , p5_a6 JTF_DATE_TABLE
579: , p5_a7 JTF_NUMBER_TABLE
580: , p5_a8 JTF_NUMBER_TABLE
581: , p5_a9 JTF_VARCHAR2_TABLE_100
582: , p5_a10 JTF_NUMBER_TABLE
583: , p5_a11 JTF_VARCHAR2_TABLE_2000
584: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 582: , p5_a10 JTF_NUMBER_TABLE

578: , p5_a6 JTF_DATE_TABLE
579: , p5_a7 JTF_NUMBER_TABLE
580: , p5_a8 JTF_NUMBER_TABLE
581: , p5_a9 JTF_VARCHAR2_TABLE_100
582: , p5_a10 JTF_NUMBER_TABLE
583: , p5_a11 JTF_VARCHAR2_TABLE_2000
584: , p5_a12 JTF_VARCHAR2_TABLE_100
585: , p5_a13 JTF_VARCHAR2_TABLE_500
586: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 600: , p5_a28 JTF_NUMBER_TABLE

596: , p5_a24 JTF_VARCHAR2_TABLE_500
597: , p5_a25 JTF_VARCHAR2_TABLE_500
598: , p5_a26 JTF_VARCHAR2_TABLE_500
599: , p5_a27 JTF_VARCHAR2_TABLE_500
600: , p5_a28 JTF_NUMBER_TABLE
601: , p5_a29 JTF_NUMBER_TABLE
602: , p5_a30 JTF_NUMBER_TABLE
603: , p5_a31 JTF_DATE_TABLE
604: , p5_a32 JTF_NUMBER_TABLE

Line 601: , p5_a29 JTF_NUMBER_TABLE

597: , p5_a25 JTF_VARCHAR2_TABLE_500
598: , p5_a26 JTF_VARCHAR2_TABLE_500
599: , p5_a27 JTF_VARCHAR2_TABLE_500
600: , p5_a28 JTF_NUMBER_TABLE
601: , p5_a29 JTF_NUMBER_TABLE
602: , p5_a30 JTF_NUMBER_TABLE
603: , p5_a31 JTF_DATE_TABLE
604: , p5_a32 JTF_NUMBER_TABLE
605: , p5_a33 JTF_NUMBER_TABLE

Line 602: , p5_a30 JTF_NUMBER_TABLE

598: , p5_a26 JTF_VARCHAR2_TABLE_500
599: , p5_a27 JTF_VARCHAR2_TABLE_500
600: , p5_a28 JTF_NUMBER_TABLE
601: , p5_a29 JTF_NUMBER_TABLE
602: , p5_a30 JTF_NUMBER_TABLE
603: , p5_a31 JTF_DATE_TABLE
604: , p5_a32 JTF_NUMBER_TABLE
605: , p5_a33 JTF_NUMBER_TABLE
606: , p5_a34 JTF_DATE_TABLE

Line 604: , p5_a32 JTF_NUMBER_TABLE

600: , p5_a28 JTF_NUMBER_TABLE
601: , p5_a29 JTF_NUMBER_TABLE
602: , p5_a30 JTF_NUMBER_TABLE
603: , p5_a31 JTF_DATE_TABLE
604: , p5_a32 JTF_NUMBER_TABLE
605: , p5_a33 JTF_NUMBER_TABLE
606: , p5_a34 JTF_DATE_TABLE
607: , p5_a35 JTF_NUMBER_TABLE
608: , p5_a36 JTF_DATE_TABLE

Line 605: , p5_a33 JTF_NUMBER_TABLE

601: , p5_a29 JTF_NUMBER_TABLE
602: , p5_a30 JTF_NUMBER_TABLE
603: , p5_a31 JTF_DATE_TABLE
604: , p5_a32 JTF_NUMBER_TABLE
605: , p5_a33 JTF_NUMBER_TABLE
606: , p5_a34 JTF_DATE_TABLE
607: , p5_a35 JTF_NUMBER_TABLE
608: , p5_a36 JTF_DATE_TABLE
609: , p5_a37 JTF_NUMBER_TABLE

Line 607: , p5_a35 JTF_NUMBER_TABLE

603: , p5_a31 JTF_DATE_TABLE
604: , p5_a32 JTF_NUMBER_TABLE
605: , p5_a33 JTF_NUMBER_TABLE
606: , p5_a34 JTF_DATE_TABLE
607: , p5_a35 JTF_NUMBER_TABLE
608: , p5_a36 JTF_DATE_TABLE
609: , p5_a37 JTF_NUMBER_TABLE
610: , p5_a38 JTF_VARCHAR2_TABLE_100
611: , p5_a39 JTF_VARCHAR2_TABLE_100

Line 609: , p5_a37 JTF_NUMBER_TABLE

605: , p5_a33 JTF_NUMBER_TABLE
606: , p5_a34 JTF_DATE_TABLE
607: , p5_a35 JTF_NUMBER_TABLE
608: , p5_a36 JTF_DATE_TABLE
609: , p5_a37 JTF_NUMBER_TABLE
610: , p5_a38 JTF_VARCHAR2_TABLE_100
611: , p5_a39 JTF_VARCHAR2_TABLE_100
612: , p5_a40 JTF_NUMBER_TABLE
613: , p5_a41 JTF_DATE_TABLE

Line 612: , p5_a40 JTF_NUMBER_TABLE

608: , p5_a36 JTF_DATE_TABLE
609: , p5_a37 JTF_NUMBER_TABLE
610: , p5_a38 JTF_VARCHAR2_TABLE_100
611: , p5_a39 JTF_VARCHAR2_TABLE_100
612: , p5_a40 JTF_NUMBER_TABLE
613: , p5_a41 JTF_DATE_TABLE
614: , p5_a42 JTF_NUMBER_TABLE
615: );
616: procedure validate_trx_csh_batch(p_api_version NUMBER

Line 614: , p5_a42 JTF_NUMBER_TABLE

610: , p5_a38 JTF_VARCHAR2_TABLE_100
611: , p5_a39 JTF_VARCHAR2_TABLE_100
612: , p5_a40 JTF_NUMBER_TABLE
613: , p5_a41 JTF_DATE_TABLE
614: , p5_a42 JTF_NUMBER_TABLE
615: );
616: procedure validate_trx_csh_batch(p_api_version NUMBER
617: , p_init_msg_list VARCHAR2
618: , x_return_status out nocopy VARCHAR2

Line 713: , p7_a0 JTF_NUMBER_TABLE

709: , p6_a39 out nocopy VARCHAR2
710: , p6_a40 out nocopy NUMBER
711: , p6_a41 out nocopy DATE
712: , p6_a42 out nocopy NUMBER
713: , p7_a0 JTF_NUMBER_TABLE
714: , p7_a1 JTF_NUMBER_TABLE
715: , p7_a2 JTF_NUMBER_TABLE
716: , p7_a3 JTF_VARCHAR2_TABLE_100
717: , p7_a4 JTF_VARCHAR2_TABLE_100

Line 714: , p7_a1 JTF_NUMBER_TABLE

710: , p6_a40 out nocopy NUMBER
711: , p6_a41 out nocopy DATE
712: , p6_a42 out nocopy NUMBER
713: , p7_a0 JTF_NUMBER_TABLE
714: , p7_a1 JTF_NUMBER_TABLE
715: , p7_a2 JTF_NUMBER_TABLE
716: , p7_a3 JTF_VARCHAR2_TABLE_100
717: , p7_a4 JTF_VARCHAR2_TABLE_100
718: , p7_a5 JTF_VARCHAR2_TABLE_100

Line 715: , p7_a2 JTF_NUMBER_TABLE

711: , p6_a41 out nocopy DATE
712: , p6_a42 out nocopy NUMBER
713: , p7_a0 JTF_NUMBER_TABLE
714: , p7_a1 JTF_NUMBER_TABLE
715: , p7_a2 JTF_NUMBER_TABLE
716: , p7_a3 JTF_VARCHAR2_TABLE_100
717: , p7_a4 JTF_VARCHAR2_TABLE_100
718: , p7_a5 JTF_VARCHAR2_TABLE_100
719: , p7_a6 JTF_VARCHAR2_TABLE_100

Line 721: , p7_a8 JTF_NUMBER_TABLE

717: , p7_a4 JTF_VARCHAR2_TABLE_100
718: , p7_a5 JTF_VARCHAR2_TABLE_100
719: , p7_a6 JTF_VARCHAR2_TABLE_100
720: , p7_a7 JTF_DATE_TABLE
721: , p7_a8 JTF_NUMBER_TABLE
722: , p7_a9 JTF_NUMBER_TABLE
723: , p7_a10 JTF_NUMBER_TABLE
724: , p7_a11 JTF_NUMBER_TABLE
725: , p7_a12 JTF_VARCHAR2_TABLE_200

Line 722: , p7_a9 JTF_NUMBER_TABLE

718: , p7_a5 JTF_VARCHAR2_TABLE_100
719: , p7_a6 JTF_VARCHAR2_TABLE_100
720: , p7_a7 JTF_DATE_TABLE
721: , p7_a8 JTF_NUMBER_TABLE
722: , p7_a9 JTF_NUMBER_TABLE
723: , p7_a10 JTF_NUMBER_TABLE
724: , p7_a11 JTF_NUMBER_TABLE
725: , p7_a12 JTF_VARCHAR2_TABLE_200
726: , p7_a13 JTF_NUMBER_TABLE

Line 723: , p7_a10 JTF_NUMBER_TABLE

719: , p7_a6 JTF_VARCHAR2_TABLE_100
720: , p7_a7 JTF_DATE_TABLE
721: , p7_a8 JTF_NUMBER_TABLE
722: , p7_a9 JTF_NUMBER_TABLE
723: , p7_a10 JTF_NUMBER_TABLE
724: , p7_a11 JTF_NUMBER_TABLE
725: , p7_a12 JTF_VARCHAR2_TABLE_200
726: , p7_a13 JTF_NUMBER_TABLE
727: , p7_a14 JTF_VARCHAR2_TABLE_100

Line 724: , p7_a11 JTF_NUMBER_TABLE

720: , p7_a7 JTF_DATE_TABLE
721: , p7_a8 JTF_NUMBER_TABLE
722: , p7_a9 JTF_NUMBER_TABLE
723: , p7_a10 JTF_NUMBER_TABLE
724: , p7_a11 JTF_NUMBER_TABLE
725: , p7_a12 JTF_VARCHAR2_TABLE_200
726: , p7_a13 JTF_NUMBER_TABLE
727: , p7_a14 JTF_VARCHAR2_TABLE_100
728: , p7_a15 JTF_VARCHAR2_TABLE_100

Line 726: , p7_a13 JTF_NUMBER_TABLE

722: , p7_a9 JTF_NUMBER_TABLE
723: , p7_a10 JTF_NUMBER_TABLE
724: , p7_a11 JTF_NUMBER_TABLE
725: , p7_a12 JTF_VARCHAR2_TABLE_200
726: , p7_a13 JTF_NUMBER_TABLE
727: , p7_a14 JTF_VARCHAR2_TABLE_100
728: , p7_a15 JTF_VARCHAR2_TABLE_100
729: , p7_a16 JTF_VARCHAR2_TABLE_200
730: , p7_a17 JTF_VARCHAR2_TABLE_200

Line 744: , p8_a0 out nocopy JTF_NUMBER_TABLE

740: , p7_a27 JTF_VARCHAR2_TABLE_200
741: , p7_a28 JTF_VARCHAR2_TABLE_200
742: , p7_a29 JTF_VARCHAR2_TABLE_200
743: , p7_a30 JTF_VARCHAR2_TABLE_200
744: , p8_a0 out nocopy JTF_NUMBER_TABLE
745: , p8_a1 out nocopy JTF_NUMBER_TABLE
746: , p8_a2 out nocopy JTF_NUMBER_TABLE
747: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
748: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 745: , p8_a1 out nocopy JTF_NUMBER_TABLE

741: , p7_a28 JTF_VARCHAR2_TABLE_200
742: , p7_a29 JTF_VARCHAR2_TABLE_200
743: , p7_a30 JTF_VARCHAR2_TABLE_200
744: , p8_a0 out nocopy JTF_NUMBER_TABLE
745: , p8_a1 out nocopy JTF_NUMBER_TABLE
746: , p8_a2 out nocopy JTF_NUMBER_TABLE
747: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
748: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
749: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 746: , p8_a2 out nocopy JTF_NUMBER_TABLE

742: , p7_a29 JTF_VARCHAR2_TABLE_200
743: , p7_a30 JTF_VARCHAR2_TABLE_200
744: , p8_a0 out nocopy JTF_NUMBER_TABLE
745: , p8_a1 out nocopy JTF_NUMBER_TABLE
746: , p8_a2 out nocopy JTF_NUMBER_TABLE
747: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
748: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
749: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
750: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 752: , p8_a8 out nocopy JTF_NUMBER_TABLE

748: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
749: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
750: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
751: , p8_a7 out nocopy JTF_DATE_TABLE
752: , p8_a8 out nocopy JTF_NUMBER_TABLE
753: , p8_a9 out nocopy JTF_NUMBER_TABLE
754: , p8_a10 out nocopy JTF_NUMBER_TABLE
755: , p8_a11 out nocopy JTF_NUMBER_TABLE
756: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 753: , p8_a9 out nocopy JTF_NUMBER_TABLE

749: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
750: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
751: , p8_a7 out nocopy JTF_DATE_TABLE
752: , p8_a8 out nocopy JTF_NUMBER_TABLE
753: , p8_a9 out nocopy JTF_NUMBER_TABLE
754: , p8_a10 out nocopy JTF_NUMBER_TABLE
755: , p8_a11 out nocopy JTF_NUMBER_TABLE
756: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
757: , p8_a13 out nocopy JTF_NUMBER_TABLE

Line 754: , p8_a10 out nocopy JTF_NUMBER_TABLE

750: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
751: , p8_a7 out nocopy JTF_DATE_TABLE
752: , p8_a8 out nocopy JTF_NUMBER_TABLE
753: , p8_a9 out nocopy JTF_NUMBER_TABLE
754: , p8_a10 out nocopy JTF_NUMBER_TABLE
755: , p8_a11 out nocopy JTF_NUMBER_TABLE
756: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
757: , p8_a13 out nocopy JTF_NUMBER_TABLE
758: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 755: , p8_a11 out nocopy JTF_NUMBER_TABLE

751: , p8_a7 out nocopy JTF_DATE_TABLE
752: , p8_a8 out nocopy JTF_NUMBER_TABLE
753: , p8_a9 out nocopy JTF_NUMBER_TABLE
754: , p8_a10 out nocopy JTF_NUMBER_TABLE
755: , p8_a11 out nocopy JTF_NUMBER_TABLE
756: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
757: , p8_a13 out nocopy JTF_NUMBER_TABLE
758: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
759: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 757: , p8_a13 out nocopy JTF_NUMBER_TABLE

753: , p8_a9 out nocopy JTF_NUMBER_TABLE
754: , p8_a10 out nocopy JTF_NUMBER_TABLE
755: , p8_a11 out nocopy JTF_NUMBER_TABLE
756: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
757: , p8_a13 out nocopy JTF_NUMBER_TABLE
758: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
759: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
760: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
761: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200