350: ** Clear out any existing data for this range of records
351: **
352: ** Don't delete just yet.
353: **
354: delete from per_rating_levels_tl
355: where rating_level_id between p_start_pkid
356: and p_end_pkid;
357: */
358:
371:
372: /*
373: ** Insert the TL rows.
374: */
375: insert into per_rating_levels_tl(
376: rating_level_id,
377: language,
378: source_lang,
379: name,
392: r.creation_date,
393: r.last_updated_by,
394: r.last_update_date,
395: r.last_update_login
396: from per_rating_levels r
397: where r.rating_level_id between p_start_pkid
398: and p_end_pkid
399: and not exists (select '1'
400: from per_rating_levels_tl rtl
396: from per_rating_levels r
397: where r.rating_level_id between p_start_pkid
398: and p_end_pkid
399: and not exists (select '1'
400: from per_rating_levels_tl rtl
401: where rtl.rating_level_id = r.rating_level_id
402: and rtl.language = l_current_language);
403:
404: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;