APPS.AMS_REL_ITEM_PVT_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as

Line 14: a number := fnd_api.g_miss_num;

10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;

Line 167: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

163: , p7_a0 NUMBER := 0-1962.0724
164: , p7_a1 NUMBER := 0-1962.0724
165: , p7_a2 NUMBER := 0-1962.0724
166: , p7_a3 NUMBER := 0-1962.0724
167: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a5 DATE := fnd_api.g_miss_date
169: , p7_a6 NUMBER := 0-1962.0724
170: , p7_a7 DATE := fnd_api.g_miss_date
171: , p7_a8 NUMBER := 0-1962.0724

Line 168: , p7_a5 DATE := fnd_api.g_miss_date

164: , p7_a1 NUMBER := 0-1962.0724
165: , p7_a2 NUMBER := 0-1962.0724
166: , p7_a3 NUMBER := 0-1962.0724
167: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a5 DATE := fnd_api.g_miss_date
169: , p7_a6 NUMBER := 0-1962.0724
170: , p7_a7 DATE := fnd_api.g_miss_date
171: , p7_a8 NUMBER := 0-1962.0724
172: , p7_a9 NUMBER := 0-1962.0724

Line 170: , p7_a7 DATE := fnd_api.g_miss_date

166: , p7_a3 NUMBER := 0-1962.0724
167: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a5 DATE := fnd_api.g_miss_date
169: , p7_a6 NUMBER := 0-1962.0724
170: , p7_a7 DATE := fnd_api.g_miss_date
171: , p7_a8 NUMBER := 0-1962.0724
172: , p7_a9 NUMBER := 0-1962.0724
173: , p7_a10 NUMBER := 0-1962.0724
174: , p7_a11 NUMBER := 0-1962.0724

Line 176: , p7_a13 DATE := fnd_api.g_miss_date

172: , p7_a9 NUMBER := 0-1962.0724
173: , p7_a10 NUMBER := 0-1962.0724
174: , p7_a11 NUMBER := 0-1962.0724
175: , p7_a12 NUMBER := 0-1962.0724
176: , p7_a13 DATE := fnd_api.g_miss_date
177: )
178:
179: as
180: ddp_rel_item_rec ams_rel_item_pvt.rel_item_rec_type;

Line 238: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

234: , p7_a0 NUMBER := 0-1962.0724
235: , p7_a1 NUMBER := 0-1962.0724
236: , p7_a2 NUMBER := 0-1962.0724
237: , p7_a3 NUMBER := 0-1962.0724
238: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a5 DATE := fnd_api.g_miss_date
240: , p7_a6 NUMBER := 0-1962.0724
241: , p7_a7 DATE := fnd_api.g_miss_date
242: , p7_a8 NUMBER := 0-1962.0724

Line 239: , p7_a5 DATE := fnd_api.g_miss_date

235: , p7_a1 NUMBER := 0-1962.0724
236: , p7_a2 NUMBER := 0-1962.0724
237: , p7_a3 NUMBER := 0-1962.0724
238: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a5 DATE := fnd_api.g_miss_date
240: , p7_a6 NUMBER := 0-1962.0724
241: , p7_a7 DATE := fnd_api.g_miss_date
242: , p7_a8 NUMBER := 0-1962.0724
243: , p7_a9 NUMBER := 0-1962.0724

Line 241: , p7_a7 DATE := fnd_api.g_miss_date

237: , p7_a3 NUMBER := 0-1962.0724
238: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a5 DATE := fnd_api.g_miss_date
240: , p7_a6 NUMBER := 0-1962.0724
241: , p7_a7 DATE := fnd_api.g_miss_date
242: , p7_a8 NUMBER := 0-1962.0724
243: , p7_a9 NUMBER := 0-1962.0724
244: , p7_a10 NUMBER := 0-1962.0724
245: , p7_a11 NUMBER := 0-1962.0724

Line 247: , p7_a13 DATE := fnd_api.g_miss_date

243: , p7_a9 NUMBER := 0-1962.0724
244: , p7_a10 NUMBER := 0-1962.0724
245: , p7_a11 NUMBER := 0-1962.0724
246: , p7_a12 NUMBER := 0-1962.0724
247: , p7_a13 DATE := fnd_api.g_miss_date
248: )
249:
250: as
251: ddp_rel_item_rec ams_rel_item_pvt.rel_item_rec_type;

Line 309: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

305: , p7_a0 NUMBER := 0-1962.0724
306: , p7_a1 NUMBER := 0-1962.0724
307: , p7_a2 NUMBER := 0-1962.0724
308: , p7_a3 NUMBER := 0-1962.0724
309: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a5 DATE := fnd_api.g_miss_date
311: , p7_a6 NUMBER := 0-1962.0724
312: , p7_a7 DATE := fnd_api.g_miss_date
313: , p7_a8 NUMBER := 0-1962.0724

Line 310: , p7_a5 DATE := fnd_api.g_miss_date

306: , p7_a1 NUMBER := 0-1962.0724
307: , p7_a2 NUMBER := 0-1962.0724
308: , p7_a3 NUMBER := 0-1962.0724
309: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a5 DATE := fnd_api.g_miss_date
311: , p7_a6 NUMBER := 0-1962.0724
312: , p7_a7 DATE := fnd_api.g_miss_date
313: , p7_a8 NUMBER := 0-1962.0724
314: , p7_a9 NUMBER := 0-1962.0724

Line 312: , p7_a7 DATE := fnd_api.g_miss_date

308: , p7_a3 NUMBER := 0-1962.0724
309: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a5 DATE := fnd_api.g_miss_date
311: , p7_a6 NUMBER := 0-1962.0724
312: , p7_a7 DATE := fnd_api.g_miss_date
313: , p7_a8 NUMBER := 0-1962.0724
314: , p7_a9 NUMBER := 0-1962.0724
315: , p7_a10 NUMBER := 0-1962.0724
316: , p7_a11 NUMBER := 0-1962.0724

Line 318: , p7_a13 DATE := fnd_api.g_miss_date

314: , p7_a9 NUMBER := 0-1962.0724
315: , p7_a10 NUMBER := 0-1962.0724
316: , p7_a11 NUMBER := 0-1962.0724
317: , p7_a12 NUMBER := 0-1962.0724
318: , p7_a13 DATE := fnd_api.g_miss_date
319: )
320:
321: as
322: ddp_rel_item_rec ams_rel_item_pvt.rel_item_rec_type;

Line 378: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

374: , p5_a0 NUMBER := 0-1962.0724
375: , p5_a1 NUMBER := 0-1962.0724
376: , p5_a2 NUMBER := 0-1962.0724
377: , p5_a3 NUMBER := 0-1962.0724
378: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a5 DATE := fnd_api.g_miss_date
380: , p5_a6 NUMBER := 0-1962.0724
381: , p5_a7 DATE := fnd_api.g_miss_date
382: , p5_a8 NUMBER := 0-1962.0724

Line 379: , p5_a5 DATE := fnd_api.g_miss_date

375: , p5_a1 NUMBER := 0-1962.0724
376: , p5_a2 NUMBER := 0-1962.0724
377: , p5_a3 NUMBER := 0-1962.0724
378: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a5 DATE := fnd_api.g_miss_date
380: , p5_a6 NUMBER := 0-1962.0724
381: , p5_a7 DATE := fnd_api.g_miss_date
382: , p5_a8 NUMBER := 0-1962.0724
383: , p5_a9 NUMBER := 0-1962.0724

Line 381: , p5_a7 DATE := fnd_api.g_miss_date

377: , p5_a3 NUMBER := 0-1962.0724
378: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a5 DATE := fnd_api.g_miss_date
380: , p5_a6 NUMBER := 0-1962.0724
381: , p5_a7 DATE := fnd_api.g_miss_date
382: , p5_a8 NUMBER := 0-1962.0724
383: , p5_a9 NUMBER := 0-1962.0724
384: , p5_a10 NUMBER := 0-1962.0724
385: , p5_a11 NUMBER := 0-1962.0724

Line 387: , p5_a13 DATE := fnd_api.g_miss_date

383: , p5_a9 NUMBER := 0-1962.0724
384: , p5_a10 NUMBER := 0-1962.0724
385: , p5_a11 NUMBER := 0-1962.0724
386: , p5_a12 NUMBER := 0-1962.0724
387: , p5_a13 DATE := fnd_api.g_miss_date
388: )
389:
390: as
391: ddp_rel_item_rec ams_rel_item_pvt.rel_item_rec_type;

Line 442: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

438: , p3_a0 NUMBER := 0-1962.0724
439: , p3_a1 NUMBER := 0-1962.0724
440: , p3_a2 NUMBER := 0-1962.0724
441: , p3_a3 NUMBER := 0-1962.0724
442: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a5 DATE := fnd_api.g_miss_date
444: , p3_a6 NUMBER := 0-1962.0724
445: , p3_a7 DATE := fnd_api.g_miss_date
446: , p3_a8 NUMBER := 0-1962.0724

Line 443: , p3_a5 DATE := fnd_api.g_miss_date

439: , p3_a1 NUMBER := 0-1962.0724
440: , p3_a2 NUMBER := 0-1962.0724
441: , p3_a3 NUMBER := 0-1962.0724
442: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a5 DATE := fnd_api.g_miss_date
444: , p3_a6 NUMBER := 0-1962.0724
445: , p3_a7 DATE := fnd_api.g_miss_date
446: , p3_a8 NUMBER := 0-1962.0724
447: , p3_a9 NUMBER := 0-1962.0724

Line 445: , p3_a7 DATE := fnd_api.g_miss_date

441: , p3_a3 NUMBER := 0-1962.0724
442: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a5 DATE := fnd_api.g_miss_date
444: , p3_a6 NUMBER := 0-1962.0724
445: , p3_a7 DATE := fnd_api.g_miss_date
446: , p3_a8 NUMBER := 0-1962.0724
447: , p3_a9 NUMBER := 0-1962.0724
448: , p3_a10 NUMBER := 0-1962.0724
449: , p3_a11 NUMBER := 0-1962.0724

Line 451: , p3_a13 DATE := fnd_api.g_miss_date

447: , p3_a9 NUMBER := 0-1962.0724
448: , p3_a10 NUMBER := 0-1962.0724
449: , p3_a11 NUMBER := 0-1962.0724
450: , p3_a12 NUMBER := 0-1962.0724
451: , p3_a13 DATE := fnd_api.g_miss_date
452: )
453:
454: as
455: ddp_rel_item_rec ams_rel_item_pvt.rel_item_rec_type;