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;
141: , p_contract_id NUMBER
142: , x_cash_receipt_id out nocopy NUMBER
143: , p8_a0 NUMBER := 0-1962.0724
144: , p8_a1 NUMBER := 0-1962.0724
145: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a4 NUMBER := 0-1962.0724
148: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a6 DATE := fnd_api.g_miss_date
142: , x_cash_receipt_id out nocopy NUMBER
143: , p8_a0 NUMBER := 0-1962.0724
144: , p8_a1 NUMBER := 0-1962.0724
145: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a4 NUMBER := 0-1962.0724
148: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a6 DATE := fnd_api.g_miss_date
150: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
144: , p8_a1 NUMBER := 0-1962.0724
145: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a4 NUMBER := 0-1962.0724
148: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a6 DATE := fnd_api.g_miss_date
150: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
151: , p8_a8 NUMBER := 0-1962.0724
152: , p8_a9 DATE := fnd_api.g_miss_date
145: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
146: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a4 NUMBER := 0-1962.0724
148: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a6 DATE := fnd_api.g_miss_date
150: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
151: , p8_a8 NUMBER := 0-1962.0724
152: , p8_a9 DATE := fnd_api.g_miss_date
153: , p8_a10 NUMBER := 0-1962.0724
146: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
147: , p8_a4 NUMBER := 0-1962.0724
148: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a6 DATE := fnd_api.g_miss_date
150: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
151: , p8_a8 NUMBER := 0-1962.0724
152: , p8_a9 DATE := fnd_api.g_miss_date
153: , p8_a10 NUMBER := 0-1962.0724
154: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
149: , p8_a6 DATE := fnd_api.g_miss_date
150: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
151: , p8_a8 NUMBER := 0-1962.0724
152: , p8_a9 DATE := fnd_api.g_miss_date
153: , p8_a10 NUMBER := 0-1962.0724
154: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
155: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
156: , p8_a13 NUMBER := 0-1962.0724
150: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
151: , p8_a8 NUMBER := 0-1962.0724
152: , p8_a9 DATE := fnd_api.g_miss_date
153: , p8_a10 NUMBER := 0-1962.0724
154: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
155: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
156: , p8_a13 NUMBER := 0-1962.0724
157: , p8_a14 NUMBER := 0-1962.0724
158: , p8_a15 NUMBER := 0-1962.0724
151: , p8_a8 NUMBER := 0-1962.0724
152: , p8_a9 DATE := fnd_api.g_miss_date
153: , p8_a10 NUMBER := 0-1962.0724
154: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
155: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
156: , p8_a13 NUMBER := 0-1962.0724
157: , p8_a14 NUMBER := 0-1962.0724
158: , p8_a15 NUMBER := 0-1962.0724
159: , p8_a16 DATE := fnd_api.g_miss_date
155: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
156: , p8_a13 NUMBER := 0-1962.0724
157: , p8_a14 NUMBER := 0-1962.0724
158: , p8_a15 NUMBER := 0-1962.0724
159: , p8_a16 DATE := fnd_api.g_miss_date
160: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
161: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
162: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
156: , p8_a13 NUMBER := 0-1962.0724
157: , p8_a14 NUMBER := 0-1962.0724
158: , p8_a15 NUMBER := 0-1962.0724
159: , p8_a16 DATE := fnd_api.g_miss_date
160: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
161: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
162: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
157: , p8_a14 NUMBER := 0-1962.0724
158: , p8_a15 NUMBER := 0-1962.0724
159: , p8_a16 DATE := fnd_api.g_miss_date
160: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
161: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
162: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
158: , p8_a15 NUMBER := 0-1962.0724
159: , p8_a16 DATE := fnd_api.g_miss_date
160: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
161: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
162: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
159: , p8_a16 DATE := fnd_api.g_miss_date
160: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
161: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
162: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
160: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
161: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
162: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
161: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
162: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
162: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
163: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
164: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
165: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
173: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
166: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
173: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
167: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
173: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
175: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
168: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
173: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
175: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
176: )
169: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
173: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
175: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
176: )
177:
170: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
173: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
175: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
176: )
177:
178: as
171: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
173: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
175: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
176: )
177:
178: as
179: ddp_rcpt_rec okl_cash_appl_rules.rcpt_rec_type;