254: -- --------------------------
255: -- initialize query id
256: -- --------------------------
257: g_error_stmt := 'Debug - initialize - 10';
258: SELECT msc_supplier_plans_s.nextval
259: INTO g_query_id
260: FROM dual;
261:
262: -- --------------------------------------------------------
506: bucket_cells(bkt+g_num_of_buckets*8);
507: END LOOP;
508:
509: FORALL bkt in 1..nvl(bkt_data.qty1.last,0)
510: INSERT INTO msc_supplier_plans(
511: query_id,
512: last_update_date,
513: last_updated_by,
514: creation_date,