DBA Data[Home] [Help]

APPS.FND_OAM_METVAL_PKG dependencies on FND_LOAD_UTIL

Line 131: f_luby := fnd_load_util.owner_id(x_owner);

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:
133: -- Translate char last_update_date to date
134: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
135:

Line 154: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

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:
154: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
155: db_ludate, X_CUSTOM_MODE)) then
156: --dbms_output.put_line('fnd_load_util.upload_test -> true');
157: begin
158: if (l_is_customized is null or l_is_customized = 'N') then

Line 156: --dbms_output.put_line('fnd_load_util.upload_test -> true');

152: (X_NODE_NAME is not null and NODE_NAME = X_NODE_NAME));
153:
154: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
155: db_ludate, X_CUSTOM_MODE)) then
156: --dbms_output.put_line('fnd_load_util.upload_test -> true');
157: begin
158: if (l_is_customized is null or l_is_customized = 'N') then
159: l_is_customized := X_IS_CUSTOMIZED;
160: l_threshold_operator := X_THRESHOLD_OPERATOR;

Line 188: -- dbms_output.put_line('fnd_load_util.upload_test -> false');

184: X_LAST_UPDATED_BY => f_luby,
185: X_LAST_UPDATE_LOGIN => 0 );
186: end;
187: else
188: -- dbms_output.put_line('fnd_load_util.upload_test -> false');
189: -- fnd_load_util.upload_test returned false,
190: -- which means the metric has been customized by the user
191: -- but we would
192: -- still like to update some columns that are not editable

Line 189: -- fnd_load_util.upload_test returned false,

185: X_LAST_UPDATE_LOGIN => 0 );
186: end;
187: else
188: -- dbms_output.put_line('fnd_load_util.upload_test -> false');
189: -- fnd_load_util.upload_test returned false,
190: -- which means the metric has been customized by the user
191: -- but we would
192: -- still like to update some columns that are not editable
193: -- by the user.

Line 275: f_luby := fnd_load_util.owner_id(x_owner);

271:
272: begin
273:
274: -- Translate owner to file_last_updated_by
275: f_luby := fnd_load_util.owner_id(x_owner);
276:
277: -- Translate char last_update_date to date
278: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
279:

Line 288: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

284: from fnd_oam_mets_tl
285: where metric_short_name = X_METRIC_SHORT_NAME
286: and LANGUAGE = userenv('LANG');
287:
288: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
289: db_ludate, X_CUSTOM_MODE)) then
290: update fnd_oam_mets_tl set
291: metric_display_name = nvl(X_METRIC_DISPLAY_NAME, metric_display_name),
292: description = nvl(X_DESCRIPTION, description),