APPS.GL_JE_CATEGORIES_PKG dependencies on GL_JE_CATEGORIES_TL

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 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 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 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 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 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;