DBA Data[Home] [Help]

APPS.GL_JE_CATEGORIES_PKG dependencies on FND_GLOBAL

Line 239: where gcat.language = FND_GLOBAL.BASE_LANGUAGE

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
243: from gl_je_categories_tl gcat2,

Line 245: where gcat2.language = FND_GLOBAL.BASE_LANGUAGE

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
248: AND ( gcat2.user_je_category_name <> fcat2.name
249: or gcat2.description <> fcat2.description ) );

Line 613: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then

609: X_Consolidation_Flag => null);
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 );

Line 674: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then

670: and je_category_name = 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 );