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.JTF_DISPLAYCONTEXT_GRP dependencies on JTF_DSP_CONTEXT_TL

Line 170: insert into JTF_DSP_CONTEXT_TL (

166: p_display_context_rec.context_type,
167: l_deliverable_id);
168:
169: --- Insert into the TL table
170: insert into JTF_DSP_CONTEXT_TL (
171: CONTEXT_ID,
172: LAST_UPDATE_DATE,
173: LAST_UPDATED_BY,
174: CREATION_DATE,

Line 198: from JTF_DSP_CONTEXT_TL T

194: from FND_LANGUAGES L
195: where L.INSTALLED_FLAG in ('I', 'B')
196: and not exists
197: (select NULL
198: from JTF_DSP_CONTEXT_TL T
199: where T.CONTEXT_ID =l_context_id
200: and T.LANGUAGE = L.LANGUAGE_CODE);
201: p_display_context_rec.context_id := l_context_id;
202: p_display_context_rec.object_version_number := 1;

Line 220: update JTF_DSP_CONTEXT_TL set

216: CONTEXT_ID = p_display_context_rec.context_id and
217: OBJECT_VERSION_NUMBER = p_display_context_rec.object_version_number;
218: --- Update the TL table
219:
220: update JTF_DSP_CONTEXT_TL set
221: NAME = decode( p_display_context_rec.display_name,
222: FND_API.G_MISS_CHAR, NAME, p_display_context_rec.display_name),
223: DESCRIPTION = decode( p_display_context_rec.description,
224: FND_API.G_MISS_CHAR, DESCRIPTION, p_display_context_rec.description),

Line 360: DELETE FROM JTF_DSP_CONTEXT_TL WHERE

356: OBJECT_VERSION_NUMBER= p_display_context_rec.object_version_number;
357:
358: p_display_context_rec.context_id := null;
359:
360: DELETE FROM JTF_DSP_CONTEXT_TL WHERE
361: CONTEXT_ID = p_display_context_rec.context_id;
362:
363: --- Delete all entries from jtf_dsp_obj_lgl_ctnt which use the context_id
364: JTF_LogicalContent_GRP.delete_context(p_display_context_rec.context_id);

Line 645: insert into JTF_DSP_CONTEXT_TL (

641: X_LAST_UPDATED_BY,
642: X_LAST_UPDATE_LOGIN
643: );
644:
645: insert into JTF_DSP_CONTEXT_TL (
646: SECURITY_GROUP_ID,
647: CONTEXT_ID,
648: OBJECT_VERSION_NUMBER,
649: CREATED_BY,

Line 675: from JTF_DSP_CONTEXT_TL T

671: from FND_LANGUAGES L
672: where L.INSTALLED_FLAG in ('I', 'B')
673: and not exists
674: (select NULL
675: from JTF_DSP_CONTEXT_TL T
676: where T.CONTEXT_ID = X_CONTEXT_ID
677: and T.LANGUAGE = L.LANGUAGE_CODE);
678:
679: open c;

Line 719: from JTF_DSP_CONTEXT_TL

715: cursor c1 is select
716: NAME,
717: DESCRIPTION,
718: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
719: from JTF_DSP_CONTEXT_TL
720: where CONTEXT_ID = X_CONTEXT_ID
721: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
722: for update of CONTEXT_ID nowait;
723: begin

Line 797: update JTF_DSP_CONTEXT_TL set

793: if (sql%notfound) then
794: raise no_data_found;
795: end if;
796:
797: update JTF_DSP_CONTEXT_TL set
798: NAME = X_NAME,
799: DESCRIPTION = X_DESCRIPTION,
800: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
801: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 820: delete from JTF_DSP_CONTEXT_TL

816: procedure DELETE_ROW (
817: X_CONTEXT_ID in NUMBER
818: ) is
819: begin
820: delete from JTF_DSP_CONTEXT_TL
821: where CONTEXT_ID = X_CONTEXT_ID;
822:
823: if (sql%notfound) then
824: raise no_data_found;

Line 847: update jtf_dsp_context_tl

843: X_DESCRIPTION in VARCHAR2 ) is
844:
845: begin
846:
847: update jtf_dsp_context_tl
848: set language = USERENV('LANG'),
849: source_lang = USERENV('LANG'),
850: name = X_NAME,
851: description = X_DESCRIPTION,

Line 921: delete from JTF_DSP_CONTEXT_TL T

917:
918: procedure ADD_LANGUAGE
919: is
920: begin
921: delete from JTF_DSP_CONTEXT_TL T
922: where not exists
923: (select NULL
924: from JTF_DSP_CONTEXT_B B
925: where B.CONTEXT_ID = T.CONTEXT_ID

Line 928: update JTF_DSP_CONTEXT_TL T set (

924: from JTF_DSP_CONTEXT_B B
925: where B.CONTEXT_ID = T.CONTEXT_ID
926: );
927:
928: update JTF_DSP_CONTEXT_TL T set (
929: NAME,
930: DESCRIPTION
931: ) = (select
932: B.NAME,

Line 934: from JTF_DSP_CONTEXT_TL B

930: DESCRIPTION
931: ) = (select
932: B.NAME,
933: B.DESCRIPTION
934: from JTF_DSP_CONTEXT_TL B
935: where B.CONTEXT_ID = T.CONTEXT_ID
936: and B.LANGUAGE = T.SOURCE_LANG)
937: where (
938: T.CONTEXT_ID,

Line 943: from JTF_DSP_CONTEXT_TL SUBB, JTF_DSP_CONTEXT_TL SUBT

939: T.LANGUAGE
940: ) in (select
941: SUBT.CONTEXT_ID,
942: SUBT.LANGUAGE
943: from JTF_DSP_CONTEXT_TL SUBB, JTF_DSP_CONTEXT_TL SUBT
944: where SUBB.CONTEXT_ID = SUBT.CONTEXT_ID
945: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
946: and (SUBB.NAME <> SUBT.NAME
947: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 954: insert into JTF_DSP_CONTEXT_TL (

950: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
951: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
952: ));
953:
954: insert into JTF_DSP_CONTEXT_TL (
955: CONTEXT_ID,
956: OBJECT_VERSION_NUMBER,
957: CREATED_BY,
958: CREATION_DATE,

Line 978: from JTF_DSP_CONTEXT_TL B, FND_LANGUAGES L

974: B.NAME,
975: B.DESCRIPTION,
976: L.LANGUAGE_CODE,
977: B.SOURCE_LANG
978: from JTF_DSP_CONTEXT_TL B, FND_LANGUAGES L
979: where L.INSTALLED_FLAG in ('I', 'B')
980: and B.LANGUAGE = userenv('LANG')
981: and not exists
982: (select NULL

Line 983: from JTF_DSP_CONTEXT_TL T

979: where L.INSTALLED_FLAG in ('I', 'B')
980: and B.LANGUAGE = userenv('LANG')
981: and not exists
982: (select NULL
983: from JTF_DSP_CONTEXT_TL T
984: where T.CONTEXT_ID = B.CONTEXT_ID
985: and T.LANGUAGE = L.LANGUAGE_CODE);
986:
987: end ADD_LANGUAGE;