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_MEDIA_PVT_W dependencies on AMS_MEDIA_PVT

Line 1: package body ams_media_pvt_w as

1: package body ams_media_pvt_w as
2: /* $Header: amswmedb.pls 115.13 2002/12/30 05:38:57 cgoyal 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 61: ddp_media_rec ams_media_pvt.media_rec_type;

57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: )
60: as
61: ddp_media_rec ams_media_pvt.media_rec_type;
62: ddindx binary_integer; indx binary_integer;
63: begin
64:
65: -- copy data to the local IN or IN-OUT args, if any

Line 105: ams_media_pvt.create_media(p_api_version,

101: ddp_media_rec.description := p7_a28;
102:
103:
104: -- here's the delegated call to the old PL/SQL routine
105: ams_media_pvt.create_media(p_api_version,
106: p_init_msg_list,
107: p_commit,
108: p_validation_level,
109: x_return_status,

Line 164: ddp_media_rec ams_media_pvt.media_rec_type;

160: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
162: )
163: as
164: ddp_media_rec ams_media_pvt.media_rec_type;
165: ddindx binary_integer; indx binary_integer;
166: begin
167:
168: -- copy data to the local IN or IN-OUT args, if any

Line 207: ams_media_pvt.update_media(p_api_version,

203: ddp_media_rec.media_name := p7_a27;
204: ddp_media_rec.description := p7_a28;
205:
206: -- here's the delegated call to the old PL/SQL routine
207: ams_media_pvt.update_media(p_api_version,
208: p_init_msg_list,
209: p_commit,
210: p_validation_level,
211: x_return_status,

Line 264: ddp_media_rec ams_media_pvt.media_rec_type;

260: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
262: )
263: as
264: ddp_media_rec ams_media_pvt.media_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 307: ams_media_pvt.validate_media(p_api_version,

303: ddp_media_rec.media_name := p7_a27;
304: ddp_media_rec.description := p7_a28;
305:
306: -- here's the delegated call to the old PL/SQL routine
307: ams_media_pvt.validate_media(p_api_version,
308: p_init_msg_list,
309: p_commit,
310: p_validation_level,
311: x_return_status,

Line 359: ddp_media_rec ams_media_pvt.media_rec_type;

355: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
357: )
358: as
359: ddp_media_rec ams_media_pvt.media_rec_type;
360: ddindx binary_integer; indx binary_integer;
361: begin
362:
363: -- copy data to the local IN or IN-OUT args, if any

Line 397: ams_media_pvt.check_media_items(ddp_media_rec,

393:
394:
395:
396: -- here's the delegated call to the old PL/SQL routine
397: ams_media_pvt.check_media_items(ddp_media_rec,
398: p_validation_mode,
399: x_return_status);
400:
401: -- copy data back from the local OUT or IN-OUT args, if any

Line 467: ddp_media_rec ams_media_pvt.media_rec_type;

463: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
465: )
466: as
467: ddp_media_rec ams_media_pvt.media_rec_type;
468: ddp_complete_rec ams_media_pvt.media_rec_type;
469: ddindx binary_integer; indx binary_integer;
470: begin
471:

Line 468: ddp_complete_rec ams_media_pvt.media_rec_type;

464: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
465: )
466: as
467: ddp_media_rec ams_media_pvt.media_rec_type;
468: ddp_complete_rec ams_media_pvt.media_rec_type;
469: ddindx binary_integer; indx binary_integer;
470: begin
471:
472: -- copy data to the local IN or IN-OUT args, if any

Line 535: ams_media_pvt.check_media_record(ddp_media_rec,

531: ddp_complete_rec.description := p1_a28;
532:
533:
534: -- here's the delegated call to the old PL/SQL routine
535: ams_media_pvt.check_media_record(ddp_media_rec,
536: ddp_complete_rec,
537: x_return_status);
538:
539: -- copy data back from the local OUT or IN-OUT args, if any

Line 575: ddx_media_rec ams_media_pvt.media_rec_type;

571: , p0_a27 OUT NOCOPY VARCHAR2
572: , p0_a28 OUT NOCOPY VARCHAR2
573: )
574: as
575: ddx_media_rec ams_media_pvt.media_rec_type;
576: ddindx binary_integer; indx binary_integer;
577: begin
578:
579: -- copy data to the local IN or IN-OUT args, if any

Line 582: ams_media_pvt.init_media_rec(ddx_media_rec);

578:
579: -- copy data to the local IN or IN-OUT args, if any
580:
581: -- here's the delegated call to the old PL/SQL routine
582: ams_media_pvt.init_media_rec(ddx_media_rec);
583:
584: -- copy data back from the local OUT or IN-OUT args, if any
585: p0_a0 := rosetta_g_miss_num_map(ddx_media_rec.media_id);
586: p0_a1 := ddx_media_rec.last_update_date;

Line 676: ddp_media_rec ams_media_pvt.media_rec_type;

672: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
673: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
674: )
675: as
676: ddp_media_rec ams_media_pvt.media_rec_type;
677: ddx_complete_rec ams_media_pvt.media_rec_type;
678: ddindx binary_integer; indx binary_integer;
679: begin
680:

Line 677: ddx_complete_rec ams_media_pvt.media_rec_type;

673: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
674: )
675: as
676: ddp_media_rec ams_media_pvt.media_rec_type;
677: ddx_complete_rec ams_media_pvt.media_rec_type;
678: ddindx binary_integer; indx binary_integer;
679: begin
680:
681: -- copy data to the local IN or IN-OUT args, if any

Line 714: ams_media_pvt.complete_media_rec(ddp_media_rec,

710: ddp_media_rec.description := p0_a28;
711:
712:
713: -- here's the delegated call to the old PL/SQL routine
714: ams_media_pvt.complete_media_rec(ddp_media_rec,
715: ddx_complete_rec);
716:
717: -- copy data back from the local OUT or IN-OUT args, if any
718:

Line 771: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;

767: , p7_a9 DATE := fnd_api.g_miss_date
768: , p7_a10 DATE := fnd_api.g_miss_date
769: )
770: as
771: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
772: ddindx binary_integer; indx binary_integer;
773: begin
774:
775: -- copy data to the local IN or IN-OUT args, if any

Line 797: ams_media_pvt.create_mediachannel(p_api_version,

793: ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p7_a10);
794:
795:
796: -- here's the delegated call to the old PL/SQL routine
797: ams_media_pvt.create_mediachannel(p_api_version,
798: p_init_msg_list,
799: p_commit,
800: p_validation_level,
801: x_return_status,

Line 838: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;

834: , p7_a9 DATE := fnd_api.g_miss_date
835: , p7_a10 DATE := fnd_api.g_miss_date
836: )
837: as
838: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
839: ddindx binary_integer; indx binary_integer;
840: begin
841:
842: -- copy data to the local IN or IN-OUT args, if any

Line 863: ams_media_pvt.update_mediachannel(p_api_version,

859: ddp_mediachl_rec.active_from_date := rosetta_g_miss_date_in_map(p7_a9);
860: ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p7_a10);
861:
862: -- here's the delegated call to the old PL/SQL routine
863: ams_media_pvt.update_mediachannel(p_api_version,
864: p_init_msg_list,
865: p_commit,
866: p_validation_level,
867: x_return_status,

Line 902: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;

898: , p7_a9 DATE := fnd_api.g_miss_date
899: , p7_a10 DATE := fnd_api.g_miss_date
900: )
901: as
902: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
903: ddindx binary_integer; indx binary_integer;
904: begin
905:
906: -- copy data to the local IN or IN-OUT args, if any

Line 927: ams_media_pvt.validate_mediachannel(p_api_version,

923: ddp_mediachl_rec.active_from_date := rosetta_g_miss_date_in_map(p7_a9);
924: ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p7_a10);
925:
926: -- here's the delegated call to the old PL/SQL routine
927: ams_media_pvt.validate_mediachannel(p_api_version,
928: p_init_msg_list,
929: p_commit,
930: p_validation_level,
931: x_return_status,

Line 961: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;

957: , p0_a9 DATE := fnd_api.g_miss_date
958: , p0_a10 DATE := fnd_api.g_miss_date
959: )
960: as
961: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
962: ddindx binary_integer; indx binary_integer;
963: begin
964:
965: -- copy data to the local IN or IN-OUT args, if any

Line 981: ams_media_pvt.check_mediachannel_items(ddp_mediachl_rec,

977:
978:
979:
980: -- here's the delegated call to the old PL/SQL routine
981: ams_media_pvt.check_mediachannel_items(ddp_mediachl_rec,
982: p_validation_mode,
983: x_return_status);
984:
985: -- copy data back from the local OUT or IN-OUT args, if any

Line 1015: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;

1011: , p1_a9 DATE := fnd_api.g_miss_date
1012: , p1_a10 DATE := fnd_api.g_miss_date
1013: )
1014: as
1015: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
1016: ddp_complete_rec ams_media_pvt.mediachannel_rec_type;
1017: ddindx binary_integer; indx binary_integer;
1018: begin
1019:

Line 1016: ddp_complete_rec ams_media_pvt.mediachannel_rec_type;

1012: , p1_a10 DATE := fnd_api.g_miss_date
1013: )
1014: as
1015: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
1016: ddp_complete_rec ams_media_pvt.mediachannel_rec_type;
1017: ddindx binary_integer; indx binary_integer;
1018: begin
1019:
1020: -- copy data to the local IN or IN-OUT args, if any

Line 1047: ams_media_pvt.check_mediachannel_record(ddp_mediachl_rec,

1043: ddp_complete_rec.active_to_date := rosetta_g_miss_date_in_map(p1_a10);
1044:
1045:
1046: -- here's the delegated call to the old PL/SQL routine
1047: ams_media_pvt.check_mediachannel_record(ddp_mediachl_rec,
1048: ddp_complete_rec,
1049: x_return_status);
1050:
1051: -- copy data back from the local OUT or IN-OUT args, if any

Line 1069: ddx_mediachl_rec ams_media_pvt.mediachannel_rec_type;

1065: , p0_a9 OUT NOCOPY DATE
1066: , p0_a10 OUT NOCOPY DATE
1067: )
1068: as
1069: ddx_mediachl_rec ams_media_pvt.mediachannel_rec_type;
1070: ddindx binary_integer; indx binary_integer;
1071: begin
1072:
1073: -- copy data to the local IN or IN-OUT args, if any

Line 1076: ams_media_pvt.init_mediachannel_rec(ddx_mediachl_rec);

1072:
1073: -- copy data to the local IN or IN-OUT args, if any
1074:
1075: -- here's the delegated call to the old PL/SQL routine
1076: ams_media_pvt.init_mediachannel_rec(ddx_mediachl_rec);
1077:
1078: -- copy data back from the local OUT or IN-OUT args, if any
1079: p0_a0 := rosetta_g_miss_num_map(ddx_mediachl_rec.media_channel_id);
1080: p0_a1 := ddx_mediachl_rec.last_update_date;

Line 1116: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;

1112: , p0_a9 DATE := fnd_api.g_miss_date
1113: , p0_a10 DATE := fnd_api.g_miss_date
1114: )
1115: as
1116: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
1117: ddx_complete_rec ams_media_pvt.mediachannel_rec_type;
1118: ddindx binary_integer; indx binary_integer;
1119: begin
1120:

Line 1117: ddx_complete_rec ams_media_pvt.mediachannel_rec_type;

1113: , p0_a10 DATE := fnd_api.g_miss_date
1114: )
1115: as
1116: ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
1117: ddx_complete_rec ams_media_pvt.mediachannel_rec_type;
1118: ddindx binary_integer; indx binary_integer;
1119: begin
1120:
1121: -- copy data to the local IN or IN-OUT args, if any

Line 1136: ams_media_pvt.complete_mediachannel_rec(ddp_mediachl_rec,

1132: ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p0_a10);
1133:
1134:
1135: -- here's the delegated call to the old PL/SQL routine
1136: ams_media_pvt.complete_mediachannel_rec(ddp_mediachl_rec,
1137: ddx_complete_rec);
1138:
1139: -- copy data back from the local OUT or IN-OUT args, if any
1140:

Line 1154: end ams_media_pvt_w;

1150: p1_a9 := ddx_complete_rec.active_from_date;
1151: p1_a10 := ddx_complete_rec.active_to_date;
1152: end;
1153:
1154: end ams_media_pvt_w;