[Home] [Help]
PACKAGE: APPS.IEM_QUEUE_MANAGEMENT_PVT_W
Source
1 package iem_queue_management_pvt_w AUTHID CURRENT_USER as
2 /* $Header: IEMPQUMS.pls 120.1 2006/02/13 14:32 chtang noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy iem_queue_management_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_100
13 , a10 JTF_DATE_TABLE
14 );
15 procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_NUMBER_TABLE
17 , a2 out nocopy JTF_VARCHAR2_TABLE_300
18 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
19 , a4 out nocopy JTF_VARCHAR2_TABLE_100
20 , a5 out nocopy JTF_VARCHAR2_TABLE_400
21 , a6 out nocopy JTF_VARCHAR2_TABLE_500
22 , a7 out nocopy JTF_NUMBER_TABLE
23 , a8 out nocopy JTF_NUMBER_TABLE
24 , a9 out nocopy JTF_VARCHAR2_TABLE_100
25 , a10 out nocopy JTF_DATE_TABLE
26 );
27
28 procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
29 , a1 JTF_NUMBER_TABLE
30 , a2 JTF_VARCHAR2_TABLE_300
31 , a3 JTF_VARCHAR2_TABLE_2000
32 , a4 JTF_VARCHAR2_TABLE_100
33 , a5 JTF_VARCHAR2_TABLE_400
34 , a6 JTF_VARCHAR2_TABLE_500
35 , a7 JTF_VARCHAR2_TABLE_100
36 , a8 JTF_NUMBER_TABLE
37 , a9 JTF_VARCHAR2_TABLE_100
38 );
39 procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
40 , a1 out nocopy JTF_NUMBER_TABLE
41 , a2 out nocopy JTF_VARCHAR2_TABLE_300
42 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
43 , a4 out nocopy JTF_VARCHAR2_TABLE_100
44 , a5 out nocopy JTF_VARCHAR2_TABLE_400
45 , a6 out nocopy JTF_VARCHAR2_TABLE_500
46 , a7 out nocopy JTF_VARCHAR2_TABLE_100
47 , a8 out nocopy JTF_NUMBER_TABLE
48 , a9 out nocopy JTF_VARCHAR2_TABLE_100
49 );
50
51 procedure rosetta_table_copy_in_p5(t out nocopy iem_queue_management_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
52 , a1 JTF_VARCHAR2_TABLE_200
53 , a2 JTF_NUMBER_TABLE
54 , a3 JTF_VARCHAR2_TABLE_500
55 );
56 procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
57 , a1 out nocopy JTF_VARCHAR2_TABLE_200
58 , a2 out nocopy JTF_NUMBER_TABLE
59 , a3 out nocopy JTF_VARCHAR2_TABLE_500
60 );
61
62 procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE
63 , a1 JTF_VARCHAR2_TABLE_200
64 , a2 JTF_NUMBER_TABLE
65 , a3 JTF_NUMBER_TABLE
66 );
67 procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
68 , a1 out nocopy JTF_VARCHAR2_TABLE_200
69 , a2 out nocopy JTF_NUMBER_TABLE
70 , a3 out nocopy JTF_NUMBER_TABLE
71 );
72
73 procedure search_messages_in_queue(p_api_version_number NUMBER
74 , p_init_msg_list VARCHAR2
75 , p_commit VARCHAR2
76 , p_email_account_id NUMBER
77 , p_classification_id NUMBER
78 , p_subject VARCHAR2
79 , p_customer_name VARCHAR2
80 , p_sender_name VARCHAR2
81 , p_sent_date_from VARCHAR2
82 , p_sent_date_to VARCHAR2
83 , p_sent_date_format VARCHAR2
84 , p_group_id NUMBER
85 , p_sort_column NUMBER
86 , p_sort_state VARCHAR2
87 , p14_a0 out nocopy JTF_NUMBER_TABLE
88 , p14_a1 out nocopy JTF_NUMBER_TABLE
89 , p14_a2 out nocopy JTF_VARCHAR2_TABLE_300
90 , p14_a3 out nocopy JTF_VARCHAR2_TABLE_2000
91 , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
92 , p14_a5 out nocopy JTF_VARCHAR2_TABLE_400
93 , p14_a6 out nocopy JTF_VARCHAR2_TABLE_500
94 , p14_a7 out nocopy JTF_NUMBER_TABLE
95 , p14_a8 out nocopy JTF_NUMBER_TABLE
96 , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
97 , p14_a10 out nocopy JTF_DATE_TABLE
98 , x_return_status out nocopy VARCHAR2
99 , x_msg_count out nocopy NUMBER
100 , x_msg_data out nocopy VARCHAR2
101 );
102 procedure show_agent_list(p_api_version_number NUMBER
103 , p_init_msg_list VARCHAR2
104 , p_commit VARCHAR2
105 , p_email_account_id NUMBER
106 , p_sort_column NUMBER
107 , p_sort_state VARCHAR2
108 , p6_a0 out nocopy JTF_NUMBER_TABLE
109 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
110 , p6_a2 out nocopy JTF_NUMBER_TABLE
111 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
112 , x_return_status out nocopy VARCHAR2
113 , x_msg_count out nocopy NUMBER
114 , x_msg_data out nocopy VARCHAR2
115 );
116 procedure show_resource_group_list(p_api_version_number NUMBER
117 , p_init_msg_list VARCHAR2
118 , p_commit VARCHAR2
119 , p_email_account_id NUMBER
120 , p_sort_column NUMBER
121 , p_sort_state VARCHAR2
122 , p6_a0 out nocopy JTF_NUMBER_TABLE
123 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
124 , p6_a2 out nocopy JTF_NUMBER_TABLE
125 , p6_a3 out nocopy JTF_NUMBER_TABLE
126 , x_return_status out nocopy VARCHAR2
127 , x_msg_count out nocopy NUMBER
128 , x_msg_data out nocopy VARCHAR2
129 );
130 end iem_queue_management_pvt_w;