[Home] [Help]
PACKAGE BODY: APPS.OZF_CODE_CONVERSION_PKG
Source
1 PACKAGE BODY OZF_Code_Conversion_PKG as
2 /* $Header: ozftsccb.pls 120.3 2007/12/21 07:44:26 gdeepika ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Code_Conversion_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19
20 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Code_Conversion_PKG';
21 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftsccb.pls';
22
23
24
25
26 -- ========================================================
27 --
28 -- NAME
29 -- Insert_Row
30 --
31 -- PURPOSE
32 --
33 -- NOTES
34 --
35 -- HISTORY
36 --
37 -- ========================================================
38 PROCEDURE Insert_Row(
39 px_code_conversion_id IN OUT NOCOPY NUMBER,
40 px_object_version_number IN OUT NOCOPY NUMBER,
41 p_last_update_date DATE,
42 p_last_updated_by NUMBER,
43 p_creation_date DATE,
44 p_created_by NUMBER,
45 p_last_update_login NUMBER,
46 px_org_id IN OUT NOCOPY NUMBER,
47 p_party_id NUMBER,
48 p_cust_account_id NUMBER,
49 p_code_conversion_type VARCHAR2,
50 p_external_code VARCHAR2,
51 p_internal_code VARCHAR2,
52 p_description VARCHAR2,
53 p_start_date_active DATE,
54 p_end_date_active DATE,
55 p_attribute_category VARCHAR2,
56 p_attribute1 VARCHAR2,
57 p_attribute2 VARCHAR2,
58 p_attribute3 VARCHAR2,
59 p_attribute4 VARCHAR2,
60 p_attribute5 VARCHAR2,
61 p_attribute6 VARCHAR2,
62 p_attribute7 VARCHAR2,
63 p_attribute8 VARCHAR2,
64 p_attribute9 VARCHAR2,
65 p_attribute10 VARCHAR2,
66 p_attribute11 VARCHAR2,
67 p_attribute12 VARCHAR2,
68 p_attribute13 VARCHAR2,
69 p_attribute14 VARCHAR2,
70 p_attribute15 VARCHAR2)
71
72 IS
73 x_rowid VARCHAR2(30);
74
75
76 BEGIN
77
78 -- R12 Enhancements
79 /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
80 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
81 INTO px_org_id
82 FROM DUAL;
83 END IF;
84 */
85
86 px_object_version_number := nvl(px_object_version_number, 1);
87
88
89 INSERT INTO ozf_code_conversions_all(
90 code_conversion_id,
91 object_version_number,
92 last_update_date,
93 last_updated_by,
94 creation_date,
95 created_by,
96 last_update_login,
97 org_id,
98 party_id,
99 cust_account_id,
100 code_conversion_type,
101 external_code,
102 internal_code,
103 description,
104 start_date_active,
105 end_date_active,
106 attribute_category,
107 attribute1,
108 attribute2,
109 attribute3,
110 attribute4,
111 attribute5,
112 attribute6,
113 attribute7,
114 attribute8,
115 attribute9,
116 attribute10,
117 attribute11,
118 attribute12,
119 attribute13,
120 attribute14,
121 attribute15
122 ) VALUES (
123 DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
124 DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
125 DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126 DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127 DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128 DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129 DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130 DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131 DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132 DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133 DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134 DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135 DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136 DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137 DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138 DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139 DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140 DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141 DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142 DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143 DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144 DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145 DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146 DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147 DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148 DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149 DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150 DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151 DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152 DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153 DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154 DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155
156 END Insert_Row;
157
158
159
160
161 -- ========================================================
162 --
163 -- NAME
164 -- Update_Row
165 --
166 -- PURPOSE
167 --
168 -- NOTES
169 --
170 -- HISTORY
171 --
172 -- ========================================================
173 PROCEDURE Update_Row(
174 p_code_conversion_id NUMBER,
175 p_object_version_number IN NUMBER,
176 p_last_update_date DATE,
177 p_last_updated_by NUMBER,
178 p_last_update_login NUMBER,
179 p_org_id NUMBER,
180 p_party_id NUMBER,
181 p_cust_account_id NUMBER,
182 p_code_conversion_type VARCHAR2,
183 p_external_code VARCHAR2,
184 p_internal_code VARCHAR2,
185 p_description VARCHAR2,
186 p_start_date_active DATE,
187 p_end_date_active DATE,
188 p_attribute_category VARCHAR2,
189 p_attribute1 VARCHAR2,
190 p_attribute2 VARCHAR2,
191 p_attribute3 VARCHAR2,
192 p_attribute4 VARCHAR2,
193 p_attribute5 VARCHAR2,
194 p_attribute6 VARCHAR2,
195 p_attribute7 VARCHAR2,
196 p_attribute8 VARCHAR2,
197 p_attribute9 VARCHAR2,
198 p_attribute10 VARCHAR2,
199 p_attribute11 VARCHAR2,
200 p_attribute12 VARCHAR2,
201 p_attribute13 VARCHAR2,
202 p_attribute14 VARCHAR2,
203 p_attribute15 VARCHAR2)
204
205 IS
206 BEGIN
207 Update ozf_code_conversions_all
208 SET
209 code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
210 object_version_number = nvl(p_object_version_number,0) + 1 ,
211 last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212 last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213 last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214 org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215 party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216 cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217 code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218 external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219 internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220 description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221 start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222 end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223 attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224 attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225 attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226 attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227 attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228 attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229 attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230 attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231 attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232 attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233 attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234 attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235 attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
236 attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
237 attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
238 attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
239 WHERE code_conversion_id = p_code_conversion_id
240 AND object_version_number = p_object_version_number;
241
242
243 IF (SQL%NOTFOUND) THEN
244 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245 END IF;
246
247
248 END Update_Row;
249
250
251
252
253 -- ========================================================
254 --
255 -- NAME
256 -- Delete_Row
257 --
258 -- PURPOSE
259 --
260 -- NOTES
261 --
262 -- HISTORY
263 --
264 -- ========================================================
265 PROCEDURE Delete_Row(
266 p_code_conversion_id NUMBER,
267 p_object_version_number NUMBER)
268 IS
269 BEGIN
270 DELETE FROM ozf_code_conversions_all
271 WHERE code_conversion_id = p_code_conversion_id
272 AND object_version_number = p_object_version_number;
273 If (SQL%NOTFOUND) then
274 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275 End If;
276 END Delete_Row ;
277
278
279 -- ========================================================
280 --
281 -- NAME
282 -- Insert_Supp_Code_Conv_Row
283 --
284 -- PURPOSE
285 --
286 -- NOTES
287 --
288 -- HISTORY
289 --
290 -- ========================================================
291 PROCEDURE Insert_Supp_Code_Conv_Row(
292 px_code_conversion_id IN OUT NOCOPY NUMBER,
293 px_object_version_number IN OUT NOCOPY NUMBER,
294 p_last_update_date DATE,
295 p_last_updated_by NUMBER,
296 p_creation_date DATE,
297 p_created_by NUMBER,
298 p_last_update_login NUMBER,
299 px_org_id IN OUT NOCOPY NUMBER,
300
301 p_supp_trade_profile_id NUMBER,
302 p_code_conversion_type VARCHAR2,
303 p_external_code VARCHAR2,
304 p_internal_code VARCHAR2,
305 p_description VARCHAR2,
306 p_start_date_active DATE,
307 p_end_date_active DATE,
308 p_attribute_category VARCHAR2,
309 p_attribute1 VARCHAR2,
310 p_attribute2 VARCHAR2,
311 p_attribute3 VARCHAR2,
312 p_attribute4 VARCHAR2,
313 p_attribute5 VARCHAR2,
314 p_attribute6 VARCHAR2,
315 p_attribute7 VARCHAR2,
316 p_attribute8 VARCHAR2,
317 p_attribute9 VARCHAR2,
318 p_attribute10 VARCHAR2,
322 p_attribute14 VARCHAR2,
319 p_attribute11 VARCHAR2,
320 p_attribute12 VARCHAR2,
321 p_attribute13 VARCHAR2,
323 p_attribute15 VARCHAR2)
324
325 IS
326 x_rowid VARCHAR2(30);
327
328
329 BEGIN
330
331 -- R12 Enhancements
332 /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
333 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
334 INTO px_org_id
335 FROM DUAL;
336 END IF;
337 */
338
339 px_object_version_number := nvl(px_object_version_number, 1);
340
341
342 INSERT INTO ozf_supp_code_conversions_all(
343 code_conversion_id,
344 object_version_number,
345 last_update_date,
346 last_updated_by,
347 creation_date,
348 created_by,
349 last_update_login,
350 org_id,
351 supp_trade_profile_id,
352 code_conversion_type,
353 external_code,
354 internal_code,
355 description,
356 start_date_active,
357 end_date_active,
358 attribute_category,
359 attribute1,
360 attribute2,
361 attribute3,
362 attribute4,
363 attribute5,
364 attribute6,
365 attribute7,
366 attribute8,
367 attribute9,
368 attribute10,
369 attribute11,
370 attribute12,
371 attribute13,
372 attribute14,
373 attribute15
374 ) VALUES (
375 DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
376 DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
377 DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
378 DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379 DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380 DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381 DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382 DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383 DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384 DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385 DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386 DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387 DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388 DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389 DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390 DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391 DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392 DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393 DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394 DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395 DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396 DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397 DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398 DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399 DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400 DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401 DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402 DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
403 DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
404 DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
405 DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
406
407 END Insert_Supp_Code_Conv_Row;
408
409
410
411
412 -- ========================================================
413 --
414 -- NAME
415 -- Update_Supp_Code_Conv_Row
416 --
417 -- PURPOSE
418 --
419 -- NOTES
420 --
421 -- HISTORY
422 --
423 -- ========================================================
424 PROCEDURE Update_Supp_Code_Conv_Row(
425 p_code_conversion_id NUMBER,
426 p_object_version_number IN NUMBER,
427 p_last_update_date DATE,
428 p_last_updated_by NUMBER,
429 p_last_update_login NUMBER,
430 p_org_id NUMBER,
431 p_supp_trade_profile_id NUMBER,
432 p_code_conversion_type VARCHAR2,
433 p_external_code VARCHAR2,
434 p_internal_code VARCHAR2,
435 p_description VARCHAR2,
436 p_start_date_active DATE,
437 p_end_date_active DATE,
438 p_attribute_category VARCHAR2,
439 p_attribute1 VARCHAR2,
440 p_attribute2 VARCHAR2,
441 p_attribute3 VARCHAR2,
442 p_attribute4 VARCHAR2,
443 p_attribute5 VARCHAR2,
444 p_attribute6 VARCHAR2,
445 p_attribute7 VARCHAR2,
446 p_attribute8 VARCHAR2,
447 p_attribute9 VARCHAR2,
448 p_attribute10 VARCHAR2,
449 p_attribute11 VARCHAR2,
450 p_attribute12 VARCHAR2,
451 p_attribute13 VARCHAR2,
452 p_attribute14 VARCHAR2,
453 p_attribute15 VARCHAR2)
454
455 IS
456 BEGIN
457 Update ozf_supp_code_conversions_all
458 SET
459 code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
460 object_version_number = nvl(p_object_version_number,0) + 1 ,
461 last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
462 last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
463 last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
464 org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465 supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466 code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467 external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468 internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469 description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470 start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471 end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472 attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473 attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474 attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475 attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476 attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477 attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478 attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479 attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480 attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481 attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482 attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483 attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484 attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
485 attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
486 attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
487 attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
488 WHERE code_conversion_id = p_code_conversion_id
489 AND object_version_number = p_object_version_number;
490
491
492 IF (SQL%NOTFOUND) THEN
496
493 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494 END IF;
495
497 END Update_Supp_Code_Conv_Row;
498
499
500
501
502 -- ========================================================
503 --
504 -- NAME
505 -- Delete_Supp_Code_Conv_Row
506 --
507 -- PURPOSE
508 --
509 -- NOTES
510 --
511 -- HISTORY
512 --
513 -- ========================================================
514 PROCEDURE Delete_Supp_Code_Conv_Row(
515 p_code_conversion_id NUMBER,
516 p_object_version_number NUMBER)
517 IS
518 BEGIN
519 DELETE FROM ozf_supp_code_conversions_all
520 WHERE code_conversion_id = p_code_conversion_id
521 AND object_version_number = p_object_version_number;
522 If (SQL%NOTFOUND) then
523 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524 End If;
525 END Delete_Supp_Code_Conv_Row ;
526
527
528
529
530 END OZF_Code_Conversion_PKG;
531