DBA Data[Home] [Help]

APPS.GL_JE_CATEGORIES_PKG dependencies on GL_JE_CATEGORIES_PKG

Line 1: PACKAGE BODY GL_JE_CATEGORIES_PKG AS

1: PACKAGE BODY GL_JE_CATEGORIES_PKG AS
2: /* $Header: glijectb.pls 120.14 2005/05/05 01:09:27 kvora ship $ */
3:
4:
5: --

Line 19: -- gl_je_categories_pkg.select_row(recinfo)

15: -- 28-MAR-94 D. J. Ogg Created
16: -- Arguments
17: -- recinfo Various information about the row
18: -- Example
19: -- gl_je_categories_pkg.select_row(recinfo)
20: -- Notes
21: --
22: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_je_categories%ROWTYPE) IS
23: BEGIN

Line 64: 'GL_JE_CATEGORIES_PKG.check_unique');

60: RAISE;
61: WHEN OTHERS THEN
62: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
63: fnd_message.set_token('PROCEDURE',
64: 'GL_JE_CATEGORIES_PKG.check_unique');
65: RAISE;
66:
67: END check_unique;
68:

Line 99: 'GL_JE_CATEGORIES_PKG.check_unique_key');

95: RAISE;
96: WHEN OTHERS THEN
97: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
98: fnd_message.set_token('PROCEDURE',
99: 'GL_JE_CATEGORIES_PKG.check_unique_key');
100: RAISE;
101:
102: END check_unique_key;
103:

Line 132: 'GL_JE_CATEGORIES_PKG.get_unique_id');

128: RAISE;
129: WHEN OTHERS THEN
130: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
131: fnd_message.set_token('PROCEDURE',
132: 'GL_JE_CATEGORIES_PKG.get_unique_id');
133: RAISE;
134:
135: END get_unique_id;
136:

Line 177: 'GL_JE_CATEGORIES_PKG.insert_fnd_cat');

173: RAISE;
174: WHEN OTHERS THEN
175: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
176: fnd_message.set_token('PROCEDURE',
177: 'GL_JE_CATEGORIES_PKG.insert_fnd_cat');
178: RAISE;
179:
180: END insert_fnd_cat;
181:

Line 217: 'GL_JE_CATEGORIES_PKG.update_fnd_cat');

213: RAISE;
214: WHEN OTHERS THEN
215: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
216: fnd_message.set_token('PROCEDURE',
217: 'GL_JE_CATEGORIES_PKG.update_fnd_cat');
218: RAISE;
219:
220: END update_fnd_cat;
221:

Line 257: 'GL_JE_CATEGORIES_PKG.update_fnd_cat_all');

253: RAISE;
254: WHEN OTHERS THEN
255: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
256: fnd_message.set_token('PROCEDURE',
257: 'GL_JE_CATEGORIES_PKG.update_fnd_cat_all');
258: RAISE;
259:
260: END update_fnd_cat_all;
261:

Line 397: GL_JE_CATEGORIES_PKG.insert_other_cat( x_je_category_name,

393: RAISE NO_DATA_FOUND;
394: end if;
395: CLOSE C;
396:
397: GL_JE_CATEGORIES_PKG.insert_other_cat( x_je_category_name,
398: x_user_je_category_name,
399: x_description,
400: x_last_updated_by,
401: x_created_by,

Line 592: GL_JE_CATEGORIES_PKG.Update_Row(

588:
589: /* Update only if force_edits is 'Y' or if user_id = 1 */
590: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
591: -- update row in GL_JE_CATEGORIES_TL if present
592: GL_JE_CATEGORIES_PKG.Update_Row(
593: X_Rowid => v_rowid,
594: X_je_category_name => X_Je_Category_Name,
595: X_last_update_date => sysdate,
596: X_last_updated_by => user_id,

Line 614: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,

610:
611: -- update FND_DOC_SEQUENCE_CATEGORIES if change is made in
612: -- the base language
613: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then
614: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,
615: x_user_je_category_name,
616: x_description,
617: user_id );
618: end if;

Line 622: GL_JE_CATEGORIES_PKG.Insert_Row(

618: end if;
619: end if;
620: exception
621: when NO_DATA_FOUND then
622: GL_JE_CATEGORIES_PKG.Insert_Row(
623: X_Rowid => v_rowid,
624: X_je_category_name => X_Je_Category_Name,
625: X_language => v_language,
626: X_source_lang => v_source_lang,

Line 675: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,

671:
672: -- update FND_DOC_SEQUENCE_CATEGORIES if change is made in
673: -- the base language
674: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then
675: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,
676: x_user_je_category_name,
677: x_description,
678: user_id );
679: end if;

Line 769: END GL_JE_CATEGORIES_PKG;

765: end ADD_LANGUAGE;
766:
767: -- ************************************************************************
768:
769: END GL_JE_CATEGORIES_PKG;