APPS.OKL_RPC_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_rpc_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIRPCS.pls 115.3 2002/12/19 23:28:01 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_2000

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_rpc_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIRPCS.pls 115.3 2002/12/19 23:28:01 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIRPCS.pls 115.3 2002/12/19 23:28:01 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE

Line 16: , a1 out nocopy JTF_VARCHAR2_TABLE_100

12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_300
20: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 17: , a2 out nocopy JTF_VARCHAR2_TABLE_100

13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_300
20: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a6 out nocopy JTF_NUMBER_TABLE

Line 18: , a3 out nocopy JTF_VARCHAR2_TABLE_100

14: );
15: procedure rosetta_table_copy_out_p2(t okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_300
20: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE

Line 30: , a2 JTF_VARCHAR2_TABLE_100

26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_rpc_pvt.rpc_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_VARCHAR2_TABLE_100
31: , a3 JTF_NUMBER_TABLE
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_DATE_TABLE

Line 38: , a10 JTF_VARCHAR2_TABLE_100

34: , a6 JTF_DATE_TABLE
35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_DATE_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_VARCHAR2_TABLE_100
39: , a11 JTF_VARCHAR2_TABLE_100
40: , a12 JTF_VARCHAR2_TABLE_100
41: , a13 JTF_NUMBER_TABLE
42: , a14 JTF_DATE_TABLE

Line 39: , a11 JTF_VARCHAR2_TABLE_100

35: , a7 JTF_NUMBER_TABLE
36: , a8 JTF_DATE_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_VARCHAR2_TABLE_100
39: , a11 JTF_VARCHAR2_TABLE_100
40: , a12 JTF_VARCHAR2_TABLE_100
41: , a13 JTF_NUMBER_TABLE
42: , a14 JTF_DATE_TABLE
43: );

Line 40: , a12 JTF_VARCHAR2_TABLE_100

36: , a8 JTF_DATE_TABLE
37: , a9 JTF_NUMBER_TABLE
38: , a10 JTF_VARCHAR2_TABLE_100
39: , a11 JTF_VARCHAR2_TABLE_100
40: , a12 JTF_VARCHAR2_TABLE_100
41: , a13 JTF_NUMBER_TABLE
42: , a14 JTF_DATE_TABLE
43: );
44: procedure rosetta_table_copy_out_p5(t okl_rpc_pvt.rpc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 46: , a2 out nocopy JTF_VARCHAR2_TABLE_100

42: , a14 JTF_DATE_TABLE
43: );
44: procedure rosetta_table_copy_out_p5(t okl_rpc_pvt.rpc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_DATE_TABLE

Line 54: , a10 out nocopy JTF_VARCHAR2_TABLE_100

50: , a6 out nocopy JTF_DATE_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_DATE_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_DATE_TABLE

Line 55: , a11 out nocopy JTF_VARCHAR2_TABLE_100

51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_DATE_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_DATE_TABLE
59: );

Line 56: , a12 out nocopy JTF_VARCHAR2_TABLE_100

52: , a8 out nocopy JTF_DATE_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_DATE_TABLE
59: );
60:

Line 63: , a2 JTF_VARCHAR2_TABLE_100

59: );
60:
61: procedure rosetta_table_copy_in_p8(t out nocopy okl_rpc_pvt.rpcv_tbl_type, a0 JTF_NUMBER_TABLE
62: , a1 JTF_NUMBER_TABLE
63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_VARCHAR2_TABLE_300
67: , a6 JTF_VARCHAR2_TABLE_2000

Line 64: , a3 JTF_VARCHAR2_TABLE_100

60:
61: procedure rosetta_table_copy_in_p8(t out nocopy okl_rpc_pvt.rpcv_tbl_type, a0 JTF_NUMBER_TABLE
62: , a1 JTF_NUMBER_TABLE
63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_VARCHAR2_TABLE_300
67: , a6 JTF_VARCHAR2_TABLE_2000
68: , a7 JTF_NUMBER_TABLE

Line 74: , a13 JTF_VARCHAR2_TABLE_100

70: , a9 JTF_DATE_TABLE
71: , a10 JTF_NUMBER_TABLE
72: , a11 JTF_DATE_TABLE
73: , a12 JTF_NUMBER_TABLE
74: , a13 JTF_VARCHAR2_TABLE_100
75: , a14 JTF_VARCHAR2_TABLE_100
76: , a15 JTF_VARCHAR2_TABLE_100
77: , a16 JTF_NUMBER_TABLE
78: , a17 JTF_DATE_TABLE

Line 75: , a14 JTF_VARCHAR2_TABLE_100

71: , a10 JTF_NUMBER_TABLE
72: , a11 JTF_DATE_TABLE
73: , a12 JTF_NUMBER_TABLE
74: , a13 JTF_VARCHAR2_TABLE_100
75: , a14 JTF_VARCHAR2_TABLE_100
76: , a15 JTF_VARCHAR2_TABLE_100
77: , a16 JTF_NUMBER_TABLE
78: , a17 JTF_DATE_TABLE
79: );

Line 76: , a15 JTF_VARCHAR2_TABLE_100

72: , a11 JTF_DATE_TABLE
73: , a12 JTF_NUMBER_TABLE
74: , a13 JTF_VARCHAR2_TABLE_100
75: , a14 JTF_VARCHAR2_TABLE_100
76: , a15 JTF_VARCHAR2_TABLE_100
77: , a16 JTF_NUMBER_TABLE
78: , a17 JTF_DATE_TABLE
79: );
80: procedure rosetta_table_copy_out_p8(t okl_rpc_pvt.rpcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 82: , a2 out nocopy JTF_VARCHAR2_TABLE_100

78: , a17 JTF_DATE_TABLE
79: );
80: procedure rosetta_table_copy_out_p8(t okl_rpc_pvt.rpcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_VARCHAR2_TABLE_100
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_VARCHAR2_TABLE_300
86: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 83: , a3 out nocopy JTF_VARCHAR2_TABLE_100

79: );
80: procedure rosetta_table_copy_out_p8(t okl_rpc_pvt.rpcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_VARCHAR2_TABLE_100
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_VARCHAR2_TABLE_300
86: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
87: , a7 out nocopy JTF_NUMBER_TABLE

Line 93: , a13 out nocopy JTF_VARCHAR2_TABLE_100

89: , a9 out nocopy JTF_DATE_TABLE
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_DATE_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_VARCHAR2_TABLE_100
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_DATE_TABLE

Line 94: , a14 out nocopy JTF_VARCHAR2_TABLE_100

90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_DATE_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_VARCHAR2_TABLE_100
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_DATE_TABLE
98: );

Line 95: , a15 out nocopy JTF_VARCHAR2_TABLE_100

91: , a11 out nocopy JTF_DATE_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_VARCHAR2_TABLE_100
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_DATE_TABLE
98: );
99:

Line 149: , p5_a2 JTF_VARCHAR2_TABLE_100

145: , x_msg_count out nocopy NUMBER
146: , x_msg_data out nocopy VARCHAR2
147: , p5_a0 JTF_NUMBER_TABLE
148: , p5_a1 JTF_NUMBER_TABLE
149: , p5_a2 JTF_VARCHAR2_TABLE_100
150: , p5_a3 JTF_VARCHAR2_TABLE_100
151: , p5_a4 JTF_NUMBER_TABLE
152: , p5_a5 JTF_VARCHAR2_TABLE_300
153: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 150: , p5_a3 JTF_VARCHAR2_TABLE_100

146: , x_msg_data out nocopy VARCHAR2
147: , p5_a0 JTF_NUMBER_TABLE
148: , p5_a1 JTF_NUMBER_TABLE
149: , p5_a2 JTF_VARCHAR2_TABLE_100
150: , p5_a3 JTF_VARCHAR2_TABLE_100
151: , p5_a4 JTF_NUMBER_TABLE
152: , p5_a5 JTF_VARCHAR2_TABLE_300
153: , p5_a6 JTF_VARCHAR2_TABLE_2000
154: , p5_a7 JTF_NUMBER_TABLE

Line 160: , p5_a13 JTF_VARCHAR2_TABLE_100

156: , p5_a9 JTF_DATE_TABLE
157: , p5_a10 JTF_NUMBER_TABLE
158: , p5_a11 JTF_DATE_TABLE
159: , p5_a12 JTF_NUMBER_TABLE
160: , p5_a13 JTF_VARCHAR2_TABLE_100
161: , p5_a14 JTF_VARCHAR2_TABLE_100
162: , p5_a15 JTF_VARCHAR2_TABLE_100
163: , p5_a16 JTF_NUMBER_TABLE
164: , p5_a17 JTF_DATE_TABLE

Line 161: , p5_a14 JTF_VARCHAR2_TABLE_100

157: , p5_a10 JTF_NUMBER_TABLE
158: , p5_a11 JTF_DATE_TABLE
159: , p5_a12 JTF_NUMBER_TABLE
160: , p5_a13 JTF_VARCHAR2_TABLE_100
161: , p5_a14 JTF_VARCHAR2_TABLE_100
162: , p5_a15 JTF_VARCHAR2_TABLE_100
163: , p5_a16 JTF_NUMBER_TABLE
164: , p5_a17 JTF_DATE_TABLE
165: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 162: , p5_a15 JTF_VARCHAR2_TABLE_100

158: , p5_a11 JTF_DATE_TABLE
159: , p5_a12 JTF_NUMBER_TABLE
160: , p5_a13 JTF_VARCHAR2_TABLE_100
161: , p5_a14 JTF_VARCHAR2_TABLE_100
162: , p5_a15 JTF_VARCHAR2_TABLE_100
163: , p5_a16 JTF_NUMBER_TABLE
164: , p5_a17 JTF_DATE_TABLE
165: , p6_a0 out nocopy JTF_NUMBER_TABLE
166: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 167: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

163: , p5_a16 JTF_NUMBER_TABLE
164: , p5_a17 JTF_DATE_TABLE
165: , p6_a0 out nocopy JTF_NUMBER_TABLE
166: , p6_a1 out nocopy JTF_NUMBER_TABLE
167: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
169: , p6_a4 out nocopy JTF_NUMBER_TABLE
170: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
171: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 168: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

164: , p5_a17 JTF_DATE_TABLE
165: , p6_a0 out nocopy JTF_NUMBER_TABLE
166: , p6_a1 out nocopy JTF_NUMBER_TABLE
167: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
169: , p6_a4 out nocopy JTF_NUMBER_TABLE
170: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
171: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
172: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 178: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

174: , p6_a9 out nocopy JTF_DATE_TABLE
175: , p6_a10 out nocopy JTF_NUMBER_TABLE
176: , p6_a11 out nocopy JTF_DATE_TABLE
177: , p6_a12 out nocopy JTF_NUMBER_TABLE
178: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a16 out nocopy JTF_NUMBER_TABLE
182: , p6_a17 out nocopy JTF_DATE_TABLE

Line 179: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

175: , p6_a10 out nocopy JTF_NUMBER_TABLE
176: , p6_a11 out nocopy JTF_DATE_TABLE
177: , p6_a12 out nocopy JTF_NUMBER_TABLE
178: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a16 out nocopy JTF_NUMBER_TABLE
182: , p6_a17 out nocopy JTF_DATE_TABLE
183: );

Line 180: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

176: , p6_a11 out nocopy JTF_DATE_TABLE
177: , p6_a12 out nocopy JTF_NUMBER_TABLE
178: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a16 out nocopy JTF_NUMBER_TABLE
182: , p6_a17 out nocopy JTF_DATE_TABLE
183: );
184: procedure lock_row(p_api_version NUMBER

Line 215: , p5_a2 JTF_VARCHAR2_TABLE_100

211: , x_msg_count out nocopy NUMBER
212: , x_msg_data out nocopy VARCHAR2
213: , p5_a0 JTF_NUMBER_TABLE
214: , p5_a1 JTF_NUMBER_TABLE
215: , p5_a2 JTF_VARCHAR2_TABLE_100
216: , p5_a3 JTF_VARCHAR2_TABLE_100
217: , p5_a4 JTF_NUMBER_TABLE
218: , p5_a5 JTF_VARCHAR2_TABLE_300
219: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 216: , p5_a3 JTF_VARCHAR2_TABLE_100

212: , x_msg_data out nocopy VARCHAR2
213: , p5_a0 JTF_NUMBER_TABLE
214: , p5_a1 JTF_NUMBER_TABLE
215: , p5_a2 JTF_VARCHAR2_TABLE_100
216: , p5_a3 JTF_VARCHAR2_TABLE_100
217: , p5_a4 JTF_NUMBER_TABLE
218: , p5_a5 JTF_VARCHAR2_TABLE_300
219: , p5_a6 JTF_VARCHAR2_TABLE_2000
220: , p5_a7 JTF_NUMBER_TABLE

Line 226: , p5_a13 JTF_VARCHAR2_TABLE_100

222: , p5_a9 JTF_DATE_TABLE
223: , p5_a10 JTF_NUMBER_TABLE
224: , p5_a11 JTF_DATE_TABLE
225: , p5_a12 JTF_NUMBER_TABLE
226: , p5_a13 JTF_VARCHAR2_TABLE_100
227: , p5_a14 JTF_VARCHAR2_TABLE_100
228: , p5_a15 JTF_VARCHAR2_TABLE_100
229: , p5_a16 JTF_NUMBER_TABLE
230: , p5_a17 JTF_DATE_TABLE

Line 227: , p5_a14 JTF_VARCHAR2_TABLE_100

223: , p5_a10 JTF_NUMBER_TABLE
224: , p5_a11 JTF_DATE_TABLE
225: , p5_a12 JTF_NUMBER_TABLE
226: , p5_a13 JTF_VARCHAR2_TABLE_100
227: , p5_a14 JTF_VARCHAR2_TABLE_100
228: , p5_a15 JTF_VARCHAR2_TABLE_100
229: , p5_a16 JTF_NUMBER_TABLE
230: , p5_a17 JTF_DATE_TABLE
231: );

Line 228: , p5_a15 JTF_VARCHAR2_TABLE_100

224: , p5_a11 JTF_DATE_TABLE
225: , p5_a12 JTF_NUMBER_TABLE
226: , p5_a13 JTF_VARCHAR2_TABLE_100
227: , p5_a14 JTF_VARCHAR2_TABLE_100
228: , p5_a15 JTF_VARCHAR2_TABLE_100
229: , p5_a16 JTF_NUMBER_TABLE
230: , p5_a17 JTF_DATE_TABLE
231: );
232: procedure update_row(p_api_version NUMBER

Line 281: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 282: , p5_a3 JTF_VARCHAR2_TABLE_100

278: , x_msg_data out nocopy VARCHAR2
279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_VARCHAR2_TABLE_100
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_300
285: , p5_a6 JTF_VARCHAR2_TABLE_2000
286: , p5_a7 JTF_NUMBER_TABLE

Line 292: , p5_a13 JTF_VARCHAR2_TABLE_100

288: , p5_a9 JTF_DATE_TABLE
289: , p5_a10 JTF_NUMBER_TABLE
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_NUMBER_TABLE
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_VARCHAR2_TABLE_100
294: , p5_a15 JTF_VARCHAR2_TABLE_100
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_DATE_TABLE

Line 293: , p5_a14 JTF_VARCHAR2_TABLE_100

289: , p5_a10 JTF_NUMBER_TABLE
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_NUMBER_TABLE
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_VARCHAR2_TABLE_100
294: , p5_a15 JTF_VARCHAR2_TABLE_100
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_DATE_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 294: , p5_a15 JTF_VARCHAR2_TABLE_100

290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_NUMBER_TABLE
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_VARCHAR2_TABLE_100
294: , p5_a15 JTF_VARCHAR2_TABLE_100
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_DATE_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 299: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_DATE_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
303: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 300: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

296: , p5_a17 JTF_DATE_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
303: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 310: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

306: , p6_a9 out nocopy JTF_DATE_TABLE
307: , p6_a10 out nocopy JTF_NUMBER_TABLE
308: , p6_a11 out nocopy JTF_DATE_TABLE
309: , p6_a12 out nocopy JTF_NUMBER_TABLE
310: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
311: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
312: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a16 out nocopy JTF_NUMBER_TABLE
314: , p6_a17 out nocopy JTF_DATE_TABLE

Line 311: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

307: , p6_a10 out nocopy JTF_NUMBER_TABLE
308: , p6_a11 out nocopy JTF_DATE_TABLE
309: , p6_a12 out nocopy JTF_NUMBER_TABLE
310: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
311: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
312: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a16 out nocopy JTF_NUMBER_TABLE
314: , p6_a17 out nocopy JTF_DATE_TABLE
315: );

Line 312: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

308: , p6_a11 out nocopy JTF_DATE_TABLE
309: , p6_a12 out nocopy JTF_NUMBER_TABLE
310: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
311: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
312: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a16 out nocopy JTF_NUMBER_TABLE
314: , p6_a17 out nocopy JTF_DATE_TABLE
315: );
316: procedure delete_row(p_api_version NUMBER

Line 347: , p5_a2 JTF_VARCHAR2_TABLE_100

343: , x_msg_count out nocopy NUMBER
344: , x_msg_data out nocopy VARCHAR2
345: , p5_a0 JTF_NUMBER_TABLE
346: , p5_a1 JTF_NUMBER_TABLE
347: , p5_a2 JTF_VARCHAR2_TABLE_100
348: , p5_a3 JTF_VARCHAR2_TABLE_100
349: , p5_a4 JTF_NUMBER_TABLE
350: , p5_a5 JTF_VARCHAR2_TABLE_300
351: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 348: , p5_a3 JTF_VARCHAR2_TABLE_100

344: , x_msg_data out nocopy VARCHAR2
345: , p5_a0 JTF_NUMBER_TABLE
346: , p5_a1 JTF_NUMBER_TABLE
347: , p5_a2 JTF_VARCHAR2_TABLE_100
348: , p5_a3 JTF_VARCHAR2_TABLE_100
349: , p5_a4 JTF_NUMBER_TABLE
350: , p5_a5 JTF_VARCHAR2_TABLE_300
351: , p5_a6 JTF_VARCHAR2_TABLE_2000
352: , p5_a7 JTF_NUMBER_TABLE

Line 358: , p5_a13 JTF_VARCHAR2_TABLE_100

354: , p5_a9 JTF_DATE_TABLE
355: , p5_a10 JTF_NUMBER_TABLE
356: , p5_a11 JTF_DATE_TABLE
357: , p5_a12 JTF_NUMBER_TABLE
358: , p5_a13 JTF_VARCHAR2_TABLE_100
359: , p5_a14 JTF_VARCHAR2_TABLE_100
360: , p5_a15 JTF_VARCHAR2_TABLE_100
361: , p5_a16 JTF_NUMBER_TABLE
362: , p5_a17 JTF_DATE_TABLE

Line 359: , p5_a14 JTF_VARCHAR2_TABLE_100

355: , p5_a10 JTF_NUMBER_TABLE
356: , p5_a11 JTF_DATE_TABLE
357: , p5_a12 JTF_NUMBER_TABLE
358: , p5_a13 JTF_VARCHAR2_TABLE_100
359: , p5_a14 JTF_VARCHAR2_TABLE_100
360: , p5_a15 JTF_VARCHAR2_TABLE_100
361: , p5_a16 JTF_NUMBER_TABLE
362: , p5_a17 JTF_DATE_TABLE
363: );

Line 360: , p5_a15 JTF_VARCHAR2_TABLE_100

356: , p5_a11 JTF_DATE_TABLE
357: , p5_a12 JTF_NUMBER_TABLE
358: , p5_a13 JTF_VARCHAR2_TABLE_100
359: , p5_a14 JTF_VARCHAR2_TABLE_100
360: , p5_a15 JTF_VARCHAR2_TABLE_100
361: , p5_a16 JTF_NUMBER_TABLE
362: , p5_a17 JTF_DATE_TABLE
363: );
364: procedure validate_row(p_api_version NUMBER

Line 395: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 396: , p5_a3 JTF_VARCHAR2_TABLE_100

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

Line 406: , p5_a13 JTF_VARCHAR2_TABLE_100

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

Line 407: , p5_a14 JTF_VARCHAR2_TABLE_100

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

Line 408: , p5_a15 JTF_VARCHAR2_TABLE_100

404: , p5_a11 JTF_DATE_TABLE
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_VARCHAR2_TABLE_100
407: , p5_a14 JTF_VARCHAR2_TABLE_100
408: , p5_a15 JTF_VARCHAR2_TABLE_100
409: , p5_a16 JTF_NUMBER_TABLE
410: , p5_a17 JTF_DATE_TABLE
411: );
412: end okl_rpc_pvt_w;