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_EMAILACCOUNT_PUB_W dependencies on IEM_EMAILACCOUNT_PUB

Line 1: package body iem_emailaccount_pub_w as

1: package body iem_emailaccount_pub_w as
2: /* $Header: IEMVEMAB.pls 120.5 2011/12/25 17:36:47 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_emailaccount_pub.emacnt_tbl_type, a0 JTF_VARCHAR2_TABLE_300

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_emailaccount_pub.emacnt_tbl_type, a0 JTF_VARCHAR2_TABLE_300
17: , a1 JTF_VARCHAR2_TABLE_300
18: , a2 JTF_VARCHAR2_TABLE_200
19: , a3 JTF_NUMBER_TABLE
20: ) as

Line 41: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p1;
41: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
42: , a1 out nocopy JTF_VARCHAR2_TABLE_300
43: , a2 out nocopy JTF_VARCHAR2_TABLE_200
44: , a3 out nocopy JTF_NUMBER_TABLE
45: ) as

Line 80: procedure rosetta_table_copy_in_p4(t out nocopy iem_emailaccount_pub.msg_header_table, a0 JTF_NUMBER_TABLE

76: end if;
77: end if;
78: end rosetta_table_copy_out_p1;
79:
80: procedure rosetta_table_copy_in_p4(t out nocopy iem_emailaccount_pub.msg_header_table, a0 JTF_NUMBER_TABLE
81: , a1 JTF_VARCHAR2_TABLE_300
82: , a2 JTF_VARCHAR2_TABLE_200
83: , a3 JTF_DATE_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100

Line 121: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE

117: end loop;
118: end if;
119: end if;
120: end rosetta_table_copy_in_p4;
121: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_300
123: , a2 out nocopy JTF_VARCHAR2_TABLE_200
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 200: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100

196: end if;
197: end if;
198: end rosetta_table_copy_out_p4;
199:
200: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100
201: , a1 JTF_VARCHAR2_TABLE_100
202: , a2 JTF_VARCHAR2_TABLE_200
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_NUMBER_TABLE

Line 227: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100

223: end loop;
224: end if;
225: end if;
226: end rosetta_table_copy_in_p6;
227: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_VARCHAR2_TABLE_200
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_NUMBER_TABLE

Line 271: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300

267: end if;
268: end if;
269: end rosetta_table_copy_out_p6;
270:
271: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300
272: , a1 JTF_VARCHAR2_TABLE_100
273: , a2 JTF_VARCHAR2_TABLE_200
274: , a3 JTF_VARCHAR2_TABLE_300
275: , a4 JTF_VARCHAR2_TABLE_100

Line 308: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

304: end loop;
305: end if;
306: end if;
307: end rosetta_table_copy_in_p8;
308: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
309: , a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , a2 out nocopy JTF_VARCHAR2_TABLE_200
311: , a3 out nocopy JTF_VARCHAR2_TABLE_300
312: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 377: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE

373: end if;
374: end if;
375: end rosetta_table_copy_out_p8;
376:
377: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
378: , a1 JTF_VARCHAR2_TABLE_300
379: , a2 JTF_VARCHAR2_TABLE_300
380: , a3 JTF_VARCHAR2_TABLE_100
381: , a4 JTF_VARCHAR2_TABLE_300

Line 404: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

400: end loop;
401: end if;
402: end if;
403: end rosetta_table_copy_in_p10;
404: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_VARCHAR2_TABLE_300
406: , a2 out nocopy JTF_VARCHAR2_TABLE_300
407: , a3 out nocopy JTF_VARCHAR2_TABLE_100
408: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 448: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE

444: end if;
445: end if;
446: end rosetta_table_copy_out_p10;
447:
448: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
449: , a1 JTF_NUMBER_TABLE
450: , a2 JTF_VARCHAR2_TABLE_300
451: , a3 JTF_VARCHAR2_TABLE_300
452: , a4 JTF_VARCHAR2_TABLE_300

Line 481: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

477: end loop;
478: end if;
479: end if;
480: end rosetta_table_copy_in_p12;
481: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_VARCHAR2_TABLE_300
484: , a3 out nocopy JTF_VARCHAR2_TABLE_300
485: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 554: ddx_email_acnt_tbl iem_emailaccount_pub.emacnt_tbl_type;

550: , p7_a3 out nocopy JTF_NUMBER_TABLE
551: )
552:
553: as
554: ddx_email_acnt_tbl iem_emailaccount_pub.emacnt_tbl_type;
555: ddindx binary_integer; indx binary_integer;
556: begin
557:
558: -- copy data to the local IN or IN-OUT args, if any

Line 568: iem_emailaccount_pub.get_emailaccount_list(p_api_version_number,

564:
565:
566:
567: -- here's the delegated call to the old PL/SQL routine
568: iem_emailaccount_pub.get_emailaccount_list(p_api_version_number,
569: p_init_msg_list,
570: p_commit,
571: p_resource_id,
572: x_return_status,

Line 585: iem_emailaccount_pub_w.rosetta_table_copy_out_p1(ddx_email_acnt_tbl, p7_a0

581:
582:
583:
584:
585: iem_emailaccount_pub_w.rosetta_table_copy_out_p1(ddx_email_acnt_tbl, p7_a0
586: , p7_a1
587: , p7_a2
588: , p7_a3
589: );

Line 611: ddmessage_headers iem_emailaccount_pub.msg_header_table;

607: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
608: )
609:
610: as
611: ddmessage_headers iem_emailaccount_pub.msg_header_table;
612: ddindx binary_integer; indx binary_integer;
613: begin
614:
615: -- copy data to the local IN or IN-OUT args, if any

Line 622: iem_emailaccount_pub.getemailheaders(p_agentname,

618:
619:
620:
621: -- here's the delegated call to the old PL/SQL routine
622: iem_emailaccount_pub.getemailheaders(p_agentname,
623: p_top_n,
624: p_top_option,
625: p_folder_path,
626: ddmessage_headers);

Line 633: iem_emailaccount_pub_w.rosetta_table_copy_out_p4(ddmessage_headers, p4_a0

629:
630:
631:
632:
633: iem_emailaccount_pub_w.rosetta_table_copy_out_p4(ddmessage_headers, p4_a0
634: , p4_a1
635: , p4_a2
636: , p4_a3
637: , p4_a4

Line 666: ddx_agent_acnt_tbl iem_emailaccount_pub.agentacnt_tbl_type;

662: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
663: )
664:
665: as
666: ddx_agent_acnt_tbl iem_emailaccount_pub.agentacnt_tbl_type;
667: ddindx binary_integer; indx binary_integer;
668: begin
669:
670: -- copy data to the local IN or IN-OUT args, if any

Line 680: iem_emailaccount_pub.listagentaccounts(p_api_version_number,

676:
677:
678:
679: -- here's the delegated call to the old PL/SQL routine
680: iem_emailaccount_pub.listagentaccounts(p_api_version_number,
681: p_init_msg_list,
682: p_commit,
683: p_resource_id,
684: x_return_status,

Line 697: iem_emailaccount_pub_w.rosetta_table_copy_out_p12(ddx_agent_acnt_tbl, p7_a0

693:
694:
695:
696:
697: iem_emailaccount_pub_w.rosetta_table_copy_out_p12(ddx_agent_acnt_tbl, p7_a0
698: , p7_a1
699: , p7_a2
700: , p7_a3
701: , p7_a4

Line 726: ddx_agent_acnt_tbl iem_emailaccount_pub.agentacnt_tbl_type;

722: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
723: )
724:
725: as
726: ddx_agent_acnt_tbl iem_emailaccount_pub.agentacnt_tbl_type;
727: ddindx binary_integer; indx binary_integer;
728: begin
729:
730: -- copy data to the local IN or IN-OUT args, if any

Line 740: iem_emailaccount_pub.listagentcpaccounts(p_api_version_number,

736:
737:
738:
739: -- here's the delegated call to the old PL/SQL routine
740: iem_emailaccount_pub.listagentcpaccounts(p_api_version_number,
741: p_init_msg_list,
742: p_commit,
743: p_resource_id,
744: x_return_status,

Line 757: iem_emailaccount_pub_w.rosetta_table_copy_out_p12(ddx_agent_acnt_tbl, p7_a0

753:
754:
755:
756:
757: iem_emailaccount_pub_w.rosetta_table_copy_out_p12(ddx_agent_acnt_tbl, p7_a0
758: , p7_a1
759: , p7_a2
760: , p7_a3
761: , p7_a4

Line 791: ddx_agent_acnt_dtl_data iem_emailaccount_pub.agntacntdetails_tbl_type;

787: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
788: )
789:
790: as
791: ddx_agent_acnt_dtl_data iem_emailaccount_pub.agntacntdetails_tbl_type;
792: ddindx binary_integer; indx binary_integer;
793: begin
794:
795: -- copy data to the local IN or IN-OUT args, if any

Line 813: iem_emailaccount_pub.listagentaccountdetails(p_api_version_number,

809:
810:
811:
812: -- here's the delegated call to the old PL/SQL routine
813: iem_emailaccount_pub.listagentaccountdetails(p_api_version_number,
814: p_init_msg_list,
815: p_commit,
816: p_email_account_id,
817: p_roleid,

Line 846: iem_emailaccount_pub_w.rosetta_table_copy_out_p10(ddx_agent_acnt_dtl_data, p15_a0

842:
843:
844:
845:
846: iem_emailaccount_pub_w.rosetta_table_copy_out_p10(ddx_agent_acnt_dtl_data, p15_a0
847: , p15_a1
848: , p15_a2
849: , p15_a3
850: , p15_a4

Line 874: ddx_acnt_details_tbl iem_emailaccount_pub.acntdetails_tbl_type;

870: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
871: )
872:
873: as
874: ddx_acnt_details_tbl iem_emailaccount_pub.acntdetails_tbl_type;
875: ddindx binary_integer; indx binary_integer;
876: begin
877:
878: -- copy data to the local IN or IN-OUT args, if any

Line 888: iem_emailaccount_pub.listaccountdetails(p_api_version_number,

884:
885:
886:
887: -- here's the delegated call to the old PL/SQL routine
888: iem_emailaccount_pub.listaccountdetails(p_api_version_number,
889: p_init_msg_list,
890: p_commit,
891: p_email_account_id,
892: x_return_status,

Line 905: iem_emailaccount_pub_w.rosetta_table_copy_out_p8(ddx_acnt_details_tbl, p7_a0

901:
902:
903:
904:
905: iem_emailaccount_pub_w.rosetta_table_copy_out_p8(ddx_acnt_details_tbl, p7_a0
906: , p7_a1
907: , p7_a2
908: , p7_a3
909: , p7_a4

Line 918: end iem_emailaccount_pub_w;

914: , p7_a9
915: );
916: end;
917:
918: end iem_emailaccount_pub_w;