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_CHARTS_PKG dependencies on FND_OAM_CHARTS

Line 1: PACKAGE BODY FND_OAM_CHARTS_PKG AS

1: PACKAGE BODY FND_OAM_CHARTS_PKG AS
2: /* $Header: AFOAMCTB.pls 115.1 2004/04/14 04:33:25 bhosingh noship $ */
3: procedure LOAD_ROW (
4: X_CHART_ID in NUMBER,
5: X_CHART_GROUP_ID in NUMBER,

Line 16: FND_OAM_CHARTS_PKG.LOAD_ROW (

12: X_CHART_NAME in VARCHAR2,
13: X_DESCRIPTION in VARCHAR2) is
14: begin
15:
16: FND_OAM_CHARTS_PKG.LOAD_ROW (
17: X_CHART_ID => X_CHART_ID,
18: X_CHART_GROUP_ID => X_CHART_GROUP_ID,
19: X_DISPLAY_ORDER => X_DISPLAY_ORDER,
20: X_ALLOW_CONFIG => X_ALLOW_CONFIG,

Line 64: from fnd_oam_charts

60: begin
61: -- check if this chart id already exists.
62: select chart_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
63: into mgroup_id, db_luby, db_ludate
64: from fnd_oam_charts
65: where chart_id = to_number(X_CHART_ID);
66:
67: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
68: db_ludate, X_CUSTOM_MODE)) then

Line 69: FND_OAM_CHARTS_PKG.UPDATE_ROW (

65: where chart_id = to_number(X_CHART_ID);
66:
67: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
68: db_ludate, X_CUSTOM_MODE)) then
69: FND_OAM_CHARTS_PKG.UPDATE_ROW (
70: X_CHART_ID => mgroup_id,
71: X_CHART_GROUP_ID => to_number(X_CHART_GROUP_ID),
72: X_DISPLAY_ORDER => to_number(X_DISPLAY_ORDER),
73: X_ALLOW_CONFIG => X_ALLOW_CONFIG,

Line 86: FND_OAM_CHARTS_PKG.INSERT_ROW (

82: end if;
83: exception
84: when NO_DATA_FOUND then
85:
86: FND_OAM_CHARTS_PKG.INSERT_ROW (
87: X_ROWID => row_id,
88: X_CHART_ID => to_number(X_CHART_ID),
89: X_CHART_GROUP_ID => to_number(X_CHART_GROUP_ID),
90: X_DISPLAY_ORDER => to_number(X_DISPLAY_ORDER),

Line 112: FND_OAM_CHARTS_PKG.translate_row(

108: X_DESCRIPTION in VARCHAR2,
109: X_OWNER in VARCHAR2) is
110: begin
111:
112: FND_OAM_CHARTS_PKG.translate_row(
113: X_CHART_ID => X_CHART_ID,
114: X_CHART_NAME => X_CHART_NAME,
115: x_description => x_description,
116: x_owner => x_owner,

Line 147: from fnd_oam_charts_tl

143:
144: begin
145: select LAST_UPDATED_BY, LAST_UPDATE_DATE
146: into db_luby, db_ludate
147: from fnd_oam_charts_tl
148: where chart_id = to_number(X_CHART_ID)
149: and LANGUAGE = userenv('LANG');
150:
151: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 153: update fnd_oam_charts_tl set

149: and LANGUAGE = userenv('LANG');
150:
151: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
152: db_ludate, X_CUSTOM_MODE)) then
153: update fnd_oam_charts_tl set
154: chart_name = nvl(X_CHART_NAME, chart_name),
155: description = nvl(X_DESCRIPTION, description),
156: source_lang = userenv('LANG'),
157: last_update_date = f_ludate,

Line 187: cursor C is select ROWID from FND_OAM_CHARTS

183: X_LAST_UPDATE_DATE in DATE,
184: X_LAST_UPDATED_BY in NUMBER,
185: X_LAST_UPDATE_LOGIN in NUMBER
186: ) is
187: cursor C is select ROWID from FND_OAM_CHARTS
188: where CHART_ID = X_CHART_ID
189: ;
190: begin
191: insert into FND_OAM_CHARTS (

Line 191: insert into FND_OAM_CHARTS (

187: cursor C is select ROWID from FND_OAM_CHARTS
188: where CHART_ID = X_CHART_ID
189: ;
190: begin
191: insert into FND_OAM_CHARTS (
192: CHART_ID,
193: CHART_GROUP_ID,
194: DISPLAY_ORDER,
195: ALLOW_CONFIG,

Line 219: insert into FND_OAM_CHARTS_TL (

215: X_LAST_UPDATED_BY,
216: X_LAST_UPDATE_LOGIN
217: );
218:
219: insert into FND_OAM_CHARTS_TL (
220: CHART_ID,
221: CHART_NAME,
222: DESCRIPTION,
223: CREATED_BY,

Line 245: from FND_OAM_CHARTS_TL T

241: from FND_LANGUAGES L
242: where L.INSTALLED_FLAG in ('I', 'B')
243: and not exists
244: (select NULL
245: from FND_OAM_CHARTS_TL T
246: where T.CHART_ID = X_CHART_ID
247: and T.LANGUAGE = L.LANGUAGE_CODE);
248:
249: open c;

Line 277: from FND_OAM_CHARTS

273: ALLOW_CONFIG,
274: REFRESH_INTERVAL,
275: REFRESH_TYPE,
276: CHART_TYPE
277: from FND_OAM_CHARTS
278: where CHART_ID = X_CHART_ID
279: for update of CHART_ID nowait;
280: recinfo c%rowtype;
281:

Line 286: from FND_OAM_CHARTS_TL

282: cursor c1 is select
283: CHART_NAME,
284: DESCRIPTION,
285: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
286: from FND_OAM_CHARTS_TL
287: where CHART_ID = X_CHART_ID
288: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
289: for update of CHART_ID nowait;
290: begin

Line 342: update FND_OAM_CHARTS set

338: X_LAST_UPDATED_BY in NUMBER,
339: X_LAST_UPDATE_LOGIN in NUMBER
340: ) is
341: begin
342: update FND_OAM_CHARTS set
343: CHART_GROUP_ID = X_CHART_GROUP_ID,
344: DISPLAY_ORDER = X_DISPLAY_ORDER,
345: ALLOW_CONFIG = X_ALLOW_CONFIG,
346: REFRESH_INTERVAL = X_REFRESH_INTERVAL,

Line 358: update FND_OAM_CHARTS_TL set

354: if (sql%notfound) then
355: raise no_data_found;
356: end if;
357:
358: update FND_OAM_CHARTS_TL set
359: CHART_NAME = X_CHART_NAME,
360: DESCRIPTION = X_DESCRIPTION,
361: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
362: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 377: delete from FND_OAM_CHARTS_TL

373: procedure DELETE_ROW (
374: X_CHART_ID in NUMBER
375: ) is
376: begin
377: delete from FND_OAM_CHARTS_TL
378: where CHART_ID = X_CHART_ID;
379:
380: if (sql%notfound) then
381: raise no_data_found;

Line 384: delete from FND_OAM_CHARTS

380: if (sql%notfound) then
381: raise no_data_found;
382: end if;
383:
384: delete from FND_OAM_CHARTS
385: where CHART_ID = X_CHART_ID;
386:
387: if (sql%notfound) then
388: raise no_data_found;

Line 400: delete from FND_OAM_CHARTS_TL T

396: /* The following update statements are commented out */
397: /* as a quick workaround to fix the time-consuming table handler issue */
398: /* Eventually we'll need to turn them into a separate fix_language procedure */
399: /*
400: delete from FND_OAM_CHARTS_TL T
401: where not exists
402: (select NULL
403: from FND_OAM_CHARTS B
404: where B.CHART_ID = T.CHART_ID

Line 403: from FND_OAM_CHARTS B

399: /*
400: delete from FND_OAM_CHARTS_TL T
401: where not exists
402: (select NULL
403: from FND_OAM_CHARTS B
404: where B.CHART_ID = T.CHART_ID
405: );
406:
407: update FND_OAM_CHARTS_TL T set (

Line 407: update FND_OAM_CHARTS_TL T set (

403: from FND_OAM_CHARTS B
404: where B.CHART_ID = T.CHART_ID
405: );
406:
407: update FND_OAM_CHARTS_TL T set (
408: CHART_NAME,
409: DESCRIPTION
410: ) = (select
411: B.CHART_NAME,

Line 413: from FND_OAM_CHARTS_TL B

409: DESCRIPTION
410: ) = (select
411: B.CHART_NAME,
412: B.DESCRIPTION
413: from FND_OAM_CHARTS_TL B
414: where B.CHART_ID = T.CHART_ID
415: and B.LANGUAGE = T.SOURCE_LANG)
416: where (
417: T.CHART_ID,

Line 422: from FND_OAM_CHARTS_TL SUBB, FND_OAM_CHARTS_TL SUBT

418: T.LANGUAGE
419: ) in (select
420: SUBT.CHART_ID,
421: SUBT.LANGUAGE
422: from FND_OAM_CHARTS_TL SUBB, FND_OAM_CHARTS_TL SUBT
423: where SUBB.CHART_ID = SUBT.CHART_ID
424: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
425: and (SUBB.CHART_NAME <> SUBT.CHART_NAME
426: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 431: insert into FND_OAM_CHARTS_TL (

427: ));
428:
429: */
430:
431: insert into FND_OAM_CHARTS_TL (
432: CHART_ID,
433: CHART_NAME,
434: DESCRIPTION,
435: CREATED_BY,

Line 453: from FND_OAM_CHARTS_TL B, FND_LANGUAGES L

449: B.LAST_UPDATE_DATE,
450: B.LAST_UPDATE_LOGIN,
451: L.LANGUAGE_CODE,
452: B.SOURCE_LANG
453: from FND_OAM_CHARTS_TL B, FND_LANGUAGES L
454: where L.INSTALLED_FLAG in ('I', 'B')
455: and B.LANGUAGE = userenv('LANG')
456: and not exists
457: (select NULL

Line 458: from FND_OAM_CHARTS_TL T

454: where L.INSTALLED_FLAG in ('I', 'B')
455: and B.LANGUAGE = userenv('LANG')
456: and not exists
457: (select NULL
458: from FND_OAM_CHARTS_TL T
459: where T.CHART_ID = B.CHART_ID
460: and T.LANGUAGE = L.LANGUAGE_CODE);
461: end ADD_LANGUAGE;
462:

Line 463: end FND_OAM_CHARTS_PKG;

459: where T.CHART_ID = B.CHART_ID
460: and T.LANGUAGE = L.LANGUAGE_CODE);
461: end ADD_LANGUAGE;
462:
463: end FND_OAM_CHARTS_PKG;