51: db_ludate date; -- entity update date in db
52:
53: begin
54: -- Translate owner to file_last_updated_by
55: f_luby := fnd_load_util.owner_id(x_owner);
56:
57: -- Translate char last_update_date to date
58: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
59:
63: into mgroup_id, db_luby, db_ludate
64: from fnd_oam_charts
65: where chart_id = to_number(X_CHART_ID);
66:
67: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
68: db_ludate, X_CUSTOM_MODE)) then
69: FND_OAM_CHARTS_PKG.UPDATE_ROW (
70: X_CHART_ID => mgroup_id,
71: X_CHART_GROUP_ID => to_number(X_CHART_GROUP_ID),
135:
136: begin
137:
138: -- Translate owner to file_last_updated_by
139: f_luby := fnd_load_util.owner_id(x_owner);
140:
141: -- Translate char last_update_date to date
142: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
143:
147: from fnd_oam_charts_tl
148: where chart_id = to_number(X_CHART_ID)
149: and LANGUAGE = userenv('LANG');
150:
151: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
152: db_ludate, X_CUSTOM_MODE)) then
153: update fnd_oam_charts_tl set
154: chart_name = nvl(X_CHART_NAME, chart_name),
155: description = nvl(X_DESCRIPTION, description),