APPS.OKL_SYSTEM_ACCT_OPT_PUB_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 250: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

246: , p5_a0 NUMBER := 0-1962.0724
247: , p5_a1 NUMBER := 0-1962.0724
248: , p5_a2 NUMBER := 0-1962.0724
249: , p5_a3 NUMBER := 0-1962.0724
250: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a6 NUMBER := 0-1962.0724
253: , p5_a7 NUMBER := 0-1962.0724
254: , p5_a8 NUMBER := 0-1962.0724

Line 251: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

247: , p5_a1 NUMBER := 0-1962.0724
248: , p5_a2 NUMBER := 0-1962.0724
249: , p5_a3 NUMBER := 0-1962.0724
250: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a6 NUMBER := 0-1962.0724
253: , p5_a7 NUMBER := 0-1962.0724
254: , p5_a8 NUMBER := 0-1962.0724
255: , p5_a9 NUMBER := 0-1962.0724

Line 265: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

261: , p5_a15 NUMBER := 0-1962.0724
262: , p5_a16 NUMBER := 0-1962.0724
263: , p5_a17 NUMBER := 0-1962.0724
264: , p5_a18 NUMBER := 0-1962.0724
265: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
266: , p5_a20 NUMBER := 0-1962.0724
267: , p5_a21 NUMBER := 0-1962.0724
268: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a23 NUMBER := 0-1962.0724

Line 268: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

264: , p5_a18 NUMBER := 0-1962.0724
265: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
266: , p5_a20 NUMBER := 0-1962.0724
267: , p5_a21 NUMBER := 0-1962.0724
268: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a23 NUMBER := 0-1962.0724
270: , p5_a24 NUMBER := 0-1962.0724
271: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 271: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

267: , p5_a21 NUMBER := 0-1962.0724
268: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a23 NUMBER := 0-1962.0724
270: , p5_a24 NUMBER := 0-1962.0724
271: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

Line 272: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

268: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a23 NUMBER := 0-1962.0724
270: , p5_a24 NUMBER := 0-1962.0724
271: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

Line 273: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

269: , p5_a23 NUMBER := 0-1962.0724
270: , p5_a24 NUMBER := 0-1962.0724
271: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

Line 274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

270: , p5_a24 NUMBER := 0-1962.0724
271: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

Line 275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

271: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

Line 276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

272: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

Line 277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

273: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char

Line 278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

274: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char

Line 279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

275: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char

Line 280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

276: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a38 VARCHAR2 := fnd_api.g_miss_char

Line 281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char

277: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a39 VARCHAR2 := fnd_api.g_miss_char

Line 282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char

278: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a40 VARCHAR2 := fnd_api.g_miss_char

Line 283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char

279: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a41 NUMBER := 0-1962.0724

Line 284: , p5_a38 VARCHAR2 := fnd_api.g_miss_char

280: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a41 NUMBER := 0-1962.0724
288: , p5_a42 NUMBER := 0-1962.0724

Line 285: , p5_a39 VARCHAR2 := fnd_api.g_miss_char

281: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a41 NUMBER := 0-1962.0724
288: , p5_a42 NUMBER := 0-1962.0724
289: , p5_a43 DATE := fnd_api.g_miss_date

Line 286: , p5_a40 VARCHAR2 := fnd_api.g_miss_char

282: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a41 NUMBER := 0-1962.0724
288: , p5_a42 NUMBER := 0-1962.0724
289: , p5_a43 DATE := fnd_api.g_miss_date
290: , p5_a44 NUMBER := 0-1962.0724

Line 289: , p5_a43 DATE := fnd_api.g_miss_date

285: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a41 NUMBER := 0-1962.0724
288: , p5_a42 NUMBER := 0-1962.0724
289: , p5_a43 DATE := fnd_api.g_miss_date
290: , p5_a44 NUMBER := 0-1962.0724
291: , p5_a45 DATE := fnd_api.g_miss_date
292: , p5_a46 NUMBER := 0-1962.0724
293: , p5_a47 VARCHAR2 := fnd_api.g_miss_char

Line 291: , p5_a45 DATE := fnd_api.g_miss_date

287: , p5_a41 NUMBER := 0-1962.0724
288: , p5_a42 NUMBER := 0-1962.0724
289: , p5_a43 DATE := fnd_api.g_miss_date
290: , p5_a44 NUMBER := 0-1962.0724
291: , p5_a45 DATE := fnd_api.g_miss_date
292: , p5_a46 NUMBER := 0-1962.0724
293: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a49 NUMBER := 0-1962.0724

Line 293: , p5_a47 VARCHAR2 := fnd_api.g_miss_char

289: , p5_a43 DATE := fnd_api.g_miss_date
290: , p5_a44 NUMBER := 0-1962.0724
291: , p5_a45 DATE := fnd_api.g_miss_date
292: , p5_a46 NUMBER := 0-1962.0724
293: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a49 NUMBER := 0-1962.0724
296: , p5_a50 NUMBER := 0-1962.0724
297: , p5_a51 VARCHAR2 := fnd_api.g_miss_char

Line 294: , p5_a48 VARCHAR2 := fnd_api.g_miss_char

290: , p5_a44 NUMBER := 0-1962.0724
291: , p5_a45 DATE := fnd_api.g_miss_date
292: , p5_a46 NUMBER := 0-1962.0724
293: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a49 NUMBER := 0-1962.0724
296: , p5_a50 NUMBER := 0-1962.0724
297: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a52 VARCHAR2 := fnd_api.g_miss_char

Line 297: , p5_a51 VARCHAR2 := fnd_api.g_miss_char

293: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a49 NUMBER := 0-1962.0724
296: , p5_a50 NUMBER := 0-1962.0724
297: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a55 VARCHAR2 := fnd_api.g_miss_char

Line 298: , p5_a52 VARCHAR2 := fnd_api.g_miss_char

294: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a49 NUMBER := 0-1962.0724
296: , p5_a50 NUMBER := 0-1962.0724
297: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a56 NUMBER := 0-1962.0724

Line 299: , p5_a53 VARCHAR2 := fnd_api.g_miss_char

295: , p5_a49 NUMBER := 0-1962.0724
296: , p5_a50 NUMBER := 0-1962.0724
297: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a56 NUMBER := 0-1962.0724
303: , p5_a57 VARCHAR2 := fnd_api.g_miss_char

Line 300: , p5_a54 VARCHAR2 := fnd_api.g_miss_char

296: , p5_a50 NUMBER := 0-1962.0724
297: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a56 NUMBER := 0-1962.0724
303: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a58 VARCHAR2 := fnd_api.g_miss_char

Line 301: , p5_a55 VARCHAR2 := fnd_api.g_miss_char

297: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a56 NUMBER := 0-1962.0724
303: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
305: )

Line 303: , p5_a57 VARCHAR2 := fnd_api.g_miss_char

299: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a56 NUMBER := 0-1962.0724
303: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
305: )
306:
307: as

Line 304: , p5_a58 VARCHAR2 := fnd_api.g_miss_char

300: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a56 NUMBER := 0-1962.0724
303: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a58 VARCHAR2 := fnd_api.g_miss_char
305: )
306:
307: as
308: ddp_saov_rec okl_system_acct_opt_pub.saov_rec_type;