5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
316: , x_msg_data out nocopy VARCHAR2
317: , x_offer_performance_id out nocopy NUMBER
318: , p7_a0 NUMBER := 0-1962.0724
319: , p7_a1 NUMBER := 0-1962.0724
320: , p7_a2 DATE := fnd_api.g_miss_date
321: , p7_a3 NUMBER := 0-1962.0724
322: , p7_a4 DATE := fnd_api.g_miss_date
323: , p7_a5 NUMBER := 0-1962.0724
324: , p7_a6 NUMBER := 0-1962.0724
318: , p7_a0 NUMBER := 0-1962.0724
319: , p7_a1 NUMBER := 0-1962.0724
320: , p7_a2 DATE := fnd_api.g_miss_date
321: , p7_a3 NUMBER := 0-1962.0724
322: , p7_a4 DATE := fnd_api.g_miss_date
323: , p7_a5 NUMBER := 0-1962.0724
324: , p7_a6 NUMBER := 0-1962.0724
325: , p7_a7 NUMBER := 0-1962.0724
326: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a4 DATE := fnd_api.g_miss_date
323: , p7_a5 NUMBER := 0-1962.0724
324: , p7_a6 NUMBER := 0-1962.0724
325: , p7_a7 NUMBER := 0-1962.0724
326: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a11 NUMBER := 0-1962.0724
330: , p7_a12 DATE := fnd_api.g_miss_date
323: , p7_a5 NUMBER := 0-1962.0724
324: , p7_a6 NUMBER := 0-1962.0724
325: , p7_a7 NUMBER := 0-1962.0724
326: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a11 NUMBER := 0-1962.0724
330: , p7_a12 DATE := fnd_api.g_miss_date
331: , p7_a13 DATE := fnd_api.g_miss_date
324: , p7_a6 NUMBER := 0-1962.0724
325: , p7_a7 NUMBER := 0-1962.0724
326: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a11 NUMBER := 0-1962.0724
330: , p7_a12 DATE := fnd_api.g_miss_date
331: , p7_a13 DATE := fnd_api.g_miss_date
332: , p7_a14 NUMBER := 0-1962.0724
326: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a11 NUMBER := 0-1962.0724
330: , p7_a12 DATE := fnd_api.g_miss_date
331: , p7_a13 DATE := fnd_api.g_miss_date
332: , p7_a14 NUMBER := 0-1962.0724
333: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a11 NUMBER := 0-1962.0724
330: , p7_a12 DATE := fnd_api.g_miss_date
331: , p7_a13 DATE := fnd_api.g_miss_date
332: , p7_a14 NUMBER := 0-1962.0724
333: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a11 NUMBER := 0-1962.0724
330: , p7_a12 DATE := fnd_api.g_miss_date
331: , p7_a13 DATE := fnd_api.g_miss_date
332: , p7_a14 NUMBER := 0-1962.0724
333: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
330: , p7_a12 DATE := fnd_api.g_miss_date
331: , p7_a13 DATE := fnd_api.g_miss_date
332: , p7_a14 NUMBER := 0-1962.0724
333: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a13 DATE := fnd_api.g_miss_date
332: , p7_a14 NUMBER := 0-1962.0724
333: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a14 NUMBER := 0-1962.0724
333: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
347: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
347: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
347: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
347: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a32 NUMBER := 0-1962.0724
343: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
347: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a32 NUMBER := 0-1962.0724
351: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
344: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
347: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a32 NUMBER := 0-1962.0724
351: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
345: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
347: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a32 NUMBER := 0-1962.0724
351: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
347: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a32 NUMBER := 0-1962.0724
351: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
354: )
355:
348: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a32 NUMBER := 0-1962.0724
351: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
354: )
355:
356: as
349: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a32 NUMBER := 0-1962.0724
351: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
354: )
355:
356: as
357: ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
435: , x_msg_data out nocopy VARCHAR2
436: , x_object_version_number out nocopy NUMBER
437: , p7_a0 NUMBER := 0-1962.0724
438: , p7_a1 NUMBER := 0-1962.0724
439: , p7_a2 DATE := fnd_api.g_miss_date
440: , p7_a3 NUMBER := 0-1962.0724
441: , p7_a4 DATE := fnd_api.g_miss_date
442: , p7_a5 NUMBER := 0-1962.0724
443: , p7_a6 NUMBER := 0-1962.0724
437: , p7_a0 NUMBER := 0-1962.0724
438: , p7_a1 NUMBER := 0-1962.0724
439: , p7_a2 DATE := fnd_api.g_miss_date
440: , p7_a3 NUMBER := 0-1962.0724
441: , p7_a4 DATE := fnd_api.g_miss_date
442: , p7_a5 NUMBER := 0-1962.0724
443: , p7_a6 NUMBER := 0-1962.0724
444: , p7_a7 NUMBER := 0-1962.0724
445: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
441: , p7_a4 DATE := fnd_api.g_miss_date
442: , p7_a5 NUMBER := 0-1962.0724
443: , p7_a6 NUMBER := 0-1962.0724
444: , p7_a7 NUMBER := 0-1962.0724
445: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
446: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
447: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
448: , p7_a11 NUMBER := 0-1962.0724
449: , p7_a12 DATE := fnd_api.g_miss_date
442: , p7_a5 NUMBER := 0-1962.0724
443: , p7_a6 NUMBER := 0-1962.0724
444: , p7_a7 NUMBER := 0-1962.0724
445: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
446: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
447: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
448: , p7_a11 NUMBER := 0-1962.0724
449: , p7_a12 DATE := fnd_api.g_miss_date
450: , p7_a13 DATE := fnd_api.g_miss_date
443: , p7_a6 NUMBER := 0-1962.0724
444: , p7_a7 NUMBER := 0-1962.0724
445: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
446: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
447: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
448: , p7_a11 NUMBER := 0-1962.0724
449: , p7_a12 DATE := fnd_api.g_miss_date
450: , p7_a13 DATE := fnd_api.g_miss_date
451: , p7_a14 NUMBER := 0-1962.0724
445: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
446: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
447: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
448: , p7_a11 NUMBER := 0-1962.0724
449: , p7_a12 DATE := fnd_api.g_miss_date
450: , p7_a13 DATE := fnd_api.g_miss_date
451: , p7_a14 NUMBER := 0-1962.0724
452: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
447: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
448: , p7_a11 NUMBER := 0-1962.0724
449: , p7_a12 DATE := fnd_api.g_miss_date
450: , p7_a13 DATE := fnd_api.g_miss_date
451: , p7_a14 NUMBER := 0-1962.0724
452: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
448: , p7_a11 NUMBER := 0-1962.0724
449: , p7_a12 DATE := fnd_api.g_miss_date
450: , p7_a13 DATE := fnd_api.g_miss_date
451: , p7_a14 NUMBER := 0-1962.0724
452: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
449: , p7_a12 DATE := fnd_api.g_miss_date
450: , p7_a13 DATE := fnd_api.g_miss_date
451: , p7_a14 NUMBER := 0-1962.0724
452: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
450: , p7_a13 DATE := fnd_api.g_miss_date
451: , p7_a14 NUMBER := 0-1962.0724
452: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
451: , p7_a14 NUMBER := 0-1962.0724
452: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
452: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
454: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
455: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
456: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
457: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
461: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a32 NUMBER := 0-1962.0724
462: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a32 NUMBER := 0-1962.0724
470: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a32 NUMBER := 0-1962.0724
470: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
464: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a32 NUMBER := 0-1962.0724
470: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a32 NUMBER := 0-1962.0724
470: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
473: )
474:
467: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a32 NUMBER := 0-1962.0724
470: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
473: )
474:
475: as
468: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a32 NUMBER := 0-1962.0724
470: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
473: )
474:
475: as
476: ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
553: , x_msg_count out nocopy NUMBER
554: , x_msg_data out nocopy VARCHAR2
555: , p3_a0 NUMBER := 0-1962.0724
556: , p3_a1 NUMBER := 0-1962.0724
557: , p3_a2 DATE := fnd_api.g_miss_date
558: , p3_a3 NUMBER := 0-1962.0724
559: , p3_a4 DATE := fnd_api.g_miss_date
560: , p3_a5 NUMBER := 0-1962.0724
561: , p3_a6 NUMBER := 0-1962.0724
555: , p3_a0 NUMBER := 0-1962.0724
556: , p3_a1 NUMBER := 0-1962.0724
557: , p3_a2 DATE := fnd_api.g_miss_date
558: , p3_a3 NUMBER := 0-1962.0724
559: , p3_a4 DATE := fnd_api.g_miss_date
560: , p3_a5 NUMBER := 0-1962.0724
561: , p3_a6 NUMBER := 0-1962.0724
562: , p3_a7 NUMBER := 0-1962.0724
563: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
559: , p3_a4 DATE := fnd_api.g_miss_date
560: , p3_a5 NUMBER := 0-1962.0724
561: , p3_a6 NUMBER := 0-1962.0724
562: , p3_a7 NUMBER := 0-1962.0724
563: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
564: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
565: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
566: , p3_a11 NUMBER := 0-1962.0724
567: , p3_a12 DATE := fnd_api.g_miss_date
560: , p3_a5 NUMBER := 0-1962.0724
561: , p3_a6 NUMBER := 0-1962.0724
562: , p3_a7 NUMBER := 0-1962.0724
563: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
564: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
565: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
566: , p3_a11 NUMBER := 0-1962.0724
567: , p3_a12 DATE := fnd_api.g_miss_date
568: , p3_a13 DATE := fnd_api.g_miss_date
561: , p3_a6 NUMBER := 0-1962.0724
562: , p3_a7 NUMBER := 0-1962.0724
563: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
564: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
565: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
566: , p3_a11 NUMBER := 0-1962.0724
567: , p3_a12 DATE := fnd_api.g_miss_date
568: , p3_a13 DATE := fnd_api.g_miss_date
569: , p3_a14 NUMBER := 0-1962.0724
563: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
564: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
565: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
566: , p3_a11 NUMBER := 0-1962.0724
567: , p3_a12 DATE := fnd_api.g_miss_date
568: , p3_a13 DATE := fnd_api.g_miss_date
569: , p3_a14 NUMBER := 0-1962.0724
570: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
571: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
564: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
565: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
566: , p3_a11 NUMBER := 0-1962.0724
567: , p3_a12 DATE := fnd_api.g_miss_date
568: , p3_a13 DATE := fnd_api.g_miss_date
569: , p3_a14 NUMBER := 0-1962.0724
570: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
571: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
572: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
566: , p3_a11 NUMBER := 0-1962.0724
567: , p3_a12 DATE := fnd_api.g_miss_date
568: , p3_a13 DATE := fnd_api.g_miss_date
569: , p3_a14 NUMBER := 0-1962.0724
570: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
571: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
572: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
573: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
567: , p3_a12 DATE := fnd_api.g_miss_date
568: , p3_a13 DATE := fnd_api.g_miss_date
569: , p3_a14 NUMBER := 0-1962.0724
570: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
571: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
572: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
573: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
568: , p3_a13 DATE := fnd_api.g_miss_date
569: , p3_a14 NUMBER := 0-1962.0724
570: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
571: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
572: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
573: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
569: , p3_a14 NUMBER := 0-1962.0724
570: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
571: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
572: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
573: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
570: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
571: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
572: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
573: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
571: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
572: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
573: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
572: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
573: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
573: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
574: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
575: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
576: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
584: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
577: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
584: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
585: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
578: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
584: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
585: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
586: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
579: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
584: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
585: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
586: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
587: , p3_a32 NUMBER := 0-1962.0724
580: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
584: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
585: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
586: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
587: , p3_a32 NUMBER := 0-1962.0724
588: , p3_a33 VARCHAR2 := fnd_api.g_miss_char
581: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
584: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
585: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
586: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
587: , p3_a32 NUMBER := 0-1962.0724
588: , p3_a33 VARCHAR2 := fnd_api.g_miss_char
589: , p3_a34 VARCHAR2 := fnd_api.g_miss_char
582: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
584: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
585: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
586: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
587: , p3_a32 NUMBER := 0-1962.0724
588: , p3_a33 VARCHAR2 := fnd_api.g_miss_char
589: , p3_a34 VARCHAR2 := fnd_api.g_miss_char
590: , p3_a35 VARCHAR2 := fnd_api.g_miss_char
584: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
585: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
586: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
587: , p3_a32 NUMBER := 0-1962.0724
588: , p3_a33 VARCHAR2 := fnd_api.g_miss_char
589: , p3_a34 VARCHAR2 := fnd_api.g_miss_char
590: , p3_a35 VARCHAR2 := fnd_api.g_miss_char
591: )
592:
585: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
586: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
587: , p3_a32 NUMBER := 0-1962.0724
588: , p3_a33 VARCHAR2 := fnd_api.g_miss_char
589: , p3_a34 VARCHAR2 := fnd_api.g_miss_char
590: , p3_a35 VARCHAR2 := fnd_api.g_miss_char
591: )
592:
593: as
586: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
587: , p3_a32 NUMBER := 0-1962.0724
588: , p3_a33 VARCHAR2 := fnd_api.g_miss_char
589: , p3_a34 VARCHAR2 := fnd_api.g_miss_char
590: , p3_a35 VARCHAR2 := fnd_api.g_miss_char
591: )
592:
593: as
594: ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
663: procedure check_offer_perf_items(p_validation_mode VARCHAR2
664: , x_return_status out nocopy VARCHAR2
665: , p0_a0 NUMBER := 0-1962.0724
666: , p0_a1 NUMBER := 0-1962.0724
667: , p0_a2 DATE := fnd_api.g_miss_date
668: , p0_a3 NUMBER := 0-1962.0724
669: , p0_a4 DATE := fnd_api.g_miss_date
670: , p0_a5 NUMBER := 0-1962.0724
671: , p0_a6 NUMBER := 0-1962.0724
665: , p0_a0 NUMBER := 0-1962.0724
666: , p0_a1 NUMBER := 0-1962.0724
667: , p0_a2 DATE := fnd_api.g_miss_date
668: , p0_a3 NUMBER := 0-1962.0724
669: , p0_a4 DATE := fnd_api.g_miss_date
670: , p0_a5 NUMBER := 0-1962.0724
671: , p0_a6 NUMBER := 0-1962.0724
672: , p0_a7 NUMBER := 0-1962.0724
673: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
669: , p0_a4 DATE := fnd_api.g_miss_date
670: , p0_a5 NUMBER := 0-1962.0724
671: , p0_a6 NUMBER := 0-1962.0724
672: , p0_a7 NUMBER := 0-1962.0724
673: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
675: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
676: , p0_a11 NUMBER := 0-1962.0724
677: , p0_a12 DATE := fnd_api.g_miss_date
670: , p0_a5 NUMBER := 0-1962.0724
671: , p0_a6 NUMBER := 0-1962.0724
672: , p0_a7 NUMBER := 0-1962.0724
673: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
675: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
676: , p0_a11 NUMBER := 0-1962.0724
677: , p0_a12 DATE := fnd_api.g_miss_date
678: , p0_a13 DATE := fnd_api.g_miss_date
671: , p0_a6 NUMBER := 0-1962.0724
672: , p0_a7 NUMBER := 0-1962.0724
673: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
675: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
676: , p0_a11 NUMBER := 0-1962.0724
677: , p0_a12 DATE := fnd_api.g_miss_date
678: , p0_a13 DATE := fnd_api.g_miss_date
679: , p0_a14 NUMBER := 0-1962.0724
673: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
675: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
676: , p0_a11 NUMBER := 0-1962.0724
677: , p0_a12 DATE := fnd_api.g_miss_date
678: , p0_a13 DATE := fnd_api.g_miss_date
679: , p0_a14 NUMBER := 0-1962.0724
680: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
681: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
674: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
675: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
676: , p0_a11 NUMBER := 0-1962.0724
677: , p0_a12 DATE := fnd_api.g_miss_date
678: , p0_a13 DATE := fnd_api.g_miss_date
679: , p0_a14 NUMBER := 0-1962.0724
680: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
681: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
682: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
676: , p0_a11 NUMBER := 0-1962.0724
677: , p0_a12 DATE := fnd_api.g_miss_date
678: , p0_a13 DATE := fnd_api.g_miss_date
679: , p0_a14 NUMBER := 0-1962.0724
680: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
681: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
682: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
683: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
677: , p0_a12 DATE := fnd_api.g_miss_date
678: , p0_a13 DATE := fnd_api.g_miss_date
679: , p0_a14 NUMBER := 0-1962.0724
680: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
681: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
682: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
683: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
678: , p0_a13 DATE := fnd_api.g_miss_date
679: , p0_a14 NUMBER := 0-1962.0724
680: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
681: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
682: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
683: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
679: , p0_a14 NUMBER := 0-1962.0724
680: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
681: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
682: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
683: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
680: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
681: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
682: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
683: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
681: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
682: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
683: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
682: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
683: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
683: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
684: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
685: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
686: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
694: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
687: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
694: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
695: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
688: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
694: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
695: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
696: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
689: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
694: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
695: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
696: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
697: , p0_a32 NUMBER := 0-1962.0724
690: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
694: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
695: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
696: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
697: , p0_a32 NUMBER := 0-1962.0724
698: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
691: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
694: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
695: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
696: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
697: , p0_a32 NUMBER := 0-1962.0724
698: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
699: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
692: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
694: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
695: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
696: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
697: , p0_a32 NUMBER := 0-1962.0724
698: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
699: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
700: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
694: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
695: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
696: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
697: , p0_a32 NUMBER := 0-1962.0724
698: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
699: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
700: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
701: )
702:
695: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
696: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
697: , p0_a32 NUMBER := 0-1962.0724
698: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
699: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
700: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
701: )
702:
703: as
696: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
697: , p0_a32 NUMBER := 0-1962.0724
698: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
699: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
700: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
701: )
702:
703: as
704: ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
761: , x_msg_count out nocopy NUMBER
762: , x_msg_data out nocopy VARCHAR2
763: , p5_a0 NUMBER := 0-1962.0724
764: , p5_a1 NUMBER := 0-1962.0724
765: , p5_a2 DATE := fnd_api.g_miss_date
766: , p5_a3 NUMBER := 0-1962.0724
767: , p5_a4 DATE := fnd_api.g_miss_date
768: , p5_a5 NUMBER := 0-1962.0724
769: , p5_a6 NUMBER := 0-1962.0724
763: , p5_a0 NUMBER := 0-1962.0724
764: , p5_a1 NUMBER := 0-1962.0724
765: , p5_a2 DATE := fnd_api.g_miss_date
766: , p5_a3 NUMBER := 0-1962.0724
767: , p5_a4 DATE := fnd_api.g_miss_date
768: , p5_a5 NUMBER := 0-1962.0724
769: , p5_a6 NUMBER := 0-1962.0724
770: , p5_a7 NUMBER := 0-1962.0724
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a4 DATE := fnd_api.g_miss_date
768: , p5_a5 NUMBER := 0-1962.0724
769: , p5_a6 NUMBER := 0-1962.0724
770: , p5_a7 NUMBER := 0-1962.0724
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
768: , p5_a5 NUMBER := 0-1962.0724
769: , p5_a6 NUMBER := 0-1962.0724
770: , p5_a7 NUMBER := 0-1962.0724
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 DATE := fnd_api.g_miss_date
769: , p5_a6 NUMBER := 0-1962.0724
770: , p5_a7 NUMBER := 0-1962.0724
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 DATE := fnd_api.g_miss_date
777: , p5_a14 NUMBER := 0-1962.0724
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 DATE := fnd_api.g_miss_date
777: , p5_a14 NUMBER := 0-1962.0724
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 DATE := fnd_api.g_miss_date
777: , p5_a14 NUMBER := 0-1962.0724
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 DATE := fnd_api.g_miss_date
777: , p5_a14 NUMBER := 0-1962.0724
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 DATE := fnd_api.g_miss_date
777: , p5_a14 NUMBER := 0-1962.0724
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 DATE := fnd_api.g_miss_date
777: , p5_a14 NUMBER := 0-1962.0724
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 NUMBER := 0-1962.0724
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a32 NUMBER := 0-1962.0724
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a32 NUMBER := 0-1962.0724
796: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a32 NUMBER := 0-1962.0724
796: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a32 NUMBER := 0-1962.0724
796: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a32 NUMBER := 0-1962.0724
796: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
799: )
800:
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a32 NUMBER := 0-1962.0724
796: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
799: )
800:
801: as
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a32 NUMBER := 0-1962.0724
796: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
799: )
800:
801: as
802: ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;