1 PACKAGE aml_MONITOR_CONDITIONS_PVT AUTHID CURRENT_USER as
2 /* $Header: amlvlmcs.pls 115.1 2002/12/06 04:53:24 ajchatto noship $ */
3 -- Start of Comments
4 -- Package name : aml_MONITOR_CONDITIONS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12
13 -- *******************************************************
14 -- Start of Comments
15 -- *******************************************************
16 -- API Name: Create_monitor_condition
17 -- Type : Private
18 -- Pre-Req :
19 -- Parameters:
20 -- IN
21 -- p_api_version_number IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
26 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
27 -- p_admin_group_id IN NUMBER Required
28 -- P_CONDITION_Rec IN AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type Required
29 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
30 --
31 -- OUT:
32 -- x_return_status OUT NOCOPY VARCHAR2
33 -- x_msg_count OUT NOCOPY NUMBER
34 -- x_msg_data OUT NOCOPY VARCHAR2
35 -- Version : Current version 2.0
36 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
37 -- and basic operation, developer must manually add parameters and business logic as necessary.
38 --
39 -- End of Comments
40 --
41 PROCEDURE Create_monitor_condition(
42 P_Api_Version_Number IN NUMBER,
43 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 P_Identity_Resource_Id IN NUMBER,
47 P_CONDITION_Rec IN AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type,
48 X_MONITOR_CONDITION_ID OUT NOCOPY NUMBER,
49 X_Return_Status OUT NOCOPY VARCHAR2,
50 X_Msg_Count OUT NOCOPY NUMBER,
51 X_Msg_Data OUT NOCOPY VARCHAR2
52 );
53
54 -- *******************************************************
55 -- Start of Comments
56 -- *******************************************************
57 -- API Name: Update_monitor_condition
58 -- Type : Private
59 -- Pre-Req :
60 -- Parameters:
61 -- IN
62 -- p_api_version_number IN NUMBER Required
63 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
64 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
65 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
66 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
67 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
68 -- p_admin_group_id IN NUMBER Required
69 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
70 -- P_CONDITION_Rec IN AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type Required
71 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
72 --
73 -- OUT:
74 -- x_return_status OUT NOCOPY VARCHAR2
75 -- x_msg_count OUT NOCOPY NUMBER
76 -- x_msg_data OUT NOCOPY VARCHAR2
77 -- Version : Current version 2.0
78 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
79 -- and basic operation, developer must manually add parameters and business logic as necessary.
80 --
81 -- End of Comments
82 --
83 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
84 PROCEDURE Update_monitor_condition(
85 P_Api_Version_Number IN NUMBER,
86 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89 p_identity_salesforce_id IN NUMBER,
90 P_CONDITION_Rec IN AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type,
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 -- Start of Comments
98 -- *******************************************************
99 -- API Name: Delete_monitor_condition
100 -- Type : Private
101 -- Pre-Req :
102 -- Parameters:
103 -- IN
104 -- p_api_version_number IN NUMBER Required
105 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
109 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
110 -- p_admin_group_id IN NUMBER Required
111 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112 -- P_CONDITION_Rec IN AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type Required
113 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
114 --
115 -- OUT:
116 -- x_return_status OUT NOCOPY VARCHAR2
117 -- x_msg_count OUT NOCOPY NUMBER
118 -- x_msg_data OUT NOCOPY VARCHAR2
119 -- Version : Current version 2.0
120 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
121 -- and basic operation, developer must manually add parameters and business logic as necessary.
122 --
123 -- End of Comments
124 --
125 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
126 -- The Master delete procedure may not be needed depends on different business requirements.
127 PROCEDURE Delete_monitor_condition(
128 P_Api_Version_Number IN NUMBER,
129 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132 p_identity_salesforce_id IN NUMBER,
133 P_CONDITION_Rec IN AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type,
134 X_Return_Status OUT NOCOPY VARCHAR2,
135 X_Msg_Count OUT NOCOPY NUMBER,
136 X_Msg_Data OUT NOCOPY VARCHAR2
137 );
138
139 PROCEDURE Validate_MONITOR_CONDITION_ID (
140 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141 P_Validation_mode IN VARCHAR2,
142 P_MONITOR_CONDITION_ID IN NUMBER,
143 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
144 X_Return_Status OUT NOCOPY VARCHAR2,
145 X_Msg_Count OUT NOCOPY NUMBER,
146 X_Msg_Data OUT NOCOPY VARCHAR2
147 );
148
149 -- *******************************************************
150 -- Start of Comments
151 -- *******************************************************
152 -- API Name: Get_monitor_condition
153 -- Type : Private
154 -- Pre-Req :
155 -- Parameters:
156 -- IN
157 -- p_api_version_number IN NUMBER Required
158 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
161 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
162 -- p_admin_group_id IN NUMBER Required
163 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
164 -- P_CONDITION_Rec IN CONDITION_Rec_Type Required
165 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
166 -- Hint: Add List of bind variables here
167 -- p_rec_requested IN NUMBER Optional Default = 30
168 -- p_start_rec_ptr IN NUMBER Optional Default = 1
169 --
170 -- Return Total Records Count Flag. This flag controls whether the total record count
171 -- and total record amount is returned.
172 --
173 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
174 -- Hint: User defined record type
175 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
176 --
177 -- OUT:
178 -- x_return_status OUT VARCHAR2
179 -- x_msg_count OUT NUMBER
180 -- x_msg_data OUT VARCHAR2
181 -- X_CONDITION_Tbl OUT CONDITION_Rec_Type
182 -- x_returned_rec_count OUT NUMBER
183 -- x_next_rec_ptr OUT NUMBER
184 -- x_tot_rec_count OUT NUMBER
185 -- other optional out parameters
186 -- x_tot_rec_amount OUT NUMBER
187 -- Version : Current version 2.0
188 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
189 -- and basic operation, developer must manually add parameters and business logic as necessary.
190 --
191 -- End of Comments
192 --
193 /*
194 PROCEDURE Get_monitor_condition(
195 P_Api_Version_Number IN NUMBER,
196 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198 P_Admin_Group_id IN NUMBER,
199 P_identity_salesforce_id IN NUMBER := NULL,
200 P_CONDITION_Rec IN aml_monitor_condition_PUB.CONDITION_Rec_Type,
201 -- Hint: Add list of bind variables here
202 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
203 p_start_rec_prt IN NUMBER := 1,
204 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
205 -- Hint: user defined record type
206 p_order_by_rec IN aml_monitor_condition_PUB.CONDITION_sort_rec_type,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 X_CONDITION_Tbl OUT aml_monitor_condition_PUB.CONDITION_Tbl_Type,
211 x_returned_rec_count OUT NOCOPY NUMBER,
212 x_next_rec_ptr OUT NOCOPY NUMBER,
213 x_tot_rec_count OUT NOCOPY NUMBER
214 -- other optional parameters
215 -- x_tot_rec_amount OUT NOCOPY NUMBER
216 );
217
218
219 -- Start of Comments
220 --
221 -- Item level validation procedures
222 --
223 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
224 -- For create: G_CREATE, for update: G_UPDATE
225 -- Note: 1. This is automated generated item level validation procedure.
226 -- The actual validation detail is needed to be added.
227 --
228 -- End of Comments
229
230 PROCEDURE Validate_MONITOR_CONDITION_ID (
231 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
232 P_Validation_mode IN VARCHAR2,
233 P_MONITOR_CONDITION_ID IN NUMBER,
234 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
235 X_Return_Status OUT NOCOPY VARCHAR2,
236 X_Msg_Count OUT NOCOPY NUMBER,
237 X_Msg_Data OUT NOCOPY VARCHAR2
238 );
239
240 -- Start of Comments
241 --
242 -- Item level validation procedures
243 --
244 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
245 -- For create: G_CREATE, for update: G_UPDATE
246 -- Note: 1. This is automated generated item level validation procedure.
247 -- The actual validation detail is needed to be added.
248 --
249 -- End of Comments
250
251 PROCEDURE Validate_OBJECT_VERSION_NUMBER (
252 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
253 P_Validation_mode IN VARCHAR2,
254 P_OBJECT_VERSION_NUMBER IN NUMBER,
255 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
256 X_Return_Status OUT NOCOPY VARCHAR2,
257 X_Msg_Count OUT NOCOPY NUMBER,
258 X_Msg_Data OUT NOCOPY VARCHAR2
259 );
260
261 -- Start of Comments
262 --
263 -- Item level validation procedures
264 --
265 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
266 -- For create: G_CREATE, for update: G_UPDATE
267 -- Note: 1. This is automated generated item level validation procedure.
268 -- The actual validation detail is needed to be added.
269 --
270 -- End of Comments
271
272 PROCEDURE Validate_PROCESS_RULE_ID (
273 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
274 P_Validation_mode IN VARCHAR2,
275 P_PROCESS_RULE_ID IN NUMBER,
276 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
277 X_Return_Status OUT NOCOPY VARCHAR2,
278 X_Msg_Count OUT NOCOPY NUMBER,
279 X_Msg_Data OUT NOCOPY VARCHAR2
280 );
281
282 -- Start of Comments
283 --
284 -- Item level validation procedures
285 --
286 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
287 -- For create: G_CREATE, for update: G_UPDATE
288 -- Note: 1. This is automated generated item level validation procedure.
289 -- The actual validation detail is needed to be added.
290 --
291 -- End of Comments
292
293 PROCEDURE Validate_MONITOR_TYPE_CODE (
294 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295 P_Validation_mode IN VARCHAR2,
296 P_MONITOR_TYPE_CODE IN VARCHAR2,
297 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
298 X_Return_Status OUT VARCHAR2,
299 X_Msg_Count OUT NUMBER,
300 X_Msg_Data OUT VARCHAR2
301 );
302
303 -- Start of Comments
304 --
305 -- Item level validation procedures
306 --
307 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
308 -- For create: G_CREATE, for update: G_UPDATE
309 -- Note: 1. This is automated generated item level validation procedure.
310 -- The actual validation detail is needed to be added.
311 --
312 -- End of Comments
313
314 PROCEDURE Validate_TIME_LAG_NUM (
315 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
316 P_Validation_mode IN VARCHAR2,
317 P_TIME_LAG_NUM IN NUMBER,
318 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
319 X_Return_Status OUT VARCHAR2,
320 X_Msg_Count OUT NUMBER,
321 X_Msg_Data OUT VARCHAR2
322 );
323
324 -- Start of Comments
325 --
326 -- Item level validation procedures
327 --
328 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
329 -- For create: G_CREATE, for update: G_UPDATE
330 -- Note: 1. This is automated generated item level validation procedure.
331 -- The actual validation detail is needed to be added.
332 --
333 -- End of Comments
334
335 PROCEDURE Validate_TIME_LAG_UOM_CODE (
336 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
337 P_Validation_mode IN VARCHAR2,
338 P_TIME_LAG_UOM_CODE IN VARCHAR2,
339 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
340 X_Return_Status OUT VARCHAR2,
341 X_Msg_Count OUT NUMBER,
342 X_Msg_Data OUT VARCHAR2
343 );
344
345 -- Start of Comments
346 --
347 -- Item level validation procedures
348 --
349 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
350 -- For create: G_CREATE, for update: G_UPDATE
351 -- Note: 1. This is automated generated item level validation procedure.
352 -- The actual validation detail is needed to be added.
353 --
354 -- End of Comments
355
356 PROCEDURE Validate_TIME_LAG_FROM_STAGE (
357 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
358 P_Validation_mode IN VARCHAR2,
359 P_TIME_LAG_FROM_STAGE IN VARCHAR2,
360 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
361 X_Return_Status OUT VARCHAR2,
362 X_Msg_Count OUT NUMBER,
363 X_Msg_Data OUT VARCHAR2
364 );
365
366 -- Start of Comments
367 --
368 -- Item level validation procedures
369 --
370 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
371 -- For create: G_CREATE, for update: G_UPDATE
372 -- Note: 1. This is automated generated item level validation procedure.
373 -- The actual validation detail is needed to be added.
374 --
375 -- End of Comments
376
377 PROCEDURE Validate_TIME_LAG_TO_STAGE (
378 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
379 P_Validation_mode IN VARCHAR2,
380 P_TIME_LAG_TO_STAGE IN VARCHAR2,
381 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
382 X_Return_Status OUT VARCHAR2,
383 X_Msg_Count OUT NUMBER,
384 X_Msg_Data OUT VARCHAR2
385 );
386
387 -- Start of Comments
388 --
389 -- Item level validation procedures
390 --
391 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
392 -- For create: G_CREATE, for update: G_UPDATE
393 -- Note: 1. This is automated generated item level validation procedure.
394 -- The actual validation detail is needed to be added.
395 --
396 -- End of Comments
397
398 PROCEDURE Validate_TIME_LAG_ACTION (
399 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
400 P_Validation_mode IN VARCHAR2,
401 P_TIME_LAG_ACTION IN VARCHAR2,
402 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
403 X_Return_Status OUT VARCHAR2,
404 X_Msg_Count OUT NUMBER,
405 X_Msg_Data OUT VARCHAR2
406 );
407
408 -- Start of Comments
409 --
410 -- Item level validation procedures
411 --
412 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
413 -- For create: G_CREATE, for update: G_UPDATE
414 -- Note: 1. This is automated generated item level validation procedure.
415 -- The actual validation detail is needed to be added.
416 --
417 -- End of Comments
418
419 PROCEDURE Validate_TIME_LAG_NOTIFY_NUM (
420 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
421 P_Validation_mode IN VARCHAR2,
422 P_TIME_LAG_NOTIFY_NUM IN NUMBER,
423 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
424 X_Return_Status OUT VARCHAR2,
425 X_Msg_Count OUT NUMBER,
426 X_Msg_Data OUT VARCHAR2
427 );
428
429 -- Start of Comments
430 --
431 -- Item level validation procedures
432 --
433 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
434 -- For create: G_CREATE, for update: G_UPDATE
435 -- Note: 1. This is automated generated item level validation procedure.
436 -- The actual validation detail is needed to be added.
437 --
438 -- End of Comments
439
440 PROCEDURE Validate_TIME_LAG_NOTIFY_UOM_CODE (
441 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
442 P_Validation_mode IN VARCHAR2,
443 P_TIME_LAG_NOTIFY_UOM_CODE IN VARCHAR2,
444 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
445 X_Return_Status OUT NOCOPY VARCHAR2,
446 X_Msg_Count OUT NOCOPY NUMBER,
447 X_Msg_Data OUT NOCOPY VARCHAR2
448 );
449
450 -- Start of Comments
451 --
452 -- Item level validation procedures
453 --
454 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
455 -- For create: G_CREATE, for update: G_UPDATE
456 -- Note: 1. This is automated generated item level validation procedure.
457 -- The actual validation detail is needed to be added.
458 --
459 -- End of Comments
460
461 PROCEDURE Validate_MAX_REROUTES (
462 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463 P_Validation_mode IN VARCHAR2,
464 P_MAX_REROUTES IN NUMBER,
465 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
466 X_Return_Status OUT NOCOPY VARCHAR2,
467 X_Msg_Count OUT NOCOPY NUMBER,
468 X_Msg_Data OUT NOCOPY VARCHAR2
469 );
470
471 -- Start of Comments
472 --
473 -- Record level validation procedures
474 --
475 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
476 -- For create: G_CREATE, for update: G_UPDATE
477 -- Note: 1. This is automated generated item level validation procedure.
478 -- The actual validation detail is needed to be added.
479 -- 2. Developer can manually added inter-field level validation.
480 -- End of Comments
481
482 PROCEDURE Validate_CONDITION_rec(
483 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
484 P_Validation_mode IN VARCHAR2,
485 P_CONDITION_Rec IN CONDITION_Rec_Type,
486 X_Return_Status OUT NOCOPY VARCHAR2,
487 X_Msg_Count OUT NOCOPY NUMBER,
488 X_Msg_Data OUT NOCOPY VARCHAR2
489 );
490 */
491 -- Start of Comments
492 --
493 -- validation procedures
494 --
495 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
496 -- For create: G_CREATE, for update: G_UPDATE
497 -- Note: 1. This is automated generated item level validation procedure.
498 -- The actual validation detail is needed to be added.
499 -- 2. We can also validate table instead of record. There will be an option for user to choose.
500 -- End of Comments
501
502 PROCEDURE Validate_monitor_condition(
503 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
505 P_Validation_mode IN VARCHAR2,
506 P_CONDITION_Rec IN AML_MONITOR_CONDITIONS_PUB.CONDITION_Rec_Type,
507 X_Return_Status OUT NOCOPY VARCHAR2,
508 X_Msg_Count OUT NOCOPY NUMBER,
509 X_Msg_Data OUT NOCOPY VARCHAR2
510 );
511 End aml_MONITOR_CONDITIONS_PVT;