284: =======================================*/
285:
286: CURSOR get_ss_matl_src IS
287: SELECT source_id
288: FROM gmd_ss_material_sources
289: WHERE batch_id = l_mig_batch.old_batch_id;
290:
291: l_ss_matl get_ss_matl_src%ROWTYPE;
292:
501: =============================================*/
502:
503: FOR l_ss_matl IN get_ss_matl_src LOOP
504: BEGIN -- begin for get_ss_matl_src
505: UPDATE gmd_ss_material_sources
506: SET batch_id = l_mig_batch.new_batch_id
507: WHERE source_id = l_ss_matl.source_id;
508:
509: l_ss_matl_upd := l_ss_matl_upd + SQL%ROWCOUNT;