APPS.OKL_SIY_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_siy_pvt_w as
2: /* $Header: OKLISIYS.pls 120.1 2005/07/30 09:40:23 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_siy_pvt_w as
2: /* $Header: OKLISIYS.pls 120.1 2005/07/30 09:40:23 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLISIYS.pls 120.1 2005/07/30 09:40:23 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_NUMBER_TABLE

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

Line 13: , a10 JTF_NUMBER_TABLE

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

Line 32: , a29 JTF_NUMBER_TABLE

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

Line 33: , a30 JTF_NUMBER_TABLE

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

Line 36: , a33 JTF_NUMBER_TABLE

32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

34: , a31 JTF_DATE_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , a1 out nocopy JTF_NUMBER_TABLE

35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 41: , a3 out nocopy JTF_NUMBER_TABLE

37: );
38: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a9 out nocopy JTF_NUMBER_TABLE

43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_VARCHAR2_TABLE_100
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_NUMBER_TABLE
49: , a11 out nocopy JTF_VARCHAR2_TABLE_100
50: , a12 out nocopy JTF_VARCHAR2_TABLE_100
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: , a10 out nocopy JTF_NUMBER_TABLE

44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_VARCHAR2_TABLE_100
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_NUMBER_TABLE
49: , a11 out nocopy JTF_VARCHAR2_TABLE_100
50: , a12 out nocopy JTF_VARCHAR2_TABLE_100
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 67: , a29 out nocopy JTF_NUMBER_TABLE

63: , a25 out nocopy JTF_VARCHAR2_TABLE_500
64: , a26 out nocopy JTF_VARCHAR2_TABLE_500
65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_NUMBER_TABLE
69: , a31 out nocopy JTF_DATE_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE

Line 68: , a30 out nocopy JTF_NUMBER_TABLE

64: , a26 out nocopy JTF_VARCHAR2_TABLE_500
65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_NUMBER_TABLE
69: , a31 out nocopy JTF_DATE_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );

Line 71: , a33 out nocopy JTF_NUMBER_TABLE

67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_NUMBER_TABLE
69: , a31 out nocopy JTF_DATE_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE

Line 74: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE

70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100

Line 75: , a1 JTF_NUMBER_TABLE

71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_VARCHAR2_TABLE_100

Line 77: , a3 JTF_NUMBER_TABLE

73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_VARCHAR2_TABLE_100
80: , a6 JTF_VARCHAR2_TABLE_100
81: , a7 JTF_VARCHAR2_TABLE_100

Line 83: , a9 JTF_NUMBER_TABLE

79: , a5 JTF_VARCHAR2_TABLE_100
80: , a6 JTF_VARCHAR2_TABLE_100
81: , a7 JTF_VARCHAR2_TABLE_100
82: , a8 JTF_VARCHAR2_TABLE_100
83: , a9 JTF_NUMBER_TABLE
84: , a10 JTF_NUMBER_TABLE
85: , a11 JTF_VARCHAR2_TABLE_100
86: , a12 JTF_VARCHAR2_TABLE_100
87: , a13 JTF_VARCHAR2_TABLE_100

Line 84: , a10 JTF_NUMBER_TABLE

80: , a6 JTF_VARCHAR2_TABLE_100
81: , a7 JTF_VARCHAR2_TABLE_100
82: , a8 JTF_VARCHAR2_TABLE_100
83: , a9 JTF_NUMBER_TABLE
84: , a10 JTF_NUMBER_TABLE
85: , a11 JTF_VARCHAR2_TABLE_100
86: , a12 JTF_VARCHAR2_TABLE_100
87: , a13 JTF_VARCHAR2_TABLE_100
88: , a14 JTF_VARCHAR2_TABLE_500

Line 103: , a29 JTF_NUMBER_TABLE

99: , a25 JTF_VARCHAR2_TABLE_500
100: , a26 JTF_VARCHAR2_TABLE_500
101: , a27 JTF_VARCHAR2_TABLE_500
102: , a28 JTF_VARCHAR2_TABLE_500
103: , a29 JTF_NUMBER_TABLE
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE

Line 104: , a30 JTF_NUMBER_TABLE

100: , a26 JTF_VARCHAR2_TABLE_500
101: , a27 JTF_VARCHAR2_TABLE_500
102: , a28 JTF_VARCHAR2_TABLE_500
103: , a29 JTF_NUMBER_TABLE
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
108: );

Line 107: , a33 JTF_NUMBER_TABLE

103: , a29 JTF_NUMBER_TABLE
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

105: , a31 JTF_DATE_TABLE
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 110: , a1 out nocopy JTF_NUMBER_TABLE

106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 112: , a3 out nocopy JTF_NUMBER_TABLE

108: );
109: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_VARCHAR2_TABLE_100
115: , a6 out nocopy JTF_VARCHAR2_TABLE_100
116: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 118: , a9 out nocopy JTF_NUMBER_TABLE

114: , a5 out nocopy JTF_VARCHAR2_TABLE_100
115: , a6 out nocopy JTF_VARCHAR2_TABLE_100
116: , a7 out nocopy JTF_VARCHAR2_TABLE_100
117: , a8 out nocopy JTF_VARCHAR2_TABLE_100
118: , a9 out nocopy JTF_NUMBER_TABLE
119: , a10 out nocopy JTF_NUMBER_TABLE
120: , a11 out nocopy JTF_VARCHAR2_TABLE_100
121: , a12 out nocopy JTF_VARCHAR2_TABLE_100
122: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , a10 out nocopy JTF_NUMBER_TABLE

115: , a6 out nocopy JTF_VARCHAR2_TABLE_100
116: , a7 out nocopy JTF_VARCHAR2_TABLE_100
117: , a8 out nocopy JTF_VARCHAR2_TABLE_100
118: , a9 out nocopy JTF_NUMBER_TABLE
119: , a10 out nocopy JTF_NUMBER_TABLE
120: , a11 out nocopy JTF_VARCHAR2_TABLE_100
121: , a12 out nocopy JTF_VARCHAR2_TABLE_100
122: , a13 out nocopy JTF_VARCHAR2_TABLE_100
123: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 138: , a29 out nocopy JTF_NUMBER_TABLE

134: , a25 out nocopy JTF_VARCHAR2_TABLE_500
135: , a26 out nocopy JTF_VARCHAR2_TABLE_500
136: , a27 out nocopy JTF_VARCHAR2_TABLE_500
137: , a28 out nocopy JTF_VARCHAR2_TABLE_500
138: , a29 out nocopy JTF_NUMBER_TABLE
139: , a30 out nocopy JTF_NUMBER_TABLE
140: , a31 out nocopy JTF_DATE_TABLE
141: , a32 out nocopy JTF_DATE_TABLE
142: , a33 out nocopy JTF_NUMBER_TABLE

Line 139: , a30 out nocopy JTF_NUMBER_TABLE

135: , a26 out nocopy JTF_VARCHAR2_TABLE_500
136: , a27 out nocopy JTF_VARCHAR2_TABLE_500
137: , a28 out nocopy JTF_VARCHAR2_TABLE_500
138: , a29 out nocopy JTF_NUMBER_TABLE
139: , a30 out nocopy JTF_NUMBER_TABLE
140: , a31 out nocopy JTF_DATE_TABLE
141: , a32 out nocopy JTF_DATE_TABLE
142: , a33 out nocopy JTF_NUMBER_TABLE
143: );

Line 142: , a33 out nocopy JTF_NUMBER_TABLE

138: , a29 out nocopy JTF_NUMBER_TABLE
139: , a30 out nocopy JTF_NUMBER_TABLE
140: , a31 out nocopy JTF_DATE_TABLE
141: , a32 out nocopy JTF_DATE_TABLE
142: , a33 out nocopy JTF_NUMBER_TABLE
143: );
144:
145: procedure insert_row(p_api_version NUMBER
146: , p_init_msg_list VARCHAR2

Line 224: , p5_a0 JTF_NUMBER_TABLE

220: , p_init_msg_list VARCHAR2
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 225: , p5_a1 JTF_NUMBER_TABLE

221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 227: , p5_a3 JTF_NUMBER_TABLE

223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_VARCHAR2_TABLE_100
230: , p5_a6 JTF_VARCHAR2_TABLE_100
231: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 233: , p5_a9 JTF_NUMBER_TABLE

229: , p5_a5 JTF_VARCHAR2_TABLE_100
230: , p5_a6 JTF_VARCHAR2_TABLE_100
231: , p5_a7 JTF_VARCHAR2_TABLE_100
232: , p5_a8 JTF_VARCHAR2_TABLE_100
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_VARCHAR2_TABLE_100
236: , p5_a12 JTF_VARCHAR2_TABLE_100
237: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 234: , p5_a10 JTF_NUMBER_TABLE

230: , p5_a6 JTF_VARCHAR2_TABLE_100
231: , p5_a7 JTF_VARCHAR2_TABLE_100
232: , p5_a8 JTF_VARCHAR2_TABLE_100
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_VARCHAR2_TABLE_100
236: , p5_a12 JTF_VARCHAR2_TABLE_100
237: , p5_a13 JTF_VARCHAR2_TABLE_100
238: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 253: , p5_a29 JTF_NUMBER_TABLE

249: , p5_a25 JTF_VARCHAR2_TABLE_500
250: , p5_a26 JTF_VARCHAR2_TABLE_500
251: , p5_a27 JTF_VARCHAR2_TABLE_500
252: , p5_a28 JTF_VARCHAR2_TABLE_500
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_NUMBER_TABLE
255: , p5_a31 JTF_DATE_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE

Line 254: , p5_a30 JTF_NUMBER_TABLE

250: , p5_a26 JTF_VARCHAR2_TABLE_500
251: , p5_a27 JTF_VARCHAR2_TABLE_500
252: , p5_a28 JTF_VARCHAR2_TABLE_500
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_NUMBER_TABLE
255: , p5_a31 JTF_DATE_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 257: , p5_a33 JTF_NUMBER_TABLE

253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_NUMBER_TABLE
255: , p5_a31 JTF_DATE_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 258: , p6_a0 out nocopy JTF_NUMBER_TABLE

254: , p5_a30 JTF_NUMBER_TABLE
255: , p5_a31 JTF_DATE_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 259: , p6_a1 out nocopy JTF_NUMBER_TABLE

255: , p5_a31 JTF_DATE_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 261: , p6_a3 out nocopy JTF_NUMBER_TABLE

257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , p6_a9 out nocopy JTF_NUMBER_TABLE

263: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a9 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 out nocopy JTF_NUMBER_TABLE
269: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , p6_a10 out nocopy JTF_NUMBER_TABLE

264: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a9 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 out nocopy JTF_NUMBER_TABLE
269: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
272: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 287: , p6_a29 out nocopy JTF_NUMBER_TABLE

283: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
285: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
286: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
287: , p6_a29 out nocopy JTF_NUMBER_TABLE
288: , p6_a30 out nocopy JTF_NUMBER_TABLE
289: , p6_a31 out nocopy JTF_DATE_TABLE
290: , p6_a32 out nocopy JTF_DATE_TABLE
291: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 288: , p6_a30 out nocopy JTF_NUMBER_TABLE

284: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
285: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
286: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
287: , p6_a29 out nocopy JTF_NUMBER_TABLE
288: , p6_a30 out nocopy JTF_NUMBER_TABLE
289: , p6_a31 out nocopy JTF_DATE_TABLE
290: , p6_a32 out nocopy JTF_DATE_TABLE
291: , p6_a33 out nocopy JTF_NUMBER_TABLE
292: );

Line 291: , p6_a33 out nocopy JTF_NUMBER_TABLE

287: , p6_a29 out nocopy JTF_NUMBER_TABLE
288: , p6_a30 out nocopy JTF_NUMBER_TABLE
289: , p6_a31 out nocopy JTF_DATE_TABLE
290: , p6_a32 out nocopy JTF_DATE_TABLE
291: , p6_a33 out nocopy JTF_NUMBER_TABLE
292: );
293: procedure lock_row(p_api_version NUMBER
294: , p_init_msg_list VARCHAR2
295: , x_return_status out nocopy VARCHAR2

Line 338: , p5_a0 JTF_NUMBER_TABLE

334: , p_init_msg_list VARCHAR2
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 339: , p5_a1 JTF_NUMBER_TABLE

335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 341: , p5_a3 JTF_NUMBER_TABLE

337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_VARCHAR2_TABLE_100
344: , p5_a6 JTF_VARCHAR2_TABLE_100
345: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 347: , p5_a9 JTF_NUMBER_TABLE

343: , p5_a5 JTF_VARCHAR2_TABLE_100
344: , p5_a6 JTF_VARCHAR2_TABLE_100
345: , p5_a7 JTF_VARCHAR2_TABLE_100
346: , p5_a8 JTF_VARCHAR2_TABLE_100
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_NUMBER_TABLE
349: , p5_a11 JTF_VARCHAR2_TABLE_100
350: , p5_a12 JTF_VARCHAR2_TABLE_100
351: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 348: , p5_a10 JTF_NUMBER_TABLE

344: , p5_a6 JTF_VARCHAR2_TABLE_100
345: , p5_a7 JTF_VARCHAR2_TABLE_100
346: , p5_a8 JTF_VARCHAR2_TABLE_100
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_NUMBER_TABLE
349: , p5_a11 JTF_VARCHAR2_TABLE_100
350: , p5_a12 JTF_VARCHAR2_TABLE_100
351: , p5_a13 JTF_VARCHAR2_TABLE_100
352: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 367: , p5_a29 JTF_NUMBER_TABLE

363: , p5_a25 JTF_VARCHAR2_TABLE_500
364: , p5_a26 JTF_VARCHAR2_TABLE_500
365: , p5_a27 JTF_VARCHAR2_TABLE_500
366: , p5_a28 JTF_VARCHAR2_TABLE_500
367: , p5_a29 JTF_NUMBER_TABLE
368: , p5_a30 JTF_NUMBER_TABLE
369: , p5_a31 JTF_DATE_TABLE
370: , p5_a32 JTF_DATE_TABLE
371: , p5_a33 JTF_NUMBER_TABLE

Line 368: , p5_a30 JTF_NUMBER_TABLE

364: , p5_a26 JTF_VARCHAR2_TABLE_500
365: , p5_a27 JTF_VARCHAR2_TABLE_500
366: , p5_a28 JTF_VARCHAR2_TABLE_500
367: , p5_a29 JTF_NUMBER_TABLE
368: , p5_a30 JTF_NUMBER_TABLE
369: , p5_a31 JTF_DATE_TABLE
370: , p5_a32 JTF_DATE_TABLE
371: , p5_a33 JTF_NUMBER_TABLE
372: );

Line 371: , p5_a33 JTF_NUMBER_TABLE

367: , p5_a29 JTF_NUMBER_TABLE
368: , p5_a30 JTF_NUMBER_TABLE
369: , p5_a31 JTF_DATE_TABLE
370: , p5_a32 JTF_DATE_TABLE
371: , p5_a33 JTF_NUMBER_TABLE
372: );
373: procedure update_row(p_api_version NUMBER
374: , p_init_msg_list VARCHAR2
375: , x_return_status out nocopy VARCHAR2

Line 452: , p5_a0 JTF_NUMBER_TABLE

448: , p_init_msg_list VARCHAR2
449: , x_return_status out nocopy VARCHAR2
450: , x_msg_count out nocopy NUMBER
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 453: , p5_a1 JTF_NUMBER_TABLE

449: , x_return_status out nocopy VARCHAR2
450: , x_msg_count out nocopy NUMBER
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 455: , p5_a3 JTF_NUMBER_TABLE

451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_VARCHAR2_TABLE_100
458: , p5_a6 JTF_VARCHAR2_TABLE_100
459: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 461: , p5_a9 JTF_NUMBER_TABLE

457: , p5_a5 JTF_VARCHAR2_TABLE_100
458: , p5_a6 JTF_VARCHAR2_TABLE_100
459: , p5_a7 JTF_VARCHAR2_TABLE_100
460: , p5_a8 JTF_VARCHAR2_TABLE_100
461: , p5_a9 JTF_NUMBER_TABLE
462: , p5_a10 JTF_NUMBER_TABLE
463: , p5_a11 JTF_VARCHAR2_TABLE_100
464: , p5_a12 JTF_VARCHAR2_TABLE_100
465: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 462: , p5_a10 JTF_NUMBER_TABLE

458: , p5_a6 JTF_VARCHAR2_TABLE_100
459: , p5_a7 JTF_VARCHAR2_TABLE_100
460: , p5_a8 JTF_VARCHAR2_TABLE_100
461: , p5_a9 JTF_NUMBER_TABLE
462: , p5_a10 JTF_NUMBER_TABLE
463: , p5_a11 JTF_VARCHAR2_TABLE_100
464: , p5_a12 JTF_VARCHAR2_TABLE_100
465: , p5_a13 JTF_VARCHAR2_TABLE_100
466: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 481: , p5_a29 JTF_NUMBER_TABLE

477: , p5_a25 JTF_VARCHAR2_TABLE_500
478: , p5_a26 JTF_VARCHAR2_TABLE_500
479: , p5_a27 JTF_VARCHAR2_TABLE_500
480: , p5_a28 JTF_VARCHAR2_TABLE_500
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE

Line 482: , p5_a30 JTF_NUMBER_TABLE

478: , p5_a26 JTF_VARCHAR2_TABLE_500
479: , p5_a27 JTF_VARCHAR2_TABLE_500
480: , p5_a28 JTF_VARCHAR2_TABLE_500
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 485: , p5_a33 JTF_NUMBER_TABLE

481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 486: , p6_a0 out nocopy JTF_NUMBER_TABLE

482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 487: , p6_a1 out nocopy JTF_NUMBER_TABLE

483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 489: , p6_a3 out nocopy JTF_NUMBER_TABLE

485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
493: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 495: , p6_a9 out nocopy JTF_NUMBER_TABLE

491: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
493: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
495: , p6_a9 out nocopy JTF_NUMBER_TABLE
496: , p6_a10 out nocopy JTF_NUMBER_TABLE
497: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
498: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 496: , p6_a10 out nocopy JTF_NUMBER_TABLE

492: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
493: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
495: , p6_a9 out nocopy JTF_NUMBER_TABLE
496: , p6_a10 out nocopy JTF_NUMBER_TABLE
497: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
498: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
500: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 515: , p6_a29 out nocopy JTF_NUMBER_TABLE

511: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
512: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
513: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
514: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a29 out nocopy JTF_NUMBER_TABLE
516: , p6_a30 out nocopy JTF_NUMBER_TABLE
517: , p6_a31 out nocopy JTF_DATE_TABLE
518: , p6_a32 out nocopy JTF_DATE_TABLE
519: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 516: , p6_a30 out nocopy JTF_NUMBER_TABLE

512: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
513: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
514: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a29 out nocopy JTF_NUMBER_TABLE
516: , p6_a30 out nocopy JTF_NUMBER_TABLE
517: , p6_a31 out nocopy JTF_DATE_TABLE
518: , p6_a32 out nocopy JTF_DATE_TABLE
519: , p6_a33 out nocopy JTF_NUMBER_TABLE
520: );

Line 519: , p6_a33 out nocopy JTF_NUMBER_TABLE

515: , p6_a29 out nocopy JTF_NUMBER_TABLE
516: , p6_a30 out nocopy JTF_NUMBER_TABLE
517: , p6_a31 out nocopy JTF_DATE_TABLE
518: , p6_a32 out nocopy JTF_DATE_TABLE
519: , p6_a33 out nocopy JTF_NUMBER_TABLE
520: );
521: procedure delete_row(p_api_version NUMBER
522: , p_init_msg_list VARCHAR2
523: , x_return_status out nocopy VARCHAR2

Line 566: , p5_a0 JTF_NUMBER_TABLE

562: , p_init_msg_list VARCHAR2
563: , x_return_status out nocopy VARCHAR2
564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 567: , p5_a1 JTF_NUMBER_TABLE

563: , x_return_status out nocopy VARCHAR2
564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 569: , p5_a3 JTF_NUMBER_TABLE

565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_VARCHAR2_TABLE_100
572: , p5_a6 JTF_VARCHAR2_TABLE_100
573: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 575: , p5_a9 JTF_NUMBER_TABLE

571: , p5_a5 JTF_VARCHAR2_TABLE_100
572: , p5_a6 JTF_VARCHAR2_TABLE_100
573: , p5_a7 JTF_VARCHAR2_TABLE_100
574: , p5_a8 JTF_VARCHAR2_TABLE_100
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_NUMBER_TABLE
577: , p5_a11 JTF_VARCHAR2_TABLE_100
578: , p5_a12 JTF_VARCHAR2_TABLE_100
579: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 576: , p5_a10 JTF_NUMBER_TABLE

572: , p5_a6 JTF_VARCHAR2_TABLE_100
573: , p5_a7 JTF_VARCHAR2_TABLE_100
574: , p5_a8 JTF_VARCHAR2_TABLE_100
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_NUMBER_TABLE
577: , p5_a11 JTF_VARCHAR2_TABLE_100
578: , p5_a12 JTF_VARCHAR2_TABLE_100
579: , p5_a13 JTF_VARCHAR2_TABLE_100
580: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 595: , p5_a29 JTF_NUMBER_TABLE

591: , p5_a25 JTF_VARCHAR2_TABLE_500
592: , p5_a26 JTF_VARCHAR2_TABLE_500
593: , p5_a27 JTF_VARCHAR2_TABLE_500
594: , p5_a28 JTF_VARCHAR2_TABLE_500
595: , p5_a29 JTF_NUMBER_TABLE
596: , p5_a30 JTF_NUMBER_TABLE
597: , p5_a31 JTF_DATE_TABLE
598: , p5_a32 JTF_DATE_TABLE
599: , p5_a33 JTF_NUMBER_TABLE

Line 596: , p5_a30 JTF_NUMBER_TABLE

592: , p5_a26 JTF_VARCHAR2_TABLE_500
593: , p5_a27 JTF_VARCHAR2_TABLE_500
594: , p5_a28 JTF_VARCHAR2_TABLE_500
595: , p5_a29 JTF_NUMBER_TABLE
596: , p5_a30 JTF_NUMBER_TABLE
597: , p5_a31 JTF_DATE_TABLE
598: , p5_a32 JTF_DATE_TABLE
599: , p5_a33 JTF_NUMBER_TABLE
600: );

Line 599: , p5_a33 JTF_NUMBER_TABLE

595: , p5_a29 JTF_NUMBER_TABLE
596: , p5_a30 JTF_NUMBER_TABLE
597: , p5_a31 JTF_DATE_TABLE
598: , p5_a32 JTF_DATE_TABLE
599: , p5_a33 JTF_NUMBER_TABLE
600: );
601: procedure validate_row(p_api_version NUMBER
602: , p_init_msg_list VARCHAR2
603: , x_return_status out nocopy VARCHAR2

Line 646: , p5_a0 JTF_NUMBER_TABLE

642: , p_init_msg_list VARCHAR2
643: , x_return_status out nocopy VARCHAR2
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 647: , p5_a1 JTF_NUMBER_TABLE

643: , x_return_status out nocopy VARCHAR2
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 649: , p5_a3 JTF_NUMBER_TABLE

645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_VARCHAR2_TABLE_100
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 655: , p5_a9 JTF_NUMBER_TABLE

651: , p5_a5 JTF_VARCHAR2_TABLE_100
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_VARCHAR2_TABLE_100
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_VARCHAR2_TABLE_100
658: , p5_a12 JTF_VARCHAR2_TABLE_100
659: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 656: , p5_a10 JTF_NUMBER_TABLE

652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_VARCHAR2_TABLE_100
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_VARCHAR2_TABLE_100
658: , p5_a12 JTF_VARCHAR2_TABLE_100
659: , p5_a13 JTF_VARCHAR2_TABLE_100
660: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 675: , p5_a29 JTF_NUMBER_TABLE

671: , p5_a25 JTF_VARCHAR2_TABLE_500
672: , p5_a26 JTF_VARCHAR2_TABLE_500
673: , p5_a27 JTF_VARCHAR2_TABLE_500
674: , p5_a28 JTF_VARCHAR2_TABLE_500
675: , p5_a29 JTF_NUMBER_TABLE
676: , p5_a30 JTF_NUMBER_TABLE
677: , p5_a31 JTF_DATE_TABLE
678: , p5_a32 JTF_DATE_TABLE
679: , p5_a33 JTF_NUMBER_TABLE

Line 676: , p5_a30 JTF_NUMBER_TABLE

672: , p5_a26 JTF_VARCHAR2_TABLE_500
673: , p5_a27 JTF_VARCHAR2_TABLE_500
674: , p5_a28 JTF_VARCHAR2_TABLE_500
675: , p5_a29 JTF_NUMBER_TABLE
676: , p5_a30 JTF_NUMBER_TABLE
677: , p5_a31 JTF_DATE_TABLE
678: , p5_a32 JTF_DATE_TABLE
679: , p5_a33 JTF_NUMBER_TABLE
680: );

Line 679: , p5_a33 JTF_NUMBER_TABLE

675: , p5_a29 JTF_NUMBER_TABLE
676: , p5_a30 JTF_NUMBER_TABLE
677: , p5_a31 JTF_DATE_TABLE
678: , p5_a32 JTF_DATE_TABLE
679: , p5_a33 JTF_NUMBER_TABLE
680: );
681: end okl_siy_pvt_w;