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;
471: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
472: , p2_a0 NUMBER := 0-1962.0724
473: , p2_a1 NUMBER := 0-1962.0724
474: , p2_a2 NUMBER := 0-1962.0724
475: , p2_a3 DATE := fnd_api.g_miss_date
476: , p2_a4 DATE := fnd_api.g_miss_date
477: , p2_a5 DATE := fnd_api.g_miss_date
478: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
479: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
472: , p2_a0 NUMBER := 0-1962.0724
473: , p2_a1 NUMBER := 0-1962.0724
474: , p2_a2 NUMBER := 0-1962.0724
475: , p2_a3 DATE := fnd_api.g_miss_date
476: , p2_a4 DATE := fnd_api.g_miss_date
477: , p2_a5 DATE := fnd_api.g_miss_date
478: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
479: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
480: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p2_a1 NUMBER := 0-1962.0724
474: , p2_a2 NUMBER := 0-1962.0724
475: , p2_a3 DATE := fnd_api.g_miss_date
476: , p2_a4 DATE := fnd_api.g_miss_date
477: , p2_a5 DATE := fnd_api.g_miss_date
478: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
479: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
480: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
481: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p2_a2 NUMBER := 0-1962.0724
475: , p2_a3 DATE := fnd_api.g_miss_date
476: , p2_a4 DATE := fnd_api.g_miss_date
477: , p2_a5 DATE := fnd_api.g_miss_date
478: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
479: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
480: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
481: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
482: , p2_a10 NUMBER := 0-1962.0724
475: , p2_a3 DATE := fnd_api.g_miss_date
476: , p2_a4 DATE := fnd_api.g_miss_date
477: , p2_a5 DATE := fnd_api.g_miss_date
478: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
479: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
480: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
481: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
482: , p2_a10 NUMBER := 0-1962.0724
483: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p2_a4 DATE := fnd_api.g_miss_date
477: , p2_a5 DATE := fnd_api.g_miss_date
478: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
479: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
480: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
481: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
482: , p2_a10 NUMBER := 0-1962.0724
483: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
484: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
477: , p2_a5 DATE := fnd_api.g_miss_date
478: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
479: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
480: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
481: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
482: , p2_a10 NUMBER := 0-1962.0724
483: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
484: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
485: , p2_a13 NUMBER := 0-1962.0724
479: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
480: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
481: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
482: , p2_a10 NUMBER := 0-1962.0724
483: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
484: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
485: , p2_a13 NUMBER := 0-1962.0724
486: , p2_a14 DATE := fnd_api.g_miss_date
487: , p2_a15 NUMBER := 0-1962.0724
480: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
481: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
482: , p2_a10 NUMBER := 0-1962.0724
483: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
484: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
485: , p2_a13 NUMBER := 0-1962.0724
486: , p2_a14 DATE := fnd_api.g_miss_date
487: , p2_a15 NUMBER := 0-1962.0724
488: , p2_a16 NUMBER := 0-1962.0724
482: , p2_a10 NUMBER := 0-1962.0724
483: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
484: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
485: , p2_a13 NUMBER := 0-1962.0724
486: , p2_a14 DATE := fnd_api.g_miss_date
487: , p2_a15 NUMBER := 0-1962.0724
488: , p2_a16 NUMBER := 0-1962.0724
489: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
490: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
485: , p2_a13 NUMBER := 0-1962.0724
486: , p2_a14 DATE := fnd_api.g_miss_date
487: , p2_a15 NUMBER := 0-1962.0724
488: , p2_a16 NUMBER := 0-1962.0724
489: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
490: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
491: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
492: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
493: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
486: , p2_a14 DATE := fnd_api.g_miss_date
487: , p2_a15 NUMBER := 0-1962.0724
488: , p2_a16 NUMBER := 0-1962.0724
489: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
490: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
491: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
492: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
493: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
494: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
487: , p2_a15 NUMBER := 0-1962.0724
488: , p2_a16 NUMBER := 0-1962.0724
489: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
490: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
491: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
492: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
493: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
494: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
495: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
488: , p2_a16 NUMBER := 0-1962.0724
489: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
490: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
491: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
492: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
493: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
494: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
495: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
496: , p2_a24 NUMBER := 0-1962.0724
489: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
490: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
491: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
492: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
493: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
494: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
495: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
496: , p2_a24 NUMBER := 0-1962.0724
497: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
490: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
491: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
492: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
493: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
494: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
495: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
496: , p2_a24 NUMBER := 0-1962.0724
497: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
498: , p2_a26 DATE := fnd_api.g_miss_date
491: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
492: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
493: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
494: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
495: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
496: , p2_a24 NUMBER := 0-1962.0724
497: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
498: , p2_a26 DATE := fnd_api.g_miss_date
499: )
493: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
494: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
495: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
496: , p2_a24 NUMBER := 0-1962.0724
497: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
498: , p2_a26 DATE := fnd_api.g_miss_date
499: )
500:
501: as
494: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
495: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
496: , p2_a24 NUMBER := 0-1962.0724
497: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
498: , p2_a26 DATE := fnd_api.g_miss_date
499: )
500:
501: as
502: ddp_catchup_rec okl_generate_accruals_pvt.accrual_rec_type;
874: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
875: , p2_a0 NUMBER := 0-1962.0724
876: , p2_a1 NUMBER := 0-1962.0724
877: , p2_a2 NUMBER := 0-1962.0724
878: , p2_a3 DATE := fnd_api.g_miss_date
879: , p2_a4 DATE := fnd_api.g_miss_date
880: , p2_a5 DATE := fnd_api.g_miss_date
881: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
882: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
875: , p2_a0 NUMBER := 0-1962.0724
876: , p2_a1 NUMBER := 0-1962.0724
877: , p2_a2 NUMBER := 0-1962.0724
878: , p2_a3 DATE := fnd_api.g_miss_date
879: , p2_a4 DATE := fnd_api.g_miss_date
880: , p2_a5 DATE := fnd_api.g_miss_date
881: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
882: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
883: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
876: , p2_a1 NUMBER := 0-1962.0724
877: , p2_a2 NUMBER := 0-1962.0724
878: , p2_a3 DATE := fnd_api.g_miss_date
879: , p2_a4 DATE := fnd_api.g_miss_date
880: , p2_a5 DATE := fnd_api.g_miss_date
881: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
882: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
883: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
884: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
877: , p2_a2 NUMBER := 0-1962.0724
878: , p2_a3 DATE := fnd_api.g_miss_date
879: , p2_a4 DATE := fnd_api.g_miss_date
880: , p2_a5 DATE := fnd_api.g_miss_date
881: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
882: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
883: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
884: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
885: , p2_a10 NUMBER := 0-1962.0724
878: , p2_a3 DATE := fnd_api.g_miss_date
879: , p2_a4 DATE := fnd_api.g_miss_date
880: , p2_a5 DATE := fnd_api.g_miss_date
881: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
882: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
883: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
884: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
885: , p2_a10 NUMBER := 0-1962.0724
886: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
879: , p2_a4 DATE := fnd_api.g_miss_date
880: , p2_a5 DATE := fnd_api.g_miss_date
881: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
882: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
883: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
884: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
885: , p2_a10 NUMBER := 0-1962.0724
886: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
887: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
880: , p2_a5 DATE := fnd_api.g_miss_date
881: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
882: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
883: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
884: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
885: , p2_a10 NUMBER := 0-1962.0724
886: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
887: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
888: , p2_a13 NUMBER := 0-1962.0724
882: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
883: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
884: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
885: , p2_a10 NUMBER := 0-1962.0724
886: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
887: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
888: , p2_a13 NUMBER := 0-1962.0724
889: , p2_a14 DATE := fnd_api.g_miss_date
890: , p2_a15 NUMBER := 0-1962.0724
883: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
884: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
885: , p2_a10 NUMBER := 0-1962.0724
886: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
887: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
888: , p2_a13 NUMBER := 0-1962.0724
889: , p2_a14 DATE := fnd_api.g_miss_date
890: , p2_a15 NUMBER := 0-1962.0724
891: , p2_a16 NUMBER := 0-1962.0724
885: , p2_a10 NUMBER := 0-1962.0724
886: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
887: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
888: , p2_a13 NUMBER := 0-1962.0724
889: , p2_a14 DATE := fnd_api.g_miss_date
890: , p2_a15 NUMBER := 0-1962.0724
891: , p2_a16 NUMBER := 0-1962.0724
892: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
893: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
888: , p2_a13 NUMBER := 0-1962.0724
889: , p2_a14 DATE := fnd_api.g_miss_date
890: , p2_a15 NUMBER := 0-1962.0724
891: , p2_a16 NUMBER := 0-1962.0724
892: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
893: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
894: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
895: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
896: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
889: , p2_a14 DATE := fnd_api.g_miss_date
890: , p2_a15 NUMBER := 0-1962.0724
891: , p2_a16 NUMBER := 0-1962.0724
892: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
893: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
894: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
895: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
896: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
897: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
890: , p2_a15 NUMBER := 0-1962.0724
891: , p2_a16 NUMBER := 0-1962.0724
892: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
893: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
894: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
895: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
896: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
897: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
898: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
891: , p2_a16 NUMBER := 0-1962.0724
892: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
893: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
894: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
895: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
896: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
897: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
898: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
899: , p2_a24 NUMBER := 0-1962.0724
892: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
893: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
894: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
895: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
896: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
897: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
898: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
899: , p2_a24 NUMBER := 0-1962.0724
900: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
893: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
894: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
895: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
896: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
897: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
898: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
899: , p2_a24 NUMBER := 0-1962.0724
900: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
901: , p2_a26 DATE := fnd_api.g_miss_date
894: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
895: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
896: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
897: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
898: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
899: , p2_a24 NUMBER := 0-1962.0724
900: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
901: , p2_a26 DATE := fnd_api.g_miss_date
902: )
896: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
897: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
898: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
899: , p2_a24 NUMBER := 0-1962.0724
900: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
901: , p2_a26 DATE := fnd_api.g_miss_date
902: )
903:
904: as
897: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
898: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
899: , p2_a24 NUMBER := 0-1962.0724
900: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
901: , p2_a26 DATE := fnd_api.g_miss_date
902: )
903:
904: as
905: ddp_reverse_rec okl_generate_accruals_pvt.accrual_rec_type;
1537: , p9_a57 out nocopy JTF_VARCHAR2_TABLE_100
1538: , p2_a0 NUMBER := 0-1962.0724
1539: , p2_a1 NUMBER := 0-1962.0724
1540: , p2_a2 NUMBER := 0-1962.0724
1541: , p2_a3 DATE := fnd_api.g_miss_date
1542: , p2_a4 DATE := fnd_api.g_miss_date
1543: , p2_a5 DATE := fnd_api.g_miss_date
1544: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
1545: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
1538: , p2_a0 NUMBER := 0-1962.0724
1539: , p2_a1 NUMBER := 0-1962.0724
1540: , p2_a2 NUMBER := 0-1962.0724
1541: , p2_a3 DATE := fnd_api.g_miss_date
1542: , p2_a4 DATE := fnd_api.g_miss_date
1543: , p2_a5 DATE := fnd_api.g_miss_date
1544: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
1545: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
1546: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
1539: , p2_a1 NUMBER := 0-1962.0724
1540: , p2_a2 NUMBER := 0-1962.0724
1541: , p2_a3 DATE := fnd_api.g_miss_date
1542: , p2_a4 DATE := fnd_api.g_miss_date
1543: , p2_a5 DATE := fnd_api.g_miss_date
1544: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
1545: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
1546: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
1547: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
1540: , p2_a2 NUMBER := 0-1962.0724
1541: , p2_a3 DATE := fnd_api.g_miss_date
1542: , p2_a4 DATE := fnd_api.g_miss_date
1543: , p2_a5 DATE := fnd_api.g_miss_date
1544: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
1545: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
1546: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
1547: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
1548: , p2_a10 NUMBER := 0-1962.0724
1541: , p2_a3 DATE := fnd_api.g_miss_date
1542: , p2_a4 DATE := fnd_api.g_miss_date
1543: , p2_a5 DATE := fnd_api.g_miss_date
1544: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
1545: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
1546: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
1547: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
1548: , p2_a10 NUMBER := 0-1962.0724
1549: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
1542: , p2_a4 DATE := fnd_api.g_miss_date
1543: , p2_a5 DATE := fnd_api.g_miss_date
1544: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
1545: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
1546: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
1547: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
1548: , p2_a10 NUMBER := 0-1962.0724
1549: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
1550: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
1543: , p2_a5 DATE := fnd_api.g_miss_date
1544: , p2_a6 VARCHAR2 := fnd_api.g_miss_char
1545: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
1546: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
1547: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
1548: , p2_a10 NUMBER := 0-1962.0724
1549: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
1550: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
1551: , p2_a13 NUMBER := 0-1962.0724
1545: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
1546: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
1547: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
1548: , p2_a10 NUMBER := 0-1962.0724
1549: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
1550: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
1551: , p2_a13 NUMBER := 0-1962.0724
1552: , p2_a14 DATE := fnd_api.g_miss_date
1553: , p2_a15 NUMBER := 0-1962.0724
1546: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
1547: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
1548: , p2_a10 NUMBER := 0-1962.0724
1549: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
1550: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
1551: , p2_a13 NUMBER := 0-1962.0724
1552: , p2_a14 DATE := fnd_api.g_miss_date
1553: , p2_a15 NUMBER := 0-1962.0724
1554: , p2_a16 NUMBER := 0-1962.0724
1548: , p2_a10 NUMBER := 0-1962.0724
1549: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
1550: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
1551: , p2_a13 NUMBER := 0-1962.0724
1552: , p2_a14 DATE := fnd_api.g_miss_date
1553: , p2_a15 NUMBER := 0-1962.0724
1554: , p2_a16 NUMBER := 0-1962.0724
1555: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
1556: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
1551: , p2_a13 NUMBER := 0-1962.0724
1552: , p2_a14 DATE := fnd_api.g_miss_date
1553: , p2_a15 NUMBER := 0-1962.0724
1554: , p2_a16 NUMBER := 0-1962.0724
1555: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
1556: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
1557: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
1558: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
1559: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p2_a14 DATE := fnd_api.g_miss_date
1553: , p2_a15 NUMBER := 0-1962.0724
1554: , p2_a16 NUMBER := 0-1962.0724
1555: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
1556: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
1557: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
1558: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
1559: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
1560: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p2_a15 NUMBER := 0-1962.0724
1554: , p2_a16 NUMBER := 0-1962.0724
1555: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
1556: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
1557: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
1558: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
1559: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
1560: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
1561: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p2_a16 NUMBER := 0-1962.0724
1555: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
1556: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
1557: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
1558: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
1559: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
1560: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
1561: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
1562: , p2_a24 NUMBER := 0-1962.0724
1555: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
1556: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
1557: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
1558: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
1559: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
1560: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
1561: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
1562: , p2_a24 NUMBER := 0-1962.0724
1563: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
1557: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
1558: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
1559: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
1560: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
1561: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
1562: , p2_a24 NUMBER := 0-1962.0724
1563: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
1564: , p2_a26 DATE := fnd_api.g_miss_date
1557: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
1558: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
1559: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
1560: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
1561: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
1562: , p2_a24 NUMBER := 0-1962.0724
1563: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
1564: , p2_a26 DATE := fnd_api.g_miss_date
1565: )
1559: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
1560: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
1561: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
1562: , p2_a24 NUMBER := 0-1962.0724
1563: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
1564: , p2_a26 DATE := fnd_api.g_miss_date
1565: )
1566:
1567: as
1560: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
1561: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
1562: , p2_a24 NUMBER := 0-1962.0724
1563: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
1564: , p2_a26 DATE := fnd_api.g_miss_date
1565: )
1566:
1567: as
1568: ddp_reverse_rec okl_generate_accruals_pvt.accrual_rec_type;
1950: , x_msg_data out nocopy VARCHAR2
1951: , p5_a0 NUMBER := 0-1962.0724
1952: , p5_a1 NUMBER := 0-1962.0724
1953: , p5_a2 NUMBER := 0-1962.0724
1954: , p5_a3 DATE := fnd_api.g_miss_date
1955: , p5_a4 DATE := fnd_api.g_miss_date
1956: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a7 DATE := fnd_api.g_miss_date
1951: , p5_a0 NUMBER := 0-1962.0724
1952: , p5_a1 NUMBER := 0-1962.0724
1953: , p5_a2 NUMBER := 0-1962.0724
1954: , p5_a3 DATE := fnd_api.g_miss_date
1955: , p5_a4 DATE := fnd_api.g_miss_date
1956: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a7 DATE := fnd_api.g_miss_date
1959: , p5_a8 VARCHAR2
1952: , p5_a1 NUMBER := 0-1962.0724
1953: , p5_a2 NUMBER := 0-1962.0724
1954: , p5_a3 DATE := fnd_api.g_miss_date
1955: , p5_a4 DATE := fnd_api.g_miss_date
1956: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a7 DATE := fnd_api.g_miss_date
1959: , p5_a8 VARCHAR2
1960: , p_representation_type VARCHAR2
1953: , p5_a2 NUMBER := 0-1962.0724
1954: , p5_a3 DATE := fnd_api.g_miss_date
1955: , p5_a4 DATE := fnd_api.g_miss_date
1956: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a7 DATE := fnd_api.g_miss_date
1959: , p5_a8 VARCHAR2
1960: , p_representation_type VARCHAR2
1961: , x_trx_number out nocopy VARCHAR2
1954: , p5_a3 DATE := fnd_api.g_miss_date
1955: , p5_a4 DATE := fnd_api.g_miss_date
1956: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a7 DATE := fnd_api.g_miss_date
1959: , p5_a8 VARCHAR2
1960: , p_representation_type VARCHAR2
1961: , x_trx_number out nocopy VARCHAR2
1962: )
2014: , p7_a3 JTF_NUMBER_TABLE
2015: , p7_a4 JTF_NUMBER_TABLE
2016: , p7_a5 JTF_NUMBER_TABLE
2017: , p6_a0 NUMBER := 0-1962.0724
2018: , p6_a1 DATE := fnd_api.g_miss_date
2019: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
2020: , p6_a3 NUMBER := 0-1962.0724
2021: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
2022: )
2015: , p7_a4 JTF_NUMBER_TABLE
2016: , p7_a5 JTF_NUMBER_TABLE
2017: , p6_a0 NUMBER := 0-1962.0724
2018: , p6_a1 DATE := fnd_api.g_miss_date
2019: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
2020: , p6_a3 NUMBER := 0-1962.0724
2021: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
2022: )
2023:
2017: , p6_a0 NUMBER := 0-1962.0724
2018: , p6_a1 DATE := fnd_api.g_miss_date
2019: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
2020: , p6_a3 NUMBER := 0-1962.0724
2021: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
2022: )
2023:
2024: as
2025: ddp_accrual_rec okl_generate_accruals_pvt.adjust_accrual_rec_type;
2074: , x_return_status out nocopy VARCHAR2
2075: , x_msg_count out nocopy NUMBER
2076: , x_msg_data out nocopy VARCHAR2
2077: , p5_a0 NUMBER := 0-1962.0724
2078: , p5_a1 DATE := fnd_api.g_miss_date
2079: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2080: , p5_a3 NUMBER := 0-1962.0724
2081: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2082: )
2075: , x_msg_count out nocopy NUMBER
2076: , x_msg_data out nocopy VARCHAR2
2077: , p5_a0 NUMBER := 0-1962.0724
2078: , p5_a1 DATE := fnd_api.g_miss_date
2079: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2080: , p5_a3 NUMBER := 0-1962.0724
2081: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2082: )
2083:
2077: , p5_a0 NUMBER := 0-1962.0724
2078: , p5_a1 DATE := fnd_api.g_miss_date
2079: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2080: , p5_a3 NUMBER := 0-1962.0724
2081: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2082: )
2083:
2084: as
2085: ddp_accrual_rec okl_generate_accruals_pvt.adjust_accrual_rec_type;