APPS.IEM_SPV_MONITORING_PVT_W dependencies on IEM_SPV_MONITORING_PVT

Line 1: package body iem_spv_monitoring_pvt_w as

1: package body iem_spv_monitoring_pvt_w as
2: /* $Header: IEMPSPMB.pls 115.4 2003/09/08 23:46:58 chtang 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_spv_monitoring_pvt.email_activity_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_spv_monitoring_pvt.email_activity_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE

Line 56: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE

52: end loop;
53: end if;
54: end if;
55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_300
59: , a3 out nocopy JTF_NUMBER_TABLE
60: , a4 out nocopy JTF_NUMBER_TABLE

Line 140: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE

136: end if;
137: end if;
138: end rosetta_table_copy_out_p1;
139:
140: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE
141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_800
143: , a3 JTF_NUMBER_TABLE
144: , a4 JTF_NUMBER_TABLE

Line 179: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE

175: end loop;
176: end if;
177: end if;
178: end rosetta_table_copy_in_p3;
179: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
180: , a1 out nocopy JTF_NUMBER_TABLE
181: , a2 out nocopy JTF_VARCHAR2_TABLE_800
182: , a3 out nocopy JTF_NUMBER_TABLE
183: , a4 out nocopy JTF_NUMBER_TABLE

Line 275: ddx_email_activity_tbl iem_spv_monitoring_pvt.email_activity_tbl;

271: , x_msg_data out nocopy VARCHAR2
272: )
273:
274: as
275: ddx_email_activity_tbl iem_spv_monitoring_pvt.email_activity_tbl;
276: ddindx binary_integer; indx binary_integer;
277: begin
278:
279: -- copy data to the local IN or IN-OUT args, if any

Line 288: iem_spv_monitoring_pvt.get_email_activity(p_api_version_number,

284:
285:
286:
287: -- here's the delegated call to the old PL/SQL routine
288: iem_spv_monitoring_pvt.get_email_activity(p_api_version_number,
289: p_init_msg_list,
290: p_commit,
291: ddx_email_activity_tbl,
292: x_return_status,

Line 300: iem_spv_monitoring_pvt_w.rosetta_table_copy_out_p1(ddx_email_activity_tbl, p3_a0

296: -- copy data back from the local variables to OUT or IN-OUT args, if any
297:
298:
299:
300: iem_spv_monitoring_pvt_w.rosetta_table_copy_out_p1(ddx_email_activity_tbl, p3_a0
301: , p3_a1
302: , p3_a2
303: , p3_a3
304: , p3_a4

Line 341: ddx_agent_activity_tbl iem_spv_monitoring_pvt.agent_activity_tbl;

337: , x_msg_data out nocopy VARCHAR2
338: )
339:
340: as
341: ddx_agent_activity_tbl iem_spv_monitoring_pvt.agent_activity_tbl;
342: ddindx binary_integer; indx binary_integer;
343: begin
344:
345: -- copy data to the local IN or IN-OUT args, if any

Line 356: iem_spv_monitoring_pvt.get_agent_activity(p_api_version_number,

352:
353:
354:
355: -- here's the delegated call to the old PL/SQL routine
356: iem_spv_monitoring_pvt.get_agent_activity(p_api_version_number,
357: p_init_msg_list,
358: p_commit,
359: p_resource_role,
360: p_resource_name,

Line 372: iem_spv_monitoring_pvt_w.rosetta_table_copy_out_p3(ddx_agent_activity_tbl, p5_a0

368:
369:
370:
371:
372: iem_spv_monitoring_pvt_w.rosetta_table_copy_out_p3(ddx_agent_activity_tbl, p5_a0
373: , p5_a1
374: , p5_a2
375: , p5_a3
376: , p5_a4

Line 389: end iem_spv_monitoring_pvt_w;

385:
386:
387: end;
388:
389: end iem_spv_monitoring_pvt_w;