APPS.OKL_CLD_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLICLDS.pls 120.6 2006/06/12 06:38:32 pagarg noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cld_pvt.cldv_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_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cld_pvt.cldv_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_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500

Line 33: , a30 JTF_VARCHAR2_TABLE_100

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

Line 34: , a31 JTF_VARCHAR2_TABLE_100

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

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_VARCHAR2_TABLE_500
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_2000
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: );

Line 41: , a38 JTF_VARCHAR2_TABLE_100

37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_2000
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p2(t okl_cld_pvt.cldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE

Line 42: , a39 JTF_VARCHAR2_TABLE_100

38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_2000
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p2(t okl_cld_pvt.cldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE

Line 47: , a3 out nocopy JTF_VARCHAR2_TABLE_100

43: );
44: procedure rosetta_table_copy_out_p2(t okl_cld_pvt.cldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_VARCHAR2_TABLE_500
50: , a6 out nocopy JTF_VARCHAR2_TABLE_500
51: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 48: , a4 out nocopy JTF_VARCHAR2_TABLE_100

44: procedure rosetta_table_copy_out_p2(t okl_cld_pvt.cldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_VARCHAR2_TABLE_500
50: , a6 out nocopy JTF_VARCHAR2_TABLE_500
51: , a7 out nocopy JTF_VARCHAR2_TABLE_500
52: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 74: , a30 out nocopy JTF_VARCHAR2_TABLE_100

70: , a26 out nocopy JTF_DATE_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_DATE_TABLE
73: , a29 out nocopy JTF_NUMBER_TABLE
74: , a30 out nocopy JTF_VARCHAR2_TABLE_100
75: , a31 out nocopy JTF_VARCHAR2_TABLE_100
76: , a32 out nocopy JTF_VARCHAR2_TABLE_500
77: , a33 out nocopy JTF_VARCHAR2_TABLE_500
78: , a34 out nocopy JTF_NUMBER_TABLE

Line 75: , a31 out nocopy JTF_VARCHAR2_TABLE_100

71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_DATE_TABLE
73: , a29 out nocopy JTF_NUMBER_TABLE
74: , a30 out nocopy JTF_VARCHAR2_TABLE_100
75: , a31 out nocopy JTF_VARCHAR2_TABLE_100
76: , a32 out nocopy JTF_VARCHAR2_TABLE_500
77: , a33 out nocopy JTF_VARCHAR2_TABLE_500
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE

Line 80: , a36 out nocopy JTF_VARCHAR2_TABLE_100

76: , a32 out nocopy JTF_VARCHAR2_TABLE_500
77: , a33 out nocopy JTF_VARCHAR2_TABLE_500
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_VARCHAR2_TABLE_100
81: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
83: , a39 out nocopy JTF_VARCHAR2_TABLE_100
84: );

Line 82: , a38 out nocopy JTF_VARCHAR2_TABLE_100

78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_VARCHAR2_TABLE_100
81: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
83: , a39 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_cld_pvt.cld_tbl_type, a0 JTF_NUMBER_TABLE

Line 83: , a39 out nocopy JTF_VARCHAR2_TABLE_100

79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_VARCHAR2_TABLE_100
81: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
83: , a39 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_cld_pvt.cld_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE

Line 89: , a3 JTF_VARCHAR2_TABLE_100

85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_cld_pvt.cld_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: , a2 JTF_NUMBER_TABLE
89: , a3 JTF_VARCHAR2_TABLE_100
90: , a4 JTF_VARCHAR2_TABLE_100
91: , a5 JTF_VARCHAR2_TABLE_500
92: , a6 JTF_VARCHAR2_TABLE_500
93: , a7 JTF_VARCHAR2_TABLE_500

Line 90: , a4 JTF_VARCHAR2_TABLE_100

86: procedure rosetta_table_copy_in_p5(t out nocopy okl_cld_pvt.cld_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: , a2 JTF_NUMBER_TABLE
89: , a3 JTF_VARCHAR2_TABLE_100
90: , a4 JTF_VARCHAR2_TABLE_100
91: , a5 JTF_VARCHAR2_TABLE_500
92: , a6 JTF_VARCHAR2_TABLE_500
93: , a7 JTF_VARCHAR2_TABLE_500
94: , a8 JTF_VARCHAR2_TABLE_500

Line 116: , a30 JTF_VARCHAR2_TABLE_100

112: , a26 JTF_DATE_TABLE
113: , a27 JTF_NUMBER_TABLE
114: , a28 JTF_DATE_TABLE
115: , a29 JTF_NUMBER_TABLE
116: , a30 JTF_VARCHAR2_TABLE_100
117: , a31 JTF_VARCHAR2_TABLE_100
118: , a32 JTF_VARCHAR2_TABLE_500
119: , a33 JTF_VARCHAR2_TABLE_500
120: , a34 JTF_NUMBER_TABLE

Line 117: , a31 JTF_VARCHAR2_TABLE_100

113: , a27 JTF_NUMBER_TABLE
114: , a28 JTF_DATE_TABLE
115: , a29 JTF_NUMBER_TABLE
116: , a30 JTF_VARCHAR2_TABLE_100
117: , a31 JTF_VARCHAR2_TABLE_100
118: , a32 JTF_VARCHAR2_TABLE_500
119: , a33 JTF_VARCHAR2_TABLE_500
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_NUMBER_TABLE

Line 122: , a36 JTF_VARCHAR2_TABLE_100

118: , a32 JTF_VARCHAR2_TABLE_500
119: , a33 JTF_VARCHAR2_TABLE_500
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_NUMBER_TABLE
122: , a36 JTF_VARCHAR2_TABLE_100
123: , a37 JTF_VARCHAR2_TABLE_2000
124: , a38 JTF_VARCHAR2_TABLE_100
125: , a39 JTF_VARCHAR2_TABLE_100
126: );

Line 124: , a38 JTF_VARCHAR2_TABLE_100

120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_NUMBER_TABLE
122: , a36 JTF_VARCHAR2_TABLE_100
123: , a37 JTF_VARCHAR2_TABLE_2000
124: , a38 JTF_VARCHAR2_TABLE_100
125: , a39 JTF_VARCHAR2_TABLE_100
126: );
127: procedure rosetta_table_copy_out_p5(t okl_cld_pvt.cld_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE

Line 125: , a39 JTF_VARCHAR2_TABLE_100

121: , a35 JTF_NUMBER_TABLE
122: , a36 JTF_VARCHAR2_TABLE_100
123: , a37 JTF_VARCHAR2_TABLE_2000
124: , a38 JTF_VARCHAR2_TABLE_100
125: , a39 JTF_VARCHAR2_TABLE_100
126: );
127: procedure rosetta_table_copy_out_p5(t okl_cld_pvt.cld_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE

Line 130: , a3 out nocopy JTF_VARCHAR2_TABLE_100

126: );
127: procedure rosetta_table_copy_out_p5(t okl_cld_pvt.cld_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_VARCHAR2_TABLE_100
131: , a4 out nocopy JTF_VARCHAR2_TABLE_100
132: , a5 out nocopy JTF_VARCHAR2_TABLE_500
133: , a6 out nocopy JTF_VARCHAR2_TABLE_500
134: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 131: , a4 out nocopy JTF_VARCHAR2_TABLE_100

127: procedure rosetta_table_copy_out_p5(t okl_cld_pvt.cld_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_VARCHAR2_TABLE_100
131: , a4 out nocopy JTF_VARCHAR2_TABLE_100
132: , a5 out nocopy JTF_VARCHAR2_TABLE_500
133: , a6 out nocopy JTF_VARCHAR2_TABLE_500
134: , a7 out nocopy JTF_VARCHAR2_TABLE_500
135: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 157: , a30 out nocopy JTF_VARCHAR2_TABLE_100

153: , a26 out nocopy JTF_DATE_TABLE
154: , a27 out nocopy JTF_NUMBER_TABLE
155: , a28 out nocopy JTF_DATE_TABLE
156: , a29 out nocopy JTF_NUMBER_TABLE
157: , a30 out nocopy JTF_VARCHAR2_TABLE_100
158: , a31 out nocopy JTF_VARCHAR2_TABLE_100
159: , a32 out nocopy JTF_VARCHAR2_TABLE_500
160: , a33 out nocopy JTF_VARCHAR2_TABLE_500
161: , a34 out nocopy JTF_NUMBER_TABLE

Line 158: , a31 out nocopy JTF_VARCHAR2_TABLE_100

154: , a27 out nocopy JTF_NUMBER_TABLE
155: , a28 out nocopy JTF_DATE_TABLE
156: , a29 out nocopy JTF_NUMBER_TABLE
157: , a30 out nocopy JTF_VARCHAR2_TABLE_100
158: , a31 out nocopy JTF_VARCHAR2_TABLE_100
159: , a32 out nocopy JTF_VARCHAR2_TABLE_500
160: , a33 out nocopy JTF_VARCHAR2_TABLE_500
161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_NUMBER_TABLE

Line 163: , a36 out nocopy JTF_VARCHAR2_TABLE_100

159: , a32 out nocopy JTF_VARCHAR2_TABLE_500
160: , a33 out nocopy JTF_VARCHAR2_TABLE_500
161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_NUMBER_TABLE
163: , a36 out nocopy JTF_VARCHAR2_TABLE_100
164: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
165: , a38 out nocopy JTF_VARCHAR2_TABLE_100
166: , a39 out nocopy JTF_VARCHAR2_TABLE_100
167: );

Line 165: , a38 out nocopy JTF_VARCHAR2_TABLE_100

161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_NUMBER_TABLE
163: , a36 out nocopy JTF_VARCHAR2_TABLE_100
164: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
165: , a38 out nocopy JTF_VARCHAR2_TABLE_100
166: , a39 out nocopy JTF_VARCHAR2_TABLE_100
167: );
168:
169: procedure insert_row(p_api_version NUMBER

Line 166: , a39 out nocopy JTF_VARCHAR2_TABLE_100

162: , a35 out nocopy JTF_NUMBER_TABLE
163: , a36 out nocopy JTF_VARCHAR2_TABLE_100
164: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
165: , a38 out nocopy JTF_VARCHAR2_TABLE_100
166: , a39 out nocopy JTF_VARCHAR2_TABLE_100
167: );
168:
169: procedure insert_row(p_api_version NUMBER
170: , p_init_msg_list VARCHAR2

Line 263: , p5_a3 JTF_VARCHAR2_TABLE_100

259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_VARCHAR2_TABLE_100
265: , p5_a5 JTF_VARCHAR2_TABLE_500
266: , p5_a6 JTF_VARCHAR2_TABLE_500
267: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 264: , p5_a4 JTF_VARCHAR2_TABLE_100

260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_VARCHAR2_TABLE_100
265: , p5_a5 JTF_VARCHAR2_TABLE_500
266: , p5_a6 JTF_VARCHAR2_TABLE_500
267: , p5_a7 JTF_VARCHAR2_TABLE_500
268: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 290: , p5_a30 JTF_VARCHAR2_TABLE_100

286: , p5_a26 JTF_DATE_TABLE
287: , p5_a27 JTF_NUMBER_TABLE
288: , p5_a28 JTF_DATE_TABLE
289: , p5_a29 JTF_NUMBER_TABLE
290: , p5_a30 JTF_VARCHAR2_TABLE_100
291: , p5_a31 JTF_VARCHAR2_TABLE_100
292: , p5_a32 JTF_VARCHAR2_TABLE_500
293: , p5_a33 JTF_VARCHAR2_TABLE_500
294: , p5_a34 JTF_NUMBER_TABLE

Line 291: , p5_a31 JTF_VARCHAR2_TABLE_100

287: , p5_a27 JTF_NUMBER_TABLE
288: , p5_a28 JTF_DATE_TABLE
289: , p5_a29 JTF_NUMBER_TABLE
290: , p5_a30 JTF_VARCHAR2_TABLE_100
291: , p5_a31 JTF_VARCHAR2_TABLE_100
292: , p5_a32 JTF_VARCHAR2_TABLE_500
293: , p5_a33 JTF_VARCHAR2_TABLE_500
294: , p5_a34 JTF_NUMBER_TABLE
295: , p5_a35 JTF_NUMBER_TABLE

Line 296: , p5_a36 JTF_VARCHAR2_TABLE_100

292: , p5_a32 JTF_VARCHAR2_TABLE_500
293: , p5_a33 JTF_VARCHAR2_TABLE_500
294: , p5_a34 JTF_NUMBER_TABLE
295: , p5_a35 JTF_NUMBER_TABLE
296: , p5_a36 JTF_VARCHAR2_TABLE_100
297: , p5_a37 JTF_VARCHAR2_TABLE_2000
298: , p5_a38 JTF_VARCHAR2_TABLE_100
299: , p5_a39 JTF_VARCHAR2_TABLE_100
300: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 298: , p5_a38 JTF_VARCHAR2_TABLE_100

294: , p5_a34 JTF_NUMBER_TABLE
295: , p5_a35 JTF_NUMBER_TABLE
296: , p5_a36 JTF_VARCHAR2_TABLE_100
297: , p5_a37 JTF_VARCHAR2_TABLE_2000
298: , p5_a38 JTF_VARCHAR2_TABLE_100
299: , p5_a39 JTF_VARCHAR2_TABLE_100
300: , p6_a0 out nocopy JTF_NUMBER_TABLE
301: , p6_a1 out nocopy JTF_NUMBER_TABLE
302: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 299: , p5_a39 JTF_VARCHAR2_TABLE_100

295: , p5_a35 JTF_NUMBER_TABLE
296: , p5_a36 JTF_VARCHAR2_TABLE_100
297: , p5_a37 JTF_VARCHAR2_TABLE_2000
298: , p5_a38 JTF_VARCHAR2_TABLE_100
299: , p5_a39 JTF_VARCHAR2_TABLE_100
300: , p6_a0 out nocopy JTF_NUMBER_TABLE
301: , p6_a1 out nocopy JTF_NUMBER_TABLE
302: , p6_a2 out nocopy JTF_NUMBER_TABLE
303: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 303: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

299: , p5_a39 JTF_VARCHAR2_TABLE_100
300: , p6_a0 out nocopy JTF_NUMBER_TABLE
301: , p6_a1 out nocopy JTF_NUMBER_TABLE
302: , p6_a2 out nocopy JTF_NUMBER_TABLE
303: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
306: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 304: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

300: , p6_a0 out nocopy JTF_NUMBER_TABLE
301: , p6_a1 out nocopy JTF_NUMBER_TABLE
302: , p6_a2 out nocopy JTF_NUMBER_TABLE
303: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
306: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
308: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 330: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

326: , p6_a26 out nocopy JTF_DATE_TABLE
327: , p6_a27 out nocopy JTF_NUMBER_TABLE
328: , p6_a28 out nocopy JTF_DATE_TABLE
329: , p6_a29 out nocopy JTF_NUMBER_TABLE
330: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 331: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

327: , p6_a27 out nocopy JTF_NUMBER_TABLE
328: , p6_a28 out nocopy JTF_DATE_TABLE
329: , p6_a29 out nocopy JTF_NUMBER_TABLE
330: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a34 out nocopy JTF_NUMBER_TABLE
335: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 336: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

332: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a34 out nocopy JTF_NUMBER_TABLE
335: , p6_a35 out nocopy JTF_NUMBER_TABLE
336: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
338: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
340: , p7_a0 in out nocopy JTF_NUMBER_TABLE

Line 338: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

334: , p6_a34 out nocopy JTF_NUMBER_TABLE
335: , p6_a35 out nocopy JTF_NUMBER_TABLE
336: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
338: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
340: , p7_a0 in out nocopy JTF_NUMBER_TABLE
341: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
342: , p7_a2 in out nocopy JTF_NUMBER_TABLE

Line 339: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

335: , p6_a35 out nocopy JTF_NUMBER_TABLE
336: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
338: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
340: , p7_a0 in out nocopy JTF_NUMBER_TABLE
341: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
342: , p7_a2 in out nocopy JTF_NUMBER_TABLE
343: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 341: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

337: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
338: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
340: , p7_a0 in out nocopy JTF_NUMBER_TABLE
341: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
342: , p7_a2 in out nocopy JTF_NUMBER_TABLE
343: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
344: , p7_a4 in out nocopy JTF_NUMBER_TABLE
345: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 345: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

341: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
342: , p7_a2 in out nocopy JTF_NUMBER_TABLE
343: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
344: , p7_a4 in out nocopy JTF_NUMBER_TABLE
345: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
346: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
347: );
348: procedure insert_row(p_api_version NUMBER
349: , p_init_msg_list VARCHAR2

Line 346: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

342: , p7_a2 in out nocopy JTF_NUMBER_TABLE
343: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
344: , p7_a4 in out nocopy JTF_NUMBER_TABLE
345: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
346: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
347: );
348: procedure insert_row(p_api_version NUMBER
349: , p_init_msg_list VARCHAR2
350: , x_return_status out nocopy VARCHAR2

Line 356: , p5_a3 JTF_VARCHAR2_TABLE_100

352: , x_msg_data out nocopy VARCHAR2
353: , p5_a0 JTF_NUMBER_TABLE
354: , p5_a1 JTF_NUMBER_TABLE
355: , p5_a2 JTF_NUMBER_TABLE
356: , p5_a3 JTF_VARCHAR2_TABLE_100
357: , p5_a4 JTF_VARCHAR2_TABLE_100
358: , p5_a5 JTF_VARCHAR2_TABLE_500
359: , p5_a6 JTF_VARCHAR2_TABLE_500
360: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 357: , p5_a4 JTF_VARCHAR2_TABLE_100

353: , p5_a0 JTF_NUMBER_TABLE
354: , p5_a1 JTF_NUMBER_TABLE
355: , p5_a2 JTF_NUMBER_TABLE
356: , p5_a3 JTF_VARCHAR2_TABLE_100
357: , p5_a4 JTF_VARCHAR2_TABLE_100
358: , p5_a5 JTF_VARCHAR2_TABLE_500
359: , p5_a6 JTF_VARCHAR2_TABLE_500
360: , p5_a7 JTF_VARCHAR2_TABLE_500
361: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 383: , p5_a30 JTF_VARCHAR2_TABLE_100

379: , p5_a26 JTF_DATE_TABLE
380: , p5_a27 JTF_NUMBER_TABLE
381: , p5_a28 JTF_DATE_TABLE
382: , p5_a29 JTF_NUMBER_TABLE
383: , p5_a30 JTF_VARCHAR2_TABLE_100
384: , p5_a31 JTF_VARCHAR2_TABLE_100
385: , p5_a32 JTF_VARCHAR2_TABLE_500
386: , p5_a33 JTF_VARCHAR2_TABLE_500
387: , p5_a34 JTF_NUMBER_TABLE

Line 384: , p5_a31 JTF_VARCHAR2_TABLE_100

380: , p5_a27 JTF_NUMBER_TABLE
381: , p5_a28 JTF_DATE_TABLE
382: , p5_a29 JTF_NUMBER_TABLE
383: , p5_a30 JTF_VARCHAR2_TABLE_100
384: , p5_a31 JTF_VARCHAR2_TABLE_100
385: , p5_a32 JTF_VARCHAR2_TABLE_500
386: , p5_a33 JTF_VARCHAR2_TABLE_500
387: , p5_a34 JTF_NUMBER_TABLE
388: , p5_a35 JTF_NUMBER_TABLE

Line 389: , p5_a36 JTF_VARCHAR2_TABLE_100

385: , p5_a32 JTF_VARCHAR2_TABLE_500
386: , p5_a33 JTF_VARCHAR2_TABLE_500
387: , p5_a34 JTF_NUMBER_TABLE
388: , p5_a35 JTF_NUMBER_TABLE
389: , p5_a36 JTF_VARCHAR2_TABLE_100
390: , p5_a37 JTF_VARCHAR2_TABLE_2000
391: , p5_a38 JTF_VARCHAR2_TABLE_100
392: , p5_a39 JTF_VARCHAR2_TABLE_100
393: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 391: , p5_a38 JTF_VARCHAR2_TABLE_100

387: , p5_a34 JTF_NUMBER_TABLE
388: , p5_a35 JTF_NUMBER_TABLE
389: , p5_a36 JTF_VARCHAR2_TABLE_100
390: , p5_a37 JTF_VARCHAR2_TABLE_2000
391: , p5_a38 JTF_VARCHAR2_TABLE_100
392: , p5_a39 JTF_VARCHAR2_TABLE_100
393: , p6_a0 out nocopy JTF_NUMBER_TABLE
394: , p6_a1 out nocopy JTF_NUMBER_TABLE
395: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 392: , p5_a39 JTF_VARCHAR2_TABLE_100

388: , p5_a35 JTF_NUMBER_TABLE
389: , p5_a36 JTF_VARCHAR2_TABLE_100
390: , p5_a37 JTF_VARCHAR2_TABLE_2000
391: , p5_a38 JTF_VARCHAR2_TABLE_100
392: , p5_a39 JTF_VARCHAR2_TABLE_100
393: , p6_a0 out nocopy JTF_NUMBER_TABLE
394: , p6_a1 out nocopy JTF_NUMBER_TABLE
395: , p6_a2 out nocopy JTF_NUMBER_TABLE
396: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 396: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

392: , p5_a39 JTF_VARCHAR2_TABLE_100
393: , p6_a0 out nocopy JTF_NUMBER_TABLE
394: , p6_a1 out nocopy JTF_NUMBER_TABLE
395: , p6_a2 out nocopy JTF_NUMBER_TABLE
396: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
397: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
398: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
399: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 397: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

393: , p6_a0 out nocopy JTF_NUMBER_TABLE
394: , p6_a1 out nocopy JTF_NUMBER_TABLE
395: , p6_a2 out nocopy JTF_NUMBER_TABLE
396: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
397: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
398: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
399: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
401: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 423: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

419: , p6_a26 out nocopy JTF_DATE_TABLE
420: , p6_a27 out nocopy JTF_NUMBER_TABLE
421: , p6_a28 out nocopy JTF_DATE_TABLE
422: , p6_a29 out nocopy JTF_NUMBER_TABLE
423: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
424: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
426: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
427: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 424: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

420: , p6_a27 out nocopy JTF_NUMBER_TABLE
421: , p6_a28 out nocopy JTF_DATE_TABLE
422: , p6_a29 out nocopy JTF_NUMBER_TABLE
423: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
424: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
426: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
427: , p6_a34 out nocopy JTF_NUMBER_TABLE
428: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 429: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

425: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
426: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
427: , p6_a34 out nocopy JTF_NUMBER_TABLE
428: , p6_a35 out nocopy JTF_NUMBER_TABLE
429: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
431: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
432: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
433: );

Line 431: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

427: , p6_a34 out nocopy JTF_NUMBER_TABLE
428: , p6_a35 out nocopy JTF_NUMBER_TABLE
429: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
431: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
432: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
433: );
434: procedure lock_row(p_api_version NUMBER
435: , p_init_msg_list VARCHAR2

Line 432: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

428: , p6_a35 out nocopy JTF_NUMBER_TABLE
429: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
431: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
432: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
433: );
434: procedure lock_row(p_api_version NUMBER
435: , p_init_msg_list VARCHAR2
436: , x_return_status out nocopy VARCHAR2

Line 488: , p5_a3 JTF_VARCHAR2_TABLE_100

484: , x_msg_data out nocopy VARCHAR2
485: , p5_a0 JTF_NUMBER_TABLE
486: , p5_a1 JTF_NUMBER_TABLE
487: , p5_a2 JTF_NUMBER_TABLE
488: , p5_a3 JTF_VARCHAR2_TABLE_100
489: , p5_a4 JTF_VARCHAR2_TABLE_100
490: , p5_a5 JTF_VARCHAR2_TABLE_500
491: , p5_a6 JTF_VARCHAR2_TABLE_500
492: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 489: , p5_a4 JTF_VARCHAR2_TABLE_100

485: , p5_a0 JTF_NUMBER_TABLE
486: , p5_a1 JTF_NUMBER_TABLE
487: , p5_a2 JTF_NUMBER_TABLE
488: , p5_a3 JTF_VARCHAR2_TABLE_100
489: , p5_a4 JTF_VARCHAR2_TABLE_100
490: , p5_a5 JTF_VARCHAR2_TABLE_500
491: , p5_a6 JTF_VARCHAR2_TABLE_500
492: , p5_a7 JTF_VARCHAR2_TABLE_500
493: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 515: , p5_a30 JTF_VARCHAR2_TABLE_100

511: , p5_a26 JTF_DATE_TABLE
512: , p5_a27 JTF_NUMBER_TABLE
513: , p5_a28 JTF_DATE_TABLE
514: , p5_a29 JTF_NUMBER_TABLE
515: , p5_a30 JTF_VARCHAR2_TABLE_100
516: , p5_a31 JTF_VARCHAR2_TABLE_100
517: , p5_a32 JTF_VARCHAR2_TABLE_500
518: , p5_a33 JTF_VARCHAR2_TABLE_500
519: , p5_a34 JTF_NUMBER_TABLE

Line 516: , p5_a31 JTF_VARCHAR2_TABLE_100

512: , p5_a27 JTF_NUMBER_TABLE
513: , p5_a28 JTF_DATE_TABLE
514: , p5_a29 JTF_NUMBER_TABLE
515: , p5_a30 JTF_VARCHAR2_TABLE_100
516: , p5_a31 JTF_VARCHAR2_TABLE_100
517: , p5_a32 JTF_VARCHAR2_TABLE_500
518: , p5_a33 JTF_VARCHAR2_TABLE_500
519: , p5_a34 JTF_NUMBER_TABLE
520: , p5_a35 JTF_NUMBER_TABLE

Line 521: , p5_a36 JTF_VARCHAR2_TABLE_100

517: , p5_a32 JTF_VARCHAR2_TABLE_500
518: , p5_a33 JTF_VARCHAR2_TABLE_500
519: , p5_a34 JTF_NUMBER_TABLE
520: , p5_a35 JTF_NUMBER_TABLE
521: , p5_a36 JTF_VARCHAR2_TABLE_100
522: , p5_a37 JTF_VARCHAR2_TABLE_2000
523: , p5_a38 JTF_VARCHAR2_TABLE_100
524: , p5_a39 JTF_VARCHAR2_TABLE_100
525: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 523: , p5_a38 JTF_VARCHAR2_TABLE_100

519: , p5_a34 JTF_NUMBER_TABLE
520: , p5_a35 JTF_NUMBER_TABLE
521: , p5_a36 JTF_VARCHAR2_TABLE_100
522: , p5_a37 JTF_VARCHAR2_TABLE_2000
523: , p5_a38 JTF_VARCHAR2_TABLE_100
524: , p5_a39 JTF_VARCHAR2_TABLE_100
525: , p6_a0 in out nocopy JTF_NUMBER_TABLE
526: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
527: , p6_a2 in out nocopy JTF_NUMBER_TABLE

Line 524: , p5_a39 JTF_VARCHAR2_TABLE_100

520: , p5_a35 JTF_NUMBER_TABLE
521: , p5_a36 JTF_VARCHAR2_TABLE_100
522: , p5_a37 JTF_VARCHAR2_TABLE_2000
523: , p5_a38 JTF_VARCHAR2_TABLE_100
524: , p5_a39 JTF_VARCHAR2_TABLE_100
525: , p6_a0 in out nocopy JTF_NUMBER_TABLE
526: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
527: , p6_a2 in out nocopy JTF_NUMBER_TABLE
528: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 526: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

522: , p5_a37 JTF_VARCHAR2_TABLE_2000
523: , p5_a38 JTF_VARCHAR2_TABLE_100
524: , p5_a39 JTF_VARCHAR2_TABLE_100
525: , p6_a0 in out nocopy JTF_NUMBER_TABLE
526: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
527: , p6_a2 in out nocopy JTF_NUMBER_TABLE
528: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
529: , p6_a4 in out nocopy JTF_NUMBER_TABLE
530: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 530: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

526: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
527: , p6_a2 in out nocopy JTF_NUMBER_TABLE
528: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
529: , p6_a4 in out nocopy JTF_NUMBER_TABLE
530: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
532: );
533: procedure lock_row(p_api_version NUMBER
534: , p_init_msg_list VARCHAR2

Line 531: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

527: , p6_a2 in out nocopy JTF_NUMBER_TABLE
528: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
529: , p6_a4 in out nocopy JTF_NUMBER_TABLE
530: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
532: );
533: procedure lock_row(p_api_version NUMBER
534: , p_init_msg_list VARCHAR2
535: , x_return_status out nocopy VARCHAR2

Line 541: , p5_a3 JTF_VARCHAR2_TABLE_100

537: , x_msg_data out nocopy VARCHAR2
538: , p5_a0 JTF_NUMBER_TABLE
539: , p5_a1 JTF_NUMBER_TABLE
540: , p5_a2 JTF_NUMBER_TABLE
541: , p5_a3 JTF_VARCHAR2_TABLE_100
542: , p5_a4 JTF_VARCHAR2_TABLE_100
543: , p5_a5 JTF_VARCHAR2_TABLE_500
544: , p5_a6 JTF_VARCHAR2_TABLE_500
545: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 542: , p5_a4 JTF_VARCHAR2_TABLE_100

538: , p5_a0 JTF_NUMBER_TABLE
539: , p5_a1 JTF_NUMBER_TABLE
540: , p5_a2 JTF_NUMBER_TABLE
541: , p5_a3 JTF_VARCHAR2_TABLE_100
542: , p5_a4 JTF_VARCHAR2_TABLE_100
543: , p5_a5 JTF_VARCHAR2_TABLE_500
544: , p5_a6 JTF_VARCHAR2_TABLE_500
545: , p5_a7 JTF_VARCHAR2_TABLE_500
546: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 568: , p5_a30 JTF_VARCHAR2_TABLE_100

564: , p5_a26 JTF_DATE_TABLE
565: , p5_a27 JTF_NUMBER_TABLE
566: , p5_a28 JTF_DATE_TABLE
567: , p5_a29 JTF_NUMBER_TABLE
568: , p5_a30 JTF_VARCHAR2_TABLE_100
569: , p5_a31 JTF_VARCHAR2_TABLE_100
570: , p5_a32 JTF_VARCHAR2_TABLE_500
571: , p5_a33 JTF_VARCHAR2_TABLE_500
572: , p5_a34 JTF_NUMBER_TABLE

Line 569: , p5_a31 JTF_VARCHAR2_TABLE_100

565: , p5_a27 JTF_NUMBER_TABLE
566: , p5_a28 JTF_DATE_TABLE
567: , p5_a29 JTF_NUMBER_TABLE
568: , p5_a30 JTF_VARCHAR2_TABLE_100
569: , p5_a31 JTF_VARCHAR2_TABLE_100
570: , p5_a32 JTF_VARCHAR2_TABLE_500
571: , p5_a33 JTF_VARCHAR2_TABLE_500
572: , p5_a34 JTF_NUMBER_TABLE
573: , p5_a35 JTF_NUMBER_TABLE

Line 574: , p5_a36 JTF_VARCHAR2_TABLE_100

570: , p5_a32 JTF_VARCHAR2_TABLE_500
571: , p5_a33 JTF_VARCHAR2_TABLE_500
572: , p5_a34 JTF_NUMBER_TABLE
573: , p5_a35 JTF_NUMBER_TABLE
574: , p5_a36 JTF_VARCHAR2_TABLE_100
575: , p5_a37 JTF_VARCHAR2_TABLE_2000
576: , p5_a38 JTF_VARCHAR2_TABLE_100
577: , p5_a39 JTF_VARCHAR2_TABLE_100
578: );

Line 576: , p5_a38 JTF_VARCHAR2_TABLE_100

572: , p5_a34 JTF_NUMBER_TABLE
573: , p5_a35 JTF_NUMBER_TABLE
574: , p5_a36 JTF_VARCHAR2_TABLE_100
575: , p5_a37 JTF_VARCHAR2_TABLE_2000
576: , p5_a38 JTF_VARCHAR2_TABLE_100
577: , p5_a39 JTF_VARCHAR2_TABLE_100
578: );
579: procedure update_row(p_api_version NUMBER
580: , p_init_msg_list VARCHAR2

Line 577: , p5_a39 JTF_VARCHAR2_TABLE_100

573: , p5_a35 JTF_NUMBER_TABLE
574: , p5_a36 JTF_VARCHAR2_TABLE_100
575: , p5_a37 JTF_VARCHAR2_TABLE_2000
576: , p5_a38 JTF_VARCHAR2_TABLE_100
577: , p5_a39 JTF_VARCHAR2_TABLE_100
578: );
579: procedure update_row(p_api_version NUMBER
580: , p_init_msg_list VARCHAR2
581: , x_return_status out nocopy VARCHAR2

Line 673: , p5_a3 JTF_VARCHAR2_TABLE_100

669: , x_msg_data out nocopy VARCHAR2
670: , p5_a0 JTF_NUMBER_TABLE
671: , p5_a1 JTF_NUMBER_TABLE
672: , p5_a2 JTF_NUMBER_TABLE
673: , p5_a3 JTF_VARCHAR2_TABLE_100
674: , p5_a4 JTF_VARCHAR2_TABLE_100
675: , p5_a5 JTF_VARCHAR2_TABLE_500
676: , p5_a6 JTF_VARCHAR2_TABLE_500
677: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 674: , p5_a4 JTF_VARCHAR2_TABLE_100

670: , p5_a0 JTF_NUMBER_TABLE
671: , p5_a1 JTF_NUMBER_TABLE
672: , p5_a2 JTF_NUMBER_TABLE
673: , p5_a3 JTF_VARCHAR2_TABLE_100
674: , p5_a4 JTF_VARCHAR2_TABLE_100
675: , p5_a5 JTF_VARCHAR2_TABLE_500
676: , p5_a6 JTF_VARCHAR2_TABLE_500
677: , p5_a7 JTF_VARCHAR2_TABLE_500
678: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 700: , p5_a30 JTF_VARCHAR2_TABLE_100

696: , p5_a26 JTF_DATE_TABLE
697: , p5_a27 JTF_NUMBER_TABLE
698: , p5_a28 JTF_DATE_TABLE
699: , p5_a29 JTF_NUMBER_TABLE
700: , p5_a30 JTF_VARCHAR2_TABLE_100
701: , p5_a31 JTF_VARCHAR2_TABLE_100
702: , p5_a32 JTF_VARCHAR2_TABLE_500
703: , p5_a33 JTF_VARCHAR2_TABLE_500
704: , p5_a34 JTF_NUMBER_TABLE

Line 701: , p5_a31 JTF_VARCHAR2_TABLE_100

697: , p5_a27 JTF_NUMBER_TABLE
698: , p5_a28 JTF_DATE_TABLE
699: , p5_a29 JTF_NUMBER_TABLE
700: , p5_a30 JTF_VARCHAR2_TABLE_100
701: , p5_a31 JTF_VARCHAR2_TABLE_100
702: , p5_a32 JTF_VARCHAR2_TABLE_500
703: , p5_a33 JTF_VARCHAR2_TABLE_500
704: , p5_a34 JTF_NUMBER_TABLE
705: , p5_a35 JTF_NUMBER_TABLE

Line 706: , p5_a36 JTF_VARCHAR2_TABLE_100

702: , p5_a32 JTF_VARCHAR2_TABLE_500
703: , p5_a33 JTF_VARCHAR2_TABLE_500
704: , p5_a34 JTF_NUMBER_TABLE
705: , p5_a35 JTF_NUMBER_TABLE
706: , p5_a36 JTF_VARCHAR2_TABLE_100
707: , p5_a37 JTF_VARCHAR2_TABLE_2000
708: , p5_a38 JTF_VARCHAR2_TABLE_100
709: , p5_a39 JTF_VARCHAR2_TABLE_100
710: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 708: , p5_a38 JTF_VARCHAR2_TABLE_100

704: , p5_a34 JTF_NUMBER_TABLE
705: , p5_a35 JTF_NUMBER_TABLE
706: , p5_a36 JTF_VARCHAR2_TABLE_100
707: , p5_a37 JTF_VARCHAR2_TABLE_2000
708: , p5_a38 JTF_VARCHAR2_TABLE_100
709: , p5_a39 JTF_VARCHAR2_TABLE_100
710: , p6_a0 out nocopy JTF_NUMBER_TABLE
711: , p6_a1 out nocopy JTF_NUMBER_TABLE
712: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 709: , p5_a39 JTF_VARCHAR2_TABLE_100

705: , p5_a35 JTF_NUMBER_TABLE
706: , p5_a36 JTF_VARCHAR2_TABLE_100
707: , p5_a37 JTF_VARCHAR2_TABLE_2000
708: , p5_a38 JTF_VARCHAR2_TABLE_100
709: , p5_a39 JTF_VARCHAR2_TABLE_100
710: , p6_a0 out nocopy JTF_NUMBER_TABLE
711: , p6_a1 out nocopy JTF_NUMBER_TABLE
712: , p6_a2 out nocopy JTF_NUMBER_TABLE
713: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 713: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

709: , p5_a39 JTF_VARCHAR2_TABLE_100
710: , p6_a0 out nocopy JTF_NUMBER_TABLE
711: , p6_a1 out nocopy JTF_NUMBER_TABLE
712: , p6_a2 out nocopy JTF_NUMBER_TABLE
713: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
716: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
717: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 714: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

710: , p6_a0 out nocopy JTF_NUMBER_TABLE
711: , p6_a1 out nocopy JTF_NUMBER_TABLE
712: , p6_a2 out nocopy JTF_NUMBER_TABLE
713: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
716: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
717: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
718: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 740: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

736: , p6_a26 out nocopy JTF_DATE_TABLE
737: , p6_a27 out nocopy JTF_NUMBER_TABLE
738: , p6_a28 out nocopy JTF_DATE_TABLE
739: , p6_a29 out nocopy JTF_NUMBER_TABLE
740: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
743: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
744: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 741: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

737: , p6_a27 out nocopy JTF_NUMBER_TABLE
738: , p6_a28 out nocopy JTF_DATE_TABLE
739: , p6_a29 out nocopy JTF_NUMBER_TABLE
740: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
743: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
744: , p6_a34 out nocopy JTF_NUMBER_TABLE
745: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 746: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

742: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
743: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
744: , p6_a34 out nocopy JTF_NUMBER_TABLE
745: , p6_a35 out nocopy JTF_NUMBER_TABLE
746: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
747: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
748: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
750: , p7_a0 in out nocopy JTF_NUMBER_TABLE

Line 748: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

744: , p6_a34 out nocopy JTF_NUMBER_TABLE
745: , p6_a35 out nocopy JTF_NUMBER_TABLE
746: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
747: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
748: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
750: , p7_a0 in out nocopy JTF_NUMBER_TABLE
751: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p7_a2 in out nocopy JTF_NUMBER_TABLE

Line 749: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

745: , p6_a35 out nocopy JTF_NUMBER_TABLE
746: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
747: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
748: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
750: , p7_a0 in out nocopy JTF_NUMBER_TABLE
751: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p7_a2 in out nocopy JTF_NUMBER_TABLE
753: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 751: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

747: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
748: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
750: , p7_a0 in out nocopy JTF_NUMBER_TABLE
751: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p7_a2 in out nocopy JTF_NUMBER_TABLE
753: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
754: , p7_a4 in out nocopy JTF_NUMBER_TABLE
755: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 755: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

751: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p7_a2 in out nocopy JTF_NUMBER_TABLE
753: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
754: , p7_a4 in out nocopy JTF_NUMBER_TABLE
755: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
756: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
757: );
758: procedure update_row(p_api_version NUMBER
759: , p_init_msg_list VARCHAR2

Line 756: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

752: , p7_a2 in out nocopy JTF_NUMBER_TABLE
753: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
754: , p7_a4 in out nocopy JTF_NUMBER_TABLE
755: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
756: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
757: );
758: procedure update_row(p_api_version NUMBER
759: , p_init_msg_list VARCHAR2
760: , x_return_status out nocopy VARCHAR2

Line 766: , p5_a3 JTF_VARCHAR2_TABLE_100

762: , x_msg_data out nocopy VARCHAR2
763: , p5_a0 JTF_NUMBER_TABLE
764: , p5_a1 JTF_NUMBER_TABLE
765: , p5_a2 JTF_NUMBER_TABLE
766: , p5_a3 JTF_VARCHAR2_TABLE_100
767: , p5_a4 JTF_VARCHAR2_TABLE_100
768: , p5_a5 JTF_VARCHAR2_TABLE_500
769: , p5_a6 JTF_VARCHAR2_TABLE_500
770: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 767: , p5_a4 JTF_VARCHAR2_TABLE_100

763: , p5_a0 JTF_NUMBER_TABLE
764: , p5_a1 JTF_NUMBER_TABLE
765: , p5_a2 JTF_NUMBER_TABLE
766: , p5_a3 JTF_VARCHAR2_TABLE_100
767: , p5_a4 JTF_VARCHAR2_TABLE_100
768: , p5_a5 JTF_VARCHAR2_TABLE_500
769: , p5_a6 JTF_VARCHAR2_TABLE_500
770: , p5_a7 JTF_VARCHAR2_TABLE_500
771: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 793: , p5_a30 JTF_VARCHAR2_TABLE_100

789: , p5_a26 JTF_DATE_TABLE
790: , p5_a27 JTF_NUMBER_TABLE
791: , p5_a28 JTF_DATE_TABLE
792: , p5_a29 JTF_NUMBER_TABLE
793: , p5_a30 JTF_VARCHAR2_TABLE_100
794: , p5_a31 JTF_VARCHAR2_TABLE_100
795: , p5_a32 JTF_VARCHAR2_TABLE_500
796: , p5_a33 JTF_VARCHAR2_TABLE_500
797: , p5_a34 JTF_NUMBER_TABLE

Line 794: , p5_a31 JTF_VARCHAR2_TABLE_100

790: , p5_a27 JTF_NUMBER_TABLE
791: , p5_a28 JTF_DATE_TABLE
792: , p5_a29 JTF_NUMBER_TABLE
793: , p5_a30 JTF_VARCHAR2_TABLE_100
794: , p5_a31 JTF_VARCHAR2_TABLE_100
795: , p5_a32 JTF_VARCHAR2_TABLE_500
796: , p5_a33 JTF_VARCHAR2_TABLE_500
797: , p5_a34 JTF_NUMBER_TABLE
798: , p5_a35 JTF_NUMBER_TABLE

Line 799: , p5_a36 JTF_VARCHAR2_TABLE_100

795: , p5_a32 JTF_VARCHAR2_TABLE_500
796: , p5_a33 JTF_VARCHAR2_TABLE_500
797: , p5_a34 JTF_NUMBER_TABLE
798: , p5_a35 JTF_NUMBER_TABLE
799: , p5_a36 JTF_VARCHAR2_TABLE_100
800: , p5_a37 JTF_VARCHAR2_TABLE_2000
801: , p5_a38 JTF_VARCHAR2_TABLE_100
802: , p5_a39 JTF_VARCHAR2_TABLE_100
803: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 801: , p5_a38 JTF_VARCHAR2_TABLE_100

797: , p5_a34 JTF_NUMBER_TABLE
798: , p5_a35 JTF_NUMBER_TABLE
799: , p5_a36 JTF_VARCHAR2_TABLE_100
800: , p5_a37 JTF_VARCHAR2_TABLE_2000
801: , p5_a38 JTF_VARCHAR2_TABLE_100
802: , p5_a39 JTF_VARCHAR2_TABLE_100
803: , p6_a0 out nocopy JTF_NUMBER_TABLE
804: , p6_a1 out nocopy JTF_NUMBER_TABLE
805: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 802: , p5_a39 JTF_VARCHAR2_TABLE_100

798: , p5_a35 JTF_NUMBER_TABLE
799: , p5_a36 JTF_VARCHAR2_TABLE_100
800: , p5_a37 JTF_VARCHAR2_TABLE_2000
801: , p5_a38 JTF_VARCHAR2_TABLE_100
802: , p5_a39 JTF_VARCHAR2_TABLE_100
803: , p6_a0 out nocopy JTF_NUMBER_TABLE
804: , p6_a1 out nocopy JTF_NUMBER_TABLE
805: , p6_a2 out nocopy JTF_NUMBER_TABLE
806: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 806: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

802: , p5_a39 JTF_VARCHAR2_TABLE_100
803: , p6_a0 out nocopy JTF_NUMBER_TABLE
804: , p6_a1 out nocopy JTF_NUMBER_TABLE
805: , p6_a2 out nocopy JTF_NUMBER_TABLE
806: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
808: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
809: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 807: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

803: , p6_a0 out nocopy JTF_NUMBER_TABLE
804: , p6_a1 out nocopy JTF_NUMBER_TABLE
805: , p6_a2 out nocopy JTF_NUMBER_TABLE
806: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
808: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
809: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
811: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 833: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

829: , p6_a26 out nocopy JTF_DATE_TABLE
830: , p6_a27 out nocopy JTF_NUMBER_TABLE
831: , p6_a28 out nocopy JTF_DATE_TABLE
832: , p6_a29 out nocopy JTF_NUMBER_TABLE
833: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
834: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
835: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
836: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
837: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 834: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

830: , p6_a27 out nocopy JTF_NUMBER_TABLE
831: , p6_a28 out nocopy JTF_DATE_TABLE
832: , p6_a29 out nocopy JTF_NUMBER_TABLE
833: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
834: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
835: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
836: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
837: , p6_a34 out nocopy JTF_NUMBER_TABLE
838: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 839: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

835: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
836: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
837: , p6_a34 out nocopy JTF_NUMBER_TABLE
838: , p6_a35 out nocopy JTF_NUMBER_TABLE
839: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
840: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
841: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
842: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
843: );

Line 841: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

837: , p6_a34 out nocopy JTF_NUMBER_TABLE
838: , p6_a35 out nocopy JTF_NUMBER_TABLE
839: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
840: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
841: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
842: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
843: );
844: procedure delete_row(p_api_version NUMBER
845: , p_init_msg_list VARCHAR2

Line 842: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

838: , p6_a35 out nocopy JTF_NUMBER_TABLE
839: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
840: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
841: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
842: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
843: );
844: procedure delete_row(p_api_version NUMBER
845: , p_init_msg_list VARCHAR2
846: , x_return_status out nocopy VARCHAR2

Line 898: , p5_a3 JTF_VARCHAR2_TABLE_100

894: , x_msg_data out nocopy VARCHAR2
895: , p5_a0 JTF_NUMBER_TABLE
896: , p5_a1 JTF_NUMBER_TABLE
897: , p5_a2 JTF_NUMBER_TABLE
898: , p5_a3 JTF_VARCHAR2_TABLE_100
899: , p5_a4 JTF_VARCHAR2_TABLE_100
900: , p5_a5 JTF_VARCHAR2_TABLE_500
901: , p5_a6 JTF_VARCHAR2_TABLE_500
902: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 899: , p5_a4 JTF_VARCHAR2_TABLE_100

895: , p5_a0 JTF_NUMBER_TABLE
896: , p5_a1 JTF_NUMBER_TABLE
897: , p5_a2 JTF_NUMBER_TABLE
898: , p5_a3 JTF_VARCHAR2_TABLE_100
899: , p5_a4 JTF_VARCHAR2_TABLE_100
900: , p5_a5 JTF_VARCHAR2_TABLE_500
901: , p5_a6 JTF_VARCHAR2_TABLE_500
902: , p5_a7 JTF_VARCHAR2_TABLE_500
903: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 925: , p5_a30 JTF_VARCHAR2_TABLE_100

921: , p5_a26 JTF_DATE_TABLE
922: , p5_a27 JTF_NUMBER_TABLE
923: , p5_a28 JTF_DATE_TABLE
924: , p5_a29 JTF_NUMBER_TABLE
925: , p5_a30 JTF_VARCHAR2_TABLE_100
926: , p5_a31 JTF_VARCHAR2_TABLE_100
927: , p5_a32 JTF_VARCHAR2_TABLE_500
928: , p5_a33 JTF_VARCHAR2_TABLE_500
929: , p5_a34 JTF_NUMBER_TABLE

Line 926: , p5_a31 JTF_VARCHAR2_TABLE_100

922: , p5_a27 JTF_NUMBER_TABLE
923: , p5_a28 JTF_DATE_TABLE
924: , p5_a29 JTF_NUMBER_TABLE
925: , p5_a30 JTF_VARCHAR2_TABLE_100
926: , p5_a31 JTF_VARCHAR2_TABLE_100
927: , p5_a32 JTF_VARCHAR2_TABLE_500
928: , p5_a33 JTF_VARCHAR2_TABLE_500
929: , p5_a34 JTF_NUMBER_TABLE
930: , p5_a35 JTF_NUMBER_TABLE

Line 931: , p5_a36 JTF_VARCHAR2_TABLE_100

927: , p5_a32 JTF_VARCHAR2_TABLE_500
928: , p5_a33 JTF_VARCHAR2_TABLE_500
929: , p5_a34 JTF_NUMBER_TABLE
930: , p5_a35 JTF_NUMBER_TABLE
931: , p5_a36 JTF_VARCHAR2_TABLE_100
932: , p5_a37 JTF_VARCHAR2_TABLE_2000
933: , p5_a38 JTF_VARCHAR2_TABLE_100
934: , p5_a39 JTF_VARCHAR2_TABLE_100
935: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 933: , p5_a38 JTF_VARCHAR2_TABLE_100

929: , p5_a34 JTF_NUMBER_TABLE
930: , p5_a35 JTF_NUMBER_TABLE
931: , p5_a36 JTF_VARCHAR2_TABLE_100
932: , p5_a37 JTF_VARCHAR2_TABLE_2000
933: , p5_a38 JTF_VARCHAR2_TABLE_100
934: , p5_a39 JTF_VARCHAR2_TABLE_100
935: , p6_a0 in out nocopy JTF_NUMBER_TABLE
936: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a2 in out nocopy JTF_NUMBER_TABLE

Line 934: , p5_a39 JTF_VARCHAR2_TABLE_100

930: , p5_a35 JTF_NUMBER_TABLE
931: , p5_a36 JTF_VARCHAR2_TABLE_100
932: , p5_a37 JTF_VARCHAR2_TABLE_2000
933: , p5_a38 JTF_VARCHAR2_TABLE_100
934: , p5_a39 JTF_VARCHAR2_TABLE_100
935: , p6_a0 in out nocopy JTF_NUMBER_TABLE
936: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a2 in out nocopy JTF_NUMBER_TABLE
938: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 936: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

932: , p5_a37 JTF_VARCHAR2_TABLE_2000
933: , p5_a38 JTF_VARCHAR2_TABLE_100
934: , p5_a39 JTF_VARCHAR2_TABLE_100
935: , p6_a0 in out nocopy JTF_NUMBER_TABLE
936: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a2 in out nocopy JTF_NUMBER_TABLE
938: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
939: , p6_a4 in out nocopy JTF_NUMBER_TABLE
940: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 940: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

936: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a2 in out nocopy JTF_NUMBER_TABLE
938: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
939: , p6_a4 in out nocopy JTF_NUMBER_TABLE
940: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
942: );
943: procedure delete_row(p_api_version NUMBER
944: , p_init_msg_list VARCHAR2

Line 941: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

937: , p6_a2 in out nocopy JTF_NUMBER_TABLE
938: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
939: , p6_a4 in out nocopy JTF_NUMBER_TABLE
940: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
942: );
943: procedure delete_row(p_api_version NUMBER
944: , p_init_msg_list VARCHAR2
945: , x_return_status out nocopy VARCHAR2

Line 951: , p5_a3 JTF_VARCHAR2_TABLE_100

947: , x_msg_data out nocopy VARCHAR2
948: , p5_a0 JTF_NUMBER_TABLE
949: , p5_a1 JTF_NUMBER_TABLE
950: , p5_a2 JTF_NUMBER_TABLE
951: , p5_a3 JTF_VARCHAR2_TABLE_100
952: , p5_a4 JTF_VARCHAR2_TABLE_100
953: , p5_a5 JTF_VARCHAR2_TABLE_500
954: , p5_a6 JTF_VARCHAR2_TABLE_500
955: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 952: , p5_a4 JTF_VARCHAR2_TABLE_100

948: , p5_a0 JTF_NUMBER_TABLE
949: , p5_a1 JTF_NUMBER_TABLE
950: , p5_a2 JTF_NUMBER_TABLE
951: , p5_a3 JTF_VARCHAR2_TABLE_100
952: , p5_a4 JTF_VARCHAR2_TABLE_100
953: , p5_a5 JTF_VARCHAR2_TABLE_500
954: , p5_a6 JTF_VARCHAR2_TABLE_500
955: , p5_a7 JTF_VARCHAR2_TABLE_500
956: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 978: , p5_a30 JTF_VARCHAR2_TABLE_100

974: , p5_a26 JTF_DATE_TABLE
975: , p5_a27 JTF_NUMBER_TABLE
976: , p5_a28 JTF_DATE_TABLE
977: , p5_a29 JTF_NUMBER_TABLE
978: , p5_a30 JTF_VARCHAR2_TABLE_100
979: , p5_a31 JTF_VARCHAR2_TABLE_100
980: , p5_a32 JTF_VARCHAR2_TABLE_500
981: , p5_a33 JTF_VARCHAR2_TABLE_500
982: , p5_a34 JTF_NUMBER_TABLE

Line 979: , p5_a31 JTF_VARCHAR2_TABLE_100

975: , p5_a27 JTF_NUMBER_TABLE
976: , p5_a28 JTF_DATE_TABLE
977: , p5_a29 JTF_NUMBER_TABLE
978: , p5_a30 JTF_VARCHAR2_TABLE_100
979: , p5_a31 JTF_VARCHAR2_TABLE_100
980: , p5_a32 JTF_VARCHAR2_TABLE_500
981: , p5_a33 JTF_VARCHAR2_TABLE_500
982: , p5_a34 JTF_NUMBER_TABLE
983: , p5_a35 JTF_NUMBER_TABLE

Line 984: , p5_a36 JTF_VARCHAR2_TABLE_100

980: , p5_a32 JTF_VARCHAR2_TABLE_500
981: , p5_a33 JTF_VARCHAR2_TABLE_500
982: , p5_a34 JTF_NUMBER_TABLE
983: , p5_a35 JTF_NUMBER_TABLE
984: , p5_a36 JTF_VARCHAR2_TABLE_100
985: , p5_a37 JTF_VARCHAR2_TABLE_2000
986: , p5_a38 JTF_VARCHAR2_TABLE_100
987: , p5_a39 JTF_VARCHAR2_TABLE_100
988: );

Line 986: , p5_a38 JTF_VARCHAR2_TABLE_100

982: , p5_a34 JTF_NUMBER_TABLE
983: , p5_a35 JTF_NUMBER_TABLE
984: , p5_a36 JTF_VARCHAR2_TABLE_100
985: , p5_a37 JTF_VARCHAR2_TABLE_2000
986: , p5_a38 JTF_VARCHAR2_TABLE_100
987: , p5_a39 JTF_VARCHAR2_TABLE_100
988: );
989: procedure validate_row(p_api_version NUMBER
990: , p_init_msg_list VARCHAR2

Line 987: , p5_a39 JTF_VARCHAR2_TABLE_100

983: , p5_a35 JTF_NUMBER_TABLE
984: , p5_a36 JTF_VARCHAR2_TABLE_100
985: , p5_a37 JTF_VARCHAR2_TABLE_2000
986: , p5_a38 JTF_VARCHAR2_TABLE_100
987: , p5_a39 JTF_VARCHAR2_TABLE_100
988: );
989: procedure validate_row(p_api_version NUMBER
990: , p_init_msg_list VARCHAR2
991: , x_return_status out nocopy VARCHAR2

Line 1043: , p5_a3 JTF_VARCHAR2_TABLE_100

1039: , x_msg_data out nocopy VARCHAR2
1040: , p5_a0 JTF_NUMBER_TABLE
1041: , p5_a1 JTF_NUMBER_TABLE
1042: , p5_a2 JTF_NUMBER_TABLE
1043: , p5_a3 JTF_VARCHAR2_TABLE_100
1044: , p5_a4 JTF_VARCHAR2_TABLE_100
1045: , p5_a5 JTF_VARCHAR2_TABLE_500
1046: , p5_a6 JTF_VARCHAR2_TABLE_500
1047: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1044: , p5_a4 JTF_VARCHAR2_TABLE_100

1040: , p5_a0 JTF_NUMBER_TABLE
1041: , p5_a1 JTF_NUMBER_TABLE
1042: , p5_a2 JTF_NUMBER_TABLE
1043: , p5_a3 JTF_VARCHAR2_TABLE_100
1044: , p5_a4 JTF_VARCHAR2_TABLE_100
1045: , p5_a5 JTF_VARCHAR2_TABLE_500
1046: , p5_a6 JTF_VARCHAR2_TABLE_500
1047: , p5_a7 JTF_VARCHAR2_TABLE_500
1048: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1070: , p5_a30 JTF_VARCHAR2_TABLE_100

1066: , p5_a26 JTF_DATE_TABLE
1067: , p5_a27 JTF_NUMBER_TABLE
1068: , p5_a28 JTF_DATE_TABLE
1069: , p5_a29 JTF_NUMBER_TABLE
1070: , p5_a30 JTF_VARCHAR2_TABLE_100
1071: , p5_a31 JTF_VARCHAR2_TABLE_100
1072: , p5_a32 JTF_VARCHAR2_TABLE_500
1073: , p5_a33 JTF_VARCHAR2_TABLE_500
1074: , p5_a34 JTF_NUMBER_TABLE

Line 1071: , p5_a31 JTF_VARCHAR2_TABLE_100

1067: , p5_a27 JTF_NUMBER_TABLE
1068: , p5_a28 JTF_DATE_TABLE
1069: , p5_a29 JTF_NUMBER_TABLE
1070: , p5_a30 JTF_VARCHAR2_TABLE_100
1071: , p5_a31 JTF_VARCHAR2_TABLE_100
1072: , p5_a32 JTF_VARCHAR2_TABLE_500
1073: , p5_a33 JTF_VARCHAR2_TABLE_500
1074: , p5_a34 JTF_NUMBER_TABLE
1075: , p5_a35 JTF_NUMBER_TABLE

Line 1076: , p5_a36 JTF_VARCHAR2_TABLE_100

1072: , p5_a32 JTF_VARCHAR2_TABLE_500
1073: , p5_a33 JTF_VARCHAR2_TABLE_500
1074: , p5_a34 JTF_NUMBER_TABLE
1075: , p5_a35 JTF_NUMBER_TABLE
1076: , p5_a36 JTF_VARCHAR2_TABLE_100
1077: , p5_a37 JTF_VARCHAR2_TABLE_2000
1078: , p5_a38 JTF_VARCHAR2_TABLE_100
1079: , p5_a39 JTF_VARCHAR2_TABLE_100
1080: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 1078: , p5_a38 JTF_VARCHAR2_TABLE_100

1074: , p5_a34 JTF_NUMBER_TABLE
1075: , p5_a35 JTF_NUMBER_TABLE
1076: , p5_a36 JTF_VARCHAR2_TABLE_100
1077: , p5_a37 JTF_VARCHAR2_TABLE_2000
1078: , p5_a38 JTF_VARCHAR2_TABLE_100
1079: , p5_a39 JTF_VARCHAR2_TABLE_100
1080: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1081: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1082: , p6_a2 in out nocopy JTF_NUMBER_TABLE

Line 1079: , p5_a39 JTF_VARCHAR2_TABLE_100

1075: , p5_a35 JTF_NUMBER_TABLE
1076: , p5_a36 JTF_VARCHAR2_TABLE_100
1077: , p5_a37 JTF_VARCHAR2_TABLE_2000
1078: , p5_a38 JTF_VARCHAR2_TABLE_100
1079: , p5_a39 JTF_VARCHAR2_TABLE_100
1080: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1081: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1082: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1083: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 1081: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1077: , p5_a37 JTF_VARCHAR2_TABLE_2000
1078: , p5_a38 JTF_VARCHAR2_TABLE_100
1079: , p5_a39 JTF_VARCHAR2_TABLE_100
1080: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1081: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1082: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1083: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1084: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1085: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1085: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1081: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1082: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1083: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1084: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1085: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1086: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1087: );
1088: procedure validate_row(p_api_version NUMBER
1089: , p_init_msg_list VARCHAR2

Line 1086: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1082: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1083: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1084: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1085: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1086: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1087: );
1088: procedure validate_row(p_api_version NUMBER
1089: , p_init_msg_list VARCHAR2
1090: , x_return_status out nocopy VARCHAR2

Line 1096: , p5_a3 JTF_VARCHAR2_TABLE_100

1092: , x_msg_data out nocopy VARCHAR2
1093: , p5_a0 JTF_NUMBER_TABLE
1094: , p5_a1 JTF_NUMBER_TABLE
1095: , p5_a2 JTF_NUMBER_TABLE
1096: , p5_a3 JTF_VARCHAR2_TABLE_100
1097: , p5_a4 JTF_VARCHAR2_TABLE_100
1098: , p5_a5 JTF_VARCHAR2_TABLE_500
1099: , p5_a6 JTF_VARCHAR2_TABLE_500
1100: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1097: , p5_a4 JTF_VARCHAR2_TABLE_100

1093: , p5_a0 JTF_NUMBER_TABLE
1094: , p5_a1 JTF_NUMBER_TABLE
1095: , p5_a2 JTF_NUMBER_TABLE
1096: , p5_a3 JTF_VARCHAR2_TABLE_100
1097: , p5_a4 JTF_VARCHAR2_TABLE_100
1098: , p5_a5 JTF_VARCHAR2_TABLE_500
1099: , p5_a6 JTF_VARCHAR2_TABLE_500
1100: , p5_a7 JTF_VARCHAR2_TABLE_500
1101: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1123: , p5_a30 JTF_VARCHAR2_TABLE_100

1119: , p5_a26 JTF_DATE_TABLE
1120: , p5_a27 JTF_NUMBER_TABLE
1121: , p5_a28 JTF_DATE_TABLE
1122: , p5_a29 JTF_NUMBER_TABLE
1123: , p5_a30 JTF_VARCHAR2_TABLE_100
1124: , p5_a31 JTF_VARCHAR2_TABLE_100
1125: , p5_a32 JTF_VARCHAR2_TABLE_500
1126: , p5_a33 JTF_VARCHAR2_TABLE_500
1127: , p5_a34 JTF_NUMBER_TABLE

Line 1124: , p5_a31 JTF_VARCHAR2_TABLE_100

1120: , p5_a27 JTF_NUMBER_TABLE
1121: , p5_a28 JTF_DATE_TABLE
1122: , p5_a29 JTF_NUMBER_TABLE
1123: , p5_a30 JTF_VARCHAR2_TABLE_100
1124: , p5_a31 JTF_VARCHAR2_TABLE_100
1125: , p5_a32 JTF_VARCHAR2_TABLE_500
1126: , p5_a33 JTF_VARCHAR2_TABLE_500
1127: , p5_a34 JTF_NUMBER_TABLE
1128: , p5_a35 JTF_NUMBER_TABLE

Line 1129: , p5_a36 JTF_VARCHAR2_TABLE_100

1125: , p5_a32 JTF_VARCHAR2_TABLE_500
1126: , p5_a33 JTF_VARCHAR2_TABLE_500
1127: , p5_a34 JTF_NUMBER_TABLE
1128: , p5_a35 JTF_NUMBER_TABLE
1129: , p5_a36 JTF_VARCHAR2_TABLE_100
1130: , p5_a37 JTF_VARCHAR2_TABLE_2000
1131: , p5_a38 JTF_VARCHAR2_TABLE_100
1132: , p5_a39 JTF_VARCHAR2_TABLE_100
1133: );

Line 1131: , p5_a38 JTF_VARCHAR2_TABLE_100

1127: , p5_a34 JTF_NUMBER_TABLE
1128: , p5_a35 JTF_NUMBER_TABLE
1129: , p5_a36 JTF_VARCHAR2_TABLE_100
1130: , p5_a37 JTF_VARCHAR2_TABLE_2000
1131: , p5_a38 JTF_VARCHAR2_TABLE_100
1132: , p5_a39 JTF_VARCHAR2_TABLE_100
1133: );
1134: end okl_cld_pvt_w;

Line 1132: , p5_a39 JTF_VARCHAR2_TABLE_100

1128: , p5_a35 JTF_NUMBER_TABLE
1129: , p5_a36 JTF_VARCHAR2_TABLE_100
1130: , p5_a37 JTF_VARCHAR2_TABLE_2000
1131: , p5_a38 JTF_VARCHAR2_TABLE_100
1132: , p5_a39 JTF_VARCHAR2_TABLE_100
1133: );
1134: end okl_cld_pvt_w;