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