1 PACKAGE IEM_SEARCHMESSAGE_PVT as
2 /* $Header: iemvmshs.pls 120.0 2005/06/02 14:18:49 appldev noship $*/
3 -- Start of Comments
4 -- API name : create_item
5 -- Type : Private
6 -- Function : This procedure insert/delete a record in the table IEM_AGENTS
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN
10 -- p_api_version_number IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
12 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 --
14 -- OUT
15 -- x_return_status OUT VARCHAR2
16 -- x_msg_count OUT NUMBER
17 -- x_msg_data OUT VARCHAR2
18 --
19 -- Version : 1.0
20 -- Notes :
21 --
22 -- End of comments
23 -- **********************************************************
24
25 TYPE message_rec_type IS RECORD (
26 message_id number,
27 ih_media_item_id number,
28 from_str varchar2(500),
29 to_str varchar2(2000),
30 subject varchar2(2000),
31 sent_date varchar2(60));
32
33 TYPE message_rec_tbl IS TABLE OF message_rec_type
34 INDEX BY BINARY_INTEGER;
35 PROCEDURE searchmessages (p_api_version_number IN NUMBER,
36 p_init_msg_list IN VARCHAR2 ,
37 p_commit IN VARCHAR2 ,
38 p_email_account_id IN NUMBER,
39 p_resource_id IN NUMBER,
40 p_email_queue IN varchar2,
41 p_sent_date_from IN varchar2,
42 p_sent_date_to IN varchar2,
43 p_received_date_from in date,
44 p_received_date_to in date,
45 p_from_str in varchar2,
46 p_recepients in varchar2,
47 p_cc_flag in varchar2,
48 p_subject in varchar2,
49 p_message_body in varchar2,
50 p_customer_id in number,
51 p_classification in varchar2,
52 p_resolved_agent in varchar2,
53 p_resolved_group in varchar2,
54 x_message_tbl out nocopy message_rec_tbl,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 END IEM_SEARCHMESSAGE_PVT;