871: l_asset_vendor_id VARCHAR2(1);
872: l_row_not_found BOOLEAN := FALSE;
873: CURSOR c1(p_asset_vendor_id NUMBER) IS
874: SELECT '1' 875: FROM ap_suppliers 876: WHERE vendor_id = p_asset_vendor_id ;
877: BEGIN
878: IF ( p_asset_vendor_id IS NOT NULL) THEN
879: -- initialize return status