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.4.12020000.3 2012/10/05 06:25:40 lkullamb 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: 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.queue_email_info_tbl, a0 JTF_NUMBER_TABLE

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.queue_email_info_tbl, a0 JTF_NUMBER_TABLE
370: , a1 JTF_NUMBER_TABLE
371: , a2 JTF_VARCHAR2_TABLE_100
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_200

Line 414: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE

410: end loop;
411: end if;
412: end if;
413: end rosetta_table_copy_in_p8;
414: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
415: , a1 out nocopy JTF_NUMBER_TABLE
416: , a2 out nocopy JTF_VARCHAR2_TABLE_100
417: , a3 out nocopy JTF_NUMBER_TABLE
418: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 503: procedure rosetta_table_copy_in_p10(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100

499: end if;
500: end if;
501: end rosetta_table_copy_out_p8;
502:
503: procedure rosetta_table_copy_in_p10(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
504: , a1 JTF_VARCHAR2_TABLE_300
505: , a2 JTF_VARCHAR2_TABLE_100
506: ) as
507: ddindx binary_integer; indx binary_integer;

Line 526: procedure rosetta_table_copy_out_p10(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

522: end loop;
523: end if;
524: end if;
525: end rosetta_table_copy_in_p10;
526: procedure rosetta_table_copy_out_p10(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
527: , a1 out nocopy JTF_VARCHAR2_TABLE_300
528: , a2 out nocopy JTF_VARCHAR2_TABLE_100
529: ) as
530: ddindx binary_integer; indx binary_integer;

Line 580: ddp_tbl iem_mailitem_pub.t_number_table;

576: , x_msg_data out nocopy VARCHAR2
577: )
578:
579: as
580: ddp_tbl iem_mailitem_pub.t_number_table;
581: ddx_email_count iem_mailitem_pub.email_count_tbl;
582: ddindx binary_integer; indx binary_integer;
583: begin
584:

Line 581: ddx_email_count iem_mailitem_pub.email_count_tbl;

577: )
578:
579: as
580: ddp_tbl iem_mailitem_pub.t_number_table;
581: ddx_email_count iem_mailitem_pub.email_count_tbl;
582: ddindx binary_integer; indx binary_integer;
583: begin
584:
585: -- copy data to the local IN or IN-OUT args, if any

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

586:
587:
588:
589:
590: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
591:
592:
593:
594:

Line 597: iem_mailitem_pub.getmailitemcount(p_api_version_number,

593:
594:
595:
596: -- here's the delegated call to the old PL/SQL routine
597: iem_mailitem_pub.getmailitemcount(p_api_version_number,
598: p_init_msg_list,
599: p_commit,
600: p_resource_id,
601: ddp_tbl,

Line 613: iem_mailitem_pub_w.rosetta_table_copy_out_p1(ddx_email_count, p5_a0

609:
610:
611:
612:
613: iem_mailitem_pub_w.rosetta_table_copy_out_p1(ddx_email_count, p5_a0
614: , p5_a1
615: , p5_a2
616: , p5_a3
617: , p5_a4

Line 643: ddp_tbl iem_mailitem_pub.t_number_table;

639: , x_msg_data out nocopy VARCHAR2
640: )
641:
642: as
643: ddp_tbl iem_mailitem_pub.t_number_table;
644: ddx_class_bin iem_mailitem_pub.class_count_tbl;
645: ddindx binary_integer; indx binary_integer;
646: begin
647:

Line 644: ddx_class_bin iem_mailitem_pub.class_count_tbl;

640: )
641:
642: as
643: ddp_tbl iem_mailitem_pub.t_number_table;
644: ddx_class_bin iem_mailitem_pub.class_count_tbl;
645: ddindx binary_integer; indx binary_integer;
646: begin
647:
648: -- copy data to the local IN or IN-OUT args, if any

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

649:
650:
651:
652:
653: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
654:
655:
656:
657:

Line 661: iem_mailitem_pub.getmailitemcount(p_api_version_number,

657:
658:
659:
660: -- here's the delegated call to the old PL/SQL routine
661: iem_mailitem_pub.getmailitemcount(p_api_version_number,
662: p_init_msg_list,
663: p_commit,
664: p_resource_id,
665: ddp_tbl,

Line 679: iem_mailitem_pub_w.rosetta_table_copy_out_p3(ddx_class_bin, p6_a0

675:
676:
677:
678:
679: iem_mailitem_pub_w.rosetta_table_copy_out_p3(ddx_class_bin, p6_a0
680: , p6_a1
681: , p6_a2
682: );
683:

Line 701: ddx_class_bin iem_mailitem_pub.class_count_tbl;

697: , x_msg_data out nocopy VARCHAR2
698: )
699:
700: as
701: ddx_class_bin iem_mailitem_pub.class_count_tbl;
702: ddindx binary_integer; indx binary_integer;
703: begin
704:
705: -- copy data to the local IN or IN-OUT args, if any

Line 715: iem_mailitem_pub.getmailitemcount(p_api_version_number,

711:
712:
713:
714: -- here's the delegated call to the old PL/SQL routine
715: iem_mailitem_pub.getmailitemcount(p_api_version_number,
716: p_init_msg_list,
717: p_commit,
718: p_email_account_id,
719: ddx_class_bin,

Line 729: iem_mailitem_pub_w.rosetta_table_copy_out_p3(ddx_class_bin, p4_a0

725:
726:
727:
728:
729: iem_mailitem_pub_w.rosetta_table_copy_out_p3(ddx_class_bin, p4_a0
730: , p4_a1
731: , p4_a2
732: );
733:

Line 752: ddp_tbl iem_mailitem_pub.t_number_table;

748: , x_msg_data out nocopy VARCHAR2
749: )
750:
751: as
752: ddp_tbl iem_mailitem_pub.t_number_table;
753: ddindx binary_integer; indx binary_integer;
754: begin
755:
756: -- copy data to the local IN or IN-OUT args, if any

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

757:
758:
759:
760:
761: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
762:
763:
764:
765:

Line 770: iem_mailitem_pub.getmailitemcount(p_api_version_number,

766:
767:
768:
769: -- here's the delegated call to the old PL/SQL routine
770: iem_mailitem_pub.getmailitemcount(p_api_version_number,
771: p_init_msg_list,
772: p_commit,
773: p_resource_id,
774: ddp_tbl,

Line 852: ddp_tbl iem_mailitem_pub.t_number_table;

848: , x_msg_data out nocopy VARCHAR2
849: )
850:
851: as
852: ddp_tbl iem_mailitem_pub.t_number_table;
853: ddx_email_data iem_rt_proc_emails%rowtype;
854: ddindx binary_integer; indx binary_integer;
855: begin
856:

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

858:
859:
860:
861:
862: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
863:
864:
865:
866:

Line 871: iem_mailitem_pub.getmailitem(p_api_version_number,

867:
868:
869:
870: -- here's the delegated call to the old PL/SQL routine
871: iem_mailitem_pub.getmailitem(p_api_version_number,
872: p_init_msg_list,
873: p_commit,
874: p_resource_id,
875: ddp_tbl,

Line 1001: ddp_tbl iem_mailitem_pub.t_number_table;

997: , x_msg_data out nocopy VARCHAR2
998: )
999:
1000: as
1001: ddp_tbl iem_mailitem_pub.t_number_table;
1002: ddx_email_data iem_rt_proc_emails%rowtype;
1003: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;
1004: ddindx binary_integer; indx binary_integer;
1005: begin

Line 1003: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;

999:
1000: as
1001: ddp_tbl iem_mailitem_pub.t_number_table;
1002: ddx_email_data iem_rt_proc_emails%rowtype;
1003: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;
1004: ddindx binary_integer; indx binary_integer;
1005: begin
1006:
1007: -- copy data to the local IN or IN-OUT args, if any

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

1008:
1009:
1010:
1011:
1012: iem_mailitem_pub_w.rosetta_table_copy_in_p4(ddp_tbl, p_tbl);
1013:
1014:
1015:
1016:

Line 1023: iem_mailitem_pub.getmailitem(p_api_version_number,

1019:
1020:
1021:
1022: -- here's the delegated call to the old PL/SQL routine
1023: iem_mailitem_pub.getmailitem(p_api_version_number,
1024: p_init_msg_list,
1025: p_commit,
1026: p_resource_id,
1027: ddp_tbl,

Line 1090: iem_mailitem_pub_w.rosetta_table_copy_out_p10(ddx_tag_key_value, p8_a0

1086: p7_a41 := ddx_email_data.attribute14;
1087: p7_a42 := ddx_email_data.attribute15;
1088: p7_a43 := ddx_email_data.security_group_id;
1089:
1090: iem_mailitem_pub_w.rosetta_table_copy_out_p10(ddx_tag_key_value, p8_a0
1091: , p8_a1
1092: , p8_a2
1093: );
1094:

Line 1170: iem_mailitem_pub.getmailitem(p_api_version_number,

1166:
1167:
1168:
1169: -- here's the delegated call to the old PL/SQL routine
1170: iem_mailitem_pub.getmailitem(p_api_version_number,
1171: p_init_msg_list,
1172: p_commit,
1173: p_resource_id,
1174: p_acct_rt_class_id,

Line 1246: ddx_tbl iem_mailitem_pub.t_number_table;

1242: , x_msg_data out nocopy VARCHAR2
1243: )
1244:
1245: as
1246: ddx_tbl iem_mailitem_pub.t_number_table;
1247: ddindx binary_integer; indx binary_integer;
1248: begin
1249:
1250: -- copy data to the local IN or IN-OUT args, if any

Line 1260: iem_mailitem_pub.getgroupdetails(p_api_version_number,

1256:
1257:
1258:
1259: -- here's the delegated call to the old PL/SQL routine
1260: iem_mailitem_pub.getgroupdetails(p_api_version_number,
1261: p_init_msg_list,
1262: p_commit,
1263: p_resource_id,
1264: ddx_tbl,

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

1270:
1271:
1272:
1273:
1274: iem_mailitem_pub_w.rosetta_table_copy_out_p4(ddx_tbl, x_tbl);
1275:
1276:
1277:
1278: end;

Line 1390: iem_mailitem_pub.updatemailitem(p_api_version_number,

1386:
1387:
1388:
1389: -- here's the delegated call to the old PL/SQL routine
1390: iem_mailitem_pub.updatemailitem(p_api_version_number,
1391: p_init_msg_list,
1392: p_commit,
1393: ddp_email_data,
1394: x_return_status,

Line 1479: iem_mailitem_pub.getmailiteminfo(p_api_version_number,

1475:
1476:
1477:
1478: -- here's the delegated call to the old PL/SQL routine
1479: iem_mailitem_pub.getmailiteminfo(p_api_version_number,
1480: p_init_msg_list,
1481: p_commit,
1482: p_message_id,
1483: p_account_id,

Line 1578: ddx_acq_email_data iem_mailitem_pub.acq_email_info_tbl;

1574: , x_msg_data out nocopy VARCHAR2
1575: )
1576:
1577: as
1578: ddx_acq_email_data iem_mailitem_pub.acq_email_info_tbl;
1579: ddindx binary_integer; indx binary_integer;
1580: begin
1581:
1582: -- copy data to the local IN or IN-OUT args, if any

Line 1598: iem_mailitem_pub.getemailheaders(p_api_version_number,

1594:
1595:
1596:
1597: -- here's the delegated call to the old PL/SQL routine
1598: iem_mailitem_pub.getemailheaders(p_api_version_number,
1599: p_init_msg_list,
1600: p_commit,
1601: p_resource_id,
1602: p_email_account_id,

Line 1624: iem_mailitem_pub_w.rosetta_table_copy_out_p6(ddx_acq_email_data, p10_a0

1620:
1621:
1622:
1623:
1624: iem_mailitem_pub_w.rosetta_table_copy_out_p6(ddx_acq_email_data, p10_a0
1625: , p10_a1
1626: , p10_a2
1627: , p10_a3
1628: , p10_a4

Line 1676: ddx_queue_email_data iem_mailitem_pub.queue_email_info_tbl;

1672: , x_msg_data out nocopy VARCHAR2
1673: )
1674:
1675: as
1676: ddx_queue_email_data iem_mailitem_pub.queue_email_info_tbl;
1677: ddindx binary_integer; indx binary_integer;
1678: begin
1679:
1680: -- copy data to the local IN or IN-OUT args, if any

Line 1696: iem_mailitem_pub.getunreademailheaders(p_api_version_number,

1692:
1693:
1694:
1695: -- here's the delegated call to the old PL/SQL routine
1696: iem_mailitem_pub.getunreademailheaders(p_api_version_number,
1697: p_init_msg_list,
1698: p_commit,
1699: p_resource_id,
1700: p_email_account_id,

Line 1722: iem_mailitem_pub_w.rosetta_table_copy_out_p8(ddx_queue_email_data, p10_a0

1718:
1719:
1720:
1721:
1722: iem_mailitem_pub_w.rosetta_table_copy_out_p8(ddx_queue_email_data, p10_a0
1723: , p10_a1
1724: , p10_a2
1725: , p10_a3
1726: , p10_a4

Line 1804: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;

1800: )
1801:
1802: as
1803: ddx_email_data iem_rt_proc_emails%rowtype;
1804: ddx_tag_key_value iem_mailitem_pub.keyvals_tbl_type;
1805: ddindx binary_integer; indx binary_integer;
1806: begin
1807:
1808: -- copy data to the local IN or IN-OUT args, if any

Line 1823: iem_mailitem_pub.getqueueitemdata(p_api_version_number,

1819:
1820:
1821:
1822: -- here's the delegated call to the old PL/SQL routine
1823: iem_mailitem_pub.getqueueitemdata(p_api_version_number,
1824: p_init_msg_list,
1825: p_commit,
1826: p_message_id,
1827: p_from_agent_id,

Line 1890: iem_mailitem_pub_w.rosetta_table_copy_out_p10(ddx_tag_key_value, p8_a0

1886: p7_a41 := ddx_email_data.attribute14;
1887: p7_a42 := ddx_email_data.attribute15;
1888: p7_a43 := ddx_email_data.security_group_id;
1889:
1890: iem_mailitem_pub_w.rosetta_table_copy_out_p10(ddx_tag_key_value, p8_a0
1891: , p8_a1
1892: , p8_a2
1893: );
1894:

Line 1900: end iem_mailitem_pub_w;

1896:
1897:
1898: end;
1899:
1900: end iem_mailitem_pub_w;