APPS.AMS_ACT_LIST_PVT_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;

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

14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_act_list_pvt.child_type, a0 JTF_VARCHAR2_TABLE_100) as

Line 206: , p7_a1 DATE := fnd_api.g_miss_date

202: , x_msg_count OUT NOCOPY NUMBER
203: , x_msg_data OUT NOCOPY VARCHAR2
204: , x_act_list_header_id OUT NOCOPY NUMBER
205: , p7_a0 NUMBER := 0-1962.0724
206: , p7_a1 DATE := fnd_api.g_miss_date
207: , p7_a2 NUMBER := 0-1962.0724
208: , p7_a3 DATE := fnd_api.g_miss_date
209: , p7_a4 NUMBER := 0-1962.0724
210: , p7_a5 NUMBER := 0-1962.0724

Line 208: , p7_a3 DATE := fnd_api.g_miss_date

204: , x_act_list_header_id OUT NOCOPY NUMBER
205: , p7_a0 NUMBER := 0-1962.0724
206: , p7_a1 DATE := fnd_api.g_miss_date
207: , p7_a2 NUMBER := 0-1962.0724
208: , p7_a3 DATE := fnd_api.g_miss_date
209: , p7_a4 NUMBER := 0-1962.0724
210: , p7_a5 NUMBER := 0-1962.0724
211: , p7_a6 NUMBER := 0-1962.0724
212: , p7_a7 NUMBER := 0-1962.0724

Line 213: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

209: , p7_a4 NUMBER := 0-1962.0724
210: , p7_a5 NUMBER := 0-1962.0724
211: , p7_a6 NUMBER := 0-1962.0724
212: , p7_a7 NUMBER := 0-1962.0724
213: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a9 NUMBER := 0-1962.0724
215: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 215: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

211: , p7_a6 NUMBER := 0-1962.0724
212: , p7_a7 NUMBER := 0-1962.0724
213: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a9 NUMBER := 0-1962.0724
215: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a13 NUMBER := 0-1962.0724
219: )

Line 216: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

212: , p7_a7 NUMBER := 0-1962.0724
213: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a9 NUMBER := 0-1962.0724
215: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a13 NUMBER := 0-1962.0724
219: )
220: as

Line 217: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

213: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a9 NUMBER := 0-1962.0724
215: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a13 NUMBER := 0-1962.0724
219: )
220: as
221: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

Line 280: , p7_a1 DATE := fnd_api.g_miss_date

276: , x_msg_count OUT NOCOPY NUMBER
277: , x_msg_data OUT NOCOPY VARCHAR2
278: , x_object_version_number OUT NOCOPY NUMBER
279: , p7_a0 NUMBER := 0-1962.0724
280: , p7_a1 DATE := fnd_api.g_miss_date
281: , p7_a2 NUMBER := 0-1962.0724
282: , p7_a3 DATE := fnd_api.g_miss_date
283: , p7_a4 NUMBER := 0-1962.0724
284: , p7_a5 NUMBER := 0-1962.0724

Line 282: , p7_a3 DATE := fnd_api.g_miss_date

278: , x_object_version_number OUT NOCOPY NUMBER
279: , p7_a0 NUMBER := 0-1962.0724
280: , p7_a1 DATE := fnd_api.g_miss_date
281: , p7_a2 NUMBER := 0-1962.0724
282: , p7_a3 DATE := fnd_api.g_miss_date
283: , p7_a4 NUMBER := 0-1962.0724
284: , p7_a5 NUMBER := 0-1962.0724
285: , p7_a6 NUMBER := 0-1962.0724
286: , p7_a7 NUMBER := 0-1962.0724

Line 287: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

283: , p7_a4 NUMBER := 0-1962.0724
284: , p7_a5 NUMBER := 0-1962.0724
285: , p7_a6 NUMBER := 0-1962.0724
286: , p7_a7 NUMBER := 0-1962.0724
287: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a9 NUMBER := 0-1962.0724
289: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
290: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 289: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

285: , p7_a6 NUMBER := 0-1962.0724
286: , p7_a7 NUMBER := 0-1962.0724
287: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a9 NUMBER := 0-1962.0724
289: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
290: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
292: , p7_a13 NUMBER := 0-1962.0724
293: )

Line 290: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

286: , p7_a7 NUMBER := 0-1962.0724
287: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a9 NUMBER := 0-1962.0724
289: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
290: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
292: , p7_a13 NUMBER := 0-1962.0724
293: )
294: as

Line 291: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

287: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a9 NUMBER := 0-1962.0724
289: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
290: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
292: , p7_a13 NUMBER := 0-1962.0724
293: )
294: as
295: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

Line 352: , p3_a1 DATE := fnd_api.g_miss_date

348: , x_return_status OUT NOCOPY VARCHAR2
349: , x_msg_count OUT NOCOPY NUMBER
350: , x_msg_data OUT NOCOPY VARCHAR2
351: , p3_a0 NUMBER := 0-1962.0724
352: , p3_a1 DATE := fnd_api.g_miss_date
353: , p3_a2 NUMBER := 0-1962.0724
354: , p3_a3 DATE := fnd_api.g_miss_date
355: , p3_a4 NUMBER := 0-1962.0724
356: , p3_a5 NUMBER := 0-1962.0724

Line 354: , p3_a3 DATE := fnd_api.g_miss_date

350: , x_msg_data OUT NOCOPY VARCHAR2
351: , p3_a0 NUMBER := 0-1962.0724
352: , p3_a1 DATE := fnd_api.g_miss_date
353: , p3_a2 NUMBER := 0-1962.0724
354: , p3_a3 DATE := fnd_api.g_miss_date
355: , p3_a4 NUMBER := 0-1962.0724
356: , p3_a5 NUMBER := 0-1962.0724
357: , p3_a6 NUMBER := 0-1962.0724
358: , p3_a7 NUMBER := 0-1962.0724

Line 359: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

355: , p3_a4 NUMBER := 0-1962.0724
356: , p3_a5 NUMBER := 0-1962.0724
357: , p3_a6 NUMBER := 0-1962.0724
358: , p3_a7 NUMBER := 0-1962.0724
359: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
360: , p3_a9 NUMBER := 0-1962.0724
361: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
362: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
363: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

Line 361: , p3_a10 VARCHAR2 := fnd_api.g_miss_char

357: , p3_a6 NUMBER := 0-1962.0724
358: , p3_a7 NUMBER := 0-1962.0724
359: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
360: , p3_a9 NUMBER := 0-1962.0724
361: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
362: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
363: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
364: , p3_a13 NUMBER := 0-1962.0724
365: )

Line 362: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

358: , p3_a7 NUMBER := 0-1962.0724
359: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
360: , p3_a9 NUMBER := 0-1962.0724
361: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
362: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
363: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
364: , p3_a13 NUMBER := 0-1962.0724
365: )
366: as

Line 363: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

359: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
360: , p3_a9 NUMBER := 0-1962.0724
361: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
362: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
363: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
364: , p3_a13 NUMBER := 0-1962.0724
365: )
366: as
367: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

Line 414: , p0_a1 DATE := fnd_api.g_miss_date

410:
411: procedure check_act_list_items(p_validation_mode VARCHAR2
412: , x_return_status OUT NOCOPY VARCHAR2
413: , p0_a0 NUMBER := 0-1962.0724
414: , p0_a1 DATE := fnd_api.g_miss_date
415: , p0_a2 NUMBER := 0-1962.0724
416: , p0_a3 DATE := fnd_api.g_miss_date
417: , p0_a4 NUMBER := 0-1962.0724
418: , p0_a5 NUMBER := 0-1962.0724

Line 416: , p0_a3 DATE := fnd_api.g_miss_date

412: , x_return_status OUT NOCOPY VARCHAR2
413: , p0_a0 NUMBER := 0-1962.0724
414: , p0_a1 DATE := fnd_api.g_miss_date
415: , p0_a2 NUMBER := 0-1962.0724
416: , p0_a3 DATE := fnd_api.g_miss_date
417: , p0_a4 NUMBER := 0-1962.0724
418: , p0_a5 NUMBER := 0-1962.0724
419: , p0_a6 NUMBER := 0-1962.0724
420: , p0_a7 NUMBER := 0-1962.0724

Line 421: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

417: , p0_a4 NUMBER := 0-1962.0724
418: , p0_a5 NUMBER := 0-1962.0724
419: , p0_a6 NUMBER := 0-1962.0724
420: , p0_a7 NUMBER := 0-1962.0724
421: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a9 NUMBER := 0-1962.0724
423: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 423: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

419: , p0_a6 NUMBER := 0-1962.0724
420: , p0_a7 NUMBER := 0-1962.0724
421: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a9 NUMBER := 0-1962.0724
423: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a13 NUMBER := 0-1962.0724
427: )

Line 424: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

420: , p0_a7 NUMBER := 0-1962.0724
421: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a9 NUMBER := 0-1962.0724
423: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a13 NUMBER := 0-1962.0724
427: )
428: as

Line 425: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

421: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a9 NUMBER := 0-1962.0724
423: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a13 NUMBER := 0-1962.0724
427: )
428: as
429: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

Line 467: , p5_a1 DATE := fnd_api.g_miss_date

463: , x_return_status OUT NOCOPY VARCHAR2
464: , x_msg_count OUT NOCOPY NUMBER
465: , x_msg_data OUT NOCOPY VARCHAR2
466: , p5_a0 NUMBER := 0-1962.0724
467: , p5_a1 DATE := fnd_api.g_miss_date
468: , p5_a2 NUMBER := 0-1962.0724
469: , p5_a3 DATE := fnd_api.g_miss_date
470: , p5_a4 NUMBER := 0-1962.0724
471: , p5_a5 NUMBER := 0-1962.0724

Line 469: , p5_a3 DATE := fnd_api.g_miss_date

465: , x_msg_data OUT NOCOPY VARCHAR2
466: , p5_a0 NUMBER := 0-1962.0724
467: , p5_a1 DATE := fnd_api.g_miss_date
468: , p5_a2 NUMBER := 0-1962.0724
469: , p5_a3 DATE := fnd_api.g_miss_date
470: , p5_a4 NUMBER := 0-1962.0724
471: , p5_a5 NUMBER := 0-1962.0724
472: , p5_a6 NUMBER := 0-1962.0724
473: , p5_a7 NUMBER := 0-1962.0724

Line 474: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

470: , p5_a4 NUMBER := 0-1962.0724
471: , p5_a5 NUMBER := 0-1962.0724
472: , p5_a6 NUMBER := 0-1962.0724
473: , p5_a7 NUMBER := 0-1962.0724
474: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a9 NUMBER := 0-1962.0724
476: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 476: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

472: , p5_a6 NUMBER := 0-1962.0724
473: , p5_a7 NUMBER := 0-1962.0724
474: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a9 NUMBER := 0-1962.0724
476: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a13 NUMBER := 0-1962.0724
480: )

Line 477: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

473: , p5_a7 NUMBER := 0-1962.0724
474: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a9 NUMBER := 0-1962.0724
476: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a13 NUMBER := 0-1962.0724
480: )
481: as

Line 478: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

474: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a9 NUMBER := 0-1962.0724
476: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a13 NUMBER := 0-1962.0724
480: )
481: as
482: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

Line 580: , p0_a1 DATE := fnd_api.g_miss_date

576: , p1_a11 OUT NOCOPY VARCHAR2
577: , p1_a12 OUT NOCOPY VARCHAR2
578: , p1_a13 OUT NOCOPY NUMBER
579: , p0_a0 NUMBER := 0-1962.0724
580: , p0_a1 DATE := fnd_api.g_miss_date
581: , p0_a2 NUMBER := 0-1962.0724
582: , p0_a3 DATE := fnd_api.g_miss_date
583: , p0_a4 NUMBER := 0-1962.0724
584: , p0_a5 NUMBER := 0-1962.0724

Line 582: , p0_a3 DATE := fnd_api.g_miss_date

578: , p1_a13 OUT NOCOPY NUMBER
579: , p0_a0 NUMBER := 0-1962.0724
580: , p0_a1 DATE := fnd_api.g_miss_date
581: , p0_a2 NUMBER := 0-1962.0724
582: , p0_a3 DATE := fnd_api.g_miss_date
583: , p0_a4 NUMBER := 0-1962.0724
584: , p0_a5 NUMBER := 0-1962.0724
585: , p0_a6 NUMBER := 0-1962.0724
586: , p0_a7 NUMBER := 0-1962.0724

Line 587: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

583: , p0_a4 NUMBER := 0-1962.0724
584: , p0_a5 NUMBER := 0-1962.0724
585: , p0_a6 NUMBER := 0-1962.0724
586: , p0_a7 NUMBER := 0-1962.0724
587: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
588: , p0_a9 NUMBER := 0-1962.0724
589: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
590: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 589: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

585: , p0_a6 NUMBER := 0-1962.0724
586: , p0_a7 NUMBER := 0-1962.0724
587: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
588: , p0_a9 NUMBER := 0-1962.0724
589: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
590: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p0_a13 NUMBER := 0-1962.0724
593: )

Line 590: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

586: , p0_a7 NUMBER := 0-1962.0724
587: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
588: , p0_a9 NUMBER := 0-1962.0724
589: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
590: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p0_a13 NUMBER := 0-1962.0724
593: )
594: as

Line 591: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

587: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
588: , p0_a9 NUMBER := 0-1962.0724
589: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
590: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p0_a13 NUMBER := 0-1962.0724
593: )
594: as
595: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;