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.FND_OAM_MET_GRPS_PKG dependencies on FND_OAM_MET_GRPS_TL

Line 40: from fnd_oam_met_grps_tl

36: db_ludate date; -- entity update date in db
37:
38: cursor c1 is
39: select last_updated_by, last_update_date
40: from fnd_oam_met_grps_tl
41: where metric_group_id = to_number(X_METRIC_GROUP_ID)
42: order by last_update_date asc;
43: begin
44: -- Translate owner to file_last_updated_by

Line 55: from fnd_oam_met_grps_tl

51: -- added for bug fix 2507658
52: -- check if this metric group id already exists.
53: select metric_group_id
54: into mgroup_id
55: from fnd_oam_met_grps_tl
56: where metric_group_id = to_number(X_METRIC_GROUP_ID)
57: and rownum = 1;
58:
59: -- obtain the last update stamp; pick the first row

Line 68: --from fnd_oam_met_grps_tl

64: end loop;
65:
66: --select metric_group_id,LAST_UPDATED_BY, LAST_UPDATE_DATE
67: --into mgroup_id, db_luby, db_ludate
68: --from fnd_oam_met_grps_tl
69: --where metric_group_id = to_number(X_METRIC_GROUP_ID)
70: --and LANGUAGE = userenv('LANG');
71:
72: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 142: from fnd_oam_met_grps_tl

138:
139: begin
140: select LAST_UPDATED_BY, LAST_UPDATE_DATE
141: into db_luby, db_ludate
142: from fnd_oam_met_grps_tl
143: where metric_group_id = to_number(X_METRIC_GROUP_ID)
144: and LANGUAGE = userenv('LANG');
145:
146: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 148: update fnd_oam_met_grps_tl set

144: and LANGUAGE = userenv('LANG');
145:
146: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
147: db_ludate, X_CUSTOM_MODE)) then
148: update fnd_oam_met_grps_tl set
149: metric_group_display_name = nvl(X_METRIC_GROUP_DISPLAY_NAME, metric_group_display_name),
150: description = nvl(X_DESCRIPTION, description),
151: source_lang = userenv('LANG'),
152: last_update_date = f_ludate,

Line 177: cursor C is select ROWID from FND_OAM_MET_GRPS_TL

173: X_LAST_UPDATED_BY in NUMBER,
174: X_LAST_UPDATE_DATE in DATE,
175: X_LAST_UPDATE_LOGIN in NUMBER)
176: is
177: cursor C is select ROWID from FND_OAM_MET_GRPS_TL
178: where METRIC_GROUP_ID = X_METRIC_GROUP_ID;
179: begin
180: insert into FND_OAM_MET_GRPS_TL (
181: METRIC_GROUP_ID,

Line 180: insert into FND_OAM_MET_GRPS_TL (

176: is
177: cursor C is select ROWID from FND_OAM_MET_GRPS_TL
178: where METRIC_GROUP_ID = X_METRIC_GROUP_ID;
179: begin
180: insert into FND_OAM_MET_GRPS_TL (
181: METRIC_GROUP_ID,
182: SEQUENCE,
183: METRIC_GROUP_DISPLAY_NAME,
184: DESCRIPTION,

Line 208: from FND_OAM_MET_GRPS_TL T

204: from FND_LANGUAGES L
205: where L.INSTALLED_FLAG in ('I', 'B')
206: and not exists
207: (select NULL
208: from FND_OAM_MET_GRPS_TL T
209: where T.METRIC_GROUP_ID = X_METRIC_GROUP_ID
210: and T.LANGUAGE = L.LANGUAGE_CODE);
211:
212: open c;

Line 231: update FND_OAM_MET_GRPS_TL set

227: X_LAST_UPDATED_BY in NUMBER,
228: X_LAST_UPDATE_LOGIN in NUMBER
229: ) is
230: begin
231: update FND_OAM_MET_GRPS_TL set
232: SEQUENCE = X_SEQUENCE,
233: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
234: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
235: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 238: update FND_OAM_MET_GRPS_TL set

234: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
235: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
236: where METRIC_GROUP_ID = X_METRIC_GROUP_ID;
237:
238: update FND_OAM_MET_GRPS_TL set
239: METRIC_GROUP_DISPLAY_NAME = X_METRIC_GROUP_DISPLAY_NAME,
240: DESCRIPTION = X_DESCRIPTION,
241: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
242: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 257: delete from FND_OAM_MET_GRPS_TL

253: procedure DELETE_ROW (
254: X_METRIC_GROUP_ID in NUMBER
255: ) is
256: begin
257: delete from FND_OAM_MET_GRPS_TL
258: where METRIC_GROUP_ID = X_METRIC_GROUP_ID;
259:
260: if (sql%notfound) then
261: raise no_data_found;

Line 275: update FND_OAM_MET_GRPS_TL T set (

271: /* as a quick workaround to fix the time-consuming table handler issue */
272: /* Eventually we'll need to turn them into a separate fix_language procedure */
273: /*
274:
275: update FND_OAM_MET_GRPS_TL T set (
276: SEQUENCE,
277: METRIC_GROUP_DISPLAY_NAME,
278: DESCRIPTION
279: ) = (select

Line 283: from FND_OAM_MET_GRPS_TL B

279: ) = (select
280: B.SEQUENCE,
281: B.METRIC_GROUP_DISPLAY_NAME,
282: B.DESCRIPTION
283: from FND_OAM_MET_GRPS_TL B
284: where B.METRIC_GROUP_ID = T.METRIC_GROUP_ID
285: and B.LANGUAGE = T.SOURCE_LANG)
286: where (
287: T.METRIC_GROUP_ID,

Line 292: from FND_OAM_MET_GRPS_TL SUBB, FND_OAM_MET_GRPS_TL SUBT

288: T.LANGUAGE
289: ) in (select
290: SUBT.METRIC_GROUP_ID,
291: SUBT.LANGUAGE
292: from FND_OAM_MET_GRPS_TL SUBB, FND_OAM_MET_GRPS_TL SUBT
293: where SUBB.METRIC_GROUP_ID = SUBT.METRIC_GROUP_ID
294: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
295: and (SUBB.METRIC_GROUP_DISPLAY_NAME <> SUBT.METRIC_GROUP_DISPLAY_NAME
296: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 302: insert into FND_OAM_MET_GRPS_TL (

298: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
299: ));
300: */
301:
302: insert into FND_OAM_MET_GRPS_TL (
303: METRIC_GROUP_ID,
304: SEQUENCE,
305: METRIC_GROUP_DISPLAY_NAME,
306: DESCRIPTION,

Line 326: from FND_OAM_MET_GRPS_TL B, FND_LANGUAGES L

322: B.LAST_UPDATE_DATE,
323: B.LAST_UPDATE_LOGIN,
324: L.LANGUAGE_CODE,
325: B.SOURCE_LANG
326: from FND_OAM_MET_GRPS_TL B, FND_LANGUAGES L
327: where L.INSTALLED_FLAG in ('I', 'B')
328: and B.LANGUAGE = userenv('LANG')
329: and not exists
330: (select NULL

Line 331: from FND_OAM_MET_GRPS_TL T

327: where L.INSTALLED_FLAG in ('I', 'B')
328: and B.LANGUAGE = userenv('LANG')
329: and not exists
330: (select NULL
331: from FND_OAM_MET_GRPS_TL T
332: where T.METRIC_GROUP_ID = B.METRIC_GROUP_ID
333: and T.LANGUAGE = L.LANGUAGE_CODE);
334: end ADD_LANGUAGE;
335: