[Home] [Help]
PACKAGE BODY: APPS.OZF_SYS_PARAMETERS_PVT_W
Source
1 package body ozf_sys_parameters_pvt_w as
2 /* $Header: ozfwsysb.pls 120.9 2012/01/03 17:16:57 nirprasa 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 procedure create_sys_parameters(p_api_version NUMBER
17 , p_init_msg_list VARCHAR2
18 , p_commit VARCHAR2
19 , p_validation_level NUMBER
20 , x_return_status out nocopy VARCHAR2
21 , x_msg_count out nocopy NUMBER
22 , x_msg_data out nocopy VARCHAR2
23 , p7_a0 NUMBER
24 , p7_a1 NUMBER
25 , p7_a2 DATE
26 , p7_a3 NUMBER
27 , p7_a4 DATE
28 , p7_a5 NUMBER
29 , p7_a6 NUMBER
30 , p7_a7 NUMBER
31 , p7_a8 NUMBER
32 , p7_a9 DATE
33 , p7_a10 NUMBER
34 , p7_a11 VARCHAR2
35 , p7_a12 VARCHAR2
36 , p7_a13 VARCHAR2
37 , p7_a14 NUMBER
38 , p7_a15 VARCHAR2
39 , p7_a16 NUMBER
40 , p7_a17 NUMBER
41 , p7_a18 NUMBER
42 , p7_a19 NUMBER
43 , p7_a20 NUMBER
44 , p7_a21 NUMBER
45 , p7_a22 NUMBER
46 , p7_a23 NUMBER
47 , p7_a24 NUMBER
48 , p7_a25 NUMBER
49 , p7_a26 VARCHAR2
50 , p7_a27 NUMBER
51 , p7_a28 NUMBER
52 , p7_a29 NUMBER
53 , p7_a30 NUMBER
54 , p7_a31 NUMBER
55 , p7_a32 VARCHAR2
56 , p7_a33 NUMBER
57 , p7_a34 VARCHAR2
58 , p7_a35 VARCHAR2
59 , p7_a36 NUMBER
60 , p7_a37 NUMBER
61 , p7_a38 VARCHAR2
62 , p7_a39 VARCHAR2
63 , p7_a40 VARCHAR2
64 , p7_a41 VARCHAR2
65 , p7_a42 VARCHAR2
66 , p7_a43 VARCHAR2
67 , p7_a44 VARCHAR2
68 , p7_a45 VARCHAR2
69 , p7_a46 VARCHAR2
70 , p7_a47 VARCHAR2
71 , p7_a48 VARCHAR2
72 , p7_a49 VARCHAR2
73 , p7_a50 VARCHAR2
74 , p7_a51 VARCHAR2
75 , p7_a52 VARCHAR2
76 , p7_a53 VARCHAR2
77 , p7_a54 NUMBER
78 , p7_a55 NUMBER
79 , p7_a56 VARCHAR2
80 , p7_a57 NUMBER
81 , p7_a58 VARCHAR2
82 , p7_a59 VARCHAR2
83 , p7_a60 NUMBER
84 , p7_a61 VARCHAR2
85 , p7_a62 NUMBER
86 , p7_a63 NUMBER
87 , p7_a64 NUMBER
88 , p7_a65 NUMBER
89 , p7_a66 NUMBER
90 , p7_a67 NUMBER
91 , p7_a68 VARCHAR2
92 , p7_a69 VARCHAR2
93 , p7_a70 NUMBER
94 , p7_a71 VARCHAR2
95 , p7_a72 VARCHAR2
96 , p7_a73 NUMBER
97 , p7_a74 VARCHAR2
98 , p7_a75 NUMBER
99 , p7_a76 VARCHAR2
100 , p7_a77 VARCHAR2
101 , p7_a78 VARCHAR2
102 , p7_a79 VARCHAR2
103 , p7_a80 VARCHAR2
104 , p7_a81 VARCHAR2
105 , p7_a82 VARCHAR2
106 , p7_a83 VARCHAR2
107 , p7_a84 VARCHAR2
108 , p7_a85 VARCHAR2
109 , p7_a86 VARCHAR2
110 , p7_a87 VARCHAR2
111 , p7_a88 VARCHAR2
112 , p7_a89 VARCHAR2
113 , p7_a90 VARCHAR2
114 , p7_a91 NUMBER
115 , p7_a92 NUMBER
116 , p7_a93 NUMBER
117 , p7_a94 NUMBER
118 , p7_a95 VARCHAR2
119 , x_set_of_books_id out nocopy NUMBER
120 )
121
122 as
123 ddp_sys_parameters_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
124 ddindx binary_integer; indx binary_integer;
125 begin
126
127 -- copy data to the local IN or IN-OUT args, if any
128
129
130
131
132
133
134
135 ddp_sys_parameters_rec.set_of_books_id := p7_a0;
136 ddp_sys_parameters_rec.object_version_number := p7_a1;
137 ddp_sys_parameters_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
138 ddp_sys_parameters_rec.last_updated_by := p7_a3;
139 ddp_sys_parameters_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
140 ddp_sys_parameters_rec.created_by := p7_a5;
141 ddp_sys_parameters_rec.last_update_login := p7_a6;
142 ddp_sys_parameters_rec.request_id := p7_a7;
143 ddp_sys_parameters_rec.program_application_id := p7_a8;
144 ddp_sys_parameters_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
145 ddp_sys_parameters_rec.program_id := p7_a10;
146 ddp_sys_parameters_rec.created_from := p7_a11;
147 ddp_sys_parameters_rec.post_to_gl := p7_a12;
148 ddp_sys_parameters_rec.transfer_to_gl_in := p7_a13;
149 ddp_sys_parameters_rec.ap_payment_term_id := p7_a14;
150 ddp_sys_parameters_rec.rounding_level_flag := p7_a15;
151 ddp_sys_parameters_rec.gl_id_rounding := p7_a16;
152 ddp_sys_parameters_rec.gl_id_ded_clearing := p7_a17;
153 ddp_sys_parameters_rec.gl_id_ded_adj := p7_a18;
154 ddp_sys_parameters_rec.gl_id_accr_promo_liab := p7_a19;
155 ddp_sys_parameters_rec.gl_id_ded_adj_clearing := p7_a20;
156 ddp_sys_parameters_rec.gl_rec_ded_account := p7_a21;
157 ddp_sys_parameters_rec.gl_rec_clearing_account := p7_a22;
158 ddp_sys_parameters_rec.gl_cost_adjustment_acct := p7_a23;
159 ddp_sys_parameters_rec.gl_contra_liability_acct := p7_a24;
160 ddp_sys_parameters_rec.gl_pp_accrual_acct := p7_a25;
161 ddp_sys_parameters_rec.gl_date_type := p7_a26;
162 ddp_sys_parameters_rec.days_due := p7_a27;
163 ddp_sys_parameters_rec.claim_type_id := p7_a28;
164 ddp_sys_parameters_rec.reason_code_id := p7_a29;
165 ddp_sys_parameters_rec.autopay_claim_type_id := p7_a30;
166 ddp_sys_parameters_rec.autopay_reason_code_id := p7_a31;
167 ddp_sys_parameters_rec.autopay_flag := p7_a32;
168 ddp_sys_parameters_rec.autopay_periodicity := p7_a33;
169 ddp_sys_parameters_rec.autopay_periodicity_type := p7_a34;
170 ddp_sys_parameters_rec.accounting_method_option := p7_a35;
171 ddp_sys_parameters_rec.billback_trx_type_id := p7_a36;
172 ddp_sys_parameters_rec.cm_trx_type_id := p7_a37;
173 ddp_sys_parameters_rec.attribute_category := p7_a38;
174 ddp_sys_parameters_rec.attribute1 := p7_a39;
175 ddp_sys_parameters_rec.attribute2 := p7_a40;
176 ddp_sys_parameters_rec.attribute3 := p7_a41;
177 ddp_sys_parameters_rec.attribute4 := p7_a42;
178 ddp_sys_parameters_rec.attribute5 := p7_a43;
179 ddp_sys_parameters_rec.attribute6 := p7_a44;
180 ddp_sys_parameters_rec.attribute7 := p7_a45;
181 ddp_sys_parameters_rec.attribute8 := p7_a46;
182 ddp_sys_parameters_rec.attribute9 := p7_a47;
183 ddp_sys_parameters_rec.attribute10 := p7_a48;
184 ddp_sys_parameters_rec.attribute11 := p7_a49;
185 ddp_sys_parameters_rec.attribute12 := p7_a50;
186 ddp_sys_parameters_rec.attribute13 := p7_a51;
187 ddp_sys_parameters_rec.attribute14 := p7_a52;
188 ddp_sys_parameters_rec.attribute15 := p7_a53;
189 ddp_sys_parameters_rec.org_id := p7_a54;
190 ddp_sys_parameters_rec.batch_source_id := p7_a55;
191 ddp_sys_parameters_rec.payables_source := p7_a56;
192 ddp_sys_parameters_rec.default_owner_id := p7_a57;
193 ddp_sys_parameters_rec.auto_assign_flag := p7_a58;
194 ddp_sys_parameters_rec.exchange_rate_type := p7_a59;
195 ddp_sys_parameters_rec.order_type_id := p7_a60;
196 ddp_sys_parameters_rec.gl_acct_for_offinv_flag := p7_a61;
197 ddp_sys_parameters_rec.cb_trx_type_id := p7_a62;
198 ddp_sys_parameters_rec.pos_write_off_threshold := p7_a63;
199 ddp_sys_parameters_rec.neg_write_off_threshold := p7_a64;
200 ddp_sys_parameters_rec.adj_rec_trx_id := p7_a65;
201 ddp_sys_parameters_rec.wo_rec_trx_id := p7_a66;
202 ddp_sys_parameters_rec.neg_wo_rec_trx_id := p7_a67;
203 ddp_sys_parameters_rec.un_earned_pay_allow_to := p7_a68;
204 ddp_sys_parameters_rec.un_earned_pay_thold_type := p7_a69;
205 ddp_sys_parameters_rec.un_earned_pay_threshold := p7_a70;
206 ddp_sys_parameters_rec.un_earned_pay_thold_flag := p7_a71;
207 ddp_sys_parameters_rec.header_tolerance_calc_code := p7_a72;
208 ddp_sys_parameters_rec.header_tolerance_operand := p7_a73;
209 ddp_sys_parameters_rec.line_tolerance_calc_code := p7_a74;
210 ddp_sys_parameters_rec.line_tolerance_operand := p7_a75;
211 ddp_sys_parameters_rec.ship_debit_accrual_flag := p7_a76;
212 ddp_sys_parameters_rec.ship_debit_calc_type := p7_a77;
213 ddp_sys_parameters_rec.inventory_tracking_flag := p7_a78;
214 ddp_sys_parameters_rec.end_cust_relation_flag := p7_a79;
215 ddp_sys_parameters_rec.auto_tp_accrual_flag := p7_a80;
216 ddp_sys_parameters_rec.gl_balancing_flex_value := p7_a81;
217 ddp_sys_parameters_rec.prorate_earnings_flag := p7_a82;
218 ddp_sys_parameters_rec.sales_credit_default_type := p7_a83;
219 ddp_sys_parameters_rec.net_amt_for_mass_settle_flag := p7_a84;
220 ddp_sys_parameters_rec.claim_tax_incl_flag := p7_a85;
221 ddp_sys_parameters_rec.rule_based := p7_a86;
222 ddp_sys_parameters_rec.approval_new_credit := p7_a87;
223 ddp_sys_parameters_rec.approval_matched_credit := p7_a88;
224 ddp_sys_parameters_rec.cust_name_match_type := p7_a89;
225 ddp_sys_parameters_rec.credit_matching_thold_type := p7_a90;
226 ddp_sys_parameters_rec.credit_tolerance_operand := p7_a91;
227 ddp_sys_parameters_rec.automate_notification_days := p7_a92;
228 ddp_sys_parameters_rec.ssd_inc_adj_type_id := p7_a93;
229 ddp_sys_parameters_rec.ssd_dec_adj_type_id := p7_a94;
230 ddp_sys_parameters_rec.ssd_imd_claim_flag := p7_a95;
231
232
233 -- here's the delegated call to the old PL/SQL routine
234 ozf_sys_parameters_pvt.create_sys_parameters(p_api_version,
235 p_init_msg_list,
236 p_commit,
237 p_validation_level,
238 x_return_status,
239 x_msg_count,
240 x_msg_data,
241 ddp_sys_parameters_rec,
242 x_set_of_books_id);
243
244 -- copy data back from the local variables to OUT or IN-OUT args, if any
245
246
247
248
249
250
251
252
253 end;
254
255 procedure update_sys_parameters(p_api_version NUMBER
256 , p_init_msg_list VARCHAR2
257 , p_commit VARCHAR2
258 , p_validation_level NUMBER
259 , x_return_status out nocopy VARCHAR2
260 , x_msg_count out nocopy NUMBER
261 , x_msg_data out nocopy VARCHAR2
262 , p7_a0 NUMBER
263 , p7_a1 NUMBER
264 , p7_a2 DATE
265 , p7_a3 NUMBER
266 , p7_a4 DATE
267 , p7_a5 NUMBER
268 , p7_a6 NUMBER
269 , p7_a7 NUMBER
270 , p7_a8 NUMBER
271 , p7_a9 DATE
272 , p7_a10 NUMBER
273 , p7_a11 VARCHAR2
274 , p7_a12 VARCHAR2
275 , p7_a13 VARCHAR2
276 , p7_a14 NUMBER
277 , p7_a15 VARCHAR2
278 , p7_a16 NUMBER
279 , p7_a17 NUMBER
280 , p7_a18 NUMBER
281 , p7_a19 NUMBER
282 , p7_a20 NUMBER
283 , p7_a21 NUMBER
284 , p7_a22 NUMBER
285 , p7_a23 NUMBER
286 , p7_a24 NUMBER
287 , p7_a25 NUMBER
288 , p7_a26 VARCHAR2
289 , p7_a27 NUMBER
290 , p7_a28 NUMBER
291 , p7_a29 NUMBER
292 , p7_a30 NUMBER
293 , p7_a31 NUMBER
294 , p7_a32 VARCHAR2
295 , p7_a33 NUMBER
296 , p7_a34 VARCHAR2
297 , p7_a35 VARCHAR2
298 , p7_a36 NUMBER
299 , p7_a37 NUMBER
300 , p7_a38 VARCHAR2
301 , p7_a39 VARCHAR2
302 , p7_a40 VARCHAR2
303 , p7_a41 VARCHAR2
304 , p7_a42 VARCHAR2
305 , p7_a43 VARCHAR2
306 , p7_a44 VARCHAR2
307 , p7_a45 VARCHAR2
308 , p7_a46 VARCHAR2
309 , p7_a47 VARCHAR2
310 , p7_a48 VARCHAR2
311 , p7_a49 VARCHAR2
312 , p7_a50 VARCHAR2
313 , p7_a51 VARCHAR2
314 , p7_a52 VARCHAR2
315 , p7_a53 VARCHAR2
316 , p7_a54 NUMBER
317 , p7_a55 NUMBER
318 , p7_a56 VARCHAR2
319 , p7_a57 NUMBER
320 , p7_a58 VARCHAR2
321 , p7_a59 VARCHAR2
322 , p7_a60 NUMBER
323 , p7_a61 VARCHAR2
324 , p7_a62 NUMBER
325 , p7_a63 NUMBER
326 , p7_a64 NUMBER
327 , p7_a65 NUMBER
328 , p7_a66 NUMBER
329 , p7_a67 NUMBER
330 , p7_a68 VARCHAR2
331 , p7_a69 VARCHAR2
332 , p7_a70 NUMBER
333 , p7_a71 VARCHAR2
334 , p7_a72 VARCHAR2
335 , p7_a73 NUMBER
336 , p7_a74 VARCHAR2
337 , p7_a75 NUMBER
338 , p7_a76 VARCHAR2
339 , p7_a77 VARCHAR2
340 , p7_a78 VARCHAR2
341 , p7_a79 VARCHAR2
342 , p7_a80 VARCHAR2
343 , p7_a81 VARCHAR2
344 , p7_a82 VARCHAR2
345 , p7_a83 VARCHAR2
346 , p7_a84 VARCHAR2
347 , p7_a85 VARCHAR2
348 , p7_a86 VARCHAR2
349 , p7_a87 VARCHAR2
350 , p7_a88 VARCHAR2
351 , p7_a89 VARCHAR2
352 , p7_a90 VARCHAR2
353 , p7_a91 NUMBER
354 , p7_a92 NUMBER
355 , p7_a93 NUMBER
356 , p7_a94 NUMBER
357 , p7_a95 VARCHAR2
358 , p_mode VARCHAR2
359 , x_object_version_number out nocopy NUMBER
360 )
361
362 as
363 ddp_sys_parameters_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
364 ddindx binary_integer; indx binary_integer;
365 begin
366
367 -- copy data to the local IN or IN-OUT args, if any
368
369
370
371
372
373
374
375 ddp_sys_parameters_rec.set_of_books_id := p7_a0;
376 ddp_sys_parameters_rec.object_version_number := p7_a1;
380 ddp_sys_parameters_rec.created_by := p7_a5;
377 ddp_sys_parameters_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
378 ddp_sys_parameters_rec.last_updated_by := p7_a3;
379 ddp_sys_parameters_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
381 ddp_sys_parameters_rec.last_update_login := p7_a6;
382 ddp_sys_parameters_rec.request_id := p7_a7;
383 ddp_sys_parameters_rec.program_application_id := p7_a8;
384 ddp_sys_parameters_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a9);
385 ddp_sys_parameters_rec.program_id := p7_a10;
386 ddp_sys_parameters_rec.created_from := p7_a11;
387 ddp_sys_parameters_rec.post_to_gl := p7_a12;
388 ddp_sys_parameters_rec.transfer_to_gl_in := p7_a13;
389 ddp_sys_parameters_rec.ap_payment_term_id := p7_a14;
390 ddp_sys_parameters_rec.rounding_level_flag := p7_a15;
391 ddp_sys_parameters_rec.gl_id_rounding := p7_a16;
392 ddp_sys_parameters_rec.gl_id_ded_clearing := p7_a17;
393 ddp_sys_parameters_rec.gl_id_ded_adj := p7_a18;
394 ddp_sys_parameters_rec.gl_id_accr_promo_liab := p7_a19;
395 ddp_sys_parameters_rec.gl_id_ded_adj_clearing := p7_a20;
396 ddp_sys_parameters_rec.gl_rec_ded_account := p7_a21;
397 ddp_sys_parameters_rec.gl_rec_clearing_account := p7_a22;
398 ddp_sys_parameters_rec.gl_cost_adjustment_acct := p7_a23;
399 ddp_sys_parameters_rec.gl_contra_liability_acct := p7_a24;
400 ddp_sys_parameters_rec.gl_pp_accrual_acct := p7_a25;
401 ddp_sys_parameters_rec.gl_date_type := p7_a26;
402 ddp_sys_parameters_rec.days_due := p7_a27;
403 ddp_sys_parameters_rec.claim_type_id := p7_a28;
404 ddp_sys_parameters_rec.reason_code_id := p7_a29;
405 ddp_sys_parameters_rec.autopay_claim_type_id := p7_a30;
406 ddp_sys_parameters_rec.autopay_reason_code_id := p7_a31;
407 ddp_sys_parameters_rec.autopay_flag := p7_a32;
408 ddp_sys_parameters_rec.autopay_periodicity := p7_a33;
409 ddp_sys_parameters_rec.autopay_periodicity_type := p7_a34;
410 ddp_sys_parameters_rec.accounting_method_option := p7_a35;
411 ddp_sys_parameters_rec.billback_trx_type_id := p7_a36;
412 ddp_sys_parameters_rec.cm_trx_type_id := p7_a37;
413 ddp_sys_parameters_rec.attribute_category := p7_a38;
414 ddp_sys_parameters_rec.attribute1 := p7_a39;
415 ddp_sys_parameters_rec.attribute2 := p7_a40;
416 ddp_sys_parameters_rec.attribute3 := p7_a41;
417 ddp_sys_parameters_rec.attribute4 := p7_a42;
418 ddp_sys_parameters_rec.attribute5 := p7_a43;
419 ddp_sys_parameters_rec.attribute6 := p7_a44;
420 ddp_sys_parameters_rec.attribute7 := p7_a45;
421 ddp_sys_parameters_rec.attribute8 := p7_a46;
422 ddp_sys_parameters_rec.attribute9 := p7_a47;
423 ddp_sys_parameters_rec.attribute10 := p7_a48;
424 ddp_sys_parameters_rec.attribute11 := p7_a49;
425 ddp_sys_parameters_rec.attribute12 := p7_a50;
426 ddp_sys_parameters_rec.attribute13 := p7_a51;
427 ddp_sys_parameters_rec.attribute14 := p7_a52;
428 ddp_sys_parameters_rec.attribute15 := p7_a53;
429 ddp_sys_parameters_rec.org_id := p7_a54;
430 ddp_sys_parameters_rec.batch_source_id := p7_a55;
431 ddp_sys_parameters_rec.payables_source := p7_a56;
432 ddp_sys_parameters_rec.default_owner_id := p7_a57;
433 ddp_sys_parameters_rec.auto_assign_flag := p7_a58;
434 ddp_sys_parameters_rec.exchange_rate_type := p7_a59;
435 ddp_sys_parameters_rec.order_type_id := p7_a60;
436 ddp_sys_parameters_rec.gl_acct_for_offinv_flag := p7_a61;
437 ddp_sys_parameters_rec.cb_trx_type_id := p7_a62;
438 ddp_sys_parameters_rec.pos_write_off_threshold := p7_a63;
439 ddp_sys_parameters_rec.neg_write_off_threshold := p7_a64;
440 ddp_sys_parameters_rec.adj_rec_trx_id := p7_a65;
441 ddp_sys_parameters_rec.wo_rec_trx_id := p7_a66;
442 ddp_sys_parameters_rec.neg_wo_rec_trx_id := p7_a67;
443 ddp_sys_parameters_rec.un_earned_pay_allow_to := p7_a68;
444 ddp_sys_parameters_rec.un_earned_pay_thold_type := p7_a69;
445 ddp_sys_parameters_rec.un_earned_pay_threshold := p7_a70;
446 ddp_sys_parameters_rec.un_earned_pay_thold_flag := p7_a71;
447 ddp_sys_parameters_rec.header_tolerance_calc_code := p7_a72;
448 ddp_sys_parameters_rec.header_tolerance_operand := p7_a73;
449 ddp_sys_parameters_rec.line_tolerance_calc_code := p7_a74;
450 ddp_sys_parameters_rec.line_tolerance_operand := p7_a75;
451 ddp_sys_parameters_rec.ship_debit_accrual_flag := p7_a76;
452 ddp_sys_parameters_rec.ship_debit_calc_type := p7_a77;
453 ddp_sys_parameters_rec.inventory_tracking_flag := p7_a78;
454 ddp_sys_parameters_rec.end_cust_relation_flag := p7_a79;
455 ddp_sys_parameters_rec.auto_tp_accrual_flag := p7_a80;
456 ddp_sys_parameters_rec.gl_balancing_flex_value := p7_a81;
457 ddp_sys_parameters_rec.prorate_earnings_flag := p7_a82;
458 ddp_sys_parameters_rec.sales_credit_default_type := p7_a83;
459 ddp_sys_parameters_rec.net_amt_for_mass_settle_flag := p7_a84;
460 ddp_sys_parameters_rec.claim_tax_incl_flag := p7_a85;
461 ddp_sys_parameters_rec.rule_based := p7_a86;
462 ddp_sys_parameters_rec.approval_new_credit := p7_a87;
463 ddp_sys_parameters_rec.approval_matched_credit := p7_a88;
464 ddp_sys_parameters_rec.cust_name_match_type := p7_a89;
465 ddp_sys_parameters_rec.credit_matching_thold_type := p7_a90;
466 ddp_sys_parameters_rec.credit_tolerance_operand := p7_a91;
467 ddp_sys_parameters_rec.automate_notification_days := p7_a92;
468 ddp_sys_parameters_rec.ssd_inc_adj_type_id := p7_a93;
469 ddp_sys_parameters_rec.ssd_dec_adj_type_id := p7_a94;
470 ddp_sys_parameters_rec.ssd_imd_claim_flag := p7_a95;
471
475 ozf_sys_parameters_pvt.update_sys_parameters(p_api_version,
472
473
474 -- here's the delegated call to the old PL/SQL routine
476 p_init_msg_list,
477 p_commit,
478 p_validation_level,
479 x_return_status,
480 x_msg_count,
481 x_msg_data,
482 ddp_sys_parameters_rec,
483 p_mode,
484 x_object_version_number);
485
486 -- copy data back from the local variables to OUT or IN-OUT args, if any
487
488
489
490
491
492
493
494
495
496 end;
497
498 procedure validate_sys_parameters(p_api_version NUMBER
499 , p_init_msg_list VARCHAR2
500 , p_validation_level NUMBER
501 , x_return_status out nocopy VARCHAR2
502 , x_msg_count out nocopy NUMBER
503 , x_msg_data out nocopy VARCHAR2
504 , p6_a0 NUMBER
505 , p6_a1 NUMBER
506 , p6_a2 DATE
507 , p6_a3 NUMBER
508 , p6_a4 DATE
509 , p6_a5 NUMBER
510 , p6_a6 NUMBER
511 , p6_a7 NUMBER
512 , p6_a8 NUMBER
513 , p6_a9 DATE
514 , p6_a10 NUMBER
515 , p6_a11 VARCHAR2
516 , p6_a12 VARCHAR2
517 , p6_a13 VARCHAR2
518 , p6_a14 NUMBER
519 , p6_a15 VARCHAR2
520 , p6_a16 NUMBER
521 , p6_a17 NUMBER
522 , p6_a18 NUMBER
523 , p6_a19 NUMBER
524 , p6_a20 NUMBER
525 , p6_a21 NUMBER
526 , p6_a22 NUMBER
527 , p6_a23 NUMBER
528 , p6_a24 NUMBER
529 , p6_a25 NUMBER
530 , p6_a26 VARCHAR2
531 , p6_a27 NUMBER
532 , p6_a28 NUMBER
533 , p6_a29 NUMBER
534 , p6_a30 NUMBER
535 , p6_a31 NUMBER
536 , p6_a32 VARCHAR2
537 , p6_a33 NUMBER
538 , p6_a34 VARCHAR2
539 , p6_a35 VARCHAR2
540 , p6_a36 NUMBER
541 , p6_a37 NUMBER
542 , p6_a38 VARCHAR2
543 , p6_a39 VARCHAR2
544 , p6_a40 VARCHAR2
545 , p6_a41 VARCHAR2
546 , p6_a42 VARCHAR2
547 , p6_a43 VARCHAR2
548 , p6_a44 VARCHAR2
549 , p6_a45 VARCHAR2
550 , p6_a46 VARCHAR2
551 , p6_a47 VARCHAR2
552 , p6_a48 VARCHAR2
553 , p6_a49 VARCHAR2
554 , p6_a50 VARCHAR2
555 , p6_a51 VARCHAR2
556 , p6_a52 VARCHAR2
557 , p6_a53 VARCHAR2
558 , p6_a54 NUMBER
559 , p6_a55 NUMBER
560 , p6_a56 VARCHAR2
561 , p6_a57 NUMBER
562 , p6_a58 VARCHAR2
563 , p6_a59 VARCHAR2
564 , p6_a60 NUMBER
565 , p6_a61 VARCHAR2
566 , p6_a62 NUMBER
567 , p6_a63 NUMBER
568 , p6_a64 NUMBER
569 , p6_a65 NUMBER
570 , p6_a66 NUMBER
571 , p6_a67 NUMBER
572 , p6_a68 VARCHAR2
573 , p6_a69 VARCHAR2
574 , p6_a70 NUMBER
575 , p6_a71 VARCHAR2
576 , p6_a72 VARCHAR2
577 , p6_a73 NUMBER
578 , p6_a74 VARCHAR2
579 , p6_a75 NUMBER
580 , p6_a76 VARCHAR2
581 , p6_a77 VARCHAR2
582 , p6_a78 VARCHAR2
583 , p6_a79 VARCHAR2
584 , p6_a80 VARCHAR2
585 , p6_a81 VARCHAR2
586 , p6_a82 VARCHAR2
587 , p6_a83 VARCHAR2
588 , p6_a84 VARCHAR2
589 , p6_a85 VARCHAR2
590 , p6_a86 VARCHAR2
591 , p6_a87 VARCHAR2
592 , p6_a88 VARCHAR2
593 , p6_a89 VARCHAR2
594 , p6_a90 VARCHAR2
595 , p6_a91 NUMBER
596 , p6_a92 NUMBER
597 , p6_a93 NUMBER
598 , p6_a94 NUMBER
599 , p6_a95 VARCHAR2
600 )
601
602 as
603 ddp_sys_parameters_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
604 ddindx binary_integer; indx binary_integer;
605 begin
606
607 -- copy data to the local IN or IN-OUT args, if any
608
609
610
611
612
613
614 ddp_sys_parameters_rec.set_of_books_id := p6_a0;
615 ddp_sys_parameters_rec.object_version_number := p6_a1;
616 ddp_sys_parameters_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
617 ddp_sys_parameters_rec.last_updated_by := p6_a3;
618 ddp_sys_parameters_rec.creation_date := rosetta_g_miss_date_in_map(p6_a4);
619 ddp_sys_parameters_rec.created_by := p6_a5;
620 ddp_sys_parameters_rec.last_update_login := p6_a6;
621 ddp_sys_parameters_rec.request_id := p6_a7;
622 ddp_sys_parameters_rec.program_application_id := p6_a8;
623 ddp_sys_parameters_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a9);
624 ddp_sys_parameters_rec.program_id := p6_a10;
625 ddp_sys_parameters_rec.created_from := p6_a11;
626 ddp_sys_parameters_rec.post_to_gl := p6_a12;
627 ddp_sys_parameters_rec.transfer_to_gl_in := p6_a13;
628 ddp_sys_parameters_rec.ap_payment_term_id := p6_a14;
629 ddp_sys_parameters_rec.rounding_level_flag := p6_a15;
630 ddp_sys_parameters_rec.gl_id_rounding := p6_a16;
631 ddp_sys_parameters_rec.gl_id_ded_clearing := p6_a17;
632 ddp_sys_parameters_rec.gl_id_ded_adj := p6_a18;
633 ddp_sys_parameters_rec.gl_id_accr_promo_liab := p6_a19;
634 ddp_sys_parameters_rec.gl_id_ded_adj_clearing := p6_a20;
635 ddp_sys_parameters_rec.gl_rec_ded_account := p6_a21;
636 ddp_sys_parameters_rec.gl_rec_clearing_account := p6_a22;
640 ddp_sys_parameters_rec.gl_date_type := p6_a26;
637 ddp_sys_parameters_rec.gl_cost_adjustment_acct := p6_a23;
638 ddp_sys_parameters_rec.gl_contra_liability_acct := p6_a24;
639 ddp_sys_parameters_rec.gl_pp_accrual_acct := p6_a25;
641 ddp_sys_parameters_rec.days_due := p6_a27;
642 ddp_sys_parameters_rec.claim_type_id := p6_a28;
643 ddp_sys_parameters_rec.reason_code_id := p6_a29;
644 ddp_sys_parameters_rec.autopay_claim_type_id := p6_a30;
645 ddp_sys_parameters_rec.autopay_reason_code_id := p6_a31;
646 ddp_sys_parameters_rec.autopay_flag := p6_a32;
647 ddp_sys_parameters_rec.autopay_periodicity := p6_a33;
648 ddp_sys_parameters_rec.autopay_periodicity_type := p6_a34;
649 ddp_sys_parameters_rec.accounting_method_option := p6_a35;
650 ddp_sys_parameters_rec.billback_trx_type_id := p6_a36;
651 ddp_sys_parameters_rec.cm_trx_type_id := p6_a37;
652 ddp_sys_parameters_rec.attribute_category := p6_a38;
653 ddp_sys_parameters_rec.attribute1 := p6_a39;
654 ddp_sys_parameters_rec.attribute2 := p6_a40;
655 ddp_sys_parameters_rec.attribute3 := p6_a41;
656 ddp_sys_parameters_rec.attribute4 := p6_a42;
657 ddp_sys_parameters_rec.attribute5 := p6_a43;
658 ddp_sys_parameters_rec.attribute6 := p6_a44;
659 ddp_sys_parameters_rec.attribute7 := p6_a45;
660 ddp_sys_parameters_rec.attribute8 := p6_a46;
661 ddp_sys_parameters_rec.attribute9 := p6_a47;
662 ddp_sys_parameters_rec.attribute10 := p6_a48;
663 ddp_sys_parameters_rec.attribute11 := p6_a49;
664 ddp_sys_parameters_rec.attribute12 := p6_a50;
665 ddp_sys_parameters_rec.attribute13 := p6_a51;
666 ddp_sys_parameters_rec.attribute14 := p6_a52;
667 ddp_sys_parameters_rec.attribute15 := p6_a53;
668 ddp_sys_parameters_rec.org_id := p6_a54;
669 ddp_sys_parameters_rec.batch_source_id := p6_a55;
670 ddp_sys_parameters_rec.payables_source := p6_a56;
671 ddp_sys_parameters_rec.default_owner_id := p6_a57;
672 ddp_sys_parameters_rec.auto_assign_flag := p6_a58;
673 ddp_sys_parameters_rec.exchange_rate_type := p6_a59;
674 ddp_sys_parameters_rec.order_type_id := p6_a60;
675 ddp_sys_parameters_rec.gl_acct_for_offinv_flag := p6_a61;
676 ddp_sys_parameters_rec.cb_trx_type_id := p6_a62;
677 ddp_sys_parameters_rec.pos_write_off_threshold := p6_a63;
678 ddp_sys_parameters_rec.neg_write_off_threshold := p6_a64;
679 ddp_sys_parameters_rec.adj_rec_trx_id := p6_a65;
680 ddp_sys_parameters_rec.wo_rec_trx_id := p6_a66;
681 ddp_sys_parameters_rec.neg_wo_rec_trx_id := p6_a67;
682 ddp_sys_parameters_rec.un_earned_pay_allow_to := p6_a68;
683 ddp_sys_parameters_rec.un_earned_pay_thold_type := p6_a69;
684 ddp_sys_parameters_rec.un_earned_pay_threshold := p6_a70;
685 ddp_sys_parameters_rec.un_earned_pay_thold_flag := p6_a71;
686 ddp_sys_parameters_rec.header_tolerance_calc_code := p6_a72;
687 ddp_sys_parameters_rec.header_tolerance_operand := p6_a73;
688 ddp_sys_parameters_rec.line_tolerance_calc_code := p6_a74;
689 ddp_sys_parameters_rec.line_tolerance_operand := p6_a75;
690 ddp_sys_parameters_rec.ship_debit_accrual_flag := p6_a76;
691 ddp_sys_parameters_rec.ship_debit_calc_type := p6_a77;
692 ddp_sys_parameters_rec.inventory_tracking_flag := p6_a78;
693 ddp_sys_parameters_rec.end_cust_relation_flag := p6_a79;
694 ddp_sys_parameters_rec.auto_tp_accrual_flag := p6_a80;
695 ddp_sys_parameters_rec.gl_balancing_flex_value := p6_a81;
696 ddp_sys_parameters_rec.prorate_earnings_flag := p6_a82;
697 ddp_sys_parameters_rec.sales_credit_default_type := p6_a83;
698 ddp_sys_parameters_rec.net_amt_for_mass_settle_flag := p6_a84;
699 ddp_sys_parameters_rec.claim_tax_incl_flag := p6_a85;
700 ddp_sys_parameters_rec.rule_based := p6_a86;
701 ddp_sys_parameters_rec.approval_new_credit := p6_a87;
702 ddp_sys_parameters_rec.approval_matched_credit := p6_a88;
703 ddp_sys_parameters_rec.cust_name_match_type := p6_a89;
704 ddp_sys_parameters_rec.credit_matching_thold_type := p6_a90;
705 ddp_sys_parameters_rec.credit_tolerance_operand := p6_a91;
706 ddp_sys_parameters_rec.automate_notification_days := p6_a92;
707 ddp_sys_parameters_rec.ssd_inc_adj_type_id := p6_a93;
708 ddp_sys_parameters_rec.ssd_dec_adj_type_id := p6_a94;
709 ddp_sys_parameters_rec.ssd_imd_claim_flag := p6_a95;
710
711 -- here's the delegated call to the old PL/SQL routine
712 ozf_sys_parameters_pvt.validate_sys_parameters(p_api_version,
713 p_init_msg_list,
714 p_validation_level,
715 x_return_status,
716 x_msg_count,
717 x_msg_data,
718 ddp_sys_parameters_rec);
719
720 -- copy data back from the local variables to OUT or IN-OUT args, if any
721
722
723
724
725
726
727 end;
728
729 procedure check_sys_parameters_items(p0_a0 NUMBER
730 , p0_a1 NUMBER
731 , p0_a2 DATE
732 , p0_a3 NUMBER
733 , p0_a4 DATE
734 , p0_a5 NUMBER
735 , p0_a6 NUMBER
736 , p0_a7 NUMBER
737 , p0_a8 NUMBER
738 , p0_a9 DATE
739 , p0_a10 NUMBER
740 , p0_a11 VARCHAR2
741 , p0_a12 VARCHAR2
742 , p0_a13 VARCHAR2
743 , p0_a14 NUMBER
744 , p0_a15 VARCHAR2
745 , p0_a16 NUMBER
746 , p0_a17 NUMBER
747 , p0_a18 NUMBER
748 , p0_a19 NUMBER
749 , p0_a20 NUMBER
750 , p0_a21 NUMBER
751 , p0_a22 NUMBER
752 , p0_a23 NUMBER
753 , p0_a24 NUMBER
754 , p0_a25 NUMBER
758 , p0_a29 NUMBER
755 , p0_a26 VARCHAR2
756 , p0_a27 NUMBER
757 , p0_a28 NUMBER
759 , p0_a30 NUMBER
760 , p0_a31 NUMBER
761 , p0_a32 VARCHAR2
762 , p0_a33 NUMBER
763 , p0_a34 VARCHAR2
764 , p0_a35 VARCHAR2
765 , p0_a36 NUMBER
766 , p0_a37 NUMBER
767 , p0_a38 VARCHAR2
768 , p0_a39 VARCHAR2
769 , p0_a40 VARCHAR2
770 , p0_a41 VARCHAR2
771 , p0_a42 VARCHAR2
772 , p0_a43 VARCHAR2
773 , p0_a44 VARCHAR2
774 , p0_a45 VARCHAR2
775 , p0_a46 VARCHAR2
776 , p0_a47 VARCHAR2
777 , p0_a48 VARCHAR2
778 , p0_a49 VARCHAR2
779 , p0_a50 VARCHAR2
780 , p0_a51 VARCHAR2
781 , p0_a52 VARCHAR2
782 , p0_a53 VARCHAR2
783 , p0_a54 NUMBER
784 , p0_a55 NUMBER
785 , p0_a56 VARCHAR2
786 , p0_a57 NUMBER
787 , p0_a58 VARCHAR2
788 , p0_a59 VARCHAR2
789 , p0_a60 NUMBER
790 , p0_a61 VARCHAR2
791 , p0_a62 NUMBER
792 , p0_a63 NUMBER
793 , p0_a64 NUMBER
794 , p0_a65 NUMBER
795 , p0_a66 NUMBER
796 , p0_a67 NUMBER
797 , p0_a68 VARCHAR2
798 , p0_a69 VARCHAR2
799 , p0_a70 NUMBER
800 , p0_a71 VARCHAR2
801 , p0_a72 VARCHAR2
802 , p0_a73 NUMBER
803 , p0_a74 VARCHAR2
804 , p0_a75 NUMBER
805 , p0_a76 VARCHAR2
806 , p0_a77 VARCHAR2
807 , p0_a78 VARCHAR2
808 , p0_a79 VARCHAR2
809 , p0_a80 VARCHAR2
810 , p0_a81 VARCHAR2
811 , p0_a82 VARCHAR2
812 , p0_a83 VARCHAR2
813 , p0_a84 VARCHAR2
814 , p0_a85 VARCHAR2
815 , p0_a86 VARCHAR2
816 , p0_a87 VARCHAR2
817 , p0_a88 VARCHAR2
818 , p0_a89 VARCHAR2
819 , p0_a90 VARCHAR2
820 , p0_a91 NUMBER
821 , p0_a92 NUMBER
822 , p0_a93 NUMBER
823 , p0_a94 NUMBER
824 , p0_a95 VARCHAR2
825 , p_validation_mode VARCHAR2
826 , x_return_status out nocopy VARCHAR2
827 )
828
829 as
830 ddp_sys_parameters_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
831 ddindx binary_integer; indx binary_integer;
832 begin
833
834 -- copy data to the local IN or IN-OUT args, if any
835 ddp_sys_parameters_rec.set_of_books_id := p0_a0;
836 ddp_sys_parameters_rec.object_version_number := p0_a1;
837 ddp_sys_parameters_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
838 ddp_sys_parameters_rec.last_updated_by := p0_a3;
839 ddp_sys_parameters_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
840 ddp_sys_parameters_rec.created_by := p0_a5;
841 ddp_sys_parameters_rec.last_update_login := p0_a6;
842 ddp_sys_parameters_rec.request_id := p0_a7;
843 ddp_sys_parameters_rec.program_application_id := p0_a8;
844 ddp_sys_parameters_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a9);
845 ddp_sys_parameters_rec.program_id := p0_a10;
846 ddp_sys_parameters_rec.created_from := p0_a11;
847 ddp_sys_parameters_rec.post_to_gl := p0_a12;
848 ddp_sys_parameters_rec.transfer_to_gl_in := p0_a13;
849 ddp_sys_parameters_rec.ap_payment_term_id := p0_a14;
850 ddp_sys_parameters_rec.rounding_level_flag := p0_a15;
851 ddp_sys_parameters_rec.gl_id_rounding := p0_a16;
852 ddp_sys_parameters_rec.gl_id_ded_clearing := p0_a17;
853 ddp_sys_parameters_rec.gl_id_ded_adj := p0_a18;
854 ddp_sys_parameters_rec.gl_id_accr_promo_liab := p0_a19;
855 ddp_sys_parameters_rec.gl_id_ded_adj_clearing := p0_a20;
856 ddp_sys_parameters_rec.gl_rec_ded_account := p0_a21;
857 ddp_sys_parameters_rec.gl_rec_clearing_account := p0_a22;
858 ddp_sys_parameters_rec.gl_cost_adjustment_acct := p0_a23;
859 ddp_sys_parameters_rec.gl_contra_liability_acct := p0_a24;
860 ddp_sys_parameters_rec.gl_pp_accrual_acct := p0_a25;
861 ddp_sys_parameters_rec.gl_date_type := p0_a26;
862 ddp_sys_parameters_rec.days_due := p0_a27;
863 ddp_sys_parameters_rec.claim_type_id := p0_a28;
864 ddp_sys_parameters_rec.reason_code_id := p0_a29;
865 ddp_sys_parameters_rec.autopay_claim_type_id := p0_a30;
866 ddp_sys_parameters_rec.autopay_reason_code_id := p0_a31;
867 ddp_sys_parameters_rec.autopay_flag := p0_a32;
868 ddp_sys_parameters_rec.autopay_periodicity := p0_a33;
869 ddp_sys_parameters_rec.autopay_periodicity_type := p0_a34;
870 ddp_sys_parameters_rec.accounting_method_option := p0_a35;
871 ddp_sys_parameters_rec.billback_trx_type_id := p0_a36;
872 ddp_sys_parameters_rec.cm_trx_type_id := p0_a37;
873 ddp_sys_parameters_rec.attribute_category := p0_a38;
874 ddp_sys_parameters_rec.attribute1 := p0_a39;
875 ddp_sys_parameters_rec.attribute2 := p0_a40;
876 ddp_sys_parameters_rec.attribute3 := p0_a41;
877 ddp_sys_parameters_rec.attribute4 := p0_a42;
878 ddp_sys_parameters_rec.attribute5 := p0_a43;
879 ddp_sys_parameters_rec.attribute6 := p0_a44;
880 ddp_sys_parameters_rec.attribute7 := p0_a45;
881 ddp_sys_parameters_rec.attribute8 := p0_a46;
882 ddp_sys_parameters_rec.attribute9 := p0_a47;
883 ddp_sys_parameters_rec.attribute10 := p0_a48;
884 ddp_sys_parameters_rec.attribute11 := p0_a49;
885 ddp_sys_parameters_rec.attribute12 := p0_a50;
886 ddp_sys_parameters_rec.attribute13 := p0_a51;
887 ddp_sys_parameters_rec.attribute14 := p0_a52;
888 ddp_sys_parameters_rec.attribute15 := p0_a53;
892 ddp_sys_parameters_rec.default_owner_id := p0_a57;
889 ddp_sys_parameters_rec.org_id := p0_a54;
890 ddp_sys_parameters_rec.batch_source_id := p0_a55;
891 ddp_sys_parameters_rec.payables_source := p0_a56;
893 ddp_sys_parameters_rec.auto_assign_flag := p0_a58;
894 ddp_sys_parameters_rec.exchange_rate_type := p0_a59;
895 ddp_sys_parameters_rec.order_type_id := p0_a60;
896 ddp_sys_parameters_rec.gl_acct_for_offinv_flag := p0_a61;
897 ddp_sys_parameters_rec.cb_trx_type_id := p0_a62;
898 ddp_sys_parameters_rec.pos_write_off_threshold := p0_a63;
899 ddp_sys_parameters_rec.neg_write_off_threshold := p0_a64;
900 ddp_sys_parameters_rec.adj_rec_trx_id := p0_a65;
901 ddp_sys_parameters_rec.wo_rec_trx_id := p0_a66;
902 ddp_sys_parameters_rec.neg_wo_rec_trx_id := p0_a67;
903 ddp_sys_parameters_rec.un_earned_pay_allow_to := p0_a68;
904 ddp_sys_parameters_rec.un_earned_pay_thold_type := p0_a69;
905 ddp_sys_parameters_rec.un_earned_pay_threshold := p0_a70;
906 ddp_sys_parameters_rec.un_earned_pay_thold_flag := p0_a71;
907 ddp_sys_parameters_rec.header_tolerance_calc_code := p0_a72;
908 ddp_sys_parameters_rec.header_tolerance_operand := p0_a73;
909 ddp_sys_parameters_rec.line_tolerance_calc_code := p0_a74;
910 ddp_sys_parameters_rec.line_tolerance_operand := p0_a75;
911 ddp_sys_parameters_rec.ship_debit_accrual_flag := p0_a76;
912 ddp_sys_parameters_rec.ship_debit_calc_type := p0_a77;
913 ddp_sys_parameters_rec.inventory_tracking_flag := p0_a78;
914 ddp_sys_parameters_rec.end_cust_relation_flag := p0_a79;
915 ddp_sys_parameters_rec.auto_tp_accrual_flag := p0_a80;
916 ddp_sys_parameters_rec.gl_balancing_flex_value := p0_a81;
917 ddp_sys_parameters_rec.prorate_earnings_flag := p0_a82;
918 ddp_sys_parameters_rec.sales_credit_default_type := p0_a83;
919 ddp_sys_parameters_rec.net_amt_for_mass_settle_flag := p0_a84;
920 ddp_sys_parameters_rec.claim_tax_incl_flag := p0_a85;
921 ddp_sys_parameters_rec.rule_based := p0_a86;
922 ddp_sys_parameters_rec.approval_new_credit := p0_a87;
923 ddp_sys_parameters_rec.approval_matched_credit := p0_a88;
924 ddp_sys_parameters_rec.cust_name_match_type := p0_a89;
925 ddp_sys_parameters_rec.credit_matching_thold_type := p0_a90;
926 ddp_sys_parameters_rec.credit_tolerance_operand := p0_a91;
927 ddp_sys_parameters_rec.automate_notification_days := p0_a92;
928 ddp_sys_parameters_rec.ssd_inc_adj_type_id := p0_a93;
929 ddp_sys_parameters_rec.ssd_dec_adj_type_id := p0_a94;
930 ddp_sys_parameters_rec.ssd_imd_claim_flag := p0_a95;
931
932
933
934 -- here's the delegated call to the old PL/SQL routine
935 ozf_sys_parameters_pvt.check_sys_parameters_items(ddp_sys_parameters_rec,
936 p_validation_mode,
937 x_return_status);
938
939 -- copy data back from the local variables to OUT or IN-OUT args, if any
940
941
942 end;
943
944 procedure check_sys_parameters_record(p0_a0 NUMBER
945 , p0_a1 NUMBER
946 , p0_a2 DATE
947 , p0_a3 NUMBER
948 , p0_a4 DATE
949 , p0_a5 NUMBER
950 , p0_a6 NUMBER
951 , p0_a7 NUMBER
952 , p0_a8 NUMBER
953 , p0_a9 DATE
954 , p0_a10 NUMBER
955 , p0_a11 VARCHAR2
956 , p0_a12 VARCHAR2
957 , p0_a13 VARCHAR2
958 , p0_a14 NUMBER
959 , p0_a15 VARCHAR2
960 , p0_a16 NUMBER
961 , p0_a17 NUMBER
962 , p0_a18 NUMBER
963 , p0_a19 NUMBER
964 , p0_a20 NUMBER
965 , p0_a21 NUMBER
966 , p0_a22 NUMBER
967 , p0_a23 NUMBER
968 , p0_a24 NUMBER
969 , p0_a25 NUMBER
970 , p0_a26 VARCHAR2
971 , p0_a27 NUMBER
972 , p0_a28 NUMBER
973 , p0_a29 NUMBER
974 , p0_a30 NUMBER
975 , p0_a31 NUMBER
976 , p0_a32 VARCHAR2
977 , p0_a33 NUMBER
978 , p0_a34 VARCHAR2
979 , p0_a35 VARCHAR2
980 , p0_a36 NUMBER
981 , p0_a37 NUMBER
982 , p0_a38 VARCHAR2
983 , p0_a39 VARCHAR2
984 , p0_a40 VARCHAR2
985 , p0_a41 VARCHAR2
986 , p0_a42 VARCHAR2
987 , p0_a43 VARCHAR2
988 , p0_a44 VARCHAR2
989 , p0_a45 VARCHAR2
990 , p0_a46 VARCHAR2
991 , p0_a47 VARCHAR2
992 , p0_a48 VARCHAR2
993 , p0_a49 VARCHAR2
994 , p0_a50 VARCHAR2
995 , p0_a51 VARCHAR2
996 , p0_a52 VARCHAR2
997 , p0_a53 VARCHAR2
998 , p0_a54 NUMBER
999 , p0_a55 NUMBER
1000 , p0_a56 VARCHAR2
1001 , p0_a57 NUMBER
1002 , p0_a58 VARCHAR2
1003 , p0_a59 VARCHAR2
1004 , p0_a60 NUMBER
1005 , p0_a61 VARCHAR2
1006 , p0_a62 NUMBER
1007 , p0_a63 NUMBER
1008 , p0_a64 NUMBER
1009 , p0_a65 NUMBER
1010 , p0_a66 NUMBER
1011 , p0_a67 NUMBER
1012 , p0_a68 VARCHAR2
1013 , p0_a69 VARCHAR2
1014 , p0_a70 NUMBER
1015 , p0_a71 VARCHAR2
1016 , p0_a72 VARCHAR2
1017 , p0_a73 NUMBER
1018 , p0_a74 VARCHAR2
1019 , p0_a75 NUMBER
1020 , p0_a76 VARCHAR2
1021 , p0_a77 VARCHAR2
1022 , p0_a78 VARCHAR2
1023 , p0_a79 VARCHAR2
1024 , p0_a80 VARCHAR2
1028 , p0_a84 VARCHAR2
1025 , p0_a81 VARCHAR2
1026 , p0_a82 VARCHAR2
1027 , p0_a83 VARCHAR2
1029 , p0_a85 VARCHAR2
1030 , p0_a86 VARCHAR2
1031 , p0_a87 VARCHAR2
1032 , p0_a88 VARCHAR2
1033 , p0_a89 VARCHAR2
1034 , p0_a90 VARCHAR2
1035 , p0_a91 NUMBER
1036 , p0_a92 NUMBER
1037 , p0_a93 NUMBER
1038 , p0_a94 NUMBER
1039 , p0_a95 VARCHAR2
1040 , p1_a0 NUMBER
1041 , p1_a1 NUMBER
1042 , p1_a2 DATE
1043 , p1_a3 NUMBER
1044 , p1_a4 DATE
1045 , p1_a5 NUMBER
1046 , p1_a6 NUMBER
1047 , p1_a7 NUMBER
1048 , p1_a8 NUMBER
1049 , p1_a9 DATE
1050 , p1_a10 NUMBER
1051 , p1_a11 VARCHAR2
1052 , p1_a12 VARCHAR2
1053 , p1_a13 VARCHAR2
1054 , p1_a14 NUMBER
1055 , p1_a15 VARCHAR2
1056 , p1_a16 NUMBER
1057 , p1_a17 NUMBER
1058 , p1_a18 NUMBER
1059 , p1_a19 NUMBER
1060 , p1_a20 NUMBER
1061 , p1_a21 NUMBER
1062 , p1_a22 NUMBER
1063 , p1_a23 NUMBER
1064 , p1_a24 NUMBER
1065 , p1_a25 NUMBER
1066 , p1_a26 VARCHAR2
1067 , p1_a27 NUMBER
1068 , p1_a28 NUMBER
1069 , p1_a29 NUMBER
1070 , p1_a30 NUMBER
1071 , p1_a31 NUMBER
1072 , p1_a32 VARCHAR2
1073 , p1_a33 NUMBER
1074 , p1_a34 VARCHAR2
1075 , p1_a35 VARCHAR2
1076 , p1_a36 NUMBER
1077 , p1_a37 NUMBER
1078 , p1_a38 VARCHAR2
1079 , p1_a39 VARCHAR2
1080 , p1_a40 VARCHAR2
1081 , p1_a41 VARCHAR2
1082 , p1_a42 VARCHAR2
1083 , p1_a43 VARCHAR2
1084 , p1_a44 VARCHAR2
1085 , p1_a45 VARCHAR2
1086 , p1_a46 VARCHAR2
1087 , p1_a47 VARCHAR2
1088 , p1_a48 VARCHAR2
1089 , p1_a49 VARCHAR2
1090 , p1_a50 VARCHAR2
1091 , p1_a51 VARCHAR2
1092 , p1_a52 VARCHAR2
1093 , p1_a53 VARCHAR2
1094 , p1_a54 NUMBER
1095 , p1_a55 NUMBER
1096 , p1_a56 VARCHAR2
1097 , p1_a57 NUMBER
1098 , p1_a58 VARCHAR2
1099 , p1_a59 VARCHAR2
1100 , p1_a60 NUMBER
1101 , p1_a61 VARCHAR2
1102 , p1_a62 NUMBER
1103 , p1_a63 NUMBER
1104 , p1_a64 NUMBER
1105 , p1_a65 NUMBER
1106 , p1_a66 NUMBER
1107 , p1_a67 NUMBER
1108 , p1_a68 VARCHAR2
1109 , p1_a69 VARCHAR2
1110 , p1_a70 NUMBER
1111 , p1_a71 VARCHAR2
1112 , p1_a72 VARCHAR2
1113 , p1_a73 NUMBER
1114 , p1_a74 VARCHAR2
1115 , p1_a75 NUMBER
1116 , p1_a76 VARCHAR2
1117 , p1_a77 VARCHAR2
1118 , p1_a78 VARCHAR2
1119 , p1_a79 VARCHAR2
1120 , p1_a80 VARCHAR2
1121 , p1_a81 VARCHAR2
1122 , p1_a82 VARCHAR2
1123 , p1_a83 VARCHAR2
1124 , p1_a84 VARCHAR2
1125 , p1_a85 VARCHAR2
1126 , p1_a86 VARCHAR2
1127 , p1_a87 VARCHAR2
1128 , p1_a88 VARCHAR2
1129 , p1_a89 VARCHAR2
1130 , p1_a90 VARCHAR2
1131 , p1_a91 NUMBER
1132 , p1_a92 NUMBER
1133 , p1_a93 NUMBER
1134 , p1_a94 NUMBER
1135 , p1_a95 VARCHAR2
1136 , p_mode VARCHAR2
1137 , x_return_status out nocopy VARCHAR2
1138 )
1139
1140 as
1141 ddp_sys_parameters_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
1142 ddp_complete_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
1143 ddindx binary_integer; indx binary_integer;
1144 begin
1145
1146 -- copy data to the local IN or IN-OUT args, if any
1147 ddp_sys_parameters_rec.set_of_books_id := p0_a0;
1148 ddp_sys_parameters_rec.object_version_number := p0_a1;
1149 ddp_sys_parameters_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
1150 ddp_sys_parameters_rec.last_updated_by := p0_a3;
1151 ddp_sys_parameters_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
1152 ddp_sys_parameters_rec.created_by := p0_a5;
1153 ddp_sys_parameters_rec.last_update_login := p0_a6;
1154 ddp_sys_parameters_rec.request_id := p0_a7;
1155 ddp_sys_parameters_rec.program_application_id := p0_a8;
1156 ddp_sys_parameters_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a9);
1157 ddp_sys_parameters_rec.program_id := p0_a10;
1158 ddp_sys_parameters_rec.created_from := p0_a11;
1159 ddp_sys_parameters_rec.post_to_gl := p0_a12;
1160 ddp_sys_parameters_rec.transfer_to_gl_in := p0_a13;
1161 ddp_sys_parameters_rec.ap_payment_term_id := p0_a14;
1162 ddp_sys_parameters_rec.rounding_level_flag := p0_a15;
1163 ddp_sys_parameters_rec.gl_id_rounding := p0_a16;
1164 ddp_sys_parameters_rec.gl_id_ded_clearing := p0_a17;
1165 ddp_sys_parameters_rec.gl_id_ded_adj := p0_a18;
1166 ddp_sys_parameters_rec.gl_id_accr_promo_liab := p0_a19;
1167 ddp_sys_parameters_rec.gl_id_ded_adj_clearing := p0_a20;
1168 ddp_sys_parameters_rec.gl_rec_ded_account := p0_a21;
1169 ddp_sys_parameters_rec.gl_rec_clearing_account := p0_a22;
1170 ddp_sys_parameters_rec.gl_cost_adjustment_acct := p0_a23;
1171 ddp_sys_parameters_rec.gl_contra_liability_acct := p0_a24;
1172 ddp_sys_parameters_rec.gl_pp_accrual_acct := p0_a25;
1173 ddp_sys_parameters_rec.gl_date_type := p0_a26;
1174 ddp_sys_parameters_rec.days_due := p0_a27;
1175 ddp_sys_parameters_rec.claim_type_id := p0_a28;
1176 ddp_sys_parameters_rec.reason_code_id := p0_a29;
1180 ddp_sys_parameters_rec.autopay_periodicity := p0_a33;
1177 ddp_sys_parameters_rec.autopay_claim_type_id := p0_a30;
1178 ddp_sys_parameters_rec.autopay_reason_code_id := p0_a31;
1179 ddp_sys_parameters_rec.autopay_flag := p0_a32;
1181 ddp_sys_parameters_rec.autopay_periodicity_type := p0_a34;
1182 ddp_sys_parameters_rec.accounting_method_option := p0_a35;
1183 ddp_sys_parameters_rec.billback_trx_type_id := p0_a36;
1184 ddp_sys_parameters_rec.cm_trx_type_id := p0_a37;
1185 ddp_sys_parameters_rec.attribute_category := p0_a38;
1186 ddp_sys_parameters_rec.attribute1 := p0_a39;
1187 ddp_sys_parameters_rec.attribute2 := p0_a40;
1188 ddp_sys_parameters_rec.attribute3 := p0_a41;
1189 ddp_sys_parameters_rec.attribute4 := p0_a42;
1190 ddp_sys_parameters_rec.attribute5 := p0_a43;
1191 ddp_sys_parameters_rec.attribute6 := p0_a44;
1192 ddp_sys_parameters_rec.attribute7 := p0_a45;
1193 ddp_sys_parameters_rec.attribute8 := p0_a46;
1194 ddp_sys_parameters_rec.attribute9 := p0_a47;
1195 ddp_sys_parameters_rec.attribute10 := p0_a48;
1196 ddp_sys_parameters_rec.attribute11 := p0_a49;
1197 ddp_sys_parameters_rec.attribute12 := p0_a50;
1198 ddp_sys_parameters_rec.attribute13 := p0_a51;
1199 ddp_sys_parameters_rec.attribute14 := p0_a52;
1200 ddp_sys_parameters_rec.attribute15 := p0_a53;
1201 ddp_sys_parameters_rec.org_id := p0_a54;
1202 ddp_sys_parameters_rec.batch_source_id := p0_a55;
1203 ddp_sys_parameters_rec.payables_source := p0_a56;
1204 ddp_sys_parameters_rec.default_owner_id := p0_a57;
1205 ddp_sys_parameters_rec.auto_assign_flag := p0_a58;
1206 ddp_sys_parameters_rec.exchange_rate_type := p0_a59;
1207 ddp_sys_parameters_rec.order_type_id := p0_a60;
1208 ddp_sys_parameters_rec.gl_acct_for_offinv_flag := p0_a61;
1209 ddp_sys_parameters_rec.cb_trx_type_id := p0_a62;
1210 ddp_sys_parameters_rec.pos_write_off_threshold := p0_a63;
1211 ddp_sys_parameters_rec.neg_write_off_threshold := p0_a64;
1212 ddp_sys_parameters_rec.adj_rec_trx_id := p0_a65;
1213 ddp_sys_parameters_rec.wo_rec_trx_id := p0_a66;
1214 ddp_sys_parameters_rec.neg_wo_rec_trx_id := p0_a67;
1215 ddp_sys_parameters_rec.un_earned_pay_allow_to := p0_a68;
1216 ddp_sys_parameters_rec.un_earned_pay_thold_type := p0_a69;
1217 ddp_sys_parameters_rec.un_earned_pay_threshold := p0_a70;
1218 ddp_sys_parameters_rec.un_earned_pay_thold_flag := p0_a71;
1219 ddp_sys_parameters_rec.header_tolerance_calc_code := p0_a72;
1220 ddp_sys_parameters_rec.header_tolerance_operand := p0_a73;
1221 ddp_sys_parameters_rec.line_tolerance_calc_code := p0_a74;
1222 ddp_sys_parameters_rec.line_tolerance_operand := p0_a75;
1223 ddp_sys_parameters_rec.ship_debit_accrual_flag := p0_a76;
1224 ddp_sys_parameters_rec.ship_debit_calc_type := p0_a77;
1225 ddp_sys_parameters_rec.inventory_tracking_flag := p0_a78;
1226 ddp_sys_parameters_rec.end_cust_relation_flag := p0_a79;
1227 ddp_sys_parameters_rec.auto_tp_accrual_flag := p0_a80;
1228 ddp_sys_parameters_rec.gl_balancing_flex_value := p0_a81;
1229 ddp_sys_parameters_rec.prorate_earnings_flag := p0_a82;
1230 ddp_sys_parameters_rec.sales_credit_default_type := p0_a83;
1231 ddp_sys_parameters_rec.net_amt_for_mass_settle_flag := p0_a84;
1232 ddp_sys_parameters_rec.claim_tax_incl_flag := p0_a85;
1233 ddp_sys_parameters_rec.rule_based := p0_a86;
1234 ddp_sys_parameters_rec.approval_new_credit := p0_a87;
1235 ddp_sys_parameters_rec.approval_matched_credit := p0_a88;
1236 ddp_sys_parameters_rec.cust_name_match_type := p0_a89;
1237 ddp_sys_parameters_rec.credit_matching_thold_type := p0_a90;
1238 ddp_sys_parameters_rec.credit_tolerance_operand := p0_a91;
1239 ddp_sys_parameters_rec.automate_notification_days := p0_a92;
1240 ddp_sys_parameters_rec.ssd_inc_adj_type_id := p0_a93;
1241 ddp_sys_parameters_rec.ssd_dec_adj_type_id := p0_a94;
1242 ddp_sys_parameters_rec.ssd_imd_claim_flag := p0_a95;
1243
1244 ddp_complete_rec.set_of_books_id := p1_a0;
1245 ddp_complete_rec.object_version_number := p1_a1;
1246 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a2);
1247 ddp_complete_rec.last_updated_by := p1_a3;
1248 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a4);
1249 ddp_complete_rec.created_by := p1_a5;
1250 ddp_complete_rec.last_update_login := p1_a6;
1251 ddp_complete_rec.request_id := p1_a7;
1252 ddp_complete_rec.program_application_id := p1_a8;
1253 ddp_complete_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a9);
1254 ddp_complete_rec.program_id := p1_a10;
1255 ddp_complete_rec.created_from := p1_a11;
1256 ddp_complete_rec.post_to_gl := p1_a12;
1257 ddp_complete_rec.transfer_to_gl_in := p1_a13;
1258 ddp_complete_rec.ap_payment_term_id := p1_a14;
1259 ddp_complete_rec.rounding_level_flag := p1_a15;
1260 ddp_complete_rec.gl_id_rounding := p1_a16;
1261 ddp_complete_rec.gl_id_ded_clearing := p1_a17;
1262 ddp_complete_rec.gl_id_ded_adj := p1_a18;
1263 ddp_complete_rec.gl_id_accr_promo_liab := p1_a19;
1264 ddp_complete_rec.gl_id_ded_adj_clearing := p1_a20;
1265 ddp_complete_rec.gl_rec_ded_account := p1_a21;
1266 ddp_complete_rec.gl_rec_clearing_account := p1_a22;
1267 ddp_complete_rec.gl_cost_adjustment_acct := p1_a23;
1268 ddp_complete_rec.gl_contra_liability_acct := p1_a24;
1269 ddp_complete_rec.gl_pp_accrual_acct := p1_a25;
1270 ddp_complete_rec.gl_date_type := p1_a26;
1271 ddp_complete_rec.days_due := p1_a27;
1275 ddp_complete_rec.autopay_reason_code_id := p1_a31;
1272 ddp_complete_rec.claim_type_id := p1_a28;
1273 ddp_complete_rec.reason_code_id := p1_a29;
1274 ddp_complete_rec.autopay_claim_type_id := p1_a30;
1276 ddp_complete_rec.autopay_flag := p1_a32;
1277 ddp_complete_rec.autopay_periodicity := p1_a33;
1278 ddp_complete_rec.autopay_periodicity_type := p1_a34;
1279 ddp_complete_rec.accounting_method_option := p1_a35;
1280 ddp_complete_rec.billback_trx_type_id := p1_a36;
1281 ddp_complete_rec.cm_trx_type_id := p1_a37;
1282 ddp_complete_rec.attribute_category := p1_a38;
1283 ddp_complete_rec.attribute1 := p1_a39;
1284 ddp_complete_rec.attribute2 := p1_a40;
1285 ddp_complete_rec.attribute3 := p1_a41;
1286 ddp_complete_rec.attribute4 := p1_a42;
1287 ddp_complete_rec.attribute5 := p1_a43;
1288 ddp_complete_rec.attribute6 := p1_a44;
1289 ddp_complete_rec.attribute7 := p1_a45;
1290 ddp_complete_rec.attribute8 := p1_a46;
1291 ddp_complete_rec.attribute9 := p1_a47;
1292 ddp_complete_rec.attribute10 := p1_a48;
1293 ddp_complete_rec.attribute11 := p1_a49;
1294 ddp_complete_rec.attribute12 := p1_a50;
1295 ddp_complete_rec.attribute13 := p1_a51;
1296 ddp_complete_rec.attribute14 := p1_a52;
1297 ddp_complete_rec.attribute15 := p1_a53;
1298 ddp_complete_rec.org_id := p1_a54;
1299 ddp_complete_rec.batch_source_id := p1_a55;
1300 ddp_complete_rec.payables_source := p1_a56;
1301 ddp_complete_rec.default_owner_id := p1_a57;
1302 ddp_complete_rec.auto_assign_flag := p1_a58;
1303 ddp_complete_rec.exchange_rate_type := p1_a59;
1304 ddp_complete_rec.order_type_id := p1_a60;
1305 ddp_complete_rec.gl_acct_for_offinv_flag := p1_a61;
1306 ddp_complete_rec.cb_trx_type_id := p1_a62;
1307 ddp_complete_rec.pos_write_off_threshold := p1_a63;
1308 ddp_complete_rec.neg_write_off_threshold := p1_a64;
1309 ddp_complete_rec.adj_rec_trx_id := p1_a65;
1310 ddp_complete_rec.wo_rec_trx_id := p1_a66;
1311 ddp_complete_rec.neg_wo_rec_trx_id := p1_a67;
1312 ddp_complete_rec.un_earned_pay_allow_to := p1_a68;
1313 ddp_complete_rec.un_earned_pay_thold_type := p1_a69;
1314 ddp_complete_rec.un_earned_pay_threshold := p1_a70;
1315 ddp_complete_rec.un_earned_pay_thold_flag := p1_a71;
1316 ddp_complete_rec.header_tolerance_calc_code := p1_a72;
1317 ddp_complete_rec.header_tolerance_operand := p1_a73;
1318 ddp_complete_rec.line_tolerance_calc_code := p1_a74;
1319 ddp_complete_rec.line_tolerance_operand := p1_a75;
1320 ddp_complete_rec.ship_debit_accrual_flag := p1_a76;
1321 ddp_complete_rec.ship_debit_calc_type := p1_a77;
1322 ddp_complete_rec.inventory_tracking_flag := p1_a78;
1323 ddp_complete_rec.end_cust_relation_flag := p1_a79;
1324 ddp_complete_rec.auto_tp_accrual_flag := p1_a80;
1325 ddp_complete_rec.gl_balancing_flex_value := p1_a81;
1326 ddp_complete_rec.prorate_earnings_flag := p1_a82;
1327 ddp_complete_rec.sales_credit_default_type := p1_a83;
1328 ddp_complete_rec.net_amt_for_mass_settle_flag := p1_a84;
1329 ddp_complete_rec.claim_tax_incl_flag := p1_a85;
1330 ddp_complete_rec.rule_based := p1_a86;
1331 ddp_complete_rec.approval_new_credit := p1_a87;
1332 ddp_complete_rec.approval_matched_credit := p1_a88;
1333 ddp_complete_rec.cust_name_match_type := p1_a89;
1334 ddp_complete_rec.credit_matching_thold_type := p1_a90;
1335 ddp_complete_rec.credit_tolerance_operand := p1_a91;
1336 ddp_complete_rec.automate_notification_days := p1_a92;
1337 ddp_complete_rec.ssd_inc_adj_type_id := p1_a93;
1338 ddp_complete_rec.ssd_dec_adj_type_id := p1_a94;
1339 ddp_complete_rec.ssd_imd_claim_flag := p1_a95;
1340
1341
1342
1343 -- here's the delegated call to the old PL/SQL routine
1344 ozf_sys_parameters_pvt.check_sys_parameters_record(ddp_sys_parameters_rec,
1345 ddp_complete_rec,
1346 p_mode,
1347 x_return_status);
1348
1349 -- copy data back from the local variables to OUT or IN-OUT args, if any
1350
1351
1352
1353 end;
1354
1355 procedure init_sys_parameters_rec(p0_a0 out nocopy NUMBER
1356 , p0_a1 out nocopy NUMBER
1357 , p0_a2 out nocopy DATE
1358 , p0_a3 out nocopy NUMBER
1359 , p0_a4 out nocopy DATE
1360 , p0_a5 out nocopy NUMBER
1361 , p0_a6 out nocopy NUMBER
1362 , p0_a7 out nocopy NUMBER
1363 , p0_a8 out nocopy NUMBER
1364 , p0_a9 out nocopy DATE
1365 , p0_a10 out nocopy NUMBER
1366 , p0_a11 out nocopy VARCHAR2
1367 , p0_a12 out nocopy VARCHAR2
1368 , p0_a13 out nocopy VARCHAR2
1369 , p0_a14 out nocopy NUMBER
1370 , p0_a15 out nocopy VARCHAR2
1371 , p0_a16 out nocopy NUMBER
1372 , p0_a17 out nocopy NUMBER
1373 , p0_a18 out nocopy NUMBER
1374 , p0_a19 out nocopy NUMBER
1375 , p0_a20 out nocopy NUMBER
1376 , p0_a21 out nocopy NUMBER
1377 , p0_a22 out nocopy NUMBER
1378 , p0_a23 out nocopy NUMBER
1379 , p0_a24 out nocopy NUMBER
1380 , p0_a25 out nocopy NUMBER
1381 , p0_a26 out nocopy VARCHAR2
1382 , p0_a27 out nocopy NUMBER
1383 , p0_a28 out nocopy NUMBER
1384 , p0_a29 out nocopy NUMBER
1385 , p0_a30 out nocopy NUMBER
1386 , p0_a31 out nocopy NUMBER
1387 , p0_a32 out nocopy VARCHAR2
1388 , p0_a33 out nocopy NUMBER
1389 , p0_a34 out nocopy VARCHAR2
1390 , p0_a35 out nocopy VARCHAR2
1391 , p0_a36 out nocopy NUMBER
1392 , p0_a37 out nocopy NUMBER
1393 , p0_a38 out nocopy VARCHAR2
1394 , p0_a39 out nocopy VARCHAR2
1398 , p0_a43 out nocopy VARCHAR2
1395 , p0_a40 out nocopy VARCHAR2
1396 , p0_a41 out nocopy VARCHAR2
1397 , p0_a42 out nocopy VARCHAR2
1399 , p0_a44 out nocopy VARCHAR2
1400 , p0_a45 out nocopy VARCHAR2
1401 , p0_a46 out nocopy VARCHAR2
1402 , p0_a47 out nocopy VARCHAR2
1403 , p0_a48 out nocopy VARCHAR2
1404 , p0_a49 out nocopy VARCHAR2
1405 , p0_a50 out nocopy VARCHAR2
1406 , p0_a51 out nocopy VARCHAR2
1407 , p0_a52 out nocopy VARCHAR2
1408 , p0_a53 out nocopy VARCHAR2
1409 , p0_a54 out nocopy NUMBER
1410 , p0_a55 out nocopy NUMBER
1411 , p0_a56 out nocopy VARCHAR2
1412 , p0_a57 out nocopy NUMBER
1413 , p0_a58 out nocopy VARCHAR2
1414 , p0_a59 out nocopy VARCHAR2
1415 , p0_a60 out nocopy NUMBER
1416 , p0_a61 out nocopy VARCHAR2
1417 , p0_a62 out nocopy NUMBER
1418 , p0_a63 out nocopy NUMBER
1419 , p0_a64 out nocopy NUMBER
1420 , p0_a65 out nocopy NUMBER
1421 , p0_a66 out nocopy NUMBER
1422 , p0_a67 out nocopy NUMBER
1423 , p0_a68 out nocopy VARCHAR2
1424 , p0_a69 out nocopy VARCHAR2
1425 , p0_a70 out nocopy NUMBER
1426 , p0_a71 out nocopy VARCHAR2
1427 , p0_a72 out nocopy VARCHAR2
1428 , p0_a73 out nocopy NUMBER
1429 , p0_a74 out nocopy VARCHAR2
1430 , p0_a75 out nocopy NUMBER
1431 , p0_a76 out nocopy VARCHAR2
1432 , p0_a77 out nocopy VARCHAR2
1433 , p0_a78 out nocopy VARCHAR2
1434 , p0_a79 out nocopy VARCHAR2
1435 , p0_a80 out nocopy VARCHAR2
1436 , p0_a81 out nocopy VARCHAR2
1437 , p0_a82 out nocopy VARCHAR2
1438 , p0_a83 out nocopy VARCHAR2
1439 , p0_a84 out nocopy VARCHAR2
1440 , p0_a85 out nocopy VARCHAR2
1441 , p0_a86 out nocopy VARCHAR2
1442 , p0_a87 out nocopy VARCHAR2
1443 , p0_a88 out nocopy VARCHAR2
1444 , p0_a89 out nocopy VARCHAR2
1445 , p0_a90 out nocopy VARCHAR2
1446 , p0_a91 out nocopy NUMBER
1447 , p0_a92 out nocopy NUMBER
1448 , p0_a93 out nocopy NUMBER
1449 , p0_a94 out nocopy NUMBER
1450 , p0_a95 out nocopy VARCHAR2
1451 )
1452
1453 as
1454 ddx_sys_parameters_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
1455 ddindx binary_integer; indx binary_integer;
1456 begin
1457
1458 -- copy data to the local IN or IN-OUT args, if any
1459
1460 -- here's the delegated call to the old PL/SQL routine
1461 ozf_sys_parameters_pvt.init_sys_parameters_rec(ddx_sys_parameters_rec);
1462
1463 -- copy data back from the local variables to OUT or IN-OUT args, if any
1464 p0_a0 := ddx_sys_parameters_rec.set_of_books_id;
1465 p0_a1 := ddx_sys_parameters_rec.object_version_number;
1466 p0_a2 := ddx_sys_parameters_rec.last_update_date;
1467 p0_a3 := ddx_sys_parameters_rec.last_updated_by;
1468 p0_a4 := ddx_sys_parameters_rec.creation_date;
1469 p0_a5 := ddx_sys_parameters_rec.created_by;
1470 p0_a6 := ddx_sys_parameters_rec.last_update_login;
1471 p0_a7 := ddx_sys_parameters_rec.request_id;
1472 p0_a8 := ddx_sys_parameters_rec.program_application_id;
1473 p0_a9 := ddx_sys_parameters_rec.program_update_date;
1474 p0_a10 := ddx_sys_parameters_rec.program_id;
1475 p0_a11 := ddx_sys_parameters_rec.created_from;
1476 p0_a12 := ddx_sys_parameters_rec.post_to_gl;
1477 p0_a13 := ddx_sys_parameters_rec.transfer_to_gl_in;
1478 p0_a14 := ddx_sys_parameters_rec.ap_payment_term_id;
1479 p0_a15 := ddx_sys_parameters_rec.rounding_level_flag;
1480 p0_a16 := ddx_sys_parameters_rec.gl_id_rounding;
1481 p0_a17 := ddx_sys_parameters_rec.gl_id_ded_clearing;
1482 p0_a18 := ddx_sys_parameters_rec.gl_id_ded_adj;
1483 p0_a19 := ddx_sys_parameters_rec.gl_id_accr_promo_liab;
1484 p0_a20 := ddx_sys_parameters_rec.gl_id_ded_adj_clearing;
1485 p0_a21 := ddx_sys_parameters_rec.gl_rec_ded_account;
1486 p0_a22 := ddx_sys_parameters_rec.gl_rec_clearing_account;
1487 p0_a23 := ddx_sys_parameters_rec.gl_cost_adjustment_acct;
1488 p0_a24 := ddx_sys_parameters_rec.gl_contra_liability_acct;
1489 p0_a25 := ddx_sys_parameters_rec.gl_pp_accrual_acct;
1490 p0_a26 := ddx_sys_parameters_rec.gl_date_type;
1491 p0_a27 := ddx_sys_parameters_rec.days_due;
1492 p0_a28 := ddx_sys_parameters_rec.claim_type_id;
1493 p0_a29 := ddx_sys_parameters_rec.reason_code_id;
1494 p0_a30 := ddx_sys_parameters_rec.autopay_claim_type_id;
1495 p0_a31 := ddx_sys_parameters_rec.autopay_reason_code_id;
1496 p0_a32 := ddx_sys_parameters_rec.autopay_flag;
1497 p0_a33 := ddx_sys_parameters_rec.autopay_periodicity;
1498 p0_a34 := ddx_sys_parameters_rec.autopay_periodicity_type;
1499 p0_a35 := ddx_sys_parameters_rec.accounting_method_option;
1500 p0_a36 := ddx_sys_parameters_rec.billback_trx_type_id;
1501 p0_a37 := ddx_sys_parameters_rec.cm_trx_type_id;
1502 p0_a38 := ddx_sys_parameters_rec.attribute_category;
1503 p0_a39 := ddx_sys_parameters_rec.attribute1;
1504 p0_a40 := ddx_sys_parameters_rec.attribute2;
1505 p0_a41 := ddx_sys_parameters_rec.attribute3;
1506 p0_a42 := ddx_sys_parameters_rec.attribute4;
1507 p0_a43 := ddx_sys_parameters_rec.attribute5;
1508 p0_a44 := ddx_sys_parameters_rec.attribute6;
1509 p0_a45 := ddx_sys_parameters_rec.attribute7;
1510 p0_a46 := ddx_sys_parameters_rec.attribute8;
1514 p0_a50 := ddx_sys_parameters_rec.attribute12;
1511 p0_a47 := ddx_sys_parameters_rec.attribute9;
1512 p0_a48 := ddx_sys_parameters_rec.attribute10;
1513 p0_a49 := ddx_sys_parameters_rec.attribute11;
1515 p0_a51 := ddx_sys_parameters_rec.attribute13;
1516 p0_a52 := ddx_sys_parameters_rec.attribute14;
1517 p0_a53 := ddx_sys_parameters_rec.attribute15;
1518 p0_a54 := ddx_sys_parameters_rec.org_id;
1519 p0_a55 := ddx_sys_parameters_rec.batch_source_id;
1520 p0_a56 := ddx_sys_parameters_rec.payables_source;
1521 p0_a57 := ddx_sys_parameters_rec.default_owner_id;
1522 p0_a58 := ddx_sys_parameters_rec.auto_assign_flag;
1523 p0_a59 := ddx_sys_parameters_rec.exchange_rate_type;
1524 p0_a60 := ddx_sys_parameters_rec.order_type_id;
1525 p0_a61 := ddx_sys_parameters_rec.gl_acct_for_offinv_flag;
1526 p0_a62 := ddx_sys_parameters_rec.cb_trx_type_id;
1527 p0_a63 := ddx_sys_parameters_rec.pos_write_off_threshold;
1528 p0_a64 := ddx_sys_parameters_rec.neg_write_off_threshold;
1529 p0_a65 := ddx_sys_parameters_rec.adj_rec_trx_id;
1530 p0_a66 := ddx_sys_parameters_rec.wo_rec_trx_id;
1531 p0_a67 := ddx_sys_parameters_rec.neg_wo_rec_trx_id;
1532 p0_a68 := ddx_sys_parameters_rec.un_earned_pay_allow_to;
1533 p0_a69 := ddx_sys_parameters_rec.un_earned_pay_thold_type;
1534 p0_a70 := ddx_sys_parameters_rec.un_earned_pay_threshold;
1535 p0_a71 := ddx_sys_parameters_rec.un_earned_pay_thold_flag;
1536 p0_a72 := ddx_sys_parameters_rec.header_tolerance_calc_code;
1537 p0_a73 := ddx_sys_parameters_rec.header_tolerance_operand;
1538 p0_a74 := ddx_sys_parameters_rec.line_tolerance_calc_code;
1539 p0_a75 := ddx_sys_parameters_rec.line_tolerance_operand;
1540 p0_a76 := ddx_sys_parameters_rec.ship_debit_accrual_flag;
1541 p0_a77 := ddx_sys_parameters_rec.ship_debit_calc_type;
1542 p0_a78 := ddx_sys_parameters_rec.inventory_tracking_flag;
1543 p0_a79 := ddx_sys_parameters_rec.end_cust_relation_flag;
1544 p0_a80 := ddx_sys_parameters_rec.auto_tp_accrual_flag;
1545 p0_a81 := ddx_sys_parameters_rec.gl_balancing_flex_value;
1546 p0_a82 := ddx_sys_parameters_rec.prorate_earnings_flag;
1547 p0_a83 := ddx_sys_parameters_rec.sales_credit_default_type;
1548 p0_a84 := ddx_sys_parameters_rec.net_amt_for_mass_settle_flag;
1549 p0_a85 := ddx_sys_parameters_rec.claim_tax_incl_flag;
1550 p0_a86 := ddx_sys_parameters_rec.rule_based;
1551 p0_a87 := ddx_sys_parameters_rec.approval_new_credit;
1552 p0_a88 := ddx_sys_parameters_rec.approval_matched_credit;
1553 p0_a89 := ddx_sys_parameters_rec.cust_name_match_type;
1554 p0_a90 := ddx_sys_parameters_rec.credit_matching_thold_type;
1555 p0_a91 := ddx_sys_parameters_rec.credit_tolerance_operand;
1556 p0_a92 := ddx_sys_parameters_rec.automate_notification_days;
1557 p0_a93 := ddx_sys_parameters_rec.ssd_inc_adj_type_id;
1558 p0_a94 := ddx_sys_parameters_rec.ssd_dec_adj_type_id;
1559 p0_a95 := ddx_sys_parameters_rec.ssd_imd_claim_flag;
1560 end;
1561
1562 procedure complete_sys_parameters_rec(p0_a0 NUMBER
1563 , p0_a1 NUMBER
1564 , p0_a2 DATE
1565 , p0_a3 NUMBER
1566 , p0_a4 DATE
1567 , p0_a5 NUMBER
1568 , p0_a6 NUMBER
1569 , p0_a7 NUMBER
1570 , p0_a8 NUMBER
1571 , p0_a9 DATE
1572 , p0_a10 NUMBER
1573 , p0_a11 VARCHAR2
1574 , p0_a12 VARCHAR2
1575 , p0_a13 VARCHAR2
1576 , p0_a14 NUMBER
1577 , p0_a15 VARCHAR2
1578 , p0_a16 NUMBER
1579 , p0_a17 NUMBER
1580 , p0_a18 NUMBER
1581 , p0_a19 NUMBER
1582 , p0_a20 NUMBER
1583 , p0_a21 NUMBER
1584 , p0_a22 NUMBER
1585 , p0_a23 NUMBER
1586 , p0_a24 NUMBER
1587 , p0_a25 NUMBER
1588 , p0_a26 VARCHAR2
1589 , p0_a27 NUMBER
1590 , p0_a28 NUMBER
1591 , p0_a29 NUMBER
1592 , p0_a30 NUMBER
1593 , p0_a31 NUMBER
1594 , p0_a32 VARCHAR2
1595 , p0_a33 NUMBER
1596 , p0_a34 VARCHAR2
1597 , p0_a35 VARCHAR2
1598 , p0_a36 NUMBER
1599 , p0_a37 NUMBER
1600 , p0_a38 VARCHAR2
1601 , p0_a39 VARCHAR2
1602 , p0_a40 VARCHAR2
1603 , p0_a41 VARCHAR2
1604 , p0_a42 VARCHAR2
1605 , p0_a43 VARCHAR2
1606 , p0_a44 VARCHAR2
1607 , p0_a45 VARCHAR2
1608 , p0_a46 VARCHAR2
1609 , p0_a47 VARCHAR2
1610 , p0_a48 VARCHAR2
1611 , p0_a49 VARCHAR2
1612 , p0_a50 VARCHAR2
1613 , p0_a51 VARCHAR2
1614 , p0_a52 VARCHAR2
1615 , p0_a53 VARCHAR2
1616 , p0_a54 NUMBER
1617 , p0_a55 NUMBER
1618 , p0_a56 VARCHAR2
1619 , p0_a57 NUMBER
1620 , p0_a58 VARCHAR2
1621 , p0_a59 VARCHAR2
1622 , p0_a60 NUMBER
1623 , p0_a61 VARCHAR2
1624 , p0_a62 NUMBER
1625 , p0_a63 NUMBER
1626 , p0_a64 NUMBER
1627 , p0_a65 NUMBER
1628 , p0_a66 NUMBER
1629 , p0_a67 NUMBER
1630 , p0_a68 VARCHAR2
1631 , p0_a69 VARCHAR2
1632 , p0_a70 NUMBER
1633 , p0_a71 VARCHAR2
1634 , p0_a72 VARCHAR2
1635 , p0_a73 NUMBER
1636 , p0_a74 VARCHAR2
1637 , p0_a75 NUMBER
1638 , p0_a76 VARCHAR2
1639 , p0_a77 VARCHAR2
1640 , p0_a78 VARCHAR2
1641 , p0_a79 VARCHAR2
1642 , p0_a80 VARCHAR2
1643 , p0_a81 VARCHAR2
1644 , p0_a82 VARCHAR2
1645 , p0_a83 VARCHAR2
1646 , p0_a84 VARCHAR2
1647 , p0_a85 VARCHAR2
1648 , p0_a86 VARCHAR2
1652 , p0_a90 VARCHAR2
1649 , p0_a87 VARCHAR2
1650 , p0_a88 VARCHAR2
1651 , p0_a89 VARCHAR2
1653 , p0_a91 NUMBER
1654 , p0_a92 NUMBER
1655 , p0_a93 NUMBER
1656 , p0_a94 NUMBER
1657 , p0_a95 VARCHAR2
1658 , p1_a0 out nocopy NUMBER
1659 , p1_a1 out nocopy NUMBER
1660 , p1_a2 out nocopy DATE
1661 , p1_a3 out nocopy NUMBER
1662 , p1_a4 out nocopy DATE
1663 , p1_a5 out nocopy NUMBER
1664 , p1_a6 out nocopy NUMBER
1665 , p1_a7 out nocopy NUMBER
1666 , p1_a8 out nocopy NUMBER
1667 , p1_a9 out nocopy DATE
1668 , p1_a10 out nocopy NUMBER
1669 , p1_a11 out nocopy VARCHAR2
1670 , p1_a12 out nocopy VARCHAR2
1671 , p1_a13 out nocopy VARCHAR2
1672 , p1_a14 out nocopy NUMBER
1673 , p1_a15 out nocopy VARCHAR2
1674 , p1_a16 out nocopy NUMBER
1675 , p1_a17 out nocopy NUMBER
1676 , p1_a18 out nocopy NUMBER
1677 , p1_a19 out nocopy NUMBER
1678 , p1_a20 out nocopy NUMBER
1679 , p1_a21 out nocopy NUMBER
1680 , p1_a22 out nocopy NUMBER
1681 , p1_a23 out nocopy NUMBER
1682 , p1_a24 out nocopy NUMBER
1683 , p1_a25 out nocopy NUMBER
1684 , p1_a26 out nocopy VARCHAR2
1685 , p1_a27 out nocopy NUMBER
1686 , p1_a28 out nocopy NUMBER
1687 , p1_a29 out nocopy NUMBER
1688 , p1_a30 out nocopy NUMBER
1689 , p1_a31 out nocopy NUMBER
1690 , p1_a32 out nocopy VARCHAR2
1691 , p1_a33 out nocopy NUMBER
1692 , p1_a34 out nocopy VARCHAR2
1693 , p1_a35 out nocopy VARCHAR2
1694 , p1_a36 out nocopy NUMBER
1695 , p1_a37 out nocopy NUMBER
1696 , p1_a38 out nocopy VARCHAR2
1697 , p1_a39 out nocopy VARCHAR2
1698 , p1_a40 out nocopy VARCHAR2
1699 , p1_a41 out nocopy VARCHAR2
1700 , p1_a42 out nocopy VARCHAR2
1701 , p1_a43 out nocopy VARCHAR2
1702 , p1_a44 out nocopy VARCHAR2
1703 , p1_a45 out nocopy VARCHAR2
1704 , p1_a46 out nocopy VARCHAR2
1705 , p1_a47 out nocopy VARCHAR2
1706 , p1_a48 out nocopy VARCHAR2
1707 , p1_a49 out nocopy VARCHAR2
1708 , p1_a50 out nocopy VARCHAR2
1709 , p1_a51 out nocopy VARCHAR2
1710 , p1_a52 out nocopy VARCHAR2
1711 , p1_a53 out nocopy VARCHAR2
1712 , p1_a54 out nocopy NUMBER
1713 , p1_a55 out nocopy NUMBER
1714 , p1_a56 out nocopy VARCHAR2
1715 , p1_a57 out nocopy NUMBER
1716 , p1_a58 out nocopy VARCHAR2
1717 , p1_a59 out nocopy VARCHAR2
1718 , p1_a60 out nocopy NUMBER
1719 , p1_a61 out nocopy VARCHAR2
1720 , p1_a62 out nocopy NUMBER
1721 , p1_a63 out nocopy NUMBER
1722 , p1_a64 out nocopy NUMBER
1723 , p1_a65 out nocopy NUMBER
1724 , p1_a66 out nocopy NUMBER
1725 , p1_a67 out nocopy NUMBER
1726 , p1_a68 out nocopy VARCHAR2
1727 , p1_a69 out nocopy VARCHAR2
1728 , p1_a70 out nocopy NUMBER
1729 , p1_a71 out nocopy VARCHAR2
1730 , p1_a72 out nocopy VARCHAR2
1731 , p1_a73 out nocopy NUMBER
1732 , p1_a74 out nocopy VARCHAR2
1733 , p1_a75 out nocopy NUMBER
1734 , p1_a76 out nocopy VARCHAR2
1735 , p1_a77 out nocopy VARCHAR2
1736 , p1_a78 out nocopy VARCHAR2
1737 , p1_a79 out nocopy VARCHAR2
1738 , p1_a80 out nocopy VARCHAR2
1739 , p1_a81 out nocopy VARCHAR2
1740 , p1_a82 out nocopy VARCHAR2
1741 , p1_a83 out nocopy VARCHAR2
1742 , p1_a84 out nocopy VARCHAR2
1743 , p1_a85 out nocopy VARCHAR2
1744 , p1_a86 out nocopy VARCHAR2
1745 , p1_a87 out nocopy VARCHAR2
1746 , p1_a88 out nocopy VARCHAR2
1747 , p1_a89 out nocopy VARCHAR2
1748 , p1_a90 out nocopy VARCHAR2
1749 , p1_a91 out nocopy NUMBER
1750 , p1_a92 out nocopy NUMBER
1751 , p1_a93 out nocopy NUMBER
1752 , p1_a94 out nocopy NUMBER
1753 , p1_a95 out nocopy VARCHAR2
1754 )
1755
1756 as
1757 ddp_sys_parameters_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
1758 ddx_complete_rec ozf_sys_parameters_pvt.sys_parameters_rec_type;
1759 ddindx binary_integer; indx binary_integer;
1760 begin
1761
1762 -- copy data to the local IN or IN-OUT args, if any
1763 ddp_sys_parameters_rec.set_of_books_id := p0_a0;
1764 ddp_sys_parameters_rec.object_version_number := p0_a1;
1765 ddp_sys_parameters_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
1766 ddp_sys_parameters_rec.last_updated_by := p0_a3;
1767 ddp_sys_parameters_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
1768 ddp_sys_parameters_rec.created_by := p0_a5;
1769 ddp_sys_parameters_rec.last_update_login := p0_a6;
1770 ddp_sys_parameters_rec.request_id := p0_a7;
1771 ddp_sys_parameters_rec.program_application_id := p0_a8;
1772 ddp_sys_parameters_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a9);
1773 ddp_sys_parameters_rec.program_id := p0_a10;
1774 ddp_sys_parameters_rec.created_from := p0_a11;
1775 ddp_sys_parameters_rec.post_to_gl := p0_a12;
1776 ddp_sys_parameters_rec.transfer_to_gl_in := p0_a13;
1777 ddp_sys_parameters_rec.ap_payment_term_id := p0_a14;
1778 ddp_sys_parameters_rec.rounding_level_flag := p0_a15;
1779 ddp_sys_parameters_rec.gl_id_rounding := p0_a16;
1780 ddp_sys_parameters_rec.gl_id_ded_clearing := p0_a17;
1784 ddp_sys_parameters_rec.gl_rec_ded_account := p0_a21;
1781 ddp_sys_parameters_rec.gl_id_ded_adj := p0_a18;
1782 ddp_sys_parameters_rec.gl_id_accr_promo_liab := p0_a19;
1783 ddp_sys_parameters_rec.gl_id_ded_adj_clearing := p0_a20;
1785 ddp_sys_parameters_rec.gl_rec_clearing_account := p0_a22;
1786 ddp_sys_parameters_rec.gl_cost_adjustment_acct := p0_a23;
1787 ddp_sys_parameters_rec.gl_contra_liability_acct := p0_a24;
1788 ddp_sys_parameters_rec.gl_pp_accrual_acct := p0_a25;
1789 ddp_sys_parameters_rec.gl_date_type := p0_a26;
1790 ddp_sys_parameters_rec.days_due := p0_a27;
1791 ddp_sys_parameters_rec.claim_type_id := p0_a28;
1792 ddp_sys_parameters_rec.reason_code_id := p0_a29;
1793 ddp_sys_parameters_rec.autopay_claim_type_id := p0_a30;
1794 ddp_sys_parameters_rec.autopay_reason_code_id := p0_a31;
1795 ddp_sys_parameters_rec.autopay_flag := p0_a32;
1796 ddp_sys_parameters_rec.autopay_periodicity := p0_a33;
1797 ddp_sys_parameters_rec.autopay_periodicity_type := p0_a34;
1798 ddp_sys_parameters_rec.accounting_method_option := p0_a35;
1799 ddp_sys_parameters_rec.billback_trx_type_id := p0_a36;
1800 ddp_sys_parameters_rec.cm_trx_type_id := p0_a37;
1801 ddp_sys_parameters_rec.attribute_category := p0_a38;
1802 ddp_sys_parameters_rec.attribute1 := p0_a39;
1803 ddp_sys_parameters_rec.attribute2 := p0_a40;
1804 ddp_sys_parameters_rec.attribute3 := p0_a41;
1805 ddp_sys_parameters_rec.attribute4 := p0_a42;
1806 ddp_sys_parameters_rec.attribute5 := p0_a43;
1807 ddp_sys_parameters_rec.attribute6 := p0_a44;
1808 ddp_sys_parameters_rec.attribute7 := p0_a45;
1809 ddp_sys_parameters_rec.attribute8 := p0_a46;
1810 ddp_sys_parameters_rec.attribute9 := p0_a47;
1811 ddp_sys_parameters_rec.attribute10 := p0_a48;
1812 ddp_sys_parameters_rec.attribute11 := p0_a49;
1813 ddp_sys_parameters_rec.attribute12 := p0_a50;
1814 ddp_sys_parameters_rec.attribute13 := p0_a51;
1815 ddp_sys_parameters_rec.attribute14 := p0_a52;
1816 ddp_sys_parameters_rec.attribute15 := p0_a53;
1817 ddp_sys_parameters_rec.org_id := p0_a54;
1818 ddp_sys_parameters_rec.batch_source_id := p0_a55;
1819 ddp_sys_parameters_rec.payables_source := p0_a56;
1820 ddp_sys_parameters_rec.default_owner_id := p0_a57;
1821 ddp_sys_parameters_rec.auto_assign_flag := p0_a58;
1822 ddp_sys_parameters_rec.exchange_rate_type := p0_a59;
1823 ddp_sys_parameters_rec.order_type_id := p0_a60;
1824 ddp_sys_parameters_rec.gl_acct_for_offinv_flag := p0_a61;
1825 ddp_sys_parameters_rec.cb_trx_type_id := p0_a62;
1826 ddp_sys_parameters_rec.pos_write_off_threshold := p0_a63;
1827 ddp_sys_parameters_rec.neg_write_off_threshold := p0_a64;
1828 ddp_sys_parameters_rec.adj_rec_trx_id := p0_a65;
1829 ddp_sys_parameters_rec.wo_rec_trx_id := p0_a66;
1830 ddp_sys_parameters_rec.neg_wo_rec_trx_id := p0_a67;
1831 ddp_sys_parameters_rec.un_earned_pay_allow_to := p0_a68;
1832 ddp_sys_parameters_rec.un_earned_pay_thold_type := p0_a69;
1833 ddp_sys_parameters_rec.un_earned_pay_threshold := p0_a70;
1834 ddp_sys_parameters_rec.un_earned_pay_thold_flag := p0_a71;
1835 ddp_sys_parameters_rec.header_tolerance_calc_code := p0_a72;
1839 ddp_sys_parameters_rec.ship_debit_accrual_flag := p0_a76;
1836 ddp_sys_parameters_rec.header_tolerance_operand := p0_a73;
1837 ddp_sys_parameters_rec.line_tolerance_calc_code := p0_a74;
1838 ddp_sys_parameters_rec.line_tolerance_operand := p0_a75;
1840 ddp_sys_parameters_rec.ship_debit_calc_type := p0_a77;
1841 ddp_sys_parameters_rec.inventory_tracking_flag := p0_a78;
1842 ddp_sys_parameters_rec.end_cust_relation_flag := p0_a79;
1843 ddp_sys_parameters_rec.auto_tp_accrual_flag := p0_a80;
1844 ddp_sys_parameters_rec.gl_balancing_flex_value := p0_a81;
1845 ddp_sys_parameters_rec.prorate_earnings_flag := p0_a82;
1846 ddp_sys_parameters_rec.sales_credit_default_type := p0_a83;
1847 ddp_sys_parameters_rec.net_amt_for_mass_settle_flag := p0_a84;
1848 ddp_sys_parameters_rec.claim_tax_incl_flag := p0_a85;
1849 ddp_sys_parameters_rec.rule_based := p0_a86;
1850 ddp_sys_parameters_rec.approval_new_credit := p0_a87;
1851 ddp_sys_parameters_rec.approval_matched_credit := p0_a88;
1852 ddp_sys_parameters_rec.cust_name_match_type := p0_a89;
1853 ddp_sys_parameters_rec.credit_matching_thold_type := p0_a90;
1854 ddp_sys_parameters_rec.credit_tolerance_operand := p0_a91;
1855 ddp_sys_parameters_rec.automate_notification_days := p0_a92;
1856 ddp_sys_parameters_rec.ssd_inc_adj_type_id := p0_a93;
1857 ddp_sys_parameters_rec.ssd_dec_adj_type_id := p0_a94;
1858 ddp_sys_parameters_rec.ssd_imd_claim_flag := p0_a95;
1859
1860
1861 -- here's the delegated call to the old PL/SQL routine
1862 ozf_sys_parameters_pvt.complete_sys_parameters_rec(ddp_sys_parameters_rec,
1863 ddx_complete_rec);
1864
1865 -- copy data back from the local variables to OUT or IN-OUT args, if any
1866
1867 p1_a0 := ddx_complete_rec.set_of_books_id;
1868 p1_a1 := ddx_complete_rec.object_version_number;
1869 p1_a2 := ddx_complete_rec.last_update_date;
1870 p1_a3 := ddx_complete_rec.last_updated_by;
1871 p1_a4 := ddx_complete_rec.creation_date;
1872 p1_a5 := ddx_complete_rec.created_by;
1873 p1_a6 := ddx_complete_rec.last_update_login;
1874 p1_a7 := ddx_complete_rec.request_id;
1875 p1_a8 := ddx_complete_rec.program_application_id;
1876 p1_a9 := ddx_complete_rec.program_update_date;
1877 p1_a10 := ddx_complete_rec.program_id;
1878 p1_a11 := ddx_complete_rec.created_from;
1879 p1_a12 := ddx_complete_rec.post_to_gl;
1880 p1_a13 := ddx_complete_rec.transfer_to_gl_in;
1881 p1_a14 := ddx_complete_rec.ap_payment_term_id;
1882 p1_a15 := ddx_complete_rec.rounding_level_flag;
1883 p1_a16 := ddx_complete_rec.gl_id_rounding;
1884 p1_a17 := ddx_complete_rec.gl_id_ded_clearing;
1885 p1_a18 := ddx_complete_rec.gl_id_ded_adj;
1886 p1_a19 := ddx_complete_rec.gl_id_accr_promo_liab;
1887 p1_a20 := ddx_complete_rec.gl_id_ded_adj_clearing;
1888 p1_a21 := ddx_complete_rec.gl_rec_ded_account;
1889 p1_a22 := ddx_complete_rec.gl_rec_clearing_account;
1890 p1_a23 := ddx_complete_rec.gl_cost_adjustment_acct;
1891 p1_a24 := ddx_complete_rec.gl_contra_liability_acct;
1892 p1_a25 := ddx_complete_rec.gl_pp_accrual_acct;
1893 p1_a26 := ddx_complete_rec.gl_date_type;
1894 p1_a27 := ddx_complete_rec.days_due;
1895 p1_a28 := ddx_complete_rec.claim_type_id;
1896 p1_a29 := ddx_complete_rec.reason_code_id;
1897 p1_a30 := ddx_complete_rec.autopay_claim_type_id;
1898 p1_a31 := ddx_complete_rec.autopay_reason_code_id;
1899 p1_a32 := ddx_complete_rec.autopay_flag;
1900 p1_a33 := ddx_complete_rec.autopay_periodicity;
1901 p1_a34 := ddx_complete_rec.autopay_periodicity_type;
1902 p1_a35 := ddx_complete_rec.accounting_method_option;
1903 p1_a36 := ddx_complete_rec.billback_trx_type_id;
1904 p1_a37 := ddx_complete_rec.cm_trx_type_id;
1905 p1_a38 := ddx_complete_rec.attribute_category;
1906 p1_a39 := ddx_complete_rec.attribute1;
1907 p1_a40 := ddx_complete_rec.attribute2;
1908 p1_a41 := ddx_complete_rec.attribute3;
1909 p1_a42 := ddx_complete_rec.attribute4;
1910 p1_a43 := ddx_complete_rec.attribute5;
1914 p1_a47 := ddx_complete_rec.attribute9;
1911 p1_a44 := ddx_complete_rec.attribute6;
1912 p1_a45 := ddx_complete_rec.attribute7;
1913 p1_a46 := ddx_complete_rec.attribute8;
1915 p1_a48 := ddx_complete_rec.attribute10;
1916 p1_a49 := ddx_complete_rec.attribute11;
1917 p1_a50 := ddx_complete_rec.attribute12;
1918 p1_a51 := ddx_complete_rec.attribute13;
1919 p1_a52 := ddx_complete_rec.attribute14;
1920 p1_a53 := ddx_complete_rec.attribute15;
1921 p1_a54 := ddx_complete_rec.org_id;
1922 p1_a55 := ddx_complete_rec.batch_source_id;
1923 p1_a56 := ddx_complete_rec.payables_source;
1924 p1_a57 := ddx_complete_rec.default_owner_id;
1925 p1_a58 := ddx_complete_rec.auto_assign_flag;
1926 p1_a59 := ddx_complete_rec.exchange_rate_type;
1927 p1_a60 := ddx_complete_rec.order_type_id;
1928 p1_a61 := ddx_complete_rec.gl_acct_for_offinv_flag;
1929 p1_a62 := ddx_complete_rec.cb_trx_type_id;
1930 p1_a63 := ddx_complete_rec.pos_write_off_threshold;
1931 p1_a64 := ddx_complete_rec.neg_write_off_threshold;
1932 p1_a65 := ddx_complete_rec.adj_rec_trx_id;
1933 p1_a66 := ddx_complete_rec.wo_rec_trx_id;
1934 p1_a67 := ddx_complete_rec.neg_wo_rec_trx_id;
1935 p1_a68 := ddx_complete_rec.un_earned_pay_allow_to;
1936 p1_a69 := ddx_complete_rec.un_earned_pay_thold_type;
1937 p1_a70 := ddx_complete_rec.un_earned_pay_threshold;
1938 p1_a71 := ddx_complete_rec.un_earned_pay_thold_flag;
1939 p1_a72 := ddx_complete_rec.header_tolerance_calc_code;
1940 p1_a73 := ddx_complete_rec.header_tolerance_operand;
1941 p1_a74 := ddx_complete_rec.line_tolerance_calc_code;
1942 p1_a75 := ddx_complete_rec.line_tolerance_operand;
1943 p1_a76 := ddx_complete_rec.ship_debit_accrual_flag;
1944 p1_a77 := ddx_complete_rec.ship_debit_calc_type;
1945 p1_a78 := ddx_complete_rec.inventory_tracking_flag;
1946 p1_a79 := ddx_complete_rec.end_cust_relation_flag;
1947 p1_a80 := ddx_complete_rec.auto_tp_accrual_flag;
1948 p1_a81 := ddx_complete_rec.gl_balancing_flex_value;
1949 p1_a82 := ddx_complete_rec.prorate_earnings_flag;
1950 p1_a83 := ddx_complete_rec.sales_credit_default_type;
1951 p1_a84 := ddx_complete_rec.net_amt_for_mass_settle_flag;
1952 p1_a85 := ddx_complete_rec.claim_tax_incl_flag;
1953 p1_a86 := ddx_complete_rec.rule_based;
1954 p1_a87 := ddx_complete_rec.approval_new_credit;
1955 p1_a88 := ddx_complete_rec.approval_matched_credit;
1956 p1_a89 := ddx_complete_rec.cust_name_match_type;
1957 p1_a90 := ddx_complete_rec.credit_matching_thold_type;
1958 p1_a91 := ddx_complete_rec.credit_tolerance_operand;
1959 p1_a92 := ddx_complete_rec.automate_notification_days;
1960 p1_a93 := ddx_complete_rec.ssd_inc_adj_type_id;
1961 p1_a94 := ddx_complete_rec.ssd_dec_adj_type_id;
1962 p1_a95 := ddx_complete_rec.ssd_imd_claim_flag;
1963 end;
1964
1965 end ozf_sys_parameters_pvt_w;