14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_300
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_300
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_200
45: , a42 JTF_VARCHAR2_TABLE_200
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_200
45: , a42 JTF_VARCHAR2_TABLE_200
46: , a43 JTF_VARCHAR2_TABLE_200
47: , a44 JTF_VARCHAR2_TABLE_200
55: , a52 JTF_VARCHAR2_TABLE_200
56: , a53 JTF_VARCHAR2_TABLE_200
57: , a54 JTF_VARCHAR2_TABLE_200
58: , a55 JTF_VARCHAR2_TABLE_200
59: , a56 JTF_VARCHAR2_TABLE_100
60: );
61: procedure rosetta_table_copy_out_p1(t ahl_prd_workorder_pvt.prd_workoper_tbl, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_NUMBER_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE
74: , a13 out nocopy JTF_NUMBER_TABLE
75: , a14 out nocopy JTF_VARCHAR2_TABLE_300
76: , a15 out nocopy JTF_VARCHAR2_TABLE_100
77: , a16 out nocopy JTF_VARCHAR2_TABLE_100
78: , a17 out nocopy JTF_NUMBER_TABLE
79: , a18 out nocopy JTF_VARCHAR2_TABLE_500
80: , a19 out nocopy JTF_VARCHAR2_TABLE_100
73: , a12 out nocopy JTF_NUMBER_TABLE
74: , a13 out nocopy JTF_NUMBER_TABLE
75: , a14 out nocopy JTF_VARCHAR2_TABLE_300
76: , a15 out nocopy JTF_VARCHAR2_TABLE_100
77: , a16 out nocopy JTF_VARCHAR2_TABLE_100
78: , a17 out nocopy JTF_NUMBER_TABLE
79: , a18 out nocopy JTF_VARCHAR2_TABLE_500
80: , a19 out nocopy JTF_VARCHAR2_TABLE_100
81: , a20 out nocopy JTF_VARCHAR2_TABLE_100
76: , a15 out nocopy JTF_VARCHAR2_TABLE_100
77: , a16 out nocopy JTF_VARCHAR2_TABLE_100
78: , a17 out nocopy JTF_NUMBER_TABLE
79: , a18 out nocopy JTF_VARCHAR2_TABLE_500
80: , a19 out nocopy JTF_VARCHAR2_TABLE_100
81: , a20 out nocopy JTF_VARCHAR2_TABLE_100
82: , a21 out nocopy JTF_VARCHAR2_TABLE_100
83: , a22 out nocopy JTF_NUMBER_TABLE
84: , a23 out nocopy JTF_NUMBER_TABLE
77: , a16 out nocopy JTF_VARCHAR2_TABLE_100
78: , a17 out nocopy JTF_NUMBER_TABLE
79: , a18 out nocopy JTF_VARCHAR2_TABLE_500
80: , a19 out nocopy JTF_VARCHAR2_TABLE_100
81: , a20 out nocopy JTF_VARCHAR2_TABLE_100
82: , a21 out nocopy JTF_VARCHAR2_TABLE_100
83: , a22 out nocopy JTF_NUMBER_TABLE
84: , a23 out nocopy JTF_NUMBER_TABLE
85: , a24 out nocopy JTF_DATE_TABLE
78: , a17 out nocopy JTF_NUMBER_TABLE
79: , a18 out nocopy JTF_VARCHAR2_TABLE_500
80: , a19 out nocopy JTF_VARCHAR2_TABLE_100
81: , a20 out nocopy JTF_VARCHAR2_TABLE_100
82: , a21 out nocopy JTF_VARCHAR2_TABLE_100
83: , a22 out nocopy JTF_NUMBER_TABLE
84: , a23 out nocopy JTF_NUMBER_TABLE
85: , a24 out nocopy JTF_DATE_TABLE
86: , a25 out nocopy JTF_NUMBER_TABLE
95: , a34 out nocopy JTF_NUMBER_TABLE
96: , a35 out nocopy JTF_NUMBER_TABLE
97: , a36 out nocopy JTF_NUMBER_TABLE
98: , a37 out nocopy JTF_NUMBER_TABLE
99: , a38 out nocopy JTF_VARCHAR2_TABLE_100
100: , a39 out nocopy JTF_NUMBER_TABLE
101: , a40 out nocopy JTF_VARCHAR2_TABLE_100
102: , a41 out nocopy JTF_VARCHAR2_TABLE_200
103: , a42 out nocopy JTF_VARCHAR2_TABLE_200
97: , a36 out nocopy JTF_NUMBER_TABLE
98: , a37 out nocopy JTF_NUMBER_TABLE
99: , a38 out nocopy JTF_VARCHAR2_TABLE_100
100: , a39 out nocopy JTF_NUMBER_TABLE
101: , a40 out nocopy JTF_VARCHAR2_TABLE_100
102: , a41 out nocopy JTF_VARCHAR2_TABLE_200
103: , a42 out nocopy JTF_VARCHAR2_TABLE_200
104: , a43 out nocopy JTF_VARCHAR2_TABLE_200
105: , a44 out nocopy JTF_VARCHAR2_TABLE_200
113: , a52 out nocopy JTF_VARCHAR2_TABLE_200
114: , a53 out nocopy JTF_VARCHAR2_TABLE_200
115: , a54 out nocopy JTF_VARCHAR2_TABLE_200
116: , a55 out nocopy JTF_VARCHAR2_TABLE_200
117: , a56 out nocopy JTF_VARCHAR2_TABLE_100
118: );
119:
120: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_workorder_pvt.prd_workorder_tbl, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_NUMBER_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_NUMBER_TABLE
125: , a5 JTF_VARCHAR2_TABLE_100
126: , a6 JTF_VARCHAR2_TABLE_300
127: , a7 JTF_NUMBER_TABLE
128: , a8 JTF_VARCHAR2_TABLE_100
129: , a9 JTF_VARCHAR2_TABLE_100
124: , a4 JTF_NUMBER_TABLE
125: , a5 JTF_VARCHAR2_TABLE_100
126: , a6 JTF_VARCHAR2_TABLE_300
127: , a7 JTF_NUMBER_TABLE
128: , a8 JTF_VARCHAR2_TABLE_100
129: , a9 JTF_VARCHAR2_TABLE_100
130: , a10 JTF_VARCHAR2_TABLE_300
131: , a11 JTF_NUMBER_TABLE
132: , a12 JTF_VARCHAR2_TABLE_100
125: , a5 JTF_VARCHAR2_TABLE_100
126: , a6 JTF_VARCHAR2_TABLE_300
127: , a7 JTF_NUMBER_TABLE
128: , a8 JTF_VARCHAR2_TABLE_100
129: , a9 JTF_VARCHAR2_TABLE_100
130: , a10 JTF_VARCHAR2_TABLE_300
131: , a11 JTF_NUMBER_TABLE
132: , a12 JTF_VARCHAR2_TABLE_100
133: , a13 JTF_VARCHAR2_TABLE_100
128: , a8 JTF_VARCHAR2_TABLE_100
129: , a9 JTF_VARCHAR2_TABLE_100
130: , a10 JTF_VARCHAR2_TABLE_300
131: , a11 JTF_NUMBER_TABLE
132: , a12 JTF_VARCHAR2_TABLE_100
133: , a13 JTF_VARCHAR2_TABLE_100
134: , a14 JTF_VARCHAR2_TABLE_100
135: , a15 JTF_DATE_TABLE
136: , a16 JTF_NUMBER_TABLE
129: , a9 JTF_VARCHAR2_TABLE_100
130: , a10 JTF_VARCHAR2_TABLE_300
131: , a11 JTF_NUMBER_TABLE
132: , a12 JTF_VARCHAR2_TABLE_100
133: , a13 JTF_VARCHAR2_TABLE_100
134: , a14 JTF_VARCHAR2_TABLE_100
135: , a15 JTF_DATE_TABLE
136: , a16 JTF_NUMBER_TABLE
137: , a17 JTF_NUMBER_TABLE
130: , a10 JTF_VARCHAR2_TABLE_300
131: , a11 JTF_NUMBER_TABLE
132: , a12 JTF_VARCHAR2_TABLE_100
133: , a13 JTF_VARCHAR2_TABLE_100
134: , a14 JTF_VARCHAR2_TABLE_100
135: , a15 JTF_DATE_TABLE
136: , a16 JTF_NUMBER_TABLE
137: , a17 JTF_NUMBER_TABLE
138: , a18 JTF_DATE_TABLE
145: , a25 JTF_NUMBER_TABLE
146: , a26 JTF_NUMBER_TABLE
147: , a27 JTF_NUMBER_TABLE
148: , a28 JTF_NUMBER_TABLE
149: , a29 JTF_VARCHAR2_TABLE_100
150: , a30 JTF_VARCHAR2_TABLE_100
151: , a31 JTF_VARCHAR2_TABLE_100
152: , a32 JTF_VARCHAR2_TABLE_300
153: , a33 JTF_VARCHAR2_TABLE_100
146: , a26 JTF_NUMBER_TABLE
147: , a27 JTF_NUMBER_TABLE
148: , a28 JTF_NUMBER_TABLE
149: , a29 JTF_VARCHAR2_TABLE_100
150: , a30 JTF_VARCHAR2_TABLE_100
151: , a31 JTF_VARCHAR2_TABLE_100
152: , a32 JTF_VARCHAR2_TABLE_300
153: , a33 JTF_VARCHAR2_TABLE_100
154: , a34 JTF_VARCHAR2_TABLE_100
147: , a27 JTF_NUMBER_TABLE
148: , a28 JTF_NUMBER_TABLE
149: , a29 JTF_VARCHAR2_TABLE_100
150: , a30 JTF_VARCHAR2_TABLE_100
151: , a31 JTF_VARCHAR2_TABLE_100
152: , a32 JTF_VARCHAR2_TABLE_300
153: , a33 JTF_VARCHAR2_TABLE_100
154: , a34 JTF_VARCHAR2_TABLE_100
155: , a35 JTF_VARCHAR2_TABLE_100
149: , a29 JTF_VARCHAR2_TABLE_100
150: , a30 JTF_VARCHAR2_TABLE_100
151: , a31 JTF_VARCHAR2_TABLE_100
152: , a32 JTF_VARCHAR2_TABLE_300
153: , a33 JTF_VARCHAR2_TABLE_100
154: , a34 JTF_VARCHAR2_TABLE_100
155: , a35 JTF_VARCHAR2_TABLE_100
156: , a36 JTF_NUMBER_TABLE
157: , a37 JTF_VARCHAR2_TABLE_300
150: , a30 JTF_VARCHAR2_TABLE_100
151: , a31 JTF_VARCHAR2_TABLE_100
152: , a32 JTF_VARCHAR2_TABLE_300
153: , a33 JTF_VARCHAR2_TABLE_100
154: , a34 JTF_VARCHAR2_TABLE_100
155: , a35 JTF_VARCHAR2_TABLE_100
156: , a36 JTF_NUMBER_TABLE
157: , a37 JTF_VARCHAR2_TABLE_300
158: , a38 JTF_NUMBER_TABLE
151: , a31 JTF_VARCHAR2_TABLE_100
152: , a32 JTF_VARCHAR2_TABLE_300
153: , a33 JTF_VARCHAR2_TABLE_100
154: , a34 JTF_VARCHAR2_TABLE_100
155: , a35 JTF_VARCHAR2_TABLE_100
156: , a36 JTF_NUMBER_TABLE
157: , a37 JTF_VARCHAR2_TABLE_300
158: , a38 JTF_NUMBER_TABLE
159: , a39 JTF_VARCHAR2_TABLE_100
155: , a35 JTF_VARCHAR2_TABLE_100
156: , a36 JTF_NUMBER_TABLE
157: , a37 JTF_VARCHAR2_TABLE_300
158: , a38 JTF_NUMBER_TABLE
159: , a39 JTF_VARCHAR2_TABLE_100
160: , a40 JTF_NUMBER_TABLE
161: , a41 JTF_VARCHAR2_TABLE_100
162: , a42 JTF_NUMBER_TABLE
163: , a43 JTF_NUMBER_TABLE
157: , a37 JTF_VARCHAR2_TABLE_300
158: , a38 JTF_NUMBER_TABLE
159: , a39 JTF_VARCHAR2_TABLE_100
160: , a40 JTF_NUMBER_TABLE
161: , a41 JTF_VARCHAR2_TABLE_100
162: , a42 JTF_NUMBER_TABLE
163: , a43 JTF_NUMBER_TABLE
164: , a44 JTF_VARCHAR2_TABLE_100
165: , a45 JTF_NUMBER_TABLE
160: , a40 JTF_NUMBER_TABLE
161: , a41 JTF_VARCHAR2_TABLE_100
162: , a42 JTF_NUMBER_TABLE
163: , a43 JTF_NUMBER_TABLE
164: , a44 JTF_VARCHAR2_TABLE_100
165: , a45 JTF_NUMBER_TABLE
166: , a46 JTF_NUMBER_TABLE
167: , a47 JTF_NUMBER_TABLE
168: , a48 JTF_VARCHAR2_TABLE_100
164: , a44 JTF_VARCHAR2_TABLE_100
165: , a45 JTF_NUMBER_TABLE
166: , a46 JTF_NUMBER_TABLE
167: , a47 JTF_NUMBER_TABLE
168: , a48 JTF_VARCHAR2_TABLE_100
169: , a49 JTF_NUMBER_TABLE
170: , a50 JTF_NUMBER_TABLE
171: , a51 JTF_VARCHAR2_TABLE_100
172: , a52 JTF_VARCHAR2_TABLE_100
167: , a47 JTF_NUMBER_TABLE
168: , a48 JTF_VARCHAR2_TABLE_100
169: , a49 JTF_NUMBER_TABLE
170: , a50 JTF_NUMBER_TABLE
171: , a51 JTF_VARCHAR2_TABLE_100
172: , a52 JTF_VARCHAR2_TABLE_100
173: , a53 JTF_NUMBER_TABLE
174: , a54 JTF_NUMBER_TABLE
175: , a55 JTF_VARCHAR2_TABLE_300
168: , a48 JTF_VARCHAR2_TABLE_100
169: , a49 JTF_NUMBER_TABLE
170: , a50 JTF_NUMBER_TABLE
171: , a51 JTF_VARCHAR2_TABLE_100
172: , a52 JTF_VARCHAR2_TABLE_100
173: , a53 JTF_NUMBER_TABLE
174: , a54 JTF_NUMBER_TABLE
175: , a55 JTF_VARCHAR2_TABLE_300
176: , a56 JTF_VARCHAR2_TABLE_100
172: , a52 JTF_VARCHAR2_TABLE_100
173: , a53 JTF_NUMBER_TABLE
174: , a54 JTF_NUMBER_TABLE
175: , a55 JTF_VARCHAR2_TABLE_300
176: , a56 JTF_VARCHAR2_TABLE_100
177: , a57 JTF_VARCHAR2_TABLE_100
178: , a58 JTF_NUMBER_TABLE
179: , a59 JTF_NUMBER_TABLE
180: , a60 JTF_NUMBER_TABLE
173: , a53 JTF_NUMBER_TABLE
174: , a54 JTF_NUMBER_TABLE
175: , a55 JTF_VARCHAR2_TABLE_300
176: , a56 JTF_VARCHAR2_TABLE_100
177: , a57 JTF_VARCHAR2_TABLE_100
178: , a58 JTF_NUMBER_TABLE
179: , a59 JTF_NUMBER_TABLE
180: , a60 JTF_NUMBER_TABLE
181: , a61 JTF_NUMBER_TABLE
182: , a62 JTF_NUMBER_TABLE
183: , a63 JTF_NUMBER_TABLE
184: , a64 JTF_NUMBER_TABLE
185: , a65 JTF_NUMBER_TABLE
186: , a66 JTF_VARCHAR2_TABLE_100
187: , a67 JTF_VARCHAR2_TABLE_100
188: , a68 JTF_NUMBER_TABLE
189: , a69 JTF_VARCHAR2_TABLE_100
190: , a70 JTF_NUMBER_TABLE
183: , a63 JTF_NUMBER_TABLE
184: , a64 JTF_NUMBER_TABLE
185: , a65 JTF_NUMBER_TABLE
186: , a66 JTF_VARCHAR2_TABLE_100
187: , a67 JTF_VARCHAR2_TABLE_100
188: , a68 JTF_NUMBER_TABLE
189: , a69 JTF_VARCHAR2_TABLE_100
190: , a70 JTF_NUMBER_TABLE
191: , a71 JTF_NUMBER_TABLE
185: , a65 JTF_NUMBER_TABLE
186: , a66 JTF_VARCHAR2_TABLE_100
187: , a67 JTF_VARCHAR2_TABLE_100
188: , a68 JTF_NUMBER_TABLE
189: , a69 JTF_VARCHAR2_TABLE_100
190: , a70 JTF_NUMBER_TABLE
191: , a71 JTF_NUMBER_TABLE
192: , a72 JTF_NUMBER_TABLE
193: , a73 JTF_NUMBER_TABLE
190: , a70 JTF_NUMBER_TABLE
191: , a71 JTF_NUMBER_TABLE
192: , a72 JTF_NUMBER_TABLE
193: , a73 JTF_NUMBER_TABLE
194: , a74 JTF_VARCHAR2_TABLE_100
195: , a75 JTF_NUMBER_TABLE
196: , a76 JTF_NUMBER_TABLE
197: , a77 JTF_VARCHAR2_TABLE_100
198: , a78 JTF_VARCHAR2_TABLE_200
193: , a73 JTF_NUMBER_TABLE
194: , a74 JTF_VARCHAR2_TABLE_100
195: , a75 JTF_NUMBER_TABLE
196: , a76 JTF_NUMBER_TABLE
197: , a77 JTF_VARCHAR2_TABLE_100
198: , a78 JTF_VARCHAR2_TABLE_200
199: , a79 JTF_VARCHAR2_TABLE_200
200: , a80 JTF_VARCHAR2_TABLE_200
201: , a81 JTF_VARCHAR2_TABLE_200
214: , a94 JTF_NUMBER_TABLE
215: , a95 JTF_DATE_TABLE
216: , a96 JTF_NUMBER_TABLE
217: , a97 JTF_NUMBER_TABLE
218: , a98 JTF_VARCHAR2_TABLE_100
219: , a99 JTF_VARCHAR2_TABLE_100
220: , a100 JTF_VARCHAR2_TABLE_100
221: );
222: procedure rosetta_table_copy_out_p3(t ahl_prd_workorder_pvt.prd_workorder_tbl, a0 out nocopy JTF_NUMBER_TABLE
215: , a95 JTF_DATE_TABLE
216: , a96 JTF_NUMBER_TABLE
217: , a97 JTF_NUMBER_TABLE
218: , a98 JTF_VARCHAR2_TABLE_100
219: , a99 JTF_VARCHAR2_TABLE_100
220: , a100 JTF_VARCHAR2_TABLE_100
221: );
222: procedure rosetta_table_copy_out_p3(t ahl_prd_workorder_pvt.prd_workorder_tbl, a0 out nocopy JTF_NUMBER_TABLE
223: , a1 out nocopy JTF_NUMBER_TABLE
216: , a96 JTF_NUMBER_TABLE
217: , a97 JTF_NUMBER_TABLE
218: , a98 JTF_VARCHAR2_TABLE_100
219: , a99 JTF_VARCHAR2_TABLE_100
220: , a100 JTF_VARCHAR2_TABLE_100
221: );
222: procedure rosetta_table_copy_out_p3(t ahl_prd_workorder_pvt.prd_workorder_tbl, a0 out nocopy JTF_NUMBER_TABLE
223: , a1 out nocopy JTF_NUMBER_TABLE
224: , a2 out nocopy JTF_NUMBER_TABLE
223: , a1 out nocopy JTF_NUMBER_TABLE
224: , a2 out nocopy JTF_NUMBER_TABLE
225: , a3 out nocopy JTF_NUMBER_TABLE
226: , a4 out nocopy JTF_NUMBER_TABLE
227: , a5 out nocopy JTF_VARCHAR2_TABLE_100
228: , a6 out nocopy JTF_VARCHAR2_TABLE_300
229: , a7 out nocopy JTF_NUMBER_TABLE
230: , a8 out nocopy JTF_VARCHAR2_TABLE_100
231: , a9 out nocopy JTF_VARCHAR2_TABLE_100
226: , a4 out nocopy JTF_NUMBER_TABLE
227: , a5 out nocopy JTF_VARCHAR2_TABLE_100
228: , a6 out nocopy JTF_VARCHAR2_TABLE_300
229: , a7 out nocopy JTF_NUMBER_TABLE
230: , a8 out nocopy JTF_VARCHAR2_TABLE_100
231: , a9 out nocopy JTF_VARCHAR2_TABLE_100
232: , a10 out nocopy JTF_VARCHAR2_TABLE_300
233: , a11 out nocopy JTF_NUMBER_TABLE
234: , a12 out nocopy JTF_VARCHAR2_TABLE_100
227: , a5 out nocopy JTF_VARCHAR2_TABLE_100
228: , a6 out nocopy JTF_VARCHAR2_TABLE_300
229: , a7 out nocopy JTF_NUMBER_TABLE
230: , a8 out nocopy JTF_VARCHAR2_TABLE_100
231: , a9 out nocopy JTF_VARCHAR2_TABLE_100
232: , a10 out nocopy JTF_VARCHAR2_TABLE_300
233: , a11 out nocopy JTF_NUMBER_TABLE
234: , a12 out nocopy JTF_VARCHAR2_TABLE_100
235: , a13 out nocopy JTF_VARCHAR2_TABLE_100
230: , a8 out nocopy JTF_VARCHAR2_TABLE_100
231: , a9 out nocopy JTF_VARCHAR2_TABLE_100
232: , a10 out nocopy JTF_VARCHAR2_TABLE_300
233: , a11 out nocopy JTF_NUMBER_TABLE
234: , a12 out nocopy JTF_VARCHAR2_TABLE_100
235: , a13 out nocopy JTF_VARCHAR2_TABLE_100
236: , a14 out nocopy JTF_VARCHAR2_TABLE_100
237: , a15 out nocopy JTF_DATE_TABLE
238: , a16 out nocopy JTF_NUMBER_TABLE
231: , a9 out nocopy JTF_VARCHAR2_TABLE_100
232: , a10 out nocopy JTF_VARCHAR2_TABLE_300
233: , a11 out nocopy JTF_NUMBER_TABLE
234: , a12 out nocopy JTF_VARCHAR2_TABLE_100
235: , a13 out nocopy JTF_VARCHAR2_TABLE_100
236: , a14 out nocopy JTF_VARCHAR2_TABLE_100
237: , a15 out nocopy JTF_DATE_TABLE
238: , a16 out nocopy JTF_NUMBER_TABLE
239: , a17 out nocopy JTF_NUMBER_TABLE
232: , a10 out nocopy JTF_VARCHAR2_TABLE_300
233: , a11 out nocopy JTF_NUMBER_TABLE
234: , a12 out nocopy JTF_VARCHAR2_TABLE_100
235: , a13 out nocopy JTF_VARCHAR2_TABLE_100
236: , a14 out nocopy JTF_VARCHAR2_TABLE_100
237: , a15 out nocopy JTF_DATE_TABLE
238: , a16 out nocopy JTF_NUMBER_TABLE
239: , a17 out nocopy JTF_NUMBER_TABLE
240: , a18 out nocopy JTF_DATE_TABLE
247: , a25 out nocopy JTF_NUMBER_TABLE
248: , a26 out nocopy JTF_NUMBER_TABLE
249: , a27 out nocopy JTF_NUMBER_TABLE
250: , a28 out nocopy JTF_NUMBER_TABLE
251: , a29 out nocopy JTF_VARCHAR2_TABLE_100
252: , a30 out nocopy JTF_VARCHAR2_TABLE_100
253: , a31 out nocopy JTF_VARCHAR2_TABLE_100
254: , a32 out nocopy JTF_VARCHAR2_TABLE_300
255: , a33 out nocopy JTF_VARCHAR2_TABLE_100
248: , a26 out nocopy JTF_NUMBER_TABLE
249: , a27 out nocopy JTF_NUMBER_TABLE
250: , a28 out nocopy JTF_NUMBER_TABLE
251: , a29 out nocopy JTF_VARCHAR2_TABLE_100
252: , a30 out nocopy JTF_VARCHAR2_TABLE_100
253: , a31 out nocopy JTF_VARCHAR2_TABLE_100
254: , a32 out nocopy JTF_VARCHAR2_TABLE_300
255: , a33 out nocopy JTF_VARCHAR2_TABLE_100
256: , a34 out nocopy JTF_VARCHAR2_TABLE_100
249: , a27 out nocopy JTF_NUMBER_TABLE
250: , a28 out nocopy JTF_NUMBER_TABLE
251: , a29 out nocopy JTF_VARCHAR2_TABLE_100
252: , a30 out nocopy JTF_VARCHAR2_TABLE_100
253: , a31 out nocopy JTF_VARCHAR2_TABLE_100
254: , a32 out nocopy JTF_VARCHAR2_TABLE_300
255: , a33 out nocopy JTF_VARCHAR2_TABLE_100
256: , a34 out nocopy JTF_VARCHAR2_TABLE_100
257: , a35 out nocopy JTF_VARCHAR2_TABLE_100
251: , a29 out nocopy JTF_VARCHAR2_TABLE_100
252: , a30 out nocopy JTF_VARCHAR2_TABLE_100
253: , a31 out nocopy JTF_VARCHAR2_TABLE_100
254: , a32 out nocopy JTF_VARCHAR2_TABLE_300
255: , a33 out nocopy JTF_VARCHAR2_TABLE_100
256: , a34 out nocopy JTF_VARCHAR2_TABLE_100
257: , a35 out nocopy JTF_VARCHAR2_TABLE_100
258: , a36 out nocopy JTF_NUMBER_TABLE
259: , a37 out nocopy JTF_VARCHAR2_TABLE_300
252: , a30 out nocopy JTF_VARCHAR2_TABLE_100
253: , a31 out nocopy JTF_VARCHAR2_TABLE_100
254: , a32 out nocopy JTF_VARCHAR2_TABLE_300
255: , a33 out nocopy JTF_VARCHAR2_TABLE_100
256: , a34 out nocopy JTF_VARCHAR2_TABLE_100
257: , a35 out nocopy JTF_VARCHAR2_TABLE_100
258: , a36 out nocopy JTF_NUMBER_TABLE
259: , a37 out nocopy JTF_VARCHAR2_TABLE_300
260: , a38 out nocopy JTF_NUMBER_TABLE
253: , a31 out nocopy JTF_VARCHAR2_TABLE_100
254: , a32 out nocopy JTF_VARCHAR2_TABLE_300
255: , a33 out nocopy JTF_VARCHAR2_TABLE_100
256: , a34 out nocopy JTF_VARCHAR2_TABLE_100
257: , a35 out nocopy JTF_VARCHAR2_TABLE_100
258: , a36 out nocopy JTF_NUMBER_TABLE
259: , a37 out nocopy JTF_VARCHAR2_TABLE_300
260: , a38 out nocopy JTF_NUMBER_TABLE
261: , a39 out nocopy JTF_VARCHAR2_TABLE_100
257: , a35 out nocopy JTF_VARCHAR2_TABLE_100
258: , a36 out nocopy JTF_NUMBER_TABLE
259: , a37 out nocopy JTF_VARCHAR2_TABLE_300
260: , a38 out nocopy JTF_NUMBER_TABLE
261: , a39 out nocopy JTF_VARCHAR2_TABLE_100
262: , a40 out nocopy JTF_NUMBER_TABLE
263: , a41 out nocopy JTF_VARCHAR2_TABLE_100
264: , a42 out nocopy JTF_NUMBER_TABLE
265: , a43 out nocopy JTF_NUMBER_TABLE
259: , a37 out nocopy JTF_VARCHAR2_TABLE_300
260: , a38 out nocopy JTF_NUMBER_TABLE
261: , a39 out nocopy JTF_VARCHAR2_TABLE_100
262: , a40 out nocopy JTF_NUMBER_TABLE
263: , a41 out nocopy JTF_VARCHAR2_TABLE_100
264: , a42 out nocopy JTF_NUMBER_TABLE
265: , a43 out nocopy JTF_NUMBER_TABLE
266: , a44 out nocopy JTF_VARCHAR2_TABLE_100
267: , a45 out nocopy JTF_NUMBER_TABLE
262: , a40 out nocopy JTF_NUMBER_TABLE
263: , a41 out nocopy JTF_VARCHAR2_TABLE_100
264: , a42 out nocopy JTF_NUMBER_TABLE
265: , a43 out nocopy JTF_NUMBER_TABLE
266: , a44 out nocopy JTF_VARCHAR2_TABLE_100
267: , a45 out nocopy JTF_NUMBER_TABLE
268: , a46 out nocopy JTF_NUMBER_TABLE
269: , a47 out nocopy JTF_NUMBER_TABLE
270: , a48 out nocopy JTF_VARCHAR2_TABLE_100
266: , a44 out nocopy JTF_VARCHAR2_TABLE_100
267: , a45 out nocopy JTF_NUMBER_TABLE
268: , a46 out nocopy JTF_NUMBER_TABLE
269: , a47 out nocopy JTF_NUMBER_TABLE
270: , a48 out nocopy JTF_VARCHAR2_TABLE_100
271: , a49 out nocopy JTF_NUMBER_TABLE
272: , a50 out nocopy JTF_NUMBER_TABLE
273: , a51 out nocopy JTF_VARCHAR2_TABLE_100
274: , a52 out nocopy JTF_VARCHAR2_TABLE_100
269: , a47 out nocopy JTF_NUMBER_TABLE
270: , a48 out nocopy JTF_VARCHAR2_TABLE_100
271: , a49 out nocopy JTF_NUMBER_TABLE
272: , a50 out nocopy JTF_NUMBER_TABLE
273: , a51 out nocopy JTF_VARCHAR2_TABLE_100
274: , a52 out nocopy JTF_VARCHAR2_TABLE_100
275: , a53 out nocopy JTF_NUMBER_TABLE
276: , a54 out nocopy JTF_NUMBER_TABLE
277: , a55 out nocopy JTF_VARCHAR2_TABLE_300
270: , a48 out nocopy JTF_VARCHAR2_TABLE_100
271: , a49 out nocopy JTF_NUMBER_TABLE
272: , a50 out nocopy JTF_NUMBER_TABLE
273: , a51 out nocopy JTF_VARCHAR2_TABLE_100
274: , a52 out nocopy JTF_VARCHAR2_TABLE_100
275: , a53 out nocopy JTF_NUMBER_TABLE
276: , a54 out nocopy JTF_NUMBER_TABLE
277: , a55 out nocopy JTF_VARCHAR2_TABLE_300
278: , a56 out nocopy JTF_VARCHAR2_TABLE_100
274: , a52 out nocopy JTF_VARCHAR2_TABLE_100
275: , a53 out nocopy JTF_NUMBER_TABLE
276: , a54 out nocopy JTF_NUMBER_TABLE
277: , a55 out nocopy JTF_VARCHAR2_TABLE_300
278: , a56 out nocopy JTF_VARCHAR2_TABLE_100
279: , a57 out nocopy JTF_VARCHAR2_TABLE_100
280: , a58 out nocopy JTF_NUMBER_TABLE
281: , a59 out nocopy JTF_NUMBER_TABLE
282: , a60 out nocopy JTF_NUMBER_TABLE
275: , a53 out nocopy JTF_NUMBER_TABLE
276: , a54 out nocopy JTF_NUMBER_TABLE
277: , a55 out nocopy JTF_VARCHAR2_TABLE_300
278: , a56 out nocopy JTF_VARCHAR2_TABLE_100
279: , a57 out nocopy JTF_VARCHAR2_TABLE_100
280: , a58 out nocopy JTF_NUMBER_TABLE
281: , a59 out nocopy JTF_NUMBER_TABLE
282: , a60 out nocopy JTF_NUMBER_TABLE
283: , a61 out nocopy JTF_NUMBER_TABLE
284: , a62 out nocopy JTF_NUMBER_TABLE
285: , a63 out nocopy JTF_NUMBER_TABLE
286: , a64 out nocopy JTF_NUMBER_TABLE
287: , a65 out nocopy JTF_NUMBER_TABLE
288: , a66 out nocopy JTF_VARCHAR2_TABLE_100
289: , a67 out nocopy JTF_VARCHAR2_TABLE_100
290: , a68 out nocopy JTF_NUMBER_TABLE
291: , a69 out nocopy JTF_VARCHAR2_TABLE_100
292: , a70 out nocopy JTF_NUMBER_TABLE
285: , a63 out nocopy JTF_NUMBER_TABLE
286: , a64 out nocopy JTF_NUMBER_TABLE
287: , a65 out nocopy JTF_NUMBER_TABLE
288: , a66 out nocopy JTF_VARCHAR2_TABLE_100
289: , a67 out nocopy JTF_VARCHAR2_TABLE_100
290: , a68 out nocopy JTF_NUMBER_TABLE
291: , a69 out nocopy JTF_VARCHAR2_TABLE_100
292: , a70 out nocopy JTF_NUMBER_TABLE
293: , a71 out nocopy JTF_NUMBER_TABLE
287: , a65 out nocopy JTF_NUMBER_TABLE
288: , a66 out nocopy JTF_VARCHAR2_TABLE_100
289: , a67 out nocopy JTF_VARCHAR2_TABLE_100
290: , a68 out nocopy JTF_NUMBER_TABLE
291: , a69 out nocopy JTF_VARCHAR2_TABLE_100
292: , a70 out nocopy JTF_NUMBER_TABLE
293: , a71 out nocopy JTF_NUMBER_TABLE
294: , a72 out nocopy JTF_NUMBER_TABLE
295: , a73 out nocopy JTF_NUMBER_TABLE
292: , a70 out nocopy JTF_NUMBER_TABLE
293: , a71 out nocopy JTF_NUMBER_TABLE
294: , a72 out nocopy JTF_NUMBER_TABLE
295: , a73 out nocopy JTF_NUMBER_TABLE
296: , a74 out nocopy JTF_VARCHAR2_TABLE_100
297: , a75 out nocopy JTF_NUMBER_TABLE
298: , a76 out nocopy JTF_NUMBER_TABLE
299: , a77 out nocopy JTF_VARCHAR2_TABLE_100
300: , a78 out nocopy JTF_VARCHAR2_TABLE_200
295: , a73 out nocopy JTF_NUMBER_TABLE
296: , a74 out nocopy JTF_VARCHAR2_TABLE_100
297: , a75 out nocopy JTF_NUMBER_TABLE
298: , a76 out nocopy JTF_NUMBER_TABLE
299: , a77 out nocopy JTF_VARCHAR2_TABLE_100
300: , a78 out nocopy JTF_VARCHAR2_TABLE_200
301: , a79 out nocopy JTF_VARCHAR2_TABLE_200
302: , a80 out nocopy JTF_VARCHAR2_TABLE_200
303: , a81 out nocopy JTF_VARCHAR2_TABLE_200
316: , a94 out nocopy JTF_NUMBER_TABLE
317: , a95 out nocopy JTF_DATE_TABLE
318: , a96 out nocopy JTF_NUMBER_TABLE
319: , a97 out nocopy JTF_NUMBER_TABLE
320: , a98 out nocopy JTF_VARCHAR2_TABLE_100
321: , a99 out nocopy JTF_VARCHAR2_TABLE_100
322: , a100 out nocopy JTF_VARCHAR2_TABLE_100
323: );
324:
317: , a95 out nocopy JTF_DATE_TABLE
318: , a96 out nocopy JTF_NUMBER_TABLE
319: , a97 out nocopy JTF_NUMBER_TABLE
320: , a98 out nocopy JTF_VARCHAR2_TABLE_100
321: , a99 out nocopy JTF_VARCHAR2_TABLE_100
322: , a100 out nocopy JTF_VARCHAR2_TABLE_100
323: );
324:
325: procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 JTF_NUMBER_TABLE
318: , a96 out nocopy JTF_NUMBER_TABLE
319: , a97 out nocopy JTF_NUMBER_TABLE
320: , a98 out nocopy JTF_VARCHAR2_TABLE_100
321: , a99 out nocopy JTF_VARCHAR2_TABLE_100
322: , a100 out nocopy JTF_VARCHAR2_TABLE_100
323: );
324:
325: procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 JTF_NUMBER_TABLE
326: , a1 JTF_NUMBER_TABLE
328: , a3 JTF_NUMBER_TABLE
329: , a4 JTF_NUMBER_TABLE
330: , a5 JTF_NUMBER_TABLE
331: , a6 JTF_NUMBER_TABLE
332: , a7 JTF_VARCHAR2_TABLE_100
333: );
334: procedure rosetta_table_copy_out_p5(t ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 out nocopy JTF_NUMBER_TABLE
335: , a1 out nocopy JTF_NUMBER_TABLE
336: , a2 out nocopy JTF_NUMBER_TABLE
337: , a3 out nocopy JTF_NUMBER_TABLE
338: , a4 out nocopy JTF_NUMBER_TABLE
339: , a5 out nocopy JTF_NUMBER_TABLE
340: , a6 out nocopy JTF_NUMBER_TABLE
341: , a7 out nocopy JTF_VARCHAR2_TABLE_100
342: );
343:
344: procedure rosetta_table_copy_in_p13(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
345: , a1 JTF_NUMBER_TABLE
342: );
343:
344: procedure rosetta_table_copy_in_p13(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
345: , a1 JTF_NUMBER_TABLE
346: , a2 JTF_VARCHAR2_TABLE_100
347: , a3 JTF_VARCHAR2_TABLE_2000
348: , a4 JTF_NUMBER_TABLE
349: , a5 JTF_VARCHAR2_TABLE_300
350: , a6 JTF_DATE_TABLE
351: , a7 JTF_NUMBER_TABLE
352: );
353: procedure rosetta_table_copy_out_p13(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE
355: , a2 out nocopy JTF_VARCHAR2_TABLE_100
356: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
357: , a4 out nocopy JTF_NUMBER_TABLE
358: , a5 out nocopy JTF_VARCHAR2_TABLE_300
359: , a6 out nocopy JTF_DATE_TABLE
373: , p9_a1 in out nocopy JTF_NUMBER_TABLE
374: , p9_a2 in out nocopy JTF_NUMBER_TABLE
375: , p9_a3 in out nocopy JTF_NUMBER_TABLE
376: , p9_a4 in out nocopy JTF_NUMBER_TABLE
377: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
379: , p9_a7 in out nocopy JTF_NUMBER_TABLE
380: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
381: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p9_a4 in out nocopy JTF_NUMBER_TABLE
377: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
379: , p9_a7 in out nocopy JTF_NUMBER_TABLE
380: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
381: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
382: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
383: , p9_a11 in out nocopy JTF_NUMBER_TABLE
384: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
379: , p9_a7 in out nocopy JTF_NUMBER_TABLE
380: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
381: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
382: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
383: , p9_a11 in out nocopy JTF_NUMBER_TABLE
384: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
381: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
382: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
383: , p9_a11 in out nocopy JTF_NUMBER_TABLE
384: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p9_a15 in out nocopy JTF_DATE_TABLE
388: , p9_a16 in out nocopy JTF_NUMBER_TABLE
381: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
382: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
383: , p9_a11 in out nocopy JTF_NUMBER_TABLE
384: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p9_a15 in out nocopy JTF_DATE_TABLE
388: , p9_a16 in out nocopy JTF_NUMBER_TABLE
389: , p9_a17 in out nocopy JTF_NUMBER_TABLE
382: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
383: , p9_a11 in out nocopy JTF_NUMBER_TABLE
384: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p9_a15 in out nocopy JTF_DATE_TABLE
388: , p9_a16 in out nocopy JTF_NUMBER_TABLE
389: , p9_a17 in out nocopy JTF_NUMBER_TABLE
390: , p9_a18 in out nocopy JTF_DATE_TABLE
397: , p9_a25 in out nocopy JTF_NUMBER_TABLE
398: , p9_a26 in out nocopy JTF_NUMBER_TABLE
399: , p9_a27 in out nocopy JTF_NUMBER_TABLE
400: , p9_a28 in out nocopy JTF_NUMBER_TABLE
401: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
402: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
403: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
404: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
405: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p9_a26 in out nocopy JTF_NUMBER_TABLE
399: , p9_a27 in out nocopy JTF_NUMBER_TABLE
400: , p9_a28 in out nocopy JTF_NUMBER_TABLE
401: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
402: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
403: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
404: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
405: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
399: , p9_a27 in out nocopy JTF_NUMBER_TABLE
400: , p9_a28 in out nocopy JTF_NUMBER_TABLE
401: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
402: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
403: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
404: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
405: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
401: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
402: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
403: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
404: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
405: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
408: , p9_a36 in out nocopy JTF_NUMBER_TABLE
409: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
402: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
403: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
404: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
405: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
408: , p9_a36 in out nocopy JTF_NUMBER_TABLE
409: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
410: , p9_a38 in out nocopy JTF_NUMBER_TABLE
403: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
404: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
405: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
408: , p9_a36 in out nocopy JTF_NUMBER_TABLE
409: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
410: , p9_a38 in out nocopy JTF_NUMBER_TABLE
411: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
408: , p9_a36 in out nocopy JTF_NUMBER_TABLE
409: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
410: , p9_a38 in out nocopy JTF_NUMBER_TABLE
411: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p9_a40 in out nocopy JTF_NUMBER_TABLE
413: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
414: , p9_a42 in out nocopy JTF_NUMBER_TABLE
415: , p9_a43 in out nocopy JTF_NUMBER_TABLE
409: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
410: , p9_a38 in out nocopy JTF_NUMBER_TABLE
411: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p9_a40 in out nocopy JTF_NUMBER_TABLE
413: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
414: , p9_a42 in out nocopy JTF_NUMBER_TABLE
415: , p9_a43 in out nocopy JTF_NUMBER_TABLE
416: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
417: , p9_a45 in out nocopy JTF_NUMBER_TABLE
412: , p9_a40 in out nocopy JTF_NUMBER_TABLE
413: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
414: , p9_a42 in out nocopy JTF_NUMBER_TABLE
415: , p9_a43 in out nocopy JTF_NUMBER_TABLE
416: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
417: , p9_a45 in out nocopy JTF_NUMBER_TABLE
418: , p9_a46 in out nocopy JTF_NUMBER_TABLE
419: , p9_a47 in out nocopy JTF_NUMBER_TABLE
420: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
416: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
417: , p9_a45 in out nocopy JTF_NUMBER_TABLE
418: , p9_a46 in out nocopy JTF_NUMBER_TABLE
419: , p9_a47 in out nocopy JTF_NUMBER_TABLE
420: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p9_a49 in out nocopy JTF_NUMBER_TABLE
422: , p9_a50 in out nocopy JTF_NUMBER_TABLE
423: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p9_a47 in out nocopy JTF_NUMBER_TABLE
420: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p9_a49 in out nocopy JTF_NUMBER_TABLE
422: , p9_a50 in out nocopy JTF_NUMBER_TABLE
423: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p9_a53 in out nocopy JTF_NUMBER_TABLE
426: , p9_a54 in out nocopy JTF_NUMBER_TABLE
427: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
420: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p9_a49 in out nocopy JTF_NUMBER_TABLE
422: , p9_a50 in out nocopy JTF_NUMBER_TABLE
423: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p9_a53 in out nocopy JTF_NUMBER_TABLE
426: , p9_a54 in out nocopy JTF_NUMBER_TABLE
427: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
428: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p9_a53 in out nocopy JTF_NUMBER_TABLE
426: , p9_a54 in out nocopy JTF_NUMBER_TABLE
427: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
428: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100
430: , p9_a58 in out nocopy JTF_NUMBER_TABLE
431: , p9_a59 in out nocopy JTF_NUMBER_TABLE
432: , p9_a60 in out nocopy JTF_NUMBER_TABLE
425: , p9_a53 in out nocopy JTF_NUMBER_TABLE
426: , p9_a54 in out nocopy JTF_NUMBER_TABLE
427: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
428: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100
430: , p9_a58 in out nocopy JTF_NUMBER_TABLE
431: , p9_a59 in out nocopy JTF_NUMBER_TABLE
432: , p9_a60 in out nocopy JTF_NUMBER_TABLE
433: , p9_a61 in out nocopy JTF_NUMBER_TABLE
434: , p9_a62 in out nocopy JTF_NUMBER_TABLE
435: , p9_a63 in out nocopy JTF_NUMBER_TABLE
436: , p9_a64 in out nocopy JTF_NUMBER_TABLE
437: , p9_a65 in out nocopy JTF_NUMBER_TABLE
438: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
439: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
440: , p9_a68 in out nocopy JTF_NUMBER_TABLE
441: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
442: , p9_a70 in out nocopy JTF_NUMBER_TABLE
435: , p9_a63 in out nocopy JTF_NUMBER_TABLE
436: , p9_a64 in out nocopy JTF_NUMBER_TABLE
437: , p9_a65 in out nocopy JTF_NUMBER_TABLE
438: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
439: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
440: , p9_a68 in out nocopy JTF_NUMBER_TABLE
441: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
442: , p9_a70 in out nocopy JTF_NUMBER_TABLE
443: , p9_a71 in out nocopy JTF_NUMBER_TABLE
437: , p9_a65 in out nocopy JTF_NUMBER_TABLE
438: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
439: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
440: , p9_a68 in out nocopy JTF_NUMBER_TABLE
441: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
442: , p9_a70 in out nocopy JTF_NUMBER_TABLE
443: , p9_a71 in out nocopy JTF_NUMBER_TABLE
444: , p9_a72 in out nocopy JTF_NUMBER_TABLE
445: , p9_a73 in out nocopy JTF_NUMBER_TABLE
442: , p9_a70 in out nocopy JTF_NUMBER_TABLE
443: , p9_a71 in out nocopy JTF_NUMBER_TABLE
444: , p9_a72 in out nocopy JTF_NUMBER_TABLE
445: , p9_a73 in out nocopy JTF_NUMBER_TABLE
446: , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100
447: , p9_a75 in out nocopy JTF_NUMBER_TABLE
448: , p9_a76 in out nocopy JTF_NUMBER_TABLE
449: , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100
450: , p9_a78 in out nocopy JTF_VARCHAR2_TABLE_200
445: , p9_a73 in out nocopy JTF_NUMBER_TABLE
446: , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100
447: , p9_a75 in out nocopy JTF_NUMBER_TABLE
448: , p9_a76 in out nocopy JTF_NUMBER_TABLE
449: , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100
450: , p9_a78 in out nocopy JTF_VARCHAR2_TABLE_200
451: , p9_a79 in out nocopy JTF_VARCHAR2_TABLE_200
452: , p9_a80 in out nocopy JTF_VARCHAR2_TABLE_200
453: , p9_a81 in out nocopy JTF_VARCHAR2_TABLE_200
466: , p9_a94 in out nocopy JTF_NUMBER_TABLE
467: , p9_a95 in out nocopy JTF_DATE_TABLE
468: , p9_a96 in out nocopy JTF_NUMBER_TABLE
469: , p9_a97 in out nocopy JTF_NUMBER_TABLE
470: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
472: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
473: , p10_a0 JTF_NUMBER_TABLE
474: , p10_a1 JTF_NUMBER_TABLE
467: , p9_a95 in out nocopy JTF_DATE_TABLE
468: , p9_a96 in out nocopy JTF_NUMBER_TABLE
469: , p9_a97 in out nocopy JTF_NUMBER_TABLE
470: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
472: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
473: , p10_a0 JTF_NUMBER_TABLE
474: , p10_a1 JTF_NUMBER_TABLE
475: , p10_a2 JTF_NUMBER_TABLE
468: , p9_a96 in out nocopy JTF_NUMBER_TABLE
469: , p9_a97 in out nocopy JTF_NUMBER_TABLE
470: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
472: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
473: , p10_a0 JTF_NUMBER_TABLE
474: , p10_a1 JTF_NUMBER_TABLE
475: , p10_a2 JTF_NUMBER_TABLE
476: , p10_a3 JTF_NUMBER_TABLE
476: , p10_a3 JTF_NUMBER_TABLE
477: , p10_a4 JTF_NUMBER_TABLE
478: , p10_a5 JTF_NUMBER_TABLE
479: , p10_a6 JTF_NUMBER_TABLE
480: , p10_a7 JTF_VARCHAR2_TABLE_100
481: );
482: procedure update_job(p_api_version NUMBER
483: , p_init_msg_list VARCHAR2
484: , p_commit VARCHAR2
604: , p11_a11 in out nocopy JTF_NUMBER_TABLE
605: , p11_a12 in out nocopy JTF_NUMBER_TABLE
606: , p11_a13 in out nocopy JTF_NUMBER_TABLE
607: , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300
608: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
609: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
610: , p11_a17 in out nocopy JTF_NUMBER_TABLE
611: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
612: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
605: , p11_a12 in out nocopy JTF_NUMBER_TABLE
606: , p11_a13 in out nocopy JTF_NUMBER_TABLE
607: , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300
608: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
609: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
610: , p11_a17 in out nocopy JTF_NUMBER_TABLE
611: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
612: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
613: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
608: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
609: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
610: , p11_a17 in out nocopy JTF_NUMBER_TABLE
611: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
612: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
613: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
614: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p11_a22 in out nocopy JTF_NUMBER_TABLE
616: , p11_a23 in out nocopy JTF_NUMBER_TABLE
609: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
610: , p11_a17 in out nocopy JTF_NUMBER_TABLE
611: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
612: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
613: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
614: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p11_a22 in out nocopy JTF_NUMBER_TABLE
616: , p11_a23 in out nocopy JTF_NUMBER_TABLE
617: , p11_a24 in out nocopy JTF_DATE_TABLE
610: , p11_a17 in out nocopy JTF_NUMBER_TABLE
611: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
612: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
613: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
614: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p11_a22 in out nocopy JTF_NUMBER_TABLE
616: , p11_a23 in out nocopy JTF_NUMBER_TABLE
617: , p11_a24 in out nocopy JTF_DATE_TABLE
618: , p11_a25 in out nocopy JTF_NUMBER_TABLE
627: , p11_a34 in out nocopy JTF_NUMBER_TABLE
628: , p11_a35 in out nocopy JTF_NUMBER_TABLE
629: , p11_a36 in out nocopy JTF_NUMBER_TABLE
630: , p11_a37 in out nocopy JTF_NUMBER_TABLE
631: , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100
632: , p11_a39 in out nocopy JTF_NUMBER_TABLE
633: , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100
634: , p11_a41 in out nocopy JTF_VARCHAR2_TABLE_200
635: , p11_a42 in out nocopy JTF_VARCHAR2_TABLE_200
629: , p11_a36 in out nocopy JTF_NUMBER_TABLE
630: , p11_a37 in out nocopy JTF_NUMBER_TABLE
631: , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100
632: , p11_a39 in out nocopy JTF_NUMBER_TABLE
633: , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100
634: , p11_a41 in out nocopy JTF_VARCHAR2_TABLE_200
635: , p11_a42 in out nocopy JTF_VARCHAR2_TABLE_200
636: , p11_a43 in out nocopy JTF_VARCHAR2_TABLE_200
637: , p11_a44 in out nocopy JTF_VARCHAR2_TABLE_200
645: , p11_a52 in out nocopy JTF_VARCHAR2_TABLE_200
646: , p11_a53 in out nocopy JTF_VARCHAR2_TABLE_200
647: , p11_a54 in out nocopy JTF_VARCHAR2_TABLE_200
648: , p11_a55 in out nocopy JTF_VARCHAR2_TABLE_200
649: , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100
650: );
651: procedure insert_turnover_notes(p_api_version NUMBER
652: , p_init_msg_list VARCHAR2
653: , p_commit VARCHAR2
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p9_a0 in out nocopy JTF_NUMBER_TABLE
661: , p9_a1 in out nocopy JTF_NUMBER_TABLE
662: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
664: , p9_a4 in out nocopy JTF_NUMBER_TABLE
665: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300
666: , p9_a6 in out nocopy JTF_DATE_TABLE