1 PACKAGE iem_temp_stores_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvmigs.pls 120.0 2005/06/02 14:04:12 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_temp_stores
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_folder_name in varchar2,
37 p_from_str in varchar2,
38 p_rfc822 in varchar2,
39 p_reply_to in varchar2,
40 p_to in varchar2,
41 p_cc in varchar2,
42 p_bcc in varchar2,
43 p_sent_date in varchar2,
44 p_subject IN varchar2,
45 p_message_size IN number,
46 p_mig_status IN varchar2,
47 p_mig_error_text IN DATE,
48 p_message_text in varchar2,
49 p_message_content in BLOB,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2
53 );
54
55 -- Start of Comments
56 -- API name : delete_item
57 -- Type : Private
58 -- Function : This procedure delete a record in the table iem_temp_stores
59 -- Pre-reqs : None.
60 -- Parameters :
61 -- IN
62 -- p_api_version_number IN NUMBER Required
63 -- p_init_msg_list IN VARCHAR2
64 -- p_commit IN VARCHAR2
65 -- p_message_id in number,
66
67 -- OUT
68 -- x_return_status OUT VARCHAR2
69 -- x_msg_count OUT NUMBER
70 -- x_msg_data OUT VARCHAR2
71 --
72 -- Version : 1.0
73 -- Notes :
74 --
75 -- End of comments
76 -- **********************************************************
77
78 PROCEDURE delete_item (p_api_version_number IN NUMBER,
79 p_init_msg_list IN VARCHAR2 ,
80 p_commit IN VARCHAR2 ,
81 p_message_id in number,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 END iem_temp_stores_PVT;