[Home] [Help]
1: PACKAGE BODY xla_acct_attributes_f_pkg AS
2: /* $Header: xlathess.pkb 120.6.12010000.1 2008/07/29 10:09:32 appldev ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |
48: WHERE accounting_attribute_code = x_accounting_attribute_code
49: ;
50:
51: BEGIN
52: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.insert_row' ,20);
53:
54: INSERT INTO xla_acct_attributes_b
55: (creation_date
56: ,created_by
117: RAISE NO_DATA_FOUND;
118: END IF;
119: CLOSE c;
120:
121: xla_utility_pkg.trace('< xla_acct_attributes_f_pkg.insert_row' ,20);
122: END insert_row;
123:
124: /*======================================================================+
125: | |
163: AND USERENV('LANG') IN (language ,source_lang)
164: FOR UPDATE OF accounting_attribute_code NOWAIT;
165:
166: BEGIN
167: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.lock_row' ,20);
168:
169: OPEN c;
170: FETCH c INTO recinfo;
171:
204: END IF;
205: END LOOP;
206:
207:
208: xla_utility_pkg.trace('< xla_acct_attributes_f_pkg.lock_row' ,20);
209: RETURN;
210:
211: END lock_row;
212:
231:
232: IS
233:
234: BEGIN
235: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.update_row' ,20);
236: UPDATE xla_acct_attributes_b
237: SET
238: last_update_date = x_last_update_date
239: ,assignment_required_code = x_assignment_required_code
264: IF (SQL%NOTFOUND) THEN
265: RAISE NO_DATA_FOUND;
266: END IF;
267:
268: xla_utility_pkg.trace('< xla_acct_attributes_f_pkg.update_row' ,20);
269: END update_row;
270:
271: /*======================================================================+
272: | |
278:
279: IS
280:
281: BEGIN
282: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.delete_row' ,20);
283: DELETE FROM xla_acct_attributes_tl
284: WHERE accounting_attribute_code = x_accounting_attribute_code;
285:
286:
296: RAISE NO_DATA_FOUND;
297: END IF;
298:
299:
300: xla_utility_pkg.trace('< xla_acct_attributes_f_pkg.delete_row' ,20);
301: END delete_row;
302:
303: /*======================================================================+
304: | |
309:
310: IS
311:
312: BEGIN
313: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.add_language' ,20);
314:
315: DELETE FROM xla_acct_attributes_tl T
316: WHERE NOT EXISTS
317: (SELECT NULL
365: FROM xla_acct_attributes_tl t
366: WHERE t.accounting_attribute_code = b.accounting_attribute_code
367: AND t.language = l.language_code);
368:
369: xla_utility_pkg.trace('< xla_acct_attributes_f_pkg.add_language' ,20);
370: END add_language;
371:
372: /*======================================================================+
373: | |
415: WHERE accounting_attribute_code = p_accounting_attribute_code;
416:
417: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
418: db_ludate, null)) then
419: xla_acct_attributes_f_pkg.update_row
420: (x_accounting_attribute_code => p_accounting_attribute_code
421: ,x_journal_entry_level_code => p_journal_entry_level_code
422: ,x_datatype_code => p_datatype_code
423: ,x_assignment_required_code => p_assignment_required_code
434:
435: EXCEPTION
436:
437: WHEN NO_DATA_FOUND THEN
438: xla_acct_attributes_f_pkg.insert_row
439: (x_rowid => l_rowid
440: ,x_accounting_attribute_code => p_accounting_attribute_code
441: ,x_journal_entry_level_code => p_journal_entry_level_code
442: ,x_datatype_code => p_datatype_code
458: WHEN NO_DATA_FOUND THEN
459: null;
460: WHEN OTHERS THEN
461: xla_exceptions_pkg.raise_message
462: (p_location => 'xla_acct_attributes_f_pkg.load_row');
463:
464: END load_row;
465:
466: /*======================================================================+
517:
518:
519: END translate_row;
520:
521: end xla_acct_attributes_f_PKG;