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;
221: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
222: , p2_a0 NUMBER := 0-1962.0724
223: , p2_a1 NUMBER := 0-1962.0724
224: , p2_a2 NUMBER := 0-1962.0724
225: , p2_a3 DATE := fnd_api.g_miss_date
226: , p2_a4 DATE := fnd_api.g_miss_date
227: , p2_a5 DATE := fnd_api.g_miss_date
228: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
229: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
222: , p2_a0 NUMBER := 0-1962.0724
223: , p2_a1 NUMBER := 0-1962.0724
224: , p2_a2 NUMBER := 0-1962.0724
225: , p2_a3 DATE := fnd_api.g_miss_date
226: , p2_a4 DATE := fnd_api.g_miss_date
227: , p2_a5 DATE := fnd_api.g_miss_date
228: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
229: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
230: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
223: , p2_a1 NUMBER := 0-1962.0724
224: , p2_a2 NUMBER := 0-1962.0724
225: , p2_a3 DATE := fnd_api.g_miss_date
226: , p2_a4 DATE := fnd_api.g_miss_date
227: , p2_a5 DATE := fnd_api.g_miss_date
228: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
229: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
230: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
231: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
224: , p2_a2 NUMBER := 0-1962.0724
225: , p2_a3 DATE := fnd_api.g_miss_date
226: , p2_a4 DATE := fnd_api.g_miss_date
227: , p2_a5 DATE := fnd_api.g_miss_date
228: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
229: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
230: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
231: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
232: , p2_a10 NUMBER := 0-1962.0724
225: , p2_a3 DATE := fnd_api.g_miss_date
226: , p2_a4 DATE := fnd_api.g_miss_date
227: , p2_a5 DATE := fnd_api.g_miss_date
228: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
229: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
230: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
231: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
232: , p2_a10 NUMBER := 0-1962.0724
233: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
226: , p2_a4 DATE := fnd_api.g_miss_date
227: , p2_a5 DATE := fnd_api.g_miss_date
228: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
229: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
230: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
231: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
232: , p2_a10 NUMBER := 0-1962.0724
233: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
234: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
227: , p2_a5 DATE := fnd_api.g_miss_date
228: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
229: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
230: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
231: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
232: , p2_a10 NUMBER := 0-1962.0724
233: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
234: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
235: , p2_a13 NUMBER := 0-1962.0724
229: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
230: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
231: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
232: , p2_a10 NUMBER := 0-1962.0724
233: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
234: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
235: , p2_a13 NUMBER := 0-1962.0724
236: , p2_a14 DATE := fnd_api.g_miss_date
237: , p2_a15 NUMBER := 0-1962.0724
230: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
231: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
232: , p2_a10 NUMBER := 0-1962.0724
233: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
234: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
235: , p2_a13 NUMBER := 0-1962.0724
236: , p2_a14 DATE := fnd_api.g_miss_date
237: , p2_a15 NUMBER := 0-1962.0724
238: , p2_a16 NUMBER := 0-1962.0724
232: , p2_a10 NUMBER := 0-1962.0724
233: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
234: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
235: , p2_a13 NUMBER := 0-1962.0724
236: , p2_a14 DATE := fnd_api.g_miss_date
237: , p2_a15 NUMBER := 0-1962.0724
238: , p2_a16 NUMBER := 0-1962.0724
239: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
240: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
235: , p2_a13 NUMBER := 0-1962.0724
236: , p2_a14 DATE := fnd_api.g_miss_date
237: , p2_a15 NUMBER := 0-1962.0724
238: , p2_a16 NUMBER := 0-1962.0724
239: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
240: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
241: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
236: , p2_a14 DATE := fnd_api.g_miss_date
237: , p2_a15 NUMBER := 0-1962.0724
238: , p2_a16 NUMBER := 0-1962.0724
239: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
240: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
241: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
237: , p2_a15 NUMBER := 0-1962.0724
238: , p2_a16 NUMBER := 0-1962.0724
239: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
240: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
241: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
238: , p2_a16 NUMBER := 0-1962.0724
239: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
240: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
241: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a24 NUMBER := 0-1962.0724
239: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
240: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
241: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a24 NUMBER := 0-1962.0724
247: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
240: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
241: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a24 NUMBER := 0-1962.0724
247: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
248: , p2_a26 DATE := fnd_api.g_miss_date
241: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a24 NUMBER := 0-1962.0724
247: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
248: , p2_a26 DATE := fnd_api.g_miss_date
249: )
243: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
244: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a24 NUMBER := 0-1962.0724
247: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
248: , p2_a26 DATE := fnd_api.g_miss_date
249: )
250:
251: as
244: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a24 NUMBER := 0-1962.0724
247: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
248: , p2_a26 DATE := fnd_api.g_miss_date
249: )
250:
251: as
252: ddp_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
624: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
625: , p2_a0 NUMBER := 0-1962.0724
626: , p2_a1 NUMBER := 0-1962.0724
627: , p2_a2 NUMBER := 0-1962.0724
628: , p2_a3 DATE := fnd_api.g_miss_date
629: , p2_a4 DATE := fnd_api.g_miss_date
630: , p2_a5 DATE := fnd_api.g_miss_date
631: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
632: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
625: , p2_a0 NUMBER := 0-1962.0724
626: , p2_a1 NUMBER := 0-1962.0724
627: , p2_a2 NUMBER := 0-1962.0724
628: , p2_a3 DATE := fnd_api.g_miss_date
629: , p2_a4 DATE := fnd_api.g_miss_date
630: , p2_a5 DATE := fnd_api.g_miss_date
631: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
632: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
633: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
626: , p2_a1 NUMBER := 0-1962.0724
627: , p2_a2 NUMBER := 0-1962.0724
628: , p2_a3 DATE := fnd_api.g_miss_date
629: , p2_a4 DATE := fnd_api.g_miss_date
630: , p2_a5 DATE := fnd_api.g_miss_date
631: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
632: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
633: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
634: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
627: , p2_a2 NUMBER := 0-1962.0724
628: , p2_a3 DATE := fnd_api.g_miss_date
629: , p2_a4 DATE := fnd_api.g_miss_date
630: , p2_a5 DATE := fnd_api.g_miss_date
631: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
632: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
633: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
634: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
635: , p2_a10 NUMBER := 0-1962.0724
628: , p2_a3 DATE := fnd_api.g_miss_date
629: , p2_a4 DATE := fnd_api.g_miss_date
630: , p2_a5 DATE := fnd_api.g_miss_date
631: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
632: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
633: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
634: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
635: , p2_a10 NUMBER := 0-1962.0724
636: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
629: , p2_a4 DATE := fnd_api.g_miss_date
630: , p2_a5 DATE := fnd_api.g_miss_date
631: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
632: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
633: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
634: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
635: , p2_a10 NUMBER := 0-1962.0724
636: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
637: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
630: , p2_a5 DATE := fnd_api.g_miss_date
631: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
632: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
633: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
634: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
635: , p2_a10 NUMBER := 0-1962.0724
636: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
637: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
638: , p2_a13 NUMBER := 0-1962.0724
632: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
633: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
634: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
635: , p2_a10 NUMBER := 0-1962.0724
636: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
637: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
638: , p2_a13 NUMBER := 0-1962.0724
639: , p2_a14 DATE := fnd_api.g_miss_date
640: , p2_a15 NUMBER := 0-1962.0724
633: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
634: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
635: , p2_a10 NUMBER := 0-1962.0724
636: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
637: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
638: , p2_a13 NUMBER := 0-1962.0724
639: , p2_a14 DATE := fnd_api.g_miss_date
640: , p2_a15 NUMBER := 0-1962.0724
641: , p2_a16 NUMBER := 0-1962.0724
635: , p2_a10 NUMBER := 0-1962.0724
636: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
637: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
638: , p2_a13 NUMBER := 0-1962.0724
639: , p2_a14 DATE := fnd_api.g_miss_date
640: , p2_a15 NUMBER := 0-1962.0724
641: , p2_a16 NUMBER := 0-1962.0724
642: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
643: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
638: , p2_a13 NUMBER := 0-1962.0724
639: , p2_a14 DATE := fnd_api.g_miss_date
640: , p2_a15 NUMBER := 0-1962.0724
641: , p2_a16 NUMBER := 0-1962.0724
642: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
643: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
644: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
645: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
646: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
639: , p2_a14 DATE := fnd_api.g_miss_date
640: , p2_a15 NUMBER := 0-1962.0724
641: , p2_a16 NUMBER := 0-1962.0724
642: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
643: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
644: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
645: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
646: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
647: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
640: , p2_a15 NUMBER := 0-1962.0724
641: , p2_a16 NUMBER := 0-1962.0724
642: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
643: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
644: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
645: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
646: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
647: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
648: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
641: , p2_a16 NUMBER := 0-1962.0724
642: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
643: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
644: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
645: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
646: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
647: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
648: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
649: , p2_a24 NUMBER := 0-1962.0724
642: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
643: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
644: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
645: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
646: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
647: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
648: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
649: , p2_a24 NUMBER := 0-1962.0724
650: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
643: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
644: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
645: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
646: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
647: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
648: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
649: , p2_a24 NUMBER := 0-1962.0724
650: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
651: , p2_a26 DATE := fnd_api.g_miss_date
644: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
645: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
646: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
647: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
648: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
649: , p2_a24 NUMBER := 0-1962.0724
650: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
651: , p2_a26 DATE := fnd_api.g_miss_date
652: )
646: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
647: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
648: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
649: , p2_a24 NUMBER := 0-1962.0724
650: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
651: , p2_a26 DATE := fnd_api.g_miss_date
652: )
653:
654: as
647: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
648: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
649: , p2_a24 NUMBER := 0-1962.0724
650: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
651: , p2_a26 DATE := fnd_api.g_miss_date
652: )
653:
654: as
655: ddp_reverse_rec okl_generate_accruals_pub.accrual_rec_type;
983: , x_msg_data out nocopy VARCHAR2
984: , p5_a0 NUMBER := 0-1962.0724
985: , p5_a1 NUMBER := 0-1962.0724
986: , p5_a2 NUMBER := 0-1962.0724
987: , p5_a3 DATE := fnd_api.g_miss_date
988: , p5_a4 DATE := fnd_api.g_miss_date
989: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a7 DATE := fnd_api.g_miss_date
984: , p5_a0 NUMBER := 0-1962.0724
985: , p5_a1 NUMBER := 0-1962.0724
986: , p5_a2 NUMBER := 0-1962.0724
987: , p5_a3 DATE := fnd_api.g_miss_date
988: , p5_a4 DATE := fnd_api.g_miss_date
989: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a7 DATE := fnd_api.g_miss_date
992: , p5_a8 VARCHAR2
985: , p5_a1 NUMBER := 0-1962.0724
986: , p5_a2 NUMBER := 0-1962.0724
987: , p5_a3 DATE := fnd_api.g_miss_date
988: , p5_a4 DATE := fnd_api.g_miss_date
989: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a7 DATE := fnd_api.g_miss_date
992: , p5_a8 VARCHAR2
993: , p_representation_type VARCHAR2
986: , p5_a2 NUMBER := 0-1962.0724
987: , p5_a3 DATE := fnd_api.g_miss_date
988: , p5_a4 DATE := fnd_api.g_miss_date
989: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a7 DATE := fnd_api.g_miss_date
992: , p5_a8 VARCHAR2
993: , p_representation_type VARCHAR2
994: , x_trx_number out nocopy VARCHAR2
987: , p5_a3 DATE := fnd_api.g_miss_date
988: , p5_a4 DATE := fnd_api.g_miss_date
989: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
990: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a7 DATE := fnd_api.g_miss_date
992: , p5_a8 VARCHAR2
993: , p_representation_type VARCHAR2
994: , x_trx_number out nocopy VARCHAR2
995: )