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 591: -- update row in GL_JE_CATEGORIES_TL if present

587: where je_category_name = X_je_category_name;
588:
589: /* Update only if force_edits is 'Y' or if user_id = 1 */
590: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
591: -- update row in GL_JE_CATEGORIES_TL if present
592: GL_JE_CATEGORIES_PKG.Update_Row(
593: X_Rowid => v_rowid,
594: X_je_category_name => X_Je_Category_Name,
595: X_last_update_date => sysdate,

Line 661: UPDATE GL_JE_CATEGORIES_TL

657: end if;
658:
659: /* Update only if force_edits is 'Y' or if user_id = 1 */
660: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
661: UPDATE GL_JE_CATEGORIES_TL
662: SET
663: user_je_category_name = x_user_je_category_name,
664: description = x_description,
665: last_update_date = sysdate,

Line 693: update GL_JE_CATEGORIES_TL T

689: procedure ADD_LANGUAGE
690: is
691: begin
692:
693: update GL_JE_CATEGORIES_TL T
694: set ( user_je_category_name,
695: DESCRIPTION )
696: = ( select
697: B.user_je_category_name,

Line 699: from gl_je_categories_tl B

695: DESCRIPTION )
696: = ( select
697: B.user_je_category_name,
698: B.DESCRIPTION
699: from gl_je_categories_tl B
700: where B.je_category_name = T.je_category_name
701: and B.LANGUAGE = T.SOURCE_LANG )
702: where ( T.je_category_name,
703: T.LANGUAGE ) in

Line 707: from gl_je_categories_tl SUBB,

703: T.LANGUAGE ) in
704: ( select
705: SUBT.je_category_name,
706: SUBT.LANGUAGE
707: from gl_je_categories_tl SUBB,
708: gl_je_categories_tl SUBT
709: where SUBB.je_category_name = SUBT.je_category_name
710: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
711: and (SUBB.USER_JE_CATEGORY_NAME <> SUBT.USER_JE_CATEGORY_NAME

Line 708: gl_je_categories_tl SUBT

704: ( select
705: SUBT.je_category_name,
706: SUBT.LANGUAGE
707: from gl_je_categories_tl SUBB,
708: gl_je_categories_tl SUBT
709: where SUBB.je_category_name = SUBT.je_category_name
710: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
711: and (SUBB.USER_JE_CATEGORY_NAME <> SUBT.USER_JE_CATEGORY_NAME
712: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 717: insert into gl_je_categories_tl (

713: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
714: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null))
715: );
716:
717: insert into gl_je_categories_tl (
718: je_category_name,
719: LAST_UPDATE_DATE,
720: LAST_UPDATED_BY,
721: CREATION_DATE,

Line 756: from gl_je_categories_tl B, FND_LANGUAGES L

752: B.attribute4,
753: B.attribute5,
754: B.context,
755: B.consolidation_flag
756: from gl_je_categories_tl B, FND_LANGUAGES L
757: where L.INSTALLED_FLAG in ('I', 'B')
758: and B.LANGUAGE = userenv('LANG')
759: and not exists
760: (select NULL

Line 761: from gl_je_categories_tl T

757: where L.INSTALLED_FLAG in ('I', 'B')
758: and B.LANGUAGE = userenv('LANG')
759: and not exists
760: (select NULL
761: from gl_je_categories_tl T
762: where T.je_category_name = B.je_category_name
763: and T.LANGUAGE = L.LANGUAGE_CODE);
764:
765: end ADD_LANGUAGE;