[Home] [Help]
442:
443: END LOOP;
444: CLOSE C2;
445:
446: -- Set request_id in po_approved_supplier_list back to null
447:
448: UPDATE po_approved_supplier_list
449: SET request_id = null
450: WHERE request_id = -99;
444: CLOSE C2;
445:
446: -- Set request_id in po_approved_supplier_list back to null
447:
448: UPDATE po_approved_supplier_list
449: SET request_id = null
450: WHERE request_id = -99;
451:
452: -- Commit the new records