eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_JE_CATEGORIES_PKG dependencies on GL_JE_CATEGORIES

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 22: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_je_categories%ROWTYPE) IS

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
24: SELECT *
25: INTO recinfo
26: FROM gl_je_categories

Line 26: FROM gl_je_categories

22: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_je_categories%ROWTYPE) IS
23: BEGIN
24: SELECT *
25: INTO recinfo
26: FROM gl_je_categories
27: WHERE je_category_name = recinfo.je_category_name;
28: END SELECT_ROW;
29:
30:

Line 39: FROM gl_je_categories cat

35: PROCEDURE check_unique( x_rowid VARCHAR2,
36: x_name VARCHAR2 ) IS
37: CURSOR c_dup IS
38: SELECT 'Duplicate'
39: FROM gl_je_categories cat
40: WHERE cat.user_je_category_name = x_name
41: AND ( x_rowid is NULL
42: OR
43: cat.rowid <> x_rowid );

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 74: FROM gl_je_categories cat

70: PROCEDURE check_unique_key( x_rowid VARCHAR2,
71: x_key VARCHAR2 ) IS
72: CURSOR c_dup IS
73: SELECT 'Duplicate'
74: FROM gl_je_categories cat
75: WHERE cat.je_category_key = x_key
76: AND ( x_rowid is NULL
77: OR
78: cat.rowid <> x_rowid );

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 108: SELECT gl_je_categories_s.NEXTVAL

104: -- ************************************************************************
105:
106: FUNCTION get_unique_id RETURN NUMBER IS
107: CURSOR c_getid IS
108: SELECT gl_je_categories_s.NEXTVAL
109: FROM dual;
110: id number;
111:
112: BEGIN

Line 122: fnd_message.set_token('SEQUENCE', 'gl_je_categories_s');

118: RETURN( id );
119: ELSE
120: CLOSE c_getid;
121: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
122: fnd_message.set_token('SEQUENCE', 'gl_je_categories_s');
123: app_exception.raise_exception;
124: END IF;
125:
126: EXCEPTION

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 238: from gl_je_categories_tl gcat

234: ( select gcat.description,
235: sysdate,
236: x_last_updated_by,
237: gcat.user_je_category_name
238: from gl_je_categories_tl gcat
239: where gcat.language = FND_GLOBAL.BASE_LANGUAGE
240: AND gcat.je_category_name = fcat.code )
241: WHERE fcat.application_id = 101
242: and fcat.code in ( select fcat2.code

Line 243: from gl_je_categories_tl gcat2,

239: where gcat.language = FND_GLOBAL.BASE_LANGUAGE
240: AND gcat.je_category_name = fcat.code )
241: WHERE fcat.application_id = 101
242: and fcat.code in ( select fcat2.code
243: from gl_je_categories_tl gcat2,
244: fnd_doc_sequence_categories fcat2
245: where gcat2.language = FND_GLOBAL.BASE_LANGUAGE
246: AND fcat2.application_id = 101
247: AND gcat2.je_category_name = fcat2.code

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 293: recinfo gl_je_categories%ROWTYPE;

289: PROCEDURE select_columns(
290: x_je_category_name VARCHAR2,
291: x_user_je_category_name IN OUT NOCOPY VARCHAR2 ) IS
292:
293: recinfo gl_je_categories%ROWTYPE;
294:
295: BEGIN
296: recinfo.je_category_name := x_je_category_name;
297:

Line 326: FROM gl_je_categories_tl

322: X_Attribute5 VARCHAR2,
323: X_Context VARCHAR2,
324: X_Consolidation_Flag VARCHAR2) IS
325: CURSOR C IS SELECT rowid, language, source_lang
326: FROM gl_je_categories_tl
327: WHERE je_category_name = X_Je_Category_Name
328: and Language = userenv('LANG');
329: BEGIN
330:

Line 337: UPDATE GL_JE_CATEGORIES_TL

333: RAISE NO_DATA_FOUND;
334: end if;
335:
336: -- update previously existing columns
337: UPDATE GL_JE_CATEGORIES_TL
338: SET
339: consolidation_flag = UPPER(x_consolidation_flag)
340: WHERE
341: je_category_name = X_je_category_name;

Line 344: INSERT INTO GL_JE_CATEGORIES_TL(

340: WHERE
341: je_category_name = X_je_category_name;
342:
343: -- insert new columns
344: INSERT INTO GL_JE_CATEGORIES_TL(
345: je_category_name,
346: language,
347: source_lang,
348: last_update_date,

Line 386: from GL_JE_CATEGORIES_TL B

382: FROM FND_LANGUAGES L
383: WHERE L.Installed_Flag in ('I', 'B')
384: AND not exists
385: ( select NULL
386: from GL_JE_CATEGORIES_TL B
387: where B.Je_Category_Name = X_Je_Category_Name
388: and B.Language = L.Language_Code);
389: OPEN C;
390: FETCH C INTO X_Rowid, X_Language, X_Source_lang;

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 421: SELECT * FROM GL_JE_CATEGORIES_TL

417: X_Attribute5 VARCHAR2,
418: X_Context VARCHAR2,
419: X_Consolidation_Flag VARCHAR2) IS
420: CURSOR C IS
421: SELECT * FROM GL_JE_CATEGORIES_TL
422: WHERE je_category_name = X_je_category_name
423: and Language = userenv('LANG')
424: FOR UPDATE OF JE_CATEGORY_NAME NOWAIT;
425: Recinfo C%ROWTYPE;

Line 506: UPDATE GL_JE_CATEGORIES_TL

502: X_Context VARCHAR2,
503: X_Consolidation_Flag VARCHAR2) IS
504: BEGIN
505: -- update non-translatable columns
506: UPDATE GL_JE_CATEGORIES_TL
507: SET
508: je_category_name = x_je_category_name,
509: je_category_key = x_je_category_key,
510: last_update_date = x_last_update_date,

Line 529: UPDATE GL_JE_CATEGORIES_TL

525: RAISE NO_DATA_FOUND;
526: end if;
527:
528: -- update the translatable columns
529: UPDATE GL_JE_CATEGORIES_TL
530: SET
531: user_je_category_name = x_user_je_category_name,
532: description = x_description,
533: source_lang = userenv('LANG')

Line 583: SELECT gl_je_categories_s.NEXTVAL

579:
580: begin
581: /* When je_category_name is null, we assume it to be a new row. */
582: if (X_je_category_name is null) then
583: SELECT gl_je_categories_s.NEXTVAL
584: INTO X_je_category_name
585: FROM dual;
586: raise no_data_found;
587: end if;

Line 593: from gl_je_categories

589: /* Check if the row exists in the database. If it does, retrieves
590: the creation date for update_row. */
591: /* select creation_date
592: into v_creation_date
593: from gl_je_categories
594: where je_category_name = X_je_category_name;*/
595:
596: /*Modified as part of bug13037565*/
597: select creation_date,

Line 611: from gl_je_categories

607: v_attribute3,
608: v_attribute4,
609: v_attribute5,
610: v_context
611: from gl_je_categories
612: where je_category_name = X_je_category_name;
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

Line 616: -- update row in GL_JE_CATEGORIES_TL if present

612: where je_category_name = X_je_category_name;
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,

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 687: UPDATE GL_JE_CATEGORIES_TL

683: end if;
684:
685: /* Update only if force_edits is 'Y' or if user_id = 1 */
686: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
687: UPDATE GL_JE_CATEGORIES_TL
688: SET
689: user_je_category_name = x_user_je_category_name,
690: description = x_description,
691: last_update_date = sysdate,

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 719: update GL_JE_CATEGORIES_TL T

715: procedure ADD_LANGUAGE
716: is
717: begin
718:
719: update GL_JE_CATEGORIES_TL T
720: set ( user_je_category_name,
721: DESCRIPTION )
722: = ( select
723: B.user_je_category_name,

Line 725: from gl_je_categories_tl B

721: DESCRIPTION )
722: = ( select
723: B.user_je_category_name,
724: B.DESCRIPTION
725: from gl_je_categories_tl B
726: where B.je_category_name = T.je_category_name
727: and B.LANGUAGE = T.SOURCE_LANG )
728: where ( T.je_category_name,
729: T.LANGUAGE ) in

Line 733: from gl_je_categories_tl SUBB,

729: T.LANGUAGE ) in
730: ( select
731: SUBT.je_category_name,
732: SUBT.LANGUAGE
733: from gl_je_categories_tl SUBB,
734: gl_je_categories_tl SUBT
735: where SUBB.je_category_name = SUBT.je_category_name
736: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
737: and (SUBB.USER_JE_CATEGORY_NAME <> SUBT.USER_JE_CATEGORY_NAME

Line 734: gl_je_categories_tl SUBT

730: ( select
731: SUBT.je_category_name,
732: SUBT.LANGUAGE
733: from gl_je_categories_tl SUBB,
734: gl_je_categories_tl SUBT
735: where SUBB.je_category_name = SUBT.je_category_name
736: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
737: and (SUBB.USER_JE_CATEGORY_NAME <> SUBT.USER_JE_CATEGORY_NAME
738: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 743: insert into gl_je_categories_tl (

739: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
740: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null))
741: );
742:
743: insert into gl_je_categories_tl (
744: je_category_name,
745: LAST_UPDATE_DATE,
746: LAST_UPDATED_BY,
747: CREATION_DATE,

Line 782: from gl_je_categories_tl B, FND_LANGUAGES L

778: B.attribute4,
779: B.attribute5,
780: B.context,
781: B.consolidation_flag
782: from gl_je_categories_tl B, FND_LANGUAGES L
783: where L.INSTALLED_FLAG in ('I', 'B')
784: and B.LANGUAGE = userenv('LANG')
785: and not exists
786: (select NULL

Line 787: from gl_je_categories_tl T

783: where L.INSTALLED_FLAG in ('I', 'B')
784: and B.LANGUAGE = userenv('LANG')
785: and not exists
786: (select NULL
787: from gl_je_categories_tl T
788: where T.je_category_name = B.je_category_name
789: and T.LANGUAGE = L.LANGUAGE_CODE);
790:
791: end ADD_LANGUAGE;

Line 795: END GL_JE_CATEGORIES_PKG;

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