APPS.GL_JE_SOURCES_PKG dependencies on GL_JE_SOURCES_TL

Line 202: FROM GL_JE_SOURCES_TL

198: X_Attribute4 VARCHAR2,
199: X_Attribute5 VARCHAR2,
200: X_Context VARCHAR2) IS
201: CURSOR C IS SELECT rowid, language, source_lang
202: FROM GL_JE_SOURCES_TL
203: WHERE je_source_name = X_Je_Source_Name
204: and Language = userenv('LANG');
205: CURSOR C2 IS SELECT gl_je_headers_s.nextval FROM dual;
206: BEGIN

Line 213: INSERT INTO GL_JE_SOURCES_TL(

209: OPEN C2;
210: FETCH C2 INTO X_Je_Source_Name;
211: CLOSE C2;
212: end if;
213: INSERT INTO GL_JE_SOURCES_TL(
214: je_source_name,
215: je_source_key,
216: language,
217: source_lang,

Line 264: from GL_JE_SOURCES_TL B

260: FROM FND_LANGUAGES L
261: WHERE L.Installed_Flag in ('I', 'B')
262: AND not exists
263: ( select NULL
264: from GL_JE_SOURCES_TL B
265: where B.Je_Source_Name = X_Je_Source_Name
266: and B.Language = L.Language_Code);
267: OPEN C;
268: FETCH C INTO X_Rowid, X_Language, X_Source_Lang;

Line 294: SELECT * FROM GL_JE_SOURCES_TL

290: X_Attribute4 VARCHAR2,
291: X_Attribute5 VARCHAR2,
292: X_Context VARCHAR2) IS
293: CURSOR C IS
294: SELECT * FROM GL_JE_SOURCES_TL
295: WHERE Je_Source_Name = X_Je_Source_Name
296: and Language = userenv('LANG')
297: FOR UPDATE OF JE_SOURCE_NAME NOWAIT;
298: Recinfo C%ROWTYPE;

Line 398: UPDATE GL_JE_SOURCES_TL

394: X_Attribute5 VARCHAR2,
395: X_Context VARCHAR2) IS
396: BEGIN
397: -- update non-translatable columns
398: UPDATE GL_JE_SOURCES_TL
399: SET
400: je_source_name = x_je_source_name,
401: je_source_key = x_je_source_key,
402: override_edits_flag = x_override_edits_flag,

Line 425: UPDATE GL_JE_SOURCES_TL

421: RAISE NO_DATA_FOUND;
422: end if;
423:
424: -- update the translatable columns
425: UPDATE GL_JE_SOURCES_TL
426: SET
427: user_je_source_name = x_user_je_source_name,
428: description = x_description,
429: source_lang = userenv('LANG')

Line 440: DELETE FROM GL_JE_SOURCES_TL

436: END Update_Row;
437:
438: PROCEDURE Delete_Row(X_Je_Source_Name VARCHAR2) IS
439: BEGIN
440: DELETE FROM GL_JE_SOURCES_TL
441: WHERE Je_Source_Name = X_Je_Source_Name;
442:
443: if (SQL%NOTFOUND) then
444: RAISE NO_DATA_FOUND;

Line 592: UPDATE GL_JE_SOURCES_TL

588: end if;
589:
590: /* Update only if force_edits is 'Y' or user_id = 1 */
591: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
592: UPDATE GL_JE_SOURCES_TL
593: SET
594: user_je_source_name = x_user_je_source_name,
595: description = x_description,
596: last_update_date = sysdate,

Line 615: update GL_JE_SOURCES_TL T

611: is
612: begin
613:
614:
615: update GL_JE_SOURCES_TL T
616: set ( user_je_source_name,
617: DESCRIPTION )
618: = ( select
619: B.user_je_source_name,

Line 621: from gl_je_sources_tl B

617: DESCRIPTION )
618: = ( select
619: B.user_je_source_name,
620: B.DESCRIPTION
621: from gl_je_sources_tl B
622: where B.je_source_name = T.je_source_name
623: and B.LANGUAGE = T.SOURCE_LANG )
624: where ( T.je_source_name,
625: T.LANGUAGE ) in

Line 629: from gl_je_sources_tl SUBB,

625: T.LANGUAGE ) in
626: ( select
627: SUBT.je_source_name,
628: SUBT.LANGUAGE
629: from gl_je_sources_tl SUBB,
630: gl_je_sources_tl SUBT
631: where SUBB.je_source_name = SUBT.je_source_name
632: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
633: and (SUBB.USER_JE_SOURCE_NAME <> SUBT.USER_JE_SOURCE_NAME

Line 630: gl_je_sources_tl SUBT

626: ( select
627: SUBT.je_source_name,
628: SUBT.LANGUAGE
629: from gl_je_sources_tl SUBB,
630: gl_je_sources_tl SUBT
631: where SUBB.je_source_name = SUBT.je_source_name
632: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
633: and (SUBB.USER_JE_SOURCE_NAME <> SUBT.USER_JE_SOURCE_NAME
634: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 639: insert into gl_je_sources_tl (

635: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
636: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null))
637: );
638:
639: insert into gl_je_sources_tl (
640: je_source_name,
641: LAST_UPDATE_DATE,
642: LAST_UPDATED_BY,
643: CREATION_DATE,

Line 686: from gl_je_sources_tl B, FND_LANGUAGES L

682: B.attribute3,
683: B.attribute4,
684: B.attribute5,
685: B.context
686: from gl_je_sources_tl B, FND_LANGUAGES L
687: where L.INSTALLED_FLAG in ('I', 'B')
688: and B.LANGUAGE = userenv('LANG')
689: and not exists
690: (select NULL

Line 691: from gl_je_sources_tl T

687: where L.INSTALLED_FLAG in ('I', 'B')
688: and B.LANGUAGE = userenv('LANG')
689: and not exists
690: (select NULL
691: from gl_je_sources_tl T
692: where T.je_source_name = B.je_source_name
693: and T.LANGUAGE = L.LANGUAGE_CODE);
694:
695: end ADD_LANGUAGE;