289: l_to_loc := mtfr_rec.to_location_id;
290: l_to_emp := mtfr_rec.to_employee_id;
291: l_category_id := mtfr_rec.category_id;
292:
293: if not fa_cache_pkg.fazcbc(X_book => l_book_type_code, p_log_level_rec => g_log_level_rec) then
294: raise masstfr_err;
295: end if;
296:
297: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
293: if not fa_cache_pkg.fazcbc(X_book => l_book_type_code, p_log_level_rec => g_log_level_rec) then
294: raise masstfr_err;
295: end if;
296:
297: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
298:
299: --dbms_output.put_line(to_char(l_category_id));
300: --dbms_output.put_line('before OPEN CURSOR');
301:
298:
299: --dbms_output.put_line(to_char(l_category_id));
300: --dbms_output.put_line('before OPEN CURSOR');
301:
302: if (fa_cache_pkg.fa_crl_enabled) then
303: OPEN CUA_C1;
304: FETCH CUA_C1 BULK COLLECT INTO
305: l_asset_id,
306: l_asset_number,