235: WHERE reporting_code_char_value = p_location_code_o --NOTE
236: AND reporting_type_id = l_reporting_type_id(k);
237:
238: FORALL i IN 1..l_reporting_code_id_tbl.count
239: DELETE FROM zx_reporting_codes_tl
240: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
241:
242: FORALL j IN 1..l_reporting_code_id_tbl.count
243: DELETE FROM zx_reporting_codes_b
265: WHERE reporting_code_char_value = p_location_code_o
266: AND reporting_type_id = l_reporting_type_id(k);
267:
268: FORALL i IN 1..l_reporting_code_id_tbl.count
269: DELETE FROM zx_reporting_codes_tl
270: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
271:
272: FORALL j IN 1..l_reporting_code_id_tbl.count
273: DELETE FROM zx_reporting_codes_b
330: WHERE reporting_code_char_value = p_location_code_o;
331: IF l_reporting_code_id_tbl IS NOT NULL
332: THEN
333: FORALL i IN 1..l_reporting_code_id_tbl.count
334: DELETE FROM zx_reporting_codes_tl
335: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
336:
337: FORALL j IN 1..l_reporting_code_id_tbl.count
338: DELETE FROM zx_reporting_codes_b