[Home] [Help]
PACKAGE: APPS.OZF_CODE_CONVERSION_PVT
Source
1 PACKAGE OZF_CODE_CONVERSION_PVT AUTHID CURRENT_USER as
2 /* $Header: ozfvsccs.pls 120.2 2007/12/24 10:27:13 gdeepika ship $ */
3 -- Start of Comments
4 -- Package name : ozf_code_conversion_pvt
5 -- Purpose :
6 -- History : 09-OCT-2003 vansub Created
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:code_conversion_rec_type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- CODE_CONVERSION_ID ,
19 -- OBJECT_VERSION_NUMBER ,
20 -- LAST_UPDATE_DATE ,
21 -- LAST_UPDATED_BY ,
22 -- CREATION_DATE ,
23 -- CREATED_BY ,
24 -- LAST_UPDATE_LOGIN ,
25 -- ORG_ID ,
26 -- PARTY_ID ,
27 -- CUST_ACCOUNT_ID ,
28 -- CODE_CONVERSION_TYPE ,
29 -- VALUE_SET_ID ,
30 -- EXTERNAL_CODE ,
31 -- INTERNAL_CODE ,
32 -- DESCRIPTION ,
33 -- START_DATE_ACTIVE ,
34 -- END_DATE_ACTIVE ,
35 -- ATTRIBUTE_CATEGORY ,
36 -- ATTRIBUTE1 ,
37 -- ATTRIBUTE2 ,
38 -- ATTRIBUTE3 ,
39 -- ATTRIBUTE4 ,
40 -- ATTRIBUTE5 ,
41 -- ATTRIBUTE6 ,
42 -- ATTRIBUTE7 ,
43 -- ATTRIBUTE8 ,
44 -- ATTRIBUTE9 ,
45 -- ATTRIBUTE10 ,
46 -- ATTRIBUTE11 ,
47 -- ATTRIBUTE12 ,
48 -- ATTRIBUTE13 ,
49 -- ATTRIBUTE14 ,
50 -- ATTRIBUTE15 ,
51 -- SECURITY_GROUP_ID ,
52
53 -- Required:
54 -- Defaults:
55 --
56 -- End of Comments
57
58 TYPE code_conversion_rec_type IS RECORD
59 (
60 CODE_CONVERSION_ID NUMBER,
61 OBJECT_VERSION_NUMBER NUMBER,
62 LAST_UPDATE_DATE DATE,
63 LAST_UPDATED_BY NUMBER,
64 CREATION_DATE DATE,
65 CREATED_BY NUMBER,
66 LAST_UPDATE_LOGIN NUMBER,
67 ORG_ID NUMBER,
68 PARTY_ID NUMBER,
69 CUST_ACCOUNT_ID NUMBER,
70 CODE_CONVERSION_TYPE VARCHAR2(30),
71 EXTERNAL_CODE VARCHAR2(240),
72 INTERNAL_CODE VARCHAR2(240),
73 DESCRIPTION VARCHAR2(240),
74 START_DATE_ACTIVE DATE,
75 END_DATE_ACTIVE DATE,
76 ATTRIBUTE_CATEGORY VARCHAR2(30),
77 ATTRIBUTE1 VARCHAR2(150),
78 ATTRIBUTE2 VARCHAR2(150),
79 ATTRIBUTE3 VARCHAR2(150),
80 ATTRIBUTE4 VARCHAR2(150),
81 ATTRIBUTE5 VARCHAR2(150),
82 ATTRIBUTE6 VARCHAR2(150),
83 ATTRIBUTE7 VARCHAR2(150),
84 ATTRIBUTE8 VARCHAR2(150),
85 ATTRIBUTE9 VARCHAR2(150),
86 ATTRIBUTE10 VARCHAR2(150),
87 ATTRIBUTE11 VARCHAR2(150),
88 ATTRIBUTE12 VARCHAR2(150),
89 ATTRIBUTE13 VARCHAR2(150),
90 ATTRIBUTE14 VARCHAR2(150),
91 ATTRIBUTE15 VARCHAR2(150),
92 SECURITY_GROUP_ID NUMBER
93
94 );
95
96 g_miss_code_conversion_rec code_conversion_rec_type;
97 TYPE code_conversion_tbl_type IS TABLE OF code_conversion_rec_type;
98 g_miss_code_conversion_tbl code_conversion_tbl_type;
99
100 -- *******************************************************
101 -- Start of Comments
102 -- *******************************************************
103 -- API Name: create_code_conversion
104 -- Type : Private
105 -- Pre-Req :
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_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
112 -- P_code_conversion_tbl IN code_conversion_tbl_type Required
113 --
114 -- OUT:
115 -- x_return_status OUT NOCOPY VARCHAR2
116 -- x_msg_count OUT NOCOPY NUMBER
117 -- x_msg_data OUT NOCOPY VARCHAR2
118 -- Version : Current version 1.0
119 --
120 -- End of Comments
121 --
122 PROCEDURE create_code_conversion(
123 p_api_version_number IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_code_conversion_tbl IN code_conversion_tbl_type ,
131 x_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE);
132
133 -- *******************************************************
134 -- Start of Comments
135 -- *******************************************************
136 -- API Name: Update_code_conversion
137 -- Type : Private
138 -- Pre-Req :
139 -- Parameters:
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_code_conversion_tbl IN code_conversion_tbl_type Required
146 --
147 -- OUT:
148 -- x_return_status OUT NOCOPY VARCHAR2
149 -- x_msg_count OUT NOCOPY NUMBER
150 -- x_msg_data OUT NOCOPY VARCHAR2
151 -- x_object_version_number OUT NOCOPY NUMBER
152 -- Version : Current version 1.0
153 --
154 -- End of Comments
155 --
156 PROCEDURE Update_code_conversion(
157 P_Api_Version_Number IN NUMBER,
158 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161 X_Return_Status OUT NOCOPY VARCHAR2,
162 X_Msg_Count OUT NOCOPY NUMBER,
163 X_Msg_Data OUT NOCOPY VARCHAR2,
164 p_code_conversion_tbl IN code_conversion_tbl_type ,
165 X_Object_Version_Number OUT NOCOPY JTF_NUMBER_TABLE);
166 -- *******************************************************
167 -- Start of Comments
168 -- *******************************************************
169 -- API Name: update_code_conversion_tbl
170 -- Type : Private
171 -- Pre-Req :
172 -- Parameters:
173 -- IN
174 -- p_api_version_number IN NUMBER Required
175 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
176 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
177 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
178 -- p_code_conversion_tbl IN code_conversion_tbl_type , Required
179 --
180 -- OUT:
181 -- x_return_status OUT NOCOPY VARCHAR2
182 -- x_msg_count OUT NOCOPY NUMBER
183 -- x_msg_data OUT NOCOPY VARCHAR2
184 -- Version : Current version 1.0
185 --
186 -- End of Comments
187 --
188 PROCEDURE update_code_conversion_tbl(
189 P_Api_Version_Number IN NUMBER,
190 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193 X_Return_Status OUT NOCOPY VARCHAR2,
194 X_Msg_Count OUT NOCOPY NUMBER,
195 X_Msg_Data OUT NOCOPY VARCHAR2,
196 p_code_conversion_tbl IN code_conversion_tbl_type
197 );
198
199 -- *******************************************************
200 -- Start of Comments
201 -- *******************************************************
202 -- API Name: Delete_code_conversion
203 -- Type : Private
204 -- Pre-Req :
205 -- Parameters:
206 -- IN
207 -- p_api_version_number IN NUMBER Required
208 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
209 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
210 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
211 -- p_code_conversion_id IN NUMBER
212 -- p_object_version_number IN NUMBER Optional Default=NULL
213 -- p_external_code IN NUMBER Optional Default=NULL
214 --
215 -- OUT:
216 -- x_return_status OUT NOCOPY VARCHAR2
217 -- x_msg_count OUT NOCOPY NUMBER
218 -- x_msg_data OUT NOCOPY VARCHAR2
219 -- Version : Current version 1.0
220 --
221 -- End of Comments
222 --
223 PROCEDURE Delete_code_conversion(
224 P_Api_Version_Number IN NUMBER,
225 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
226 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
227 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228 X_Return_Status OUT NOCOPY VARCHAR2,
229 X_Msg_Count OUT NOCOPY NUMBER,
230 X_Msg_Data OUT NOCOPY VARCHAR2,
231 P_code_conversion_id IN NUMBER,
232 P_Object_Version_Number IN NUMBER,
233 p_external_code IN VARCHAR2,
234 p_code_conversion_type IN VARCHAR2
235
236 );
237
238
239
240 PROCEDURE delete_code_conversion_tbl(
241 P_Api_Version_Number IN NUMBER,
242 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245 X_Return_Status OUT NOCOPY VARCHAR2,
246 X_Msg_Count OUT NOCOPY NUMBER,
247 X_Msg_Data OUT NOCOPY VARCHAR2,
248 P_code_conversion_Tbl IN code_conversion_Tbl_Type
249 );
250
251 -- *******************************************************
252 -- Start of Comments
253 -- *******************************************************
254 -- API Name: Check_uniq_code_conversion
255 -- Type : Private
256 -- Pre-Req :
257 -- Parameters:
258 -- IN
259 -- p_code_conversion_tbl IN code_conversion_tbl_type , Required
260 -- p_validation_mode IN VARCHAR2 Optional Default=JTF_PLSQL_API.g_create
261 --
262 -- OUT:
263 -- x_return_status OUT NOCOPY VARCHAR2
264 --
265 -- Version : Current version 1.0
266 -- Description : Checks the uniqueness of the Reason Mapping for a Customer .
267 --
268 -- End of Comments
269 PROCEDURE Check_uniq_code_conversion(
270 p_code_conversion_rec IN code_conversion_rec_type ,
271 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
272 x_return_status OUT NOCOPY VARCHAR2
273 );
274
275 /***
276 -- Start of Comments
277 --
278 -- Record level validation procedures
279 --
280 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
281 -- For create: G_CREATE, for update: G_UPDATE
282 -- End of Comments
283
284 PROCEDURE validate_code_conversion_Rec(
285 P_Api_Version_Number IN NUMBER,
286 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
287 X_Return_Status OUT NOCOPY VARCHAR2,
288 X_Msg_Count OUT NOCOPY NUMBER,
289 X_Msg_Data OUT NOCOPY VARCHAR2,
290 p_code_conversion_tbl IN CODE_CONVERSION_TBL_TYPE
291 );
292
293 ***/
294 -- Start of Comments
295 --
296 -- validation procedures
297 --
298 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
299 -- For create: G_CREATE, for update: G_UPDATE
300 -- End of Comments
301
302 PROCEDURE Validate_code_conversion(
303 P_Api_Version_Number IN NUMBER,
304 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
305 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306 P_Validation_mode IN VARCHAR2,
307 p_code_conversion_tbl IN code_conversion_tbl_type,
308 X_Return_Status OUT NOCOPY VARCHAR2,
309 X_Msg_Count OUT NOCOPY NUMBER,
310 X_Msg_Data OUT NOCOPY VARCHAR2
311 );
312 -- Start of Comments
313 --
314 -- get_claim_reason
315 -- Translate the external code to the internal code.
316 --
317 -- End of Comments
318 PROCEDURE convert_code(
319 p_cust_account_id IN NUMBER,
320 p_party_id IN NUMBER,
321 p_code_conversion_type IN VARCHAR2,
322 p_external_code IN VARCHAR2,
323 x_internal_code OUT NOCOPY VARCHAR2,
324 X_Return_Status OUT NOCOPY VARCHAR2,
325 X_Msg_Count OUT NOCOPY NUMBER,
326 X_Msg_Data OUT NOCOPY VARCHAR2
327 );
328
329 -- *******************************************************
330 -- Start of Comments
331 -- -------------------------------------------------------
332 -- Record name:supp_code_conversion_rec_type
333 -- -------------------------------------------------------
334 -- Parameters:
335 -- CODE_CONVERSION_ID ,
336 -- OBJECT_VERSION_NUMBER ,
337 -- LAST_UPDATE_DATE ,
338 -- LAST_UPDATED_BY ,
339 -- LAST_UPDATE_BY ,
340 -- CREATION_DATE ,
341 -- CREATED_BY ,
342 -- LAST_UPDATE_LOGIN ,
343 -- SUPP_TRADE_PROFILE_ID ,
344 -- ORG_ID ,
345 -- CODE_CONVERSION_TYPE ,
346 -- EXTERNAL_CODE ,
347 -- INTERNAL_CODE ,
348 -- DESCRIPTION ,
349 -- START_DATE_ACTIVE ,
350 -- END_DATE_ACTIVE ,
351 -- ATTRIBUTE_CATEGORY ,
352 -- ATTRIBUTE1 ,
353 -- ATTRIBUTE2 ,
354 -- ATTRIBUTE3 ,
355 -- ATTRIBUTE4 ,
356 -- ATTRIBUTE5 ,
357 -- ATTRIBUTE6 ,
358 -- ATTRIBUTE7 ,
359 -- ATTRIBUTE8 ,
360 -- ATTRIBUTE9 ,
361 -- ATTRIBUTE10 ,
362 -- ATTRIBUTE11 ,
363 -- ATTRIBUTE12 ,
364 -- ATTRIBUTE13 ,
365 -- ATTRIBUTE14 ,
366 -- ATTRIBUTE15 ,
367 -- SECURITY_GROUP_ID ,
368 -- Required:
369 -- Defaults:
370 --
371 -- End of Comments
372
373 TYPE supp_code_conversion_rec_type IS RECORD
374 (
375 CODE_CONVERSION_ID NUMBER,
376 OBJECT_VERSION_NUMBER NUMBER,
377 LAST_UPDATE_DATE DATE,
378 LAST_UPDATED_BY NUMBER,
379 CREATION_DATE DATE,
380 CREATED_BY NUMBER,
381 LAST_UPDATE_LOGIN NUMBER,
382 ORG_ID NUMBER,
383 SUPP_TRADE_PROFILE_ID NUMBER,
384 CODE_CONVERSION_TYPE VARCHAR2(30),
385 EXTERNAL_CODE VARCHAR2(240),
386 INTERNAL_CODE VARCHAR2(240),
387 DESCRIPTION VARCHAR2(240),
388 START_DATE_ACTIVE DATE,
392 ATTRIBUTE2 VARCHAR2(150),
389 END_DATE_ACTIVE DATE,
390 ATTRIBUTE_CATEGORY VARCHAR2(30),
391 ATTRIBUTE1 VARCHAR2(150),
393 ATTRIBUTE3 VARCHAR2(150),
394 ATTRIBUTE4 VARCHAR2(150),
395 ATTRIBUTE5 VARCHAR2(150),
396 ATTRIBUTE6 VARCHAR2(150),
397 ATTRIBUTE7 VARCHAR2(150),
398 ATTRIBUTE8 VARCHAR2(150),
399 ATTRIBUTE9 VARCHAR2(150),
400 ATTRIBUTE10 VARCHAR2(150),
401 ATTRIBUTE11 VARCHAR2(150),
402 ATTRIBUTE12 VARCHAR2(150),
403 ATTRIBUTE13 VARCHAR2(150),
404 ATTRIBUTE14 VARCHAR2(150),
405 ATTRIBUTE15 VARCHAR2(150),
406 SECURITY_GROUP_ID NUMBER
407
408 );
409
410 g_miss_supp_code_conv_rec supp_code_conversion_rec_type;
411 TYPE supp_code_conversion_tbl_type IS TABLE OF supp_code_conversion_rec_type;
412 g_miss_supp_code_conv_tbl supp_code_conversion_tbl_type;
413
414 -- *******************************************************
415 -- Start of Comments
416 -- *******************************************************
417 -- API Name: create_supp_code_conversion
418 -- Type : Private
419 -- Pre-Req :
420 -- Parameters:
421 -- IN
422 -- p_api_version_number IN NUMBER Required
423 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
424 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
425 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
426 -- P_supp_code_conversion_tbl IN supp_code_conversion_tbl_type Required
427 --
428 -- OUT:
429 -- x_return_status OUT NOCOPY VARCHAR2
430 -- x_msg_count OUT NOCOPY NUMBER
431 -- x_msg_data OUT NOCOPY VARCHAR2
432 -- Version : Current version 1.0
433 --
434 -- End of Comments
435 --
436 PROCEDURE create_supp_code_conversion(
437 p_api_version_number IN NUMBER,
438 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
439 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
440 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2,
444 p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type ,
445 x_supp_code_conversion_id_tbl OUT NOCOPY JTF_NUMBER_TABLE);
446
447 -- *******************************************************
448 -- Start of Comments
449 -- *******************************************************
450 -- API Name: Update_supp_code_conversion
451 -- Type : Private
452 -- Pre-Req :
453 -- Parameters:
454 -- IN
455 -- p_api_version_number IN NUMBER Required
456 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
457 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
458 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
459 -- p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type Required
460 --
461 -- OUT:
462 -- x_return_status OUT NOCOPY VARCHAR2
463 -- x_msg_count OUT NOCOPY NUMBER
464 -- x_msg_data OUT NOCOPY VARCHAR2
465 -- x_object_version_number OUT NOCOPY NUMBER
466 -- Version : Current version 1.0
467 --
468 -- End of Comments
469 --
470 PROCEDURE Update_supp_code_conversion(
471 P_Api_Version_Number IN NUMBER,
472 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
473 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
474 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
475 X_Return_Status OUT NOCOPY VARCHAR2,
476 X_Msg_Count OUT NOCOPY NUMBER,
477 X_Msg_Data OUT NOCOPY VARCHAR2,
478 p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type ,
479 X_Object_Version_Number OUT NOCOPY JTF_NUMBER_TABLE);
480 -- *******************************************************
481 -- Start of Comments
482 -- *******************************************************
483 -- API Name: update_supp_code_conversion_tbl
484 -- Type : Private
485 -- Pre-Req :
486 -- Parameters:
487 -- IN
488 -- p_api_version_number IN NUMBER Required
489 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
490 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
491 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
492 -- p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type , Required
493 --
494 -- OUT:
495 -- x_return_status OUT NOCOPY VARCHAR2
496 -- x_msg_count OUT NOCOPY NUMBER
497 -- x_msg_data OUT NOCOPY VARCHAR2
498 -- Version : Current version 1.0
499 --
500 -- End of Comments
501 --
502 PROCEDURE update_supp_code_conv_tbl(
506 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
503 P_Api_Version_Number IN NUMBER,
504 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
505 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
507 X_Return_Status OUT NOCOPY VARCHAR2,
508 X_Msg_Count OUT NOCOPY NUMBER,
509 X_Msg_Data OUT NOCOPY VARCHAR2,
510 p_supp_code_conversion_tbl IN supp_code_conversion_tbl_type
511 );
512
513 -- *******************************************************
514 -- Start of Comments
515 -- *******************************************************
516 -- API Name: Delete_supp_code_conversion
517 -- Type : Private
518 -- Pre-Req :
519 -- Parameters:
520 -- IN
521 -- p_api_version_number IN NUMBER Required
522 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
523 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
524 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
525 -- p_code_conversion_id IN NUMBER
526 -- p_object_version_number IN NUMBER Optional Default=NULL
527 -- p_external_code IN NUMBER Optional Default=NULL
528 --
529 -- OUT:
530 -- x_return_status OUT NOCOPY VARCHAR2
531 -- x_msg_count OUT NOCOPY NUMBER
532 -- x_msg_data OUT NOCOPY VARCHAR2
533 -- Version : Current version 1.0
534 --
535 -- End of Comments
536 --
537 PROCEDURE Delete_supp_code_conversion(
538 P_Api_Version_Number IN NUMBER,
539 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
540 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
541 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542 X_Return_Status OUT NOCOPY VARCHAR2,
543 X_Msg_Count OUT NOCOPY NUMBER,
544 X_Msg_Data OUT NOCOPY VARCHAR2,
545 P_code_conversion_id IN NUMBER,
546 P_Object_Version_Number IN NUMBER
547 );
548
549
550
551 PROCEDURE delete_supp_code_conv_tbl(
552 P_Api_Version_Number IN NUMBER,
553 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
554 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
555 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
556 X_Return_Status OUT NOCOPY VARCHAR2,
557 X_Msg_Count OUT NOCOPY NUMBER,
558 X_Msg_Data OUT NOCOPY VARCHAR2,
559 P_supp_code_conversion_Tbl IN supp_code_conversion_Tbl_Type
560 );
561
562
563 End ozf_code_conversion_pvt;
564
565