[Home] [Help]
PACKAGE: APPS.IEM_AGENT_INBOX_MGMT_PVT_W
Source
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
8 , a5 JTF_VARCHAR2_TABLE_400
9 , a6 JTF_VARCHAR2_TABLE_500
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_VARCHAR2_TABLE_400
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
22 , a5 out nocopy JTF_VARCHAR2_TABLE_400
23 , a6 out nocopy JTF_VARCHAR2_TABLE_500
24 , a7 out nocopy JTF_NUMBER_TABLE
25 , a8 out nocopy JTF_NUMBER_TABLE
26 , a9 out nocopy JTF_VARCHAR2_TABLE_400
27 , a10 out nocopy JTF_NUMBER_TABLE
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
37 , a5 JTF_VARCHAR2_TABLE_400
38 , a6 JTF_VARCHAR2_TABLE_500
39 , a7 JTF_VARCHAR2_TABLE_100
40 , a8 JTF_NUMBER_TABLE
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
50 , a5 out nocopy JTF_VARCHAR2_TABLE_400
51 , a6 out nocopy JTF_VARCHAR2_TABLE_500
52 , a7 out nocopy JTF_VARCHAR2_TABLE_100
53 , a8 out nocopy JTF_NUMBER_TABLE
54 , a9 out nocopy JTF_VARCHAR2_TABLE_400
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 );
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 );
69
70 procedure search_messages_in_inbox(p_api_version_number NUMBER
71 , p_init_msg_list VARCHAR2
72 , p_commit VARCHAR2
73 , p_email_account_id NUMBER
74 , p_classification_id NUMBER
75 , p_subject VARCHAR2
76 , p_customer_name VARCHAR2
77 , p_sender_name VARCHAR2
78 , p_sent_date_from VARCHAR2
79 , p_sent_date_to VARCHAR2
80 , p_sent_date_format VARCHAR2
81 , p_resource_name VARCHAR2
82 , p_resource_id NUMBER
83 , p_page_flag NUMBER
84 , p_sort_column NUMBER
85 , p_sort_state VARCHAR2
86 , p16_a0 out nocopy JTF_NUMBER_TABLE
87 , p16_a1 out nocopy JTF_NUMBER_TABLE
88 , p16_a2 out nocopy JTF_VARCHAR2_TABLE_300
89 , p16_a3 out nocopy JTF_VARCHAR2_TABLE_2000
90 , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100
91 , p16_a5 out nocopy JTF_VARCHAR2_TABLE_400
92 , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
93 , p16_a7 out nocopy JTF_NUMBER_TABLE
94 , p16_a8 out nocopy JTF_NUMBER_TABLE
95 , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
96 , p16_a10 out nocopy JTF_NUMBER_TABLE
97 , p16_a11 out nocopy JTF_NUMBER_TABLE
98 , p16_a12 out nocopy JTF_DATE_TABLE
99 , x_return_status out nocopy VARCHAR2
100 , x_msg_count out nocopy NUMBER
101 , x_msg_data out nocopy VARCHAR2
102 );
103 procedure show_agent_list(p_api_version_number NUMBER
104 , p_init_msg_list VARCHAR2
105 , p_commit VARCHAR2
106 , p_email_account_id NUMBER
107 , p_sort_column NUMBER
108 , p_sort_state VARCHAR2
109 , p_resource_role NUMBER
110 , p_resource_name VARCHAR2
111 , p_transferrer_id NUMBER
112 , p9_a0 out nocopy JTF_NUMBER_TABLE
113 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
114 , p9_a2 out nocopy JTF_NUMBER_TABLE
115 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_500
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;