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.15 2011/11/03 06:10:28 skotakar 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 617: GL_JE_CATEGORIES_PKG.Update_Row(

613:
614: /* Update only if force_edits is 'Y' or if user_id = 1 */
615: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
616: -- update row in GL_JE_CATEGORIES_TL if present
617: GL_JE_CATEGORIES_PKG.Update_Row(
618: X_Rowid => v_rowid,
619: X_je_category_name => X_Je_Category_Name,
620: X_last_update_date => sysdate,
621: X_last_updated_by => user_id,

Line 640: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,

636:
637: -- update FND_DOC_SEQUENCE_CATEGORIES if change is made in
638: -- the base language
639: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then
640: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,
641: x_user_je_category_name,
642: x_description,
643: user_id );
644: end if;

Line 648: GL_JE_CATEGORIES_PKG.Insert_Row(

644: end if;
645: end if;
646: exception
647: when NO_DATA_FOUND then
648: GL_JE_CATEGORIES_PKG.Insert_Row(
649: X_Rowid => v_rowid,
650: X_je_category_name => X_Je_Category_Name,
651: X_language => v_language,
652: X_source_lang => v_source_lang,

Line 701: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,

697:
698: -- update FND_DOC_SEQUENCE_CATEGORIES if change is made in
699: -- the base language
700: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then
701: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,
702: x_user_je_category_name,
703: x_description,
704: user_id );
705: end if;

Line 795: END GL_JE_CATEGORIES_PKG;

791: end ADD_LANGUAGE;
792:
793: -- ************************************************************************
794:
795: END GL_JE_CATEGORIES_PKG;