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_GEO_AREAS_PVT_W dependencies on AMS_GEO_AREAS_PVT

Line 1: package body ams_geo_areas_pvt_w as

1: package body ams_geo_areas_pvt_w as
2: /* $Header: amswgeob.pls 115.6 2002/11/16 01:47:04 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 59: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 NUMBER := 0-1962.0724
57: )
58: as
59: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
60: ddindx binary_integer; indx binary_integer;
61: begin
62:
63: -- copy data to the local IN or IN-OUT args, if any

Line 101: ams_geo_areas_pvt.create_geo_area(p_api_version,

97: ddp_geo_area_rec.geo_hierarchy_id := rosetta_g_miss_num_map(p7_a26);
98:
99:
100: -- here's the delegated call to the old PL/SQL routine
101: ams_geo_areas_pvt.create_geo_area(p_api_version,
102: p_init_msg_list,
103: p_commit,
104: p_validation_level,
105: x_return_status,

Line 158: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

154: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a26 NUMBER := 0-1962.0724
156: )
157: as
158: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
159: ddindx binary_integer; indx binary_integer;
160: begin
161:
162: -- copy data to the local IN or IN-OUT args, if any

Line 199: ams_geo_areas_pvt.update_geo_area(p_api_version,

195: ddp_geo_area_rec.geo_area_type_code := p7_a25;
196: ddp_geo_area_rec.geo_hierarchy_id := rosetta_g_miss_num_map(p7_a26);
197:
198: -- here's the delegated call to the old PL/SQL routine
199: ams_geo_areas_pvt.update_geo_area(p_api_version,
200: p_init_msg_list,
201: p_commit,
202: p_validation_level,
203: x_return_status,

Line 253: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

249: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a26 NUMBER := 0-1962.0724
251: )
252: as
253: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
254: ddindx binary_integer; indx binary_integer;
255: begin
256:
257: -- copy data to the local IN or IN-OUT args, if any

Line 293: ams_geo_areas_pvt.validate_geo_area(p_api_version,

289: ddp_geo_area_rec.geo_area_type_code := p6_a25;
290: ddp_geo_area_rec.geo_hierarchy_id := rosetta_g_miss_num_map(p6_a26);
291:
292: -- here's the delegated call to the old PL/SQL routine
293: ams_geo_areas_pvt.validate_geo_area(p_api_version,
294: p_init_msg_list,
295: p_validation_level,
296: x_return_status,
297: x_msg_count,

Line 341: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

337: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
338: , p2_a26 NUMBER := 0-1962.0724
339: )
340: as
341: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
342: ddindx binary_integer; indx binary_integer;
343: begin
344:
345: -- copy data to the local IN or IN-OUT args, if any

Line 377: ams_geo_areas_pvt.check_items(p_validation_mode,

373: ddp_geo_area_rec.geo_area_type_code := p2_a25;
374: ddp_geo_area_rec.geo_hierarchy_id := rosetta_g_miss_num_map(p2_a26);
375:
376: -- here's the delegated call to the old PL/SQL routine
377: ams_geo_areas_pvt.check_items(p_validation_mode,
378: x_return_status,
379: ddp_geo_area_rec);
380:
381: -- copy data back from the local OUT or IN-OUT args, if any

Line 417: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

413: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
414: , p1_a26 NUMBER := 0-1962.0724
415: )
416: as
417: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
418: ddindx binary_integer; indx binary_integer;
419: begin
420:
421: -- copy data to the local IN or IN-OUT args, if any

Line 453: ams_geo_areas_pvt.check_geo_area_req_items(p_validation_mode,

449: ddp_geo_area_rec.geo_hierarchy_id := rosetta_g_miss_num_map(p1_a26);
450:
451:
452: -- here's the delegated call to the old PL/SQL routine
453: ams_geo_areas_pvt.check_geo_area_req_items(p_validation_mode,
454: ddp_geo_area_rec,
455: x_return_status);
456:
457: -- copy data back from the local OUT or IN-OUT args, if any

Line 493: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

489: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
490: , p1_a26 NUMBER := 0-1962.0724
491: )
492: as
493: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
494: ddindx binary_integer; indx binary_integer;
495: begin
496:
497: -- copy data to the local IN or IN-OUT args, if any

Line 529: ams_geo_areas_pvt.check_geo_area_uk_items(p_validation_mode,

525: ddp_geo_area_rec.geo_hierarchy_id := rosetta_g_miss_num_map(p1_a26);
526:
527:
528: -- here's the delegated call to the old PL/SQL routine
529: ams_geo_areas_pvt.check_geo_area_uk_items(p_validation_mode,
530: ddp_geo_area_rec,
531: x_return_status);
532:
533: -- copy data back from the local OUT or IN-OUT args, if any

Line 568: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

564: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a26 NUMBER := 0-1962.0724
566: )
567: as
568: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
569: ddindx binary_integer; indx binary_integer;
570: begin
571:
572: -- copy data to the local IN or IN-OUT args, if any

Line 603: ams_geo_areas_pvt.check_geo_area_fk_items(ddp_geo_area_rec,

599: ddp_geo_area_rec.geo_hierarchy_id := rosetta_g_miss_num_map(p0_a26);
600:
601:
602: -- here's the delegated call to the old PL/SQL routine
603: ams_geo_areas_pvt.check_geo_area_fk_items(ddp_geo_area_rec,
604: x_return_status);
605:
606: -- copy data back from the local OUT or IN-OUT args, if any
607:

Line 666: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

662: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
663: , p0_a26 NUMBER := 0-1962.0724
664: )
665: as
666: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
667: ddx_complete_rec ams_geo_areas_pvt.geo_area_rec_type;
668: ddindx binary_integer; indx binary_integer;
669: begin
670:

Line 667: ddx_complete_rec ams_geo_areas_pvt.geo_area_rec_type;

663: , p0_a26 NUMBER := 0-1962.0724
664: )
665: as
666: ddp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
667: ddx_complete_rec ams_geo_areas_pvt.geo_area_rec_type;
668: ddindx binary_integer; indx binary_integer;
669: begin
670:
671: -- copy data to the local IN or IN-OUT args, if any

Line 702: ams_geo_areas_pvt.complete_geo_area_rec(ddp_geo_area_rec,

698: ddp_geo_area_rec.geo_hierarchy_id := rosetta_g_miss_num_map(p0_a26);
699:
700:
701: -- here's the delegated call to the old PL/SQL routine
702: ams_geo_areas_pvt.complete_geo_area_rec(ddp_geo_area_rec,
703: ddx_complete_rec);
704:
705: -- copy data back from the local OUT or IN-OUT args, if any
706:

Line 765: ddx_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

761: , p0_a25 OUT NOCOPY VARCHAR2
762: , p0_a26 OUT NOCOPY NUMBER
763: )
764: as
765: ddx_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
766: ddindx binary_integer; indx binary_integer;
767: begin
768:
769: -- copy data to the local IN or IN-OUT args, if any

Line 772: ams_geo_areas_pvt.init_rec(ddx_geo_area_rec);

768:
769: -- copy data to the local IN or IN-OUT args, if any
770:
771: -- here's the delegated call to the old PL/SQL routine
772: ams_geo_areas_pvt.init_rec(ddx_geo_area_rec);
773:
774: -- copy data back from the local OUT or IN-OUT args, if any
775: p0_a0 := rosetta_g_miss_num_map(ddx_geo_area_rec.activity_geo_area_id);
776: p0_a1 := ddx_geo_area_rec.last_update_date;

Line 804: end ams_geo_areas_pvt_w;

800: p0_a25 := ddx_geo_area_rec.geo_area_type_code;
801: p0_a26 := rosetta_g_miss_num_map(ddx_geo_area_rec.geo_hierarchy_id);
802: end;
803:
804: end ams_geo_areas_pvt_w;