eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_DISPLAYCONTEXT_GRP dependencies on IBE_DSP_CONTEXT_TL

Line 147: INSERT INTO IBE_DSP_CONTEXT_TL (

143: l_deliverable_id,
144: p_display_context_rec.component_type_code);
145:
146: --- Insert into the TL table
147: INSERT INTO IBE_DSP_CONTEXT_TL (
148: CONTEXT_ID,
149: LAST_UPDATE_DATE,
150: LAST_UPDATED_BY,
151: CREATION_DATE,

Line 173: FROM IBE_DSP_CONTEXT_TL T

169: USERENV('LANG')
170: FROM FND_LANGUAGES L
171: WHERE L.INSTALLED_FLAG IN ('I', 'B')
172: AND NOT EXISTS (SELECT NULL
173: FROM IBE_DSP_CONTEXT_TL T
174: WHERE T.CONTEXT_ID = l_context_id
175: AND T.language = L.LANGUAGE_CODE);
176:
177: p_display_context_rec.context_id := l_context_id;

Line 197: UPDATE IBE_DSP_CONTEXT_TL

193: AND OBJECT_VERSION_NUMBER =
194: p_display_context_rec.object_version_number;
195:
196: --- Update the TL table
197: UPDATE IBE_DSP_CONTEXT_TL
198: SET NAME = DECODE( p_display_context_rec.display_name,
199: FND_API.G_MISS_CHAR, NAME,
200: p_display_context_rec.display_name),
201: DESCRIPTION = decode( p_display_context_rec.description,

Line 324: DELETE FROM IBE_DSP_CONTEXT_TL

320: AND OBJECT_VERSION_NUMBER= p_display_context_rec.object_version_number;
321:
322: p_display_context_rec.context_id := null;
323:
324: DELETE FROM IBE_DSP_CONTEXT_TL
325: WHERE CONTEXT_ID = p_display_context_rec.context_id;
326:
327: --Delete all entries from ibe_dsp_obj_lgl_ctnt which use the context_id
328: IBE_LogicalContent_GRP.delete_context(p_display_context_rec.context_id);

Line 600: INSERT INTO IBE_DSP_CONTEXT_TL (

596: X_LAST_UPDATED_BY,
597: X_LAST_UPDATE_LOGIN,
598: X_COMPONENT_TYPE_CODE);
599:
600: INSERT INTO IBE_DSP_CONTEXT_TL (
601: CONTEXT_ID,
602: OBJECT_VERSION_NUMBER,
603: CREATED_BY,
604: CREATION_DATE,

Line 628: FROM IBE_DSP_CONTEXT_TL T

624: FROM FND_LANGUAGES L
625: WHERE L.INSTALLED_FLAG in ('I', 'B')
626: AND NOT EXISTS(
627: SELECT NULL
628: FROM IBE_DSP_CONTEXT_TL T
629: WHERE T.CONTEXT_ID = X_CONTEXT_ID
630: AND T.LANGUAGE = L.LANGUAGE_CODE);
631: OPEN c;
632: FETCH c INTO X_ROWID;

Line 668: FROM IBE_DSP_CONTEXT_TL

664: CURSOR c1 IS
665: SELECT NAME,
666: DESCRIPTION,
667: DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') baselang
668: FROM IBE_DSP_CONTEXT_TL
669: WHERE CONTEXT_ID = X_CONTEXT_ID
670: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
671: FOR UPDATE OF CONTEXT_ID NOWAIT;
672: BEGIN

Line 748: UPDATE IBE_DSP_CONTEXT_TL

744: THEN
745: RAISE no_data_found;
746: END IF;
747:
748: UPDATE IBE_DSP_CONTEXT_TL
749: SET NAME = X_NAME,
750: DESCRIPTION = X_DESCRIPTION,
751: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
752: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 769: DELETE FROM IBE_DSP_CONTEXT_TL

765: ---- Start DELETE_ROW Procedure -----+
766: PROCEDURE DELETE_ROW (X_CONTEXT_ID IN NUMBER )
767: IS
768: BEGIN
769: DELETE FROM IBE_DSP_CONTEXT_TL
770: WHERE CONTEXT_ID = X_CONTEXT_ID;
771:
772: IF (sql%notfound)
773: THEN

Line 807: UPDATE ibe_dsp_context_tl

803:
804: -- Translate char last_update_date to date
805: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
806:
807: UPDATE ibe_dsp_context_tl
808: SET language = USERENV('LANG'),
809: source_lang = USERENV('LANG'),
810: name = X_NAME,
811: description = X_DESCRIPTION,

Line 922: DELETE FROM IBE_DSP_CONTEXT_TL T

918:
919: PROCEDURE ADD_LANGUAGE
920: IS
921: BEGIN
922: DELETE FROM IBE_DSP_CONTEXT_TL T
923: WHERE NOT EXISTS(
924: SELECT NULL
925: FROM IBE_DSP_CONTEXT_B B
926: WHERE B.CONTEXT_ID = T.CONTEXT_ID );

Line 928: UPDATE IBE_DSP_CONTEXT_TL T

924: SELECT NULL
925: FROM IBE_DSP_CONTEXT_B B
926: WHERE B.CONTEXT_ID = T.CONTEXT_ID );
927:
928: UPDATE IBE_DSP_CONTEXT_TL T
929: SET (NAME,DESCRIPTION) =
930: (SELECT B.NAME,
931: B.DESCRIPTION
932: FROM IBE_DSP_CONTEXT_TL B

Line 932: FROM IBE_DSP_CONTEXT_TL B

928: UPDATE IBE_DSP_CONTEXT_TL T
929: SET (NAME,DESCRIPTION) =
930: (SELECT B.NAME,
931: B.DESCRIPTION
932: FROM IBE_DSP_CONTEXT_TL B
933: WHERE B.CONTEXT_ID = T.CONTEXT_ID
934: AND B.LANGUAGE = T.SOURCE_LANG)
935: WHERE (T.CONTEXT_ID,T.LANGUAGE) IN
936: (SELECT SUBT.CONTEXT_ID,

Line 938: FROM IBE_DSP_CONTEXT_TL SUBB,

934: AND B.LANGUAGE = T.SOURCE_LANG)
935: WHERE (T.CONTEXT_ID,T.LANGUAGE) IN
936: (SELECT SUBT.CONTEXT_ID,
937: SUBT.LANGUAGE
938: FROM IBE_DSP_CONTEXT_TL SUBB,
939: IBE_DSP_CONTEXT_TL SUBT
940: WHERE SUBB.CONTEXT_ID = SUBT.CONTEXT_ID
941: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
942: AND (SUBB.NAME <> SUBT.NAME OR

Line 939: IBE_DSP_CONTEXT_TL SUBT

935: WHERE (T.CONTEXT_ID,T.LANGUAGE) IN
936: (SELECT SUBT.CONTEXT_ID,
937: SUBT.LANGUAGE
938: FROM IBE_DSP_CONTEXT_TL SUBB,
939: IBE_DSP_CONTEXT_TL SUBT
940: WHERE SUBB.CONTEXT_ID = SUBT.CONTEXT_ID
941: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
942: AND (SUBB.NAME <> SUBT.NAME OR
943: (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)

Line 950: INSERT INTO IBE_DSP_CONTEXT_TL (

946: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
947: OR (SUBB.DESCRIPTION IS NOT NULL AND
948: SUBT.DESCRIPTION IS NULL)));
949:
950: INSERT INTO IBE_DSP_CONTEXT_TL (
951: CONTEXT_ID,
952: OBJECT_VERSION_NUMBER,
953: CREATED_BY,
954: CREATION_DATE,

Line 975: IBE_DSP_CONTEXT_TL B,

971: B.DESCRIPTION,
972: L.LANGUAGE_CODE,
973: B.SOURCE_LANG
974: FROM
975: IBE_DSP_CONTEXT_TL B,
976: FND_LANGUAGES L
977: WHERE L.INSTALLED_FLAG IN ('I', 'B')
978: AND B.LANGUAGE = USERENV('LANG')
979: AND NOT EXISTS

Line 981: FROM IBE_DSP_CONTEXT_TL T

977: WHERE L.INSTALLED_FLAG IN ('I', 'B')
978: AND B.LANGUAGE = USERENV('LANG')
979: AND NOT EXISTS
980: (SELECT NULL
981: FROM IBE_DSP_CONTEXT_TL T
982: WHERE T.CONTEXT_ID = B.CONTEXT_ID
983: AND T.LANGUAGE = L.LANGUAGE_CODE);
984: END ADD_LANGUAGE;
985: