1 PACKAGE AMS_Ct_Rule_PVT AS
2 /* $Header: amsvctrs.pls 120.2 2006/05/30 11:09:54 prageorg noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Ct_Rule_PVT
7 --
8 -- Purpose
9 -- Private api created to Update/insert/Delete general
10 -- and object-specific content rules
11 --
12 -- History
13 -- 21-mar-2002 jieli Created.
14 -- 21-aug-2002 soagrawa Fixed bug# 2524840, regd default value of p_profile_id
15 -- 29-May-2006 prageorg Added delivery_mode column. Bug 4920064
16 --
17 -- NOTE
18 --
19 -- End of Comments
20 -- ===============================================================
21
22
23 -- Default number of records fetch per call
24 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
25 --===================================================================
26 -- Start of Comments
27 -- -------------------------------------------------------
28 -- Record name
29 -- ct_rule_rec_type
30 -- -------------------------------------------------------
31 -- Parameters:
32 -- content_rule_id
33 -- created_by
34 -- creation_date
35 -- last_updated_by
36 -- last_updated_date
37 -- last_update_login
38 -- object_version_number
39 -- object_type
40 -- object_id
41 -- sender
42 -- reply_to
43 -- cover_letter_id
44 -- table_of_content_flag
45 -- trigger_code
46 -- enabled_flag
47 -- delivery_mode
48 --
49 -- Required
50 --
51 -- Defaults
52 --
53 -- Note: This is automatic generated record definition, it includes all columns
54 -- defined in the table, developer must manually add or delete some of the attributes.
55 --
56 -- End of Comments
57
58 --===================================================================
59 TYPE ct_rule_rec_type IS RECORD
60 (
61 content_rule_id NUMBER := FND_API.G_MISS_NUM,
62 created_by NUMBER := FND_API.G_MISS_NUM,
63 creation_date DATE := FND_API.G_MISS_DATE,
64 last_updated_by NUMBER := FND_API.G_MISS_NUM,
65 last_updated_date DATE := FND_API.G_MISS_DATE,
66 last_update_login NUMBER := FND_API.G_MISS_NUM,
67 object_version_number NUMBER := FND_API.G_MISS_NUM,
68 object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69 object_id NUMBER := FND_API.G_MISS_NUM,
70 sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71 reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72 cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73 table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74 trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75 enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76 subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
77 sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,--anchaudh
78 delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR --prageorg
79 );
80
81 g_miss_ct_rule_rec ct_rule_rec_type;
82 TYPE ct_rule_tbl_type IS TABLE OF ct_rule_rec_type INDEX BY BINARY_INTEGER;
83 g_miss_ct_rule_tbl ct_rule_tbl_type;
84
85 -- ==============================================================================
86 -- Start of Comments
87 -- ==============================================================================
88 -- API Name
89 -- Create_Ct_Rule
90 -- Type
91 -- Private
92 -- Pre-Req
93 --
94 -- Parameters
95 --
96 -- IN
97 -- p_api_version_number IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101 -- p_ct_rule_rec IN ct_rule_rec_type Required
102 --
103 -- OUT
104 -- x_return_status OUT VARCHAR2
105 -- x_msg_count OUT NUMBER
106 -- x_msg_data OUT VARCHAR2
107 -- Version : Current version 1.0
108 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
109 -- and basic operation, developer must manually add parameters and business logic as necessary.
110 --
111 -- End of Comments
112 -- ==============================================================================
113 --
114
115 PROCEDURE Create_Ct_Rule(
116 p_api_version_number IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124
125 p_ct_rule_rec IN ct_rule_rec_type := g_miss_ct_rule_rec,
126 x_content_rule_id OUT NOCOPY NUMBER
127 );
128
129 -- ==============================================================================
130 -- Start of Comments
131 -- ==============================================================================
132 -- API Name
133 -- Update_Ct_Rule
134 -- Type
135 -- Private
136 -- Pre-Req
137 --
138 -- Parameters
139 --
140 -- IN
141 -- p_api_version_number IN NUMBER Required
142 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145 -- p_ct_rule_rec IN ct_rule_rec_type Required
146 --
147 -- OUT
148 -- x_return_status OUT VARCHAR2
149 -- x_msg_count OUT NUMBER
150 -- x_msg_data OUT VARCHAR2
151 -- Version : Current version 1.0
152 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
153 -- and basic operation, developer must manually add parameters and business logic as necessary.
154 --
155 -- End of Comments
156 -- ==============================================================================
157 --
158
159 PROCEDURE Update_Ct_Rule(
160 p_api_version_number IN NUMBER,
161 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162 p_commit IN VARCHAR2 := FND_API.G_FALSE,
163 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168
169 p_ct_rule_rec IN ct_rule_rec_type,
170 x_object_version_number OUT NOCOPY NUMBER
171 );
172
173 -- ==============================================================================
174 -- Start of Comments
175 -- ==============================================================================
176 -- API Name
177 -- Delete_Ct_Rule
178 -- Type
179 -- Private
180 -- Pre-Req
181 --
182 -- Parameters
183 --
184 -- IN
185 -- p_api_version_number IN NUMBER Required
186 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189 -- p_CONTENT_RULE_ID IN NUMBER
190 -- p_object_version_number IN NUMBER Optional Default = NULL
191 --
192 -- OUT
193 -- x_return_status OUT VARCHAR2
194 -- x_msg_count OUT NUMBER
195 -- x_msg_data OUT VARCHAR2
196 -- Version : Current version 1.0
197 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
198 -- and basic operation, developer must manually add parameters and business logic as necessary.
199 --
200 -- End of Comments
201 -- ==============================================================================
202 --
203
204 PROCEDURE Delete_Ct_Rule(
205 p_api_version_number IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207 p_commit IN VARCHAR2 := FND_API.G_FALSE,
208 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_content_rule_id IN NUMBER,
213 p_object_version_number IN NUMBER
214 );
215
216 -- ==============================================================================
217 -- Start of Comments
218 -- ==============================================================================
219 -- API Name
220 -- Lock_Ct_Rule
221 -- Type
222 -- Private
223 -- Pre-Req
224 --
225 -- Parameters
226 --
227 -- IN
228 -- p_api_version_number IN NUMBER Required
229 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232 -- p_ct_rule_rec IN ct_rule_rec_type Required
233 --
234 -- OUT
235 -- x_return_status OUT VARCHAR2
236 -- x_msg_count OUT NUMBER
237 -- x_msg_data OUT VARCHAR2
238 -- Version : Current version 1.0
239 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
240 -- and basic operation, developer must manually add parameters and business logic as necessary.
241 --
242 -- End of Comments
243 -- ==============================================================================
244 --
245
246 PROCEDURE Lock_Ct_Rule(
247 p_api_version_number IN NUMBER,
248 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253
254 p_content_rule_id IN NUMBER,
255 p_object_version IN NUMBER
256 );
257
258
259 -- Start of Comments
260 --
261 -- validation procedures
262 --
263 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
264 -- For create: G_CREATE, for update: G_UPDATE
265 -- Note: 1. This is automated generated item level validation procedure.
266 -- The actual validation detail is needed to be added.
267 -- 2. We can also validate table instead of record. There will be an option for user to choose.
268 -- End of Comments
269
270 PROCEDURE Validate_ct_rule(
271 p_api_version_number IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274 p_ct_rule_rec IN ct_rule_rec_type,
275 p_validation_mode IN VARCHAR2,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2
279 );
280
281 -- Start of Comments
282 --
283 -- validation procedures
284 --
285 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
286 -- For create: G_CREATE, for update: G_UPDATE
287 -- Note: 1. This is automated generated item level validation procedure.
288 -- The actual validation detail is needed to be added.
289 -- 2. Validate the unique keys, lookups here
290 -- End of Comments
291
292 PROCEDURE Check_ct_rule_Items (
293 P_ct_rule_rec IN ct_rule_rec_type,
294 p_validation_mode IN VARCHAR2,
295 x_return_status OUT NOCOPY VARCHAR2
296 );
297
298 -- Start of Comments
299 --
300 -- Record level validation procedures
301 --
302 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
303 -- For create: G_CREATE, for update: G_UPDATE
304 -- Note: 1. This is automated generated item level validation procedure.
305 -- The actual validation detail is needed to be added.
306 -- 2. Developer can manually added inter-field level validation.
307 -- End of Comments
308
309 PROCEDURE Validate_ct_rule_rec(
310 p_api_version_number IN NUMBER,
311 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2,
315 p_ct_rule_rec IN ct_rule_rec_type
316 );
317
318 --===================================================================
319 -- NAME
320 -- xyz
321 --
322 -- PURPOSE
323 -- sees if there are any content rules for given object
324 -- and submits a request to Fulfillment
325 --
326 -- NOTES
327 --
328 -- HISTORY
329 -- 10-APR-2001 SOAGRAWA Created
330 --===================================================================
331
332 PROCEDURE check_content_rule(
333 p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
335 p_commit IN VARCHAR2 := FND_API.g_false,
336 p_object_type IN VARCHAR2,
337 p_object_id IN NUMBER,
338 p_trigger_type IN VARCHAR2,
339 p_requestor_type IN VARCHAR2 := NULL,
340 p_requestor_id IN NUMBER,
341 p_server_group IN NUMBER := NULL,
342 p_scheduled_date IN DATE := SYSDATE,
343 p_media_types IN VARCHAR2 := 'E',
344 p_archive IN VARCHAR2 := 'N',
345 p_log_user_ih IN VARCHAR2 := 'Y', --anchaudh: fixed to be able to log interactions for fulfillment rules related to Events.
346 p_request_type IN VARCHAR2 := 'E',
347 p_language_code IN VARCHAR2 := NULL,
348 p_profile_id IN NUMBER := NULL,
349 p_order_id IN NUMBER := NULL,
350 p_collateral_id IN NUMBER := NULL,
351 p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE,
352 p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
353 p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
354 p_bind_names IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
355 p_bind_values IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
356 x_return_status OUT NOCOPY VARCHAR2,
357 x_msg_count OUT NOCOPY NUMBER,
358 x_msg_data OUT NOCOPY VARCHAR2,
359 x_request_history_id OUT NOCOPY NUMBER
360 );
361
362 END AMS_Ct_Rule_PVT;