APPS.IEM_UTILITY_PVT_W dependencies on IEM_UTILITY_PVT

Line 1: package body iem_utility_pvt_w as

1: package body iem_utility_pvt_w as
2: /* $Header: iemutlwb.pls 115.1 2002/12/12 22:58:41 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:

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy iem_utility_pvt.email_account_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iem_utility_pvt.email_account_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_300
15: ) as
16: ddindx binary_integer; indx binary_integer;
17: begin

Line 34: procedure rosetta_table_copy_out_p1(t iem_utility_pvt.email_account_tbl, a0 out nocopy JTF_NUMBER_TABLE

30: end loop;
31: end if;
32: end if;
33: end rosetta_table_copy_in_p1;
34: procedure rosetta_table_copy_out_p1(t iem_utility_pvt.email_account_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_VARCHAR2_TABLE_300
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin

Line 63: procedure rosetta_table_copy_in_p3(t out nocopy iem_utility_pvt.email_class_tbl, a0 JTF_NUMBER_TABLE

59: end if;
60: end if;
61: end rosetta_table_copy_out_p1;
62:
63: procedure rosetta_table_copy_in_p3(t out nocopy iem_utility_pvt.email_class_tbl, a0 JTF_NUMBER_TABLE
64: , a1 JTF_VARCHAR2_TABLE_100
65: ) as
66: ddindx binary_integer; indx binary_integer;
67: begin

Line 84: procedure rosetta_table_copy_out_p3(t iem_utility_pvt.email_class_tbl, a0 out nocopy JTF_NUMBER_TABLE

80: end loop;
81: end if;
82: end if;
83: end rosetta_table_copy_in_p3;
84: procedure rosetta_table_copy_out_p3(t iem_utility_pvt.email_class_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_100
86: ) as
87: ddindx binary_integer; indx binary_integer;
88: begin

Line 124: ddx_account_tbl iem_utility_pvt.email_account_tbl;

120: , x_msg_data out nocopy VARCHAR2
121: )
122:
123: as
124: ddx_account_tbl iem_utility_pvt.email_account_tbl;
125: ddindx binary_integer; indx binary_integer;
126: begin
127:
128: -- copy data to the local IN or IN-OUT args, if any

Line 137: iem_utility_pvt.getemailaccountlist(p_api_version_number,

133:
134:
135:
136: -- here's the delegated call to the old PL/SQL routine
137: iem_utility_pvt.getemailaccountlist(p_api_version_number,
138: p_init_msg_list,
139: p_commit,
140: ddx_account_tbl,
141: x_return_status,

Line 149: iem_utility_pvt_w.rosetta_table_copy_out_p1(ddx_account_tbl, p3_a0

145: -- copy data back from the local variables to OUT or IN-OUT args, if any
146:
147:
148:
149: iem_utility_pvt_w.rosetta_table_copy_out_p1(ddx_account_tbl, p3_a0
150: , p3_a1
151: );
152:
153:

Line 169: ddx_class_tbl iem_utility_pvt.email_class_tbl;

165: , x_msg_data out nocopy VARCHAR2
166: )
167:
168: as
169: ddx_class_tbl iem_utility_pvt.email_class_tbl;
170: ddindx binary_integer; indx binary_integer;
171: begin
172:
173: -- copy data to the local IN or IN-OUT args, if any

Line 183: iem_utility_pvt.getclasslists(p_api_version_number,

179:
180:
181:
182: -- here's the delegated call to the old PL/SQL routine
183: iem_utility_pvt.getclasslists(p_api_version_number,
184: p_init_msg_list,
185: p_commit,
186: p_email_account_id,
187: ddx_class_tbl,

Line 197: iem_utility_pvt_w.rosetta_table_copy_out_p3(ddx_class_tbl, p4_a0

193:
194:
195:
196:
197: iem_utility_pvt_w.rosetta_table_copy_out_p3(ddx_class_tbl, p4_a0
198: , p4_a1
199: );
200:
201:

Line 205: end iem_utility_pvt_w;

201:
202:
203: end;
204:
205: end iem_utility_pvt_w;