1 PACKAGE IEM_RT_PROC_EMAILS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemrprcs.pls 120.0 2005/06/02 14:18:52 appldev noship $*/
3 -- Start of Comments
4 -- API name : create_item
5 -- Type : Private
6 -- Function : This procedure create a record in the table iem_rt_proc_emails
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN
10 -- p_api_version_number IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2
12 -- p_commit IN VARCHAR2
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 PROCEDURE create_item (p_api_version_number IN NUMBER,
26 p_init_msg_list IN VARCHAR2 ,
27 p_commit IN VARCHAR2 ,
28 p_message_id IN NUMBER,
29 p_email_account_id IN NUMBER,
30 p_priority IN NUMBER ,
31 p_agent_id IN NUMBER,
32 p_group_id IN NUMBER,
33 p_sent_date IN varchar2,
34 p_received_date in date,
35 p_rt_classification_id in number,
36 p_customer_id in number,
37 p_contact_id in number,
38 p_relationship_id in number,
39 p_interaction_id in number,
40 p_ih_media_item_id in number,
41 p_msg_status in varchar2,
42 p_mail_proc_status in varchar2,
43 p_mail_item_status in varchar2,
44 p_category_map_id in number,
45 p_rule_id in number,
46 p_subject in varchar2,
47 p_sender_address in varchar2,
48 p_from_agent_id in number,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 -- Start of Comments
55 -- API name : delete_item
56 -- Type : Private
57 -- Function : This procedure delete a record in the table iem_rt_proc_emails
58 -- Pre-reqs : None.
59 -- Parameters :
60 -- IN
61 -- p_api_version_number IN NUMBER Required
62 -- p_init_msg_list IN VARCHAR2
63 -- p_commit IN VARCHAR2
64 -- p_message_id in number,
65
66 -- OUT
67 -- x_return_status OUT VARCHAR2
68 -- x_msg_count OUT NUMBER
69 -- x_msg_data OUT VARCHAR2
70 --
71 -- Version : 1.0
72 -- Notes :
73 --
74 -- End of comments
75 -- **********************************************************
76
77 PROCEDURE delete_item (p_api_version_number IN NUMBER,
78 p_init_msg_list IN VARCHAR2 ,
79 p_commit IN VARCHAR2 ,
80 p_message_id in number,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86 END IEM_RT_PROC_EMAILS_PVT;