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_GRPS_PKG dependencies on FND_OAM_CHART_GRPS

Line 1: PACKAGE BODY FND_OAM_CHART_GRPS_PKG AS

1: PACKAGE BODY FND_OAM_CHART_GRPS_PKG AS
2: /* $Header: AFOAMCGB.pls 115.1 2004/04/14 04:32:49 bhosingh noship $ */
3: procedure LOAD_ROW (
4: X_CHART_GROUP_ID in NUMBER,
5: X_CHART_GROUP_SHORT_NAME in VARCHAR2,

Line 13: FND_OAM_CHART_GRPS_PKG.LOAD_ROW (

9: X_CHART_GROUP_NAME in VARCHAR2,
10: X_DESCRIPTION in VARCHAR2) is
11: begin
12:
13: FND_OAM_CHART_GRPS_PKG.LOAD_ROW (
14: X_CHART_GROUP_ID => X_CHART_GROUP_ID,
15: X_CHART_GROUP_SHORT_NAME => X_CHART_GROUP_SHORT_NAME,
16: X_PARENT_GROUP_ID => X_PARENT_GROUP_ID,
17: X_DISPLAY_ORDER => X_DISPLAY_ORDER,

Line 55: from fnd_oam_chart_grps

51: begin
52: -- check if this chart group id already exists.
53: select chart_group_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
54: into mgroup_id, db_luby, db_ludate
55: from fnd_oam_chart_grps
56: where chart_group_id = to_number(X_CHART_GROUP_ID);
57:
58: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
59: db_ludate, X_CUSTOM_MODE)) then

Line 60: FND_OAM_CHART_GRPS_PKG.UPDATE_ROW (

56: where chart_group_id = to_number(X_CHART_GROUP_ID);
57:
58: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
59: db_ludate, X_CUSTOM_MODE)) then
60: FND_OAM_CHART_GRPS_PKG.UPDATE_ROW (
61: X_CHART_GROUP_ID => mgroup_id,
62: X_CHART_GROUP_SHORT_NAME => X_CHART_GROUP_SHORT_NAME,
63: X_PARENT_GROUP_ID => to_number(X_PARENT_GROUP_ID),
64: X_DISPLAY_ORDER => to_number(X_DISPLAY_ORDER),

Line 74: FND_OAM_CHART_GRPS_PKG.INSERT_ROW (

70: end if;
71: exception
72: when NO_DATA_FOUND then
73:
74: FND_OAM_CHART_GRPS_PKG.INSERT_ROW (
75: X_ROWID => row_id,
76: X_CHART_GROUP_ID => to_number(X_CHART_GROUP_ID),
77: X_CHART_GROUP_SHORT_NAME => X_CHART_GROUP_SHORT_NAME,
78: X_PARENT_GROUP_ID => to_number(X_PARENT_GROUP_ID),

Line 97: FND_OAM_CHART_GRPS_PKG.translate_row(

93: X_DESCRIPTION in VARCHAR2,
94: X_OWNER in VARCHAR2) is
95: begin
96:
97: FND_OAM_CHART_GRPS_PKG.translate_row(
98: X_CHART_GROUP_ID => X_CHART_GROUP_ID,
99: X_CHART_GROUP_NAME => X_CHART_GROUP_NAME,
100: x_description => x_description,
101: x_owner => x_owner,

Line 132: from fnd_oam_chart_grps_tl

128:
129: begin
130: select LAST_UPDATED_BY, LAST_UPDATE_DATE
131: into db_luby, db_ludate
132: from fnd_oam_chart_grps_tl
133: where chart_group_id = to_number(X_CHART_GROUP_ID)
134: and LANGUAGE = userenv('LANG');
135:
136: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 138: update fnd_oam_chart_grps_tl set

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

Line 169: cursor C is select ROWID from FND_OAM_CHART_GRPS

165: X_LAST_UPDATE_DATE in DATE,
166: X_LAST_UPDATED_BY in NUMBER,
167: X_LAST_UPDATE_LOGIN in NUMBER
168: ) is
169: cursor C is select ROWID from FND_OAM_CHART_GRPS
170: where CHART_GROUP_ID = X_CHART_GROUP_ID
171: ;
172: begin
173: insert into FND_OAM_CHART_GRPS (

Line 173: insert into FND_OAM_CHART_GRPS (

169: cursor C is select ROWID from FND_OAM_CHART_GRPS
170: where CHART_GROUP_ID = X_CHART_GROUP_ID
171: ;
172: begin
173: insert into FND_OAM_CHART_GRPS (
174: CHART_GROUP_ID,
175: CHART_GROUP_SHORT_NAME,
176: PARENT_GROUP_ID,
177: DISPLAY_ORDER,

Line 195: insert into FND_OAM_CHART_GRPS_TL (

191: X_LAST_UPDATED_BY,
192: X_LAST_UPDATE_LOGIN
193: );
194:
195: insert into FND_OAM_CHART_GRPS_TL (
196: CHART_GROUP_ID,
197: CHART_GROUP_NAME,
198: DESCRIPTION,
199: CREATED_BY,

Line 221: from FND_OAM_CHART_GRPS_TL T

217: from FND_LANGUAGES L
218: where L.INSTALLED_FLAG in ('I', 'B')
219: and not exists
220: (select NULL
221: from FND_OAM_CHART_GRPS_TL T
222: where T.CHART_GROUP_ID = X_CHART_GROUP_ID
223: and T.LANGUAGE = L.LANGUAGE_CODE);
224:
225: open c;

Line 247: from FND_OAM_CHART_GRPS

243: cursor c is select
244: CHART_GROUP_SHORT_NAME,
245: PARENT_GROUP_ID,
246: DISPLAY_ORDER
247: from FND_OAM_CHART_GRPS
248: where CHART_GROUP_ID = X_CHART_GROUP_ID
249: for update of CHART_GROUP_ID nowait;
250: recinfo c%rowtype;
251:

Line 256: from FND_OAM_CHART_GRPS_TL

252: cursor c1 is select
253: CHART_GROUP_NAME,
254: DESCRIPTION,
255: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
256: from FND_OAM_CHART_GRPS_TL
257: where CHART_GROUP_ID = X_CHART_GROUP_ID
258: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
259: for update of CHART_GROUP_ID nowait;
260: begin

Line 308: update FND_OAM_CHART_GRPS set

304: X_LAST_UPDATED_BY in NUMBER,
305: X_LAST_UPDATE_LOGIN in NUMBER
306: ) is
307: begin
308: update FND_OAM_CHART_GRPS set
309: CHART_GROUP_SHORT_NAME = X_CHART_GROUP_SHORT_NAME,
310: PARENT_GROUP_ID = X_PARENT_GROUP_ID,
311: DISPLAY_ORDER = X_DISPLAY_ORDER,
312: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 321: update FND_OAM_CHART_GRPS_TL set

317: if (sql%notfound) then
318: raise no_data_found;
319: end if;
320:
321: update FND_OAM_CHART_GRPS_TL set
322: CHART_GROUP_NAME = X_CHART_GROUP_NAME,
323: DESCRIPTION = X_DESCRIPTION,
324: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
325: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 340: delete from FND_OAM_CHART_GRPS_TL

336: procedure DELETE_ROW (
337: X_CHART_GROUP_ID in NUMBER
338: ) is
339: begin
340: delete from FND_OAM_CHART_GRPS_TL
341: where CHART_GROUP_ID = X_CHART_GROUP_ID;
342:
343: if (sql%notfound) then
344: raise no_data_found;

Line 347: delete from FND_OAM_CHART_GRPS

343: if (sql%notfound) then
344: raise no_data_found;
345: end if;
346:
347: delete from FND_OAM_CHART_GRPS
348: where CHART_GROUP_ID = X_CHART_GROUP_ID;
349:
350: if (sql%notfound) then
351: raise no_data_found;

Line 364: delete from FND_OAM_CHART_GRPS_TL T

360: /* The following update statements are commented out */
361: /* as a quick workaround to fix the time-consuming table handler issue */
362: /* Eventually we'll need to turn them into a separate fix_language procedure */
363: /*
364: delete from FND_OAM_CHART_GRPS_TL T
365: where not exists
366: (select NULL
367: from FND_OAM_CHART_GRPS B
368: where B.CHART_GROUP_ID = T.CHART_GROUP_ID

Line 367: from FND_OAM_CHART_GRPS B

363: /*
364: delete from FND_OAM_CHART_GRPS_TL T
365: where not exists
366: (select NULL
367: from FND_OAM_CHART_GRPS B
368: where B.CHART_GROUP_ID = T.CHART_GROUP_ID
369: );
370:
371: update FND_OAM_CHART_GRPS_TL T set (

Line 371: update FND_OAM_CHART_GRPS_TL T set (

367: from FND_OAM_CHART_GRPS B
368: where B.CHART_GROUP_ID = T.CHART_GROUP_ID
369: );
370:
371: update FND_OAM_CHART_GRPS_TL T set (
372: CHART_GROUP_NAME,
373: DESCRIPTION
374: ) = (select
375: B.CHART_GROUP_NAME,

Line 377: from FND_OAM_CHART_GRPS_TL B

373: DESCRIPTION
374: ) = (select
375: B.CHART_GROUP_NAME,
376: B.DESCRIPTION
377: from FND_OAM_CHART_GRPS_TL B
378: where B.CHART_GROUP_ID = T.CHART_GROUP_ID
379: and B.LANGUAGE = T.SOURCE_LANG)
380: where (
381: T.CHART_GROUP_ID,

Line 386: from FND_OAM_CHART_GRPS_TL SUBB, FND_OAM_CHART_GRPS_TL SUBT

382: T.LANGUAGE
383: ) in (select
384: SUBT.CHART_GROUP_ID,
385: SUBT.LANGUAGE
386: from FND_OAM_CHART_GRPS_TL SUBB, FND_OAM_CHART_GRPS_TL SUBT
387: where SUBB.CHART_GROUP_ID = SUBT.CHART_GROUP_ID
388: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
389: and (SUBB.CHART_GROUP_NAME <> SUBT.CHART_GROUP_NAME
390: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 395: insert into FND_OAM_CHART_GRPS_TL (

391: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
392: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
393: ));
394: */
395: insert into FND_OAM_CHART_GRPS_TL (
396: CHART_GROUP_ID,
397: CHART_GROUP_NAME,
398: DESCRIPTION,
399: CREATED_BY,

Line 417: from FND_OAM_CHART_GRPS_TL B, FND_LANGUAGES L

413: B.LAST_UPDATE_DATE,
414: B.LAST_UPDATE_LOGIN,
415: L.LANGUAGE_CODE,
416: B.SOURCE_LANG
417: from FND_OAM_CHART_GRPS_TL B, FND_LANGUAGES L
418: where L.INSTALLED_FLAG in ('I', 'B')
419: and B.LANGUAGE = userenv('LANG')
420: and not exists
421: (select NULL

Line 422: from FND_OAM_CHART_GRPS_TL T

418: where L.INSTALLED_FLAG in ('I', 'B')
419: and B.LANGUAGE = userenv('LANG')
420: and not exists
421: (select NULL
422: from FND_OAM_CHART_GRPS_TL T
423: where T.CHART_GROUP_ID = B.CHART_GROUP_ID
424: and T.LANGUAGE = L.LANGUAGE_CODE);
425: end ADD_LANGUAGE;
426:

Line 427: end FND_OAM_CHART_GRPS_PKG;

423: where T.CHART_GROUP_ID = B.CHART_GROUP_ID
424: and T.LANGUAGE = L.LANGUAGE_CODE);
425: end ADD_LANGUAGE;
426:
427: end FND_OAM_CHART_GRPS_PKG;