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: --
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:
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
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,
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,
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 ,
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: --
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:
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
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,
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,
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 ,
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: --
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:
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
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,
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,
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
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
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
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: --
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,
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,
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,
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,
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,
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
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
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,
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,
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: --
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:
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
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,
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,
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 ,
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: --
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:
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
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,
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,
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 ,
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: --
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:
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
500: -- End of Comments
501: --
502: PROCEDURE update_supp_code_conv_tbl(
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,
506: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
507: X_Return_Status OUT NOCOPY VARCHAR2,
508: X_Msg_Count OUT NOCOPY NUMBER,
501: --
502: PROCEDURE update_supp_code_conv_tbl(
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,
506: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
507: X_Return_Status OUT NOCOPY VARCHAR2,
508: X_Msg_Count OUT NOCOPY NUMBER,
509: X_Msg_Data OUT NOCOPY VARCHAR2,
502: PROCEDURE update_supp_code_conv_tbl(
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,
506: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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
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
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
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: --
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,
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,
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,
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,
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,
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