APPS.AMS_DM_TARGET_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 165: , p7_a1 DATE := fnd_api.g_miss_date

161: , x_msg_count out nocopy NUMBER
162: , x_msg_data out nocopy VARCHAR2
163: , x_target_id out nocopy NUMBER
164: , p7_a0 NUMBER := 0-1962.0724
165: , p7_a1 DATE := fnd_api.g_miss_date
166: , p7_a2 NUMBER := 0-1962.0724
167: , p7_a3 DATE := fnd_api.g_miss_date
168: , p7_a4 NUMBER := 0-1962.0724
169: , p7_a5 NUMBER := 0-1962.0724

Line 167: , p7_a3 DATE := fnd_api.g_miss_date

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

Line 171: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

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

Line 172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

168: , p7_a4 NUMBER := 0-1962.0724
169: , p7_a5 NUMBER := 0-1962.0724
170: , p7_a6 NUMBER := 0-1962.0724
171: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a9 NUMBER := 0-1962.0724
174: , p7_a10 NUMBER := 0-1962.0724
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

171: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a9 NUMBER := 0-1962.0724
174: , p7_a10 NUMBER := 0-1962.0724
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a13 NUMBER := 0-1962.0724
178: )
179:

Line 176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a9 NUMBER := 0-1962.0724
174: , p7_a10 NUMBER := 0-1962.0724
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a13 NUMBER := 0-1962.0724
178: )
179:
180: as

Line 240: , p7_a1 DATE := fnd_api.g_miss_date

236: , x_msg_count out nocopy NUMBER
237: , x_msg_data out nocopy VARCHAR2
238: , x_object_version_number out nocopy NUMBER
239: , p7_a0 NUMBER := 0-1962.0724
240: , p7_a1 DATE := fnd_api.g_miss_date
241: , p7_a2 NUMBER := 0-1962.0724
242: , p7_a3 DATE := fnd_api.g_miss_date
243: , p7_a4 NUMBER := 0-1962.0724
244: , p7_a5 NUMBER := 0-1962.0724

Line 242: , p7_a3 DATE := fnd_api.g_miss_date

238: , x_object_version_number out nocopy NUMBER
239: , p7_a0 NUMBER := 0-1962.0724
240: , p7_a1 DATE := fnd_api.g_miss_date
241: , p7_a2 NUMBER := 0-1962.0724
242: , p7_a3 DATE := fnd_api.g_miss_date
243: , p7_a4 NUMBER := 0-1962.0724
244: , p7_a5 NUMBER := 0-1962.0724
245: , p7_a6 NUMBER := 0-1962.0724
246: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 246: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

242: , p7_a3 DATE := fnd_api.g_miss_date
243: , p7_a4 NUMBER := 0-1962.0724
244: , p7_a5 NUMBER := 0-1962.0724
245: , p7_a6 NUMBER := 0-1962.0724
246: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a9 NUMBER := 0-1962.0724
249: , p7_a10 NUMBER := 0-1962.0724
250: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 247: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

243: , p7_a4 NUMBER := 0-1962.0724
244: , p7_a5 NUMBER := 0-1962.0724
245: , p7_a6 NUMBER := 0-1962.0724
246: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a9 NUMBER := 0-1962.0724
249: , p7_a10 NUMBER := 0-1962.0724
250: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 250: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

246: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a9 NUMBER := 0-1962.0724
249: , p7_a10 NUMBER := 0-1962.0724
250: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a13 NUMBER := 0-1962.0724
253: )
254:

Line 251: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

247: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a9 NUMBER := 0-1962.0724
249: , p7_a10 NUMBER := 0-1962.0724
250: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a13 NUMBER := 0-1962.0724
253: )
254:
255: as

Line 314: , p3_a1 DATE := fnd_api.g_miss_date

310: , x_return_status out nocopy VARCHAR2
311: , x_msg_count out nocopy NUMBER
312: , x_msg_data out nocopy VARCHAR2
313: , p3_a0 NUMBER := 0-1962.0724
314: , p3_a1 DATE := fnd_api.g_miss_date
315: , p3_a2 NUMBER := 0-1962.0724
316: , p3_a3 DATE := fnd_api.g_miss_date
317: , p3_a4 NUMBER := 0-1962.0724
318: , p3_a5 NUMBER := 0-1962.0724

Line 316: , p3_a3 DATE := fnd_api.g_miss_date

312: , x_msg_data out nocopy VARCHAR2
313: , p3_a0 NUMBER := 0-1962.0724
314: , p3_a1 DATE := fnd_api.g_miss_date
315: , p3_a2 NUMBER := 0-1962.0724
316: , p3_a3 DATE := fnd_api.g_miss_date
317: , p3_a4 NUMBER := 0-1962.0724
318: , p3_a5 NUMBER := 0-1962.0724
319: , p3_a6 NUMBER := 0-1962.0724
320: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

Line 320: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

316: , p3_a3 DATE := fnd_api.g_miss_date
317: , p3_a4 NUMBER := 0-1962.0724
318: , p3_a5 NUMBER := 0-1962.0724
319: , p3_a6 NUMBER := 0-1962.0724
320: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
321: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p3_a9 NUMBER := 0-1962.0724
323: , p3_a10 NUMBER := 0-1962.0724
324: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

Line 321: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

317: , p3_a4 NUMBER := 0-1962.0724
318: , p3_a5 NUMBER := 0-1962.0724
319: , p3_a6 NUMBER := 0-1962.0724
320: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
321: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p3_a9 NUMBER := 0-1962.0724
323: , p3_a10 NUMBER := 0-1962.0724
324: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

Line 324: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

320: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
321: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p3_a9 NUMBER := 0-1962.0724
323: , p3_a10 NUMBER := 0-1962.0724
324: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
326: , p3_a13 NUMBER := 0-1962.0724
327: )
328:

Line 325: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

321: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p3_a9 NUMBER := 0-1962.0724
323: , p3_a10 NUMBER := 0-1962.0724
324: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
326: , p3_a13 NUMBER := 0-1962.0724
327: )
328:
329: as

Line 380: , p0_a1 DATE := fnd_api.g_miss_date

376:
377: procedure check_dm_target_items(p_validation_mode VARCHAR2
378: , x_return_status out nocopy VARCHAR2
379: , p0_a0 NUMBER := 0-1962.0724
380: , p0_a1 DATE := fnd_api.g_miss_date
381: , p0_a2 NUMBER := 0-1962.0724
382: , p0_a3 DATE := fnd_api.g_miss_date
383: , p0_a4 NUMBER := 0-1962.0724
384: , p0_a5 NUMBER := 0-1962.0724

Line 382: , p0_a3 DATE := fnd_api.g_miss_date

378: , x_return_status out nocopy VARCHAR2
379: , p0_a0 NUMBER := 0-1962.0724
380: , p0_a1 DATE := fnd_api.g_miss_date
381: , p0_a2 NUMBER := 0-1962.0724
382: , p0_a3 DATE := fnd_api.g_miss_date
383: , p0_a4 NUMBER := 0-1962.0724
384: , p0_a5 NUMBER := 0-1962.0724
385: , p0_a6 NUMBER := 0-1962.0724
386: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 386: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

382: , p0_a3 DATE := fnd_api.g_miss_date
383: , p0_a4 NUMBER := 0-1962.0724
384: , p0_a5 NUMBER := 0-1962.0724
385: , p0_a6 NUMBER := 0-1962.0724
386: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
387: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
388: , p0_a9 NUMBER := 0-1962.0724
389: , p0_a10 NUMBER := 0-1962.0724
390: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 387: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

383: , p0_a4 NUMBER := 0-1962.0724
384: , p0_a5 NUMBER := 0-1962.0724
385: , p0_a6 NUMBER := 0-1962.0724
386: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
387: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
388: , p0_a9 NUMBER := 0-1962.0724
389: , p0_a10 NUMBER := 0-1962.0724
390: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 390: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

386: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
387: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
388: , p0_a9 NUMBER := 0-1962.0724
389: , p0_a10 NUMBER := 0-1962.0724
390: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
392: , p0_a13 NUMBER := 0-1962.0724
393: )
394:

Line 391: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

387: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
388: , p0_a9 NUMBER := 0-1962.0724
389: , p0_a10 NUMBER := 0-1962.0724
390: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
392: , p0_a13 NUMBER := 0-1962.0724
393: )
394:
395: as

Line 434: , p5_a1 DATE := fnd_api.g_miss_date

430: , x_return_status out nocopy VARCHAR2
431: , x_msg_count out nocopy NUMBER
432: , x_msg_data out nocopy VARCHAR2
433: , p5_a0 NUMBER := 0-1962.0724
434: , p5_a1 DATE := fnd_api.g_miss_date
435: , p5_a2 NUMBER := 0-1962.0724
436: , p5_a3 DATE := fnd_api.g_miss_date
437: , p5_a4 NUMBER := 0-1962.0724
438: , p5_a5 NUMBER := 0-1962.0724

Line 436: , p5_a3 DATE := fnd_api.g_miss_date

432: , x_msg_data out nocopy VARCHAR2
433: , p5_a0 NUMBER := 0-1962.0724
434: , p5_a1 DATE := fnd_api.g_miss_date
435: , p5_a2 NUMBER := 0-1962.0724
436: , p5_a3 DATE := fnd_api.g_miss_date
437: , p5_a4 NUMBER := 0-1962.0724
438: , p5_a5 NUMBER := 0-1962.0724
439: , p5_a6 NUMBER := 0-1962.0724
440: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 440: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

436: , p5_a3 DATE := fnd_api.g_miss_date
437: , p5_a4 NUMBER := 0-1962.0724
438: , p5_a5 NUMBER := 0-1962.0724
439: , p5_a6 NUMBER := 0-1962.0724
440: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a9 NUMBER := 0-1962.0724
443: , p5_a10 NUMBER := 0-1962.0724
444: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 441: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

437: , p5_a4 NUMBER := 0-1962.0724
438: , p5_a5 NUMBER := 0-1962.0724
439: , p5_a6 NUMBER := 0-1962.0724
440: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a9 NUMBER := 0-1962.0724
443: , p5_a10 NUMBER := 0-1962.0724
444: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 444: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

440: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a9 NUMBER := 0-1962.0724
443: , p5_a10 NUMBER := 0-1962.0724
444: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a13 NUMBER := 0-1962.0724
447: )
448:

Line 445: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

441: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a9 NUMBER := 0-1962.0724
443: , p5_a10 NUMBER := 0-1962.0724
444: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a13 NUMBER := 0-1962.0724
447: )
448:
449: as