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.IEM_MAILITEM_PUB_W dependencies on IEM_MAILITEM_PUB

Line 1: package body iem_mailitem_pub_w as

1: package body iem_mailitem_pub_w as
2: /* $Header: IEMPMICB.pls 120.2 2006/05/16 08:51 txliu noship $ */
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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 51: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE

Line 115: procedure rosetta_table_copy_in_p3(t out nocopy iem_mailitem_pub.class_count_tbl, a0 JTF_NUMBER_TABLE

111: end if;
112: end if;
113: end rosetta_table_copy_out_p1;
114:
115: procedure rosetta_table_copy_in_p3(t out nocopy iem_mailitem_pub.class_count_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_NUMBER_TABLE
118: ) as
119: ddindx binary_integer; indx binary_integer;

Line 138: procedure rosetta_table_copy_out_p3(t iem_mailitem_pub.class_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

134: end loop;
135: end if;
136: end if;
137: end rosetta_table_copy_in_p3;
138: procedure rosetta_table_copy_out_p3(t iem_mailitem_pub.class_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
139: , a1 out nocopy JTF_VARCHAR2_TABLE_100
140: , a2 out nocopy JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;

Line 172: procedure rosetta_table_copy_in_p4(t out nocopy iem_mailitem_pub.t_number_table, a0 JTF_NUMBER_TABLE) as

168: end if;
169: end if;
170: end rosetta_table_copy_out_p3;
171:
172: procedure rosetta_table_copy_in_p4(t out nocopy iem_mailitem_pub.t_number_table, a0 JTF_NUMBER_TABLE) as
173: ddindx binary_integer; indx binary_integer;
174: begin
175: if a0 is null then
176: t := null;

Line 178: t := iem_mailitem_pub.t_number_table();

174: begin
175: if a0 is null then
176: t := null;
177: elsif a0.count = 0 then
178: t := iem_mailitem_pub.t_number_table();
179: else
180: if a0.count > 0 then
181: t := iem_mailitem_pub.t_number_table();
182: t.extend(a0.count);

Line 181: t := iem_mailitem_pub.t_number_table();

177: elsif a0.count = 0 then
178: t := iem_mailitem_pub.t_number_table();
179: else
180: if a0.count > 0 then
181: t := iem_mailitem_pub.t_number_table();
182: t.extend(a0.count);
183: indx := a0.first;
184: ddindx := 1;
185: while true loop

Line 196: procedure rosetta_table_copy_out_p4(t iem_mailitem_pub.t_number_table, a0 out nocopy JTF_NUMBER_TABLE) as

192: end loop;
193: end if;
194: end if;
195: end rosetta_table_copy_in_p4;
196: procedure rosetta_table_copy_out_p4(t iem_mailitem_pub.t_number_table, a0 out nocopy JTF_NUMBER_TABLE) as
197: ddindx binary_integer; indx binary_integer;
198: begin
199: if t is null then
200: a0 := null;

Line 221: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE

217: end if;
218: end if;
219: end rosetta_table_copy_out_p4;
220:
221: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_VARCHAR2_TABLE_100
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_NUMBER_TABLE

Line 270: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE

266: end loop;
267: end if;
268: end if;
269: end rosetta_table_copy_in_p6;
270: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
271: , a1 out nocopy JTF_NUMBER_TABLE
272: , a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , a3 out nocopy JTF_NUMBER_TABLE
274: , a4 out nocopy JTF_NUMBER_TABLE

Line 369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100

365: end if;
366: end if;
367: end rosetta_table_copy_out_p6;
368:
369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
370: , a1 JTF_VARCHAR2_TABLE_300
371: , a2 JTF_VARCHAR2_TABLE_100
372: ) as
373: ddindx binary_integer; indx binary_integer;

Line 392: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

388: end loop;
389: end if;
390: end if;
391: end rosetta_table_copy_in_p8;
392: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
393: , a1 out nocopy JTF_VARCHAR2_TABLE_300
394: , a2 out nocopy JTF_VARCHAR2_TABLE_100
395: ) as
396: ddindx binary_integer; indx binary_integer;

Line 446: ddp_tbl iem_mailitem_pub.t_number_table;

442: , x_msg_data out nocopy VARCHAR2
443: )
444:
445: as
446: ddp_tbl iem_mailitem_pub.t_number_table;
447: ddx_email_count iem_mailitem_pub.email_count_tbl;
448: ddindx binary_integer; indx binary_integer;
449: begin
450:

Line 447: ddx_email_count iem_mailitem_pub.email_count_tbl;

443: )
444:
445: as
446: ddp_tbl iem_mailitem_pub.t_number_table;
447: ddx_email_count iem_mailitem_pub.email_count_tbl;
448: ddindx binary_integer; indx binary_integer;
449: begin
450:
451: -- copy data to the local IN or IN-OUT args, if any

Line 456: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);

452:
453:
454:
455:
456: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
457:
458:
459:
460:

Line 463: iem_mailitem_pub.getmailitemcount(p_api_version_number,

459:
460:
461:
462: -- here's the delegated call to the old PL/SQL routine
463: iem_mailitem_pub.getmailitemcount(p_api_version_number,
464: p_init_msg_list,
465: p_commit,
466: p_resource_id,
467: ddp_tbl,

Line 479: iem_mailitem_pub_w.rosetta_table_copy_out_p1(ddx_email_count, p5_a0

475:
476:
477:
478:
479: iem_mailitem_pub_w.rosetta_table_copy_out_p1(ddx_email_count, p5_a0
480: , p5_a1
481: , p5_a2
482: , p5_a3
483: , p5_a4

Line 509: ddp_tbl iem_mailitem_pub.t_number_table;

505: , x_msg_data out nocopy VARCHAR2
506: )
507:
508: as
509: ddp_tbl iem_mailitem_pub.t_number_table;
510: ddx_class_bin iem_mailitem_pub.class_count_tbl;
511: ddindx binary_integer; indx binary_integer;
512: begin
513:

Line 510: ddx_class_bin iem_mailitem_pub.class_count_tbl;

506: )
507:
508: as
509: ddp_tbl iem_mailitem_pub.t_number_table;
510: ddx_class_bin iem_mailitem_pub.class_count_tbl;
511: ddindx binary_integer; indx binary_integer;
512: begin
513:
514: -- copy data to the local IN or IN-OUT args, if any

Line 519: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);

515:
516:
517:
518:
519: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
520:
521:
522:
523:

Line 527: iem_mailitem_pub.getmailitemcount(p_api_version_number,

523:
524:
525:
526: -- here's the delegated call to the old PL/SQL routine
527: iem_mailitem_pub.getmailitemcount(p_api_version_number,
528: p_init_msg_list,
529: p_commit,
530: p_resource_id,
531: ddp_tbl,

Line 545: iem_mailitem_pub_w.rosetta_table_copy_out_p3(ddx_class_bin, p6_a0

541:
542:
543:
544:
545: iem_mailitem_pub_w.rosetta_table_copy_out_p3(ddx_class_bin, p6_a0
546: , p6_a1
547: , p6_a2
548: );
549:

Line 567: ddx_class_bin iem_mailitem_pub.class_count_tbl;

563: , x_msg_data out nocopy VARCHAR2
564: )
565:
566: as
567: ddx_class_bin iem_mailitem_pub.class_count_tbl;
568: ddindx binary_integer; indx binary_integer;
569: begin
570:
571: -- copy data to the local IN or IN-OUT args, if any

Line 581: iem_mailitem_pub.getmailitemcount(p_api_version_number,

577:
578:
579:
580: -- here's the delegated call to the old PL/SQL routine
581: iem_mailitem_pub.getmailitemcount(p_api_version_number,
582: p_init_msg_list,
583: p_commit,
584: p_email_account_id,
585: ddx_class_bin,

Line 595: iem_mailitem_pub_w.rosetta_table_copy_out_p3(ddx_class_bin, p4_a0

591:
592:
593:
594:
595: iem_mailitem_pub_w.rosetta_table_copy_out_p3(ddx_class_bin, p4_a0
596: , p4_a1
597: , p4_a2
598: );
599:

Line 618: ddp_tbl iem_mailitem_pub.t_number_table;

614: , x_msg_data out nocopy VARCHAR2
615: )
616:
617: as
618: ddp_tbl iem_mailitem_pub.t_number_table;
619: ddindx binary_integer; indx binary_integer;
620: begin
621:
622: -- copy data to the local IN or IN-OUT args, if any

Line 627: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);

623:
624:
625:
626:
627: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
628:
629:
630:
631:

Line 636: iem_mailitem_pub.getmailitemcount(p_api_version_number,

632:
633:
634:
635: -- here's the delegated call to the old PL/SQL routine
636: iem_mailitem_pub.getmailitemcount(p_api_version_number,
637: p_init_msg_list,
638: p_commit,
639: p_resource_id,
640: ddp_tbl,

Line 718: ddp_tbl iem_mailitem_pub.t_number_table;

714: , x_msg_data out nocopy VARCHAR2
715: )
716:
717: as
718: ddp_tbl iem_mailitem_pub.t_number_table;
719: ddx_email_data iem_rt_proc_emails%rowtype;
720: ddindx binary_integer; indx binary_integer;
721: begin
722:

Line 728: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);

724:
725:
726:
727:
728: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
729:
730:
731:
732:

Line 737: iem_mailitem_pub.getmailitem(p_api_version_number,

733:
734:
735:
736: -- here's the delegated call to the old PL/SQL routine
737: iem_mailitem_pub.getmailitem(p_api_version_number,
738: p_init_msg_list,
739: p_commit,
740: p_resource_id,
741: ddp_tbl,

Line 867: ddp_tbl iem_mailitem_pub.t_number_table;

863: , x_msg_data out nocopy VARCHAR2
864: )
865:
866: as
867: ddp_tbl iem_mailitem_pub.t_number_table;
868: ddx_email_data iem_rt_proc_emails%rowtype;
869: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;
870: ddindx binary_integer; indx binary_integer;
871: begin

Line 869: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;

865:
866: as
867: ddp_tbl iem_mailitem_pub.t_number_table;
868: ddx_email_data iem_rt_proc_emails%rowtype;
869: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;
870: ddindx binary_integer; indx binary_integer;
871: begin
872:
873: -- copy data to the local IN or IN-OUT args, if any

Line 878: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);

874:
875:
876:
877:
878: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
879:
880:
881:
882:

Line 889: iem_mailitem_pub.getmailitem(p_api_version_number,

885:
886:
887:
888: -- here's the delegated call to the old PL/SQL routine
889: iem_mailitem_pub.getmailitem(p_api_version_number,
890: p_init_msg_list,
891: p_commit,
892: p_resource_id,
893: ddp_tbl,

Line 956: iem_mailitem_pub_w.rosetta_table_copy_out_p8(ddx_tag_key_value, p8_a0

952: p7_a41 := ddx_email_data.attribute14;
953: p7_a42 := ddx_email_data.attribute15;
954: p7_a43 := ddx_email_data.security_group_id;
955:
956: iem_mailitem_pub_w.rosetta_table_copy_out_p8(ddx_tag_key_value, p8_a0
957: , p8_a1
958: , p8_a2
959: );
960:

Line 1036: iem_mailitem_pub.getmailitem(p_api_version_number,

1032:
1033:
1034:
1035: -- here's the delegated call to the old PL/SQL routine
1036: iem_mailitem_pub.getmailitem(p_api_version_number,
1037: p_init_msg_list,
1038: p_commit,
1039: p_resource_id,
1040: p_acct_rt_class_id,

Line 1112: ddx_tbl iem_mailitem_pub.t_number_table;

1108: , x_msg_data out nocopy VARCHAR2
1109: )
1110:
1111: as
1112: ddx_tbl iem_mailitem_pub.t_number_table;
1113: ddindx binary_integer; indx binary_integer;
1114: begin
1115:
1116: -- copy data to the local IN or IN-OUT args, if any

Line 1126: iem_mailitem_pub.getgroupdetails(p_api_version_number,

1122:
1123:
1124:
1125: -- here's the delegated call to the old PL/SQL routine
1126: iem_mailitem_pub.getgroupdetails(p_api_version_number,
1127: p_init_msg_list,
1128: p_commit,
1129: p_resource_id,
1130: ddx_tbl,

Line 1140: iem_mailitem_pub_w.rosetta_table_copy_out_p4(ddx_tbl, x_tbl);

1136:
1137:
1138:
1139:
1140: iem_mailitem_pub_w.rosetta_table_copy_out_p4(ddx_tbl, x_tbl);
1141:
1142:
1143:
1144: end;

Line 1256: iem_mailitem_pub.updatemailitem(p_api_version_number,

1252:
1253:
1254:
1255: -- here's the delegated call to the old PL/SQL routine
1256: iem_mailitem_pub.updatemailitem(p_api_version_number,
1257: p_init_msg_list,
1258: p_commit,
1259: ddp_email_data,
1260: x_return_status,

Line 1345: iem_mailitem_pub.getmailiteminfo(p_api_version_number,

1341:
1342:
1343:
1344: -- here's the delegated call to the old PL/SQL routine
1345: iem_mailitem_pub.getmailiteminfo(p_api_version_number,
1346: p_init_msg_list,
1347: p_commit,
1348: p_message_id,
1349: p_account_id,

Line 1444: ddx_acq_email_data iem_mailitem_pub.acq_email_info_tbl;

1440: , x_msg_data out nocopy VARCHAR2
1441: )
1442:
1443: as
1444: ddx_acq_email_data iem_mailitem_pub.acq_email_info_tbl;
1445: ddindx binary_integer; indx binary_integer;
1446: begin
1447:
1448: -- copy data to the local IN or IN-OUT args, if any

Line 1464: iem_mailitem_pub.getemailheaders(p_api_version_number,

1460:
1461:
1462:
1463: -- here's the delegated call to the old PL/SQL routine
1464: iem_mailitem_pub.getemailheaders(p_api_version_number,
1465: p_init_msg_list,
1466: p_commit,
1467: p_resource_id,
1468: p_email_account_id,

Line 1490: iem_mailitem_pub_w.rosetta_table_copy_out_p6(ddx_acq_email_data, p10_a0

1486:
1487:
1488:
1489:
1490: iem_mailitem_pub_w.rosetta_table_copy_out_p6(ddx_acq_email_data, p10_a0
1491: , p10_a1
1492: , p10_a2
1493: , p10_a3
1494: , p10_a4

Line 1574: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;

1570: )
1571:
1572: as
1573: ddx_email_data iem_rt_proc_emails%rowtype;
1574: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;
1575: ddindx binary_integer; indx binary_integer;
1576: begin
1577:
1578: -- copy data to the local IN or IN-OUT args, if any

Line 1593: iem_mailitem_pub.getqueueitemdata(p_api_version_number,

1589:
1590:
1591:
1592: -- here's the delegated call to the old PL/SQL routine
1593: iem_mailitem_pub.getqueueitemdata(p_api_version_number,
1594: p_init_msg_list,
1595: p_commit,
1596: p_message_id,
1597: p_from_agent_id,

Line 1660: iem_mailitem_pub_w.rosetta_table_copy_out_p8(ddx_tag_key_value, p8_a0

1656: p7_a41 := ddx_email_data.attribute14;
1657: p7_a42 := ddx_email_data.attribute15;
1658: p7_a43 := ddx_email_data.security_group_id;
1659:
1660: iem_mailitem_pub_w.rosetta_table_copy_out_p8(ddx_tag_key_value, p8_a0
1661: , p8_a1
1662: , p8_a2
1663: );
1664:

Line 1670: end iem_mailitem_pub_w;

1666:
1667:
1668: end;
1669:
1670: end iem_mailitem_pub_w;