DBA Data[Home] [Help]

APPS.IEM_EML_CLASSIFICATIONS_PVT_W dependencies on IEM_EML_CLASSIFICATIONS_PVT

Line 1: package body iem_eml_classifications_pvt_w as

1: package body iem_eml_classifications_pvt_w as
2: /* $Header: IEMVCLSB.pls 115.8 2003/08/06 20:54:50 ukari shipped $ */
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_eml_classifications_pvt.emclass_tbl_type, 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_eml_classifications_pvt.emclass_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_NUMBER_TABLE
16: ) as
17: ddindx binary_integer; indx binary_integer;

Line 36: procedure rosetta_table_copy_out_p1(t iem_eml_classifications_pvt.emclass_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t iem_eml_classifications_pvt.emclass_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_100
38: , a2 out nocopy JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;

Line 112: iem_eml_classifications_pvt.create_item(p_api_version_number,

108:
109:
110:
111: -- here's the delegated call to the old PL/SQL routine
112: iem_eml_classifications_pvt.create_item(p_api_version_number,
113: p_init_msg_list,
114: p_commit,
115: p_email_account_id,
116: p_classification_id,

Line 159: ddx_email_classn_tbl iem_eml_classifications_pvt.emclass_tbl_type;

155: , x_msg_data out nocopy VARCHAR2
156: )
157:
158: as
159: ddx_email_classn_tbl iem_eml_classifications_pvt.emclass_tbl_type;
160: ddindx binary_integer; indx binary_integer;
161: begin
162:
163: -- copy data to the local IN or IN-OUT args, if any

Line 174: iem_eml_classifications_pvt.getclassification(p_api_version_number,

170:
171:
172:
173: -- here's the delegated call to the old PL/SQL routine
174: iem_eml_classifications_pvt.getclassification(p_api_version_number,
175: p_init_msg_list,
176: p_commit,
177: p_email_account_id,
178: p_message_id,

Line 190: iem_eml_classifications_pvt_w.rosetta_table_copy_out_p1(ddx_email_classn_tbl, p5_a0

186:
187:
188:
189:
190: iem_eml_classifications_pvt_w.rosetta_table_copy_out_p1(ddx_email_classn_tbl, p5_a0
191: , p5_a1
192: , p5_a2
193: );
194:

Line 214: ddx_email_classn_tbl iem_eml_classifications_pvt.emclass_tbl_type;

210: , x_msg_data out nocopy VARCHAR2
211: )
212:
213: as
214: ddx_email_classn_tbl iem_eml_classifications_pvt.emclass_tbl_type;
215: ddindx binary_integer; indx binary_integer;
216: begin
217:
218: -- copy data to the local IN or IN-OUT args, if any

Line 230: iem_eml_classifications_pvt.getclassification(p_api_version_number,

226:
227:
228:
229: -- here's the delegated call to the old PL/SQL routine
230: iem_eml_classifications_pvt.getclassification(p_api_version_number,
231: p_init_msg_list,
232: p_commit,
233: p_email_account_id,
234: p_message_id,

Line 248: iem_eml_classifications_pvt_w.rosetta_table_copy_out_p1(ddx_email_classn_tbl, p6_a0

244:
245:
246:
247:
248: iem_eml_classifications_pvt_w.rosetta_table_copy_out_p1(ddx_email_classn_tbl, p6_a0
249: , p6_a1
250: , p6_a2
251: );
252:

Line 301: iem_eml_classifications_pvt.create_item(p_api_version_number,

297:
298:
299:
300: -- here's the delegated call to the old PL/SQL routine
301: iem_eml_classifications_pvt.create_item(p_api_version_number,
302: p_init_msg_list,
303: p_commit,
304: p_email_account_id,
305: p_classification_id,

Line 336: end iem_eml_classifications_pvt_w;

332:
333:
334: end;
335:
336: end iem_eml_classifications_pvt_w;