APPS.FND_OAM_CPCHARTS_COL dependencies on FND_OAM_CHART_METRICS

Line 9: -- fnd_oam_chart_metrics table.

5: -- refresh_all
6: --
7: -- Purpose
8: -- Computes the values for all the chart metrics and updates the
9: -- fnd_oam_chart_metrics table.
10: --
11: -- Input Arguments
12: --
13: -- Output Arguments

Line 116: -- This procedure will insert a row in fnd_oam_chart_metrics for the given

112: -- Name
113: -- insert_metric_internal
114: -- Purpose
115: -- This procedure is for internal use only!
116: -- This procedure will insert a row in fnd_oam_chart_metrics for the given
117: -- metric name.
118: --
119: -- Input Arguments
120: -- p_metric_name varchar2

Line 141: insert into fnd_oam_chart_metrics (metric_short_name, metric_context,

137: BEGIN
138: v_userid := get_user_id;
139:
140: -- insert the data
141: insert into fnd_oam_chart_metrics (metric_short_name, metric_context,
142: value, last_updated_by, last_update_date,
143: last_update_login, created_by, creation_date)
144: values (p_metric_name, p_context, p_value,
145: v_userid, sysdate, v_userid, 0, sysdate);

Line 153: -- This procedure will update a row in fnd_oam_chart_metrics for the given

149: -- Name
150: -- update_metric_internal
151: -- Purpose
152: -- This procedure is for internal use only!
153: -- This procedure will update a row in fnd_oam_chart_metrics for the given
154: -- metric name. If it does not exist, then insert.
155: --
156: -- Input Arguments
157: -- p_metric_name varchar2

Line 180: from fnd_oam_chart_metrics

176: BEGIN
177: v_userid := get_user_id;
178:
179: select metric_short_name into name
180: from fnd_oam_chart_metrics
181: where metric_short_name = p_metric_name
182: and metric_context = p_context;
183:
184: if(name is not null) then

Line 185: update fnd_oam_chart_metrics

181: where metric_short_name = p_metric_name
182: and metric_context = p_context;
183:
184: if(name is not null) then
185: update fnd_oam_chart_metrics
186: set value = p_value,
187: last_updated_by = v_userid,
188: last_update_date = sysdate,
189: last_update_login = v_userid

Line 198: insert into fnd_oam_chart_metrics (metric_short_name, metric_context,

194:
195: exception
196: when no_data_found then
197: -- insert the data
198: insert into fnd_oam_chart_metrics (metric_short_name, metric_context,
199: value, last_updated_by, last_update_date,
200: last_update_login, created_by, creation_date)
201: values (p_metric_name, p_context, p_value,
202: v_userid, sysdate, v_userid, 0, sysdate);

Line 210: -- This procedure will delete the metric entry if it exists in fnd_oam_chart_metrics for the given

206: -- Name
207: -- delete_metric_internal
208: -- Purpose
209: -- This procedure is for internal use only!
210: -- This procedure will delete the metric entry if it exists in fnd_oam_chart_metrics for the given
211: -- metric name regardless of the context.
212: --
213: -- Input Arguments
214: -- p_metric_name varchar2

Line 229: delete from fnd_oam_chart_metrics

225: IS
226: BEGIN
227:
228: -- delete the entry
229: delete from fnd_oam_chart_metrics
230: where metric_short_name = p_metric_name;
231:
232: END delete_metric_internal;
233: