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.FRM_REP_TEMPLATE_ALIASES_PKG dependencies on FRM_REP_TEMPLATE_ALIASES_TL

Line 44: insert into FRM_REP_TEMPLATE_ALIASES_TL (

40: X_LAST_UPDATED_BY,
41: X_LAST_UPDATE_LOGIN
42: );
43:
44: insert into FRM_REP_TEMPLATE_ALIASES_TL (
45: APPLICATION_SHORT_NAME,
46: CONCURRENT_PROGRAM_NAME,
47: ELEMENT_NAME,
48: USER_NAME,

Line 72: from FRM_REP_TEMPLATE_ALIASES_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from FRM_REP_TEMPLATE_ALIASES_TL T
73: where T.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
74: and T.CONCURRENT_PROGRAM_NAME = X_CONCURRENT_PROGRAM_NAME
75: and T.ELEMENT_NAME = X_ELEMENT_NAME
76: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 107: from FRM_REP_TEMPLATE_ALIASES_TL

103:
104: cursor c1 is select
105: USER_NAME,
106: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
107: from FRM_REP_TEMPLATE_ALIASES_TL
108: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
109: and CONCURRENT_PROGRAM_NAME = X_CONCURRENT_PROGRAM_NAME
110: and ELEMENT_NAME = X_ELEMENT_NAME
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 168: update FRM_REP_TEMPLATE_ALIASES_TL set

164: if (sql%notfound) then
165: raise no_data_found;
166: end if;
167:
168: update FRM_REP_TEMPLATE_ALIASES_TL set
169: USER_NAME = X_USER_NAME,
170: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
171: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
172: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 190: delete from FRM_REP_TEMPLATE_ALIASES_TL

186: X_CONCURRENT_PROGRAM_NAME in VARCHAR2,
187: X_ELEMENT_NAME in VARCHAR2
188: ) is
189: begin
190: delete from FRM_REP_TEMPLATE_ALIASES_TL
191: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
192: and CONCURRENT_PROGRAM_NAME = X_CONCURRENT_PROGRAM_NAME
193: and ELEMENT_NAME = X_ELEMENT_NAME;
194:

Line 212: delete from FRM_REP_TEMPLATE_ALIASES_TL T

208:
209: procedure ADD_LANGUAGE
210: is
211: begin
212: delete from FRM_REP_TEMPLATE_ALIASES_TL T
213: where not exists
214: (select NULL
215: from FRM_REP_TEMPLATE_ALIASES_B B
216: where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME

Line 221: update FRM_REP_TEMPLATE_ALIASES_TL T set (

217: and B.CONCURRENT_PROGRAM_NAME = T.CONCURRENT_PROGRAM_NAME
218: and B.ELEMENT_NAME = T.ELEMENT_NAME
219: );
220:
221: update FRM_REP_TEMPLATE_ALIASES_TL T set (
222: USER_NAME
223: ) = (select
224: B.USER_NAME
225: from FRM_REP_TEMPLATE_ALIASES_TL B

Line 225: from FRM_REP_TEMPLATE_ALIASES_TL B

221: update FRM_REP_TEMPLATE_ALIASES_TL T set (
222: USER_NAME
223: ) = (select
224: B.USER_NAME
225: from FRM_REP_TEMPLATE_ALIASES_TL B
226: where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME
227: and B.CONCURRENT_PROGRAM_NAME = T.CONCURRENT_PROGRAM_NAME
228: and B.ELEMENT_NAME = T.ELEMENT_NAME
229: and B.LANGUAGE = T.SOURCE_LANG)

Line 240: from FRM_REP_TEMPLATE_ALIASES_TL SUBB, FRM_REP_TEMPLATE_ALIASES_TL SUBT

236: SUBT.APPLICATION_SHORT_NAME,
237: SUBT.CONCURRENT_PROGRAM_NAME,
238: SUBT.ELEMENT_NAME,
239: SUBT.LANGUAGE
240: from FRM_REP_TEMPLATE_ALIASES_TL SUBB, FRM_REP_TEMPLATE_ALIASES_TL SUBT
241: where SUBB.APPLICATION_SHORT_NAME = SUBT.APPLICATION_SHORT_NAME
242: and SUBB.CONCURRENT_PROGRAM_NAME = SUBT.CONCURRENT_PROGRAM_NAME
243: and SUBB.ELEMENT_NAME = SUBT.ELEMENT_NAME
244: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 248: insert into FRM_REP_TEMPLATE_ALIASES_TL (

244: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
245: and (SUBB.USER_NAME <> SUBT.USER_NAME
246: ));
247:
248: insert into FRM_REP_TEMPLATE_ALIASES_TL (
249: APPLICATION_SHORT_NAME,
250: CONCURRENT_PROGRAM_NAME,
251: ELEMENT_NAME,
252: USER_NAME,

Line 272: from FRM_REP_TEMPLATE_ALIASES_TL B, FND_LANGUAGES L

268: B.LAST_UPDATE_LOGIN,
269: B.LAST_UPDATE_DATE,
270: L.LANGUAGE_CODE,
271: B.SOURCE_LANG
272: from FRM_REP_TEMPLATE_ALIASES_TL B, FND_LANGUAGES L
273: where L.INSTALLED_FLAG in ('I', 'B')
274: and B.LANGUAGE = userenv('LANG')
275: and not exists
276: (select NULL

Line 277: from FRM_REP_TEMPLATE_ALIASES_TL T

273: where L.INSTALLED_FLAG in ('I', 'B')
274: and B.LANGUAGE = userenv('LANG')
275: and not exists
276: (select NULL
277: from FRM_REP_TEMPLATE_ALIASES_TL T
278: where T.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME
279: and T.CONCURRENT_PROGRAM_NAME = B.CONCURRENT_PROGRAM_NAME
280: and T.ELEMENT_NAME = B.ELEMENT_NAME
281: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 400: from FRM_REP_TEMPLATE_ALIASES_TL

396: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
397: begin
398: select LAST_UPDATED_BY, LAST_UPDATE_DATE
399: into db_luby, db_ludate
400: from FRM_REP_TEMPLATE_ALIASES_TL
401: where APPLICATION_SHORT_NAME = x_application_short_name
402: and CONCURRENT_PROGRAM_NAME = x_concurrent_program_name
403: and ELEMENT_NAME = x_element_name
404: and LANGUAGE = userenv('LANG');

Line 410: update FRM_REP_TEMPLATE_ALIASES_TL

406: -- Test for customization and version
407: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
408: db_ludate, x_custom_mode)) then
409:
410: update FRM_REP_TEMPLATE_ALIASES_TL
411: set USER_NAME = x_user_name,
412: LAST_UPDATE_DATE = f_ludate,
413: LAST_UPDATED_BY = f_luby,
414: LAST_UPDATE_LOGIN = 0,