APPS.IEM_AGENT_INBOX_MGMT_PVT_W dependencies on IEM_AGENT_INBOX_MGMT_PVT

Line 1: package body iem_agent_inbox_mgmt_pvt_w as

1: package body iem_agent_inbox_mgmt_pvt_w as
2: /* $Header: IEMPAIMB.pls 120.1 2006/02/14 15:17 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_agent_inbox_mgmt_pvt.message_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_agent_inbox_mgmt_pvt.message_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_2000
17: , a4 JTF_VARCHAR2_TABLE_100

Line 56: procedure rosetta_table_copy_out_p1(t iem_agent_inbox_mgmt_pvt.message_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_agent_inbox_mgmt_pvt.message_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_VARCHAR2_TABLE_2000
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_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_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_300
143: , a3 JTF_VARCHAR2_TABLE_2000
144: , a4 JTF_VARCHAR2_TABLE_100

Line 181: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE

177: end loop;
178: end if;
179: end if;
180: end rosetta_table_copy_in_p3;
181: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
182: , a1 out nocopy JTF_NUMBER_TABLE
183: , a2 out nocopy JTF_VARCHAR2_TABLE_300
184: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 260: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE

256: end if;
257: end if;
258: end rosetta_table_copy_out_p3;
259:
260: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
261: , a1 JTF_VARCHAR2_TABLE_200
262: , a2 JTF_NUMBER_TABLE
263: , a3 JTF_VARCHAR2_TABLE_500
264: ) as

Line 285: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

281: end loop;
282: end if;
283: end if;
284: end rosetta_table_copy_in_p5;
285: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
286: , a1 out nocopy JTF_VARCHAR2_TABLE_200
287: , a2 out nocopy JTF_NUMBER_TABLE
288: , a3 out nocopy JTF_VARCHAR2_TABLE_500
289: ) as

Line 359: ddx_message_tbl iem_agent_inbox_mgmt_pvt.message_tbl;

355: , x_msg_data out nocopy VARCHAR2
356: )
357:
358: as
359: ddx_message_tbl iem_agent_inbox_mgmt_pvt.message_tbl;
360: ddindx binary_integer; indx binary_integer;
361: begin
362:
363: -- copy data to the local IN or IN-OUT args, if any

Line 385: iem_agent_inbox_mgmt_pvt.search_messages_in_inbox(p_api_version_number,

381:
382:
383:
384: -- here's the delegated call to the old PL/SQL routine
385: iem_agent_inbox_mgmt_pvt.search_messages_in_inbox(p_api_version_number,
386: p_init_msg_list,
387: p_commit,
388: p_email_account_id,
389: p_classification_id,

Line 423: iem_agent_inbox_mgmt_pvt_w.rosetta_table_copy_out_p1(ddx_message_tbl, p16_a0

419:
420:
421:
422:
423: iem_agent_inbox_mgmt_pvt_w.rosetta_table_copy_out_p1(ddx_message_tbl, p16_a0
424: , p16_a1
425: , p16_a2
426: , p16_a3
427: , p16_a4

Line 461: ddx_resource_count iem_agent_inbox_mgmt_pvt.resource_count_tbl;

457: , x_msg_data out nocopy VARCHAR2
458: )
459:
460: as
461: ddx_resource_count iem_agent_inbox_mgmt_pvt.resource_count_tbl;
462: ddindx binary_integer; indx binary_integer;
463: begin
464:
465: -- copy data to the local IN or IN-OUT args, if any

Line 480: iem_agent_inbox_mgmt_pvt.show_agent_list(p_api_version_number,

476:
477:
478:
479: -- here's the delegated call to the old PL/SQL routine
480: iem_agent_inbox_mgmt_pvt.show_agent_list(p_api_version_number,
481: p_init_msg_list,
482: p_commit,
483: p_email_account_id,
484: p_sort_column,

Line 504: iem_agent_inbox_mgmt_pvt_w.rosetta_table_copy_out_p5(ddx_resource_count, p9_a0

500:
501:
502:
503:
504: iem_agent_inbox_mgmt_pvt_w.rosetta_table_copy_out_p5(ddx_resource_count, p9_a0
505: , p9_a1
506: , p9_a2
507: , p9_a3
508: );

Line 514: end iem_agent_inbox_mgmt_pvt_w;

510:
511:
512: end;
513:
514: end iem_agent_inbox_mgmt_pvt_w;