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 639: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then

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

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

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