1: package body AR_DUNNING_LETTERS_PKG as
2: /* $Header: ARPADLSB.pls 120.2.12000000.2 2007/05/16 11:38:09 tthangav ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
439: begin
440:
441: user_id := fnd_load_util.owner_id(X_OWNER);
442:
443: AR_DUNNING_LETTERS_PKG.UPDATE_ROW (
444: X_DUNNING_LETTER_ID => X_DUNNING_LETTER_ID,
445: X_STATUS => X_STATUS,
446: X_REVIEW_DATE => X_REVIEW_DATE,
447: X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
468:
469: exception
470: when NO_DATA_FOUND then
471:
472: AR_DUNNING_LETTERS_PKG.INSERT_ROW(
473: X_ROWID => row_id,
474: X_DUNNING_LETTER_ID => X_DUNNING_LETTER_ID,
475: X_STATUS => X_STATUS,
476: X_REVIEW_DATE => X_REVIEW_DATE,
523: and userenv('LANG') in (language, source_lang);
524:
525: END TRANSLATE_ROW;
526:
527: end AR_DUNNING_LETTERS_PKG;