DBA Data[Home] [Help]

APPS.OKL_CASH_APPL_RULES_W dependencies on FND_API

Line 11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;

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:

Line 12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;

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

Line 17: a number := fnd_api.g_miss_num;

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;

Line 168: , p8_a2 VARCHAR2 := fnd_api.g_miss_char

164: , p_contract_id NUMBER
165: , x_cash_receipt_id out nocopy NUMBER
166: , p8_a0 NUMBER := 0-1962.0724
167: , p8_a1 NUMBER := 0-1962.0724
168: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a4 NUMBER := 0-1962.0724
171: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a6 DATE := fnd_api.g_miss_date

Line 169: , p8_a3 VARCHAR2 := fnd_api.g_miss_char

165: , x_cash_receipt_id out nocopy NUMBER
166: , p8_a0 NUMBER := 0-1962.0724
167: , p8_a1 NUMBER := 0-1962.0724
168: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a4 NUMBER := 0-1962.0724
171: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a6 DATE := fnd_api.g_miss_date
173: , p8_a7 VARCHAR2 := fnd_api.g_miss_char

Line 171: , p8_a5 VARCHAR2 := fnd_api.g_miss_char

167: , p8_a1 NUMBER := 0-1962.0724
168: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a4 NUMBER := 0-1962.0724
171: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a6 DATE := fnd_api.g_miss_date
173: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a8 NUMBER := 0-1962.0724
175: , p8_a9 DATE := fnd_api.g_miss_date

Line 172: , p8_a6 DATE := fnd_api.g_miss_date

168: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
169: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a4 NUMBER := 0-1962.0724
171: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a6 DATE := fnd_api.g_miss_date
173: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a8 NUMBER := 0-1962.0724
175: , p8_a9 DATE := fnd_api.g_miss_date
176: , p8_a10 NUMBER := 0-1962.0724

Line 173: , p8_a7 VARCHAR2 := fnd_api.g_miss_char

169: , p8_a3 VARCHAR2 := fnd_api.g_miss_char
170: , p8_a4 NUMBER := 0-1962.0724
171: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a6 DATE := fnd_api.g_miss_date
173: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a8 NUMBER := 0-1962.0724
175: , p8_a9 DATE := fnd_api.g_miss_date
176: , p8_a10 NUMBER := 0-1962.0724
177: , p8_a11 VARCHAR2 := fnd_api.g_miss_char

Line 175: , p8_a9 DATE := fnd_api.g_miss_date

171: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
172: , p8_a6 DATE := fnd_api.g_miss_date
173: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a8 NUMBER := 0-1962.0724
175: , p8_a9 DATE := fnd_api.g_miss_date
176: , p8_a10 NUMBER := 0-1962.0724
177: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
179: , p8_a13 NUMBER := 0-1962.0724

Line 177: , p8_a11 VARCHAR2 := fnd_api.g_miss_char

173: , p8_a7 VARCHAR2 := fnd_api.g_miss_char
174: , p8_a8 NUMBER := 0-1962.0724
175: , p8_a9 DATE := fnd_api.g_miss_date
176: , p8_a10 NUMBER := 0-1962.0724
177: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
179: , p8_a13 NUMBER := 0-1962.0724
180: , p8_a14 NUMBER := 0-1962.0724
181: , p8_a15 NUMBER := 0-1962.0724

Line 178: , p8_a12 VARCHAR2 := fnd_api.g_miss_char

174: , p8_a8 NUMBER := 0-1962.0724
175: , p8_a9 DATE := fnd_api.g_miss_date
176: , p8_a10 NUMBER := 0-1962.0724
177: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
178: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
179: , p8_a13 NUMBER := 0-1962.0724
180: , p8_a14 NUMBER := 0-1962.0724
181: , p8_a15 NUMBER := 0-1962.0724
182: , p8_a16 DATE := fnd_api.g_miss_date

Line 182: , p8_a16 DATE := fnd_api.g_miss_date

178: , p8_a12 VARCHAR2 := fnd_api.g_miss_char
179: , p8_a13 NUMBER := 0-1962.0724
180: , p8_a14 NUMBER := 0-1962.0724
181: , p8_a15 NUMBER := 0-1962.0724
182: , p8_a16 DATE := fnd_api.g_miss_date
183: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char

Line 183: , p8_a17 VARCHAR2 := fnd_api.g_miss_char

179: , p8_a13 NUMBER := 0-1962.0724
180: , p8_a14 NUMBER := 0-1962.0724
181: , p8_a15 NUMBER := 0-1962.0724
182: , p8_a16 DATE := fnd_api.g_miss_date
183: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char

Line 184: , p8_a18 VARCHAR2 := fnd_api.g_miss_char

180: , p8_a14 NUMBER := 0-1962.0724
181: , p8_a15 NUMBER := 0-1962.0724
182: , p8_a16 DATE := fnd_api.g_miss_date
183: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char

Line 185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char

181: , p8_a15 NUMBER := 0-1962.0724
182: , p8_a16 DATE := fnd_api.g_miss_date
183: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char

Line 186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char

182: , p8_a16 DATE := fnd_api.g_miss_date
183: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char

Line 187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char

183: , p8_a17 VARCHAR2 := fnd_api.g_miss_char
184: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char

Line 188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char

184: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char

Line 189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char

185: , p8_a19 VARCHAR2 := fnd_api.g_miss_char
186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char

Line 190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char

186: , p8_a20 VARCHAR2 := fnd_api.g_miss_char
187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char

Line 191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char

187: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char

Line 192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char

188: , p8_a22 VARCHAR2 := fnd_api.g_miss_char
189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p8_a30 VARCHAR2 := fnd_api.g_miss_char

Line 193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char

189: , p8_a23 VARCHAR2 := fnd_api.g_miss_char
190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p8_a31 VARCHAR2 := fnd_api.g_miss_char

Line 194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char

190: , p8_a24 VARCHAR2 := fnd_api.g_miss_char
191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p8_a32 VARCHAR2 := fnd_api.g_miss_char

Line 195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char

191: , p8_a25 VARCHAR2 := fnd_api.g_miss_char
192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
199: )

Line 196: , p8_a30 VARCHAR2 := fnd_api.g_miss_char

192: , p8_a26 VARCHAR2 := fnd_api.g_miss_char
193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
199: )
200:

Line 197: , p8_a31 VARCHAR2 := fnd_api.g_miss_char

193: , p8_a27 VARCHAR2 := fnd_api.g_miss_char
194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
199: )
200:
201: as

Line 198: , p8_a32 VARCHAR2 := fnd_api.g_miss_char

194: , p8_a28 VARCHAR2 := fnd_api.g_miss_char
195: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
196: , p8_a30 VARCHAR2 := fnd_api.g_miss_char
197: , p8_a31 VARCHAR2 := fnd_api.g_miss_char
198: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
199: )
200:
201: as
202: ddp_rcpt_rec okl_cash_appl_rules.rcpt_rec_type;