[Home] [Help]
PACKAGE BODY: APPS.OKL_SYSTEM_PARAMS_ALL_PUB_W
Source
1 package body okl_system_params_all_pub_w as
2 /* $Header: OKLUSYPB.pls 120.14.12010000.2 2008/11/13 16:20:44 kkorrapo ship $ */
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 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 function rosetta_g_miss_num_map(n number) return number as
17 a number := fnd_api.g_miss_num;
18 b number := 0-1962.0724;
19 begin
20 if n=a then return b; end if;
21 if n=b then return a; end if;
22 return n;
23 end;
24
25 procedure insert_system_parameters(p_api_version NUMBER
26 , p_init_msg_list VARCHAR2
27 , x_return_status out nocopy VARCHAR2
28 , x_msg_count out nocopy NUMBER
29 , x_msg_data out nocopy VARCHAR2
30 , p6_a0 out nocopy NUMBER
31 , p6_a1 out nocopy VARCHAR2
32 , p6_a2 out nocopy VARCHAR2
33 , p6_a3 out nocopy NUMBER
34 , p6_a4 out nocopy NUMBER
35 , p6_a5 out nocopy VARCHAR2
36 , p6_a6 out nocopy NUMBER
37 , p6_a7 out nocopy VARCHAR2
38 , p6_a8 out nocopy VARCHAR2
39 , p6_a9 out nocopy VARCHAR2
40 , p6_a10 out nocopy VARCHAR2
41 , p6_a11 out nocopy VARCHAR2
42 , p6_a12 out nocopy NUMBER
43 , p6_a13 out nocopy NUMBER
44 , p6_a14 out nocopy NUMBER
45 , p6_a15 out nocopy VARCHAR2
46 , p6_a16 out nocopy VARCHAR2
47 , p6_a17 out nocopy NUMBER
48 , p6_a18 out nocopy VARCHAR2
49 , p6_a19 out nocopy NUMBER
50 , p6_a20 out nocopy NUMBER
51 , p6_a21 out nocopy VARCHAR2
52 , p6_a22 out nocopy VARCHAR2
53 , p6_a23 out nocopy NUMBER
54 , p6_a24 out nocopy VARCHAR2
55 , p6_a25 out nocopy VARCHAR2
56 , p6_a26 out nocopy VARCHAR2
57 , p6_a27 out nocopy VARCHAR2
58 , p6_a28 out nocopy NUMBER
59 , p6_a29 out nocopy NUMBER
60 , p6_a30 out nocopy NUMBER
61 , p6_a31 out nocopy VARCHAR2
62 , p6_a32 out nocopy NUMBER
63 , p6_a33 out nocopy NUMBER
64 , p6_a34 out nocopy NUMBER
65 , p6_a35 out nocopy NUMBER
66 , p6_a36 out nocopy NUMBER
67 , p6_a37 out nocopy DATE
68 , p6_a38 out nocopy VARCHAR2
69 , p6_a39 out nocopy VARCHAR2
70 , p6_a40 out nocopy VARCHAR2
71 , p6_a41 out nocopy VARCHAR2
72 , p6_a42 out nocopy VARCHAR2
73 , p6_a43 out nocopy VARCHAR2
74 , p6_a44 out nocopy VARCHAR2
75 , p6_a45 out nocopy VARCHAR2
76 , p6_a46 out nocopy VARCHAR2
77 , p6_a47 out nocopy VARCHAR2
78 , p6_a48 out nocopy VARCHAR2
79 , p6_a49 out nocopy VARCHAR2
80 , p6_a50 out nocopy VARCHAR2
81 , p6_a51 out nocopy VARCHAR2
82 , p6_a52 out nocopy VARCHAR2
83 , p6_a53 out nocopy VARCHAR2
84 , p6_a54 out nocopy NUMBER
85 , p6_a55 out nocopy DATE
86 , p6_a56 out nocopy NUMBER
87 , p6_a57 out nocopy DATE
88 , p6_a58 out nocopy NUMBER
89 , p6_a59 out nocopy VARCHAR2
90 , p6_a60 out nocopy VARCHAR2
91 , p6_a61 out nocopy VARCHAR2
92 , p6_a62 out nocopy VARCHAR2
93 , p5_a0 NUMBER := 0-1962.0724
94 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
95 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
96 , p5_a3 NUMBER := 0-1962.0724
97 , p5_a4 NUMBER := 0-1962.0724
98 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a6 NUMBER := 0-1962.0724
100 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
101 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
102 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
103 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
104 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
105 , p5_a12 NUMBER := 0-1962.0724
106 , p5_a13 NUMBER := 0-1962.0724
107 , p5_a14 NUMBER := 0-1962.0724
108 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
109 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
110 , p5_a17 NUMBER := 0-1962.0724
111 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
112 , p5_a19 NUMBER := 0-1962.0724
113 , p5_a20 NUMBER := 0-1962.0724
114 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
115 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
116 , p5_a23 NUMBER := 0-1962.0724
117 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
119 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
120 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
121 , p5_a28 NUMBER := 0-1962.0724
122 , p5_a29 NUMBER := 0-1962.0724
123 , p5_a30 NUMBER := 0-1962.0724
124 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
125 , p5_a32 NUMBER := 0-1962.0724
126 , p5_a33 NUMBER := 0-1962.0724
127 , p5_a34 NUMBER := 0-1962.0724
128 , p5_a35 NUMBER := 0-1962.0724
129 , p5_a36 NUMBER := 0-1962.0724
130 , p5_a37 DATE := fnd_api.g_miss_date
131 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
132 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
133 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
134 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
135 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
136 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
137 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
138 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
139 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
140 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
141 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
142 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
143 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
144 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
145 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
146 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
147 , p5_a54 NUMBER := 0-1962.0724
148 , p5_a55 DATE := fnd_api.g_miss_date
149 , p5_a56 NUMBER := 0-1962.0724
150 , p5_a57 DATE := fnd_api.g_miss_date
151 , p5_a58 NUMBER := 0-1962.0724
152 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
153 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
154 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
155 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
156 )
157
158 as
159 ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
160 ddx_sypv_rec okl_system_params_all_pub.sypv_rec_type;
161 ddindx binary_integer; indx binary_integer;
162 begin
163
164 -- copy data to the local IN or IN-OUT args, if any
165
166
167
168
169
170 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
171 ddp_sypv_rec.delink_yn := p5_a1;
172 ddp_sypv_rec.remk_subinventory := p5_a2;
173 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
174 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
175 ddp_sypv_rec.remk_process_code := p5_a5;
176 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
177 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
178 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
179 ddp_sypv_rec.tax_upfront_yn := p5_a9;
180 ddp_sypv_rec.tax_invoice_yn := p5_a10;
181 ddp_sypv_rec.tax_schedule_yn := p5_a11;
182 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
183 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
184 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
185 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
186 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
187 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
188 ddp_sypv_rec.owner_type_code := p5_a18;
189 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
190 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
191 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
192 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
193 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
194 ddp_sypv_rec.corporate_book := p5_a24;
195 ddp_sypv_rec.tax_book_1 := p5_a25;
196 ddp_sypv_rec.tax_book_2 := p5_a26;
197 ddp_sypv_rec.depreciate_yn := p5_a27;
198 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
199 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
200 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
201 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
202 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
203 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
204 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
205 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
206 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
207 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
208 ddp_sypv_rec.attribute_category := p5_a38;
209 ddp_sypv_rec.attribute1 := p5_a39;
210 ddp_sypv_rec.attribute2 := p5_a40;
211 ddp_sypv_rec.attribute3 := p5_a41;
212 ddp_sypv_rec.attribute4 := p5_a42;
213 ddp_sypv_rec.attribute5 := p5_a43;
214 ddp_sypv_rec.attribute6 := p5_a44;
215 ddp_sypv_rec.attribute7 := p5_a45;
216 ddp_sypv_rec.attribute8 := p5_a46;
217 ddp_sypv_rec.attribute9 := p5_a47;
218 ddp_sypv_rec.attribute10 := p5_a48;
219 ddp_sypv_rec.attribute11 := p5_a49;
220 ddp_sypv_rec.attribute12 := p5_a50;
221 ddp_sypv_rec.attribute13 := p5_a51;
222 ddp_sypv_rec.attribute14 := p5_a52;
223 ddp_sypv_rec.attribute15 := p5_a53;
224 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
225 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
226 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
227 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
228 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
229 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
230 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
231 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
232 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
233
234
235 -- here's the delegated call to the old PL/SQL routine
236 okl_system_params_all_pub.insert_system_parameters(p_api_version,
237 p_init_msg_list,
238 x_return_status,
239 x_msg_count,
240 x_msg_data,
241 ddp_sypv_rec,
242 ddx_sypv_rec);
243
244 -- copy data back from the local variables to OUT or IN-OUT args, if any
245
246
247
248
249
250
251 p6_a0 := rosetta_g_miss_num_map(ddx_sypv_rec.id);
252 p6_a1 := ddx_sypv_rec.delink_yn;
253 p6_a2 := ddx_sypv_rec.remk_subinventory;
254 p6_a3 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_organization_id);
255 p6_a4 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_price_list_id);
256 p6_a5 := ddx_sypv_rec.remk_process_code;
257 p6_a6 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_item_template_id);
258 p6_a7 := ddx_sypv_rec.remk_item_invoiced_code;
259 p6_a8 := ddx_sypv_rec.lease_inv_org_yn;
260 p6_a9 := ddx_sypv_rec.tax_upfront_yn;
261 p6_a10 := ddx_sypv_rec.tax_invoice_yn;
262 p6_a11 := ddx_sypv_rec.tax_schedule_yn;
263 p6_a12 := rosetta_g_miss_num_map(ddx_sypv_rec.tax_upfront_sty_id);
264 p6_a13 := rosetta_g_miss_num_map(ddx_sypv_rec.category_set_id);
265 p6_a14 := rosetta_g_miss_num_map(ddx_sypv_rec.validation_set_id);
266 p6_a15 := ddx_sypv_rec.cancel_quotes_yn;
267 p6_a16 := ddx_sypv_rec.chk_accrual_previous_mnth_yn;
268 p6_a17 := rosetta_g_miss_num_map(ddx_sypv_rec.task_template_group_id);
269 p6_a18 := ddx_sypv_rec.owner_type_code;
270 p6_a19 := rosetta_g_miss_num_map(ddx_sypv_rec.owner_id);
271 p6_a20 := rosetta_g_miss_num_map(ddx_sypv_rec.item_inv_org_id);
272 p6_a21 := ddx_sypv_rec.rpt_prod_book_type_code;
273 p6_a22 := ddx_sypv_rec.asst_add_book_type_code;
274 p6_a23 := rosetta_g_miss_num_map(ddx_sypv_rec.ccard_remittance_id);
275 p6_a24 := ddx_sypv_rec.corporate_book;
276 p6_a25 := ddx_sypv_rec.tax_book_1;
277 p6_a26 := ddx_sypv_rec.tax_book_2;
278 p6_a27 := ddx_sypv_rec.depreciate_yn;
279 p6_a28 := rosetta_g_miss_num_map(ddx_sypv_rec.fa_location_id);
280 p6_a29 := rosetta_g_miss_num_map(ddx_sypv_rec.formula_id);
281 p6_a30 := rosetta_g_miss_num_map(ddx_sypv_rec.asset_key_id);
282 p6_a31 := ddx_sypv_rec.part_trmnt_apply_round_diff;
283 p6_a32 := rosetta_g_miss_num_map(ddx_sypv_rec.object_version_number);
284 p6_a33 := rosetta_g_miss_num_map(ddx_sypv_rec.org_id);
285 p6_a34 := rosetta_g_miss_num_map(ddx_sypv_rec.request_id);
286 p6_a35 := rosetta_g_miss_num_map(ddx_sypv_rec.program_application_id);
287 p6_a36 := rosetta_g_miss_num_map(ddx_sypv_rec.program_id);
288 p6_a37 := ddx_sypv_rec.program_update_date;
289 p6_a38 := ddx_sypv_rec.attribute_category;
290 p6_a39 := ddx_sypv_rec.attribute1;
291 p6_a40 := ddx_sypv_rec.attribute2;
292 p6_a41 := ddx_sypv_rec.attribute3;
293 p6_a42 := ddx_sypv_rec.attribute4;
294 p6_a43 := ddx_sypv_rec.attribute5;
295 p6_a44 := ddx_sypv_rec.attribute6;
296 p6_a45 := ddx_sypv_rec.attribute7;
297 p6_a46 := ddx_sypv_rec.attribute8;
298 p6_a47 := ddx_sypv_rec.attribute9;
299 p6_a48 := ddx_sypv_rec.attribute10;
300 p6_a49 := ddx_sypv_rec.attribute11;
301 p6_a50 := ddx_sypv_rec.attribute12;
302 p6_a51 := ddx_sypv_rec.attribute13;
303 p6_a52 := ddx_sypv_rec.attribute14;
304 p6_a53 := ddx_sypv_rec.attribute15;
305 p6_a54 := rosetta_g_miss_num_map(ddx_sypv_rec.created_by);
306 p6_a55 := ddx_sypv_rec.creation_date;
307 p6_a56 := rosetta_g_miss_num_map(ddx_sypv_rec.last_updated_by);
308 p6_a57 := ddx_sypv_rec.last_update_date;
309 p6_a58 := rosetta_g_miss_num_map(ddx_sypv_rec.last_update_login);
310 p6_a59 := ddx_sypv_rec.lseapp_seq_prefix_txt;
311 p6_a60 := ddx_sypv_rec.lseopp_seq_prefix_txt;
312 p6_a61 := ddx_sypv_rec.qckqte_seq_prefix_txt;
313 p6_a62 := ddx_sypv_rec.lseqte_seq_prefix_txt;
314 end;
315
316 procedure insert_system_parameters(p_api_version NUMBER
317 , p_init_msg_list VARCHAR2
318 , x_return_status out nocopy VARCHAR2
319 , x_msg_count out nocopy NUMBER
320 , x_msg_data out nocopy VARCHAR2
321 , p5_a0 JTF_NUMBER_TABLE
322 , p5_a1 JTF_VARCHAR2_TABLE_100
323 , p5_a2 JTF_VARCHAR2_TABLE_100
324 , p5_a3 JTF_NUMBER_TABLE
325 , p5_a4 JTF_NUMBER_TABLE
326 , p5_a5 JTF_VARCHAR2_TABLE_100
327 , p5_a6 JTF_NUMBER_TABLE
328 , p5_a7 JTF_VARCHAR2_TABLE_100
329 , p5_a8 JTF_VARCHAR2_TABLE_100
330 , p5_a9 JTF_VARCHAR2_TABLE_100
331 , p5_a10 JTF_VARCHAR2_TABLE_100
332 , p5_a11 JTF_VARCHAR2_TABLE_100
333 , p5_a12 JTF_NUMBER_TABLE
334 , p5_a13 JTF_NUMBER_TABLE
335 , p5_a14 JTF_NUMBER_TABLE
336 , p5_a15 JTF_VARCHAR2_TABLE_100
337 , p5_a16 JTF_VARCHAR2_TABLE_100
338 , p5_a17 JTF_NUMBER_TABLE
339 , p5_a18 JTF_VARCHAR2_TABLE_100
340 , p5_a19 JTF_NUMBER_TABLE
341 , p5_a20 JTF_NUMBER_TABLE
342 , p5_a21 JTF_VARCHAR2_TABLE_100
343 , p5_a22 JTF_VARCHAR2_TABLE_100
344 , p5_a23 JTF_NUMBER_TABLE
345 , p5_a24 JTF_VARCHAR2_TABLE_100
346 , p5_a25 JTF_VARCHAR2_TABLE_100
347 , p5_a26 JTF_VARCHAR2_TABLE_100
348 , p5_a27 JTF_VARCHAR2_TABLE_100
349 , p5_a28 JTF_NUMBER_TABLE
350 , p5_a29 JTF_NUMBER_TABLE
351 , p5_a30 JTF_NUMBER_TABLE
352 , p5_a31 JTF_VARCHAR2_TABLE_100
353 , p5_a32 JTF_NUMBER_TABLE
354 , p5_a33 JTF_NUMBER_TABLE
355 , p5_a34 JTF_NUMBER_TABLE
356 , p5_a35 JTF_NUMBER_TABLE
357 , p5_a36 JTF_NUMBER_TABLE
358 , p5_a37 JTF_DATE_TABLE
359 , p5_a38 JTF_VARCHAR2_TABLE_100
360 , p5_a39 JTF_VARCHAR2_TABLE_500
361 , p5_a40 JTF_VARCHAR2_TABLE_500
362 , p5_a41 JTF_VARCHAR2_TABLE_500
363 , p5_a42 JTF_VARCHAR2_TABLE_500
364 , p5_a43 JTF_VARCHAR2_TABLE_500
365 , p5_a44 JTF_VARCHAR2_TABLE_500
366 , p5_a45 JTF_VARCHAR2_TABLE_500
367 , p5_a46 JTF_VARCHAR2_TABLE_500
368 , p5_a47 JTF_VARCHAR2_TABLE_500
369 , p5_a48 JTF_VARCHAR2_TABLE_500
370 , p5_a49 JTF_VARCHAR2_TABLE_500
371 , p5_a50 JTF_VARCHAR2_TABLE_500
372 , p5_a51 JTF_VARCHAR2_TABLE_500
373 , p5_a52 JTF_VARCHAR2_TABLE_500
374 , p5_a53 JTF_VARCHAR2_TABLE_500
375 , p5_a54 JTF_NUMBER_TABLE
376 , p5_a55 JTF_DATE_TABLE
377 , p5_a56 JTF_NUMBER_TABLE
378 , p5_a57 JTF_DATE_TABLE
379 , p5_a58 JTF_NUMBER_TABLE
380 , p5_a59 JTF_VARCHAR2_TABLE_200
381 , p5_a60 JTF_VARCHAR2_TABLE_200
382 , p5_a61 JTF_VARCHAR2_TABLE_200
383 , p5_a62 JTF_VARCHAR2_TABLE_200
384 , p6_a0 out nocopy JTF_NUMBER_TABLE
385 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
386 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
387 , p6_a3 out nocopy JTF_NUMBER_TABLE
388 , p6_a4 out nocopy JTF_NUMBER_TABLE
389 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
390 , p6_a6 out nocopy JTF_NUMBER_TABLE
391 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
392 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
393 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
394 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
395 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
396 , p6_a12 out nocopy JTF_NUMBER_TABLE
397 , p6_a13 out nocopy JTF_NUMBER_TABLE
398 , p6_a14 out nocopy JTF_NUMBER_TABLE
399 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
400 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
401 , p6_a17 out nocopy JTF_NUMBER_TABLE
402 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
403 , p6_a19 out nocopy JTF_NUMBER_TABLE
404 , p6_a20 out nocopy JTF_NUMBER_TABLE
405 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
406 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
407 , p6_a23 out nocopy JTF_NUMBER_TABLE
408 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
409 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
410 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
411 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
412 , p6_a28 out nocopy JTF_NUMBER_TABLE
413 , p6_a29 out nocopy JTF_NUMBER_TABLE
414 , p6_a30 out nocopy JTF_NUMBER_TABLE
415 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
416 , p6_a32 out nocopy JTF_NUMBER_TABLE
417 , p6_a33 out nocopy JTF_NUMBER_TABLE
418 , p6_a34 out nocopy JTF_NUMBER_TABLE
419 , p6_a35 out nocopy JTF_NUMBER_TABLE
420 , p6_a36 out nocopy JTF_NUMBER_TABLE
421 , p6_a37 out nocopy JTF_DATE_TABLE
422 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
423 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
424 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
425 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
426 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
427 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
428 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
429 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
430 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
431 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
432 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
433 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
434 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
435 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
436 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
437 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
438 , p6_a54 out nocopy JTF_NUMBER_TABLE
439 , p6_a55 out nocopy JTF_DATE_TABLE
440 , p6_a56 out nocopy JTF_NUMBER_TABLE
441 , p6_a57 out nocopy JTF_DATE_TABLE
442 , p6_a58 out nocopy JTF_NUMBER_TABLE
443 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
444 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_200
445 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_200
446 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_200
447 )
448
449 as
450 ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
451 ddx_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
452 ddindx binary_integer; indx binary_integer;
453 begin
454
455 -- copy data to the local IN or IN-OUT args, if any
456
457
458
459
460
461 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
462 , p5_a1
463 , p5_a2
464 , p5_a3
465 , p5_a4
466 , p5_a5
467 , p5_a6
468 , p5_a7
469 , p5_a8
470 , p5_a9
471 , p5_a10
472 , p5_a11
473 , p5_a12
474 , p5_a13
475 , p5_a14
476 , p5_a15
477 , p5_a16
478 , p5_a17
479 , p5_a18
480 , p5_a19
481 , p5_a20
482 , p5_a21
483 , p5_a22
484 , p5_a23
485 , p5_a24
486 , p5_a25
487 , p5_a26
488 , p5_a27
489 , p5_a28
490 , p5_a29
491 , p5_a30
492 , p5_a31
493 , p5_a32
494 , p5_a33
495 , p5_a34
496 , p5_a35
497 , p5_a36
498 , p5_a37
499 , p5_a38
500 , p5_a39
501 , p5_a40
502 , p5_a41
503 , p5_a42
504 , p5_a43
505 , p5_a44
506 , p5_a45
507 , p5_a46
508 , p5_a47
509 , p5_a48
510 , p5_a49
511 , p5_a50
512 , p5_a51
513 , p5_a52
514 , p5_a53
515 , p5_a54
516 , p5_a55
517 , p5_a56
518 , p5_a57
519 , p5_a58
520 , p5_a59
521 , p5_a60
522 , p5_a61
523 , p5_a62
524 );
525
526
527 -- here's the delegated call to the old PL/SQL routine
528 okl_system_params_all_pub.insert_system_parameters(p_api_version,
529 p_init_msg_list,
530 x_return_status,
531 x_msg_count,
532 x_msg_data,
533 ddp_sypv_tbl,
534 ddx_sypv_tbl);
535
536 -- copy data back from the local variables to OUT or IN-OUT args, if any
537
538
539
540
541
542
543 okl_syp_pvt_w.rosetta_table_copy_out_p2(ddx_sypv_tbl, p6_a0
544 , p6_a1
545 , p6_a2
546 , p6_a3
547 , p6_a4
548 , p6_a5
549 , p6_a6
550 , p6_a7
551 , p6_a8
552 , p6_a9
553 , p6_a10
554 , p6_a11
555 , p6_a12
556 , p6_a13
557 , p6_a14
558 , p6_a15
559 , p6_a16
560 , p6_a17
561 , p6_a18
562 , p6_a19
563 , p6_a20
564 , p6_a21
565 , p6_a22
566 , p6_a23
567 , p6_a24
568 , p6_a25
569 , p6_a26
570 , p6_a27
571 , p6_a28
572 , p6_a29
573 , p6_a30
574 , p6_a31
575 , p6_a32
576 , p6_a33
577 , p6_a34
578 , p6_a35
579 , p6_a36
580 , p6_a37
581 , p6_a38
582 , p6_a39
583 , p6_a40
584 , p6_a41
585 , p6_a42
586 , p6_a43
587 , p6_a44
588 , p6_a45
589 , p6_a46
590 , p6_a47
591 , p6_a48
592 , p6_a49
593 , p6_a50
594 , p6_a51
595 , p6_a52
596 , p6_a53
597 , p6_a54
598 , p6_a55
599 , p6_a56
600 , p6_a57
601 , p6_a58
602 , p6_a59
603 , p6_a60
604 , p6_a61
605 , p6_a62
606 );
607 end;
608
609 procedure lock_system_parameters(p_api_version NUMBER
610 , p_init_msg_list VARCHAR2
611 , x_return_status out nocopy VARCHAR2
612 , x_msg_count out nocopy NUMBER
613 , x_msg_data out nocopy VARCHAR2
614 , p5_a0 NUMBER := 0-1962.0724
615 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
616 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a3 NUMBER := 0-1962.0724
618 , p5_a4 NUMBER := 0-1962.0724
619 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
620 , p5_a6 NUMBER := 0-1962.0724
621 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
622 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
623 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
624 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
625 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
626 , p5_a12 NUMBER := 0-1962.0724
627 , p5_a13 NUMBER := 0-1962.0724
628 , p5_a14 NUMBER := 0-1962.0724
629 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
630 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
631 , p5_a17 NUMBER := 0-1962.0724
632 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
633 , p5_a19 NUMBER := 0-1962.0724
634 , p5_a20 NUMBER := 0-1962.0724
635 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
637 , p5_a23 NUMBER := 0-1962.0724
638 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
639 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
640 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
641 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
642 , p5_a28 NUMBER := 0-1962.0724
643 , p5_a29 NUMBER := 0-1962.0724
644 , p5_a30 NUMBER := 0-1962.0724
645 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
646 , p5_a32 NUMBER := 0-1962.0724
647 , p5_a33 NUMBER := 0-1962.0724
648 , p5_a34 NUMBER := 0-1962.0724
649 , p5_a35 NUMBER := 0-1962.0724
650 , p5_a36 NUMBER := 0-1962.0724
651 , p5_a37 DATE := fnd_api.g_miss_date
652 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
653 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
654 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
655 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
656 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
657 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
658 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
659 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
660 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
661 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
662 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
663 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
664 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
665 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
666 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
667 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
668 , p5_a54 NUMBER := 0-1962.0724
669 , p5_a55 DATE := fnd_api.g_miss_date
670 , p5_a56 NUMBER := 0-1962.0724
671 , p5_a57 DATE := fnd_api.g_miss_date
672 , p5_a58 NUMBER := 0-1962.0724
673 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
674 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
675 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
676 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
677 )
678
679 as
680 ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
681 ddindx binary_integer; indx binary_integer;
682 begin
683
684 -- copy data to the local IN or IN-OUT args, if any
685
686
687
688
689
690 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
691 ddp_sypv_rec.delink_yn := p5_a1;
692 ddp_sypv_rec.remk_subinventory := p5_a2;
693 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
694 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
695 ddp_sypv_rec.remk_process_code := p5_a5;
696 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
697 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
698 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
699 ddp_sypv_rec.tax_upfront_yn := p5_a9;
700 ddp_sypv_rec.tax_invoice_yn := p5_a10;
701 ddp_sypv_rec.tax_schedule_yn := p5_a11;
702 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
703 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
704 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
705 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
706 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
707 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
708 ddp_sypv_rec.owner_type_code := p5_a18;
709 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
710 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
711 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
712 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
713 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
714 ddp_sypv_rec.corporate_book := p5_a24;
715 ddp_sypv_rec.tax_book_1 := p5_a25;
716 ddp_sypv_rec.tax_book_2 := p5_a26;
717 ddp_sypv_rec.depreciate_yn := p5_a27;
718 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
719 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
720 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
721 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
722 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
723 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
724 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
725 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
726 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
727 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
728 ddp_sypv_rec.attribute_category := p5_a38;
729 ddp_sypv_rec.attribute1 := p5_a39;
730 ddp_sypv_rec.attribute2 := p5_a40;
731 ddp_sypv_rec.attribute3 := p5_a41;
732 ddp_sypv_rec.attribute4 := p5_a42;
733 ddp_sypv_rec.attribute5 := p5_a43;
734 ddp_sypv_rec.attribute6 := p5_a44;
735 ddp_sypv_rec.attribute7 := p5_a45;
736 ddp_sypv_rec.attribute8 := p5_a46;
737 ddp_sypv_rec.attribute9 := p5_a47;
738 ddp_sypv_rec.attribute10 := p5_a48;
739 ddp_sypv_rec.attribute11 := p5_a49;
740 ddp_sypv_rec.attribute12 := p5_a50;
741 ddp_sypv_rec.attribute13 := p5_a51;
742 ddp_sypv_rec.attribute14 := p5_a52;
743 ddp_sypv_rec.attribute15 := p5_a53;
744 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
745 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
746 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
747 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
748 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
749 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
750 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
751 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
752 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
753
754 -- here's the delegated call to the old PL/SQL routine
755 okl_system_params_all_pub.lock_system_parameters(p_api_version,
756 p_init_msg_list,
757 x_return_status,
758 x_msg_count,
759 x_msg_data,
760 ddp_sypv_rec);
761
762 -- copy data back from the local variables to OUT or IN-OUT args, if any
763
764
765
766
767
768 end;
769
770 procedure lock_system_parameters(p_api_version NUMBER
771 , p_init_msg_list VARCHAR2
772 , x_return_status out nocopy VARCHAR2
773 , x_msg_count out nocopy NUMBER
774 , x_msg_data out nocopy VARCHAR2
775 , p5_a0 JTF_NUMBER_TABLE
776 , p5_a1 JTF_VARCHAR2_TABLE_100
777 , p5_a2 JTF_VARCHAR2_TABLE_100
778 , p5_a3 JTF_NUMBER_TABLE
779 , p5_a4 JTF_NUMBER_TABLE
780 , p5_a5 JTF_VARCHAR2_TABLE_100
781 , p5_a6 JTF_NUMBER_TABLE
782 , p5_a7 JTF_VARCHAR2_TABLE_100
783 , p5_a8 JTF_VARCHAR2_TABLE_100
784 , p5_a9 JTF_VARCHAR2_TABLE_100
785 , p5_a10 JTF_VARCHAR2_TABLE_100
786 , p5_a11 JTF_VARCHAR2_TABLE_100
787 , p5_a12 JTF_NUMBER_TABLE
788 , p5_a13 JTF_NUMBER_TABLE
789 , p5_a14 JTF_NUMBER_TABLE
790 , p5_a15 JTF_VARCHAR2_TABLE_100
791 , p5_a16 JTF_VARCHAR2_TABLE_100
792 , p5_a17 JTF_NUMBER_TABLE
793 , p5_a18 JTF_VARCHAR2_TABLE_100
794 , p5_a19 JTF_NUMBER_TABLE
795 , p5_a20 JTF_NUMBER_TABLE
796 , p5_a21 JTF_VARCHAR2_TABLE_100
797 , p5_a22 JTF_VARCHAR2_TABLE_100
798 , p5_a23 JTF_NUMBER_TABLE
799 , p5_a24 JTF_VARCHAR2_TABLE_100
800 , p5_a25 JTF_VARCHAR2_TABLE_100
801 , p5_a26 JTF_VARCHAR2_TABLE_100
802 , p5_a27 JTF_VARCHAR2_TABLE_100
803 , p5_a28 JTF_NUMBER_TABLE
804 , p5_a29 JTF_NUMBER_TABLE
805 , p5_a30 JTF_NUMBER_TABLE
806 , p5_a31 JTF_VARCHAR2_TABLE_100
807 , p5_a32 JTF_NUMBER_TABLE
808 , p5_a33 JTF_NUMBER_TABLE
809 , p5_a34 JTF_NUMBER_TABLE
810 , p5_a35 JTF_NUMBER_TABLE
811 , p5_a36 JTF_NUMBER_TABLE
812 , p5_a37 JTF_DATE_TABLE
813 , p5_a38 JTF_VARCHAR2_TABLE_100
814 , p5_a39 JTF_VARCHAR2_TABLE_500
815 , p5_a40 JTF_VARCHAR2_TABLE_500
816 , p5_a41 JTF_VARCHAR2_TABLE_500
817 , p5_a42 JTF_VARCHAR2_TABLE_500
818 , p5_a43 JTF_VARCHAR2_TABLE_500
819 , p5_a44 JTF_VARCHAR2_TABLE_500
820 , p5_a45 JTF_VARCHAR2_TABLE_500
821 , p5_a46 JTF_VARCHAR2_TABLE_500
822 , p5_a47 JTF_VARCHAR2_TABLE_500
823 , p5_a48 JTF_VARCHAR2_TABLE_500
824 , p5_a49 JTF_VARCHAR2_TABLE_500
825 , p5_a50 JTF_VARCHAR2_TABLE_500
826 , p5_a51 JTF_VARCHAR2_TABLE_500
827 , p5_a52 JTF_VARCHAR2_TABLE_500
828 , p5_a53 JTF_VARCHAR2_TABLE_500
829 , p5_a54 JTF_NUMBER_TABLE
830 , p5_a55 JTF_DATE_TABLE
831 , p5_a56 JTF_NUMBER_TABLE
832 , p5_a57 JTF_DATE_TABLE
833 , p5_a58 JTF_NUMBER_TABLE
834 , p5_a59 JTF_VARCHAR2_TABLE_200
835 , p5_a60 JTF_VARCHAR2_TABLE_200
836 , p5_a61 JTF_VARCHAR2_TABLE_200
837 , p5_a62 JTF_VARCHAR2_TABLE_200
838 )
839
840 as
841 ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
842 ddindx binary_integer; indx binary_integer;
843 begin
844
845 -- copy data to the local IN or IN-OUT args, if any
846
847
848
849
850
851 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
852 , p5_a1
853 , p5_a2
854 , p5_a3
855 , p5_a4
856 , p5_a5
857 , p5_a6
858 , p5_a7
859 , p5_a8
860 , p5_a9
861 , p5_a10
862 , p5_a11
863 , p5_a12
864 , p5_a13
865 , p5_a14
866 , p5_a15
867 , p5_a16
868 , p5_a17
869 , p5_a18
870 , p5_a19
871 , p5_a20
872 , p5_a21
873 , p5_a22
874 , p5_a23
875 , p5_a24
876 , p5_a25
877 , p5_a26
878 , p5_a27
879 , p5_a28
880 , p5_a29
881 , p5_a30
882 , p5_a31
883 , p5_a32
884 , p5_a33
885 , p5_a34
886 , p5_a35
887 , p5_a36
888 , p5_a37
889 , p5_a38
890 , p5_a39
891 , p5_a40
892 , p5_a41
893 , p5_a42
894 , p5_a43
895 , p5_a44
896 , p5_a45
897 , p5_a46
898 , p5_a47
899 , p5_a48
900 , p5_a49
901 , p5_a50
902 , p5_a51
903 , p5_a52
904 , p5_a53
905 , p5_a54
906 , p5_a55
907 , p5_a56
908 , p5_a57
909 , p5_a58
910 , p5_a59
911 , p5_a60
912 , p5_a61
913 , p5_a62
914 );
915
916 -- here's the delegated call to the old PL/SQL routine
917 okl_system_params_all_pub.lock_system_parameters(p_api_version,
918 p_init_msg_list,
919 x_return_status,
920 x_msg_count,
921 x_msg_data,
922 ddp_sypv_tbl);
923
924 -- copy data back from the local variables to OUT or IN-OUT args, if any
925
926
927
928
929
930 end;
931
932 procedure update_system_parameters(p_api_version NUMBER
933 , p_init_msg_list VARCHAR2
934 , x_return_status out nocopy VARCHAR2
935 , x_msg_count out nocopy NUMBER
936 , x_msg_data out nocopy VARCHAR2
937 , p6_a0 out nocopy NUMBER
938 , p6_a1 out nocopy VARCHAR2
939 , p6_a2 out nocopy VARCHAR2
940 , p6_a3 out nocopy NUMBER
941 , p6_a4 out nocopy NUMBER
942 , p6_a5 out nocopy VARCHAR2
943 , p6_a6 out nocopy NUMBER
944 , p6_a7 out nocopy VARCHAR2
945 , p6_a8 out nocopy VARCHAR2
946 , p6_a9 out nocopy VARCHAR2
947 , p6_a10 out nocopy VARCHAR2
948 , p6_a11 out nocopy VARCHAR2
949 , p6_a12 out nocopy NUMBER
950 , p6_a13 out nocopy NUMBER
951 , p6_a14 out nocopy NUMBER
952 , p6_a15 out nocopy VARCHAR2
953 , p6_a16 out nocopy VARCHAR2
954 , p6_a17 out nocopy NUMBER
955 , p6_a18 out nocopy VARCHAR2
956 , p6_a19 out nocopy NUMBER
957 , p6_a20 out nocopy NUMBER
958 , p6_a21 out nocopy VARCHAR2
959 , p6_a22 out nocopy VARCHAR2
960 , p6_a23 out nocopy NUMBER
961 , p6_a24 out nocopy VARCHAR2
962 , p6_a25 out nocopy VARCHAR2
963 , p6_a26 out nocopy VARCHAR2
964 , p6_a27 out nocopy VARCHAR2
965 , p6_a28 out nocopy NUMBER
966 , p6_a29 out nocopy NUMBER
967 , p6_a30 out nocopy NUMBER
968 , p6_a31 out nocopy VARCHAR2
969 , p6_a32 out nocopy NUMBER
970 , p6_a33 out nocopy NUMBER
971 , p6_a34 out nocopy NUMBER
972 , p6_a35 out nocopy NUMBER
973 , p6_a36 out nocopy NUMBER
974 , p6_a37 out nocopy DATE
975 , p6_a38 out nocopy VARCHAR2
976 , p6_a39 out nocopy VARCHAR2
977 , p6_a40 out nocopy VARCHAR2
978 , p6_a41 out nocopy VARCHAR2
979 , p6_a42 out nocopy VARCHAR2
980 , p6_a43 out nocopy VARCHAR2
981 , p6_a44 out nocopy VARCHAR2
982 , p6_a45 out nocopy VARCHAR2
983 , p6_a46 out nocopy VARCHAR2
984 , p6_a47 out nocopy VARCHAR2
985 , p6_a48 out nocopy VARCHAR2
986 , p6_a49 out nocopy VARCHAR2
987 , p6_a50 out nocopy VARCHAR2
988 , p6_a51 out nocopy VARCHAR2
989 , p6_a52 out nocopy VARCHAR2
990 , p6_a53 out nocopy VARCHAR2
991 , p6_a54 out nocopy NUMBER
992 , p6_a55 out nocopy DATE
993 , p6_a56 out nocopy NUMBER
994 , p6_a57 out nocopy DATE
995 , p6_a58 out nocopy NUMBER
996 , p6_a59 out nocopy VARCHAR2
997 , p6_a60 out nocopy VARCHAR2
998 , p6_a61 out nocopy VARCHAR2
999 , p6_a62 out nocopy VARCHAR2
1000 , p5_a0 NUMBER := 0-1962.0724
1001 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1002 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1003 , p5_a3 NUMBER := 0-1962.0724
1004 , p5_a4 NUMBER := 0-1962.0724
1005 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1006 , p5_a6 NUMBER := 0-1962.0724
1007 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1008 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1009 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1010 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1011 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1012 , p5_a12 NUMBER := 0-1962.0724
1013 , p5_a13 NUMBER := 0-1962.0724
1014 , p5_a14 NUMBER := 0-1962.0724
1015 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1016 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1017 , p5_a17 NUMBER := 0-1962.0724
1018 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1019 , p5_a19 NUMBER := 0-1962.0724
1020 , p5_a20 NUMBER := 0-1962.0724
1021 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1022 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1023 , p5_a23 NUMBER := 0-1962.0724
1024 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1025 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1026 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1027 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1028 , p5_a28 NUMBER := 0-1962.0724
1029 , p5_a29 NUMBER := 0-1962.0724
1030 , p5_a30 NUMBER := 0-1962.0724
1031 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1032 , p5_a32 NUMBER := 0-1962.0724
1033 , p5_a33 NUMBER := 0-1962.0724
1034 , p5_a34 NUMBER := 0-1962.0724
1035 , p5_a35 NUMBER := 0-1962.0724
1036 , p5_a36 NUMBER := 0-1962.0724
1037 , p5_a37 DATE := fnd_api.g_miss_date
1038 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1039 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1040 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1041 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1042 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1043 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1044 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1045 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1046 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1047 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1048 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1049 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1050 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1051 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1052 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1053 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1054 , p5_a54 NUMBER := 0-1962.0724
1055 , p5_a55 DATE := fnd_api.g_miss_date
1056 , p5_a56 NUMBER := 0-1962.0724
1057 , p5_a57 DATE := fnd_api.g_miss_date
1058 , p5_a58 NUMBER := 0-1962.0724
1059 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1060 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1061 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1062 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1063 )
1064
1065 as
1066 ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1067 ddx_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1068 ddindx binary_integer; indx binary_integer;
1069 begin
1070
1071 -- copy data to the local IN or IN-OUT args, if any
1072
1073
1074
1075
1076
1077 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
1078 ddp_sypv_rec.delink_yn := p5_a1;
1079 ddp_sypv_rec.remk_subinventory := p5_a2;
1080 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
1081 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
1082 ddp_sypv_rec.remk_process_code := p5_a5;
1083 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
1084 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
1085 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
1086 ddp_sypv_rec.tax_upfront_yn := p5_a9;
1087 ddp_sypv_rec.tax_invoice_yn := p5_a10;
1088 ddp_sypv_rec.tax_schedule_yn := p5_a11;
1089 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
1090 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
1091 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
1092 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
1093 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
1094 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
1095 ddp_sypv_rec.owner_type_code := p5_a18;
1096 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
1097 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
1098 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
1099 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
1100 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
1101 ddp_sypv_rec.corporate_book := p5_a24;
1102 ddp_sypv_rec.tax_book_1 := p5_a25;
1103 ddp_sypv_rec.tax_book_2 := p5_a26;
1104 ddp_sypv_rec.depreciate_yn := p5_a27;
1105 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
1106 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
1107 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
1108 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
1109 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
1110 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
1111 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
1112 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
1113 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
1114 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
1115 ddp_sypv_rec.attribute_category := p5_a38;
1116 ddp_sypv_rec.attribute1 := p5_a39;
1117 ddp_sypv_rec.attribute2 := p5_a40;
1118 ddp_sypv_rec.attribute3 := p5_a41;
1119 ddp_sypv_rec.attribute4 := p5_a42;
1120 ddp_sypv_rec.attribute5 := p5_a43;
1121 ddp_sypv_rec.attribute6 := p5_a44;
1122 ddp_sypv_rec.attribute7 := p5_a45;
1123 ddp_sypv_rec.attribute8 := p5_a46;
1124 ddp_sypv_rec.attribute9 := p5_a47;
1125 ddp_sypv_rec.attribute10 := p5_a48;
1126 ddp_sypv_rec.attribute11 := p5_a49;
1127 ddp_sypv_rec.attribute12 := p5_a50;
1128 ddp_sypv_rec.attribute13 := p5_a51;
1129 ddp_sypv_rec.attribute14 := p5_a52;
1130 ddp_sypv_rec.attribute15 := p5_a53;
1131 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1132 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
1133 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
1134 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1135 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1136 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
1137 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
1138 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
1139 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
1140
1141
1142 -- here's the delegated call to the old PL/SQL routine
1143 okl_system_params_all_pub.update_system_parameters(p_api_version,
1144 p_init_msg_list,
1145 x_return_status,
1146 x_msg_count,
1147 x_msg_data,
1148 ddp_sypv_rec,
1149 ddx_sypv_rec);
1150
1151 -- copy data back from the local variables to OUT or IN-OUT args, if any
1152
1153
1154
1155
1156
1157
1158 p6_a0 := rosetta_g_miss_num_map(ddx_sypv_rec.id);
1159 p6_a1 := ddx_sypv_rec.delink_yn;
1160 p6_a2 := ddx_sypv_rec.remk_subinventory;
1161 p6_a3 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_organization_id);
1162 p6_a4 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_price_list_id);
1163 p6_a5 := ddx_sypv_rec.remk_process_code;
1164 p6_a6 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_item_template_id);
1165 p6_a7 := ddx_sypv_rec.remk_item_invoiced_code;
1166 p6_a8 := ddx_sypv_rec.lease_inv_org_yn;
1167 p6_a9 := ddx_sypv_rec.tax_upfront_yn;
1168 p6_a10 := ddx_sypv_rec.tax_invoice_yn;
1169 p6_a11 := ddx_sypv_rec.tax_schedule_yn;
1170 p6_a12 := rosetta_g_miss_num_map(ddx_sypv_rec.tax_upfront_sty_id);
1171 p6_a13 := rosetta_g_miss_num_map(ddx_sypv_rec.category_set_id);
1172 p6_a14 := rosetta_g_miss_num_map(ddx_sypv_rec.validation_set_id);
1173 p6_a15 := ddx_sypv_rec.cancel_quotes_yn;
1174 p6_a16 := ddx_sypv_rec.chk_accrual_previous_mnth_yn;
1175 p6_a17 := rosetta_g_miss_num_map(ddx_sypv_rec.task_template_group_id);
1176 p6_a18 := ddx_sypv_rec.owner_type_code;
1177 p6_a19 := rosetta_g_miss_num_map(ddx_sypv_rec.owner_id);
1178 p6_a20 := rosetta_g_miss_num_map(ddx_sypv_rec.item_inv_org_id);
1179 p6_a21 := ddx_sypv_rec.rpt_prod_book_type_code;
1180 p6_a22 := ddx_sypv_rec.asst_add_book_type_code;
1181 p6_a23 := rosetta_g_miss_num_map(ddx_sypv_rec.ccard_remittance_id);
1182 p6_a24 := ddx_sypv_rec.corporate_book;
1183 p6_a25 := ddx_sypv_rec.tax_book_1;
1184 p6_a26 := ddx_sypv_rec.tax_book_2;
1185 p6_a27 := ddx_sypv_rec.depreciate_yn;
1186 p6_a28 := rosetta_g_miss_num_map(ddx_sypv_rec.fa_location_id);
1187 p6_a29 := rosetta_g_miss_num_map(ddx_sypv_rec.formula_id);
1188 p6_a30 := rosetta_g_miss_num_map(ddx_sypv_rec.asset_key_id);
1189 p6_a31 := ddx_sypv_rec.part_trmnt_apply_round_diff;
1190 p6_a32 := rosetta_g_miss_num_map(ddx_sypv_rec.object_version_number);
1191 p6_a33 := rosetta_g_miss_num_map(ddx_sypv_rec.org_id);
1192 p6_a34 := rosetta_g_miss_num_map(ddx_sypv_rec.request_id);
1193 p6_a35 := rosetta_g_miss_num_map(ddx_sypv_rec.program_application_id);
1194 p6_a36 := rosetta_g_miss_num_map(ddx_sypv_rec.program_id);
1195 p6_a37 := ddx_sypv_rec.program_update_date;
1196 p6_a38 := ddx_sypv_rec.attribute_category;
1197 p6_a39 := ddx_sypv_rec.attribute1;
1198 p6_a40 := ddx_sypv_rec.attribute2;
1199 p6_a41 := ddx_sypv_rec.attribute3;
1200 p6_a42 := ddx_sypv_rec.attribute4;
1201 p6_a43 := ddx_sypv_rec.attribute5;
1202 p6_a44 := ddx_sypv_rec.attribute6;
1203 p6_a45 := ddx_sypv_rec.attribute7;
1204 p6_a46 := ddx_sypv_rec.attribute8;
1205 p6_a47 := ddx_sypv_rec.attribute9;
1206 p6_a48 := ddx_sypv_rec.attribute10;
1207 p6_a49 := ddx_sypv_rec.attribute11;
1208 p6_a50 := ddx_sypv_rec.attribute12;
1209 p6_a51 := ddx_sypv_rec.attribute13;
1210 p6_a52 := ddx_sypv_rec.attribute14;
1211 p6_a53 := ddx_sypv_rec.attribute15;
1212 p6_a54 := rosetta_g_miss_num_map(ddx_sypv_rec.created_by);
1213 p6_a55 := ddx_sypv_rec.creation_date;
1214 p6_a56 := rosetta_g_miss_num_map(ddx_sypv_rec.last_updated_by);
1215 p6_a57 := ddx_sypv_rec.last_update_date;
1216 p6_a58 := rosetta_g_miss_num_map(ddx_sypv_rec.last_update_login);
1217 p6_a59 := ddx_sypv_rec.lseapp_seq_prefix_txt;
1218 p6_a60 := ddx_sypv_rec.lseopp_seq_prefix_txt;
1219 p6_a61 := ddx_sypv_rec.qckqte_seq_prefix_txt;
1220 p6_a62 := ddx_sypv_rec.lseqte_seq_prefix_txt;
1221 end;
1222
1223 procedure update_system_parameters(p_api_version NUMBER
1224 , p_init_msg_list VARCHAR2
1225 , x_return_status out nocopy VARCHAR2
1226 , x_msg_count out nocopy NUMBER
1227 , x_msg_data out nocopy VARCHAR2
1228 , p5_a0 JTF_NUMBER_TABLE
1229 , p5_a1 JTF_VARCHAR2_TABLE_100
1230 , p5_a2 JTF_VARCHAR2_TABLE_100
1231 , p5_a3 JTF_NUMBER_TABLE
1232 , p5_a4 JTF_NUMBER_TABLE
1233 , p5_a5 JTF_VARCHAR2_TABLE_100
1234 , p5_a6 JTF_NUMBER_TABLE
1235 , p5_a7 JTF_VARCHAR2_TABLE_100
1236 , p5_a8 JTF_VARCHAR2_TABLE_100
1237 , p5_a9 JTF_VARCHAR2_TABLE_100
1238 , p5_a10 JTF_VARCHAR2_TABLE_100
1239 , p5_a11 JTF_VARCHAR2_TABLE_100
1240 , p5_a12 JTF_NUMBER_TABLE
1241 , p5_a13 JTF_NUMBER_TABLE
1242 , p5_a14 JTF_NUMBER_TABLE
1243 , p5_a15 JTF_VARCHAR2_TABLE_100
1244 , p5_a16 JTF_VARCHAR2_TABLE_100
1245 , p5_a17 JTF_NUMBER_TABLE
1246 , p5_a18 JTF_VARCHAR2_TABLE_100
1247 , p5_a19 JTF_NUMBER_TABLE
1248 , p5_a20 JTF_NUMBER_TABLE
1249 , p5_a21 JTF_VARCHAR2_TABLE_100
1250 , p5_a22 JTF_VARCHAR2_TABLE_100
1251 , p5_a23 JTF_NUMBER_TABLE
1252 , p5_a24 JTF_VARCHAR2_TABLE_100
1253 , p5_a25 JTF_VARCHAR2_TABLE_100
1254 , p5_a26 JTF_VARCHAR2_TABLE_100
1255 , p5_a27 JTF_VARCHAR2_TABLE_100
1256 , p5_a28 JTF_NUMBER_TABLE
1257 , p5_a29 JTF_NUMBER_TABLE
1258 , p5_a30 JTF_NUMBER_TABLE
1259 , p5_a31 JTF_VARCHAR2_TABLE_100
1260 , p5_a32 JTF_NUMBER_TABLE
1261 , p5_a33 JTF_NUMBER_TABLE
1262 , p5_a34 JTF_NUMBER_TABLE
1263 , p5_a35 JTF_NUMBER_TABLE
1264 , p5_a36 JTF_NUMBER_TABLE
1265 , p5_a37 JTF_DATE_TABLE
1266 , p5_a38 JTF_VARCHAR2_TABLE_100
1267 , p5_a39 JTF_VARCHAR2_TABLE_500
1268 , p5_a40 JTF_VARCHAR2_TABLE_500
1269 , p5_a41 JTF_VARCHAR2_TABLE_500
1270 , p5_a42 JTF_VARCHAR2_TABLE_500
1271 , p5_a43 JTF_VARCHAR2_TABLE_500
1272 , p5_a44 JTF_VARCHAR2_TABLE_500
1273 , p5_a45 JTF_VARCHAR2_TABLE_500
1274 , p5_a46 JTF_VARCHAR2_TABLE_500
1275 , p5_a47 JTF_VARCHAR2_TABLE_500
1276 , p5_a48 JTF_VARCHAR2_TABLE_500
1277 , p5_a49 JTF_VARCHAR2_TABLE_500
1278 , p5_a50 JTF_VARCHAR2_TABLE_500
1279 , p5_a51 JTF_VARCHAR2_TABLE_500
1280 , p5_a52 JTF_VARCHAR2_TABLE_500
1281 , p5_a53 JTF_VARCHAR2_TABLE_500
1282 , p5_a54 JTF_NUMBER_TABLE
1283 , p5_a55 JTF_DATE_TABLE
1284 , p5_a56 JTF_NUMBER_TABLE
1285 , p5_a57 JTF_DATE_TABLE
1286 , p5_a58 JTF_NUMBER_TABLE
1287 , p5_a59 JTF_VARCHAR2_TABLE_200
1288 , p5_a60 JTF_VARCHAR2_TABLE_200
1289 , p5_a61 JTF_VARCHAR2_TABLE_200
1290 , p5_a62 JTF_VARCHAR2_TABLE_200
1291 , p6_a0 out nocopy JTF_NUMBER_TABLE
1292 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1293 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1294 , p6_a3 out nocopy JTF_NUMBER_TABLE
1295 , p6_a4 out nocopy JTF_NUMBER_TABLE
1296 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1297 , p6_a6 out nocopy JTF_NUMBER_TABLE
1298 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1299 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1300 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1301 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1302 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1303 , p6_a12 out nocopy JTF_NUMBER_TABLE
1304 , p6_a13 out nocopy JTF_NUMBER_TABLE
1305 , p6_a14 out nocopy JTF_NUMBER_TABLE
1306 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1307 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1308 , p6_a17 out nocopy JTF_NUMBER_TABLE
1309 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1310 , p6_a19 out nocopy JTF_NUMBER_TABLE
1311 , p6_a20 out nocopy JTF_NUMBER_TABLE
1312 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1313 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1314 , p6_a23 out nocopy JTF_NUMBER_TABLE
1315 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
1316 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1317 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1318 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
1319 , p6_a28 out nocopy JTF_NUMBER_TABLE
1320 , p6_a29 out nocopy JTF_NUMBER_TABLE
1321 , p6_a30 out nocopy JTF_NUMBER_TABLE
1322 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1323 , p6_a32 out nocopy JTF_NUMBER_TABLE
1324 , p6_a33 out nocopy JTF_NUMBER_TABLE
1325 , p6_a34 out nocopy JTF_NUMBER_TABLE
1326 , p6_a35 out nocopy JTF_NUMBER_TABLE
1327 , p6_a36 out nocopy JTF_NUMBER_TABLE
1328 , p6_a37 out nocopy JTF_DATE_TABLE
1329 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1330 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1331 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1332 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1333 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1334 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1335 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1336 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1337 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1338 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1339 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
1340 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
1341 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
1342 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
1343 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
1344 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
1345 , p6_a54 out nocopy JTF_NUMBER_TABLE
1346 , p6_a55 out nocopy JTF_DATE_TABLE
1347 , p6_a56 out nocopy JTF_NUMBER_TABLE
1348 , p6_a57 out nocopy JTF_DATE_TABLE
1349 , p6_a58 out nocopy JTF_NUMBER_TABLE
1350 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
1351 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_200
1352 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_200
1353 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_200
1354 )
1355
1356 as
1357 ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
1358 ddx_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
1359 ddindx binary_integer; indx binary_integer;
1360 begin
1361
1362 -- copy data to the local IN or IN-OUT args, if any
1363
1364
1365
1366
1367
1368 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
1369 , p5_a1
1370 , p5_a2
1371 , p5_a3
1372 , p5_a4
1373 , p5_a5
1374 , p5_a6
1375 , p5_a7
1376 , p5_a8
1377 , p5_a9
1378 , p5_a10
1379 , p5_a11
1380 , p5_a12
1381 , p5_a13
1382 , p5_a14
1383 , p5_a15
1384 , p5_a16
1385 , p5_a17
1386 , p5_a18
1387 , p5_a19
1388 , p5_a20
1389 , p5_a21
1390 , p5_a22
1391 , p5_a23
1392 , p5_a24
1393 , p5_a25
1394 , p5_a26
1395 , p5_a27
1396 , p5_a28
1397 , p5_a29
1398 , p5_a30
1399 , p5_a31
1400 , p5_a32
1401 , p5_a33
1402 , p5_a34
1403 , p5_a35
1404 , p5_a36
1405 , p5_a37
1406 , p5_a38
1407 , p5_a39
1408 , p5_a40
1409 , p5_a41
1410 , p5_a42
1411 , p5_a43
1412 , p5_a44
1413 , p5_a45
1414 , p5_a46
1415 , p5_a47
1416 , p5_a48
1417 , p5_a49
1418 , p5_a50
1419 , p5_a51
1420 , p5_a52
1421 , p5_a53
1422 , p5_a54
1423 , p5_a55
1424 , p5_a56
1425 , p5_a57
1426 , p5_a58
1427 , p5_a59
1428 , p5_a60
1429 , p5_a61
1430 , p5_a62
1431 );
1432
1433
1434 -- here's the delegated call to the old PL/SQL routine
1435 okl_system_params_all_pub.update_system_parameters(p_api_version,
1436 p_init_msg_list,
1437 x_return_status,
1438 x_msg_count,
1439 x_msg_data,
1440 ddp_sypv_tbl,
1441 ddx_sypv_tbl);
1442
1443 -- copy data back from the local variables to OUT or IN-OUT args, if any
1444
1445
1446
1447
1448
1449
1450 okl_syp_pvt_w.rosetta_table_copy_out_p2(ddx_sypv_tbl, p6_a0
1451 , p6_a1
1452 , p6_a2
1453 , p6_a3
1454 , p6_a4
1455 , p6_a5
1456 , p6_a6
1457 , p6_a7
1458 , p6_a8
1459 , p6_a9
1460 , p6_a10
1461 , p6_a11
1462 , p6_a12
1463 , p6_a13
1464 , p6_a14
1465 , p6_a15
1466 , p6_a16
1467 , p6_a17
1468 , p6_a18
1469 , p6_a19
1470 , p6_a20
1471 , p6_a21
1472 , p6_a22
1473 , p6_a23
1474 , p6_a24
1475 , p6_a25
1476 , p6_a26
1477 , p6_a27
1478 , p6_a28
1479 , p6_a29
1480 , p6_a30
1481 , p6_a31
1482 , p6_a32
1483 , p6_a33
1484 , p6_a34
1485 , p6_a35
1486 , p6_a36
1487 , p6_a37
1488 , p6_a38
1489 , p6_a39
1490 , p6_a40
1491 , p6_a41
1492 , p6_a42
1493 , p6_a43
1494 , p6_a44
1495 , p6_a45
1496 , p6_a46
1497 , p6_a47
1498 , p6_a48
1499 , p6_a49
1500 , p6_a50
1501 , p6_a51
1502 , p6_a52
1503 , p6_a53
1504 , p6_a54
1505 , p6_a55
1506 , p6_a56
1507 , p6_a57
1508 , p6_a58
1509 , p6_a59
1510 , p6_a60
1511 , p6_a61
1512 , p6_a62
1513 );
1514 end;
1515
1516 procedure delete_system_parameters(p_api_version NUMBER
1517 , p_init_msg_list VARCHAR2
1518 , x_return_status out nocopy VARCHAR2
1519 , x_msg_count out nocopy NUMBER
1520 , x_msg_data out nocopy VARCHAR2
1521 , p5_a0 NUMBER := 0-1962.0724
1522 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1523 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1524 , p5_a3 NUMBER := 0-1962.0724
1525 , p5_a4 NUMBER := 0-1962.0724
1526 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1527 , p5_a6 NUMBER := 0-1962.0724
1528 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1529 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1530 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1531 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1532 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1533 , p5_a12 NUMBER := 0-1962.0724
1534 , p5_a13 NUMBER := 0-1962.0724
1535 , p5_a14 NUMBER := 0-1962.0724
1536 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1537 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1538 , p5_a17 NUMBER := 0-1962.0724
1539 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1540 , p5_a19 NUMBER := 0-1962.0724
1541 , p5_a20 NUMBER := 0-1962.0724
1542 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1543 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1544 , p5_a23 NUMBER := 0-1962.0724
1545 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1546 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1547 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1548 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1549 , p5_a28 NUMBER := 0-1962.0724
1550 , p5_a29 NUMBER := 0-1962.0724
1551 , p5_a30 NUMBER := 0-1962.0724
1552 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1553 , p5_a32 NUMBER := 0-1962.0724
1554 , p5_a33 NUMBER := 0-1962.0724
1555 , p5_a34 NUMBER := 0-1962.0724
1556 , p5_a35 NUMBER := 0-1962.0724
1557 , p5_a36 NUMBER := 0-1962.0724
1558 , p5_a37 DATE := fnd_api.g_miss_date
1559 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1560 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1561 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1562 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1563 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1564 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1565 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1566 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1567 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1568 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1569 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1570 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1571 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1572 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1573 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1574 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1575 , p5_a54 NUMBER := 0-1962.0724
1576 , p5_a55 DATE := fnd_api.g_miss_date
1577 , p5_a56 NUMBER := 0-1962.0724
1578 , p5_a57 DATE := fnd_api.g_miss_date
1579 , p5_a58 NUMBER := 0-1962.0724
1580 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1581 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1582 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1583 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1584 )
1585
1586 as
1587 ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1588 ddindx binary_integer; indx binary_integer;
1589 begin
1590
1591 -- copy data to the local IN or IN-OUT args, if any
1592
1593
1594
1595
1596
1597 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
1598 ddp_sypv_rec.delink_yn := p5_a1;
1599 ddp_sypv_rec.remk_subinventory := p5_a2;
1600 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
1601 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
1602 ddp_sypv_rec.remk_process_code := p5_a5;
1603 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
1604 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
1605 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
1606 ddp_sypv_rec.tax_upfront_yn := p5_a9;
1607 ddp_sypv_rec.tax_invoice_yn := p5_a10;
1608 ddp_sypv_rec.tax_schedule_yn := p5_a11;
1609 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
1610 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
1611 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
1612 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
1613 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
1614 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
1615 ddp_sypv_rec.owner_type_code := p5_a18;
1616 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
1617 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
1618 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
1619 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
1620 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
1621 ddp_sypv_rec.corporate_book := p5_a24;
1622 ddp_sypv_rec.tax_book_1 := p5_a25;
1623 ddp_sypv_rec.tax_book_2 := p5_a26;
1624 ddp_sypv_rec.depreciate_yn := p5_a27;
1625 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
1626 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
1627 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
1628 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
1629 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
1630 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
1631 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
1632 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
1633 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
1634 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
1635 ddp_sypv_rec.attribute_category := p5_a38;
1636 ddp_sypv_rec.attribute1 := p5_a39;
1637 ddp_sypv_rec.attribute2 := p5_a40;
1638 ddp_sypv_rec.attribute3 := p5_a41;
1639 ddp_sypv_rec.attribute4 := p5_a42;
1640 ddp_sypv_rec.attribute5 := p5_a43;
1641 ddp_sypv_rec.attribute6 := p5_a44;
1642 ddp_sypv_rec.attribute7 := p5_a45;
1643 ddp_sypv_rec.attribute8 := p5_a46;
1644 ddp_sypv_rec.attribute9 := p5_a47;
1645 ddp_sypv_rec.attribute10 := p5_a48;
1646 ddp_sypv_rec.attribute11 := p5_a49;
1647 ddp_sypv_rec.attribute12 := p5_a50;
1648 ddp_sypv_rec.attribute13 := p5_a51;
1649 ddp_sypv_rec.attribute14 := p5_a52;
1650 ddp_sypv_rec.attribute15 := p5_a53;
1651 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1652 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
1653 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
1654 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1655 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1656 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
1657 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
1658 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
1659 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
1660
1661 -- here's the delegated call to the old PL/SQL routine
1662 okl_system_params_all_pub.delete_system_parameters(p_api_version,
1663 p_init_msg_list,
1664 x_return_status,
1665 x_msg_count,
1666 x_msg_data,
1667 ddp_sypv_rec);
1668
1669 -- copy data back from the local variables to OUT or IN-OUT args, if any
1670
1671
1672
1673
1674
1675 end;
1676
1677 procedure delete_system_parameters(p_api_version NUMBER
1678 , p_init_msg_list VARCHAR2
1679 , x_return_status out nocopy VARCHAR2
1680 , x_msg_count out nocopy NUMBER
1681 , x_msg_data out nocopy VARCHAR2
1682 , p5_a0 JTF_NUMBER_TABLE
1683 , p5_a1 JTF_VARCHAR2_TABLE_100
1684 , p5_a2 JTF_VARCHAR2_TABLE_100
1685 , p5_a3 JTF_NUMBER_TABLE
1686 , p5_a4 JTF_NUMBER_TABLE
1687 , p5_a5 JTF_VARCHAR2_TABLE_100
1688 , p5_a6 JTF_NUMBER_TABLE
1689 , p5_a7 JTF_VARCHAR2_TABLE_100
1690 , p5_a8 JTF_VARCHAR2_TABLE_100
1691 , p5_a9 JTF_VARCHAR2_TABLE_100
1692 , p5_a10 JTF_VARCHAR2_TABLE_100
1693 , p5_a11 JTF_VARCHAR2_TABLE_100
1694 , p5_a12 JTF_NUMBER_TABLE
1695 , p5_a13 JTF_NUMBER_TABLE
1696 , p5_a14 JTF_NUMBER_TABLE
1697 , p5_a15 JTF_VARCHAR2_TABLE_100
1698 , p5_a16 JTF_VARCHAR2_TABLE_100
1699 , p5_a17 JTF_NUMBER_TABLE
1700 , p5_a18 JTF_VARCHAR2_TABLE_100
1701 , p5_a19 JTF_NUMBER_TABLE
1702 , p5_a20 JTF_NUMBER_TABLE
1703 , p5_a21 JTF_VARCHAR2_TABLE_100
1704 , p5_a22 JTF_VARCHAR2_TABLE_100
1705 , p5_a23 JTF_NUMBER_TABLE
1706 , p5_a24 JTF_VARCHAR2_TABLE_100
1707 , p5_a25 JTF_VARCHAR2_TABLE_100
1708 , p5_a26 JTF_VARCHAR2_TABLE_100
1709 , p5_a27 JTF_VARCHAR2_TABLE_100
1710 , p5_a28 JTF_NUMBER_TABLE
1711 , p5_a29 JTF_NUMBER_TABLE
1712 , p5_a30 JTF_NUMBER_TABLE
1713 , p5_a31 JTF_VARCHAR2_TABLE_100
1714 , p5_a32 JTF_NUMBER_TABLE
1715 , p5_a33 JTF_NUMBER_TABLE
1716 , p5_a34 JTF_NUMBER_TABLE
1717 , p5_a35 JTF_NUMBER_TABLE
1718 , p5_a36 JTF_NUMBER_TABLE
1719 , p5_a37 JTF_DATE_TABLE
1720 , p5_a38 JTF_VARCHAR2_TABLE_100
1721 , p5_a39 JTF_VARCHAR2_TABLE_500
1722 , p5_a40 JTF_VARCHAR2_TABLE_500
1723 , p5_a41 JTF_VARCHAR2_TABLE_500
1724 , p5_a42 JTF_VARCHAR2_TABLE_500
1725 , p5_a43 JTF_VARCHAR2_TABLE_500
1726 , p5_a44 JTF_VARCHAR2_TABLE_500
1727 , p5_a45 JTF_VARCHAR2_TABLE_500
1728 , p5_a46 JTF_VARCHAR2_TABLE_500
1729 , p5_a47 JTF_VARCHAR2_TABLE_500
1730 , p5_a48 JTF_VARCHAR2_TABLE_500
1731 , p5_a49 JTF_VARCHAR2_TABLE_500
1732 , p5_a50 JTF_VARCHAR2_TABLE_500
1733 , p5_a51 JTF_VARCHAR2_TABLE_500
1734 , p5_a52 JTF_VARCHAR2_TABLE_500
1735 , p5_a53 JTF_VARCHAR2_TABLE_500
1736 , p5_a54 JTF_NUMBER_TABLE
1737 , p5_a55 JTF_DATE_TABLE
1738 , p5_a56 JTF_NUMBER_TABLE
1739 , p5_a57 JTF_DATE_TABLE
1740 , p5_a58 JTF_NUMBER_TABLE
1741 , p5_a59 JTF_VARCHAR2_TABLE_200
1742 , p5_a60 JTF_VARCHAR2_TABLE_200
1743 , p5_a61 JTF_VARCHAR2_TABLE_200
1744 , p5_a62 JTF_VARCHAR2_TABLE_200
1745 )
1746
1747 as
1748 ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
1749 ddindx binary_integer; indx binary_integer;
1750 begin
1751
1752 -- copy data to the local IN or IN-OUT args, if any
1753
1754
1755
1756
1757
1758 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
1759 , p5_a1
1760 , p5_a2
1761 , p5_a3
1762 , p5_a4
1763 , p5_a5
1764 , p5_a6
1765 , p5_a7
1766 , p5_a8
1767 , p5_a9
1768 , p5_a10
1769 , p5_a11
1770 , p5_a12
1771 , p5_a13
1772 , p5_a14
1773 , p5_a15
1774 , p5_a16
1775 , p5_a17
1776 , p5_a18
1777 , p5_a19
1778 , p5_a20
1779 , p5_a21
1780 , p5_a22
1781 , p5_a23
1782 , p5_a24
1783 , p5_a25
1784 , p5_a26
1785 , p5_a27
1786 , p5_a28
1787 , p5_a29
1788 , p5_a30
1789 , p5_a31
1790 , p5_a32
1791 , p5_a33
1792 , p5_a34
1793 , p5_a35
1794 , p5_a36
1795 , p5_a37
1796 , p5_a38
1797 , p5_a39
1798 , p5_a40
1799 , p5_a41
1800 , p5_a42
1801 , p5_a43
1802 , p5_a44
1803 , p5_a45
1804 , p5_a46
1805 , p5_a47
1806 , p5_a48
1807 , p5_a49
1808 , p5_a50
1809 , p5_a51
1810 , p5_a52
1811 , p5_a53
1812 , p5_a54
1813 , p5_a55
1814 , p5_a56
1815 , p5_a57
1816 , p5_a58
1817 , p5_a59
1818 , p5_a60
1819 , p5_a61
1820 , p5_a62
1821 );
1822
1823 -- here's the delegated call to the old PL/SQL routine
1824 okl_system_params_all_pub.delete_system_parameters(p_api_version,
1825 p_init_msg_list,
1826 x_return_status,
1827 x_msg_count,
1828 x_msg_data,
1829 ddp_sypv_tbl);
1830
1831 -- copy data back from the local variables to OUT or IN-OUT args, if any
1832
1833
1834
1835
1836
1837 end;
1838
1839 procedure validate_system_parameters(p_api_version NUMBER
1840 , p_init_msg_list VARCHAR2
1841 , x_return_status out nocopy VARCHAR2
1842 , x_msg_count out nocopy NUMBER
1843 , x_msg_data out nocopy VARCHAR2
1844 , p5_a0 NUMBER := 0-1962.0724
1845 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1846 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1847 , p5_a3 NUMBER := 0-1962.0724
1848 , p5_a4 NUMBER := 0-1962.0724
1849 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1850 , p5_a6 NUMBER := 0-1962.0724
1851 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1852 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1853 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1854 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1855 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1856 , p5_a12 NUMBER := 0-1962.0724
1857 , p5_a13 NUMBER := 0-1962.0724
1858 , p5_a14 NUMBER := 0-1962.0724
1859 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1860 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1861 , p5_a17 NUMBER := 0-1962.0724
1862 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1863 , p5_a19 NUMBER := 0-1962.0724
1864 , p5_a20 NUMBER := 0-1962.0724
1865 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1866 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1867 , p5_a23 NUMBER := 0-1962.0724
1868 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1869 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1870 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1871 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1872 , p5_a28 NUMBER := 0-1962.0724
1873 , p5_a29 NUMBER := 0-1962.0724
1874 , p5_a30 NUMBER := 0-1962.0724
1875 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1876 , p5_a32 NUMBER := 0-1962.0724
1877 , p5_a33 NUMBER := 0-1962.0724
1878 , p5_a34 NUMBER := 0-1962.0724
1879 , p5_a35 NUMBER := 0-1962.0724
1880 , p5_a36 NUMBER := 0-1962.0724
1881 , p5_a37 DATE := fnd_api.g_miss_date
1882 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1883 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1884 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1885 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1886 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1887 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1888 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1889 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1890 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1891 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1892 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1893 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1894 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1895 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1896 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1897 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1898 , p5_a54 NUMBER := 0-1962.0724
1899 , p5_a55 DATE := fnd_api.g_miss_date
1900 , p5_a56 NUMBER := 0-1962.0724
1901 , p5_a57 DATE := fnd_api.g_miss_date
1902 , p5_a58 NUMBER := 0-1962.0724
1903 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1904 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1905 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1906 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1907 )
1908
1909 as
1910 ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1911 ddindx binary_integer; indx binary_integer;
1912 begin
1913
1914 -- copy data to the local IN or IN-OUT args, if any
1915
1916
1917
1918
1919
1920 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
1921 ddp_sypv_rec.delink_yn := p5_a1;
1922 ddp_sypv_rec.remk_subinventory := p5_a2;
1923 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
1924 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
1925 ddp_sypv_rec.remk_process_code := p5_a5;
1926 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
1927 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
1928 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
1929 ddp_sypv_rec.tax_upfront_yn := p5_a9;
1930 ddp_sypv_rec.tax_invoice_yn := p5_a10;
1931 ddp_sypv_rec.tax_schedule_yn := p5_a11;
1932 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
1933 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
1934 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
1935 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
1936 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
1937 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
1938 ddp_sypv_rec.owner_type_code := p5_a18;
1939 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
1940 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
1941 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
1942 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
1943 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
1944 ddp_sypv_rec.corporate_book := p5_a24;
1945 ddp_sypv_rec.tax_book_1 := p5_a25;
1946 ddp_sypv_rec.tax_book_2 := p5_a26;
1947 ddp_sypv_rec.depreciate_yn := p5_a27;
1948 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
1949 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
1950 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
1951 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
1952 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
1953 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
1954 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
1955 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
1956 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
1957 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
1958 ddp_sypv_rec.attribute_category := p5_a38;
1959 ddp_sypv_rec.attribute1 := p5_a39;
1960 ddp_sypv_rec.attribute2 := p5_a40;
1961 ddp_sypv_rec.attribute3 := p5_a41;
1962 ddp_sypv_rec.attribute4 := p5_a42;
1963 ddp_sypv_rec.attribute5 := p5_a43;
1964 ddp_sypv_rec.attribute6 := p5_a44;
1965 ddp_sypv_rec.attribute7 := p5_a45;
1966 ddp_sypv_rec.attribute8 := p5_a46;
1967 ddp_sypv_rec.attribute9 := p5_a47;
1968 ddp_sypv_rec.attribute10 := p5_a48;
1969 ddp_sypv_rec.attribute11 := p5_a49;
1970 ddp_sypv_rec.attribute12 := p5_a50;
1971 ddp_sypv_rec.attribute13 := p5_a51;
1972 ddp_sypv_rec.attribute14 := p5_a52;
1973 ddp_sypv_rec.attribute15 := p5_a53;
1974 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1975 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
1976 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
1977 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1978 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1979 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
1980 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
1981 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
1982 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
1983
1984 -- here's the delegated call to the old PL/SQL routine
1985 okl_system_params_all_pub.validate_system_parameters(p_api_version,
1986 p_init_msg_list,
1987 x_return_status,
1988 x_msg_count,
1989 x_msg_data,
1990 ddp_sypv_rec);
1991
1992 -- copy data back from the local variables to OUT or IN-OUT args, if any
1993
1994
1995
1996
1997
1998 end;
1999
2000 procedure validate_system_parameters(p_api_version NUMBER
2001 , p_init_msg_list VARCHAR2
2002 , x_return_status out nocopy VARCHAR2
2003 , x_msg_count out nocopy NUMBER
2004 , x_msg_data out nocopy VARCHAR2
2005 , p5_a0 JTF_NUMBER_TABLE
2006 , p5_a1 JTF_VARCHAR2_TABLE_100
2007 , p5_a2 JTF_VARCHAR2_TABLE_100
2008 , p5_a3 JTF_NUMBER_TABLE
2009 , p5_a4 JTF_NUMBER_TABLE
2010 , p5_a5 JTF_VARCHAR2_TABLE_100
2011 , p5_a6 JTF_NUMBER_TABLE
2012 , p5_a7 JTF_VARCHAR2_TABLE_100
2013 , p5_a8 JTF_VARCHAR2_TABLE_100
2014 , p5_a9 JTF_VARCHAR2_TABLE_100
2015 , p5_a10 JTF_VARCHAR2_TABLE_100
2016 , p5_a11 JTF_VARCHAR2_TABLE_100
2017 , p5_a12 JTF_NUMBER_TABLE
2018 , p5_a13 JTF_NUMBER_TABLE
2019 , p5_a14 JTF_NUMBER_TABLE
2020 , p5_a15 JTF_VARCHAR2_TABLE_100
2021 , p5_a16 JTF_VARCHAR2_TABLE_100
2022 , p5_a17 JTF_NUMBER_TABLE
2023 , p5_a18 JTF_VARCHAR2_TABLE_100
2024 , p5_a19 JTF_NUMBER_TABLE
2025 , p5_a20 JTF_NUMBER_TABLE
2026 , p5_a21 JTF_VARCHAR2_TABLE_100
2027 , p5_a22 JTF_VARCHAR2_TABLE_100
2028 , p5_a23 JTF_NUMBER_TABLE
2029 , p5_a24 JTF_VARCHAR2_TABLE_100
2030 , p5_a25 JTF_VARCHAR2_TABLE_100
2031 , p5_a26 JTF_VARCHAR2_TABLE_100
2032 , p5_a27 JTF_VARCHAR2_TABLE_100
2033 , p5_a28 JTF_NUMBER_TABLE
2034 , p5_a29 JTF_NUMBER_TABLE
2035 , p5_a30 JTF_NUMBER_TABLE
2036 , p5_a31 JTF_VARCHAR2_TABLE_100
2037 , p5_a32 JTF_NUMBER_TABLE
2038 , p5_a33 JTF_NUMBER_TABLE
2039 , p5_a34 JTF_NUMBER_TABLE
2040 , p5_a35 JTF_NUMBER_TABLE
2041 , p5_a36 JTF_NUMBER_TABLE
2042 , p5_a37 JTF_DATE_TABLE
2043 , p5_a38 JTF_VARCHAR2_TABLE_100
2044 , p5_a39 JTF_VARCHAR2_TABLE_500
2045 , p5_a40 JTF_VARCHAR2_TABLE_500
2046 , p5_a41 JTF_VARCHAR2_TABLE_500
2047 , p5_a42 JTF_VARCHAR2_TABLE_500
2048 , p5_a43 JTF_VARCHAR2_TABLE_500
2049 , p5_a44 JTF_VARCHAR2_TABLE_500
2050 , p5_a45 JTF_VARCHAR2_TABLE_500
2051 , p5_a46 JTF_VARCHAR2_TABLE_500
2052 , p5_a47 JTF_VARCHAR2_TABLE_500
2053 , p5_a48 JTF_VARCHAR2_TABLE_500
2054 , p5_a49 JTF_VARCHAR2_TABLE_500
2055 , p5_a50 JTF_VARCHAR2_TABLE_500
2056 , p5_a51 JTF_VARCHAR2_TABLE_500
2057 , p5_a52 JTF_VARCHAR2_TABLE_500
2058 , p5_a53 JTF_VARCHAR2_TABLE_500
2059 , p5_a54 JTF_NUMBER_TABLE
2060 , p5_a55 JTF_DATE_TABLE
2061 , p5_a56 JTF_NUMBER_TABLE
2062 , p5_a57 JTF_DATE_TABLE
2063 , p5_a58 JTF_NUMBER_TABLE
2064 , p5_a59 JTF_VARCHAR2_TABLE_200
2065 , p5_a60 JTF_VARCHAR2_TABLE_200
2066 , p5_a61 JTF_VARCHAR2_TABLE_200
2067 , p5_a62 JTF_VARCHAR2_TABLE_200
2068 )
2069
2070 as
2071 ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
2072 ddindx binary_integer; indx binary_integer;
2073 begin
2074
2075 -- copy data to the local IN or IN-OUT args, if any
2076
2077
2078
2079
2080
2081 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
2082 , p5_a1
2083 , p5_a2
2084 , p5_a3
2085 , p5_a4
2086 , p5_a5
2087 , p5_a6
2088 , p5_a7
2089 , p5_a8
2090 , p5_a9
2091 , p5_a10
2092 , p5_a11
2093 , p5_a12
2094 , p5_a13
2095 , p5_a14
2096 , p5_a15
2097 , p5_a16
2098 , p5_a17
2099 , p5_a18
2100 , p5_a19
2101 , p5_a20
2102 , p5_a21
2103 , p5_a22
2104 , p5_a23
2105 , p5_a24
2106 , p5_a25
2107 , p5_a26
2108 , p5_a27
2109 , p5_a28
2110 , p5_a29
2111 , p5_a30
2112 , p5_a31
2113 , p5_a32
2114 , p5_a33
2115 , p5_a34
2116 , p5_a35
2117 , p5_a36
2118 , p5_a37
2119 , p5_a38
2120 , p5_a39
2121 , p5_a40
2122 , p5_a41
2123 , p5_a42
2124 , p5_a43
2125 , p5_a44
2126 , p5_a45
2127 , p5_a46
2128 , p5_a47
2129 , p5_a48
2130 , p5_a49
2131 , p5_a50
2132 , p5_a51
2133 , p5_a52
2134 , p5_a53
2135 , p5_a54
2136 , p5_a55
2137 , p5_a56
2138 , p5_a57
2139 , p5_a58
2140 , p5_a59
2141 , p5_a60
2142 , p5_a61
2143 , p5_a62
2144 );
2145
2146 -- here's the delegated call to the old PL/SQL routine
2147 okl_system_params_all_pub.validate_system_parameters(p_api_version,
2148 p_init_msg_list,
2149 x_return_status,
2150 x_msg_count,
2151 x_msg_data,
2152 ddp_sypv_tbl);
2153
2154 -- copy data back from the local variables to OUT or IN-OUT args, if any
2155
2156
2157
2158
2159
2160 end;
2161
2162 end okl_system_params_all_pub_w;