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_CHART_ITEMS_PKG dependencies on FND_OAM_CHART_ITEMS

Line 1: PACKAGE BODY FND_OAM_CHART_ITEMS_PKG AS

1: PACKAGE BODY FND_OAM_CHART_ITEMS_PKG AS
2: /* $Header: AFOAMCIB.pls 120.1 2005/07/02 04:12:38 appldev noship $ */
3: procedure LOAD_ROW (
4: X_CHART_ITEM_SHORT_NAME in VARCHAR2,
5: X_USER_ID in NUMBER,

Line 13: FND_OAM_CHART_ITEMS_PKG.LOAD_ROW (

9: X_CHART_ITEM_NAME in VARCHAR2,
10: X_DESCRIPTION in VARCHAR2) is
11: begin
12:
13: FND_OAM_CHART_ITEMS_PKG.LOAD_ROW (
14: X_CHART_ITEM_SHORT_NAME => X_CHART_ITEM_SHORT_NAME,
15: X_USER_ID => X_USER_ID,
16: X_CHART_ID => X_CHART_ID,
17: X_SELECTED => X_SELECTED,

Line 54: from fnd_oam_chart_items

50: begin
51: -- check if this chart id already exists.
52: select LAST_UPDATED_BY, LAST_UPDATE_DATE
53: into db_luby, db_ludate
54: from fnd_oam_chart_items
55: where chart_item_short_name = X_CHART_ITEM_SHORT_NAME
56: AND USER_ID = TO_NUMBER(X_USER_ID)
57: AND CHART_ID = TO_NUMBER(X_CHART_ID);
58:

Line 61: FND_OAM_CHART_ITEMS_PKG.UPDATE_ROW (

57: AND CHART_ID = TO_NUMBER(X_CHART_ID);
58:
59: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
60: db_ludate, X_CUSTOM_MODE)) then
61: FND_OAM_CHART_ITEMS_PKG.UPDATE_ROW (
62: X_CHART_ITEM_SHORT_NAME => X_CHART_ITEM_SHORT_NAME,
63: X_USER_ID => to_number(X_USER_ID),
64: X_CHART_ID => to_number(X_CHART_ID),
65: X_SELECTED => X_SELECTED,

Line 75: FND_OAM_CHART_ITEMS_PKG.INSERT_ROW (

71: end if;
72: exception
73: when NO_DATA_FOUND then
74:
75: FND_OAM_CHART_ITEMS_PKG.INSERT_ROW (
76: X_ROWID => row_id,
77: X_CHART_ITEM_SHORT_NAME => X_CHART_ITEM_SHORT_NAME,
78: X_USER_ID => to_number(X_USER_ID),
79: X_CHART_ID => to_number(X_CHART_ID),

Line 98: FND_OAM_CHART_ITEMS_PKG.translate_row(

94: X_DESCRIPTION in VARCHAR2,
95: X_OWNER in VARCHAR2) is
96: begin
97:
98: FND_OAM_CHART_ITEMS_PKG.translate_row(
99: X_CHART_ITEM_SHORT_NAME => X_CHART_ITEM_SHORT_NAME,
100: X_CHART_ITEM_NAME => X_CHART_ITEM_NAME,
101: x_description => x_description,
102: x_owner => x_owner,

Line 133: from fnd_oam_chart_items_tl

129:
130: begin
131: select LAST_UPDATED_BY, LAST_UPDATE_DATE
132: into db_luby, db_ludate
133: from fnd_oam_chart_items_tl
134: where chart_item_short_name = X_CHART_ITEM_SHORT_NAME
135: and LANGUAGE = userenv('LANG');
136:
137: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 139: update fnd_oam_chart_items_tl set

135: and LANGUAGE = userenv('LANG');
136:
137: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
138: db_ludate, X_CUSTOM_MODE)) then
139: update fnd_oam_chart_items_tl set
140: chart_item_name = nvl(X_CHART_ITEM_NAME, chart_item_name),
141: description = nvl(X_DESCRIPTION, description),
142: source_lang = userenv('LANG'),
143: last_update_date = f_ludate,

Line 170: cursor C is select ROWID from FND_OAM_CHART_ITEMS

166: X_LAST_UPDATE_DATE in DATE,
167: X_LAST_UPDATED_BY in NUMBER,
168: X_LAST_UPDATE_LOGIN in NUMBER
169: ) is
170: cursor C is select ROWID from FND_OAM_CHART_ITEMS
171: where CHART_ITEM_SHORT_NAME = X_CHART_ITEM_SHORT_NAME
172: and USER_ID = X_USER_ID
173: and CHART_ID = X_CHART_ID
174: ;

Line 177: insert into FND_OAM_CHART_ITEMS (

173: and CHART_ID = X_CHART_ID
174: ;
175:
176: begin
177: insert into FND_OAM_CHART_ITEMS (
178: CHART_ITEM_SHORT_NAME,
179: USER_ID,
180: CHART_ID,
181: SELECTED,

Line 199: insert into FND_OAM_CHART_ITEMS_TL (

195: X_LAST_UPDATE_DATE,
196: X_LAST_UPDATE_LOGIN
197: );
198:
199: insert into FND_OAM_CHART_ITEMS_TL (
200: CHART_ITEM_SHORT_NAME,
201: CHART_ITEM_NAME,
202: DESCRIPTION,
203: CREATED_BY,

Line 225: from FND_OAM_CHART_ITEMS_TL T

221: from FND_LANGUAGES L
222: where L.INSTALLED_FLAG in ('I', 'B')
223: and not exists
224: (select NULL
225: from FND_OAM_CHART_ITEMS_TL T
226: where T.CHART_ITEM_SHORT_NAME = X_CHART_ITEM_SHORT_NAME
227: and T.LANGUAGE = L.LANGUAGE_CODE);
228:
229: open c;

Line 252: update FND_OAM_CHART_ITEMS set

248: X_LAST_UPDATED_BY in NUMBER,
249: X_LAST_UPDATE_LOGIN in NUMBER
250: ) is
251: begin
252: update FND_OAM_CHART_ITEMS set
253: SELECTED = X_SELECTED,
254: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
255: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
256: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 265: update FND_OAM_CHART_ITEMS_TL set

261: if (sql%notfound) then
262: raise no_data_found;
263: end if;
264:
265: update FND_OAM_CHART_ITEMS_TL set
266: CHART_ITEM_NAME = X_CHART_ITEM_NAME,
267: DESCRIPTION = X_DESCRIPTION,
268: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
269: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 288: delete from FND_OAM_CHART_ITEMS

284: X_USER_ID in NUMBER,
285: X_CHART_ID in NUMBER
286: ) is
287: begin
288: delete from FND_OAM_CHART_ITEMS
289: where CHART_ITEM_SHORT_NAME = X_CHART_ITEM_SHORT_NAME
290: and USER_ID = X_USER_ID
291: and CHART_ID = X_CHART_ID;
292:

Line 297: delete from FND_OAM_CHART_ITEMS_TL

293: if (sql%notfound) then
294: raise no_data_found;
295: end if;
296:
297: delete from FND_OAM_CHART_ITEMS_TL
298: where CHART_ITEM_SHORT_NAME = X_CHART_ITEM_SHORT_NAME;
299:
300: if (sql%notfound) then
301: raise no_data_found;

Line 314: delete from FND_OAM_CHART_ITEMS_TL T

310: /* The following update statements are commented out */
311: /* as a quick workaround to fix the time-consuming table handler issue */
312: /* Eventually we'll need to turn them into a separate fix_language procedure */
313: /*
314: delete from FND_OAM_CHART_ITEMS_TL T
315: where not exists
316: (select NULL
317: from FND_OAM_CHART_ITEMS B
318: where B.CHART_ITEM_SHORT_NAME = T.CHART_ITEM_SHORT_NAME

Line 317: from FND_OAM_CHART_ITEMS B

313: /*
314: delete from FND_OAM_CHART_ITEMS_TL T
315: where not exists
316: (select NULL
317: from FND_OAM_CHART_ITEMS B
318: where B.CHART_ITEM_SHORT_NAME = T.CHART_ITEM_SHORT_NAME
319: );
320:
321: update FND_OAM_CHART_ITEMS_TL T set (

Line 321: update FND_OAM_CHART_ITEMS_TL T set (

317: from FND_OAM_CHART_ITEMS B
318: where B.CHART_ITEM_SHORT_NAME = T.CHART_ITEM_SHORT_NAME
319: );
320:
321: update FND_OAM_CHART_ITEMS_TL T set (
322: CHART_ITEM_NAME,
323: DESCRIPTION
324: ) = (select
325: B.CHART_ITEM_NAME,

Line 327: from FND_OAM_CHART_ITEMS_TL B

323: DESCRIPTION
324: ) = (select
325: B.CHART_ITEM_NAME,
326: B.DESCRIPTION
327: from FND_OAM_CHART_ITEMS_TL B
328: where B.CHART_ITEM_SHORT_NAME = T.CHART_ITEM_SHORT_NAME
329: and B.LANGUAGE = T.SOURCE_LANG)
330: where (
331: T.CHART_ITEM_SHORT_NAME,

Line 336: from FND_OAM_CHART_ITEMS_TL SUBB, FND_OAM_CHART_ITEMS_TL SUBT

332: T.LANGUAGE
333: ) in (select
334: SUBT.CHART_ITEM_SHORT_NAME,
335: SUBT.LANGUAGE
336: from FND_OAM_CHART_ITEMS_TL SUBB, FND_OAM_CHART_ITEMS_TL SUBT
337: where SUBB.CHART_ITEM_SHORT_NAME = SUBT.CHART_ITEM_SHORT_NAME
338: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
339: and (SUBB.CHART_ITEM_NAME <> SUBT.CHART_ITEM_NAME
340: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 345: insert into FND_OAM_CHART_ITEMS_TL (

341: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
342: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
343: ));
344: */
345: insert into FND_OAM_CHART_ITEMS_TL (
346: CHART_ITEM_SHORT_NAME,
347: CHART_ITEM_NAME,
348: DESCRIPTION,
349: CREATED_BY,

Line 367: from FND_OAM_CHART_ITEMS_TL B, FND_LANGUAGES L

363: B.LAST_UPDATE_DATE,
364: B.LAST_UPDATE_LOGIN,
365: L.LANGUAGE_CODE,
366: B.SOURCE_LANG
367: from FND_OAM_CHART_ITEMS_TL B, FND_LANGUAGES L
368: where L.INSTALLED_FLAG in ('I', 'B')
369: and B.LANGUAGE = userenv('LANG')
370: and not exists
371: (select NULL

Line 372: from FND_OAM_CHART_ITEMS_TL T

368: where L.INSTALLED_FLAG in ('I', 'B')
369: and B.LANGUAGE = userenv('LANG')
370: and not exists
371: (select NULL
372: from FND_OAM_CHART_ITEMS_TL T
373: where T.CHART_ITEM_SHORT_NAME = B.CHART_ITEM_SHORT_NAME
374: and T.LANGUAGE = L.LANGUAGE_CODE);
375: end ADD_LANGUAGE;
376:

Line 377: end FND_OAM_CHART_ITEMS_PKG;

373: where T.CHART_ITEM_SHORT_NAME = B.CHART_ITEM_SHORT_NAME
374: and T.LANGUAGE = L.LANGUAGE_CODE);
375: end ADD_LANGUAGE;
376:
377: end FND_OAM_CHART_ITEMS_PKG;