1 PACKAGE IEM_ARCH_PVT AUTHID CURRENT_USER as
2 /* $Header: iemarcps.pls 120.2 2005/10/11 13:31:15 rtripath ship $ */
3 -- Start of Comments
4 -- API name : submit_request
5 -- Type : Private
6 -- Function : This procedure allows to submit a request for archiving
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_folder IN VARCHAR2,
14 -- p_email_account_id in number,
15 -- p_search_criteria in varchar2,
16
17 -- OUT
18 -- x_return_status OUT VARCHAR2
19 -- x_msg_count OUT NUMBER
20 -- x_msg_data OUT VARCHAR2
21 --
22 -- Version : 1.0
23 -- Notes :
24 --
25 -- End of comments
26 -- **********************************************************
27
28 PROCEDURE submit_request(p_api_version_number IN NUMBER,
29 p_init_msg_list IN VARCHAR2 ,
30 p_commit IN VARCHAR2 ,
31 p_message_id IN jtf_varchar2_Table_100,
32 p_folder IN VARCHAR2,
33 p_email_account_id in number,
34 p_search_criteria in varchar2,
35 p_request_type in varchar2,
36 x_request_id OUT NOCOPY NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2
40 );
41
42 -- Start of Comments
43 -- API name : process_request
44 -- Type : Private
45 -- Function : This procedure starts the archiving process
46 -- Pre-reqs : None.
47 -- Parameters :
48 -- IN
49 -- p_api_version_number IN NUMBER Required
50 -- p_init_msg_list IN VARCHAR2
51 -- p_commit IN VARCHAR2
52 -- p_request_id in number,
53
54 -- OUT
55 -- x_return_status OUT VARCHAR2
56 -- x_msg_count OUT NUMBER
57 -- x_msg_data OUT VARCHAR2
58 --
59 -- Version : 1.0
60 -- Notes :
61 --
62 -- End of comments
63 -- **********************************************************
64 PROCEDURE process_request(p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2 ,
66 p_commit IN VARCHAR2 ,
67 p_request_id IN NUMBER,
68 p_request_type in varchar2,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 -- Start of Comments
75 -- API name : cancel_request
76 -- Type : Private
77 -- Function : This procedure delete a archiving request
78 -- Pre-reqs : None.
79 -- Parameters :
80 -- IN
81 -- p_api_version_number IN NUMBER Required
82 -- p_init_msg_list IN VARCHAR2
83 -- p_commit IN VARCHAR2
84 -- p_request_id in number,
85
86 -- OUT
87 -- x_return_status OUT VARCHAR2
88 -- x_msg_count OUT NUMBER
89 -- x_msg_data OUT VARCHAR2
90 --
91 -- Version : 1.0
92 -- Notes :
93 --
94 -- End of comments
95 -- **********************************************************
96 PROCEDURE cancel_request(p_api_version_number IN NUMBER,
97 p_init_msg_list IN VARCHAR2 ,
98 p_commit IN VARCHAR2 ,
99 p_request_id IN NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE get_folder_dtl(
106 p_email_account_id IN NUMBER,
107 p_folder IN VARCHAR2,
108 p_date IN varchar2,
109 p_date_format in varchar2,
110 x_count OUT NOCOPY NUMBER,
111 x_msg_table OUT NOCOPY jtf_number_table,
112 x_arch_date OUT NOCOPY VARCHAR2,
113 x_action_flg OUT NOCOPY VARCHAR2, --Y/N
114 x_action_desc OUT NOCOPY VARCHAR2, --Y/N
115 x_ret_status OUT NOCOPY VARCHAR2,
116 x_out_text OUT NOCOPY VARCHAR2);
117
118 PROCEDURE PROC_REQUESTS(ERRBUF OUT NOCOPY VARCHAR2,
119 ERRRET OUT NOCOPY VARCHAR2,
120 p_api_version_number in number:= 1.0);
121 PROCEDURE CREATE_MLCS(p_request_id in number,
122 p_milcs_type in number,
123 x_ret_status OUT NOCOPY VARCHAR2,
124 x_out_text OUT NOCOPY VARCHAR2);
125
126 END IEM_ARCH_PVT;