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.
PACKAGE: APPS.IEM_EMAILPROC_PVT_W

Source


1 package iem_emailproc_pvt_w AUTHID CURRENT_USER as
2   /* $Header: iemvepcs.pls 115.4 2003/08/19 20:44:38 liangxia noship $ */
3   procedure rosetta_table_copy_in_p5(t out nocopy iem_emailproc_pvt.emailproc_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_300
5     , a2 JTF_VARCHAR2_TABLE_300
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_300
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_VARCHAR2_TABLE_100
11     );
12   procedure rosetta_table_copy_out_p5(t iem_emailproc_pvt.emailproc_tbl, a0 out nocopy JTF_NUMBER_TABLE
13     , a1 out nocopy JTF_VARCHAR2_TABLE_300
14     , a2 out nocopy JTF_VARCHAR2_TABLE_300
15     , a3 out nocopy JTF_VARCHAR2_TABLE_100
16     , a4 out nocopy JTF_VARCHAR2_TABLE_100
17     , a5 out nocopy JTF_VARCHAR2_TABLE_300
18     , a6 out nocopy JTF_VARCHAR2_TABLE_100
19     , a7 out nocopy JTF_VARCHAR2_TABLE_100
20     );
21 
22   procedure rosetta_table_copy_in_p7(t out nocopy iem_emailproc_pvt.acctemailproc_tbl, a0 JTF_NUMBER_TABLE
23     , a1 JTF_NUMBER_TABLE
24     , a2 JTF_VARCHAR2_TABLE_300
25     , a3 JTF_VARCHAR2_TABLE_300
26     , a4 JTF_VARCHAR2_TABLE_100
27     , a5 JTF_VARCHAR2_TABLE_100
28     , a6 JTF_VARCHAR2_TABLE_100
29     , a7 JTF_NUMBER_TABLE
30     , a8 JTF_VARCHAR2_TABLE_100
31     );
32   procedure rosetta_table_copy_out_p7(t iem_emailproc_pvt.acctemailproc_tbl, a0 out nocopy JTF_NUMBER_TABLE
33     , a1 out nocopy JTF_NUMBER_TABLE
34     , a2 out nocopy JTF_VARCHAR2_TABLE_300
35     , a3 out nocopy JTF_VARCHAR2_TABLE_300
36     , a4 out nocopy JTF_VARCHAR2_TABLE_100
37     , a5 out nocopy JTF_VARCHAR2_TABLE_100
38     , a6 out nocopy JTF_VARCHAR2_TABLE_100
39     , a7 out nocopy JTF_NUMBER_TABLE
40     , a8 out nocopy JTF_VARCHAR2_TABLE_100
41     );
42 
43   procedure loademailproc(p_api_version_number  NUMBER
44     , p_init_msg_list  VARCHAR2
45     , p_commit  VARCHAR2
46     , p3_a0 out nocopy JTF_NUMBER_TABLE
47     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_300
48     , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
49     , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
50     , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
51     , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
52     , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
53     , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
54     , p4_a0 out nocopy JTF_NUMBER_TABLE
55     , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300
56     , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
57     , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
58     , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
59     , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
60     , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
61     , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
62     , p5_a0 out nocopy JTF_NUMBER_TABLE
63     , p5_a1 out nocopy JTF_VARCHAR2_TABLE_300
64     , p5_a2 out nocopy JTF_VARCHAR2_TABLE_300
65     , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
66     , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
67     , p5_a5 out nocopy JTF_VARCHAR2_TABLE_300
68     , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
69     , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
70     , p6_a0 out nocopy JTF_NUMBER_TABLE
71     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
72     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
73     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
74     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
75     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
76     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
77     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
78     , p7_a0 out nocopy JTF_NUMBER_TABLE
79     , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300
80     , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
81     , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
82     , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
83     , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
84     , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
85     , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
86     , p8_a0 out nocopy JTF_NUMBER_TABLE
87     , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
88     , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
89     , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
90     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
91     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_300
92     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
93     , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
94     , p9_a0 out nocopy JTF_NUMBER_TABLE
95     , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300
96     , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
97     , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
98     , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
99     , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
100     , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
101     , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
102     , p10_a0 out nocopy JTF_NUMBER_TABLE
103     , p10_a1 out nocopy JTF_VARCHAR2_TABLE_300
104     , p10_a2 out nocopy JTF_VARCHAR2_TABLE_300
105     , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
106     , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
107     , p10_a5 out nocopy JTF_VARCHAR2_TABLE_300
108     , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
109     , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
110     , x_return_status out nocopy  VARCHAR2
111     , x_msg_count out nocopy  NUMBER
112     , x_msg_data out nocopy  VARCHAR2
113   );
114   procedure loadacctemailproc(p_api_version_number  NUMBER
115     , p_init_msg_list  VARCHAR2
116     , p_commit  VARCHAR2
117     , p_acct_id  NUMBER
118     , p4_a0 out nocopy JTF_NUMBER_TABLE
119     , p4_a1 out nocopy JTF_NUMBER_TABLE
120     , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
121     , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
122     , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
123     , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
124     , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
125     , p4_a7 out nocopy JTF_NUMBER_TABLE
126     , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
127     , p5_a0 out nocopy JTF_NUMBER_TABLE
128     , p5_a1 out nocopy JTF_NUMBER_TABLE
129     , p5_a2 out nocopy JTF_VARCHAR2_TABLE_300
130     , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
131     , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
132     , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
133     , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
134     , p5_a7 out nocopy JTF_NUMBER_TABLE
135     , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
136     , p6_a0 out nocopy JTF_NUMBER_TABLE
137     , p6_a1 out nocopy JTF_NUMBER_TABLE
138     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
139     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
140     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
141     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
142     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
143     , p6_a7 out nocopy JTF_NUMBER_TABLE
144     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
145     , p7_a0 out nocopy JTF_NUMBER_TABLE
146     , p7_a1 out nocopy JTF_NUMBER_TABLE
147     , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
148     , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
149     , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
150     , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
151     , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
152     , p7_a7 out nocopy JTF_NUMBER_TABLE
153     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
154     , p8_a0 out nocopy JTF_NUMBER_TABLE
155     , p8_a1 out nocopy JTF_NUMBER_TABLE
156     , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
157     , p8_a3 out nocopy JTF_VARCHAR2_TABLE_300
158     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
159     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
160     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
161     , p8_a7 out nocopy JTF_NUMBER_TABLE
162     , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
163     , p9_a0 out nocopy JTF_NUMBER_TABLE
164     , p9_a1 out nocopy JTF_NUMBER_TABLE
165     , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
166     , p9_a3 out nocopy JTF_VARCHAR2_TABLE_300
167     , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
168     , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
169     , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
170     , p9_a7 out nocopy JTF_NUMBER_TABLE
171     , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
172     , p10_a0 out nocopy JTF_NUMBER_TABLE
173     , p10_a1 out nocopy JTF_NUMBER_TABLE
174     , p10_a2 out nocopy JTF_VARCHAR2_TABLE_300
175     , p10_a3 out nocopy JTF_VARCHAR2_TABLE_300
176     , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
177     , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
178     , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
179     , p10_a7 out nocopy JTF_NUMBER_TABLE
180     , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
181     , p11_a0 out nocopy JTF_NUMBER_TABLE
182     , p11_a1 out nocopy JTF_NUMBER_TABLE
183     , p11_a2 out nocopy JTF_VARCHAR2_TABLE_300
184     , p11_a3 out nocopy JTF_VARCHAR2_TABLE_300
185     , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
186     , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
187     , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
188     , p11_a7 out nocopy JTF_NUMBER_TABLE
189     , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
190     , x_return_status out nocopy  VARCHAR2
191     , x_msg_count out nocopy  NUMBER
192     , x_msg_data out nocopy  VARCHAR2
193   );
194 end iem_emailproc_pvt_w;