[Home] [Help]
PACKAGE BODY: APPS.CN_PRD_QUOTA_PVT_W
Source
1 package body cn_prd_quota_pvt_w as
2 /* $Header: cnwpedqb.pls 120.3 2005/09/14 04:28 rarajara ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_prd_quota_pvt.prd_quota_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_DATE_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_DATE_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_NUMBER_TABLE
28 ) as
29 ddindx binary_integer; indx binary_integer;
30 begin
31 if a0 is not null and a0.count > 0 then
32 if a0.count > 0 then
33 indx := a0.first;
34 ddindx := 1;
35 while true loop
36 t(ddindx).period_quota_id := a0(indx);
37 t(ddindx).period_id := a1(indx);
38 t(ddindx).period_name := a2(indx);
39 t(ddindx).quota_id := a3(indx);
40 t(ddindx).period_target := a4(indx);
41 t(ddindx).itd_target := a5(indx);
42 t(ddindx).period_payment := a6(indx);
43 t(ddindx).itd_payment := a7(indx);
44 t(ddindx).quarter_num := a8(indx);
45 t(ddindx).period_year := a9(indx);
46 t(ddindx).org_id := a10(indx);
47 t(ddindx).performance_goal := a11(indx);
48 t(ddindx).performance_goal_itd := a12(indx);
49 t(ddindx).period_target_tot := a13(indx);
50 t(ddindx).period_payment_tot := a14(indx);
51 t(ddindx).performance_goal_tot := a15(indx);
52 t(ddindx).period_target_pct := a16(indx);
53 t(ddindx).period_payment_pct := a17(indx);
54 t(ddindx).performance_goal_pct := a18(indx);
55 t(ddindx).created_by := a19(indx);
56 t(ddindx).creation_date := a20(indx);
57 t(ddindx).last_update_login := a21(indx);
58 t(ddindx).last_update_date := a22(indx);
59 t(ddindx).last_updated_by := a23(indx);
60 t(ddindx).object_version_number := a24(indx);
61 ddindx := ddindx+1;
62 if a0.last =indx
63 then exit;
64 end if;
65 indx := a0.next(indx);
66 end loop;
67 end if;
68 end if;
69 end rosetta_table_copy_in_p1;
70 procedure rosetta_table_copy_out_p1(t cn_prd_quota_pvt.prd_quota_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71 , a1 out nocopy JTF_NUMBER_TABLE
72 , a2 out nocopy JTF_VARCHAR2_TABLE_100
73 , a3 out nocopy JTF_NUMBER_TABLE
74 , a4 out nocopy JTF_NUMBER_TABLE
75 , a5 out nocopy JTF_NUMBER_TABLE
76 , a6 out nocopy JTF_NUMBER_TABLE
77 , a7 out nocopy JTF_NUMBER_TABLE
78 , a8 out nocopy JTF_NUMBER_TABLE
79 , a9 out nocopy JTF_NUMBER_TABLE
80 , a10 out nocopy JTF_NUMBER_TABLE
81 , a11 out nocopy JTF_NUMBER_TABLE
82 , a12 out nocopy JTF_NUMBER_TABLE
83 , a13 out nocopy JTF_NUMBER_TABLE
84 , a14 out nocopy JTF_NUMBER_TABLE
85 , a15 out nocopy JTF_NUMBER_TABLE
86 , a16 out nocopy JTF_NUMBER_TABLE
87 , a17 out nocopy JTF_NUMBER_TABLE
88 , a18 out nocopy JTF_NUMBER_TABLE
89 , a19 out nocopy JTF_NUMBER_TABLE
90 , a20 out nocopy JTF_DATE_TABLE
91 , a21 out nocopy JTF_NUMBER_TABLE
92 , a22 out nocopy JTF_DATE_TABLE
93 , a23 out nocopy JTF_NUMBER_TABLE
94 , a24 out nocopy JTF_NUMBER_TABLE
95 ) as
96 ddindx binary_integer; indx binary_integer;
97 begin
98 if t is null or t.count = 0 then
99 a0 := JTF_NUMBER_TABLE();
100 a1 := JTF_NUMBER_TABLE();
101 a2 := JTF_VARCHAR2_TABLE_100();
102 a3 := JTF_NUMBER_TABLE();
103 a4 := JTF_NUMBER_TABLE();
104 a5 := JTF_NUMBER_TABLE();
105 a6 := JTF_NUMBER_TABLE();
106 a7 := JTF_NUMBER_TABLE();
107 a8 := JTF_NUMBER_TABLE();
108 a9 := JTF_NUMBER_TABLE();
109 a10 := JTF_NUMBER_TABLE();
110 a11 := JTF_NUMBER_TABLE();
111 a12 := JTF_NUMBER_TABLE();
112 a13 := JTF_NUMBER_TABLE();
113 a14 := JTF_NUMBER_TABLE();
114 a15 := JTF_NUMBER_TABLE();
115 a16 := JTF_NUMBER_TABLE();
116 a17 := JTF_NUMBER_TABLE();
117 a18 := JTF_NUMBER_TABLE();
118 a19 := JTF_NUMBER_TABLE();
119 a20 := JTF_DATE_TABLE();
120 a21 := JTF_NUMBER_TABLE();
121 a22 := JTF_DATE_TABLE();
122 a23 := JTF_NUMBER_TABLE();
123 a24 := JTF_NUMBER_TABLE();
124 else
125 a0 := JTF_NUMBER_TABLE();
126 a1 := JTF_NUMBER_TABLE();
127 a2 := JTF_VARCHAR2_TABLE_100();
128 a3 := JTF_NUMBER_TABLE();
129 a4 := JTF_NUMBER_TABLE();
130 a5 := JTF_NUMBER_TABLE();
131 a6 := JTF_NUMBER_TABLE();
132 a7 := JTF_NUMBER_TABLE();
133 a8 := JTF_NUMBER_TABLE();
134 a9 := JTF_NUMBER_TABLE();
135 a10 := JTF_NUMBER_TABLE();
136 a11 := JTF_NUMBER_TABLE();
137 a12 := JTF_NUMBER_TABLE();
138 a13 := JTF_NUMBER_TABLE();
139 a14 := JTF_NUMBER_TABLE();
140 a15 := JTF_NUMBER_TABLE();
141 a16 := JTF_NUMBER_TABLE();
142 a17 := JTF_NUMBER_TABLE();
143 a18 := JTF_NUMBER_TABLE();
144 a19 := JTF_NUMBER_TABLE();
145 a20 := JTF_DATE_TABLE();
146 a21 := JTF_NUMBER_TABLE();
147 a22 := JTF_DATE_TABLE();
148 a23 := JTF_NUMBER_TABLE();
149 a24 := JTF_NUMBER_TABLE();
150 if t.count > 0 then
151 a0.extend(t.count);
152 a1.extend(t.count);
153 a2.extend(t.count);
154 a3.extend(t.count);
155 a4.extend(t.count);
156 a5.extend(t.count);
157 a6.extend(t.count);
158 a7.extend(t.count);
159 a8.extend(t.count);
160 a9.extend(t.count);
161 a10.extend(t.count);
162 a11.extend(t.count);
163 a12.extend(t.count);
164 a13.extend(t.count);
165 a14.extend(t.count);
166 a15.extend(t.count);
167 a16.extend(t.count);
168 a17.extend(t.count);
169 a18.extend(t.count);
170 a19.extend(t.count);
171 a20.extend(t.count);
172 a21.extend(t.count);
173 a22.extend(t.count);
174 a23.extend(t.count);
175 a24.extend(t.count);
176 ddindx := t.first;
177 indx := 1;
178 while true loop
179 a0(indx) := t(ddindx).period_quota_id;
180 a1(indx) := t(ddindx).period_id;
181 a2(indx) := t(ddindx).period_name;
182 a3(indx) := t(ddindx).quota_id;
183 a4(indx) := t(ddindx).period_target;
184 a5(indx) := t(ddindx).itd_target;
185 a6(indx) := t(ddindx).period_payment;
186 a7(indx) := t(ddindx).itd_payment;
187 a8(indx) := t(ddindx).quarter_num;
188 a9(indx) := t(ddindx).period_year;
189 a10(indx) := t(ddindx).org_id;
190 a11(indx) := t(ddindx).performance_goal;
191 a12(indx) := t(ddindx).performance_goal_itd;
192 a13(indx) := t(ddindx).period_target_tot;
193 a14(indx) := t(ddindx).period_payment_tot;
194 a15(indx) := t(ddindx).performance_goal_tot;
195 a16(indx) := t(ddindx).period_target_pct;
196 a17(indx) := t(ddindx).period_payment_pct;
197 a18(indx) := t(ddindx).performance_goal_pct;
198 a19(indx) := t(ddindx).created_by;
199 a20(indx) := t(ddindx).creation_date;
200 a21(indx) := t(ddindx).last_update_login;
201 a22(indx) := t(ddindx).last_update_date;
202 a23(indx) := t(ddindx).last_updated_by;
203 a24(indx) := t(ddindx).object_version_number;
204 indx := indx+1;
205 if t.last =ddindx
206 then exit;
207 end if;
208 ddindx := t.next(ddindx);
209 end loop;
210 end if;
211 end if;
212 end rosetta_table_copy_out_p1;
213
214 procedure rosetta_table_copy_in_p3(t out nocopy cn_prd_quota_pvt.prd_quota_q_tbl_type, a0 JTF_NUMBER_TABLE
215 , a1 JTF_NUMBER_TABLE
216 , a2 JTF_NUMBER_TABLE
217 , a3 JTF_NUMBER_TABLE
218 , a4 JTF_NUMBER_TABLE
219 , a5 JTF_NUMBER_TABLE
220 , a6 JTF_NUMBER_TABLE
221 , a7 JTF_NUMBER_TABLE
222 , a8 JTF_NUMBER_TABLE
223 , a9 JTF_NUMBER_TABLE
224 , a10 JTF_NUMBER_TABLE
225 , a11 JTF_NUMBER_TABLE
226 ) as
227 ddindx binary_integer; indx binary_integer;
228 begin
229 if a0 is not null and a0.count > 0 then
230 if a0.count > 0 then
231 indx := a0.first;
232 ddindx := 1;
233 while true loop
234 t(ddindx).quota_id := a0(indx);
235 t(ddindx).period_target := a1(indx);
236 t(ddindx).period_payment := a2(indx);
237 t(ddindx).quarter_num := a3(indx);
238 t(ddindx).period_year := a4(indx);
239 t(ddindx).performance_goal := a5(indx);
240 t(ddindx).period_target_tot := a6(indx);
241 t(ddindx).period_payment_tot := a7(indx);
242 t(ddindx).performance_goal_tot := a8(indx);
243 t(ddindx).period_target_pct := a9(indx);
244 t(ddindx).period_payment_pct := a10(indx);
245 t(ddindx).performance_goal_pct := a11(indx);
246 ddindx := ddindx+1;
247 if a0.last =indx
248 then exit;
249 end if;
250 indx := a0.next(indx);
251 end loop;
252 end if;
253 end if;
254 end rosetta_table_copy_in_p3;
255 procedure rosetta_table_copy_out_p3(t cn_prd_quota_pvt.prd_quota_q_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
256 , a1 out nocopy JTF_NUMBER_TABLE
257 , a2 out nocopy JTF_NUMBER_TABLE
258 , a3 out nocopy JTF_NUMBER_TABLE
259 , a4 out nocopy JTF_NUMBER_TABLE
260 , a5 out nocopy JTF_NUMBER_TABLE
261 , a6 out nocopy JTF_NUMBER_TABLE
262 , a7 out nocopy JTF_NUMBER_TABLE
263 , a8 out nocopy JTF_NUMBER_TABLE
264 , a9 out nocopy JTF_NUMBER_TABLE
265 , a10 out nocopy JTF_NUMBER_TABLE
266 , a11 out nocopy JTF_NUMBER_TABLE
267 ) as
268 ddindx binary_integer; indx binary_integer;
269 begin
270 if t is null or t.count = 0 then
271 a0 := JTF_NUMBER_TABLE();
272 a1 := JTF_NUMBER_TABLE();
273 a2 := JTF_NUMBER_TABLE();
274 a3 := JTF_NUMBER_TABLE();
275 a4 := JTF_NUMBER_TABLE();
276 a5 := JTF_NUMBER_TABLE();
277 a6 := JTF_NUMBER_TABLE();
278 a7 := JTF_NUMBER_TABLE();
279 a8 := JTF_NUMBER_TABLE();
280 a9 := JTF_NUMBER_TABLE();
281 a10 := JTF_NUMBER_TABLE();
282 a11 := JTF_NUMBER_TABLE();
283 else
284 a0 := JTF_NUMBER_TABLE();
285 a1 := JTF_NUMBER_TABLE();
286 a2 := JTF_NUMBER_TABLE();
287 a3 := JTF_NUMBER_TABLE();
288 a4 := JTF_NUMBER_TABLE();
289 a5 := JTF_NUMBER_TABLE();
290 a6 := JTF_NUMBER_TABLE();
291 a7 := JTF_NUMBER_TABLE();
292 a8 := JTF_NUMBER_TABLE();
293 a9 := JTF_NUMBER_TABLE();
294 a10 := JTF_NUMBER_TABLE();
295 a11 := JTF_NUMBER_TABLE();
296 if t.count > 0 then
297 a0.extend(t.count);
298 a1.extend(t.count);
299 a2.extend(t.count);
300 a3.extend(t.count);
301 a4.extend(t.count);
302 a5.extend(t.count);
303 a6.extend(t.count);
304 a7.extend(t.count);
305 a8.extend(t.count);
306 a9.extend(t.count);
307 a10.extend(t.count);
308 a11.extend(t.count);
309 ddindx := t.first;
310 indx := 1;
311 while true loop
312 a0(indx) := t(ddindx).quota_id;
313 a1(indx) := t(ddindx).period_target;
314 a2(indx) := t(ddindx).period_payment;
315 a3(indx) := t(ddindx).quarter_num;
316 a4(indx) := t(ddindx).period_year;
317 a5(indx) := t(ddindx).performance_goal;
318 a6(indx) := t(ddindx).period_target_tot;
319 a7(indx) := t(ddindx).period_payment_tot;
320 a8(indx) := t(ddindx).performance_goal_tot;
321 a9(indx) := t(ddindx).period_target_pct;
322 a10(indx) := t(ddindx).period_payment_pct;
323 a11(indx) := t(ddindx).performance_goal_pct;
324 indx := indx+1;
325 if t.last =ddindx
326 then exit;
327 end if;
328 ddindx := t.next(ddindx);
329 end loop;
330 end if;
331 end if;
332 end rosetta_table_copy_out_p3;
333
334 procedure rosetta_table_copy_in_p5(t out nocopy cn_prd_quota_pvt.prd_quota_year_tbl_type, a0 JTF_NUMBER_TABLE
335 , a1 JTF_NUMBER_TABLE
336 , a2 JTF_NUMBER_TABLE
337 , a3 JTF_NUMBER_TABLE
338 , a4 JTF_NUMBER_TABLE
339 , a5 JTF_NUMBER_TABLE
340 , a6 JTF_NUMBER_TABLE
341 , a7 JTF_NUMBER_TABLE
342 , a8 JTF_NUMBER_TABLE
343 , a9 JTF_NUMBER_TABLE
344 , a10 JTF_NUMBER_TABLE
345 ) as
346 ddindx binary_integer; indx binary_integer;
347 begin
348 if a0 is not null and a0.count > 0 then
349 if a0.count > 0 then
350 indx := a0.first;
351 ddindx := 1;
352 while true loop
353 t(ddindx).quota_id := a0(indx);
354 t(ddindx).period_target := a1(indx);
355 t(ddindx).period_payment := a2(indx);
356 t(ddindx).performance_goal := a3(indx);
357 t(ddindx).period_year := a4(indx);
358 t(ddindx).period_target_tot := a5(indx);
359 t(ddindx).period_payment_tot := a6(indx);
360 t(ddindx).performance_goal_tot := a7(indx);
361 t(ddindx).period_target_pct := a8(indx);
362 t(ddindx).period_payment_pct := a9(indx);
363 t(ddindx).performance_goal_pct := a10(indx);
364 ddindx := ddindx+1;
365 if a0.last =indx
366 then exit;
367 end if;
368 indx := a0.next(indx);
372 end rosetta_table_copy_in_p5;
369 end loop;
370 end if;
371 end if;
373 procedure rosetta_table_copy_out_p5(t cn_prd_quota_pvt.prd_quota_year_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
374 , a1 out nocopy JTF_NUMBER_TABLE
375 , a2 out nocopy JTF_NUMBER_TABLE
376 , a3 out nocopy JTF_NUMBER_TABLE
377 , a4 out nocopy JTF_NUMBER_TABLE
378 , a5 out nocopy JTF_NUMBER_TABLE
379 , a6 out nocopy JTF_NUMBER_TABLE
380 , a7 out nocopy JTF_NUMBER_TABLE
381 , a8 out nocopy JTF_NUMBER_TABLE
382 , a9 out nocopy JTF_NUMBER_TABLE
383 , a10 out nocopy JTF_NUMBER_TABLE
384 ) as
385 ddindx binary_integer; indx binary_integer;
386 begin
387 if t is null or t.count = 0 then
388 a0 := JTF_NUMBER_TABLE();
389 a1 := JTF_NUMBER_TABLE();
390 a2 := JTF_NUMBER_TABLE();
391 a3 := JTF_NUMBER_TABLE();
392 a4 := JTF_NUMBER_TABLE();
393 a5 := JTF_NUMBER_TABLE();
394 a6 := JTF_NUMBER_TABLE();
395 a7 := JTF_NUMBER_TABLE();
396 a8 := JTF_NUMBER_TABLE();
397 a9 := JTF_NUMBER_TABLE();
398 a10 := JTF_NUMBER_TABLE();
399 else
400 a0 := JTF_NUMBER_TABLE();
401 a1 := JTF_NUMBER_TABLE();
402 a2 := JTF_NUMBER_TABLE();
403 a3 := JTF_NUMBER_TABLE();
404 a4 := JTF_NUMBER_TABLE();
405 a5 := JTF_NUMBER_TABLE();
406 a6 := JTF_NUMBER_TABLE();
407 a7 := JTF_NUMBER_TABLE();
408 a8 := JTF_NUMBER_TABLE();
409 a9 := JTF_NUMBER_TABLE();
410 a10 := JTF_NUMBER_TABLE();
411 if t.count > 0 then
412 a0.extend(t.count);
413 a1.extend(t.count);
414 a2.extend(t.count);
415 a3.extend(t.count);
416 a4.extend(t.count);
417 a5.extend(t.count);
418 a6.extend(t.count);
419 a7.extend(t.count);
420 a8.extend(t.count);
421 a9.extend(t.count);
422 a10.extend(t.count);
423 ddindx := t.first;
424 indx := 1;
425 while true loop
426 a0(indx) := t(ddindx).quota_id;
427 a1(indx) := t(ddindx).period_target;
428 a2(indx) := t(ddindx).period_payment;
429 a3(indx) := t(ddindx).performance_goal;
430 a4(indx) := t(ddindx).period_year;
431 a5(indx) := t(ddindx).period_target_tot;
432 a6(indx) := t(ddindx).period_payment_tot;
433 a7(indx) := t(ddindx).performance_goal_tot;
434 a8(indx) := t(ddindx).period_target_pct;
435 a9(indx) := t(ddindx).period_payment_pct;
436 a10(indx) := t(ddindx).performance_goal_pct;
437 indx := indx+1;
438 if t.last =ddindx
439 then exit;
440 end if;
441 ddindx := t.next(ddindx);
442 end loop;
443 end if;
444 end if;
445 end rosetta_table_copy_out_p5;
446
447 procedure update_period_quota(p_api_version NUMBER
448 , p_init_msg_list VARCHAR2
449 , p_commit VARCHAR2
450 , p_validation_level NUMBER
451 , p4_a0 in out nocopy NUMBER
452 , p4_a1 in out nocopy NUMBER
453 , p4_a2 in out nocopy VARCHAR2
454 , p4_a3 in out nocopy NUMBER
455 , p4_a4 in out nocopy NUMBER
456 , p4_a5 in out nocopy NUMBER
457 , p4_a6 in out nocopy NUMBER
458 , p4_a7 in out nocopy NUMBER
459 , p4_a8 in out nocopy NUMBER
460 , p4_a9 in out nocopy NUMBER
461 , p4_a10 in out nocopy NUMBER
462 , p4_a11 in out nocopy NUMBER
463 , p4_a12 in out nocopy NUMBER
464 , p4_a13 in out nocopy NUMBER
465 , p4_a14 in out nocopy NUMBER
466 , p4_a15 in out nocopy NUMBER
467 , p4_a16 in out nocopy NUMBER
468 , p4_a17 in out nocopy NUMBER
469 , p4_a18 in out nocopy NUMBER
470 , p4_a19 in out nocopy NUMBER
471 , p4_a20 in out nocopy DATE
472 , p4_a21 in out nocopy NUMBER
473 , p4_a22 in out nocopy DATE
474 , p4_a23 in out nocopy NUMBER
475 , p4_a24 in out nocopy NUMBER
476 , x_return_status out nocopy VARCHAR2
477 , x_msg_count out nocopy NUMBER
478 , x_msg_data out nocopy VARCHAR2
479 )
480
481 as
482 ddp_prd_quota cn_prd_quota_pvt.prd_quota_rec_type;
483 ddindx binary_integer; indx binary_integer;
484 begin
485
486 -- copy data to the local IN or IN-OUT args, if any
487
488
489
490
491 ddp_prd_quota.period_quota_id := p4_a0;
492 ddp_prd_quota.period_id := p4_a1;
493 ddp_prd_quota.period_name := p4_a2;
494 ddp_prd_quota.quota_id := p4_a3;
495 ddp_prd_quota.period_target := p4_a4;
496 ddp_prd_quota.itd_target := p4_a5;
497 ddp_prd_quota.period_payment := p4_a6;
498 ddp_prd_quota.itd_payment := p4_a7;
499 ddp_prd_quota.quarter_num := p4_a8;
500 ddp_prd_quota.period_year := p4_a9;
501 ddp_prd_quota.org_id := p4_a10;
502 ddp_prd_quota.performance_goal := p4_a11;
503 ddp_prd_quota.performance_goal_itd := p4_a12;
504 ddp_prd_quota.period_target_tot := p4_a13;
505 ddp_prd_quota.period_payment_tot := p4_a14;
506 ddp_prd_quota.performance_goal_tot := p4_a15;
507 ddp_prd_quota.period_target_pct := p4_a16;
508 ddp_prd_quota.period_payment_pct := p4_a17;
509 ddp_prd_quota.performance_goal_pct := p4_a18;
510 ddp_prd_quota.created_by := p4_a19;
511 ddp_prd_quota.creation_date := p4_a20;
512 ddp_prd_quota.last_update_login := p4_a21;
513 ddp_prd_quota.last_update_date := p4_a22;
514 ddp_prd_quota.last_updated_by := p4_a23;
515 ddp_prd_quota.object_version_number := p4_a24;
516
517
518
519
520 -- here's the delegated call to the old PL/SQL routine
521 cn_prd_quota_pvt.update_period_quota(p_api_version,
522 p_init_msg_list,
523 p_commit,
524 p_validation_level,
525 ddp_prd_quota,
526 x_return_status,
527 x_msg_count,
528 x_msg_data);
529
530 -- copy data back from the local variables to OUT or IN-OUT args, if any
531
532
533
534
535 p4_a0 := ddp_prd_quota.period_quota_id;
536 p4_a1 := ddp_prd_quota.period_id;
537 p4_a2 := ddp_prd_quota.period_name;
538 p4_a3 := ddp_prd_quota.quota_id;
539 p4_a4 := ddp_prd_quota.period_target;
540 p4_a5 := ddp_prd_quota.itd_target;
541 p4_a6 := ddp_prd_quota.period_payment;
542 p4_a7 := ddp_prd_quota.itd_payment;
543 p4_a8 := ddp_prd_quota.quarter_num;
544 p4_a9 := ddp_prd_quota.period_year;
545 p4_a10 := ddp_prd_quota.org_id;
546 p4_a11 := ddp_prd_quota.performance_goal;
547 p4_a12 := ddp_prd_quota.performance_goal_itd;
548 p4_a13 := ddp_prd_quota.period_target_tot;
549 p4_a14 := ddp_prd_quota.period_payment_tot;
550 p4_a15 := ddp_prd_quota.performance_goal_tot;
551 p4_a16 := ddp_prd_quota.period_target_pct;
552 p4_a17 := ddp_prd_quota.period_payment_pct;
553 p4_a18 := ddp_prd_quota.performance_goal_pct;
554 p4_a19 := ddp_prd_quota.created_by;
555 p4_a20 := ddp_prd_quota.creation_date;
556 p4_a21 := ddp_prd_quota.last_update_login;
557 p4_a22 := ddp_prd_quota.last_update_date;
558 p4_a23 := ddp_prd_quota.last_updated_by;
559 p4_a24 := ddp_prd_quota.object_version_number;
560
561
562
563 end;
564
565 end cn_prd_quota_pvt_w;