1 PACKAGE IEX_LITIGATION_PVT AUTHID CURRENT_USER as
2 /* $Header: iexvltgs.pls 120.1 2007/12/20 09:14:42 gnramasa ship $ */
3 -- Start of Comments
4 -- Package name : IEX_LITIGATION_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 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:LTG_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- LITIGATION_ID
19 -- DELINQUENCY_ID
20 -- PARTY_ID
21 -- UNPAID_REASON_CODE
22 -- JUDGEMENT_DATE
23 -- DISPOSITION_CODE
24 -- REQUEST_ID
25 -- PROGRAM_APPLICATION_ID
26 -- PROGRAM_ID
27 -- PROGRAM_UPDATE_DATE
28 -- ATTRIBUTE_CATEGORY
29 -- ATTRIBUTE1
30 -- ATTRIBUTE2
31 -- ATTRIBUTE3
32 -- ATTRIBUTE4
33 -- ATTRIBUTE5
34 -- ATTRIBUTE6
35 -- ATTRIBUTE7
36 -- ATTRIBUTE8
37 -- ATTRIBUTE9
38 -- ATTRIBUTE10
39 -- ATTRIBUTE11
40 -- ATTRIBUTE12
41 -- ATTRIBUTE13
42 -- ATTRIBUTE14
43 -- ATTRIBUTE15
44 -- CREATED_BY
45 -- CREATION_DATE
46 -- LAST_UPDATED_BY
47 -- LAST_UPDATE_DATE
48 -- LAST_UPDATE_LOGIN
49 -- CREDIT_HOLD_REQUEST_FLAG
50 -- CREDIT_HOLD_APPROVED_FLAG
51 -- SERVICE_HOLD_REQUEST_FLAG
52 -- SERVICE_HOLD_APPROVED_FLAG
53 -- SUGGESTION_APPROVED_FLAG
54 --
55 -- Required:
56 -- Defaults:
57 -- Note: This is automatic generated record definition, it includes all columns
58 -- defined in the table, developer must manually add or delete some of the attributes.
59 --
60 -- End of Comments
61
62 TYPE LTG_Rec_Type IS RECORD
63 (
64 LITIGATION_ID NUMBER := FND_API.G_MISS_NUM
65 , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
66 , PARTY_ID NUMBER := FND_API.G_MISS_NUM
67 , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68 , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69 , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74 , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75 , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76 , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77 , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78 , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79 , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80 , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81 , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82 , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83 , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84 , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85 , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86 , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87 , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88 , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89 , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91 , CREATION_DATE DATE := FND_API.G_MISS_DATE
92 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95 , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96 , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97 , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98 , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99 , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100 , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101 , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102 , ORG_ID NUMBER := FND_API.G_MISS_NUM
103 , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
104 , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
105 );
106
107 TYPE LTG_sort_rec_type IS RECORD
108 (
109 -- Please define your own sort by record here.
110 DELINQUENCY_ID NUMBER := NULL
111 );
112
113 G_MISS_LTG_REC LTG_Rec_Type;
114 TYPE LTG_Tbl_Type IS TABLE OF LTG_Rec_Type
115 INDEX BY BINARY_INTEGER;
116 G_MISS_LTG_TBL LTG_Tbl_Type;
117
118 -- *******************************************************
119 -- Start of Comments
120 -- *******************************************************
121 -- API Name: Create_litigation
122 -- Type : Private
123 -- Pre-Req :
124 -- Parameters:
125 -- IN
126 -- p_api_version_number IN NUMBER Required
127 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
131 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
132 -- p_admin_group_id IN NUMBER Required
133 -- P_LTG_Rec IN LTG_Rec_Type Required
134 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
135 --
136 -- OUT:
137 -- x_return_status OUT NOCOPY VARCHAR2
138 -- x_msg_count OUT NOCOPY NUMBER
139 -- x_msg_data OUT NOCOPY VARCHAR2
140 -- Version : Current version 2.0
141 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
142 -- and basic operation, developer must manually add parameters and business logic as necessary.
143 --
144 -- End of Comments
145 --
146 PROCEDURE Create_litigation(
147 P_Api_Version_Number IN NUMBER,
148 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
149 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
152 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
153 P_Admin_Group_Id IN NUMBER,
154 P_Identity_Salesforce_Id IN NUMBER,
155 --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
156 P_LTG_Rec IN LTG_Rec_Type := G_MISS_LTG_REC,
157 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
158 X_LITIGATION_ID OUT NOCOPY NUMBER,
159 X_Return_Status OUT NOCOPY VARCHAR2,
160 X_Msg_Count OUT NOCOPY NUMBER,
161 X_Msg_Data OUT NOCOPY VARCHAR2
162 );
163
164 -- *******************************************************
165 -- Start of Comments
166 -- *******************************************************
167 -- API Name: Update_litigation
168 -- Type : Private
169 -- Pre-Req :
170 -- Parameters:
171 -- IN
172 -- p_api_version_number IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
177 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178 -- p_admin_group_id IN NUMBER Required
179 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
180 -- P_LTG_Rec IN LTG_Rec_Type Required
181 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
182 --
183 -- OUT:
184 -- x_return_status OUT NOCOPY VARCHAR2
185 -- x_msg_count OUT NOCOPY NUMBER
186 -- x_msg_data OUT NOCOPY VARCHAR2
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 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
194 PROCEDURE Update_litigation(
195 P_Api_Version_Number IN NUMBER,
196 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
200 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
201 P_Admin_Group_Id IN NUMBER,
202 P_Identity_Salesforce_Id IN NUMBER,
203 -- P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
204 P_LTG_Rec IN LTG_Rec_Type,
205 X_Return_Status OUT NOCOPY VARCHAR2,
206 X_Msg_Count OUT NOCOPY NUMBER,
207 X_Msg_Data OUT NOCOPY VARCHAR2
208 );
209
210 -- *******************************************************
211 -- Start of Comments
212 -- *******************************************************
213 -- API Name: Delete_litigation
214 -- Type : Private
215 -- Pre-Req :
216 -- Parameters:
217 -- IN
218 -- p_api_version_number IN NUMBER Required
219 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224 -- p_admin_group_id IN NUMBER Required
225 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
226 -- P_LTG_Rec IN LTG_Rec_Type Required
227 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
228 --
229 -- OUT:
230 -- x_return_status OUT NOCOPY VARCHAR2
231 -- x_msg_count OUT NOCOPY NUMBER
232 -- x_msg_data OUT NOCOPY VARCHAR2
233 -- Version : Current version 2.0
234 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
235 -- and basic operation, developer must manually add parameters and business logic as necessary.
236 --
237 -- End of Comments
238 --
239 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
240 -- The Master delete procedure may not be needed depends on different business requirements.
241 PROCEDURE Delete_litigation(
242 P_Api_Version_Number IN NUMBER,
243 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
245 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
247 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
248 P_Admin_Group_Id IN NUMBER,
249 P_Identity_Salesforce_Id IN NUMBER,
250 P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
251 P_LTG_Rec IN LTG_Rec_Type,
252 X_Return_Status OUT NOCOPY VARCHAR2,
253 X_Msg_Count OUT NOCOPY NUMBER,
254 X_Msg_Data OUT NOCOPY VARCHAR2
255 );
256
257 -- *******************************************************
258 -- Start of Comments
259 -- *******************************************************
260 -- API Name: Get_litigation
261 -- Type : Private
262 -- Pre-Req :
263 -- Parameters:
264 -- IN
265 -- p_api_version_number IN NUMBER Required
266 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
269 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
270 -- p_admin_group_id IN NUMBER Required
271 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
272 -- P_LTG_Rec IN LTG_Rec_Type Required
273 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
274 -- Hint: Add List of bind variables here
275 -- p_rec_requested IN NUMBER Optional Default = 30
276 -- p_start_rec_ptr IN NUMBER Optional Default = 1
277 --
278 -- Return Total Records Count Flag. This flag controls whether the total record count
279 -- and total record amount is returned.
280 --
281 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
282 -- Hint: User defined record type
283 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
284 --
285 -- OUT:
286 -- x_return_status OUT NOCOPY VARCHAR2
287 -- x_msg_count OUT NOCOPY NUMBER
288 -- x_msg_data OUT NOCOPY VARCHAR2
289 -- X_LTG_Tbl OUT NOCOPY LTG_Rec_Type
290 -- x_returned_rec_count OUT NOCOPY NUMBER
291 -- x_next_rec_ptr OUT NOCOPY NUMBER
292 -- x_tot_rec_count OUT NOCOPY NUMBER
293 -- other optional out NOCOPY parameters
294 -- x_tot_rec_amount OUT NOCOPY NUMBER
295 -- Version : Current version 2.0
296 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
297 -- and basic operation, developer must manually add parameters and business logic as necessary.
298 --
299 -- End of Comments
300 --
301 PROCEDURE Get_litigation(
302 P_Api_Version_Number IN NUMBER,
303 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
304 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305 P_Admin_Group_id IN NUMBER,
306 P_identity_salesforce_id IN NUMBER := NULL,
307 P_LTG_Rec IN LTG_Rec_Type,
308 -- Hint: Add list of bind variables here
309 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
310 p_start_rec_prt IN NUMBER := 1,
311 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
312 -- Hint: user defined record type
313 p_order_by_rec IN LTG_sort_rec_type,
314 x_return_status OUT NOCOPY VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2,
317 X_LTG_Tbl OUT NOCOPY LTG_Tbl_Type,
318 x_returned_rec_count OUT NOCOPY NUMBER,
319 x_next_rec_ptr OUT NOCOPY NUMBER,
320 x_tot_rec_count OUT NOCOPY NUMBER
321 -- other optional parameters
322 -- x_tot_rec_amount OUT NOCOPY NUMBER
323 );
324
325
326 -- Start of Comments
327 --
328 -- Item level validation procedures
329 --
330 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
331 -- For create: G_CREATE, for update: G_UPDATE
332 -- Note: 1. This is automated generated item level validation procedure.
333 -- The actual validation detail is needed to be added.
334 --
335 -- End of Comments
336
337 PROCEDURE Validate_LITIGATION_ID (
338 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
339 P_Validation_mode IN VARCHAR2,
340 P_LITIGATION_ID IN NUMBER,
341 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
342 X_Return_Status OUT NOCOPY VARCHAR2,
343 X_Msg_Count OUT NOCOPY NUMBER,
344 X_Msg_Data OUT NOCOPY VARCHAR2
345 );
346
347 -- Start of Comments
348 --
349 -- Item level validation procedures
350 --
351 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
352 -- For create: G_CREATE, for update: G_UPDATE
353 -- Note: 1. This is automated generated item level validation procedure.
354 -- The actual validation detail is needed to be added.
355 --
356 -- End of Comments
357
358 PROCEDURE Validate_DELINQUENCY_ID (
359 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
360 P_Validation_mode IN VARCHAR2,
361 P_DELINQUENCY_ID IN NUMBER,
362 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
363 X_Return_Status OUT NOCOPY VARCHAR2,
364 X_Msg_Count OUT NOCOPY NUMBER,
365 X_Msg_Data OUT NOCOPY VARCHAR2
366 );
367
368 -- Start of Comments
369 --
370 -- Item level validation procedures
371 --
372 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
373 -- For create: G_CREATE, for update: G_UPDATE
374 -- Note: 1. This is automated generated item level validation procedure.
375 -- The actual validation detail is needed to be added.
376 --
377 -- End of Comments
378
379 PROCEDURE Validate_PARTY_ID (
380 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
381 P_Validation_mode IN VARCHAR2,
382 P_PARTY_ID IN NUMBER,
383 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
384 X_Return_Status OUT NOCOPY VARCHAR2,
385 X_Msg_Count OUT NOCOPY NUMBER,
386 X_Msg_Data OUT NOCOPY VARCHAR2
387 );
388
389 -- Start of Comments
390 --
391 -- Item level validation procedures
392 --
393 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
394 -- For create: G_CREATE, for update: G_UPDATE
395 -- Note: 1. This is automated generated item level validation procedure.
396 -- The actual validation detail is needed to be added.
397 --
398 -- End of Comments
399
400 PROCEDURE Validate_UNPAID_REASON_CODE (
401 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
402 P_Validation_mode IN VARCHAR2,
403 P_UNPAID_REASON_CODE IN VARCHAR2,
404 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
405 X_Return_Status OUT NOCOPY VARCHAR2,
406 X_Msg_Count OUT NOCOPY NUMBER,
407 X_Msg_Data OUT NOCOPY VARCHAR2
408 );
409
410 -- Start of Comments
411 --
412 -- Item level validation procedures
413 --
414 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
415 -- For create: G_CREATE, for update: G_UPDATE
416 -- Note: 1. This is automated generated item level validation procedure.
417 -- The actual validation detail is needed to be added.
418 --
419 -- End of Comments
420
421 PROCEDURE Validate_JUDGEMENT_DATE (
422 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
423 P_Validation_mode IN VARCHAR2,
424 P_JUDGEMENT_DATE IN DATE,
425 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
426 X_Return_Status OUT NOCOPY VARCHAR2,
427 X_Msg_Count OUT NOCOPY NUMBER,
428 X_Msg_Data OUT NOCOPY VARCHAR2
429 );
430
431 -- Start of Comments
432 --
433 -- Item level validation procedures
434 --
435 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
436 -- For create: G_CREATE, for update: G_UPDATE
437 -- Note: 1. This is automated generated item level validation procedure.
438 -- The actual validation detail is needed to be added.
439 --
440 -- End of Comments
441
442 PROCEDURE Validate_DISPOSITION_CODE (
443 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444 P_Validation_mode IN VARCHAR2,
445 P_DISPOSITION_CODE IN VARCHAR2,
446 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
447 X_Return_Status OUT NOCOPY VARCHAR2,
448 X_Msg_Count OUT NOCOPY NUMBER,
449 X_Msg_Data OUT NOCOPY VARCHAR2
450 );
451
452 -- Start of Comments
453 --
454 -- Item level validation procedures
455 --
456 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
457 -- For create: G_CREATE, for update: G_UPDATE
458 -- Note: 1. This is automated generated item level validation procedure.
459 -- The actual validation detail is needed to be added.
460 --
461 -- End of Comments
462
463 PROCEDURE v_CREDIT_HOLD_REQUEST_FLAG (
464 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
465 P_Validation_mode IN VARCHAR2,
466 P_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2,
467 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
468 X_Return_Status OUT NOCOPY VARCHAR2,
469 X_Msg_Count OUT NOCOPY NUMBER,
470 X_Msg_Data OUT NOCOPY VARCHAR2
471 );
472
473 -- Start of Comments
474 --
475 -- Item level validation procedures
476 --
477 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
478 -- For create: G_CREATE, for update: G_UPDATE
479 -- Note: 1. This is automated generated item level validation procedure.
480 -- The actual validation detail is needed to be added.
481 --
482 -- End of Comments
483
484 PROCEDURE v_CREDIT_HOLD_APPROVED_FLAG (
485 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
486 P_Validation_mode IN VARCHAR2,
487 P_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2,
488 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
489 X_Return_Status OUT NOCOPY VARCHAR2,
490 X_Msg_Count OUT NOCOPY NUMBER,
491 X_Msg_Data OUT NOCOPY VARCHAR2
492 );
493
494 -- Start of Comments
495 --
496 -- Item level validation procedures
497 --
498 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
499 -- For create: G_CREATE, for update: G_UPDATE
500 -- Note: 1. This is automated generated item level validation procedure.
501 -- The actual validation detail is needed to be added.
502 --
503 -- End of Comments
504
505 PROCEDURE v_SERVICE_HOLD_REQUEST_FLAG (
506 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
507 P_Validation_mode IN VARCHAR2,
508 P_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2,
509 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
510 X_Return_Status OUT NOCOPY VARCHAR2,
511 X_Msg_Count OUT NOCOPY NUMBER,
512 X_Msg_Data OUT NOCOPY VARCHAR2
513 );
514
515 -- Start of Comments
516 --
517 -- Item level validation procedures
518 --
519 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
520 -- For create: G_CREATE, for update: G_UPDATE
521 -- Note: 1. This is automated generated item level validation procedure.
522 -- The actual validation detail is needed to be added.
523 --
524 -- End of Comments
525
526 PROCEDURE v_SERVICE_HOLD_APPROVED_FLAG (
527 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
528 P_Validation_mode IN VARCHAR2,
529 P_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2,
530 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
531 X_Return_Status OUT NOCOPY VARCHAR2,
532 X_Msg_Count OUT NOCOPY NUMBER,
533 X_Msg_Data OUT NOCOPY VARCHAR2
534 );
535
536 -- Start of Comments
537 --
538 -- Item level validation procedures
539 --
540 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
541 -- For create: G_CREATE, for update: G_UPDATE
542 -- Note: 1. This is automated generated item level validation procedure.
543 -- The actual validation detail is needed to be added.
544 --
545 -- End of Comments
546
547 PROCEDURE v_SUGGESTION_APPROVED_FLAG (
548 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
549 P_Validation_mode IN VARCHAR2,
550 P_SUGGESTION_APPROVED_FLAG IN VARCHAR2,
551 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
552 X_Return_Status OUT NOCOPY VARCHAR2,
553 X_Msg_Count OUT NOCOPY NUMBER,
554 X_Msg_Data OUT NOCOPY VARCHAR2
555 );
556
557 -- Start of Comments
558 --
559 -- Record level validation procedures
560 --
561 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
562 -- For create: G_CREATE, for update: G_UPDATE
563 -- Note: 1. This is automated generated item level validation procedure.
564 -- The actual validation detail is needed to be added.
565 -- 2. Developer can manually added inter-field level validation.
566 -- End of Comments
567
568 PROCEDURE Validate_LTG_rec(
569 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
570 P_Validation_mode IN VARCHAR2,
571 P_LTG_Rec IN LTG_Rec_Type,
572 X_Return_Status OUT NOCOPY VARCHAR2,
573 X_Msg_Count OUT NOCOPY NUMBER,
574 X_Msg_Data OUT NOCOPY VARCHAR2
575 );
576
577 -- Start of Comments
578 --
579 -- validation procedures
580 --
581 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
582 -- For create: G_CREATE, for update: G_UPDATE
583 -- Note: 1. This is automated generated item level validation procedure.
584 -- The actual validation detail is needed to be added.
585 -- 2. We can also validate table instead of record. There will be an option for user to choose.
586 -- End of Comments
587
588 PROCEDURE Validate_litigation(
589 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
590 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
591 P_Validation_mode IN VARCHAR2,
592 P_LTG_Rec IN LTG_Rec_Type,
593 X_Return_Status OUT NOCOPY VARCHAR2,
594 X_Msg_Count OUT NOCOPY NUMBER,
595 X_Msg_Data OUT NOCOPY VARCHAR2
596 );
597 End IEX_LITIGATION_PVT;