DBA Data[Home] [Help]

APPS.OKL_VRR_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_vrr_pvt_w as
2: /* $Header: OKLIVRRS.pls 120.0 2005/08/03 07:54:05 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_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_400

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_vrr_pvt_w as
2: /* $Header: OKLIVRRS.pls 120.0 2005/08/03 07:54:05 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_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_400
8: , a5 JTF_VARCHAR2_TABLE_2000

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_vrr_pvt_w as
2: /* $Header: OKLIVRRS.pls 120.0 2005/08/03 07:54:05 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_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_400
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100

Line 25: , a22 JTF_NUMBER_TABLE

21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE

Line 27: , a24 JTF_NUMBER_TABLE

23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE

Line 29: , a26 JTF_NUMBER_TABLE

25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE

Line 31: , a28 JTF_NUMBER_TABLE

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 33: , a30 JTF_NUMBER_TABLE

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE

Line 35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 36: , a1 out nocopy JTF_NUMBER_TABLE

32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_400
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 37: , a2 out nocopy JTF_NUMBER_TABLE

33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_400
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , a22 out nocopy JTF_NUMBER_TABLE

53: , a18 out nocopy JTF_VARCHAR2_TABLE_500
54: , a19 out nocopy JTF_VARCHAR2_TABLE_500
55: , a20 out nocopy JTF_VARCHAR2_TABLE_500
56: , a21 out nocopy JTF_VARCHAR2_TABLE_500
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE

Line 58: , a23 out nocopy JTF_NUMBER_TABLE

54: , a19 out nocopy JTF_VARCHAR2_TABLE_500
55: , a20 out nocopy JTF_VARCHAR2_TABLE_500
56: , a21 out nocopy JTF_VARCHAR2_TABLE_500
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE

Line 59: , a24 out nocopy JTF_NUMBER_TABLE

55: , a20 out nocopy JTF_VARCHAR2_TABLE_500
56: , a21 out nocopy JTF_VARCHAR2_TABLE_500
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE

Line 61: , a26 out nocopy JTF_NUMBER_TABLE

57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE

Line 63: , a28 out nocopy JTF_NUMBER_TABLE

59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:

Line 65: , a30 out nocopy JTF_NUMBER_TABLE

61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE

Line 68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE

64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_100
72: , a4 JTF_VARCHAR2_TABLE_400

Line 69: , a1 JTF_NUMBER_TABLE

65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_100
72: , a4 JTF_VARCHAR2_TABLE_400
73: , a5 JTF_VARCHAR2_TABLE_2000

Line 70: , a2 JTF_NUMBER_TABLE

66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_100
72: , a4 JTF_VARCHAR2_TABLE_400
73: , a5 JTF_VARCHAR2_TABLE_2000
74: , a6 JTF_VARCHAR2_TABLE_100

Line 90: , a22 JTF_NUMBER_TABLE

86: , a18 JTF_VARCHAR2_TABLE_500
87: , a19 JTF_VARCHAR2_TABLE_500
88: , a20 JTF_VARCHAR2_TABLE_500
89: , a21 JTF_VARCHAR2_TABLE_500
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE

Line 91: , a23 JTF_NUMBER_TABLE

87: , a19 JTF_VARCHAR2_TABLE_500
88: , a20 JTF_VARCHAR2_TABLE_500
89: , a21 JTF_VARCHAR2_TABLE_500
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE

Line 92: , a24 JTF_NUMBER_TABLE

88: , a20 JTF_VARCHAR2_TABLE_500
89: , a21 JTF_VARCHAR2_TABLE_500
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE

Line 94: , a26 JTF_NUMBER_TABLE

90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE

Line 96: , a28 JTF_NUMBER_TABLE

92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 98: , a30 JTF_NUMBER_TABLE

94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE

Line 100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_100
104: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 101: , a1 out nocopy JTF_NUMBER_TABLE

97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_100
104: , a4 out nocopy JTF_VARCHAR2_TABLE_400
105: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 102: , a2 out nocopy JTF_NUMBER_TABLE

98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_100
104: , a4 out nocopy JTF_VARCHAR2_TABLE_400
105: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
106: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 122: , a22 out nocopy JTF_NUMBER_TABLE

118: , a18 out nocopy JTF_VARCHAR2_TABLE_500
119: , a19 out nocopy JTF_VARCHAR2_TABLE_500
120: , a20 out nocopy JTF_VARCHAR2_TABLE_500
121: , a21 out nocopy JTF_VARCHAR2_TABLE_500
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE

Line 123: , a23 out nocopy JTF_NUMBER_TABLE

119: , a19 out nocopy JTF_VARCHAR2_TABLE_500
120: , a20 out nocopy JTF_VARCHAR2_TABLE_500
121: , a21 out nocopy JTF_VARCHAR2_TABLE_500
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE

Line 124: , a24 out nocopy JTF_NUMBER_TABLE

120: , a20 out nocopy JTF_VARCHAR2_TABLE_500
121: , a21 out nocopy JTF_VARCHAR2_TABLE_500
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE

Line 126: , a26 out nocopy JTF_NUMBER_TABLE

122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE

Line 128: , a28 out nocopy JTF_NUMBER_TABLE

124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:

Line 130: , a30 out nocopy JTF_NUMBER_TABLE

126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:
133: procedure insert_row(p_api_version NUMBER
134: , p_init_msg_list VARCHAR2

Line 206: , p5_a0 JTF_NUMBER_TABLE

202: , p_init_msg_list VARCHAR2
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_100
210: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 207: , p5_a1 JTF_NUMBER_TABLE

203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_100
210: , p5_a4 JTF_VARCHAR2_TABLE_400
211: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 208: , p5_a2 JTF_NUMBER_TABLE

204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_100
210: , p5_a4 JTF_VARCHAR2_TABLE_400
211: , p5_a5 JTF_VARCHAR2_TABLE_2000
212: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 228: , p5_a22 JTF_NUMBER_TABLE

224: , p5_a18 JTF_VARCHAR2_TABLE_500
225: , p5_a19 JTF_VARCHAR2_TABLE_500
226: , p5_a20 JTF_VARCHAR2_TABLE_500
227: , p5_a21 JTF_VARCHAR2_TABLE_500
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE

Line 229: , p5_a23 JTF_NUMBER_TABLE

225: , p5_a19 JTF_VARCHAR2_TABLE_500
226: , p5_a20 JTF_VARCHAR2_TABLE_500
227: , p5_a21 JTF_VARCHAR2_TABLE_500
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE

Line 230: , p5_a24 JTF_NUMBER_TABLE

226: , p5_a20 JTF_VARCHAR2_TABLE_500
227: , p5_a21 JTF_VARCHAR2_TABLE_500
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE

Line 232: , p5_a26 JTF_NUMBER_TABLE

228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE

Line 234: , p5_a28 JTF_NUMBER_TABLE

230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 236: , p5_a30 JTF_NUMBER_TABLE

232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 237: , p6_a0 out nocopy JTF_NUMBER_TABLE

233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 238: , p6_a1 out nocopy JTF_NUMBER_TABLE

234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
242: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 239: , p6_a2 out nocopy JTF_NUMBER_TABLE

235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
242: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
243: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 259: , p6_a22 out nocopy JTF_NUMBER_TABLE

255: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE

Line 260: , p6_a23 out nocopy JTF_NUMBER_TABLE

256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE

Line 261: , p6_a24 out nocopy JTF_NUMBER_TABLE

257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 263: , p6_a26 out nocopy JTF_NUMBER_TABLE

259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 265: , p6_a28 out nocopy JTF_NUMBER_TABLE

261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , p6_a30 out nocopy JTF_NUMBER_TABLE

263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 268: , p7_a0 in out nocopy JTF_NUMBER_TABLE

264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 270: , p7_a2 in out nocopy JTF_NUMBER_TABLE

266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE
273: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 272: , p7_a4 in out nocopy JTF_NUMBER_TABLE

268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE
273: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: );
276: procedure insert_row(p_api_version NUMBER

Line 281: , p5_a0 JTF_NUMBER_TABLE

277: , p_init_msg_list VARCHAR2
278: , x_return_status out nocopy VARCHAR2
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_VARCHAR2_TABLE_100
285: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 282: , p5_a1 JTF_NUMBER_TABLE

278: , x_return_status out nocopy VARCHAR2
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_VARCHAR2_TABLE_100
285: , p5_a4 JTF_VARCHAR2_TABLE_400
286: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 283: , p5_a2 JTF_NUMBER_TABLE

279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_VARCHAR2_TABLE_100
285: , p5_a4 JTF_VARCHAR2_TABLE_400
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 303: , p5_a22 JTF_NUMBER_TABLE

299: , p5_a18 JTF_VARCHAR2_TABLE_500
300: , p5_a19 JTF_VARCHAR2_TABLE_500
301: , p5_a20 JTF_VARCHAR2_TABLE_500
302: , p5_a21 JTF_VARCHAR2_TABLE_500
303: , p5_a22 JTF_NUMBER_TABLE
304: , p5_a23 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE

Line 304: , p5_a23 JTF_NUMBER_TABLE

300: , p5_a19 JTF_VARCHAR2_TABLE_500
301: , p5_a20 JTF_VARCHAR2_TABLE_500
302: , p5_a21 JTF_VARCHAR2_TABLE_500
303: , p5_a22 JTF_NUMBER_TABLE
304: , p5_a23 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE

Line 305: , p5_a24 JTF_NUMBER_TABLE

301: , p5_a20 JTF_VARCHAR2_TABLE_500
302: , p5_a21 JTF_VARCHAR2_TABLE_500
303: , p5_a22 JTF_NUMBER_TABLE
304: , p5_a23 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE

Line 307: , p5_a26 JTF_NUMBER_TABLE

303: , p5_a22 JTF_NUMBER_TABLE
304: , p5_a23 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE

Line 309: , p5_a28 JTF_NUMBER_TABLE

305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 311: , p5_a30 JTF_NUMBER_TABLE

307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 312: , p6_a0 out nocopy JTF_NUMBER_TABLE

308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 313: , p6_a1 out nocopy JTF_NUMBER_TABLE

309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 314: , p6_a2 out nocopy JTF_NUMBER_TABLE

310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 334: , p6_a22 out nocopy JTF_NUMBER_TABLE

330: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
331: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
332: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a22 out nocopy JTF_NUMBER_TABLE
335: , p6_a23 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE

Line 335: , p6_a23 out nocopy JTF_NUMBER_TABLE

331: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
332: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a22 out nocopy JTF_NUMBER_TABLE
335: , p6_a23 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE

Line 336: , p6_a24 out nocopy JTF_NUMBER_TABLE

332: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a22 out nocopy JTF_NUMBER_TABLE
335: , p6_a23 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
340: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 338: , p6_a26 out nocopy JTF_NUMBER_TABLE

334: , p6_a22 out nocopy JTF_NUMBER_TABLE
335: , p6_a23 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
340: , p6_a28 out nocopy JTF_NUMBER_TABLE
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 340: , p6_a28 out nocopy JTF_NUMBER_TABLE

336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
340: , p6_a28 out nocopy JTF_NUMBER_TABLE
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER

Line 342: , p6_a30 out nocopy JTF_NUMBER_TABLE

338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
340: , p6_a28 out nocopy JTF_NUMBER_TABLE
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER
345: , p_init_msg_list VARCHAR2
346: , x_return_status out nocopy VARCHAR2

Line 386: , p5_a0 JTF_NUMBER_TABLE

382: , p_init_msg_list VARCHAR2
383: , x_return_status out nocopy VARCHAR2
384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2
386: , p5_a0 JTF_NUMBER_TABLE
387: , p5_a1 JTF_NUMBER_TABLE
388: , p5_a2 JTF_NUMBER_TABLE
389: , p5_a3 JTF_VARCHAR2_TABLE_100
390: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 387: , p5_a1 JTF_NUMBER_TABLE

383: , x_return_status out nocopy VARCHAR2
384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2
386: , p5_a0 JTF_NUMBER_TABLE
387: , p5_a1 JTF_NUMBER_TABLE
388: , p5_a2 JTF_NUMBER_TABLE
389: , p5_a3 JTF_VARCHAR2_TABLE_100
390: , p5_a4 JTF_VARCHAR2_TABLE_400
391: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 388: , p5_a2 JTF_NUMBER_TABLE

384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2
386: , p5_a0 JTF_NUMBER_TABLE
387: , p5_a1 JTF_NUMBER_TABLE
388: , p5_a2 JTF_NUMBER_TABLE
389: , p5_a3 JTF_VARCHAR2_TABLE_100
390: , p5_a4 JTF_VARCHAR2_TABLE_400
391: , p5_a5 JTF_VARCHAR2_TABLE_2000
392: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 408: , p5_a22 JTF_NUMBER_TABLE

404: , p5_a18 JTF_VARCHAR2_TABLE_500
405: , p5_a19 JTF_VARCHAR2_TABLE_500
406: , p5_a20 JTF_VARCHAR2_TABLE_500
407: , p5_a21 JTF_VARCHAR2_TABLE_500
408: , p5_a22 JTF_NUMBER_TABLE
409: , p5_a23 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE

Line 409: , p5_a23 JTF_NUMBER_TABLE

405: , p5_a19 JTF_VARCHAR2_TABLE_500
406: , p5_a20 JTF_VARCHAR2_TABLE_500
407: , p5_a21 JTF_VARCHAR2_TABLE_500
408: , p5_a22 JTF_NUMBER_TABLE
409: , p5_a23 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE

Line 410: , p5_a24 JTF_NUMBER_TABLE

406: , p5_a20 JTF_VARCHAR2_TABLE_500
407: , p5_a21 JTF_VARCHAR2_TABLE_500
408: , p5_a22 JTF_NUMBER_TABLE
409: , p5_a23 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE

Line 412: , p5_a26 JTF_NUMBER_TABLE

408: , p5_a22 JTF_NUMBER_TABLE
409: , p5_a23 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE

Line 414: , p5_a28 JTF_NUMBER_TABLE

410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 416: , p5_a30 JTF_NUMBER_TABLE

412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 417: , p6_a0 in out nocopy JTF_NUMBER_TABLE

413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 419: , p6_a2 in out nocopy JTF_NUMBER_TABLE

415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE
422: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 421: , p6_a4 in out nocopy JTF_NUMBER_TABLE

417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE
422: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
424: );
425: procedure lock_row(p_api_version NUMBER

Line 430: , p5_a0 JTF_NUMBER_TABLE

426: , p_init_msg_list VARCHAR2
427: , x_return_status out nocopy VARCHAR2
428: , x_msg_count out nocopy NUMBER
429: , x_msg_data out nocopy VARCHAR2
430: , p5_a0 JTF_NUMBER_TABLE
431: , p5_a1 JTF_NUMBER_TABLE
432: , p5_a2 JTF_NUMBER_TABLE
433: , p5_a3 JTF_VARCHAR2_TABLE_100
434: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 431: , p5_a1 JTF_NUMBER_TABLE

427: , x_return_status out nocopy VARCHAR2
428: , x_msg_count out nocopy NUMBER
429: , x_msg_data out nocopy VARCHAR2
430: , p5_a0 JTF_NUMBER_TABLE
431: , p5_a1 JTF_NUMBER_TABLE
432: , p5_a2 JTF_NUMBER_TABLE
433: , p5_a3 JTF_VARCHAR2_TABLE_100
434: , p5_a4 JTF_VARCHAR2_TABLE_400
435: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 432: , p5_a2 JTF_NUMBER_TABLE

428: , x_msg_count out nocopy NUMBER
429: , x_msg_data out nocopy VARCHAR2
430: , p5_a0 JTF_NUMBER_TABLE
431: , p5_a1 JTF_NUMBER_TABLE
432: , p5_a2 JTF_NUMBER_TABLE
433: , p5_a3 JTF_VARCHAR2_TABLE_100
434: , p5_a4 JTF_VARCHAR2_TABLE_400
435: , p5_a5 JTF_VARCHAR2_TABLE_2000
436: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 452: , p5_a22 JTF_NUMBER_TABLE

448: , p5_a18 JTF_VARCHAR2_TABLE_500
449: , p5_a19 JTF_VARCHAR2_TABLE_500
450: , p5_a20 JTF_VARCHAR2_TABLE_500
451: , p5_a21 JTF_VARCHAR2_TABLE_500
452: , p5_a22 JTF_NUMBER_TABLE
453: , p5_a23 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE

Line 453: , p5_a23 JTF_NUMBER_TABLE

449: , p5_a19 JTF_VARCHAR2_TABLE_500
450: , p5_a20 JTF_VARCHAR2_TABLE_500
451: , p5_a21 JTF_VARCHAR2_TABLE_500
452: , p5_a22 JTF_NUMBER_TABLE
453: , p5_a23 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE

Line 454: , p5_a24 JTF_NUMBER_TABLE

450: , p5_a20 JTF_VARCHAR2_TABLE_500
451: , p5_a21 JTF_VARCHAR2_TABLE_500
452: , p5_a22 JTF_NUMBER_TABLE
453: , p5_a23 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
458: , p5_a28 JTF_NUMBER_TABLE

Line 456: , p5_a26 JTF_NUMBER_TABLE

452: , p5_a22 JTF_NUMBER_TABLE
453: , p5_a23 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
458: , p5_a28 JTF_NUMBER_TABLE
459: , p5_a29 JTF_DATE_TABLE
460: , p5_a30 JTF_NUMBER_TABLE

Line 458: , p5_a28 JTF_NUMBER_TABLE

454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
458: , p5_a28 JTF_NUMBER_TABLE
459: , p5_a29 JTF_DATE_TABLE
460: , p5_a30 JTF_NUMBER_TABLE
461: );
462: procedure update_row(p_api_version NUMBER

Line 460: , p5_a30 JTF_NUMBER_TABLE

456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
458: , p5_a28 JTF_NUMBER_TABLE
459: , p5_a29 JTF_DATE_TABLE
460: , p5_a30 JTF_NUMBER_TABLE
461: );
462: procedure update_row(p_api_version NUMBER
463: , p_init_msg_list VARCHAR2
464: , x_return_status out nocopy VARCHAR2

Line 535: , p5_a0 JTF_NUMBER_TABLE

531: , p_init_msg_list VARCHAR2
532: , x_return_status out nocopy VARCHAR2
533: , x_msg_count out nocopy NUMBER
534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 JTF_NUMBER_TABLE
536: , p5_a1 JTF_NUMBER_TABLE
537: , p5_a2 JTF_NUMBER_TABLE
538: , p5_a3 JTF_VARCHAR2_TABLE_100
539: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 536: , p5_a1 JTF_NUMBER_TABLE

532: , x_return_status out nocopy VARCHAR2
533: , x_msg_count out nocopy NUMBER
534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 JTF_NUMBER_TABLE
536: , p5_a1 JTF_NUMBER_TABLE
537: , p5_a2 JTF_NUMBER_TABLE
538: , p5_a3 JTF_VARCHAR2_TABLE_100
539: , p5_a4 JTF_VARCHAR2_TABLE_400
540: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 537: , p5_a2 JTF_NUMBER_TABLE

533: , x_msg_count out nocopy NUMBER
534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 JTF_NUMBER_TABLE
536: , p5_a1 JTF_NUMBER_TABLE
537: , p5_a2 JTF_NUMBER_TABLE
538: , p5_a3 JTF_VARCHAR2_TABLE_100
539: , p5_a4 JTF_VARCHAR2_TABLE_400
540: , p5_a5 JTF_VARCHAR2_TABLE_2000
541: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 557: , p5_a22 JTF_NUMBER_TABLE

553: , p5_a18 JTF_VARCHAR2_TABLE_500
554: , p5_a19 JTF_VARCHAR2_TABLE_500
555: , p5_a20 JTF_VARCHAR2_TABLE_500
556: , p5_a21 JTF_VARCHAR2_TABLE_500
557: , p5_a22 JTF_NUMBER_TABLE
558: , p5_a23 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE

Line 558: , p5_a23 JTF_NUMBER_TABLE

554: , p5_a19 JTF_VARCHAR2_TABLE_500
555: , p5_a20 JTF_VARCHAR2_TABLE_500
556: , p5_a21 JTF_VARCHAR2_TABLE_500
557: , p5_a22 JTF_NUMBER_TABLE
558: , p5_a23 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE

Line 559: , p5_a24 JTF_NUMBER_TABLE

555: , p5_a20 JTF_VARCHAR2_TABLE_500
556: , p5_a21 JTF_VARCHAR2_TABLE_500
557: , p5_a22 JTF_NUMBER_TABLE
558: , p5_a23 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE

Line 561: , p5_a26 JTF_NUMBER_TABLE

557: , p5_a22 JTF_NUMBER_TABLE
558: , p5_a23 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE

Line 563: , p5_a28 JTF_NUMBER_TABLE

559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 565: , p5_a30 JTF_NUMBER_TABLE

561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 566: , p6_a0 out nocopy JTF_NUMBER_TABLE

562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 567: , p6_a1 out nocopy JTF_NUMBER_TABLE

563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
571: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 568: , p6_a2 out nocopy JTF_NUMBER_TABLE

564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
571: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
572: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 588: , p6_a22 out nocopy JTF_NUMBER_TABLE

584: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
585: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
586: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a22 out nocopy JTF_NUMBER_TABLE
589: , p6_a23 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE

Line 589: , p6_a23 out nocopy JTF_NUMBER_TABLE

585: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
586: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a22 out nocopy JTF_NUMBER_TABLE
589: , p6_a23 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE

Line 590: , p6_a24 out nocopy JTF_NUMBER_TABLE

586: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a22 out nocopy JTF_NUMBER_TABLE
589: , p6_a23 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 592: , p6_a26 out nocopy JTF_NUMBER_TABLE

588: , p6_a22 out nocopy JTF_NUMBER_TABLE
589: , p6_a23 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 594: , p6_a28 out nocopy JTF_NUMBER_TABLE

590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 596: , p6_a30 out nocopy JTF_NUMBER_TABLE

592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 597: , p7_a0 in out nocopy JTF_NUMBER_TABLE

593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 599: , p7_a2 in out nocopy JTF_NUMBER_TABLE

595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE
602: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 601: , p7_a4 in out nocopy JTF_NUMBER_TABLE

597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE
602: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
604: );
605: procedure update_row(p_api_version NUMBER

Line 610: , p5_a0 JTF_NUMBER_TABLE

606: , p_init_msg_list VARCHAR2
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p5_a0 JTF_NUMBER_TABLE
611: , p5_a1 JTF_NUMBER_TABLE
612: , p5_a2 JTF_NUMBER_TABLE
613: , p5_a3 JTF_VARCHAR2_TABLE_100
614: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 611: , p5_a1 JTF_NUMBER_TABLE

607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p5_a0 JTF_NUMBER_TABLE
611: , p5_a1 JTF_NUMBER_TABLE
612: , p5_a2 JTF_NUMBER_TABLE
613: , p5_a3 JTF_VARCHAR2_TABLE_100
614: , p5_a4 JTF_VARCHAR2_TABLE_400
615: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 612: , p5_a2 JTF_NUMBER_TABLE

608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p5_a0 JTF_NUMBER_TABLE
611: , p5_a1 JTF_NUMBER_TABLE
612: , p5_a2 JTF_NUMBER_TABLE
613: , p5_a3 JTF_VARCHAR2_TABLE_100
614: , p5_a4 JTF_VARCHAR2_TABLE_400
615: , p5_a5 JTF_VARCHAR2_TABLE_2000
616: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 632: , p5_a22 JTF_NUMBER_TABLE

628: , p5_a18 JTF_VARCHAR2_TABLE_500
629: , p5_a19 JTF_VARCHAR2_TABLE_500
630: , p5_a20 JTF_VARCHAR2_TABLE_500
631: , p5_a21 JTF_VARCHAR2_TABLE_500
632: , p5_a22 JTF_NUMBER_TABLE
633: , p5_a23 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE

Line 633: , p5_a23 JTF_NUMBER_TABLE

629: , p5_a19 JTF_VARCHAR2_TABLE_500
630: , p5_a20 JTF_VARCHAR2_TABLE_500
631: , p5_a21 JTF_VARCHAR2_TABLE_500
632: , p5_a22 JTF_NUMBER_TABLE
633: , p5_a23 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE

Line 634: , p5_a24 JTF_NUMBER_TABLE

630: , p5_a20 JTF_VARCHAR2_TABLE_500
631: , p5_a21 JTF_VARCHAR2_TABLE_500
632: , p5_a22 JTF_NUMBER_TABLE
633: , p5_a23 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE

Line 636: , p5_a26 JTF_NUMBER_TABLE

632: , p5_a22 JTF_NUMBER_TABLE
633: , p5_a23 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE

Line 638: , p5_a28 JTF_NUMBER_TABLE

634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 640: , p5_a30 JTF_NUMBER_TABLE

636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 641: , p6_a0 out nocopy JTF_NUMBER_TABLE

637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 642: , p6_a1 out nocopy JTF_NUMBER_TABLE

638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
646: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 643: , p6_a2 out nocopy JTF_NUMBER_TABLE

639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
646: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
647: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 663: , p6_a22 out nocopy JTF_NUMBER_TABLE

659: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
660: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
661: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
662: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
663: , p6_a22 out nocopy JTF_NUMBER_TABLE
664: , p6_a23 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE

Line 664: , p6_a23 out nocopy JTF_NUMBER_TABLE

660: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
661: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
662: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
663: , p6_a22 out nocopy JTF_NUMBER_TABLE
664: , p6_a23 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE

Line 665: , p6_a24 out nocopy JTF_NUMBER_TABLE

661: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
662: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
663: , p6_a22 out nocopy JTF_NUMBER_TABLE
664: , p6_a23 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
669: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 667: , p6_a26 out nocopy JTF_NUMBER_TABLE

663: , p6_a22 out nocopy JTF_NUMBER_TABLE
664: , p6_a23 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
669: , p6_a28 out nocopy JTF_NUMBER_TABLE
670: , p6_a29 out nocopy JTF_DATE_TABLE
671: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 669: , p6_a28 out nocopy JTF_NUMBER_TABLE

665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
669: , p6_a28 out nocopy JTF_NUMBER_TABLE
670: , p6_a29 out nocopy JTF_DATE_TABLE
671: , p6_a30 out nocopy JTF_NUMBER_TABLE
672: );
673: procedure delete_row(p_api_version NUMBER

Line 671: , p6_a30 out nocopy JTF_NUMBER_TABLE

667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
669: , p6_a28 out nocopy JTF_NUMBER_TABLE
670: , p6_a29 out nocopy JTF_DATE_TABLE
671: , p6_a30 out nocopy JTF_NUMBER_TABLE
672: );
673: procedure delete_row(p_api_version NUMBER
674: , p_init_msg_list VARCHAR2
675: , x_return_status out nocopy VARCHAR2

Line 715: , p5_a0 JTF_NUMBER_TABLE

711: , p_init_msg_list VARCHAR2
712: , x_return_status out nocopy VARCHAR2
713: , x_msg_count out nocopy NUMBER
714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_NUMBER_TABLE
718: , p5_a3 JTF_VARCHAR2_TABLE_100
719: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 716: , p5_a1 JTF_NUMBER_TABLE

712: , x_return_status out nocopy VARCHAR2
713: , x_msg_count out nocopy NUMBER
714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_NUMBER_TABLE
718: , p5_a3 JTF_VARCHAR2_TABLE_100
719: , p5_a4 JTF_VARCHAR2_TABLE_400
720: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 717: , p5_a2 JTF_NUMBER_TABLE

713: , x_msg_count out nocopy NUMBER
714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_NUMBER_TABLE
718: , p5_a3 JTF_VARCHAR2_TABLE_100
719: , p5_a4 JTF_VARCHAR2_TABLE_400
720: , p5_a5 JTF_VARCHAR2_TABLE_2000
721: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 737: , p5_a22 JTF_NUMBER_TABLE

733: , p5_a18 JTF_VARCHAR2_TABLE_500
734: , p5_a19 JTF_VARCHAR2_TABLE_500
735: , p5_a20 JTF_VARCHAR2_TABLE_500
736: , p5_a21 JTF_VARCHAR2_TABLE_500
737: , p5_a22 JTF_NUMBER_TABLE
738: , p5_a23 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE

Line 738: , p5_a23 JTF_NUMBER_TABLE

734: , p5_a19 JTF_VARCHAR2_TABLE_500
735: , p5_a20 JTF_VARCHAR2_TABLE_500
736: , p5_a21 JTF_VARCHAR2_TABLE_500
737: , p5_a22 JTF_NUMBER_TABLE
738: , p5_a23 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE

Line 739: , p5_a24 JTF_NUMBER_TABLE

735: , p5_a20 JTF_VARCHAR2_TABLE_500
736: , p5_a21 JTF_VARCHAR2_TABLE_500
737: , p5_a22 JTF_NUMBER_TABLE
738: , p5_a23 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE

Line 741: , p5_a26 JTF_NUMBER_TABLE

737: , p5_a22 JTF_NUMBER_TABLE
738: , p5_a23 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE

Line 743: , p5_a28 JTF_NUMBER_TABLE

739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 745: , p5_a30 JTF_NUMBER_TABLE

741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 746: , p6_a0 in out nocopy JTF_NUMBER_TABLE

742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 748: , p6_a2 in out nocopy JTF_NUMBER_TABLE

744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE
751: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 750: , p6_a4 in out nocopy JTF_NUMBER_TABLE

746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE
751: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
753: );
754: procedure delete_row(p_api_version NUMBER

Line 759: , p5_a0 JTF_NUMBER_TABLE

755: , p_init_msg_list VARCHAR2
756: , x_return_status out nocopy VARCHAR2
757: , x_msg_count out nocopy NUMBER
758: , x_msg_data out nocopy VARCHAR2
759: , p5_a0 JTF_NUMBER_TABLE
760: , p5_a1 JTF_NUMBER_TABLE
761: , p5_a2 JTF_NUMBER_TABLE
762: , p5_a3 JTF_VARCHAR2_TABLE_100
763: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 760: , p5_a1 JTF_NUMBER_TABLE

756: , x_return_status out nocopy VARCHAR2
757: , x_msg_count out nocopy NUMBER
758: , x_msg_data out nocopy VARCHAR2
759: , p5_a0 JTF_NUMBER_TABLE
760: , p5_a1 JTF_NUMBER_TABLE
761: , p5_a2 JTF_NUMBER_TABLE
762: , p5_a3 JTF_VARCHAR2_TABLE_100
763: , p5_a4 JTF_VARCHAR2_TABLE_400
764: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 761: , p5_a2 JTF_NUMBER_TABLE

757: , x_msg_count out nocopy NUMBER
758: , x_msg_data out nocopy VARCHAR2
759: , p5_a0 JTF_NUMBER_TABLE
760: , p5_a1 JTF_NUMBER_TABLE
761: , p5_a2 JTF_NUMBER_TABLE
762: , p5_a3 JTF_VARCHAR2_TABLE_100
763: , p5_a4 JTF_VARCHAR2_TABLE_400
764: , p5_a5 JTF_VARCHAR2_TABLE_2000
765: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 781: , p5_a22 JTF_NUMBER_TABLE

777: , p5_a18 JTF_VARCHAR2_TABLE_500
778: , p5_a19 JTF_VARCHAR2_TABLE_500
779: , p5_a20 JTF_VARCHAR2_TABLE_500
780: , p5_a21 JTF_VARCHAR2_TABLE_500
781: , p5_a22 JTF_NUMBER_TABLE
782: , p5_a23 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE

Line 782: , p5_a23 JTF_NUMBER_TABLE

778: , p5_a19 JTF_VARCHAR2_TABLE_500
779: , p5_a20 JTF_VARCHAR2_TABLE_500
780: , p5_a21 JTF_VARCHAR2_TABLE_500
781: , p5_a22 JTF_NUMBER_TABLE
782: , p5_a23 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE

Line 783: , p5_a24 JTF_NUMBER_TABLE

779: , p5_a20 JTF_VARCHAR2_TABLE_500
780: , p5_a21 JTF_VARCHAR2_TABLE_500
781: , p5_a22 JTF_NUMBER_TABLE
782: , p5_a23 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
787: , p5_a28 JTF_NUMBER_TABLE

Line 785: , p5_a26 JTF_NUMBER_TABLE

781: , p5_a22 JTF_NUMBER_TABLE
782: , p5_a23 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
787: , p5_a28 JTF_NUMBER_TABLE
788: , p5_a29 JTF_DATE_TABLE
789: , p5_a30 JTF_NUMBER_TABLE

Line 787: , p5_a28 JTF_NUMBER_TABLE

783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
787: , p5_a28 JTF_NUMBER_TABLE
788: , p5_a29 JTF_DATE_TABLE
789: , p5_a30 JTF_NUMBER_TABLE
790: );
791: procedure validate_row(p_api_version NUMBER

Line 789: , p5_a30 JTF_NUMBER_TABLE

785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
787: , p5_a28 JTF_NUMBER_TABLE
788: , p5_a29 JTF_DATE_TABLE
789: , p5_a30 JTF_NUMBER_TABLE
790: );
791: procedure validate_row(p_api_version NUMBER
792: , p_init_msg_list VARCHAR2
793: , x_return_status out nocopy VARCHAR2

Line 833: , p5_a0 JTF_NUMBER_TABLE

829: , p_init_msg_list VARCHAR2
830: , x_return_status out nocopy VARCHAR2
831: , x_msg_count out nocopy NUMBER
832: , x_msg_data out nocopy VARCHAR2
833: , p5_a0 JTF_NUMBER_TABLE
834: , p5_a1 JTF_NUMBER_TABLE
835: , p5_a2 JTF_NUMBER_TABLE
836: , p5_a3 JTF_VARCHAR2_TABLE_100
837: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 834: , p5_a1 JTF_NUMBER_TABLE

830: , x_return_status out nocopy VARCHAR2
831: , x_msg_count out nocopy NUMBER
832: , x_msg_data out nocopy VARCHAR2
833: , p5_a0 JTF_NUMBER_TABLE
834: , p5_a1 JTF_NUMBER_TABLE
835: , p5_a2 JTF_NUMBER_TABLE
836: , p5_a3 JTF_VARCHAR2_TABLE_100
837: , p5_a4 JTF_VARCHAR2_TABLE_400
838: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 835: , p5_a2 JTF_NUMBER_TABLE

831: , x_msg_count out nocopy NUMBER
832: , x_msg_data out nocopy VARCHAR2
833: , p5_a0 JTF_NUMBER_TABLE
834: , p5_a1 JTF_NUMBER_TABLE
835: , p5_a2 JTF_NUMBER_TABLE
836: , p5_a3 JTF_VARCHAR2_TABLE_100
837: , p5_a4 JTF_VARCHAR2_TABLE_400
838: , p5_a5 JTF_VARCHAR2_TABLE_2000
839: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 855: , p5_a22 JTF_NUMBER_TABLE

851: , p5_a18 JTF_VARCHAR2_TABLE_500
852: , p5_a19 JTF_VARCHAR2_TABLE_500
853: , p5_a20 JTF_VARCHAR2_TABLE_500
854: , p5_a21 JTF_VARCHAR2_TABLE_500
855: , p5_a22 JTF_NUMBER_TABLE
856: , p5_a23 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE

Line 856: , p5_a23 JTF_NUMBER_TABLE

852: , p5_a19 JTF_VARCHAR2_TABLE_500
853: , p5_a20 JTF_VARCHAR2_TABLE_500
854: , p5_a21 JTF_VARCHAR2_TABLE_500
855: , p5_a22 JTF_NUMBER_TABLE
856: , p5_a23 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE

Line 857: , p5_a24 JTF_NUMBER_TABLE

853: , p5_a20 JTF_VARCHAR2_TABLE_500
854: , p5_a21 JTF_VARCHAR2_TABLE_500
855: , p5_a22 JTF_NUMBER_TABLE
856: , p5_a23 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE

Line 859: , p5_a26 JTF_NUMBER_TABLE

855: , p5_a22 JTF_NUMBER_TABLE
856: , p5_a23 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE

Line 861: , p5_a28 JTF_NUMBER_TABLE

857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 863: , p5_a30 JTF_NUMBER_TABLE

859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 864: , p6_a0 in out nocopy JTF_NUMBER_TABLE

860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 866: , p6_a2 in out nocopy JTF_NUMBER_TABLE

862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE
869: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 868: , p6_a4 in out nocopy JTF_NUMBER_TABLE

864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE
869: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
871: );
872: procedure validate_row(p_api_version NUMBER

Line 877: , p5_a0 JTF_NUMBER_TABLE

873: , p_init_msg_list VARCHAR2
874: , x_return_status out nocopy VARCHAR2
875: , x_msg_count out nocopy NUMBER
876: , x_msg_data out nocopy VARCHAR2
877: , p5_a0 JTF_NUMBER_TABLE
878: , p5_a1 JTF_NUMBER_TABLE
879: , p5_a2 JTF_NUMBER_TABLE
880: , p5_a3 JTF_VARCHAR2_TABLE_100
881: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 878: , p5_a1 JTF_NUMBER_TABLE

874: , x_return_status out nocopy VARCHAR2
875: , x_msg_count out nocopy NUMBER
876: , x_msg_data out nocopy VARCHAR2
877: , p5_a0 JTF_NUMBER_TABLE
878: , p5_a1 JTF_NUMBER_TABLE
879: , p5_a2 JTF_NUMBER_TABLE
880: , p5_a3 JTF_VARCHAR2_TABLE_100
881: , p5_a4 JTF_VARCHAR2_TABLE_400
882: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 879: , p5_a2 JTF_NUMBER_TABLE

875: , x_msg_count out nocopy NUMBER
876: , x_msg_data out nocopy VARCHAR2
877: , p5_a0 JTF_NUMBER_TABLE
878: , p5_a1 JTF_NUMBER_TABLE
879: , p5_a2 JTF_NUMBER_TABLE
880: , p5_a3 JTF_VARCHAR2_TABLE_100
881: , p5_a4 JTF_VARCHAR2_TABLE_400
882: , p5_a5 JTF_VARCHAR2_TABLE_2000
883: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 899: , p5_a22 JTF_NUMBER_TABLE

895: , p5_a18 JTF_VARCHAR2_TABLE_500
896: , p5_a19 JTF_VARCHAR2_TABLE_500
897: , p5_a20 JTF_VARCHAR2_TABLE_500
898: , p5_a21 JTF_VARCHAR2_TABLE_500
899: , p5_a22 JTF_NUMBER_TABLE
900: , p5_a23 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE

Line 900: , p5_a23 JTF_NUMBER_TABLE

896: , p5_a19 JTF_VARCHAR2_TABLE_500
897: , p5_a20 JTF_VARCHAR2_TABLE_500
898: , p5_a21 JTF_VARCHAR2_TABLE_500
899: , p5_a22 JTF_NUMBER_TABLE
900: , p5_a23 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE

Line 901: , p5_a24 JTF_NUMBER_TABLE

897: , p5_a20 JTF_VARCHAR2_TABLE_500
898: , p5_a21 JTF_VARCHAR2_TABLE_500
899: , p5_a22 JTF_NUMBER_TABLE
900: , p5_a23 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
905: , p5_a28 JTF_NUMBER_TABLE

Line 903: , p5_a26 JTF_NUMBER_TABLE

899: , p5_a22 JTF_NUMBER_TABLE
900: , p5_a23 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
905: , p5_a28 JTF_NUMBER_TABLE
906: , p5_a29 JTF_DATE_TABLE
907: , p5_a30 JTF_NUMBER_TABLE

Line 905: , p5_a28 JTF_NUMBER_TABLE

901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
905: , p5_a28 JTF_NUMBER_TABLE
906: , p5_a29 JTF_DATE_TABLE
907: , p5_a30 JTF_NUMBER_TABLE
908: );
909: end okl_vrr_pvt_w;

Line 907: , p5_a30 JTF_NUMBER_TABLE

903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
905: , p5_a28 JTF_NUMBER_TABLE
906: , p5_a29 JTF_DATE_TABLE
907: , p5_a30 JTF_NUMBER_TABLE
908: );
909: end okl_vrr_pvt_w;