1 PACKAGE IEM_DPM_PP_QUEUE_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvdpms.pls 120.0 2005/09/06 11:23:41 liangxia noship $ */
3 --
4 -- file name: iemvques.pls
5 --
6 -- Purpose: EMTA runtime queue management
7 --
8 -- MODIFICATION HISTORY
9 -- Person Date Comments
10 -- Liang Xia 8/01/2005 Created
11 -- --------- ------ ------------------------------------------
12
13 TYPE folder_worklist_rec is RECORD (
14 migration_id number,
15 email_acct_id number,
16 folder_type varchar2(1),
17 folder_name varchar2(30), --STATIC or DYNAMIC
18 user_name varchar2(256),
19 password varchar2(256),
20 server_name varchar2(30),
21 port number
22 );
23
24 --Table of emailProc_rec
25 TYPE folder_worklist_tbl is TABLE OF folder_worklist_rec INDEX BY BINARY_INTEGER;
26
27 -- Start of Comments
28 -- API name : get_folder_work_list
29 -- Type : Private
30 -- Function : This procedure get folder work list from iem_migration_details
31 -- Pre-reqs : None.
32 -- Parameters :
33 Procedure get_folder_work_list(
34 p_api_version_number IN NUMBER,
35 p_init_msg_list IN VARCHAR2 := null,
36 p_commit IN VARCHAR2 := null,
37 x_folder_work_list OUT NOCOPY folder_worklist_tbl,
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 : get_msg_work_list
45 -- Type : Private
46 -- Function : This procedure get message work list from iem_migration_temp_store
47 -- for the give migration id
48 -- Pre-reqs : None.
49 -- Parameters :
50 Procedure get_msg_work_list(
51 p_api_version_number IN NUMBER,
52 p_init_msg_list IN VARCHAR2 := null,
53 p_commit IN VARCHAR2 := null,
54 p_batch IN NUMBER,
55 p_migration_id IN NUMBER,
56 x_mail_ids OUT NOCOPY JTF_NUMBER_TABLE,
57 x_message_ids OUT NOCOPY JTF_NUMBER_TABLE,
58 x_msg_uids OUT NOCOPY JTF_NUMBER_TABLE,
59 x_subjects OUT NOCOPY jtf_varchar2_Table_2000,
60 x_rfc_msgids OUT NOCOPY jtf_varchar2_Table_300,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2
64 ) ;
65
66 -- Start of Comments
67 -- API name : log_batch_error
68 -- Type : Private
69 -- Function : This procedure get message work list from iem_migration_temp_store
70 -- for the give migration id
71 -- Pre-reqs : None.
72 -- Parameters :
73 Procedure log_batch_error(
74 p_api_version_number IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := null,
76 p_commit IN VARCHAR2 := null,
77 p_migration_id IN NUMBER,
78 p_mail_ids IN JTF_NUMBER_TABLE,
79 p_error IN VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2
83 ) ;
84
85 END IEM_DPM_PP_QUEUE_PVT ;