1 PACKAGE iem_rt_preproc_emails_PVT as
2 /* $Header: iempreps.pls 120.0 2005/06/02 13:56:36 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_preproc_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 -- p_db_link IN VARCHAR2,
14 -- p_db_username IN VARCHAR2,
15 -- p_db_password IN VARCHAR2,
16 -- p_db_server_id IN NUMBER,
17 -- p_is_admin IN VARCHAR2,
18 -- p_conn_desc IN VARCHAR2,
19 --
20 -- OUT
21 -- x_return_status OUT VARCHAR2
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2
24 --
25 -- Version : 1.0
26 -- Notes :
27 --
28 -- End of comments
29 -- **********************************************************
30
31 PROCEDURE create_item (p_api_version_number IN NUMBER,
32 p_init_msg_list IN VARCHAR2 ,
33 p_commit IN VARCHAR2 ,
34 p_message_id IN NUMBER,
35 p_email_account_id IN NUMBER,
36 p_priority IN number,
37 p_received_date IN DATE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 -- Start of Comments
44 -- API name : delete_item
45 -- Type : Private
46 -- Function : This procedure delete a record in the table iem_rt_preproc_emails
47 -- Pre-reqs : None.
48 -- Parameters :
49 -- IN
50 -- p_api_version_number IN NUMBER Required
51 -- p_init_msg_list IN VARCHAR2
52 -- p_commit IN VARCHAR2
53 -- p_message_id in number,
54
55 -- OUT
56 -- x_return_status OUT VARCHAR2
57 -- x_msg_count OUT NUMBER
58 -- x_msg_data OUT VARCHAR2
59 --
60 -- Version : 1.0
61 -- Notes :
62 --
63 -- End of comments
64 -- **********************************************************
65
66 PROCEDURE delete_item (p_api_version_number IN NUMBER,
67 p_init_msg_list IN VARCHAR2 ,
68 p_commit IN VARCHAR2 ,
69 p_message_id in number,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 END iem_rt_preproc_emails_PVT;