1 PACKAGE IEM_EMTA_ADMIN_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvemts.pls 120.2 2005/07/13 18:01:40 appldev noship $ */
3 --
4 --
5 -- Purpose:
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- Liang Xia 10/05/2004 Created
10 -- --------- ------ ------------------------------------------
11 TYPE acct_info_rec is RECORD (
12 account_id number,
13 action varchar2(10),
14 update_flag varchar2(1),
15 user_name varchar2(100),
16 user_password varchar2(100),
17 in_host varchar2(256),
18 in_port number
19 );
20
21 TYPE acct_info_tbl is TABLE OF acct_info_rec INDEX BY BINARY_INTEGER;
22
23 -- Start of Comments
24 -- API name : IS_DLPS_RUNNING
25 -- Type : Private
26 -- Function : This procedure is used to check if Download Processor running for the given Account.
27 -- Pre-reqs : None.
28 -- Parameters :
29 PROCEDURE IS_DLPS_RUNNING (
30 p_api_version_number IN NUMBER,
31 p_init_msg_list IN VARCHAR2 := null,
32 p_commit IN VARCHAR2 := null,
33 p_email_acct_id IN NUMBER,
34 x_running_status OUT NOCOPY VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2 );
38
39
40 -- Start of Comments
41 -- API name : UPDATE_DP_CONFIG_DATA
42 -- Type : Private
43 -- Function : This procedure is to insert data into IEM_EMTA_CONFIG_PARAMS so that email account update could be uptake by
44 -- Download Processor.
45 -- Pre-reqs : None.
46 -- Parameters :
47 PROCEDURE UPDATE_DP_CONFIG_DATA(
48 p_api_version_number IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := null,
50 p_commit IN VARCHAR2 := null,
51 p_email_acct_id IN NUMBER,
52 p_active_flag IN VARCHAR2,
53 p_is_acct_update IN VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2 );
57
58 -- Start of Comments
59 -- API name : UGET_ACCOUNT_INFO
60 -- Type : Private
61 -- Function : This procedure is retrieve email account information to be updated
62 -- Download Processor.
63 -- Pre-reqs : None.
64 -- Parameters :
65 PROCEDURE GET_ACCOUNT_INFO(
66 p_api_version_number IN NUMBER,
67 p_init_msg_list IN VARCHAR2 := null,
68 p_commit IN VARCHAR2 := null,
69 x_acct_info OUT NOCOPY acct_info_tbl,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75
76 -- Start of Comments
77 -- API name : UDELETE_ITEMS
78 -- Type : Private
79 -- Function : This procedure is delete items that has been used.
80 -- Download Processor.
81 -- Pre-reqs : None.
82 -- Parameters :
83 PROCEDURE DELETE_ITEMS(
84 p_api_version_number IN NUMBER,
85 p_init_msg_list IN VARCHAR2 := null,
86 p_commit IN VARCHAR2 := null,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2
90 );
91
92 -- Start of Comments
93 -- API name : UPDATE_DP_CONFIG_DATA_WRAP
94 -- Type : Private
95 -- Function : This procedure is called by Email account GUI to insert data into IEM_EMTA_CONFIG_PARAMS when Email account is
96 -- created, updated or deleted.
97 -- Pre-reqs : None.
98 -- Parameters :
99 PROCEDURE UPDATE_DP_CONFIG_DATA_WRAP(
100 p_api_version_number IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := null,
102 p_commit IN VARCHAR2 := null,
103 p_email_acct_id IN NUMBER ,
104 p_action IN VARCHAR2,
105 P_ACTIVE_FLAG IN varchar2 := null,
106 P_USER_NAME IN varchar2 := null,
107 P_USER_PASSWORD IN varchar2 := null,
108 P_IN_HOST IN varchar2 := null,
109 P_IN_PORT IN varchar2 := null,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2 );
113 -- Start of Comments
114 -- API name : is_data_changed
115 -- Type : Private
116 -- Function : This procedure is internally used to check if any inbound server related account info changed
117 -- Pre-reqs : None.
118 -- Parameters :
119 /*
120 FUNCTION is_data_changed ( p_email_account_id IN number,
121 P_ACTIVE_FLAG IN varchar2,
122 P_USER_NAME IN varchar2,
123 P_USER_PASSWORD IN varchar2,
124 P_IN_HOST IN varchar2,
125 P_IN_PORT IN varchar2,
126 x_is_acct_updated OUT varchar2 )
127 return boolean;*/
128 PROCEDURE CHECK_IF_ACCOUNT_UPDATED(
129 p_api_version_number IN NUMBER,
130 p_init_msg_list IN VARCHAR2 := null,
131 p_commit IN VARCHAR2 := null,
132 p_email_account_id IN number,
133 P_ACTIVE_FLAG IN varchar2,
134 P_USER_NAME IN varchar2,
135 P_USER_PASSWORD IN varchar2,
136 P_IN_HOST IN varchar2,
137 P_IN_PORT IN varchar2,
138 x_is_data_changed OUT NOCOPY varchar2,
139 x_is_acct_updated OUT NOCOPY varchar2,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2 );
143 end ;