APPS.AMS_VENUE_RATES_PVT_W dependencies on AMS_VENUE_RATES_PVT

Line 1: package body ams_venue_rates_pvt_w as

1: package body ams_venue_rates_pvt_w as
2: /* $Header: amswvrtb.pls 115.5 2002/12/24 18:59:49 mukumar ship $ */
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:

Line 22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE

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_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 105: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

101: end loop;
102: end if;
103: end if;
104: end rosetta_table_copy_in_p3;
105: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
106: , a1 OUT NOCOPY JTF_DATE_TABLE
107: , a2 OUT NOCOPY JTF_NUMBER_TABLE
108: , a3 OUT NOCOPY JTF_DATE_TABLE
109: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 332: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )
331: as
332: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:
336: -- copy data to the local IN or IN-OUT args, if any

Line 380: ams_venue_rates_pvt.create_venue_rates(p_api_version_number,

376: ddp_venue_rates_rec.description := p7_a32;
377:
378:
379: -- here's the delegated call to the old PL/SQL routine
380: ams_venue_rates_pvt.create_venue_rates(p_api_version_number,
381: p_init_msg_list,
382: p_commit,
383: p_validation_level,
384: x_return_status,

Line 444: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

440: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
441: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
442: )
443: as
444: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
445: ddindx binary_integer; indx binary_integer;
446: begin
447:
448: -- copy data to the local IN or IN-OUT args, if any

Line 492: ams_venue_rates_pvt.update_venue_rates(p_api_version_number,

488: ddp_venue_rates_rec.description := p7_a32;
489:
490:
491: -- here's the delegated call to the old PL/SQL routine
492: ams_venue_rates_pvt.update_venue_rates(p_api_version_number,
493: p_init_msg_list,
494: p_commit,
495: p_validation_level,
496: x_return_status,

Line 555: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

551: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a32 VARCHAR2 := fnd_api.g_miss_char
553: )
554: as
555: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
556: ddindx binary_integer; indx binary_integer;
557: begin
558:
559: -- copy data to the local IN or IN-OUT args, if any

Line 602: ams_venue_rates_pvt.validate_venue_rates(p_api_version_number,

598:
599:
600:
601: -- here's the delegated call to the old PL/SQL routine
602: ams_venue_rates_pvt.validate_venue_rates(p_api_version_number,
603: p_init_msg_list,
604: p_validation_level,
605: ddp_venue_rates_rec,
606: p_validation_mode,

Line 658: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

654: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
656: )
657: as
658: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
659: ddindx binary_integer; indx binary_integer;
660: begin
661:
662: -- copy data to the local IN or IN-OUT args, if any

Line 700: ams_venue_rates_pvt.check_venue_rates_items(ddp_venue_rates_rec,

696:
697:
698:
699: -- here's the delegated call to the old PL/SQL routine
700: ams_venue_rates_pvt.check_venue_rates_items(ddp_venue_rates_rec,
701: p_validation_mode,
702: x_return_status);
703:
704: -- copy data back from the local OUT or IN-OUT args, if any

Line 749: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
747: )
748: as
749: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
750: ddindx binary_integer; indx binary_integer;
751: begin
752:
753: -- copy data to the local IN or IN-OUT args, if any

Line 794: ams_venue_rates_pvt.validate_venue_rates_rec(p_api_version_number,

790: ddp_venue_rates_rec.attribute15 := p5_a31;
791: ddp_venue_rates_rec.description := p5_a32;
792:
793: -- here's the delegated call to the old PL/SQL routine
794: ams_venue_rates_pvt.validate_venue_rates_rec(p_api_version_number,
795: p_init_msg_list,
796: x_return_status,
797: x_msg_count,
798: x_msg_data,

Line 809: end ams_venue_rates_pvt_w;

805:
806:
807: end;
808:
809: end ams_venue_rates_pvt_w;