240:
241: f_start_date DATE; -- start date in file
242: BEGIN
243: -- Get last updated information from the loader data file
244: f_luby := fnd_load_util.owner_id(owner);
245: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
246:
247: BEGIN
248: SELECT cb.last_updated_by, cb.last_update_date
250: FROM gcs_elim_rules_b cb
251: WHERE cb.RULE_ID = load_row.RULE_ID;
252:
253: -- Test for customization information
254: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
255: custom_mode) THEN
256: update_row
257: (
258: row_id=>row_id,
323: db_luby NUMBER; -- category owner in db
324: db_ludate DATE; -- category update date in db
325: BEGIN
326: -- Get last updated information from the loader data file
327: f_luby := fnd_load_util.owner_id(owner);
328: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
329:
330: BEGIN
331: SELECT ctl.last_updated_by, ctl.last_update_date
334: WHERE ctl.RULE_ID = translate_row.RULE_ID
335: AND ctl.language = userenv('LANG');
336:
337: -- Test for customization information
338: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
339: custom_mode) THEN
340: UPDATE
341: gcs_elim_rules_tl ctl
342: SET