APPS.AMS_PS_RULE_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_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100

Line 316: , p7_a1 DATE := fnd_api.g_miss_date

312: , p8_a1 NUMBER
313: , p8_a2 NUMBER
314: , x_rule_id OUT NOCOPY NUMBER
315: , p7_a0 NUMBER := 0-1962.0724
316: , p7_a1 DATE := fnd_api.g_miss_date
317: , p7_a2 NUMBER := 0-1962.0724
318: , p7_a3 DATE := fnd_api.g_miss_date
319: , p7_a4 NUMBER := 0-1962.0724
320: , p7_a5 NUMBER := 0-1962.0724

Line 318: , p7_a3 DATE := fnd_api.g_miss_date

314: , x_rule_id OUT NOCOPY NUMBER
315: , p7_a0 NUMBER := 0-1962.0724
316: , p7_a1 DATE := fnd_api.g_miss_date
317: , p7_a2 NUMBER := 0-1962.0724
318: , p7_a3 DATE := fnd_api.g_miss_date
319: , p7_a4 NUMBER := 0-1962.0724
320: , p7_a5 NUMBER := 0-1962.0724
321: , p7_a6 NUMBER := 0-1962.0724
322: , p7_a7 NUMBER := 0-1962.0724

Line 326: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

322: , p7_a7 NUMBER := 0-1962.0724
323: , p7_a8 NUMBER := 0-1962.0724
324: , p7_a9 NUMBER := 0-1962.0724
325: , p7_a10 NUMBER := 0-1962.0724
326: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a14 NUMBER := 0-1962.0724
330: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 327: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

323: , p7_a8 NUMBER := 0-1962.0724
324: , p7_a9 NUMBER := 0-1962.0724
325: , p7_a10 NUMBER := 0-1962.0724
326: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a14 NUMBER := 0-1962.0724
330: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 328: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

324: , p7_a9 NUMBER := 0-1962.0724
325: , p7_a10 NUMBER := 0-1962.0724
326: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a14 NUMBER := 0-1962.0724
330: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a17 NUMBER := 0-1962.0724

Line 330: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

326: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a14 NUMBER := 0-1962.0724
330: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a17 NUMBER := 0-1962.0724
333: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 331: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

327: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a14 NUMBER := 0-1962.0724
330: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a17 NUMBER := 0-1962.0724
333: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 333: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

329: , p7_a14 NUMBER := 0-1962.0724
330: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a17 NUMBER := 0-1962.0724
333: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

330: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a17 NUMBER := 0-1962.0724
333: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

331: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a17 NUMBER := 0-1962.0724
333: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

332: , p7_a17 NUMBER := 0-1962.0724
333: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

333: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

334: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

Line 339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

335: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
343: )

Line 340: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

336: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
343: )
344: as

Line 341: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

337: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
343: )
344: as
345: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line 342: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

338: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
339: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
342: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
343: )
344: as
345: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;
346: ddp_visitor_rec ams_ps_rule_pvt.visitor_type_rec;

Line 447: , p7_a1 DATE := fnd_api.g_miss_date

443: , p10_a0 JTF_VARCHAR2_TABLE_100
444: , p10_a1 JTF_VARCHAR2_TABLE_100
445: , x_object_version_number OUT NOCOPY NUMBER
446: , p7_a0 NUMBER := 0-1962.0724
447: , p7_a1 DATE := fnd_api.g_miss_date
448: , p7_a2 NUMBER := 0-1962.0724
449: , p7_a3 DATE := fnd_api.g_miss_date
450: , p7_a4 NUMBER := 0-1962.0724
451: , p7_a5 NUMBER := 0-1962.0724

Line 449: , p7_a3 DATE := fnd_api.g_miss_date

445: , x_object_version_number OUT NOCOPY NUMBER
446: , p7_a0 NUMBER := 0-1962.0724
447: , p7_a1 DATE := fnd_api.g_miss_date
448: , p7_a2 NUMBER := 0-1962.0724
449: , p7_a3 DATE := fnd_api.g_miss_date
450: , p7_a4 NUMBER := 0-1962.0724
451: , p7_a5 NUMBER := 0-1962.0724
452: , p7_a6 NUMBER := 0-1962.0724
453: , p7_a7 NUMBER := 0-1962.0724

Line 457: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

453: , p7_a7 NUMBER := 0-1962.0724
454: , p7_a8 NUMBER := 0-1962.0724
455: , p7_a9 NUMBER := 0-1962.0724
456: , p7_a10 NUMBER := 0-1962.0724
457: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a14 NUMBER := 0-1962.0724
461: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 458: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

454: , p7_a8 NUMBER := 0-1962.0724
455: , p7_a9 NUMBER := 0-1962.0724
456: , p7_a10 NUMBER := 0-1962.0724
457: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a14 NUMBER := 0-1962.0724
461: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 459: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

455: , p7_a9 NUMBER := 0-1962.0724
456: , p7_a10 NUMBER := 0-1962.0724
457: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a14 NUMBER := 0-1962.0724
461: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a17 NUMBER := 0-1962.0724

Line 461: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

457: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
458: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a14 NUMBER := 0-1962.0724
461: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a17 NUMBER := 0-1962.0724
464: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 462: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

458: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
459: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
460: , p7_a14 NUMBER := 0-1962.0724
461: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a17 NUMBER := 0-1962.0724
464: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 464: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

460: , p7_a14 NUMBER := 0-1962.0724
461: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a17 NUMBER := 0-1962.0724
464: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

461: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
462: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a17 NUMBER := 0-1962.0724
464: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

462: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
463: , p7_a17 NUMBER := 0-1962.0724
464: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

463: , p7_a17 NUMBER := 0-1962.0724
464: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

464: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

465: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
473: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

Line 470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

466: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
473: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
474: )

Line 471: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

467: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
473: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
474: )
475: as

Line 472: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

468: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
473: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
474: )
475: as
476: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line 473: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

469: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
471: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
472: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
473: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
474: )
475: as
476: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;
477: ddp_visitor_rec ams_ps_rule_pvt.visitor_type_rec;

Line 594: , p7_a1 DATE := fnd_api.g_miss_date

590: , p_vistype_change number
591: , p_rem_change number
592: , x_object_version_number OUT NOCOPY NUMBER
593: , p7_a0 NUMBER := 0-1962.0724
594: , p7_a1 DATE := fnd_api.g_miss_date
595: , p7_a2 NUMBER := 0-1962.0724
596: , p7_a3 DATE := fnd_api.g_miss_date
597: , p7_a4 NUMBER := 0-1962.0724
598: , p7_a5 NUMBER := 0-1962.0724

Line 596: , p7_a3 DATE := fnd_api.g_miss_date

592: , x_object_version_number OUT NOCOPY NUMBER
593: , p7_a0 NUMBER := 0-1962.0724
594: , p7_a1 DATE := fnd_api.g_miss_date
595: , p7_a2 NUMBER := 0-1962.0724
596: , p7_a3 DATE := fnd_api.g_miss_date
597: , p7_a4 NUMBER := 0-1962.0724
598: , p7_a5 NUMBER := 0-1962.0724
599: , p7_a6 NUMBER := 0-1962.0724
600: , p7_a7 NUMBER := 0-1962.0724

Line 604: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

600: , p7_a7 NUMBER := 0-1962.0724
601: , p7_a8 NUMBER := 0-1962.0724
602: , p7_a9 NUMBER := 0-1962.0724
603: , p7_a10 NUMBER := 0-1962.0724
604: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
607: , p7_a14 NUMBER := 0-1962.0724
608: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 605: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

601: , p7_a8 NUMBER := 0-1962.0724
602: , p7_a9 NUMBER := 0-1962.0724
603: , p7_a10 NUMBER := 0-1962.0724
604: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
607: , p7_a14 NUMBER := 0-1962.0724
608: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 606: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

602: , p7_a9 NUMBER := 0-1962.0724
603: , p7_a10 NUMBER := 0-1962.0724
604: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
607: , p7_a14 NUMBER := 0-1962.0724
608: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a17 NUMBER := 0-1962.0724

Line 608: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

604: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
607: , p7_a14 NUMBER := 0-1962.0724
608: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a17 NUMBER := 0-1962.0724
611: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 609: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

605: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
607: , p7_a14 NUMBER := 0-1962.0724
608: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a17 NUMBER := 0-1962.0724
611: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 611: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

607: , p7_a14 NUMBER := 0-1962.0724
608: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a17 NUMBER := 0-1962.0724
611: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

608: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a17 NUMBER := 0-1962.0724
611: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

609: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a17 NUMBER := 0-1962.0724
611: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

610: , p7_a17 NUMBER := 0-1962.0724
611: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

611: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
619: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

612: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
619: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
620: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

Line 617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

613: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
619: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
620: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
621: )

Line 618: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

614: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
619: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
620: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
621: )
622: as

Line 619: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

615: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
619: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
620: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
621: )
622: as
623: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line 620: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

616: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
617: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
619: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
620: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
621: )
622: as
623: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;
624: ddp_visitor_rec ams_ps_rule_pvt.visitor_type_rec;

Line 752: , p7_a1 DATE := fnd_api.g_miss_date

748: , x_msg_count OUT NOCOPY NUMBER
749: , x_msg_data OUT NOCOPY VARCHAR2
750: , p_object_version_number NUMBER
751: , p7_a0 NUMBER := 0-1962.0724
752: , p7_a1 DATE := fnd_api.g_miss_date
753: , p7_a2 NUMBER := 0-1962.0724
754: , p7_a3 DATE := fnd_api.g_miss_date
755: , p7_a4 NUMBER := 0-1962.0724
756: , p7_a5 NUMBER := 0-1962.0724

Line 754: , p7_a3 DATE := fnd_api.g_miss_date

750: , p_object_version_number NUMBER
751: , p7_a0 NUMBER := 0-1962.0724
752: , p7_a1 DATE := fnd_api.g_miss_date
753: , p7_a2 NUMBER := 0-1962.0724
754: , p7_a3 DATE := fnd_api.g_miss_date
755: , p7_a4 NUMBER := 0-1962.0724
756: , p7_a5 NUMBER := 0-1962.0724
757: , p7_a6 NUMBER := 0-1962.0724
758: , p7_a7 NUMBER := 0-1962.0724

Line 762: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

758: , p7_a7 NUMBER := 0-1962.0724
759: , p7_a8 NUMBER := 0-1962.0724
760: , p7_a9 NUMBER := 0-1962.0724
761: , p7_a10 NUMBER := 0-1962.0724
762: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p7_a14 NUMBER := 0-1962.0724
766: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 763: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

759: , p7_a8 NUMBER := 0-1962.0724
760: , p7_a9 NUMBER := 0-1962.0724
761: , p7_a10 NUMBER := 0-1962.0724
762: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p7_a14 NUMBER := 0-1962.0724
766: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 764: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

760: , p7_a9 NUMBER := 0-1962.0724
761: , p7_a10 NUMBER := 0-1962.0724
762: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p7_a14 NUMBER := 0-1962.0724
766: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p7_a17 NUMBER := 0-1962.0724

Line 766: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

762: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
763: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p7_a14 NUMBER := 0-1962.0724
766: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p7_a17 NUMBER := 0-1962.0724
769: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 767: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

763: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
765: , p7_a14 NUMBER := 0-1962.0724
766: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p7_a17 NUMBER := 0-1962.0724
769: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 769: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

765: , p7_a14 NUMBER := 0-1962.0724
766: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p7_a17 NUMBER := 0-1962.0724
769: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

766: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p7_a17 NUMBER := 0-1962.0724
769: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

767: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
768: , p7_a17 NUMBER := 0-1962.0724
769: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

768: , p7_a17 NUMBER := 0-1962.0724
769: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
776: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

769: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
776: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
777: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

770: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
776: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
777: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

Line 775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

771: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
776: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
777: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
779: )

Line 776: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

772: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
776: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
777: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
779: )
780: as

Line 777: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

773: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
776: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
777: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
779: )
780: as
781: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line 778: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

774: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
776: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
777: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
779: )
780: as
781: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;
782: ddindx binary_integer; indx binary_integer;

Line 852: , p3_a1 DATE := fnd_api.g_miss_date

848: , x_return_status OUT NOCOPY VARCHAR2
849: , x_msg_count OUT NOCOPY NUMBER
850: , x_msg_data OUT NOCOPY VARCHAR2
851: , p3_a0 NUMBER := 0-1962.0724
852: , p3_a1 DATE := fnd_api.g_miss_date
853: , p3_a2 NUMBER := 0-1962.0724
854: , p3_a3 DATE := fnd_api.g_miss_date
855: , p3_a4 NUMBER := 0-1962.0724
856: , p3_a5 NUMBER := 0-1962.0724

Line 854: , p3_a3 DATE := fnd_api.g_miss_date

850: , x_msg_data OUT NOCOPY VARCHAR2
851: , p3_a0 NUMBER := 0-1962.0724
852: , p3_a1 DATE := fnd_api.g_miss_date
853: , p3_a2 NUMBER := 0-1962.0724
854: , p3_a3 DATE := fnd_api.g_miss_date
855: , p3_a4 NUMBER := 0-1962.0724
856: , p3_a5 NUMBER := 0-1962.0724
857: , p3_a6 NUMBER := 0-1962.0724
858: , p3_a7 NUMBER := 0-1962.0724

Line 862: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

858: , p3_a7 NUMBER := 0-1962.0724
859: , p3_a8 NUMBER := 0-1962.0724
860: , p3_a9 NUMBER := 0-1962.0724
861: , p3_a10 NUMBER := 0-1962.0724
862: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
863: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
864: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
865: , p3_a14 NUMBER := 0-1962.0724
866: , p3_a15 VARCHAR2 := fnd_api.g_miss_char

Line 863: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

859: , p3_a8 NUMBER := 0-1962.0724
860: , p3_a9 NUMBER := 0-1962.0724
861: , p3_a10 NUMBER := 0-1962.0724
862: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
863: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
864: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
865: , p3_a14 NUMBER := 0-1962.0724
866: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
867: , p3_a16 VARCHAR2 := fnd_api.g_miss_char

Line 864: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

860: , p3_a9 NUMBER := 0-1962.0724
861: , p3_a10 NUMBER := 0-1962.0724
862: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
863: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
864: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
865: , p3_a14 NUMBER := 0-1962.0724
866: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
867: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
868: , p3_a17 NUMBER := 0-1962.0724

Line 866: , p3_a15 VARCHAR2 := fnd_api.g_miss_char

862: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
863: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
864: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
865: , p3_a14 NUMBER := 0-1962.0724
866: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
867: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
868: , p3_a17 NUMBER := 0-1962.0724
869: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char

Line 867: , p3_a16 VARCHAR2 := fnd_api.g_miss_char

863: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
864: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
865: , p3_a14 NUMBER := 0-1962.0724
866: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
867: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
868: , p3_a17 NUMBER := 0-1962.0724
869: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

Line 869: , p3_a18 VARCHAR2 := fnd_api.g_miss_char

865: , p3_a14 NUMBER := 0-1962.0724
866: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
867: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
868: , p3_a17 NUMBER := 0-1962.0724
869: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

Line 870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char

866: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
867: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
868: , p3_a17 NUMBER := 0-1962.0724
869: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char

Line 871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

867: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
868: , p3_a17 NUMBER := 0-1962.0724
869: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char

Line 872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char

868: , p3_a17 NUMBER := 0-1962.0724
869: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p3_a25 VARCHAR2 := fnd_api.g_miss_char

Line 873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

869: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p3_a26 VARCHAR2 := fnd_api.g_miss_char

Line 874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char

870: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p3_a27 VARCHAR2 := fnd_api.g_miss_char

Line 875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char

871: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
879: )

Line 876: , p3_a25 VARCHAR2 := fnd_api.g_miss_char

872: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
879: )
880: as

Line 877: , p3_a26 VARCHAR2 := fnd_api.g_miss_char

873: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
879: )
880: as
881: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line 878: , p3_a27 VARCHAR2 := fnd_api.g_miss_char

874: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
879: )
880: as
881: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;
882: ddindx binary_integer; indx binary_integer;

Line 942: , p0_a1 DATE := fnd_api.g_miss_date

938:
939: procedure check_ps_rules_items(p_validation_mode VARCHAR2
940: , x_return_status OUT NOCOPY VARCHAR2
941: , p0_a0 NUMBER := 0-1962.0724
942: , p0_a1 DATE := fnd_api.g_miss_date
943: , p0_a2 NUMBER := 0-1962.0724
944: , p0_a3 DATE := fnd_api.g_miss_date
945: , p0_a4 NUMBER := 0-1962.0724
946: , p0_a5 NUMBER := 0-1962.0724

Line 944: , p0_a3 DATE := fnd_api.g_miss_date

940: , x_return_status OUT NOCOPY VARCHAR2
941: , p0_a0 NUMBER := 0-1962.0724
942: , p0_a1 DATE := fnd_api.g_miss_date
943: , p0_a2 NUMBER := 0-1962.0724
944: , p0_a3 DATE := fnd_api.g_miss_date
945: , p0_a4 NUMBER := 0-1962.0724
946: , p0_a5 NUMBER := 0-1962.0724
947: , p0_a6 NUMBER := 0-1962.0724
948: , p0_a7 NUMBER := 0-1962.0724

Line 952: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

948: , p0_a7 NUMBER := 0-1962.0724
949: , p0_a8 NUMBER := 0-1962.0724
950: , p0_a9 NUMBER := 0-1962.0724
951: , p0_a10 NUMBER := 0-1962.0724
952: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p0_a14 NUMBER := 0-1962.0724
956: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 953: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

949: , p0_a8 NUMBER := 0-1962.0724
950: , p0_a9 NUMBER := 0-1962.0724
951: , p0_a10 NUMBER := 0-1962.0724
952: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p0_a14 NUMBER := 0-1962.0724
956: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 954: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

950: , p0_a9 NUMBER := 0-1962.0724
951: , p0_a10 NUMBER := 0-1962.0724
952: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p0_a14 NUMBER := 0-1962.0724
956: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p0_a17 NUMBER := 0-1962.0724

Line 956: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

952: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p0_a14 NUMBER := 0-1962.0724
956: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p0_a17 NUMBER := 0-1962.0724
959: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

Line 957: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

953: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p0_a14 NUMBER := 0-1962.0724
956: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p0_a17 NUMBER := 0-1962.0724
959: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 959: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

955: , p0_a14 NUMBER := 0-1962.0724
956: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p0_a17 NUMBER := 0-1962.0724
959: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

956: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p0_a17 NUMBER := 0-1962.0724
959: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

Line 961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

957: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p0_a17 NUMBER := 0-1962.0724
959: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

Line 962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

958: , p0_a17 NUMBER := 0-1962.0724
959: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
966: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

Line 963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

959: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
966: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
967: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

Line 964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

960: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
966: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
967: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
968: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

Line 965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

961: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
966: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
967: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
968: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
969: )

Line 966: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

962: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
966: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
967: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
968: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
969: )
970: as

Line 967: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

963: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
966: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
967: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
968: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
969: )
970: as
971: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line 968: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

964: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
965: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
966: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
967: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
968: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
969: )
970: as
971: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;
972: ddindx binary_integer; indx binary_integer;

Line 1077: , p5_a1 DATE := fnd_api.g_miss_date

1073: , x_return_status OUT NOCOPY VARCHAR2
1074: , x_msg_count OUT NOCOPY NUMBER
1075: , x_msg_data OUT NOCOPY VARCHAR2
1076: , p5_a0 NUMBER := 0-1962.0724
1077: , p5_a1 DATE := fnd_api.g_miss_date
1078: , p5_a2 NUMBER := 0-1962.0724
1079: , p5_a3 DATE := fnd_api.g_miss_date
1080: , p5_a4 NUMBER := 0-1962.0724
1081: , p5_a5 NUMBER := 0-1962.0724

Line 1079: , p5_a3 DATE := fnd_api.g_miss_date

1075: , x_msg_data OUT NOCOPY VARCHAR2
1076: , p5_a0 NUMBER := 0-1962.0724
1077: , p5_a1 DATE := fnd_api.g_miss_date
1078: , p5_a2 NUMBER := 0-1962.0724
1079: , p5_a3 DATE := fnd_api.g_miss_date
1080: , p5_a4 NUMBER := 0-1962.0724
1081: , p5_a5 NUMBER := 0-1962.0724
1082: , p5_a6 NUMBER := 0-1962.0724
1083: , p5_a7 NUMBER := 0-1962.0724

Line 1087: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

1083: , p5_a7 NUMBER := 0-1962.0724
1084: , p5_a8 NUMBER := 0-1962.0724
1085: , p5_a9 NUMBER := 0-1962.0724
1086: , p5_a10 NUMBER := 0-1962.0724
1087: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1088: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1089: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1090: , p5_a14 NUMBER := 0-1962.0724
1091: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 1088: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

1084: , p5_a8 NUMBER := 0-1962.0724
1085: , p5_a9 NUMBER := 0-1962.0724
1086: , p5_a10 NUMBER := 0-1962.0724
1087: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1088: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1089: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1090: , p5_a14 NUMBER := 0-1962.0724
1091: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 1089: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

1085: , p5_a9 NUMBER := 0-1962.0724
1086: , p5_a10 NUMBER := 0-1962.0724
1087: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1088: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1089: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1090: , p5_a14 NUMBER := 0-1962.0724
1091: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a17 NUMBER := 0-1962.0724

Line 1091: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

1087: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1088: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1089: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1090: , p5_a14 NUMBER := 0-1962.0724
1091: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a17 NUMBER := 0-1962.0724
1094: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 1092: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

1088: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1089: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1090: , p5_a14 NUMBER := 0-1962.0724
1091: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a17 NUMBER := 0-1962.0724
1094: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 1094: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

1090: , p5_a14 NUMBER := 0-1962.0724
1091: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a17 NUMBER := 0-1962.0724
1094: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

1091: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a17 NUMBER := 0-1962.0724
1094: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

1092: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a17 NUMBER := 0-1962.0724
1094: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

1093: , p5_a17 NUMBER := 0-1962.0724
1094: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

1094: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

1095: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

Line 1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

1096: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1104: )

Line 1101: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

1097: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1104: )
1105: as

Line 1102: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

1098: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1104: )
1105: as
1106: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;

Line 1103: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

1099: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1104: )
1105: as
1106: ddp_ps_rules_rec ams_ps_rule_pvt.ps_rules_rec_type;
1107: ddindx binary_integer; indx binary_integer;