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:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
345: , p10_a64 out nocopy JTF_NUMBER_TABLE
346: , p10_a65 out nocopy JTF_NUMBER_TABLE
347: , p5_a0 NUMBER := 0-1962.0724
348: , p5_a1 NUMBER := 0-1962.0724
349: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a5 NUMBER := 0-1962.0724
353: , p5_a6 DATE := fnd_api.g_miss_date
346: , p10_a65 out nocopy JTF_NUMBER_TABLE
347: , p5_a0 NUMBER := 0-1962.0724
348: , p5_a1 NUMBER := 0-1962.0724
349: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a5 NUMBER := 0-1962.0724
353: , p5_a6 DATE := fnd_api.g_miss_date
354: , p5_a7 NUMBER := 0-1962.0724
347: , p5_a0 NUMBER := 0-1962.0724
348: , p5_a1 NUMBER := 0-1962.0724
349: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a5 NUMBER := 0-1962.0724
353: , p5_a6 DATE := fnd_api.g_miss_date
354: , p5_a7 NUMBER := 0-1962.0724
355: , p5_a8 NUMBER := 0-1962.0724
349: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
351: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a5 NUMBER := 0-1962.0724
353: , p5_a6 DATE := fnd_api.g_miss_date
354: , p5_a7 NUMBER := 0-1962.0724
355: , p5_a8 NUMBER := 0-1962.0724
356: , p5_a9 NUMBER := 0-1962.0724
357: , p5_a10 NUMBER := 0-1962.0724
357: , p5_a10 NUMBER := 0-1962.0724
358: , p5_a11 NUMBER := 0-1962.0724
359: , p5_a12 NUMBER := 0-1962.0724
360: , p5_a13 NUMBER := 0-1962.0724
361: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a15 NUMBER := 0-1962.0724
363: , p5_a16 NUMBER := 0-1962.0724
364: , p5_a17 NUMBER := 0-1962.0724
365: , p5_a18 NUMBER := 0-1962.0724
366: , p5_a19 NUMBER := 0-1962.0724
367: , p5_a20 NUMBER := 0-1962.0724
368: , p5_a21 NUMBER := 0-1962.0724
369: , p5_a22 NUMBER := 0-1962.0724
370: , p5_a23 DATE := fnd_api.g_miss_date
371: , p5_a24 NUMBER := 0-1962.0724
372: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a27 NUMBER := 0-1962.0724
368: , p5_a21 NUMBER := 0-1962.0724
369: , p5_a22 NUMBER := 0-1962.0724
370: , p5_a23 DATE := fnd_api.g_miss_date
371: , p5_a24 NUMBER := 0-1962.0724
372: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a27 NUMBER := 0-1962.0724
375: , p5_a28 NUMBER := 0-1962.0724
376: , p5_a29 NUMBER := 0-1962.0724
369: , p5_a22 NUMBER := 0-1962.0724
370: , p5_a23 DATE := fnd_api.g_miss_date
371: , p5_a24 NUMBER := 0-1962.0724
372: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a27 NUMBER := 0-1962.0724
375: , p5_a28 NUMBER := 0-1962.0724
376: , p5_a29 NUMBER := 0-1962.0724
377: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a27 NUMBER := 0-1962.0724
375: , p5_a28 NUMBER := 0-1962.0724
376: , p5_a29 NUMBER := 0-1962.0724
377: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a27 NUMBER := 0-1962.0724
375: , p5_a28 NUMBER := 0-1962.0724
376: , p5_a29 NUMBER := 0-1962.0724
377: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a28 NUMBER := 0-1962.0724
376: , p5_a29 NUMBER := 0-1962.0724
377: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a29 NUMBER := 0-1962.0724
377: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
383: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
384: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
385: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a46 DATE := fnd_api.g_miss_date
386: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a46 DATE := fnd_api.g_miss_date
394: , p5_a47 NUMBER := 0-1962.0724
387: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a46 DATE := fnd_api.g_miss_date
394: , p5_a47 NUMBER := 0-1962.0724
395: , p5_a48 NUMBER := 0-1962.0724
388: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a46 DATE := fnd_api.g_miss_date
394: , p5_a47 NUMBER := 0-1962.0724
395: , p5_a48 NUMBER := 0-1962.0724
396: , p5_a49 NUMBER := 0-1962.0724
389: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a46 DATE := fnd_api.g_miss_date
394: , p5_a47 NUMBER := 0-1962.0724
395: , p5_a48 NUMBER := 0-1962.0724
396: , p5_a49 NUMBER := 0-1962.0724
397: , p5_a50 DATE := fnd_api.g_miss_date
393: , p5_a46 DATE := fnd_api.g_miss_date
394: , p5_a47 NUMBER := 0-1962.0724
395: , p5_a48 NUMBER := 0-1962.0724
396: , p5_a49 NUMBER := 0-1962.0724
397: , p5_a50 DATE := fnd_api.g_miss_date
398: , p5_a51 NUMBER := 0-1962.0724
399: , p5_a52 NUMBER := 0-1962.0724
400: , p5_a53 DATE := fnd_api.g_miss_date
401: , p5_a54 NUMBER := 0-1962.0724
396: , p5_a49 NUMBER := 0-1962.0724
397: , p5_a50 DATE := fnd_api.g_miss_date
398: , p5_a51 NUMBER := 0-1962.0724
399: , p5_a52 NUMBER := 0-1962.0724
400: , p5_a53 DATE := fnd_api.g_miss_date
401: , p5_a54 NUMBER := 0-1962.0724
402: , p5_a55 DATE := fnd_api.g_miss_date
403: , p5_a56 NUMBER := 0-1962.0724
404: , p5_a57 NUMBER := 0-1962.0724
398: , p5_a51 NUMBER := 0-1962.0724
399: , p5_a52 NUMBER := 0-1962.0724
400: , p5_a53 DATE := fnd_api.g_miss_date
401: , p5_a54 NUMBER := 0-1962.0724
402: , p5_a55 DATE := fnd_api.g_miss_date
403: , p5_a56 NUMBER := 0-1962.0724
404: , p5_a57 NUMBER := 0-1962.0724
405: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a54 NUMBER := 0-1962.0724
402: , p5_a55 DATE := fnd_api.g_miss_date
403: , p5_a56 NUMBER := 0-1962.0724
404: , p5_a57 NUMBER := 0-1962.0724
405: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a61 NUMBER := 0-1962.0724
409: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a55 DATE := fnd_api.g_miss_date
403: , p5_a56 NUMBER := 0-1962.0724
404: , p5_a57 NUMBER := 0-1962.0724
405: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a61 NUMBER := 0-1962.0724
409: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a63 DATE := fnd_api.g_miss_date
403: , p5_a56 NUMBER := 0-1962.0724
404: , p5_a57 NUMBER := 0-1962.0724
405: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a61 NUMBER := 0-1962.0724
409: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a63 DATE := fnd_api.g_miss_date
411: , p5_a64 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a61 NUMBER := 0-1962.0724
409: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a63 DATE := fnd_api.g_miss_date
411: , p5_a64 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a65 NUMBER := 0-1962.0724
413: , p5_a66 NUMBER := 0-1962.0724
406: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a61 NUMBER := 0-1962.0724
409: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a63 DATE := fnd_api.g_miss_date
411: , p5_a64 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a65 NUMBER := 0-1962.0724
413: , p5_a66 NUMBER := 0-1962.0724
414: , p5_a67 NUMBER := 0-1962.0724
407: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a61 NUMBER := 0-1962.0724
409: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a63 DATE := fnd_api.g_miss_date
411: , p5_a64 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a65 NUMBER := 0-1962.0724
413: , p5_a66 NUMBER := 0-1962.0724
414: , p5_a67 NUMBER := 0-1962.0724
415: , p5_a68 NUMBER := 0-1962.0724
412: , p5_a65 NUMBER := 0-1962.0724
413: , p5_a66 NUMBER := 0-1962.0724
414: , p5_a67 NUMBER := 0-1962.0724
415: , p5_a68 NUMBER := 0-1962.0724
416: , p5_a69 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a70 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a71 NUMBER := 0-1962.0724
419: , p5_a72 VARCHAR2 := fnd_api.g_miss_char
420: )
413: , p5_a66 NUMBER := 0-1962.0724
414: , p5_a67 NUMBER := 0-1962.0724
415: , p5_a68 NUMBER := 0-1962.0724
416: , p5_a69 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a70 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a71 NUMBER := 0-1962.0724
419: , p5_a72 VARCHAR2 := fnd_api.g_miss_char
420: )
421:
415: , p5_a68 NUMBER := 0-1962.0724
416: , p5_a69 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a70 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a71 NUMBER := 0-1962.0724
419: , p5_a72 VARCHAR2 := fnd_api.g_miss_char
420: )
421:
422: as
423: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
1118: , p9_a64 out nocopy JTF_NUMBER_TABLE
1119: , p9_a65 out nocopy JTF_NUMBER_TABLE
1120: , p5_a0 NUMBER := 0-1962.0724
1121: , p5_a1 NUMBER := 0-1962.0724
1122: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a5 NUMBER := 0-1962.0724
1126: , p5_a6 DATE := fnd_api.g_miss_date
1119: , p9_a65 out nocopy JTF_NUMBER_TABLE
1120: , p5_a0 NUMBER := 0-1962.0724
1121: , p5_a1 NUMBER := 0-1962.0724
1122: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a5 NUMBER := 0-1962.0724
1126: , p5_a6 DATE := fnd_api.g_miss_date
1127: , p5_a7 NUMBER := 0-1962.0724
1120: , p5_a0 NUMBER := 0-1962.0724
1121: , p5_a1 NUMBER := 0-1962.0724
1122: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a5 NUMBER := 0-1962.0724
1126: , p5_a6 DATE := fnd_api.g_miss_date
1127: , p5_a7 NUMBER := 0-1962.0724
1128: , p5_a8 NUMBER := 0-1962.0724
1122: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a5 NUMBER := 0-1962.0724
1126: , p5_a6 DATE := fnd_api.g_miss_date
1127: , p5_a7 NUMBER := 0-1962.0724
1128: , p5_a8 NUMBER := 0-1962.0724
1129: , p5_a9 NUMBER := 0-1962.0724
1130: , p5_a10 NUMBER := 0-1962.0724
1130: , p5_a10 NUMBER := 0-1962.0724
1131: , p5_a11 NUMBER := 0-1962.0724
1132: , p5_a12 NUMBER := 0-1962.0724
1133: , p5_a13 NUMBER := 0-1962.0724
1134: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a15 NUMBER := 0-1962.0724
1136: , p5_a16 NUMBER := 0-1962.0724
1137: , p5_a17 NUMBER := 0-1962.0724
1138: , p5_a18 NUMBER := 0-1962.0724
1139: , p5_a19 NUMBER := 0-1962.0724
1140: , p5_a20 NUMBER := 0-1962.0724
1141: , p5_a21 NUMBER := 0-1962.0724
1142: , p5_a22 NUMBER := 0-1962.0724
1143: , p5_a23 DATE := fnd_api.g_miss_date
1144: , p5_a24 NUMBER := 0-1962.0724
1145: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a27 NUMBER := 0-1962.0724
1141: , p5_a21 NUMBER := 0-1962.0724
1142: , p5_a22 NUMBER := 0-1962.0724
1143: , p5_a23 DATE := fnd_api.g_miss_date
1144: , p5_a24 NUMBER := 0-1962.0724
1145: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a27 NUMBER := 0-1962.0724
1148: , p5_a28 NUMBER := 0-1962.0724
1149: , p5_a29 NUMBER := 0-1962.0724
1142: , p5_a22 NUMBER := 0-1962.0724
1143: , p5_a23 DATE := fnd_api.g_miss_date
1144: , p5_a24 NUMBER := 0-1962.0724
1145: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a27 NUMBER := 0-1962.0724
1148: , p5_a28 NUMBER := 0-1962.0724
1149: , p5_a29 NUMBER := 0-1962.0724
1150: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a27 NUMBER := 0-1962.0724
1148: , p5_a28 NUMBER := 0-1962.0724
1149: , p5_a29 NUMBER := 0-1962.0724
1150: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a27 NUMBER := 0-1962.0724
1148: , p5_a28 NUMBER := 0-1962.0724
1149: , p5_a29 NUMBER := 0-1962.0724
1150: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a28 NUMBER := 0-1962.0724
1149: , p5_a29 NUMBER := 0-1962.0724
1150: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a29 NUMBER := 0-1962.0724
1150: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a46 DATE := fnd_api.g_miss_date
1159: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a46 DATE := fnd_api.g_miss_date
1167: , p5_a47 NUMBER := 0-1962.0724
1160: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a46 DATE := fnd_api.g_miss_date
1167: , p5_a47 NUMBER := 0-1962.0724
1168: , p5_a48 NUMBER := 0-1962.0724
1161: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a46 DATE := fnd_api.g_miss_date
1167: , p5_a47 NUMBER := 0-1962.0724
1168: , p5_a48 NUMBER := 0-1962.0724
1169: , p5_a49 NUMBER := 0-1962.0724
1162: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a46 DATE := fnd_api.g_miss_date
1167: , p5_a47 NUMBER := 0-1962.0724
1168: , p5_a48 NUMBER := 0-1962.0724
1169: , p5_a49 NUMBER := 0-1962.0724
1170: , p5_a50 DATE := fnd_api.g_miss_date
1166: , p5_a46 DATE := fnd_api.g_miss_date
1167: , p5_a47 NUMBER := 0-1962.0724
1168: , p5_a48 NUMBER := 0-1962.0724
1169: , p5_a49 NUMBER := 0-1962.0724
1170: , p5_a50 DATE := fnd_api.g_miss_date
1171: , p5_a51 NUMBER := 0-1962.0724
1172: , p5_a52 NUMBER := 0-1962.0724
1173: , p5_a53 DATE := fnd_api.g_miss_date
1174: , p5_a54 NUMBER := 0-1962.0724
1169: , p5_a49 NUMBER := 0-1962.0724
1170: , p5_a50 DATE := fnd_api.g_miss_date
1171: , p5_a51 NUMBER := 0-1962.0724
1172: , p5_a52 NUMBER := 0-1962.0724
1173: , p5_a53 DATE := fnd_api.g_miss_date
1174: , p5_a54 NUMBER := 0-1962.0724
1175: , p5_a55 DATE := fnd_api.g_miss_date
1176: , p5_a56 NUMBER := 0-1962.0724
1177: , p5_a57 NUMBER := 0-1962.0724
1171: , p5_a51 NUMBER := 0-1962.0724
1172: , p5_a52 NUMBER := 0-1962.0724
1173: , p5_a53 DATE := fnd_api.g_miss_date
1174: , p5_a54 NUMBER := 0-1962.0724
1175: , p5_a55 DATE := fnd_api.g_miss_date
1176: , p5_a56 NUMBER := 0-1962.0724
1177: , p5_a57 NUMBER := 0-1962.0724
1178: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a54 NUMBER := 0-1962.0724
1175: , p5_a55 DATE := fnd_api.g_miss_date
1176: , p5_a56 NUMBER := 0-1962.0724
1177: , p5_a57 NUMBER := 0-1962.0724
1178: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a61 NUMBER := 0-1962.0724
1182: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a55 DATE := fnd_api.g_miss_date
1176: , p5_a56 NUMBER := 0-1962.0724
1177: , p5_a57 NUMBER := 0-1962.0724
1178: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a61 NUMBER := 0-1962.0724
1182: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a63 DATE := fnd_api.g_miss_date
1176: , p5_a56 NUMBER := 0-1962.0724
1177: , p5_a57 NUMBER := 0-1962.0724
1178: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a61 NUMBER := 0-1962.0724
1182: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a63 DATE := fnd_api.g_miss_date
1184: , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a61 NUMBER := 0-1962.0724
1182: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a63 DATE := fnd_api.g_miss_date
1184: , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a65 NUMBER := 0-1962.0724
1186: , p5_a66 NUMBER := 0-1962.0724
1179: , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a61 NUMBER := 0-1962.0724
1182: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a63 DATE := fnd_api.g_miss_date
1184: , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a65 NUMBER := 0-1962.0724
1186: , p5_a66 NUMBER := 0-1962.0724
1187: , p5_a67 NUMBER := 0-1962.0724
1180: , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a61 NUMBER := 0-1962.0724
1182: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a63 DATE := fnd_api.g_miss_date
1184: , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a65 NUMBER := 0-1962.0724
1186: , p5_a66 NUMBER := 0-1962.0724
1187: , p5_a67 NUMBER := 0-1962.0724
1188: , p5_a68 NUMBER := 0-1962.0724
1185: , p5_a65 NUMBER := 0-1962.0724
1186: , p5_a66 NUMBER := 0-1962.0724
1187: , p5_a67 NUMBER := 0-1962.0724
1188: , p5_a68 NUMBER := 0-1962.0724
1189: , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a71 NUMBER := 0-1962.0724
1192: , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1193: )
1186: , p5_a66 NUMBER := 0-1962.0724
1187: , p5_a67 NUMBER := 0-1962.0724
1188: , p5_a68 NUMBER := 0-1962.0724
1189: , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a71 NUMBER := 0-1962.0724
1192: , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1193: )
1194:
1188: , p5_a68 NUMBER := 0-1962.0724
1189: , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a71 NUMBER := 0-1962.0724
1192: , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1193: )
1194:
1195: as
1196: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;