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 566: UPDATE GL_JE_SOURCES_TL

562: end if;
563:
564: /* Update only if force_edits is 'Y' or user_id = 1 */
565: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
566: UPDATE GL_JE_SOURCES_TL
567: SET
568: user_je_source_name = x_user_je_source_name,
569: description = x_description,
570: last_update_date = sysdate,

Line 589: update GL_JE_SOURCES_TL T

585: is
586: begin
587:
588:
589: update GL_JE_SOURCES_TL T
590: set ( user_je_source_name,
591: DESCRIPTION )
592: = ( select
593: B.user_je_source_name,

Line 595: from gl_je_sources_tl B

591: DESCRIPTION )
592: = ( select
593: B.user_je_source_name,
594: B.DESCRIPTION
595: from gl_je_sources_tl B
596: where B.je_source_name = T.je_source_name
597: and B.LANGUAGE = T.SOURCE_LANG )
598: where ( T.je_source_name,
599: T.LANGUAGE ) in

Line 603: from gl_je_sources_tl SUBB,

599: T.LANGUAGE ) in
600: ( select
601: SUBT.je_source_name,
602: SUBT.LANGUAGE
603: from gl_je_sources_tl SUBB,
604: gl_je_sources_tl SUBT
605: where SUBB.je_source_name = SUBT.je_source_name
606: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
607: and (SUBB.USER_JE_SOURCE_NAME <> SUBT.USER_JE_SOURCE_NAME

Line 604: gl_je_sources_tl SUBT

600: ( select
601: SUBT.je_source_name,
602: SUBT.LANGUAGE
603: from gl_je_sources_tl SUBB,
604: gl_je_sources_tl SUBT
605: where SUBB.je_source_name = SUBT.je_source_name
606: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
607: and (SUBB.USER_JE_SOURCE_NAME <> SUBT.USER_JE_SOURCE_NAME
608: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 613: insert into gl_je_sources_tl (

609: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
610: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null))
611: );
612:
613: insert into gl_je_sources_tl (
614: je_source_name,
615: LAST_UPDATE_DATE,
616: LAST_UPDATED_BY,
617: CREATION_DATE,

Line 660: from gl_je_sources_tl B, FND_LANGUAGES L

656: B.attribute3,
657: B.attribute4,
658: B.attribute5,
659: B.context
660: from gl_je_sources_tl B, FND_LANGUAGES L
661: where L.INSTALLED_FLAG in ('I', 'B')
662: and B.LANGUAGE = userenv('LANG')
663: and not exists
664: (select NULL

Line 665: from gl_je_sources_tl T

661: where L.INSTALLED_FLAG in ('I', 'B')
662: and B.LANGUAGE = userenv('LANG')
663: and not exists
664: (select NULL
665: from gl_je_sources_tl T
666: where T.je_source_name = B.je_source_name
667: and T.LANGUAGE = L.LANGUAGE_CODE);
668:
669: end ADD_LANGUAGE;