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_METVAL_PKG dependencies on FND_OAM_METVAL

Line 1: PACKAGE BODY fnd_oam_metval_pkg AS

1: PACKAGE BODY fnd_oam_metval_pkg AS
2: /* $Header: AFOAMMTB.pls 120.2 2005/10/20 12:29:41 ilawler noship $ */
3:
4: -- PRIVATE -----------------
5:

Line 21: update FND_OAM_METVAL set

17: X_METRIC_DISPLAY_NAME in VARCHAR2,
18: X_DESCRIPTION in VARCHAR2
19: ) is
20: begin
21: update FND_OAM_METVAL set
22: GROUP_ID = X_GROUP_ID,
23: SEQUENCE = X_SEQUENCE,
24: METRIC_TYPE = X_METRIC_TYPE,
25: IS_SUPPORTED = nvl(X_IS_SUPPORTED, 'Y')

Line 67: fnd_oam_metval_pkg.LOAD_ROW (

63: X_METRIC_DISPLAY_NAME in VARCHAR2,
64: X_DESCRIPTION in VARCHAR2) is
65: begin
66:
67: fnd_oam_metval_pkg.LOAD_ROW (
68: X_METRIC_SHORT_NAME => X_METRIC_SHORT_NAME,
69: X_METRIC_VALUE => X_METRIC_VALUE,
70: X_STATUS_CODE => X_STATUS_CODE,
71: X_GROUP_ID => X_GROUP_ID,

Line 120: l_is_customized fnd_oam_metval.is_customized%TYPE;

116: db_luby number; -- entity owner in db
117: db_ludate date; -- entity update date in db
118:
119: -- columns that are user customizable
120: l_is_customized fnd_oam_metval.is_customized%TYPE;
121: l_metric_value fnd_oam_metval.metric_value%TYPE;
122: l_status_code fnd_oam_metval.status_code%TYPE;
123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;

Line 121: l_metric_value fnd_oam_metval.metric_value%TYPE;

117: db_ludate date; -- entity update date in db
118:
119: -- columns that are user customizable
120: l_is_customized fnd_oam_metval.is_customized%TYPE;
121: l_metric_value fnd_oam_metval.metric_value%TYPE;
122: l_status_code fnd_oam_metval.status_code%TYPE;
123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;

Line 122: l_status_code fnd_oam_metval.status_code%TYPE;

118:
119: -- columns that are user customizable
120: l_is_customized fnd_oam_metval.is_customized%TYPE;
121: l_metric_value fnd_oam_metval.metric_value%TYPE;
122: l_status_code fnd_oam_metval.status_code%TYPE;
123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
126: l_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;

Line 123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;

119: -- columns that are user customizable
120: l_is_customized fnd_oam_metval.is_customized%TYPE;
121: l_metric_value fnd_oam_metval.metric_value%TYPE;
122: l_status_code fnd_oam_metval.status_code%TYPE;
123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
126: l_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;
127: l_last_collected_date fnd_oam_metval.last_collected_date%TYPE;

Line 124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;

120: l_is_customized fnd_oam_metval.is_customized%TYPE;
121: l_metric_value fnd_oam_metval.metric_value%TYPE;
122: l_status_code fnd_oam_metval.status_code%TYPE;
123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
126: l_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;
127: l_last_collected_date fnd_oam_metval.last_collected_date%TYPE;
128: l_interval_counter fnd_oam_metval.interval_counter%TYPE;

Line 125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;

121: l_metric_value fnd_oam_metval.metric_value%TYPE;
122: l_status_code fnd_oam_metval.status_code%TYPE;
123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
126: l_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;
127: l_last_collected_date fnd_oam_metval.last_collected_date%TYPE;
128: l_interval_counter fnd_oam_metval.interval_counter%TYPE;
129: begin

Line 126: l_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;

122: l_status_code fnd_oam_metval.status_code%TYPE;
123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
126: l_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;
127: l_last_collected_date fnd_oam_metval.last_collected_date%TYPE;
128: l_interval_counter fnd_oam_metval.interval_counter%TYPE;
129: begin
130: -- Translate owner to file_last_updated_by

Line 127: l_last_collected_date fnd_oam_metval.last_collected_date%TYPE;

123: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
126: l_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;
127: l_last_collected_date fnd_oam_metval.last_collected_date%TYPE;
128: l_interval_counter fnd_oam_metval.interval_counter%TYPE;
129: begin
130: -- Translate owner to file_last_updated_by
131: f_luby := fnd_load_util.owner_id(x_owner);

Line 128: l_interval_counter fnd_oam_metval.interval_counter%TYPE;

124: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
125: l_alert_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
126: l_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;
127: l_last_collected_date fnd_oam_metval.last_collected_date%TYPE;
128: l_interval_counter fnd_oam_metval.interval_counter%TYPE;
129: begin
130: -- Translate owner to file_last_updated_by
131: f_luby := fnd_load_util.owner_id(x_owner);
132:

Line 149: from fnd_oam_metval

145: into db_luby, db_ludate, l_is_customized,
146: l_metric_value, l_status_code, l_threshold_operator,
147: l_threshold_value, l_alert_enabled_flag, l_collection_enabled_flag,
148: l_last_collected_date, l_interval_counter
149: from fnd_oam_metval
150: where metric_short_name = X_METRIC_SHORT_NAME
151: and (X_NODE_NAME is null or
152: (X_NODE_NAME is not null and NODE_NAME = X_NODE_NAME));
153:

Line 165: fnd_oam_metval_pkg.UPDATE_ROW (

161: l_threshold_value := X_THRESHOLD_VALUE;
162: l_alert_enabled_flag := X_ALERT_ENABLED_FLAG;
163: l_collection_enabled_flag := X_COLLECTION_ENABLED_FLAG;
164: end if;
165: fnd_oam_metval_pkg.UPDATE_ROW (
166: X_METRIC_SHORT_NAME => X_METRIC_SHORT_NAME,
167: X_METRIC_VALUE => l_metric_value,
168: X_STATUS_CODE => to_number(l_status_code),
169: X_GROUP_ID => to_number(X_GROUP_ID),

Line 214: fnd_oam_metval_pkg.INSERT_ROW (

210: end if;
211: exception
212: when NO_DATA_FOUND then
213:
214: fnd_oam_metval_pkg.INSERT_ROW (
215: X_ROWID => row_id,
216: X_METRIC_SHORT_NAME => X_METRIC_SHORT_NAME,
217: X_METRIC_VALUE => X_METRIC_VALUE,
218: X_STATUS_CODE => to_number(X_STATUS_CODE),

Line 248: fnd_oam_metval_pkg.translate_row(

244: X_METRIC_DISPLAY_NAME in VARCHAR2,
245: X_DESCRIPTION in VARCHAR2) is
246: begin
247:
248: fnd_oam_metval_pkg.translate_row(
249: x_metric_short_name => x_metric_short_name,
250: x_owner => x_owner,
251: x_metric_display_name => x_metric_display_name,
252: x_description => x_description,

Line 332: cursor C is select ROWID from FND_OAM_METVAL

328: X_LAST_UPDATED_BY in NUMBER,
329: X_LAST_UPDATE_DATE in DATE,
330: X_LAST_UPDATE_LOGIN in NUMBER)
331: is
332: cursor C is select ROWID from FND_OAM_METVAL
333: where METRIC_SHORT_NAME = X_METRIC_SHORT_NAME
334: and (X_NODE_NAME is null or
335: (X_NODE_NAME is not null and NODE_NAME = X_NODE_NAME));
336: begin

Line 337: insert into FND_OAM_METVAL (

333: where METRIC_SHORT_NAME = X_METRIC_SHORT_NAME
334: and (X_NODE_NAME is null or
335: (X_NODE_NAME is not null and NODE_NAME = X_NODE_NAME));
336: begin
337: insert into FND_OAM_METVAL (
338: METRIC_SHORT_NAME,
339: METRIC_VALUE,
340: STATUS_CODE,
341: GROUP_ID,

Line 442: update FND_OAM_METVAL set

438: X_LAST_UPDATED_BY in NUMBER,
439: X_LAST_UPDATE_LOGIN in NUMBER
440: ) is
441: begin
442: update FND_OAM_METVAL set
443: METRIC_VALUE = X_METRIC_VALUE,
444: STATUS_CODE = X_STATUS_CODE,
445: GROUP_ID = X_GROUP_ID,
446: SEQUENCE = X_SEQUENCE,

Line 493: delete from FND_OAM_METVAL

489: if (sql%notfound) then
490: raise no_data_found;
491: end if;
492:
493: delete from FND_OAM_METVAL
494: where METRIC_SHORT_NAME = X_METRIC_SHORT_NAME;
495:
496: if (sql%notfound) then
497: raise no_data_found;

Line 513: from FND_OAM_METVAL B

509: /*
510: delete from FND_OAM_METS_TL T
511: where not exists
512: (select NULL
513: from FND_OAM_METVAL B
514: where B.METRIC_SHORT_NAME = T.METRIC_SHORT_NAME
515: );
516:
517: update FND_OAM_METS_TL T set (

Line 574: END fnd_oam_metval_pkg;

570: where T.METRIC_SHORT_NAME = B.METRIC_SHORT_NAME
571: and T.LANGUAGE = L.LANGUAGE_CODE);
572: end ADD_LANGUAGE;
573:
574: END fnd_oam_metval_pkg;