1: package iem_agent_inbox_mgmt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: IEMPAIMS.pls 120.1 2006/02/14 15:17 chtang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_agent_inbox_mgmt_pvt.message_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
1: package iem_agent_inbox_mgmt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: IEMPAIMS.pls 120.1 2006/02/14 15:17 chtang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_agent_inbox_mgmt_pvt.message_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iem_agent_inbox_mgmt_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_NUMBER_TABLE
19: , a2 out nocopy JTF_VARCHAR2_TABLE_300
20: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_DATE_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
33: , a1 JTF_NUMBER_TABLE
34: , a2 JTF_VARCHAR2_TABLE_300
35: , a3 JTF_VARCHAR2_TABLE_2000
36: , a4 JTF_VARCHAR2_TABLE_100
41: , a9 JTF_VARCHAR2_TABLE_400
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_VARCHAR2_TABLE_300
48: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a10 out nocopy JTF_NUMBER_TABLE
56: , a11 out nocopy JTF_NUMBER_TABLE
57: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_200
61: , a2 JTF_NUMBER_TABLE
62: , a3 JTF_VARCHAR2_TABLE_500
63: );
60: , a1 JTF_VARCHAR2_TABLE_200
61: , a2 JTF_NUMBER_TABLE
62: , a3 JTF_VARCHAR2_TABLE_500
63: );
64: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_VARCHAR2_TABLE_200
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_VARCHAR2_TABLE_500
68: );
116: , x_return_status out nocopy VARCHAR2
117: , x_msg_count out nocopy NUMBER
118: , x_msg_data out nocopy VARCHAR2
119: );
120: end iem_agent_inbox_mgmt_pvt_w;