[Home] [Help]
PACKAGE: APPS.IEM_EMAILPROC_HDL_PVT
Source
1 PACKAGE IEM_EMAILPROC_HDL_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvpros.pls 120.0.12010000.2 2009/07/11 16:49:40 lkullamb ship $ */
3
4
5
6 -- transfer display date format to canonical date format
7 -- ***************************************************************************
8
9 FUNCTION displayDT_to_canonical ( displayDT IN VARCHAR2 )return varchar2;
10
11
12 -- ************************************************************************
13 -- Start of Comments
14 -- API name : create_item_account_emailprocs
15 -- Type : Private
16 -- Function : This procedure create a tuple in iem_account_emailprocs table
17 -- Pre-reqs : None.
18 -- Parameters :
19 -- IN
20 -- p_api_version_number IN NUMBER Required
21 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
22 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
23 -- p_email_account_id IN VARCHAR2 Required
24 -- p_emailproc_id IN VARCHAR2 Required
25 -- p_enabled_flag IN VARCHAR2, Required
26 -- p_priority IN VARCHAR2, Required
27
28 -- OUT
29 -- x_return_status OUT VARCHAR2
30 -- x_msg_count OUT NUMBER
31 -- x_msg_data OUT VARCHAR2
32 --
33 -- Version : 1.0
34 -- Notes :
35 --
36 -- End of comments
37 -- **********************************************************
38 PROCEDURE create_item_account_emailprocs (
39 p_api_version_number IN NUMBER,
40 p_init_msg_list IN VARCHAR2 := null,
41 p_commit IN VARCHAR2 := null,
42 p_email_account_id IN NUMBER,
43 p_emailproc_id IN NUMBER,
44 p_enabled_flag IN VARCHAR2,
45 p_priority IN NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 -- ************************************************************************
52 -- Start of Comments
53 -- API name : update_item_emailproc
54 -- Type : Private
55 -- Function : This procedure update route in update_item_emailproc table
56 -- Pre-reqs : None.
57 -- Parameters :
58 -- IN
59 -- p_api_version_number IN NUMBER Required
60 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
61 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
62
63 -- p_route_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
64 -- p_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
65 -- p_description IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
66
67 -- p_ruling_chain IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
68 -- p_proc_name IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
69 -- this is procedure name for dynamic route ( 11.5.7)
70 -- OUT
71 -- x_return_status OUT VARCHAR2
72 -- x_msg_count OUT NUMBER
73 -- x_msg_data OUT VARCHAR2
74 --
75 -- Version : 1.0
76 -- Notes :
77
78 --
79 -- End of comments
80 -- **********************************************************
81 PROCEDURE update_item_emailproc (
82 p_api_version_number IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := null,
84 p_commit IN VARCHAR2 := null,
85 p_emailproc_id IN NUMBER,
86 p_name IN VARCHAR2:= null,
87 p_description IN VARCHAR2:= null,
88 p_ruling_chain IN VARCHAR2:= null,
89 p_all_email IN VARCHAR2:= null,
90 p_rule_type IN VARCHAR2:= null,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2
94 );
95
96
97
98
99 -- ************************************************************************
100 -- Start of Comments
101 -- API name : update_item_rule
102 -- Type : Private
103 -- Function : This procedure update route in iem_emailproc_rules table
104 -- Pre-reqs : None.
105
106 -- Parameters :
107 -- IN
108 -- p_api_version_number IN NUMBER Required
109 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
110 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111 -- p_key_type_code IN NUMBER Optional Default = FND_API.G_MISS_NUM
112 -- p_key_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
113 -- p_operator_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114 -- p_value IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
115 -- OUT
116 -- x_return_status OUT VARCHAR2
117 -- x_msg_count OUT NUMBER
118 -- x_msg_data OUT VARCHAR2
119 --
120 -- Version : 1.0
121 -- Notes :
122 --
123 -- End of comments
124 -- **********************************************************
125 PROCEDURE update_item_rule (p_api_version_number IN NUMBER,
126 p_init_msg_list IN VARCHAR2 := null,
127 p_commit IN VARCHAR2 := null,
128 p_emailproc_rule_id IN NUMBER,
129 p_key_type_code IN VARCHAR2:= null,
130 p_operator_type_code IN VARCHAR2:= null,
131 p_value IN VARCHAR2:= null,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 -- ************************************************************************
138 -- Start of Comments
139 -- API name : update_account_emailprocs
140 -- Type : Private
141
142 -- Function : This procedure update iem_account_emailprocs table
143 -- Pre-reqs : None.
144 -- Parameters :
145 -- IN
146 -- p_api_version_number IN NUMBER Required
147 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149 -- p_route_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
150 -- p_email_account_id IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
151 -- p_default_grp_id IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
152 -- p_enabled_flag IN VARCHAR2, Optional Default = FND_API.G_MISS_CHAR
153 -- p_priority IN NUMBER Optional Default = FND_API.G_MISS_NUM
154 -- OUT
155 -- x_return_status OUT VARCHAR2
156 -- x_msg_count OUT NUMBER
157 -- x_msg_data OUT VARCHAR2
158 --
159 -- Version : 1.0
160 -- Notes :
161 --
162 -- End of comments
163 -- **********************************************************
164
165 PROCEDURE update_account_emailprocs
166 (p_api_version_number IN NUMBER,
167 p_init_msg_list IN VARCHAR2 := null,
168 p_commit IN VARCHAR2 := null,
169 p_emailproc_id IN NUMBER,
170 p_email_account_id IN NUMBER,
171 p_enabled_flag IN VARCHAR2:= NULL,
172 p_priority IN VARCHAR2:= NULL,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2
176 );
177
178
179 -- ************************************************************************
180
181 -- Start of Comments
182 -- API name : create_item_emailprocs
183 -- Type : Private
184 -- Function : This procedure create a route in iem_emailprocs table
185 -- Pre-reqs : None.
186 -- Parameters :
187 -- IN
188 -- p_api_version_number IN NUMBER Required
189
190 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
191 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192 -- p_name IN VARCHAR2 Required
193 -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
194 -- p_boolean_type_code IN VARCHAR2, Required
195
196 -- OUT
197 -- x_return_status OUT VARCHAR2
198 -- x_msg_count OUT NUMBER
199 -- x_msg_data OUT VARCHAR2
200 --
201 -- Version : 1.0
202 -- Notes :
203
204 --
205 -- End of comments
206 -- **********************************************************
207
208 PROCEDURE create_item_emailprocs (
209 p_api_version_number IN NUMBER,
210 p_init_msg_list IN VARCHAR2 := null,
211 p_commit IN VARCHAR2 := null,
212 p_name IN VARCHAR2,
213 p_description IN VARCHAR2:= null,
214 p_boolean_type_code IN VARCHAR2,
215 P_rule_type IN VARCHAR2,
216 p_all_email IN VARCHAR2,
217 x_emailproc_id OUT NOCOPY NUMBER,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2
221 );
222
223 -- ************************************************************************
224 -- Start of Comments
225 -- API name : create_item_emailproc_rules
226 -- Type : Private
227 -- Function : This procedure create a route in iem_emailproc_rules table
228 -- Pre-reqs : None.
229 -- Parameters :
230
231 -- IN
232 -- p_api_version_number IN NUMBER Required
233 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
234 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
235 -- p_route_id IN VARCHAR2 Required
236 -- p_key_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
237 -- p_operator_type_code IN VARCHAR2, Required
238 -- p_value IN VARCHAR2, Required
239
240 -- OUT
241 -- x_return_status OUT VARCHAR2
242 -- x_msg_count OUT NUMBER
243 -- x_msg_data OUT VARCHAR2
244 --
245 -- Version : 1.0
246
247 -- Notes :
248 --
249 -- End of comments
250 -- *********************************************************************************************
251 PROCEDURE create_item_emailproc_rules (
252 p_api_version_number IN NUMBER,
253 p_init_msg_list IN VARCHAR2 := null,
254 p_commit IN VARCHAR2 := null,
255 p_emailproc_id IN NUMBER,
256 p_key_type_code IN VARCHAR2,
257 p_operator_type_code IN VARCHAR2,
258 p_value IN VARCHAR2,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2
262 );
263
264 PROCEDURE create_item_actions (
265 p_api_version_number IN NUMBER,
266 p_init_msg_list IN VARCHAR2 := null,
267 p_commit IN VARCHAR2 := null,
268 p_emailproc_id IN NUMBER,
269 p_action_name IN VARCHAR2,
270 x_action_id OUT NOCOPY NUMBER,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2
274 );
275
276 PROCEDURE create_item_action_dtls (
277 p_api_version_number IN NUMBER,
278 p_init_msg_list IN VARCHAR2 := null,
279 p_commit IN VARCHAR2 := null,
280 p_action_id IN NUMBER,
281 p_param1 IN VARCHAR2,
282 p_param2 IN VARCHAR2,
283 p_param3 IN VARCHAR2,
284 p_param_tag IN VARCHAR2,
285 x_return_status OUT NOCOPY VARCHAR2,
286 x_msg_count OUT NOCOPY NUMBER,
287 x_msg_data OUT NOCOPY VARCHAR2
288 );
289
290 PROCEDURE delete_acct_emailproc_batch
291 (p_api_version_number IN NUMBER,
292 P_init_msg_list IN VARCHAR2 := null,
293 p_commit IN VARCHAR2 := null,
294 p_emailproc_ids_tbl IN jtf_varchar2_Table_100,
295 p_account_id IN NUMBER,
296 p_rule_type IN VARCHAR2,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2);
300
301 END IEM_EMAILPROC_HDL_PVT;