eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_VENUE_PVT_W dependencies on AMS_VENUE_PVT

Line 1: package body ams_venue_pvt_w as

1: package body ams_venue_pvt_w as
2: /* $Header: amswvnub.pls 115.8 2002/11/16 01:47:41 dbiswas 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 94: ddp_venue_rec ams_venue_pvt.venue_rec_type;

90: , p7_a60 NUMBER := 0-1962.0724
91: , p7_a61 NUMBER := 0-1962.0724
92: )
93: as
94: ddp_venue_rec ams_venue_pvt.venue_rec_type;
95: ddindx binary_integer; indx binary_integer;
96: begin
97:
98: -- copy data to the local IN or IN-OUT args, if any

Line 171: ams_venue_pvt.create_venue(p_api_version,

167: ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
168:
169:
170: -- here's the delegated call to the old PL/SQL routine
171: ams_venue_pvt.create_venue(p_api_version,
172: p_init_msg_list,
173: p_commit,
174: p_validation_level,
175: x_return_status,

Line 264: ddp_venue_rec ams_venue_pvt.venue_rec_type;

260: , p7_a60 NUMBER := 0-1962.0724
261: , p7_a61 NUMBER := 0-1962.0724
262: )
263: as
264: ddp_venue_rec ams_venue_pvt.venue_rec_type;
265: ddindx binary_integer; indx binary_integer;
266: begin
267:
268: -- copy data to the local IN or IN-OUT args, if any

Line 341: ams_venue_pvt.create_room(p_api_version,

337: ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
338:
339:
340: -- here's the delegated call to the old PL/SQL routine
341: ams_venue_pvt.create_room(p_api_version,
342: p_init_msg_list,
343: p_commit,
344: p_validation_level,
345: x_return_status,

Line 433: ddp_venue_rec ams_venue_pvt.venue_rec_type;

429: , p7_a60 NUMBER := 0-1962.0724
430: , p7_a61 NUMBER := 0-1962.0724
431: )
432: as
433: ddp_venue_rec ams_venue_pvt.venue_rec_type;
434: ddindx binary_integer; indx binary_integer;
435: begin
436:
437: -- copy data to the local IN or IN-OUT args, if any

Line 509: ams_venue_pvt.update_venue(p_api_version,

505: ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p7_a60);
506: ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
507:
508: -- here's the delegated call to the old PL/SQL routine
509: ams_venue_pvt.update_venue(p_api_version,
510: p_init_msg_list,
511: p_commit,
512: p_validation_level,
513: x_return_status,

Line 599: ddp_venue_rec ams_venue_pvt.venue_rec_type;

595: , p7_a60 NUMBER := 0-1962.0724
596: , p7_a61 NUMBER := 0-1962.0724
597: )
598: as
599: ddp_venue_rec ams_venue_pvt.venue_rec_type;
600: ddindx binary_integer; indx binary_integer;
601: begin
602:
603: -- copy data to the local IN or IN-OUT args, if any

Line 675: ams_venue_pvt.update_room(p_api_version,

671: ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p7_a60);
672: ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
673:
674: -- here's the delegated call to the old PL/SQL routine
675: ams_venue_pvt.update_room(p_api_version,
676: p_init_msg_list,
677: p_commit,
678: p_validation_level,
679: x_return_status,

Line 766: ddp_venue_rec ams_venue_pvt.venue_rec_type;

762: , p7_a60 NUMBER := 0-1962.0724
763: , p7_a61 NUMBER := 0-1962.0724
764: )
765: as
766: ddp_venue_rec ams_venue_pvt.venue_rec_type;
767: ddindx binary_integer; indx binary_integer;
768: begin
769:
770: -- copy data to the local IN or IN-OUT args, if any

Line 843: ams_venue_pvt.validate_venue(p_api_version,

839: ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
840:
841:
842: -- here's the delegated call to the old PL/SQL routine
843: ams_venue_pvt.validate_venue(p_api_version,
844: p_init_msg_list,
845: p_commit,
846: p_validation_level,
847: x_return_status,

Line 931: ddp_venue_rec ams_venue_pvt.venue_rec_type;

927: , p0_a60 NUMBER := 0-1962.0724
928: , p0_a61 NUMBER := 0-1962.0724
929: )
930: as
931: ddp_venue_rec ams_venue_pvt.venue_rec_type;
932: ddindx binary_integer; indx binary_integer;
933: begin
934:
935: -- copy data to the local IN or IN-OUT args, if any

Line 1003: ams_venue_pvt.check_venue_items(ddp_venue_rec,

999:
1000:
1001:
1002: -- here's the delegated call to the old PL/SQL routine
1003: ams_venue_pvt.check_venue_items(ddp_venue_rec,
1004: p_object_type,
1005: p_validation_mode,
1006: x_return_status);
1007:

Line 1141: ddp_venue_rec ams_venue_pvt.venue_rec_type;

1137: , p1_a60 NUMBER := 0-1962.0724
1138: , p1_a61 NUMBER := 0-1962.0724
1139: )
1140: as
1141: ddp_venue_rec ams_venue_pvt.venue_rec_type;
1142: ddp_complete_rec ams_venue_pvt.venue_rec_type;
1143: ddindx binary_integer; indx binary_integer;
1144: begin
1145:

Line 1142: ddp_complete_rec ams_venue_pvt.venue_rec_type;

1138: , p1_a61 NUMBER := 0-1962.0724
1139: )
1140: as
1141: ddp_venue_rec ams_venue_pvt.venue_rec_type;
1142: ddp_complete_rec ams_venue_pvt.venue_rec_type;
1143: ddindx binary_integer; indx binary_integer;
1144: begin
1145:
1146: -- copy data to the local IN or IN-OUT args, if any

Line 1275: ams_venue_pvt.check_venue_record(ddp_venue_rec,

1271: ddp_complete_rec.person_id := rosetta_g_miss_num_map(p1_a61);
1272:
1273:
1274: -- here's the delegated call to the old PL/SQL routine
1275: ams_venue_pvt.check_venue_record(ddp_venue_rec,
1276: ddp_complete_rec,
1277: x_return_status);
1278:
1279: -- copy data back from the local OUT or IN-OUT args, if any

Line 1348: ddx_venue_rec ams_venue_pvt.venue_rec_type;

1344: , p0_a60 OUT NOCOPY NUMBER
1345: , p0_a61 OUT NOCOPY NUMBER
1346: )
1347: as
1348: ddx_venue_rec ams_venue_pvt.venue_rec_type;
1349: ddindx binary_integer; indx binary_integer;
1350: begin
1351:
1352: -- copy data to the local IN or IN-OUT args, if any

Line 1355: ams_venue_pvt.init_venue_rec(ddx_venue_rec);

1351:
1352: -- copy data to the local IN or IN-OUT args, if any
1353:
1354: -- here's the delegated call to the old PL/SQL routine
1355: ams_venue_pvt.init_venue_rec(ddx_venue_rec);
1356:
1357: -- copy data back from the local OUT or IN-OUT args, if any
1358: p0_a0 := rosetta_g_miss_num_map(ddx_venue_rec.venue_id);
1359: p0_a1 := rosetta_g_miss_num_map(ddx_venue_rec.custom_setup_id);

Line 1548: ddp_venue_rec ams_venue_pvt.venue_rec_type;

1544: , p0_a60 NUMBER := 0-1962.0724
1545: , p0_a61 NUMBER := 0-1962.0724
1546: )
1547: as
1548: ddp_venue_rec ams_venue_pvt.venue_rec_type;
1549: ddx_complete_rec ams_venue_pvt.venue_rec_type;
1550: ddindx binary_integer; indx binary_integer;
1551: begin
1552:

Line 1549: ddx_complete_rec ams_venue_pvt.venue_rec_type;

1545: , p0_a61 NUMBER := 0-1962.0724
1546: )
1547: as
1548: ddp_venue_rec ams_venue_pvt.venue_rec_type;
1549: ddx_complete_rec ams_venue_pvt.venue_rec_type;
1550: ddindx binary_integer; indx binary_integer;
1551: begin
1552:
1553: -- copy data to the local IN or IN-OUT args, if any

Line 1619: ams_venue_pvt.complete_venue_rec(ddp_venue_rec,

1615: ddp_venue_rec.person_id := rosetta_g_miss_num_map(p0_a61);
1616:
1617:
1618: -- here's the delegated call to the old PL/SQL routine
1619: ams_venue_pvt.complete_venue_rec(ddp_venue_rec,
1620: ddx_complete_rec);
1621:
1622: -- copy data back from the local OUT or IN-OUT args, if any
1623:

Line 1688: end ams_venue_pvt_w;

1684: p1_a60 := rosetta_g_miss_num_map(ddx_complete_rec.sales_group_id);
1685: p1_a61 := rosetta_g_miss_num_map(ddx_complete_rec.person_id);
1686: end;
1687:
1688: end ams_venue_pvt_w;