[Home] [Help]
PACKAGE BODY: APPS.OE_LINE_UTIL_W
Source
1 package body oe_line_util_w as
2 /* $Header: OERULINB.pls 120.0 2005/05/31 23:07:06 appldev noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure post_line_process(p0_a0 NUMBER
23 , p0_a1 NUMBER
24 , p0_a2 NUMBER
25 , p0_a3 NUMBER
26 , p0_a4 NUMBER
27 , p0_a5 NUMBER
28 , p0_a6 NUMBER
29 , p0_a7 NUMBER
30 , p0_a8 NUMBER
31 , p0_a9 NUMBER
32 , p0_a10 VARCHAR2
33 , p0_a11 NUMBER
34 , p0_a12 NUMBER
35 , p0_a13 VARCHAR2
36 , p0_a14 VARCHAR2
37 , p0_a15 NUMBER
38 , p1_a0 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
39 , p1_a1 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
40 , p1_a2 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
41 , p1_a3 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
42 , p1_a4 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
43 , p1_a5 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
44 , p1_a6 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
45 , p1_a7 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
46 , p1_a8 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47 , p1_a9 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48 , p1_a10 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
49 , p1_a11 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
50 , p1_a12 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
51 , p1_a13 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000
52 , p1_a14 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
53 , p1_a15 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
54 , p1_a16 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
55 , p1_a17 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
56 , p1_a18 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
57 , p1_a19 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
58 , p1_a20 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
59 , p1_a21 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60 , p1_a22 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
61 , p1_a23 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
62 , p1_a24 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
63 , p1_a25 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
64 , p1_a26 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
65 , p1_a27 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
66 , p1_a28 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
67 , p1_a29 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
68 , p1_a30 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69 , p1_a31 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
70 , p1_a32 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
71 , p1_a33 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
72 , p1_a34 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
73 , p1_a35 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74 , p1_a36 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
75 , p1_a37 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
76 , p1_a38 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
77 , p1_a39 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
78 , p1_a40 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
79 , p1_a41 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
80 , p1_a42 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
81 , p1_a43 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
82 , p1_a44 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
83 , p1_a45 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
84 , p1_a46 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
85 , p1_a47 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
86 , p1_a48 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
87 , p1_a49 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
88 , p1_a50 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
89 , p1_a51 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
90 , p1_a52 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
91 , p1_a53 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
92 , p1_a54 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
93 , p1_a55 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94 , p1_a56 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
95 , p1_a57 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
96 , p1_a58 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
97 , p1_a59 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
98 , p1_a60 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
99 , p1_a61 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
100 , p1_a62 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
101 , p1_a63 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
102 , p1_a64 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
103 , p1_a65 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
104 , p1_a66 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
105 , p1_a67 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
106 , p1_a68 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
107 , p1_a69 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
108 , p1_a70 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
109 , p1_a71 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
110 , p1_a72 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
111 , p1_a73 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
112 , p1_a74 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
113 , p1_a75 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
114 , p1_a76 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
115 , p1_a77 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
116 , p1_a78 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
117 , p1_a79 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118 , p1_a80 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
119 , p1_a81 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120 , p1_a82 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
121 , p1_a83 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
122 , p1_a84 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
123 , p1_a85 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
124 , p1_a86 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
125 , p1_a87 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
126 , p1_a88 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
127 , p1_a89 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
128 , p1_a90 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
129 , p1_a91 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
130 , p1_a92 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
131 , p1_a93 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
132 , p1_a94 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
133 , p1_a95 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
134 , p1_a96 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
135 , p1_a97 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
136 , p1_a98 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
137 , p1_a99 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
138 , p1_a100 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
139 , p1_a101 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
140 , p1_a102 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
141 , p1_a103 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
142 , p1_a104 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143 , p1_a105 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
144 , p1_a106 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
145 , p1_a107 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
146 , p1_a108 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
147 , p1_a109 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
148 , p1_a110 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149 , p1_a111 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
150 , p1_a112 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
151 , p1_a113 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
152 , p1_a114 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153 , p1_a115 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
154 , p1_a116 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
155 , p1_a117 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
156 , p1_a118 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
157 , p1_a119 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
158 , p1_a120 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
159 , p1_a121 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
160 , p1_a122 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
161 , p1_a123 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
162 , p1_a124 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
163 , p1_a125 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
164 , p1_a126 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
165 , p1_a127 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
166 , p1_a128 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
167 , p1_a129 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
168 , p1_a130 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
169 , p1_a131 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
170 , p1_a132 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
171 , p1_a133 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
172 , p1_a134 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
173 , p1_a135 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174 , p1_a136 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
175 , p1_a137 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
176 , p1_a138 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
177 , p1_a139 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
178 , p1_a140 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
179 , p1_a141 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
180 , p1_a142 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
181 , p1_a143 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
182 , p1_a144 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
183 , p1_a145 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
184 , p1_a146 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
185 , p1_a147 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
186 , p1_a148 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
187 , p1_a149 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
188 , p1_a150 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
189 , p1_a151 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
190 , p1_a152 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
191 , p1_a153 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
192 , p1_a154 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
193 , p1_a155 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
194 , p1_a156 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
195 , p1_a157 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
196 , p1_a158 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
197 , p1_a159 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
198 , p1_a160 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
199 , p1_a161 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
200 , p1_a162 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
201 , p1_a163 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
202 , p1_a164 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
203 , p1_a165 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204 , p1_a166 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205 , p1_a167 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
206 , p1_a168 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
207 , p1_a169 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
208 , p1_a170 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
209 , p1_a171 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
210 , p1_a172 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
211 , p1_a173 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
212 , p1_a174 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
213 , p1_a175 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
214 , p1_a176 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
215 , p1_a177 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
216 , p1_a178 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
217 , p1_a179 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
218 , p1_a180 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
219 , p1_a181 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
220 , p1_a182 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221 , p1_a183 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
222 , p1_a184 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223 , p1_a185 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
224 , p1_a186 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
225 , p1_a187 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
226 , p1_a188 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
227 , p1_a189 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
228 , p1_a190 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
229 , p1_a191 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
230 , p1_a192 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
231 , p1_a193 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
232 , p1_a194 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
233 , p1_a195 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
234 , p1_a196 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
235 , p1_a197 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
236 , p1_a198 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
237 , p1_a199 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
238 , p1_a200 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
239 , p1_a201 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
240 , p1_a202 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
241 , p1_a203 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
242 , p1_a204 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
243 , p1_a205 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
244 , p1_a206 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
245 , p1_a207 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
246 , p1_a208 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
247 , p1_a209 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
248 , p1_a210 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
249 , p1_a211 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
250 , p1_a212 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
251 , p1_a213 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
252 , p1_a214 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
253 , p1_a215 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
254 , p1_a216 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
255 , p1_a217 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
256 , p1_a218 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
257 , p1_a219 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
258 , p1_a220 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
259 , p1_a221 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
260 , p1_a222 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
261 , p1_a223 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
262 , p1_a224 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
263 , p1_a225 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
264 , p1_a226 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
265 , p1_a227 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266 , p1_a228 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
267 , p1_a229 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268 , p1_a230 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
269 , p1_a231 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
270 , p1_a232 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
271 , p1_a233 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272 , p1_a234 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273 , p1_a235 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
274 , p1_a236 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
275 , p1_a237 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
276 , p1_a238 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
277 , p1_a239 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
278 , p1_a240 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
279 , p1_a241 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
280 , p1_a242 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
281 , p1_a243 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
282 , p1_a244 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
283 , p1_a245 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
284 , p1_a246 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
285 , p1_a247 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
286 , p1_a248 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
287 , p1_a249 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
288 , p1_a250 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
289 , p1_a251 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
290 , p1_a252 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_1000
291 , p1_a253 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
292 , p1_a254 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
293 , p1_a255 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
294 , p1_a256 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
295 , p1_a257 in out NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
296 , p1_a258 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
297 , p1_a259 in out NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
298 , p1_a260 in out NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
299 )
300
301 as
302 ddp_control_rec oe_globals.control_rec_type;
303 ddp_x_line_tbl oe_order_pub.line_tbl_type;
304 ddindx binary_integer; indx binary_integer;
305 begin
306
307 -- copy data to the local IN or IN-OUT args, if any
308 if p0_a0 is null
309 then ddp_control_rec.controlled_operation := null;
310 elsif p0_a0 = 0
311 then ddp_control_rec.controlled_operation := false;
312 else ddp_control_rec.controlled_operation := true;
313 end if;
314 if p0_a1 is null
315 then ddp_control_rec.private_call := null;
316 elsif p0_a1 = 0
317 then ddp_control_rec.private_call := false;
318 else ddp_control_rec.private_call := true;
319 end if;
320 if p0_a2 is null
321 then ddp_control_rec.check_security := null;
322 elsif p0_a2 = 0
323 then ddp_control_rec.check_security := false;
324 else ddp_control_rec.check_security := true;
325 end if;
326 if p0_a3 is null
327 then ddp_control_rec.clear_dependents := null;
328 elsif p0_a3 = 0
329 then ddp_control_rec.clear_dependents := false;
330 else ddp_control_rec.clear_dependents := true;
331 end if;
332 if p0_a4 is null
333 then ddp_control_rec.default_attributes := null;
334 elsif p0_a4 = 0
335 then ddp_control_rec.default_attributes := false;
336 else ddp_control_rec.default_attributes := true;
337 end if;
338 if p0_a5 is null
339 then ddp_control_rec.change_attributes := null;
340 elsif p0_a5 = 0
341 then ddp_control_rec.change_attributes := false;
342 else ddp_control_rec.change_attributes := true;
343 end if;
344 if p0_a6 is null
345 then ddp_control_rec.validate_entity := null;
346 elsif p0_a6 = 0
347 then ddp_control_rec.validate_entity := false;
348 else ddp_control_rec.validate_entity := true;
349 end if;
350 if p0_a7 is null
351 then ddp_control_rec.write_to_db := null;
352 elsif p0_a7 = 0
353 then ddp_control_rec.write_to_db := false;
354 else ddp_control_rec.write_to_db := true;
355 end if;
356 if p0_a8 is null
357 then ddp_control_rec.process_partial := null;
358 elsif p0_a8 = 0
359 then ddp_control_rec.process_partial := false;
360 else ddp_control_rec.process_partial := true;
361 end if;
362 if p0_a9 is null
363 then ddp_control_rec.process := null;
364 elsif p0_a9 = 0
365 then ddp_control_rec.process := false;
366 else ddp_control_rec.process := true;
367 end if;
368 ddp_control_rec.process_entity := p0_a10;
369 if p0_a11 is null
370 then ddp_control_rec.clear_api_cache := null;
371 elsif p0_a11 = 0
372 then ddp_control_rec.clear_api_cache := false;
373 else ddp_control_rec.clear_api_cache := true;
374 end if;
375 if p0_a12 is null
376 then ddp_control_rec.clear_api_requests := null;
377 elsif p0_a12 = 0
378 then ddp_control_rec.clear_api_requests := false;
379 else ddp_control_rec.clear_api_requests := true;
380 end if;
381 ddp_control_rec.request_category := p0_a13;
382 ddp_control_rec.request_name := p0_a14;
383 ddp_control_rec.org_id := rosetta_g_miss_num_map(p0_a15);
384
385 /* oe_order_pub_w_obsolete.rosetta_table_copy_in_p15(ddp_x_line_tbl, p1_a0
386 , p1_a1
387 , p1_a2
388 , p1_a3
389 , p1_a4
390 , p1_a5
391 , p1_a6
392 , p1_a7
393 , p1_a8
394 , p1_a9
395 , p1_a10
396 , p1_a11
397 , p1_a12
398 , p1_a13
399 , p1_a14
400 , p1_a15
401 , p1_a16
402 , p1_a17
403 , p1_a18
404 , p1_a19
405 , p1_a20
406 , p1_a21
407 , p1_a22
408 , p1_a23
409 , p1_a24
410 , p1_a25
411 , p1_a26
412 , p1_a27
413 , p1_a28
414 , p1_a29
415 , p1_a30
416 , p1_a31
417 , p1_a32
418 , p1_a33
419 , p1_a34
420 , p1_a35
421 , p1_a36
422 , p1_a37
423 , p1_a38
424 , p1_a39
425 , p1_a40
426 , p1_a41
427 , p1_a42
428 , p1_a43
429 , p1_a44
430 , p1_a45
431 , p1_a46
432 , p1_a47
433 , p1_a48
434 , p1_a49
435 , p1_a50
436 , p1_a51
437 , p1_a52
438 , p1_a53
439 , p1_a54
440 , p1_a55
441 , p1_a56
442 , p1_a57
443 , p1_a58
444 , p1_a59
445 , p1_a60
446 , p1_a61
447 , p1_a62
448 , p1_a63
449 , p1_a64
450 , p1_a65
451 , p1_a66
452 , p1_a67
453 , p1_a68
454 , p1_a69
455 , p1_a70
456 , p1_a71
457 , p1_a72
458 , p1_a73
459 , p1_a74
460 , p1_a75
461 , p1_a76
462 , p1_a77
463 , p1_a78
464 , p1_a79
465 , p1_a80
466 , p1_a81
467 , p1_a82
468 , p1_a83
469 , p1_a84
470 , p1_a85
471 , p1_a86
472 , p1_a87
473 , p1_a88
474 , p1_a89
475 , p1_a90
476 , p1_a91
477 , p1_a92
478 , p1_a93
479 , p1_a94
480 , p1_a95
481 , p1_a96
482 , p1_a97
483 , p1_a98
484 , p1_a99
485 , p1_a100
486 , p1_a101
487 , p1_a102
488 , p1_a103
489 , p1_a104
490 , p1_a105
491 , p1_a106
492 , p1_a107
493 , p1_a108
494 , p1_a109
495 , p1_a110
496 , p1_a111
497 , p1_a112
498 , p1_a113
499 , p1_a114
500 , p1_a115
501 , p1_a116
502 , p1_a117
503 , p1_a118
504 , p1_a119
505 , p1_a120
506 , p1_a121
507 , p1_a122
508 , p1_a123
509 , p1_a124
510 , p1_a125
511 , p1_a126
512 , p1_a127
513 , p1_a128
514 , p1_a129
515 , p1_a130
516 , p1_a131
517 , p1_a132
518 , p1_a133
519 , p1_a134
520 , p1_a135
521 , p1_a136
522 , p1_a137
523 , p1_a138
524 , p1_a139
525 , p1_a140
526 , p1_a141
527 , p1_a142
528 , p1_a143
529 , p1_a144
530 , p1_a145
531 , p1_a146
532 , p1_a147
533 , p1_a148
534 , p1_a149
535 , p1_a150
536 , p1_a151
537 , p1_a152
538 , p1_a153
539 , p1_a154
540 , p1_a155
541 , p1_a156
542 , p1_a157
543 , p1_a158
544 , p1_a159
545 , p1_a160
546 , p1_a161
547 , p1_a162
548 , p1_a163
549 , p1_a164
550 , p1_a165
551 , p1_a166
552 , p1_a167
553 , p1_a168
554 , p1_a169
555 , p1_a170
556 , p1_a171
557 , p1_a172
558 , p1_a173
559 , p1_a174
560 , p1_a175
561 , p1_a176
562 , p1_a177
563 , p1_a178
564 , p1_a179
565 , p1_a180
566 , p1_a181
567 , p1_a182
568 , p1_a183
569 , p1_a184
570 , p1_a185
571 , p1_a186
572 , p1_a187
573 , p1_a188
574 , p1_a189
575 , p1_a190
576 , p1_a191
577 , p1_a192
578 , p1_a193
579 , p1_a194
580 , p1_a195
581 , p1_a196
582 , p1_a197
583 , p1_a198
584 , p1_a199
585 , p1_a200
586 , p1_a201
587 , p1_a202
588 , p1_a203
589 , p1_a204
590 , p1_a205
591 , p1_a206
592 , p1_a207
593 , p1_a208
594 , p1_a209
595 , p1_a210
596 , p1_a211
597 , p1_a212
598 , p1_a213
599 , p1_a214
600 , p1_a215
601 , p1_a216
602 , p1_a217
603 , p1_a218
604 , p1_a219
605 , p1_a220
606 , p1_a221
607 , p1_a222
608 , p1_a223
609 , p1_a224
610 , p1_a225
611 , p1_a226
612 , p1_a227
613 , p1_a228
614 , p1_a229
615 , p1_a230
616 , p1_a231
617 , p1_a232
618 , p1_a233
619 , p1_a234
620 , p1_a235
621 , p1_a236
622 , p1_a237
623 , p1_a238
624 , p1_a239
625 , p1_a240
626 , p1_a241
627 , p1_a242
628 , p1_a243
629 , p1_a244
630 , p1_a245
631 , p1_a246
632 , p1_a247
633 , p1_a248
634 , p1_a249
635 , p1_a250
636 , p1_a251
637 , p1_a252
638 , p1_a253
639 , p1_a254
640 , p1_a255
641 , p1_a256
642 , p1_a257
643 , p1_a258
644 , p1_a259
645 , p1_a260
646 );
647 */
648 -- here's the delegated call to the old PL/SQL routine
649 oe_line_util.post_line_process(ddp_control_rec,
650 ddp_x_line_tbl);
651
652 -- copy data back from the local variables to OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
653 /*
654 oe_order_pub_w_obsolete.rosetta_table_copy_out_p15(ddp_x_line_tbl, p1_a0
655 , p1_a1
656 , p1_a2
657 , p1_a3
658 , p1_a4
659 , p1_a5
660 , p1_a6
661 , p1_a7
662 , p1_a8
663 , p1_a9
664 , p1_a10
665 , p1_a11
666 , p1_a12
667 , p1_a13
668 , p1_a14
669 , p1_a15
670 , p1_a16
671 , p1_a17
672 , p1_a18
673 , p1_a19
674 , p1_a20
675 , p1_a21
676 , p1_a22
677 , p1_a23
678 , p1_a24
679 , p1_a25
680 , p1_a26
681 , p1_a27
682 , p1_a28
683 , p1_a29
684 , p1_a30
685 , p1_a31
686 , p1_a32
687 , p1_a33
688 , p1_a34
689 , p1_a35
690 , p1_a36
691 , p1_a37
692 , p1_a38
693 , p1_a39
694 , p1_a40
695 , p1_a41
696 , p1_a42
697 , p1_a43
698 , p1_a44
699 , p1_a45
700 , p1_a46
701 , p1_a47
702 , p1_a48
703 , p1_a49
704 , p1_a50
705 , p1_a51
706 , p1_a52
707 , p1_a53
708 , p1_a54
709 , p1_a55
710 , p1_a56
711 , p1_a57
712 , p1_a58
713 , p1_a59
714 , p1_a60
715 , p1_a61
716 , p1_a62
717 , p1_a63
718 , p1_a64
719 , p1_a65
720 , p1_a66
721 , p1_a67
722 , p1_a68
723 , p1_a69
724 , p1_a70
725 , p1_a71
726 , p1_a72
727 , p1_a73
728 , p1_a74
729 , p1_a75
730 , p1_a76
731 , p1_a77
732 , p1_a78
733 , p1_a79
734 , p1_a80
735 , p1_a81
736 , p1_a82
737 , p1_a83
738 , p1_a84
739 , p1_a85
740 , p1_a86
741 , p1_a87
742 , p1_a88
743 , p1_a89
744 , p1_a90
745 , p1_a91
746 , p1_a92
747 , p1_a93
748 , p1_a94
749 , p1_a95
750 , p1_a96
751 , p1_a97
752 , p1_a98
753 , p1_a99
754 , p1_a100
755 , p1_a101
756 , p1_a102
757 , p1_a103
758 , p1_a104
759 , p1_a105
760 , p1_a106
761 , p1_a107
762 , p1_a108
763 , p1_a109
764 , p1_a110
765 , p1_a111
766 , p1_a112
767 , p1_a113
768 , p1_a114
769 , p1_a115
770 , p1_a116
771 , p1_a117
772 , p1_a118
773 , p1_a119
774 , p1_a120
775 , p1_a121
776 , p1_a122
777 , p1_a123
778 , p1_a124
779 , p1_a125
780 , p1_a126
781 , p1_a127
782 , p1_a128
783 , p1_a129
784 , p1_a130
785 , p1_a131
786 , p1_a132
787 , p1_a133
788 , p1_a134
789 , p1_a135
790 , p1_a136
791 , p1_a137
792 , p1_a138
793 , p1_a139
794 , p1_a140
795 , p1_a141
796 , p1_a142
797 , p1_a143
798 , p1_a144
799 , p1_a145
800 , p1_a146
801 , p1_a147
802 , p1_a148
803 , p1_a149
804 , p1_a150
805 , p1_a151
806 , p1_a152
807 , p1_a153
808 , p1_a154
809 , p1_a155
810 , p1_a156
811 , p1_a157
812 , p1_a158
813 , p1_a159
814 , p1_a160
815 , p1_a161
816 , p1_a162
817 , p1_a163
818 , p1_a164
819 , p1_a165
820 , p1_a166
821 , p1_a167
822 , p1_a168
823 , p1_a169
824 , p1_a170
825 , p1_a171
826 , p1_a172
827 , p1_a173
828 , p1_a174
829 , p1_a175
830 , p1_a176
831 , p1_a177
832 , p1_a178
833 , p1_a179
834 , p1_a180
835 , p1_a181
836 , p1_a182
837 , p1_a183
838 , p1_a184
839 , p1_a185
840 , p1_a186
841 , p1_a187
842 , p1_a188
843 , p1_a189
844 , p1_a190
845 , p1_a191
846 , p1_a192
847 , p1_a193
848 , p1_a194
849 , p1_a195
850 , p1_a196
851 , p1_a197
852 , p1_a198
853 , p1_a199
854 , p1_a200
855 , p1_a201
856 , p1_a202
857 , p1_a203
858 , p1_a204
859 , p1_a205
860 , p1_a206
861 , p1_a207
862 , p1_a208
863 , p1_a209
864 , p1_a210
865 , p1_a211
866 , p1_a212
867 , p1_a213
868 , p1_a214
869 , p1_a215
870 , p1_a216
871 , p1_a217
872 , p1_a218
873 , p1_a219
874 , p1_a220
875 , p1_a221
876 , p1_a222
877 , p1_a223
878 , p1_a224
879 , p1_a225
880 , p1_a226
881 , p1_a227
882 , p1_a228
883 , p1_a229
884 , p1_a230
885 , p1_a231
886 , p1_a232
887 , p1_a233
888 , p1_a234
889 , p1_a235
890 , p1_a236
891 , p1_a237
892 , p1_a238
893 , p1_a239
894 , p1_a240
895 , p1_a241
896 , p1_a242
897 , p1_a243
898 , p1_a244
899 , p1_a245
900 , p1_a246
901 , p1_a247
902 , p1_a248
903 , p1_a249
904 , p1_a250
905 , p1_a251
906 , p1_a252
907 , p1_a253
908 , p1_a254
909 , p1_a255
910 , p1_a256
911 , p1_a257
912 , p1_a258
913 , p1_a259
914 , p1_a260
915 );
916 */
917 end;
918
919 end oe_line_util_w;