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

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

Line 248: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

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

Line 262: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

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

Line 265: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

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

Line 268: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

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

Line 269: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

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

Line 270: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

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

Line 271: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

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

Line 272: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

268: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

Line 273: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

269: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

Line 274: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

270: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a35 VARCHAR2 := fnd_api.g_miss_char

Line 275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

271: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a36 VARCHAR2 := fnd_api.g_miss_char

Line 276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

272: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a37 VARCHAR2 := fnd_api.g_miss_char

Line 277: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

273: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a38 VARCHAR2 := fnd_api.g_miss_char

Line 278: , p5_a35 VARCHAR2 := fnd_api.g_miss_char

274: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a39 VARCHAR2 := fnd_api.g_miss_char

Line 279: , p5_a36 VARCHAR2 := fnd_api.g_miss_char

275: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a40 VARCHAR2 := fnd_api.g_miss_char

Line 280: , p5_a37 VARCHAR2 := fnd_api.g_miss_char

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

Line 281: , p5_a38 VARCHAR2 := fnd_api.g_miss_char

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

Line 282: , p5_a39 VARCHAR2 := fnd_api.g_miss_char

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

Line 283: , p5_a40 VARCHAR2 := fnd_api.g_miss_char

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

Line 286: , p5_a43 DATE := fnd_api.g_miss_date

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

Line 288: , p5_a45 DATE := fnd_api.g_miss_date

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

Line 290: , p5_a47 VARCHAR2 := fnd_api.g_miss_char

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

Line 291: , p5_a48 VARCHAR2 := fnd_api.g_miss_char

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

Line 294: , p5_a51 VARCHAR2 := fnd_api.g_miss_char

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

Line 295: , p5_a52 VARCHAR2 := fnd_api.g_miss_char

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

Line 296: , p5_a53 VARCHAR2 := fnd_api.g_miss_char

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

Line 297: , p5_a54 VARCHAR2 := fnd_api.g_miss_char

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

Line 298: , p5_a55 VARCHAR2 := fnd_api.g_miss_char

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

Line 300: , p5_a57 VARCHAR2 := fnd_api.g_miss_char

296: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a56 NUMBER := 0-1962.0724
300: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
301: )
302:
303: as
304: ddp_saov_rec okl_system_acct_opt_pub.saov_rec_type;